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_PRJMFG_COST_COLLECTOR dependencies on FND_FILE

Line 304: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: pm_mark_non_project_world_txns');

300: l_stmt_num := 5;
301:
302: l_debug := FND_PROFILE.VALUE('MRP_DEBUG');
303: if (l_debug = 'Y') then
304: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: pm_mark_non_project_world_txns');
305: end if;
306:
307: -- The query is to mark all non-project world txns satisfying the
308: -- arguments provided, as processed.

Line 389: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: NP Count MMT is #: '||to_char(SQL%ROWCOUNT) );

385:
386: END IF;
387:
388: if (l_debug = 'Y') then
389: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: NP Count MMT is #: '||to_char(SQL%ROWCOUNT) );
390: end if;
391:
392: /* Changes for consigned inventory */
393: /* Mark all transactions not owned by the current org as cost collected */

Line 418: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Count of consigned txns in MMT - no cost collection - is #: '||to_char(SQL%ROWCOUNT) );

414: AND mmt.transaction_date <= ((trunc(sysdate) - p_prior_days) + 0.99999)
415: AND mmt.costed_flag is null;
416:
417: if (l_debug = 'Y') then
418: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Count of consigned txns in MMT - no cost collection - is #: '||to_char(SQL%ROWCOUNT) );
419: end if;
420:
421: l_stmt_num := 35;
422:

Line 467: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Count of logical txns or retroactive price updates in MMT - no cost collection - is #: '||to_char(SQL%ROWCOUNT) );

463: OR NVL(mmt.logical_trx_type_code,5) = 4
464: );
465:
466: if (l_debug = 'Y') then
467: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Count of logical txns or retroactive price updates in MMT - no cost collection - is #: '||to_char(SQL%ROWCOUNT) );
468: end if;
469:
470:
471: l_stmt_num := 40;

Line 540: FND_FILE.PUT_LINE(FND_FILE.LOG,'The count of the txn of assembly completion/assembly return with no MOH absorption in MTA - no applicable to be cost collected: '||to_char(SQL%ROWCOUNT) );

536: AND mmt.pm_cost_collected = 'N'
537: AND mmt.transaction_action_id in (31, 32);
538:
539: if (l_debug = 'Y') then
540: FND_FILE.PUT_LINE(FND_FILE.LOG,'The count of the txn of assembly completion/assembly return with no MOH absorption in MTA - no applicable to be cost collected: '||to_char(SQL%ROWCOUNT) );
541: end if;
542:
543: EXCEPTION
544: WHEN CST_FAILED_STD_CG_FLAG THEN

Line 659: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: assign_groups_to_mmt_txns');

655: l_stmt_num := 1;
656:
657: l_debug := FND_PROFILE.VALUE('MRP_DEBUG');
658: if (l_debug = 'Y') then
659: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: assign_groups_to_mmt_txns');
660: end if;
661:
662:
663: l_stmt_num := 10;

Line 830: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: pm_cc_worker_mmt ...');

826: l_error_explanation := '';
827:
828: l_debug := FND_PROFILE.VALUE('MRP_DEBUG');
829: if (l_debug = 'Y') then
830: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: pm_cc_worker_mmt ...');
831: end if;
832:
833: l_stmt_num := 10;
834:

Line 847: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Transfer between same project and task.' ||

843:
844: IF (l_count = 0)
845: THEN
846: if (l_debug = 'Y') then
847: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Transfer between same project and task.' ||
848: ' No need to collect cost');
849: end if;
850:
851: UPDATE mtl_material_transactions mmt

Line 870: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Processing transaction : '||to_char(p_transaction_id));

866: FOR cpmtv_rec IN sel_mmt_trx_to_cost(p_transaction_id,
867: p_Org_Id) LOOP
868:
869: if (l_debug = 'Y') then
870: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Processing transaction : '||to_char(p_transaction_id));
871: end if;
872:
873: savepoint pm_cc_worker_mmt;
874:

Line 1272: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: assign_groups_to_wt_txns ...');

1268: l_stmt_num := 1;
1269:
1270: l_debug := FND_PROFILE.VALUE('MRP_DEBUG');
1271: if (l_debug = 'Y') then
1272: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: assign_groups_to_wt_txns ...');
1273: end if;
1274:
1275: l_stmt_num := 10;
1276:

Line 1520: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: pm_cc_worker_wt');

1516: l_cross_bg_profile := pa_utils.IsCrossBGProfile_WNPS; /*Added or bug 8398299, using wrapping function to get profile value*/
1517:
1518: l_debug := FND_PROFILE.VALUE('MRP_DEBUG');
1519: if (l_debug = 'Y') then
1520: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: pm_cc_worker_wt');
1521: end if;
1522:
1523: l_stmt_num := 10;
1524:

Line 1528: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing transaction : '||to_char(p_transaction_id));

1524:
1525: FOR wt_rec IN sel_wt_trx_to_cost(p_transaction_id, p_Org_Id) LOOP
1526:
1527: if (l_debug = 'Y') then
1528: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing transaction : '||to_char(p_transaction_id));
1529: end if;
1530:
1531: savepoint pm_cc_worker_wt;
1532:

Line 1549: FND_FILE.put_line(FND_FILE.log, l_msg_data);

1545: p_txn_id => p_transaction_id,
1546: x_expenditure_type => l_expenditure_type
1547: );
1548: if (l_return_status <> fnd_api.g_ret_sts_success) then
1549: FND_FILE.put_line(FND_FILE.log, l_msg_data);
1550: l_api_message := 'get_ExpType_for_DirectItem returned unexpected error';
1551: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
1552: FND_MESSAGE.set_token('TEXT', l_api_message);
1553: FND_MSG_pub.add;

Line 2671: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: pm_process_txn_mmt ...');

2667:
2668:
2669: l_debug := FND_PROFILE.VALUE('MRP_DEBUG');
2670: if (l_debug = 'Y') then
2671: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: pm_process_txn_mmt ...');
2672: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Transaction ID: '||to_char(p_transaction_id));
2673: end if;
2674:
2675:

Line 2672: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Transaction ID: '||to_char(p_transaction_id));

2668:
2669: l_debug := FND_PROFILE.VALUE('MRP_DEBUG');
2670: if (l_debug = 'Y') then
2671: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: pm_process_txn_mmt ...');
2672: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Transaction ID: '||to_char(p_transaction_id));
2673: end if;
2674:
2675:
2676:

Line 3026: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Processing Project Miscellaneous Transactions ...');

3022:
3023: l_stmt_num := 125;
3024:
3025: if (l_debug = 'Y') then
3026: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Processing Project Miscellaneous Transactions ...');
3027: end if;
3028:
3029: FOR c_rec1 IN c_sel_std_misc LOOP
3030:

Line 3231: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Collecting MOH costs ...');

3227:
3228: l_stmt_num := 145;
3229:
3230: if (l_debug = 'Y') then
3231: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Collecting MOH costs ...');
3232: end if;
3233:
3234: FOR c_rec2 IN c_sel_moh_txn LOOP
3235:

Line 3353: FND_FILE.PUT_LINE(FND_FILE.LOG,'Collecting the MOH absorption on the receiving side');

3349: interorg transaction */
3350:
3351: If (l_earn_tomoh <> -99 AND p_transaction_id <> -99 ) then
3352:
3353: FND_FILE.PUT_LINE(FND_FILE.LOG,'Collecting the MOH absorption on the receiving side');
3354:
3355: l_rownum := 0;
3356:
3357: For c_rec9 in c_sel_tomoh LOOP

Line 3382: FND_FILE.PUT_LINE(FND_FILE.LOG,'Blue print org ' || l_org_id);

3378: where organization_id = l_org_id ;
3379:
3380: If l_blue_print_enabled_flag = 'Y' then
3381:
3382: FND_FILE.PUT_LINE(FND_FILE.LOG,'Blue print org ' || l_org_id);
3383: If l_autoaccounting_flag = 'Y' then
3384:
3385: /* BP and autoaccounting */
3386: Select pts1.transaction_source,

Line 3668: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Collecting Project related Locator txn costs ...');

3664: l_stmt_num := 160;
3665:
3666:
3667: if (l_debug = 'Y') then
3668: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Collecting Project related Locator txn costs ...');
3669: end if;
3670:
3671: FOR c_rec3 IN c_sel_prj_txn LOOP
3672:

Line 3732: fnd_file.put_line(fnd_file.log,'Burdened cost is zero');

3728: l_stmt_num := 170;
3729:
3730:
3731: If c_rec3.burdened_cost = 0 then
3732: fnd_file.put_line(fnd_file.log,'Burdened cost is zero');
3733: end if;
3734:
3735: If c_rec3.burdened_cost <> 0 then
3736:

Line 3898: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Collecting Transfer Side Locator Project costs ...');

3894:
3895: l_stmt_num := 175;
3896:
3897: if (l_debug = 'Y') then
3898: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Collecting Transfer Side Locator Project costs ...');
3899: end if;
3900:
3901: FOR c_rec4 IN c_sel_toprj_txn LOOP
3902:

Line 3987: fnd_file.put_line(fnd_file.log,'Burdened cost is zero');

3983:
3984: END IF; /* check for BP org */
3985:
3986: If c_rec4.burdened_cost = 0 then
3987: fnd_file.put_line(fnd_file.log,'Burdened cost is zero');
3988: end if;
3989:
3990: If c_rec4.burdened_cost <> 0 then
3991:

Line 4111: fnd_file.put_line(fnd_file.log, 'Receving Txn not yet costed!!!!');

4107: p_organization_id);
4108:
4109: IF (l_costed_flag = 'N') THEN
4110: if (l_debug = 'Y') then
4111: fnd_file.put_line(fnd_file.log, 'Receving Txn not yet costed!!!!');
4112: end if;
4113: RAISE ROW_NOT_COSTED;
4114: ELSE
4115:

Line 4176: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Collecting source side project costs ...');

4172:
4173: l_stmt_num := 185;
4174:
4175: if (l_debug = 'Y') then
4176: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Collecting source side project costs ...');
4177: end if;
4178:
4179: FOR c_rec5 IN c_sel_src_txn LOOP
4180:

Line 4342: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Collecting Borrow Payback transactions ...');

4338: l_rownum := 0;
4339: l_stmt_num := 200;
4340:
4341: if (l_debug = 'Y') then
4342: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Collecting Borrow Payback transactions ...');
4343: end if;
4344:
4345: FOR c_rec6 IN c_sel_bp_txn LOOP
4346:

Line 4616: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Collecting purchase price variances ...');

4612:
4613: l_rownum := 0;
4614:
4615: if (l_debug = 'Y') then
4616: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Collecting purchase price variances ...');
4617: FND_FILE.PUT_LINE(FND_FILE.LOG,'ppv_txfr_flag : '||ppv_txfr_flag||
4618: 'p_primary_cost_method : '||p_primary_cost_method||
4619: 'l_primary_cost_method_snd : '||l_primary_cost_method_snd||
4620: ' p_organization_id : '||p_organization_id||

Line 4617: FND_FILE.PUT_LINE(FND_FILE.LOG,'ppv_txfr_flag : '||ppv_txfr_flag||

4613: l_rownum := 0;
4614:
4615: if (l_debug = 'Y') then
4616: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Collecting purchase price variances ...');
4617: FND_FILE.PUT_LINE(FND_FILE.LOG,'ppv_txfr_flag : '||ppv_txfr_flag||
4618: 'p_primary_cost_method : '||p_primary_cost_method||
4619: 'l_primary_cost_method_snd : '||l_primary_cost_method_snd||
4620: ' p_organization_id : '||p_organization_id||
4621: ' p_transaction_id : '||p_transaction_id||

Line 5058: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: pm_check_error_mmt');

5054: l_stmt_num := 1;
5055:
5056: l_debug := FND_PROFILE.VALUE('MRP_DEBUG');
5057: if (l_debug = 'Y') then
5058: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: pm_check_error_mmt');
5059: end if;
5060:
5061: IF(p_transaction_source_type_id = 5 AND p_source_project_id IS NOT NULL) THEN
5062: l_proj_job_ind := 1;

Line 5491: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: pm_mark_error_mmt');

5487:
5488:
5489: l_debug := FND_PROFILE.VALUE('MRP_DEBUG');
5490: if (l_debug = 'Y') then
5491: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: pm_mark_error_mmt');
5492: end if;
5493:
5494: l_stmt_num := 10;
5495:

Line 5719: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: pm_process_txn_wt');

5715: l_stmt_num := 1;
5716:
5717: l_debug := FND_PROFILE.VALUE('MRP_DEBUG');
5718: if (l_debug = 'Y') then
5719: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: pm_process_txn_wt');
5720: end if;
5721:
5722: -- Initialize the batch name as CC followed by group_id
5723:

Line 5866: fnd_file.put_line(fnd_file.log,'Setting Straight time');

5862: * resource cost element. If there is a resource based overhead, it
5863: * should be passed with a transaction source of WIP. */
5864: If c_rec.employee_number is NOT NULL and p_cost_element_id <> 5 then
5865:
5866: fnd_file.put_line(fnd_file.log,'Setting Straight time');
5867: fnd_file.put_line(fnd_file.log,p_wip_straight_time_literal);
5868: l_transaction_source := p_wip_straight_time_literal ;
5869:
5870: /* set the sys linkage to the system linkage to which this transaction source maps to

Line 5867: fnd_file.put_line(fnd_file.log,p_wip_straight_time_literal);

5863: * should be passed with a transaction source of WIP. */
5864: If c_rec.employee_number is NOT NULL and p_cost_element_id <> 5 then
5865:
5866: fnd_file.put_line(fnd_file.log,'Setting Straight time');
5867: fnd_file.put_line(fnd_file.log,p_wip_straight_time_literal);
5868: l_transaction_source := p_wip_straight_time_literal ;
5869:
5870: /* set the sys linkage to the system linkage to which this transaction source maps to
5871: (usually this transaction source should map to the straight time system linkage) */

Line 5915: fnd_file.put_line(fnd_file.log,' Deriving Currency Conversion Information ');

5911: where transaction_id = p_transaction_id ;
5912:
5913: l_stmt_num := 62;
5914: If l_debug = 'Y' then
5915: fnd_file.put_line(fnd_file.log,' Deriving Currency Conversion Information ');
5916: end If;
5917: /*Bug 9656218
5918: Get the currency information */
5919: BEGIN

Line 5942: fnd_file.put_line(fnd_file.log,' Not a foreign currency transaction ');

5938: l_cc_foreign_currency := null;
5939: END;
5940: If l_debug = 'Y' then
5941: IF l_cc_rate IS NULL then
5942: fnd_file.put_line(fnd_file.log,' Not a foreign currency transaction ');
5943: ELSE
5944: fnd_file.put_line(fnd_file.log,' Currency Conversion Rate : '||to_char(l_cc_rate));
5945: fnd_file.put_line(fnd_file.log,' Currency Conversion Type : '||l_cc_type);
5946: fnd_file.put_line(fnd_file.log,' Currency Conversion Date : '||to_char(l_cc_date));

Line 5944: fnd_file.put_line(fnd_file.log,' Currency Conversion Rate : '||to_char(l_cc_rate));

5940: If l_debug = 'Y' then
5941: IF l_cc_rate IS NULL then
5942: fnd_file.put_line(fnd_file.log,' Not a foreign currency transaction ');
5943: ELSE
5944: fnd_file.put_line(fnd_file.log,' Currency Conversion Rate : '||to_char(l_cc_rate));
5945: fnd_file.put_line(fnd_file.log,' Currency Conversion Type : '||l_cc_type);
5946: fnd_file.put_line(fnd_file.log,' Currency Conversion Date : '||to_char(l_cc_date));
5947: fnd_file.put_line(fnd_file.log,' Foreign Currency : '||l_cc_foreign_currency);
5948: END IF;

Line 5945: fnd_file.put_line(fnd_file.log,' Currency Conversion Type : '||l_cc_type);

5941: IF l_cc_rate IS NULL then
5942: fnd_file.put_line(fnd_file.log,' Not a foreign currency transaction ');
5943: ELSE
5944: fnd_file.put_line(fnd_file.log,' Currency Conversion Rate : '||to_char(l_cc_rate));
5945: fnd_file.put_line(fnd_file.log,' Currency Conversion Type : '||l_cc_type);
5946: fnd_file.put_line(fnd_file.log,' Currency Conversion Date : '||to_char(l_cc_date));
5947: fnd_file.put_line(fnd_file.log,' Foreign Currency : '||l_cc_foreign_currency);
5948: END IF;
5949: fnd_file.put_line(fnd_file.log,' UOM code for the WIP txn : ' || l_uom_code);

Line 5946: fnd_file.put_line(fnd_file.log,' Currency Conversion Date : '||to_char(l_cc_date));

5942: fnd_file.put_line(fnd_file.log,' Not a foreign currency transaction ');
5943: ELSE
5944: fnd_file.put_line(fnd_file.log,' Currency Conversion Rate : '||to_char(l_cc_rate));
5945: fnd_file.put_line(fnd_file.log,' Currency Conversion Type : '||l_cc_type);
5946: fnd_file.put_line(fnd_file.log,' Currency Conversion Date : '||to_char(l_cc_date));
5947: fnd_file.put_line(fnd_file.log,' Foreign Currency : '||l_cc_foreign_currency);
5948: END IF;
5949: fnd_file.put_line(fnd_file.log,' UOM code for the WIP txn : ' || l_uom_code);
5950: fnd_file.put_line(fnd_file.log,' Quantity : ' || c_rec.quantity);

Line 5947: fnd_file.put_line(fnd_file.log,' Foreign Currency : '||l_cc_foreign_currency);

5943: ELSE
5944: fnd_file.put_line(fnd_file.log,' Currency Conversion Rate : '||to_char(l_cc_rate));
5945: fnd_file.put_line(fnd_file.log,' Currency Conversion Type : '||l_cc_type);
5946: fnd_file.put_line(fnd_file.log,' Currency Conversion Date : '||to_char(l_cc_date));
5947: fnd_file.put_line(fnd_file.log,' Foreign Currency : '||l_cc_foreign_currency);
5948: END IF;
5949: fnd_file.put_line(fnd_file.log,' UOM code for the WIP txn : ' || l_uom_code);
5950: fnd_file.put_line(fnd_file.log,' Quantity : ' || c_rec.quantity);
5951: fnd_file.put_line(fnd_file.log,' Raw Cost Rate : ' || l_raw_cost_rate);

Line 5949: fnd_file.put_line(fnd_file.log,' UOM code for the WIP txn : ' || l_uom_code);

5945: fnd_file.put_line(fnd_file.log,' Currency Conversion Type : '||l_cc_type);
5946: fnd_file.put_line(fnd_file.log,' Currency Conversion Date : '||to_char(l_cc_date));
5947: fnd_file.put_line(fnd_file.log,' Foreign Currency : '||l_cc_foreign_currency);
5948: END IF;
5949: fnd_file.put_line(fnd_file.log,' UOM code for the WIP txn : ' || l_uom_code);
5950: fnd_file.put_line(fnd_file.log,' Quantity : ' || c_rec.quantity);
5951: fnd_file.put_line(fnd_file.log,' Raw Cost Rate : ' || l_raw_cost_rate);
5952: end If;
5953:

Line 5950: fnd_file.put_line(fnd_file.log,' Quantity : ' || c_rec.quantity);

5946: fnd_file.put_line(fnd_file.log,' Currency Conversion Date : '||to_char(l_cc_date));
5947: fnd_file.put_line(fnd_file.log,' Foreign Currency : '||l_cc_foreign_currency);
5948: END IF;
5949: fnd_file.put_line(fnd_file.log,' UOM code for the WIP txn : ' || l_uom_code);
5950: fnd_file.put_line(fnd_file.log,' Quantity : ' || c_rec.quantity);
5951: fnd_file.put_line(fnd_file.log,' Raw Cost Rate : ' || l_raw_cost_rate);
5952: end If;
5953:
5954: l_stmt_num := 63; /*BUG 10623781: Added derivation of User Conversion type to pass to PA interface*/

Line 5951: fnd_file.put_line(fnd_file.log,' Raw Cost Rate : ' || l_raw_cost_rate);

5947: fnd_file.put_line(fnd_file.log,' Foreign Currency : '||l_cc_foreign_currency);
5948: END IF;
5949: fnd_file.put_line(fnd_file.log,' UOM code for the WIP txn : ' || l_uom_code);
5950: fnd_file.put_line(fnd_file.log,' Quantity : ' || c_rec.quantity);
5951: fnd_file.put_line(fnd_file.log,' Raw Cost Rate : ' || l_raw_cost_rate);
5952: end If;
5953:
5954: l_stmt_num := 63; /*BUG 10623781: Added derivation of User Conversion type to pass to PA interface*/
5955: IF l_cc_type is NULL THEN

Line 5966: fnd_file.put_line(fnd_file.log,'User Currency Conversion Type : '||l_user_cc_type);

5962: END IF;
5963:
5964: If l_debug = 'Y' then
5965: IF l_user_cc_type is NOT NULL then
5966: fnd_file.put_line(fnd_file.log,'User Currency Conversion Type : '||l_user_cc_type);
5967: END IF;
5968: end If;
5969:
5970:

Line 6196: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: pm_check_error_wt');

6192: l_organization_name := '';
6193:
6194: l_debug := FND_PROFILE.VALUE('MRP_DEBUG');
6195: if (l_debug = 'Y') then
6196: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: pm_check_error_wt');
6197: end if;
6198:
6199: p_process_yn := 1; /* 1 Implies Process the Txn */
6200: --

Line 6443: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: pm_mark_error_wt ' );

6439: l_stmt_num := 1;
6440:
6441: l_debug := FND_PROFILE.VALUE('MRP_DEBUG');
6442: if (l_debug = 'Y') then
6443: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: pm_mark_error_wt ' );
6444: end if;
6445:
6446:
6447: l_stmt_num := 10;

Line 6610: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: pm_get_mta_accts');

6606: l_wip_txn_source_type := '';
6607:
6608: l_debug := FND_PROFILE.VALUE('MRP_DEBUG');
6609: if (l_debug = 'Y') then
6610: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#: pm_get_mta_accts');
6611: end if;
6612:
6613: BEGIN
6614: /****** Get Transaction Information ******/

Line 6892: FND_FILE.PUT_LINE (FND_FILE.LOG,

6888:
6889: END IF;
6890:
6891: if (l_debug = 'Y') then
6892: FND_FILE.PUT_LINE (FND_FILE.LOG,
6893: 'DEBIT DATA. Txn: '||to_char(l_mta_transaction_id)
6894: ||' Exp_Flag: '||to_char(l_exp_flag)
6895: ||' Xfer_Exp_Flag: '
6896: ||to_char(l_xfer_exp_flag)

Line 6970: fnd_file.put_line(fnd_file.log,' Deriving Currency Conversion Information ');

6966: /* currency information back */
6967:
6968: l_stmt_num := 52;
6969: If l_debug = 'Y' then
6970: fnd_file.put_line(fnd_file.log,' Deriving Currency Conversion Information ');
6971: end If;
6972: BEGIN
6973: select COALESCE(mta.currency_conversion_rate, mta.base_transaction_value/mta.transaction_value),
6974: mta.currency_conversion_type,

Line 7003: fnd_file.put_line(fnd_file.log,' Not a foreign currency transaction ');

6999: where organization_id = l_mta_organization_id;
7000:
7001: If l_debug = 'Y' then
7002: IF l_cc_rate IS NULL then
7003: fnd_file.put_line(fnd_file.log,' Not a foreign currency transaction ');
7004: ELSE
7005: fnd_file.put_line(fnd_file.log,' Currency Conversion Rate : '||to_char(l_cc_rate));
7006: fnd_file.put_line(fnd_file.log,' Currency Conversion Type : '||l_cc_type);
7007: fnd_file.put_line(fnd_file.log,' Currency Conversion Date : '||to_char(l_cc_date));

Line 7005: fnd_file.put_line(fnd_file.log,' Currency Conversion Rate : '||to_char(l_cc_rate));

7001: If l_debug = 'Y' then
7002: IF l_cc_rate IS NULL then
7003: fnd_file.put_line(fnd_file.log,' Not a foreign currency transaction ');
7004: ELSE
7005: fnd_file.put_line(fnd_file.log,' Currency Conversion Rate : '||to_char(l_cc_rate));
7006: fnd_file.put_line(fnd_file.log,' Currency Conversion Type : '||l_cc_type);
7007: fnd_file.put_line(fnd_file.log,' Currency Conversion Date : '||to_char(l_cc_date));
7008: fnd_file.put_line(fnd_file.log,' Foreign Currency : '||l_cc_foreign_currency);
7009: END IF;

Line 7006: fnd_file.put_line(fnd_file.log,' Currency Conversion Type : '||l_cc_type);

7002: IF l_cc_rate IS NULL then
7003: fnd_file.put_line(fnd_file.log,' Not a foreign currency transaction ');
7004: ELSE
7005: fnd_file.put_line(fnd_file.log,' Currency Conversion Rate : '||to_char(l_cc_rate));
7006: fnd_file.put_line(fnd_file.log,' Currency Conversion Type : '||l_cc_type);
7007: fnd_file.put_line(fnd_file.log,' Currency Conversion Date : '||to_char(l_cc_date));
7008: fnd_file.put_line(fnd_file.log,' Foreign Currency : '||l_cc_foreign_currency);
7009: END IF;
7010: fnd_file.put_line(fnd_file.log,' Functional Currency : '||l_cc_functional_currency);

Line 7007: fnd_file.put_line(fnd_file.log,' Currency Conversion Date : '||to_char(l_cc_date));

7003: fnd_file.put_line(fnd_file.log,' Not a foreign currency transaction ');
7004: ELSE
7005: fnd_file.put_line(fnd_file.log,' Currency Conversion Rate : '||to_char(l_cc_rate));
7006: fnd_file.put_line(fnd_file.log,' Currency Conversion Type : '||l_cc_type);
7007: fnd_file.put_line(fnd_file.log,' Currency Conversion Date : '||to_char(l_cc_date));
7008: fnd_file.put_line(fnd_file.log,' Foreign Currency : '||l_cc_foreign_currency);
7009: END IF;
7010: fnd_file.put_line(fnd_file.log,' Functional Currency : '||l_cc_functional_currency);
7011: end If;

Line 7008: fnd_file.put_line(fnd_file.log,' Foreign Currency : '||l_cc_foreign_currency);

7004: ELSE
7005: fnd_file.put_line(fnd_file.log,' Currency Conversion Rate : '||to_char(l_cc_rate));
7006: fnd_file.put_line(fnd_file.log,' Currency Conversion Type : '||l_cc_type);
7007: fnd_file.put_line(fnd_file.log,' Currency Conversion Date : '||to_char(l_cc_date));
7008: fnd_file.put_line(fnd_file.log,' Foreign Currency : '||l_cc_foreign_currency);
7009: END IF;
7010: fnd_file.put_line(fnd_file.log,' Functional Currency : '||l_cc_functional_currency);
7011: end If;
7012:

Line 7010: fnd_file.put_line(fnd_file.log,' Functional Currency : '||l_cc_functional_currency);

7006: fnd_file.put_line(fnd_file.log,' Currency Conversion Type : '||l_cc_type);
7007: fnd_file.put_line(fnd_file.log,' Currency Conversion Date : '||to_char(l_cc_date));
7008: fnd_file.put_line(fnd_file.log,' Foreign Currency : '||l_cc_foreign_currency);
7009: END IF;
7010: fnd_file.put_line(fnd_file.log,' Functional Currency : '||l_cc_functional_currency);
7011: end If;
7012:
7013: l_stmt_num := 54; /*BUG 10623781: Added derivation of User Conversion type to pass to PA interface*/
7014: IF l_cc_type is NULL THEN

Line 7025: fnd_file.put_line(fnd_file.log,'User Currency Conversion Type : '||l_user_cc_type);

7021: END IF;
7022:
7023: If l_debug = 'Y' then
7024: IF l_user_cc_type is NOT NULL then
7025: fnd_file.put_line(fnd_file.log,'User Currency Conversion Type : '||l_user_cc_type);
7026: END IF;
7027: end If;
7028:
7029: O_cc_rate := l_cc_rate;

Line 7194: FND_FILE.put_line(fnd_file.log, 'CREDIT DATA: ');

7190: END IF; /*MAIN IF */
7191:
7192: IF (l_citw_flag <> 1) THEN
7193: IF l_debug = 'Y' THEN
7194: FND_FILE.put_line(fnd_file.log, 'CREDIT DATA: ');
7195: FND_FILE.put_line(fnd_file.log, 'Cost Element: '||to_char(l_cost_element_id) || ' Accounting Line Type: '||to_char(l_accounting_line_type)||' Primary Quantity: '||to_char(l_mta_primary_quantity));
7196: END IF;
7197: -- Bug 936641, for borrow payback variance, should NOT
7198: -- store both Cr and Dr with the same accounting information

Line 7195: FND_FILE.put_line(fnd_file.log, 'Cost Element: '||to_char(l_cost_element_id) || ' Accounting Line Type: '||to_char(l_accounting_line_type)||' Primary Quantity: '||to_char(l_mta_primary_quantity));

7191:
7192: IF (l_citw_flag <> 1) THEN
7193: IF l_debug = 'Y' THEN
7194: FND_FILE.put_line(fnd_file.log, 'CREDIT DATA: ');
7195: FND_FILE.put_line(fnd_file.log, 'Cost Element: '||to_char(l_cost_element_id) || ' Accounting Line Type: '||to_char(l_accounting_line_type)||' Primary Quantity: '||to_char(l_mta_primary_quantity));
7196: END IF;
7197: -- Bug 936641, for borrow payback variance, should NOT
7198: -- store both Cr and Dr with the same accounting information
7199: -- The line 'O_cr_code_combination_id := O_dr_code_combination_id;'

Line 7271: FND_FILE.put_line(FND_FILE.log, 'Credit Account not found. It will be set the same as Debit account');

7267: O_cr_code_combination_id := O_dr_code_combination_id;
7268: O_inv_cr_sub_ledger_id := O_inv_dr_sub_ledger_id;
7269:
7270: IF l_debug = 'Y' THEN
7271: FND_FILE.put_line(FND_FILE.log, 'Credit Account not found. It will be set the same as Debit account');
7272: END IF;
7273:
7274: END IF;
7275:

Line 7495: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#:pm_insert_pti_pvt');

7491: l_business_group_name := NULL;
7492:
7493: l_debug := FND_PROFILE.VALUE('MRP_DEBUG');
7494: if (l_debug = 'Y') then
7495: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#:pm_insert_pti_pvt');
7496: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Transaction_id :'||to_char(p_transaction_id));
7497: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: HR:Cross Business Profile = '||l_cross_bg_profile);
7498: end if;
7499:

Line 7496: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Transaction_id :'||to_char(p_transaction_id));

7492:
7493: l_debug := FND_PROFILE.VALUE('MRP_DEBUG');
7494: if (l_debug = 'Y') then
7495: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#:pm_insert_pti_pvt');
7496: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Transaction_id :'||to_char(p_transaction_id));
7497: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: HR:Cross Business Profile = '||l_cross_bg_profile);
7498: end if;
7499:
7500: l_stmt_num := 10;

Line 7497: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: HR:Cross Business Profile = '||l_cross_bg_profile);

7493: l_debug := FND_PROFILE.VALUE('MRP_DEBUG');
7494: if (l_debug = 'Y') then
7495: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Reached#:pm_insert_pti_pvt');
7496: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Transaction_id :'||to_char(p_transaction_id));
7497: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: HR:Cross Business Profile = '||l_cross_bg_profile);
7498: end if;
7499:
7500: l_stmt_num := 10;
7501:

Line 7671: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: CSE hook usage flag :'||to_char(l_cse_hook_used));

7667: O_err_msg => l_cse_err_msg);
7668:
7669: l_stmt_num := 40;
7670:
7671: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: CSE hook usage flag :'||to_char(l_cse_hook_used));
7672: IF (l_err_num <> 0) THEN
7673:
7674: RAISE CST_FAILED_CSE_CALL;
7675:

Line 7748: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: INV hook usage flag :'||to_char(l_hook_used));

7744: l_hook_used ,
7745: l_err_num ,
7746: l_err_code ,
7747: l_err_msg);
7748: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: INV hook usage flag :'||to_char(l_hook_used));
7749:
7750: IF (l_err_num <> 0) THEN
7751:
7752: RAISE CST_FAILED_CST_CC_HOOK;

Line 7804: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Inserting transaction into PTI ');

7800:
7801: IF (l_hook_used = 0 ) THEN
7802:
7803: if (l_debug = 'Y') then
7804: FND_FILE.PUT_LINE(FND_FILE.LOG,'DEBUG: Inserting transaction into PTI ');
7805: end if;
7806:
7807:
7808: /* The following insert statement into pa_transaction_interface will be changed to insert into pa_transaction_interface_all */

Line 7823: fnd_file.put_line(fnd_file.log,'UOM code for the INV txn : ' || l_uom_code);

7819: where msi.inventory_item_id = p_inventory_item_id
7820: AND msi.organization_id = p_organization_id;
7821:
7822: If l_debug = 'Y' then
7823: fnd_file.put_line(fnd_file.log,'UOM code for the INV txn : ' || l_uom_code);
7824: end If;
7825:
7826:
7827: /*++++++++++++++++++++++++++++++++++++++++++++++++++++++