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.CSTPPIPV dependencies on CSTPPIPV

Line 1: PACKAGE BODY CSTPPIPV AS

1: PACKAGE BODY CSTPPIPV AS
2: /* $Header: CSTPIPVB.pls 120.12.12010000.2 2008/11/10 13:31:44 anjha ship $ */
3:
4: /*---------------------------------------------------------------------------*
5: | PUBLIC PROCEDURE |

Line 74: cst_cstppipv_running EXCEPTION;

70: l_debug VARCHAR2(80);
71: l_default_cost_group_id number;
72: conc_status BOOLEAN;
73: cst_process_error EXCEPTION;
74: cst_cstppipv_running EXCEPTION;
75: cst_no_avg_org EXCEPTION;
76:
77: -- For a given org, this cursor will give list of items and cost group that
78: -- have invoices not yet interfaced with inventory

Line 323: RAISE CST_CSTPPIPV_RUNNING;

319: l_dummy := -1;
320: END;
321:
322: IF (l_dummy <> -1) THEN
323: RAISE CST_CSTPPIPV_RUNNING;
324: END IF;
325:
326: l_org_id := p_organization_id;
327:

Line 466: CSTPPIPV.generate_trf_info

462: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CG: '||TO_CHAR(l_cost_group_id));
463: END IF;
464:
465: l_stmt_num := 50;
466: CSTPPIPV.generate_trf_info
467: ( p_organization_id => l_org_id,
468: p_inventory_item_id => c_item_rec.item_id,
469: p_invoice_project_option => p_invoice_project_option,
470: p_project_id => p_project_id,

Line 616: WHEN CST_CSTPPIPV_RUNNING THEN

612: COMMIT;
613:
614: EXCEPTION
615:
616: WHEN CST_CSTPPIPV_RUNNING THEN
617: ROLLBACK;
618: l_err_num := 20009;
619:
620: l_err_code := SUBSTR('CSTPPIPV.trf_invoice_to_inventory('

Line 620: l_err_code := SUBSTR('CSTPPIPV.trf_invoice_to_inventory('

616: WHEN CST_CSTPPIPV_RUNNING THEN
617: ROLLBACK;
618: l_err_num := 20009;
619:
620: l_err_code := SUBSTR('CSTPPIPV.trf_invoice_to_inventory('
621: || to_char(l_stmt_num)
622: || '): '
623: || 'Req_id: '
624: || TO_CHAR(l_dummy)

Line 629: fnd_message.set_name('BOM', 'CST_CSTPPIPV_RUNNING');

625: ||' '
626: || l_err_msg
627: || '. ',1,240);
628:
629: fnd_message.set_name('BOM', 'CST_CSTPPIPV_RUNNING');
630: l_err_msg := fnd_message.get;
631: l_err_msg := SUBSTR(l_err_msg,1,240);
632: FND_FILE.PUT_LINE(fnd_file.log,SUBSTR(l_err_code
633: ||' '

Line 643: l_err_code := SUBSTR('CSTPPIPV.trf_invoice_to_inventory('

639: WHEN CST_NO_AVG_ORG THEN
640: ROLLBACK;
641: l_err_num := 20010;
642:
643: l_err_code := SUBSTR('CSTPPIPV.trf_invoice_to_inventory('
644: || to_char(l_stmt_num)
645: || '): '
646: || l_err_msg
647: || '. ',1,240);

Line 671: l_err_msg := SUBSTR('CSTPPIPV.trf_invoice_to_inventory('

667: WHEN OTHERS THEN
668: ROLLBACK;
669: l_err_num := SQLCODE;
670: l_err_code := NULL;
671: l_err_msg := SUBSTR('CSTPPIPV.trf_invoice_to_inventory('
672: || to_char(l_stmt_num)
673: || '): '
674: ||SQLERRM,1,240);
675: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);

Line 763: cst_cstppipv_running EXCEPTION;

759: l_le_day_time DATE;
760: l_server_le_offset NUMBER;
761: conc_status BOOLEAN;
762: cst_process_error EXCEPTION;
763: cst_cstppipv_running EXCEPTION;
764:
765: TYPE dists_tab_type is TABLE OF po_distributions_all.po_distribution_id%TYPE INDEX BY BINARY_INTEGER;
766: l_po_dists_tab dists_tab_type;
767:

Line 1009: RAISE CST_CSTPPIPV_RUNNING;

1005: l_dummy := -1;
1006: END;
1007:
1008: IF (l_dummy <> -1) THEN
1009: RAISE CST_CSTPPIPV_RUNNING;
1010: END IF;
1011:
1012: ----------------------------------------------------------------------
1013: -- Set aida rows with 'N' status but which was created for an OSP

Line 1202: CSTPPIPV.generate_wip_info (

1198: END IF;
1199:
1200: l_stmt_num := 50;
1201:
1202: CSTPPIPV.generate_wip_info (
1203: p_organization_id => p_organization_id,
1204: p_inventory_item_id => c_po_dist_rec.inventory_item_id,
1205: p_project_id => c_po_dist_rec.project_id,
1206: p_po_distribution_id => c_po_dist_rec.po_distribution_id,

Line 1350: WHEN CST_CSTPPIPV_RUNNING THEN

1346:
1347: RETURN l_batch_id;
1348:
1349: EXCEPTION
1350: WHEN CST_CSTPPIPV_RUNNING THEN
1351: ROLLBACK;
1352: retcode := 1;
1353: l_err_num := 20009;
1354: l_err_code := SUBSTR('CSTPPIPV.trf_invoice_to_wip('

Line 1354: l_err_code := SUBSTR('CSTPPIPV.trf_invoice_to_wip('

1350: WHEN CST_CSTPPIPV_RUNNING THEN
1351: ROLLBACK;
1352: retcode := 1;
1353: l_err_num := 20009;
1354: l_err_code := SUBSTR('CSTPPIPV.trf_invoice_to_wip('
1355: || to_char(l_stmt_num)
1356: || '): '
1357: || 'Req_id: '
1358: || TO_CHAR(l_dummy)

Line 1363: fnd_message.set_name('BOM', 'CST_CSTPPIPV_RUNNING');

1359: ||' '
1360: || l_err_msg
1361: || '. ',1,240);
1362:
1363: fnd_message.set_name('BOM', 'CST_CSTPPIPV_RUNNING');
1364: l_err_msg := fnd_message.get;
1365: l_err_msg := SUBSTR(l_err_msg,1,240);
1366: FND_FILE.PUT_LINE(fnd_file.log,SUBSTR(l_err_code
1367: ||' '

Line 1387: l_err_msg := SUBSTR('CSTPPIPV.trf_invoice_to_wip('

1383: ROLLBACK;
1384: retcode := 1;
1385: l_err_num := SQLCODE;
1386: l_err_code := NULL;
1387: l_err_msg := SUBSTR('CSTPPIPV.trf_invoice_to_wip('
1388: || to_char(l_stmt_num)
1389: || '): '
1390: ||SQLERRM,1,240);
1391: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);

Line 1502: l_err_msg := SUBSTR('CSTPPIPV.trf_invoice_to_wip('

1498: ROLLBACK;
1499: retcode := 1;
1500: l_err_num := SQLCODE;
1501: l_err_code := NULL;
1502: l_err_msg := SUBSTR('CSTPPIPV.trf_invoice_to_wip('
1503: || to_char(l_stmt_num)
1504: || '): '
1505: ||SQLERRM,1,240);
1506: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);

Line 1720: CSTPPIPV.get_upd_txn_date

1716: l_stmt_num := 15;
1717:
1718: -- Get transaction date for header records
1719:
1720: CSTPPIPV.get_upd_txn_date
1721: (
1722: p_po_distribution_id => c_cavl_po_rec.po_distribution_id,
1723: p_default_txn_date => p_default_txn_date,
1724: -- p_organization_id => p_organization_id, --BUG#5709567 - FPBUG#5109100

Line 1848: x_err_msg := SUBSTR('CSTPPIPV.generate_trf_info('

1844: WHEN OTHERS THEN
1845: ROLLBACK;
1846: x_err_num := SQLCODE;
1847: x_err_code := NULL;
1848: x_err_msg := SUBSTR('CSTPPIPV.generate_trf_info('
1849: || to_char(l_stmt_num)
1850: || '): '
1851: ||SQLERRM,1,240);
1852: END generate_trf_info;

Line 1989: CSTPPIPV.get_upd_txn_date(

1985:
1986: l_stmt_num := 15;
1987:
1988: -- Get transaction date for header records
1989: CSTPPIPV.get_upd_txn_date(
1990: p_po_distribution_id => p_po_distribution_id,
1991: p_default_txn_date => p_default_txn_date,
1992: -- p_organization_id => p_organization_id, --BUG#5709567-FPBUG5109100
1993: x_transaction_date => l_txn_date,

Line 2100: x_err_msg := SUBSTR('CSTPPIPV.generate_wip_info('

2096: WHEN OTHERS THEN
2097: ROLLBACK;
2098: x_err_num := SQLCODE;
2099: x_err_code := NULL;
2100: x_err_msg := SUBSTR('CSTPPIPV.generate_wip_info('
2101: || to_char(l_stmt_num)
2102: || '): '
2103: ||SQLERRM,1,240);
2104: END generate_wip_info;

Line 2251: x_err_msg := SUBSTR('CSTPPIPV.get_upd_txn_date('

2247: WHEN OTHERS THEN
2248: ROLLBACK;
2249: x_err_num := SQLCODE;
2250: x_err_code := NULL;
2251: x_err_msg := SUBSTR('CSTPPIPV.get_upd_txn_date('
2252: || to_char(l_stmt_num)
2253: || '): '
2254: ||SQLERRM,1,240);
2255:

Line 2342: x_err_msg := SUBSTR('CSTPPIPV.get_default_date('

2338: WHEN OTHERS THEN
2339: ROLLBACK;
2340: x_err_num := SQLCODE;
2341: x_err_code := NULL;
2342: x_err_msg := SUBSTR('CSTPPIPV.get_default_date('
2343: || to_char(l_stmt_num)
2344: || '): '
2345: ||SQLERRM,1,240);
2346:

Line 2349: END CSTPPIPV;

2345: ||SQLERRM,1,240);
2346:
2347: END get_default_date;
2348:
2349: END CSTPPIPV;