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

Line 252: IF (PO_LOG.d_exc) THEN

248:
249:
250: IF (PO_AUTOCREATE_PARAMS.g_sys.period_name IS NULL) THEN
251: l_progress := 70;
252: IF (PO_LOG.d_exc) THEN
253: PO_LOG.exc(g_log_head||l_api_name, l_progress, 'Unable to find period name for SYSDATE');
254: END IF;
255:
256: --CLM Phase 2 changes : error handling

Line 253: PO_LOG.exc(g_log_head||l_api_name, l_progress, 'Unable to find period name for SYSDATE');

249:
250: IF (PO_AUTOCREATE_PARAMS.g_sys.period_name IS NULL) THEN
251: l_progress := 70;
252: IF (PO_LOG.d_exc) THEN
253: PO_LOG.exc(g_log_head||l_api_name, l_progress, 'Unable to find period name for SYSDATE');
254: END IF;
255:
256: --CLM Phase 2 changes : error handling
257: PO_AUTOCREATE_PVT.report_error('PO_AUTO_DIST_GL_PERIOD_ERR',x_token1_value => sqlerrm);

Line 918: IF (PO_LOG.d_proc) THEN

914:
915: FOR i IN 1..p_lines.intf_line_id_tbl.Count
916: LOOP
917: d_progress := 0;
918: IF (PO_LOG.d_proc) THEN
919: PO_LOG.proc_begin(d_module);
920: PO_LOG.proc_begin(d_module, 'p_po_line_id', p_lines.po_line_id_tbl(i));
921: PO_LOG.proc_begin(d_module, 'p_req_line_id', p_lines.requisition_line_id_tbl(i));
922: PO_LOG.proc_begin(d_module, 'p_interface_line_id', p_lines.intf_line_id_tbl(i));

Line 919: PO_LOG.proc_begin(d_module);

915: FOR i IN 1..p_lines.intf_line_id_tbl.Count
916: LOOP
917: d_progress := 0;
918: IF (PO_LOG.d_proc) THEN
919: PO_LOG.proc_begin(d_module);
920: PO_LOG.proc_begin(d_module, 'p_po_line_id', p_lines.po_line_id_tbl(i));
921: PO_LOG.proc_begin(d_module, 'p_req_line_id', p_lines.requisition_line_id_tbl(i));
922: PO_LOG.proc_begin(d_module, 'p_interface_line_id', p_lines.intf_line_id_tbl(i));
923: END IF;

Line 920: PO_LOG.proc_begin(d_module, 'p_po_line_id', p_lines.po_line_id_tbl(i));

916: LOOP
917: d_progress := 0;
918: IF (PO_LOG.d_proc) THEN
919: PO_LOG.proc_begin(d_module);
920: PO_LOG.proc_begin(d_module, 'p_po_line_id', p_lines.po_line_id_tbl(i));
921: PO_LOG.proc_begin(d_module, 'p_req_line_id', p_lines.requisition_line_id_tbl(i));
922: PO_LOG.proc_begin(d_module, 'p_interface_line_id', p_lines.intf_line_id_tbl(i));
923: END IF;
924:

Line 921: PO_LOG.proc_begin(d_module, 'p_req_line_id', p_lines.requisition_line_id_tbl(i));

917: d_progress := 0;
918: IF (PO_LOG.d_proc) THEN
919: PO_LOG.proc_begin(d_module);
920: PO_LOG.proc_begin(d_module, 'p_po_line_id', p_lines.po_line_id_tbl(i));
921: PO_LOG.proc_begin(d_module, 'p_req_line_id', p_lines.requisition_line_id_tbl(i));
922: PO_LOG.proc_begin(d_module, 'p_interface_line_id', p_lines.intf_line_id_tbl(i));
923: END IF;
924:
925: d_progress := 10;

Line 922: PO_LOG.proc_begin(d_module, 'p_interface_line_id', p_lines.intf_line_id_tbl(i));

918: IF (PO_LOG.d_proc) THEN
919: PO_LOG.proc_begin(d_module);
920: PO_LOG.proc_begin(d_module, 'p_po_line_id', p_lines.po_line_id_tbl(i));
921: PO_LOG.proc_begin(d_module, 'p_req_line_id', p_lines.requisition_line_id_tbl(i));
922: PO_LOG.proc_begin(d_module, 'p_interface_line_id', p_lines.intf_line_id_tbl(i));
923: END IF;
924:
925: d_progress := 10;
926: l_charge_success := TRUE;

Line 943: IF (PO_LOG.d_stmt) THEN

939: END IF;
940:
941: --Bug13553227
942: l_validate_gl_period := nvl(FND_PROFILE.VALUE('PO_VALIDATE_GL_PERIOD'),'Y');
943: IF (PO_LOG.d_stmt) THEN
944: PO_LOG.stmt(d_module, d_progress, 'l_validate_gl_period', l_validate_gl_period);
945: END IF;
946:
947: -- Bug 9960752: Added another IF condition for exercised distribution

Line 944: PO_LOG.stmt(d_module, d_progress, 'l_validate_gl_period', l_validate_gl_period);

940:
941: --Bug13553227
942: l_validate_gl_period := nvl(FND_PROFILE.VALUE('PO_VALIDATE_GL_PERIOD'),'Y');
943: IF (PO_LOG.d_stmt) THEN
944: PO_LOG.stmt(d_module, d_progress, 'l_validate_gl_period', l_validate_gl_period);
945: END IF;
946:
947: -- Bug 9960752: Added another IF condition for exercised distribution
948: IF p_lines.clm_option_indicator_tbl(i) = 'O' AND NVL(p_lines.clm_exercised_flag_tbl(i),'N') = 'N' THEN

Line 991: IF (PO_LOG.d_stmt) THEN

987:
988: END IF;
989: END IF;
990:
991: IF (PO_LOG.d_stmt) THEN
992: PO_LOG.stmt(d_module, d_progress, 'PO_AUTOCREATE_PARAMS.g_sys.period_name', PO_AUTOCREATE_PARAMS.g_sys.period_name);
993: END IF;
994:
995: IF (PO_AUTOCREATE_PARAMS.g_sys.period_name IS NULL) THEN

Line 992: PO_LOG.stmt(d_module, d_progress, 'PO_AUTOCREATE_PARAMS.g_sys.period_name', PO_AUTOCREATE_PARAMS.g_sys.period_name);

988: END IF;
989: END IF;
990:
991: IF (PO_LOG.d_stmt) THEN
992: PO_LOG.stmt(d_module, d_progress, 'PO_AUTOCREATE_PARAMS.g_sys.period_name', PO_AUTOCREATE_PARAMS.g_sys.period_name);
993: END IF;
994:
995: IF (PO_AUTOCREATE_PARAMS.g_sys.period_name IS NULL) THEN
996: d_progress := 70;

Line 997: IF (PO_LOG.d_exc) THEN

993: END IF;
994:
995: IF (PO_AUTOCREATE_PARAMS.g_sys.period_name IS NULL) THEN
996: d_progress := 70;
997: IF (PO_LOG.d_exc) THEN
998: PO_LOG.exc(d_module, d_progress, 'Unable to find period name for SYSDATE');
999: END IF;
1000:
1001: --CLM Phase 2 changes : error handling

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

994:
995: IF (PO_AUTOCREATE_PARAMS.g_sys.period_name IS NULL) THEN
996: d_progress := 70;
997: IF (PO_LOG.d_exc) THEN
998: PO_LOG.exc(d_module, d_progress, 'Unable to find period name for SYSDATE');
999: END IF;
1000:
1001: --CLM Phase 2 changes : error handling
1002: PO_AUTOCREATE_PVT.report_error('PO_AUTO_DIST_GL_PERIOD_ERR',x_token1_value => sqlerrm);

Line 1163: IF (PO_LOG.d_stmt) THEN

1159: AND prd.requisition_line_id = p_lines.requisition_line_id_tbl(i)
1160: AND prl.requisition_line_id = prd.requisition_line_id
1161: AND poll.payment_type <> 'ADVANCE';
1162:
1163: IF (PO_LOG.d_stmt) THEN
1164: PO_LOG.stmt(d_module, d_progress, 'Payitems distributions created from requisition distributions.');
1165: END IF;
1166:
1167: ELSE

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

1160: AND prl.requisition_line_id = prd.requisition_line_id
1161: AND poll.payment_type <> 'ADVANCE';
1162:
1163: IF (PO_LOG.d_stmt) THEN
1164: PO_LOG.stmt(d_module, d_progress, 'Payitems distributions created from requisition distributions.');
1165: END IF;
1166:
1167: ELSE
1168: -- no backing req exists; create distributions for payitems

Line 1190: IF (PO_LOG.d_stmt) THEN

1186:
1187: END IF;
1188: END IF;
1189:
1190: IF (PO_LOG.d_stmt) THEN
1191: PO_LOG.stmt(d_module, d_progress, 'PO_AUTOCREATE_PARAMS.g_sys.period_name', PO_AUTOCREATE_PARAMS.g_sys.period_name);
1192: END IF;
1193:
1194: IF (PO_AUTOCREATE_PARAMS.g_sys.period_name IS NULL) THEN

Line 1191: PO_LOG.stmt(d_module, d_progress, 'PO_AUTOCREATE_PARAMS.g_sys.period_name', PO_AUTOCREATE_PARAMS.g_sys.period_name);

1187: END IF;
1188: END IF;
1189:
1190: IF (PO_LOG.d_stmt) THEN
1191: PO_LOG.stmt(d_module, d_progress, 'PO_AUTOCREATE_PARAMS.g_sys.period_name', PO_AUTOCREATE_PARAMS.g_sys.period_name);
1192: END IF;
1193:
1194: IF (PO_AUTOCREATE_PARAMS.g_sys.period_name IS NULL) THEN
1195: d_progress := 90;

Line 1196: IF (PO_LOG.d_exc) THEN

1192: END IF;
1193:
1194: IF (PO_AUTOCREATE_PARAMS.g_sys.period_name IS NULL) THEN
1195: d_progress := 90;
1196: IF (PO_LOG.d_exc) THEN
1197: PO_LOG.exc(d_module, d_progress, 'Unable to find period name for SYSDATE');
1198: END IF;
1199:
1200: --CLM Phase 2 changes : error handling

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

1193:
1194: IF (PO_AUTOCREATE_PARAMS.g_sys.period_name IS NULL) THEN
1195: d_progress := 90;
1196: IF (PO_LOG.d_exc) THEN
1197: PO_LOG.exc(d_module, d_progress, 'Unable to find period name for SYSDATE');
1198: END IF;
1199:
1200: --CLM Phase 2 changes : error handling
1201: PO_AUTOCREATE_PVT.report_error('PO_AUTO_DIST_GL_PERIOD_ERR',x_token1_value => sqlerrm);

Line 1329: IF (PO_LOG.d_stmt) THEN

1325: WHERE poll.po_line_id = p_lines.po_line_id_tbl(i)
1326: AND poll.line_location_id = polli.line_location_id
1327: AND poll.payment_type <> 'ADVANCE';
1328:
1329: IF (PO_LOG.d_stmt) THEN
1330: PO_LOG.stmt(d_module, d_progress, 'Payitems distributions created from scratch.');
1331: END IF;
1332:
1333: END IF; -- if p_req_line_id IS NOT NULL

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

1326: AND poll.line_location_id = polli.line_location_id
1327: AND poll.payment_type <> 'ADVANCE';
1328:
1329: IF (PO_LOG.d_stmt) THEN
1330: PO_LOG.stmt(d_module, d_progress, 'Payitems distributions created from scratch.');
1331: END IF;
1332:
1333: END IF; -- if p_req_line_id IS NOT NULL
1334:

Line 1455: IF (PO_LOG.d_stmt) THEN

1451: )
1452: )
1453: AND pod.line_location_id = deliv.line_location_id;
1454:
1455: IF (PO_LOG.d_stmt) THEN
1456: PO_LOG.stmt(d_module, d_progress, 'Advance distributions created.');
1457: END IF;
1458:
1459: END IF; -- if interface.has_advance_flag

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

1452: )
1453: AND pod.line_location_id = deliv.line_location_id;
1454:
1455: IF (PO_LOG.d_stmt) THEN
1456: PO_LOG.stmt(d_module, d_progress, 'Advance distributions created.');
1457: END IF;
1458:
1459: END IF; -- if interface.has_advance_flag
1460:

Line 1494: IF (PO_LOG.d_stmt) THEN

1490: EXIT
1491: WHEN payitem_acct_gen_cursor%NOTFOUND;
1492: d_progress := 170;
1493:
1494: IF (PO_LOG.d_stmt) THEN
1495: PO_LOG.stmt(d_module, d_progress, 'Calling account generator wf method.');
1496: PO_LOG.stmt(d_module, d_progress, 'payitem_acct_rec.po_distribution_id', payitem_acct_rec.po_distribution_id);
1497: END IF;
1498:

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

1491: WHEN payitem_acct_gen_cursor%NOTFOUND;
1492: d_progress := 170;
1493:
1494: IF (PO_LOG.d_stmt) THEN
1495: PO_LOG.stmt(d_module, d_progress, 'Calling account generator wf method.');
1496: PO_LOG.stmt(d_module, d_progress, 'payitem_acct_rec.po_distribution_id', payitem_acct_rec.po_distribution_id);
1497: END IF;
1498:
1499: SELECT agent_id

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

1492: d_progress := 170;
1493:
1494: IF (PO_LOG.d_stmt) THEN
1495: PO_LOG.stmt(d_module, d_progress, 'Calling account generator wf method.');
1496: PO_LOG.stmt(d_module, d_progress, 'payitem_acct_rec.po_distribution_id', payitem_acct_rec.po_distribution_id);
1497: END IF;
1498:
1499: SELECT agent_id
1500: INTO l_agent_id

Line 1631: IF (PO_LOG.d_stmt) THEN

1627: p_distribution_type => payitem_acct_rec.distribution_type ,
1628: p_payment_type => payitem_acct_rec.payment_type );
1629:
1630: d_progress := 180;
1631: IF (PO_LOG.d_stmt) THEN
1632: PO_LOG.stmt(d_module, d_progress, 'Finished account generator call.');
1633: PO_LOG.stmt(d_module, d_progress, 'l_acct_api_success', l_acct_api_success);
1634: PO_LOG.stmt(d_module, d_progress, 'l_charge_success', l_charge_success);
1635: PO_LOG.stmt(d_module, d_progress, 'l_variance_success', l_variance_success);

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

1628: p_payment_type => payitem_acct_rec.payment_type );
1629:
1630: d_progress := 180;
1631: IF (PO_LOG.d_stmt) THEN
1632: PO_LOG.stmt(d_module, d_progress, 'Finished account generator call.');
1633: PO_LOG.stmt(d_module, d_progress, 'l_acct_api_success', l_acct_api_success);
1634: PO_LOG.stmt(d_module, d_progress, 'l_charge_success', l_charge_success);
1635: PO_LOG.stmt(d_module, d_progress, 'l_variance_success', l_variance_success);
1636: PO_LOG.stmt(d_module, d_progress, 'l_budget_success', l_budget_success);

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

1629:
1630: d_progress := 180;
1631: IF (PO_LOG.d_stmt) THEN
1632: PO_LOG.stmt(d_module, d_progress, 'Finished account generator call.');
1633: PO_LOG.stmt(d_module, d_progress, 'l_acct_api_success', l_acct_api_success);
1634: PO_LOG.stmt(d_module, d_progress, 'l_charge_success', l_charge_success);
1635: PO_LOG.stmt(d_module, d_progress, 'l_variance_success', l_variance_success);
1636: PO_LOG.stmt(d_module, d_progress, 'l_budget_success', l_budget_success);
1637: PO_LOG.stmt(d_module, d_progress, 'l_accrual_success', l_accrual_success);

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

1630: d_progress := 180;
1631: IF (PO_LOG.d_stmt) THEN
1632: PO_LOG.stmt(d_module, d_progress, 'Finished account generator call.');
1633: PO_LOG.stmt(d_module, d_progress, 'l_acct_api_success', l_acct_api_success);
1634: PO_LOG.stmt(d_module, d_progress, 'l_charge_success', l_charge_success);
1635: PO_LOG.stmt(d_module, d_progress, 'l_variance_success', l_variance_success);
1636: PO_LOG.stmt(d_module, d_progress, 'l_budget_success', l_budget_success);
1637: PO_LOG.stmt(d_module, d_progress, 'l_accrual_success', l_accrual_success);
1638: END IF;

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

1631: IF (PO_LOG.d_stmt) THEN
1632: PO_LOG.stmt(d_module, d_progress, 'Finished account generator call.');
1633: PO_LOG.stmt(d_module, d_progress, 'l_acct_api_success', l_acct_api_success);
1634: PO_LOG.stmt(d_module, d_progress, 'l_charge_success', l_charge_success);
1635: PO_LOG.stmt(d_module, d_progress, 'l_variance_success', l_variance_success);
1636: PO_LOG.stmt(d_module, d_progress, 'l_budget_success', l_budget_success);
1637: PO_LOG.stmt(d_module, d_progress, 'l_accrual_success', l_accrual_success);
1638: END IF;
1639: -- follow same behavior as with shipment distributions:

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

1632: PO_LOG.stmt(d_module, d_progress, 'Finished account generator call.');
1633: PO_LOG.stmt(d_module, d_progress, 'l_acct_api_success', l_acct_api_success);
1634: PO_LOG.stmt(d_module, d_progress, 'l_charge_success', l_charge_success);
1635: PO_LOG.stmt(d_module, d_progress, 'l_variance_success', l_variance_success);
1636: PO_LOG.stmt(d_module, d_progress, 'l_budget_success', l_budget_success);
1637: PO_LOG.stmt(d_module, d_progress, 'l_accrual_success', l_accrual_success);
1638: END IF;
1639: -- follow same behavior as with shipment distributions:
1640: -- if account generator failed, do not create distribution

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

1633: PO_LOG.stmt(d_module, d_progress, 'l_acct_api_success', l_acct_api_success);
1634: PO_LOG.stmt(d_module, d_progress, 'l_charge_success', l_charge_success);
1635: PO_LOG.stmt(d_module, d_progress, 'l_variance_success', l_variance_success);
1636: PO_LOG.stmt(d_module, d_progress, 'l_budget_success', l_budget_success);
1637: PO_LOG.stmt(d_module, d_progress, 'l_accrual_success', l_accrual_success);
1638: END IF;
1639: -- follow same behavior as with shipment distributions:
1640: -- if account generator failed, do not create distribution
1641: d_progress := 190;

Line 1647: IF (PO_LOG.d_stmt) THEN

1643: --Bug 5645242: Added the check to test if the charge account id generated is null or 0,
1644: --if this is the case, then we should delete the distribution record.
1645: AND (NVL(l_code_combination_id , 0) <> 0) AND l_variance_success AND l_accrual_success AND (l_budget_success OR (NVL(PO_AUTOCREATE_PARAMS.g_sys.po_encumbrance_flag, 'N') <> 'Y'))) THEN
1646: d_progress := 200;
1647: IF (PO_LOG.d_stmt) THEN
1648: PO_LOG.stmt(d_module, d_progress, 'Updating dist. with acct. info');
1649: END IF;
1650: --SQL WHAT: Update account information for a po distribution
1651: --SQL WHY : PO Distributions that don't have a backing req need to

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

1644: --if this is the case, then we should delete the distribution record.
1645: AND (NVL(l_code_combination_id , 0) <> 0) AND l_variance_success AND l_accrual_success AND (l_budget_success OR (NVL(PO_AUTOCREATE_PARAMS.g_sys.po_encumbrance_flag, 'N') <> 'Y'))) THEN
1646: d_progress := 200;
1647: IF (PO_LOG.d_stmt) THEN
1648: PO_LOG.stmt(d_module, d_progress, 'Updating dist. with acct. info');
1649: END IF;
1650: --SQL WHAT: Update account information for a po distribution
1651: --SQL WHY : PO Distributions that don't have a backing req need to
1652: -- have account defaulted from account generator.

Line 1664: IF (PO_LOG.d_stmt) THEN

1660:
1661: ELSE
1662: d_progress := 210;
1663:
1664: IF (PO_LOG.d_stmt) THEN
1665: PO_LOG.stmt(d_module, d_progress, 'Deleting distribution - acct. gen failure');
1666: END IF;
1667:
1668: DELETE

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

1661: ELSE
1662: d_progress := 210;
1663:
1664: IF (PO_LOG.d_stmt) THEN
1665: PO_LOG.stmt(d_module, d_progress, 'Deleting distribution - acct. gen failure');
1666: END IF;
1667:
1668: DELETE
1669: FROM po_distributions_draft_all pod

Line 1680: IF (PO_LOG.d_stmt) THEN

1676:
1677: CLOSE payitem_acct_gen_cursor;
1678: d_progress := 220;
1679:
1680: IF (PO_LOG.d_stmt) THEN
1681: PO_LOG.stmt(d_module, d_progress, 'Calling update_award_distributions');
1682: END IF;
1683:
1684: update_award_distributions( p_lines.intf_header_id_tbl(i) ,

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

1677: CLOSE payitem_acct_gen_cursor;
1678: d_progress := 220;
1679:
1680: IF (PO_LOG.d_stmt) THEN
1681: PO_LOG.stmt(d_module, d_progress, 'Calling update_award_distributions');
1682: END IF;
1683:
1684: update_award_distributions( p_lines.intf_header_id_tbl(i) ,
1685: p_lines.intf_line_id_tbl(i) ,

Line 1703: IF (PO_LOG.d_proc) THEN

1699: d_progress := 240;
1700: PO_AUTOCREATE_PVT.calculate_local('PO', 'DISTRIBUTION', l_dist_id_tbl(i));
1701: END LOOP;
1702:
1703: IF (PO_LOG.d_proc) THEN
1704: PO_LOG.proc_end(d_module);
1705: END IF;
1706: END IF;
1707: END IF;

Line 1704: PO_LOG.proc_end(d_module);

1700: PO_AUTOCREATE_PVT.calculate_local('PO', 'DISTRIBUTION', l_dist_id_tbl(i));
1701: END LOOP;
1702:
1703: IF (PO_LOG.d_proc) THEN
1704: PO_LOG.proc_end(d_module);
1705: END IF;
1706: END IF;
1707: END IF;
1708: END LOOP;

Line 1716: IF (PO_LOG.d_exc) THEN

1712: END IF;
1713:
1714: EXCEPTION
1715: WHEN OTHERS THEN
1716: IF (PO_LOG.d_exc) THEN
1717: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1718: END IF;
1719: IF (payitem_acct_gen_cursor%ISOPEN) THEN
1720: CLOSE payitem_acct_gen_cursor;

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

1713:
1714: EXCEPTION
1715: WHEN OTHERS THEN
1716: IF (PO_LOG.d_exc) THEN
1717: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1718: END IF;
1719: IF (payitem_acct_gen_cursor%ISOPEN) THEN
1720: CLOSE payitem_acct_gen_cursor;
1721: END IF;

Line 2050: IF (PO_LOG.d_proc) THEN

2046:
2047: BEGIN
2048:
2049: d_progress := 0;
2050: IF (PO_LOG.d_proc) THEN
2051: PO_LOG.proc_begin(d_module);
2052: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
2053: END IF;
2054:

Line 2051: PO_LOG.proc_begin(d_module);

2047: BEGIN
2048:
2049: d_progress := 0;
2050: IF (PO_LOG.d_proc) THEN
2051: PO_LOG.proc_begin(d_module);
2052: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
2053: END IF;
2054:
2055: d_progress := 10;

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

2048:
2049: d_progress := 0;
2050: IF (PO_LOG.d_proc) THEN
2051: PO_LOG.proc_begin(d_module);
2052: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
2053: END IF;
2054:
2055: d_progress := 10;
2056: SELECT SUM(pod.quantity_ordered),

Line 2065: IF (PO_LOG.d_stmt) THEN

2061: WHERE pod.line_location_id = p_line_location_id
2062: AND pod.draft_id =po_autocreate_params.g_draft_id;
2063:
2064: d_progress := 20;
2065: IF (PO_LOG.d_stmt) THEN
2066: PO_LOG.stmt(d_module, d_progress, 'l_last_dist_id', l_last_dist_id);
2067: END IF;
2068: SELECT poll.quantity
2069: INTO l_shipment_quantity

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

2062: AND pod.draft_id =po_autocreate_params.g_draft_id;
2063:
2064: d_progress := 20;
2065: IF (PO_LOG.d_stmt) THEN
2066: PO_LOG.stmt(d_module, d_progress, 'l_last_dist_id', l_last_dist_id);
2067: END IF;
2068: SELECT poll.quantity
2069: INTO l_shipment_quantity
2070: FROM po_line_locations_draft_all poll

Line 2080: IF (PO_LOG.d_proc) THEN

2076: SET pod.quantity_ordered = l_shipment_quantity - (l_sum_dist_quantities - pod.quantity_ordered)
2077: WHERE pod.po_distribution_id = l_last_dist_id
2078: AND draft_id =po_autocreate_params.g_draft_id RETURNING pod.quantity_ordered
2079: INTO l_last_dist_qty;
2080: IF (PO_LOG.d_proc) THEN
2081: PO_LOG.proc_end(d_module, 'l_last_dist_qty', l_last_dist_qty);
2082: PO_LOG.proc_end(d_module);
2083: END IF;
2084:

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

2077: WHERE pod.po_distribution_id = l_last_dist_id
2078: AND draft_id =po_autocreate_params.g_draft_id RETURNING pod.quantity_ordered
2079: INTO l_last_dist_qty;
2080: IF (PO_LOG.d_proc) THEN
2081: PO_LOG.proc_end(d_module, 'l_last_dist_qty', l_last_dist_qty);
2082: PO_LOG.proc_end(d_module);
2083: END IF;
2084:
2085: EXCEPTION

Line 2082: PO_LOG.proc_end(d_module);

2078: AND draft_id =po_autocreate_params.g_draft_id RETURNING pod.quantity_ordered
2079: INTO l_last_dist_qty;
2080: IF (PO_LOG.d_proc) THEN
2081: PO_LOG.proc_end(d_module, 'l_last_dist_qty', l_last_dist_qty);
2082: PO_LOG.proc_end(d_module);
2083: END IF;
2084:
2085: EXCEPTION
2086: WHEN OTHERS THEN

Line 2087: IF (PO_LOG.d_exc) THEN

2083: END IF;
2084:
2085: EXCEPTION
2086: WHEN OTHERS THEN
2087: IF (PO_LOG.d_exc) THEN
2088: PO_LOG.exc(d_module, d_progress, SQLCODE||SQLERRM);
2089: END IF;
2090: --CLM Phase 2 changes : error handling
2091: PO_AUTOCREATE_PVT.report_error('PO_AUTO_DIST_CAL_QTY',x_token1_value => sqlerrm);

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

2084:
2085: EXCEPTION
2086: WHEN OTHERS THEN
2087: IF (PO_LOG.d_exc) THEN
2088: PO_LOG.exc(d_module, d_progress, SQLCODE||SQLERRM);
2089: END IF;
2090: --CLM Phase 2 changes : error handling
2091: PO_AUTOCREATE_PVT.report_error('PO_AUTO_DIST_CAL_QTY',x_token1_value => sqlerrm);
2092:

Line 2148: IF (PO_LOG.d_stmt) THEN

2144: AND pdd.draft_id = PO_AUTOCREATE_PARAMS.g_draft_id
2145: ORDER BY pdd.po_distribution_id ;
2146:
2147: -- Calling buil_acrn API
2148: IF (PO_LOG.d_stmt) THEN
2149: PO_LOG.stmt(l_module||l_api_name, l_progress, 'calling BUILD_ACRN');
2150: END IF;
2151: l_progress := '020';
2152: --ACRN Regenerate changes begin

Line 2149: PO_LOG.stmt(l_module||l_api_name, l_progress, 'calling BUILD_ACRN');

2145: ORDER BY pdd.po_distribution_id ;
2146:
2147: -- Calling buil_acrn API
2148: IF (PO_LOG.d_stmt) THEN
2149: PO_LOG.stmt(l_module||l_api_name, l_progress, 'calling BUILD_ACRN');
2150: END IF;
2151: l_progress := '020';
2152: --ACRN Regenerate changes begin
2153: po_account_helper.BUILD_ACRN (PO_AUTOCREATE_PARAMS.g_po_header_id,

Line 2167: IF (PO_LOG.d_stmt) THEN

2163: X_MESSAGE_TOKEN);
2164: --ACRN Regenerate changes End
2165: l_ACRN_tbl := x_ACRN_tbl;
2166:
2167: IF (PO_LOG.d_stmt) THEN
2168: PO_LOG.stmt(l_module||l_api_name, l_progress, 'after BUILD_ACRN');
2169: END IF;
2170:
2171: FOR j IN 1..l_dist_id_tbl.Count

Line 2168: PO_LOG.stmt(l_module||l_api_name, l_progress, 'after BUILD_ACRN');

2164: --ACRN Regenerate changes End
2165: l_ACRN_tbl := x_ACRN_tbl;
2166:
2167: IF (PO_LOG.d_stmt) THEN
2168: PO_LOG.stmt(l_module||l_api_name, l_progress, 'after BUILD_ACRN');
2169: END IF;
2170:
2171: FOR j IN 1..l_dist_id_tbl.Count
2172: LOOP

Line 2182: IF (PO_LOG.d_exc) THEN

2178: END LOOP;
2179:
2180: EXCEPTION
2181: WHEN OTHERS THEN
2182: IF (PO_LOG.d_exc) THEN
2183: PO_LOG.exc(l_module, l_progress, SQLCODE||SQLERRM);
2184: END IF;
2185:
2186: --CLM Phase 2 changes : error handling

Line 2183: PO_LOG.exc(l_module, l_progress, SQLCODE||SQLERRM);

2179:
2180: EXCEPTION
2181: WHEN OTHERS THEN
2182: IF (PO_LOG.d_exc) THEN
2183: PO_LOG.exc(l_module, l_progress, SQLCODE||SQLERRM);
2184: END IF;
2185:
2186: --CLM Phase 2 changes : error handling
2187: PO_AUTOCREATE_PVT.report_error('PO_AUTO_DIST_ACRN_ERR',x_token1_value => sqlerrm);