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.CST_EAMCOST_PUB dependencies on STANDARD

Line 65: , wor.standard_rate_flag

61: , wor.usage_rate_or_amount
62: , wor.basis_type
63: , wor.autocharge_type
64: , wor.uom_code
65: , wor.standard_rate_flag
66: FROM rcv_transactions rt
67: , wip_operation_resources wor
68: WHERE rt.transaction_id = p_rcv_trx_id
69: AND wor.wip_entity_id = rt.wip_entity_id

Line 260: -- Standard Start of API savepoint

256: l_debug VARCHAR2(80);
257:
258: BEGIN
259:
260: -- Standard Start of API savepoint
261: SAVEPOINT Process_MatCost_PUB;
262: l_debug := fnd_profile.value('MRP_DEBUG');
263:
264:

Line 265: -- Standard call to check for call compatibility

261: SAVEPOINT Process_MatCost_PUB;
262: l_debug := fnd_profile.value('MRP_DEBUG');
263:
264:
265: -- Standard call to check for call compatibility
266: IF NOT FND_API.Compatible_API_Call (
267: l_api_version,
268: p_api_version,
269: l_api_name,

Line 344: --- Standard check of p_commit

340: FND_MSG_pub.add;
341: RAISE FND_API.g_exc_error;
342: END IF;
343:
344: --- Standard check of p_commit
345: IF FND_API.to_Boolean(p_commit) THEN
346: COMMIT WORK;
347: END IF;
348:

Line 349: -- Standard Call to get message count and if count = 1, get message info

345: IF FND_API.to_Boolean(p_commit) THEN
346: COMMIT WORK;
347: END IF;
348:
349: -- Standard Call to get message count and if count = 1, get message info
350: FND_MSG_PUB.Count_And_Get (
351: p_count => x_msg_count,
352: p_data => x_msg_data );
353:

Line 472: -- Standard Start of API savepoint

468: AND we.entity_type in (6,7));
469:
470: BEGIN
471:
472: -- Standard Start of API savepoint
473: SAVEPOINT Process_ResCost_PUB;
474: l_debug := fnd_profile.value('MRP_DEBUG');
475:
476:

Line 482: -- Standard call to check for call compatibility

478: fnd_file.put_line(fnd_file.log, 'In process_resCost');
479: end if;
480:
481:
482: -- Standard call to check for call compatibility
483: IF NOT FND_API.Compatible_API_Call (
484: l_api_version,
485: p_api_version,
486: l_api_name,

Line 561: --- Standard check of p_commit

557: END IF;
558:
559: END LOOP;
560:
561: --- Standard check of p_commit
562: IF FND_API.to_Boolean(p_commit) THEN
563: COMMIT WORK;
564: END IF;
565:

Line 566: -- Standard Call to get message count and if count = 1, get message info

562: IF FND_API.to_Boolean(p_commit) THEN
563: COMMIT WORK;
564: END IF;
565:
566: -- Standard Call to get message count and if count = 1, get message info
567: FND_MSG_PUB.Count_And_Get (
568: p_count => x_msg_count,
569: p_data => x_msg_data );
570:

Line 715: -- Standard Start of API savepoint

711: l_check_category NUMBER;/*BUG 8835299*/
712:
713: BEGIN
714:
715: -- Standard Start of API savepoint
716: SAVEPOINT Update_eamCost_PUB;
717: l_debug := fnd_profile.value('MRP_DEBUG');
718:
719: if (l_debug = 'Y') then

Line 723: -- Standard call to check for call compatibility

719: if (l_debug = 'Y') then
720: fnd_file.put_line(fnd_file.log, 'In Update_eamCost');
721: end if;
722:
723: -- Standard call to check for call compatibility
724: IF NOT FND_API.Compatible_API_Call (
725: l_api_version,
726: p_api_version,
727: l_api_name,

Line 948: --- Standard check of p_commit

944: FND_MSG_pub.add;
945: RAISE FND_API.g_exc_error;
946: END IF;
947:
948: --- Standard check of p_commit
949: IF FND_API.to_Boolean(p_commit) THEN
950: COMMIT WORK;
951: END IF;
952:

Line 953: -- Standard Call to get message count and if count = 1, get message info

949: IF FND_API.to_Boolean(p_commit) THEN
950: COMMIT WORK;
951: END IF;
952:
953: -- Standard Call to get message count and if count = 1, get message info
954: FND_MSG_PUB.Count_And_Get (
955: p_count => x_msg_count,
956: p_data => x_msg_data );
957:

Line 1131: -- Standard Start of API savepoint

1127:
1128: BEGIN
1129:
1130:
1131: -- Standard Start of API savepoint
1132: SAVEPOINT InsertUpdate_eamPerBal_PUB;
1133: l_debug := fnd_profile.value('MRP_DEBUG');
1134:
1135: if (l_debug = 'Y') then

Line 1140: -- Standard call to check for call compatibility

1136: FND_FILE.PUT_LINE(fnd_file.log,'In InsertUpdate_eamPerBal');
1137: FND_FILE.PUT_LINE(fnd_file.log,'p_asset_group_id: ' || to_char( p_asset_group_id ));
1138: end if;
1139:
1140: -- Standard call to check for call compatibility
1141: IF NOT FND_API.Compatible_API_Call (
1142: l_api_version,
1143: p_api_version,
1144: l_api_name,

Line 1555: -- Standard check of p_commit

1551: if (l_debug = 'Y') then
1552: FND_FILE.PUT_LINE(fnd_file.log,'inserted into cst_eam_asset_per_balances' );
1553: end if;
1554:
1555: -- Standard check of p_commit
1556: IF FND_API.to_Boolean(p_commit) THEN
1557: COMMIT WORK;
1558: END IF;
1559:

Line 1560: -- Standard Call to get message count and if count = 1, get message info

1556: IF FND_API.to_Boolean(p_commit) THEN
1557: COMMIT WORK;
1558: END IF;
1559:
1560: -- Standard Call to get message count and if count = 1, get message info
1561: FND_MSG_PUB.Count_And_Get (
1562: p_count => x_msg_count,
1563: p_data => x_msg_data );
1564:

Line 1698: -- Standard Start of API savepoint

1694:
1695: l_debug VARCHAR2(1);
1696:
1697: BEGIN
1698: -- Standard Start of API savepoint
1699: SAVEPOINT InsertUpdate_assetPerBal_PUB;
1700: l_debug := fnd_profile.value('MRP_DEBUG');
1701:
1702: if (l_debug = 'Y') then

Line 1707: -- Standard call to check for call compatibility

1703: FND_FILE.PUT_LINE(fnd_file.log,'In InsertUpdate_assetPerBal');
1704: FND_FILE.PUT_LINE(fnd_file.log,'p_asset_group_id: ' || to_char( p_asset_group_id ));
1705: end if;
1706:
1707: -- Standard call to check for call compatibility
1708: IF NOT FND_API.Compatible_API_Call (
1709: l_api_version,
1710: p_api_version,
1711: l_api_name,

Line 1816: -- Standard check of p_commit

1812: );
1813: END IF; -- end checking asset balance rowcount
1814:
1815:
1816: -- Standard check of p_commit
1817: IF FND_API.to_Boolean(p_commit) THEN
1818: COMMIT WORK;
1819: END IF;
1820:

Line 1821: -- Standard Call to get message count and if count = 1, get message info

1817: IF FND_API.to_Boolean(p_commit) THEN
1818: COMMIT WORK;
1819: END IF;
1820:
1821: -- Standard Call to get message count and if count = 1, get message info
1822: FND_MSG_PUB.Count_And_Get (
1823: p_count => x_msg_count,
1824: p_data => x_msg_data );
1825:

Line 2246: -- Standard Start of API savepoint

2242: maint_cost_category;
2243:
2244: BEGIN
2245:
2246: -- Standard Start of API savepoint
2247: SAVEPOINT Delete_eamPerBal_PUB;
2248:
2249: -- Standard call to check for call compatibility
2250: IF NOT FND_API.Compatible_API_Call (

Line 2249: -- Standard call to check for call compatibility

2245:
2246: -- Standard Start of API savepoint
2247: SAVEPOINT Delete_eamPerBal_PUB;
2248:
2249: -- Standard call to check for call compatibility
2250: IF NOT FND_API.Compatible_API_Call (
2251: l_api_version,
2252: p_api_version,
2253: l_api_name,

Line 2778: wor.standard_rate_flag standard_flag,

2774: * decode(wor.basis_type,
2775: 1, l_lot_size,
2776: 2, 1,
2777: 1) usage_rate_or_amount,
2778: wor.standard_rate_flag standard_flag,
2779: wor.department_id department_id,
2780: br.functional_currency_flag functional_currency_flag,
2781: br.cost_element_id cost_element_id,
2782: br.resource_type resource_type

Line 3129: -- standard start of API savepoint

3125: l_mfg_cost_element_id Number;
3126:
3127: BEGIN
3128: -------------------------------------------------------------------------
3129: -- standard start of API savepoint
3130: -------------------------------------------------------------------------
3131: SAVEPOINT Compute_Job_Estimate;
3132:
3133: -------------------------------------------------------------------------

Line 3134: -- standard call to check for call compatibility

3130: -------------------------------------------------------------------------
3131: SAVEPOINT Compute_Job_Estimate;
3132:
3133: -------------------------------------------------------------------------
3134: -- standard call to check for call compatibility
3135: -------------------------------------------------------------------------
3136: IF NOT fnd_api.compatible_api_call (
3137: l_api_version,
3138: p_api_version,

Line 4269: /* NOTE: joining to ccicv.cost_group_id of 1 for standard costing org.

4265: AND wro.department_id = c_wro_rec.department_id
4266: AND wro.operation_seq_num = c_wro_rec.operation_seq_num
4267: AND wdj.organization_id = wro.organization_id ;/* Bug 5230287 */
4268:
4269: /* NOTE: joining to ccicv.cost_group_id of 1 for standard costing org.
4270: for ccicv, using default cost group id for that org is not
4271: needed in the case of standard costing. */
4272:
4273: END LOOP;

Line 4271: needed in the case of standard costing. */

4267: AND wdj.organization_id = wro.organization_id ;/* Bug 5230287 */
4268:
4269: /* NOTE: joining to ccicv.cost_group_id of 1 for standard costing org.
4270: for ccicv, using default cost group id for that org is not
4271: needed in the case of standard costing. */
4272:
4273: END LOOP;
4274:
4275: l_stmt_num := 130;

Line 5193: -- Standard check of p_commit

5189:
5190: END LOOP;
5191:
5192: ---------------------------------------------------------------------------
5193: -- Standard check of p_commit
5194: ---------------------------------------------------------------------------
5195:
5196: IF FND_API.to_Boolean(p_commit) THEN
5197: COMMIT WORK;

Line 5201: -- Standard Call to get message count and if count = 1, get message info

5197: COMMIT WORK;
5198: END IF;
5199:
5200: ---------------------------------------------------------------------------
5201: -- Standard Call to get message count and if count = 1, get message info
5202: ---------------------------------------------------------------------------
5203:
5204: FND_MSG_PUB.Count_And_Get (
5205: p_count => x_msg_count,

Line 5306: -- Standard start of API savepoint

5302: l_maintenance_object_id NUMBER;
5303: l_org_id NUMBER;
5304: BEGIN
5305: ---------------------------------------------
5306: -- Standard start of API savepoint
5307: ---------------------------------------------
5308: SAVEPOINT Rollup_Cost_PUB;
5309:
5310: ------------------------------------------------

Line 5311: -- Standard call to check for API compatibility

5307: ---------------------------------------------
5308: SAVEPOINT Rollup_Cost_PUB;
5309:
5310: ------------------------------------------------
5311: -- Standard call to check for API compatibility
5312: ------------------------------------------------
5313: l_statement := 10;
5314: IF not fnd_api.compatible_api_call (
5315: l_api_version,

Line 5710: -- Standard check of p_commit

5706: RAISE fnd_api.g_exc_error;
5707: END IF;
5708:
5709: ---------------------------------------------------------------------------
5710: -- Standard check of p_commit
5711: ---------------------------------------------------------------------------
5712: l_statement := 110;
5713: IF FND_API.to_Boolean(p_commit) THEN
5714: COMMIT WORK;

Line 5718: -- Standard Call to get message count and if count = 1, get message info

5714: COMMIT WORK;
5715: END IF;
5716:
5717: ---------------------------------------------------------------------------
5718: -- Standard Call to get message count and if count = 1, get message info
5719: ---------------------------------------------------------------------------
5720: l_statement := 120;
5721: fnd_msg_pub.count_and_get (p_count => x_msg_count,
5722: p_data => x_msg_data );

Line 5792: -- Standard start of API savepoint

5788: l_statement NUMBER := 0;
5789:
5790: BEGIN
5791: ---------------------------------------------
5792: -- Standard start of API savepoint
5793: ---------------------------------------------
5794: SAVEPOINT Purge_Rollup_Cost_PUB;
5795:
5796: ------------------------------------------------

Line 5797: -- Standard call to check for API compatibility

5793: ---------------------------------------------
5794: SAVEPOINT Purge_Rollup_Cost_PUB;
5795:
5796: ------------------------------------------------
5797: -- Standard call to check for API compatibility
5798: ------------------------------------------------
5799: l_statement := 10;
5800: IF not fnd_api.compatible_api_call (
5801: l_api_version,

Line 5837: -- Standard check of p_commit

5833: DELETE cst_eam_rollup_temp
5834: WHERE group_id= p_group_id;
5835:
5836: ---------------------------------------------------------------------------
5837: -- Standard check of p_commit
5838: ---------------------------------------------------------------------------
5839: l_statement := 60;
5840: IF FND_API.to_Boolean(p_commit) THEN
5841: COMMIT WORK;

Line 5845: -- Standard Call to get message count and if count = 1, get message info

5841: COMMIT WORK;
5842: END IF;
5843:
5844: ---------------------------------------------------------------------------
5845: -- Standard Call to get message count and if count = 1, get message info
5846: ---------------------------------------------------------------------------
5847: l_statement := 70;
5848: fnd_msg_pub.count_and_get (p_count => x_msg_count,
5849: p_data => x_msg_data );

Line 5930: -- Standard Start of API savepoint

5926: l_interface_txn_id NUMBER;
5927:
5928: BEGIN
5929:
5930: -- Standard Start of API savepoint
5931: SAVEPOINT check_if_direct_item_PUB;
5932: l_debug := fnd_profile.value('MRP_DEBUG');
5933:
5934: if (l_debug = 'Y') then

Line 5938: -- Standard call to check for call compatibility

5934: if (l_debug = 'Y') then
5935: FND_FILE.PUT_LINE(fnd_file.log,'Check if direct item');
5936: end if;
5937:
5938: -- Standard call to check for call compatibility
5939: IF NOT FND_API.Compatible_API_Call (
5940: l_api_version,
5941: p_api_version,
5942: l_api_name,

Line 6060: -- Standard check of p_commit

6056: if (l_debug = 'Y') then
6057: fnd_file.put_line(fnd_file.log,'Direct item flag : ' || to_char(x_direct_item_flag));
6058: end if;
6059:
6060: -- Standard check of p_commit
6061: IF FND_API.to_Boolean(p_commit) THEN
6062: COMMIT WORK;
6063: END IF;
6064:

Line 6065: -- Standard Call to get message count and if count = 1, get message info

6061: IF FND_API.to_Boolean(p_commit) THEN
6062: COMMIT WORK;
6063: END IF;
6064:
6065: -- Standard Call to get message count and if count = 1, get message info
6066: FND_MSG_PUB.Count_And_Get (
6067: p_count => x_msg_count,
6068: p_data => x_msg_data );
6069:

Line 6195: -- Standard Start of API savepoint

6191: l_enc_msg_data VARCHAR2(2000);
6192:
6193: BEGIN
6194:
6195: -- Standard Start of API savepoint
6196: SAVEPOINT process_direct_item_txn_PUB;
6197:
6198: l_debug := fnd_profile.value('MRP_DEBUG');
6199:

Line 6200: -- Standard call to check for call compatibility

6196: SAVEPOINT process_direct_item_txn_PUB;
6197:
6198: l_debug := fnd_profile.value('MRP_DEBUG');
6199:
6200: -- Standard call to check for call compatibility
6201: IF NOT FND_API.Compatible_API_Call (
6202: l_api_version,
6203: p_api_version,
6204: l_api_name,

Line 6365: l_directItem_rec.standard_rate_flag,

6361: l_directItem_rec.program_update_date,
6362: l_directItem_rec.project_id,
6363: l_directItem_rec.reason_id,
6364: l_directItem_rec.reference,
6365: l_directItem_rec.standard_rate_flag,
6366: l_directItem_rec.task_id,
6367: l_directItem_rec.transaction_date,
6368: l_directItem_rec.transaction_quantity,
6369: l_directItem_rec.transaction_type,

Line 6551: l_directItem_rec.standard_rate_flag,

6547: l_directItem_rec.program_update_date,
6548: l_directItem_rec.project_id,
6549: l_directItem_rec.reason_id,
6550: l_directItem_rec.reference,
6551: l_directItem_rec.standard_rate_flag,
6552: l_directItem_rec.task_id,
6553: l_directItem_rec.transaction_date,
6554: l_directItem_rec.transaction_quantity,
6555: l_directItem_rec.transaction_type,

Line 6696: -- Standard check of p_commit

6692: FND_MSG_pub.add;
6693: RAISE FND_API.g_exc_error;
6694: END IF;
6695:
6696: -- Standard check of p_commit
6697: IF FND_API.to_Boolean(p_commit) THEN
6698: COMMIT WORK;
6699: END IF;
6700:

Line 6701: -- Standard Call to get message count and if count = 1, get message info

6697: IF FND_API.to_Boolean(p_commit) THEN
6698: COMMIT WORK;
6699: END IF;
6700:
6701: -- Standard Call to get message count and if count = 1, get message info
6702: FND_MSG_PUB.Count_And_Get (
6703: p_count => x_msg_count,
6704: p_data => x_msg_data );
6705:

Line 6839: -- Standard Start of API savepoint

6835:
6836:
6837: BEGIN
6838:
6839: -- Standard Start of API savepoint
6840: SAVEPOINT cost_direct_item_txn_PUB;
6841:
6842: l_debug := fnd_profile.value('MRP_DEBUG');
6843:

Line 6844: -- Standard call to check for call compatibility

6840: SAVEPOINT cost_direct_item_txn_PUB;
6841:
6842: l_debug := fnd_profile.value('MRP_DEBUG');
6843:
6844: -- Standard call to check for call compatibility
6845: IF NOT FND_API.Compatible_API_Call (
6846: l_api_version,
6847: p_api_version,
6848: l_api_name,

Line 6876: first calculated and then rounded with standard precision of the functional currency*/

6872: l_stmt_num := 60;
6873: -- Obtain transaction value and line type
6874:
6875: /* Added the select statements in the IF clause for bug 4683371. The transaction value is
6876: first calculated and then rounded with standard precision of the functional currency*/
6877:
6878: /* Removed the select statement that fetched actual resource rate in functional
6879: currency for IPV xrf txns as actual resource rate is correctly populated in WCTI,
6880: no need to convert the value. Bug 5360723 */

Line 7173: -- Standard check of p_commit

7169: delete from wip_cost_txn_interface
7170: where group_id = p_group_id
7171: and process_status = 2;
7172:
7173: -- Standard check of p_commit
7174: IF FND_API.to_Boolean(p_commit) THEN
7175: COMMIT WORK;
7176: END IF;
7177:

Line 7178: -- Standard Call to get message count and if count = 1, get message info

7174: IF FND_API.to_Boolean(p_commit) THEN
7175: COMMIT WORK;
7176: END IF;
7177:
7178: -- Standard Call to get message count and if count = 1, get message info
7179: FND_MSG_PUB.Count_And_Get (
7180: p_count => x_msg_count,
7181: p_data => x_msg_data );
7182:

Line 7291: -- Standard Start of API savepoint

7287: l_source_code VARCHAR2(10);
7288:
7289: BEGIN
7290:
7291: -- Standard Start of API savepoint
7292: SAVEPOINT insert_direct_item_distr_PUB;
7293:
7294: l_debug := fnd_profile.value('MRP_DEBUG');
7295:

Line 7296: -- Standard call to check for call compatibility

7292: SAVEPOINT insert_direct_item_distr_PUB;
7293:
7294: l_debug := fnd_profile.value('MRP_DEBUG');
7295:
7296: -- Standard call to check for call compatibility
7297: IF NOT FND_API.Compatible_API_Call (
7298: l_api_version,
7299: p_api_version,
7300: l_api_name,

Line 7604: -- Standard check of p_commit

7600: FROM wip_cost_txn_interface wcti
7601: WHERE wcti.transaction_id = p_txn_id;
7602: END IF;
7603:
7604: -- Standard check of p_commit
7605: IF FND_API.to_Boolean(p_commit) THEN
7606: COMMIT WORK;
7607: END IF;
7608:

Line 7609: -- Standard Call to get message count and if count = 1, get message info

7605: IF FND_API.to_Boolean(p_commit) THEN
7606: COMMIT WORK;
7607: END IF;
7608:
7609: -- Standard Call to get message count and if count = 1, get message info
7610: FND_MSG_PUB.Count_And_Get (
7611: p_count => x_msg_count,
7612: p_data => x_msg_data );
7613:

Line 7705: -- Standard start of API savepoint

7701: l_update_stmt VARCHAR2(2000) := NULL;
7702:
7703: BEGIN
7704: ---------------------------------------------
7705: -- Standard start of API savepoint
7706: ---------------------------------------------
7707: SAVEPOINT update_wip_period_balances_PUB;
7708:
7709: l_debug := fnd_profile.value('MRP_DEBUG');

Line 7712: -- Standard call to check for API compatibility

7708:
7709: l_debug := fnd_profile.value('MRP_DEBUG');
7710:
7711: ------------------------------------------------
7712: -- Standard call to check for API compatibility
7713: ------------------------------------------------
7714: l_statement := 10;
7715: IF not fnd_api.compatible_api_call (
7716: l_api_version,

Line 7789: comply with PL/SQL Standards */

7785: end if;
7786:
7787: /* Bug 4321505 - Modified the dynamic update query to remove literals
7788: in the SQL and use bind variables instead. This is to make the SQL
7789: comply with PL/SQL Standards */
7790:
7791: if l_cost_element = 1 then
7792: l_update_stmt := 'UPDATE wip_period_balances ' ||
7793: 'SET pl_material_in = nvl( pl_material_in, 0) + :l_txn_value , ' ||

Line 7842: -- Standard check of p_commit

7838: EXECUTE IMMEDIATE l_update_stmt USING
7839: l_txn_value, p_user_id, p_login_id, p_request_id, p_prg_appl_id, p_prg_id,
7840: p_wip_entity_id, p_acct_period_id;
7841:
7842: -- Standard check of p_commit
7843: IF FND_API.to_Boolean(p_commit) THEN
7844: COMMIT WORK;
7845: END IF;
7846:

Line 7847: -- Standard Call to get message count and if count = 1, get message info

7843: IF FND_API.to_Boolean(p_commit) THEN
7844: COMMIT WORK;
7845: END IF;
7846:
7847: -- Standard Call to get message count and if count = 1, get message info
7848: FND_MSG_PUB.Count_And_Get (
7849: p_count => x_msg_count,
7850: p_data => x_msg_data );
7851:

Line 7928: -- Standard Start of API savepoint

7924: l_debug VARCHAR2(80);
7925:
7926: BEGIN
7927:
7928: -- Standard Start of API savepoint
7929: SAVEPOINT insert_direct_item_txn_PUB;
7930:
7931: l_debug := fnd_profile.value('MRP_DEBUG');
7932:

Line 7933: -- Standard call to check for call compatibility

7929: SAVEPOINT insert_direct_item_txn_PUB;
7930:
7931: l_debug := fnd_profile.value('MRP_DEBUG');
7932:
7933: -- Standard call to check for call compatibility
7934: IF NOT FND_API.Compatible_API_Call (
7935: l_api_version,
7936: p_api_version,
7937: l_api_name,

Line 7977: standard_rate_flag,

7973: line_id,
7974: source_code,
7975: source_line_id,
7976: operation_seq_num,
7977: standard_rate_flag,
7978: usage_rate_or_amount,
7979: basis_type,
7980: transaction_quantity,
7981: transaction_uom,

Line 8024: wcti.standard_rate_flag,

8020: wcti.line_id,
8021: wcti.source_code,
8022: wcti.source_line_id,
8023: wcti.operation_seq_num,
8024: wcti.standard_rate_flag,
8025: wcti.usage_rate_or_amount,
8026: wcti.basis_type,
8027: decode(wcti.source_code,'IPV',NULL,wcti.transaction_quantity),
8028: wcti.transaction_uom,

Line 8066: -- Standard check of p_commit

8062: from wip_cost_txn_interface wcti
8063: where group_id = p_group_id
8064: and process_status = 2;
8065:
8066: -- Standard check of p_commit
8067: IF FND_API.to_Boolean(p_commit) THEN
8068: COMMIT WORK;
8069: END IF;
8070:

Line 8071: -- Standard Call to get message count and if count = 1, get message info

8067: IF FND_API.to_Boolean(p_commit) THEN
8068: COMMIT WORK;
8069: END IF;
8070:
8071: -- Standard Call to get message count and if count = 1, get message info
8072: FND_MSG_PUB.Count_And_Get (
8073: p_count => x_msg_count,
8074: p_data => x_msg_data );
8075:

Line 8172: -- Standard start of API savepoint

8168:
8169: BEGIN
8170:
8171: ---------------------------------------------
8172: -- Standard start of API savepoint
8173: ---------------------------------------------
8174: SAVEPOINT get_Direct_Item_Charge_Acct;
8175:
8176: ------------------------------------------------

Line 8177: -- Standard call to check for API compatibility

8173: ---------------------------------------------
8174: SAVEPOINT get_Direct_Item_Charge_Acct;
8175:
8176: ------------------------------------------------
8177: -- Standard call to check for API compatibility
8178: ------------------------------------------------
8179: l_statement := 10;
8180: IF not fnd_api.compatible_api_call (
8181: l_api_version,

Line 8316: -- Standard start of API savepoint

8312: l_validate_flag NUMBER := 0;
8313: l_hook NUMBER := 0;
8314:
8315: BEGIN
8316: -- Standard start of API savepoint
8317: SAVEPOINT validate_for_reestimation_PUB;
8318:
8319: -- Standard call to check for call compatibility
8320: IF NOT FND_API.Compatible_API_Call (

Line 8319: -- Standard call to check for call compatibility

8315: BEGIN
8316: -- Standard start of API savepoint
8317: SAVEPOINT validate_for_reestimation_PUB;
8318:
8319: -- Standard call to check for call compatibility
8320: IF NOT FND_API.Compatible_API_Call (
8321: l_api_version,
8322: p_api_version,
8323: l_api_name,

Line 8378: -- Standard check of p_commit

8374: else
8375: x_validate_flag := 0;
8376: end if;
8377:
8378: -- Standard check of p_commit
8379: IF FND_API.to_Boolean(p_commit) THEN
8380: COMMIT WORK;
8381: END IF;
8382:

Line 8383: -- Standard Call to get message count and if count = 1, get message info

8379: IF FND_API.to_Boolean(p_commit) THEN
8380: COMMIT WORK;
8381: END IF;
8382:
8383: -- Standard Call to get message count and if count = 1, get message info
8384: FND_MSG_PUB.Count_And_Get (
8385: p_count => x_msg_count,
8386: p_data => x_msg_data );
8387:

Line 8560: -- standard start of API savepoint

8556:
8557: BEGIN
8558:
8559: -------------------------------------------------------------------------
8560: -- standard start of API savepoint
8561: -------------------------------------------------------------------------
8562: SAVEPOINT Redistribute_WIP_Accounts;
8563:
8564: -------------------------------------------------------------------------

Line 8565: -- standard call to check for call compatibility

8561: -------------------------------------------------------------------------
8562: SAVEPOINT Redistribute_WIP_Accounts;
8563:
8564: -------------------------------------------------------------------------
8565: -- standard call to check for call compatibility
8566: -------------------------------------------------------------------------
8567: IF NOT fnd_api.compatible_api_call (
8568: l_api_version,
8569: p_api_version,

Line 8886: -- Standard check of p_commit

8882: END LOOP; --for route jobs
8883:
8884: l_stmt_num := 75;
8885: ---------------------------------------------------------------------------
8886: -- Standard check of p_commit
8887: ---------------------------------------------------------------------------
8888:
8889: IF FND_API.to_Boolean(p_commit) THEN
8890: COMMIT WORK;

Line 8894: -- Standard Call to get message count and if count = 1, get message info

8890: COMMIT WORK;
8891: END IF;
8892:
8893: ---------------------------------------------------------------------------
8894: -- Standard Call to get message count and if count = 1, get message info
8895: ---------------------------------------------------------------------------
8896:
8897: FND_MSG_PUB.Count_And_Get (
8898: p_count => x_msg_count,

Line 8990: -- Standard call to check for call compatibility

8986: l_maint_object_id wip_discrete_jobs.maintenance_object_source%TYPE;
8987: l_inventory_item_id csi_item_instances.inventory_item_id%TYPE;
8988: l_serial_number csi_item_instances.serial_number%TYPE;
8989: BEGIN
8990: -- Standard call to check for call compatibility
8991: IF NOT FND_API.Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
8992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8993: END IF;
8994:

Line 9066: -- Standard Call to get message count and if count = 1, get message info

9062: x_serial_number := NULL;
9063: x_maintenance_object_id := NULL;
9064: END IF;
9065:
9066: -- Standard Call to get message count and if count = 1, get message info
9067: l_stmt_num := 30;
9068: FND_MSG_PUB.Count_And_Get(
9069: p_count => x_msg_count,
9070: p_data => x_msg_data);

Line 9154: -- Standard start of API savepoint

9150:
9151:
9152: BEGIN
9153: -----------------------------------
9154: -- Standard start of API savepoint
9155: -----------------------------------
9156: SAVEPOINT get_CostEle_for_DirectItem_PVT;
9157:
9158: l_debug := fnd_profile.value('MRP_DEBUG');

Line 9164: -- Standard call to check for API compatibility

9160: fnd_file.put_line(fnd_file.log, 'In get_CostEle_for_DirectItem');
9161: end if;
9162:
9163: ------------------------------------------------
9164: -- Standard call to check for API compatibility
9165: ------------------------------------------------
9166: l_statement := 10;
9167: IF not fnd_api.compatible_api_call( l_api_version,
9168: p_api_version,

Line 9392: -- Standard Call to get message count and if count = 1, get message info

9388: end if;
9389:
9390: x_cost_element_id := l_cost_element_id;
9391:
9392: -- Standard Call to get message count and if count = 1, get message info
9393: FND_MSG_PUB.Count_And_Get (
9394: p_count => x_msg_count,
9395: p_data => x_msg_data );
9396:

Line 9500: -- Standard start of API savepoint

9496: l_project_id NUMBER;
9497:
9498: BEGIN
9499: -----------------------------------
9500: -- Standard start of API savepoint
9501: -----------------------------------
9502: SAVEPOINT get_ExpType_for_DirectItem_PVT;
9503:
9504: l_debug := fnd_profile.value('MRP_DEBUG');

Line 9510: -- Standard call to check for API compatibility

9506: fnd_file.put_line(fnd_file.log, 'In get_ExpType_for_DirectItem');
9507: end if;
9508:
9509: ------------------------------------------------
9510: -- Standard call to check for API compatibility
9511: ------------------------------------------------
9512: l_statement := 10;
9513: IF not fnd_api.compatible_api_call( l_api_version,
9514: p_api_version,

Line 9711: -- Standard Call to get message count and if count = 1, get message info

9707: end if;
9708:
9709: x_expenditure_type := l_expenditure_type;
9710:
9711: -- Standard Call to get message count and if count = 1, get message info
9712: FND_MSG_PUB.Count_And_Get (
9713: p_count => x_msg_count,
9714: p_data => x_msg_data );
9715:

Line 9765: -- Standard Start of API savepoint

9761: l_stmt_num NUMBER := 0;
9762: l_object_type_count NUMBER;
9763: l_object_type_exc EXCEPTION;
9764: BEGIN
9765: -- Standard Start of API savepoint
9766: SAVEPOINT Rollup_WorkOrderCost_PUB;
9767:
9768: -- Initialize message list if p_init_msg_list is set to TRUE
9769: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 10015: -- Standard Start of API savepoint

10011: l_api_version CONSTANT NUMBER := 1.0;
10012: l_msg_level_threshold NUMBER;
10013: l_stmt_num NUMBER := 0;
10014: BEGIN
10015: -- Standard Start of API savepoint
10016: SAVEPOINT Purge_RollupCost_PUB;
10017:
10018: -- Initialize message list if p_init_msg_list is set to TRUE
10019: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 10173: -- Standard Start of API savepoint

10169: l_cnt_cebba NUMBER;
10170: l_stmt_num NUMBER;
10171:
10172: BEGIN
10173: -- Standard Start of API savepoint
10174: SAVEPOINT Insert_eamBalAcct_PUB;
10175:
10176: if( l_pLog ) then
10177: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 10197: -- Standard call to check for call compatibility.

10193: 'p_value=' || p_value ||',' ||
10194: ')');
10195: end if;
10196:
10197: -- Standard call to check for call compatibility.
10198: IF NOT FND_API.Compatible_API_Call ( l_api_version,
10199: p_api_version,
10200: l_api_name ,
10201: 'CST_eamCost_PUB')

Line 10291: -- Standard check of p_commit.

10287: p_login_id
10288: );
10289:
10290:
10291: -- Standard check of p_commit.
10292: IF FND_API.To_Boolean( p_commit ) THEN
10293: COMMIT WORK;
10294: END IF;
10295:

Line 10306: -- Standard call to get message count and if count is 1, get message info.

10302: 'End of ' || l_full_name
10303: );
10304: END IF;
10305:
10306: -- Standard call to get message count and if count is 1, get message info.
10307: FND_MSG_PUB.Count_And_Get
10308: ( p_count => x_msg_count ,
10309: p_data => x_msg_data
10310: );

Line 10390: -- Standard Start of API savepoint

10386: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
10387:
10388: l_stmt_num NUMBER;
10389: BEGIN
10390: -- Standard Start of API savepoint
10391: SAVEPOINT Delete_eamBalAcct_PUB;
10392: -- Standard call to check for call compatibility.
10393: IF NOT FND_API.Compatible_API_Call ( l_api_version,
10394: p_api_version,

Line 10392: -- Standard call to check for call compatibility.

10388: l_stmt_num NUMBER;
10389: BEGIN
10390: -- Standard Start of API savepoint
10391: SAVEPOINT Delete_eamBalAcct_PUB;
10392: -- Standard call to check for call compatibility.
10393: IF NOT FND_API.Compatible_API_Call ( l_api_version,
10394: p_api_version,
10395: l_api_name ,
10396: 'CST_eamCost_PUB')

Line 10422: -- Standard check of p_commit.

10418: Delete from CST_EAM_BALANCE_BY_ACCOUNTS
10419: where wip_entity_id = p_entity_id_tab(l_index)
10420: and organization_id=p_org_id;
10421:
10422: -- Standard check of p_commit.
10423: IF FND_API.To_Boolean( p_commit ) THEN
10424: COMMIT WORK;
10425: END IF;
10426:

Line 10436: -- Standard call to get message count and if count is 1, get message info.

10432: 'End of ' || l_full_name
10433: );
10434: END IF;
10435:
10436: -- Standard call to get message count and if count is 1, get message info.
10437: FND_MSG_PUB.Count_And_Get
10438: ( p_count => x_msg_count ,
10439: p_data => x_msg_data
10440: );

Line 10544: -- Standard Start of API savepoint

10540: FOR UPDATE;
10541:
10542: BEGIN
10543:
10544: -- Standard Start of API savepoint
10545: SAVEPOINT Insert_tempEstimateDetails_PUB;
10546:
10547: -- Standard call to check for call compatibility.
10548: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 10547: -- Standard call to check for call compatibility.

10543:
10544: -- Standard Start of API savepoint
10545: SAVEPOINT Insert_tempEstimateDetails_PUB;
10546:
10547: -- Standard call to check for call compatibility.
10548: IF NOT FND_API.Compatible_API_Call (l_api_version,
10549: p_api_version,
10550: l_api_name ,
10551: 'CST_eamCost_PUB') THEN

Line 10939: -- Standard check of p_commit.

10935: End if;
10936:
10937: l_stmt_num := 40;
10938:
10939: -- Standard check of p_commit.
10940: IF FND_API.To_Boolean( p_commit ) THEN
10941: COMMIT WORK;
10942: END IF;
10943:

Line 10953: -- Standard call to get message count and if count is 1, get message info.

10949: 'End of ' || l_full_name
10950: );
10951: END IF;
10952:
10953: -- Standard call to get message count and if count is 1, get message info.
10954: FND_MSG_PUB.Count_And_Get
10955: ( p_count => x_msg_count,
10956: p_data => x_msg_data
10957: );

Line 11085: -- Standard start of API savepoint

11081: --Step 3 : Compute encumbrance amount using values got in Step 1 and assign final
11082: --values to out parameter
11083: ---------------------------------------------------------
11084:
11085: -- Standard start of API savepoint
11086: SAVEPOINT GET_ENCUMBRANCE_DATA_PVT;
11087: l_stmt_num := 10 ;
11088:
11089: -- Initialize API return status to success