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

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

212: and type='OTA_LEARNING_PATH';*/
213:
214: begin
215:
216: hr_utility.set_location('Entering:'||l_proc, 5);
217: if p_obj_type='COURSE' then
218: OPEN course_eff_date;
219: FETCH course_eff_date INTO l_eff_date;
220: if course_eff_date%notfound then

Line 227: hr_utility.set_location('Leaving:'||l_proc, 5);

223: CLOSE course_eff_date;
224: else
225: select trunc(sysdate) into l_eff_date from dual;
226: end if;
227: hr_utility.set_location('Leaving:'||l_proc, 5);
228: return l_eff_date;
229:
230: Exception
231:

Line 307: hr_utility.set_location('Before chk transaction step'||l_proc, 5);

303: ,p_item_key => p_item_key);
304:
305: END IF;
306:
307: hr_utility.set_location('Before chk transaction step'||l_proc, 5);
308:
309: if (hr_transaction_api.transaction_step_exist (p_item_type => p_item_type
310: ,p_item_key => p_item_key
311: ,p_activity_id => l_activity_id) and p_from is null ) then

Line 333: hr_utility.set_location('Me Entering Create transaction step'||l_proc, 5);

329:
330: --
331: -- Create a transaction step
332: --
333: hr_utility.set_location('Me Entering Create transaction step'||l_proc, 5);
334:
335: if p_from ='SS' then
336: l_transaction_step_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type
337: ,itemkey => p_item_key

Line 365: hr_utility.set_location('out of Create transaction step'||l_proc, 5);

361:
362:
363: end if;
364: --
365: hr_utility.set_location('out of Create transaction step'||l_proc, 5);
366: HR_UTILITY.TRACE ('tranasction step id: ' || to_char (l_transaction_step_id));
367: l_count := 1;
368: l_transaction_table(l_count).param_name := 'P_COMPETENCE';
369: l_transaction_table(l_count).param_value := p_competence_id;

Line 366: HR_UTILITY.TRACE ('tranasction step id: ' || to_char (l_transaction_step_id));

362:
363: end if;
364: --
365: hr_utility.set_location('out of Create transaction step'||l_proc, 5);
366: HR_UTILITY.TRACE ('tranasction step id: ' || to_char (l_transaction_step_id));
367: l_count := 1;
368: l_transaction_table(l_count).param_name := 'P_COMPETENCE';
369: l_transaction_table(l_count).param_value := p_competence_id;
370: l_transaction_table(l_count).param_data_type := 'VARCHAR2';

Line 445: hr_utility.set_location('Before save transaction step'||l_proc, 5);

441: p_item_key,
442: 'OTA_TRANSACTION_STEP_ID',
443: l_transaction_step_id);
444:
445: hr_utility.set_location('Before save transaction step'||l_proc, 5);
446: hr_transaction_ss.save_transaction_step
447: (p_item_type => p_item_type
448: ,p_item_key => p_item_key
449: ,p_actid => l_activity_id

Line 456: hr_utility.set_location('After save transaction step'||l_proc, 50);

452: ,p_api_name => g_package || '.PROCESS_API'
453: ,p_function_id => 0 ---not used
454: ,p_transaction_data => l_transaction_table);
455:
456: hr_utility.set_location('After save transaction step'||l_proc, 50);
457:
458: if p_from ='SS' then
459: hr_transaction_api.update_transaction
460: (p_transaction_id => l_transaction_id

Line 468: /* WHEN hr_utility.hr_error THEN

464: );
465: end if;
466:
467: EXCEPTION
468: /* WHEN hr_utility.hr_error THEN
469: -- -------------------------------------------
470: -- an application error has been raised so we must
471: -- redisplay the web form to display the error
472: -- --------------------------------------------

Line 513: hr_utility.set_location('ENTERING Update Competence', 10);

509: l_error_text varchar2(2000);
510: l_result varchar2(25);
511:
512: begin
513: hr_utility.set_location('ENTERING Update Competence', 10);
514:
515: hr_multi_message.disable_message_list;
516:
517: IF (funcmode='RUN') THEN

Line 555: hr_utility.set_location('ERROR Update Competence', 10);

551: When others then
552:
553: rollback to commit_transaction;
554: --
555: hr_utility.set_location('ERROR Update Competence', 10);
556:
557: l_error_text := hr_utility.get_message;
558: if l_error_text is null then
559: l_error_text := fnd_message.get;

Line 557: l_error_text := hr_utility.get_message;

553: rollback to commit_transaction;
554: --
555: hr_utility.set_location('ERROR Update Competence', 10);
556:
557: l_error_text := hr_utility.get_message;
558: if l_error_text is null then
559: l_error_text := fnd_message.get;
560: end if;
561: -- 1903606

Line 574: hr_utility.trace('l_error_text' || nvl(l_error_text, sqlerrm));

570: (itemtype => itemtype
571: ,itemkey => itemkey
572: ,aname => 'ERROR_MESSAGE_TEXT'
573: ,avalue => nvl(l_error_text, sqlerrm));
574: hr_utility.trace('l_error_text' || nvl(l_error_text, sqlerrm));
575: -- update the transaction table status
576: hr_transaction_api.update_transaction(
577: p_transaction_id => hr_transaction_ss.get_transaction_id
578: (p_item_type => itemtype

Line 605: hr_utility.set_location('ENTERING check Update Competence', 10);

601: l_error_text varchar2(2000);
602: l_result varchar2(25);
603:
604: begin
605: hr_utility.set_location('ENTERING check Update Competence', 10);
606: hr_multi_message.disable_message_list;
607: IF (funcmode='RUN') THEN
608: -- savepoint commit_transaction;
609:

Line 620: hr_utility.trace('l_result chk_proceed' || l_result);

616: process_api(true,l_transaction_step_id);
617: l_result := wf_engine.GetItemAttrText(itemtype => itemtype
618: ,itemkey => itemkey
619: ,aname => 'HR_FLOW_NAME_ATTR');
620: hr_utility.trace('l_result chk_proceed' || l_result);
621: if l_result = 'PROCEED' then
622: resultout := 'COMPLETE:Y' ;
623: else
624: resultout := 'COMPLETE:N';

Line 645: hr_utility.set_location('ERROR Update Competence', 10);

641: When others then
642:
643: -- rollback to commit_transaction;
644: --
645: hr_utility.set_location('ERROR Update Competence', 10);
646:
647: l_error_text := hr_utility.get_message;
648: if l_error_text is null then
649: l_error_text := fnd_message.get;

Line 647: l_error_text := hr_utility.get_message;

643: -- rollback to commit_transaction;
644: --
645: hr_utility.set_location('ERROR Update Competence', 10);
646:
647: l_error_text := hr_utility.get_message;
648: if l_error_text is null then
649: l_error_text := fnd_message.get;
650: end if;
651: -- 1903606

Line 664: hr_utility.trace('l_error_text' || nvl(l_error_text, sqlerrm));

660: (itemtype => itemtype
661: ,itemkey => itemkey
662: ,aname => 'ERROR_MESSAGE_TEXT'
663: ,avalue => nvl(l_error_text, sqlerrm));
664: hr_utility.trace('l_error_text' || nvl(l_error_text, sqlerrm));
665: -- update the transaction table status
666: hr_transaction_api.update_transaction(
667: p_transaction_id => hr_transaction_ss.get_transaction_id
668: (p_item_type => itemtype

Line 737: hr_utility.set_location('ENTERING get_approval_req', 10);

733: AND paf.primary_flag ='Y'
734: AND paf.assignment_type in ('E','A', 'C');
735:
736: BEGIN
737: hr_utility.set_location('ENTERING get_approval_req', 10);
738: IF (funcmode='RUN') THEN
739:
740: l_cert_id := wf_engine.getItemAttrNumber(itemtype => itemtype
741: ,itemkey => itemkey

Line 791: hr_utility.trace('l_item_value' || l_item_value);

787: if l_item_value is null then
788:
789: OPEN getActAttrValue;
790: FETCH getActAttrValue INTO l_item_value;
791: hr_utility.trace('l_item_value' || l_item_value);
792: close getActAttrValue;
793:
794: end if;
795: -- if getActAttrValue%FOUND then

Line 824: hr_utility.trace('l_resultout' || resultout);

820: resultout:='COMPLETE';
821:
822:
823: end if;
824: hr_utility.trace('l_resultout' || resultout);
825: l_ntf_url := generate_url(l_item_value);
826: WF_ENGINE.setitemattrtext(itemtype, itemkey, 'APPROVAL_GENERIC_URL', l_ntf_url);
827: WF_ENGINE.setitemattrtext(itemtype, itemkey, 'HR_REVIEW_TEMPLATE_RN_ATTR', 'OTA_LIST_COMP_NTF');
828: /* END IF; -- cursor

Line 840: hr_utility.set_location('ENTERING exception get_approval_req', 10);

836: END IF;
837: Exception
838:
839: when others then
840: hr_utility.set_location('ENTERING exception get_approval_req', 10);
841:
842:
843:
844: end get_approval_req;

Line 1039: hr_utility.trace ('l_comp_retValue ' ||l_comp_retValue);

1035: get_value(inString =>l_comp_ids,
1036: startPos =>l_comp_startPos,
1037: endPos => l_comp_endPos,
1038: retValue => l_comp_retValue);
1039: hr_utility.trace ('l_comp_retValue ' ||l_comp_retValue);
1040:
1041: l_comp_startPos := l_comp_endPos+1;
1042:
1043: get_value(inString =>l_level_ids,

Line 1075: hr_utility.trace ('l_dtFrom_retValue ' ||l_dtFrom_retValue);

1071: get_value(inString =>l_dtFrom,
1072: startPos =>l_dtFrom_startPos,
1073: endPos => l_dtFrom_endPos,
1074: retValue => l_dtFrom_retValue);
1075: hr_utility.trace ('l_dtFrom_retValue ' ||l_dtFrom_retValue);
1076: l_dtFrom_startPos := l_dtFrom_endPos+1;
1077:
1078: if l_dtFrom_retValue ='-1' then
1079:

Line 1094: hr_utility.trace ('l_dtTo_retValue ' ||l_dtTo_retValue);

1090: get_value(inString =>l_dtTo,
1091: startPos =>l_dtTo_startPos,
1092: endPos => l_dtTo_endPos,
1093: retValue => l_dtTo_retValue);
1094: hr_utility.trace ('l_dtTo_retValue ' ||l_dtTo_retValue);
1095: l_dtTo_startPos := l_dtTo_endPos+1;
1096:
1097: if l_dtTo_retValue ='-1' then
1098:

Line 1181: hr_utility.set_location('BEFORE call to competence element api', 100);

1177: CLOSE Comp_level;
1178:
1179: --if ((l_level_value_to_use is not null and l_old_level_id <= l_level_value_to_use) or l_old_level_id is null) then
1180:
1181: hr_utility.set_location('BEFORE call to competence element api', 100);
1182:
1183: hr_competence_element_api.maintain_student_comp_element
1184: (p_person_id => l_person_id
1185: ,p_competence_id => l_comp_retValue

Line 1198: hr_utility.set_location('After call to competence element api', 100);

1194: ,p_comments => l_comments_retValue
1195: ,p_effective_date => trunc(sysdate)
1196: -- ,p_validate => p_validate
1197: ,p_competence_created => l_competence_created);
1198: hr_utility.set_location('After call to competence element api', 100);
1199: hr_utility.trace ('l_competence_created ' ||l_competence_created);
1200:
1201:
1202:

Line 1199: hr_utility.trace ('l_competence_created ' ||l_competence_created);

1195: ,p_effective_date => trunc(sysdate)
1196: -- ,p_validate => p_validate
1197: ,p_competence_created => l_competence_created);
1198: hr_utility.set_location('After call to competence element api', 100);
1199: hr_utility.trace ('l_competence_created ' ||l_competence_created);
1200:
1201:
1202:
1203: if l_competence_created <> 0 and (l_attr_chk) then

Line 1230: hr_utility.set_location('Leaving'||l_proc, 5);

1226: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_FLOW_NAME_ATTR', 'STOP');
1227: else
1228: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_FLOW_NAME_ATTR', 'PROCEED');
1229: end if;
1230: hr_utility.set_location('Leaving'||l_proc, 5);
1231:
1232: EXCEPTION
1233: WHEN OTHERS THEN
1234: hr_utility.set_location('Leaving with error:'||l_proc, 25);

Line 1234: hr_utility.set_location('Leaving with error:'||l_proc, 25);

1230: hr_utility.set_location('Leaving'||l_proc, 5);
1231:
1232: EXCEPTION
1233: WHEN OTHERS THEN
1234: hr_utility.set_location('Leaving with error:'||l_proc, 25);
1235: rollback to validate_competence;
1236: -- In case of Approvla required Error notification shud go to approving manager
1237: -- In case of auto competence update error notification shud go to learner
1238: l_fwd_to_username:= nvl(wf_engine.getitemattrtext

Line 1257: hr_utility.trace('l_msg_name' || sqlerrm);

1253: );
1254: */
1255: -- change date message to a more meaningful one.
1256: l_msg_name:= sqlerrm;
1257: hr_utility.trace('l_msg_name' || sqlerrm);
1258: if instr(l_msg_name,'_51647_')>0 then
1259: hr_utility.set_location('MESSAGE CHANGED', 10);
1260: fnd_message.set_name('OTA', 'OTA_443335_COMP_UPD_FAIL');
1261: --fnd_message.raise_error;

Line 1259: hr_utility.set_location('MESSAGE CHANGED', 10);

1255: -- change date message to a more meaningful one.
1256: l_msg_name:= sqlerrm;
1257: hr_utility.trace('l_msg_name' || sqlerrm);
1258: if instr(l_msg_name,'_51647_')>0 then
1259: hr_utility.set_location('MESSAGE CHANGED', 10);
1260: fnd_message.set_name('OTA', 'OTA_443335_COMP_UPD_FAIL');
1261: --fnd_message.raise_error;
1262: end if;
1263: RAISE;

Line 1342: hr_utility.trace ('l_comp_retValue ' ||l_comp_retValue);

1338: get_value(inString =>l_comp_ids,
1339: startPos =>l_comp_startPos,
1340: endPos => l_comp_endPos,
1341: retValue => l_comp_retValue);
1342: hr_utility.trace ('l_comp_retValue ' ||l_comp_retValue);
1343:
1344: l_comp_startPos := l_comp_endPos+1;
1345:
1346: get_value(inString =>l_level_ids,

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

1566: l_ntfFyiParamVal varchar2(5) := 'N';
1567:
1568:
1569: BEGIN
1570: hr_utility.set_location('Entering:'||l_proc, 5);
1571:
1572: OPEN chk_person_business_grp;
1573: FETCH chk_person_business_grp INTO l_business_group_id;
1574: if chk_person_business_grp%found then

Line 1590: hr_utility.trace ('l_LP_idsssss ' ||l_LP_ids);

1586: ,p_eff_date_to => l_eff_date_to);
1587:
1588: --Retrieve comp. info for each of the LP's to be stored in tt table ,
1589: --create separate worklfow process for each LP.
1590: hr_utility.trace ('l_LP_idsssss ' ||l_LP_ids);
1591:
1592: -- code required for object type to be set in notifications
1593: if p_learningpath_ids is not null then
1594: l_LP_lookup_meaning := ota_utility.get_lookup_meaning(p_lookup_type => 'OTA_CATALOG_OBJECT_TYPE',

Line 1614: hr_utility.trace ('l_LP_retValue ' ||l_LP_retValue);

1610: get_value(inString =>l_LP_ids,
1611: startPos =>l_LP_startPos,
1612: endPos => l_LP_endPos,
1613: retValue => l_LP_retValue);
1614: hr_utility.trace ('l_LP_retValue ' ||l_LP_retValue);
1615:
1616: l_LP_startPos := l_LP_endPos+1;
1617:
1618: --Retrieve comp. info for the course first , to be stored in tt table

Line 1626: hr_utility.trace ('l_comp_idssssssssss ' ||l_comp_ids);

1622: , p_level_ids =>l_level_ids
1623: ,p_eff_date_from => l_eff_date_from);
1624:
1625: end if;
1626: hr_utility.trace ('l_comp_idssssssssss ' ||l_comp_ids);
1627: --l_current_user_Id := 12725;
1628: */
1629: --Start transaction and workflow only when competencies are attached
1630: /*if l_comp_ids is not null then

Line 1683: hr_utility.set_location('Entering:'||l_proc, 10);

1679: FETCH certification_name INTO l_course_name;
1680: CLOSE certification_name;
1681: end if;
1682:
1683: hr_utility.set_location('Entering:'||l_proc, 10);
1684: -- Get the next item key from the sequence
1685: select hr_workflow_item_key_s.nextval
1686: into l_item_key
1687: from sys.dual;

Line 1693: hr_utility.set_location('before OTA_OBJECT_TYPE'||l_proc, 140);

1689:
1690: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
1691:
1692: if p_Learningpath_ids is not null then
1693: hr_utility.set_location('before OTA_OBJECT_TYPE'||l_proc, 140);
1694: WF_ENGINE.setitemattrtext(l_item_type,
1695: l_item_key,
1696: 'REVIEW_OBJECT',
1697: l_LP_lookup_meaning);

Line 1698: hr_utility.set_location('after OTA_OBJECT_TYPE'||l_proc, 240);

1694: WF_ENGINE.setitemattrtext(l_item_type,
1695: l_item_key,
1696: 'REVIEW_OBJECT',
1697: l_LP_lookup_meaning);
1698: hr_utility.set_location('after OTA_OBJECT_TYPE'||l_proc, 240);
1699: elsif p_eventid is not null then
1700: hr_utility.set_location('before OTA_OBJECT_TYPE 2'||l_proc, 340);
1701: WF_ENGINE.setitemattrtext(l_item_type,
1702: l_item_key,

Line 1700: hr_utility.set_location('before OTA_OBJECT_TYPE 2'||l_proc, 340);

1696: 'REVIEW_OBJECT',
1697: l_LP_lookup_meaning);
1698: hr_utility.set_location('after OTA_OBJECT_TYPE'||l_proc, 240);
1699: elsif p_eventid is not null then
1700: hr_utility.set_location('before OTA_OBJECT_TYPE 2'||l_proc, 340);
1701: WF_ENGINE.setitemattrtext(l_item_type,
1702: l_item_key,
1703: 'REVIEW_OBJECT',
1704: l_CRS_lookup_meaning);

Line 1705: hr_utility.set_location('after OTA_OBJECT_TYPE 2'||l_proc, 440);

1701: WF_ENGINE.setitemattrtext(l_item_type,
1702: l_item_key,
1703: 'REVIEW_OBJECT',
1704: l_CRS_lookup_meaning);
1705: hr_utility.set_location('after OTA_OBJECT_TYPE 2'||l_proc, 440);
1706: else
1707: WF_ENGINE.setitemattrtext(l_item_type,
1708: l_item_key,
1709: 'REVIEW_OBJECT',

Line 1736: hr_utility.set_location('Before Getting Owner'||l_proc, 10);

1732: end if;
1733:
1734: -- Get and set owner role
1735:
1736: hr_utility.set_location('Before Getting Owner'||l_proc, 10);
1737:
1738: WF_DIRECTORY.GetRoleName(p_orig_system =>'PER',
1739: p_orig_system_id => l_creator_person_id,
1740: p_name =>l_role_name,

Line 1749: hr_utility.set_location('After Setting Owner'||l_proc, 10);

1745: itemtype => l_item_type,
1746: itemkey =>l_item_key,
1747: owner =>l_role_name);
1748:
1749: hr_utility.set_location('After Setting Owner'||l_proc, 10);
1750:
1751: --modified for bug 7308160
1752:
1753: /*l_person_details := ota_learner_enroll_ss.Get_Person_To_Enroll_Details(p_person_id => p_person_id);

Line 1778: HR_UTILITY.TRACE ('item key: ' || l_item_key);

1774: l_person_full_name);
1775: END IF;
1776:
1777:
1778: HR_UTILITY.TRACE ('item key: ' || l_item_key);
1779:
1780:
1781:
1782:

Line 1794: hr_utility.set_location('before supervisor'||l_proc, 30);

1790: p_date_from =>l_eff_date_from,
1791: p_date_to => l_eff_date_to);
1792:
1793:
1794: hr_utility.set_location('before supervisor'||l_proc, 30);
1795: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_CUSTOM_RETURN_FOR_CORR','Y');
1796:
1797: --always set to Y
1798: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_RUNTIME_APPROVAL_REQ_FLAG', 'YES');

Line 1799: hr_utility.set_location('before supervisor'||l_proc, 40);

1795: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_CUSTOM_RETURN_FOR_CORR','Y');
1796:
1797: --always set to Y
1798: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_RUNTIME_APPROVAL_REQ_FLAG', 'YES');
1799: hr_utility.set_location('before supervisor'||l_proc, 40);
1800: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'P_ASSIGNMENT_ID', l_assignment);
1801: hr_utility.set_location('before supervisor'||l_proc, 50);
1802: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'CURRENT_ASSIGNMENT_ID', to_number(l_assignment));
1803:

Line 1801: hr_utility.set_location('before supervisor'||l_proc, 50);

1797: --always set to Y
1798: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_RUNTIME_APPROVAL_REQ_FLAG', 'YES');
1799: hr_utility.set_location('before supervisor'||l_proc, 40);
1800: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'P_ASSIGNMENT_ID', l_assignment);
1801: hr_utility.set_location('before supervisor'||l_proc, 50);
1802: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'CURRENT_ASSIGNMENT_ID', to_number(l_assignment));
1803:
1804: if p_eventId is not null then
1805: WF_ENGINE.setitemattrText(l_item_type, l_item_key, 'OTA_EVENT_TITLE', l_event_name);

Line 1815: hr_utility.set_location('before supervisor'||l_proc, 20);

1811: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'HR_AME_TRAN_TYPE_ATTR','OTA');
1812: WF_ENGINE.setitemattrNumber(l_item_type, l_item_key, 'HR_AME_APP_ID_ATTR', 810);
1813: --WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'TRAN_SUBMIT','Y');
1814: --WF_ENGINE.SetItemattrtext(p_itemtype,p_item_key, 'EVENT_OWNER',l_user_name);
1815: hr_utility.set_location('before supervisor'||l_proc, 20);
1816:
1817: FOR a IN csr_supervisor_id LOOP
1818: l_supervisor_id := a.supervisor_id;
1819: l_supervisor_full_name := a.full_name;

Line 1827: hr_utility.set_location('after supervisor cursor'||l_proc, 20);

1823: FOR b IN csr_supervisor_user LOOP
1824: l_supervisor_username := b.user_name;
1825: END LOOP;
1826:
1827: hr_utility.set_location('after supervisor cursor'||l_proc, 20);
1828:
1829: wf_engine.setitemattrtext
1830: (l_item_type,
1831: l_item_key,

Line 1834: hr_utility.set_location('after supervisor username'||l_proc, 20);

1830: (l_item_type,
1831: l_item_key,
1832: 'SUPERVISOR_USERNAME',
1833: l_supervisor_username);
1834: hr_utility.set_location('after supervisor username'||l_proc, 20);
1835:
1836: wf_engine.setitemattrtext
1837: (l_item_type,
1838: l_item_key,

Line 1841: hr_utility.set_location('after supervisor disp name'||l_proc, 20);

1837: (l_item_type,
1838: l_item_key,
1839: 'SUPERVISOR_DISPLAY_NAME',
1840: l_supervisor_full_name);
1841: hr_utility.set_location('after supervisor disp name'||l_proc, 20);
1842: wf_engine.setitemattrtext
1843: (l_item_type,
1844: l_item_key,
1845: 'SUPERVISOR_ID',

Line 1847: hr_utility.set_location('before start process'||l_proc, 20);

1843: (l_item_type,
1844: l_item_key,
1845: 'SUPERVISOR_ID',
1846: l_supervisor_id);
1847: hr_utility.set_location('before start process'||l_proc, 20);
1848: if p_learningpath_ids is not null then
1849:
1850: /*hr_approval_wf.create_item_attrib_if_notexist
1851: (p_item_type => l_item_type

Line 1884: hr_utility.set_location('leaving:'||l_proc, 20);

1880:
1881: p_itemkey:=l_item_key;
1882:
1883:
1884: hr_utility.set_location('leaving:'||l_proc, 20);
1885: EXCEPTION
1886: WHEN OTHERS THEN
1887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1888: -- Raise;

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

1905: l_amp varchar2(2) := '&';
1906: l_func varchar2(80);
1907:
1908: begin
1909: hr_utility.set_location('Entering'||l_proc, 5);
1910:
1911: --l_jsp_apps_agent := fnd_profile.value('APPS_FRAMEWORK_AGENT');
1912: --HR_UTILITY.TRACE ('Agent :: ' || l_jsp_apps_agent);
1913: if p_func='APPROVAL' then

Line 1912: --HR_UTILITY.TRACE ('Agent :: ' || l_jsp_apps_agent);

1908: begin
1909: hr_utility.set_location('Entering'||l_proc, 5);
1910:
1911: --l_jsp_apps_agent := fnd_profile.value('APPS_FRAMEWORK_AGENT');
1912: --HR_UTILITY.TRACE ('Agent :: ' || l_jsp_apps_agent);
1913: if p_func='APPROVAL' then
1914: l_func:='OTA_ADMIN_COMPETENCE_UPDATE';
1915: else
1916: l_func:='OTA_ADMIN_COMPETENCE_VIEW';

Line 1922: HR_UTILITY.TRACE ('URL :: ' || l_url);

1918: end if;
1919:
1920: l_url := 'JSP:' || '/OA_HTML/OA.jsp?OAFunc=' || l_func || l_amp || 'NtfId=-&#NID-' || l_amp || 'retainAM=Y';
1921:
1922: HR_UTILITY.TRACE ('URL :: ' || l_url);
1923:
1924: return l_url;
1925:
1926: hr_utility.set_location('Leaving'||l_proc, 5);

Line 1926: hr_utility.set_location('Leaving'||l_proc, 5);

1922: HR_UTILITY.TRACE ('URL :: ' || l_url);
1923:
1924: return l_url;
1925:
1926: hr_utility.set_location('Leaving'||l_proc, 5);
1927: end generate_url;
1928:
1929: -- ---------------------------------------------------------------------------
1930: -- |----------------------< COMP_RETREIVE >--------------------------|

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

2021:
2022:
2023: BEGIN
2024:
2025: hr_utility.set_location('Entering:'||l_proc, 5);
2026: IF p_learning_path_ids = '' or p_learning_path_ids is null THEN
2027: l_learning_path_ids := NULL;
2028: ELSE
2029: l_learning_path_ids:= p_learning_path_ids;

Line 2032: hr_utility.set_location('l_:'||l_proc, 10);

2028: ELSE
2029: l_learning_path_ids:= p_learning_path_ids;
2030: END IF;
2031: IF p_event_id IS not NULL THEN
2032: hr_utility.set_location('l_:'||l_proc, 10);
2033: OPEN get_comp_profile;
2034: FETCH get_comp_profile into allow_comp_renewal_period;
2035: CLOSE get_comp_profile;
2036: FOR crs_comp_rec IN csr_get_crs_comps LOOP

Line 2178: hr_utility.set_location('Entering:'||l_proc, 15);

2174: END LOOP;
2175: END IF;
2176:
2177: IF l_learning_path_ids IS NOT NULL THEN
2178: hr_utility.set_location('Entering:'||l_proc, 15);
2179: /* LOOP
2180: l_rightpos := INSTR(p_learning_path_ids,'^',1,l_count);
2181: IF l_rightpos = 0 THEN
2182: l_learning_path_id := to_number(SUBSTR(l_learning_path_ids,l_leftpos,length(p_learning_path_ids) - l_leftpos +1));

Line 2190: hr_utility.trace ('l_learning_path_id ' ||l_learning_path_id);

2186: l_leftpos := l_rightpos + 1;
2187: l_count := l_count +1; */
2188:
2189: l_learning_path_id := to_number(l_learning_path_ids);
2190: hr_utility.trace ('l_learning_path_id ' ||l_learning_path_id);
2191: FOR lps_comp_rec IN csr_get_lp_comps LOOP
2192: hr_utility.set_location('Entering:'||l_proc, 20);
2193: IF p_comp_ids IS NULL OR p_comp_ids = '' THEN
2194: hr_utility.set_location('Entering:'||l_proc, 25);

Line 2192: hr_utility.set_location('Entering:'||l_proc, 20);

2188:
2189: l_learning_path_id := to_number(l_learning_path_ids);
2190: hr_utility.trace ('l_learning_path_id ' ||l_learning_path_id);
2191: FOR lps_comp_rec IN csr_get_lp_comps LOOP
2192: hr_utility.set_location('Entering:'||l_proc, 20);
2193: IF p_comp_ids IS NULL OR p_comp_ids = '' THEN
2194: hr_utility.set_location('Entering:'||l_proc, 25);
2195: p_comp_ids := lps_comp_rec.CompetenceId;
2196: p_level_ids := lps_comp_rec.LevelId;

Line 2194: hr_utility.set_location('Entering:'||l_proc, 25);

2190: hr_utility.trace ('l_learning_path_id ' ||l_learning_path_id);
2191: FOR lps_comp_rec IN csr_get_lp_comps LOOP
2192: hr_utility.set_location('Entering:'||l_proc, 20);
2193: IF p_comp_ids IS NULL OR p_comp_ids = '' THEN
2194: hr_utility.set_location('Entering:'||l_proc, 25);
2195: p_comp_ids := lps_comp_rec.CompetenceId;
2196: p_level_ids := lps_comp_rec.LevelId;
2197: hr_utility.set_location('Entering:'||l_proc, 35);
2198: l_eff_date_from := to_char(get_competence_eff_date(p_comp_id=> lps_comp_rec.CompetenceId,p_id=>l_learning_path_id,p_obj_type=>'LP'),g_date_format) ;

Line 2197: hr_utility.set_location('Entering:'||l_proc, 35);

2193: IF p_comp_ids IS NULL OR p_comp_ids = '' THEN
2194: hr_utility.set_location('Entering:'||l_proc, 25);
2195: p_comp_ids := lps_comp_rec.CompetenceId;
2196: p_level_ids := lps_comp_rec.LevelId;
2197: hr_utility.set_location('Entering:'||l_proc, 35);
2198: l_eff_date_from := to_char(get_competence_eff_date(p_comp_id=> lps_comp_rec.CompetenceId,p_id=>l_learning_path_id,p_obj_type=>'LP'),g_date_format) ;
2199: hr_utility.set_location('Entering:'||l_proc, 45);
2200:
2201: ELSE

Line 2199: hr_utility.set_location('Entering:'||l_proc, 45);

2195: p_comp_ids := lps_comp_rec.CompetenceId;
2196: p_level_ids := lps_comp_rec.LevelId;
2197: hr_utility.set_location('Entering:'||l_proc, 35);
2198: l_eff_date_from := to_char(get_competence_eff_date(p_comp_id=> lps_comp_rec.CompetenceId,p_id=>l_learning_path_id,p_obj_type=>'LP'),g_date_format) ;
2199: hr_utility.set_location('Entering:'||l_proc, 45);
2200:
2201: ELSE
2202: p_comp_ids := p_comp_ids || '^' || lps_comp_rec.CompetenceId;
2203: p_level_ids := p_level_ids || '^' || lps_comp_rec.LevelId;

Line 2243: hr_utility.set_location('Leaving:'||l_proc, 5);

2239: END IF;
2240: p_eff_date_from :=l_eff_date_from;
2241: p_eff_date_to := l_eff_date_to;
2242:
2243: hr_utility.set_location('Leaving:'||l_proc, 5);
2244:
2245: Exception
2246:
2247: when others then