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

Line 140: hr_utility.set_location('Now Entering:'||l_proc, 5);

136: select ghr_pd_wf_item_key_s.nextval
137: from dual;
138:
139: BEGIN
140: hr_utility.set_location('Now Entering:'||l_proc, 5);
141: -- Issue a savepoint if operating in validation only mode.
142: --IF p_validate THEN
143: SAVEPOINT create_pdi;
144: --END IF;

Line 214: hr_utility.set_location(l_proc,6);

210: --
211: -- End of Before Process User Hook call
212: --
213: --
214: hr_utility.set_location(l_proc,6);
215: -- Validation in Addition to Row Handlers: There is no additional validation
216: -- Process Logic: The process logic is to call the row handlers to insert the information into
217: -- GHR_POSITION_DESCRIPTIONS and GHR_PD_CLASSIFICATIONS.
218: -- 1)First insert a row into GHR_POSITION_DESCRIPTIONS table.

Line 272: hr_utility.set_location('after pdi_ins.ins' ,6);

268: p_object_version_number => l_pdi_object_version_number
269: );
270: p_pdi_object_version_number := l_pdi_object_version_number;
271: p_position_description_id := l_position_description_id;
272: hr_utility.set_location('after pdi_ins.ins' ,6);
273: --insert_messages(2,l_position_description_id,l_proc);
274: --
275: --------------------------------------------------------------------------------------
276: -- Inserted by Dinkar. Karumuri for routing and Workflow on 05-AUG-1997

Line 301: hr_utility.set_message(8301,'GHR_38111_USER_NAME_REQD');

297: l_user_name_emp_middle_names := user_emp_names.middle_names;
298: exit;
299: end loop;
300: else
301: hr_utility.set_message(8301,'GHR_38111_USER_NAME_REQD');
302: hr_utility.raise_error;
303:
304: end if; -- End if for User Acted On condn.
305: l_action_taken := p_1_action_taken;

Line 302: hr_utility.raise_error;

298: exit;
299: end loop;
300: else
301: hr_utility.set_message(8301,'GHR_38111_USER_NAME_REQD');
302: hr_utility.raise_error;
303:
304: end if; -- End if for User Acted On condn.
305: l_action_taken := p_1_action_taken;
306: if l_action_taken is null then

Line 309: hr_utility.set_location('before invalid condition',10);

305: l_action_taken := p_1_action_taken;
306: if l_action_taken is null then
307: l_action_taken := 'NO_ACTION';
308: end if;
309: hr_utility.set_location('before invalid condition',10);
310:
311: if l_action_taken not in ('NOT_ROUTED','INITIATED','AUTHORIZED',
312: 'NO_ACTION','REVIEWED','CANCELED','CLASSIFIED',
313: 'REQUESTED')

Line 316: hr_utility.set_message(8301,'GHR_38110_INVALID_ACTION_TAKEN');

312: 'NO_ACTION','REVIEWED','CANCELED','CLASSIFIED',
313: 'REQUESTED')
314: then
315:
316: hr_utility.set_message(8301,'GHR_38110_INVALID_ACTION_TAKEN');
317: hr_utility.raise_error;
318: end if;
319: -- to check if there is any routing information, if required.
320: if l_action_taken not in ('CANCELED','CLASSIFIED','NOT_ROUTED') then

Line 317: hr_utility.raise_error;

313: 'REQUESTED')
314: then
315:
316: hr_utility.set_message(8301,'GHR_38110_INVALID_ACTION_TAKEN');
317: hr_utility.raise_error;
318: end if;
319: -- to check if there is any routing information, if required.
320: if l_action_taken not in ('CANCELED','CLASSIFIED','NOT_ROUTED') then
321: if p_2_user_name_routed_to is null and

Line 324: hr_utility.set_message(8301,'GHR_38280_NO_ROUTING_INFO');

320: if l_action_taken not in ('CANCELED','CLASSIFIED','NOT_ROUTED') then
321: if p_2_user_name_routed_to is null and
322: p_2_groupbox_id is null and
323: p_2_routing_list_id is null then
324: hr_utility.set_message(8301,'GHR_38280_NO_ROUTING_INFO');
325: hr_utility.raise_error;
326: end if;
327: end if;
328: hr_utility.set_location('before getting item key'||l_action_taken,10);

Line 325: hr_utility.raise_error;

321: if p_2_user_name_routed_to is null and
322: p_2_groupbox_id is null and
323: p_2_routing_list_id is null then
324: hr_utility.set_message(8301,'GHR_38280_NO_ROUTING_INFO');
325: hr_utility.raise_error;
326: end if;
327: end if;
328: hr_utility.set_location('before getting item key'||l_action_taken,10);
329: if nvl(l_action_taken,hr_api.g_varchar2) in

Line 328: hr_utility.set_location('before getting item key'||l_action_taken,10);

324: hr_utility.set_message(8301,'GHR_38280_NO_ROUTING_INFO');
325: hr_utility.raise_error;
326: end if;
327: end if;
328: hr_utility.set_location('before getting item key'||l_action_taken,10);
329: if nvl(l_action_taken,hr_api.g_varchar2) in
330: ('NOT_ROUTED','INITIATED','CLASSIFIED','AUTHORIZED','REQUESTED')
331: then
332:

Line 337: hr_utility.set_message(8301,'GHR_38625_NO_WF_ITEM_KEY_SEQ');

333: OPEN c_item_key_seq;
334: FETCH c_item_key_seq INTO l_item_key;
335: IF c_item_key_seq%NOTFOUND THEN
336:
337: hr_utility.set_message(8301,'GHR_38625_NO_WF_ITEM_KEY_SEQ');
338: hr_utility.raise_error;
339: END IF;
340: CLOSE c_item_key_seq;
341: end if;

Line 338: hr_utility.raise_error;

334: FETCH c_item_key_seq INTO l_item_key;
335: IF c_item_key_seq%NOTFOUND THEN
336:
337: hr_utility.set_message(8301,'GHR_38625_NO_WF_ITEM_KEY_SEQ');
338: hr_utility.raise_error;
339: END IF;
340: CLOSE c_item_key_seq;
341: end if;
342:

Line 347: hr_utility.set_location('after not in cancled',10);

343: --insert_messages(5,l_position_description_id,'after item_key_seq');
344: -- write the first record into the routing history (actions done by the user)
345: if nvl(l_action_taken,hr_api.g_varchar2) not in
346: ('CANCELED') then
347: hr_utility.set_location('after not in cancled',10);
348: ghr_pdh_ins.ins
349: (
350: p_pd_routing_history_id => p_1_pd_routing_history_id,
351: p_position_description_id => l_position_description_id,

Line 373: hr_utility.set_location('in the 2nd row',10);

369: );
370: -- Insert 2nd record into routing_history for routing details
371: -- (exception when routing_status = 'NOT_ROUTED' )
372: if nvl(l_action_taken,hr_api.g_varchar2) not in ('CLASSIFIED','NOT_ROUTED') then
373: hr_utility.set_location('in the 2nd row',10);
374: l_2_routing_seq_number := p_2_routing_seq_number;
375: l_2_groupbox_id := p_2_groupbox_id;
376: l_2_user_name := p_2_user_name_routed_to;
377: -- derive the next sequence number for the speicific routing list if seq. number is not passed in

Line 386: hr_utility.set_message(8301,'GHR_38114_NO_MORE_SEQ_NUMBER' );

382: l_2_user_name := rout_seq_numb.user_name;
383: exit;
384: end loop;
385: if l_2_routing_seq_number is null then
386: hr_utility.set_message(8301,'GHR_38114_NO_MORE_SEQ_NUMBER' );
387: hr_utility.raise_error;
388: end if;
389: end if;
390:

Line 387: hr_utility.raise_error;

383: exit;
384: end loop;
385: if l_2_routing_seq_number is null then
386: hr_utility.set_message(8301,'GHR_38114_NO_MORE_SEQ_NUMBER' );
387: hr_utility.raise_error;
388: end if;
389: end if;
390:
391: -- vravikan - Getting the next sequence number for workflow routing

Line 417: hr_utility.set_message(8301,'GHR_38112_INVALID_API');

413: p_validate => false
414: );
415: end if;
416: else
417: hr_utility.set_message(8301,'GHR_38112_INVALID_API');
418: hr_utility.raise_error;
419: end if;
420: -----------------------------------------------------------------------------------
421: --- When in validation only mode raise the Validate_Enabled_Exception

Line 418: hr_utility.raise_error;

414: );
415: end if;
416: else
417: hr_utility.set_message(8301,'GHR_38112_INVALID_API');
418: hr_utility.raise_error;
419: end if;
420: -----------------------------------------------------------------------------------
421: --- When in validation only mode raise the Validate_Enabled_Exception
422:

Line 506: hr_utility.set_location ('Leaving:'|| l_proc,11);

502: -- Set All output Arguments
503: --
504: p_position_description_id := l_position_description_id;
505: p_pdi_object_version_number := l_pdi_object_version_number;
506: hr_utility.set_location ('Leaving:'|| l_proc,11);
507: EXCEPTION
508:
509: WHEN hr_api.validate_enabled THEN
510: -- As the validation exception has been raised

Line 538: hr_utility.set_location('Leaving:' || l_proc,12);

534: p_pdi_object_version_number := NULL;
535:
536: raise;
537: --
538: hr_utility.set_location('Leaving:' || l_proc,12);
539: END create_pdi;
540: ----------------------------|------------< Update_pdi >------------|--------------------------------
541:
542: PROCEDURE update_pdi

Line 728: hr_utility.set_location('Entering'||l_proc,5);

724: Cursor c_item_key_seq is
725: select ghr_pd_wf_item_key_s.nextval
726: from dual;
727: BEGIN
728: hr_utility.set_location('Entering'||l_proc,5);
729: --
730: -- Issue a savepoint if operating in validation mode.
731: --
732: --IF p_validate THEN

Line 813: hr_utility.set_location(l_proc,6);

809: end;
810: --
811: -- End of Before Process User Hook call
812: --
813: hr_utility.set_location(l_proc,6);
814: --
815: -- Validation in addition to row handlers.
816: --
817: -- To Update the ghr_position_descriptions table. we need the primary key.

Line 819: hr_utility.set_message(8301, 'GHR_PD_ID_PRIMARY_KEY_INVALID');

815: -- Validation in addition to row handlers.
816: --
817: -- To Update the ghr_position_descriptions table. we need the primary key.
818: IF p_position_description_id is null then
819: hr_utility.set_message(8301, 'GHR_PD_ID_PRIMARY_KEY_INVALID');
820: hr_utility.raise_error;
821: end if;
822: -- Process Logic
823: -- Update the row in ghr_position_description by calling the update row handler.

Line 820: hr_utility.raise_error;

816: --
817: -- To Update the ghr_position_descriptions table. we need the primary key.
818: IF p_position_description_id is null then
819: hr_utility.set_message(8301, 'GHR_PD_ID_PRIMARY_KEY_INVALID');
820: hr_utility.raise_error;
821: end if;
822: -- Process Logic
823: -- Update the row in ghr_position_description by calling the update row handler.
824: -- Routing Group _Id can be changed only in a case where the request has been initiated

Line 838: hr_utility.set_message(8301,'GHR_38638_PD_ROUT_GRP_NON_UPD');

834: l_cnt_history := cnt_of_history.cnt;
835: exit;
836: end loop;
837: if nvl(l_cnt_history,0) > 1 then
838: hr_utility.set_message(8301,'GHR_38638_PD_ROUT_GRP_NON_UPD');
839: hr_utility.raise_error;
840: end if;
841: end if;
842: end if;

Line 839: hr_utility.raise_error;

835: exit;
836: end loop;
837: if nvl(l_cnt_history,0) > 1 then
838: hr_utility.set_message(8301,'GHR_38638_PD_ROUT_GRP_NON_UPD');
839: hr_utility.raise_error;
840: end if;
841: end if;
842: end if;
843: l_pdi_object_version_number := p_pdi_object_version_number;

Line 907: hr_utility.set_location('before open init',10);

903: l_action_taken := 'NO_ACTION';
904: end if;
905: -- To check if PD has already been initiated
906:
907: hr_utility.set_location('before open init',10);
908: OPEN c_pd_initiated;
909: FETCH c_pd_initiated INTO l_dummy;
910: IF c_pd_initiated%FOUND THEN
911: l_pd_initiated := TRUE;

Line 937: hr_utility.set_message(8301,'GHR_38110_INVALID_ACTION_TAKEN');

933: if l_action_taken not in('NOT_ROUTED','INITIATED','AUTHORIZED',
934: 'NO_ACTION','REVIEWED','CANCELED','REOPENED',
935: 'REQUESTED', 'RECLASSIFIED','CLASSIFIED')
936: then
937: hr_utility.set_message(8301,'GHR_38110_INVALID_ACTION_TAKEN');
938: hr_utility.raise_error;
939: end if;
940:
941: hr_utility.set_location('after invalid action',10);

Line 938: hr_utility.raise_error;

934: 'NO_ACTION','REVIEWED','CANCELED','REOPENED',
935: 'REQUESTED', 'RECLASSIFIED','CLASSIFIED')
936: then
937: hr_utility.set_message(8301,'GHR_38110_INVALID_ACTION_TAKEN');
938: hr_utility.raise_error;
939: end if;
940:
941: hr_utility.set_location('after invalid action',10);
942: if l_action_taken not in ('CANCELED','CLASSIFIED','RECLASSIFIED','NOT_ROUTED') then

Line 941: hr_utility.set_location('after invalid action',10);

937: hr_utility.set_message(8301,'GHR_38110_INVALID_ACTION_TAKEN');
938: hr_utility.raise_error;
939: end if;
940:
941: hr_utility.set_location('after invalid action',10);
942: if l_action_taken not in ('CANCELED','CLASSIFIED','RECLASSIFIED','NOT_ROUTED') then
943: if p_i_user_name_routed_to is null and
944: p_i_groupbox_id is null and
945: p_i_routing_list_id is null then

Line 946: hr_utility.set_message(8301,'GHR_38280_NO_ROUTING_INFO');

942: if l_action_taken not in ('CANCELED','CLASSIFIED','RECLASSIFIED','NOT_ROUTED') then
943: if p_i_user_name_routed_to is null and
944: p_i_groupbox_id is null and
945: p_i_routing_list_id is null then
946: hr_utility.set_message(8301,'GHR_38280_NO_ROUTING_INFO');
947: hr_utility.raise_error;
948: end if;
949: end if;
950:

Line 947: hr_utility.raise_error;

943: if p_i_user_name_routed_to is null and
944: p_i_groupbox_id is null and
945: p_i_routing_list_id is null then
946: hr_utility.set_message(8301,'GHR_38280_NO_ROUTING_INFO');
947: hr_utility.raise_error;
948: end if;
949: end if;
950:
951: -- For Direct Reclassification and getting the last_item_key in case NOT_ROUTED to INITIATED

Line 967: hr_utility.set_location('action taken is'||l_action_taken,10);

963: l_reclass_direct_flag := 'Y';
964: end if;
965: end if;
966:
967: hr_utility.set_location('action taken is'||l_action_taken,10);
968:
969: if l_action_taken in ('REOPENED') or l_reclass_direct_flag = 'Y' then
970: OPEN c_item_key_seq;
971: FETCH c_item_key_seq INTO l_item_key;

Line 974: hr_utility.set_message(8301,'GHR_38625_NO_WF_ITEM_KEY_SEQ');

970: OPEN c_item_key_seq;
971: FETCH c_item_key_seq INTO l_item_key;
972: IF c_item_key_seq%NOTFOUND THEN
973:
974: hr_utility.set_message(8301,'GHR_38625_NO_WF_ITEM_KEY_SEQ');
975: hr_utility.raise_error;
976: END IF;
977: CLOSE c_item_key_seq;
978: end if;

Line 975: hr_utility.raise_error;

971: FETCH c_item_key_seq INTO l_item_key;
972: IF c_item_key_seq%NOTFOUND THEN
973:
974: hr_utility.set_message(8301,'GHR_38625_NO_WF_ITEM_KEY_SEQ');
975: hr_utility.raise_error;
976: END IF;
977: CLOSE c_item_key_seq;
978: end if;
979:

Line 1006: hr_utility.set_message(8301,'GHR_38111_USER_NAME_REQD');

1002: l_user_name_emp_middle_names := name_rec.middle_names;
1003: exit;
1004: end loop;
1005: else
1006: hr_utility.set_message(8301,'GHR_38111_USER_NAME_REQD');
1007: hr_utility.raise_error;
1008: end if;
1009:
1010:

Line 1007: hr_utility.raise_error;

1003: exit;
1004: end loop;
1005: else
1006: hr_utility.set_message(8301,'GHR_38111_USER_NAME_REQD');
1007: hr_utility.raise_error;
1008: end if;
1009:
1010:
1011: -- Update the latest record in the routing history for the specific pd id

Line 1023: hr_utility.set_location('l_action taken is ' || l_action_taken,10);

1019: then
1020: if nvl(l_action_taken,hr_api.g_varchar2) not in ('CANCELED','RECLASSIFIED','CLASSIFIED')
1021: then
1022:
1023: hr_utility.set_location('l_action taken is ' || l_action_taken,10);
1024: hr_utility.set_location('l_reclass_direct is ' || l_reclass_direct_flag,10);
1025: if l_action_taken <> 'REOPENED' or
1026: ((l_action_taken = 'REOPENED') and (l_reclass_action_taken = 'NOT_ROUTED')) then
1027:

Line 1024: hr_utility.set_location('l_reclass_direct is ' || l_reclass_direct_flag,10);

1020: if nvl(l_action_taken,hr_api.g_varchar2) not in ('CANCELED','RECLASSIFIED','CLASSIFIED')
1021: then
1022:
1023: hr_utility.set_location('l_action taken is ' || l_action_taken,10);
1024: hr_utility.set_location('l_reclass_direct is ' || l_reclass_direct_flag,10);
1025: if l_action_taken <> 'REOPENED' or
1026: ((l_action_taken = 'REOPENED') and (l_reclass_action_taken = 'NOT_ROUTED')) then
1027:
1028: ghr_pdh_upd.upd

Line 1106: hr_utility.set_message(8301, 'GHR_38114_NO_MORE_SEQ_NUMBER');

1102: if l_next_groupbox_id is null then
1103: l_next_groupbox_id := p_i_groupbox_id;
1104: end if;
1105: if l_next_seq_numb is null then
1106: hr_utility.set_message(8301, 'GHR_38114_NO_MORE_SEQ_NUMBER');
1107: hr_utility.raise_error;
1108: end if;
1109: end if;
1110:

Line 1107: hr_utility.raise_error;

1103: l_next_groupbox_id := p_i_groupbox_id;
1104: end if;
1105: if l_next_seq_numb is null then
1106: hr_utility.set_message(8301, 'GHR_38114_NO_MORE_SEQ_NUMBER');
1107: hr_utility.raise_error;
1108: end if;
1109: end if;
1110:
1111:

Line 1142: hr_utility.set_location('l_action taken is ' || l_action_taken,10);

1138:
1139: IF l_action_taken IN ('CANCELED','RECLASSIFIED','CLASSIFIED')
1140: or (nvl(l_action_taken,hr_api.g_varchar2) in ('NOT_ROUTED') and l_reclass_direct_flag = 'Y' )
1141: then
1142: hr_utility.set_location('l_action taken is ' || l_action_taken,10);
1143: hr_utility.set_location('l_reclass_direct is ' || l_reclass_direct_flag,10);
1144: for cur_routing_history_id in C_routing_history_id loop
1145: l_u_pd_routing_history_id := cur_routing_history_id.pd_routing_history_id;
1146: l_u_pdh_object_version_number := cur_routing_history_id.object_version_number;

Line 1143: hr_utility.set_location('l_reclass_direct is ' || l_reclass_direct_flag,10);

1139: IF l_action_taken IN ('CANCELED','RECLASSIFIED','CLASSIFIED')
1140: or (nvl(l_action_taken,hr_api.g_varchar2) in ('NOT_ROUTED') and l_reclass_direct_flag = 'Y' )
1141: then
1142: hr_utility.set_location('l_action taken is ' || l_action_taken,10);
1143: hr_utility.set_location('l_reclass_direct is ' || l_reclass_direct_flag,10);
1144: for cur_routing_history_id in C_routing_history_id loop
1145: l_u_pd_routing_history_id := cur_routing_history_id.pd_routing_history_id;
1146: l_u_pdh_object_version_number := cur_routing_history_id.object_version_number;
1147: exit;

Line 1278: hr_utility.set_location('Leaving:'|| l_proc,11);

1274: IF p_validate THEN
1275: RAISE hr_api.validate_enabled;
1276: END IF;
1277: p_pdi_object_version_number := l_pdi_object_version_number;
1278: hr_utility.set_location('Leaving:'|| l_proc,11);
1279: EXCEPTION
1280: WHEN hr_api.validate_enabled THEN
1281: --
1282: -- As the Validate_Enabled exception has been raised

Line 1309: hr_utility.set_location('Leaving:'||l_proc,12);

1305: p_o_pdh_object_version_number := null;
1306: p_pdi_object_version_number := l_initial_pdi_ovn;
1307:
1308: raise;
1309: hr_utility.set_location('Leaving:'||l_proc,12);
1310: END update_pdi;
1311:
1312: procedure call_workflow
1313: (

Line 1385: hr_utility.set_location('Now Entering:'||l_proc, 5);

1381: and action_taken in ( 'INITIATED','AUTHORIZED','REQUESTED','CLASSIFIED');
1382:
1383: begin
1384:
1385: hr_utility.set_location('Now Entering:'||l_proc, 5);
1386: -- Get the Routing history Count
1387: FOR cnt_history in c_cnt_history LOOP
1388: l_cnt_history := cnt_history.cnt;
1389: END LOOP;

Line 1390: hr_utility.set_location('after count history: #'||to_char(l_cnt_history), 5);

1386: -- Get the Routing history Count
1387: FOR cnt_history in c_cnt_history LOOP
1388: l_cnt_history := cnt_history.cnt;
1389: END LOOP;
1390: hr_utility.set_location('after count history: #'||to_char(l_cnt_history), 5);
1391: hr_utility.set_location('action taken is '||p_action_taken, 5);
1392: -- Get the last two action takens
1393: if l_cnt_history > 0 then
1394: open c_routing_history_id;

Line 1391: hr_utility.set_location('action taken is '||p_action_taken, 5);

1387: FOR cnt_history in c_cnt_history LOOP
1388: l_cnt_history := cnt_history.cnt;
1389: END LOOP;
1390: hr_utility.set_location('after count history: #'||to_char(l_cnt_history), 5);
1391: hr_utility.set_location('action taken is '||p_action_taken, 5);
1392: -- Get the last two action takens
1393: if l_cnt_history > 0 then
1394: open c_routing_history_id;
1395: fetch c_routing_history_id into

Line 1411: hr_utility.set_location('action 1 is '||l_last_action_taken_1, 5);

1407: l_user_name_2;
1408: end if;
1409: end if;
1410: close c_routing_history_id;
1411: hr_utility.set_location('action 1 is '||l_last_action_taken_1, 5);
1412: hr_utility.set_location('action 2 is '||l_last_action_taken_2, 5);
1413: hr_utility.set_location('item key1 is '||l_item_key_1, 5);
1414: hr_utility.set_location('item key2 is '||l_item_key_2, 5);
1415: open c_pd_initiated;

Line 1412: hr_utility.set_location('action 2 is '||l_last_action_taken_2, 5);

1408: end if;
1409: end if;
1410: close c_routing_history_id;
1411: hr_utility.set_location('action 1 is '||l_last_action_taken_1, 5);
1412: hr_utility.set_location('action 2 is '||l_last_action_taken_2, 5);
1413: hr_utility.set_location('item key1 is '||l_item_key_1, 5);
1414: hr_utility.set_location('item key2 is '||l_item_key_2, 5);
1415: open c_pd_initiated;
1416: fetch c_pd_initiated into l_dummy;

Line 1413: hr_utility.set_location('item key1 is '||l_item_key_1, 5);

1409: end if;
1410: close c_routing_history_id;
1411: hr_utility.set_location('action 1 is '||l_last_action_taken_1, 5);
1412: hr_utility.set_location('action 2 is '||l_last_action_taken_2, 5);
1413: hr_utility.set_location('item key1 is '||l_item_key_1, 5);
1414: hr_utility.set_location('item key2 is '||l_item_key_2, 5);
1415: open c_pd_initiated;
1416: fetch c_pd_initiated into l_dummy;
1417: if c_pd_initiated%FOUND then

Line 1414: hr_utility.set_location('item key2 is '||l_item_key_2, 5);

1410: close c_routing_history_id;
1411: hr_utility.set_location('action 1 is '||l_last_action_taken_1, 5);
1412: hr_utility.set_location('action 2 is '||l_last_action_taken_2, 5);
1413: hr_utility.set_location('item key1 is '||l_item_key_1, 5);
1414: hr_utility.set_location('item key2 is '||l_item_key_2, 5);
1415: open c_pd_initiated;
1416: fetch c_pd_initiated into l_dummy;
1417: if c_pd_initiated%FOUND then
1418: l_pd_initiated := TRUE;

Line 1440: hr_utility.set_location('l_forward_to_name is '||l_forward_to_name, 5);

1436: end loop;
1437: else
1438: l_forward_to_name := l_user_name_1;
1439: end if;
1440: hr_utility.set_location('l_forward_to_name is '||l_forward_to_name, 5);
1441: if p_action_taken in ('REOPENED','INITIATED') or (l_reclass_direct_flag = 'Y' and p_action_taken = 'RECLASSIFIED' ) then
1442: ghr_wf_pd_pkg.StartPDprocess
1443: (p_position_description_id => p_position_description_id,
1444: p_item_key => l_item_key_1,