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.RCV_UTILITIES dependencies on ASN_DEBUG

Line 5: g_asn_debug VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');

1: PACKAGE BODY RCV_UTILITIES AS
2: /* $Header: RCVUTILB.pls 120.1.12010000.2 2008/11/18 21:50:58 vthevark noship $*/
3:
4: -- Read the profile option that enables/disables the debug log
5: g_asn_debug VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');
6:
7: /* This API is called by AP in their Supplier Merge program */
8:
9: PROCEDURE Merge_Vendor

Line 24: IF (g_asn_debug = 'Y') THEN

20: l_last_updated_by NUMBER;
21:
22: BEGIN
23:
24: IF (g_asn_debug = 'Y') THEN
25: asn_debug.put_line('p_vendor_id: ' || p_vendor_id);
26: asn_debug.put_line('p_vendor_site_id ' || p_vendor_site_id);
27: asn_debug.put_line('p_dup_vendor_id ' || p_dup_vendor_id);
28: asn_debug.put_line('p_dup_vendor_site_id ' || p_dup_vendor_site_id);

Line 25: asn_debug.put_line('p_vendor_id: ' || p_vendor_id);

21:
22: BEGIN
23:
24: IF (g_asn_debug = 'Y') THEN
25: asn_debug.put_line('p_vendor_id: ' || p_vendor_id);
26: asn_debug.put_line('p_vendor_site_id ' || p_vendor_site_id);
27: asn_debug.put_line('p_dup_vendor_id ' || p_dup_vendor_id);
28: asn_debug.put_line('p_dup_vendor_site_id ' || p_dup_vendor_site_id);
29: END IF;

Line 26: asn_debug.put_line('p_vendor_site_id ' || p_vendor_site_id);

22: BEGIN
23:
24: IF (g_asn_debug = 'Y') THEN
25: asn_debug.put_line('p_vendor_id: ' || p_vendor_id);
26: asn_debug.put_line('p_vendor_site_id ' || p_vendor_site_id);
27: asn_debug.put_line('p_dup_vendor_id ' || p_dup_vendor_id);
28: asn_debug.put_line('p_dup_vendor_site_id ' || p_dup_vendor_site_id);
29: END IF;
30:

Line 27: asn_debug.put_line('p_dup_vendor_id ' || p_dup_vendor_id);

23:
24: IF (g_asn_debug = 'Y') THEN
25: asn_debug.put_line('p_vendor_id: ' || p_vendor_id);
26: asn_debug.put_line('p_vendor_site_id ' || p_vendor_site_id);
27: asn_debug.put_line('p_dup_vendor_id ' || p_dup_vendor_id);
28: asn_debug.put_line('p_dup_vendor_site_id ' || p_dup_vendor_site_id);
29: END IF;
30:
31: -- Initialize API return status to success

Line 28: asn_debug.put_line('p_dup_vendor_site_id ' || p_dup_vendor_site_id);

24: IF (g_asn_debug = 'Y') THEN
25: asn_debug.put_line('p_vendor_id: ' || p_vendor_id);
26: asn_debug.put_line('p_vendor_site_id ' || p_vendor_site_id);
27: asn_debug.put_line('p_dup_vendor_id ' || p_dup_vendor_id);
28: asn_debug.put_line('p_dup_vendor_site_id ' || p_dup_vendor_site_id);
29: END IF;
30:
31: -- Initialize API return status to success
32: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 63: IF (g_asn_debug = 'Y') THEN

59: WHERE receipt_source_code = 'VENDOR'
60: AND vendor_id = p_dup_vendor_id
61: AND vendor_site_id is null;
62:
63: IF (g_asn_debug = 'Y') THEN
64: asn_debug.put_line('Updating rcv_shipment_headers: count =' || sql%rowcount);
65: END IF;
66:
67: -- Updating rcv_transactions

Line 64: asn_debug.put_line('Updating rcv_shipment_headers: count =' || sql%rowcount);

60: AND vendor_id = p_dup_vendor_id
61: AND vendor_site_id is null;
62:
63: IF (g_asn_debug = 'Y') THEN
64: asn_debug.put_line('Updating rcv_shipment_headers: count =' || sql%rowcount);
65: END IF;
66:
67: -- Updating rcv_transactions
68: UPDATE rcv_transactions

Line 77: IF (g_asn_debug = 'Y') THEN

73: WHERE source_document_code = 'PO'
74: AND vendor_id = p_dup_vendor_id
75: AND vendor_site_id = p_dup_vendor_site_id ;
76:
77: IF (g_asn_debug = 'Y') THEN
78: asn_debug.put_line('After updating rcv_transactions: count =' || sql%rowcount);
79: END IF;
80:
81: -- Updating rcv_headers_interface

Line 78: asn_debug.put_line('After updating rcv_transactions: count =' || sql%rowcount);

74: AND vendor_id = p_dup_vendor_id
75: AND vendor_site_id = p_dup_vendor_site_id ;
76:
77: IF (g_asn_debug = 'Y') THEN
78: asn_debug.put_line('After updating rcv_transactions: count =' || sql%rowcount);
79: END IF;
80:
81: -- Updating rcv_headers_interface
82: UPDATE rcv_headers_interface

Line 100: IF (g_asn_debug = 'Y') THEN

96: WHERE receipt_source_code = 'VENDOR'
97: AND vendor_id = p_dup_vendor_id
98: AND vendor_site_id is null;
99:
100: IF (g_asn_debug = 'Y') THEN
101: asn_debug.put_line('After updating rcv_headers_interface: count =' || sql%rowcount);
102: END IF;
103:
104: -- Updating rcv_transactions_interface

Line 101: asn_debug.put_line('After updating rcv_headers_interface: count =' || sql%rowcount);

97: AND vendor_id = p_dup_vendor_id
98: AND vendor_site_id is null;
99:
100: IF (g_asn_debug = 'Y') THEN
101: asn_debug.put_line('After updating rcv_headers_interface: count =' || sql%rowcount);
102: END IF;
103:
104: -- Updating rcv_transactions_interface
105: UPDATE rcv_transactions_interface

Line 123: IF (g_asn_debug = 'Y') THEN

119: WHERE source_document_code = 'PO'
120: AND vendor_id = p_dup_vendor_id
121: AND vendor_site_id is null;
122:
123: IF (g_asn_debug = 'Y') THEN
124: asn_debug.put_line('After updating rcv_transactions_interface: count =' || sql%rowcount);
125: END IF;
126:
127: IF (g_asn_debug = 'Y') THEN

Line 124: asn_debug.put_line('After updating rcv_transactions_interface: count =' || sql%rowcount);

120: AND vendor_id = p_dup_vendor_id
121: AND vendor_site_id is null;
122:
123: IF (g_asn_debug = 'Y') THEN
124: asn_debug.put_line('After updating rcv_transactions_interface: count =' || sql%rowcount);
125: END IF;
126:
127: IF (g_asn_debug = 'Y') THEN
128: asn_debug.put_line('x_return_status: ' || x_return_status);

Line 127: IF (g_asn_debug = 'Y') THEN

123: IF (g_asn_debug = 'Y') THEN
124: asn_debug.put_line('After updating rcv_transactions_interface: count =' || sql%rowcount);
125: END IF;
126:
127: IF (g_asn_debug = 'Y') THEN
128: asn_debug.put_line('x_return_status: ' || x_return_status);
129: asn_debug.put_line('x_msg_count: ' || x_msg_count);
130: asn_debug.put_line('x_msg_data: ' || x_msg_data);
131: END IF;

Line 128: asn_debug.put_line('x_return_status: ' || x_return_status);

124: asn_debug.put_line('After updating rcv_transactions_interface: count =' || sql%rowcount);
125: END IF;
126:
127: IF (g_asn_debug = 'Y') THEN
128: asn_debug.put_line('x_return_status: ' || x_return_status);
129: asn_debug.put_line('x_msg_count: ' || x_msg_count);
130: asn_debug.put_line('x_msg_data: ' || x_msg_data);
131: END IF;
132:

Line 129: asn_debug.put_line('x_msg_count: ' || x_msg_count);

125: END IF;
126:
127: IF (g_asn_debug = 'Y') THEN
128: asn_debug.put_line('x_return_status: ' || x_return_status);
129: asn_debug.put_line('x_msg_count: ' || x_msg_count);
130: asn_debug.put_line('x_msg_data: ' || x_msg_data);
131: END IF;
132:
133: IF FND_API.To_Boolean( p_commit ) THEN

Line 130: asn_debug.put_line('x_msg_data: ' || x_msg_data);

126:
127: IF (g_asn_debug = 'Y') THEN
128: asn_debug.put_line('x_return_status: ' || x_return_status);
129: asn_debug.put_line('x_msg_count: ' || x_msg_count);
130: asn_debug.put_line('x_msg_data: ' || x_msg_data);
131: END IF;
132:
133: IF FND_API.To_Boolean( p_commit ) THEN
134: COMMIT WORK;

Line 142: IF (g_asn_debug = 'Y') THEN

138: WHEN OTHERS THEN
139: ROLLBACK;
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
141:
142: IF (g_asn_debug = 'Y') THEN
143: asn_debug.put_line('x_return_status: ' || x_return_status);
144: asn_debug.put_line('x_msg_count: ' || x_msg_count);
145: asn_debug.put_line('x_msg_data: ' || x_msg_data);
146: END IF;

Line 143: asn_debug.put_line('x_return_status: ' || x_return_status);

139: ROLLBACK;
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
141:
142: IF (g_asn_debug = 'Y') THEN
143: asn_debug.put_line('x_return_status: ' || x_return_status);
144: asn_debug.put_line('x_msg_count: ' || x_msg_count);
145: asn_debug.put_line('x_msg_data: ' || x_msg_data);
146: END IF;
147:

Line 144: asn_debug.put_line('x_msg_count: ' || x_msg_count);

140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
141:
142: IF (g_asn_debug = 'Y') THEN
143: asn_debug.put_line('x_return_status: ' || x_return_status);
144: asn_debug.put_line('x_msg_count: ' || x_msg_count);
145: asn_debug.put_line('x_msg_data: ' || x_msg_data);
146: END IF;
147:
148: END Merge_Vendor;

Line 145: asn_debug.put_line('x_msg_data: ' || x_msg_data);

141:
142: IF (g_asn_debug = 'Y') THEN
143: asn_debug.put_line('x_return_status: ' || x_return_status);
144: asn_debug.put_line('x_msg_count: ' || x_msg_count);
145: asn_debug.put_line('x_msg_data: ' || x_msg_data);
146: END IF;
147:
148: END Merge_Vendor;
149:

Line 167: IF (g_asn_debug = 'Y') THEN

163: x_org_id NUMBER;
164: x_lcm_flag VARCHAR2(1);
165:
166: BEGIN
167: IF (g_asn_debug = 'Y') THEN
168: asn_debug.put_line('In Get_RtLcmInfo: p_rcv_transaction_id' || p_rcv_transaction_id);
169: END IF;
170:
171: SELECT rt.po_line_location_id,

Line 168: asn_debug.put_line('In Get_RtLcmInfo: p_rcv_transaction_id' || p_rcv_transaction_id);

164: x_lcm_flag VARCHAR2(1);
165:
166: BEGIN
167: IF (g_asn_debug = 'Y') THEN
168: asn_debug.put_line('In Get_RtLcmInfo: p_rcv_transaction_id' || p_rcv_transaction_id);
169: END IF;
170:
171: SELECT rt.po_line_location_id,
172: rt.organization_id,

Line 183: IF (g_asn_debug = 'Y') THEN

179: WHERE rt.po_line_location_id is not null
180: AND rt.po_line_location_id = pll.line_location_id
181: AND transaction_id = p_rcv_transaction_id;
182:
183: IF (g_asn_debug = 'Y') THEN
184: asn_debug.put_line('x_progress' || x_progress);
185: asn_debug.put_line('x_pll_id' || x_pll_id);
186: asn_debug.put_line('x_org_id' || x_org_id);
187: asn_debug.put_line('x_lcm_flag' || x_lcm_flag);

Line 184: asn_debug.put_line('x_progress' || x_progress);

180: AND rt.po_line_location_id = pll.line_location_id
181: AND transaction_id = p_rcv_transaction_id;
182:
183: IF (g_asn_debug = 'Y') THEN
184: asn_debug.put_line('x_progress' || x_progress);
185: asn_debug.put_line('x_pll_id' || x_pll_id);
186: asn_debug.put_line('x_org_id' || x_org_id);
187: asn_debug.put_line('x_lcm_flag' || x_lcm_flag);
188: END IF;

Line 185: asn_debug.put_line('x_pll_id' || x_pll_id);

181: AND transaction_id = p_rcv_transaction_id;
182:
183: IF (g_asn_debug = 'Y') THEN
184: asn_debug.put_line('x_progress' || x_progress);
185: asn_debug.put_line('x_pll_id' || x_pll_id);
186: asn_debug.put_line('x_org_id' || x_org_id);
187: asn_debug.put_line('x_lcm_flag' || x_lcm_flag);
188: END IF;
189:

Line 186: asn_debug.put_line('x_org_id' || x_org_id);

182:
183: IF (g_asn_debug = 'Y') THEN
184: asn_debug.put_line('x_progress' || x_progress);
185: asn_debug.put_line('x_pll_id' || x_pll_id);
186: asn_debug.put_line('x_org_id' || x_org_id);
187: asn_debug.put_line('x_lcm_flag' || x_lcm_flag);
188: END IF;
189:
190: x_progress := '010';

Line 187: asn_debug.put_line('x_lcm_flag' || x_lcm_flag);

183: IF (g_asn_debug = 'Y') THEN
184: asn_debug.put_line('x_progress' || x_progress);
185: asn_debug.put_line('x_pll_id' || x_pll_id);
186: asn_debug.put_line('x_org_id' || x_org_id);
187: asn_debug.put_line('x_lcm_flag' || x_lcm_flag);
188: END IF;
189:
190: x_progress := '010';
191:

Line 207: IF (g_asn_debug = 'Y') THEN

203: FROM rcv_parameters
204: WHERE organization_id = x_org_id;
205: END IF;
206:
207: IF (g_asn_debug = 'Y') THEN
208: asn_debug.put_line('x_lcm_account_id' || x_lcm_account_id);
209: asn_debug.put_line('x_tax_variance_account_id' || x_tax_variance_account_id);
210: asn_debug.put_line('x_def_charges_account_id' || x_def_charges_account_id);
211: asn_debug.put_line('x_exchange_variance_account_id' || x_exchange_variance_account_id);

Line 208: asn_debug.put_line('x_lcm_account_id' || x_lcm_account_id);

204: WHERE organization_id = x_org_id;
205: END IF;
206:
207: IF (g_asn_debug = 'Y') THEN
208: asn_debug.put_line('x_lcm_account_id' || x_lcm_account_id);
209: asn_debug.put_line('x_tax_variance_account_id' || x_tax_variance_account_id);
210: asn_debug.put_line('x_def_charges_account_id' || x_def_charges_account_id);
211: asn_debug.put_line('x_exchange_variance_account_id' || x_exchange_variance_account_id);
212: asn_debug.put_line('x_inv_variance_account_id' || x_inv_variance_account_id);

Line 209: asn_debug.put_line('x_tax_variance_account_id' || x_tax_variance_account_id);

205: END IF;
206:
207: IF (g_asn_debug = 'Y') THEN
208: asn_debug.put_line('x_lcm_account_id' || x_lcm_account_id);
209: asn_debug.put_line('x_tax_variance_account_id' || x_tax_variance_account_id);
210: asn_debug.put_line('x_def_charges_account_id' || x_def_charges_account_id);
211: asn_debug.put_line('x_exchange_variance_account_id' || x_exchange_variance_account_id);
212: asn_debug.put_line('x_inv_variance_account_id' || x_inv_variance_account_id);
213: END IF;

Line 210: asn_debug.put_line('x_def_charges_account_id' || x_def_charges_account_id);

206:
207: IF (g_asn_debug = 'Y') THEN
208: asn_debug.put_line('x_lcm_account_id' || x_lcm_account_id);
209: asn_debug.put_line('x_tax_variance_account_id' || x_tax_variance_account_id);
210: asn_debug.put_line('x_def_charges_account_id' || x_def_charges_account_id);
211: asn_debug.put_line('x_exchange_variance_account_id' || x_exchange_variance_account_id);
212: asn_debug.put_line('x_inv_variance_account_id' || x_inv_variance_account_id);
213: END IF;
214:

Line 211: asn_debug.put_line('x_exchange_variance_account_id' || x_exchange_variance_account_id);

207: IF (g_asn_debug = 'Y') THEN
208: asn_debug.put_line('x_lcm_account_id' || x_lcm_account_id);
209: asn_debug.put_line('x_tax_variance_account_id' || x_tax_variance_account_id);
210: asn_debug.put_line('x_def_charges_account_id' || x_def_charges_account_id);
211: asn_debug.put_line('x_exchange_variance_account_id' || x_exchange_variance_account_id);
212: asn_debug.put_line('x_inv_variance_account_id' || x_inv_variance_account_id);
213: END IF;
214:
215: EXCEPTION

Line 212: asn_debug.put_line('x_inv_variance_account_id' || x_inv_variance_account_id);

208: asn_debug.put_line('x_lcm_account_id' || x_lcm_account_id);
209: asn_debug.put_line('x_tax_variance_account_id' || x_tax_variance_account_id);
210: asn_debug.put_line('x_def_charges_account_id' || x_def_charges_account_id);
211: asn_debug.put_line('x_exchange_variance_account_id' || x_exchange_variance_account_id);
212: asn_debug.put_line('x_inv_variance_account_id' || x_inv_variance_account_id);
213: END IF;
214:
215: EXCEPTION
216: WHEN OTHERS THEN

Line 223: IF (g_asn_debug = 'Y') THEN

219: x_def_charges_account_id := null;
220: x_exchange_variance_account_id := null;
221: x_inv_variance_account_id := null;
222:
223: IF (g_asn_debug = 'Y') THEN
224: asn_debug.put_line('Error in Get_RtLcmInfo: ' || x_progress);
225: END IF;
226: END Get_RtLcmInfo;
227:

Line 224: asn_debug.put_line('Error in Get_RtLcmInfo: ' || x_progress);

220: x_exchange_variance_account_id := null;
221: x_inv_variance_account_id := null;
222:
223: IF (g_asn_debug = 'Y') THEN
224: asn_debug.put_line('Error in Get_RtLcmInfo: ' || x_progress);
225: END IF;
226: END Get_RtLcmInfo;
227:
228: END RCV_UTILITIES;