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.EGO_ODI_PUB dependencies on EGO_ODI_PUB

Line 1: package body ego_odi_pub as

1: package body ego_odi_pub as
2: /* $Header: EGOODIXB.pls 120.59.12020000.2 2013/04/09 01:25:29 trudave ship $ */
3:
4: /*==========================================================================+
5: | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |

Line 140: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

136: from mtl_system_items_kfv
137: WHERE organization_id = p_org_id
138: AND inventory_item_id = to_number(l_inv_item_id);
139:
140: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
141: p_odi_session_id => p_odi_session_id,
142: p_input_id => p_index,
143: p_param_name => 'InventoryItemId',
144: p_param_value => l_inv_item_id );

Line 209: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

205: --raise_application_error(-20101, 'Invalid Organization Id or Organization Name');
206:
207: IF (l_inv_item_id IS NOT NULL) THEN
208:
209: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
210: p_odi_session_id => p_odi_session_id,
211: p_input_id => p_index,
212: p_err_code => 'EGO_INVALID_ITEM_ID',
213: p_err_message => 'Invalid Inventory Item Id');

Line 217: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

213: p_err_message => 'Invalid Inventory Item Id');
214:
215: ELSE
216:
217: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
218: p_odi_session_id => p_odi_session_id,
219: p_input_id => p_index,
220: p_err_code => 'EGO_INVALID_ITEM_NAME',
221: p_err_message => 'Invalid Inventory Item Name');

Line 270: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

266: INTO x_organization_id
267: from mtl_parameters
268: WHERE organization_id = to_number(l_org_id);
269:
270: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
271: p_odi_session_id => p_odi_session_id,
272: p_input_id => p_index,
273: p_param_name => 'OrganizationId',
274: p_param_value => l_org_id);

Line 284: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

280: INTO x_organization_id
281: from mtl_parameters
282: WHERE organization_code = p_org_code;
283:
284: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
285: p_odi_session_id => p_odi_session_id,
286: p_input_id => p_index,
287: p_param_name => 'OrganizationCode',
288: p_param_value => p_org_code );

Line 301: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

297: --dbms_output.put_line(' Error : Invalid Organization Details ');
298: --raise_application_error(-20101, 'Invalid Organization Id');
299: IF (l_org_id IS NOT NULL) THEN
300:
301: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
302: p_odi_session_id => p_odi_session_id,
303: p_input_id => p_index,
304: p_err_code => 'EGO_INVALID_ORG_ID',
305: p_err_message => 'Invalid Organization Id');

Line 308: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

304: p_err_code => 'EGO_INVALID_ORG_ID',
305: p_err_message => 'Invalid Organization Id');
306: ELSE
307:
308: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
309: p_odi_session_id => p_odi_session_id,
310: p_input_id => p_index,
311: p_err_code => 'EGO_INVALID_ORG_CODE',
312: p_err_message => 'Invalid Organization Code');

Line 391: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

387: WHERE session_id = p_session_id;
388:
389: IF (l_ag_id IS NOT NULL) THEN
390:
391: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
392: p_odi_session_id => p_odi_session_id,
393: p_input_id => l_index,
394: p_param_name => 'AttributeGroupId',
395: p_param_value => l_ag_id

Line 398: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

394: p_param_name => 'AttributeGroupId',
395: p_param_value => l_ag_id
396: );
397:
398: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
399: p_odi_session_id => p_odi_session_id,
400: p_input_id => l_index,
401: p_err_code => 'EGO_INVALID_AG_ID',
402: p_err_message => 'Invalid Attribute Group Id');

Line 406: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

402: p_err_message => 'Invalid Attribute Group Id');
403:
404: ELSE
405:
406: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
407: p_odi_session_id => p_odi_session_id,
408: p_input_id => l_index,
409: p_param_name => 'AttributeGroupName',
410: p_param_value => l_ag_name

Line 413: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

409: p_param_name => 'AttributeGroupName',
410: p_param_value => l_ag_name
411: );
412:
413: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
414: p_odi_session_id => p_odi_session_id,
415: p_input_id => l_index,
416: p_err_code => 'EGO_INVALID_AG_NAME',
417: p_err_message => 'Invalid Attribute Group Name');

Line 484: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

480: SELECT Nvl(Max(INPUT_ID),0) + 1 into p_index
481: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
482: WHERE session_id = p_session_id;
483:
484: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
485: p_odi_session_id => p_odi_session_id,
486: p_input_id => p_index,
487: p_param_name => 'StructureName',
488: p_param_value => l_error_str_name

Line 491: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

487: p_param_name => 'StructureName',
488: p_param_value => l_error_str_name
489: );
490:
491: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
492: p_odi_session_id => p_odi_session_id,
493: p_input_id => p_index,
494: p_err_code => 'EGO_INVALID_STRUCTURE',
495: p_err_message => 'Invalid Structure Name and Org Combination');

Line 567: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

563: /*SELECT Nvl(Max(INPUT_ID),0) + 1 into p_index
564: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
565: WHERE session_id = p_session_id;*/
566:
567: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
568: p_odi_session_id => p_odi_session_id,
569: p_input_id => p_input_index,
570: p_param_name => 'StructureName',
571: p_param_value => l_error_str_name

Line 574: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

570: p_param_name => 'StructureName',
571: p_param_value => l_error_str_name
572: );
573:
574: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
575: p_odi_session_id => p_odi_session_id,
576: p_input_id => p_input_index,
577: p_err_code => 'EGO_INVALID_STRUCTURE',
578: p_err_message => 'Invalid Structure Name for a given Item');

Line 622: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

618: SELECT Nvl(Max(INPUT_ID),0) + 1 into l_index
619: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
620: WHERE session_id = p_session_id;
621:
622: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
623: p_odi_session_id => p_odi_session_id,
624: p_input_id => l_index,
625: p_param_name => 'SecurityGroup',
626: p_param_value => p_sec_grp_name

Line 629: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

625: p_param_name => 'SecurityGroup',
626: p_param_value => p_sec_grp_name
627: );
628:
629: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
630: p_odi_session_id => p_odi_session_id,
631: p_input_id => l_index,
632: p_err_code => 'EGO_INVALID_SECURITY_GROUP',
633: p_err_message => 'Invalid Security Group');

Line 676: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

672: SELECT Nvl(Max(INPUT_ID),0) + 1 into l_index
673: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
674: WHERE session_id = p_session_id;
675:
676: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
677: p_odi_session_id => p_odi_session_id,
678: p_input_id => l_index,
679: p_param_name => 'ResponsibilityApplicationName',
680: p_param_value => p_resp_appl_name

Line 683: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

679: p_param_name => 'ResponsibilityApplicationName',
680: p_param_value => p_resp_appl_name
681: );
682:
683: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
684: p_odi_session_id => p_odi_session_id,
685: p_input_id => l_index,
686: p_err_code => 'EGO_INVALID_RESP_APPL_NAME',
687: p_err_message => 'Invalid Responsibility Application Name');

Line 730: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

726: SELECT Nvl(Max(INPUT_ID),0) + 1 into l_index
727: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
728: WHERE session_id = p_session_id;
729:
730: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
731: p_odi_session_id => p_odi_session_id,
732: p_input_id => l_index,
733: p_param_name => 'ResponsibilityName',
734: p_param_value => p_resp_name

Line 737: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

733: p_param_name => 'ResponsibilityName',
734: p_param_value => p_resp_name
735: );
736:
737: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
738: p_odi_session_id => p_odi_session_id,
739: p_input_id => l_index,
740: p_err_code => 'EGO_INVALID_RESP_NAME',
741: p_err_message => 'Invalid Responsibility Name');

Line 802: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

798:
799:
800: IF l_temp IS NOT NULL THEN
801:
802: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
803: p_odi_session_id => p_odi_session_id,
804: p_input_id => l_index,
805: p_param_name => 'LanguageCode',
806: p_param_value => l_temp

Line 809: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

805: p_param_name => 'LanguageCode',
806: p_param_value => l_temp
807: );
808:
809: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
810: p_odi_session_id => p_odi_session_id,
811: p_input_id => l_index,
812: p_err_code => 'EGO_INVALID_LANGUAGE_CODE',
813: p_err_message => 'Invalid Language Code');

Line 817: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,

813: p_err_message => 'Invalid Language Code');
814:
815: ELSE
816:
817: EGO_ODI_PUB.Populate_Input_Identifier(p_session_id => p_session_id,
818: p_odi_session_id => p_odi_session_id,
819: p_input_id => l_index,
820: p_param_name => 'LanguageName',
821: p_param_value => p_language_name

Line 824: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

820: p_param_name => 'LanguageName',
821: p_param_value => p_language_name
822: );
823:
824: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
825: p_odi_session_id => p_odi_session_id,
826: p_input_id => l_index,
827: p_err_code => 'EGO_INVALID_LANGUAGE_NAME',
828: p_err_message => 'Invalid Language Name');

Line 1264: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

1260: /*INSERT INTO emt_temp (Session_id, message)
1261: values (p_session_id, ' No publish privilege for item: ' || l_item_id);*/
1262:
1263:
1264: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
1265: p_odi_session_id => p_odi_session_id,
1266: p_input_id => l_seq_number,
1267: p_err_code => 'EGO_NO_PUBLISH_PRIV',
1268: p_err_message => 'User does not have the publish privilege for item');

Line 1389: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

1385: WHERE batch_id = l_batch_id AND BATCH_ENTITY_OBJECT_ID = l_batch_ent_obj_id;
1386:
1387: ELSE
1388:
1389: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
1390: p_odi_session_id => p_odi_session_id,
1391: p_input_id => l_seq_number,
1392: p_err_code => 'EGO_NO_PUBLISH_PRIV',
1393: p_err_message => 'User does not have the publilsh privilege on few components of the structure for the item');

Line 1516: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

1512: --TODO: Replace this code with a proper error generation mechanim
1513: --for components
1514: IF TRUE THEN
1515:
1516: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
1517: p_odi_session_id => p_odi_session_id,
1518: p_input_id => l_seq_number,
1519: p_err_code => 'EGO_NO_PUBLISH_PRIV',
1520: p_err_message => 'User does not have the publilsh privilege on few components of the structure for the item');

Line 1670: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,

1666:
1667: /*INSERT INTO emt_temp (Session_id, message)
1668: values (p_session_id, 'components without publish privilege: ' || l_count);
1669: */
1670: EGO_ODI_PUB.Log_Error(p_session_id => p_session_id,
1671: p_odi_session_id => p_odi_session_id,
1672: p_input_id => p_input_identifier,
1673: p_err_code => 'EGO_NO_PUBLISH_PRIV',
1674: p_err_message => 'User does not have the publilsh privilege on few components of the structure for the item');

Line 2392: l_config_option := upper(EGO_ODI_PUB.Get_ODI_Input_Parameter(p_session_id, l_xpath_expr_array(position)));

2388: --and store them in table EGO_PUB_WS_CONFIG
2389: FOR position IN 1..l_parameter_name_array.COUNT
2390: LOOP
2391:
2392: l_config_option := upper(EGO_ODI_PUB.Get_ODI_Input_Parameter(p_session_id, l_xpath_expr_array(position)));
2393:
2394: --if parameter is not provided, assume a default value of 'Y' (Yes)
2395: IF l_config_option IS NULL OR l_config_option = '?' THEN
2396:

Line 7834: END EGO_ODI_PUB;

7830:
7831: END POPULATE_VSTBLINFO_ICCSVC;
7832:
7833:
7834: END EGO_ODI_PUB;