317: ELSIF p_event_class_rec.event_type_code = 'PO_PA_ADJUSTED' THEN
318: lv_action := JAI_CONSTANTS.updating;
319: END IF;
320: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
321: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.process_po with trx_id ' || p_event_class_rec.trx_id ||', action:'||lv_action);
322: end if;
323: jai_po_proc_pkg.process_po(p_event_class_rec.trx_id, lv_action);
324:
325: ELSIF p_event_class_rec.entity_code = 'RELEASE'
319: END IF;
320: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
321: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.process_po with trx_id ' || p_event_class_rec.trx_id ||', action:'||lv_action);
322: end if;
323: jai_po_proc_pkg.process_po(p_event_class_rec.trx_id, lv_action);
324:
325: ELSIF p_event_class_rec.entity_code = 'RELEASE'
326: AND p_event_class_rec.event_class_code = 'RELEASE'
327: AND p_event_class_rec.event_type_code IN ('RELEASE_CREATED','RELEASE_ADJUSTED')
331: ELSIF p_event_class_rec.event_type_code = 'RELEASE_ADJUSTED' THEN
332: lv_action := JAI_CONSTANTS.updating;
333: END IF;
334: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
335: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.process_release with trx_id ' || p_event_class_rec.trx_id ||', action:'||lv_action);
336: end if;
337: jai_po_proc_pkg.process_release(p_event_class_rec.trx_id, lv_action);
338: ELSIF p_event_class_rec.entity_code = 'REQUISITION'
339: AND p_event_class_rec.event_class_code = 'REQUISITION'
333: END IF;
334: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
335: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.process_release with trx_id ' || p_event_class_rec.trx_id ||', action:'||lv_action);
336: end if;
337: jai_po_proc_pkg.process_release(p_event_class_rec.trx_id, lv_action);
338: ELSIF p_event_class_rec.entity_code = 'REQUISITION'
339: AND p_event_class_rec.event_class_code = 'REQUISITION'
340: AND p_event_class_rec.event_type_code IN ('REQ_CREATED') THEN
341: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
338: ELSIF p_event_class_rec.entity_code = 'REQUISITION'
339: AND p_event_class_rec.event_class_code = 'REQUISITION'
340: AND p_event_class_rec.event_type_code IN ('REQ_CREATED') THEN
341: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
342: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.process_requisition with trx_id ' || p_event_class_rec.trx_id );
343: end if;
344:
345: jai_po_proc_pkg.process_requisition(p_event_class_rec.trx_id);
346: END IF;
341: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
342: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.process_requisition with trx_id ' || p_event_class_rec.trx_id );
343: end if;
344:
345: jai_po_proc_pkg.process_requisition(p_event_class_rec.trx_id);
346: END IF;
347: ELSIF p_transaction_rec.application_id = 201 THEN--Indicates PO Module
348: IF p_transaction_rec.entity_code = 'PURCHASE_ORDER'AND p_transaction_rec.event_class_code = 'PO_PA' THEN
349: IF p_transaction_rec.event_type_code IN( 'PO_PA_ADJUSTED') THEN
347: ELSIF p_transaction_rec.application_id = 201 THEN--Indicates PO Module
348: IF p_transaction_rec.entity_code = 'PURCHASE_ORDER'AND p_transaction_rec.event_class_code = 'PO_PA' THEN
349: IF p_transaction_rec.event_type_code IN( 'PO_PA_ADJUSTED') THEN
350: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
351: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.delete_po_taxes and delete_jai_po_lines with p_trx_line_id ' || p_trx_line_id );
352: end if;
353: jai_po_proc_pkg.delete_po_taxes(pn_line_loc_id => p_trx_line_id );
354: jai_po_proc_pkg.delete_jai_po_lines(pn_line_loc_id => p_trx_line_id);
355: ELSIF p_transaction_rec.event_type_code IN( 'PO_PA_CANCELLED') THEN
349: IF p_transaction_rec.event_type_code IN( 'PO_PA_ADJUSTED') THEN
350: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
351: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.delete_po_taxes and delete_jai_po_lines with p_trx_line_id ' || p_trx_line_id );
352: end if;
353: jai_po_proc_pkg.delete_po_taxes(pn_line_loc_id => p_trx_line_id );
354: jai_po_proc_pkg.delete_jai_po_lines(pn_line_loc_id => p_trx_line_id);
355: ELSIF p_transaction_rec.event_type_code IN( 'PO_PA_CANCELLED') THEN
356: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
357: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.cancel_po with TRX_ID' || p_transaction_rec.TRX_ID );
350: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
351: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.delete_po_taxes and delete_jai_po_lines with p_trx_line_id ' || p_trx_line_id );
352: end if;
353: jai_po_proc_pkg.delete_po_taxes(pn_line_loc_id => p_trx_line_id );
354: jai_po_proc_pkg.delete_jai_po_lines(pn_line_loc_id => p_trx_line_id);
355: ELSIF p_transaction_rec.event_type_code IN( 'PO_PA_CANCELLED') THEN
356: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
357: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.cancel_po with TRX_ID' || p_transaction_rec.TRX_ID );
358: end if;
353: jai_po_proc_pkg.delete_po_taxes(pn_line_loc_id => p_trx_line_id );
354: jai_po_proc_pkg.delete_jai_po_lines(pn_line_loc_id => p_trx_line_id);
355: ELSIF p_transaction_rec.event_type_code IN( 'PO_PA_CANCELLED') THEN
356: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
357: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.cancel_po with TRX_ID' || p_transaction_rec.TRX_ID );
358: end if;
359: jai_po_proc_pkg.cancel_po(p_transaction_rec.TRX_ID);
360: END IF;
361:
355: ELSIF p_transaction_rec.event_type_code IN( 'PO_PA_CANCELLED') THEN
356: if ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
357: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, 'Call jai_po_proc_pkg.cancel_po with TRX_ID' || p_transaction_rec.TRX_ID );
358: end if;
359: jai_po_proc_pkg.cancel_po(p_transaction_rec.TRX_ID);
360: END IF;
361:
362: END IF;
363: