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.28.12010000.6 2008/11/29 02:36:19 anjha 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.28.12010000.6 2008/11/29 02:36:19 anjha 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 3271: 'Exiting CSTPPWAC.periodic_cost_update with '||

3267: IF l_plog THEN
3268: fnd_log.string(
3269: fnd_log.level_procedure,
3270: l_module||'.'||l_stmt_num,
3271: 'Exiting CSTPPWAC.periodic_cost_update with '||
3272: 'O_Err_Num = '||O_Err_Num||','||
3273: 'O_Err_Code = '||O_Err_Code||','||
3274: 'O_Err_Msg = '||O_Err_Msg
3275: );

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

3318: ) IS
3319: l_stmt_num NUMBER;
3320:
3321: -- start of auto log ---
3322: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_txn_history';
3323: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3324: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3325: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3326: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

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

3335: IF l_plog THEN
3336: fnd_log.string(
3337: fnd_log.level_procedure,
3338: l_module||'.'||l_stmt_num,
3339: 'Entering CSTPPWAC.insert_txn_history with '||
3340: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
3341: 'I_COST_GROUP_ID = '||I_COST_GROUP_ID||','||
3342: 'I_TXN_ID = '||I_TXN_ID||','||
3343: 'I_PROCESS_GROUP = '||I_PROCESS_GROUP||','||

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

3403: IF l_plog THEN
3404: fnd_log.string(
3405: fnd_log.level_procedure,
3406: l_module||'.'||l_stmt_num,
3407: 'Exiting CSTPPWAC.insert_txn_history with '||
3408: 'O_Err_Num = '||O_Err_Num||','||
3409: 'O_Err_Code = '||O_Err_Code||','||
3410: 'O_Err_Msg = '||O_Err_Msg
3411: );

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

3452: ) IS
3453: l_stmt_num NUMBER;
3454:
3455: --- start of auto log ---
3456: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_txn_history';
3457: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3458: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3459: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3460: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

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

3469: IF l_plog THEN
3470: fnd_log.string(
3471: fnd_log.level_procedure,
3472: l_module||'.'||l_stmt_num,
3473: 'Entering CSTPPWAC.update_txn_history with '||
3474: 'I_PAC_PERIOD_ID = '||I_PAC_PERIOD_ID||','||
3475: 'I_COST_GROUP_ID = '||I_COST_GROUP_ID||','||
3476: 'I_TXN_ID = '||I_TXN_ID||','||
3477: 'I_USER_ID = '||I_USER_ID||','||

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

3507: IF l_plog THEN
3508: fnd_log.string(
3509: fnd_log.level_procedure,
3510: l_module||'.'||l_stmt_num,
3511: 'Exiting CSTPPWAC.update_txn_history with '||
3512: 'O_Err_Num = '||O_Err_Num||','||
3513: 'O_Err_Code = '||O_Err_Code||','||
3514: 'O_Err_Msg = '||O_Err_Msg
3515: );

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

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

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

3573: IF l_plog THEN
3574: fnd_log.string(
3575: fnd_log.level_procedure,
3576: l_module||'.'||l_stmt_num,
3577: 'Entering CSTPPWAC.insert_into_cppb with '||
3578: 'i_cost_group_id = '||i_cost_group_id||','||
3579: 'i_txn_category = '||i_txn_category||','||
3580: 'i_user_id = '||i_user_id||','||
3581: 'i_login_id = '||i_login_id||','||

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

3830: IF l_plog THEN
3831: fnd_log.string(
3832: fnd_log.level_procedure,
3833: l_module||'.'||l_stmt_num,
3834: 'Exiting CSTPPWAC.insert_into_cppb with '||
3835: 'o_err_num = '||o_err_num||','||
3836: 'o_err_code = '||o_err_code||','||
3837: 'o_err_msg = '||o_err_msg
3838: );

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

3885: l_txn_category_tbl t_txn_category_tbl;
3886: l_cost_layer_id_tbl CSTPPINV.t_cost_layer_id_tbl;
3887:
3888: /* --- start of auto log --- */
3889: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_item_periodic_cost';
3890: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
3891: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
3892: fnd_log.TEST(fnd_log.level_unexpected, l_module);
3893: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

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

3902: IF l_plog THEN
3903: fnd_log.string(
3904: fnd_log.level_procedure,
3905: l_module||'.'||l_stmt_num,
3906: 'Entering CSTPPWAC.calc_item_periodic_cost with '||
3907: 'i_cost_group_id = '||i_cost_group_id||','||
3908: 'i_cost_type_id = '||i_cost_type_id||','||
3909: 'i_low_level_code = '||i_low_level_code||','||
3910: 'i_item_id = '||i_item_id||','||

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

4442: IF l_plog THEN
4443: fnd_log.string(
4444: fnd_log.level_procedure,
4445: l_module||'.'||l_stmt_num,
4446: 'Exiting CSTPPWAC.calc_item_periodic_cost with '||
4447: 'o_err_num = '||o_err_num||','||
4448: 'o_err_code = '||o_err_code||','||
4449: 'o_err_msg = '||o_err_msg
4450: );

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

4494: l_txn_category_tbl t_txn_category_tbl;
4495: l_cost_layer_id_tbl CSTPPINV.t_cost_layer_id_tbl;
4496:
4497: /* --- start of auto log --- */
4498: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calc_periodic_cost';
4499: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
4500: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
4501: fnd_log.TEST(fnd_log.level_unexpected, l_module);
4502: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

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

4511: IF l_plog THEN
4512: fnd_log.string(
4513: fnd_log.level_procedure,
4514: l_module||'.'||l_stmt_num,
4515: 'Entering CSTPPWAC.calc_periodic_cost with '||
4516: 'i_cost_group_id = '||i_cost_group_id||','||
4517: 'i_cost_type_id = '||i_cost_type_id||','||
4518: 'i_low_level_code = '||i_low_level_code||','||
4519: 'i_user_id = '||i_user_id||','||

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

5044: IF l_plog THEN
5045: fnd_log.string(
5046: fnd_log.level_procedure,
5047: l_module||'.'||l_stmt_num,
5048: 'Exiting CSTPPWAC.calc_periodic_cost with '||
5049: 'o_err_num = '||o_err_num||','||
5050: 'o_err_code = '||o_err_code||','||
5051: 'o_err_msg = '||o_err_msg
5052: );

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

5088: o_err_msg OUT NOCOPY VARCHAR2)
5089: IS
5090: l_stmt_num NUMBER;
5091: /* --- start of auto log --- */
5092: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.calculate_periodic_cost';
5093: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5094: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5095: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5096: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

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

5106: IF l_plog THEN
5107: fnd_log.string(
5108: fnd_log.level_procedure,
5109: l_module||'.'||l_stmt_num,
5110: 'Entering CSTPPWAC.calculate_periodic_cost with '||
5111: 'i_cost_group_id = '||i_cost_group_id||','||
5112: 'i_cost_type_id = '||i_cost_type_id||','||
5113: 'i_low_level_code = '||i_low_level_code||','||
5114: 'i_item_id = '||i_item_id||','||

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

5161: IF l_plog THEN
5162: fnd_log.string(
5163: fnd_log.level_procedure,
5164: l_module||'.'||l_stmt_num,
5165: 'Exiting CSTPPWAC.calculate_periodic_cost with '||
5166: 'o_err_num = '||o_err_num||','||
5167: 'o_err_code = '||o_err_code||','||
5168: 'o_err_msg = '||o_err_msg
5169: );

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

5189: IS
5190: l_stmt_num NUMBER;
5191:
5192: /* --- start of auto log --- */
5193: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_cppb';
5194: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5195: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5196: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5197: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

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

5206: IF l_plog THEN
5207: fnd_log.string(
5208: fnd_log.level_procedure,
5209: l_module||'.'||l_stmt_num,
5210: 'Entering CSTPPWAC.update_cppb with '||
5211: 'i_cost_group_id = '||i_cost_group_id||','||
5212: 'i_txn_category = '||i_txn_category||','||
5213: 'i_low_level_code = '||i_low_level_code||','||
5214: 'i_user_id = '||i_user_id||','||

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

5408: IF l_plog THEN
5409: fnd_log.string(
5410: fnd_log.level_procedure,
5411: l_module||'.'||l_stmt_num,
5412: 'Exiting CSTPPWAC.update_cppb with '||
5413: 'o_err_num = '||o_err_num||','||
5414: 'o_err_code = '||o_err_code||','||
5415: 'o_err_msg = '||o_err_msg
5416: );

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

5453: IS
5454: l_stmt_num NUMBER;
5455:
5456: /* --- start of auto log --- */
5457: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.update_item_cppb';
5458: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5459: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5460: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5461: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

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

5470: IF l_plog THEN
5471: fnd_log.string(
5472: fnd_log.level_procedure,
5473: l_module||'.'||l_stmt_num,
5474: 'Entering CSTPPWAC.update_item_cppb with '||
5475: 'i_cost_group_id = '||i_cost_group_id||','||
5476: 'i_txn_category = '||i_txn_category||','||
5477: 'i_item_id = '||i_item_id||','||
5478: 'i_user_id = '||i_user_id||','||

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

5543: IF l_plog THEN
5544: fnd_log.string(
5545: fnd_log.level_procedure,
5546: l_module||'.'||l_stmt_num,
5547: 'Exiting CSTPPWAC.update_item_cppb with '||
5548: 'o_err_num = '||o_err_num||','||
5549: 'o_err_code = '||o_err_code||','||
5550: 'o_err_msg = '||o_err_msg
5551: );

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

5585: IS
5586: l_stmt_num NUMBER;
5587:
5588: /* --- start of auto log --- */
5589: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CSTPPWAC.insert_ending_balance';
5590: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
5591: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
5592: fnd_log.TEST(fnd_log.level_unexpected, l_module);
5593: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

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

5602: IF l_plog THEN
5603: fnd_log.string(
5604: fnd_log.level_procedure,
5605: l_module||'.'||l_stmt_num,
5606: 'Entering CSTPPWAC.insert_ending_balance with '||
5607: 'i_cost_group_id = '||i_cost_group_id||','||
5608: 'i_user_id = '||i_user_id||','||
5609: 'i_login_id = '||i_login_id||','||
5610: 'i_request_id = '||i_request_id||','||

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

5683: IF l_plog THEN
5684: fnd_log.string(
5685: fnd_log.level_procedure,
5686: l_module||'.'||l_stmt_num,
5687: 'Exiting CSTPPWAC.insert_ending_balance with '||
5688: 'o_err_num = '||o_err_num||','||
5689: 'o_err_code = '||o_err_code||','||
5690: 'o_err_msg = '||o_err_msg
5691: );

Line 5712: END CSTPPWAC;

5708: o_err_msg := l_module || ' (' || to_char(l_stmt_num) || '): ' || substr(SQLERRM,1,200);
5709: /* --- end of auto log --- */
5710: END insert_ending_balance;
5711:
5712: END CSTPPWAC;