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 419: FND_File.Put_Line(Fnd_File.LOG,'Process_iface_txns-P_Source_System_Name : '||p_source_system_name);

415: l_fnd_g_true := FND_API.G_TRUE;
416:
417: IF(l_debug_level>1) THEN
418:
419: FND_File.Put_Line(Fnd_File.LOG,'Process_iface_txns-P_Source_System_Name : '||p_source_system_name);
420: FND_File.Put_Line(Fnd_File.LOG,'Process_iface_txns-P_Batch_Name : '||p_batch_name);
421: END IF;
422:
423: OPEN internal_party_cur;

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

416:
417: IF(l_debug_level>1) THEN
418:
419: FND_File.Put_Line(Fnd_File.LOG,'Process_iface_txns-P_Source_System_Name : '||p_source_system_name);
420: FND_File.Put_Line(Fnd_File.LOG,'Process_iface_txns-P_Batch_Name : '||p_batch_name);
421: END IF;
422:
423: OPEN internal_party_cur;
424: FETCH internal_party_cur INTO g_int_party;

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

449: AND cii.process_status = 'R'
450: AND cii.location_type_code in ('INVENTORY','PO','IN_TRANSIT','WIP','PROJECT');
451:
452: IF SQL%FOUND THEN
453: FND_File.Put_Line(Fnd_File.LOG, l_error_message||' Total Rows in this error : '||SQL%ROWCOUNT );
454: END IF;
455:
456: END;
457:

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

457:
458: IF NVL(p_resolve_ids,'Y') = 'Y'
459: THEN
460: IF(l_debug_level>1) THEN
461: FND_File.Put_Line(Fnd_File.LOG,'Resolving the Ids based on user values ');
462: END IF;
463: CSI_ML_UTIL_PVT.resolve_ids(p_txn_from_date,
464: p_txn_to_date,
465: p_batch_name,

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

468: l_error_message);
469:
470: IF NOT l_return_status = l_fnd_success THEN
471: IF(l_debug_level>1) THEN
472: FND_File.Put_Line(Fnd_File.LOG,'Error Resolving the Ids: ');
473: END IF;
474: RAISE g_exc_error;
475: END IF;
476: END IF;

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

498: );
499:
500: IF SQL%FOUND THEN
501: IF(l_debug_level>1) THEN
502: FND_File.Put_Line(Fnd_File.LOG, l_error_message||' Total Rows in this error : '||SQL%ROWCOUNT );
503: END IF;
504: END IF;
505:
506:

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

522: AND ciai.fa_asset_number IS NULL
523: );
524:
525: IF SQL%FOUND THEN
526: FND_File.Put_Line(Fnd_File.LOG, l_error_message ||' Total Rows in this error : '||SQL%ROWCOUNT);
527: END IF;
528:
529:
530:

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

551: WHERE cii.inst_interface_id = ciai.inst_interface_id
552: ));
553:
554: IF SQL%FOUND THEN
555: FND_File.Put_Line(Fnd_File.LOG, l_error_message ||' Total Rows in this error : '||SQL%ROWCOUNT);
556: END IF;
557:
558: END;
559: l_txn_count := 0;

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

561: p_batch_name)
562: LOOP
563: l_txn_count := l_txn_count +1;
564: IF(l_debug_level>1) THEN
565: FND_File.Put_Line(Fnd_File.LOG,'Started Processing the Transaction Identifier : '||get_txns_rec.transaction_identifier);
566: END IF;
567: c_instance_tbl.DELETE;
568: c_ext_attrib_tbl.DELETE;
569: c_party_tbl.DELETE;

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

602: FOR iface_det_rec IN iface_det_cur(get_txns_rec.transaction_identifier,
603: p_source_system_name)
604: LOOP
605: IF(l_debug_level>1) THEN
606: FND_File.Put_Line(Fnd_File.LOG,'Processing Inst_interface_id : '||iface_det_rec.inst_interface_id);
607: END IF;
608: --to find out whether the instance exists
609: instance_exists(iface_det_rec.inst_interface_id,
610: l_instance_id,

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

613: IF NOT l_return_status = l_fnd_success
614: THEN -- create item instance
615:
616: IF(l_debug_level>1) THEN
617: FND_File.Put_Line(Fnd_File.LOG,'Create New Instance CASE:');
618: END IF;
619: x_return_status := l_fnd_success;
620:
621: c_instance_tbl(inst_idx).INSTANCE_ID := NULL;

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

2653:
2654: inst_idx := inst_idx + 1;
2655: ELSE -- update candidate
2656: IF(l_debug_level>1) THEN
2657: FND_File.Put_Line(Fnd_File.LOG,'CASE -update item instance id: '||l_instance_id);
2658: END IF;
2659: --u_instance_tbl(inst_idx).instance_id := l_instance_id;
2660: u_instance_tbl(u_inst_idx).instance_id := l_instance_id; --Added for open
2661: -- call resolve_update_ids

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

2684:
2685: IF u_instance_tbl.COUNT >0
2686: THEN
2687: IF(l_debug_level>1) THEN
2688: FND_File.Put_Line(Fnd_File.LOG,'Resolving Update Related Ids:');
2689: END IF;
2690: csi_ml_util_pvt.resolve_update_ids
2691: (p_source_system_name => p_source_system_name,
2692: p_txn_identifier => get_txns_rec.transaction_identifier,

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

2693: x_return_status => l_return_status,
2694: x_error_message => l_error_message);
2695: IF NOT l_return_status = l_fnd_success
2696: THEN
2697: FND_File.Put_Line(Fnd_File.LOG,'Error from csi_ml_util_pvt.resolve_update_ids');
2698: RAISE g_exc_error;
2699: END IF;
2700:
2701: csi_ml_update_pvt.populate_recs(

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

2714:
2715: IF NOT l_return_status = l_fnd_success
2716: THEN
2717: IF(l_debug_level>1) THEN
2718: FND_File.Put_Line(Fnd_File.LOG,'Error from csi_ml_update_pvt.populate_recs ');
2719: END IF;
2720: RAISE g_exc_error;
2721: END IF;
2722: END IF;

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

2788: FOR i IN 1 .. c_instance_tbl.COUNT LOOP
2789: IF c_instance_tbl(i).instance_id IS NOT NULL
2790: THEN
2791: IF(l_debug_level>1) THEN
2792: FND_File.Put_Line(Fnd_File.LOG,'Instance Crearted with number : '||c_instance_tbl(i).instance_id);
2793: END IF;
2794: END IF;
2795: END LOOP;
2796: END IF;

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

2994: END LOOP;
2995:
2996: IF c_relationship_tbl.COUNT>0
2997: THEN
2998: FND_File.Put_Line(Fnd_File.LOG,'creating relationships :');
2999: csi_ii_relationships_pub.create_relationship(
3000: p_api_version => l_api_version
3001: ,p_commit => l_commit
3002: ,p_init_msg_list => l_init_msg_list

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

3022:
3023: IF u_relationship_tbl.COUNT>0
3024: THEN
3025:
3026: FND_File.Put_Line(Fnd_File.LOG,'updating relationships :');
3027: csi_ii_relationships_pub.update_relationship(
3028: p_api_version => l_api_version
3029: ,p_commit => l_commit
3030: ,p_init_msg_list => l_init_msg_list

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

3063: u_grp_error_tbl);
3064: l_failure_count := l_failure_count +1;
3065:
3066: WHEN g_exc_error THEN
3067: FND_File.Put_Line(Fnd_File.LOG,'error:'||l_error_message);
3068: ROLLBACK TO s_txnbegin;
3069: UPDATE csi_instance_interface
3070: SET process_Status = 'E',
3071: error_text = l_error_message

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

3077:
3078: l_return_status := fnd_api.g_ret_sts_success;
3079:
3080: IF(l_debug_level>1) THEN
3081: FND_File.Put_Line(Fnd_File.LOG,'No of Transactions Processed :'||l_txn_count);
3082: FND_File.Put_Line(Fnd_File.LOG,'No of successful Transactions :'||l_success_count);
3083: FND_File.Put_Line(Fnd_File.LOG,'No of failed Transactions :'||l_failure_count);
3084: END IF;
3085:

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

3078: l_return_status := fnd_api.g_ret_sts_success;
3079:
3080: IF(l_debug_level>1) THEN
3081: FND_File.Put_Line(Fnd_File.LOG,'No of Transactions Processed :'||l_txn_count);
3082: FND_File.Put_Line(Fnd_File.LOG,'No of successful Transactions :'||l_success_count);
3083: FND_File.Put_Line(Fnd_File.LOG,'No of failed Transactions :'||l_failure_count);
3084: END IF;
3085:
3086: BEGIN

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

3079:
3080: IF(l_debug_level>1) THEN
3081: FND_File.Put_Line(Fnd_File.LOG,'No of Transactions Processed :'||l_txn_count);
3082: FND_File.Put_Line(Fnd_File.LOG,'No of successful Transactions :'||l_success_count);
3083: FND_File.Put_Line(Fnd_File.LOG,'No of failed Transactions :'||l_failure_count);
3084: END IF;
3085:
3086: BEGIN
3087: -- Added for releationships

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

3101: ,x_error_message => l_error_message
3102: );
3103: -- Need to check l_error_message
3104: IF(l_debug_level>1) THEN
3105: FND_File.Put_Line(Fnd_File.LOG,'Start for creating rel in single thread :'||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
3106: END IF;
3107: FOR irel_det_rec IN irel_det_cur
3108: LOOP
3109: check_rel_exists(irel_det_rec.subject_id,

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

3133: c_rel_txn_rec.transaction_status_code := 'COMPLETE';
3134: c_rel_txn_rec.transaction_action_code := NULL;
3135: c_rel_txn_rec.object_version_number := 1;
3136: IF(l_debug_level>1) THEN
3137: FND_File.Put_Line(Fnd_File.LOG,'creating relationships :');
3138: END IF;
3139:
3140: csi_ii_relationships_pvt.create_relationship(
3141: p_api_version => l_api_version

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

3273: u_rel_txn_rec.transaction_action_code := NULL;
3274: u_rel_txn_rec.object_version_number := 1;
3275:
3276: IF(l_debug_level>1) THEN
3277: FND_File.Put_Line(Fnd_File.LOG,'updating relationships :');
3278: END IF;
3279: csi_ii_relationships_pvt.update_relationship
3280: ( p_api_version => l_api_version
3281: ,p_commit => l_commit

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

3316: COMMIT;
3317: END IF;
3318: END LOOP;
3319: IF(l_debug_level>1) THEN
3320: FND_File.Put_Line(Fnd_File.LOG,'End for creating rel in single thread :'||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
3321: FND_File.Put_Line(Fnd_File.LOG,'No of relation transactions processed :'||l_found);
3322: FND_File.Put_Line(Fnd_File.LOG,'No of successful relation transactions :'||l_rel_success_count);
3323: FND_File.Put_Line(Fnd_File.LOG,'No of failed relation transactions :'||l_rel_failure_count);
3324: END IF;

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

3317: END IF;
3318: END LOOP;
3319: IF(l_debug_level>1) THEN
3320: FND_File.Put_Line(Fnd_File.LOG,'End for creating rel in single thread :'||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
3321: FND_File.Put_Line(Fnd_File.LOG,'No of relation transactions processed :'||l_found);
3322: FND_File.Put_Line(Fnd_File.LOG,'No of successful relation transactions :'||l_rel_success_count);
3323: FND_File.Put_Line(Fnd_File.LOG,'No of failed relation transactions :'||l_rel_failure_count);
3324: END IF;
3325: END IF;

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

3318: END LOOP;
3319: IF(l_debug_level>1) THEN
3320: FND_File.Put_Line(Fnd_File.LOG,'End for creating rel in single thread :'||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
3321: FND_File.Put_Line(Fnd_File.LOG,'No of relation transactions processed :'||l_found);
3322: FND_File.Put_Line(Fnd_File.LOG,'No of successful relation transactions :'||l_rel_success_count);
3323: FND_File.Put_Line(Fnd_File.LOG,'No of failed relation transactions :'||l_rel_failure_count);
3324: END IF;
3325: END IF;
3326: EXCEPTION

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

3319: IF(l_debug_level>1) THEN
3320: FND_File.Put_Line(Fnd_File.LOG,'End for creating rel in single thread :'||to_char(sysdate,'dd-mon-yy hh24:mi:ss'));
3321: FND_File.Put_Line(Fnd_File.LOG,'No of relation transactions processed :'||l_found);
3322: FND_File.Put_Line(Fnd_File.LOG,'No of successful relation transactions :'||l_rel_success_count);
3323: FND_File.Put_Line(Fnd_File.LOG,'No of failed relation transactions :'||l_rel_failure_count);
3324: END IF;
3325: END IF;
3326: EXCEPTION
3327: WHEN g_exc_error THEN