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.PO_REQCHANGEREQUESTWF_PVT dependencies on PO_DEBUG

Line 9: g_debug_stmt CONSTANT BOOLEAN := po_debug.is_debug_stmt_on;

5: -- Read the profile option that enables/disables the debug log
6: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
7: g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
8: -- Debugging
9: g_debug_stmt CONSTANT BOOLEAN := po_debug.is_debug_stmt_on;
10: g_debug_unexp CONSTANT BOOLEAN := po_debug.is_debug_unexp_on;
11: --Bug#3497033
12: --g_currency_format_mask declared to pass in as the second parameter
13: --in FND_CURRENCY.GET_FORMAT_MASK

Line 10: g_debug_unexp CONSTANT BOOLEAN := po_debug.is_debug_unexp_on;

6: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
7: g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
8: -- Debugging
9: g_debug_stmt CONSTANT BOOLEAN := po_debug.is_debug_stmt_on;
10: g_debug_unexp CONSTANT BOOLEAN := po_debug.is_debug_unexp_on;
11: --Bug#3497033
12: --g_currency_format_mask declared to pass in as the second parameter
13: --in FND_CURRENCY.GET_FORMAT_MASK
14: g_currency_format_mask NUMBER := 60;

Line 11850: po_debug.debug_var(l_log_head,l_progress,'p_req_header_id',p_req_header_id );

11846: -- End standard API initialization
11847: l_progress := '001';
11848:
11849: IF g_debug_stmt THEN
11850: po_debug.debug_var(l_log_head,l_progress,'p_req_header_id',p_req_header_id );
11851: po_debug.debug_var(l_log_head,l_progress,'p_initiator',p_initiator);
11852: po_debug.debug_stmt(l_log_head, l_progress,'Placing the Sales order on hold');
11853: END IF;
11854:

Line 11851: po_debug.debug_var(l_log_head,l_progress,'p_initiator',p_initiator);

11847: l_progress := '001';
11848:
11849: IF g_debug_stmt THEN
11850: po_debug.debug_var(l_log_head,l_progress,'p_req_header_id',p_req_header_id );
11851: po_debug.debug_var(l_log_head,l_progress,'p_initiator',p_initiator);
11852: po_debug.debug_stmt(l_log_head, l_progress,'Placing the Sales order on hold');
11853: END IF;
11854:
11855:

Line 11852: po_debug.debug_stmt(l_log_head, l_progress,'Placing the Sales order on hold');

11848:
11849: IF g_debug_stmt THEN
11850: po_debug.debug_var(l_log_head,l_progress,'p_req_header_id',p_req_header_id );
11851: po_debug.debug_var(l_log_head,l_progress,'p_initiator',p_initiator);
11852: po_debug.debug_stmt(l_log_head, l_progress,'Placing the Sales order on hold');
11853: END IF;
11854:
11855:
11856: l_progress := '002';

Line 11887: po_debug.debug_var(l_log_head, l_progress, 'Sales order l_orgid', l_orgid);

11883: -- need to appli req line level hold
11884: l_orgid := get_sales_order_org(p_req_line_id => l_line_id);
11885:
11886: IF g_debug_stmt THEN
11887: po_debug.debug_var(l_log_head, l_progress, 'Sales order l_orgid', l_orgid);
11888: END IF;
11889:
11890:
11891: IF l_orgid is NOT NULL THEN

Line 11908: po_debug.debug_var(l_log_head, l_progress, 'Requisition l_orgid', l_orgid);

11904: CLOSE req_line_id_chn_csr;
11905:
11906: l_orgid := get_requisition_org( p_req_hdr_id => p_req_header_id);
11907: IF g_debug_stmt THEN
11908: po_debug.debug_var(l_log_head, l_progress, 'Requisition l_orgid', l_orgid);
11909: END IF;
11910:
11911: IF l_orgid is NOT NULL THEN
11912: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

Line 11916: po_debug.debug_var(l_log_head,l_progress,'p_item_key',p_item_key );

11912: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
11913: END IF;
11914:
11915: IF g_debug_stmt THEN
11916: po_debug.debug_var(l_log_head,l_progress,'p_item_key',p_item_key );
11917: po_debug.debug_var(l_log_head,l_progress,'l_change_request_group_id',l_change_request_group_id);
11918: po_debug.debug_var(l_log_head,l_progress,'l_preparer_id',l_preparer_id );
11919: po_debug.debug_var(l_log_head,l_progress,'p_document_subtype',p_document_subtype );
11920: po_debug.debug_var(l_log_head,l_progress,'l_change_request_group_id',l_change_request_group_id);

Line 11917: po_debug.debug_var(l_log_head,l_progress,'l_change_request_group_id',l_change_request_group_id);

11913: END IF;
11914:
11915: IF g_debug_stmt THEN
11916: po_debug.debug_var(l_log_head,l_progress,'p_item_key',p_item_key );
11917: po_debug.debug_var(l_log_head,l_progress,'l_change_request_group_id',l_change_request_group_id);
11918: po_debug.debug_var(l_log_head,l_progress,'l_preparer_id',l_preparer_id );
11919: po_debug.debug_var(l_log_head,l_progress,'p_document_subtype',p_document_subtype );
11920: po_debug.debug_var(l_log_head,l_progress,'l_change_request_group_id',l_change_request_group_id);
11921: po_debug.debug_var(l_log_head,l_progress,'l_req_num',l_req_num );

Line 11918: po_debug.debug_var(l_log_head,l_progress,'l_preparer_id',l_preparer_id );

11914:
11915: IF g_debug_stmt THEN
11916: po_debug.debug_var(l_log_head,l_progress,'p_item_key',p_item_key );
11917: po_debug.debug_var(l_log_head,l_progress,'l_change_request_group_id',l_change_request_group_id);
11918: po_debug.debug_var(l_log_head,l_progress,'l_preparer_id',l_preparer_id );
11919: po_debug.debug_var(l_log_head,l_progress,'p_document_subtype',p_document_subtype );
11920: po_debug.debug_var(l_log_head,l_progress,'l_change_request_group_id',l_change_request_group_id);
11921: po_debug.debug_var(l_log_head,l_progress,'l_req_num',l_req_num );
11922: po_debug.debug_stmt(l_log_head, l_progress,'Starting POREQCHA workflow');

Line 11919: po_debug.debug_var(l_log_head,l_progress,'p_document_subtype',p_document_subtype );

11915: IF g_debug_stmt THEN
11916: po_debug.debug_var(l_log_head,l_progress,'p_item_key',p_item_key );
11917: po_debug.debug_var(l_log_head,l_progress,'l_change_request_group_id',l_change_request_group_id);
11918: po_debug.debug_var(l_log_head,l_progress,'l_preparer_id',l_preparer_id );
11919: po_debug.debug_var(l_log_head,l_progress,'p_document_subtype',p_document_subtype );
11920: po_debug.debug_var(l_log_head,l_progress,'l_change_request_group_id',l_change_request_group_id);
11921: po_debug.debug_var(l_log_head,l_progress,'l_req_num',l_req_num );
11922: po_debug.debug_stmt(l_log_head, l_progress,'Starting POREQCHA workflow');
11923: END IF;

Line 11920: po_debug.debug_var(l_log_head,l_progress,'l_change_request_group_id',l_change_request_group_id);

11916: po_debug.debug_var(l_log_head,l_progress,'p_item_key',p_item_key );
11917: po_debug.debug_var(l_log_head,l_progress,'l_change_request_group_id',l_change_request_group_id);
11918: po_debug.debug_var(l_log_head,l_progress,'l_preparer_id',l_preparer_id );
11919: po_debug.debug_var(l_log_head,l_progress,'p_document_subtype',p_document_subtype );
11920: po_debug.debug_var(l_log_head,l_progress,'l_change_request_group_id',l_change_request_group_id);
11921: po_debug.debug_var(l_log_head,l_progress,'l_req_num',l_req_num );
11922: po_debug.debug_stmt(l_log_head, l_progress,'Starting POREQCHA workflow');
11923: END IF;
11924:

Line 11921: po_debug.debug_var(l_log_head,l_progress,'l_req_num',l_req_num );

11917: po_debug.debug_var(l_log_head,l_progress,'l_change_request_group_id',l_change_request_group_id);
11918: po_debug.debug_var(l_log_head,l_progress,'l_preparer_id',l_preparer_id );
11919: po_debug.debug_var(l_log_head,l_progress,'p_document_subtype',p_document_subtype );
11920: po_debug.debug_var(l_log_head,l_progress,'l_change_request_group_id',l_change_request_group_id);
11921: po_debug.debug_var(l_log_head,l_progress,'l_req_num',l_req_num );
11922: po_debug.debug_stmt(l_log_head, l_progress,'Starting POREQCHA workflow');
11923: END IF;
11924:
11925: po_reqapproval_init1.start_wf_process(

Line 11922: po_debug.debug_stmt(l_log_head, l_progress,'Starting POREQCHA workflow');

11918: po_debug.debug_var(l_log_head,l_progress,'l_preparer_id',l_preparer_id );
11919: po_debug.debug_var(l_log_head,l_progress,'p_document_subtype',p_document_subtype );
11920: po_debug.debug_var(l_log_head,l_progress,'l_change_request_group_id',l_change_request_group_id);
11921: po_debug.debug_var(l_log_head,l_progress,'l_req_num',l_req_num );
11922: po_debug.debug_stmt(l_log_head, l_progress,'Starting POREQCHA workflow');
11923: END IF;
11924:
11925: po_reqapproval_init1.start_wf_process(
11926: itemtype => p_item_type,

Line 11950: po_debug.debug_stmt(l_log_head, l_progress,'ending submit_internal_req_change');

11946: END IF;
11947:
11948: l_progress := '004';
11949: IF g_debug_stmt THEN
11950: po_debug.debug_stmt(l_log_head, l_progress,'ending submit_internal_req_change');
11951: END IF;
11952: EXCEPTION
11953: WHEN fnd_api.g_exc_unexpected_error THEN
11954: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 12050: po_debug.debug_var(l_log_head, x_progress, 'Sales order l_orgid', l_orgid);

12046:
12047: l_orgid := get_sales_order_org(p_req_line_id => l_document_line_id);
12048:
12049: IF g_debug_stmt THEN
12050: po_debug.debug_var(l_log_head, x_progress, 'Sales order l_orgid', l_orgid);
12051: END IF;
12052:
12053:
12054: IF l_orgid is NOT NULL THEN

Line 12069: po_debug.debug_var(l_log_head, x_progress, 'Requisition l_orgid', l_orgid);

12065: , X_return_status => l_return_status
12066: );
12067: l_orgid := get_requisition_org( p_req_hdr_id => l_document_header_id);
12068: IF g_debug_stmt THEN
12069: po_debug.debug_var(l_log_head, x_progress, 'Requisition l_orgid', l_orgid);
12070: END IF;
12071:
12072: IF l_orgid is NOT NULL THEN
12073: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

Line 12189: po_debug.debug_begin(l_log_head);

12185: */
12186: SAVEPOINT convertintosochange_sp;
12187: l_progress := '001';
12188: IF g_debug_stmt THEN
12189: po_debug.debug_begin(l_log_head);
12190: po_debug.debug_var(l_log_head, l_progress, 'p_chn_request_group_id', p_chn_request_group_id);
12191: po_debug.debug_var(l_log_head, l_progress, 'p_document_header_id', p_document_header_id);
12192: po_debug.debug_var(l_log_head, l_progress, 'p_document_line_id', p_document_line_id);
12193: po_debug.debug_var(l_log_head, l_progress, 'p_document_num', p_document_num);

Line 12190: po_debug.debug_var(l_log_head, l_progress, 'p_chn_request_group_id', p_chn_request_group_id);

12186: SAVEPOINT convertintosochange_sp;
12187: l_progress := '001';
12188: IF g_debug_stmt THEN
12189: po_debug.debug_begin(l_log_head);
12190: po_debug.debug_var(l_log_head, l_progress, 'p_chn_request_group_id', p_chn_request_group_id);
12191: po_debug.debug_var(l_log_head, l_progress, 'p_document_header_id', p_document_header_id);
12192: po_debug.debug_var(l_log_head, l_progress, 'p_document_line_id', p_document_line_id);
12193: po_debug.debug_var(l_log_head, l_progress, 'p_document_num', p_document_num);
12194: po_debug.debug_var(l_log_head, l_progress, 'p_old_quantity', p_old_quantity);

Line 12191: po_debug.debug_var(l_log_head, l_progress, 'p_document_header_id', p_document_header_id);

12187: l_progress := '001';
12188: IF g_debug_stmt THEN
12189: po_debug.debug_begin(l_log_head);
12190: po_debug.debug_var(l_log_head, l_progress, 'p_chn_request_group_id', p_chn_request_group_id);
12191: po_debug.debug_var(l_log_head, l_progress, 'p_document_header_id', p_document_header_id);
12192: po_debug.debug_var(l_log_head, l_progress, 'p_document_line_id', p_document_line_id);
12193: po_debug.debug_var(l_log_head, l_progress, 'p_document_num', p_document_num);
12194: po_debug.debug_var(l_log_head, l_progress, 'p_old_quantity', p_old_quantity);
12195: po_debug.debug_var(l_log_head, l_progress, 'p_new_quantity', p_new_quantity);

Line 12192: po_debug.debug_var(l_log_head, l_progress, 'p_document_line_id', p_document_line_id);

12188: IF g_debug_stmt THEN
12189: po_debug.debug_begin(l_log_head);
12190: po_debug.debug_var(l_log_head, l_progress, 'p_chn_request_group_id', p_chn_request_group_id);
12191: po_debug.debug_var(l_log_head, l_progress, 'p_document_header_id', p_document_header_id);
12192: po_debug.debug_var(l_log_head, l_progress, 'p_document_line_id', p_document_line_id);
12193: po_debug.debug_var(l_log_head, l_progress, 'p_document_num', p_document_num);
12194: po_debug.debug_var(l_log_head, l_progress, 'p_old_quantity', p_old_quantity);
12195: po_debug.debug_var(l_log_head, l_progress, 'p_new_quantity', p_new_quantity);
12196: po_debug.debug_var(l_log_head, l_progress, 'p_old_need_by_date', p_old_need_by_date);

Line 12193: po_debug.debug_var(l_log_head, l_progress, 'p_document_num', p_document_num);

12189: po_debug.debug_begin(l_log_head);
12190: po_debug.debug_var(l_log_head, l_progress, 'p_chn_request_group_id', p_chn_request_group_id);
12191: po_debug.debug_var(l_log_head, l_progress, 'p_document_header_id', p_document_header_id);
12192: po_debug.debug_var(l_log_head, l_progress, 'p_document_line_id', p_document_line_id);
12193: po_debug.debug_var(l_log_head, l_progress, 'p_document_num', p_document_num);
12194: po_debug.debug_var(l_log_head, l_progress, 'p_old_quantity', p_old_quantity);
12195: po_debug.debug_var(l_log_head, l_progress, 'p_new_quantity', p_new_quantity);
12196: po_debug.debug_var(l_log_head, l_progress, 'p_old_need_by_date', p_old_need_by_date);
12197: po_debug.debug_var(l_log_head, l_progress, 'p_new_need_by_date', p_new_need_by_date);

Line 12194: po_debug.debug_var(l_log_head, l_progress, 'p_old_quantity', p_old_quantity);

12190: po_debug.debug_var(l_log_head, l_progress, 'p_chn_request_group_id', p_chn_request_group_id);
12191: po_debug.debug_var(l_log_head, l_progress, 'p_document_header_id', p_document_header_id);
12192: po_debug.debug_var(l_log_head, l_progress, 'p_document_line_id', p_document_line_id);
12193: po_debug.debug_var(l_log_head, l_progress, 'p_document_num', p_document_num);
12194: po_debug.debug_var(l_log_head, l_progress, 'p_old_quantity', p_old_quantity);
12195: po_debug.debug_var(l_log_head, l_progress, 'p_new_quantity', p_new_quantity);
12196: po_debug.debug_var(l_log_head, l_progress, 'p_old_need_by_date', p_old_need_by_date);
12197: po_debug.debug_var(l_log_head, l_progress, 'p_new_need_by_date', p_new_need_by_date);
12198: po_debug.debug_var(l_log_head, l_progress, 'p_action_type', p_action_type);

Line 12195: po_debug.debug_var(l_log_head, l_progress, 'p_new_quantity', p_new_quantity);

12191: po_debug.debug_var(l_log_head, l_progress, 'p_document_header_id', p_document_header_id);
12192: po_debug.debug_var(l_log_head, l_progress, 'p_document_line_id', p_document_line_id);
12193: po_debug.debug_var(l_log_head, l_progress, 'p_document_num', p_document_num);
12194: po_debug.debug_var(l_log_head, l_progress, 'p_old_quantity', p_old_quantity);
12195: po_debug.debug_var(l_log_head, l_progress, 'p_new_quantity', p_new_quantity);
12196: po_debug.debug_var(l_log_head, l_progress, 'p_old_need_by_date', p_old_need_by_date);
12197: po_debug.debug_var(l_log_head, l_progress, 'p_new_need_by_date', p_new_need_by_date);
12198: po_debug.debug_var(l_log_head, l_progress, 'p_action_type', p_action_type);
12199: po_debug.debug_var(l_log_head, l_progress, 'p_mode', p_mode);

Line 12196: po_debug.debug_var(l_log_head, l_progress, 'p_old_need_by_date', p_old_need_by_date);

12192: po_debug.debug_var(l_log_head, l_progress, 'p_document_line_id', p_document_line_id);
12193: po_debug.debug_var(l_log_head, l_progress, 'p_document_num', p_document_num);
12194: po_debug.debug_var(l_log_head, l_progress, 'p_old_quantity', p_old_quantity);
12195: po_debug.debug_var(l_log_head, l_progress, 'p_new_quantity', p_new_quantity);
12196: po_debug.debug_var(l_log_head, l_progress, 'p_old_need_by_date', p_old_need_by_date);
12197: po_debug.debug_var(l_log_head, l_progress, 'p_new_need_by_date', p_new_need_by_date);
12198: po_debug.debug_var(l_log_head, l_progress, 'p_action_type', p_action_type);
12199: po_debug.debug_var(l_log_head, l_progress, 'p_mode', p_mode);
12200: END IF;

Line 12197: po_debug.debug_var(l_log_head, l_progress, 'p_new_need_by_date', p_new_need_by_date);

12193: po_debug.debug_var(l_log_head, l_progress, 'p_document_num', p_document_num);
12194: po_debug.debug_var(l_log_head, l_progress, 'p_old_quantity', p_old_quantity);
12195: po_debug.debug_var(l_log_head, l_progress, 'p_new_quantity', p_new_quantity);
12196: po_debug.debug_var(l_log_head, l_progress, 'p_old_need_by_date', p_old_need_by_date);
12197: po_debug.debug_var(l_log_head, l_progress, 'p_new_need_by_date', p_new_need_by_date);
12198: po_debug.debug_var(l_log_head, l_progress, 'p_action_type', p_action_type);
12199: po_debug.debug_var(l_log_head, l_progress, 'p_mode', p_mode);
12200: END IF;
12201:

Line 12198: po_debug.debug_var(l_log_head, l_progress, 'p_action_type', p_action_type);

12194: po_debug.debug_var(l_log_head, l_progress, 'p_old_quantity', p_old_quantity);
12195: po_debug.debug_var(l_log_head, l_progress, 'p_new_quantity', p_new_quantity);
12196: po_debug.debug_var(l_log_head, l_progress, 'p_old_need_by_date', p_old_need_by_date);
12197: po_debug.debug_var(l_log_head, l_progress, 'p_new_need_by_date', p_new_need_by_date);
12198: po_debug.debug_var(l_log_head, l_progress, 'p_action_type', p_action_type);
12199: po_debug.debug_var(l_log_head, l_progress, 'p_mode', p_mode);
12200: END IF;
12201:
12202: --calling the OM API for hold if called from reqschedule program

Line 12199: po_debug.debug_var(l_log_head, l_progress, 'p_mode', p_mode);

12195: po_debug.debug_var(l_log_head, l_progress, 'p_new_quantity', p_new_quantity);
12196: po_debug.debug_var(l_log_head, l_progress, 'p_old_need_by_date', p_old_need_by_date);
12197: po_debug.debug_var(l_log_head, l_progress, 'p_new_need_by_date', p_new_need_by_date);
12198: po_debug.debug_var(l_log_head, l_progress, 'p_action_type', p_action_type);
12199: po_debug.debug_var(l_log_head, l_progress, 'p_mode', p_mode);
12200: END IF;
12201:
12202: --calling the OM API for hold if called from reqschedule program
12203:

Line 12242: po_debug.debug_var(l_log_head, l_progress, 'Sales order l_orgid', l_orgid);

12238: --release the OM LINE FROM HOLD call OM_API
12239:
12240: l_orgid := get_sales_order_org(p_req_line_id => p_document_line_id);
12241: IF g_debug_stmt THEN
12242: po_debug.debug_var(l_log_head, l_progress, 'Sales order l_orgid', l_orgid);
12243: END IF;
12244:
12245: IF l_orgid is NOT NULL AND p_mode <> 'REQ_RESCHEDULE' THEN
12246: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

Line 12264: po_debug.debug_var(l_log_head, l_progress, 'Sales order l_orgid', l_orgid);

12260: END IF;
12261:
12262: l_progress := '004';
12263: IF g_debug_stmt THEN
12264: po_debug.debug_var(l_log_head, l_progress, 'Sales order l_orgid', l_orgid);
12265: END IF;
12266:
12267: IF l_orgid is NOT NULL THEN
12268: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

Line 12297: po_debug.debug_var(l_log_head, l_progress,'returning from OM API Call_Process_Order_for_IReq for modification',l_return_status);

12293: , P_Cancel_ISO_Lines => FALSE
12294: );
12295:
12296: IF g_debug_stmt THEN
12297: po_debug.debug_var(l_log_head, l_progress,'returning from OM API Call_Process_Order_for_IReq for modification',l_return_status);
12298: END IF;
12299:
12300: ELSIF (p_action_type = 'CANCELLATION') THEN
12301:

Line 12317: po_debug.debug_var(l_log_head, l_progress,'returning from OM API Call_Process_Order_for_IReq for cancellation',l_return_status);

12313: , X_return_status => l_return_status
12314: );
12315:
12316: IF g_debug_stmt THEN
12317: po_debug.debug_var(l_log_head, l_progress,'returning from OM API Call_Process_Order_for_IReq for cancellation',l_return_status);
12318: END IF;
12319:
12320: END IF;
12321:

Line 12328: po_debug.debug_var(l_log_head, l_progress, 'requisition l_orgid', l_orgid);

12324:
12325: l_progress := '007';
12326: l_orgid := get_requisition_org( p_req_line_id => p_document_line_id);
12327: IF g_debug_stmt THEN
12328: po_debug.debug_var(l_log_head, l_progress, 'requisition l_orgid', l_orgid);
12329: po_debug.debug_var(l_log_head, l_progress,'returning from OM API ',l_return_status);
12330: END IF;
12331:
12332: IF l_orgid is NOT NULL THEN

Line 12329: po_debug.debug_var(l_log_head, l_progress,'returning from OM API ',l_return_status);

12325: l_progress := '007';
12326: l_orgid := get_requisition_org( p_req_line_id => p_document_line_id);
12327: IF g_debug_stmt THEN
12328: po_debug.debug_var(l_log_head, l_progress, 'requisition l_orgid', l_orgid);
12329: po_debug.debug_var(l_log_head, l_progress,'returning from OM API ',l_return_status);
12330: END IF;
12331:
12332: IF l_orgid is NOT NULL THEN
12333: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

Line 12342: po_debug.debug_stmt(l_log_head, l_progress,'for successful lines updating the change request as accepted');

12338: IF (l_return_status = fnd_api.g_ret_sts_success) THEN --return status from OM API
12339: -- for successful lines update the change request as accepted
12340: l_progress := '008';
12341: IF g_debug_stmt THEN
12342: po_debug.debug_stmt(l_log_head, l_progress,'for successful lines updating the change request as accepted');
12343: END IF;
12344:
12345: IF (p_action_type = 'MODIFICATION') THEN
12346:

Line 12390: po_debug.debug_stmt(l_log_head, l_progress,'UPDATED po_change_requests');

12386: AND document_header_id = l_document_header_id
12387: AND document_line_id = p_document_line_id ;
12388:
12389: IF g_debug_stmt THEN
12390: po_debug.debug_stmt(l_log_head, l_progress,'UPDATED po_change_requests');
12391: END IF;
12392:
12393: req_line_CANCEL(p_req_line_id => p_document_line_id,
12394: x_return_status =>l_return_status);

Line 12402: po_debug.debug_stmt(l_log_head, l_progress,'for unsuccessful lines rollback');

12398: -- for unsuccessful lines update the change request as rejected
12399: l_progress := '013';
12400:
12401: IF g_debug_stmt THEN
12402: po_debug.debug_stmt(l_log_head, l_progress,'for unsuccessful lines rollback');
12403: po_debug.debug_stmt(l_log_head, l_progress,'update the change request as rejected');
12404: END IF;
12405:
12406: ROLLBACK TO convertintosochange_SP; -- revert the so changes

Line 12403: po_debug.debug_stmt(l_log_head, l_progress,'update the change request as rejected');

12399: l_progress := '013';
12400:
12401: IF g_debug_stmt THEN
12402: po_debug.debug_stmt(l_log_head, l_progress,'for unsuccessful lines rollback');
12403: po_debug.debug_stmt(l_log_head, l_progress,'update the change request as rejected');
12404: END IF;
12405:
12406: ROLLBACK TO convertintosochange_SP; -- revert the so changes
12407:

Line 12426: po_debug.debug_var(l_log_head, l_progress, 'Requisition l_orgid', l_orgid);

12422:
12423: l_orgid := get_requisition_org( p_req_line_id => p_document_line_id);
12424:
12425: IF g_debug_stmt THEN
12426: po_debug.debug_var(l_log_head, l_progress, 'Requisition l_orgid', l_orgid);
12427: END IF;
12428:
12429: IF l_orgid is NOT NULL THEN
12430: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --

Line 12525: po_debug.debug_var(l_log_head,l_progress,'p_req_line_id', p_req_line_id );

12521: -- Step 1: ADJUST the encumberance
12522: l_progress := '001';
12523:
12524: IF g_debug_stmt THEN
12525: po_debug.debug_var(l_log_head,l_progress,'p_req_line_id', p_req_line_id );
12526: po_debug.debug_var(l_log_head,l_progress,'p_delta_quantity', p_delta_quantity );
12527: po_debug.debug_var(l_log_head,l_progress,'p_uom', p_uom );
12528:
12529: END IF;

Line 12526: po_debug.debug_var(l_log_head,l_progress,'p_delta_quantity', p_delta_quantity );

12522: l_progress := '001';
12523:
12524: IF g_debug_stmt THEN
12525: po_debug.debug_var(l_log_head,l_progress,'p_req_line_id', p_req_line_id );
12526: po_debug.debug_var(l_log_head,l_progress,'p_delta_quantity', p_delta_quantity );
12527: po_debug.debug_var(l_log_head,l_progress,'p_uom', p_uom );
12528:
12529: END IF;
12530: IF( p_req_line_id is not null) THEN

Line 12527: po_debug.debug_var(l_log_head,l_progress,'p_uom', p_uom );

12523:
12524: IF g_debug_stmt THEN
12525: po_debug.debug_var(l_log_head,l_progress,'p_req_line_id', p_req_line_id );
12526: po_debug.debug_var(l_log_head,l_progress,'p_delta_quantity', p_delta_quantity );
12527: po_debug.debug_var(l_log_head,l_progress,'p_uom', p_uom );
12528:
12529: END IF;
12530: IF( p_req_line_id is not null) THEN
12531:

Line 12547: po_debug.debug_var(l_log_head,l_progress,'l_preparer_id',l_preparer_id );

12543: where prl.requisition_line_id = p_req_line_id
12544: and prl.requisition_header_id = prh.requisition_header_id;
12545:
12546: IF g_debug_stmt THEN
12547: po_debug.debug_var(l_log_head,l_progress,'l_preparer_id',l_preparer_id );
12548: po_debug.debug_stmt(l_log_head, l_progress,'Populating encumbrance gt');
12549: END IF;
12550: l_distribution_id_tbl := po_tbl_number();
12551: l_progress := '003';

Line 12548: po_debug.debug_stmt(l_log_head, l_progress,'Populating encumbrance gt');

12544: and prl.requisition_header_id = prh.requisition_header_id;
12545:
12546: IF g_debug_stmt THEN
12547: po_debug.debug_var(l_log_head,l_progress,'l_preparer_id',l_preparer_id );
12548: po_debug.debug_stmt(l_log_head, l_progress,'Populating encumbrance gt');
12549: END IF;
12550: l_distribution_id_tbl := po_tbl_number();
12551: l_progress := '003';
12552:

Line 12576: po_debug.debug_stmt(l_log_head, l_progress,'error exists with funds check');

12572:
12573: -- error handling after calling populate_encumbrance_gt
12574: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
12575: IF g_debug_stmt THEN
12576: po_debug.debug_stmt(l_log_head, l_progress,'error exists with funds check');
12577: END IF;
12578: RAISE fnd_api.g_exc_unexpected_error;
12579: END IF;
12580:

Line 12589: po_debug.debug_stmt(l_log_head, l_progress,'after populating encumbrance gt');

12585: -- values
12586: l_progress := '006';
12587:
12588: IF g_debug_stmt THEN
12589: po_debug.debug_stmt(l_log_head, l_progress,'after populating encumbrance gt');
12590: END IF;
12591:
12592: OPEN l_dist_tax_csr(p_req_line_id);
12593:

Line 12606: po_debug.debug_var(l_log_head, l_progress,'l_req_dist_id', l_req_dist_id );

12602:
12603: l_new_quantity := l_old_quantity + p_delta_quantity;
12604:
12605: IF g_debug_stmt THEN
12606: po_debug.debug_var(l_log_head, l_progress,'l_req_dist_id', l_req_dist_id );
12607: po_debug.debug_var(l_log_head, l_progress,'l_new_price', l_new_price );
12608: po_debug.debug_var(l_log_head, l_progress, 'l_quantity', l_new_quantity);
12609: END IF;
12610:

Line 12607: po_debug.debug_var(l_log_head, l_progress,'l_new_price', l_new_price );

12603: l_new_quantity := l_old_quantity + p_delta_quantity;
12604:
12605: IF g_debug_stmt THEN
12606: po_debug.debug_var(l_log_head, l_progress,'l_req_dist_id', l_req_dist_id );
12607: po_debug.debug_var(l_log_head, l_progress,'l_new_price', l_new_price );
12608: po_debug.debug_var(l_log_head, l_progress, 'l_quantity', l_new_quantity);
12609: END IF;
12610:
12611: po_rco_validation_pvt.calculate_disttax(1.0, l_cal_disttax_status, l_req_dist_id, l_new_price, l_new_quantity, NULL,

Line 12608: po_debug.debug_var(l_log_head, l_progress, 'l_quantity', l_new_quantity);

12604:
12605: IF g_debug_stmt THEN
12606: po_debug.debug_var(l_log_head, l_progress,'l_req_dist_id', l_req_dist_id );
12607: po_debug.debug_var(l_log_head, l_progress,'l_new_price', l_new_price );
12608: po_debug.debug_var(l_log_head, l_progress, 'l_quantity', l_new_quantity);
12609: END IF;
12610:
12611: po_rco_validation_pvt.calculate_disttax(1.0, l_cal_disttax_status, l_req_dist_id, l_new_price, l_new_quantity, NULL,
12612: l_rec_tax, l_nonrec_tax);

Line 12619: po_debug.debug_var(l_log_head, l_progress, 'l_rec_tax', l_rec_tax);

12615: l_new_tax := l_nonrec_tax;
12616: l_new_amount := l_new_price*l_new_quantity;
12617:
12618: IF g_debug_stmt THEN
12619: po_debug.debug_var(l_log_head, l_progress, 'l_rec_tax', l_rec_tax);
12620: po_debug.debug_var(l_log_head, l_progress, 'l_nonrec_tax', l_nonrec_tax);
12621: END IF;
12622:
12623: -- update new values in PO_ENCUMBRANCE_GT

Line 12620: po_debug.debug_var(l_log_head, l_progress, 'l_nonrec_tax', l_nonrec_tax);

12616: l_new_amount := l_new_price*l_new_quantity;
12617:
12618: IF g_debug_stmt THEN
12619: po_debug.debug_var(l_log_head, l_progress, 'l_rec_tax', l_rec_tax);
12620: po_debug.debug_var(l_log_head, l_progress, 'l_nonrec_tax', l_nonrec_tax);
12621: END IF;
12622:
12623: -- update new values in PO_ENCUMBRANCE_GT
12624: UPDATE po_encumbrance_gt

Line 12637: po_debug.debug_stmt(l_log_head, l_progress,'Updating po_encumbrance_gt NEW record');

12633: adjustment_status = po_document_funds_grp.g_adjustment_status_new;
12634:
12635: l_progress := '009';
12636: IF g_debug_stmt THEN
12637: po_debug.debug_stmt(l_log_head, l_progress,'Updating po_encumbrance_gt NEW record');
12638: END IF;
12639:
12640:
12641:

Line 12665: po_debug.debug_stmt(l_log_head, l_progress, 'FUNDS ADJUST:' || l_fc_result_status ||' PO RETURN CODE:' || l_po_return_code);

12661:
12662: l_progress := '011';
12663:
12664: IF g_debug_stmt THEN
12665: po_debug.debug_stmt(l_log_head, l_progress, 'FUNDS ADJUST:' || l_fc_result_status ||' PO RETURN CODE:' || l_po_return_code);
12666: END IF;
12667:
12668: IF (l_fc_result_status = fnd_api.g_ret_sts_unexp_error) THEN
12669: IF g_debug_stmt THEN

Line 12670: po_debug.debug_stmt(l_log_head, l_progress,'error exists with funds check');

12666: END IF;
12667:
12668: IF (l_fc_result_status = fnd_api.g_ret_sts_unexp_error) THEN
12669: IF g_debug_stmt THEN
12670: po_debug.debug_stmt(l_log_head, l_progress,'error exists with funds check');
12671: END IF;
12672: RAISE fnd_api.g_exc_unexpected_error;
12673: RETURN;
12674:

Line 12678: po_debug.debug_STmt(l_log_head, l_progress, 'after DO adjust of funds');

12674:
12675: ELSE
12676:
12677: IF g_debug_stmt THEN
12678: po_debug.debug_STmt(l_log_head, l_progress, 'after DO adjust of funds');
12679: END IF;
12680:
12681: IF (l_po_return_code = po_document_funds_grp.g_return_success) THEN
12682: x_return_status := fnd_api.g_ret_sts_success;

Line 12697: po_debug.debug_STmt(l_log_head, l_progress, 'Updating the req line and dist with the quantity changes');

12693: IF (p_delta_quantity IS NOT NULL) THEN
12694:
12695: l_progress := '012';
12696: IF g_debug_stmt THEN
12697: po_debug.debug_STmt(l_log_head, l_progress, 'Updating the req line and dist with the quantity changes');
12698: END IF;
12699:
12700: UPDATE po_requisition_lines_all
12701: SET quantity = quantity + p_delta_quantity

Line 12737: po_debug.debug_STmt(l_log_head, l_progress, 'Updated the req line and dist and mtl_supply with the quantity changes');

12733: IF NOT l_bool_ret_sts THEN
12734: RAISE fnd_api.g_exc_unexpected_error;
12735: END IF;
12736: IF g_debug_stmt THEN
12737: po_debug.debug_STmt(l_log_head, l_progress, 'Updated the req line and dist and mtl_supply with the quantity changes');
12738: po_debug.debug_STmt(l_log_head, l_progress, 'Returning from update_reqline_quan_changes');
12739: END IF;
12740: END IF;
12741: END IF; -- IF( p_req_line_id is not null)

Line 12738: po_debug.debug_STmt(l_log_head, l_progress, 'Returning from update_reqline_quan_changes');

12734: RAISE fnd_api.g_exc_unexpected_error;
12735: END IF;
12736: IF g_debug_stmt THEN
12737: po_debug.debug_STmt(l_log_head, l_progress, 'Updated the req line and dist and mtl_supply with the quantity changes');
12738: po_debug.debug_STmt(l_log_head, l_progress, 'Returning from update_reqline_quan_changes');
12739: END IF;
12740: END IF;
12741: END IF; -- IF( p_req_line_id is not null)
12742:

Line 12776: po_debug.debug_var(l_log_head,x_progress,'p_need_by_date', p_need_by_date );

12772:
12773: IF (p_need_by_date IS NOT NULL) THEN
12774: x_progress := '001';
12775: IF g_debug_stmt THEN
12776: po_debug.debug_var(l_log_head,x_progress,'p_need_by_date', p_need_by_date );
12777: po_debug.debug_var(l_log_head,x_progress,'p_req_line_id', p_req_line_id );
12778: END IF;
12779:
12780: UPDATE po_requisition_lines_all

Line 12777: po_debug.debug_var(l_log_head,x_progress,'p_req_line_id', p_req_line_id );

12773: IF (p_need_by_date IS NOT NULL) THEN
12774: x_progress := '001';
12775: IF g_debug_stmt THEN
12776: po_debug.debug_var(l_log_head,x_progress,'p_need_by_date', p_need_by_date );
12777: po_debug.debug_var(l_log_head,x_progress,'p_req_line_id', p_req_line_id );
12778: END IF;
12779:
12780: UPDATE po_requisition_lines_all
12781: SET need_by_date = p_need_by_date

Line 12805: po_debug.debug_stmt(l_log_head, x_progress,'Need by updation successful');

12801:
12802: END IF;
12803:
12804: IF g_debug_stmt THEN
12805: po_debug.debug_stmt(l_log_head, x_progress,'Need by updation successful');
12806: END IF;
12807:
12808: END update_req_line_date_changes;
12809:

Line 12836: po_debug.debug_var(l_log_head,x_progress,'p_req_line_id', p_req_line_id );

12832: --14227140 changes ends
12833: BEGIN
12834: x_progress := '001';
12835: IF g_debug_stmt THEN
12836: po_debug.debug_var(l_log_head,x_progress,'p_req_line_id', p_req_line_id );
12837: po_debug.debug_stmt(l_log_head, x_progress,'Updating po_requisition_lines_all');
12838: END IF;
12839: --12831835 Begin Added the foll code to get the cancelled qty for update
12840: BEGIN

Line 12837: po_debug.debug_stmt(l_log_head, x_progress,'Updating po_requisition_lines_all');

12833: BEGIN
12834: x_progress := '001';
12835: IF g_debug_stmt THEN
12836: po_debug.debug_var(l_log_head,x_progress,'p_req_line_id', p_req_line_id );
12837: po_debug.debug_stmt(l_log_head, x_progress,'Updating po_requisition_lines_all');
12838: END IF;
12839: --12831835 Begin Added the foll code to get the cancelled qty for update
12840: BEGIN
12841: select order_source_id

Line 12850: po_debug.debug_var(l_log_head,x_progress,'X_order_source_id', X_order_source_id );

12846: X_order_source_id :=NULL;
12847: END;
12848:
12849: IF g_debug_stmt THEN
12850: po_debug.debug_var(l_log_head,x_progress,'X_order_source_id', X_order_source_id );
12851: po_debug.debug_stmt(l_log_head, x_progress,'Order Source Id');
12852: END IF;
12853:
12854: BEGIN

Line 12851: po_debug.debug_stmt(l_log_head, x_progress,'Order Source Id');

12847: END;
12848:
12849: IF g_debug_stmt THEN
12850: po_debug.debug_var(l_log_head,x_progress,'X_order_source_id', X_order_source_id );
12851: po_debug.debug_stmt(l_log_head, x_progress,'Order Source Id');
12852: END IF;
12853:
12854: BEGIN
12855: --14227140 changes starts

Line 12902: po_debug.debug_var(l_log_head,x_progress,'x_cancelled_quanity', x_cancelled_quanity );

12898: --14227140 changes ends
12899: END;
12900:
12901: IF g_debug_stmt THEN
12902: po_debug.debug_var(l_log_head,x_progress,'x_cancelled_quanity', x_cancelled_quanity );
12903: po_debug.debug_stmt(l_log_head, x_progress,'Cancelled Quantity');
12904: END IF;
12905:
12906: --12831835 End

Line 12903: po_debug.debug_stmt(l_log_head, x_progress,'Cancelled Quantity');

12899: END;
12900:
12901: IF g_debug_stmt THEN
12902: po_debug.debug_var(l_log_head,x_progress,'x_cancelled_quanity', x_cancelled_quanity );
12903: po_debug.debug_stmt(l_log_head, x_progress,'Cancelled Quantity');
12904: END IF;
12905:
12906: --12831835 End
12907: /*Algorithm 1. Check if Req encumbrance is ON

Line 12957: po_debug.debug_var(l_log_head,x_progress,'l_return_status', l_return_status );

12953:
12954: x_return_status := l_return_status;
12955:
12956: IF g_debug_stmt THEN
12957: po_debug.debug_var(l_log_head,x_progress,'l_return_status', l_return_status );
12958: po_debug.debug_var(l_log_head,x_progress,'x_po_return_code ', l_po_return_code );
12959: po_debug.debug_stmt(l_log_head, x_progress,'Mtl_supply deleted and cancelling funds after call');
12960: END IF;
12961:

Line 12958: po_debug.debug_var(l_log_head,x_progress,'x_po_return_code ', l_po_return_code );

12954: x_return_status := l_return_status;
12955:
12956: IF g_debug_stmt THEN
12957: po_debug.debug_var(l_log_head,x_progress,'l_return_status', l_return_status );
12958: po_debug.debug_var(l_log_head,x_progress,'x_po_return_code ', l_po_return_code );
12959: po_debug.debug_stmt(l_log_head, x_progress,'Mtl_supply deleted and cancelling funds after call');
12960: END IF;
12961:
12962: IF (l_return_status =FND_API.G_RET_STS_SUCCESS) then

Line 12959: po_debug.debug_stmt(l_log_head, x_progress,'Mtl_supply deleted and cancelling funds after call');

12955:
12956: IF g_debug_stmt THEN
12957: po_debug.debug_var(l_log_head,x_progress,'l_return_status', l_return_status );
12958: po_debug.debug_var(l_log_head,x_progress,'x_po_return_code ', l_po_return_code );
12959: po_debug.debug_stmt(l_log_head, x_progress,'Mtl_supply deleted and cancelling funds after call');
12960: END IF;
12961:
12962: IF (l_return_status =FND_API.G_RET_STS_SUCCESS) then
12963:

Line 12990: po_debug.debug_stmt(l_log_head, x_progress,'Requisition encumbrance not ON');

12986: END IF;
12987:
12988: ELSE -- IF (l_is_req_encumbrance ) THEN
12989: IF g_debug_stmt THEN
12990: po_debug.debug_stmt(l_log_head, x_progress,'Requisition encumbrance not ON');
12991: END IF;
12992: --12831835 Added updation of quantity_cancelled
12993:
12994: --update po req lines as cancel flag I

Line 13007: po_debug.debug_stmt(l_log_head, x_progress,'updated the cancel flag of req line');

13003: cancel_date = SYSDATE
13004: WHERE requisition_line_id = p_req_line_id ;
13005: end if;
13006: IF g_debug_stmt THEN
13007: po_debug.debug_stmt(l_log_head, x_progress,'updated the cancel flag of req line');
13008: END IF;
13009:
13010:
13011: --bug 7664476 -- roll up the authorization status if all lines of requisiton is cancelled

Line 13048: po_debug.debug_stmt(l_log_head, x_progress,'Mtl_supply deleted and cancelling funds');

13044: IF NOT l_bool_ret_sts THEN
13045: RAISE fnd_api.g_exc_unexpected_error;
13046: END IF;
13047: IF g_debug_stmt THEN
13048: po_debug.debug_stmt(l_log_head, x_progress,'Mtl_supply deleted and cancelling funds');
13049: END IF;
13050:
13051:
13052:

Line 13393: po_debug.debug_var(l_log_head,l_progress,'p_req_line_id', p_req_line_id );

13389: -- Step 1: ADJUST the encumberance
13390: l_progress := '001';
13391:
13392: IF g_debug_stmt THEN
13393: po_debug.debug_var(l_log_head,l_progress,'p_req_line_id', p_req_line_id );
13394: po_debug.debug_var(l_log_head,l_progress,'p_delta_prim_quantity', p_delta_prim_quantity );
13395: po_debug.debug_var(l_log_head,l_progress,'p_uom', p_uom );
13396: po_debug.debug_var(l_log_head,l_progress,'p_delta_sec_quantity', p_delta_sec_quantity );
13397:

Line 13394: po_debug.debug_var(l_log_head,l_progress,'p_delta_prim_quantity', p_delta_prim_quantity );

13390: l_progress := '001';
13391:
13392: IF g_debug_stmt THEN
13393: po_debug.debug_var(l_log_head,l_progress,'p_req_line_id', p_req_line_id );
13394: po_debug.debug_var(l_log_head,l_progress,'p_delta_prim_quantity', p_delta_prim_quantity );
13395: po_debug.debug_var(l_log_head,l_progress,'p_uom', p_uom );
13396: po_debug.debug_var(l_log_head,l_progress,'p_delta_sec_quantity', p_delta_sec_quantity );
13397:
13398: END IF;

Line 13395: po_debug.debug_var(l_log_head,l_progress,'p_uom', p_uom );

13391:
13392: IF g_debug_stmt THEN
13393: po_debug.debug_var(l_log_head,l_progress,'p_req_line_id', p_req_line_id );
13394: po_debug.debug_var(l_log_head,l_progress,'p_delta_prim_quantity', p_delta_prim_quantity );
13395: po_debug.debug_var(l_log_head,l_progress,'p_uom', p_uom );
13396: po_debug.debug_var(l_log_head,l_progress,'p_delta_sec_quantity', p_delta_sec_quantity );
13397:
13398: END IF;
13399: IF( p_req_line_id is not null) THEN

Line 13396: po_debug.debug_var(l_log_head,l_progress,'p_delta_sec_quantity', p_delta_sec_quantity );

13392: IF g_debug_stmt THEN
13393: po_debug.debug_var(l_log_head,l_progress,'p_req_line_id', p_req_line_id );
13394: po_debug.debug_var(l_log_head,l_progress,'p_delta_prim_quantity', p_delta_prim_quantity );
13395: po_debug.debug_var(l_log_head,l_progress,'p_uom', p_uom );
13396: po_debug.debug_var(l_log_head,l_progress,'p_delta_sec_quantity', p_delta_sec_quantity );
13397:
13398: END IF;
13399: IF( p_req_line_id is not null) THEN
13400:

Line 13416: po_debug.debug_var(l_log_head,l_progress,'l_preparer_id',l_preparer_id );

13412: where prl.requisition_line_id = p_req_line_id
13413: and prl.requisition_header_id = prh.requisition_header_id;
13414:
13415: IF g_debug_stmt THEN
13416: po_debug.debug_var(l_log_head,l_progress,'l_preparer_id',l_preparer_id );
13417: po_debug.debug_stmt(l_log_head, l_progress,'Populating encumbrance gt');
13418: END IF;
13419: l_distribution_id_tbl := po_tbl_number();
13420: l_progress := '003';

Line 13417: po_debug.debug_stmt(l_log_head, l_progress,'Populating encumbrance gt');

13413: and prl.requisition_header_id = prh.requisition_header_id;
13414:
13415: IF g_debug_stmt THEN
13416: po_debug.debug_var(l_log_head,l_progress,'l_preparer_id',l_preparer_id );
13417: po_debug.debug_stmt(l_log_head, l_progress,'Populating encumbrance gt');
13418: END IF;
13419: l_distribution_id_tbl := po_tbl_number();
13420: l_progress := '003';
13421:

Line 13445: po_debug.debug_stmt(l_log_head, l_progress,'error exists with funds check');

13441:
13442: -- error handling after calling populate_encumbrance_gt
13443: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
13444: IF g_debug_stmt THEN
13445: po_debug.debug_stmt(l_log_head, l_progress,'error exists with funds check');
13446: END IF;
13447: RAISE fnd_api.g_exc_unexpected_error;
13448: END IF;
13449:

Line 13458: po_debug.debug_stmt(l_log_head, l_progress,'after populating encumbrance gt');

13454: -- values
13455: l_progress := '006';
13456:
13457: IF g_debug_stmt THEN
13458: po_debug.debug_stmt(l_log_head, l_progress,'after populating encumbrance gt');
13459: END IF;
13460:
13461: OPEN l_dist_tax_csr(p_req_line_id);
13462:

Line 13474: po_debug.debug_var(l_log_head, l_progress,'l_req_dist_id', l_req_dist_id );

13470: l_progress := '007';
13471: l_new_quantity := l_old_quantity + Nvl(p_delta_prim_quantity,0);
13472:
13473: IF g_debug_stmt THEN
13474: po_debug.debug_var(l_log_head, l_progress,'l_req_dist_id', l_req_dist_id );
13475: po_debug.debug_var(l_log_head, l_progress,'l_new_price', l_new_price );
13476: po_debug.debug_var(l_log_head, l_progress, 'l_quantity', l_new_quantity);
13477: END IF;
13478:

Line 13475: po_debug.debug_var(l_log_head, l_progress,'l_new_price', l_new_price );

13471: l_new_quantity := l_old_quantity + Nvl(p_delta_prim_quantity,0);
13472:
13473: IF g_debug_stmt THEN
13474: po_debug.debug_var(l_log_head, l_progress,'l_req_dist_id', l_req_dist_id );
13475: po_debug.debug_var(l_log_head, l_progress,'l_new_price', l_new_price );
13476: po_debug.debug_var(l_log_head, l_progress, 'l_quantity', l_new_quantity);
13477: END IF;
13478:
13479: po_rco_validation_pvt.calculate_disttax(1.0, l_cal_disttax_status, l_req_dist_id, l_new_price, l_new_quantity, NULL,

Line 13476: po_debug.debug_var(l_log_head, l_progress, 'l_quantity', l_new_quantity);

13472:
13473: IF g_debug_stmt THEN
13474: po_debug.debug_var(l_log_head, l_progress,'l_req_dist_id', l_req_dist_id );
13475: po_debug.debug_var(l_log_head, l_progress,'l_new_price', l_new_price );
13476: po_debug.debug_var(l_log_head, l_progress, 'l_quantity', l_new_quantity);
13477: END IF;
13478:
13479: po_rco_validation_pvt.calculate_disttax(1.0, l_cal_disttax_status, l_req_dist_id, l_new_price, l_new_quantity, NULL,
13480: l_rec_tax, l_nonrec_tax);

Line 13487: po_debug.debug_var(l_log_head, l_progress, 'l_rec_tax', l_rec_tax);

13483: l_new_tax := l_nonrec_tax;
13484: l_new_amount := l_new_price*l_new_quantity;
13485:
13486: IF g_debug_stmt THEN
13487: po_debug.debug_var(l_log_head, l_progress, 'l_rec_tax', l_rec_tax);
13488: po_debug.debug_var(l_log_head, l_progress, 'l_nonrec_tax', l_nonrec_tax);
13489: END IF;
13490:
13491: -- update new values in PO_ENCUMBRANCE_GT

Line 13488: po_debug.debug_var(l_log_head, l_progress, 'l_nonrec_tax', l_nonrec_tax);

13484: l_new_amount := l_new_price*l_new_quantity;
13485:
13486: IF g_debug_stmt THEN
13487: po_debug.debug_var(l_log_head, l_progress, 'l_rec_tax', l_rec_tax);
13488: po_debug.debug_var(l_log_head, l_progress, 'l_nonrec_tax', l_nonrec_tax);
13489: END IF;
13490:
13491: -- update new values in PO_ENCUMBRANCE_GT
13492: UPDATE po_encumbrance_gt

Line 13505: po_debug.debug_stmt(l_log_head, l_progress,'Updating po_encumbrance_gt NEW record');

13501: adjustment_status = po_document_funds_grp.g_adjustment_status_new;
13502:
13503: l_progress := '009';
13504: IF g_debug_stmt THEN
13505: po_debug.debug_stmt(l_log_head, l_progress,'Updating po_encumbrance_gt NEW record');
13506: END IF;
13507:
13508: END LOOP;
13509: CLOSE l_dist_tax_csr;

Line 13531: po_debug.debug_stmt(l_log_head, l_progress, 'FUNDS ADJUST:' || l_fc_result_status ||' PO RETURN CODE:' || l_po_return_code);

13527:
13528: l_progress := '011';
13529:
13530: IF g_debug_stmt THEN
13531: po_debug.debug_stmt(l_log_head, l_progress, 'FUNDS ADJUST:' || l_fc_result_status ||' PO RETURN CODE:' || l_po_return_code);
13532: END IF;
13533:
13534: IF (l_fc_result_status = fnd_api.g_ret_sts_unexp_error) THEN
13535: IF g_debug_stmt THEN

Line 13536: po_debug.debug_stmt(l_log_head, l_progress,'error exists with funds check');

13532: END IF;
13533:
13534: IF (l_fc_result_status = fnd_api.g_ret_sts_unexp_error) THEN
13535: IF g_debug_stmt THEN
13536: po_debug.debug_stmt(l_log_head, l_progress,'error exists with funds check');
13537: END IF;
13538: RAISE fnd_api.g_exc_unexpected_error;
13539: RETURN;
13540:

Line 13544: po_debug.debug_STmt(l_log_head, l_progress, 'after DO adjust of funds');

13540:
13541: ELSE
13542:
13543: IF g_debug_stmt THEN
13544: po_debug.debug_STmt(l_log_head, l_progress, 'after DO adjust of funds');
13545: END IF;
13546:
13547: IF (l_po_return_code = po_document_funds_grp.g_return_success) THEN
13548: x_return_status := fnd_api.g_ret_sts_success;

Line 13612: po_debug.debug_STmt(l_log_head, l_progress, 'Updating the req line and dist with the quantity changes');

13608:
13609:
13610: l_progress := '016';
13611: IF g_debug_stmt THEN
13612: po_debug.debug_STmt(l_log_head, l_progress, 'Updating the req line and dist with the quantity changes');
13613: END IF;
13614:
13615: IF (p_delta_prim_quantity IS NOT NULL ) THEN
13616: UPDATE po_requisition_lines_all

Line 13652: po_debug.debug_STmt(l_log_head, l_progress, 'Updated the req line and dist and mtl_supply with the quantity changes');

13648: IF NOT l_bool_ret_sts THEN
13649: RAISE fnd_api.g_exc_unexpected_error;
13650: END IF;
13651: IF g_debug_stmt THEN
13652: po_debug.debug_STmt(l_log_head, l_progress, 'Updated the req line and dist and mtl_supply with the quantity changes');
13653: po_debug.debug_STmt(l_log_head, l_progress, 'Returning from update_reqline_quan_changes');
13654: END IF;
13655: END IF;
13656: END IF; -- IF( p_req_line_id is not null)

Line 13653: po_debug.debug_STmt(l_log_head, l_progress, 'Returning from update_reqline_quan_changes');

13649: RAISE fnd_api.g_exc_unexpected_error;
13650: END IF;
13651: IF g_debug_stmt THEN
13652: po_debug.debug_STmt(l_log_head, l_progress, 'Updated the req line and dist and mtl_supply with the quantity changes');
13653: po_debug.debug_STmt(l_log_head, l_progress, 'Returning from update_reqline_quan_changes');
13654: END IF;
13655: END IF;
13656: END IF; -- IF( p_req_line_id is not null)
13657: