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_INTERFACE_S dependencies on PO_LOG

Line 7332: IF (PO_LOG.d_proc) THEN

7328: BEGIN
7329:
7330: d_progress := 0;
7331:
7332: IF (PO_LOG.d_proc) THEN
7333: PO_LOG.proc_begin(d_module);
7334: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
7335: END IF;
7336:

Line 7333: PO_LOG.proc_begin(d_module);

7329:
7330: d_progress := 0;
7331:
7332: IF (PO_LOG.d_proc) THEN
7333: PO_LOG.proc_begin(d_module);
7334: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
7335: END IF;
7336:
7337: d_progress := 10;

Line 7334: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);

7330: d_progress := 0;
7331:
7332: IF (PO_LOG.d_proc) THEN
7333: PO_LOG.proc_begin(d_module);
7334: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
7335: END IF;
7336:
7337: d_progress := 10;
7338:

Line 7346: IF (PO_LOG.d_stmt) THEN

7342: WHERE pod.line_location_id = p_line_location_id;
7343:
7344: d_progress := 20;
7345:
7346: IF (PO_LOG.d_stmt) THEN
7347: PO_LOG.stmt(d_module, d_progress, 'l_last_dist_id', l_last_dist_id);
7348: END IF;
7349:
7350: SELECT poll.quantity

Line 7347: PO_LOG.stmt(d_module, d_progress, 'l_last_dist_id', l_last_dist_id);

7343:
7344: d_progress := 20;
7345:
7346: IF (PO_LOG.d_stmt) THEN
7347: PO_LOG.stmt(d_module, d_progress, 'l_last_dist_id', l_last_dist_id);
7348: END IF;
7349:
7350: SELECT poll.quantity
7351: INTO l_shipment_quantity

Line 7363: IF (PO_LOG.d_proc) THEN

7359: (l_sum_dist_quantities - pod.quantity_ordered)
7360: WHERE pod.po_distribution_id = l_last_dist_id
7361: RETURNING pod.quantity_ordered INTO l_last_dist_qty;
7362:
7363: IF (PO_LOG.d_proc) THEN
7364: PO_LOG.proc_end(d_module, 'l_last_dist_qty', l_last_dist_qty);
7365: PO_LOG.proc_end(d_module);
7366: END IF;
7367:

Line 7364: PO_LOG.proc_end(d_module, 'l_last_dist_qty', l_last_dist_qty);

7360: WHERE pod.po_distribution_id = l_last_dist_id
7361: RETURNING pod.quantity_ordered INTO l_last_dist_qty;
7362:
7363: IF (PO_LOG.d_proc) THEN
7364: PO_LOG.proc_end(d_module, 'l_last_dist_qty', l_last_dist_qty);
7365: PO_LOG.proc_end(d_module);
7366: END IF;
7367:
7368: EXCEPTION

Line 7365: PO_LOG.proc_end(d_module);

7361: RETURNING pod.quantity_ordered INTO l_last_dist_qty;
7362:
7363: IF (PO_LOG.d_proc) THEN
7364: PO_LOG.proc_end(d_module, 'l_last_dist_qty', l_last_dist_qty);
7365: PO_LOG.proc_end(d_module);
7366: END IF;
7367:
7368: EXCEPTION
7369: WHEN OTHERS THEN

Line 7370: IF (PO_LOG.d_exc) THEN

7366: END IF;
7367:
7368: EXCEPTION
7369: WHEN OTHERS THEN
7370: IF (PO_LOG.d_exc) THEN
7371: PO_LOG.exc(d_module, d_progress, SQLCODE||SQLERRM);
7372: END IF;
7373:
7374: RAISE;

Line 7371: PO_LOG.exc(d_module, d_progress, SQLCODE||SQLERRM);

7367:
7368: EXCEPTION
7369: WHEN OTHERS THEN
7370: IF (PO_LOG.d_exc) THEN
7371: PO_LOG.exc(d_module, d_progress, SQLCODE||SQLERRM);
7372: END IF;
7373:
7374: RAISE;
7375:

Line 9613: IF (PO_LOG.d_stmt) THEN

9609: --insert only takes care of the interface lines which are backed by
9610: --requisitions.
9611: if g_interface_source_code='SOURCING' then
9612:
9613: IF (PO_LOG.d_stmt) THEN
9614: PO_LOG.stmt(g_log_head || l_api_name, 190, 'Defaulting dists interface for sourcing.');
9615: END IF;
9616:
9617: l_progress:='190';

Line 9614: PO_LOG.stmt(g_log_head || l_api_name, 190, 'Defaulting dists interface for sourcing.');

9610: --requisitions.
9611: if g_interface_source_code='SOURCING' then
9612:
9613: IF (PO_LOG.d_stmt) THEN
9614: PO_LOG.stmt(g_log_head || l_api_name, 190, 'Defaulting dists interface for sourcing.');
9615: END IF;
9616:
9617: l_progress:='190';
9618: for i in c_default_distribution

Line 9622: IF (PO_LOG.d_stmt) THEN

9618: for i in c_default_distribution
9619: loop
9620:
9621: --
9622: IF (PO_LOG.d_stmt) THEN
9623: PO_LOG.stmt(g_log_head || l_api_name, 190, 'i.interface_line_id', i.interface_line_id);
9624: END IF;
9625:
9626:

Line 9623: PO_LOG.stmt(g_log_head || l_api_name, 190, 'i.interface_line_id', i.interface_line_id);

9619: loop
9620:
9621: --
9622: IF (PO_LOG.d_stmt) THEN
9623: PO_LOG.stmt(g_log_head || l_api_name, 190, 'i.interface_line_id', i.interface_line_id);
9624: END IF;
9625:
9626:
9627: IF (p_is_complex_work_po) THEN

Line 9676: IF (PO_LOG.d_stmt) THEN

9672: , i.ship_to_location_id
9673: , l_ship_to_org_id
9674: );
9675:
9676: IF (PO_LOG.d_stmt) THEN
9677: PO_LOG.stmt(g_log_head || l_api_name, 190, 'Num rows inserted', SQL%ROWCOUNT);
9678: END IF;
9679:
9680: ELSE

Line 9677: PO_LOG.stmt(g_log_head || l_api_name, 190, 'Num rows inserted', SQL%ROWCOUNT);

9673: , l_ship_to_org_id
9674: );
9675:
9676: IF (PO_LOG.d_stmt) THEN
9677: PO_LOG.stmt(g_log_head || l_api_name, 190, 'Num rows inserted', SQL%ROWCOUNT);
9678: END IF;
9679:
9680: ELSE
9681:

Line 13486: IF (PO_LOG.d_proc) THEN

13482: BEGIN
13483:
13484: d_progress := 0;
13485:
13486: IF (PO_LOG.d_proc) THEN
13487: PO_LOG.proc_begin(d_module);
13488: PO_LOG.proc_begin(d_module, 'p_deliver_to_loc_id', p_deliver_to_loc_id);
13489: END IF;
13490:

Line 13487: PO_LOG.proc_begin(d_module);

13483:
13484: d_progress := 0;
13485:
13486: IF (PO_LOG.d_proc) THEN
13487: PO_LOG.proc_begin(d_module);
13488: PO_LOG.proc_begin(d_module, 'p_deliver_to_loc_id', p_deliver_to_loc_id);
13489: END IF;
13490:
13491: d_progress := 10;

Line 13488: PO_LOG.proc_begin(d_module, 'p_deliver_to_loc_id', p_deliver_to_loc_id);

13484: d_progress := 0;
13485:
13486: IF (PO_LOG.d_proc) THEN
13487: PO_LOG.proc_begin(d_module);
13488: PO_LOG.proc_begin(d_module, 'p_deliver_to_loc_id', p_deliver_to_loc_id);
13489: END IF;
13490:
13491: d_progress := 10;
13492:

Line 13504: IF (PO_LOG.d_stmt) THEN

13500: l_found := TRUE;
13501:
13502: EXCEPTION
13503: WHEN NO_DATA_FOUND THEN
13504: IF (PO_LOG.d_stmt) THEN
13505: PO_LOG.stmt(d_module, d_progress, 'No data found in hr_locations.');
13506: END IF;
13507: END;
13508:

Line 13505: PO_LOG.stmt(d_module, d_progress, 'No data found in hr_locations.');

13501:
13502: EXCEPTION
13503: WHEN NO_DATA_FOUND THEN
13504: IF (PO_LOG.d_stmt) THEN
13505: PO_LOG.stmt(d_module, d_progress, 'No data found in hr_locations.');
13506: END IF;
13507: END;
13508:
13509: d_progress := 20;

Line 13524: IF (PO_LOG.d_stmt) THEN

13520: l_found := TRUE;
13521:
13522: EXCEPTION
13523: WHEN NO_DATA_FOUND THEN
13524: IF (PO_LOG.d_stmt) THEN
13525: PO_LOG.stmt(d_module, d_progress, 'No data found in hz_locations.');
13526: END IF;
13527: END;
13528:

Line 13525: PO_LOG.stmt(d_module, d_progress, 'No data found in hz_locations.');

13521:
13522: EXCEPTION
13523: WHEN NO_DATA_FOUND THEN
13524: IF (PO_LOG.d_stmt) THEN
13525: PO_LOG.stmt(d_module, d_progress, 'No data found in hz_locations.');
13526: END IF;
13527: END;
13528:
13529: END IF; -- if not l_found

Line 13535: IF (PO_LOG.d_proc) THEN

13531: IF (NOT l_found) THEN
13532: RAISE NO_DATA_FOUND;
13533: END IF;
13534:
13535: IF (PO_LOG.d_proc) THEN
13536: PO_LOG.proc_return(d_module, l_ship_to_location_id);
13537: PO_LOG.proc_end(d_module);
13538: END IF;
13539:

Line 13536: PO_LOG.proc_return(d_module, l_ship_to_location_id);

13532: RAISE NO_DATA_FOUND;
13533: END IF;
13534:
13535: IF (PO_LOG.d_proc) THEN
13536: PO_LOG.proc_return(d_module, l_ship_to_location_id);
13537: PO_LOG.proc_end(d_module);
13538: END IF;
13539:
13540: RETURN l_ship_to_location_id;

Line 13537: PO_LOG.proc_end(d_module);

13533: END IF;
13534:
13535: IF (PO_LOG.d_proc) THEN
13536: PO_LOG.proc_return(d_module, l_ship_to_location_id);
13537: PO_LOG.proc_end(d_module);
13538: END IF;
13539:
13540: RETURN l_ship_to_location_id;
13541:

Line 13544: IF (PO_LOG.d_exc) THEN

13540: RETURN l_ship_to_location_id;
13541:
13542: EXCEPTION
13543: WHEN OTHERS THEN
13544: IF (PO_LOG.d_exc) THEN
13545: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
13546: END IF;
13547: wrapup(interface.interface_header_id);
13548: RAISE;

Line 13545: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

13541:
13542: EXCEPTION
13543: WHEN OTHERS THEN
13544: IF (PO_LOG.d_exc) THEN
13545: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
13546: END IF;
13547: wrapup(interface.interface_header_id);
13548: RAISE;
13549: END;

Line 14084: IF (PO_LOG.d_proc) THEN

14080:
14081: BEGIN
14082:
14083: d_progress := 0;
14084: IF (PO_LOG.d_proc) THEN
14085: PO_LOG.proc_begin(d_module);
14086: PO_LOG.proc_begin(d_module, 'p_interface_line_id', p_interface_line_id);
14087: PO_LOG.proc_begin(d_module, 'p_po_line_id', p_po_line_id);
14088: END IF;

Line 14085: PO_LOG.proc_begin(d_module);

14081: BEGIN
14082:
14083: d_progress := 0;
14084: IF (PO_LOG.d_proc) THEN
14085: PO_LOG.proc_begin(d_module);
14086: PO_LOG.proc_begin(d_module, 'p_interface_line_id', p_interface_line_id);
14087: PO_LOG.proc_begin(d_module, 'p_po_line_id', p_po_line_id);
14088: END IF;
14089:

Line 14086: PO_LOG.proc_begin(d_module, 'p_interface_line_id', p_interface_line_id);

14082:
14083: d_progress := 0;
14084: IF (PO_LOG.d_proc) THEN
14085: PO_LOG.proc_begin(d_module);
14086: PO_LOG.proc_begin(d_module, 'p_interface_line_id', p_interface_line_id);
14087: PO_LOG.proc_begin(d_module, 'p_po_line_id', p_po_line_id);
14088: END IF;
14089:
14090: d_progress := 10;

Line 14087: PO_LOG.proc_begin(d_module, 'p_po_line_id', p_po_line_id);

14083: d_progress := 0;
14084: IF (PO_LOG.d_proc) THEN
14085: PO_LOG.proc_begin(d_module);
14086: PO_LOG.proc_begin(d_module, 'p_interface_line_id', p_interface_line_id);
14087: PO_LOG.proc_begin(d_module, 'p_po_line_id', p_po_line_id);
14088: END IF;
14089:
14090: d_progress := 10;
14091:

Line 14115: IF (PO_LOG.d_stmt) THEN

14111: l_isFinancing := PO_COMPLEX_WORK_PVT.is_financing_po(
14112: p_po_header_id => l_po_header_id
14113: );
14114:
14115: IF (PO_LOG.d_stmt) THEN
14116: PO_LOG.stmt(d_module, d_progress, 'l_isFinancing', l_isFinancing);
14117: END IF;
14118:
14119: d_progress := 30;

Line 14116: PO_LOG.stmt(d_module, d_progress, 'l_isFinancing', l_isFinancing);

14112: p_po_header_id => l_po_header_id
14113: );
14114:
14115: IF (PO_LOG.d_stmt) THEN
14116: PO_LOG.stmt(d_module, d_progress, 'l_isFinancing', l_isFinancing);
14117: END IF;
14118:
14119: d_progress := 30;
14120:

Line 14231: IF (PO_LOG.d_stmt) THEN

14227: END IF; -- if l_isFinancing
14228:
14229: d_progress := 80;
14230:
14231: IF (PO_LOG.d_stmt) THEN
14232: PO_LOG.stmt(d_module, d_progress, 'interface.has_advance_flag', interface.has_advance_flag);
14233: END IF;
14234:
14235: IF (interface.has_advance_flag = 'Y') THEN

Line 14232: PO_LOG.stmt(d_module, d_progress, 'interface.has_advance_flag', interface.has_advance_flag);

14228:
14229: d_progress := 80;
14230:
14231: IF (PO_LOG.d_stmt) THEN
14232: PO_LOG.stmt(d_module, d_progress, 'interface.has_advance_flag', interface.has_advance_flag);
14233: END IF;
14234:
14235: IF (interface.has_advance_flag = 'Y') THEN
14236:

Line 14384: IF (PO_LOG.d_stmt) THEN

14380: EXIT WHEN poll_interface_cursor%NOTFOUND;
14381:
14382: d_progress := 160;
14383:
14384: IF (PO_LOG.d_stmt) THEN
14385: PO_LOG.stmt(d_module, d_progress, 'Getting receiving controls.');
14386: END IF;
14387:
14388: RCV_CORE_S.get_receiving_controls(

Line 14385: PO_LOG.stmt(d_module, d_progress, 'Getting receiving controls.');

14381:
14382: d_progress := 160;
14383:
14384: IF (PO_LOG.d_stmt) THEN
14385: PO_LOG.stmt(d_module, d_progress, 'Getting receiving controls.');
14386: END IF;
14387:
14388: RCV_CORE_S.get_receiving_controls(
14389: p_order_type_lookup_code => line_location_rec.value_basis

Line 14409: IF (PO_LOG.d_stmt) THEN

14405: , x_receipt_days_exception_code => payitem_rcv_ctl_rec.receipt_days_exception_code
14406: );
14407:
14408: d_progress := 200;
14409: IF (PO_LOG.d_stmt) THEN
14410: PO_LOG.stmt(d_module, d_progress, 'Getting default country of origin');
14411: END IF;
14412:
14413: po_coo_s.get_default_country_of_origin(

Line 14410: PO_LOG.stmt(d_module, d_progress, 'Getting default country of origin');

14406: );
14407:
14408: d_progress := 200;
14409: IF (PO_LOG.d_stmt) THEN
14410: PO_LOG.stmt(d_module, d_progress, 'Getting default country of origin');
14411: END IF;
14412:
14413: po_coo_s.get_default_country_of_origin(
14414: x_item_id => interface.item_id

Line 14422: IF (PO_LOG.d_stmt) THEN

14418: , x_country_of_origin => l_country_of_origin_code
14419: );
14420:
14421: d_progress := 210;
14422: IF (PO_LOG.d_stmt) THEN
14423: PO_LOG.stmt(d_module, d_progress, 'Inserting payitem into po_line_locations_all');
14424: END IF;
14425:
14426: -- insert payitem into po_line_locations_all

Line 14423: PO_LOG.stmt(d_module, d_progress, 'Inserting payitem into po_line_locations_all');

14419: );
14420:
14421: d_progress := 210;
14422: IF (PO_LOG.d_stmt) THEN
14423: PO_LOG.stmt(d_module, d_progress, 'Inserting payitem into po_line_locations_all');
14424: END IF;
14425:
14426: -- insert payitem into po_line_locations_all
14427:

Line 14612: IF (PO_LOG.d_stmt) THEN

14608: )
14609: RETURNING line_location_id INTO l_line_loc_id;
14610:
14611: d_progress := 220;
14612: IF (PO_LOG.d_stmt) THEN
14613: PO_LOG.stmt(d_module, d_progress, 'Inserted payitem.');
14614: PO_LOG.stmt(d_module, d_progress, 'l_line_loc_id', l_line_loc_id);
14615: END IF;
14616:

Line 14613: PO_LOG.stmt(d_module, d_progress, 'Inserted payitem.');

14609: RETURNING line_location_id INTO l_line_loc_id;
14610:
14611: d_progress := 220;
14612: IF (PO_LOG.d_stmt) THEN
14613: PO_LOG.stmt(d_module, d_progress, 'Inserted payitem.');
14614: PO_LOG.stmt(d_module, d_progress, 'l_line_loc_id', l_line_loc_id);
14615: END IF;
14616:
14617: d_progress := 230;

Line 14614: PO_LOG.stmt(d_module, d_progress, 'l_line_loc_id', l_line_loc_id);

14610:
14611: d_progress := 220;
14612: IF (PO_LOG.d_stmt) THEN
14613: PO_LOG.stmt(d_module, d_progress, 'Inserted payitem.');
14614: PO_LOG.stmt(d_module, d_progress, 'l_line_loc_id', l_line_loc_id);
14615: END IF;
14616:
14617: d_progress := 230;
14618:

Line 14648: IF (PO_LOG.d_stmt) THEN

14644:
14645: d_progress := 300;
14646:
14647: -- call create_payitem_dists to create distributions for all new payitems
14648: IF (PO_LOG.d_stmt) THEN
14649: PO_LOG.stmt(d_module, d_progress, 'Ready to call create_payitem_dists');
14650: END IF;
14651:
14652: create_payitem_dists(

Line 14649: PO_LOG.stmt(d_module, d_progress, 'Ready to call create_payitem_dists');

14645: d_progress := 300;
14646:
14647: -- call create_payitem_dists to create distributions for all new payitems
14648: IF (PO_LOG.d_stmt) THEN
14649: PO_LOG.stmt(d_module, d_progress, 'Ready to call create_payitem_dists');
14650: END IF;
14651:
14652: create_payitem_dists(
14653: p_po_line_id => p_po_line_id

Line 14662: IF (PO_LOG.d_stmt) THEN

14658: );
14659:
14660: d_progress := 310;
14661:
14662: IF (PO_LOG.d_stmt) THEN
14663: PO_LOG.stmt(d_module, d_progress, 'Done calling create_payitem dists');
14664: END IF;
14665:
14666: d_progress := 400;

Line 14663: PO_LOG.stmt(d_module, d_progress, 'Done calling create_payitem dists');

14659:
14660: d_progress := 310;
14661:
14662: IF (PO_LOG.d_stmt) THEN
14663: PO_LOG.stmt(d_module, d_progress, 'Done calling create_payitem dists');
14664: END IF;
14665:
14666: d_progress := 400;
14667:

Line 14668: IF (PO_LOG.d_stmt) THEN

14664: END IF;
14665:
14666: d_progress := 400;
14667:
14668: IF (PO_LOG.d_stmt) THEN
14669: PO_LOG.stmt(d_module, d_progress, 'calling tax api ');
14670: END IF;
14671:
14672: d_progress := 1420;

Line 14669: PO_LOG.stmt(d_module, d_progress, 'calling tax api ');

14665:
14666: d_progress := 400;
14667:
14668: IF (PO_LOG.d_stmt) THEN
14669: PO_LOG.stmt(d_module, d_progress, 'calling tax api ');
14670: END IF;
14671:
14672: d_progress := 1420;
14673:

Line 14674: IF (PO_LOG.d_proc) THEN

14670: END IF;
14671:
14672: d_progress := 1420;
14673:
14674: IF (PO_LOG.d_proc) THEN
14675: PO_LOG.proc_end(d_module, 'x_line_location_id', x_line_location_id);
14676: PO_LOG.proc_end(d_module, 'x_line_loc_id_tbl', x_line_loc_id_tbl);
14677: PO_LOG.proc_end(d_module);
14678: END IF;

Line 14675: PO_LOG.proc_end(d_module, 'x_line_location_id', x_line_location_id);

14671:
14672: d_progress := 1420;
14673:
14674: IF (PO_LOG.d_proc) THEN
14675: PO_LOG.proc_end(d_module, 'x_line_location_id', x_line_location_id);
14676: PO_LOG.proc_end(d_module, 'x_line_loc_id_tbl', x_line_loc_id_tbl);
14677: PO_LOG.proc_end(d_module);
14678: END IF;
14679:

Line 14676: PO_LOG.proc_end(d_module, 'x_line_loc_id_tbl', x_line_loc_id_tbl);

14672: d_progress := 1420;
14673:
14674: IF (PO_LOG.d_proc) THEN
14675: PO_LOG.proc_end(d_module, 'x_line_location_id', x_line_location_id);
14676: PO_LOG.proc_end(d_module, 'x_line_loc_id_tbl', x_line_loc_id_tbl);
14677: PO_LOG.proc_end(d_module);
14678: END IF;
14679:
14680: EXCEPTION

Line 14677: PO_LOG.proc_end(d_module);

14673:
14674: IF (PO_LOG.d_proc) THEN
14675: PO_LOG.proc_end(d_module, 'x_line_location_id', x_line_location_id);
14676: PO_LOG.proc_end(d_module, 'x_line_loc_id_tbl', x_line_loc_id_tbl);
14677: PO_LOG.proc_end(d_module);
14678: END IF;
14679:
14680: EXCEPTION
14681: WHEN OTHERS THEN

Line 14683: IF (PO_LOG.d_exc) THEN

14679:
14680: EXCEPTION
14681: WHEN OTHERS THEN
14682:
14683: IF (PO_LOG.d_exc) THEN
14684: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
14685: END IF;
14686:
14687: IF (poll_interface_cursor%ISOPEN) THEN

Line 14684: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

14680: EXCEPTION
14681: WHEN OTHERS THEN
14682:
14683: IF (PO_LOG.d_exc) THEN
14684: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
14685: END IF;
14686:
14687: IF (poll_interface_cursor%ISOPEN) THEN
14688: CLOSE poll_interface_cursor;

Line 14814: IF (PO_LOG.d_proc) THEN

14810:
14811: BEGIN
14812:
14813: d_progress := 0;
14814: IF (PO_LOG.d_proc) THEN
14815: PO_LOG.proc_begin(d_module);
14816: PO_LOG.proc_begin(d_module, 'p_po_line_id', p_po_line_id);
14817: PO_LOG.proc_begin(d_module, 'p_req_line_id', p_req_line_id);
14818: PO_LOG.proc_begin(d_module, 'p_interface_line_id', p_interface_line_id);

Line 14815: PO_LOG.proc_begin(d_module);

14811: BEGIN
14812:
14813: d_progress := 0;
14814: IF (PO_LOG.d_proc) THEN
14815: PO_LOG.proc_begin(d_module);
14816: PO_LOG.proc_begin(d_module, 'p_po_line_id', p_po_line_id);
14817: PO_LOG.proc_begin(d_module, 'p_req_line_id', p_req_line_id);
14818: PO_LOG.proc_begin(d_module, 'p_interface_line_id', p_interface_line_id);
14819: END IF;

Line 14816: PO_LOG.proc_begin(d_module, 'p_po_line_id', p_po_line_id);

14812:
14813: d_progress := 0;
14814: IF (PO_LOG.d_proc) THEN
14815: PO_LOG.proc_begin(d_module);
14816: PO_LOG.proc_begin(d_module, 'p_po_line_id', p_po_line_id);
14817: PO_LOG.proc_begin(d_module, 'p_req_line_id', p_req_line_id);
14818: PO_LOG.proc_begin(d_module, 'p_interface_line_id', p_interface_line_id);
14819: END IF;
14820:

Line 14817: PO_LOG.proc_begin(d_module, 'p_req_line_id', p_req_line_id);

14813: d_progress := 0;
14814: IF (PO_LOG.d_proc) THEN
14815: PO_LOG.proc_begin(d_module);
14816: PO_LOG.proc_begin(d_module, 'p_po_line_id', p_po_line_id);
14817: PO_LOG.proc_begin(d_module, 'p_req_line_id', p_req_line_id);
14818: PO_LOG.proc_begin(d_module, 'p_interface_line_id', p_interface_line_id);
14819: END IF;
14820:
14821: d_progress := 10;

Line 14818: PO_LOG.proc_begin(d_module, 'p_interface_line_id', p_interface_line_id);

14814: IF (PO_LOG.d_proc) THEN
14815: PO_LOG.proc_begin(d_module);
14816: PO_LOG.proc_begin(d_module, 'p_po_line_id', p_po_line_id);
14817: PO_LOG.proc_begin(d_module, 'p_req_line_id', p_req_line_id);
14818: PO_LOG.proc_begin(d_module, 'p_interface_line_id', p_interface_line_id);
14819: END IF;
14820:
14821: d_progress := 10;
14822:

Line 14856: IF (PO_LOG.d_exc) THEN

14852: );
14853:
14854: IF (params.period_name IS NULL) THEN
14855: d_progress := 50;
14856: IF (PO_LOG.d_exc) THEN
14857: PO_LOG.exc(d_module, d_progress, 'Unable to find period name for SYSDATE');
14858: END IF;
14859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
14860: END IF;

Line 14857: PO_LOG.exc(d_module, d_progress, 'Unable to find period name for SYSDATE');

14853:
14854: IF (params.period_name IS NULL) THEN
14855: d_progress := 50;
14856: IF (PO_LOG.d_exc) THEN
14857: PO_LOG.exc(d_module, d_progress, 'Unable to find period name for SYSDATE');
14858: END IF;
14859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
14860: END IF;
14861:

Line 15004: IF (PO_LOG.d_stmt) THEN

15000: AND prl.requisition_line_id = prd.requisition_line_id
15001: AND poll.payment_type <> 'ADVANCE';
15002:
15003: d_progress := 70;
15004: IF (PO_LOG.d_stmt) THEN
15005: PO_LOG.stmt(d_module, d_progress, 'Payitems distributions created from requisition distributions.');
15006: END IF;
15007:
15008: ELSE

Line 15005: PO_LOG.stmt(d_module, d_progress, 'Payitems distributions created from requisition distributions.');

15001: AND poll.payment_type <> 'ADVANCE';
15002:
15003: d_progress := 70;
15004: IF (PO_LOG.d_stmt) THEN
15005: PO_LOG.stmt(d_module, d_progress, 'Payitems distributions created from requisition distributions.');
15006: END IF;
15007:
15008: ELSE
15009:

Line 15030: IF (PO_LOG.d_exc) THEN

15026: );
15027:
15028: IF (params.period_name IS NULL) THEN
15029: d_progress := 100;
15030: IF (PO_LOG.d_exc) THEN
15031: PO_LOG.exc(d_module, d_progress, 'Unable to find period name for SYSDATE');
15032: END IF;
15033: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
15034: END IF;

Line 15031: PO_LOG.exc(d_module, d_progress, 'Unable to find period name for SYSDATE');

15027:
15028: IF (params.period_name IS NULL) THEN
15029: d_progress := 100;
15030: IF (PO_LOG.d_exc) THEN
15031: PO_LOG.exc(d_module, d_progress, 'Unable to find period name for SYSDATE');
15032: END IF;
15033: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
15034: END IF;
15035:

Line 15133: IF (PO_LOG.d_stmt) THEN

15129: AND poll.line_location_id = polli.line_location_id
15130: AND poll.payment_type <> 'ADVANCE';
15131:
15132: d_progress := 120;
15133: IF (PO_LOG.d_stmt) THEN
15134: PO_LOG.stmt(d_module, d_progress, 'Payitems distributions created from scratch.');
15135: END IF;
15136:
15137: END IF; -- if p_req_line_id IS NOT NULL

Line 15134: PO_LOG.stmt(d_module, d_progress, 'Payitems distributions created from scratch.');

15130: AND poll.payment_type <> 'ADVANCE';
15131:
15132: d_progress := 120;
15133: IF (PO_LOG.d_stmt) THEN
15134: PO_LOG.stmt(d_module, d_progress, 'Payitems distributions created from scratch.');
15135: END IF;
15136:
15137: END IF; -- if p_req_line_id IS NOT NULL
15138:

Line 15254: IF (PO_LOG.d_stmt) THEN

15250: AND poll2.shipment_type = 'STANDARD'))
15251: AND pod.line_location_id = deliv.line_location_id;
15252:
15253: d_progress := 150;
15254: IF (PO_LOG.d_stmt) THEN
15255: PO_LOG.stmt(d_module, d_progress, 'Advance distributions created.');
15256: END IF;
15257:
15258: END IF; -- if interface.has_advance_flag

Line 15255: PO_LOG.stmt(d_module, d_progress, 'Advance distributions created.');

15251: AND pod.line_location_id = deliv.line_location_id;
15252:
15253: d_progress := 150;
15254: IF (PO_LOG.d_stmt) THEN
15255: PO_LOG.stmt(d_module, d_progress, 'Advance distributions created.');
15256: END IF;
15257:
15258: END IF; -- if interface.has_advance_flag
15259:

Line 15292: IF (PO_LOG.d_stmt) THEN

15288: FETCH payitem_acct_gen_cursor INTO payitem_acct_rec;
15289: EXIT WHEN payitem_acct_gen_cursor%NOTFOUND;
15290:
15291: d_progress := 180;
15292: IF (PO_LOG.d_stmt) THEN
15293: PO_LOG.stmt(d_module, d_progress, 'Calling account generator wf method.');
15294: PO_LOG.stmt(d_module, d_progress, 'payitem_acct_rec.po_distribution_id', payitem_acct_rec.po_distribution_id);
15295: END IF;
15296:

Line 15293: PO_LOG.stmt(d_module, d_progress, 'Calling account generator wf method.');

15289: EXIT WHEN payitem_acct_gen_cursor%NOTFOUND;
15290:
15291: d_progress := 180;
15292: IF (PO_LOG.d_stmt) THEN
15293: PO_LOG.stmt(d_module, d_progress, 'Calling account generator wf method.');
15294: PO_LOG.stmt(d_module, d_progress, 'payitem_acct_rec.po_distribution_id', payitem_acct_rec.po_distribution_id);
15295: END IF;
15296:
15297: l_acct_api_success := PO_WF_BUILD_ACCOUNT_INIT.Start_Workflow(

Line 15294: PO_LOG.stmt(d_module, d_progress, 'payitem_acct_rec.po_distribution_id', payitem_acct_rec.po_distribution_id);

15290:
15291: d_progress := 180;
15292: IF (PO_LOG.d_stmt) THEN
15293: PO_LOG.stmt(d_module, d_progress, 'Calling account generator wf method.');
15294: PO_LOG.stmt(d_module, d_progress, 'payitem_acct_rec.po_distribution_id', payitem_acct_rec.po_distribution_id);
15295: END IF;
15296:
15297: l_acct_api_success := PO_WF_BUILD_ACCOUNT_INIT.Start_Workflow(
15298: x_purchasing_ou_id => g_purchasing_ou_id

Line 15428: IF (PO_LOG.d_stmt) THEN

15424: , p_payment_type => payitem_acct_rec.payment_type
15425: );
15426:
15427: d_progress := 190;
15428: IF (PO_LOG.d_stmt) THEN
15429: PO_LOG.stmt(d_module, d_progress, 'Finished account generator call.');
15430: PO_LOG.stmt(d_module, d_progress, 'l_acct_api_success', l_acct_api_success);
15431: PO_LOG.stmt(d_module, d_progress, 'l_charge_success', l_charge_success);
15432: PO_LOG.stmt(d_module, d_progress, 'l_variance_success', l_variance_success);

Line 15429: PO_LOG.stmt(d_module, d_progress, 'Finished account generator call.');

15425: );
15426:
15427: d_progress := 190;
15428: IF (PO_LOG.d_stmt) THEN
15429: PO_LOG.stmt(d_module, d_progress, 'Finished account generator call.');
15430: PO_LOG.stmt(d_module, d_progress, 'l_acct_api_success', l_acct_api_success);
15431: PO_LOG.stmt(d_module, d_progress, 'l_charge_success', l_charge_success);
15432: PO_LOG.stmt(d_module, d_progress, 'l_variance_success', l_variance_success);
15433: PO_LOG.stmt(d_module, d_progress, 'l_budget_success', l_budget_success);

Line 15430: PO_LOG.stmt(d_module, d_progress, 'l_acct_api_success', l_acct_api_success);

15426:
15427: d_progress := 190;
15428: IF (PO_LOG.d_stmt) THEN
15429: PO_LOG.stmt(d_module, d_progress, 'Finished account generator call.');
15430: PO_LOG.stmt(d_module, d_progress, 'l_acct_api_success', l_acct_api_success);
15431: PO_LOG.stmt(d_module, d_progress, 'l_charge_success', l_charge_success);
15432: PO_LOG.stmt(d_module, d_progress, 'l_variance_success', l_variance_success);
15433: PO_LOG.stmt(d_module, d_progress, 'l_budget_success', l_budget_success);
15434: PO_LOG.stmt(d_module, d_progress, 'l_accrual_success', l_accrual_success);

Line 15431: PO_LOG.stmt(d_module, d_progress, 'l_charge_success', l_charge_success);

15427: d_progress := 190;
15428: IF (PO_LOG.d_stmt) THEN
15429: PO_LOG.stmt(d_module, d_progress, 'Finished account generator call.');
15430: PO_LOG.stmt(d_module, d_progress, 'l_acct_api_success', l_acct_api_success);
15431: PO_LOG.stmt(d_module, d_progress, 'l_charge_success', l_charge_success);
15432: PO_LOG.stmt(d_module, d_progress, 'l_variance_success', l_variance_success);
15433: PO_LOG.stmt(d_module, d_progress, 'l_budget_success', l_budget_success);
15434: PO_LOG.stmt(d_module, d_progress, 'l_accrual_success', l_accrual_success);
15435: END IF;

Line 15432: PO_LOG.stmt(d_module, d_progress, 'l_variance_success', l_variance_success);

15428: IF (PO_LOG.d_stmt) THEN
15429: PO_LOG.stmt(d_module, d_progress, 'Finished account generator call.');
15430: PO_LOG.stmt(d_module, d_progress, 'l_acct_api_success', l_acct_api_success);
15431: PO_LOG.stmt(d_module, d_progress, 'l_charge_success', l_charge_success);
15432: PO_LOG.stmt(d_module, d_progress, 'l_variance_success', l_variance_success);
15433: PO_LOG.stmt(d_module, d_progress, 'l_budget_success', l_budget_success);
15434: PO_LOG.stmt(d_module, d_progress, 'l_accrual_success', l_accrual_success);
15435: END IF;
15436:

Line 15433: PO_LOG.stmt(d_module, d_progress, 'l_budget_success', l_budget_success);

15429: PO_LOG.stmt(d_module, d_progress, 'Finished account generator call.');
15430: PO_LOG.stmt(d_module, d_progress, 'l_acct_api_success', l_acct_api_success);
15431: PO_LOG.stmt(d_module, d_progress, 'l_charge_success', l_charge_success);
15432: PO_LOG.stmt(d_module, d_progress, 'l_variance_success', l_variance_success);
15433: PO_LOG.stmt(d_module, d_progress, 'l_budget_success', l_budget_success);
15434: PO_LOG.stmt(d_module, d_progress, 'l_accrual_success', l_accrual_success);
15435: END IF;
15436:
15437: -- follow same behavior as with shipment distributions:

Line 15434: PO_LOG.stmt(d_module, d_progress, 'l_accrual_success', l_accrual_success);

15430: PO_LOG.stmt(d_module, d_progress, 'l_acct_api_success', l_acct_api_success);
15431: PO_LOG.stmt(d_module, d_progress, 'l_charge_success', l_charge_success);
15432: PO_LOG.stmt(d_module, d_progress, 'l_variance_success', l_variance_success);
15433: PO_LOG.stmt(d_module, d_progress, 'l_budget_success', l_budget_success);
15434: PO_LOG.stmt(d_module, d_progress, 'l_accrual_success', l_accrual_success);
15435: END IF;
15436:
15437: -- follow same behavior as with shipment distributions:
15438: -- if account generator failed, do not create distribution

Line 15451: IF (PO_LOG.d_stmt) THEN

15447: AND (l_budget_success OR (NVL(params.po_encumbrance_flag, 'N') <> 'Y')))
15448: THEN
15449:
15450: d_progress := 210;
15451: IF (PO_LOG.d_stmt) THEN
15452: PO_LOG.stmt(d_module, d_progress, 'Updating dist. with acct. info');
15453: END IF;
15454:
15455: --SQL WHAT: Update account information for a po distribution

Line 15452: PO_LOG.stmt(d_module, d_progress, 'Updating dist. with acct. info');

15448: THEN
15449:
15450: d_progress := 210;
15451: IF (PO_LOG.d_stmt) THEN
15452: PO_LOG.stmt(d_module, d_progress, 'Updating dist. with acct. info');
15453: END IF;
15454:
15455: --SQL WHAT: Update account information for a po distribution
15456: --SQL WHY : PO Distributions that don't have a backing req need to

Line 15471: IF (PO_LOG.d_stmt) THEN

15467:
15468: ELSE
15469:
15470: d_progress := 220;
15471: IF (PO_LOG.d_stmt) THEN
15472: PO_LOG.stmt(d_module, d_progress, 'Deleting distribution - acct. gen failure');
15473: END IF;
15474:
15475: DELETE FROM po_distributions_all pod

Line 15472: PO_LOG.stmt(d_module, d_progress, 'Deleting distribution - acct. gen failure');

15468: ELSE
15469:
15470: d_progress := 220;
15471: IF (PO_LOG.d_stmt) THEN
15472: PO_LOG.stmt(d_module, d_progress, 'Deleting distribution - acct. gen failure');
15473: END IF;
15474:
15475: DELETE FROM po_distributions_all pod
15476: WHERE pod.po_distribution_id =

Line 15485: IF (PO_LOG.d_stmt) THEN

15481: END LOOP; -- payitem_acct_gen_cursor loop
15482: CLOSE payitem_acct_gen_cursor;
15483:
15484: d_progress := 300;
15485: IF (PO_LOG.d_stmt) THEN
15486: PO_LOG.stmt(d_module, d_progress, 'Calling update_award_distributions');
15487: END IF;
15488:
15489: update_award_distributions(

Line 15486: PO_LOG.stmt(d_module, d_progress, 'Calling update_award_distributions');

15482: CLOSE payitem_acct_gen_cursor;
15483:
15484: d_progress := 300;
15485: IF (PO_LOG.d_stmt) THEN
15486: PO_LOG.stmt(d_module, d_progress, 'Calling update_award_distributions');
15487: END IF;
15488:
15489: update_award_distributions(
15490: p_table_type => 'ALL'

Line 15508: IF (PO_LOG.d_proc) THEN

15504: LOOP
15505: calculate_local('PO', 'DISTRIBUTION', l_dist_id_tbl(i));
15506: END LOOP;
15507:
15508: IF (PO_LOG.d_proc) THEN
15509: PO_LOG.proc_end(d_module);
15510: END IF;
15511:
15512: EXCEPTION

Line 15509: PO_LOG.proc_end(d_module);

15505: calculate_local('PO', 'DISTRIBUTION', l_dist_id_tbl(i));
15506: END LOOP;
15507:
15508: IF (PO_LOG.d_proc) THEN
15509: PO_LOG.proc_end(d_module);
15510: END IF;
15511:
15512: EXCEPTION
15513: WHEN OTHERS THEN

Line 15514: IF (PO_LOG.d_exc) THEN

15510: END IF;
15511:
15512: EXCEPTION
15513: WHEN OTHERS THEN
15514: IF (PO_LOG.d_exc) THEN
15515: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
15516: END IF;
15517:
15518: IF (payitem_acct_gen_cursor%ISOPEN) THEN

Line 15515: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

15511:
15512: EXCEPTION
15513: WHEN OTHERS THEN
15514: IF (PO_LOG.d_exc) THEN
15515: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
15516: END IF;
15517:
15518: IF (payitem_acct_gen_cursor%ISOPEN) THEN
15519: CLOSE payitem_acct_gen_cursor;