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.CSI_ML_INTERFACE_TXN_PVT dependencies on FND_FILE

Line 98: FND_File.Put_Line(Fnd_File.LOG,'relationship exists: '||t_rel_rec.relationship_id);

94: IF rel_cur%FOUND
95: THEN x_exists := TRUE;
96: x_relation_rec.relationship_id := t_rel_rec.relationship_id;
97: IF(l_debug_level>1) THEN
98: FND_File.Put_Line(Fnd_File.LOG,'relationship exists: '||t_rel_rec.relationship_id);
99: END IF;
100: x_relation_rec.relationship_type_code := t_rel_rec.relationship_type_code;
101: x_relation_rec.active_start_date:= t_rel_rec.active_start_date;
102: x_relation_rec.active_end_date:= t_rel_rec.active_end_date;

Line 426: FND_File.Put_Line(Fnd_File.LOG,'Process_iface_txns-P_Source_System_Name : '||p_source_system_name);

422: l_fnd_g_false := FND_API.G_FALSE; --bug#13072088
423:
424: IF(l_debug_level>1) THEN
425:
426: FND_File.Put_Line(Fnd_File.LOG,'Process_iface_txns-P_Source_System_Name : '||p_source_system_name);
427: FND_File.Put_Line(Fnd_File.LOG,'Process_iface_txns-P_Batch_Name : '||p_batch_name);
428: END IF;
429:
430: --bug#13072088

Line 427: FND_File.Put_Line(Fnd_File.LOG,'Process_iface_txns-P_Batch_Name : '||p_batch_name);

423:
424: IF(l_debug_level>1) THEN
425:
426: FND_File.Put_Line(Fnd_File.LOG,'Process_iface_txns-P_Source_System_Name : '||p_source_system_name);
427: FND_File.Put_Line(Fnd_File.LOG,'Process_iface_txns-P_Batch_Name : '||p_batch_name);
428: END IF;
429:
430: --bug#13072088
431: IF(l_debug_level>1) THEN

Line 432: FND_File.Put_Line(Fnd_File.LOG,'Call to contract profile value : '||l_enable_contracts_oi);

428: END IF;
429:
430: --bug#13072088
431: IF(l_debug_level>1) THEN
432: FND_File.Put_Line(Fnd_File.LOG,'Call to contract profile value : '||l_enable_contracts_oi);
433: END IF;
434: --bug#13072088
435:
436: OPEN internal_party_cur;

Line 466: FND_File.Put_Line(Fnd_File.LOG, l_error_message||' Total Rows in this error : '||SQL%ROWCOUNT );

462: AND cii.process_status = 'R'
463: AND cii.location_type_code in ('INVENTORY','PO','IN_TRANSIT','WIP','PROJECT');
464:
465: IF SQL%FOUND THEN
466: FND_File.Put_Line(Fnd_File.LOG, l_error_message||' Total Rows in this error : '||SQL%ROWCOUNT );
467: END IF;
468:
469: END;
470:

Line 474: FND_File.Put_Line(Fnd_File.LOG,'Resolving the Ids based on user values ');

470:
471: IF NVL(p_resolve_ids,'Y') = 'Y'
472: THEN
473: IF(l_debug_level>1) THEN
474: FND_File.Put_Line(Fnd_File.LOG,'Resolving the Ids based on user values ');
475: END IF;
476: CSI_ML_UTIL_PVT.resolve_ids(p_txn_from_date,
477: p_txn_to_date,
478: p_batch_name,

Line 485: FND_File.Put_Line(Fnd_File.LOG,'Error Resolving the Ids: ');

481: l_error_message);
482:
483: IF NOT l_return_status = l_fnd_success THEN
484: IF(l_debug_level>1) THEN
485: FND_File.Put_Line(Fnd_File.LOG,'Error Resolving the Ids: ');
486: END IF;
487: RAISE g_exc_error;
488: END IF;
489: END IF;

Line 515: FND_File.Put_Line(Fnd_File.LOG, l_error_message||' Total Rows in this error : '||SQL%ROWCOUNT );

511: );
512:
513: IF SQL%FOUND THEN
514: IF(l_debug_level>1) THEN
515: FND_File.Put_Line(Fnd_File.LOG, l_error_message||' Total Rows in this error : '||SQL%ROWCOUNT );
516: END IF;
517: END IF;
518:
519:

Line 539: FND_File.Put_Line(Fnd_File.LOG, l_error_message ||' Total Rows in this error : '||SQL%ROWCOUNT);

535: AND ciai.fa_asset_number IS NULL
536: );
537:
538: IF SQL%FOUND THEN
539: FND_File.Put_Line(Fnd_File.LOG, l_error_message ||' Total Rows in this error : '||SQL%ROWCOUNT);
540: END IF;
541:
542:
543: /* Commented for bug 9924463

Line 570: FND_File.Put_Line(Fnd_File.LOG, l_error_message ||' Total Rows in this error : '||SQL%ROWCOUNT);

566: WHERE cii.inst_interface_id = ciai.inst_interface_id
567: ));
568:
569: IF SQL%FOUND THEN
570: FND_File.Put_Line(Fnd_File.LOG, l_error_message ||' Total Rows in this error : '||SQL%ROWCOUNT);
571: END IF;
572: */ --Commented for bug 9924463
573: END;
574: l_txn_count := 0;

Line 580: FND_File.Put_Line(Fnd_File.LOG,'Started Processing the Transaction Identifier : '||get_txns_rec.transaction_identifier);

576: p_batch_name)
577: LOOP
578: l_txn_count := l_txn_count +1;
579: IF(l_debug_level>1) THEN
580: FND_File.Put_Line(Fnd_File.LOG,'Started Processing the Transaction Identifier : '||get_txns_rec.transaction_identifier);
581: END IF;
582: c_instance_tbl.DELETE;
583: c_ext_attrib_tbl.DELETE;
584: c_party_tbl.DELETE;

Line 621: FND_File.Put_Line(Fnd_File.LOG,'Processing Inst_interface_id : '||iface_det_rec.inst_interface_id);

617: FOR iface_det_rec IN iface_det_cur(get_txns_rec.transaction_identifier,
618: p_source_system_name)
619: LOOP
620: IF(l_debug_level>1) THEN
621: FND_File.Put_Line(Fnd_File.LOG,'Processing Inst_interface_id : '||iface_det_rec.inst_interface_id);
622: END IF;
623: --to find out whether the instance exists
624: instance_exists(iface_det_rec.inst_interface_id,
625: l_instance_id,

Line 632: FND_File.Put_Line(Fnd_File.LOG,'Create New Instance CASE:');

628: IF NOT l_return_status = l_fnd_success
629: THEN -- create item instance
630:
631: IF(l_debug_level>1) THEN
632: FND_File.Put_Line(Fnd_File.LOG,'Create New Instance CASE:');
633: END IF;
634: x_return_status := l_fnd_success;
635:
636: c_instance_tbl(inst_idx).INSTANCE_ID := NULL;

Line 2770: FND_File.Put_Line(Fnd_File.LOG,'CASE -update item instance id: '||l_instance_id);

2766:
2767: inst_idx := inst_idx + 1;
2768: ELSE -- update candidate
2769: IF(l_debug_level>1) THEN
2770: FND_File.Put_Line(Fnd_File.LOG,'CASE -update item instance id: '||l_instance_id);
2771: END IF;
2772: --u_instance_tbl(inst_idx).instance_id := l_instance_id;
2773: u_instance_tbl(u_inst_idx).instance_id := l_instance_id; --Added for open
2774: -- call resolve_update_ids

Line 2801: FND_File.Put_Line(Fnd_File.LOG,'Resolving Update Related Ids:');

2797:
2798: IF u_instance_tbl.COUNT >0
2799: THEN
2800: IF(l_debug_level>1) THEN
2801: FND_File.Put_Line(Fnd_File.LOG,'Resolving Update Related Ids:');
2802: END IF;
2803: csi_ml_util_pvt.resolve_update_ids
2804: (p_source_system_name => p_source_system_name,
2805: p_txn_identifier => get_txns_rec.transaction_identifier,

Line 2811: FND_File.Put_Line(Fnd_File.LOG,'Error from csi_ml_util_pvt.resolve_update_ids');

2807: x_error_message => l_error_message);
2808: IF NOT l_return_status = l_fnd_success
2809: THEN
2810: IF(l_debug_level>1) THEN
2811: FND_File.Put_Line(Fnd_File.LOG,'Error from csi_ml_util_pvt.resolve_update_ids');
2812: END IF;
2813: SAVEPOINT s_txnmiddle;
2814: RAISE g_exc_error;
2815: END IF;

Line 2834: FND_File.Put_Line(Fnd_File.LOG,'Error from csi_ml_update_pvt.populate_recs ');

2830:
2831: IF NOT l_return_status = l_fnd_success
2832: THEN
2833: IF(l_debug_level>1) THEN
2834: FND_File.Put_Line(Fnd_File.LOG,'Error from csi_ml_update_pvt.populate_recs ');
2835: END IF;
2836: SAVEPOINT s_txnmiddle;
2837: RAISE g_exc_error;
2838: END IF;

Line 2911: FND_File.Put_Line(Fnd_File.LOG,'Instance Crearted with number : '||c_instance_tbl(i).instance_id);

2907: FOR i IN 1 .. c_instance_tbl.COUNT LOOP
2908: IF c_instance_tbl(i).instance_id IS NOT NULL
2909: THEN
2910: IF(l_debug_level>1) THEN
2911: FND_File.Put_Line(Fnd_File.LOG,'Instance Crearted with number : '||c_instance_tbl(i).instance_id);
2912: END IF;
2913: END IF;
2914: END LOOP;
2915: END IF;

Line 3119: FND_File.Put_Line(Fnd_File.LOG,'creating relationships :');

3115: END LOOP;
3116:
3117: IF c_relationship_tbl.COUNT>0
3118: THEN
3119: FND_File.Put_Line(Fnd_File.LOG,'creating relationships :');
3120: csi_ii_relationships_pub.create_relationship(
3121: p_api_version => l_api_version
3122: ,p_commit => l_commit
3123: ,p_init_msg_list => l_init_msg_list

Line 3147: FND_File.Put_Line(Fnd_File.LOG,'updating relationships :');

3143:
3144: IF u_relationship_tbl.COUNT>0
3145: THEN
3146:
3147: FND_File.Put_Line(Fnd_File.LOG,'updating relationships :');
3148: csi_ii_relationships_pub.update_relationship(
3149: p_api_version => l_api_version
3150: ,p_commit => l_commit
3151: ,p_init_msg_list => l_init_msg_list

Line 3189: FND_File.Put_Line(Fnd_File.LOG,'error:'||l_error_message);

3185: u_grp_error_tbl);
3186: l_failure_count := l_failure_count +1;
3187:
3188: WHEN g_exc_error THEN
3189: FND_File.Put_Line(Fnd_File.LOG,'error:'||l_error_message);
3190:
3191: ROLLBACK TO s_txnmiddle;
3192: UPDATE csi_instance_interface
3193: SET process_Status = 'E',

Line 3204: FND_File.Put_Line(Fnd_File.LOG,'No of Transactions Processed :'||l_txn_count);

3200:
3201: l_return_status := fnd_api.g_ret_sts_success;
3202:
3203: IF(l_debug_level>1) THEN
3204: FND_File.Put_Line(Fnd_File.LOG,'No of Transactions Processed :'||l_txn_count);
3205: FND_File.Put_Line(Fnd_File.LOG,'No of successful Transactions :'||l_success_count);
3206: FND_File.Put_Line(Fnd_File.LOG,'No of failed Transactions :'||l_failure_count);
3207: END IF;
3208:

Line 3205: FND_File.Put_Line(Fnd_File.LOG,'No of successful Transactions :'||l_success_count);

3201: l_return_status := fnd_api.g_ret_sts_success;
3202:
3203: IF(l_debug_level>1) THEN
3204: FND_File.Put_Line(Fnd_File.LOG,'No of Transactions Processed :'||l_txn_count);
3205: FND_File.Put_Line(Fnd_File.LOG,'No of successful Transactions :'||l_success_count);
3206: FND_File.Put_Line(Fnd_File.LOG,'No of failed Transactions :'||l_failure_count);
3207: END IF;
3208:
3209: BEGIN

Line 3206: FND_File.Put_Line(Fnd_File.LOG,'No of failed Transactions :'||l_failure_count);

3202:
3203: IF(l_debug_level>1) THEN
3204: FND_File.Put_Line(Fnd_File.LOG,'No of Transactions Processed :'||l_txn_count);
3205: FND_File.Put_Line(Fnd_File.LOG,'No of successful Transactions :'||l_success_count);
3206: FND_File.Put_Line(Fnd_File.LOG,'No of failed Transactions :'||l_failure_count);
3207: END IF;
3208:
3209: BEGIN
3210: -- Added for releationships

Line 3228: FND_File.Put_Line(Fnd_File.LOG,'Start for creating rel in single thread :'||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));

3224: ,x_error_message => l_error_message
3225: );
3226: -- Need to check l_error_message
3227: IF(l_debug_level>1) THEN
3228: FND_File.Put_Line(Fnd_File.LOG,'Start for creating rel in single thread :'||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
3229: END IF;
3230: FOR irel_det_rec IN irel_det_cur
3231: LOOP
3232: check_rel_exists(irel_det_rec.subject_id,

Line 3260: FND_File.Put_Line(Fnd_File.LOG,'creating relationships :');

3256: c_rel_txn_rec.transaction_status_code := 'COMPLETE';
3257: c_rel_txn_rec.transaction_action_code := NULL;
3258: c_rel_txn_rec.object_version_number := 1;
3259: IF(l_debug_level>1) THEN
3260: FND_File.Put_Line(Fnd_File.LOG,'creating relationships :');
3261: END IF;
3262:
3263: csi_ii_relationships_pvt.create_relationship(
3264: p_api_version => l_api_version

Line 3400: FND_File.Put_Line(Fnd_File.LOG,'updating relationships :');

3396: u_rel_txn_rec.transaction_action_code := NULL;
3397: u_rel_txn_rec.object_version_number := 1;
3398:
3399: IF(l_debug_level>1) THEN
3400: FND_File.Put_Line(Fnd_File.LOG,'updating relationships :');
3401: END IF;
3402: csi_ii_relationships_pvt.update_relationship
3403: ( p_api_version => l_api_version
3404: ,p_commit => l_commit

Line 3443: FND_File.Put_Line(Fnd_File.LOG,'End for creating rel in single thread :'||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));

3439: COMMIT;
3440: END IF;
3441: END LOOP;
3442: IF(l_debug_level>1) THEN
3443: FND_File.Put_Line(Fnd_File.LOG,'End for creating rel in single thread :'||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
3444: FND_File.Put_Line(Fnd_File.LOG,'No of relation transactions processed :'||l_found);
3445: FND_File.Put_Line(Fnd_File.LOG,'No of successful relation transactions :'||l_rel_success_count);
3446: FND_File.Put_Line(Fnd_File.LOG,'No of failed relation transactions :'||l_rel_failure_count);
3447: END IF;

Line 3444: FND_File.Put_Line(Fnd_File.LOG,'No of relation transactions processed :'||l_found);

3440: END IF;
3441: END LOOP;
3442: IF(l_debug_level>1) THEN
3443: FND_File.Put_Line(Fnd_File.LOG,'End for creating rel in single thread :'||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
3444: FND_File.Put_Line(Fnd_File.LOG,'No of relation transactions processed :'||l_found);
3445: FND_File.Put_Line(Fnd_File.LOG,'No of successful relation transactions :'||l_rel_success_count);
3446: FND_File.Put_Line(Fnd_File.LOG,'No of failed relation transactions :'||l_rel_failure_count);
3447: END IF;
3448: END IF;

Line 3445: FND_File.Put_Line(Fnd_File.LOG,'No of successful relation transactions :'||l_rel_success_count);

3441: END LOOP;
3442: IF(l_debug_level>1) THEN
3443: FND_File.Put_Line(Fnd_File.LOG,'End for creating rel in single thread :'||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
3444: FND_File.Put_Line(Fnd_File.LOG,'No of relation transactions processed :'||l_found);
3445: FND_File.Put_Line(Fnd_File.LOG,'No of successful relation transactions :'||l_rel_success_count);
3446: FND_File.Put_Line(Fnd_File.LOG,'No of failed relation transactions :'||l_rel_failure_count);
3447: END IF;
3448: END IF;
3449: EXCEPTION

Line 3446: FND_File.Put_Line(Fnd_File.LOG,'No of failed relation transactions :'||l_rel_failure_count);

3442: IF(l_debug_level>1) THEN
3443: FND_File.Put_Line(Fnd_File.LOG,'End for creating rel in single thread :'||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
3444: FND_File.Put_Line(Fnd_File.LOG,'No of relation transactions processed :'||l_found);
3445: FND_File.Put_Line(Fnd_File.LOG,'No of successful relation transactions :'||l_rel_success_count);
3446: FND_File.Put_Line(Fnd_File.LOG,'No of failed relation transactions :'||l_rel_failure_count);
3447: END IF;
3448: END IF;
3449: EXCEPTION
3450: WHEN g_exc_error THEN