DBA Data[Home] [Help]

APPS.PO_RESCHEDULE_PKG dependencies on PO_DEBUG

Line 18: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;

14: );
15: -- END Forward declarations for private procedures
16:
17: --
18: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
19: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
20:
21: -- Forward declare private procedure po_reschedule_req
22: PROCEDURE PO_RESCHEDULE_REQ (

Line 19: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;

15: -- END Forward declarations for private procedures
16:
17: --
18: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
19: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
20:
21: -- Forward declare private procedure po_reschedule_req
22: PROCEDURE PO_RESCHEDULE_REQ (
23: p_line_location_id_tbl IN po_tbl_number,

Line 203: po_debug.debug_begin(l_log_head);

199: --Bug 5255550
200:
201: -- Step1 get the release id from x_supply number into l_po_release_id;
202: -- debug
203: po_debug.debug_begin(l_log_head);
204: -- debug
205:
206: select instr(x_supply_number, '(')
207: into x_pare_left

Line 216: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_type', x_po_type);

212: ELSE
213: x_po_type := 'RELEASE';
214: end if;
215: -- debug
216: PO_DEBUG.debug_var(l_log_head,l_progress,'x_po_type', x_po_type);
217: -- debug
218:
219: l_progress:= '010';
220: if X_po_type <> 'PO' then

Line 243: PO_DEBUG.debug_var(l_log_head,l_progress,'x_release_num', x_release_num);

239:
240:
241: l_progress:= '020';
242: -- debug
243: PO_DEBUG.debug_var(l_log_head,l_progress,'x_release_num', x_release_num);
244: -- debug
245:
246: begin
247: -- Get the po_release_id out of supply_number

Line 256: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_release_id', l_po_release_id);

252: and release_num = x_release_num;
253:
254: l_progress:= '030';
255: -- debug
256: PO_DEBUG.debug_var(l_log_head,l_progress,'l_po_release_id', l_po_release_id);
257: -- debug
258:
259: exception
260: when no_data_found then

Line 276: PO_DEBUG.debug_var(l_log_head,l_progress,'l_original_org_context', l_original_org_context);

272: po_header_id and set the context to this org_id */
273: l_original_org_context := PO_MOAC_UTILS_PVT.get_current_org_id ; --
274:
275: -- debug
276: PO_DEBUG.debug_var(l_log_head,l_progress,'l_original_org_context', l_original_org_context);
277: -- debug
278:
279: --Bug 5255550
280: BEGIN

Line 296: PO_DEBUG.debug_var(l_log_head,l_progress,'l_document_org_id', l_document_org_id);

292: END IF; -- x_po_type
293:
294: l_progress:= '050';
295: -- debug
296: PO_DEBUG.debug_var(l_log_head,l_progress,'l_document_org_id', l_document_org_id);
297: -- debug
298:
299: -- Set the org context to the document's OU.
300: PO_MOAC_UTILS_PVT.set_org_context(l_document_org_id) ; --

Line 321: PO_DEBUG.debug_var(l_log_head,l_progress,'l_session_gt_key', l_session_gt_key);

317: l_session_gt_key := PO_CORE_S.get_session_gt_nextval();
318:
319: l_progress:= '060';
320: -- debug
321: PO_DEBUG.debug_var(l_log_head,l_progress,'l_session_gt_key', l_session_gt_key);
322: -- debug
323:
324: -- Bug 5610714 replacing x_shipment_nums.Count with X_po_line_ids.Count as x_shipment_nums can be Null
325: -- Bug 5610714 Added the following If Condition to handle the issue of passing x_shipment_nums as Null.

Line 526: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status', l_return_status);

522: p_ship_methods => p_ship_methods,
523: x_return_status => l_return_status);
524:
525: -- debug
526: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status', l_return_status);
527: -- debug
528:
529: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
530: RAISE FND_API.G_EXC_ERROR;

Line 588: PO_DEBUG.debug_stmt(l_log_head,l_progress,'After return from update document');

584:
585: l_progress:= '160';
586: /* Step 8: add the errors to the error list.*/
587: -- debug
588: PO_DEBUG.debug_stmt(l_log_head,l_progress,'After return from update document');
589: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status', l_return_status);
590: -- debug
591:
592: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 589: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status', l_return_status);

585: l_progress:= '160';
586: /* Step 8: add the errors to the error list.*/
587: -- debug
588: PO_DEBUG.debug_stmt(l_log_head,l_progress,'After return from update document');
589: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status', l_return_status);
590: -- debug
591:
592: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
593: x_error_count := x_error_message.Count; --bug9693292

Line 609: PO_DEBUG.debug_stmt(l_log_head,l_progress,'setting the context back to '

605: END IF;
606:
607: l_progress:= '160';
608: -- debug
609: PO_DEBUG.debug_stmt(l_log_head,l_progress,'setting the context back to '
610: ||l_original_org_context);
611: -- debug
612: /* Step 9: set the context back to the orginal context.*/
613: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_context) ; --

Line 619: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Deleting data from session gt '

615: /* Delete all the data from po_session_gt */
616: l_progress:= '170';
617:
618: -- debug
619: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Deleting data from session gt '
620: );
621: -- debug
622:
623: DELETE FROM po_session_gt

Line 627: PO_DEBUG.debug_end(l_log_head);

623: DELETE FROM po_session_gt
624: WHERE KEY = l_session_gt_key;
625:
626: /*Step 10 : return from the api */
627: PO_DEBUG.debug_end(l_log_head);
628: return TRUE;
629:
630:
631: EXCEPTION

Line 693: PO_DEBUG.debug_begin(l_log_head);

689: BEGIN
690: -- Bug 5255550
691: x_return_status := FND_API.G_RET_STS_SUCCESS;
692: l_progress:= '000';
693: PO_DEBUG.debug_begin(l_log_head);
694:
695: --SQL What: line_location_id, query out
696: --SQL the backing requistion lines and update them with new
697: --SQL estimated_pickup_dates and ship_methods

Line 711: PO_DEBUG.debug_end(l_log_head);

707: WHERE REQ.line_location_id = p_line_location_id_tbl(i);
708:
709: l_progress:= '020';
710:
711: PO_DEBUG.debug_end(l_log_head);
712:
713: EXCEPTION
714: WHEN OTHERS THEN
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 722: PO_DEBUG.debug_exc (

718: p_api_name => l_api_name,
719: p_message => 'Can not update estimated_pickup_date and ship_method on requisitions');
720:
721: IF (g_debug_unexp) THEN
722: PO_DEBUG.debug_exc (
723: p_log_head => l_log_head,
724: p_progress => l_progress || 'with sqlcode' || sqlcode);
725: END IF;
726: