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

Line 1: PACKAGE BODY CSTPPWAC AS

1: PACKAGE BODY CSTPPWAC AS
2: /* $Header: CSTPWACB.pls 120.42 2011/12/18 00:42:04 fayang ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSTPPWAC';
5: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSTPPWAC';

1: PACKAGE BODY CSTPPWAC AS
2: /* $Header: CSTPWACB.pls 120.42 2011/12/18 00:42:04 fayang ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSTPPWAC';
5: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6:
7: -- PROCEDURE
8: -- cost_processor Costs inventory transactions

Line 56: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.cost_processor';

52: l_err_msg VARCHAR2(240);
53: l_stmt_num NUMBER;
54:
55: /* --- start of auto log --- */
56: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.cost_processor';
57: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
58: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
59: fnd_log.TEST(fnd_log.level_unexpected, l_module);
60: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

Line 73: 'Entering CSTPPWAC.cost_processor with '||

69: IF l_plog THEN
70: fnd_log.string(
71: fnd_log.level_procedure,
72: l_module||'.'||l_stmt_num,
73: 'Entering CSTPPWAC.cost_processor with '||
74: 'I_LEGAL_ENTITY = '||I_LEGAL_ENTITY||','||
75: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
76: 'I_ORG_ID = '||I_ORG_ID||','||
77: 'I_COST_GROUP_ID = '||I_COST_GROUP_ID||','||

Line 134: CSTPPWAC.periodic_cost_update(

130: -- No need to process cost update
131: if (i_txn_action_id = 24) then
132: if i_cost_method = 3 then
133: -- PWAC cost method
134: CSTPPWAC.periodic_cost_update(
135: i_pac_period_id,
136: i_cost_group_id,
137: i_cost_type_id,
138: i_txn_id,

Line 251: l_new_cost := CSTPPWAC.compute_pwac_cost(

247: -- If hook is not used then proceed to compute actual cost.
248:
249: -- PAC Weighted Average costing method
250: if (i_cost_method = 3) then
251: l_new_cost := CSTPPWAC.compute_pwac_cost(
252: i_pac_period_id,
253: i_org_id,
254: i_cost_group_id,
255: i_cost_type_id,

Line 341: CSTPPWAC.sub_transfer(

337: (i_txn_action_id in (3,21,12) and l_across_cgs = 0) or
338: (i_txn_action_id = 21 and i_fob_point = 2) or
339: (i_txn_action_id = 12 and i_fob_point = 1))
340: then
341: CSTPPWAC.sub_transfer(
342: i_pac_period_id,
343: i_org_id,
344: i_cost_group_id,
345: i_cost_type_id,

Line 376: CSTPPWAC.interorg( i_pac_period_id,

372: -- InterOrg Transfer across cost groups(ownership changes)
373: -- INVCONV sikhanna adding 15 and 22 (as these will be across CG's only)
374: elsif (i_txn_action_id in (3,21,12,15,22) and l_across_cgs = 1) then
375:
376: CSTPPWAC.interorg( i_pac_period_id,
377: i_org_id,
378: i_cost_group_id,
379: i_txfr_cost_group_id,
380: i_cost_type_id,

Line 441: CSTPPWAC.cost_owned_txns(

437: WHERE cpic.cost_layer_id = i_cost_layer_id;
438: else
439: -- end of bug 2541342 addition; original code follows
440:
441: CSTPPWAC.cost_owned_txns(
442: i_pac_period_id,
443: i_cost_group_id,
444: i_cost_type_id,
445: i_txn_id,

Line 478: CSTPPWAC.cost_derived_txns(

474:
475: -- Cost Derived transactions has impact only on issue quantity
476: l_issue_qty := i_txn_qty * -1;
477:
478: CSTPPWAC.cost_derived_txns(
479: i_pac_period_id,
480: i_cost_group_id,
481: i_cost_type_id,
482: i_txn_id,

Line 530: 'Exiting CSTPPWAC.cost_processor with '||

526: IF l_plog THEN
527: fnd_log.string(
528: fnd_log.level_procedure,
529: l_module||'.'||l_stmt_num,
530: 'Exiting CSTPPWAC.cost_processor with '||
531: 'O_Err_Num = '||O_Err_Num||','||
532: 'O_Err_Code = '||O_Err_Code||','||
533: 'O_Err_Msg = '||O_Err_Msg
534: );

Line 542: p_pkg_name => 'CSTPPWAC',

538: /* --- start of auto log --- */
539: WHEN fnd_api.g_exc_unexpected_error THEN
540: IF l_exceptionlog THEN
541: fnd_msg_pub.add_exc_msg(
542: p_pkg_name => 'CSTPPWAC',
543: p_procedure_name => 'cost_processor',
544: p_error_text => 'An exception has occurred.'
545: );
546: fnd_log.string(

Line 607: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.cost_owned_txns';

603: l_err_msg VARCHAR2(240);
604: l_stmt_num NUMBER;
605:
606: /* --- start of auto log --- */
607: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.cost_owned_txns';
608: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
609: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
610: fnd_log.TEST(fnd_log.level_unexpected, l_module);
611: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

Line 624: 'Entering CSTPPWAC.cost_owned_txns with '||

620: IF l_plog THEN
621: fnd_log.string(
622: fnd_log.level_procedure,
623: l_module||'.'||l_stmt_num,
624: 'Entering CSTPPWAC.cost_owned_txns with '||
625: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
626: 'I_COST_GROUP_ID = '||I_COST_GROUP_ID||','||
627: 'I_COST_TYPE_ID = '||I_COST_TYPE_ID||','||
628: 'I_TXN_ID = '||I_TXN_ID||','||

Line 656: CSTPPWAC.calc_pwac_cost(

652:
653:
654: -- PAC Weighted Average costing method
655: if (i_cost_method = 3) then
656: CSTPPWAC.calc_pwac_cost(
657: i_pac_period_id,
658: i_cost_group_id,
659: i_cost_type_id,
660: i_txn_id,

Line 715: 'Exiting CSTPPWAC.cost_owned_txns with '||

711: IF l_plog THEN
712: fnd_log.string(
713: fnd_log.level_procedure,
714: l_module||'.'||l_stmt_num,
715: 'Exiting CSTPPWAC.cost_owned_txns with '||
716: 'O_Err_Num = '||O_Err_Num||','||
717: 'O_Err_Code = '||O_Err_Code||','||
718: 'O_Err_Msg = '||O_Err_Msg
719: );

Line 727: p_pkg_name => 'CSTPPWAC',

723: /* --- start of auto log --- */
724: WHEN fnd_api.g_exc_unexpected_error THEN
725: IF l_exceptionlog THEN
726: fnd_msg_pub.add_exc_msg(
727: p_pkg_name => 'CSTPPWAC',
728: p_procedure_name => 'cost_owned_txns',
729: p_error_text => 'An exception has occurred.'
730: );
731: fnd_log.string(

Line 793: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.cost_derived_txns';

789: l_err_msg VARCHAR2(240);
790: l_stmt_num NUMBER;
791:
792: /* --- start of auto log --- */
793: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.cost_derived_txns';
794: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
795: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
796: fnd_log.TEST(fnd_log.level_unexpected, l_module);
797: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

Line 810: 'Entering CSTPPWAC.cost_derived_txns with '||

806: IF l_plog THEN
807: fnd_log.string(
808: fnd_log.level_procedure,
809: l_module||'.'||l_stmt_num,
810: 'Entering CSTPPWAC.cost_derived_txns with '||
811: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
812: 'I_COST_GROUP_ID = '||I_COST_GROUP_ID||','||
813: 'I_COST_TYPE_ID = '||I_COST_TYPE_ID||','||
814: 'I_TXN_ID = '||I_TXN_ID||','||

Line 845: CSTPPWAC.current_pwac_cost(

841:
842:
843: -- PAC Weighted Average costing method
844: if (i_cost_method = 3) then
845: CSTPPWAC.current_pwac_cost(
846: i_cost_layer_id,
847: i_qty_layer_id,
848: i_txn_qty,
849: i_issue_qty,

Line 900: 'Exiting CSTPPWAC.cost_derived_txns with '||

896: IF l_plog THEN
897: fnd_log.string(
898: fnd_log.level_procedure,
899: l_module||'.'||l_stmt_num,
900: 'Exiting CSTPPWAC.cost_derived_txns with '||
901: 'O_Err_Num = '||O_Err_Num||','||
902: 'O_Err_Code = '||O_Err_Code||','||
903: 'O_Err_Msg = '||O_Err_Msg
904: );

Line 912: p_pkg_name => 'CSTPPWAC',

908: /* --- start of auto log --- */
909: WHEN fnd_api.g_exc_unexpected_error THEN
910: IF l_exceptionlog THEN
911: fnd_msg_pub.add_exc_msg(
912: p_pkg_name => 'CSTPPWAC',
913: p_procedure_name => 'cost_derived_txns',
914: p_error_text => 'An exception has occurred.'
915: );
916: fnd_log.string(

Line 985: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.sub_transfer';

981: l_err_msg VARCHAR2(240);
982: l_stmt_num NUMBER;
983:
984: /* --- start of auto log --- */
985: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.sub_transfer';
986: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
987: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
988: fnd_log.TEST(fnd_log.level_unexpected, l_module);
989: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

Line 1002: 'Entering CSTPPWAC.sub_transfer with '||

998: IF l_plog THEN
999: fnd_log.string(
1000: fnd_log.level_procedure,
1001: l_module||'.'||l_stmt_num,
1002: 'Entering CSTPPWAC.sub_transfer with '||
1003: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
1004: 'I_ORG_ID = '||I_ORG_ID||','||
1005: 'I_COST_GROUP_ID = '||I_COST_GROUP_ID||','||
1006: 'I_COST_TYPE_ID = '||I_COST_TYPE_ID||','||

Line 1098: CSTPPWAC.cost_derived_txns(

1094: end if;
1095:
1096:
1097: l_stmt_num := 30;
1098: CSTPPWAC.cost_derived_txns(
1099: i_pac_period_id,
1100: i_cost_group_id,
1101: i_cost_type_id,
1102: i_txn_id,

Line 1137: 'Exiting CSTPPWAC.sub_transfer with '||

1133: IF l_plog THEN
1134: fnd_log.string(
1135: fnd_log.level_procedure,
1136: l_module||'.'||l_stmt_num,
1137: 'Exiting CSTPPWAC.sub_transfer with '||
1138: 'O_Err_Num = '||O_Err_Num||','||
1139: 'O_Err_Code = '||O_Err_Code||','||
1140: 'O_Err_Msg = '||O_Err_Msg
1141: );

Line 1149: p_pkg_name => 'CSTPPWAC',

1145: /* --- start of auto log --- */
1146: WHEN fnd_api.g_exc_unexpected_error THEN
1147: IF l_exceptionlog THEN
1148: fnd_msg_pub.add_exc_msg(
1149: p_pkg_name => 'CSTPPWAC',
1150: p_procedure_name => 'sub_transfer',
1151: p_error_text => 'An exception has occurred.'
1152: );
1153: fnd_log.string(

Line 1223: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.interorg';

1219: l_err_msg VARCHAR2(240);
1220: l_stmt_num NUMBER;
1221:
1222: /* --- start of auto log --- */
1223: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.interorg';
1224: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
1225: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
1226: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1227: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

Line 1240: 'Entering CSTPPWAC.interorg with '||

1236: IF l_plog THEN
1237: fnd_log.string(
1238: fnd_log.level_procedure,
1239: l_module||'.'||l_stmt_num,
1240: 'Entering CSTPPWAC.interorg with '||
1241: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
1242: 'I_ORG_ID = '||I_ORG_ID||','||
1243: 'I_COST_GROUP_ID = '||I_COST_GROUP_ID||','||
1244: 'I_TXFR_COST_GROUP_ID = '||I_TXFR_COST_GROUP_ID||','||

Line 1318: CSTPPWAC.cost_owned_txns(

1314: l_buy_qty := i_txn_qty;
1315: l_txn_qty := i_txn_qty;
1316: end if;
1317:
1318: CSTPPWAC.cost_owned_txns(
1319: i_pac_period_id,
1320: i_cost_group_id,
1321: i_cost_type_id,
1322: i_txn_id,

Line 1363: CSTPPWAC.cost_derived_txns(

1359: l_issue_qty := i_txn_qty * -1;
1360: l_txn_qty := i_txn_qty;
1361: end if;
1362:
1363: CSTPPWAC.cost_derived_txns(
1364: i_pac_period_id,
1365: i_cost_group_id,
1366: i_cost_type_id,
1367: i_txn_id,

Line 1405: 'Exiting CSTPPWAC.interorg with '||

1401: IF l_plog THEN
1402: fnd_log.string(
1403: fnd_log.level_procedure,
1404: l_module||'.'||l_stmt_num,
1405: 'Exiting CSTPPWAC.interorg with '||
1406: 'O_Err_Num = '||O_Err_Num||','||
1407: 'O_Err_Code = '||O_Err_Code||','||
1408: 'O_Err_Msg = '||O_Err_Msg
1409: );

Line 1417: p_pkg_name => 'CSTPPWAC',

1413: /* --- start of auto log --- */
1414: WHEN fnd_api.g_exc_unexpected_error THEN
1415: IF l_exceptionlog THEN
1416: fnd_msg_pub.add_exc_msg(
1417: p_pkg_name => 'CSTPPWAC',
1418: p_procedure_name => 'interorg',
1419: p_error_text => 'An exception has occurred.'
1420: );
1421: fnd_log.string(

Line 1499: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.compute_pwac_cost';

1495: l_msg_data VARCHAR2(8000) := '';
1496: l_api_message VARCHAR2(1000) := '';
1497:
1498: /* --- start of auto log --- */
1499: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.compute_pwac_cost';
1500: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
1501: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
1502: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1503: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

Line 1516: 'Entering CSTPPWAC.compute_pwac_cost with '||

1512: IF l_plog THEN
1513: fnd_log.string(
1514: fnd_log.level_procedure,
1515: l_module||'.'||l_stmt_num,
1516: 'Entering CSTPPWAC.compute_pwac_cost with '||
1517: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
1518: 'I_ORG_ID = '||I_ORG_ID||','||
1519: 'I_COST_GROUP_ID = '||I_COST_GROUP_ID||','||
1520: 'I_COST_TYPE_ID = '||I_COST_TYPE_ID||','||

Line 1831: CSTPPWAC.apply_material_ovhd(

1827:
1828: l_level := 1;
1829:
1830: l_stmt_num := 80;
1831: CSTPPWAC.apply_material_ovhd(
1832: i_pac_period_id,
1833: l_moh_org_id,
1834: i_cost_group_id,
1835: i_cost_type_id,

Line 1868: 'Exiting CSTPPWAC.compute_pwac_cost with '||

1864: IF l_plog THEN
1865: fnd_log.string(
1866: fnd_log.level_procedure,
1867: l_module||'.'||l_stmt_num,
1868: 'Exiting CSTPPWAC.compute_pwac_cost with '||
1869: 'O_Err_Num = '||O_Err_Num||','||
1870: 'O_Err_Code = '||O_Err_Code||','||
1871: 'O_Err_Msg = '||O_Err_Msg
1872: );

Line 1883: p_pkg_name => 'CSTPPWAC',

1879: /* --- start of auto log --- */
1880: WHEN fnd_api.g_exc_unexpected_error THEN
1881: IF l_exceptionlog THEN
1882: fnd_msg_pub.add_exc_msg(
1883: p_pkg_name => 'CSTPPWAC',
1884: p_procedure_name => 'compute_pwac_cost',
1885: p_error_text => 'An exception has occurred.'
1886: );
1887: fnd_log.string(

Line 1951: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.apply_material_ovhd';

1947: l_err_msg VARCHAR2(240);
1948: l_stmt_num NUMBER;
1949:
1950: /* --- start of auto log --- */
1951: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.apply_material_ovhd';
1952: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
1953: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
1954: fnd_log.TEST(fnd_log.level_unexpected, l_module);
1955: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

Line 1968: 'Entering CSTPPWAC.apply_material_ovhd with '||

1964: IF l_plog THEN
1965: fnd_log.string(
1966: fnd_log.level_procedure,
1967: l_module||'.'||l_stmt_num,
1968: 'Entering CSTPPWAC.apply_material_ovhd with '||
1969: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
1970: 'I_ORG_ID = '||I_ORG_ID||','||
1971: 'I_COST_GROUP_ID = '||I_COST_GROUP_ID||','||
1972: 'I_COST_TYPE_ID = '||I_COST_TYPE_ID||','||

Line 2185: 'Exiting CSTPPWAC.apply_material_ovhd with '||

2181: IF l_plog THEN
2182: fnd_log.string(
2183: fnd_log.level_procedure,
2184: l_module||'.'||l_stmt_num,
2185: 'Exiting CSTPPWAC.apply_material_ovhd with '||
2186: 'O_Err_Num = '||O_Err_Num||','||
2187: 'O_Err_Code = '||O_Err_Code||','||
2188: 'O_Err_Msg = '||O_Err_Msg
2189: );

Line 2241: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.current_pwac_cost';

2237: l_err_msg VARCHAR2(240);
2238: l_stmt_num NUMBER;
2239:
2240: /* --- start of auto log --- */
2241: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.current_pwac_cost';
2242: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
2243: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
2244: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2245: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

Line 2258: 'Entering CSTPPWAC.current_pwac_cost with '||

2254: IF l_plog THEN
2255: fnd_log.string(
2256: fnd_log.level_procedure,
2257: l_module||'.'||l_stmt_num,
2258: 'Entering CSTPPWAC.current_pwac_cost with '||
2259: 'I_COST_LAYER_ID = '||I_COST_LAYER_ID||','||
2260: 'I_QTY_LAYER_ID = '||I_QTY_LAYER_ID||','||
2261: 'I_TXN_QTY = '||I_TXN_QTY||','||
2262: 'I_ISSUE_QTY = '||I_ISSUE_QTY||','||

Line 2378: 'Exiting CSTPPWAC.current_pwac_cost with '||

2374: IF l_plog THEN
2375: fnd_log.string(
2376: fnd_log.level_procedure,
2377: l_module||'.'||l_stmt_num,
2378: 'Exiting CSTPPWAC.current_pwac_cost with '||
2379: 'O_Err_Num = '||O_Err_Num||','||
2380: 'O_Err_Code = '||O_Err_Code||','||
2381: 'O_Err_Msg = '||O_Err_Msg
2382: );

Line 2390: p_pkg_name => 'CSTPPWAC',

2386: /* --- start of auto log --- */
2387: WHEN fnd_api.g_exc_unexpected_error THEN
2388: IF l_exceptionlog THEN
2389: fnd_msg_pub.add_exc_msg(
2390: p_pkg_name => 'CSTPPWAC',
2391: p_procedure_name => 'current_pwac_cost',
2392: p_error_text => 'An exception has occurred.'
2393: );
2394: fnd_log.string(

Line 2458: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_pwac_cost';

2454: l_err_msg VARCHAR2(240);
2455: l_stmt_num NUMBER;
2456:
2457: /* --- start of auto log --- */
2458: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_pwac_cost';
2459: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
2460: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
2461: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2462: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

Line 2475: 'Entering CSTPPWAC.calc_pwac_cost with '||

2471: IF l_plog THEN
2472: fnd_log.string(
2473: fnd_log.level_procedure,
2474: l_module||'.'||l_stmt_num,
2475: 'Entering CSTPPWAC.calc_pwac_cost with '||
2476: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
2477: 'I_COST_GROUP_ID = '||I_COST_GROUP_ID||','||
2478: 'I_COST_TYPE_ID = '||I_COST_TYPE_ID||','||
2479: 'I_TXN_ID = '||I_TXN_ID||','||

Line 2664: 'Exiting CSTPPWAC.calc_pwac_cost with '||

2660: IF l_plog THEN
2661: fnd_log.string(
2662: fnd_log.level_procedure,
2663: l_module||'.'||l_stmt_num,
2664: 'Exiting CSTPPWAC.calc_pwac_cost with '||
2665: 'O_Err_Num = '||O_Err_Num||','||
2666: 'O_Err_Code = '||O_Err_Code||','||
2667: 'O_Err_Msg = '||O_Err_Msg
2668: );

Line 2676: p_pkg_name => 'CSTPPWAC',

2672: /* --- start of auto log --- */
2673: WHEN fnd_api.g_exc_unexpected_error THEN
2674: IF l_exceptionlog THEN
2675: fnd_msg_pub.add_exc_msg(
2676: p_pkg_name => 'CSTPPWAC',
2677: p_procedure_name => 'calc_pwac_cost',
2678: p_error_text => 'An exception has occurred.'
2679: );
2680: fnd_log.string(

Line 2735: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.periodic_cost_update';

2731: l_make_qty NUMBER;
2732: l_buy_qty NUMBER;
2733:
2734: /* --- start of auto log --- */
2735: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.periodic_cost_update';
2736: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
2737: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
2738: fnd_log.TEST(fnd_log.level_unexpected, l_module);
2739: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

Line 2752: 'Entering CSTPPWAC.periodic_cost_update with '||

2748: IF l_plog THEN
2749: fnd_log.string(
2750: fnd_log.level_procedure,
2751: l_module||'.'||l_stmt_num,
2752: 'Entering CSTPPWAC.periodic_cost_update with '||
2753: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
2754: 'I_COST_GROUP_ID = '||I_COST_GROUP_ID||','||
2755: 'I_COST_TYPE_ID = '||I_COST_TYPE_ID||','||
2756: 'I_TXN_ID = '||I_TXN_ID||','||

Line 3276: 'Exiting CSTPPWAC.periodic_cost_update with '||

3272: IF l_plog THEN
3273: fnd_log.string(
3274: fnd_log.level_procedure,
3275: l_module||'.'||l_stmt_num,
3276: 'Exiting CSTPPWAC.periodic_cost_update with '||
3277: 'O_Err_Num = '||O_Err_Num||','||
3278: 'O_Err_Code = '||O_Err_Code||','||
3279: 'O_Err_Msg = '||O_Err_Msg
3280: );

Line 3327: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_txn_history';

3323: ) IS
3324: l_stmt_num NUMBER;
3325:
3326: -- start of auto log ---
3327: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_txn_history';
3328: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3329: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3330: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3331: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

Line 3344: 'Entering CSTPPWAC.insert_txn_history with '||

3340: IF l_plog THEN
3341: fnd_log.string(
3342: fnd_log.level_procedure,
3343: l_module||'.'||l_stmt_num,
3344: 'Entering CSTPPWAC.insert_txn_history with '||
3345: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
3346: 'I_COST_GROUP_ID = '||I_COST_GROUP_ID||','||
3347: 'I_TXN_ID = '||I_TXN_ID||','||
3348: 'I_PROCESS_GROUP = '||I_PROCESS_GROUP||','||

Line 3412: 'Exiting CSTPPWAC.insert_txn_history with '||

3408: IF l_plog THEN
3409: fnd_log.string(
3410: fnd_log.level_procedure,
3411: l_module||'.'||l_stmt_num,
3412: 'Exiting CSTPPWAC.insert_txn_history with '||
3413: 'O_Err_Num = '||O_Err_Num||','||
3414: 'O_Err_Code = '||O_Err_Code||','||
3415: 'O_Err_Msg = '||O_Err_Msg
3416: );

Line 3461: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_txn_history';

3457: ) IS
3458: l_stmt_num NUMBER;
3459:
3460: --- start of auto log ---
3461: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_txn_history';
3462: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3463: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3464: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3465: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

Line 3478: 'Entering CSTPPWAC.update_txn_history with '||

3474: IF l_plog THEN
3475: fnd_log.string(
3476: fnd_log.level_procedure,
3477: l_module||'.'||l_stmt_num,
3478: 'Entering CSTPPWAC.update_txn_history with '||
3479: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
3480: 'I_COST_GROUP_ID = '||I_COST_GROUP_ID||','||
3481: 'I_TXN_ID = '||I_TXN_ID||','||
3482: 'I_USER_ID = '||I_USER_ID||','||

Line 3516: 'Exiting CSTPPWAC.update_txn_history with '||

3512: IF l_plog THEN
3513: fnd_log.string(
3514: fnd_log.level_procedure,
3515: l_module||'.'||l_stmt_num,
3516: 'Exiting CSTPPWAC.update_txn_history with '||
3517: 'O_Err_Num = '||O_Err_Num||','||
3518: 'O_Err_Code = '||O_Err_Code||','||
3519: 'O_Err_Msg = '||O_Err_Msg
3520: );

Line 3565: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_into_cppb';

3561: l_new_issue_qty_tbl CSTPPINV.t_item_quantity_tbl;
3562: l_category_qty_tbl CSTPPINV.t_item_quantity_tbl;
3563:
3564: /* --- start of auto log --- */
3565: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_into_cppb';
3566: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3567: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3568: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3569: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

Line 3582: 'Entering CSTPPWAC.insert_into_cppb with '||

3578: IF l_plog THEN
3579: fnd_log.string(
3580: fnd_log.level_procedure,
3581: l_module||'.'||l_stmt_num,
3582: 'Entering CSTPPWAC.insert_into_cppb with '||
3583: 'i_cost_group_id = '||i_cost_group_id||','||
3584: 'i_txn_category = '||i_txn_category||','||
3585: 'i_user_id = '||i_user_id||','||
3586: 'i_login_id = '||i_login_id||','||

Line 3865: 'Exiting CSTPPWAC.insert_into_cppb with '||

3861: IF l_plog THEN
3862: fnd_log.string(
3863: fnd_log.level_procedure,
3864: l_module||'.'||l_stmt_num,
3865: 'Exiting CSTPPWAC.insert_into_cppb with '||
3866: 'o_err_num = '||o_err_num||','||
3867: 'o_err_code = '||o_err_code||','||
3868: 'o_err_msg = '||o_err_msg
3869: );

Line 3920: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_item_periodic_cost';

3916: l_txn_category_tbl t_txn_category_tbl;
3917: l_cost_layer_id_tbl CSTPPINV.t_cost_layer_id_tbl;
3918:
3919: /* --- start of auto log --- */
3920: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_item_periodic_cost';
3921: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3922: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3923: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3924: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

Line 3937: 'Entering CSTPPWAC.calc_item_periodic_cost with '||

3933: IF l_plog THEN
3934: fnd_log.string(
3935: fnd_log.level_procedure,
3936: l_module||'.'||l_stmt_num,
3937: 'Entering CSTPPWAC.calc_item_periodic_cost with '||
3938: 'i_cost_group_id = '||i_cost_group_id||','||
3939: 'i_cost_type_id = '||i_cost_type_id||','||
3940: 'i_low_level_code = '||i_low_level_code||','||
3941: 'i_item_id = '||i_item_id||','||

Line 4477: 'Exiting CSTPPWAC.calc_item_periodic_cost with '||

4473: IF l_plog THEN
4474: fnd_log.string(
4475: fnd_log.level_procedure,
4476: l_module||'.'||l_stmt_num,
4477: 'Exiting CSTPPWAC.calc_item_periodic_cost with '||
4478: 'o_err_num = '||o_err_num||','||
4479: 'o_err_code = '||o_err_code||','||
4480: 'o_err_msg = '||o_err_msg
4481: );

Line 4529: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_periodic_cost';

4525: l_txn_category_tbl t_txn_category_tbl;
4526: l_cost_layer_id_tbl CSTPPINV.t_cost_layer_id_tbl;
4527:
4528: /* --- start of auto log --- */
4529: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_periodic_cost';
4530: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
4531: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
4532: fnd_log.TEST(fnd_log.level_unexpected, l_module);
4533: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

Line 4546: 'Entering CSTPPWAC.calc_periodic_cost with '||

4542: IF l_plog THEN
4543: fnd_log.string(
4544: fnd_log.level_procedure,
4545: l_module||'.'||l_stmt_num,
4546: 'Entering CSTPPWAC.calc_periodic_cost with '||
4547: 'i_cost_group_id = '||i_cost_group_id||','||
4548: 'i_cost_type_id = '||i_cost_type_id||','||
4549: 'i_low_level_code = '||i_low_level_code||','||
4550: 'i_user_id = '||i_user_id||','||

Line 5079: 'Exiting CSTPPWAC.calc_periodic_cost with '||

5075: IF l_plog THEN
5076: fnd_log.string(
5077: fnd_log.level_procedure,
5078: l_module||'.'||l_stmt_num,
5079: 'Exiting CSTPPWAC.calc_periodic_cost with '||
5080: 'o_err_num = '||o_err_num||','||
5081: 'o_err_code = '||o_err_code||','||
5082: 'o_err_msg = '||o_err_msg
5083: );

Line 5123: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calculate_periodic_cost';

5119: o_err_msg OUT NOCOPY VARCHAR2)
5120: IS
5121: l_stmt_num NUMBER;
5122: /* --- start of auto log --- */
5123: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calculate_periodic_cost';
5124: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5125: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5126: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5127: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

Line 5141: 'Entering CSTPPWAC.calculate_periodic_cost with '||

5137: IF l_plog THEN
5138: fnd_log.string(
5139: fnd_log.level_procedure,
5140: l_module||'.'||l_stmt_num,
5141: 'Entering CSTPPWAC.calculate_periodic_cost with '||
5142: 'i_cost_group_id = '||i_cost_group_id||','||
5143: 'i_cost_type_id = '||i_cost_type_id||','||
5144: 'i_low_level_code = '||i_low_level_code||','||
5145: 'i_item_id = '||i_item_id||','||

Line 5196: 'Exiting CSTPPWAC.calculate_periodic_cost with '||

5192: IF l_plog THEN
5193: fnd_log.string(
5194: fnd_log.level_procedure,
5195: l_module||'.'||l_stmt_num,
5196: 'Exiting CSTPPWAC.calculate_periodic_cost with '||
5197: 'o_err_num = '||o_err_num||','||
5198: 'o_err_code = '||o_err_code||','||
5199: 'o_err_msg = '||o_err_msg
5200: );

Line 5224: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_cppb';

5220: IS
5221: l_stmt_num NUMBER;
5222:
5223: /* --- start of auto log --- */
5224: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_cppb';
5225: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5226: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5227: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5228: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

Line 5241: 'Entering CSTPPWAC.update_cppb with '||

5237: IF l_plog THEN
5238: fnd_log.string(
5239: fnd_log.level_procedure,
5240: l_module||'.'||l_stmt_num,
5241: 'Entering CSTPPWAC.update_cppb with '||
5242: 'i_cost_group_id = '||i_cost_group_id||','||
5243: 'i_txn_category = '||i_txn_category||','||
5244: 'i_low_level_code = '||i_low_level_code||','||
5245: 'i_user_id = '||i_user_id||','||

Line 5453: 'Exiting CSTPPWAC.update_cppb with '||

5449: IF l_plog THEN
5450: fnd_log.string(
5451: fnd_log.level_procedure,
5452: l_module||'.'||l_stmt_num,
5453: 'Exiting CSTPPWAC.update_cppb with '||
5454: 'o_err_num = '||o_err_num||','||
5455: 'o_err_code = '||o_err_code||','||
5456: 'o_err_msg = '||o_err_msg
5457: );

Line 5498: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_item_cppb';

5494: IS
5495: l_stmt_num NUMBER;
5496:
5497: /* --- start of auto log --- */
5498: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_item_cppb';
5499: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5500: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5501: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5502: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

Line 5515: 'Entering CSTPPWAC.update_item_cppb with '||

5511: IF l_plog THEN
5512: fnd_log.string(
5513: fnd_log.level_procedure,
5514: l_module||'.'||l_stmt_num,
5515: 'Entering CSTPPWAC.update_item_cppb with '||
5516: 'i_cost_group_id = '||i_cost_group_id||','||
5517: 'i_txn_category = '||i_txn_category||','||
5518: 'i_item_id = '||i_item_id||','||
5519: 'i_user_id = '||i_user_id||','||

Line 5588: 'Exiting CSTPPWAC.update_item_cppb with '||

5584: IF l_plog THEN
5585: fnd_log.string(
5586: fnd_log.level_procedure,
5587: l_module||'.'||l_stmt_num,
5588: 'Exiting CSTPPWAC.update_item_cppb with '||
5589: 'o_err_num = '||o_err_num||','||
5590: 'o_err_code = '||o_err_code||','||
5591: 'o_err_msg = '||o_err_msg
5592: );

Line 5630: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_ending_balance';

5626: IS
5627: l_stmt_num NUMBER;
5628:
5629: /* --- start of auto log --- */
5630: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_ending_balance';
5631: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5632: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5633: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5634: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

Line 5647: 'Entering CSTPPWAC.insert_ending_balance with '||

5643: IF l_plog THEN
5644: fnd_log.string(
5645: fnd_log.level_procedure,
5646: l_module||'.'||l_stmt_num,
5647: 'Entering CSTPPWAC.insert_ending_balance with '||
5648: 'i_cost_group_id = '||i_cost_group_id||','||
5649: 'i_user_id = '||i_user_id||','||
5650: 'i_login_id = '||i_login_id||','||
5651: 'i_request_id = '||i_request_id||','||

Line 5728: 'Exiting CSTPPWAC.insert_ending_balance with '||

5724: IF l_plog THEN
5725: fnd_log.string(
5726: fnd_log.level_procedure,
5727: l_module||'.'||l_stmt_num,
5728: 'Exiting CSTPPWAC.insert_ending_balance with '||
5729: 'o_err_num = '||o_err_num||','||
5730: 'o_err_code = '||o_err_code||','||
5731: 'o_err_msg = '||o_err_msg
5732: );

Line 5753: END CSTPPWAC;

5749: o_err_msg := l_module || ' (' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,200);
5750: /* --- end of auto log --- */
5751: END insert_ending_balance;
5752:
5753: END CSTPPWAC;