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

Line 1: package body CSTPSCEX as

1: package body CSTPSCEX as
2: /* $Header: CSTSCEXB.pls 120.19 2011/04/21 12:01:31 pbasrani ship $ */
3:
4:
5: -- This is the low level code for the bottom most component in an explosion

Line 91: o_error_msg := 'CSTPSCEX.insert_assembly_items():' ||

87:
88: exception
89: when OTHERS then
90: o_error_code := SQLCODE;
91: o_error_msg := 'CSTPSCEX.insert_assembly_items():' ||
92: to_char(l_stmt_num) || ':' ||
93: substrb(SQLERRM, 1, 1000);
94:
95: end insert_assembly_items;

Line 267: o_error_msg := 'CSTPSCEX.snapshot_sc_sourcing_rules():' ||

263:
264: exception
265: when OTHERS then
266: o_error_code := SQLCODE;
267: o_error_msg := 'CSTPSCEX.snapshot_sc_sourcing_rules():' ||
268: to_char(l_stmt_num) || ':' ||
269: substrb(SQLERRM, 1, 1000);
270: end snapshot_sc_sourcing_rules;
271:

Line 352: o_error_msg := 'CSTPSCEX.snapshot_sc_conversion_rates():' ||

348:
349: exception
350: when OTHERS then
351: o_error_code := SQLCODE;
352: o_error_msg := 'CSTPSCEX.snapshot_sc_conversion_rates():' ||
353: to_char(l_stmt_num) || ':' ||
354: substrb(SQLERRM, 1, 1000);
355: end snapshot_sc_conversion_rates;
356:

Line 444: CSTPSCEX.snapshot_sc_sourcing_rules

440:
441: if l_active_flag = 1 then
442:
443: l_stmt_num := 20;
444: CSTPSCEX.snapshot_sc_sourcing_rules
445: (
446: i_rollup_id,
447: i_assignment_set_id,
448: CSBE.component_item_id,

Line 713: o_error_msg := 'CSTPSCEX.explode_sc_bom():' ||

709:
710: exception
711: when OTHERS then
712: o_error_code := SQLCODE;
713: o_error_msg := 'CSTPSCEX.explode_sc_bom():' ||
714: to_char(l_stmt_num) || ':' ||
715: substrb(SQLERRM, 1, 1000);
716:
717: end explode_sc_bom;

Line 948: o_error_msg := 'CSTPSCEX.explode_sc_cost_flags():' ||

944:
945: EXCEPTION
946: WHEN OTHERS THEN
947: o_error_code := SQLCODE;
948: o_error_msg := 'CSTPSCEX.explode_sc_cost_flags():' ||
949: to_char(l_stmt_num) || ':' ||
950: substrb(SQLERRM, 1, 1000);
951:
952: end explode_sc_cost_flags;

Line 1265: o_error_msg := 'CSTPSCEX.snapshot_sc_bom_structures():' ||

1261:
1262: EXCEPTION
1263: WHEN OTHERS THEN
1264: o_error_code := SQLCODE;
1265: o_error_msg := 'CSTPSCEX.snapshot_sc_bom_structures():' ||
1266: to_char(l_stmt_num) || ':' ||
1267: substrb(SQLERRM, 1, 1000);
1268:
1269: end snapshot_sc_bom_structures;

Line 1320: o_error_msg := 'CSTPSCEX.check_loop():' ||

1316: EXCEPTION
1317:
1318: when OTHERS then
1319: o_error_code := SQLCODE;
1320: o_error_msg := 'CSTPSCEX.check_loop():' ||
1321: to_char(l_stmt_num) || ':' ||
1322: substrb(SQLERRM, 1, 1000);
1323: END check_loop;
1324:

Line 1471: 'CSTPSCEX.compute_sc_low_level_codes():' ||

1467:
1468: IF SQL%ROWCOUNT > 0 THEN
1469: o_error_code := 1001;
1470: o_error_msg :=
1471: 'CSTPSCEX.compute_sc_low_level_codes():' ||
1472: to_char(l_stmt_num) || ':' ||
1473: 'Cannot update standard cost for ' || to_char(SQL%ROWCOUNT) ||
1474: ' items due to existing MMT transactions';
1475: END IF;

Line 1484: o_error_msg := 'CSTPSCEX.compute_sc_low_level_codes():' ||

1480:
1481: exception
1482: when OTHERS then
1483: o_error_code := SQLCODE;
1484: o_error_msg := 'CSTPSCEX.compute_sc_low_level_codes():' ||
1485: to_char(l_stmt_num) || ':' ||
1486: substrb(SQLERRM, 1, 1000);
1487:
1488: end compute_sc_low_level_codes;

Line 1620: CSTPSCEX.insert_assembly_items

1616:
1617:
1618:
1619: l_stmt_num := 40;
1620: CSTPSCEX.insert_assembly_items
1621: (
1622: l_rollup_id,
1623: i_user_id,
1624: i_login_id,

Line 1640: CSTPSCEX.explode_sc_bom

1636:
1637: l_timestamp := SYSDATE;
1638:
1639: l_stmt_num := 50;
1640: CSTPSCEX.explode_sc_bom
1641: (
1642: l_rollup_id,
1643: i_explosion_levels,
1644: i_assignment_set_id,

Line 1668: CSTPSCEX.snapshot_sc_conversion_rates

1664:
1665:
1666:
1667: l_stmt_num := 60;
1668: CSTPSCEX.snapshot_sc_conversion_rates
1669: (
1670: l_rollup_id,
1671: i_conversion_type,
1672: o_error_code,

Line 1684: CSTPSCEX.compute_sc_low_level_codes

1680:
1681: l_timestamp := SYSDATE;
1682:
1683: l_stmt_num := 70;
1684: CSTPSCEX.compute_sc_low_level_codes
1685: (
1686: l_rollup_id,
1687: i_explosion_levels,
1688: i_cost_type_id,

Line 1704: CSTPSCEX.check_loop (

1700: END IF;
1701:
1702: --To print the BOM structure loops if any, to the log file.
1703: l_stmt_num := 75;
1704: CSTPSCEX.check_loop (
1705: l_rollup_id,
1706: o_error_code,
1707: o_error_msg
1708: );

Line 1816: CSTPSCEX.snapshot_sc_bom_structures

1812:
1813: IF l_report_levels IS NOT NULL THEN
1814:
1815: l_stmt_num := 105;
1816: CSTPSCEX.snapshot_sc_bom_structures
1817: (
1818: l_rollup_id,
1819: i_cost_type_id,
1820: l_report_levels,

Line 1859: o_error_msg := 'CSTPSCEX.supply_chain_rollup():' ||

1855:
1856: exception
1857: when OTHERS then
1858: o_error_code := SQLCODE;
1859: o_error_msg := 'CSTPSCEX.supply_chain_rollup():' ||
1860: to_char(l_stmt_num) || ':' ||
1861: substrb(SQLERRM, 1, 1000);
1862:
1863: end supply_chain_rollup;

Line 1867: end CSTPSCEX;

1863: end supply_chain_rollup;
1864:
1865:
1866:
1867: end CSTPSCEX;