APPS.CSTPSCEX dependencies on CSTPSCEX

Line 1: package body CSTPSCEX as

1: package body CSTPSCEX as
2: /* $Header: CSTSCEXB.pls 120.12.12010000.2 2008/08/08 12:33:20 smsasidh 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 443: CSTPSCEX.snapshot_sc_sourcing_rules

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

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

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

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

953:
954: EXCEPTION
955: WHEN OTHERS THEN
956: o_error_code := SQLCODE;
957: o_error_msg := 'CSTPSCEX.explode_sc_cost_flags():' ||
958: to_char(l_stmt_num) || ':' ||
959: substrb(SQLERRM, 1, 1000);
960:
961: end explode_sc_cost_flags;

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

1269:
1270: EXCEPTION
1271: WHEN OTHERS THEN
1272: o_error_code := SQLCODE;
1273: o_error_msg := 'CSTPSCEX.snapshot_sc_bom_structures():' ||
1274: to_char(l_stmt_num) || ':' ||
1275: substrb(SQLERRM, 1, 1000);
1276:
1277: end snapshot_sc_bom_structures;

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

1423:
1424: IF SQL%ROWCOUNT > 0 THEN
1425: o_error_code := 1001;
1426: o_error_msg :=
1427: 'CSTPSCEX.compute_sc_low_level_codes():' ||
1428: to_char(l_stmt_num) || ':' ||
1429: 'Cannot update standard cost for ' || to_char(SQL%ROWCOUNT) ||
1430: ' items due to existing MMT transactions';
1431: END IF;

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

1437:
1438: exception
1439: when OTHERS then
1440: o_error_code := SQLCODE;
1441: o_error_msg := 'CSTPSCEX.compute_sc_low_level_codes():' ||
1442: to_char(l_stmt_num) || ':' ||
1443: substrb(SQLERRM, 1, 1000);
1444:
1445: end compute_sc_low_level_codes;

Line 1577: CSTPSCEX.insert_assembly_items

1573:
1574:
1575:
1576: l_stmt_num := 40;
1577: CSTPSCEX.insert_assembly_items
1578: (
1579: l_rollup_id,
1580: i_user_id,
1581: i_login_id,

Line 1597: CSTPSCEX.explode_sc_bom

1593:
1594: l_timestamp := SYSDATE;
1595:
1596: l_stmt_num := 50;
1597: CSTPSCEX.explode_sc_bom
1598: (
1599: l_rollup_id,
1600: i_explosion_levels,
1601: i_assignment_set_id,

Line 1625: CSTPSCEX.snapshot_sc_conversion_rates

1621:
1622:
1623:
1624: l_stmt_num := 60;
1625: CSTPSCEX.snapshot_sc_conversion_rates
1626: (
1627: l_rollup_id,
1628: i_conversion_type,
1629: o_error_code,

Line 1641: CSTPSCEX.compute_sc_low_level_codes

1637:
1638: l_timestamp := SYSDATE;
1639:
1640: l_stmt_num := 70;
1641: CSTPSCEX.compute_sc_low_level_codes
1642: (
1643: l_rollup_id,
1644: i_explosion_levels,
1645: i_cost_type_id,

Line 1761: CSTPSCEX.snapshot_sc_bom_structures

1757:
1758: IF l_report_levels IS NOT NULL THEN
1759:
1760: l_stmt_num := 105;
1761: CSTPSCEX.snapshot_sc_bom_structures
1762: (
1763: l_rollup_id,
1764: i_cost_type_id,
1765: l_report_levels,

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

1800:
1801: exception
1802: when OTHERS then
1803: o_error_code := SQLCODE;
1804: o_error_msg := 'CSTPSCEX.supply_chain_rollup():' ||
1805: to_char(l_stmt_num) || ':' ||
1806: substrb(SQLERRM, 1, 1000);
1807:
1808: end supply_chain_rollup;

Line 1812: end CSTPSCEX;

1808: end supply_chain_rollup;
1809:
1810:
1811:
1812: end CSTPSCEX;