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_GAPLESS_NUMBERING dependencies on ASN_DEBUG

Line 5: g_asn_debug VARCHAR2(1) := asn_debug.is_debug_on; -- Bug 9152790

1: PACKAGE BODY RCV_GAPLESS_NUMBERING AS
2: /* $Header: RCVSBGNB.pls 120.1.12010000.2 2010/01/25 23:26:52 vthevark ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(32) := 'RCV_GAPLESS_NUMBERING';
5: g_asn_debug VARCHAR2(1) := asn_debug.is_debug_on; -- Bug 9152790
6:
7: PROCEDURE generate_invoice_number (
8: p_api_version IN NUMBER,
9: p_org_id IN NUMBER, -- BugFix 5192878

Line 58: IF (g_asn_debug = 'Y')

54: FOR UPDATE OF next_sequence_number;
55:
56: BEGIN
57:
58: IF (g_asn_debug = 'Y')
59: THEN
60: asn_debug.put_line ( 'Following are input parameters to rcv_gapless_numbering.generate_invoice_number package.');
61: asn_debug.put_line ( 'p_org_id = ' || p_org_id );
62: asn_debug.put_line ( 'p_vendor_site_id = ' || p_vendor_site_id );

Line 60: asn_debug.put_line ( 'Following are input parameters to rcv_gapless_numbering.generate_invoice_number package.');

56: BEGIN
57:
58: IF (g_asn_debug = 'Y')
59: THEN
60: asn_debug.put_line ( 'Following are input parameters to rcv_gapless_numbering.generate_invoice_number package.');
61: asn_debug.put_line ( 'p_org_id = ' || p_org_id );
62: asn_debug.put_line ( 'p_vendor_site_id = ' || p_vendor_site_id );
63: asn_debug.put_line ( 'p_invoice_type = ' || p_invoice_type );
64: END IF;

Line 61: asn_debug.put_line ( 'p_org_id = ' || p_org_id );

57:
58: IF (g_asn_debug = 'Y')
59: THEN
60: asn_debug.put_line ( 'Following are input parameters to rcv_gapless_numbering.generate_invoice_number package.');
61: asn_debug.put_line ( 'p_org_id = ' || p_org_id );
62: asn_debug.put_line ( 'p_vendor_site_id = ' || p_vendor_site_id );
63: asn_debug.put_line ( 'p_invoice_type = ' || p_invoice_type );
64: END IF;
65:

Line 62: asn_debug.put_line ( 'p_vendor_site_id = ' || p_vendor_site_id );

58: IF (g_asn_debug = 'Y')
59: THEN
60: asn_debug.put_line ( 'Following are input parameters to rcv_gapless_numbering.generate_invoice_number package.');
61: asn_debug.put_line ( 'p_org_id = ' || p_org_id );
62: asn_debug.put_line ( 'p_vendor_site_id = ' || p_vendor_site_id );
63: asn_debug.put_line ( 'p_invoice_type = ' || p_invoice_type );
64: END IF;
65:
66: l_progress := '000';

Line 63: asn_debug.put_line ( 'p_invoice_type = ' || p_invoice_type );

59: THEN
60: asn_debug.put_line ( 'Following are input parameters to rcv_gapless_numbering.generate_invoice_number package.');
61: asn_debug.put_line ( 'p_org_id = ' || p_org_id );
62: asn_debug.put_line ( 'p_vendor_site_id = ' || p_vendor_site_id );
63: asn_debug.put_line ( 'p_invoice_type = ' || p_invoice_type );
64: END IF;
65:
66: l_progress := '000';
67:

Line 94: IF (g_asn_debug = 'Y')

90: po_vendors pv
91: WHERE vendor_site_id = p_vendor_site_id
92: AND pvs.vendor_id = pv.vendor_id;
93:
94: IF (g_asn_debug = 'Y')
95: THEN
96: asn_debug.put_line ( 'Vendor_id = ' || l_vendor_id );
97: END IF;
98:

Line 96: asn_debug.put_line ( 'Vendor_id = ' || l_vendor_id );

92: AND pvs.vendor_id = pv.vendor_id;
93:
94: IF (g_asn_debug = 'Y')
95: THEN
96: asn_debug.put_line ( 'Vendor_id = ' || l_vendor_id );
97: END IF;
98:
99: EXCEPTION
100: WHEN OTHERS

Line 102: IF (g_asn_debug = 'Y')

98:
99: EXCEPTION
100: WHEN OTHERS
101: THEN
102: IF (g_asn_debug = 'Y')
103: THEN
104: asn_debug.put_line ( 'Error occured while selecting Vendor_id. Error message is =' || SQLERRM );
105: END IF;
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 104: asn_debug.put_line ( 'Error occured while selecting Vendor_id. Error message is =' || SQLERRM );

100: WHEN OTHERS
101: THEN
102: IF (g_asn_debug = 'Y')
103: THEN
104: asn_debug.put_line ( 'Error occured while selecting Vendor_id. Error message is =' || SQLERRM );
105: END IF;
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END;
108:

Line 115: IF (g_asn_debug = 'Y')

111: INTO l_organization_name
112: FROM hr_organization_units
113: WHERE organization_id = p_org_id;
114:
115: IF (g_asn_debug = 'Y')
116: THEN
117: asn_debug.put_line ( 'Orgnization name = ' || l_organization_name );
118: END IF;
119: EXCEPTION

Line 117: asn_debug.put_line ( 'Orgnization name = ' || l_organization_name );

113: WHERE organization_id = p_org_id;
114:
115: IF (g_asn_debug = 'Y')
116: THEN
117: asn_debug.put_line ( 'Orgnization name = ' || l_organization_name );
118: END IF;
119: EXCEPTION
120: WHEN OTHERS
121: THEN

Line 122: IF (g_asn_debug = 'Y')

118: END IF;
119: EXCEPTION
120: WHEN OTHERS
121: THEN
122: IF (g_asn_debug = 'Y')
123: THEN
124: asn_debug.put_line ( 'Error occured while selecting Organization Name. Error message is =' || SQLERRM );
125: END IF;
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 124: asn_debug.put_line ( 'Error occured while selecting Organization Name. Error message is =' || SQLERRM );

120: WHEN OTHERS
121: THEN
122: IF (g_asn_debug = 'Y')
123: THEN
124: asn_debug.put_line ( 'Error occured while selecting Organization Name. Error message is =' || SQLERRM );
125: END IF;
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END;
128:

Line 136: IF (g_asn_debug = 'Y')

132: INTO l_organization_code
133: FROM mtl_parameters
134: WHERE organization_id = p_org_id;
135:
136: IF (g_asn_debug = 'Y')
137: THEN
138: asn_debug.put_line ( 'Orgnization Code = ' || l_organization_code );
139: END IF;
140:

Line 138: asn_debug.put_line ( 'Orgnization Code = ' || l_organization_code );

134: WHERE organization_id = p_org_id;
135:
136: IF (g_asn_debug = 'Y')
137: THEN
138: asn_debug.put_line ( 'Orgnization Code = ' || l_organization_code );
139: END IF;
140:
141: l_org_code_name := l_organization_code || ': ' || l_organization_name;
142:

Line 149: IF (g_asn_debug = 'Y')

145: THEN
146: l_org_code_name := l_organization_name;
147: WHEN OTHERS
148: THEN
149: IF (g_asn_debug = 'Y')
150: THEN
151: asn_debug.put_line ( 'Error occured while selecting Organization Code. Error message is =' || SQLERRM );
152: END IF;
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 151: asn_debug.put_line ( 'Error occured while selecting Organization Code. Error message is =' || SQLERRM );

147: WHEN OTHERS
148: THEN
149: IF (g_asn_debug = 'Y')
150: THEN
151: asn_debug.put_line ( 'Error occured while selecting Organization Code. Error message is =' || SQLERRM );
152: END IF;
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: END;
155:

Line 173: IF (g_asn_debug = 'Y')

169: l_buying_company_identifier,
170: l_gapless_inv_num_flag_org
171: );
172:
173: IF (g_asn_debug = 'Y')
174: THEN
175: asn_debug.put_line ( 'po_ap_integration_grp.get_invoice_numbering_options returned with status ' || l_return_status);
176: asn_debug.put_line ( 'l_buying_company_identifier = ' || l_buying_company_identifier );
177: asn_debug.put_line ( 'l_gapless_inv_num_flag_org = ' || l_gapless_inv_num_flag_org);

Line 175: asn_debug.put_line ( 'po_ap_integration_grp.get_invoice_numbering_options returned with status ' || l_return_status);

171: );
172:
173: IF (g_asn_debug = 'Y')
174: THEN
175: asn_debug.put_line ( 'po_ap_integration_grp.get_invoice_numbering_options returned with status ' || l_return_status);
176: asn_debug.put_line ( 'l_buying_company_identifier = ' || l_buying_company_identifier );
177: asn_debug.put_line ( 'l_gapless_inv_num_flag_org = ' || l_gapless_inv_num_flag_org);
178: END IF;
179:

Line 176: asn_debug.put_line ( 'l_buying_company_identifier = ' || l_buying_company_identifier );

172:
173: IF (g_asn_debug = 'Y')
174: THEN
175: asn_debug.put_line ( 'po_ap_integration_grp.get_invoice_numbering_options returned with status ' || l_return_status);
176: asn_debug.put_line ( 'l_buying_company_identifier = ' || l_buying_company_identifier );
177: asn_debug.put_line ( 'l_gapless_inv_num_flag_org = ' || l_gapless_inv_num_flag_org);
178: END IF;
179:
180: l_progress := '030';

Line 177: asn_debug.put_line ( 'l_gapless_inv_num_flag_org = ' || l_gapless_inv_num_flag_org);

173: IF (g_asn_debug = 'Y')
174: THEN
175: asn_debug.put_line ( 'po_ap_integration_grp.get_invoice_numbering_options returned with status ' || l_return_status);
176: asn_debug.put_line ( 'l_buying_company_identifier = ' || l_buying_company_identifier );
177: asn_debug.put_line ( 'l_gapless_inv_num_flag_org = ' || l_gapless_inv_num_flag_org);
178: END IF;
179:
180: l_progress := '030';
181:

Line 188: IF (g_asn_debug = 'Y')

184: l_selling_company_identifier
185: );
186: l_progress := '040';
187:
188: IF (g_asn_debug = 'Y')
189: THEN
190: asn_debug.put_line ( 'AP_PO_GAPLESS_SBI_PKG.site_uses_gapless_num returned with status ' || l_return_status);
191: asn_debug.put_line ( 'l_gapless_inv_num_flag_sup = ' || l_gapless_inv_num_flag_sup );
192: asn_debug.put_line ( 'l_selling_company_identifier = ' || l_selling_company_identifier);

Line 190: asn_debug.put_line ( 'AP_PO_GAPLESS_SBI_PKG.site_uses_gapless_num returned with status ' || l_return_status);

186: l_progress := '040';
187:
188: IF (g_asn_debug = 'Y')
189: THEN
190: asn_debug.put_line ( 'AP_PO_GAPLESS_SBI_PKG.site_uses_gapless_num returned with status ' || l_return_status);
191: asn_debug.put_line ( 'l_gapless_inv_num_flag_sup = ' || l_gapless_inv_num_flag_sup );
192: asn_debug.put_line ( 'l_selling_company_identifier = ' || l_selling_company_identifier);
193: END IF;
194:

Line 191: asn_debug.put_line ( 'l_gapless_inv_num_flag_sup = ' || l_gapless_inv_num_flag_sup );

187:
188: IF (g_asn_debug = 'Y')
189: THEN
190: asn_debug.put_line ( 'AP_PO_GAPLESS_SBI_PKG.site_uses_gapless_num returned with status ' || l_return_status);
191: asn_debug.put_line ( 'l_gapless_inv_num_flag_sup = ' || l_gapless_inv_num_flag_sup );
192: asn_debug.put_line ( 'l_selling_company_identifier = ' || l_selling_company_identifier);
193: END IF;
194:
195: -- End of code BugFix 5197828

Line 192: asn_debug.put_line ( 'l_selling_company_identifier = ' || l_selling_company_identifier);

188: IF (g_asn_debug = 'Y')
189: THEN
190: asn_debug.put_line ( 'AP_PO_GAPLESS_SBI_PKG.site_uses_gapless_num returned with status ' || l_return_status);
191: asn_debug.put_line ( 'l_gapless_inv_num_flag_sup = ' || l_gapless_inv_num_flag_sup );
192: asn_debug.put_line ( 'l_selling_company_identifier = ' || l_selling_company_identifier);
193: END IF;
194:
195: -- End of code BugFix 5197828
196:

Line 205: IF (g_asn_debug = 'Y')

201: END IF;
202:
203: IF (l_buying_company_identifier is null) THEN
204:
205: IF (g_asn_debug = 'Y')
206: THEN
207: asn_debug.put_line ( 'Buying company identofier not defined loggeing error. for organization ' || l_org_code_name );
208: END IF;
209:

Line 207: asn_debug.put_line ( 'Buying company identofier not defined loggeing error. for organization ' || l_org_code_name );

203: IF (l_buying_company_identifier is null) THEN
204:
205: IF (g_asn_debug = 'Y')
206: THEN
207: asn_debug.put_line ( 'Buying company identofier not defined loggeing error. for organization ' || l_org_code_name );
208: END IF;
209:
210: FND_MESSAGE.set_name('PO','RCV_NO_BUYING_COMPANY_ID');
211: FND_MESSAGE.SET_TOKEN('ORGCODENAME', l_org_code_name); -- Bugfix 5197828

Line 217: IF (g_asn_debug = 'Y')

213: RAISE invoice_exception;
214: END IF;
215:
216: IF (l_selling_company_identifier is null) THEN
217: IF (g_asn_debug = 'Y')
218: THEN
219: asn_debug.put_line ( 'Selling company identofier not defined loggeing error. for vendor '
220: || l_vendor_name || ' and vendor site = ' || l_vendor_site_code );
221: END IF;

Line 219: asn_debug.put_line ( 'Selling company identofier not defined loggeing error. for vendor '

215:
216: IF (l_selling_company_identifier is null) THEN
217: IF (g_asn_debug = 'Y')
218: THEN
219: asn_debug.put_line ( 'Selling company identofier not defined loggeing error. for vendor '
220: || l_vendor_name || ' and vendor site = ' || l_vendor_site_code );
221: END IF;
222:
223: FND_MESSAGE.set_name('PO','RCV_NO_SELLING_COMPANY_ID');