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_SELECTION_CRITERIA_PKG dependencies on ARP_UTIL

Line 39: | arp_util.debug |

35: | |
36: | SCOPE - PRIVATE |
37: | |
38: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
39: | arp_util.debug |
40: | |
41: | ARGUMENTS : IN: |
42: | p_sel_rec |
43: | OUT: |

Line 64: arp_util.debug('arp_selection_criteria_pkg.display_selection_rec()+');

60: IS
61:
62: BEGIN
63:
64: arp_util.debug('arp_selection_criteria_pkg.display_selection_rec()+');
65:
66: arp_util.debug('************** Dump of ar_selection_criteria record **************');
67: arp_util.debug('selection_criteria_id: ' || p_sel_rec.selection_criteria_id);
68: arp_util.debug('last_updated_by: ' || p_sel_rec.last_updated_by);

Line 66: arp_util.debug(' Dump of ar_selection_criteria record ');

62: BEGIN
63:
64: arp_util.debug('arp_selection_criteria_pkg.display_selection_rec()+');
65:
66: arp_util.debug('************** Dump of ar_selection_criteria record **************');
67: arp_util.debug('selection_criteria_id: ' || p_sel_rec.selection_criteria_id);
68: arp_util.debug('last_updated_by: ' || p_sel_rec.last_updated_by);
69: arp_util.debug('created_by: ' || p_sel_rec.created_by);
70: arp_util.debug('last_update_login: ' || p_sel_rec.last_update_login);

Line 67: arp_util.debug('selection_criteria_id: ' || p_sel_rec.selection_criteria_id);

63:
64: arp_util.debug('arp_selection_criteria_pkg.display_selection_rec()+');
65:
66: arp_util.debug('************** Dump of ar_selection_criteria record **************');
67: arp_util.debug('selection_criteria_id: ' || p_sel_rec.selection_criteria_id);
68: arp_util.debug('last_updated_by: ' || p_sel_rec.last_updated_by);
69: arp_util.debug('created_by: ' || p_sel_rec.created_by);
70: arp_util.debug('last_update_login: ' || p_sel_rec.last_update_login);
71: arp_util.debug('due_date_low: ' || p_sel_rec.due_date_low);

Line 68: arp_util.debug('last_updated_by: ' || p_sel_rec.last_updated_by);

64: arp_util.debug('arp_selection_criteria_pkg.display_selection_rec()+');
65:
66: arp_util.debug('************** Dump of ar_selection_criteria record **************');
67: arp_util.debug('selection_criteria_id: ' || p_sel_rec.selection_criteria_id);
68: arp_util.debug('last_updated_by: ' || p_sel_rec.last_updated_by);
69: arp_util.debug('created_by: ' || p_sel_rec.created_by);
70: arp_util.debug('last_update_login: ' || p_sel_rec.last_update_login);
71: arp_util.debug('due_date_low: ' || p_sel_rec.due_date_low);
72: arp_util.debug('due_date_high: ' || p_sel_rec.due_date_high);

Line 69: arp_util.debug('created_by: ' || p_sel_rec.created_by);

65:
66: arp_util.debug('************** Dump of ar_selection_criteria record **************');
67: arp_util.debug('selection_criteria_id: ' || p_sel_rec.selection_criteria_id);
68: arp_util.debug('last_updated_by: ' || p_sel_rec.last_updated_by);
69: arp_util.debug('created_by: ' || p_sel_rec.created_by);
70: arp_util.debug('last_update_login: ' || p_sel_rec.last_update_login);
71: arp_util.debug('due_date_low: ' || p_sel_rec.due_date_low);
72: arp_util.debug('due_date_high: ' || p_sel_rec.due_date_high);
73: arp_util.debug('trx_date_low: ' || p_sel_rec.trx_date_low);

Line 70: arp_util.debug('last_update_login: ' || p_sel_rec.last_update_login);

66: arp_util.debug('************** Dump of ar_selection_criteria record **************');
67: arp_util.debug('selection_criteria_id: ' || p_sel_rec.selection_criteria_id);
68: arp_util.debug('last_updated_by: ' || p_sel_rec.last_updated_by);
69: arp_util.debug('created_by: ' || p_sel_rec.created_by);
70: arp_util.debug('last_update_login: ' || p_sel_rec.last_update_login);
71: arp_util.debug('due_date_low: ' || p_sel_rec.due_date_low);
72: arp_util.debug('due_date_high: ' || p_sel_rec.due_date_high);
73: arp_util.debug('trx_date_low: ' || p_sel_rec.trx_date_low);
74: arp_util.debug('trx_date_high: ' || p_sel_rec.trx_date_high);

Line 71: arp_util.debug('due_date_low: ' || p_sel_rec.due_date_low);

67: arp_util.debug('selection_criteria_id: ' || p_sel_rec.selection_criteria_id);
68: arp_util.debug('last_updated_by: ' || p_sel_rec.last_updated_by);
69: arp_util.debug('created_by: ' || p_sel_rec.created_by);
70: arp_util.debug('last_update_login: ' || p_sel_rec.last_update_login);
71: arp_util.debug('due_date_low: ' || p_sel_rec.due_date_low);
72: arp_util.debug('due_date_high: ' || p_sel_rec.due_date_high);
73: arp_util.debug('trx_date_low: ' || p_sel_rec.trx_date_low);
74: arp_util.debug('trx_date_high: ' || p_sel_rec.trx_date_high);
75: arp_util.debug('cust_trx_type_id: ' || p_sel_rec.cust_trx_type_id);

Line 72: arp_util.debug('due_date_high: ' || p_sel_rec.due_date_high);

68: arp_util.debug('last_updated_by: ' || p_sel_rec.last_updated_by);
69: arp_util.debug('created_by: ' || p_sel_rec.created_by);
70: arp_util.debug('last_update_login: ' || p_sel_rec.last_update_login);
71: arp_util.debug('due_date_low: ' || p_sel_rec.due_date_low);
72: arp_util.debug('due_date_high: ' || p_sel_rec.due_date_high);
73: arp_util.debug('trx_date_low: ' || p_sel_rec.trx_date_low);
74: arp_util.debug('trx_date_high: ' || p_sel_rec.trx_date_high);
75: arp_util.debug('cust_trx_type_id: ' || p_sel_rec.cust_trx_type_id);
76: arp_util.debug('receipt_method_id: ' || p_sel_rec.receipt_method_id);

Line 73: arp_util.debug('trx_date_low: ' || p_sel_rec.trx_date_low);

69: arp_util.debug('created_by: ' || p_sel_rec.created_by);
70: arp_util.debug('last_update_login: ' || p_sel_rec.last_update_login);
71: arp_util.debug('due_date_low: ' || p_sel_rec.due_date_low);
72: arp_util.debug('due_date_high: ' || p_sel_rec.due_date_high);
73: arp_util.debug('trx_date_low: ' || p_sel_rec.trx_date_low);
74: arp_util.debug('trx_date_high: ' || p_sel_rec.trx_date_high);
75: arp_util.debug('cust_trx_type_id: ' || p_sel_rec.cust_trx_type_id);
76: arp_util.debug('receipt_method_id: ' || p_sel_rec.receipt_method_id);
77: arp_util.debug('bank_branch_id: ' || p_sel_rec.bank_branch_id);

Line 74: arp_util.debug('trx_date_high: ' || p_sel_rec.trx_date_high);

70: arp_util.debug('last_update_login: ' || p_sel_rec.last_update_login);
71: arp_util.debug('due_date_low: ' || p_sel_rec.due_date_low);
72: arp_util.debug('due_date_high: ' || p_sel_rec.due_date_high);
73: arp_util.debug('trx_date_low: ' || p_sel_rec.trx_date_low);
74: arp_util.debug('trx_date_high: ' || p_sel_rec.trx_date_high);
75: arp_util.debug('cust_trx_type_id: ' || p_sel_rec.cust_trx_type_id);
76: arp_util.debug('receipt_method_id: ' || p_sel_rec.receipt_method_id);
77: arp_util.debug('bank_branch_id: ' || p_sel_rec.bank_branch_id);
78: arp_util.debug('trx_number_low: ' || p_sel_rec.trx_number_low);

Line 75: arp_util.debug('cust_trx_type_id: ' || p_sel_rec.cust_trx_type_id);

71: arp_util.debug('due_date_low: ' || p_sel_rec.due_date_low);
72: arp_util.debug('due_date_high: ' || p_sel_rec.due_date_high);
73: arp_util.debug('trx_date_low: ' || p_sel_rec.trx_date_low);
74: arp_util.debug('trx_date_high: ' || p_sel_rec.trx_date_high);
75: arp_util.debug('cust_trx_type_id: ' || p_sel_rec.cust_trx_type_id);
76: arp_util.debug('receipt_method_id: ' || p_sel_rec.receipt_method_id);
77: arp_util.debug('bank_branch_id: ' || p_sel_rec.bank_branch_id);
78: arp_util.debug('trx_number_low: ' || p_sel_rec.trx_number_low);
79: arp_util.debug('trx_number_high: ' || p_sel_rec.trx_number_high);

Line 76: arp_util.debug('receipt_method_id: ' || p_sel_rec.receipt_method_id);

72: arp_util.debug('due_date_high: ' || p_sel_rec.due_date_high);
73: arp_util.debug('trx_date_low: ' || p_sel_rec.trx_date_low);
74: arp_util.debug('trx_date_high: ' || p_sel_rec.trx_date_high);
75: arp_util.debug('cust_trx_type_id: ' || p_sel_rec.cust_trx_type_id);
76: arp_util.debug('receipt_method_id: ' || p_sel_rec.receipt_method_id);
77: arp_util.debug('bank_branch_id: ' || p_sel_rec.bank_branch_id);
78: arp_util.debug('trx_number_low: ' || p_sel_rec.trx_number_low);
79: arp_util.debug('trx_number_high: ' || p_sel_rec.trx_number_high);
80: arp_util.debug('customer_class_code: ' || p_sel_rec.customer_class_code);

Line 77: arp_util.debug('bank_branch_id: ' || p_sel_rec.bank_branch_id);

73: arp_util.debug('trx_date_low: ' || p_sel_rec.trx_date_low);
74: arp_util.debug('trx_date_high: ' || p_sel_rec.trx_date_high);
75: arp_util.debug('cust_trx_type_id: ' || p_sel_rec.cust_trx_type_id);
76: arp_util.debug('receipt_method_id: ' || p_sel_rec.receipt_method_id);
77: arp_util.debug('bank_branch_id: ' || p_sel_rec.bank_branch_id);
78: arp_util.debug('trx_number_low: ' || p_sel_rec.trx_number_low);
79: arp_util.debug('trx_number_high: ' || p_sel_rec.trx_number_high);
80: arp_util.debug('customer_class_code: ' || p_sel_rec.customer_class_code);
81: arp_util.debug('customer_category_code: ' || p_sel_rec.customer_category_code);

Line 78: arp_util.debug('trx_number_low: ' || p_sel_rec.trx_number_low);

74: arp_util.debug('trx_date_high: ' || p_sel_rec.trx_date_high);
75: arp_util.debug('cust_trx_type_id: ' || p_sel_rec.cust_trx_type_id);
76: arp_util.debug('receipt_method_id: ' || p_sel_rec.receipt_method_id);
77: arp_util.debug('bank_branch_id: ' || p_sel_rec.bank_branch_id);
78: arp_util.debug('trx_number_low: ' || p_sel_rec.trx_number_low);
79: arp_util.debug('trx_number_high: ' || p_sel_rec.trx_number_high);
80: arp_util.debug('customer_class_code: ' || p_sel_rec.customer_class_code);
81: arp_util.debug('customer_category_code: ' || p_sel_rec.customer_category_code);
82: arp_util.debug('customer_id : ' || p_sel_rec.customer_id);

Line 79: arp_util.debug('trx_number_high: ' || p_sel_rec.trx_number_high);

75: arp_util.debug('cust_trx_type_id: ' || p_sel_rec.cust_trx_type_id);
76: arp_util.debug('receipt_method_id: ' || p_sel_rec.receipt_method_id);
77: arp_util.debug('bank_branch_id: ' || p_sel_rec.bank_branch_id);
78: arp_util.debug('trx_number_low: ' || p_sel_rec.trx_number_low);
79: arp_util.debug('trx_number_high: ' || p_sel_rec.trx_number_high);
80: arp_util.debug('customer_class_code: ' || p_sel_rec.customer_class_code);
81: arp_util.debug('customer_category_code: ' || p_sel_rec.customer_category_code);
82: arp_util.debug('customer_id : ' || p_sel_rec.customer_id);
83: arp_util.debug('site_use_id: ' || p_sel_rec.site_use_id);

Line 80: arp_util.debug('customer_class_code: ' || p_sel_rec.customer_class_code);

76: arp_util.debug('receipt_method_id: ' || p_sel_rec.receipt_method_id);
77: arp_util.debug('bank_branch_id: ' || p_sel_rec.bank_branch_id);
78: arp_util.debug('trx_number_low: ' || p_sel_rec.trx_number_low);
79: arp_util.debug('trx_number_high: ' || p_sel_rec.trx_number_high);
80: arp_util.debug('customer_class_code: ' || p_sel_rec.customer_class_code);
81: arp_util.debug('customer_category_code: ' || p_sel_rec.customer_category_code);
82: arp_util.debug('customer_id : ' || p_sel_rec.customer_id);
83: arp_util.debug('site_use_id: ' || p_sel_rec.site_use_id);
84:

Line 81: arp_util.debug('customer_category_code: ' || p_sel_rec.customer_category_code);

77: arp_util.debug('bank_branch_id: ' || p_sel_rec.bank_branch_id);
78: arp_util.debug('trx_number_low: ' || p_sel_rec.trx_number_low);
79: arp_util.debug('trx_number_high: ' || p_sel_rec.trx_number_high);
80: arp_util.debug('customer_class_code: ' || p_sel_rec.customer_class_code);
81: arp_util.debug('customer_category_code: ' || p_sel_rec.customer_category_code);
82: arp_util.debug('customer_id : ' || p_sel_rec.customer_id);
83: arp_util.debug('site_use_id: ' || p_sel_rec.site_use_id);
84:
85: arp_util.debug('************** End ar_selection_criteria record **************');

Line 82: arp_util.debug('customer_id : ' || p_sel_rec.customer_id);

78: arp_util.debug('trx_number_low: ' || p_sel_rec.trx_number_low);
79: arp_util.debug('trx_number_high: ' || p_sel_rec.trx_number_high);
80: arp_util.debug('customer_class_code: ' || p_sel_rec.customer_class_code);
81: arp_util.debug('customer_category_code: ' || p_sel_rec.customer_category_code);
82: arp_util.debug('customer_id : ' || p_sel_rec.customer_id);
83: arp_util.debug('site_use_id: ' || p_sel_rec.site_use_id);
84:
85: arp_util.debug('************** End ar_selection_criteria record **************');
86:

Line 83: arp_util.debug('site_use_id: ' || p_sel_rec.site_use_id);

79: arp_util.debug('trx_number_high: ' || p_sel_rec.trx_number_high);
80: arp_util.debug('customer_class_code: ' || p_sel_rec.customer_class_code);
81: arp_util.debug('customer_category_code: ' || p_sel_rec.customer_category_code);
82: arp_util.debug('customer_id : ' || p_sel_rec.customer_id);
83: arp_util.debug('site_use_id: ' || p_sel_rec.site_use_id);
84:
85: arp_util.debug('************** End ar_selection_criteria record **************');
86:
87: arp_util.debug('arp_selection_criteria_pkg.display_selection_rec()-');

Line 85: arp_util.debug(' End ar_selection_criteria record ');

81: arp_util.debug('customer_category_code: ' || p_sel_rec.customer_category_code);
82: arp_util.debug('customer_id : ' || p_sel_rec.customer_id);
83: arp_util.debug('site_use_id: ' || p_sel_rec.site_use_id);
84:
85: arp_util.debug('************** End ar_selection_criteria record **************');
86:
87: arp_util.debug('arp_selection_criteria_pkg.display_selection_rec()-');
88:
89: EXCEPTION

Line 87: arp_util.debug('arp_selection_criteria_pkg.display_selection_rec()-');

83: arp_util.debug('site_use_id: ' || p_sel_rec.site_use_id);
84:
85: arp_util.debug('************** End ar_selection_criteria record **************');
86:
87: arp_util.debug('arp_selection_criteria_pkg.display_selection_rec()-');
88:
89: EXCEPTION
90: WHEN OTHERS THEN
91: arp_util.debug('EXCEPTION: arp_selection_criteria_pkg.display_selection_rec()');

Line 91: arp_util.debug('EXCEPTION: arp_selection_criteria_pkg.display_selection_rec()');

87: arp_util.debug('arp_selection_criteria_pkg.display_selection_rec()-');
88:
89: EXCEPTION
90: WHEN OTHERS THEN
91: arp_util.debug('EXCEPTION: arp_selection_criteria_pkg.display_selection_rec()');
92: RAISE;
93:
94: END;
95:

Line 108: | arp_util.debug |

104: | |
105: | SCOPE - PRIVATE |
106: | |
107: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
108: | arp_util.debug |
109: | |
110: | ARGUMENTS : IN: |
111: | p_sel_id |
112: | OUT: |

Line 134: arp_util.debug('arp_selection_criteria_pkg.display_selection()+');

130: l_sel_rec ar_selection_criteria%rowtype;
131:
132: BEGIN
133:
134: arp_util.debug('arp_selection_criteria_pkg.display_selection()+');
135:
136: ARP_SELECTION_CRITERIA_PKG.fetch_p(l_sel_rec, p_sel_id);
137:
138: ARP_SELECTION_CRITERIA_PKG.display_selection_rec (l_sel_rec);

Line 140: arp_util.debug('arp_selection_criteria_pkg.display_selection()-');

136: ARP_SELECTION_CRITERIA_PKG.fetch_p(l_sel_rec, p_sel_id);
137:
138: ARP_SELECTION_CRITERIA_PKG.display_selection_rec (l_sel_rec);
139:
140: arp_util.debug('arp_selection_criteria_pkg.display_selection()-');
141:
142: EXCEPTION
143: WHEN OTHERS THEN
144: arp_util.debug('EXCEPTION: arp_selection_criteria_pkg.display_selection()');

Line 144: arp_util.debug('EXCEPTION: arp_selection_criteria_pkg.display_selection()');

140: arp_util.debug('arp_selection_criteria_pkg.display_selection()-');
141:
142: EXCEPTION
143: WHEN OTHERS THEN
144: arp_util.debug('EXCEPTION: arp_selection_criteria_pkg.display_selection()');
145: RAISE;
146:
147: END;
148:

Line 166: | arp_util.debug |

162: | |
163: | SCOPE - PUBLIC |
164: | |
165: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
166: | arp_util.debug |
167: | |
168: | ARGUMENTS : IN: |
169: | None |
170: | OUT: |

Line 187: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.set_to_dummy()+');

183: PROCEDURE set_to_dummy( p_sel_rec OUT NOCOPY ar_selection_criteria%rowtype) IS
184:
185: BEGIN
186:
187: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.set_to_dummy()+');
188:
189: p_sel_rec.selection_criteria_id := AR_NUMBER_DUMMY;
190: p_sel_rec.last_update_date := AR_DATE_DUMMY;
191: p_sel_rec.last_updated_by := AR_NUMBER_DUMMY;

Line 209: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.set_to_dummy()-');

205: p_sel_rec.customer_category_code := AR_TEXT_DUMMY;
206: p_sel_rec.customer_id := AR_NUMBER_DUMMY;
207: p_sel_rec.site_use_id := AR_NUMBER_DUMMY;
208:
209: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.set_to_dummy()-');
210:
211: EXCEPTION
212: WHEN OTHERS THEN
213: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.set_to_dummy()');

Line 213: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.set_to_dummy()');

209: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.set_to_dummy()-');
210:
211: EXCEPTION
212: WHEN OTHERS THEN
213: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.set_to_dummy()');
214: RAISE;
215:
216: END;
217:

Line 231: | arp_util.debug |

227: | |
228: | SCOPE - PUBLIC |
229: | |
230: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
231: | arp_util.debug |
232: | |
233: | ARGUMENTS : IN: |
234: | p_sel_id - identifies the record to fetch |
235: | OUT: |

Line 251: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.fetch_p()+');

247: PROCEDURE fetch_p( p_sel_rec OUT NOCOPY ar_selection_criteria%rowtype ,
248: p_sel_id IN ar_selection_criteria.selection_criteria_id%TYPE ) IS
249:
250: BEGIN
251: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.fetch_p()+');
252:
253: SELECT *
254: INTO p_sel_rec
255: FROM ar_selection_criteria

Line 258: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.fetch_p()-');

254: INTO p_sel_rec
255: FROM ar_selection_criteria
256: WHERE selection_criteria_id = p_sel_id;
257:
258: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.fetch_p()-');
259:
260: EXCEPTION
261: WHEN OTHERS THEN
262: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.fetch_p' );

Line 262: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.fetch_p' );

258: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.fetch_p()-');
259:
260: EXCEPTION
261: WHEN OTHERS THEN
262: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.fetch_p' );
263: RAISE;
264: END;
265:
266:

Line 279: | arp_util.debug |

275: | |
276: | SCOPE - PUBLIC |
277: | |
278: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
279: | arp_util.debug |
280: | |
281: | ARGUMENTS : IN: |
282: | p_sel_id - identifies the row to lock |
283: | OUT: |

Line 302: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_p()+');

298:
299: l_sel_id ar_selection_criteria.selection_criteria_id%TYPE;
300:
301: BEGIN
302: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_p()+');
303:
304: SELECT selection_criteria_id
305: INTO l_sel_id
306: FROM ar_selection_criteria

Line 310: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_p()-');

306: FROM ar_selection_criteria
307: WHERE selection_criteria_id = p_sel_id
308: FOR UPDATE OF selection_criteria_id NOWAIT;
309:
310: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_p()-');
311:
312: EXCEPTION
313: WHEN OTHERS THEN
314: arp_util.debug( 'EXCEPTION: ARP_SELECTION_CRITERIA_PKG.lock_p' );

Line 314: arp_util.debug( 'EXCEPTION: ARP_SELECTION_CRITERIA_PKG.lock_p' );

310: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_p()-');
311:
312: EXCEPTION
313: WHEN OTHERS THEN
314: arp_util.debug( 'EXCEPTION: ARP_SELECTION_CRITERIA_PKG.lock_p' );
315: RAISE;
316: END;
317:
318:

Line 331: | arp_util.debug |

327: | |
328: | SCOPE - PUBLIC |
329: | |
330: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
331: | arp_util.debug |
332: | |
333: | ARGUMENTS : IN: |
334: | p_sel_id - identifies the row to lock |
335: | OUT: |

Line 352: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_fetch_p()+');

348: p_sel_id IN ar_selection_criteria.selection_criteria_id%TYPE )
349: IS
350:
351: BEGIN
352: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_fetch_p()+');
353:
354: SELECT *
355: INTO p_sel_rec
356: FROM ar_selection_criteria

Line 360: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_fetch_p()-');

356: FROM ar_selection_criteria
357: WHERE selection_criteria_id = p_sel_id
358: FOR UPDATE OF selection_criteria_id NOWAIT;
359:
360: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_fetch_p()-');
361:
362: EXCEPTION
363: WHEN OTHERS THEN
364: arp_util.debug( 'EXCEPTION: ARP_SELECTION_CRITERIA_PKG.lock_fetch_p' );

Line 364: arp_util.debug( 'EXCEPTION: ARP_SELECTION_CRITERIA_PKG.lock_fetch_p' );

360: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_fetch_p()-');
361:
362: EXCEPTION
363: WHEN OTHERS THEN
364: arp_util.debug( 'EXCEPTION: ARP_SELECTION_CRITERIA_PKG.lock_fetch_p' );
365: RAISE;
366: END;
367:
368:

Line 381: | arp_util.debug |

377: | |
378: | SCOPE - PUBLIC |
379: | |
380: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
381: | arp_util.debug |
382: | |
383: | ARGUMENTS : IN: |
384: | p_sel_id - identifies the row to lock |
385: | p_sel_rec - selection record for comparison |

Line 406: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_p()+');

402:
403: l_new_sel_rec ar_selection_criteria%rowtype;
404:
405: BEGIN
406: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_p()+');
407:
408: SELECT *
409: INTO l_new_sel_rec
410: FROM ar_selection_criteria tsel

Line 572: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_p()-');

568:
569: )
570: FOR UPDATE OF selection_criteria_id NOWAIT;
571:
572: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_p()-');
573:
574: EXCEPTION
575: WHEN OTHERS THEN
576: arp_util.debug( 'EXCEPTION: ARP_SELECTION_CRITERIA_PKG.lock_compare_p' );

Line 576: arp_util.debug( 'EXCEPTION: ARP_SELECTION_CRITERIA_PKG.lock_compare_p' );

572: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_p()-');
573:
574: EXCEPTION
575: WHEN OTHERS THEN
576: arp_util.debug( 'EXCEPTION: ARP_SELECTION_CRITERIA_PKG.lock_compare_p' );
577: RAISE;
578: END;
579:
580:

Line 591: | arp_util.debug |

587: | |
588: | SCOPE - PRIVATE |
589: | |
590: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
591: | arp_util.debug |
592: | |
593: | ARGUMENTS : IN: |
594: | p_form_name |
595: | p_form_version |

Line 649: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_cover()+');

645:
646: l_sel_rec ar_selection_criteria%rowtype;
647:
648: BEGIN
649: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_cover()+');
650:
651: ARP_SELECTION_CRITERIA_PKG.set_to_dummy(l_sel_rec);
652:
653: l_sel_rec.selection_criteria_id := p_selection_criteria_id ;

Line 670: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_cover()-');

666: l_sel_rec.site_use_id := p_site_use_id ;
667:
668: ARP_SELECTION_CRITERIA_PKG.lock_compare_p(l_sel_rec, p_selection_criteria_id);
669:
670: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_cover()-');
671:
672: EXCEPTION
673: WHEN OTHERS THEN
674: arp_util.debug('EXCEPTION : ARP_SELECTION_CRITERIA_PKG.lock_compare_cover');

Line 674: arp_util.debug('EXCEPTION : ARP_SELECTION_CRITERIA_PKG.lock_compare_cover');

670: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.lock_compare_cover()-');
671:
672: EXCEPTION
673: WHEN OTHERS THEN
674: arp_util.debug('EXCEPTION : ARP_SELECTION_CRITERIA_PKG.lock_compare_cover');
675:
676: arp_util.debug('************** Dump of ar_selection_criteria record **************');
677: arp_util.debug('p_selection_criteria_id: ' || p_selection_criteria_id);
678: arp_util.debug('p_due_date_low: ' || p_due_date_low);

Line 676: arp_util.debug(' Dump of ar_selection_criteria record ');

672: EXCEPTION
673: WHEN OTHERS THEN
674: arp_util.debug('EXCEPTION : ARP_SELECTION_CRITERIA_PKG.lock_compare_cover');
675:
676: arp_util.debug('************** Dump of ar_selection_criteria record **************');
677: arp_util.debug('p_selection_criteria_id: ' || p_selection_criteria_id);
678: arp_util.debug('p_due_date_low: ' || p_due_date_low);
679: arp_util.debug('p_due_date_high: ' || p_due_date_high);
680: arp_util.debug('p_trx_date_low: ' || p_trx_date_low);

Line 677: arp_util.debug('p_selection_criteria_id: ' || p_selection_criteria_id);

673: WHEN OTHERS THEN
674: arp_util.debug('EXCEPTION : ARP_SELECTION_CRITERIA_PKG.lock_compare_cover');
675:
676: arp_util.debug('************** Dump of ar_selection_criteria record **************');
677: arp_util.debug('p_selection_criteria_id: ' || p_selection_criteria_id);
678: arp_util.debug('p_due_date_low: ' || p_due_date_low);
679: arp_util.debug('p_due_date_high: ' || p_due_date_high);
680: arp_util.debug('p_trx_date_low: ' || p_trx_date_low);
681: arp_util.debug('p_trx_date_high: ' || p_trx_date_high);

Line 678: arp_util.debug('p_due_date_low: ' || p_due_date_low);

674: arp_util.debug('EXCEPTION : ARP_SELECTION_CRITERIA_PKG.lock_compare_cover');
675:
676: arp_util.debug('************** Dump of ar_selection_criteria record **************');
677: arp_util.debug('p_selection_criteria_id: ' || p_selection_criteria_id);
678: arp_util.debug('p_due_date_low: ' || p_due_date_low);
679: arp_util.debug('p_due_date_high: ' || p_due_date_high);
680: arp_util.debug('p_trx_date_low: ' || p_trx_date_low);
681: arp_util.debug('p_trx_date_high: ' || p_trx_date_high);
682: arp_util.debug('p_cust_trx_type_id: ' || p_cust_trx_type_id);

Line 679: arp_util.debug('p_due_date_high: ' || p_due_date_high);

675:
676: arp_util.debug('************** Dump of ar_selection_criteria record **************');
677: arp_util.debug('p_selection_criteria_id: ' || p_selection_criteria_id);
678: arp_util.debug('p_due_date_low: ' || p_due_date_low);
679: arp_util.debug('p_due_date_high: ' || p_due_date_high);
680: arp_util.debug('p_trx_date_low: ' || p_trx_date_low);
681: arp_util.debug('p_trx_date_high: ' || p_trx_date_high);
682: arp_util.debug('p_cust_trx_type_id: ' || p_cust_trx_type_id);
683: arp_util.debug('p_receipt_method_id: ' || p_receipt_method_id);

Line 680: arp_util.debug('p_trx_date_low: ' || p_trx_date_low);

676: arp_util.debug('************** Dump of ar_selection_criteria record **************');
677: arp_util.debug('p_selection_criteria_id: ' || p_selection_criteria_id);
678: arp_util.debug('p_due_date_low: ' || p_due_date_low);
679: arp_util.debug('p_due_date_high: ' || p_due_date_high);
680: arp_util.debug('p_trx_date_low: ' || p_trx_date_low);
681: arp_util.debug('p_trx_date_high: ' || p_trx_date_high);
682: arp_util.debug('p_cust_trx_type_id: ' || p_cust_trx_type_id);
683: arp_util.debug('p_receipt_method_id: ' || p_receipt_method_id);
684: arp_util.debug('p_bank_branch_id: ' || p_bank_branch_id);

Line 681: arp_util.debug('p_trx_date_high: ' || p_trx_date_high);

677: arp_util.debug('p_selection_criteria_id: ' || p_selection_criteria_id);
678: arp_util.debug('p_due_date_low: ' || p_due_date_low);
679: arp_util.debug('p_due_date_high: ' || p_due_date_high);
680: arp_util.debug('p_trx_date_low: ' || p_trx_date_low);
681: arp_util.debug('p_trx_date_high: ' || p_trx_date_high);
682: arp_util.debug('p_cust_trx_type_id: ' || p_cust_trx_type_id);
683: arp_util.debug('p_receipt_method_id: ' || p_receipt_method_id);
684: arp_util.debug('p_bank_branch_id: ' || p_bank_branch_id);
685: arp_util.debug('p_trx_number_low: ' || p_trx_number_low);

Line 682: arp_util.debug('p_cust_trx_type_id: ' || p_cust_trx_type_id);

678: arp_util.debug('p_due_date_low: ' || p_due_date_low);
679: arp_util.debug('p_due_date_high: ' || p_due_date_high);
680: arp_util.debug('p_trx_date_low: ' || p_trx_date_low);
681: arp_util.debug('p_trx_date_high: ' || p_trx_date_high);
682: arp_util.debug('p_cust_trx_type_id: ' || p_cust_trx_type_id);
683: arp_util.debug('p_receipt_method_id: ' || p_receipt_method_id);
684: arp_util.debug('p_bank_branch_id: ' || p_bank_branch_id);
685: arp_util.debug('p_trx_number_low: ' || p_trx_number_low);
686: arp_util.debug('p_trx_number_high: ' || p_trx_number_high);

Line 683: arp_util.debug('p_receipt_method_id: ' || p_receipt_method_id);

679: arp_util.debug('p_due_date_high: ' || p_due_date_high);
680: arp_util.debug('p_trx_date_low: ' || p_trx_date_low);
681: arp_util.debug('p_trx_date_high: ' || p_trx_date_high);
682: arp_util.debug('p_cust_trx_type_id: ' || p_cust_trx_type_id);
683: arp_util.debug('p_receipt_method_id: ' || p_receipt_method_id);
684: arp_util.debug('p_bank_branch_id: ' || p_bank_branch_id);
685: arp_util.debug('p_trx_number_low: ' || p_trx_number_low);
686: arp_util.debug('p_trx_number_high: ' || p_trx_number_high);
687: arp_util.debug('p_customer_class_code: ' || p_customer_class_code);

Line 684: arp_util.debug('p_bank_branch_id: ' || p_bank_branch_id);

680: arp_util.debug('p_trx_date_low: ' || p_trx_date_low);
681: arp_util.debug('p_trx_date_high: ' || p_trx_date_high);
682: arp_util.debug('p_cust_trx_type_id: ' || p_cust_trx_type_id);
683: arp_util.debug('p_receipt_method_id: ' || p_receipt_method_id);
684: arp_util.debug('p_bank_branch_id: ' || p_bank_branch_id);
685: arp_util.debug('p_trx_number_low: ' || p_trx_number_low);
686: arp_util.debug('p_trx_number_high: ' || p_trx_number_high);
687: arp_util.debug('p_customer_class_code: ' || p_customer_class_code);
688: arp_util.debug('p_customer_category_code: ' || p_customer_category_code);

Line 685: arp_util.debug('p_trx_number_low: ' || p_trx_number_low);

681: arp_util.debug('p_trx_date_high: ' || p_trx_date_high);
682: arp_util.debug('p_cust_trx_type_id: ' || p_cust_trx_type_id);
683: arp_util.debug('p_receipt_method_id: ' || p_receipt_method_id);
684: arp_util.debug('p_bank_branch_id: ' || p_bank_branch_id);
685: arp_util.debug('p_trx_number_low: ' || p_trx_number_low);
686: arp_util.debug('p_trx_number_high: ' || p_trx_number_high);
687: arp_util.debug('p_customer_class_code: ' || p_customer_class_code);
688: arp_util.debug('p_customer_category_code: ' || p_customer_category_code);
689: arp_util.debug('p_customer_id : ' || p_customer_id);

Line 686: arp_util.debug('p_trx_number_high: ' || p_trx_number_high);

682: arp_util.debug('p_cust_trx_type_id: ' || p_cust_trx_type_id);
683: arp_util.debug('p_receipt_method_id: ' || p_receipt_method_id);
684: arp_util.debug('p_bank_branch_id: ' || p_bank_branch_id);
685: arp_util.debug('p_trx_number_low: ' || p_trx_number_low);
686: arp_util.debug('p_trx_number_high: ' || p_trx_number_high);
687: arp_util.debug('p_customer_class_code: ' || p_customer_class_code);
688: arp_util.debug('p_customer_category_code: ' || p_customer_category_code);
689: arp_util.debug('p_customer_id : ' || p_customer_id);
690: arp_util.debug('p_site_use_id: ' || p_site_use_id);

Line 687: arp_util.debug('p_customer_class_code: ' || p_customer_class_code);

683: arp_util.debug('p_receipt_method_id: ' || p_receipt_method_id);
684: arp_util.debug('p_bank_branch_id: ' || p_bank_branch_id);
685: arp_util.debug('p_trx_number_low: ' || p_trx_number_low);
686: arp_util.debug('p_trx_number_high: ' || p_trx_number_high);
687: arp_util.debug('p_customer_class_code: ' || p_customer_class_code);
688: arp_util.debug('p_customer_category_code: ' || p_customer_category_code);
689: arp_util.debug('p_customer_id : ' || p_customer_id);
690: arp_util.debug('p_site_use_id: ' || p_site_use_id);
691:

Line 688: arp_util.debug('p_customer_category_code: ' || p_customer_category_code);

684: arp_util.debug('p_bank_branch_id: ' || p_bank_branch_id);
685: arp_util.debug('p_trx_number_low: ' || p_trx_number_low);
686: arp_util.debug('p_trx_number_high: ' || p_trx_number_high);
687: arp_util.debug('p_customer_class_code: ' || p_customer_class_code);
688: arp_util.debug('p_customer_category_code: ' || p_customer_category_code);
689: arp_util.debug('p_customer_id : ' || p_customer_id);
690: arp_util.debug('p_site_use_id: ' || p_site_use_id);
691:
692: arp_util.debug('************** End ar_selection_criteria record **************');

Line 689: arp_util.debug('p_customer_id : ' || p_customer_id);

685: arp_util.debug('p_trx_number_low: ' || p_trx_number_low);
686: arp_util.debug('p_trx_number_high: ' || p_trx_number_high);
687: arp_util.debug('p_customer_class_code: ' || p_customer_class_code);
688: arp_util.debug('p_customer_category_code: ' || p_customer_category_code);
689: arp_util.debug('p_customer_id : ' || p_customer_id);
690: arp_util.debug('p_site_use_id: ' || p_site_use_id);
691:
692: arp_util.debug('************** End ar_selection_criteria record **************');
693:

Line 690: arp_util.debug('p_site_use_id: ' || p_site_use_id);

686: arp_util.debug('p_trx_number_high: ' || p_trx_number_high);
687: arp_util.debug('p_customer_class_code: ' || p_customer_class_code);
688: arp_util.debug('p_customer_category_code: ' || p_customer_category_code);
689: arp_util.debug('p_customer_id : ' || p_customer_id);
690: arp_util.debug('p_site_use_id: ' || p_site_use_id);
691:
692: arp_util.debug('************** End ar_selection_criteria record **************');
693:
694:

Line 692: arp_util.debug(' End ar_selection_criteria record ');

688: arp_util.debug('p_customer_category_code: ' || p_customer_category_code);
689: arp_util.debug('p_customer_id : ' || p_customer_id);
690: arp_util.debug('p_site_use_id: ' || p_site_use_id);
691:
692: arp_util.debug('************** End ar_selection_criteria record **************');
693:
694:
695: RAISE;
696: END;

Line 709: | arp_util.debug |

705: | |
706: | SCOPE - PUBLIC |
707: | |
708: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
709: | arp_util.debug |
710: | |
711: | ARGUMENTS : IN: |
712: | p_sel_id - identifies the row to delete |
713: | OUT: |

Line 729: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.delete_p()+');

725: procedure delete_p( p_sel_id IN ar_selection_criteria.selection_criteria_id%TYPE) IS
726:
727: BEGIN
728:
729: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.delete_p()+');
730:
731: DELETE FROM ar_selection_criteria
732: WHERE selection_criteria_id = p_sel_id;
733:

Line 734: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.delete_p()-');

730:
731: DELETE FROM ar_selection_criteria
732: WHERE selection_criteria_id = p_sel_id;
733:
734: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.delete_p()-');
735:
736: EXCEPTION
737: WHEN OTHERS THEN
738: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.delete_p()');

Line 738: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.delete_p()');

734: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.delete_p()-');
735:
736: EXCEPTION
737: WHEN OTHERS THEN
738: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.delete_p()');
739: RAISE;
740:
741: END;
742:

Line 755: | arp_util.debug |

751: | |
752: | SCOPE - PUBLIC |
753: | |
754: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
755: | arp_util.debug |
756: | |
757: | ARGUMENTS : IN: |
758: | p_sel_id - identifies the row to update |
759: | p_sel_rec - contains the new column values |

Line 780: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.update_p()+');

776:
777:
778: BEGIN
779:
780: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.update_p()+');
781:
782: UPDATE AR_SELECTION_CRITERIA SET
783:
784: due_date_low =

Line 856: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.update_p()-');

852:
853: WHERE selection_criteria_id = p_sel_id;
854:
855:
856: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.update_p()-');
857:
858:
859: EXCEPTION
860: WHEN OTHERS THEN

Line 861: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.update_p()');

857:
858:
859: EXCEPTION
860: WHEN OTHERS THEN
861: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.update_p()');
862: RAISE;
863: END;
864:
865:

Line 877: | arp_util.debug |

873: | |
874: | SCOPE - PUBLIC |
875: | |
876: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
877: | arp_util.debug |
878: | arp_global.set_of_books_id |
879: | |
880: | ARGUMENTS : IN: |
881: | p_sel_rec - contains the new column values |

Line 903: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.insert_p()+');

899: l_sel_id ar_selection_criteria.selection_criteria_id%TYPE;
900:
901: BEGIN
902:
903: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.insert_p()+');
904:
905: p_sel_id := '';
906:
907: /*---------------------------*

Line 967: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.insert_p()-');

963: );
964:
965: p_sel_id := l_sel_id;
966:
967: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.insert_p()-');
968:
969: EXCEPTION
970: WHEN OTHERS THEN
971: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.insert_p()');

Line 971: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.insert_p()');

967: arp_util.debug('ARP_SELECTION_CRITERIA_PKG.insert_p()-');
968:
969: EXCEPTION
970: WHEN OTHERS THEN
971: arp_util.debug('EXCEPTION: ARP_SELECTION_CRITERIA_PKG.insert_p()');
972: RAISE;
973: END;
974:
975: