DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_UTIL_PVT dependencies on EAM_ERROR_MESSAGE_PVT

Line 115: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('PO_DIRECT_DELIVERY_TO_SHOPFLOOR profile option is not set. So not creating requisitions.'); END IF;

111: -- API body
112:
113: -- If PO_DIRECT_DELIVERY_TO_SHOPFLOOR profile option is not set then return immediately with out error status
114: IF ( NVL(fnd_profile.value('PO_DIRECT_DELIVERY_TO_SHOPFLOOR'), 'N') = 'N' ) THEN
115: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('PO_DIRECT_DELIVERY_TO_SHOPFLOOR profile option is not set. So not creating requisitions.'); END IF;
116: return;
117: END IF;
118:
119: --bug# 3691325 If requested quantity is less than or equal to zero then return immediately with out error status

Line 121: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Requested Quantity is less than or equal to zero. So not creating requisitions.'); END IF;

117: END IF;
118:
119: --bug# 3691325 If requested quantity is less than or equal to zero then return immediately with out error status
120: IF ( NVL(p_quantity,0) <= 0) then
121: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Requested Quantity is less than or equal to zero. So not creating requisitions.'); END IF;
122: return;
123: END IF;
124:
125: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Start of create_requisition'); END IF;

Line 125: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Start of create_requisition'); END IF;

121: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Requested Quantity is less than or equal to zero. So not creating requisitions.'); END IF;
122: return;
123: END IF;
124:
125: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Start of create_requisition'); END IF;
126:
127: if (p_user_id is not null) then
128:
129: select employee_id

Line 195: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside create_requisitions : inserting into po_requisitions_interface_all ..'); END IF;

191:
192: end if;
193:
194:
195: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside create_requisitions : inserting into po_requisitions_interface_all ..'); END IF;
196:
197: /* Changed for MOAC: Insert org_id as well */
198: insert into po_requisitions_interface_all (
199: interface_source_code,

Line 273: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Asset Number Debug:- '||l_asset_number||':'||l_DESCRIPTIVE_TEXT||':'||l_ASSET_CRITICALITY||':'||l_priority); END IF;

269: l_ou_id,
270: substrb(l_wip_entity_name, 1, 25) ,
271: l_asset_number||':'||l_DESCRIPTIVE_TEXT||':'||l_ASSET_CRITICALITY||':'||l_priority_meaning
272: );
273: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Asset Number Debug:- '||l_asset_number||':'||l_DESCRIPTIVE_TEXT||':'||l_ASSET_CRITICALITY||':'||l_priority); END IF;
274:
275:
276: l_str_application_id := fnd_profile.value('RESP_APPL_ID');
277:

Line 290: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside create_requisitions. Calling the concurrent program ...'); END IF;

286:
287: /* Changes for MOAC */
288: fnd_request.set_org_id (l_ou_id);
289:
290: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside create_requisitions. Calling the concurrent program ...'); END IF;
291: SELECT REQIMPORT_GROUP_BY_CODE into l_req_import
292: FROM PO_SYSTEM_PARAMETERS_ALL where ORG_ID=l_ou_id; -- Changed for bug 6837105
293: l_request_id := fnd_request.submit_request(
294: 'PO', 'REQIMPORT', NULL, NULL, FALSE,'EAM', NULL, l_req_import,

Line 321: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside create_requisitions. concurrent program finished ...'); END IF;

317: fnd_msg_pub.count_and_get(
318: p_encoded => fnd_api.g_false
319: ,p_count => x_msg_count
320: ,p_data => x_msg_data);
321: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside create_requisitions. concurrent program finished ...'); END IF;
322:
323: return;
324:
325:

Line 483: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Start of create_reqs_at_wo_rel'); END IF;

479: x_return_status := fnd_api.g_ret_sts_success;
480:
481: l_stmt_num := 50;
482:
483: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Start of create_reqs_at_wo_rel'); END IF;
484:
485: FOR l_di_record in l_di_recs
486: LOOP
487:

Line 590: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('creating reqs for di seq finished with status '||l_api_return_status); END IF;

586: ,p_suggested_vendor_phone => l_di_record.suggested_vendor_phone
587: ,p_suggested_vendor_item_num => l_di_record.suggested_vendor_item_num);
588:
589:
590: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('creating reqs for di seq finished with status '||l_api_return_status); END IF;
591:
592: if nvl(l_api_return_status,'Q') <> 'S' then
593: x_return_status := fnd_api.g_ret_sts_error;
594: end if;

Line 600: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('End of create_reqs_at_wo_rel'); END IF;

596: end if;
597:
598: END LOOP;
599:
600: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('End of create_reqs_at_wo_rel'); END IF;
601:
602:
603: EXCEPTION
604:

Line 613: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('creating reqs for di seq , sqlerrm='||substrb(l_text,1,200)); END IF;

609: declare
610: l_text varchar2(1000);
611: begin
612: l_text := sqlerrm;
613: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('creating reqs for di seq , sqlerrm='||substrb(l_text,1,200)); END IF;
614: end;
615:
616: END create_reqs_at_wo_rel;
617: