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

Line 35: fnd_file.put_line(fnd_file.log,

31: l_exception_msg VARCHAR2(100);
32: BEGIN
33: x_return_status := fnd_api.g_ret_sts_success;
34:
35: fnd_file.put_line(fnd_file.log,
36: 'Inside POS_MERGE_SUPPLIER_PKG.create_bus_attr ');
37: BEGIN
38: pos_supp_classification_pkg.add_bus_class_attr(p_party_id,
39: p_buss_class_rec.vendor_id,

Line 51: fnd_file.put_line(fnd_file.log,

47: p_classification_id,
48: l_status,
49: l_exception_msg);
50:
51: fnd_file.put_line(fnd_file.log,
52: 'l_exception_msg from pos_supp_classification_pkg.add_bus_class_attr : ' ||
53: l_exception_msg || ' for party id : ' || p_party_id);
54:
55: END;

Line 81: fnd_file.put_line(fnd_file.log,

77: ) IS
78:
79: BEGIN
80: x_return_status := fnd_api.g_ret_sts_success;
81: fnd_file.put_line(fnd_file.log,
82: 'Inside POS_MERGE_SUPPLIER_PKG.get_bus_attr_rec ' ||
83: p_party_id);
84:
85: SELECT --classification_id,

Line 153: fnd_file.put_line(fnd_file.log,

149:
150: BEGIN
151: x_return_status := fnd_api.g_ret_sts_success;
152:
153: fnd_file.put_line(fnd_file.log,
154: 'Inside POS_MERGE_SUPPLIER_PKG.Buss_Class_Merge p_to_fk_id: ' ||
155: p_to_fk_id || ' p_from_fk_id: ' || p_from_fk_id ||
156: ' p_from_id: ' || p_from_id);
157:

Line 167: fnd_file.put_line(fnd_file.log, 'Rowcount: ' || SQL%ROWCOUNT);

163: last_update_login = hz_utility_pub.last_update_login
164: WHERE party_id = p_from_fk_id
165: AND classification_id = p_from_id;
166:
167: fnd_file.put_line(fnd_file.log, 'Rowcount: ' || SQL%ROWCOUNT);
168:
169: SELECT vendor_id
170: INTO l_to_vendor_id
171: FROM ap_suppliers

Line 174: fnd_file.put_line(fnd_file.log,

170: INTO l_to_vendor_id
171: FROM ap_suppliers
172: WHERE party_id = p_to_fk_id;
173:
174: fnd_file.put_line(fnd_file.log,
175: 'Inside POS_MERGE_SUPPLIER_PKG.Buss_Class_Merge l_to_vendor_id: ' ||
176: l_to_vendor_id);
177:
178: DELETE FROM pos_supplier_mappings a

Line 195: fnd_file.put_line(fnd_file.log, 'Rowcount1: ' || SQL%ROWCOUNT);

191: WHERE mapping_id IN (SELECT mapping_id
192: FROM pos_supplier_mappings
193: WHERE party_id = p_to_fk_id);
194:
195: fnd_file.put_line(fnd_file.log, 'Rowcount1: ' || SQL%ROWCOUNT);
196:
197: /* Check for the duplicate business classification details */
198: SELECT COUNT(1)
199: INTO l_count

Line 211: fnd_file.put_line(fnd_file.log,

207: AND attr_from.classification_id = p_from_id;
208: /*AND attr_from.classification_id = p_from_fk_id
209: AND attr_to.classification_id = p_to_fk_id;*/
210:
211: fnd_file.put_line(fnd_file.log,
212: 'Inside POS_MERGE_SUPPLIER_PKG.Buss_Class_Merge l_count: ' ||
213: l_count);
214:
215: IF (l_count = 0) THEN

Line 233: fnd_file.put_line(fnd_file.log,

229: 'Cannot get classification ID : ' ||
230: p_from_id);
231: fnd_msg_pub.add;
232:
233: fnd_file.put_line(fnd_file.log,
234: 'No. of Messages: ' || l_msg_count ||
235: ', Message: ' || l_msg_data ||
236: ' From get_bus_attr_rec API.');
237: x_return_status := fnd_api.g_ret_sts_error;

Line 260: fnd_file.put_line(fnd_file.log,

256: 'Cannot copy classification ID : ' ||
257: p_from_id);
258: fnd_msg_pub.add;
259:
260: fnd_file.put_line(fnd_file.log,
261: 'No. of Messages: ' || l_msg_count ||
262: ', Message: ' || l_msg_data ||
263: ' From create_bus_attr API.');
264: x_return_status := fnd_api.g_ret_sts_error;

Line 272: fnd_file.put_line(fnd_file.log, 'In others : ' || SQLERRM);

268: END IF;
269:
270: EXCEPTION
271: WHEN OTHERS THEN
272: fnd_file.put_line(fnd_file.log, 'In others : ' || SQLERRM);
273: x_return_status := fnd_api.g_ret_sts_unexp_error;
274: END buss_class_merge;
275:
276: PROCEDURE create_prod_serv

Line 327: fnd_file.put_line(fnd_file.log,

323: x_msg_count => l_msg_count,
324: x_msg_data => l_msg_data);
325:
326: IF x_return_status <> fnd_api.g_ret_sts_success THEN
327: fnd_file.put_line(fnd_file.log,
328: 'No. of Messages: ' || l_msg_count || ', Message: ' ||
329: l_msg_data ||
330: ' From pos_product_service_utl_pkg.add_new_ps_req API.');
331: RETURN;

Line 422: fnd_file.put_line(fnd_file.log,

418: x_msg_count => l_msg_count,
419: x_msg_data => l_msg_data);
420:
421: IF x_return_status <> fnd_api.g_ret_sts_success THEN
422: fnd_file.put_line(fnd_file.log,
423: 'No. of Messages: ' || l_msg_count || ', Message: ' ||
424: l_msg_data ||
425: ' From pos_profile_change_request_pkg.approve_ps_req API.');
426: RETURN;

Line 565: fnd_file.put_line(fnd_file.log,

561: l_row_count NUMBER := 0;
562: BEGIN
563: x_return_status := fnd_api.g_ret_sts_success;
564:
565: fnd_file.put_line(fnd_file.log,
566: 'Inside POS_MERGE_SUPPLIER_PKG.prod_service_merge p_to_fk_id: ' ||
567: p_to_fk_id || ' p_from_fk_id: ' || p_from_fk_id ||
568: ' p_from_id : ' || p_from_id);
569:

Line 622: fnd_file.put_line(fnd_file.log,

618: fnd_message.set_token('ERROR',
619: 'Cannot get classification ID : ' || p_from_id);
620: fnd_msg_pub.add;
621:
622: fnd_file.put_line(fnd_file.log,
623: 'No. of Messages: ' || l_msg_count || ', Message: ' ||
624: l_msg_data || ' From get_prod_serv_rec API.');
625: x_return_status := fnd_api.g_ret_sts_error;
626:

Line 645: fnd_file.put_line(fnd_file.log,

641: 'Cannot copy classification ID : ' ||
642: p_from_id);
643: fnd_msg_pub.add;
644:
645: fnd_file.put_line(fnd_file.log,
646: 'No. of Messages: ' || l_msg_count ||
647: ', Message: ' || l_msg_data ||
648: ' From create_prod_serv API.');
649: x_return_status := fnd_api.g_ret_sts_error;

Line 680: fnd_file.put_line(fnd_file.log,

676:
677: BEGIN
678: x_return_status := fnd_api.g_ret_sts_success;
679:
680: fnd_file.put_line(fnd_file.log,
681: 'Inside POS_MERGE_SUPPLIER_PKG.party_contact_merge p_to_fk_id: ' ||
682: p_to_fk_id || ' p_from_fk_id: ' || p_from_fk_id ||
683: ' p_from_id : ' || p_from_id);
684:

Line 701: fnd_file.put_line(fnd_file.log,

697: x_msg_count => l_msg_count,
698: x_msg_data => l_msg_data);
699:
700: IF x_return_status <> fnd_api.g_ret_sts_success THEN
701: fnd_file.put_line(fnd_file.log,
702: 'No. of Messages: ' || l_msg_count || ', Message: ' ||
703: l_msg_data ||
704: ' From hz_party_usg_assignment_pvt.assign_party_usage API.');
705: END IF;

Line 736: fnd_file.put_line(fnd_file.log,

732: x_assign_id => l_assign_id,
733: x_response => l_response);
734:
735: IF x_return_status <> fnd_api.g_ret_sts_success THEN
736: fnd_file.put_line(fnd_file.log,
737: 'No. of Messages: ' || x_msg_count ||
738: ', Message: ' || x_msg_data ||
739: ' From iby_disbursement_setup_pub.set_payee_instr_assignment API.');
740: END IF;

Line 830: fnd_file.put_line(fnd_file.log,

826: l_assign iby_fndcpt_setup_pub.pmtinstrassignment_rec_type;
827: BEGIN
828: x_return_status := fnd_api.g_ret_sts_success;
829:
830: fnd_file.put_line(fnd_file.log,
831: 'Inside POS_MERGE_SUPPLIER_PKG.bank_dtls_merge p_to_fk_id: ' ||
832: p_to_fk_id || ' p_to_fk_id: ' || p_from_fk_id);
833:
834: get_bank_dtls_rec(p_init_msg_list => 'T',

Line 848: fnd_file.put_line(fnd_file.log,

844: fnd_message.set_token('ERROR',
845: 'Cannot get Bank Details : ' || p_from_id);
846: fnd_msg_pub.add;
847:
848: fnd_file.put_line(fnd_file.log,
849: 'No. of Messages: ' || l_msg_count || ', Message: ' ||
850: l_msg_data || ' From get_bank_dtls_rec API.');
851: x_return_status := fnd_api.g_ret_sts_error;
852:

Line 885: fnd_file.put_line(fnd_file.log,

881: fnd_message.set_token('ERROR',
882: 'Cannot copy Bank Details : ' || p_from_id);
883: fnd_msg_pub.add;
884:
885: fnd_file.put_line(fnd_file.log,
886: 'No. of Messages: ' || l_msg_count ||
887: ', Message: ' || l_msg_data ||
888: ' From create_bank_dtls API.');
889: x_return_status := fnd_api.g_ret_sts_error;

Line 2856: fnd_file.put_line(fnd_file.log,

2852: WHERE party_site_id = p_to_party_id;
2853:
2854: EXCEPTION
2855: WHEN no_data_found THEN
2856: fnd_file.put_line(fnd_file.log,
2857: 'No party id found for party site id : ' ||
2858: p_to_party_id);
2859: x_return_status := fnd_api.g_ret_sts_error;
2860: RETURN;

Line 2874: fnd_file.put_line(fnd_file.log,

2870: WHERE vendor_id = p_vendor_id;
2871:
2872: EXCEPTION
2873: WHEN no_data_found THEN
2874: fnd_file.put_line(fnd_file.log,
2875: 'No party id found for vendor id : ' ||
2876: p_vendor_id);
2877: x_return_status := fnd_api.g_ret_sts_error;
2878: RETURN;

Line 2889: fnd_file.put_line(fnd_file.log,

2885: WHERE vendor_site_id = p_to_party_id;
2886:
2887: EXCEPTION
2888: WHEN no_data_found THEN
2889: fnd_file.put_line(fnd_file.log,
2890: 'No party site id found for vendor site id : ' ||
2891: p_to_party_id);
2892: x_return_status := fnd_api.g_ret_sts_error;
2893: RETURN;

Line 3463: fnd_file.put_line(fnd_file.log,

3459: error_handler.get_message_list(l_error_msg_tbl);
3460: IF l_error_msg_tbl.first IS NOT NULL THEN
3461: l_msg_count := l_error_msg_tbl.first;
3462: WHILE l_msg_count IS NOT NULL LOOP
3463: fnd_file.put_line(fnd_file.log,
3464: 'Error Message: ' || l_error_msg_tbl(l_msg_count)
3465: .message_text ||
3466: ' From ego_user_attrs_data_pub.process_user_attrs_data API.');
3467: l_msg_count := l_error_msg_tbl.next(l_msg_count);

Line 3512: fnd_file.put_line(fnd_file.log,

3508: error_handler.get_message_list(l_error_msg_tbl);
3509: IF l_error_msg_tbl.first IS NOT NULL THEN
3510: l_msg_count := l_error_msg_tbl.first;
3511: WHILE l_msg_count IS NOT NULL LOOP
3512: fnd_file.put_line(fnd_file.log,
3513: 'Error Message: ' || l_error_msg_tbl(l_msg_count)
3514: .message_text ||
3515: ' From ego_user_attrs_data_pub.process_user_attrs_data API.');
3516: l_msg_count := l_error_msg_tbl.next(l_msg_count);

Line 3581: fnd_file.put_line(fnd_file.log,

3577: WHERE party_site_id = p_to_party_id;
3578:
3579: EXCEPTION
3580: WHEN no_data_found THEN
3581: fnd_file.put_line(fnd_file.log,
3582: 'No party id found for party site id : ' ||
3583: p_to_party_id);
3584: x_return_status := fnd_api.g_ret_sts_error;
3585: RETURN;

Line 3599: fnd_file.put_line(fnd_file.log,

3595: WHERE vendor_id = p_vendor_id;
3596:
3597: EXCEPTION
3598: WHEN no_data_found THEN
3599: fnd_file.put_line(fnd_file.log,
3600: 'No party id found for vendor id : ' ||
3601: p_vendor_id);
3602: x_return_status := fnd_api.g_ret_sts_error;
3603: RETURN;

Line 3614: fnd_file.put_line(fnd_file.log,

3610: WHERE vendor_site_id = p_to_party_id;
3611:
3612: EXCEPTION
3613: WHEN no_data_found THEN
3614: fnd_file.put_line(fnd_file.log,
3615: 'No party site id found for vendor site id : ' ||
3616: p_to_party_id);
3617: x_return_status := fnd_api.g_ret_sts_error;
3618: RETURN;

Line 3780: fnd_file.put_line(fnd_file.log,

3776: error_handler.get_message_list(l_error_msg_tbl);
3777: IF l_error_msg_tbl.first IS NOT NULL THEN
3778: l_msg_count := l_error_msg_tbl.first;
3779: WHILE l_msg_count IS NOT NULL LOOP
3780: fnd_file.put_line(fnd_file.log,
3781: 'Error Message: ' || l_error_msg_tbl(l_msg_count)
3782: .message_text ||
3783: ' From ego_user_attrs_data_pub.process_user_attrs_data API.');
3784: l_msg_count := l_error_msg_tbl.next(l_msg_count);

Line 3853: fnd_file.put_line(fnd_file.log,

3849: ELSE
3850: RETURN;
3851: END IF;
3852:
3853: fnd_file.put_line(fnd_file.log,
3854: 'Inside POS_MERGE_SUPPLIER_PKG.supplier_uda_merge p_to_fk_id: ' ||
3855: p_to_fk_id || ' p_to_fk_id: ' || p_from_fk_id);
3856:
3857: /* Update the status of all the records in the bath to

Line 3880: fnd_file.put_line(fnd_file.log,

3876:
3877: /* Query the extension table for the to and from parties
3878: and get the rows in the ascending order of the creation
3879: date */
3880: fnd_file.put_line(fnd_file.log,
3881: 'supplier_uda_merge single row processing for attr group id : ' || attributes_group_coll(cntr)
3882: .attr_group_id);
3883:
3884: get_batch_user_attr_data(p_to_fk_id,

Line 3953: fnd_file.put_line(fnd_file.log,

3949: ELSE
3950:
3951: /* If the attribute group is multi row */
3952: -- Multirow processing
3953: fnd_file.put_line(fnd_file.log,
3954: 'supplier_uda_merge multi row processing for attr group id : ' || attributes_group_coll(cntr)
3955: .attr_group_id);
3956:
3957: get_batch_user_attr_data(p_to_fk_id,

Line 4034: fnd_file.put_line(fnd_file.log,

4030:
4031: BEGIN
4032: x_return_status := fnd_api.g_ret_sts_success;
4033:
4034: fnd_file.put_line(fnd_file.log,
4035: 'Inside POS_MERGE_SUPPLIER_PKG.supplier_site_uda_merge p_to_fk_id: ' ||
4036: p_to_fk_id || ' p_to_fk_id: ' || p_from_fk_id ||
4037: ' p_from_id : ' || p_from_id);
4038:

Line 4062: fnd_file.put_line(fnd_file.log,

4058:
4059: /* Query the extension table for the to and from parties
4060: and get the rows in the ascending order of the creation
4061: date */
4062: fnd_file.put_line(fnd_file.log,
4063: 'supplier_site_uda_merge single row processing for attr group id : ' || attributes_group_coll(cntr)
4064: .attr_group_id);
4065:
4066: get_supp_site_attr_data(p_from_fk_id,

Line 4137: fnd_file.put_line(fnd_file.log,

4133: ELSE
4134:
4135: /* If the attribute group is multi row */
4136: -- Multirow processing
4137: fnd_file.put_line(fnd_file.log,
4138: 'supplier_site_uda_merge multi row processing for attr group id : ' || attributes_group_coll(cntr)
4139: .attr_group_id);
4140:
4141: get_supp_site_attr_data(p_from_fk_id,

Line 4241: fnd_file.put_line(fnd_file.log,

4237: ELSE
4238: RETURN;
4239: END IF;
4240:
4241: fnd_file.put_line(fnd_file.log,
4242: 'Inside POS_MERGE_SUPPLIER_PKG.party_site_uda_merge p_to_fk_id: ' ||
4243: p_to_fk_id || ' p_from_fk_id: ' || p_from_fk_id ||
4244: ' p_from_id: ' || p_from_id || ' p_batch_id: ' ||
4245: p_batch_id);

Line 4270: fnd_file.put_line(fnd_file.log,

4266:
4267: /* Query the extension table for the to and from parties
4268: and get the rows in the ascending order of the creation
4269: date */
4270: fnd_file.put_line(fnd_file.log,
4271: 'party_site_uda_merge single row processing for attr group id : ' || attributes_group_coll(cntr)
4272: .attr_group_id);
4273:
4274: get_party_site_attr_data(p_from_fk_id,

Line 4344: fnd_file.put_line(fnd_file.log,

4340: ELSE
4341:
4342: /* If the attribute group is multi row */
4343: -- Multirow processing
4344: fnd_file.put_line(fnd_file.log,
4345: 'party_site_uda_merge multi row processing for attr group id : ' || attributes_group_coll(cntr)
4346: .attr_group_id);
4347:
4348: get_party_site_attr_data(p_from_fk_id,

Line 4413: fnd_file.put_line(fnd_file.log,

4409:
4410: BEGIN
4411: x_return_status := fnd_api.g_ret_sts_success;
4412:
4413: fnd_file.put_line(fnd_file.log,
4414: 'Inside POS_MERGE_SUPPLIER_PKG.enable_party_as_supplier p_to_fk_id: ' ||
4415: p_to_fk_id || ' p_to_fk_id: ' || p_from_fk_id);
4416:
4417: UPDATE ap_suppliers

Line 4426: fnd_file.put_line(fnd_file.log, 'l_to_vendor_id: ' || l_to_vendor_id);

4422: INTO l_to_vendor_id
4423: FROM ap_suppliers
4424: WHERE party_id = p_to_fk_id;
4425:
4426: fnd_file.put_line(fnd_file.log, 'l_to_vendor_id: ' || l_to_vendor_id);
4427:
4428: IF (l_to_vendor_id = 0) THEN
4429: l_ven_num_code := pos_batch_import_pkg.chk_vendor_num_nmbering_method();
4430:

Line 4459: fnd_file.put_line(fnd_file.log,

4455: vendor_rec,
4456: l_vendor_id,
4457: l_party_id);
4458:
4459: fnd_file.put_line(fnd_file.log,
4460: 'x_return_status from ap_vendor_pub_pkg.create_vendor: ' ||
4461: x_return_status || ' l_vendor_id: ' || l_vendor_id);
4462:
4463: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 4464: fnd_file.put_line(fnd_file.log,

4460: 'x_return_status from ap_vendor_pub_pkg.create_vendor: ' ||
4461: x_return_status || ' l_vendor_id: ' || l_vendor_id);
4462:
4463: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4464: fnd_file.put_line(fnd_file.log,
4465: 'No. of Messages: ' || l_msg_count ||
4466: ', Message: ' || l_msg_data ||
4467: ' From ap_vendor_pub_pkg.create_vendor API.');
4468: RETURN;