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_OM_UPD_API dependencies on HR_UTILITY

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

120:
121:
122:
123: BEGIN
124: hr_utility.set_location('Entering:'||l_proc, 5);
125: --fnd_client_info.set_org_context(context => to_char(p_org_id));
126:
127: /* Bug 2707198 */
128: Begin

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

140: l_org_id,
141: l_ordered_quantity;
142: CLOSE C_ORDER;
143:
144: hr_utility.set_location('Entering:'||l_proc, 10);
145: -- IF l_ordered_quantity is not null and l_ordered_quantity > 0 THEN
146: IF l_ordered_quantity is not null and l_ordered_quantity > 0 and l_caller_source is null THEN -- Bug 2707198
147: BEGIN
148: MO_GLOBAL.SET_POLICY_CONTEXT ('S', l_org_id); -- For MOAC support

Line 237: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

233: when others then
234: l_err_num := SQLCODE;
235: l_err_msg := SUBSTR(SQLERRM, 1, 1000);
236:
237: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
238: hr_utility.set_message_token('PROCEDURE', l_proc);
239: hr_utility.set_message_token('STEP',l_err_msg );
240: hr_utility.raise_error;
241:

Line 238: hr_utility.set_message_token('PROCEDURE', l_proc);

234: l_err_num := SQLCODE;
235: l_err_msg := SUBSTR(SQLERRM, 1, 1000);
236:
237: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
238: hr_utility.set_message_token('PROCEDURE', l_proc);
239: hr_utility.set_message_token('STEP',l_err_msg );
240: hr_utility.raise_error;
241:
242: END;

Line 239: hr_utility.set_message_token('STEP',l_err_msg );

235: l_err_msg := SUBSTR(SQLERRM, 1, 1000);
236:
237: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
238: hr_utility.set_message_token('PROCEDURE', l_proc);
239: hr_utility.set_message_token('STEP',l_err_msg );
240: hr_utility.raise_error;
241:
242: END;
243: END IF;

Line 240: hr_utility.raise_error;

236:
237: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
238: hr_utility.set_message_token('PROCEDURE', l_proc);
239: hr_utility.set_message_token('STEP',l_err_msg );
240: hr_utility.raise_error;
241:
242: END;
243: END IF;
244:

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

436: OL.LINE_ID = p_line_id;
437:
438:
439: BEGIN
440: hr_utility.set_location('Entering:'||l_proc, 5);
441:
442: Select count(*)into l_count from oe_order_lines_all
443: where reference_line_id = p_line_id;
444: if l_count = 0 then

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

483: l_line_type_id,
484: l_commitment_id,
485: l_org_id;
486: CLOSE C_ORDER;
487: hr_utility.set_location('Entering:'||l_proc, 10);
488: BEGIN
489:
490: -- Header Level
491: MO_GLOBAL.SET_POLICY_CONTEXT ('S', l_org_id); -- For MOAC support

Line 650: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

646: l_err_msg := SUBSTR(SQLERRM, 1, 300);
647:
648:
649: -- raise_application_error(-20001,l_err_num||': '||l_err_msg);
650: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
651: hr_utility.set_message_token('PROCEDURE', l_proc);
652: hr_utility.set_message_token('STEP',l_message_data);
653: hr_utility.raise_error;
654:

Line 651: hr_utility.set_message_token('PROCEDURE', l_proc);

647:
648:
649: -- raise_application_error(-20001,l_err_num||': '||l_err_msg);
650: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
651: hr_utility.set_message_token('PROCEDURE', l_proc);
652: hr_utility.set_message_token('STEP',l_message_data);
653: hr_utility.raise_error;
654:
655:

Line 652: hr_utility.set_message_token('STEP',l_message_data);

648:
649: -- raise_application_error(-20001,l_err_num||': '||l_err_msg);
650: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
651: hr_utility.set_message_token('PROCEDURE', l_proc);
652: hr_utility.set_message_token('STEP',l_message_data);
653: hr_utility.raise_error;
654:
655:
656: END;

Line 653: hr_utility.raise_error;

649: -- raise_application_error(-20001,l_err_num||': '||l_err_msg);
650: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
651: hr_utility.set_message_token('PROCEDURE', l_proc);
652: hr_utility.set_message_token('STEP',l_message_data);
653: hr_utility.raise_error;
654:
655:
656: END;
657: END IF;

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

793: l_order_exception EXCEPTION;
794: l_org_id oe_order_headers.org_id%type;
795:
796: BEGIN
797: hr_utility.set_location('Entering:'||l_proc, 5);
798: hr_utility.set_location('Entering:'||l_proc, 10);
799: BEGIN
800: MO_GLOBAL.INIT('ONT');
801: l_org_id := MO_UTILS.Get_Default_Org_Id;

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

794: l_org_id oe_order_headers.org_id%type;
795:
796: BEGIN
797: hr_utility.set_location('Entering:'||l_proc, 5);
798: hr_utility.set_location('Entering:'||l_proc, 10);
799: BEGIN
800: MO_GLOBAL.INIT('ONT');
801: l_org_id := MO_UTILS.Get_Default_Org_Id;
802: MO_GLOBAL.SET_POLICY_CONTEXT ('S', l_org_id); -- For MOAC support

Line 901: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

897: raise l_order_exception;
898: END IF;
899: exception
900: when l_order_exception then
901: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
902: hr_utility.set_message_token('PROCEDURE', l_proc);
903: hr_utility.set_message_token('STEP',l_message_data);
904: hr_utility.raise_error;
905: -- RAISE FND_API.G_EXC_ERROR;

Line 902: hr_utility.set_message_token('PROCEDURE', l_proc);

898: END IF;
899: exception
900: when l_order_exception then
901: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
902: hr_utility.set_message_token('PROCEDURE', l_proc);
903: hr_utility.set_message_token('STEP',l_message_data);
904: hr_utility.raise_error;
905: -- RAISE FND_API.G_EXC_ERROR;
906:

Line 903: hr_utility.set_message_token('STEP',l_message_data);

899: exception
900: when l_order_exception then
901: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
902: hr_utility.set_message_token('PROCEDURE', l_proc);
903: hr_utility.set_message_token('STEP',l_message_data);
904: hr_utility.raise_error;
905: -- RAISE FND_API.G_EXC_ERROR;
906:
907:

Line 904: hr_utility.raise_error;

900: when l_order_exception then
901: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
902: hr_utility.set_message_token('PROCEDURE', l_proc);
903: hr_utility.set_message_token('STEP',l_message_data);
904: hr_utility.raise_error;
905: -- RAISE FND_API.G_EXC_ERROR;
906:
907:
908: when others then

Line 913: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

909: l_err_num := SQLCODE;
910: l_err_msg := SUBSTR(SQLERRM, 1, 100);
911:
912:
913: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
914: hr_utility.set_message_token('PROCEDURE', l_proc);
915: hr_utility.set_message_token('STEP',l_err_msg );
916: hr_utility.raise_error;
917:

Line 914: hr_utility.set_message_token('PROCEDURE', l_proc);

910: l_err_msg := SUBSTR(SQLERRM, 1, 100);
911:
912:
913: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
914: hr_utility.set_message_token('PROCEDURE', l_proc);
915: hr_utility.set_message_token('STEP',l_err_msg );
916: hr_utility.raise_error;
917:
918: END;

Line 915: hr_utility.set_message_token('STEP',l_err_msg );

911:
912:
913: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
914: hr_utility.set_message_token('PROCEDURE', l_proc);
915: hr_utility.set_message_token('STEP',l_err_msg );
916: hr_utility.raise_error;
917:
918: END;
919: END;

Line 916: hr_utility.raise_error;

912:
913: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
914: hr_utility.set_message_token('PROCEDURE', l_proc);
915: hr_utility.set_message_token('STEP',l_err_msg );
916: hr_utility.raise_error;
917:
918: END;
919: END;
920: