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.PQP_RIW_WEBADI_UTILS dependencies on HR_UTILITY

Line 81: hr_utility.set_location('Entering Mapping Rows ', 30);

77: l_proc VARCHAR2(72) := g_package||'Create_RIW_Mappings_row';
78: l_mapping_code VARCHAR2(50);
79: BEGIN
80:
81: hr_utility.set_location('Entering Mapping Rows ', 30);
82: IF p_entity_name IS NULL THEN
83: IF p_data_source = 'XML' THEN
84: OPEN c_mapping_row(c_mapping_code => 'PQP_FLEXI_WEBADI_XML_MAP_KEY');
85: ELSIF p_data_source = 'CSV' THEN

Line 125: hr_utility.set_location('Exiting Mapping rows ', 40);

121: ,X_LAST_UPDATE_DATE => Sysdate
122: ,X_LAST_UPDATED_BY => l_mapping_row.CREATED_BY
123: ,X_LAST_UPDATE_LOGIN => l_mapping_row.CREATED_BY);
124:
125: hr_utility.set_location('Exiting Mapping rows ', 40);
126:
127: END Create_RIW_mappings_row;
128:
129:

Line 195: hr_utility.set_location(l_temp_interface_seq_num, 50);

191: EXIT WHEN c_mapping_cols_row%NOTFOUND;
192: --Checking the base Interface Seq number exist in selected interface number
193: --or by default provided sequence number
194: l_temp_interface_seq_num := l_mapping_cols_row.INTERFACE_SEQ_NUM;
195: hr_utility.set_location(l_temp_interface_seq_num, 50);
196: IF p_entity_name IS NULL THEN
197: IF g_riw_data.EXISTS(l_temp_interface_seq_num) OR l_temp_interface_seq_num IN
198: (59,176,253,254,332,334,335,333,331,330,328,177,19, 62, 93, 124, 155,340,
199: 350,351 --$ Include Batch Link and Exception

Line 247: hr_utility.set_location('Before finishing the loop', 60);

243: ,X_LAST_UPDATED_BY => l_mapping_cols_row.CREATED_BY
244: ,X_LAST_UPDATE_LOGIN => l_mapping_cols_row.CREATED_BY);
245: END IF;
246: END IF;
247: hr_utility.set_location('Before finishing the loop', 60);
248: END LOOP;
249: CLOSE c_mapping_cols_row;
250:
251: END Create_RIW_Mapping_Links_Rows;

Line 386: hr_utility.set_location('Inside creating the layout cols',20);

382:
383:
384: BEGIN
385:
386: hr_utility.set_location('Inside creating the layout cols',20);
387: hr_utility.set_location(p_new_interface_code, 25);
388: --Gettting the values for selected seq numbers
389: FOR l_interface_index IN g_temp_riw_data.FIRST..g_temp_riw_data.LAST
390: LOOP

Line 387: hr_utility.set_location(p_new_interface_code, 25);

383:
384: BEGIN
385:
386: hr_utility.set_location('Inside creating the layout cols',20);
387: hr_utility.set_location(p_new_interface_code, 25);
388: --Gettting the values for selected seq numbers
389: FOR l_interface_index IN g_temp_riw_data.FIRST..g_temp_riw_data.LAST
390: LOOP
391: l_interface_seq_num := g_temp_riw_data(l_interface_index).interface_seq;

Line 396: hr_utility.set_location(l_interface_seq_num, 30);

392: OPEN c_layout_cols_seq_row(c_interface_seq_num => l_interface_seq_num);
393: LOOP
394: FETCH c_layout_cols_seq_row INTO l_layout_cols_seq_row;
395: EXIT WHEN c_layout_cols_seq_row%NOTFOUND;
396: hr_utility.set_location(l_interface_seq_num, 30);
397: l_default_value := g_riw_data(l_layout_cols_seq_row.interface_seq_num).default_value;
398: l_default_type := g_riw_data(l_layout_cols_seq_row.interface_seq_num).default_type;
399:
400: IF l_default_type ='N' THEN

Line 428: hr_utility.set_location(l_placement_value, 56);

424: END IF;
425: END IF;
426: END IF;
427: l_placement_value := g_riw_data(l_layout_cols_seq_row.interface_seq_num).placement;
428: hr_utility.set_location(l_placement_value, 56);
429:
430: IF l_placement_value ='LINE' OR l_placement_value IS NULL THEN
431: hr_utility.set_location('The Value is Line', 67);
432: l_placement_block := 3;

Line 431: hr_utility.set_location('The Value is Line', 67);

427: l_placement_value := g_riw_data(l_layout_cols_seq_row.interface_seq_num).placement;
428: hr_utility.set_location(l_placement_value, 56);
429:
430: IF l_placement_value ='LINE' OR l_placement_value IS NULL THEN
431: hr_utility.set_location('The Value is Line', 67);
432: l_placement_block := 3;
433: l_line_exist_seq := l_line_exist_seq+10;
434: l_dummy_seq_number := l_line_exist_seq;
435: ELSIF l_placement_value ='HEADER' THEN

Line 440: hr_utility.set_location('The Value is Line', 67);

436: l_placement_block := 2;
437: l_head_exist_seq := l_head_exist_seq+10;
438: l_dummy_seq_number := l_head_exist_seq;
439: ELSE
440: hr_utility.set_location('The Value is Line', 67);
441: l_placement_block := 1;
442: l_context_exist_seq := l_context_exist_seq+10;
443: l_dummy_seq_number := l_context_exist_seq;
444: END IF;

Line 476: hr_utility.set_location('bne package is called', 10);

472: ,x_display_width => l_layout_cols_seq_row.display_width
473: --$ Added New Column as in BNE Layout Table
474: ,X_READ_ONLY_FLAG => l_layout_cols_seq_row.READ_ONLY_FLAG);
475:
476: hr_utility.set_location('bne package is called', 10);
477: END LOOP;
478: CLOSE c_layout_cols_seq_row;
479: END LOOP;
480:

Line 489: Hr_Utility.set_location('NON Exist --Exist Seq Number: '||l_layout_cols_row.interface_seq_num, 5);

485: FETCH c_layout_cols_row INTO l_layout_cols_row;
486: EXIT WHEN c_layout_cols_row%NOTFOUND;
487:
488: IF g_riw_data.EXISTS(l_layout_cols_row.interface_seq_num) THEN
489: Hr_Utility.set_location('NON Exist --Exist Seq Number: '||l_layout_cols_row.interface_seq_num, 5);
490: ELSE
491: /* l_insert_flag := 'false';
492: --Checking to know the flexfields are selected by user
493: IF l_layout_cols_row.interface_seq_num = 155 THEN

Line 561: hr_utility.trace('layout col'||l_layout_cols_row.interface_seq_num);

557: ,x_last_updated_by => l_layout_cols_row.last_updated_by
558: ,x_last_update_login => l_layout_cols_row.last_update_login
559: --$ Added New Column as in BNE Layout Table
560: ,X_READ_ONLY_FLAG => l_layout_cols_row.READ_ONLY_FLAG);
561: hr_utility.trace('layout col'||l_layout_cols_row.interface_seq_num);
562: END IF;
563: END LOOP;
564: CLOSE c_layout_cols_row;
565: ELSE

Line 584: hr_utility.set_location('It is in the loop ', 88);

580: INTO l_layout_cols_row_others;
581: l_placement_block := l_layout_cols_row_others.block_id;
582: l_default_type := l_layout_cols_row_others.default_type;
583: l_default_value := l_layout_cols_row_others.DEFAULT_VALUE;
584: hr_utility.set_location('It is in the loop ', 88);
585: IF l_layout_cols_row_others.block_id = 3 then
586: l_line_display_seq := l_line_display_seq+10;
587: l_dummy_seq_number := l_line_display_seq;
588: ELSIF l_layout_cols_row_others.block_id = 2 THEN

Line 634: hr_utility.set_location('It is in the loop ', 88);

630: INTO l_layout_cols_row_others;
631: l_placement_block := l_layout_cols_row_others.block_id;
632: l_default_type := l_layout_cols_row_others.default_type;
633: l_default_value := l_layout_cols_row_others.DEFAULT_VALUE;
634: hr_utility.set_location('It is in the loop ', 88);
635: IF l_layout_cols_row_others.block_id = 3 then
636: l_line_display_seq := l_line_display_seq+10;
637: l_dummy_seq_number := l_line_display_seq;
638: ELSIF l_layout_cols_row_others.block_id = 2 THEN

Line 684: hr_utility.set_location('It is in the loop ', 88);

680: INTO l_layout_cols_row_others;
681: l_placement_block := l_layout_cols_row_others.block_id;
682: l_default_type := l_layout_cols_row_others.default_type;
683: l_default_value := l_layout_cols_row_others.DEFAULT_VALUE;
684: hr_utility.set_location('It is in the loop ', 88);
685: IF l_layout_cols_row_others.block_id = 3 then
686: l_line_display_seq := l_line_display_seq+10;
687: l_dummy_seq_number := l_line_display_seq;
688: ELSIF l_layout_cols_row_others.block_id = 2 THEN

Line 874: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

870: VV_INTERFACE_CODE BNE_INTERFACES_B.INTERFACE_CODE%TYPE;
871: l_proc_name VARCHAR2(72) := g_proc_name||'Create_RIW_Interface_Row';
872:
873: BEGIN
874: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
875: OPEN c_interface_row;
876: FETCH c_interface_row INTO l_interface_row;
877: IF c_interface_row%NOTFOUND THEN
878: RAISE no_default_layout;

Line 946: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);

942: ,SYSDATE
943: ,l_interface_row.CREATED_BY
944: ,SYSDATE);
945: END IF;
946: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
947:
948: END Create_RIW_Interface_Row;
949:
950:

Line 1046: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

1042: l_crt_upd_seq_num BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE;
1043:
1044:
1045: BEGIN
1046: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1047: -- Check the BNE_INTERFACE_COLS_B table to ensure that the record
1048: -- does not already exist
1049: VN_NO_INTERFACE_COL_FLAG := 0;
1050:

Line 1065: hr_utility.set_location('Loop Outside', 90);

1061: EXCEPTION
1062: WHEN NO_DATA_FOUND THEN NULL;
1063: END;
1064:
1065: hr_utility.set_location('Loop Outside', 90);
1066: -- If the Interface Column was not found then create
1067: IF (VN_NO_INTERFACE_COL_FLAG = 0) THEN
1068: OPEN c_interface_cols_row;
1069: LOOP

Line 1072: hr_utility.set_location(l_interface_cols_row.sequence_num, 78);

1068: OPEN c_interface_cols_row;
1069: LOOP
1070: FETCH c_interface_cols_row INTO l_interface_cols_row;
1071: EXIT WHEN c_interface_cols_row%NOTFOUND;
1072: hr_utility.set_location(l_interface_cols_row.sequence_num, 78);
1073: IF p_entity_name IS NULL then
1074: IF l_interface_cols_row.SEQUENCE_NUM IN (352) THEN
1075: l_default_type := 'CONSTANT';
1076: l_default_value := g_ins_upd_flag;

Line 1107: hr_utility.set_location('The Flag in cols row is ' || g_ins_upd_flag, 89);

1103: END IF;
1104: ELSE
1105:
1106: IF l_interface_cols_row.SEQUENCE_NUM IN (l_crt_upd_seq_num) THEN
1107: hr_utility.set_location('The Flag in cols row is ' || g_ins_upd_flag, 89);
1108: l_default_type := 'CONSTANT';
1109: l_default_value := g_ins_upd_flag;
1110: ELSE
1111: l_default_type := l_interface_cols_row.DEFAULT_TYPE;

Line 1207: hr_utility.set_location('The cols_b got created successfully', 79) ;

1203: ,l_interface_cols_row.CREATED_BY
1204: ,SYSDATE
1205: ,l_interface_cols_row.CREATED_BY
1206: ,SYSDATE);
1207: hr_utility.set_location('The cols_b got created successfully', 79) ;
1208:
1209: -- Insert the required row in BNE_INTERFACE_COLS_TL only if P_LANGUAGE is populated
1210:
1211: OPEN c_interface_tl_cols_row(l_interface_cols_row.SEQUENCE_NUM , userenv('LANG'));

Line 1213: hr_utility.set_location(l_interface_tl_cols_row.sequence_num, 80);

1209: -- Insert the required row in BNE_INTERFACE_COLS_TL only if P_LANGUAGE is populated
1210:
1211: OPEN c_interface_tl_cols_row(l_interface_cols_row.SEQUENCE_NUM , userenv('LANG'));
1212: FETCH c_interface_tl_cols_row into l_interface_tl_cols_row;
1213: hr_utility.set_location(l_interface_tl_cols_row.sequence_num, 80);
1214: IF c_interface_tl_cols_row%NOTFOUND THEN
1215: RAISE no_default_layout;
1216: END IF;
1217: CLOSE c_interface_tl_cols_row;

Line 1255: hr_utility.set_location('TL Records succes', 81);

1251: ,l_interface_cols_row.CREATED_BY
1252: ,SYSDATE
1253: ,l_interface_cols_row.CREATED_BY
1254: ,SYSDATE);
1255: hr_utility.set_location('TL Records succes', 81);
1256:
1257:
1258: END LOOP;
1259: CLOSE c_interface_cols_row;

Line 1261: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);

1257:
1258: END LOOP;
1259: CLOSE c_interface_cols_row;
1260: END IF;
1261: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
1262:
1263: END Create_RIW_Interface_Col_Rows;
1264:
1265:

Line 1305: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

1301: no_default_layout EXCEPTION;
1302: l_proc_name VARCHAR2(72) := g_package||'Create_RIW_Layout_Row';
1303:
1304: BEGIN
1305: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1306:
1307: OPEN c_layout_row;
1308: FETCH c_layout_row INTO l_layout_row;
1309: IF c_layout_row%NOTFOUND THEN

Line 1336: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);

1332: ,x_last_updated_by => l_layout_row.last_updated_by
1333: ,x_last_update_login => l_layout_row.last_update_login
1334: ,x_create_doc_list_app_id => l_layout_row.create_doc_list_app_id
1335: ,x_create_doc_list_code => l_layout_row.create_doc_list_code);
1336: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
1337:
1338: END Create_RIW_Layout_Row;
1339:
1340:

Line 1402: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

1398: l_seg_column_xml_data VARCHAR2(150);
1399: l_proc_name VARCHAR2(72) := g_package||'Create_RIW_OAF_Function';
1400:
1401: BEGIN
1402: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1403:
1404: IF p_action_type = 'Update' THEN
1405: SELECT fff.function_name into l_function_name
1406: FROM fnd_form_functions fff, fnd_form_functions_tl ffft

Line 1580: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);

1576: ,l_function_row.CREATED_BY
1577: ,1);
1578: END IF;
1579:
1580: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
1581:
1582: END Create_RIW_OAF_Function;
1583:
1584:

Line 1604: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

1600: l_ENTRY_SEQUENCE NUMBER := 0;
1601: l_proc_name VARCHAR2(72) := g_package||'Create_RIW_Menu_Entries';
1602:
1603: BEGIN
1604: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1605:
1606: SELECT function_id
1607: INTO l_fun_id
1608: FROM fnd_form_functions

Line 1631: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);

1627: ,X_LAST_UPDATE_DATE => sysdate
1628: ,X_LAST_UPDATED_BY => 1
1629: ,X_LAST_UPDATE_LOGIN => 0);
1630:
1631: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
1632: END Create_RIW_Menu_Entries;
1633:
1634:
1635:

Line 1736: hr_utility.set_location('ERROR occured',30);

1732: WHERE APPLICATION_ID = P_APPLICATION_ID
1733: AND INTERFACE_CODE = p_INTERFACE_CODE; */
1734: EXCEPTION
1735: WHEN OTHERS THEN
1736: hr_utility.set_location('ERROR occured',30);
1737: Null;
1738: END Delete_riw_integrator;
1739:
1740:

Line 1785: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

1781: VV_INTEGRATOR_CODE BNE_INTEGRATORS_B.INTEGRATOR_CODE%TYPE;
1782: l_proc_name VARCHAR2(72) := g_package||'Create_RIW_Integrator_Row';
1783:
1784: BEGIN
1785: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1786: OPEN c_intg_row;
1787: FETCH c_intg_row INTO l_intg_row;
1788: IF c_intg_row%NOTFOUND THEN
1789: RAISE no_default_layout;

Line 1889: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);

1885: P_SECURITY_TYPE =>'FUNCTION',
1886: P_SECURITY_VALUE =>'PQP_FLEXIBLE_WEBADI_CREATE_DOC',
1887: P_USER_ID =>1);
1888: END IF;
1889: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
1890:
1891: END Create_RIW_Integrator_Row;
1892:
1893:

Line 1945: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

1941: l_temp_val VARCHAR2(4000);
1942: l_proc_name VARCHAR2(72) := g_package||'Create_RIW_Content_Row';
1943:
1944: BEGIN
1945: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1946:
1947: OPEN c_content_row(c_base_content_code => p_base_content_code); --$ create non data pump content
1948: FETCH c_content_row INTO l_content_row;
1949: IF c_content_row%NOTFOUND THEN

Line 2136: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);

2132: (l_ce_content_out) and sequence_num = 270;
2133:
2134:
2135: --------
2136: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
2137:
2138: END Create_RIW_Content_Row;
2139:
2140: -- =============================================================================

Line 2251: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

2247: l_read_only_flag varchar2(3);
2248: l_sequence_num number(5);
2249:
2250: BEGIN
2251: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2252:
2253: OPEN c_content_row(c_base_content_code => p_base_content_code); --$ create non data pump content
2254: FETCH c_content_row INTO l_content_row;
2255: IF c_content_row%NOTFOUND THEN

Line 2274: hr_utility.set_location(l_temp_val, 44);

2270: l_first := false;
2271: END LOOP;
2272: CLOSE c_content_cols_row;
2273:
2274: hr_utility.set_location(l_temp_val, 44);
2275: BNE_CONTENT_UTILS.CREATE_CONTENT_DYNAMIC_SQL
2276: (P_APPLICATION_ID =>l_content_row.APPLICATION_ID
2277: ,P_OBJECT_CODE =>p_new_content_code
2278: ,P_INTEGRATOR_CODE =>p_intg_code

Line 2287: hr_utility.set_location('The content got created sucessfully ' || l_content_out, 55);

2283: ,P_SOURCE_LANGUAGE =>userenv('LANG')
2284: ,P_USER_ID =>1
2285: ,P_CONTENT_CODE =>l_content_out);
2286:
2287: hr_utility.set_location('The content got created sucessfully ' || l_content_out, 55);
2288:
2289: update bne_contents_b
2290: set param_list_code = l_content_row.param_list_code
2291: ,param_list_app_id = l_content_row.param_list_app_id

Line 2305: hr_utility.set_location('The content got created sucessfully ' || l_content_out, 55);

2301:
2302: END LOOP;
2303: CLOSE c_content_cols_row;
2304:
2305: hr_utility.set_location('The content got created sucessfully ' || l_content_out, 55);
2306: p_content_out := l_content_out;
2307:
2308: END Create_RIW_Content_Row_Others;
2309: -- =============================================================================

Line 2401: --Hr_Utility.trace_on(null,'RI_Trace');

2397: no_code_found EXCEPTION;
2398: l_func_type VARCHAR2(50);
2399: l_search VARCHAR2(10);
2400: BEGIN
2401: --Hr_Utility.trace_on(null,'RI_Trace');
2402: hr_utility.set_location('Entering: '||l_proc_name, 5);
2403: hr_utility.set_location('The flag is ' ||p_ins_upd_datapmp_flag, 6);
2404: hr_utility.set_location(p_seq_params || ' First', 10);
2405: hr_utility.set_location(p_intrfce_seq_params || ' Second', 15);

Line 2402: hr_utility.set_location('Entering: '||l_proc_name, 5);

2398: l_func_type VARCHAR2(50);
2399: l_search VARCHAR2(10);
2400: BEGIN
2401: --Hr_Utility.trace_on(null,'RI_Trace');
2402: hr_utility.set_location('Entering: '||l_proc_name, 5);
2403: hr_utility.set_location('The flag is ' ||p_ins_upd_datapmp_flag, 6);
2404: hr_utility.set_location(p_seq_params || ' First', 10);
2405: hr_utility.set_location(p_intrfce_seq_params || ' Second', 15);
2406: -- hr_utility.set_location(p_xml_tag_params || ' Third', 10);

Line 2403: hr_utility.set_location('The flag is ' ||p_ins_upd_datapmp_flag, 6);

2399: l_search VARCHAR2(10);
2400: BEGIN
2401: --Hr_Utility.trace_on(null,'RI_Trace');
2402: hr_utility.set_location('Entering: '||l_proc_name, 5);
2403: hr_utility.set_location('The flag is ' ||p_ins_upd_datapmp_flag, 6);
2404: hr_utility.set_location(p_seq_params || ' First', 10);
2405: hr_utility.set_location(p_intrfce_seq_params || ' Second', 15);
2406: -- hr_utility.set_location(p_xml_tag_params || ' Third', 10);
2407: hr_utility.set_location(p_defalut_type_params || ' Fourth', 10);

Line 2404: hr_utility.set_location(p_seq_params || ' First', 10);

2400: BEGIN
2401: --Hr_Utility.trace_on(null,'RI_Trace');
2402: hr_utility.set_location('Entering: '||l_proc_name, 5);
2403: hr_utility.set_location('The flag is ' ||p_ins_upd_datapmp_flag, 6);
2404: hr_utility.set_location(p_seq_params || ' First', 10);
2405: hr_utility.set_location(p_intrfce_seq_params || ' Second', 15);
2406: -- hr_utility.set_location(p_xml_tag_params || ' Third', 10);
2407: hr_utility.set_location(p_defalut_type_params || ' Fourth', 10);
2408: -- hr_utility.set_location(p_defalut_value_params || ' Fifth', 10);

Line 2405: hr_utility.set_location(p_intrfce_seq_params || ' Second', 15);

2401: --Hr_Utility.trace_on(null,'RI_Trace');
2402: hr_utility.set_location('Entering: '||l_proc_name, 5);
2403: hr_utility.set_location('The flag is ' ||p_ins_upd_datapmp_flag, 6);
2404: hr_utility.set_location(p_seq_params || ' First', 10);
2405: hr_utility.set_location(p_intrfce_seq_params || ' Second', 15);
2406: -- hr_utility.set_location(p_xml_tag_params || ' Third', 10);
2407: hr_utility.set_location(p_defalut_type_params || ' Fourth', 10);
2408: -- hr_utility.set_location(p_defalut_value_params || ' Fifth', 10);
2409: hr_utility.set_location(p_placement_params || ' Sixth', 10);

Line 2406: -- hr_utility.set_location(p_xml_tag_params || ' Third', 10);

2402: hr_utility.set_location('Entering: '||l_proc_name, 5);
2403: hr_utility.set_location('The flag is ' ||p_ins_upd_datapmp_flag, 6);
2404: hr_utility.set_location(p_seq_params || ' First', 10);
2405: hr_utility.set_location(p_intrfce_seq_params || ' Second', 15);
2406: -- hr_utility.set_location(p_xml_tag_params || ' Third', 10);
2407: hr_utility.set_location(p_defalut_type_params || ' Fourth', 10);
2408: -- hr_utility.set_location(p_defalut_value_params || ' Fifth', 10);
2409: hr_utility.set_location(p_placement_params || ' Sixth', 10);
2410: -- get next seq value : INTERFACE_SEQ

Line 2407: hr_utility.set_location(p_defalut_type_params || ' Fourth', 10);

2403: hr_utility.set_location('The flag is ' ||p_ins_upd_datapmp_flag, 6);
2404: hr_utility.set_location(p_seq_params || ' First', 10);
2405: hr_utility.set_location(p_intrfce_seq_params || ' Second', 15);
2406: -- hr_utility.set_location(p_xml_tag_params || ' Third', 10);
2407: hr_utility.set_location(p_defalut_type_params || ' Fourth', 10);
2408: -- hr_utility.set_location(p_defalut_value_params || ' Fifth', 10);
2409: hr_utility.set_location(p_placement_params || ' Sixth', 10);
2410: -- get next seq value : INTERFACE_SEQ
2411: hr_utility.set_location(p_entity_name, 15);

Line 2408: -- hr_utility.set_location(p_defalut_value_params || ' Fifth', 10);

2404: hr_utility.set_location(p_seq_params || ' First', 10);
2405: hr_utility.set_location(p_intrfce_seq_params || ' Second', 15);
2406: -- hr_utility.set_location(p_xml_tag_params || ' Third', 10);
2407: hr_utility.set_location(p_defalut_type_params || ' Fourth', 10);
2408: -- hr_utility.set_location(p_defalut_value_params || ' Fifth', 10);
2409: hr_utility.set_location(p_placement_params || ' Sixth', 10);
2410: -- get next seq value : INTERFACE_SEQ
2411: hr_utility.set_location(p_entity_name, 15);
2412:

Line 2409: hr_utility.set_location(p_placement_params || ' Sixth', 10);

2405: hr_utility.set_location(p_intrfce_seq_params || ' Second', 15);
2406: -- hr_utility.set_location(p_xml_tag_params || ' Third', 10);
2407: hr_utility.set_location(p_defalut_type_params || ' Fourth', 10);
2408: -- hr_utility.set_location(p_defalut_value_params || ' Fifth', 10);
2409: hr_utility.set_location(p_placement_params || ' Sixth', 10);
2410: -- get next seq value : INTERFACE_SEQ
2411: hr_utility.set_location(p_entity_name, 15);
2412:
2413: BEGIN

Line 2411: hr_utility.set_location(p_entity_name, 15);

2407: hr_utility.set_location(p_defalut_type_params || ' Fourth', 10);
2408: -- hr_utility.set_location(p_defalut_value_params || ' Fifth', 10);
2409: hr_utility.set_location(p_placement_params || ' Sixth', 10);
2410: -- get next seq value : INTERFACE_SEQ
2411: hr_utility.set_location(p_entity_name, 15);
2412:
2413: BEGIN
2414: SELECT description into l_func_type
2415: FROM pqp_flxdu_columns WHERE

Line 2427: hr_utility.set_location('The search Value is ' || l_search, 99);

2423: l_search := SUBSTR(l_func_type, 11, 1);
2424: ELSE
2425: l_search := 'T';
2426: END IF;
2427: hr_utility.set_location('The search Value is ' || l_search, 99);
2428:
2429: SELECT PQP_FLXDU_FUNCTIONS_S.nextval
2430: INTO l_riw_seq_id
2431: FROM dual;

Line 2516: hr_utility.set_location('Allow First Is '|| l_ins_upd_datapmp_flag, 5);

2512: l_flag1 := l_ins_upd_datapmp_flag;
2513: l_allow_insert_loc := INSTR(l_ins_upd_datapmp_flag, ':');
2514: l_allow_insert := SUBSTR(l_ins_upd_datapmp_flag, 1, l_allow_insert_loc-1);
2515: l_flag1 := SUBSTR(l_ins_upd_datapmp_flag, l_allow_insert_loc+1, LENGTH(l_ins_upd_datapmp_flag));
2516: hr_utility.set_location('Allow First Is '|| l_ins_upd_datapmp_flag, 5);
2517: l_migration_flag_loc := INSTR(l_flag1, ':');
2518: hr_utility.set_location('Allow Second Is '|| l_migration_flag_loc, 6);
2519: l_migration_flag := SUBSTR(l_flag1, 3);
2520: hr_utility.set_location('Allow Third Is '|| l_migration_flag, 6);

Line 2518: hr_utility.set_location('Allow Second Is '|| l_migration_flag_loc, 6);

2514: l_allow_insert := SUBSTR(l_ins_upd_datapmp_flag, 1, l_allow_insert_loc-1);
2515: l_flag1 := SUBSTR(l_ins_upd_datapmp_flag, l_allow_insert_loc+1, LENGTH(l_ins_upd_datapmp_flag));
2516: hr_utility.set_location('Allow First Is '|| l_ins_upd_datapmp_flag, 5);
2517: l_migration_flag_loc := INSTR(l_flag1, ':');
2518: hr_utility.set_location('Allow Second Is '|| l_migration_flag_loc, 6);
2519: l_migration_flag := SUBSTR(l_flag1, 3);
2520: hr_utility.set_location('Allow Third Is '|| l_migration_flag, 6);
2521: hr_utility.set_location('Allow Insert Is '|| l_allow_insert, 7);
2522: hr_utility.set_location('Allow Migration Is '|| l_migration_flag, 8);

Line 2520: hr_utility.set_location('Allow Third Is '|| l_migration_flag, 6);

2516: hr_utility.set_location('Allow First Is '|| l_ins_upd_datapmp_flag, 5);
2517: l_migration_flag_loc := INSTR(l_flag1, ':');
2518: hr_utility.set_location('Allow Second Is '|| l_migration_flag_loc, 6);
2519: l_migration_flag := SUBSTR(l_flag1, 3);
2520: hr_utility.set_location('Allow Third Is '|| l_migration_flag, 6);
2521: hr_utility.set_location('Allow Insert Is '|| l_allow_insert, 7);
2522: hr_utility.set_location('Allow Migration Is '|| l_migration_flag, 8);
2523: IF l_allow_insert = 'Create' THEN
2524: g_ins_upd_flag := 'C';

Line 2521: hr_utility.set_location('Allow Insert Is '|| l_allow_insert, 7);

2517: l_migration_flag_loc := INSTR(l_flag1, ':');
2518: hr_utility.set_location('Allow Second Is '|| l_migration_flag_loc, 6);
2519: l_migration_flag := SUBSTR(l_flag1, 3);
2520: hr_utility.set_location('Allow Third Is '|| l_migration_flag, 6);
2521: hr_utility.set_location('Allow Insert Is '|| l_allow_insert, 7);
2522: hr_utility.set_location('Allow Migration Is '|| l_migration_flag, 8);
2523: IF l_allow_insert = 'Create' THEN
2524: g_ins_upd_flag := 'C';
2525: IF l_entity_name is null THEN

Line 2522: hr_utility.set_location('Allow Migration Is '|| l_migration_flag, 8);

2518: hr_utility.set_location('Allow Second Is '|| l_migration_flag_loc, 6);
2519: l_migration_flag := SUBSTR(l_flag1, 3);
2520: hr_utility.set_location('Allow Third Is '|| l_migration_flag, 6);
2521: hr_utility.set_location('Allow Insert Is '|| l_allow_insert, 7);
2522: hr_utility.set_location('Allow Migration Is '|| l_migration_flag, 8);
2523: IF l_allow_insert = 'Create' THEN
2524: g_ins_upd_flag := 'C';
2525: IF l_entity_name is null THEN
2526: g_ins_upd_flag := g_ins_upd_flag||':'||l_migration_flag;

Line 2541: hr_utility.set_location('Allow Insert Is '|| g_ins_upd_flag, 7);

2537: IF l_entity_name is null THEN
2538: g_ins_upd_flag := g_ins_upd_flag||':'||l_migration_flag;
2539: END IF;
2540: END IF;
2541: hr_utility.set_location('Allow Insert Is '|| g_ins_upd_flag, 7);
2542:
2543: hr_utility.set_location('Before PL/SQL Records', 5);
2544: LOOP
2545: l_sq_location := INSTR(l_seq_params, '+');

Line 2543: hr_utility.set_location('Before PL/SQL Records', 5);

2539: END IF;
2540: END IF;
2541: hr_utility.set_location('Allow Insert Is '|| g_ins_upd_flag, 7);
2542:
2543: hr_utility.set_location('Before PL/SQL Records', 5);
2544: LOOP
2545: l_sq_location := INSTR(l_seq_params, '+');
2546: l_inter_location := INSTR(l_intrfce_seq_params, '+');
2547: l_type_location := INSTR(l_defalut_type_params, '+');

Line 2622: hr_utility.set_location('Before Calling functions', 5);

2618:
2619: EXIT WHEN l_sq_location = 0;
2620: END LOOP;
2621:
2622: hr_utility.set_location('Before Calling functions', 5);
2623: IF p_action_type ='Update' THEN
2624: hr_utility.trace('Inside Update:');
2625: Delete_riw_integrator
2626: (p_LAYOUT_CODE => p_upd_layout_code

Line 2624: hr_utility.trace('Inside Update:');

2620: END LOOP;
2621:
2622: hr_utility.set_location('Before Calling functions', 5);
2623: IF p_action_type ='Update' THEN
2624: hr_utility.trace('Inside Update:');
2625: Delete_riw_integrator
2626: (p_LAYOUT_CODE => p_upd_layout_code
2627: ,p_MAPPING_CODE => p_upd_mapping_code
2628: ,p_INTERFACE_CODE => p_upd_interface_code

Line 2689: hr_utility.set_location('Outside the call ' || l_out_content_code, 76);

2685: ,p_intg_code =>l_new_intg_code
2686: ,p_content_name =>p_user_function_name
2687: ,p_entity_name =>l_entity_name
2688: ,p_content_out =>l_out_content_code);
2689: hr_utility.set_location('Outside the call ' || l_out_content_code, 76);
2690: END IF;
2691: END IF;
2692:
2693:

Line 2727: hr_utility.set_location('Executed block API', 50);

2723: (p_application_id => p_application_id
2724: ,p_new_layout_code => l_new_layout_code
2725: ,p_base_layout_code => l_base_layout_code
2726: ,p_user_name => p_user_function_name);
2727: hr_utility.set_location('Executed block API', 50);
2728: Create_RIW_Layout_Cols_Row
2729: (p_application_id => p_application_id
2730: ,p_new_layout_code => l_new_layout_code
2731: ,p_base_layout_code => l_base_layout_code

Line 2773: hr_utility.set_location(l_out_content_code, 56);

2769: ,p_data_source => p_data_source
2770: ,p_new_intg_code => l_new_intg_code
2771: ,p_entity_name => l_entity_name);
2772:
2773: hr_utility.set_location(l_out_content_code, 56);
2774: Create_RIW_Mapping_Links_Rows
2775: (p_application_id => p_application_id
2776: ,p_new_mapping_code => l_new_mapping_code
2777: ,p_new_interface_code => l_new_intrfc_code

Line 2881: hr_utility.set_location('Leaving: '||l_proc_name, 5);

2877: END IF;
2878: g_temp_riw_data.DELETE;
2879: g_riw_data.DELETE;
2880: p_return_status := 'Y';
2881: hr_utility.set_location('Leaving: '||l_proc_name, 5);
2882:
2883: Create_Derived_Param_List(p_application_id => p_application_id
2884: ,p_param_list_code => l_derived_param_list_code
2885: ,p_parameter_value => l_ins_upd_datapmp_flag);

Line 2888: hr_utility.set_location('Error: '||l_proc_name, 5);

2884: ,p_param_list_code => l_derived_param_list_code
2885: ,p_parameter_value => l_ins_upd_datapmp_flag);
2886: Exception
2887: when others then
2888: hr_utility.set_location('Error: '||l_proc_name, 5);
2889: g_temp_riw_data.DELETE;
2890: g_riw_data.DELETE;
2891: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 100);
2892: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 101);

Line 2891: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 100);

2887: when others then
2888: hr_utility.set_location('Error: '||l_proc_name, 5);
2889: g_temp_riw_data.DELETE;
2890: g_riw_data.DELETE;
2891: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 100);
2892: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 101);
2893: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 102);
2894: p_return_status := 'E';
2895: END Create_RIW_Webadi_Setup;

Line 2892: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 101);

2888: hr_utility.set_location('Error: '||l_proc_name, 5);
2889: g_temp_riw_data.DELETE;
2890: g_riw_data.DELETE;
2891: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 100);
2892: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 101);
2893: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 102);
2894: p_return_status := 'E';
2895: END Create_RIW_Webadi_Setup;
2896:

Line 2893: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 102);

2889: g_temp_riw_data.DELETE;
2890: g_riw_data.DELETE;
2891: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 100);
2892: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 101);
2893: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 102);
2894: p_return_status := 'E';
2895: END Create_RIW_Webadi_Setup;
2896:
2897:

Line 2931: -- hr_utility.trace_on(null,'TTT');

2927: --$
2928: l_intf_code VARCHAR2(30);
2929:
2930: BEGIN
2931: -- hr_utility.trace_on(null,'TTT');
2932: -- get the count of function_id from fnd_menu_entries
2933: SELECT count(function_id)
2934: INTO l_count
2935: FROM fnd_menu_entries

Line 2978: hr_utility.trace('DELETE: INTERFACE='|| l_intf_code);

2974: FND_FORM_FUNCTIONS_PKG.DELETE_ROW(
2975: X_FUNCTION_ID => p_function_id);
2976:
2977:
2978: hr_utility.trace('DELETE: INTERFACE='|| l_intf_code);
2979:
2980: if l_intf_code IS NOT NULL then
2981: Delete_riw_integrator(p_INTERFACE_CODE => l_intf_code
2982: ,p_application_id => 8303 );

Line 3201: Hr_Utility.raise_error;

3197: -- If Delimiter is not found then that means the passed DFF doesn't exist for
3198: -- the passed application id. Raise an Error
3199: IF csr_get_delimiter_and_context%NOTFOUND THEN
3200: CLOSE csr_get_delimiter_and_context;
3201: Hr_Utility.raise_error;
3202: END IF;
3203: CLOSE csr_get_delimiter_and_context;
3204:
3205: l_delimiter := r_delim_ctx_rec.con_seg_delim;

Line 3234: hr_utility.trace('Inside non global condition');

3230:
3231: --IF condition added by pkagrawa to check for non global data context
3232: IF p_context <> 'Global Data Elements' THEN
3233:
3234: hr_utility.trace('Inside non global condition');
3235:
3236: --$3
3237: l_segment_count := l_segment_count +1; -- keeping no of delimiters and segments in sync
3238:

Line 3310: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 100);

3306: RETURN l_concat_segments;
3307:
3308: Exception
3309: when others then
3310: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 100);
3311: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 101);
3312: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 102);
3313:
3314: END Get_Concatanated_DFF_Segments;

Line 3311: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 101);

3307:
3308: Exception
3309: when others then
3310: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 100);
3311: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 101);
3312: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 102);
3313:
3314: END Get_Concatanated_DFF_Segments;
3315:

Line 3312: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 102);

3308: Exception
3309: when others then
3310: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 100);
3311: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 101);
3312: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 102);
3313:
3314: END Get_Concatanated_DFF_Segments;
3315:
3316: END PQP_RIW_WEBADI_UTILS;