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.

[Home] [Help]

APPS.PQP_RIW_WEBADI_UTILS dependencies on HR_UTILITY

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

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

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

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

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

264: EXIT WHEN c_mapping_cols_row%NOTFOUND;
265: --Checking the base Interface Seq number exist in selected interface number
266: --or by default provided sequence number
267: l_temp_interface_seq_num := l_mapping_cols_row.INTERFACE_SEQ_NUM;
268: hr_utility.set_location(l_temp_interface_seq_num, 50);
269: IF p_entity_name IS NULL THEN
270: IF g_riw_data.EXISTS(l_temp_interface_seq_num) OR l_temp_interface_seq_num IN
271: (59,176,253,254,332,334,335,333,331,330,328,177,19, 62, 93, 124, 155,340,
272: 350,351 --$ Include Batch Link and Exception

Line 300: hr_utility.set_location('l_interface_code'||l_interface_code, 10);

296: ,X_LAST_UPDATE_LOGIN => l_mapping_cols_row.CREATED_BY);
297: END IF;
298: ELSE
299: --$ Cursor to get the interface column for the current interface seq num
300: hr_utility.set_location('l_interface_code'||l_interface_code, 10);
301: hr_utility.set_location('l_temp_interface_seq_num'||l_temp_interface_seq_num, 20);
302:
303: OPEN c_intf_cols_row(c_interface_code => l_interface_code
304: ,c_interface_seq_num => l_temp_interface_seq_num);

Line 301: hr_utility.set_location('l_temp_interface_seq_num'||l_temp_interface_seq_num, 20);

297: END IF;
298: ELSE
299: --$ Cursor to get the interface column for the current interface seq num
300: hr_utility.set_location('l_interface_code'||l_interface_code, 10);
301: hr_utility.set_location('l_temp_interface_seq_num'||l_temp_interface_seq_num, 20);
302:
303: OPEN c_intf_cols_row(c_interface_code => l_interface_code
304: ,c_interface_seq_num => l_temp_interface_seq_num);
305: FETCH c_intf_cols_row INTO l_intf_cols_row;

Line 307: hr_utility.set_location('l_intf_cols_row.VAL_TYPE'||l_intf_cols_row.VAL_TYPE, 10);

303: OPEN c_intf_cols_row(c_interface_code => l_interface_code
304: ,c_interface_seq_num => l_temp_interface_seq_num);
305: FETCH c_intf_cols_row INTO l_intf_cols_row;
306: --$ Include KFF segments only if the Concatenated segment is included in the layout
307: hr_utility.set_location('l_intf_cols_row.VAL_TYPE'||l_intf_cols_row.VAL_TYPE, 10);
308: hr_utility.set_location('l_intf_cols_row.GROUP_NAME'||l_intf_cols_row.GROUP_NAME, 20);
309: if(l_intf_cols_row.VAL_TYPE = 'KEYFLEXSEG') then
310: open c_key_flex_row (c_interface_code =>l_interface_code
311: ,c_grp_name =>l_intf_cols_row.GROUP_NAME);

Line 308: hr_utility.set_location('l_intf_cols_row.GROUP_NAME'||l_intf_cols_row.GROUP_NAME, 20);

304: ,c_interface_seq_num => l_temp_interface_seq_num);
305: FETCH c_intf_cols_row INTO l_intf_cols_row;
306: --$ Include KFF segments only if the Concatenated segment is included in the layout
307: hr_utility.set_location('l_intf_cols_row.VAL_TYPE'||l_intf_cols_row.VAL_TYPE, 10);
308: hr_utility.set_location('l_intf_cols_row.GROUP_NAME'||l_intf_cols_row.GROUP_NAME, 20);
309: if(l_intf_cols_row.VAL_TYPE = 'KEYFLEXSEG') then
310: open c_key_flex_row (c_interface_code =>l_interface_code
311: ,c_grp_name =>l_intf_cols_row.GROUP_NAME);
312: FETCH c_key_flex_row into l_key_flex_row;

Line 314: hr_utility.set_location('Inside the KEYFLEXSEG IF', 10);

310: open c_key_flex_row (c_interface_code =>l_interface_code
311: ,c_grp_name =>l_intf_cols_row.GROUP_NAME);
312: FETCH c_key_flex_row into l_key_flex_row;
313:
314: hr_utility.set_location('Inside the KEYFLEXSEG IF', 10);
315: hr_utility.set_location('l_key_flex_row.sequence_num'||l_key_flex_row.sequence_num, 20);
316:
317: IF g_riw_data.EXISTS(l_key_flex_row.sequence_num) THEN
318: l_kff_seg_flag := TRUE;

Line 315: hr_utility.set_location('l_key_flex_row.sequence_num'||l_key_flex_row.sequence_num, 20);

311: ,c_grp_name =>l_intf_cols_row.GROUP_NAME);
312: FETCH c_key_flex_row into l_key_flex_row;
313:
314: hr_utility.set_location('Inside the KEYFLEXSEG IF', 10);
315: hr_utility.set_location('l_key_flex_row.sequence_num'||l_key_flex_row.sequence_num, 20);
316:
317: IF g_riw_data.EXISTS(l_key_flex_row.sequence_num) THEN
318: l_kff_seg_flag := TRUE;
319: END IF;

Line 322: hr_utility.set_location('Before If ', 30);

318: l_kff_seg_flag := TRUE;
319: END IF;
320: CLOSE c_key_flex_row;
321: end if;
322: hr_utility.set_location('Before If ', 30);
323:
324: IF g_riw_data.EXISTS(l_temp_interface_seq_num)
325: or l_kff_seg_flag
326: -- or ((l_temp_interface_seq_num between 52 and 81) and (p_entity_name='JOB'))

Line 328: hr_utility.set_location('Inside if ', 40);

324: IF g_riw_data.EXISTS(l_temp_interface_seq_num)
325: or l_kff_seg_flag
326: -- or ((l_temp_interface_seq_num between 52 and 81) and (p_entity_name='JOB'))
327: THEN
328: hr_utility.set_location('Inside if ', 40);
329: BNE_MAPPING_LINES_PKG.INSERT_ROW
330: (x_rowid => l_rowid
331: ,x_application_id => p_application_id
332: ,X_MAPPING_CODE => p_new_mapping_code

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

346: ,X_LAST_UPDATE_LOGIN => l_mapping_cols_row.CREATED_BY);
347: END IF;
348: CLOSE c_intf_cols_row;
349: END IF;
350: hr_utility.set_location('Before finishing the loop', 60);
351: l_kff_seg_flag := FALSE;
352: END LOOP;
353: CLOSE c_mapping_cols_row;
354:

Line 407: hr_utility.set_location('Hehehehe ' || l_layout_cols_row.interface_seq_num, 99);

403: OPEN c_layout_cols_row(c_interface_seq_num => p_interface_seq_num);
404: LOOP
405: FETCH c_layout_cols_row INTO l_layout_cols_row;
406: EXIT WHEN c_layout_cols_row%NOTFOUND;
407: hr_utility.set_location('Hehehehe ' || l_layout_cols_row.interface_seq_num, 99);
408:
409: l_final_seq_number := p_layout_seq_num;
410:
411: bne_layout_cols_pkg.insert_row

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

432: ,x_last_updated_by => l_layout_cols_row.last_updated_by
433: ,x_last_update_login => l_layout_cols_row.last_update_login
434: --$ Added New Column as in BNE Layout Table
435: ,X_READ_ONLY_FLAG => l_layout_cols_row.READ_ONLY_FLAG);
436: hr_utility.trace('layout col'||l_layout_cols_row.interface_seq_num);
437: END LOOP;
438: CLOSE c_layout_cols_row;
439:
440: END Create_Layout_Cols_Spec_Row;

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

571:
572:
573: BEGIN
574:
575: hr_utility.set_location('Inside creating the layout cols',20);
576: hr_utility.set_location(p_new_interface_code, 25);
577: --Gettting the values for selected seq numbers
578: FOR l_interface_index IN g_temp_riw_data.FIRST..g_temp_riw_data.LAST
579: LOOP

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

572:
573: BEGIN
574:
575: hr_utility.set_location('Inside creating the layout cols',20);
576: hr_utility.set_location(p_new_interface_code, 25);
577: --Gettting the values for selected seq numbers
578: FOR l_interface_index IN g_temp_riw_data.FIRST..g_temp_riw_data.LAST
579: LOOP
580: l_interface_seq_num := g_temp_riw_data(l_interface_index).interface_seq;

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

581: OPEN c_layout_cols_seq_row(c_interface_seq_num => l_interface_seq_num);
582: LOOP
583: FETCH c_layout_cols_seq_row INTO l_layout_cols_seq_row;
584: EXIT WHEN c_layout_cols_seq_row%NOTFOUND;
585: hr_utility.set_location(l_interface_seq_num, 30);
586: l_default_value := g_riw_data(l_layout_cols_seq_row.interface_seq_num).default_value;
587: l_default_type := g_riw_data(l_layout_cols_seq_row.interface_seq_num).default_type;
588:
589: IF l_default_type ='N' THEN

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

613: END IF;
614: END IF;
615: END IF;
616: l_placement_value := g_riw_data(l_layout_cols_seq_row.interface_seq_num).placement;
617: hr_utility.set_location(l_placement_value, 56);
618:
619: IF l_placement_value ='LINE' OR l_placement_value IS NULL THEN
620: hr_utility.set_location('The Value is Line', 67);
621: l_placement_block := 3;

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

616: l_placement_value := g_riw_data(l_layout_cols_seq_row.interface_seq_num).placement;
617: hr_utility.set_location(l_placement_value, 56);
618:
619: IF l_placement_value ='LINE' OR l_placement_value IS NULL THEN
620: hr_utility.set_location('The Value is Line', 67);
621: l_placement_block := 3;
622: l_line_exist_seq := l_line_exist_seq+10;
623: l_dummy_seq_number := l_line_exist_seq;
624: ELSIF l_placement_value ='HEADER' THEN

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

625: l_placement_block := 2;
626: l_head_exist_seq := l_head_exist_seq+10;
627: l_dummy_seq_number := l_head_exist_seq;
628: ELSE
629: hr_utility.set_location('The Value is Line', 67);
630: l_placement_block := 1;
631: l_context_exist_seq := l_context_exist_seq+10;
632: l_dummy_seq_number := l_context_exist_seq;
633: END IF;

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

692: ,p_placement_block_id => l_placement_block);
693: END IF;
694:
695: IF l_placement_value ='LINE' OR l_placement_value IS NULL THEN
696: hr_utility.set_location('The Value is Line', 67);
697: l_placement_block := 3;
698: l_line_exist_seq := l_line_exist_seq+10;
699: l_dummy_seq_number := l_line_exist_seq;
700: ELSIF l_placement_value ='HEADER' THEN

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

701: l_placement_block := 2;
702: l_head_exist_seq := l_head_exist_seq+10;
703: l_dummy_seq_number := l_head_exist_seq;
704: ELSE
705: hr_utility.set_location('The Value is Line', 67);
706: l_placement_block := 1;
707: l_context_exist_seq := l_context_exist_seq+10;
708: l_dummy_seq_number := l_context_exist_seq;
709: END IF;

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

741: ,x_display_width => l_layout_cols_seq_row.display_width
742: --$ Added New Column as in BNE Layout Table
743: ,X_READ_ONLY_FLAG => l_layout_cols_seq_row.READ_ONLY_FLAG);
744:
745: hr_utility.set_location('bne package is called', 10);
746: END LOOP;
747: CLOSE c_layout_cols_seq_row;
748: END LOOP;
749:

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

754: FETCH c_layout_cols_row INTO l_layout_cols_row;
755: EXIT WHEN c_layout_cols_row%NOTFOUND;
756:
757: IF g_riw_data.EXISTS(l_layout_cols_row.interface_seq_num) THEN
758: Hr_Utility.set_location('NON Exist --Exist Seq Number: '||l_layout_cols_row.interface_seq_num, 5);
759: ELSE
760: /* l_insert_flag := 'false';
761: --Checking to know the flexfields are selected by user
762: IF l_layout_cols_row.interface_seq_num = 155 THEN

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

826: ,x_last_updated_by => l_layout_cols_row.last_updated_by
827: ,x_last_update_login => l_layout_cols_row.last_update_login
828: --$ Added New Column as in BNE Layout Table
829: ,X_READ_ONLY_FLAG => l_layout_cols_row.READ_ONLY_FLAG);
830: hr_utility.trace('layout col'||l_layout_cols_row.interface_seq_num);
831: END IF;
832: END LOOP;
833: CLOSE c_layout_cols_row;
834: ELSE

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

849: INTO l_layout_cols_row_others;
850: l_placement_block := l_layout_cols_row_others.block_id;
851: l_default_type := l_layout_cols_row_others.default_type;
852: l_default_value := l_layout_cols_row_others.DEFAULT_VALUE;
853: hr_utility.set_location('It is in the loop ', 88);
854: IF l_layout_cols_row_others.block_id = 3 then
855: l_line_display_seq := l_line_display_seq+10;
856: l_dummy_seq_number := l_line_display_seq;
857: ELSIF l_layout_cols_row_others.block_id = 2 THEN

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

899: INTO l_layout_cols_row_others;
900: l_placement_block := l_layout_cols_row_others.block_id;
901: l_default_type := l_layout_cols_row_others.default_type;
902: l_default_value := l_layout_cols_row_others.DEFAULT_VALUE;
903: hr_utility.set_location('It is in the loop ', 88);
904: IF l_layout_cols_row_others.block_id = 3 then
905: l_line_display_seq := l_line_display_seq+10;
906: l_dummy_seq_number := l_line_display_seq;
907: ELSIF l_layout_cols_row_others.block_id = 2 THEN

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

949: INTO l_layout_cols_row_others;
950: l_placement_block := l_layout_cols_row_others.block_id;
951: l_default_type := l_layout_cols_row_others.default_type;
952: l_default_value := l_layout_cols_row_others.DEFAULT_VALUE;
953: hr_utility.set_location('It is in the loop ', 88);
954: IF l_layout_cols_row_others.block_id = 3 then
955: l_line_display_seq := l_line_display_seq+10;
956: l_dummy_seq_number := l_line_display_seq;
957: ELSIF l_layout_cols_row_others.block_id = 2 THEN

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

1139: VV_INTERFACE_CODE BNE_INTERFACES_B.INTERFACE_CODE%TYPE;
1140: l_proc_name VARCHAR2(72) := g_proc_name||'Create_RIW_Interface_Row';
1141:
1142: BEGIN
1143: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1144: OPEN c_interface_row;
1145: FETCH c_interface_row INTO l_interface_row;
1146: IF c_interface_row%NOTFOUND THEN
1147: RAISE no_default_layout;

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

1211: ,SYSDATE
1212: ,l_interface_row.CREATED_BY
1213: ,SYSDATE);
1214: END IF;
1215: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
1216:
1217: END Create_RIW_Interface_Row;
1218:
1219:

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

1311: l_crt_upd_seq_num BNE_INTERFACE_COLS_B.SEQUENCE_NUM%TYPE;
1312:
1313:
1314: BEGIN
1315: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1316: -- Check the BNE_INTERFACE_COLS_B table to ensure that the record
1317: -- does not already exist
1318: VN_NO_INTERFACE_COL_FLAG := 0;
1319:

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

1330: EXCEPTION
1331: WHEN NO_DATA_FOUND THEN NULL;
1332: END;
1333:
1334: hr_utility.set_location('Loop Outside', 90);
1335: -- If the Interface Column was not found then create
1336: IF (VN_NO_INTERFACE_COL_FLAG = 0) THEN
1337: OPEN c_interface_cols_row;
1338: LOOP

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

1337: OPEN c_interface_cols_row;
1338: LOOP
1339: FETCH c_interface_cols_row INTO l_interface_cols_row;
1340: EXIT WHEN c_interface_cols_row%NOTFOUND;
1341: hr_utility.set_location(l_interface_cols_row.sequence_num, 78);
1342: IF p_entity_name IS NULL then
1343: IF l_interface_cols_row.SEQUENCE_NUM IN (352) THEN
1344: l_default_type := 'CONSTANT';
1345: l_default_value := g_ins_upd_flag;

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

1372: END IF;
1373: ELSE
1374:
1375: IF l_interface_cols_row.SEQUENCE_NUM IN (l_crt_upd_seq_num) THEN
1376: hr_utility.set_location('The Flag in cols row is ' || g_ins_upd_flag, 89);
1377: l_default_type := 'CONSTANT';
1378: l_default_value := g_ins_upd_flag;
1379: ELSE
1380: l_default_type := l_interface_cols_row.DEFAULT_TYPE;

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

1486: ,l_interface_cols_row.CREATED_BY
1487: ,SYSDATE
1488: ,l_interface_cols_row.CREATED_BY
1489: ,SYSDATE);
1490: hr_utility.set_location('The cols_b got created successfully', 79) ;
1491:
1492: -- Insert the required row in BNE_INTERFACE_COLS_TL only if P_LANGUAGE is populated
1493:
1494: OPEN c_interface_tl_cols_row(l_interface_cols_row.SEQUENCE_NUM , userenv('LANG'));

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

1492: -- Insert the required row in BNE_INTERFACE_COLS_TL only if P_LANGUAGE is populated
1493:
1494: OPEN c_interface_tl_cols_row(l_interface_cols_row.SEQUENCE_NUM , userenv('LANG'));
1495: FETCH c_interface_tl_cols_row into l_interface_tl_cols_row;
1496: hr_utility.set_location(l_interface_tl_cols_row.sequence_num, 80);
1497: IF c_interface_tl_cols_row%NOTFOUND THEN
1498: RAISE no_default_layout;
1499: END IF;
1500: CLOSE c_interface_tl_cols_row;

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

1534: ,l_interface_cols_row.CREATED_BY
1535: ,SYSDATE
1536: ,l_interface_cols_row.CREATED_BY
1537: ,SYSDATE);
1538: hr_utility.set_location('TL Records succes', 81);
1539:
1540:
1541: END LOOP;
1542: CLOSE c_interface_cols_row;

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

1540:
1541: END LOOP;
1542: CLOSE c_interface_cols_row;
1543: END IF;
1544: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
1545:
1546: END Create_RIW_Interface_Col_Rows;
1547:
1548:

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

1584: no_default_layout EXCEPTION;
1585: l_proc_name VARCHAR2(72) := g_package||'Create_RIW_Layout_Row';
1586:
1587: BEGIN
1588: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1589:
1590: OPEN c_layout_row;
1591: FETCH c_layout_row INTO l_layout_row;
1592: IF c_layout_row%NOTFOUND THEN

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

1615: ,x_last_updated_by => l_layout_row.last_updated_by
1616: ,x_last_update_login => l_layout_row.last_update_login
1617: ,x_create_doc_list_app_id => l_layout_row.create_doc_list_app_id
1618: ,x_create_doc_list_code => l_layout_row.create_doc_list_code);
1619: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
1620:
1621: END Create_RIW_Layout_Row;
1622:
1623:

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

1681: l_seg_column_xml_data VARCHAR2(150);
1682: l_proc_name VARCHAR2(72) := g_package||'Create_RIW_OAF_Function';
1683:
1684: BEGIN
1685: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1686:
1687: IF p_action_type = 'Update' THEN
1688: SELECT fff.function_name into l_function_name
1689: FROM fnd_form_functions fff, fnd_form_functions_tl ffft

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

1859: ,l_function_row.CREATED_BY
1860: ,1);
1861: END IF;
1862:
1863: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
1864:
1865: END Create_RIW_OAF_Function;
1866:
1867:

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

1883: l_ENTRY_SEQUENCE NUMBER := 0;
1884: l_proc_name VARCHAR2(72) := g_package||'Create_RIW_Menu_Entries';
1885:
1886: BEGIN
1887: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1888:
1889: SELECT function_id
1890: INTO l_fun_id
1891: FROM fnd_form_functions

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

1910: ,X_LAST_UPDATE_DATE => sysdate
1911: ,X_LAST_UPDATED_BY => 1
1912: ,X_LAST_UPDATE_LOGIN => 0);
1913:
1914: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
1915: END Create_RIW_Menu_Entries;
1916:
1917:
1918:

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

2015: WHERE APPLICATION_ID = P_APPLICATION_ID
2016: AND INTERFACE_CODE = p_INTERFACE_CODE; */
2017: EXCEPTION
2018: WHEN OTHERS THEN
2019: hr_utility.set_location('ERROR occured',30);
2020: Null;
2021: END Delete_riw_integrator;
2022:
2023:

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

2064: VV_INTEGRATOR_CODE BNE_INTEGRATORS_B.INTEGRATOR_CODE%TYPE;
2065: l_proc_name VARCHAR2(72) := g_package||'Create_RIW_Integrator_Row';
2066:
2067: BEGIN
2068: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2069: OPEN c_intg_row;
2070: FETCH c_intg_row INTO l_intg_row;
2071: IF c_intg_row%NOTFOUND THEN
2072: RAISE no_default_layout;

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

2168: P_SECURITY_TYPE =>'FUNCTION',
2169: P_SECURITY_VALUE =>'PQP_FLEXIBLE_WEBADI_CREATE_DOC',
2170: P_USER_ID =>1);
2171: END IF;
2172: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
2173:
2174: END Create_RIW_Integrator_Row;
2175:
2176:

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

2224: l_temp_val VARCHAR2(4000);
2225: l_proc_name VARCHAR2(72) := g_package||'Create_RIW_Content_Row';
2226:
2227: BEGIN
2228: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2229:
2230: OPEN c_content_row(c_base_content_code => p_base_content_code); --$ create non data pump content
2231: FETCH c_content_row INTO l_content_row;
2232: IF c_content_row%NOTFOUND THEN

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

2418: (l_ce_content_out) and sequence_num = 270;
2419:
2420:
2421: --------
2422: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
2423:
2424: END Create_RIW_Content_Row;
2425:
2426: -- =============================================================================

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

2533: l_read_only_flag varchar2(3);
2534: l_sequence_num number(5);
2535:
2536: BEGIN
2537: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2538:
2539: OPEN c_content_row(c_base_content_code => p_base_content_code); --$ create non data pump content
2540: FETCH c_content_row INTO l_content_row;
2541: IF c_content_row%NOTFOUND THEN

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

2556: l_first := false;
2557: END LOOP;
2558: CLOSE c_content_cols_row;
2559:
2560: hr_utility.set_location(l_temp_val, 44);
2561: BNE_CONTENT_UTILS.CREATE_CONTENT_DYNAMIC_SQL
2562: (P_APPLICATION_ID =>l_content_row.APPLICATION_ID
2563: ,P_OBJECT_CODE =>p_new_content_code
2564: ,P_INTEGRATOR_CODE =>p_intg_code

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

2569: ,P_SOURCE_LANGUAGE =>userenv('LANG')
2570: ,P_USER_ID =>1
2571: ,P_CONTENT_CODE =>l_content_out);
2572:
2573: hr_utility.set_location('The content got created sucessfully ' || l_content_out, 55);
2574:
2575: update bne_contents_b
2576: set param_list_code = l_content_row.param_list_code
2577: ,param_list_app_id = l_content_row.param_list_app_id

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

2587:
2588: END LOOP;
2589: CLOSE c_content_cols_row;
2590:
2591: hr_utility.set_location('The content got created sucessfully ' || l_content_out, 55);
2592: p_content_out := l_content_out;
2593:
2594: END Create_RIW_Content_Row_Others;
2595: --Added by sravikum

Line 2609: hr_utility.set_location('Entered the procedure Convert_Columns_Read_Only', 78);

2605: temp_content_ro_value VARCHAR2(5);
2606: temp_interface_seq_num NUMBER(3);
2607:
2608: BEGIN
2609: hr_utility.set_location('Entered the procedure Convert_Columns_Read_Only', 78);
2610: FOR l_interface_index IN g_temp_riw_data.FIRST..g_temp_riw_data.LAST
2611: LOOP
2612: temp_interface_seq_num := g_temp_riw_data(l_interface_index).interface_seq;
2613: temp_content_ro_value := g_temp_riw_data(l_interface_index).read_only;

Line 2615: hr_utility.set_location('temp_interface_seq_num: '||temp_interface_seq_num, 5);

2611: LOOP
2612: temp_interface_seq_num := g_temp_riw_data(l_interface_index).interface_seq;
2613: temp_content_ro_value := g_temp_riw_data(l_interface_index).read_only;
2614: temp_content_seq_num :=null;
2615: hr_utility.set_location('temp_interface_seq_num: '||temp_interface_seq_num, 5);
2616: hr_utility.set_location('temp_content_ro_value: '||temp_content_ro_value, 5);
2617: hr_utility.set_location('p_content_code: '||p_content_code, 5);
2618: hr_utility.set_location('p_interface_code: '||p_interface_code, 5);
2619: hr_utility.set_location('p_mapping_code: '||p_mapping_code, 5);

Line 2616: hr_utility.set_location('temp_content_ro_value: '||temp_content_ro_value, 5);

2612: temp_interface_seq_num := g_temp_riw_data(l_interface_index).interface_seq;
2613: temp_content_ro_value := g_temp_riw_data(l_interface_index).read_only;
2614: temp_content_seq_num :=null;
2615: hr_utility.set_location('temp_interface_seq_num: '||temp_interface_seq_num, 5);
2616: hr_utility.set_location('temp_content_ro_value: '||temp_content_ro_value, 5);
2617: hr_utility.set_location('p_content_code: '||p_content_code, 5);
2618: hr_utility.set_location('p_interface_code: '||p_interface_code, 5);
2619: hr_utility.set_location('p_mapping_code: '||p_mapping_code, 5);
2620: begin

Line 2617: hr_utility.set_location('p_content_code: '||p_content_code, 5);

2613: temp_content_ro_value := g_temp_riw_data(l_interface_index).read_only;
2614: temp_content_seq_num :=null;
2615: hr_utility.set_location('temp_interface_seq_num: '||temp_interface_seq_num, 5);
2616: hr_utility.set_location('temp_content_ro_value: '||temp_content_ro_value, 5);
2617: hr_utility.set_location('p_content_code: '||p_content_code, 5);
2618: hr_utility.set_location('p_interface_code: '||p_interface_code, 5);
2619: hr_utility.set_location('p_mapping_code: '||p_mapping_code, 5);
2620: begin
2621: select cont.sequence_num into temp_content_seq_num

Line 2618: hr_utility.set_location('p_interface_code: '||p_interface_code, 5);

2614: temp_content_seq_num :=null;
2615: hr_utility.set_location('temp_interface_seq_num: '||temp_interface_seq_num, 5);
2616: hr_utility.set_location('temp_content_ro_value: '||temp_content_ro_value, 5);
2617: hr_utility.set_location('p_content_code: '||p_content_code, 5);
2618: hr_utility.set_location('p_interface_code: '||p_interface_code, 5);
2619: hr_utility.set_location('p_mapping_code: '||p_mapping_code, 5);
2620: begin
2621: select cont.sequence_num into temp_content_seq_num
2622: from bne_content_cols_b cont,

Line 2619: hr_utility.set_location('p_mapping_code: '||p_mapping_code, 5);

2615: hr_utility.set_location('temp_interface_seq_num: '||temp_interface_seq_num, 5);
2616: hr_utility.set_location('temp_content_ro_value: '||temp_content_ro_value, 5);
2617: hr_utility.set_location('p_content_code: '||p_content_code, 5);
2618: hr_utility.set_location('p_interface_code: '||p_interface_code, 5);
2619: hr_utility.set_location('p_mapping_code: '||p_mapping_code, 5);
2620: begin
2621: select cont.sequence_num into temp_content_seq_num
2622: from bne_content_cols_b cont,
2623: bne_interface_cols_b intf,

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

2741: l_func_type VARCHAR2(50);
2742: l_search VARCHAR2(10);
2743: l_security_func_name VARCHAR2(100);
2744: BEGIN
2745: --Hr_Utility.trace_on(null,'RI_Trace');
2746: hr_utility.set_location('Entering: '||l_proc_name, 5);
2747: hr_utility.set_location('The flag is ' ||p_ins_upd_datapmp_flag, 6);
2748: hr_utility.set_location(p_seq_params || ' First', 10);
2749: hr_utility.set_location(p_intrfce_seq_params || ' Second', 15);

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

2742: l_search VARCHAR2(10);
2743: l_security_func_name VARCHAR2(100);
2744: BEGIN
2745: --Hr_Utility.trace_on(null,'RI_Trace');
2746: hr_utility.set_location('Entering: '||l_proc_name, 5);
2747: hr_utility.set_location('The flag is ' ||p_ins_upd_datapmp_flag, 6);
2748: hr_utility.set_location(p_seq_params || ' First', 10);
2749: hr_utility.set_location(p_intrfce_seq_params || ' Second', 15);
2750: -- hr_utility.set_location(p_xml_tag_params || ' Third', 10);

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

2743: l_security_func_name VARCHAR2(100);
2744: BEGIN
2745: --Hr_Utility.trace_on(null,'RI_Trace');
2746: hr_utility.set_location('Entering: '||l_proc_name, 5);
2747: hr_utility.set_location('The flag is ' ||p_ins_upd_datapmp_flag, 6);
2748: hr_utility.set_location(p_seq_params || ' First', 10);
2749: hr_utility.set_location(p_intrfce_seq_params || ' Second', 15);
2750: -- hr_utility.set_location(p_xml_tag_params || ' Third', 10);
2751: hr_utility.set_location(p_defalut_type_params || ' Fourth', 10);

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

2744: BEGIN
2745: --Hr_Utility.trace_on(null,'RI_Trace');
2746: hr_utility.set_location('Entering: '||l_proc_name, 5);
2747: hr_utility.set_location('The flag is ' ||p_ins_upd_datapmp_flag, 6);
2748: hr_utility.set_location(p_seq_params || ' First', 10);
2749: hr_utility.set_location(p_intrfce_seq_params || ' Second', 15);
2750: -- hr_utility.set_location(p_xml_tag_params || ' Third', 10);
2751: hr_utility.set_location(p_defalut_type_params || ' Fourth', 10);
2752: -- hr_utility.set_location(p_defalut_value_params || ' Fifth', 10);

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

2745: --Hr_Utility.trace_on(null,'RI_Trace');
2746: hr_utility.set_location('Entering: '||l_proc_name, 5);
2747: hr_utility.set_location('The flag is ' ||p_ins_upd_datapmp_flag, 6);
2748: hr_utility.set_location(p_seq_params || ' First', 10);
2749: hr_utility.set_location(p_intrfce_seq_params || ' Second', 15);
2750: -- hr_utility.set_location(p_xml_tag_params || ' Third', 10);
2751: hr_utility.set_location(p_defalut_type_params || ' Fourth', 10);
2752: -- hr_utility.set_location(p_defalut_value_params || ' Fifth', 10);
2753: hr_utility.set_location(p_placement_params || ' Sixth', 10);

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

2746: hr_utility.set_location('Entering: '||l_proc_name, 5);
2747: hr_utility.set_location('The flag is ' ||p_ins_upd_datapmp_flag, 6);
2748: hr_utility.set_location(p_seq_params || ' First', 10);
2749: hr_utility.set_location(p_intrfce_seq_params || ' Second', 15);
2750: -- hr_utility.set_location(p_xml_tag_params || ' Third', 10);
2751: hr_utility.set_location(p_defalut_type_params || ' Fourth', 10);
2752: -- hr_utility.set_location(p_defalut_value_params || ' Fifth', 10);
2753: hr_utility.set_location(p_placement_params || ' Sixth', 10);
2754: -- get next seq value : INTERFACE_SEQ

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

2747: hr_utility.set_location('The flag is ' ||p_ins_upd_datapmp_flag, 6);
2748: hr_utility.set_location(p_seq_params || ' First', 10);
2749: hr_utility.set_location(p_intrfce_seq_params || ' Second', 15);
2750: -- hr_utility.set_location(p_xml_tag_params || ' Third', 10);
2751: hr_utility.set_location(p_defalut_type_params || ' Fourth', 10);
2752: -- hr_utility.set_location(p_defalut_value_params || ' Fifth', 10);
2753: hr_utility.set_location(p_placement_params || ' Sixth', 10);
2754: -- get next seq value : INTERFACE_SEQ
2755: hr_utility.set_location(p_entity_name, 15);

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

2748: hr_utility.set_location(p_seq_params || ' First', 10);
2749: hr_utility.set_location(p_intrfce_seq_params || ' Second', 15);
2750: -- hr_utility.set_location(p_xml_tag_params || ' Third', 10);
2751: hr_utility.set_location(p_defalut_type_params || ' Fourth', 10);
2752: -- hr_utility.set_location(p_defalut_value_params || ' Fifth', 10);
2753: hr_utility.set_location(p_placement_params || ' Sixth', 10);
2754: -- get next seq value : INTERFACE_SEQ
2755: hr_utility.set_location(p_entity_name, 15);
2756:

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

2749: hr_utility.set_location(p_intrfce_seq_params || ' Second', 15);
2750: -- hr_utility.set_location(p_xml_tag_params || ' Third', 10);
2751: hr_utility.set_location(p_defalut_type_params || ' Fourth', 10);
2752: -- hr_utility.set_location(p_defalut_value_params || ' Fifth', 10);
2753: hr_utility.set_location(p_placement_params || ' Sixth', 10);
2754: -- get next seq value : INTERFACE_SEQ
2755: hr_utility.set_location(p_entity_name, 15);
2756:
2757: BEGIN

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

2751: hr_utility.set_location(p_defalut_type_params || ' Fourth', 10);
2752: -- hr_utility.set_location(p_defalut_value_params || ' Fifth', 10);
2753: hr_utility.set_location(p_placement_params || ' Sixth', 10);
2754: -- get next seq value : INTERFACE_SEQ
2755: hr_utility.set_location(p_entity_name, 15);
2756:
2757: BEGIN
2758: SELECT description into l_func_type
2759: FROM pqp_flxdu_columns WHERE

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

2767: l_search := SUBSTR(l_func_type, 11, 1);
2768: ELSE
2769: l_search := 'T';
2770: END IF;
2771: hr_utility.set_location('The search Value is ' || l_search, 99);
2772:
2773: SELECT PQP_FLXDU_FUNCTIONS_S.nextval
2774: INTO l_riw_seq_id
2775: FROM dual;

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

2858: l_flag1 := l_ins_upd_datapmp_flag;
2859: l_allow_insert_loc := INSTR(l_ins_upd_datapmp_flag, ':');
2860: l_allow_insert := SUBSTR(l_ins_upd_datapmp_flag, 1, l_allow_insert_loc-1);
2861: l_flag1 := SUBSTR(l_ins_upd_datapmp_flag, l_allow_insert_loc+1, LENGTH(l_ins_upd_datapmp_flag));
2862: hr_utility.set_location('Allow First Is '|| l_ins_upd_datapmp_flag, 5);
2863: l_migration_flag_loc := INSTR(l_flag1, ':');
2864: hr_utility.set_location('Allow Second Is '|| l_migration_flag_loc, 6);
2865: l_migration_flag := SUBSTR(l_flag1, 3);
2866: g_migration_flag := l_migration_flag;

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

2860: l_allow_insert := SUBSTR(l_ins_upd_datapmp_flag, 1, l_allow_insert_loc-1);
2861: l_flag1 := SUBSTR(l_ins_upd_datapmp_flag, l_allow_insert_loc+1, LENGTH(l_ins_upd_datapmp_flag));
2862: hr_utility.set_location('Allow First Is '|| l_ins_upd_datapmp_flag, 5);
2863: l_migration_flag_loc := INSTR(l_flag1, ':');
2864: hr_utility.set_location('Allow Second Is '|| l_migration_flag_loc, 6);
2865: l_migration_flag := SUBSTR(l_flag1, 3);
2866: g_migration_flag := l_migration_flag;
2867: hr_utility.set_location('Allow Third Is '|| l_migration_flag, 6);
2868: hr_utility.set_location('Allow Insert Is '|| l_allow_insert, 7);

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

2863: l_migration_flag_loc := INSTR(l_flag1, ':');
2864: hr_utility.set_location('Allow Second Is '|| l_migration_flag_loc, 6);
2865: l_migration_flag := SUBSTR(l_flag1, 3);
2866: g_migration_flag := l_migration_flag;
2867: hr_utility.set_location('Allow Third Is '|| l_migration_flag, 6);
2868: hr_utility.set_location('Allow Insert Is '|| l_allow_insert, 7);
2869: hr_utility.set_location('Allow Migration Is '|| l_migration_flag, 8);
2870: IF l_allow_insert = 'Create' THEN
2871: g_ins_upd_flag := 'C';

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

2864: hr_utility.set_location('Allow Second Is '|| l_migration_flag_loc, 6);
2865: l_migration_flag := SUBSTR(l_flag1, 3);
2866: g_migration_flag := l_migration_flag;
2867: hr_utility.set_location('Allow Third Is '|| l_migration_flag, 6);
2868: hr_utility.set_location('Allow Insert Is '|| l_allow_insert, 7);
2869: hr_utility.set_location('Allow Migration Is '|| l_migration_flag, 8);
2870: IF l_allow_insert = 'Create' THEN
2871: g_ins_upd_flag := 'C';
2872: IF p_entity_name is NULL THEN

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

2865: l_migration_flag := SUBSTR(l_flag1, 3);
2866: g_migration_flag := l_migration_flag;
2867: hr_utility.set_location('Allow Third Is '|| l_migration_flag, 6);
2868: hr_utility.set_location('Allow Insert Is '|| l_allow_insert, 7);
2869: hr_utility.set_location('Allow Migration Is '|| l_migration_flag, 8);
2870: IF l_allow_insert = 'Create' THEN
2871: g_ins_upd_flag := 'C';
2872: IF p_entity_name is NULL THEN
2873: g_ins_upd_flag := g_ins_upd_flag||':'||l_migration_flag;

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

2902: g_ins_upd_flag := g_ins_upd_flag||':'||l_new_intrfc_code;
2903: END IF;
2904: END IF;
2905: END IF;
2906: hr_utility.set_location('Allow Insert Is '|| g_ins_upd_flag, 7);
2907:
2908: hr_utility.set_location('Before PL/SQL Records', 5);
2909: LOOP
2910: l_sq_location := INSTR(l_seq_params, '+');

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

2904: END IF;
2905: END IF;
2906: hr_utility.set_location('Allow Insert Is '|| g_ins_upd_flag, 7);
2907:
2908: hr_utility.set_location('Before PL/SQL Records', 5);
2909: LOOP
2910: l_sq_location := INSTR(l_seq_params, '+');
2911: l_inter_location := INSTR(l_intrfce_seq_params, '+');
2912: l_type_location := INSTR(l_defalut_type_params, '+');

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

2991:
2992: EXIT WHEN l_sq_location = 0;
2993: END LOOP;
2994:
2995: hr_utility.set_location('Before Calling functions', 5);
2996: IF p_action_type ='Update' THEN
2997: hr_utility.trace('Inside Update:');
2998: Delete_riw_integrator
2999: (p_LAYOUT_CODE => p_upd_layout_code

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

2993: END LOOP;
2994:
2995: hr_utility.set_location('Before Calling functions', 5);
2996: IF p_action_type ='Update' THEN
2997: hr_utility.trace('Inside Update:');
2998: Delete_riw_integrator
2999: (p_LAYOUT_CODE => p_upd_layout_code
3000: ,p_MAPPING_CODE => p_upd_mapping_code
3001: ,p_INTERFACE_CODE => p_upd_interface_code

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

3058: ,p_intg_code =>l_new_intg_code
3059: ,p_content_name =>p_user_function_name
3060: ,p_entity_name =>l_entity_name
3061: ,p_content_out =>l_out_content_code);
3062: hr_utility.set_location('Outside the call ' || l_out_content_code, 76);
3063: END IF;
3064: END IF;
3065:
3066:

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

3096: (p_application_id => p_application_id
3097: ,p_new_layout_code => l_new_layout_code
3098: ,p_base_layout_code => l_base_layout_code
3099: ,p_user_name => p_user_function_name);
3100: hr_utility.set_location('Executed block API', 50);
3101: Create_RIW_Layout_Cols_Row
3102: (p_application_id => p_application_id
3103: ,p_new_layout_code => l_new_layout_code
3104: ,p_base_layout_code => l_base_layout_code

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

3142: ,p_data_source => p_data_source
3143: ,p_new_intg_code => l_new_intg_code
3144: ,p_entity_name => l_entity_name);
3145:
3146: hr_utility.set_location(l_out_content_code, 56);
3147: Create_RIW_Mapping_Links_Rows
3148: (p_application_id => p_application_id
3149: ,p_new_mapping_code => l_new_mapping_code
3150: ,p_new_interface_code => l_new_intrfc_code

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

3286: END IF;
3287: g_temp_riw_data.DELETE;
3288: g_riw_data.DELETE;
3289: p_return_status := 'Y';
3290: hr_utility.set_location('Leaving: '||l_proc_name, 5);
3291:
3292: Create_Derived_Param_List(p_application_id => p_application_id
3293: ,p_param_list_code => l_derived_param_list_code
3294: ,p_parameter_value => l_ins_upd_datapmp_flag);

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

3293: ,p_param_list_code => l_derived_param_list_code
3294: ,p_parameter_value => l_ins_upd_datapmp_flag);
3295: Exception
3296: when others then
3297: hr_utility.set_location('Error: '||l_proc_name, 5);
3298: g_temp_riw_data.DELETE;
3299: g_riw_data.DELETE;
3300: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 100);
3301: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 101);

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

3296: when others then
3297: hr_utility.set_location('Error: '||l_proc_name, 5);
3298: g_temp_riw_data.DELETE;
3299: g_riw_data.DELETE;
3300: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 100);
3301: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 101);
3302: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 102);
3303: p_return_status := 'E';
3304: END Create_RIW_Webadi_Setup;

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

3297: hr_utility.set_location('Error: '||l_proc_name, 5);
3298: g_temp_riw_data.DELETE;
3299: g_riw_data.DELETE;
3300: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 100);
3301: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 101);
3302: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 102);
3303: p_return_status := 'E';
3304: END Create_RIW_Webadi_Setup;
3305:

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

3298: g_temp_riw_data.DELETE;
3299: g_riw_data.DELETE;
3300: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 100);
3301: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 101);
3302: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 102);
3303: p_return_status := 'E';
3304: END Create_RIW_Webadi_Setup;
3305:
3306:

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

3336: --$
3337: l_intf_code VARCHAR2(30);
3338:
3339: BEGIN
3340: -- hr_utility.trace_on(null,'TTT');
3341: -- get the count of function_id from fnd_menu_entries
3342: SELECT count(function_id)
3343: INTO l_count
3344: FROM fnd_menu_entries

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

3383: FND_FORM_FUNCTIONS_PKG.DELETE_ROW(
3384: X_FUNCTION_ID => p_function_id);
3385:
3386:
3387: hr_utility.trace('DELETE: INTERFACE='|| l_intf_code);
3388:
3389: if l_intf_code IS NOT NULL then
3390: Delete_riw_integrator(p_INTERFACE_CODE => l_intf_code
3391: ,p_application_id => 8303 );

Line 3612: Hr_Utility.raise_error;

3608: -- If Delimiter is not found then that means the passed DFF doesn't exist for
3609: -- the passed application id. Raise an Error
3610: IF csr_get_delimiter_and_context%NOTFOUND THEN
3611: CLOSE csr_get_delimiter_and_context;
3612: Hr_Utility.raise_error;
3613: END IF;
3614: CLOSE csr_get_delimiter_and_context;
3615:
3616: l_delimiter := r_delim_ctx_rec.con_seg_delim;

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

3641:
3642: --IF condition added by pkagrawa to check for non global data context
3643: IF p_context <> 'Global Data Elements' THEN
3644:
3645: hr_utility.trace('Inside non global condition');
3646:
3647: --$3
3648: l_segment_count := l_segment_count +1; -- keeping no of delimiters and segments in sync
3649:

Line 3696: hr_utility.trace('p_table_name '||p_table_name);

3692: ' WHERE address_id = :p_entity_id';
3693: END IF;
3694:
3695: IF p_table_name is not null AND p_column is not null THEN
3696: hr_utility.trace('p_table_name '||p_table_name);
3697: hr_utility.trace('p_column '||p_column);
3698: l_dyn_sql_qry := ' SELECT ' || l_segment_list ||
3699: ' FROM ' || p_table_name ||
3700: ' where ' || p_column || ' = :p_entity_id';

Line 3697: hr_utility.trace('p_column '||p_column);

3693: END IF;
3694:
3695: IF p_table_name is not null AND p_column is not null THEN
3696: hr_utility.trace('p_table_name '||p_table_name);
3697: hr_utility.trace('p_column '||p_column);
3698: l_dyn_sql_qry := ' SELECT ' || l_segment_list ||
3699: ' FROM ' || p_table_name ||
3700: ' where ' || p_column || ' = :p_entity_id';
3701: hr_utility.trace('Reaching here');

Line 3701: hr_utility.trace('Reaching here');

3697: hr_utility.trace('p_column '||p_column);
3698: l_dyn_sql_qry := ' SELECT ' || l_segment_list ||
3699: ' FROM ' || p_table_name ||
3700: ' where ' || p_column || ' = :p_entity_id';
3701: hr_utility.trace('Reaching here');
3702: --create_log(l_dyn_sql_qry);
3703: END IF;
3704:
3705: IF p_entity = 'PERSON' OR p_entity = 'ASSIGNMENT' THEN

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

3727: RETURN l_concat_segments;
3728:
3729: Exception
3730: when others then
3731: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 100);
3732: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 101);
3733: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 102);
3734:
3735: END Get_Concatanated_DFF_Segments;

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

3728:
3729: Exception
3730: when others then
3731: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 100);
3732: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 101);
3733: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 102);
3734:
3735: END Get_Concatanated_DFF_Segments;
3736:

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

3729: Exception
3730: when others then
3731: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,1,50), 100);
3732: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,51,100), 101);
3733: hr_utility.set_location('sqlerrm:'||substr(sqlerrm,101,150), 102);
3734:
3735: END Get_Concatanated_DFF_Segments;
3736:
3737: