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.EAM_PROCESS_WO_UTIL_PVT dependencies on EAM_PROCESS_WO_PVT

Line 91: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

87: l_status_options BOOLEAN ; --Added for bug 13638082
88: l_asset_cur_org_id NUMBER; --Added for bug 14101354
89:
90: BEGIN
91: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
92: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : Start===============================================================');
93: END IF;
94:
95: -- Standard Start of API savepoint

Line 125: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

121: -- API body
122:
123: -- If PO_DIRECT_DELIVERY_TO_SHOPFLOOR profile option is not set then return immediately with out error status
124: IF ( NVL(fnd_profile.value('PO_DIRECT_DELIVERY_TO_SHOPFLOOR'), 'N') = 'N' ) THEN
125: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
126: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : PO_DIRECT_DELIVERY_TO_SHOPFLOOR profile option is not set. So not creating requisitions.');
127: END IF;
128: return;
129: END IF;

Line 133: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

129: END IF;
130:
131: --bug# 3691325 If requested quantity is less than or equal to zero then return immediately with out error status
132: IF ( NVL(p_quantity,0) <= 0) then
133: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
134: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : Requested Quantity is less than or equal to zero. So not creating requisitions.');
135: END IF;
136: return;
137: END IF;

Line 212: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

208: -- Added for the bug 8363544, the fix of the previous bug fixing
209: -- To get the correct asset number from csi_item_instances for serialized items
210: IF l_maintenance_object_type = 3 THEN
211:
212: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
213: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : Serialized Asset Retrieving info from csi_item_instances');
214: END IF;
215:
216: SELECT serial_number, inventory_item_id, last_vld_organization_id

Line 221: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

217: INTO l_serial_number, l_asset_group_id, l_asset_cur_org_id
218: FROM csi_item_instances
219: WHERE instance_id =l_maintenance_object_id;
220: --changed for the 14101354..Retrieving New org Id if the asset is moved out of current org
221: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
222: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : Checking query variables are null or not : Serial Number:'|| l_serial_number);
223: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : Asset Group Id :' || l_asset_group_id ||' , Organization Id:' || l_organization_id);
224: END IF;
225:

Line 236: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

232: AND meanv.CURRENT_ORGANIZATION_ID = nvl(l_asset_cur_org_id, l_organization_id);
233: --changed for the 14101354
234: --for non serialized items
235: ELSIF l_maintenance_object_type = 2 THEN
236: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
237: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : Non-serialized Asset-Retrieving info from mtl_system_items_b: l_serial_number:'||l_serial_number);
238: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : Asset Group Id:' || l_asset_group_id ||' , Organization Id:' || l_organization_id);
239: END IF;
240:

Line 283: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : inserting into po_requisitions_interface_all ..'); END IF;

279:
280: end if;
281:
282:
283: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : inserting into po_requisitions_interface_all ..'); END IF;
284:
285: /* Changed for MOAC: Insert org_id as well */
286: insert into po_requisitions_interface_all (
287: interface_source_code,

Line 363: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

359: l_ou_id,
360: substrb(l_wip_entity_name, 1, 25) ,
361: l_asset_number||':'||l_DESCRIPTIVE_TEXT||':'||l_ASSET_CRITICALITY||':'||l_priority_meaning
362: );
363: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
364: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : Asset Number Debug: Asset Number: '||l_asset_number||' , Description:'||l_DESCRIPTIVE_TEXT);
365: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : Criticality:'||l_ASSET_CRITICALITY||' , Priority:'||l_priority);
366: END IF;
367:

Line 383: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : Calling the concurrent program ...'); END IF;

379: /* Changes for MOAC */
380: fnd_request.set_org_id (l_ou_id);
381: l_status_options := fnd_request.set_options(datagroup => 'Standard');
382:
383: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : Calling the concurrent program ...'); END IF;
384: SELECT REQIMPORT_GROUP_BY_CODE into l_req_import
385: FROM PO_SYSTEM_PARAMETERS_ALL where ORG_ID=l_ou_id; -- Changed for bug 6837105
386: l_request_id := fnd_request.submit_request(
387: 'PO', 'REQIMPORT', NULL, NULL, FALSE,'EAM', NULL, l_req_import,

Line 415: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

411: p_encoded => fnd_api.g_false
412: ,p_count => x_msg_count
413: ,p_data => x_msg_data);
414:
415: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
416: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : Concurrent program finished Status : '||x_return_status||' End =========================');
417: END IF;
418: return;
419:

Line 579: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel : Start ==========================================================='); END IF;

575: x_return_status := fnd_api.g_ret_sts_success;
576:
577: l_stmt_num := 50;
578:
579: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel : Start ==========================================================='); END IF;
580:
581: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel:PROFILE : EAM: Trigger requisition for cancelled quantity : '||FND_PROFILE.VALUE('EAM_TRIGGER_REQ_CANCEL_QTY')); END IF;
582:
583: l_req_for_cancel_qty_profile := NVL(FND_PROFILE.VALUE('EAM_TRIGGER_REQ_CANCEL_QTY'),'Y'); --bug 13102446

Line 581: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel:PROFILE : EAM: Trigger requisition for cancelled quantity : '||FND_PROFILE.VALUE('EAM_TRIGGER_REQ_CANCEL_QTY')); END IF;

577: l_stmt_num := 50;
578:
579: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel : Start ==========================================================='); END IF;
580:
581: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel:PROFILE : EAM: Trigger requisition for cancelled quantity : '||FND_PROFILE.VALUE('EAM_TRIGGER_REQ_CANCEL_QTY')); END IF;
582:
583: l_req_for_cancel_qty_profile := NVL(FND_PROFILE.VALUE('EAM_TRIGGER_REQ_CANCEL_QTY'),'Y'); --bug 13102446
584:
585: FOR l_di_record in l_di_recs

Line 833: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

829: END IF; --IF(l_req_for_cancel_qty_profile = 'Y') then
830:
831: END IF; -- IF l_di_record.direct_item_type_id = 1
832:
833: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
834: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel : DirectItemType(1:Description/2:Non-Stock) : '||l_di_record.direct_item_type_id||', Description: '||l_description);
835: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel : WipentityId : '||l_di_record.wip_entity_id||', Operation : '||l_di_record.task_number);
836: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel : Inv Item Id : '||l_di_record.inventory_item_id||', Direct Item Seq Id: '||l_di_record.direct_item_sequence_id);
837: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel : UOM : '||l_di_record.uom_code||', Unit Price : '||l_di_record.unit_price);

Line 873: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

869:
870:
871: if nvl(l_api_return_status,'Q') <> 'S' then
872: x_return_status := fnd_api.g_ret_sts_error;
873: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
874: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel : Creating reqs for the above direct item finished with status '||l_api_return_status);
875: END IF;
876:
877: end if;

Line 883: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel : End=============================================================='); END IF;

879: end if;
880:
881: END LOOP;
882:
883: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel : End=============================================================='); END IF;
884:
885:
886: EXCEPTION
887:

Line 896: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

892: declare
893: l_text varchar2(1000);
894: begin
895: l_text := sqlerrm;
896: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
897: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_wo_rel : Creating reqs for direct items Error: , sqlerrm='||substrb(l_text,1,200));
898: END IF;
899: end;
900:

Line 960: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_di_upd : Start========================================'); END IF;

956: l_di_recs l_di_recs_type;
957: l_di_record l_di_recs%ROWTYPE;
958:
959: BEGIN
960: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_di_upd : Start========================================'); END IF;
961: -- Standard Start of API savepoint
962: l_stmt_num := 10;
963: SAVEPOINT create_requisition_pvt;
964:

Line 993: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_di_upd : Description Direct Item Update'); END IF;

989: IF NOT l_di_recs%ISOPEN THEN
990:
991: IF p_direct_item_sequence_id is not null then
992:
993: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_di_upd : Description Direct Item Update'); END IF;
994:
995: OPEN l_di_recs FOR
996: SELECT wip_entity_id,
997: organization_id,

Line 1021: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_di_upd : Non-Stock Direct Item Update'); END IF;

1017: AND direct_item_sequence_id = p_direct_item_sequence_id;
1018:
1019: ELSIF p_inventory_item_id is not null then
1020:
1021: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_di_upd : Non-Stock Direct Item Update'); END IF;
1022:
1023: OPEN l_di_recs FOR
1024: SELECT wro.wip_entity_id,
1025: wro.organization_id,

Line 1068: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

1064:
1065: if l_di_record.wip_entity_id is not null
1066: and l_di_record.auto_request_material = 'Y' then
1067:
1068: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
1069: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_di_upd : Direct Item Type(1:Description Direct /2:Non-Stock Direct ) : '||l_di_record.direct_item_type_id);
1070: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_di_upd : WipentityId: '||l_di_record.wip_entity_id||' Operation : '||l_di_record.task_number);
1071: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_di_upd : Inv Item Id: '||l_di_record.inventory_item_id||' Dir Item Seq id: '||l_di_record.direct_item_sequence_id);
1072: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_di_upd : UOM : '||l_di_record.uom_code||' Unit Price : '||l_di_record.unit_price);

Line 1107: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_di_upd : create_requisition return status : '||l_api_return_status); END IF;

1103:
1104:
1105: if nvl(l_api_return_status,'Q') <> 'S' then
1106: x_return_status := fnd_api.g_ret_sts_error;
1107: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_di_upd : create_requisition return status : '||l_api_return_status); END IF;
1108:
1109: end if;
1110:
1111: end if;

Line 1116: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_di_upd : End================================================='); END IF;

1112:
1113: END LOOP;
1114: CLOSE l_di_recs;
1115:
1116: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_di_upd : End================================================='); END IF;
1117:
1118: EXCEPTION
1119:
1120: when others then

Line 1128: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

1124: declare
1125: l_text varchar2(1000);
1126: begin
1127: l_text := sqlerrm;
1128: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
1129: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_reqs_at_di_upd : Creating reqs for direct items Error: , sqlerrm='||substrb(l_text,1,200));
1130: END IF;
1131: end;
1132: END create_reqs_at_di_upd;