877: END IF;
878: -- Use p_inc_addr to append address lnies that are not null
879: IF p_inc_addr = 'Y' THEN
880: IF v_line_1 IS NOT NULL THEN
881: v_addr := v_addr || fnd_global.local_chr(10) || v_line_1;
882: END IF;
883: IF v_line_2 IS NOT NULL THEN
884: v_addr := v_addr || fnd_global.local_chr(10) || v_line_2;
885: END IF;
880: IF v_line_1 IS NOT NULL THEN
881: v_addr := v_addr || fnd_global.local_chr(10) || v_line_1;
882: END IF;
883: IF v_line_2 IS NOT NULL THEN
884: v_addr := v_addr || fnd_global.local_chr(10) || v_line_2;
885: END IF;
886: IF v_line_3 IS NOT NULL THEN
887: v_addr := v_addr || fnd_global.local_chr(10) || v_line_3;
888: END IF;
883: IF v_line_2 IS NOT NULL THEN
884: v_addr := v_addr || fnd_global.local_chr(10) || v_line_2;
885: END IF;
886: IF v_line_3 IS NOT NULL THEN
887: v_addr := v_addr || fnd_global.local_chr(10) || v_line_3;
888: END IF;
889: IF v_line_4 IS NOT NULL THEN
890: v_addr := v_addr || fnd_global.local_chr(10) || v_line_4;
891: END IF;
886: IF v_line_3 IS NOT NULL THEN
887: v_addr := v_addr || fnd_global.local_chr(10) || v_line_3;
888: END IF;
889: IF v_line_4 IS NOT NULL THEN
890: v_addr := v_addr || fnd_global.local_chr(10) || v_line_4;
891: END IF;
892: IF v_line_5 IS NOT NULL THEN
893: v_addr := v_addr || fnd_global.local_chr(10) || v_line_5;
894: END IF;
889: IF v_line_4 IS NOT NULL THEN
890: v_addr := v_addr || fnd_global.local_chr(10) || v_line_4;
891: END IF;
892: IF v_line_5 IS NOT NULL THEN
893: v_addr := v_addr || fnd_global.local_chr(10) || v_line_5;
894: END IF;
895: -- # 2382471 Added for Country ,State and Zip Code
896: IF v_state IS NOT NULL THEN
897: v_addr := v_addr || fnd_global.local_chr(10) || v_state;
893: v_addr := v_addr || fnd_global.local_chr(10) || v_line_5;
894: END IF;
895: -- # 2382471 Added for Country ,State and Zip Code
896: IF v_state IS NOT NULL THEN
897: v_addr := v_addr || fnd_global.local_chr(10) || v_state;
898: END IF;
899: IF v_country_desc IS NOT NULL THEN
900: v_addr := v_addr || fnd_global.local_chr(10) || v_country_desc;
901: END IF;
896: IF v_state IS NOT NULL THEN
897: v_addr := v_addr || fnd_global.local_chr(10) || v_state;
898: END IF;
899: IF v_country_desc IS NOT NULL THEN
900: v_addr := v_addr || fnd_global.local_chr(10) || v_country_desc;
901: END IF;
902: IF v_postal_code IS NOT NULL THEN
903: v_addr := v_addr || fnd_global.local_chr(10) || v_postal_code;
904: END IF;
899: IF v_country_desc IS NOT NULL THEN
900: v_addr := v_addr || fnd_global.local_chr(10) || v_country_desc;
901: END IF;
902: IF v_postal_code IS NOT NULL THEN
903: v_addr := v_addr || fnd_global.local_chr(10) || v_postal_code;
904: END IF;
905:
906: END IF;
907: -- Test if v_addr is null, if so then raise exception