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.ARI_SELF_REG_CONFIG dependencies on STANDARD

Line 47: arp_standard.debug(' customer site use id :: '||p_customer_site_use_id);

43:
44: cust_site_rec cust_site_cur%ROWTYPE;
45: BEGIN
46:
47: arp_standard.debug(' customer site use id :: '||p_customer_site_use_id);
48: arp_standard.debug(' customer Id :: '||p_customer_id);
49: /*
50: Customize this portion to specify the parameters for different
51: customers/customer sites

Line 48: arp_standard.debug(' customer Id :: '||p_customer_id);

44: cust_site_rec cust_site_cur%ROWTYPE;
45: BEGIN
46:
47: arp_standard.debug(' customer site use id :: '||p_customer_site_use_id);
48: arp_standard.debug(' customer Id :: '||p_customer_id);
49: /*
50: Customize this portion to specify the parameters for different
51: customers/customer sites
52: */

Line 94: arp_standard.debug(' question1 - attribute15 :: '||FUN_RULE_PUB.get_attribute15||' answer table1 - attribute14 :: '||FUN_RULE_PUB.get_attribute14||' answer column1 - attribute13 :: '||FUN_RULE_PUB.get_attribute13);

90: -- begin added for bug 7713325
91:
92: IF (FUN_RULE_PUB.get_attribute15 is not null) THEN
93:
94: arp_standard.debug(' question1 - attribute15 :: '||FUN_RULE_PUB.get_attribute15||' answer table1 - attribute14 :: '||FUN_RULE_PUB.get_attribute14||' answer column1 - attribute13 :: '||FUN_RULE_PUB.get_attribute13);
95: arp_standard.debug('answer join column1 - attribute12 :: '||FUN_RULE_PUB.get_attribute12||' hz party sites join column1 - attribute11 :: '||FUN_RULE_PUB.get_attribute11);
96:
97: l_answer := validate_access(p_customer_id,p_customer_site_use_id,FUN_RULE_PUB.get_attribute14,FUN_RULE_PUB.get_attribute13,FUN_RULE_PUB.get_attribute12,FUN_RULE_PUB.get_attribute11);
98:

Line 95: arp_standard.debug('answer join column1 - attribute12 :: '||FUN_RULE_PUB.get_attribute12||' hz party sites join column1 - attribute11 :: '||FUN_RULE_PUB.get_attribute11);

91:
92: IF (FUN_RULE_PUB.get_attribute15 is not null) THEN
93:
94: arp_standard.debug(' question1 - attribute15 :: '||FUN_RULE_PUB.get_attribute15||' answer table1 - attribute14 :: '||FUN_RULE_PUB.get_attribute14||' answer column1 - attribute13 :: '||FUN_RULE_PUB.get_attribute13);
95: arp_standard.debug('answer join column1 - attribute12 :: '||FUN_RULE_PUB.get_attribute12||' hz party sites join column1 - attribute11 :: '||FUN_RULE_PUB.get_attribute11);
96:
97: l_answer := validate_access(p_customer_id,p_customer_site_use_id,FUN_RULE_PUB.get_attribute14,FUN_RULE_PUB.get_attribute13,FUN_RULE_PUB.get_attribute12,FUN_RULE_PUB.get_attribute11);
98:
99: arp_standard.debug('l_answer :: '||l_answer);

Line 99: arp_standard.debug('l_answer :: '||l_answer);

95: arp_standard.debug('answer join column1 - attribute12 :: '||FUN_RULE_PUB.get_attribute12||' hz party sites join column1 - attribute11 :: '||FUN_RULE_PUB.get_attribute11);
96:
97: l_answer := validate_access(p_customer_id,p_customer_site_use_id,FUN_RULE_PUB.get_attribute14,FUN_RULE_PUB.get_attribute13,FUN_RULE_PUB.get_attribute12,FUN_RULE_PUB.get_attribute11);
98:
99: arp_standard.debug('l_answer :: '||l_answer);
100:
101: x_verify_access(i).question := FUN_RULE_PUB.get_attribute15;
102: x_verify_access(i).expected_answer := l_answer;
103:

Line 104: arp_standard.debug('Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);

100:
101: x_verify_access(i).question := FUN_RULE_PUB.get_attribute15;
102: x_verify_access(i).expected_answer := l_answer;
103:
104: arp_standard.debug('Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);
105:
106: i := i+1;
107:
108: END IF;

Line 112: arp_standard.debug('question2 - attribute10 :: '||FUN_RULE_PUB.get_attribute10||' answer table2 - attribute9 :: '||FUN_RULE_PUB.get_attribute9||' answer column2 - attribute8 :: '||FUN_RULE_PUB.get_attribute8);

108: END IF;
109:
110: IF (FUN_RULE_PUB.get_attribute10 is not null and FUN_RULE_PUB.get_attribute6 is not null) THEN -- to confirm that 2nd custom question is defined
111:
112: arp_standard.debug('question2 - attribute10 :: '||FUN_RULE_PUB.get_attribute10||' answer table2 - attribute9 :: '||FUN_RULE_PUB.get_attribute9||' answer column2 - attribute8 :: '||FUN_RULE_PUB.get_attribute8);
113: arp_standard.debug(' answer join column2 - attribute7 :: '||FUN_RULE_PUB.get_attribute7||' hz join column2 - attribute6 :: '||FUN_RULE_PUB.get_attribute6);
114:
115: l_answer := validate_access(p_customer_id,p_customer_site_use_id,FUN_RULE_PUB.get_attribute9,FUN_RULE_PUB.get_attribute8,FUN_RULE_PUB.get_attribute7,FUN_RULE_PUB.get_attribute6);
116:

Line 113: arp_standard.debug(' answer join column2 - attribute7 :: '||FUN_RULE_PUB.get_attribute7||' hz join column2 - attribute6 :: '||FUN_RULE_PUB.get_attribute6);

109:
110: IF (FUN_RULE_PUB.get_attribute10 is not null and FUN_RULE_PUB.get_attribute6 is not null) THEN -- to confirm that 2nd custom question is defined
111:
112: arp_standard.debug('question2 - attribute10 :: '||FUN_RULE_PUB.get_attribute10||' answer table2 - attribute9 :: '||FUN_RULE_PUB.get_attribute9||' answer column2 - attribute8 :: '||FUN_RULE_PUB.get_attribute8);
113: arp_standard.debug(' answer join column2 - attribute7 :: '||FUN_RULE_PUB.get_attribute7||' hz join column2 - attribute6 :: '||FUN_RULE_PUB.get_attribute6);
114:
115: l_answer := validate_access(p_customer_id,p_customer_site_use_id,FUN_RULE_PUB.get_attribute9,FUN_RULE_PUB.get_attribute8,FUN_RULE_PUB.get_attribute7,FUN_RULE_PUB.get_attribute6);
116:
117: x_verify_access(i).question := FUN_RULE_PUB.get_attribute10;

Line 120: arp_standard.debug('Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);

116:
117: x_verify_access(i).question := FUN_RULE_PUB.get_attribute10;
118: x_verify_access(i).expected_answer := l_answer;
119:
120: arp_standard.debug('Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);
121:
122: i := i+1;
123:
124: END IF; --IF (FUN_RULE_PUB.get_attribute6 is not null) THEN

Line 128: arp_standard.debug('question3 - attribute5 :: '||FUN_RULE_PUB.get_attribute5||' answer table3 - attribute4 :: '||FUN_RULE_PUB.get_attribute4||' answer column3 - attribute3 :: '||FUN_RULE_PUB.get_attribute3);

124: END IF; --IF (FUN_RULE_PUB.get_attribute6 is not null) THEN
125:
126: IF (FUN_RULE_PUB.get_attribute5 is not null and FUN_RULE_PUB.get_attribute1 is not null) THEN -- to confirm that 3 rd custom question is defined
127:
128: arp_standard.debug('question3 - attribute5 :: '||FUN_RULE_PUB.get_attribute5||' answer table3 - attribute4 :: '||FUN_RULE_PUB.get_attribute4||' answer column3 - attribute3 :: '||FUN_RULE_PUB.get_attribute3);
129: arp_standard.debug(' answer join column3 - attribute2 :: '||FUN_RULE_PUB.get_attribute2||' hz join column3 - attribute1 :: '||FUN_RULE_PUB.get_attribute1);
130: l_answer := validate_access(p_customer_id,p_customer_site_use_id,FUN_RULE_PUB.get_attribute4,FUN_RULE_PUB.get_attribute3,FUN_RULE_PUB.get_attribute2,FUN_RULE_PUB.get_attribute1);
131:
132: x_verify_access(i).question := FUN_RULE_PUB.get_attribute5;

Line 129: arp_standard.debug(' answer join column3 - attribute2 :: '||FUN_RULE_PUB.get_attribute2||' hz join column3 - attribute1 :: '||FUN_RULE_PUB.get_attribute1);

125:
126: IF (FUN_RULE_PUB.get_attribute5 is not null and FUN_RULE_PUB.get_attribute1 is not null) THEN -- to confirm that 3 rd custom question is defined
127:
128: arp_standard.debug('question3 - attribute5 :: '||FUN_RULE_PUB.get_attribute5||' answer table3 - attribute4 :: '||FUN_RULE_PUB.get_attribute4||' answer column3 - attribute3 :: '||FUN_RULE_PUB.get_attribute3);
129: arp_standard.debug(' answer join column3 - attribute2 :: '||FUN_RULE_PUB.get_attribute2||' hz join column3 - attribute1 :: '||FUN_RULE_PUB.get_attribute1);
130: l_answer := validate_access(p_customer_id,p_customer_site_use_id,FUN_RULE_PUB.get_attribute4,FUN_RULE_PUB.get_attribute3,FUN_RULE_PUB.get_attribute2,FUN_RULE_PUB.get_attribute1);
131:
132: x_verify_access(i).question := FUN_RULE_PUB.get_attribute5;
133: x_verify_access(i).expected_answer := l_answer;

Line 135: arp_standard.debug('Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);

131:
132: x_verify_access(i).question := FUN_RULE_PUB.get_attribute5;
133: x_verify_access(i).expected_answer := l_answer;
134:
135: arp_standard.debug('Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);
136:
137: i := i+1;
138:
139: END IF; --IF (FUN_RULE_PUB.get_attribute11 is not null) THEN

Line 279: arp_standard.debug('Begin procedure validate_cust_detail_access ');

275: /*
276: Customize this portion to specify the parameters for different
277: customers
278: */
279: arp_standard.debug('Begin procedure validate_cust_detail_access ');
280: FUN_RULE_PUB.init_parameter_list;
281: FUN_RULE_PUB.add_parameter('ARI_CUSTOMER_ID', to_char(p_customer_id));
282: FUN_RULE_PUB.apply_rule('AR','ARI_VALIDATE_CUST_ACCESS');
283:

Line 289: arp_standard.debug(' question1 - attribute1 :: '||FUN_RULE_PUB.get_attribute1||' answer table1 - attribute2 '||FUN_RULE_PUB.get_attribute2||' answer column1 - attribute3 '||FUN_RULE_PUB.get_attribute3);

285:
286: IF (FUN_RULE_PUB.get_attribute1 is not null) THEN
287: IF (FUN_RULE_PUB.get_attribute5 is not null) THEN -- to confirm that 1 st custom question is defined
288:
289: arp_standard.debug(' question1 - attribute1 :: '||FUN_RULE_PUB.get_attribute1||' answer table1 - attribute2 '||FUN_RULE_PUB.get_attribute2||' answer column1 - attribute3 '||FUN_RULE_PUB.get_attribute3);
290: arp_standard.debug(' answer join column1 - attribute4 '||FUN_RULE_PUB.get_attribute4||' hz join column1 - attribute5 '||FUN_RULE_PUB.get_attribute5);
291:
292: l_answer := validate_access(p_customer_id,'CUST_LEVEL',FUN_RULE_PUB.get_attribute2,FUN_RULE_PUB.get_attribute3,FUN_RULE_PUB.get_attribute4,FUN_RULE_PUB.get_attribute5);
293: arp_standard.debug('l_answer :: '||l_answer);

Line 290: arp_standard.debug(' answer join column1 - attribute4 '||FUN_RULE_PUB.get_attribute4||' hz join column1 - attribute5 '||FUN_RULE_PUB.get_attribute5);

286: IF (FUN_RULE_PUB.get_attribute1 is not null) THEN
287: IF (FUN_RULE_PUB.get_attribute5 is not null) THEN -- to confirm that 1 st custom question is defined
288:
289: arp_standard.debug(' question1 - attribute1 :: '||FUN_RULE_PUB.get_attribute1||' answer table1 - attribute2 '||FUN_RULE_PUB.get_attribute2||' answer column1 - attribute3 '||FUN_RULE_PUB.get_attribute3);
290: arp_standard.debug(' answer join column1 - attribute4 '||FUN_RULE_PUB.get_attribute4||' hz join column1 - attribute5 '||FUN_RULE_PUB.get_attribute5);
291:
292: l_answer := validate_access(p_customer_id,'CUST_LEVEL',FUN_RULE_PUB.get_attribute2,FUN_RULE_PUB.get_attribute3,FUN_RULE_PUB.get_attribute4,FUN_RULE_PUB.get_attribute5);
293: arp_standard.debug('l_answer :: '||l_answer);
294:

Line 293: arp_standard.debug('l_answer :: '||l_answer);

289: arp_standard.debug(' question1 - attribute1 :: '||FUN_RULE_PUB.get_attribute1||' answer table1 - attribute2 '||FUN_RULE_PUB.get_attribute2||' answer column1 - attribute3 '||FUN_RULE_PUB.get_attribute3);
290: arp_standard.debug(' answer join column1 - attribute4 '||FUN_RULE_PUB.get_attribute4||' hz join column1 - attribute5 '||FUN_RULE_PUB.get_attribute5);
291:
292: l_answer := validate_access(p_customer_id,'CUST_LEVEL',FUN_RULE_PUB.get_attribute2,FUN_RULE_PUB.get_attribute3,FUN_RULE_PUB.get_attribute4,FUN_RULE_PUB.get_attribute5);
293: arp_standard.debug('l_answer :: '||l_answer);
294:
295: elsif (FUN_RULE_PUB.get_attribute2 is not null) then -- IF (FUN_RULE_PUB.get_attribute5 is not null) THEN
296: l_answer := FUN_RULE_PUB.get_attribute2;
297: arp_standard.debug('l_answer for static question '||l_answer);

Line 297: arp_standard.debug('l_answer for static question '||l_answer);

293: arp_standard.debug('l_answer :: '||l_answer);
294:
295: elsif (FUN_RULE_PUB.get_attribute2 is not null) then -- IF (FUN_RULE_PUB.get_attribute5 is not null) THEN
296: l_answer := FUN_RULE_PUB.get_attribute2;
297: arp_standard.debug('l_answer for static question '||l_answer);
298: END IF; --IF (FUN_RULE_PUB.get_attribute5 is not null) THEN
299:
300: x_verify_access(i).question := FUN_RULE_PUB.get_attribute1;
301: x_verify_access(i).expected_answer := l_answer;

Line 303: arp_standard.debug('Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);

299:
300: x_verify_access(i).question := FUN_RULE_PUB.get_attribute1;
301: x_verify_access(i).expected_answer := l_answer;
302:
303: arp_standard.debug('Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);
304: i := i+1;
305:
306: END IF; --IF (FUN_RULE_PUB.get_attribute1 is not null) THEN
307:

Line 310: arp_standard.debug('question2 - attribute6 :: '||FUN_RULE_PUB.get_attribute6||' answer table2 - attribute7 '||FUN_RULE_PUB.get_attribute7||' answer column2 - attribute8 '||FUN_RULE_PUB.get_attribute8);

306: END IF; --IF (FUN_RULE_PUB.get_attribute1 is not null) THEN
307:
308: IF (FUN_RULE_PUB.get_attribute6 is not null and FUN_RULE_PUB.get_attribute10 is not null) THEN -- to confirm that 2nd custom question is defined
309:
310: arp_standard.debug('question2 - attribute6 :: '||FUN_RULE_PUB.get_attribute6||' answer table2 - attribute7 '||FUN_RULE_PUB.get_attribute7||' answer column2 - attribute8 '||FUN_RULE_PUB.get_attribute8);
311: arp_standard.debug('answer join column2 - attribute9 '||FUN_RULE_PUB.get_attribute9||' hz join column2 - attribute10 '||FUN_RULE_PUB.get_attribute10);
312:
313: l_answer := validate_access(p_customer_id,'CUST_LEVEL',FUN_RULE_PUB.get_attribute7,FUN_RULE_PUB.get_attribute8,FUN_RULE_PUB.get_attribute9,FUN_RULE_PUB.get_attribute10);
314:

Line 311: arp_standard.debug('answer join column2 - attribute9 '||FUN_RULE_PUB.get_attribute9||' hz join column2 - attribute10 '||FUN_RULE_PUB.get_attribute10);

307:
308: IF (FUN_RULE_PUB.get_attribute6 is not null and FUN_RULE_PUB.get_attribute10 is not null) THEN -- to confirm that 2nd custom question is defined
309:
310: arp_standard.debug('question2 - attribute6 :: '||FUN_RULE_PUB.get_attribute6||' answer table2 - attribute7 '||FUN_RULE_PUB.get_attribute7||' answer column2 - attribute8 '||FUN_RULE_PUB.get_attribute8);
311: arp_standard.debug('answer join column2 - attribute9 '||FUN_RULE_PUB.get_attribute9||' hz join column2 - attribute10 '||FUN_RULE_PUB.get_attribute10);
312:
313: l_answer := validate_access(p_customer_id,'CUST_LEVEL',FUN_RULE_PUB.get_attribute7,FUN_RULE_PUB.get_attribute8,FUN_RULE_PUB.get_attribute9,FUN_RULE_PUB.get_attribute10);
314:
315: x_verify_access(i).question := FUN_RULE_PUB.get_attribute6;

Line 318: arp_standard.debug('Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);

314:
315: x_verify_access(i).question := FUN_RULE_PUB.get_attribute6;
316: x_verify_access(i).expected_answer := l_answer;
317:
318: arp_standard.debug('Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);
319:
320: i := i+1;
321:
322: END IF; --IF (FUN_RULE_PUB.get_attribute6 is not null) THEN

Line 327: arp_standard.debug('question3 - attribute11 :: '||FUN_RULE_PUB.get_attribute11||' answer table3 - attribute12 '||FUN_RULE_PUB.get_attribute12||' answer column3 - attribute13 '||FUN_RULE_PUB.get_attribute13);

323:
324:
325: IF (FUN_RULE_PUB.get_attribute11 is not null and FUN_RULE_PUB.get_attribute15 is not null) THEN -- to confirm that 3 rd custom question is defined
326:
327: arp_standard.debug('question3 - attribute11 :: '||FUN_RULE_PUB.get_attribute11||' answer table3 - attribute12 '||FUN_RULE_PUB.get_attribute12||' answer column3 - attribute13 '||FUN_RULE_PUB.get_attribute13);
328: arp_standard.debug(' answer join column3 - attribute14 '||FUN_RULE_PUB.get_attribute14||' hz join column3 - attribute15 '||FUN_RULE_PUB.get_attribute15);
329:
330: l_answer := validate_access(p_customer_id,'CUST_LEVEL',FUN_RULE_PUB.get_attribute12,FUN_RULE_PUB.get_attribute13,FUN_RULE_PUB.get_attribute14,FUN_RULE_PUB.get_attribute15);
331:

Line 328: arp_standard.debug(' answer join column3 - attribute14 '||FUN_RULE_PUB.get_attribute14||' hz join column3 - attribute15 '||FUN_RULE_PUB.get_attribute15);

324:
325: IF (FUN_RULE_PUB.get_attribute11 is not null and FUN_RULE_PUB.get_attribute15 is not null) THEN -- to confirm that 3 rd custom question is defined
326:
327: arp_standard.debug('question3 - attribute11 :: '||FUN_RULE_PUB.get_attribute11||' answer table3 - attribute12 '||FUN_RULE_PUB.get_attribute12||' answer column3 - attribute13 '||FUN_RULE_PUB.get_attribute13);
328: arp_standard.debug(' answer join column3 - attribute14 '||FUN_RULE_PUB.get_attribute14||' hz join column3 - attribute15 '||FUN_RULE_PUB.get_attribute15);
329:
330: l_answer := validate_access(p_customer_id,'CUST_LEVEL',FUN_RULE_PUB.get_attribute12,FUN_RULE_PUB.get_attribute13,FUN_RULE_PUB.get_attribute14,FUN_RULE_PUB.get_attribute15);
331:
332: x_verify_access(i).question := FUN_RULE_PUB.get_attribute11;

Line 335: arp_standard.debug('Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);

331:
332: x_verify_access(i).question := FUN_RULE_PUB.get_attribute11;
333: x_verify_access(i).expected_answer := l_answer;
334:
335: arp_standard.debug('Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);
336:
337: i := i+1;
338:
339: END IF; --IF (FUN_RULE_PUB.get_attribute11 is not null) THEN

Line 343: arp_standard.debug('In Exception.. Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);

339: END IF; --IF (FUN_RULE_PUB.get_attribute11 is not null) THEN
340: --Modified for Bug# 13506129
341: EXCEPTION
342: WHEN NO_DATA_FOUND THEN
343: arp_standard.debug('In Exception.. Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);
344: arp_standard.debug('ERROR => :: '||SQLERRM);
345: l_answer := NULL;
346: RETURN;
347: END;

Line 344: arp_standard.debug('ERROR => :: '||SQLERRM);

340: --Modified for Bug# 13506129
341: EXCEPTION
342: WHEN NO_DATA_FOUND THEN
343: arp_standard.debug('In Exception.. Expected Answer.. '||x_verify_access(i).expected_answer||'..Question'||x_verify_access(i).question);
344: arp_standard.debug('ERROR => :: '||SQLERRM);
345: l_answer := NULL;
346: RETURN;
347: END;
348:

Line 500: arp_standard.debug('apps context initialized');

496: else
497:
498: mo_global.init('AR');
499: mo_global.set_policy_context('M',null);
500: arp_standard.debug('apps context initialized');
501:
502: SELECT site_use_id into l_site_use_id FROM
503: ( SELECT site_uses.site_use_id FROM
504: fnd_territories_vl Terr,

Line 522: arp_standard.debug('oldest bill to site id :: '||l_site_use_id);

518: AND loc.country = Terr.territory_code(+)
519: order by site_uses.creation_date asc ) dummy
520: where rownum=1;
521:
522: arp_standard.debug('oldest bill to site id :: '||l_site_use_id);
523:
524: l_query_string :='SELECT anstable.'||p_answer_column|| ' from '|| p_answer_table||' anstable,hz_party_sites hps, hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu where hcsu.site_use_id =' || l_site_use_id ||
525: ' and hcsu.cust_acct_site_id = hcas.cust_acct_site_id and hcas.party_site_id = hps.party_site_id and hps.'||p_hz_join_column||' = anstable.'||p_answer_join_column;
526:

Line 529: arp_standard.debug('l_query_string :: '||l_query_string);

525: ' and hcsu.cust_acct_site_id = hcas.cust_acct_site_id and hcas.party_site_id = hps.party_site_id and hps.'||p_hz_join_column||' = anstable.'||p_answer_join_column;
526:
527: end if;
528:
529: arp_standard.debug('l_query_string :: '||l_query_string);
530:
531: open l_ref_cur for l_query_string;
532: fetch l_ref_cur into l_answer;
533: close l_ref_cur;

Line 535: arp_standard.debug('l_answer ::'||l_answer);

531: open l_ref_cur for l_query_string;
532: fetch l_ref_cur into l_answer;
533: close l_ref_cur;
534:
535: arp_standard.debug('l_answer ::'||l_answer);
536:
537: RETURN l_answer;
538:
539: EXCEPTION

Line 541: arp_standard.debug('Exception in validate_access');

537: RETURN l_answer;
538:
539: EXCEPTION
540: WHEN OTHERS THEN
541: arp_standard.debug('Exception in validate_access');
542: arp_standard.debug('ERROR => :: '||SQLERRM);
543: l_answer := NULL;
544: return l_answer;
545:

Line 542: arp_standard.debug('ERROR => :: '||SQLERRM);

538:
539: EXCEPTION
540: WHEN OTHERS THEN
541: arp_standard.debug('Exception in validate_access');
542: arp_standard.debug('ERROR => :: '||SQLERRM);
543: l_answer := NULL;
544: return l_answer;
545:
546: END validate_access;

Line 559: arp_standard.debug('Enetered procedure get_customer_id_number..');

555: l_customer_id NUMBER;
556: l_account_number VARCHAR2(30);
557: BEGIN
558: --If user searches by customer, get customer id from hz_cust_accounts
559: arp_standard.debug('Enetered procedure get_customer_id_number..');
560: IF p_search_type = 'CUSTOMER_NUMBER' THEN
561: SELECT cust_account_id
562: INTO l_customer_id
563: FROM hz_cust_accounts

Line 604: arp_standard.debug('x_account_number: '||x_account_number);

600: END;
601:
602: END IF;
603: x_account_number := l_account_number;
604: arp_standard.debug('x_account_number: '||x_account_number);
605: x_cust_account_id := l_customer_id;
606: arp_standard.debug('x_cust_account_id: '||x_cust_account_id);
607: arp_standard.debug('Exiting procedure get_customer_id_number..');
608: EXCEPTION

Line 606: arp_standard.debug('x_cust_account_id: '||x_cust_account_id);

602: END IF;
603: x_account_number := l_account_number;
604: arp_standard.debug('x_account_number: '||x_account_number);
605: x_cust_account_id := l_customer_id;
606: arp_standard.debug('x_cust_account_id: '||x_cust_account_id);
607: arp_standard.debug('Exiting procedure get_customer_id_number..');
608: EXCEPTION
609: WHEN NO_DATA_FOUND THEN
610: x_cust_account_id := -2;

Line 607: arp_standard.debug('Exiting procedure get_customer_id_number..');

603: x_account_number := l_account_number;
604: arp_standard.debug('x_account_number: '||x_account_number);
605: x_cust_account_id := l_customer_id;
606: arp_standard.debug('x_cust_account_id: '||x_cust_account_id);
607: arp_standard.debug('Exiting procedure get_customer_id_number..');
608: EXCEPTION
609: WHEN NO_DATA_FOUND THEN
610: x_cust_account_id := -2;
611: