DBA Data[Home] [Help]

APPS.IGS_GE_GEN_002 dependencies on FND_GLOBAL

Line 881: v_addr := v_addr || fnd_global.local_chr(10) || v_line_1;

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;

Line 884: v_addr := v_addr || fnd_global.local_chr(10) || v_line_2;

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;

Line 887: v_addr := v_addr || fnd_global.local_chr(10) || v_line_3;

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;

Line 890: v_addr := v_addr || fnd_global.local_chr(10) || v_line_4;

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;

Line 893: v_addr := v_addr || fnd_global.local_chr(10) || v_line_5;

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;

Line 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;

Line 900: v_addr := v_addr || fnd_global.local_chr(10) || v_country_desc;

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;

Line 903: v_addr := v_addr || fnd_global.local_chr(10) || v_postal_code;

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