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

Line 1: PACKAGE BODY CSTPACDP AS

1: PACKAGE BODY CSTPACDP AS
2: /* $Header: CSTACDPB.pls 120.64.12010000.5 2009/01/24 03:15:57 ipineda ship $ */
3:
4: --
5: -- OPM INVCONV umoogala Process-Discrete Xfers Enh.

Line 144: FND_FILE.put_line( FND_FILE.log, 'CSTPACDP.Cost_txn << ' );

140: l_debug := fnd_profile.value('MRP_DEBUG');
141:
142:
143: IF (l_debug = 'Y' ) THEN
144: FND_FILE.put_line( FND_FILE.log, 'CSTPACDP.Cost_txn << ' );
145: END IF;
146:
147:
148: -- Populate local variables

Line 335: CSTPACDP.comm_iss_to_wip(I_TXN_ID => i_txn_id,

331: ** 6) rest of inventory transactions **
332: *******************************************************************/
333: if (i_comm_iss_flag = 1) THEN
334: -- call dedicated function for common issue to wip txn here.
335: CSTPACDP.comm_iss_to_wip(I_TXN_ID => i_txn_id,
336: I_COMM_ISS_FLAG => i_comm_iss_flag,
337: I_FLOW_SCHEDULE => i_flow_schedule,
338: I_ORG_ID => i_org_id,
339: I_ITEM_ID => l_item_id,

Line 370: CSTPACDP.wip_cost_txn(i_org_id, i_txn_id, l_cost_grp_id, l_item_id,

366:
367: elsif (l_src_type_id = 5 and l_txn_act_id <> 2) then
368: -- WIP transaction
369: -- These always occur in base currency.
370: CSTPACDP.wip_cost_txn(i_org_id, i_txn_id, l_cost_grp_id, l_item_id,
371: l_txn_date, l_p_qty, l_subinv, l_txn_act_id,
372: l_txn_src_id, l_src_type_id,
373: l_dist_acct,
374: l_sob_id, l_pri_curr,

Line 387: CSTPACDP.sub_cost_txn(i_org_id, i_txn_id, l_cost_grp_id, l_txfr_cost_grp,

383:
384: /* Changes for VMI. Adding Planning Transfer transaction */
385: elsif (l_txn_act_id in (2,5,28,55)) then
386: -- Subinventory transfer,VMI Planning transfer,staging transfer,cost group transfer for WMS mobile
387: CSTPACDP.sub_cost_txn(i_org_id, i_txn_id, l_cost_grp_id, l_txfr_cost_grp,
388: l_item_id,
389: l_txn_date, l_p_qty, l_subinv, l_txf_subinv,
390: l_txf_txn_id, l_txn_act_id,
391: l_txn_src_id, l_src_type_id,

Line 414: CSTPACDP.interorg_cost_txn(i_org_id, i_txn_id, l_cost_grp_id,

410: l_txf_cost := 0;
411: end if;
412:
413: -- OPM INVCONV umoogala: Added new parameter (l_pd_txfr_price) to send transfer_price
414: CSTPACDP.interorg_cost_txn(i_org_id, i_txn_id, l_cost_grp_id,
415: l_txfr_cost_grp, l_item_id,
416: l_txn_date, l_p_qty, l_subinv,
417: l_txn_org_id, l_txf_org_id,
418: l_txf_txn_id, l_txf_cost, l_trp_cost,

Line 465: CSTPACDP.avcu_cost_txn(i_org_id, i_txn_id, l_cost_grp_id, l_item_id,

461: end if;
462:
463: elsif (l_txn_act_id = 24) then /*Removed i_txn_src_type_id = 15 for bug 6030287*/
464: -- Average Cost Update
465: CSTPACDP.avcu_cost_txn(i_org_id, i_txn_id, l_cost_grp_id, l_item_id,
466: l_txn_date, l_qty_adj, l_txn_act_id,
467: l_txn_src_id, l_src_type_id,
468: l_mat_acct, l_mat_ovhd_acct, l_res_acct,
469: l_osp_acct, l_ovhd_acct,

Line 485: CSTPACDP.logical_cost_txn(i_org_id, i_txn_id, l_cost_grp_id, l_item_id,

481: -- the following 2 elsifs are added for dropshipment project
482: elsif (l_logical_txn = 1) then
483: -- 11i10 - dropshipment project added logical transaction types
484: -- this function handles all new logical transactions
485: CSTPACDP.logical_cost_txn(i_org_id, i_txn_id, l_cost_grp_id, l_item_id,
486: l_txn_date, l_p_qty, l_subinv, l_txn_act_id,
487: l_txn_src_id, l_src_type_id, l_txn_type_id, l_dist_acct,
488: l_sob_id, l_pri_curr, l_alt_curr,
489: l_conv_date, l_conv_rate, l_conv_type,

Line 499: CSTPACDP.consigned_update_cost_txn(i_org_id, i_txn_id, l_cost_grp_id, l_item_id,

495: raise process_error;
496: end if;
497: elsif (l_txn_act_id = 25 and l_src_type_id = 1) then
498: -- 11i10 - Retroactive Price Update for consigned
499: CSTPACDP.consigned_update_cost_txn(i_org_id, i_txn_id, l_cost_grp_id, l_item_id,
500: l_txn_date, l_p_qty, l_subinv, l_txn_act_id,
501: l_txn_src_id, l_src_type_id, l_dist_acct,
502: l_sob_id, l_pri_curr, l_alt_curr,
503: l_conv_date, l_conv_rate, l_conv_type,

Line 512: CSTPACDP.inv_cost_txn(i_org_id, i_txn_id, l_cost_grp_id, l_item_id,

508: raise process_error;
509: end if;
510: else
511: -- Rest of inventory transactions
512: CSTPACDP.inv_cost_txn(i_org_id, i_txn_id, l_cost_grp_id, l_item_id,
513: l_txn_date, l_p_qty, l_subinv, l_txn_act_id,
514: l_txn_src_id, l_src_type_id,l_dist_acct,
515: l_sob_id, l_pri_curr, l_alt_curr,
516: l_conv_date, l_conv_rate, l_conv_type,

Line 625: CSTPACDP.encumbrance_account(i_org_id, i_txn_id, l_item_id,

621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
622: END IF;
623: /* Create the encumbrance for this transaction against the receipt
624: organization */
625: CSTPACDP.encumbrance_account(i_org_id, i_txn_id, l_item_id,
626: -1*l_enc_amount, l_p_qty, l_enc_acct,
627: l_sob_id, l_txn_date,
628: l_txn_src_id, l_src_type_id,
629: l_pri_curr, l_alt_curr,

Line 713: CSTPACDP.encumbrance_account(i_org_id, i_txn_id, l_item_id,

709:
710: /* Bug 6030861 :Added hook call to override the recoverable and Non-Recoverable
711: taxes for ENCUMBRANCE_REVERSAL event */
712:
713: CSTPACDP.encumbrance_account(i_org_id, i_txn_id, l_item_id,
714: -1*l_enc_amount, l_p_qty, l_enc_acct,
715: l_sob_id, l_txn_date,
716: l_txn_src_id, l_src_type_id,
717: l_pri_curr, l_alt_curr,

Line 737: FND_FILE.put_line( FND_FILE.log, 'CSTPACDP.Cost_Txn >>');

733: where transaction_id = i_txn_id
734: and transaction_costed_date is NULL;
735:
736: IF (l_debug = 'Y' ) THEN
737: FND_FILE.put_line( FND_FILE.log, 'CSTPACDP.Cost_Txn >>');
738: END IF;
739:
740: EXCEPTION
741:

Line 770: O_error_message := 'CSTPACDP.cost_txn' || to_char(l_stmt_num) ||

766:
767: when others then
768: rollback;
769: O_error_num := SQLCODE;
770: O_error_message := 'CSTPACDP.cost_txn' || to_char(l_stmt_num) ||
771: substr(SQLERRM,1,180);
772:
773: END cost_txn;
774:

Line 1110: O_error_message := 'CSTPACDP.comm_iss_to_wip (' || to_char(l_stmt_num) ||

1106: when others then
1107:
1108: rollback;
1109: O_error_num := SQLCODE;
1110: O_error_message := 'CSTPACDP.comm_iss_to_wip (' || to_char(l_stmt_num) ||
1111: '): ' || substr(SQLERRM,1,180);
1112:
1113: END comm_iss_to_wip;
1114:

Line 1403: O_error_message := 'CSTPACDP.wip_cost_txn (' || to_char(l_stmt_num) ||

1399: when others then
1400: fnd_file.put_line(fnd_file.log,'other exceptions raised');
1401: rollback;
1402: O_error_num := SQLCODE;
1403: O_error_message := 'CSTPACDP.wip_cost_txn (' || to_char(l_stmt_num) ||
1404: '): ' || substr(SQLERRM,1,180);
1405:
1406: END wip_cost_txn;
1407:

Line 1586: O_error_message := 'CSTPACDP.sub_cost_txn' || to_char(l_stmt_num) ||

1582: when others then
1583:
1584: rollback;
1585: O_error_num := SQLCODE;
1586: O_error_message := 'CSTPACDP.sub_cost_txn' || to_char(l_stmt_num) ||
1587: substr(SQLERRM,1,180);
1588:
1589: END sub_cost_txn;
1590:

Line 2255: O_error_message := 'CSTPACDP.inv_cost_txn (' || to_char(l_stmt_num) ||

2251: when others then
2252:
2253: rollback;
2254: O_error_num := SQLCODE;
2255: O_error_message := 'CSTPACDP.inv_cost_txn (' || to_char(l_stmt_num) ||
2256: '): ' || substr(SQLERRM,1,180);
2257:
2258: END inv_cost_txn;
2259:

Line 4287: O_error_message := 'CSTPACDP.interorg_cost_txn(' || to_char(l_stmt_num) || ') '||

4283: when others then
4284:
4285: rollback;
4286: O_error_num := SQLCODE;
4287: O_error_message := 'CSTPACDP.interorg_cost_txn(' || to_char(l_stmt_num) || ') '||
4288: substr(SQLERRM,1,180);
4289:
4290: end interorg_cost_txn;
4291:

Line 4354: fnd_file.put_line(fnd_file.log, 'CSTPACDP.avcu_cost_txn: ' || FND_MESSAGE.Get);

4350:
4351: l_stmt_num := 2;
4352: if (i_qty = 0 and l_debug = 'Y') THEN
4353: FND_MESSAGE.set_name('BOM', 'CST_UPDATE_ZERO_QTY');
4354: fnd_file.put_line(fnd_file.log, 'CSTPACDP.avcu_cost_txn: ' || FND_MESSAGE.Get);
4355: end if;
4356:
4357: l_stmt_num := 5;
4358:

Line 4652: O_error_message := 'CSTPACDP.avcu_cost_txn' || to_char(l_stmt_num) ||

4648:
4649: when others then
4650: rollback;
4651: O_error_num := SQLCODE;
4652: O_error_message := 'CSTPACDP.avcu_cost_txn' || to_char(l_stmt_num) ||
4653: substr(SQLERRM,1,180);
4654:
4655: END avcu_cost_txn;
4656:

Line 4991: O_error_message := 'CSTPACDP.logical_cost_txn (' || to_char(l_stmt_num) ||

4987:
4988: when process_error then
4989: rollback;
4990: O_error_num := SQLCODE;
4991: O_error_message := 'CSTPACDP.logical_cost_txn (' || to_char(l_stmt_num) ||
4992: '): ' || substr(SQLERRM,1,180);
4993:
4994: when others then
4995:

Line 4998: O_error_message := 'CSTPACDP.logical_cost_txn (' || to_char(l_stmt_num) ||

4994: when others then
4995:
4996: rollback;
4997: O_error_num := SQLCODE;
4998: O_error_message := 'CSTPACDP.logical_cost_txn (' || to_char(l_stmt_num) ||
4999: '): ' || substr(SQLERRM,1,180);
5000:
5001: END logical_cost_txn;
5002:

Line 5057: l_err_msg := 'CSTPACDP.consigned_update_cost_txn (10): '||

5053: where organization_id = i_org_id;
5054:
5055: if (l_retro_acct_id = -1) then
5056: l_err_num := SQLCODE;
5057: l_err_msg := 'CSTPACDP.consigned_update_cost_txn (10): '||
5058: 'RCV_PARAMETERS.RETROOPRICE_ADJ_ACCOUNT_ID must not be NULL';
5059: raise process_error;
5060: end if;
5061:

Line 5115: O_error_message := 'CSTPACDP.consigned_update_cost_txn (' || to_char(l_stmt_num) ||

5111: when others then
5112:
5113: rollback;
5114: O_error_num := SQLCODE;
5115: O_error_message := 'CSTPACDP.consigned_update_cost_txn (' || to_char(l_stmt_num) ||
5116: '): ' || substr(SQLERRM,1,180);
5117:
5118: END consigned_update_cost_txn;
5119:

Line 5269: l_err_msg := 'CSTPACDP.inventory_accounts_std(80): Unabled to obtain elemental accounts';

5265: AND organization_id = i_org_id;
5266:
5267: if (l_ccga_count = 0) then
5268: l_err_num := 9999;
5269: l_err_msg := 'CSTPACDP.inventory_accounts_std(80): Unabled to obtain elemental accounts';
5270: raise process_error;
5271: end if;
5272:
5273: l_stmt_num := 90;

Line 5364: O_error_message := 'CSTPACDP.inventory_accounts' || to_char(l_stmt_num) ||

5360: when others then
5361:
5362: rollback;
5363: O_error_num := SQLCODE;
5364: O_error_message := 'CSTPACDP.inventory_accounts' || to_char(l_stmt_num) ||
5365: substr(SQLERRM,1,180);
5366:
5367: END inventory_accounts_std;
5368:

Line 5813: O_error_message := 'CSTPACDP.inventory_accounts' || to_char(l_stmt_num) ||

5809: fnd_file.put_line (fnd_file.log, 'Inventory_accounts' || to_char(l_stmt_num)
5810: || substr(SQLERRM,1,180)) ;
5811: end if;
5812: O_error_num := SQLCODE;
5813: O_error_message := 'CSTPACDP.inventory_accounts' || to_char(l_stmt_num) ||
5814: substr(SQLERRM,1,180);
5815:
5816: END inventory_accounts;
5817:

Line 6175: O_error_message := 'CSTPACDP.distribute_accounts' || to_char(l_stmt_num) ||

6171:
6172: when others then
6173: rollback;
6174: O_error_num := SQLCODE;
6175: O_error_message := 'CSTPACDP.distribute_accounts' || to_char(l_stmt_num) ||
6176: substr(SQLERRM,1,180);
6177:
6178: end distribute_accounts;
6179:

Line 6323: O_error_message := 'CSTPACDP.cfm_scrap_dist_accounts' || to_char(l_stmt_num) ||

6319:
6320: when others then
6321: rollback;
6322: O_error_num := SQLCODE;
6323: O_error_message := 'CSTPACDP.cfm_scrap_dist_accounts' || to_char(l_stmt_num) ||
6324: substr(SQLERRM,1,180);
6325: end cfm_scrap_dist_accounts;
6326:
6327: procedure ovhd_accounts(

Line 6430: O_error_message := 'CSTPACDP.ovhd_accounts' || to_char(l_stmt_num) ||

6426: when others then
6427:
6428: rollback;
6429: O_error_num := SQLCODE;
6430: O_error_message := 'CSTPACDP.ovhd_accounts' || to_char(l_stmt_num) ||
6431: substr(SQLERRM,1,180);
6432:
6433: END ovhd_accounts;
6434:

Line 6523: O_error_message := 'CSTPACDP.encumbrance_account' || to_char(l_stmt_num) ||

6519:
6520: when others then
6521: rollback;
6522: O_error_num := SQLCODE;
6523: O_error_message := 'CSTPACDP.encumbrance_account' || to_char(l_stmt_num) ||
6524: substr(SQLERRM,1,180);
6525:
6526: END encumbrance_account;
6527:

Line 6779: O_error_message := 'CSTPACDP.insert_account (' || to_char(l_stmt_num)

6775:
6776: when others then
6777: rollback;
6778: O_error_num := SQLCODE;
6779: O_error_message := 'CSTPACDP.insert_account (' || to_char(l_stmt_num)
6780: || ') ' || substr(SQLERRM,1,180);
6781: FND_FILE.put_line(FND_FILE.log,'DS - others Exception, sqlcode = '||SQLCODE);
6782:
6783: end insert_account;

Line 6849: O_error_message := 'CSTPACDP.balance_account (' || to_char(l_stmt_num) ||

6845: when others then
6846:
6847: rollback;
6848: O_error_num := SQLCODE;
6849: O_error_message := 'CSTPACDP.balance_account (' || to_char(l_stmt_num) ||
6850: ') ' || substr(SQLERRM,1,180);
6851:
6852: END balance_account;
6853:

Line 7762: CSTPACDP.distribute_accounts(

7758: | Cr Inv. Val @ sending org cost
7759: +----------------------------------------------------------------------*/
7760: fnd_file.put_line(fnd_file.log, 'Cr Inv Val @ sending org cost');
7761:
7762: CSTPACDP.distribute_accounts(
7763: org_id, trans_id,
7764: 0, cg_id , txn_act_id,
7765: item_id, p_qty, 1,
7766: 1, 0, NULL, mat_acct, mat_ovhd_acct,

Line 7801: CSTPACDP.distribute_accounts(

7797: -- Shipping from expense destination fails with ORA-1400
7798: -- We were calling distribute_accounts with elemental flag 1.
7799: -- To book to exp account only, now sending elemental flag 0.
7800: --
7801: CSTPACDP.distribute_accounts(
7802: org_id, trans_id, 0, cg_id , txn_act_id,
7803: item_id, p_qty, 2, 0, 0,
7804: exp_acct, NULL, NULL, NULL, NULL, NULL,
7805: sob_id, txn_date, txn_src_id, src_type_id,

Line 7840: CSTPACDP.insert_account

7836: /*----------------------------------------------------------------------+
7837: | Cr Freight Acct
7838: +----------------------------------------------------------------------*/
7839: fnd_file.put_line(fnd_file.log, 'Cr Freight Acct with ' || trp_cost || ' ' || pri_curr);
7840: CSTPACDP.insert_account
7841: (org_id, trans_id, item_id, -1 * trp_cost,
7842: p_qty, trp_acct, sob_id, 12, NULL, NULL,
7843: txn_date, txn_src_id, src_type_id,
7844: pri_curr, NULL, NULL, NULL, NULL,1,

Line 7874: CSTPACDP.insert_account

7870: end if;
7871:
7872:
7873: fnd_file.put_line(fnd_file.log, 'Dr Receivables with ' || (txf_price * p_qty) || ' ' || pri_curr);
7874: CSTPACDP.insert_account
7875: (org_id, trans_id, item_id, -1 * txf_price * p_qty,
7876: -1 * p_qty, io_rec_acct, sob_id, 10, NULL, NULL,
7877: txn_date, txn_src_id, src_type_id,
7878: pri_curr, NULL, NULL, NULL, NULL,1,

Line 7943: CSTPACDP.insert_account

7939: interorg_profit_acct := user_acct_id;
7940: end if;
7941:
7942: fnd_file.put_line(fnd_file.log, 'Cr InterOrg Profit with ' || nvl(interorg_profit,0) || ' ' || pri_curr);
7943: CSTPACDP.insert_account
7944: (org_id, trans_id, item_id, -1 * interorg_profit,
7945: p_qty, interorg_profit_acct, sob_id,
7946: G_INTERORG_PROFIT_ACCT, NULL, NULL,
7947: txn_date, txn_src_id, src_type_id,

Line 7999: CSTPACDP.distribute_accounts(

7995: /*----------------------------------------------------------------------+
7996: | Cr Inv. Val @ sending org cost
7997: +----------------------------------------------------------------------*/
7998: fnd_file.put_line(fnd_file.log, 'Cr Inv Val @ sending org cost');
7999: CSTPACDP.distribute_accounts(
8000: org_id, trans_id,
8001: 0, cg_id , txn_act_id,
8002: item_id, p_qty, 1,
8003: 1, 0, NULL, mat_acct, mat_ovhd_acct,

Line 8021: CSTPACDP.distribute_accounts(

8017: /*----------------------------------------------------------------------+
8018: | Dr Intransit Acct @ org cost
8019: +----------------------------------------------------------------------*/
8020: fnd_file.put_line(fnd_file.log, 'Dr Intransit Acct @ org cost');
8021: CSTPACDP.distribute_accounts(
8022: org_id, trans_id, 0, cg_id , txn_act_id,
8023: item_id, -1 * p_qty, 14, 0, 0,
8024: io_inv_acct, NULL, NULL, NULL, NULL,NULL,
8025: sob_id, txn_date, txn_src_id, src_type_id,

Line 8055: CSTPACDP.insert_account

8051: mat_acct := user_acct_id;
8052: end if;
8053:
8054: fnd_file.put_line(fnd_file.log, 'Cr Inv Val');
8055: CSTPACDP.insert_account
8056: (org_id, trans_id, item_id, 0,
8057: p_qty, mat_acct, sob_id, 1, NULL, NULL,
8058: txn_date, txn_src_id, src_type_id,
8059: pri_curr, NULL, NULL, NULL, NULL,1,

Line 8085: CSTPACDP.insert_account

8081: io_inv_acct := user_acct_id;
8082: end if;
8083:
8084: fnd_file.put_line(fnd_file.log, 'Dr Intransit Acct');
8085: CSTPACDP.insert_account
8086: (org_id, trans_id, item_id, 0,
8087: -1 * p_qty, io_inv_acct, sob_id, 14, NULL, NULL,
8088: txn_date, txn_src_id, src_type_id,
8089: pri_curr, NULL, NULL, NULL, NULL,1,

Line 8115: CSTPACDP.distribute_accounts(

8111: /*----------------------------------------------------------------------+
8112: | Cr Exp Acct
8113: +----------------------------------------------------------------------*/
8114: fnd_file.put_line(fnd_file.log, 'Cr Exp Acct');
8115: CSTPACDP.distribute_accounts(
8116: org_id, trans_id, 0, cg_id , txn_act_id,
8117: item_id, p_qty, 2, 0, 0,
8118: exp_acct, NULL, NULL, NULL, NULL, NULL,
8119: sob_id, txn_date, txn_src_id, src_type_id,

Line 8133: CSTPACDP.distribute_accounts(

8129: /*----------------------------------------------------------------------+
8130: | Dr Intransit Acct @ org cost
8131: +----------------------------------------------------------------------*/
8132: fnd_file.put_line(fnd_file.log, 'Dr Intransit Acct @ org cost');
8133: CSTPACDP.distribute_accounts(
8134: org_id, trans_id,
8135: 0, cg_id , txn_act_id,
8136: item_id, -1 * p_qty, 14,
8137: 0, 0, io_inv_acct, NULL, NULL, NULL, NULL,NULL,

Line 8215: CSTPACDP.insert_account

8211: io_pay_acct := user_acct_id;
8212: end if;
8213:
8214: fnd_file.put_line(fnd_file.log, 'Cr Payables with ' || payamt || ' ' || pri_curr);
8215: CSTPACDP.insert_account
8216: (org_id, trans_id, item_id, -1 * payamt,
8217: -1 * p_qty, io_pay_acct, sob_id, 9, NULL, NULL,
8218: txn_date, txn_src_id, src_type_id,
8219: pri_curr, l_snd_curr, l_conv_date, l_conv_rate, l_curr_type, 1, /* INVCONV ANTHIYAG Bug#5352186 09-Sep-2006 */

Line 8255: CSTPACDP.insert_account

8251: /*----------------------------------------------------------------------+
8252: | Dr Exp Acct
8253: +----------------------------------------------------------------------*/
8254: fnd_file.put_line(fnd_file.log, 'Dr Exp Acct');
8255: CSTPACDP.insert_account
8256: (org_id, trans_id, item_id, interorg_xfr_price * p_qty,
8257: p_qty, exp_acct, sob_id, 2, NULL, NULL,
8258: txn_date, txn_src_id, src_type_id,
8259: pri_curr, l_snd_curr, l_conv_date, l_conv_rate, l_curr_type, 1, /* umoogala Bug#5708387 13-dec-2006 */

Line 8280: CSTPACDP.distribute_accounts(

8276: /*----------------------------------------------------------------------+
8277: | Dr Inv. Val @ org cost
8278: +----------------------------------------------------------------------*/
8279: fnd_file.put_line(fnd_file.log, 'Dr Inv Val @ org cost');
8280: CSTPACDP.distribute_accounts(
8281: org_id, trans_id,
8282: 0, cg_id , txn_act_id,
8283: item_id, p_qty, 1,
8284: 1, 0, NULL, mat_acct, mat_ovhd_acct,

Line 8308: CSTPACDP.ovhd_accounts(org_id, trans_id, item_id,

8304: /*----------------------------------------------------------------------+
8305: | Booking Overhead Acct
8306: +----------------------------------------------------------------------*/
8307: fnd_file.put_line(fnd_file.log, 'Booking Overhead Acct');
8308: CSTPACDP.ovhd_accounts(org_id, trans_id, item_id,
8309: -1 * p_qty, sob_id,
8310: txn_date, txn_src_id, src_type_id, subinv,
8311: snd_rcv, pri_curr,
8312: l_snd_curr, l_conv_date, l_conv_rate, l_curr_type, /* umoogala Bug#5708387 13-dec-2006 */

Line 8355: CSTPACDP.insert_account

8351: io_ppv_acct := user_acct_id;
8352: end if;
8353:
8354: fnd_file.put_line(fnd_file.log, 'Dr PPV with ' || ppv_amt || ' ' || pri_curr);
8355: CSTPACDP.insert_account
8356: (org_id, trans_id, item_id, ppv_amt,
8357: p_qty, io_ppv_acct, sob_id, 6, NULL, NULL,
8358: txn_date, txn_src_id, src_type_id,
8359: pri_curr, l_snd_curr, l_conv_date, l_conv_rate, l_curr_type, 1, /* umoogala Bug#5708387 13-dec-2006 */

Line 8423: CSTPACDP.distribute_accounts(

8419: exp_acct := user_acct_id;
8420: end if;
8421:
8422: fnd_file.put_line(fnd_file.log, 'Dr Exp Acct');
8423: CSTPACDP.distribute_accounts(
8424: org_id, trans_id,
8425: 0, cg_id , txn_act_id,
8426: item_id, p_qty, 2,
8427: 0, 0, exp_acct, NULL, NULL,

Line 8451: CSTPACDP.distribute_accounts(

8447: /*----------------------------------------------------------------------+
8448: | Dr Inv. Val @ org cost
8449: +----------------------------------------------------------------------*/
8450: fnd_file.put_line(fnd_file.log, 'Dr Inv Val @ org cost');
8451: CSTPACDP.distribute_accounts(
8452: org_id, trans_id,
8453: 0, cg_id , txn_act_id,
8454: item_id, p_qty, 1,
8455: 1, 0, NULL, mat_acct, mat_ovhd_acct,

Line 8492: CSTPACDP.distribute_accounts(

8488: /*----------------------------------------------------------------------+
8489: | Cr Intransit Acct @ org cost
8490: +----------------------------------------------------------------------*/
8491: fnd_file.put_line(fnd_file.log, 'Cr Intransit Acct @ org cost');
8492: CSTPACDP.distribute_accounts(
8493: org_id, trans_id,
8494: 0, cg_id , txn_act_id,
8495: item_id, -1 * p_qty, 14,
8496: 0, 0, io_inv_acct, NULL, NULL, NULL, NULL,NULL,

Line 8539: CSTPACDP.insert_account

8535: io_pay_acct := user_acct_id;
8536: end if;
8537:
8538: fnd_file.put_line(fnd_file.log, 'Cr Payables with ' || payamt || ' ' || pri_curr);
8539: CSTPACDP.insert_account
8540: (org_id, trans_id, item_id, payamt,
8541: -1 * p_qty, io_pay_acct, sob_id, 9, NULL, NULL,
8542: txn_date, txn_src_id, src_type_id,
8543: pri_curr, l_snd_curr,l_conv_date, l_conv_rate, l_curr_type, 1, /* INVCONV ANTHIYAG Bug#5352186 09-Sep-2006 End */

Line 8566: CSTPACDP.distribute_accounts(

8562: /*----------------------------------------------------------------------+
8563: | Dr Inv. Val @ org cost
8564: +----------------------------------------------------------------------*/
8565: fnd_file.put_line(fnd_file.log, 'Dr Inv Val @ org cost');
8566: CSTPACDP.distribute_accounts(
8567: org_id, trans_id,
8568: 0, cg_id , txn_act_id,
8569: item_id, p_qty, 1,
8570: 1, 0, NULL, mat_acct, mat_ovhd_acct,

Line 8591: CSTPACDP.ovhd_accounts(org_id, trans_id, item_id,

8587: IF (txn_act_id <> 17) AND -- Bug 5349860
8588: (exp_flg = 0) AND (exp_sub = 0) AND (l_earn_moh <> 0)
8589: THEN
8590: fnd_file.put_line(fnd_file.log, 'Booking Overhead Acct');
8591: CSTPACDP.ovhd_accounts(org_id, trans_id, item_id,
8592: -1 * p_qty, sob_id,
8593: txn_date, txn_src_id, src_type_id, subinv,
8594: snd_rcv, pri_curr,
8595: l_snd_curr, l_conv_date, l_conv_rate, l_curr_type, /* umoogala Bug#5708387 13-dec-2006 */

Line 8637: CSTPACDP.insert_account

8633: io_ppv_acct := user_acct_id;
8634: end if;
8635:
8636: fnd_file.put_line(fnd_file.log, 'Dr PPV with ' || ppv_amt || ' ' || pri_curr);
8637: CSTPACDP.insert_account
8638: (org_id, trans_id, item_id, ppv_amt,
8639: p_qty, io_ppv_acct, sob_id, 6, NULL, NULL,
8640: txn_date, txn_src_id, src_type_id,
8641: pri_curr, l_snd_curr, l_conv_date, l_conv_rate, l_curr_type, 1, /* umoogala Bug#5708387 13-dec-2006 */

Line 8674: CSTPACDP.insert_account

8670: exp_acct := user_acct_id;
8671: end if;
8672:
8673: fnd_file.put_line(fnd_file.log, 'Dr Exp Acct');
8674: CSTPACDP.insert_account
8675: (org_id, trans_id, item_id, -1 * payamt,
8676: p_qty, exp_acct, sob_id, 2, NULL, NULL,
8677: txn_date, txn_src_id, src_type_id,
8678: pri_curr, l_snd_curr, l_conv_date, l_conv_rate, l_curr_type, 1, /* umoogala Bug#5708387 13-dec-2006 */

Line 8766: CSTPACDP.distribute_accounts(

8762: io_inv_acct := user_acct_id;
8763: end if;
8764:
8765: fnd_file.put_line(fnd_file.log, 'Cr Intransit Acct @ org cost');
8766: CSTPACDP.distribute_accounts(
8767: org_id, trans_id,
8768: 0, cg_id , txn_act_id,
8769: item_id, -1 * p_qty, 14,
8770: 0, 0, io_inv_acct, NULL, NULL, NULL, NULL,NULL,

Line 8802: CSTPACDP.insert_account

8798: trp_acct := user_acct_id;
8799: end if;
8800:
8801: fnd_file.put_line(fnd_file.log, 'Cr Freight Acct with ' || trp_cost || ' ' || pri_curr);
8802: CSTPACDP.insert_account
8803: (org_id, trans_id, item_id, -1 * trp_cost,
8804: p_qty, trp_acct, sob_id, 12, NULL, NULL,
8805: txn_date, txn_src_id, src_type_id,
8806: pri_curr, NULL, NULL, NULL, NULL,1,

Line 8836: CSTPACDP.insert_account

8832: end if;
8833:
8834:
8835: fnd_file.put_line(fnd_file.log, 'Dr Receivalbes with ' || (interorg_xfr_price * p_qty) || ' ' || pri_curr);
8836: CSTPACDP.insert_account
8837: (org_id, trans_id, item_id, interorg_xfr_price * p_qty,
8838: p_qty, io_rec_acct, sob_id, 10, NULL, NULL,
8839: txn_date, txn_src_id, src_type_id,
8840: pri_curr, NULL, NULL, NULL, NULL,1,

Line 8892: CSTPACDP.insert_account

8888: interorg_profit_acct := user_acct_id;
8889: end if;
8890:
8891: fnd_file.put_line(fnd_file.log, 'Dr InterOrg Profit with ' || nvl(interorg_profit,0) || ' ' || pri_curr);
8892: CSTPACDP.insert_account
8893: (org_id, trans_id, item_id, -1 * interorg_profit, /* ANTHIYAG Bug#5459157 11-Aug-2006 */
8894: p_qty, interorg_profit_acct, sob_id,
8895: G_INTERORG_PROFIT_ACCT, NULL, NULL,
8896: txn_date, txn_src_id, src_type_id,

Line 8960: CSTPACDP.insert_account

8956: io_pay_acct := user_acct_id;
8957: end if;
8958:
8959: fnd_file.put_line(fnd_file.log, 'Cr Payables with ' || payamt || ' ' || pri_curr);
8960: CSTPACDP.insert_account
8961: (org_id, trans_id, item_id, payamt,
8962: -1 * p_qty, io_pay_acct, sob_id, 9, NULL, NULL,
8963: txn_date, txn_src_id, src_type_id,
8964: pri_curr, l_snd_curr,l_conv_date, l_conv_rate, l_curr_type, 1, /* INVCONV ANTHIYAG Bug#5352186 09-Sep-2006 End */

Line 8994: CSTPACDP.insert_account

8990: trp_acct := user_acct_id;
8991: end if;
8992:
8993: fnd_file.put_line(fnd_file.log, 'Cr Freight Acct with ' || trp_cost || ' ' || pri_curr);
8994: CSTPACDP.insert_account
8995: (org_id, trans_id, item_id, -1 * trp_cost,
8996: p_qty, trp_acct, sob_id, 12, NULL, NULL,
8997: txn_date, txn_src_id, src_type_id,
8998: pri_curr, l_snd_curr,l_conv_date, l_conv_rate, l_curr_type, 1, /* INVCONV ANTHIYAG Bug#5352186 09-Sep-2006 End */

Line 9030: CSTPACDP.insert_account

9026: acv_acct := user_acct_id;
9027: end if;
9028:
9029: fnd_file.put_line(fnd_file.log, 'Cr variance account with ' || var_amt || ' ' || pri_curr);
9030: CSTPACDP.insert_account
9031: (org_id, trans_id, item_id, var_amt,
9032: p_qty, acv_acct, sob_id, 13, NULL, NULL,
9033: txn_date, txn_src_id, src_type_id,
9034: pri_curr, l_snd_curr,l_conv_date, l_conv_rate, l_curr_type, 1, /* umoogala Bug#5708387 13-dec-2006 */

Line 9071: CSTPACDP.insert_account

9067: exp_acct := user_acct_id;
9068: end if;
9069:
9070: fnd_file.put_line(fnd_file.log, 'Dr Exp Acct');
9071: CSTPACDP.insert_account
9072: (org_id, trans_id, item_id, trp_cost,
9073: p_qty, exp_acct, sob_id, 2, NULL, NULL,
9074: txn_date, txn_src_id, src_type_id,
9075: pri_curr, l_snd_curr, l_conv_date, l_conv_rate, l_curr_type, 1, /* umoogala Bug#5708387 13-dec-2006 */

Line 9107: CSTPACDP.distribute_accounts(

9103: io_inv_acct := user_acct_id;
9104: end if;
9105:
9106: fnd_file.put_line(fnd_file.log, 'Dr Intransit Acct @ org cost');
9107: CSTPACDP.distribute_accounts(
9108: org_id, trans_id,
9109: 0, cg_id , txn_act_id,
9110: item_id, p_qty, 14,
9111: 0, 0, io_inv_acct, NULL, NULL, NULL, NULL,NULL,

Line 9139: CSTPACDP.ovhd_accounts(org_id, trans_id, item_id,

9135: /*----------------------------------------------------------------------+
9136: | Booking Overhead Acct
9137: +----------------------------------------------------------------------*/
9138: fnd_file.put_line(fnd_file.log, '-- Booking Overhead Acct');
9139: CSTPACDP.ovhd_accounts(org_id, trans_id, item_id,
9140: -1 * p_qty, sob_id,
9141: txn_date, txn_src_id, src_type_id, subinv,
9142: snd_rcv, pri_curr,
9143: l_snd_curr, l_conv_date, l_conv_rate, l_curr_type, /* umoogala Bug#5708387 13-dec-2006 */

Line 9186: CSTPACDP.insert_account

9182: io_ppv_acct := user_acct_id;
9183: end if;
9184:
9185: fnd_file.put_line(fnd_file.log, 'Dr PPV with ' || ppv_amt || ' ' || pri_curr);
9186: CSTPACDP.insert_account
9187: (org_id, trans_id, item_id, ppv_amt,
9188: p_qty, io_ppv_acct, sob_id, 6, NULL, NULL,
9189: txn_date, txn_src_id, src_type_id,
9190: pri_curr, l_snd_curr, l_conv_date, l_conv_rate, l_curr_type, 1, /* umoogala Bug#5708387 13-dec-2006 */

Line 9229: CSTPACDP.insert_account

9225: enc_acct := user_acct_id;
9226: end if;
9227:
9228: fnd_file.put_line(fnd_file.log, 'Cr Enc Acct with ' || enc_amt || ' ' || pri_curr);
9229: CSTPACDP.insert_account
9230: (org_id, trans_id, item_id, -1*enc_amt,
9231: p_qty, enc_acct, sob_id, 15, NULL, NULL,
9232: txn_date, txn_src_id, src_type_id,
9233: pri_curr, NULL, NULL, NULL, NULL,1,

Line 9287: CSTPACDP.balance_account(org_id, trans_id, O_Error_Num, O_Error_Code, O_Error_Message);

9283:
9284: l_stmt_num := 942;
9285:
9286: fnd_file.put_line(fnd_file.log, 'Balancing Accounts');
9287: CSTPACDP.balance_account(org_id, trans_id, O_Error_Num, O_Error_Code, O_Error_Message);
9288:
9289: if O_Error_Num <> 0
9290: then
9291: raise errexit;

Line 9450: O_Error_Message := 'CSTPACDP.cost_process_discrete_trx:' || '(' || l_stmt_num || '):' ||

9446: fnd_file.put_line(fnd_file.log,'in errexit exception');
9447: ROLLBACK;
9448:
9449: O_Error_Num := NVL(O_Error_Num, -1);
9450: O_Error_Message := 'CSTPACDP.cost_process_discrete_trx:' || '(' || l_stmt_num || '):' ||
9451: substr(O_Error_Message, 1, 180);
9452:
9453:
9454: UPDATE mtl_material_transactions

Line 9488: O_error_message := 'CSTPACDP.cost_process_discrete_trx:' || '(' || to_char(l_stmt_num) || '): '|| substr(SQLERRM,1,180);

9484: rollback;
9485:
9486: O_error_num := SQLCODE;
9487: O_error_code := SQLCODE;
9488: O_error_message := 'CSTPACDP.cost_process_discrete_trx:' || '(' || to_char(l_stmt_num) || '): '|| substr(SQLERRM,1,180);
9489:
9490: UPDATE mtl_material_transactions
9491: SET costed_flag = 'E',
9492: error_code = substrb(O_Error_Code,1,240),

Line 9794: O_error_message := 'CSTPACDP.balance_account_txn_type (' || to_char(l_stmt_num) ||

9790: WHEN OTHERS then
9791:
9792: ROLLBACK;
9793: O_error_num := SQLCODE;
9794: O_error_message := 'CSTPACDP.balance_account_txn_type (' || to_char(l_stmt_num) ||
9795: ') ' || substr(SQLERRM,1,180);
9796:
9797: END balance_account_txn_type;
9798:

Line 9802: END CSTPACDP;

9798:
9799:
9800:
9801:
9802: END CSTPACDP;
9803: