DBA Data[Home] [Help]

APPS.CSTPACDP dependencies on CSTPACHK

Line 2216: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,

2212: l_stmt_num := 50;
2213:
2214: l_io_receivable_acct := l_acct;
2215:
2216: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,
2217: sign(-1 * i_p_qty),
2218: l_acct_line_type,
2219: NULL, NULL, i_subinv,
2220: 0, NULL, l_err_num, l_err_code,

Line 2268: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,

2264:
2265: IF l_value <> 0
2266: THEN
2267:
2268: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,
2269: -1, l_acct_line_type,
2270: NULL, NULL, i_subinv,
2271: 0, NULL, l_err_num, l_err_code,
2272: l_err_msg,NULL);

Line 2878: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, -1, 12,

2874: then
2875: -- shipping txn, trp_cost
2876: l_value := i_trp_cost;
2877:
2878: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, -1, 12,
2879: NULL, NULL, l_subinv,0, l_snd_rcv,
2880: l_err_num, l_err_code, l_err_msg,NULL);
2881:
2882: if (l_err_num <> 0) then

Line 2916: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, 1, 10,

2912: l_value := i_txf_price * l_snd_qty;
2913:
2914: fnd_file.put_line(fnd_file.log,'Receivables amount: ' || l_value);
2915:
2916: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, 1, 10,
2917: NULL, NULL, l_subinv,0, l_snd_rcv,
2918: l_err_num, l_err_code, l_err_msg,NULL);
2919:
2920: if (l_err_num <> 0) then

Line 3005: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, 1, 34,

3001: ;
3002:
3003: fnd_file.put_line(fnd_file.log,'InterOrg Profit amount: ' || l_value);
3004:
3005: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, 1, 34,
3006: NULL, NULL, l_subinv,0, l_snd_rcv,
3007: l_err_num, l_err_code, l_err_msg,NULL);
3008:
3009: if (l_err_num <> 0) then

Line 3179: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, -1, 11,

3175:
3176: fnd_file.put_line(fnd_file.log,'Transfer Credit account: ' || l_value);
3177:
3178: /* Credit sending org transfer credit */
3179: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, -1, 11,
3180: NULL, NULL, l_subinv,0, l_snd_rcv,
3181: l_err_num, l_err_code, l_err_msg,NULL);
3182:
3183: if (l_err_num <> 0) then

Line 3225: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, -1, 12,

3221: end if;
3222:
3223: fnd_file.put_line(fnd_file.log,'Freight account: ' || l_value);
3224:
3225: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, -1, 12,
3226: NULL, NULL, l_subinv,0, l_snd_rcv,
3227: l_err_num, l_err_code, l_err_msg,NULL);
3228:
3229: if (l_err_num <> 0) then

Line 3281: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, 1, 10,

3277: end if;
3278:
3279: fnd_file.put_line(fnd_file.log,'receivables account: ' || l_value);
3280:
3281: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, 1, 10,
3282: NULL, NULL, l_subinv,0, l_snd_rcv,
3283: l_err_num, l_err_code, l_err_msg,NULL);
3284:
3285: if (l_err_num <> 0) then

Line 3342: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, 1,

3338: ;
3339:
3340: fnd_file.put_line(fnd_file.log,'InterOrg profit account: ' || l_value);
3341:
3342: l_acct := CSTPACHK.get_account_id(l_from_org, i_txn_id, 1,
3343: G_INTERORG_PROFIT_ACCT,
3344: NULL, NULL, l_subinv,0, l_snd_rcv,
3345: l_err_num, l_err_code, l_err_msg,NULL);
3346:

Line 3521: l_acct := CSTPACHK.get_account_id(l_to_org, i_txn_id, -1, 2,

3517: * Inventory AP Accrual account rather than the Inter-Org Payables Account *
3518: ************************************************************************************/
3519:
3520: IF nvl(l_io_invoicing, 2) = 1 AND i_src_type_id = 7 AND l_org_ou <> l_txf_org_ou THEN /* INVCONV Bug#5498133/5498041 ANTHIYAG 30-Aug-2006 */
3521: l_acct := CSTPACHK.get_account_id(l_to_org, i_txn_id, -1, 2,
3522: NULL, NULL, l_subinv,0, l_snd_rcv,
3523: l_err_num, l_err_code, l_err_msg,NULL);
3524:
3525: if (l_err_num <> 0) then

Line 3548: l_acct := CSTPACHK.get_account_id(l_to_org, i_txn_id, -1, 9,

3544:
3545: ELSE
3546: /* INVCONV Bug#5471471 ANTHIYAG 18-Aug-2006 End */
3547:
3548: l_acct := CSTPACHK.get_account_id(l_to_org, i_txn_id, -1, 9,
3549: NULL, NULL, l_subinv,0, l_snd_rcv,
3550: l_err_num, l_err_code, l_err_msg,NULL);
3551:
3552: if (l_err_num <> 0) then

Line 3580: l_acct := CSTPACHK.get_account_id(l_to_org, i_txn_id, -1, 12,

3576: if (i_trp_cost <> 0) then
3577:
3578: l_value := i_trp_cost;
3579:
3580: l_acct := CSTPACHK.get_account_id(l_to_org, i_txn_id, -1, 12,
3581: NULL, NULL, l_subinv,0, l_snd_rcv,
3582: l_err_num, l_err_code, l_err_msg,NULL);
3583:
3584: if (l_err_num <> 0) then

Line 3704: l_acct := CSTPACHK.get_account_id(l_to_org, i_txn_id, sign(l_ppv), 6,

3700: and organization_id = l_std_org;
3701:
3702: if (l_ppv <> 0)
3703: then
3704: l_acct := CSTPACHK.get_account_id(l_to_org, i_txn_id, sign(l_ppv), 6,
3705: NULL, NULL, l_subinv,0, l_snd_rcv,
3706: l_err_num, l_err_code, l_err_msg,NULL);
3707:
3708: if (l_err_num <> 0) then

Line 3972: l_acct := CSTPACHK.get_account_id(l_to_org, i_txn_id, sign(l_ppv), 6,

3968: where transaction_id = i_txn_id
3969: and organization_id = l_std_org;
3970:
3971: if (l_ppv <> 0) then
3972: l_acct := CSTPACHK.get_account_id(l_to_org, i_txn_id, sign(l_ppv), 6,
3973: NULL, NULL, l_subinv,0, l_snd_rcv,
3974: l_err_num, l_err_code, l_err_msg,NULL);
3975:
3976: if (l_err_num <> 0) then

Line 4086: l_acct := CSTPACHK.get_account_id(l_to_org, i_txn_id, -1, 2,

4082: * If Intercompany invoicing is enabled, then the booking should be made against the *
4083: * Inventory AP Accrual account rather than the Inter-Org Payables Account *
4084: ************************************************************************************/
4085: IF nvl(l_io_invoicing, 2) = 1 AND i_src_type_id IN (7, 8) AND l_org_ou <> l_txf_org_ou THEN /* INVCONV Bug#5498133/5498041 ANTHIYAG 30-Aug-2006 */
4086: l_acct := CSTPACHK.get_account_id(l_to_org, i_txn_id, -1, 2,
4087: NULL, NULL, l_subinv,0, l_snd_rcv,
4088: l_err_num, l_err_code, l_err_msg,NULL);
4089:
4090: if (l_err_num <> 0) then

Line 4115: l_acct := CSTPACHK.get_account_id(l_to_org, i_txn_id, -1, 9,

4111:
4112: ELSE
4113: /* INVCONV Bug#5476815 ANTHIYAG 21-Aug-2006 End */
4114:
4115: l_acct := CSTPACHK.get_account_id(l_to_org, i_txn_id, -1, 9,
4116: NULL, NULL, l_subinv,0, l_snd_rcv,
4117: l_err_num, l_err_code, l_err_msg,NULL);
4118: if (l_err_num <> 0) then
4119: raise process_error;

Line 4154: l_acct := CSTPACHK.get_account_id(l_to_org, i_txn_id, -1, 12,

4150: if (l_to_org <> i_txn_org_id) then
4151: l_value := i_trp_cost * l_conv_rate;
4152: end if;
4153:
4154: l_acct := CSTPACHK.get_account_id(l_to_org, i_txn_id, -1, 12,
4155: NULL, NULL, l_subinv,0, l_snd_rcv,
4156: l_err_num, l_err_code, l_err_msg,NULL);
4157:
4158: if (l_err_num <> 0) then

Line 4546: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,

4542:
4543: if (l_cost <> 0) then -- 4706781 This applies to INV accounting only
4544:
4545: -- First post to inventory.
4546: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,
4547: sign(l_cost), 1,
4548: cost_element, NULL, NULL,
4549: 0, NULL, l_err_num, l_err_code,
4550: l_err_msg,i_cost_grp_id);

Line 4589: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,

4585: if (l_cost <> 0 OR l_var <> 0 OR l_onhand_var <> 0) then -- 4706781 Adj has to be posted if variance exists
4586:
4587: -- Second post to adjustment.
4588: l_cost := -1 * l_cost;
4589: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,
4590: sign((i_qty * l_cost) - l_var-l_onhand_var), 2,
4591: cost_element, NULL, NULL,
4592: 0, NULL, l_err_num, l_err_code,
4593: l_err_msg,i_cost_grp_id);

Line 4630: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,

4626:
4627: end if; -- (l_cost <> 0 and l_var <> 0)
4628: if (l_onhand_var <> 0) then
4629:
4630: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,
4631: sign(l_onhand_var), 20,
4632: cost_element, NULL, NULL,
4633: 0, NULL, l_err_num, l_err_code,
4634: l_err_msg,i_cost_grp_id);

Line 4677: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,

4673: and organization_id = i_org_id;
4674:
4675: if (l_var <> 0) then
4676:
4677: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,
4678: sign(l_var), 13,
4679: NULL, NULL, NULL,
4680: 0, NULL, l_err_num, l_err_code,
4681: l_err_msg,i_cost_grp_id);

Line 5679: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,

5675: fnd_file.put_line(fnd_file.log, 'org-txn-i_p_qty-cost_element-i_subinv');
5676: fnd_file.put_line(fnd_file.log, i_org_id || '-' || i_txn_id || '-' ||
5677: i_p_qty || '-' || i_subinv);
5678: end if;
5679: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,
5680: sign(i_p_qty), l_acct_line_type,
5681: cost_element, NULL, i_subinv,
5682: l_exp, i_snd_rcv,
5683: l_err_num, l_err_code, l_err_msg,i_cost_grp_id);

Line 5739: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,

5735:
5736:
5737: if (l_exp <> 1 and l_var <> 0) then /* Not expense */
5738: -- Insert into variance account.
5739: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,
5740: sign(i_p_qty), 13,
5741: NULL, NULL, i_subinv,
5742: 0, i_snd_rcv, l_err_num, l_err_code,
5743: l_err_msg,i_cost_grp_id);

Line 5803: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,

5799: and organization_id = i_org_id
5800: and layer_id = l_layer_id
5801: and cost_element_id = cost_element;
5802:
5803: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,
5804: sign(i_p_qty), 13,
5805: cost_element, NULL, i_subinv,
5806: 0, i_snd_rcv,
5807: l_err_num, l_err_code, l_err_msg,i_cost_grp_id);

Line 6057: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,

6053: if (l_elemental_cost(cost_element) is not null) then
6054:
6055: -- dropshipment changes
6056: if (l_cost_method <> 1) then
6057: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,
6058: sign(i_p_qty),
6059: i_acct_line_type,
6060: cost_element, NULL, i_subinv,
6061: 0, i_snd_rcv, l_err_num, l_err_code,

Line 6226: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,

6222:
6223: l_stmt_num := 60;
6224:
6225: if (l_cost_method <> 1) then
6226: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,
6227: sign(i_p_qty),
6228: i_acct_line_type,
6229: NULL, NULL, i_subinv,
6230: 0, i_snd_rcv, l_err_num, l_err_code,

Line 6383: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,

6379: and cost_element_id = cost_element;
6380: end if;
6381:
6382: if (l_cost is not null AND cost_element <> 2) then
6383: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,
6384: sign(i_p_qty),
6385: i_acct_line_type,
6386: cost_element, NULL, i_subinv,
6387: 0, i_snd_rcv, l_err_num, l_err_code,

Line 6491: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,

6487: loop
6488: fetch mat_ovhds into l_res_id, l_cost;
6489: exit when mat_ovhds%NOTFOUND;
6490:
6491: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,
6492: sign(i_p_qty), 3,
6493: 2, l_res_id, i_subinv,
6494: 0, i_snd_rcv, l_err_num, l_err_code,
6495: l_err_msg,NULL);

Line 6594: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,

6590: l_act_flag := 0; -- 0 means that encumbrance is being used
6591:
6592: l_stmt_num := 10;
6593:
6594: l_acct := CSTPACHK.get_account_id(i_org_id, i_txn_id,
6595: sign(i_enc_amount), l_acct_line_type,
6596: NULL, NULL, NULL,
6597: 0, NULL, l_err_num, l_err_code,
6598: l_err_msg,NULL);