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.ARP_TAX_VIEW_VERTEX dependencies on FND_LOG

Line 7: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3:
4: USE_SHIP_TO_GEO CONSTANT VARCHAR2(10) := 'XXXXXXXXX';
5: USE_SHIP_TO_INOUT CONSTANT VARCHAR2(10) := 'X';
6:
7: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
11: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 8: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

4: USE_SHIP_TO_GEO CONSTANT VARCHAR2(10) := 'XXXXXXXXX';
5: USE_SHIP_TO_INOUT CONSTANT VARCHAR2(10) := 'X';
6:
7: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
11: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: g_error_buffer VARCHAR2(100);

Line 9: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

5: USE_SHIP_TO_INOUT CONSTANT VARCHAR2(10) := 'X';
6:
7: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
11: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: g_error_buffer VARCHAR2(100);
13:

Line 10: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

6:
7: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
11: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: g_error_buffer VARCHAR2(100);
13:
14:

Line 11: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

7: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
9: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
11: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: g_error_buffer VARCHAR2(100);
13:
14:
15:

Line 43: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.PRODUCT_CODE',

39: p_memo_line_id IN NUMBER)
40: RETURN VARCHAR2 IS
41: BEGIN
42: IF (g_level_procedure >= g_current_runtime_level ) THEN
43: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.PRODUCT_CODE',
44: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.PRODUCT_CODE(+)');
45: END IF;
46:
47: RETURN NULL;

Line 50: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.PRODUCT_CODE',

46:
47: RETURN NULL;
48:
49: IF (g_level_procedure >= g_current_runtime_level ) THEN
50: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.PRODUCT_CODE',
51: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.PRODUCT_CODE(-)');
52: END IF;
53:
54: END PRODUCT_CODE;

Line 78: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.VENDOR_CONTROL_EXEMPTIONS',

74: p_trx_type_id IN Number)
75: return VARCHAR2 is
76: begin
77: IF (g_level_procedure >= g_current_runtime_level ) THEN
78: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.VENDOR_CONTROL_EXEMPTIONS',
79: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.VENDOR_CONTROL_EXEMPTIONS(+)');
80: END IF;
81: IF (g_level_statement >= g_current_runtime_level ) THEN
82: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.VENDOR_CONTROL_EXEMPTIONS',

Line 82: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.VENDOR_CONTROL_EXEMPTIONS',

78: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.VENDOR_CONTROL_EXEMPTIONS',
79: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.VENDOR_CONTROL_EXEMPTIONS(+)');
80: END IF;
81: IF (g_level_statement >= g_current_runtime_level ) THEN
82: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.VENDOR_CONTROL_EXEMPTIONS',
83: 'p_view_name = '||p_view_name||' p_header_id = '||to_char(p_header_id)||' p_line_id = '||to_char(p_line_id));
84: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.VENDOR_CONTROL_EXEMPTIONS',
85: 'p_trx_type_id = '||to_char(p_trx_type_id));
86: END IF;

Line 84: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.VENDOR_CONTROL_EXEMPTIONS',

80: END IF;
81: IF (g_level_statement >= g_current_runtime_level ) THEN
82: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.VENDOR_CONTROL_EXEMPTIONS',
83: 'p_view_name = '||p_view_name||' p_header_id = '||to_char(p_header_id)||' p_line_id = '||to_char(p_line_id));
84: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.VENDOR_CONTROL_EXEMPTIONS',
85: 'p_trx_type_id = '||to_char(p_trx_type_id));
86: END IF;
87: return null;
88: exception

Line 92: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.VENDOR_CONTROL_EXEMPTIONS EXCEPTION ERROR:',

88: exception
89: when others then
90: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
91: IF (g_level_unexpected >= g_current_runtime_level ) THEN
92: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.VENDOR_CONTROL_EXEMPTIONS EXCEPTION ERROR:',
93: g_error_buffer);
94: END IF;
95: end vendor_control_exemptions;
96:

Line 120: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.COMPANY_CODE',

116: p_line_id IN Number)
117: return VARCHAR2 is
118: begin
119: IF (g_level_procedure >= g_current_runtime_level ) THEN
120: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.COMPANY_CODE',
121: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.COMPANY_CODE(+)');
122: END IF;
123: IF (g_level_statement >= g_current_runtime_level ) THEN
124: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.COMPANY_CODE',

Line 124: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.COMPANY_CODE',

120: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.COMPANY_CODE',
121: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.COMPANY_CODE(+)');
122: END IF;
123: IF (g_level_statement >= g_current_runtime_level ) THEN
124: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.COMPANY_CODE',
125: 'p_view_name = '||p_view_name||' p_header_id = '||to_char(p_header_id)||' p_line_id = '||to_char(p_line_id));
126: END IF;
127: return NULL;
128: exception

Line 132: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.COMPANY_CODE EXCEPTION ERROR:',

128: exception
129: when others then
130: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
131: IF (g_level_unexpected >= g_current_runtime_level ) THEN
132: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.COMPANY_CODE EXCEPTION ERROR:',
133: g_error_buffer);
134: END IF;
135: end company_code;
136:

Line 159: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.DIVISION_CODE',

155: p_line_id IN Number)
156: return VARCHAR2 is
157: begin
158: IF (g_level_procedure >= g_current_runtime_level ) THEN
159: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.DIVISION_CODE',
160: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.DIVISION_CODE(+)');
161: END IF;
162: IF (g_level_statement >= g_current_runtime_level ) THEN
163: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.DIVISION_CODE',

Line 163: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.DIVISION_CODE',

159: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.DIVISION_CODE',
160: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.DIVISION_CODE(+)');
161: END IF;
162: IF (g_level_statement >= g_current_runtime_level ) THEN
163: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.DIVISION_CODE',
164: 'p_view_name = '||p_view_name||' p_header_id = '||to_char(p_header_id)||' p_line_id = '||to_char(p_line_id));
165: END IF;
166: return '01';
167: exception

Line 171: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.DIVISION_CODE EXCEPTION ERROR:',

167: exception
168: when others then
169: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
170: IF (g_level_unexpected >= g_current_runtime_level ) THEN
171: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.DIVISION_CODE EXCEPTION ERROR:',
172: g_error_buffer);
173: END IF;
174: end division_code;
175:

Line 198: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TRX_LINE_TYPE',

194: p_line_id IN Number)
195: return VARCHAR2 is
196: begin
197: IF (g_level_procedure >= g_current_runtime_level ) THEN
198: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TRX_LINE_TYPE',
199: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TRX_LINE_TYPE(+)');
200: END IF;
201: IF (g_level_statement >= g_current_runtime_level ) THEN
202: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TRX_LINE_TYPE',

Line 202: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TRX_LINE_TYPE',

198: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TRX_LINE_TYPE',
199: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TRX_LINE_TYPE(+)');
200: END IF;
201: IF (g_level_statement >= g_current_runtime_level ) THEN
202: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TRX_LINE_TYPE',
203: 'p_view_name = '||p_view_name||' p_header_id = '||to_char(p_header_id)||' p_line_id = '||to_char(p_line_id));
204: END IF;
205: return NULL;
206: exception

Line 210: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TRX_LINE_TYPE EXCEPTION ERROR:',

206: exception
207: when others then
208: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
209: IF (g_level_unexpected >= g_current_runtime_level ) THEN
210: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TRX_LINE_TYPE EXCEPTION ERROR:',
211: g_error_buffer);
212: END IF;
213: end trx_line_type;
214:

Line 237: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CLASS',

233: p_customer_id IN Number)
234: return VARCHAR2 is
235: begin
236: IF (g_level_procedure >= g_current_runtime_level ) THEN
237: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CLASS',
238: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CLASS(+)');
239: END IF;
240: IF (g_level_statement >= g_current_runtime_level ) THEN
241: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CLASS',

Line 241: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CLASS',

237: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CLASS',
238: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CLASS(+)');
239: END IF;
240: IF (g_level_statement >= g_current_runtime_level ) THEN
241: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CLASS',
242: 'p_view_name = '||p_view_name||' p_header_id = '||to_char(p_header_id)||' p_line_id = '||to_char(p_line_id));
243: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CLASS',
244: 'p_customer_id = '||to_char(p_customer_id));
245: END IF;

Line 243: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CLASS',

239: END IF;
240: IF (g_level_statement >= g_current_runtime_level ) THEN
241: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CLASS',
242: 'p_view_name = '||p_view_name||' p_header_id = '||to_char(p_header_id)||' p_line_id = '||to_char(p_line_id));
243: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CLASS',
244: 'p_customer_id = '||to_char(p_customer_id));
245: END IF;
246: return null;
247: exception

Line 251: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CLASS EXCEPTION ERROR:',

247: exception
248: when others then
249: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
250: IF (g_level_unexpected >= g_current_runtime_level ) THEN
251: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CLASS EXCEPTION ERROR:',
252: g_error_buffer);
253: END IF;
254: end customer_class;
255:

Line 285: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.GET_EXEMPTIONS',

281: p_District_Exempt_Reason Out NOCOPY Varchar2)
282: IS
283: BEGIN
284: IF (g_level_procedure >= g_current_runtime_level ) THEN
285: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.GET_EXEMPTIONS',
286: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.GET_EXEMPTIONS(+)');
287: END IF;
288:
289: p_cert_no := null;

Line 302: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.GET_EXEMPTIONS',

298: p_City_Exempt_Reason := null;
299: p_District_Exempt_Reason := null;
300:
301: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
302: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.GET_EXEMPTIONS',
303: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.GET_EXEMPTIONS(-)');
304: END IF;
305:
306: END GET_EXEMPTIONS;

Line 331: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POO_ADDRESS_CODE',

327: p_line_id IN Number)
328: return Varchar2 is
329: begin
330: IF (g_level_procedure >= g_current_runtime_level ) THEN
331: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POO_ADDRESS_CODE',
332: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POO_ADDRESS_CODE(+)');
333: END IF;
334: IF (g_level_statement >= g_current_runtime_level ) THEN
335: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POO_ADDRESS_CODE',

Line 335: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POO_ADDRESS_CODE',

331: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POO_ADDRESS_CODE',
332: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POO_ADDRESS_CODE(+)');
333: END IF;
334: IF (g_level_statement >= g_current_runtime_level ) THEN
335: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POO_ADDRESS_CODE',
336: 'p_view_name = '||p_view_name||' p_header_id = '||to_char(p_header_id)||' p_line_id = '||to_char(p_line_id));
337: END IF;
338: return null;
339: exception

Line 343: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POO_ADDRESS_CODE EXCEPTION ERROR:',

339: exception
340: when others then
341: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
342: IF (g_level_unexpected >= g_current_runtime_level ) THEN
343: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POO_ADDRESS_CODE EXCEPTION ERROR:',
344: g_error_buffer);
345: END IF;
346:
347: end POO_ADDRESS_CODE;

Line 374: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POA_GEOCODE',

370: p_salesrep_id IN Number)
371: return Varchar2 is
372: begin
373: IF (g_level_procedure >= g_current_runtime_level ) THEN
374: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POA_GEOCODE',
375: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POA_GEOCODE(+)');
376: END IF;
377: IF (g_level_statement >= g_current_runtime_level ) THEN
378: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POA_GEOCODE',

Line 378: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POA_GEOCODE',

374: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POA_GEOCODE',
375: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POA_GEOCODE(+)');
376: END IF;
377: IF (g_level_statement >= g_current_runtime_level ) THEN
378: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POA_GEOCODE',
379: 'p_view_name = '||p_view_name||' p_header_id = '||to_char(p_header_id)||' p_line_id = '||to_char(p_line_id));
380: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POO_GEOCODE',
381: 'p_salesrep_id = '||to_char(p_salesrep_id));
382: END IF;

Line 380: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POO_GEOCODE',

376: END IF;
377: IF (g_level_statement >= g_current_runtime_level ) THEN
378: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POA_GEOCODE',
379: 'p_view_name = '||p_view_name||' p_header_id = '||to_char(p_header_id)||' p_line_id = '||to_char(p_line_id));
380: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POO_GEOCODE',
381: 'p_salesrep_id = '||to_char(p_salesrep_id));
382: END IF;
383: return NULL;
384: exception

Line 388: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POA_GEOCODE EXCEPTION ERROR:',

384: exception
385: when others then
386: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
387: IF (g_level_unexpected >= g_current_runtime_level ) THEN
388: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.POA_GEOCODE EXCEPTION ERROR:',
389: g_error_buffer);
390: END IF;
391: end;
392:

Line 416: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_FROM_ADDRESS_CODE',

412: p_warehouse_id IN Number)
413: return Varchar2 is
414: begin
415: IF (g_level_procedure >= g_current_runtime_level ) THEN
416: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_FROM_ADDRESS_CODE',
417: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_FROM_ADDRESS_CODE(+)');
418: END IF;
419: IF (g_level_statement >= g_current_runtime_level ) THEN
420: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_FROM_ADDRESS_CODE',

Line 420: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_FROM_ADDRESS_CODE',

416: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_FROM_ADDRESS_CODE',
417: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_FROM_ADDRESS_CODE(+)');
418: END IF;
419: IF (g_level_statement >= g_current_runtime_level ) THEN
420: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_FROM_ADDRESS_CODE',
421: 'p_view_name = '||p_view_name||' p_header_id = '||to_char(p_header_id)||' p_line_id = '||to_char(p_line_id));
422: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_FROM_ADDRESS_CODE',
423: 'p_warehouse_id = '||to_char(p_warehouse_id));
424: END IF;

Line 422: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_FROM_ADDRESS_CODE',

418: END IF;
419: IF (g_level_statement >= g_current_runtime_level ) THEN
420: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_FROM_ADDRESS_CODE',
421: 'p_view_name = '||p_view_name||' p_header_id = '||to_char(p_header_id)||' p_line_id = '||to_char(p_line_id));
422: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_FROM_ADDRESS_CODE',
423: 'p_warehouse_id = '||to_char(p_warehouse_id));
424: END IF;
425: return NULL;
426: exception

Line 430: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_FROM_ADDRESS_CODE EXCEPTION ERROR:',

426: exception
427: when others then
428: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
429: IF (g_level_unexpected >= g_current_runtime_level ) THEN
430: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_FROM_ADDRESS_CODE EXCEPTION ERROR:',
431: g_error_buffer);
432: END IF;
433: end;
434:

Line 466: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE',

462: /* if arp_process_tax.vendor_installed_flag = 'N' then
463: return NULL;
464: end if;*/
465: IF (g_level_procedure >= g_current_runtime_level ) THEN
466: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE',
467: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE(+)');
468: END IF;
469: IF (g_level_statement >= g_current_runtime_level ) THEN
470: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE',

Line 470: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE',

466: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE',
467: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE(+)');
468: END IF;
469: IF (g_level_statement >= g_current_runtime_level ) THEN
470: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE',
471: 'p_view_name = '||p_view_name||' p_header_id = '||to_char(p_header_id)||' p_line_id = '||to_char(p_line_id));
472: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE',
473: 'p_ship_to_address_id = '||to_char(p_ship_to_address_id)||'p_ship_to_location_id = '||to_char(p_ship_to_location_id));
474: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE',

Line 472: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE',

468: END IF;
469: IF (g_level_statement >= g_current_runtime_level ) THEN
470: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE',
471: 'p_view_name = '||p_view_name||' p_header_id = '||to_char(p_header_id)||' p_line_id = '||to_char(p_line_id));
472: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE',
473: 'p_ship_to_address_id = '||to_char(p_ship_to_address_id)||'p_ship_to_location_id = '||to_char(p_ship_to_location_id));
474: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE',
475: 'p_trx_date = '||p_trx_date||' p_ship_to_state = '||p_ship_to_state||'p_postal_code = '||p_postal_code);
476: END IF;

Line 474: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE',

470: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE',
471: 'p_view_name = '||p_view_name||' p_header_id = '||to_char(p_header_id)||' p_line_id = '||to_char(p_line_id));
472: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE',
473: 'p_ship_to_address_id = '||to_char(p_ship_to_address_id)||'p_ship_to_location_id = '||to_char(p_ship_to_location_id));
474: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE',
475: 'p_trx_date = '||p_trx_date||' p_ship_to_state = '||p_ship_to_state||'p_postal_code = '||p_postal_code);
476: END IF;
477:
478: return NULL;

Line 483: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE EXCEPTION ERROR:',

479: exception
480: when others then
481: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
482: IF (g_level_unexpected >= g_current_runtime_level ) THEN
483: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.SHIP_TO_ADDRESS_CODE EXCEPTION ERROR:',
484: g_error_buffer);
485: END IF;
486: end;
487:

Line 510: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.AUDIT_FLAG',

506: return Varchar2 is
507: l_audit_flag Varchar2(10);
508: begin
509: IF (g_level_procedure >= g_current_runtime_level ) THEN
510: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.AUDIT_FLAG',
511: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.AUDIT_FLAG(+)');
512: END IF;
513: IF (g_level_procedure >= g_current_runtime_level ) THEN
514: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.AUDIT_FLAG',

Line 514: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.AUDIT_FLAG',

510: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.AUDIT_FLAG',
511: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.AUDIT_FLAG(+)');
512: END IF;
513: IF (g_level_procedure >= g_current_runtime_level ) THEN
514: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.AUDIT_FLAG',
515: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.AUDIT_FLAG(-)');
516: END IF;
517: return null;
518: exception

Line 522: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.AUDIT_FLAG EXCEPTION ERROR:',

518: exception
519: When others then
520: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
521: IF (g_level_unexpected >= g_current_runtime_level ) THEN
522: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.AUDIT_FLAG EXCEPTION ERROR:',
523: g_error_buffer);
524: END IF;
525: end audit_flag;
526:

Line 550: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TOTAL_TAX',

546: )
547: return number is
548: begin
549: IF (g_level_procedure >= g_current_runtime_level ) THEN
550: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TOTAL_TAX',
551: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TOTAL_TAX(+)');
552: END IF;
553: IF (g_level_statement >= g_current_runtime_level ) THEN
554: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TOTAL_TAX',

Line 554: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TOTAL_TAX',

550: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TOTAL_TAX',
551: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TOTAL_TAX(+)');
552: END IF;
553: IF (g_level_statement >= g_current_runtime_level ) THEN
554: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TOTAL_TAX',
555: ' p_customer_trx_id = '||to_char(p_customer_trx_id));
556: END IF;
557:
558: return null;

Line 561: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TOTAL_TAX',

557:
558: return null;
559:
560: IF (g_level_procedure >= g_current_runtime_level ) THEN
561: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TOTAL_TAX',
562: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TOTAL_TAX(-)');
563: END IF;
564: exception
565: when others then

Line 593: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CODE',

589: is
590: begin
591: /* Santosh */
592: IF (g_level_procedure >= g_current_runtime_level ) THEN
593: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CODE',
594: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CODE(+)');
595: END IF;
596: IF (g_level_statement >= g_current_runtime_level ) THEN
597: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CODE',

Line 597: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CODE',

593: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CODE',
594: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CODE(+)');
595: END IF;
596: IF (g_level_statement >= g_current_runtime_level ) THEN
597: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CODE',
598: 'p_view_name = '||p_view_name||' p_header_id = '||to_char(p_header_id)||' p_line_id = '||to_char(p_line_id));
599: END IF;
600: return null;
601: exception

Line 605: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CODE EXCEPTION ERROR:',

601: exception
602: when others then
603: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
604: IF (g_level_unexpected >= g_current_runtime_level ) THEN
605: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.CUSTOMER_CODE EXCEPTION ERROR:',
606: g_error_buffer);
607: END IF;
608: end customer_code;
609:

Line 634: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TRANSACTION_DATE',

630: -- Bug 4175816 return DATE
631: is
632: begin
633: IF (g_level_procedure >= g_current_runtime_level ) THEN
634: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TRANSACTION_DATE',
635: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TRANSACTION_DATE(+)');
636: END IF;
637: IF (g_level_statement >= g_current_runtime_level ) THEN
638: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TRANSACTION_DATE',

Line 638: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TRANSACTION_DATE',

634: FND_LOG.STRING(g_level_procedure, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TRANSACTION_DATE',
635: 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TRANSACTION_DATE(+)');
636: END IF;
637: IF (g_level_statement >= g_current_runtime_level ) THEN
638: FND_LOG.STRING(g_level_statement, 'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TRANSACTION_DATE',
639: 'p_view_name = '||p_view_name||' p_header_id = '||to_char(p_header_id)||' p_line_id = '||to_char(p_line_id));
640: END IF;
641: return null;
642: exception

Line 646: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TRANSACTION_DATE EXCEPTION ERROR:',

642: exception
643: when others then
644: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
645: IF (g_level_unexpected >= g_current_runtime_level ) THEN
646: FND_LOG.STRING(g_level_unexpected,'ZX.PARTNER.ARP_TAX_VIEW_VERTEX.TRANSACTION_DATE EXCEPTION ERROR:',
647: g_error_buffer);
648: END IF;
649: end transaction_date;
650: