eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_HR_LOCATION dependencies on FND_LOG

Line 712: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

708:
709: /* If location id is not null then get the address from hr_locations */
710:
711: Begin
712: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
713: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Retreiving data from HR_LOCATIONS');
714: END IF;
715: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
716: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'location Id:'|| p_location_id);

Line 713: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Retreiving data from HR_LOCATIONS');

709: /* If location id is not null then get the address from hr_locations */
710:
711: Begin
712: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
713: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Retreiving data from HR_LOCATIONS');
714: END IF;
715: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
716: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'location Id:'|| p_location_id);
717: END IF;

Line 715: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

711: Begin
712: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
713: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Retreiving data from HR_LOCATIONS');
714: END IF;
715: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
716: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'location Id:'|| p_location_id);
717: END IF;
718: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
719: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Style code:'|| l_style_code);

Line 716: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'location Id:'|| p_location_id);

712: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
713: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Retreiving data from HR_LOCATIONS');
714: END IF;
715: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
716: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'location Id:'|| p_location_id);
717: END IF;
718: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
719: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Style code:'|| l_style_code);
720: END IF;

Line 718: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

714: END IF;
715: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
716: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'location Id:'|| p_location_id);
717: END IF;
718: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
719: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Style code:'|| l_style_code);
720: END IF;
721:
722: /*Bug 5084855 Adding the NVL to get the Country value for Generic Address Style */

Line 719: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Style code:'|| l_style_code);

715: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
716: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'location Id:'|| p_location_id);
717: END IF;
718: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
719: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Style code:'|| l_style_code);
720: END IF;
721:
722: /*Bug 5084855 Adding the NVL to get the Country value for Generic Address Style */
723: Select HLC.ADDRESS_LINE_1,

Line 865: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

861: fnd_dflex.get_flexfield('PER', 'Address Location', flexfield, flexinfo);
862: lcontext.flexfield := flexfield;
863: lcontext.context_code := l_style_code;
864: fnd_dflex.get_segments(lcontext, segments);
865: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
866: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Retrieved Values from descriptive flex');
867: END IF;
868: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
869: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Number of values retrieved:'||segments.nsegments);

Line 866: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Retrieved Values from descriptive flex');

862: lcontext.flexfield := flexfield;
863: lcontext.context_code := l_style_code;
864: fnd_dflex.get_segments(lcontext, segments);
865: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
866: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Retrieved Values from descriptive flex');
867: END IF;
868: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
869: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Number of values retrieved:'||segments.nsegments);
870: END IF;

Line 868: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

864: fnd_dflex.get_segments(lcontext, segments);
865: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
866: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Retrieved Values from descriptive flex');
867: END IF;
868: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
869: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Number of values retrieved:'||segments.nsegments);
870: END IF;
871:
872: FOR i IN 1 .. segments.nsegments LOOP

Line 869: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Number of values retrieved:'||segments.nsegments);

865: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
866: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Retrieved Values from descriptive flex');
867: END IF;
868: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
869: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Number of values retrieved:'||segments.nsegments);
870: END IF;
871:
872: FOR i IN 1 .. segments.nsegments LOOP
873:

Line 898: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

894: END LOOP;
895:
896: -- Query to retrieve the address values from HR_LOCATIONS.
897: l_addr_select_qry := 'select '|| l_addr_col_names || ' from hr_locations where location_id = :1 ' ;
898: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
899: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'select query:'||l_addr_select_qry);
900: END IF;
901:
902: END IF;

Line 899: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'select query:'||l_addr_select_qry);

895:
896: -- Query to retrieve the address values from HR_LOCATIONS.
897: l_addr_select_qry := 'select '|| l_addr_col_names || ' from hr_locations where location_id = :1 ' ;
898: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
899: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'select query:'||l_addr_select_qry);
900: END IF;
901:
902: END IF;
903:

Line 959: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

955: g_addr_prompt_query(l_addr_prompt_query_count).addr_label_20:= l_addr_prompts_array(20);
956: -- End bug#3622675
957: g_addr_prompt_query(l_addr_prompt_query_count).query := l_addr_select_qry;
958: END IF;
959: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
960: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Before executing the HR_LOCATIONS query');
961: END IF;
962:
963: execute immediate l_addr_select_qry INTO g_address_details(l_table_count).addr_data_1, g_address_details(l_table_count).addr_data_2, g_address_details(l_table_count).addr_data_3,

Line 960: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Before executing the HR_LOCATIONS query');

956: -- End bug#3622675
957: g_addr_prompt_query(l_addr_prompt_query_count).query := l_addr_select_qry;
958: END IF;
959: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
960: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Before executing the HR_LOCATIONS query');
961: END IF;
962:
963: execute immediate l_addr_select_qry INTO g_address_details(l_table_count).addr_data_1, g_address_details(l_table_count).addr_data_2, g_address_details(l_table_count).addr_data_3,
964: g_address_details(l_table_count).addr_data_4, g_address_details(l_table_count).addr_data_5, g_address_details(l_table_count).addr_data_6,

Line 970: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

966: g_address_details(l_table_count).addr_data_10, g_address_details(l_table_count).addr_data_11, g_address_details(l_table_count).addr_data_12,
967: g_address_details(l_table_count).addr_data_13, g_address_details(l_table_count).addr_data_14, g_address_details(l_table_count).addr_data_15,
968: g_address_details(l_table_count).addr_data_16, g_address_details(l_table_count).addr_data_17, g_address_details(l_table_count).addr_data_18,
969: g_address_details(l_table_count).addr_data_19, g_address_details(l_table_count).addr_data_20 USING p_location_id ;
970: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
971: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'After executing the HR_LOCATIONS query');
972: END IF;
973:
974:

Line 971: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'After executing the HR_LOCATIONS query');

967: g_address_details(l_table_count).addr_data_13, g_address_details(l_table_count).addr_data_14, g_address_details(l_table_count).addr_data_15,
968: g_address_details(l_table_count).addr_data_16, g_address_details(l_table_count).addr_data_17, g_address_details(l_table_count).addr_data_18,
969: g_address_details(l_table_count).addr_data_19, g_address_details(l_table_count).addr_data_20 USING p_location_id ;
970: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
971: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'After executing the HR_LOCATIONS query');
972: END IF;
973:
974:
975:

Line 981: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

977:
978:
979: Exception
980: WHEN OTHERS then
981: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
982: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Exception while retrieving data from HR_LOCATIONS');
983: END IF;
984: x_address_line_1 := '';
985: x_address_line_2 := '';

Line 982: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Exception while retrieving data from HR_LOCATIONS');

978:
979: Exception
980: WHEN OTHERS then
981: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
982: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Exception while retrieving data from HR_LOCATIONS');
983: END IF;
984: x_address_line_1 := '';
985: x_address_line_2 := '';
986: x_address_line_3 := '';

Line 1000: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

996:
997: else
998:
999: /* If location id is null then select the address from hz_locations */
1000: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1001: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Before executing the HZ_LOCATIONS query');
1002: END IF;
1003: Begin
1004: /*Bug 5084855 Adding the NVL to get the Country value for Generic Address Style */

Line 1001: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Before executing the HZ_LOCATIONS query');

997: else
998:
999: /* If location id is null then select the address from hz_locations */
1000: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1001: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Before executing the HZ_LOCATIONS query');
1002: END IF;
1003: Begin
1004: /*Bug 5084855 Adding the NVL to get the Country value for Generic Address Style */
1005: SELECT

Line 1066: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1062: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.VIEW_APPLICATION_ID) =
1063: DECODE(FCL3.LOOKUP_CODE, NULL, '1', 3) AND
1064: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.LANGUAGE) =
1065: DECODE(FCL3.LOOKUP_CODE, NULL, '1', USERENV('LANG')) ;
1066: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1067: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'After executing the HZ_LOCATIONS query');
1068: END IF;
1069:
1070: /* hz_locations table doesn't have columns for location code, phone and fax. */

Line 1067: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'After executing the HZ_LOCATIONS query');

1063: DECODE(FCL3.LOOKUP_CODE, NULL, '1', 3) AND
1064: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.LANGUAGE) =
1065: DECODE(FCL3.LOOKUP_CODE, NULL, '1', USERENV('LANG')) ;
1066: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1067: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'After executing the HZ_LOCATIONS query');
1068: END IF;
1069:
1070: /* hz_locations table doesn't have columns for location code, phone and fax. */
1071:

Line 1077: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1073: x_contact_phone :=null;
1074: x_contact_fax :=null;
1075:
1076: l_table_count := g_address_details.count; -- Number of rows in the PL/SQl table
1077: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1078: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'l_table_count:'||l_table_count);
1079: END IF;
1080:
1081: /* Check whether the location id exists in g_address_details PL/SQL table.*/

Line 1078: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'l_table_count:'||l_table_count);

1074: x_contact_fax :=null;
1075:
1076: l_table_count := g_address_details.count; -- Number of rows in the PL/SQl table
1077: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1078: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'l_table_count:'||l_table_count);
1079: END IF;
1080:
1081: /* Check whether the location id exists in g_address_details PL/SQL table.*/
1082: FOR i IN 1 .. l_table_count LOOP

Line 1089: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1085: l_location_id_exists := 'Y';
1086: EXIT ;
1087: END IF;
1088: END LOOP;
1089: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1090: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'l_location_id_exists:'||l_location_id_exists);
1091: END IF;
1092:
1093: IF l_location_id_exists <> 'Y' THEN

Line 1090: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'l_location_id_exists:'||l_location_id_exists);

1086: EXIT ;
1087: END IF;
1088: END LOOP;
1089: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1090: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'l_location_id_exists:'||l_location_id_exists);
1091: END IF;
1092:
1093: IF l_location_id_exists <> 'Y' THEN
1094:

Line 1098: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1094:
1095: l_table_count := l_table_count + 1;
1096: g_address_details(l_table_count).location_id := p_location_id;
1097: g_address_details(l_table_count).address_style := l_style_code;
1098: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1099: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'p_location_id:'|| p_location_id);
1100: END IF;
1101:
1102:

Line 1099: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'p_location_id:'|| p_location_id);

1095: l_table_count := l_table_count + 1;
1096: g_address_details(l_table_count).location_id := p_location_id;
1097: g_address_details(l_table_count).address_style := l_style_code;
1098: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1099: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'p_location_id:'|| p_location_id);
1100: END IF;
1101:
1102:
1103: HZ_FORMAT_PUB.FORMAT_ADDRESS(p_location_id => p_location_id,

Line 1109: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1105: x_return_status => x_return_status, x_msg_count => x_msg_count,
1106: x_msg_data => x_msg_data, x_formatted_address => x_formatted_address,
1107: x_formatted_lines_cnt => x_formatted_lines_cnt,
1108: x_formatted_address_tbl => x_formatted_address_tbl) ;
1109: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1110: /* assign address values to l_addr_values_array list */
1111:
1112: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'x_formatted_lines_cnt:'|| x_formatted_lines_cnt);
1113: END IF;

Line 1112: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'x_formatted_lines_cnt:'|| x_formatted_lines_cnt);

1108: x_formatted_address_tbl => x_formatted_address_tbl) ;
1109: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1110: /* assign address values to l_addr_values_array list */
1111:
1112: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'x_formatted_lines_cnt:'|| x_formatted_lines_cnt);
1113: END IF;
1114:
1115:
1116: IF x_formatted_lines_cnt > 0 THEN

Line 1125: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1121: EXIT;
1122: END IF;
1123: END LOOP;
1124: END IF;
1125: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1126: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Before adding HZ_LOCATIONS to PL/SQL tables');
1127: END IF;
1128: /* Assigning the values to global PL/SQL table */
1129: g_address_details(l_table_count).addr_data_1 := l_addr_values_array(1);

Line 1126: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Before adding HZ_LOCATIONS to PL/SQL tables');

1122: END IF;
1123: END LOOP;
1124: END IF;
1125: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1126: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Before adding HZ_LOCATIONS to PL/SQL tables');
1127: END IF;
1128: /* Assigning the values to global PL/SQL table */
1129: g_address_details(l_table_count).addr_data_1 := l_addr_values_array(1);
1130: g_address_details(l_table_count).addr_data_2 := l_addr_values_array(2);

Line 1149: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1145: g_address_details(l_table_count).addr_data_17 := l_addr_values_array(17);
1146: g_address_details(l_table_count).addr_data_18 := l_addr_values_array(18);
1147: g_address_details(l_table_count).addr_data_19 := l_addr_values_array(19);
1148: g_address_details(l_table_count).addr_data_20 := l_addr_values_array(20);
1149: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1150: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'After adding HZ_LOCATIONS to PL/SQL tables');
1151: END IF;
1152:
1153: END IF;

Line 1150: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'After adding HZ_LOCATIONS to PL/SQL tables');

1146: g_address_details(l_table_count).addr_data_18 := l_addr_values_array(18);
1147: g_address_details(l_table_count).addr_data_19 := l_addr_values_array(19);
1148: g_address_details(l_table_count).addr_data_20 := l_addr_values_array(20);
1149: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1150: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'After adding HZ_LOCATIONS to PL/SQL tables');
1151: END IF;
1152:
1153: END IF;
1154:

Line 1157: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1153: END IF;
1154:
1155: Exception
1156: WHEN OTHERS then
1157: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1158: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Exception in retrieving data from HZ_LOCATIONS');
1159: END IF;
1160: x_address_line_1 := '';
1161: x_address_line_2 := '';

Line 1158: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Exception in retrieving data from HZ_LOCATIONS');

1154:
1155: Exception
1156: WHEN OTHERS then
1157: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1158: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head, l_api_name ||'Exception in retrieving data from HZ_LOCATIONS');
1159: END IF;
1160: x_address_line_1 := '';
1161: x_address_line_2 := '';
1162: x_address_line_3 := '';

Line 1216: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1212: l_count number := 0;
1213: begin
1214:
1215: l_count := g_address_details.count ;
1216: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1217: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'populate_gt Before inserting values in global temp table');
1218: END IF;
1219: FOR i IN 1..l_count LOOP
1220: INSERT INTO po_address_details_gt

Line 1217: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'populate_gt Before inserting values in global temp table');

1213: begin
1214:
1215: l_count := g_address_details.count ;
1216: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1217: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'populate_gt Before inserting values in global temp table');
1218: END IF;
1219: FOR i IN 1..l_count LOOP
1220: INSERT INTO po_address_details_gt
1221: (location_id,

Line 1307: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1303: g_address_details(i).addr_data_18,
1304: g_address_details(i).addr_data_19,
1305: g_address_details(i).addr_data_20);
1306: end loop;
1307: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1308: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'populate_gt: After inserting values in global temp table');
1309: END IF;
1310:
1311: g_address_details.delete;

Line 1308: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'populate_gt: After inserting values in global temp table');

1304: g_address_details(i).addr_data_19,
1305: g_address_details(i).addr_data_20);
1306: end loop;
1307: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1308: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'populate_gt: After inserting values in global temp table');
1309: END IF;
1310:
1311: g_address_details.delete;
1312:

Line 1315: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1311: g_address_details.delete;
1312:
1313: EXCEPTION
1314: WHEN OTHERS THEN
1315: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1316: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'populate_gt: Error while inserting values in global temp table');
1317: END IF;
1318: end;
1319:

Line 1316: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'populate_gt: Error while inserting values in global temp table');

1312:
1313: EXCEPTION
1314: WHEN OTHERS THEN
1315: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1316: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'populate_gt: Error while inserting values in global temp table');
1317: END IF;
1318: end;
1319:
1320: -----------------------------------------------------------

Line 1351: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1347: l_postal_code Varchar2(240) := '';
1348: l_state_or_province Varchar2(240) := '';
1349:
1350: BEGIN
1351: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1352: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'Call the get_address procedure');
1353: END IF;
1354: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1355: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'Location Id: '|| p_location_id);

Line 1352: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'Call the get_address procedure');

1348: l_state_or_province Varchar2(240) := '';
1349:
1350: BEGIN
1351: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1352: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'Call the get_address procedure');
1353: END IF;
1354: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1355: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'Location Id: '|| p_location_id);
1356: END IF;

Line 1354: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1350: BEGIN
1351: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1352: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'Call the get_address procedure');
1353: END IF;
1354: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1355: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'Location Id: '|| p_location_id);
1356: END IF;
1357:
1358: get_address

Line 1355: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'Location Id: '|| p_location_id);

1351: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1352: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'Call the get_address procedure');
1353: END IF;
1354: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1355: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION', 'Location Id: '|| p_location_id);
1356: END IF;
1357:
1358: get_address
1359: (p_location_id => p_location_id,

Line 1388: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1384:
1385: l_address_lines := l_address_line_1 || ', ' || l_address_line_2 ||
1386: l_address_line_3 || l_address_line_4;
1387: l_formatted_address := substrb(l_address_lines || l_address_info || ', '|| l_territory, 1,2000);
1388: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1389: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION',
1390: 'Complete address: '|| l_formatted_address);
1391: END IF;
1392:

Line 1389: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION',

1385: l_address_lines := l_address_line_1 || ', ' || l_address_line_2 ||
1386: l_address_line_3 || l_address_line_4;
1387: l_formatted_address := substrb(l_address_lines || l_address_info || ', '|| l_territory, 1,2000);
1388: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1389: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,'PO_HR_LOCATION',
1390: 'Complete address: '|| l_formatted_address);
1391: END IF;
1392:
1393: Return l_formatted_address;

Line 1397: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1393: Return l_formatted_address;
1394:
1395: Exception
1396: When Others then
1397: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1398: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,'PO_HR_LOCATION','Error in Retrieving address');
1399: END IF;
1400: l_formatted_address := null;
1401: END;

Line 1398: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,'PO_HR_LOCATION','Error in Retrieving address');

1394:
1395: Exception
1396: When Others then
1397: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1398: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,'PO_HR_LOCATION','Error in Retrieving address');
1399: END IF;
1400: l_formatted_address := null;
1401: END;
1402: