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

Line 42: | arp_util.debug |

38: | |
39: | SCOPE - PRIVATE |
40: | |
41: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
42: | arp_util.debug |
43: | |
44: | ARGUMENTS : IN: |
45: | p_batch_rec |
46: | OUT: |

Line 76: arp_util.debug('arp_tbat_pgk.display_batch_rec()+');

72:
73:
74: BEGIN
75:
76: arp_util.debug('arp_tbat_pgk.display_batch_rec()+');
77:
78:
79: arp_util.debug('************** Dump of ra_batches record **************');
80: arp_util.debug('batch_id: ' || p_batch_rec.batch_id);

Line 79: arp_util.debug(' Dump of ra_batches record ');

75:
76: arp_util.debug('arp_tbat_pgk.display_batch_rec()+');
77:
78:
79: arp_util.debug('************** Dump of ra_batches record **************');
80: arp_util.debug('batch_id: ' || p_batch_rec.batch_id);
81: arp_util.debug('last_updated_by: ' || p_batch_rec.last_updated_by);
82: arp_util.debug('created_by: ' || p_batch_rec.created_by);
83: arp_util.debug('last_update_login: ' || p_batch_rec.last_update_login);

Line 80: arp_util.debug('batch_id: ' || p_batch_rec.batch_id);

76: arp_util.debug('arp_tbat_pgk.display_batch_rec()+');
77:
78:
79: arp_util.debug('************** Dump of ra_batches record **************');
80: arp_util.debug('batch_id: ' || p_batch_rec.batch_id);
81: arp_util.debug('last_updated_by: ' || p_batch_rec.last_updated_by);
82: arp_util.debug('created_by: ' || p_batch_rec.created_by);
83: arp_util.debug('last_update_login: ' || p_batch_rec.last_update_login);
84: arp_util.debug('program_id: ' || p_batch_rec.program_id);

Line 81: arp_util.debug('last_updated_by: ' || p_batch_rec.last_updated_by);

77:
78:
79: arp_util.debug('************** Dump of ra_batches record **************');
80: arp_util.debug('batch_id: ' || p_batch_rec.batch_id);
81: arp_util.debug('last_updated_by: ' || p_batch_rec.last_updated_by);
82: arp_util.debug('created_by: ' || p_batch_rec.created_by);
83: arp_util.debug('last_update_login: ' || p_batch_rec.last_update_login);
84: arp_util.debug('program_id: ' || p_batch_rec.program_id);
85: arp_util.debug('set_of_books_id: ' || p_batch_rec.set_of_books_id);

Line 82: arp_util.debug('created_by: ' || p_batch_rec.created_by);

78:
79: arp_util.debug('************** Dump of ra_batches record **************');
80: arp_util.debug('batch_id: ' || p_batch_rec.batch_id);
81: arp_util.debug('last_updated_by: ' || p_batch_rec.last_updated_by);
82: arp_util.debug('created_by: ' || p_batch_rec.created_by);
83: arp_util.debug('last_update_login: ' || p_batch_rec.last_update_login);
84: arp_util.debug('program_id: ' || p_batch_rec.program_id);
85: arp_util.debug('set_of_books_id: ' || p_batch_rec.set_of_books_id);
86: arp_util.debug('name: ' || p_batch_rec.name);

Line 83: arp_util.debug('last_update_login: ' || p_batch_rec.last_update_login);

79: arp_util.debug('************** Dump of ra_batches record **************');
80: arp_util.debug('batch_id: ' || p_batch_rec.batch_id);
81: arp_util.debug('last_updated_by: ' || p_batch_rec.last_updated_by);
82: arp_util.debug('created_by: ' || p_batch_rec.created_by);
83: arp_util.debug('last_update_login: ' || p_batch_rec.last_update_login);
84: arp_util.debug('program_id: ' || p_batch_rec.program_id);
85: arp_util.debug('set_of_books_id: ' || p_batch_rec.set_of_books_id);
86: arp_util.debug('name: ' || p_batch_rec.name);
87: arp_util.debug('batch_source_id: ' || p_batch_rec.batch_source_id);

Line 84: arp_util.debug('program_id: ' || p_batch_rec.program_id);

80: arp_util.debug('batch_id: ' || p_batch_rec.batch_id);
81: arp_util.debug('last_updated_by: ' || p_batch_rec.last_updated_by);
82: arp_util.debug('created_by: ' || p_batch_rec.created_by);
83: arp_util.debug('last_update_login: ' || p_batch_rec.last_update_login);
84: arp_util.debug('program_id: ' || p_batch_rec.program_id);
85: arp_util.debug('set_of_books_id: ' || p_batch_rec.set_of_books_id);
86: arp_util.debug('name: ' || p_batch_rec.name);
87: arp_util.debug('batch_source_id: ' || p_batch_rec.batch_source_id);
88: arp_util.debug('batch_date: ' || p_batch_rec.batch_date);

Line 85: arp_util.debug('set_of_books_id: ' || p_batch_rec.set_of_books_id);

81: arp_util.debug('last_updated_by: ' || p_batch_rec.last_updated_by);
82: arp_util.debug('created_by: ' || p_batch_rec.created_by);
83: arp_util.debug('last_update_login: ' || p_batch_rec.last_update_login);
84: arp_util.debug('program_id: ' || p_batch_rec.program_id);
85: arp_util.debug('set_of_books_id: ' || p_batch_rec.set_of_books_id);
86: arp_util.debug('name: ' || p_batch_rec.name);
87: arp_util.debug('batch_source_id: ' || p_batch_rec.batch_source_id);
88: arp_util.debug('batch_date: ' || p_batch_rec.batch_date);
89: arp_util.debug('gl_date: ' || p_batch_rec.gl_date);

Line 86: arp_util.debug('name: ' || p_batch_rec.name);

82: arp_util.debug('created_by: ' || p_batch_rec.created_by);
83: arp_util.debug('last_update_login: ' || p_batch_rec.last_update_login);
84: arp_util.debug('program_id: ' || p_batch_rec.program_id);
85: arp_util.debug('set_of_books_id: ' || p_batch_rec.set_of_books_id);
86: arp_util.debug('name: ' || p_batch_rec.name);
87: arp_util.debug('batch_source_id: ' || p_batch_rec.batch_source_id);
88: arp_util.debug('batch_date: ' || p_batch_rec.batch_date);
89: arp_util.debug('gl_date: ' || p_batch_rec.gl_date);
90: arp_util.debug('status: ' || p_batch_rec.status);

Line 87: arp_util.debug('batch_source_id: ' || p_batch_rec.batch_source_id);

83: arp_util.debug('last_update_login: ' || p_batch_rec.last_update_login);
84: arp_util.debug('program_id: ' || p_batch_rec.program_id);
85: arp_util.debug('set_of_books_id: ' || p_batch_rec.set_of_books_id);
86: arp_util.debug('name: ' || p_batch_rec.name);
87: arp_util.debug('batch_source_id: ' || p_batch_rec.batch_source_id);
88: arp_util.debug('batch_date: ' || p_batch_rec.batch_date);
89: arp_util.debug('gl_date: ' || p_batch_rec.gl_date);
90: arp_util.debug('status: ' || p_batch_rec.status);
91: arp_util.debug('type: ' || p_batch_rec.type);

Line 88: arp_util.debug('batch_date: ' || p_batch_rec.batch_date);

84: arp_util.debug('program_id: ' || p_batch_rec.program_id);
85: arp_util.debug('set_of_books_id: ' || p_batch_rec.set_of_books_id);
86: arp_util.debug('name: ' || p_batch_rec.name);
87: arp_util.debug('batch_source_id: ' || p_batch_rec.batch_source_id);
88: arp_util.debug('batch_date: ' || p_batch_rec.batch_date);
89: arp_util.debug('gl_date: ' || p_batch_rec.gl_date);
90: arp_util.debug('status: ' || p_batch_rec.status);
91: arp_util.debug('type: ' || p_batch_rec.type);
92: arp_util.debug('control_count: ' || p_batch_rec.control_count);

Line 89: arp_util.debug('gl_date: ' || p_batch_rec.gl_date);

85: arp_util.debug('set_of_books_id: ' || p_batch_rec.set_of_books_id);
86: arp_util.debug('name: ' || p_batch_rec.name);
87: arp_util.debug('batch_source_id: ' || p_batch_rec.batch_source_id);
88: arp_util.debug('batch_date: ' || p_batch_rec.batch_date);
89: arp_util.debug('gl_date: ' || p_batch_rec.gl_date);
90: arp_util.debug('status: ' || p_batch_rec.status);
91: arp_util.debug('type: ' || p_batch_rec.type);
92: arp_util.debug('control_count: ' || p_batch_rec.control_count);
93: arp_util.debug('control_amount: ' || p_batch_rec.control_amount);

Line 90: arp_util.debug('status: ' || p_batch_rec.status);

86: arp_util.debug('name: ' || p_batch_rec.name);
87: arp_util.debug('batch_source_id: ' || p_batch_rec.batch_source_id);
88: arp_util.debug('batch_date: ' || p_batch_rec.batch_date);
89: arp_util.debug('gl_date: ' || p_batch_rec.gl_date);
90: arp_util.debug('status: ' || p_batch_rec.status);
91: arp_util.debug('type: ' || p_batch_rec.type);
92: arp_util.debug('control_count: ' || p_batch_rec.control_count);
93: arp_util.debug('control_amount: ' || p_batch_rec.control_amount);
94: arp_util.debug('comments: ' || p_batch_rec.comments);

Line 91: arp_util.debug('type: ' || p_batch_rec.type);

87: arp_util.debug('batch_source_id: ' || p_batch_rec.batch_source_id);
88: arp_util.debug('batch_date: ' || p_batch_rec.batch_date);
89: arp_util.debug('gl_date: ' || p_batch_rec.gl_date);
90: arp_util.debug('status: ' || p_batch_rec.status);
91: arp_util.debug('type: ' || p_batch_rec.type);
92: arp_util.debug('control_count: ' || p_batch_rec.control_count);
93: arp_util.debug('control_amount: ' || p_batch_rec.control_amount);
94: arp_util.debug('comments: ' || p_batch_rec.comments);
95: arp_util.debug('currency_code: ' || p_batch_rec.currency_code);

Line 92: arp_util.debug('control_count: ' || p_batch_rec.control_count);

88: arp_util.debug('batch_date: ' || p_batch_rec.batch_date);
89: arp_util.debug('gl_date: ' || p_batch_rec.gl_date);
90: arp_util.debug('status: ' || p_batch_rec.status);
91: arp_util.debug('type: ' || p_batch_rec.type);
92: arp_util.debug('control_count: ' || p_batch_rec.control_count);
93: arp_util.debug('control_amount: ' || p_batch_rec.control_amount);
94: arp_util.debug('comments: ' || p_batch_rec.comments);
95: arp_util.debug('currency_code: ' || p_batch_rec.currency_code);
96: arp_util.debug('exchange_rate_type: ' || p_batch_rec.exchange_rate_type);

Line 93: arp_util.debug('control_amount: ' || p_batch_rec.control_amount);

89: arp_util.debug('gl_date: ' || p_batch_rec.gl_date);
90: arp_util.debug('status: ' || p_batch_rec.status);
91: arp_util.debug('type: ' || p_batch_rec.type);
92: arp_util.debug('control_count: ' || p_batch_rec.control_count);
93: arp_util.debug('control_amount: ' || p_batch_rec.control_amount);
94: arp_util.debug('comments: ' || p_batch_rec.comments);
95: arp_util.debug('currency_code: ' || p_batch_rec.currency_code);
96: arp_util.debug('exchange_rate_type: ' || p_batch_rec.exchange_rate_type);
97: arp_util.debug('exchange_date: ' || p_batch_rec.exchange_date);

Line 94: arp_util.debug('comments: ' || p_batch_rec.comments);

90: arp_util.debug('status: ' || p_batch_rec.status);
91: arp_util.debug('type: ' || p_batch_rec.type);
92: arp_util.debug('control_count: ' || p_batch_rec.control_count);
93: arp_util.debug('control_amount: ' || p_batch_rec.control_amount);
94: arp_util.debug('comments: ' || p_batch_rec.comments);
95: arp_util.debug('currency_code: ' || p_batch_rec.currency_code);
96: arp_util.debug('exchange_rate_type: ' || p_batch_rec.exchange_rate_type);
97: arp_util.debug('exchange_date: ' || p_batch_rec.exchange_date);
98: arp_util.debug('exchange_rate: ' || p_batch_rec.exchange_rate);

Line 95: arp_util.debug('currency_code: ' || p_batch_rec.currency_code);

91: arp_util.debug('type: ' || p_batch_rec.type);
92: arp_util.debug('control_count: ' || p_batch_rec.control_count);
93: arp_util.debug('control_amount: ' || p_batch_rec.control_amount);
94: arp_util.debug('comments: ' || p_batch_rec.comments);
95: arp_util.debug('currency_code: ' || p_batch_rec.currency_code);
96: arp_util.debug('exchange_rate_type: ' || p_batch_rec.exchange_rate_type);
97: arp_util.debug('exchange_date: ' || p_batch_rec.exchange_date);
98: arp_util.debug('exchange_rate: ' || p_batch_rec.exchange_rate);
99: arp_util.debug('purged_children_flag:'|| p_batch_rec.purged_children_flag);

Line 96: arp_util.debug('exchange_rate_type: ' || p_batch_rec.exchange_rate_type);

92: arp_util.debug('control_count: ' || p_batch_rec.control_count);
93: arp_util.debug('control_amount: ' || p_batch_rec.control_amount);
94: arp_util.debug('comments: ' || p_batch_rec.comments);
95: arp_util.debug('currency_code: ' || p_batch_rec.currency_code);
96: arp_util.debug('exchange_rate_type: ' || p_batch_rec.exchange_rate_type);
97: arp_util.debug('exchange_date: ' || p_batch_rec.exchange_date);
98: arp_util.debug('exchange_rate: ' || p_batch_rec.exchange_rate);
99: arp_util.debug('purged_children_flag:'|| p_batch_rec.purged_children_flag);
100: arp_util.debug('attribute_category: ' || p_batch_rec.attribute_category);

Line 97: arp_util.debug('exchange_date: ' || p_batch_rec.exchange_date);

93: arp_util.debug('control_amount: ' || p_batch_rec.control_amount);
94: arp_util.debug('comments: ' || p_batch_rec.comments);
95: arp_util.debug('currency_code: ' || p_batch_rec.currency_code);
96: arp_util.debug('exchange_rate_type: ' || p_batch_rec.exchange_rate_type);
97: arp_util.debug('exchange_date: ' || p_batch_rec.exchange_date);
98: arp_util.debug('exchange_rate: ' || p_batch_rec.exchange_rate);
99: arp_util.debug('purged_children_flag:'|| p_batch_rec.purged_children_flag);
100: arp_util.debug('attribute_category: ' || p_batch_rec.attribute_category);
101: arp_util.debug('attribute1: ' || p_batch_rec.attribute1);

Line 98: arp_util.debug('exchange_rate: ' || p_batch_rec.exchange_rate);

94: arp_util.debug('comments: ' || p_batch_rec.comments);
95: arp_util.debug('currency_code: ' || p_batch_rec.currency_code);
96: arp_util.debug('exchange_rate_type: ' || p_batch_rec.exchange_rate_type);
97: arp_util.debug('exchange_date: ' || p_batch_rec.exchange_date);
98: arp_util.debug('exchange_rate: ' || p_batch_rec.exchange_rate);
99: arp_util.debug('purged_children_flag:'|| p_batch_rec.purged_children_flag);
100: arp_util.debug('attribute_category: ' || p_batch_rec.attribute_category);
101: arp_util.debug('attribute1: ' || p_batch_rec.attribute1);
102: arp_util.debug('attribute2: ' || p_batch_rec.attribute2);

Line 99: arp_util.debug('purged_children_flag:'|| p_batch_rec.purged_children_flag);

95: arp_util.debug('currency_code: ' || p_batch_rec.currency_code);
96: arp_util.debug('exchange_rate_type: ' || p_batch_rec.exchange_rate_type);
97: arp_util.debug('exchange_date: ' || p_batch_rec.exchange_date);
98: arp_util.debug('exchange_rate: ' || p_batch_rec.exchange_rate);
99: arp_util.debug('purged_children_flag:'|| p_batch_rec.purged_children_flag);
100: arp_util.debug('attribute_category: ' || p_batch_rec.attribute_category);
101: arp_util.debug('attribute1: ' || p_batch_rec.attribute1);
102: arp_util.debug('attribute2: ' || p_batch_rec.attribute2);
103: arp_util.debug('attribute3: ' || p_batch_rec.attribute3);

Line 100: arp_util.debug('attribute_category: ' || p_batch_rec.attribute_category);

96: arp_util.debug('exchange_rate_type: ' || p_batch_rec.exchange_rate_type);
97: arp_util.debug('exchange_date: ' || p_batch_rec.exchange_date);
98: arp_util.debug('exchange_rate: ' || p_batch_rec.exchange_rate);
99: arp_util.debug('purged_children_flag:'|| p_batch_rec.purged_children_flag);
100: arp_util.debug('attribute_category: ' || p_batch_rec.attribute_category);
101: arp_util.debug('attribute1: ' || p_batch_rec.attribute1);
102: arp_util.debug('attribute2: ' || p_batch_rec.attribute2);
103: arp_util.debug('attribute3: ' || p_batch_rec.attribute3);
104: arp_util.debug('attribute4: ' || p_batch_rec.attribute4);

Line 101: arp_util.debug('attribute1: ' || p_batch_rec.attribute1);

97: arp_util.debug('exchange_date: ' || p_batch_rec.exchange_date);
98: arp_util.debug('exchange_rate: ' || p_batch_rec.exchange_rate);
99: arp_util.debug('purged_children_flag:'|| p_batch_rec.purged_children_flag);
100: arp_util.debug('attribute_category: ' || p_batch_rec.attribute_category);
101: arp_util.debug('attribute1: ' || p_batch_rec.attribute1);
102: arp_util.debug('attribute2: ' || p_batch_rec.attribute2);
103: arp_util.debug('attribute3: ' || p_batch_rec.attribute3);
104: arp_util.debug('attribute4: ' || p_batch_rec.attribute4);
105: arp_util.debug('attribute5: ' || p_batch_rec.attribute5);

Line 102: arp_util.debug('attribute2: ' || p_batch_rec.attribute2);

98: arp_util.debug('exchange_rate: ' || p_batch_rec.exchange_rate);
99: arp_util.debug('purged_children_flag:'|| p_batch_rec.purged_children_flag);
100: arp_util.debug('attribute_category: ' || p_batch_rec.attribute_category);
101: arp_util.debug('attribute1: ' || p_batch_rec.attribute1);
102: arp_util.debug('attribute2: ' || p_batch_rec.attribute2);
103: arp_util.debug('attribute3: ' || p_batch_rec.attribute3);
104: arp_util.debug('attribute4: ' || p_batch_rec.attribute4);
105: arp_util.debug('attribute5: ' || p_batch_rec.attribute5);
106: arp_util.debug('attribute6: ' || p_batch_rec.attribute6);

Line 103: arp_util.debug('attribute3: ' || p_batch_rec.attribute3);

99: arp_util.debug('purged_children_flag:'|| p_batch_rec.purged_children_flag);
100: arp_util.debug('attribute_category: ' || p_batch_rec.attribute_category);
101: arp_util.debug('attribute1: ' || p_batch_rec.attribute1);
102: arp_util.debug('attribute2: ' || p_batch_rec.attribute2);
103: arp_util.debug('attribute3: ' || p_batch_rec.attribute3);
104: arp_util.debug('attribute4: ' || p_batch_rec.attribute4);
105: arp_util.debug('attribute5: ' || p_batch_rec.attribute5);
106: arp_util.debug('attribute6: ' || p_batch_rec.attribute6);
107: arp_util.debug('attribute7: ' || p_batch_rec.attribute7);

Line 104: arp_util.debug('attribute4: ' || p_batch_rec.attribute4);

100: arp_util.debug('attribute_category: ' || p_batch_rec.attribute_category);
101: arp_util.debug('attribute1: ' || p_batch_rec.attribute1);
102: arp_util.debug('attribute2: ' || p_batch_rec.attribute2);
103: arp_util.debug('attribute3: ' || p_batch_rec.attribute3);
104: arp_util.debug('attribute4: ' || p_batch_rec.attribute4);
105: arp_util.debug('attribute5: ' || p_batch_rec.attribute5);
106: arp_util.debug('attribute6: ' || p_batch_rec.attribute6);
107: arp_util.debug('attribute7: ' || p_batch_rec.attribute7);
108: arp_util.debug('attribute8: ' || p_batch_rec.attribute8);

Line 105: arp_util.debug('attribute5: ' || p_batch_rec.attribute5);

101: arp_util.debug('attribute1: ' || p_batch_rec.attribute1);
102: arp_util.debug('attribute2: ' || p_batch_rec.attribute2);
103: arp_util.debug('attribute3: ' || p_batch_rec.attribute3);
104: arp_util.debug('attribute4: ' || p_batch_rec.attribute4);
105: arp_util.debug('attribute5: ' || p_batch_rec.attribute5);
106: arp_util.debug('attribute6: ' || p_batch_rec.attribute6);
107: arp_util.debug('attribute7: ' || p_batch_rec.attribute7);
108: arp_util.debug('attribute8: ' || p_batch_rec.attribute8);
109: arp_util.debug('attribute9: ' || p_batch_rec.attribute9);

Line 106: arp_util.debug('attribute6: ' || p_batch_rec.attribute6);

102: arp_util.debug('attribute2: ' || p_batch_rec.attribute2);
103: arp_util.debug('attribute3: ' || p_batch_rec.attribute3);
104: arp_util.debug('attribute4: ' || p_batch_rec.attribute4);
105: arp_util.debug('attribute5: ' || p_batch_rec.attribute5);
106: arp_util.debug('attribute6: ' || p_batch_rec.attribute6);
107: arp_util.debug('attribute7: ' || p_batch_rec.attribute7);
108: arp_util.debug('attribute8: ' || p_batch_rec.attribute8);
109: arp_util.debug('attribute9: ' || p_batch_rec.attribute9);
110: arp_util.debug('attribute10: ' || p_batch_rec.attribute10);

Line 107: arp_util.debug('attribute7: ' || p_batch_rec.attribute7);

103: arp_util.debug('attribute3: ' || p_batch_rec.attribute3);
104: arp_util.debug('attribute4: ' || p_batch_rec.attribute4);
105: arp_util.debug('attribute5: ' || p_batch_rec.attribute5);
106: arp_util.debug('attribute6: ' || p_batch_rec.attribute6);
107: arp_util.debug('attribute7: ' || p_batch_rec.attribute7);
108: arp_util.debug('attribute8: ' || p_batch_rec.attribute8);
109: arp_util.debug('attribute9: ' || p_batch_rec.attribute9);
110: arp_util.debug('attribute10: ' || p_batch_rec.attribute10);
111: arp_util.debug('attribute11: ' || p_batch_rec.attribute11);

Line 108: arp_util.debug('attribute8: ' || p_batch_rec.attribute8);

104: arp_util.debug('attribute4: ' || p_batch_rec.attribute4);
105: arp_util.debug('attribute5: ' || p_batch_rec.attribute5);
106: arp_util.debug('attribute6: ' || p_batch_rec.attribute6);
107: arp_util.debug('attribute7: ' || p_batch_rec.attribute7);
108: arp_util.debug('attribute8: ' || p_batch_rec.attribute8);
109: arp_util.debug('attribute9: ' || p_batch_rec.attribute9);
110: arp_util.debug('attribute10: ' || p_batch_rec.attribute10);
111: arp_util.debug('attribute11: ' || p_batch_rec.attribute11);
112: arp_util.debug('attribute12: ' || p_batch_rec.attribute12);

Line 109: arp_util.debug('attribute9: ' || p_batch_rec.attribute9);

105: arp_util.debug('attribute5: ' || p_batch_rec.attribute5);
106: arp_util.debug('attribute6: ' || p_batch_rec.attribute6);
107: arp_util.debug('attribute7: ' || p_batch_rec.attribute7);
108: arp_util.debug('attribute8: ' || p_batch_rec.attribute8);
109: arp_util.debug('attribute9: ' || p_batch_rec.attribute9);
110: arp_util.debug('attribute10: ' || p_batch_rec.attribute10);
111: arp_util.debug('attribute11: ' || p_batch_rec.attribute11);
112: arp_util.debug('attribute12: ' || p_batch_rec.attribute12);
113: arp_util.debug('attribute13: ' || p_batch_rec.attribute13);

Line 110: arp_util.debug('attribute10: ' || p_batch_rec.attribute10);

106: arp_util.debug('attribute6: ' || p_batch_rec.attribute6);
107: arp_util.debug('attribute7: ' || p_batch_rec.attribute7);
108: arp_util.debug('attribute8: ' || p_batch_rec.attribute8);
109: arp_util.debug('attribute9: ' || p_batch_rec.attribute9);
110: arp_util.debug('attribute10: ' || p_batch_rec.attribute10);
111: arp_util.debug('attribute11: ' || p_batch_rec.attribute11);
112: arp_util.debug('attribute12: ' || p_batch_rec.attribute12);
113: arp_util.debug('attribute13: ' || p_batch_rec.attribute13);
114: arp_util.debug('attribute14: ' || p_batch_rec.attribute14);

Line 111: arp_util.debug('attribute11: ' || p_batch_rec.attribute11);

107: arp_util.debug('attribute7: ' || p_batch_rec.attribute7);
108: arp_util.debug('attribute8: ' || p_batch_rec.attribute8);
109: arp_util.debug('attribute9: ' || p_batch_rec.attribute9);
110: arp_util.debug('attribute10: ' || p_batch_rec.attribute10);
111: arp_util.debug('attribute11: ' || p_batch_rec.attribute11);
112: arp_util.debug('attribute12: ' || p_batch_rec.attribute12);
113: arp_util.debug('attribute13: ' || p_batch_rec.attribute13);
114: arp_util.debug('attribute14: ' || p_batch_rec.attribute14);
115: arp_util.debug('attribute15: ' || p_batch_rec.attribute15);

Line 112: arp_util.debug('attribute12: ' || p_batch_rec.attribute12);

108: arp_util.debug('attribute8: ' || p_batch_rec.attribute8);
109: arp_util.debug('attribute9: ' || p_batch_rec.attribute9);
110: arp_util.debug('attribute10: ' || p_batch_rec.attribute10);
111: arp_util.debug('attribute11: ' || p_batch_rec.attribute11);
112: arp_util.debug('attribute12: ' || p_batch_rec.attribute12);
113: arp_util.debug('attribute13: ' || p_batch_rec.attribute13);
114: arp_util.debug('attribute14: ' || p_batch_rec.attribute14);
115: arp_util.debug('attribute15: ' || p_batch_rec.attribute15);
116: arp_util.debug('program_application_id: ' || p_batch_rec.program_application_id);

Line 113: arp_util.debug('attribute13: ' || p_batch_rec.attribute13);

109: arp_util.debug('attribute9: ' || p_batch_rec.attribute9);
110: arp_util.debug('attribute10: ' || p_batch_rec.attribute10);
111: arp_util.debug('attribute11: ' || p_batch_rec.attribute11);
112: arp_util.debug('attribute12: ' || p_batch_rec.attribute12);
113: arp_util.debug('attribute13: ' || p_batch_rec.attribute13);
114: arp_util.debug('attribute14: ' || p_batch_rec.attribute14);
115: arp_util.debug('attribute15: ' || p_batch_rec.attribute15);
116: arp_util.debug('program_application_id: ' || p_batch_rec.program_application_id);
117: arp_util.debug('issue_date: ' || p_batch_rec.issue_date);

Line 114: arp_util.debug('attribute14: ' || p_batch_rec.attribute14);

110: arp_util.debug('attribute10: ' || p_batch_rec.attribute10);
111: arp_util.debug('attribute11: ' || p_batch_rec.attribute11);
112: arp_util.debug('attribute12: ' || p_batch_rec.attribute12);
113: arp_util.debug('attribute13: ' || p_batch_rec.attribute13);
114: arp_util.debug('attribute14: ' || p_batch_rec.attribute14);
115: arp_util.debug('attribute15: ' || p_batch_rec.attribute15);
116: arp_util.debug('program_application_id: ' || p_batch_rec.program_application_id);
117: arp_util.debug('issue_date: ' || p_batch_rec.issue_date);
118: arp_util.debug('maturity_date: ' || p_batch_rec.maturity_date);

Line 115: arp_util.debug('attribute15: ' || p_batch_rec.attribute15);

111: arp_util.debug('attribute11: ' || p_batch_rec.attribute11);
112: arp_util.debug('attribute12: ' || p_batch_rec.attribute12);
113: arp_util.debug('attribute13: ' || p_batch_rec.attribute13);
114: arp_util.debug('attribute14: ' || p_batch_rec.attribute14);
115: arp_util.debug('attribute15: ' || p_batch_rec.attribute15);
116: arp_util.debug('program_application_id: ' || p_batch_rec.program_application_id);
117: arp_util.debug('issue_date: ' || p_batch_rec.issue_date);
118: arp_util.debug('maturity_date: ' || p_batch_rec.maturity_date);
119: arp_util.debug('special_instructions: ' || p_batch_rec.special_instructions);

Line 116: arp_util.debug('program_application_id: ' || p_batch_rec.program_application_id);

112: arp_util.debug('attribute12: ' || p_batch_rec.attribute12);
113: arp_util.debug('attribute13: ' || p_batch_rec.attribute13);
114: arp_util.debug('attribute14: ' || p_batch_rec.attribute14);
115: arp_util.debug('attribute15: ' || p_batch_rec.attribute15);
116: arp_util.debug('program_application_id: ' || p_batch_rec.program_application_id);
117: arp_util.debug('issue_date: ' || p_batch_rec.issue_date);
118: arp_util.debug('maturity_date: ' || p_batch_rec.maturity_date);
119: arp_util.debug('special_instructions: ' || p_batch_rec.special_instructions);
120: arp_util.debug('batch_process_status: ' || p_batch_rec.batch_process_status);

Line 117: arp_util.debug('issue_date: ' || p_batch_rec.issue_date);

113: arp_util.debug('attribute13: ' || p_batch_rec.attribute13);
114: arp_util.debug('attribute14: ' || p_batch_rec.attribute14);
115: arp_util.debug('attribute15: ' || p_batch_rec.attribute15);
116: arp_util.debug('program_application_id: ' || p_batch_rec.program_application_id);
117: arp_util.debug('issue_date: ' || p_batch_rec.issue_date);
118: arp_util.debug('maturity_date: ' || p_batch_rec.maturity_date);
119: arp_util.debug('special_instructions: ' || p_batch_rec.special_instructions);
120: arp_util.debug('batch_process_status: ' || p_batch_rec.batch_process_status);
121: arp_util.debug('selection_criteria_id: ' || p_batch_rec.selection_criteria_id);

Line 118: arp_util.debug('maturity_date: ' || p_batch_rec.maturity_date);

114: arp_util.debug('attribute14: ' || p_batch_rec.attribute14);
115: arp_util.debug('attribute15: ' || p_batch_rec.attribute15);
116: arp_util.debug('program_application_id: ' || p_batch_rec.program_application_id);
117: arp_util.debug('issue_date: ' || p_batch_rec.issue_date);
118: arp_util.debug('maturity_date: ' || p_batch_rec.maturity_date);
119: arp_util.debug('special_instructions: ' || p_batch_rec.special_instructions);
120: arp_util.debug('batch_process_status: ' || p_batch_rec.batch_process_status);
121: arp_util.debug('selection_criteria_id: ' || p_batch_rec.selection_criteria_id);
122: arp_util.debug('request_id: ' || p_batch_rec.request_id);

Line 119: arp_util.debug('special_instructions: ' || p_batch_rec.special_instructions);

115: arp_util.debug('attribute15: ' || p_batch_rec.attribute15);
116: arp_util.debug('program_application_id: ' || p_batch_rec.program_application_id);
117: arp_util.debug('issue_date: ' || p_batch_rec.issue_date);
118: arp_util.debug('maturity_date: ' || p_batch_rec.maturity_date);
119: arp_util.debug('special_instructions: ' || p_batch_rec.special_instructions);
120: arp_util.debug('batch_process_status: ' || p_batch_rec.batch_process_status);
121: arp_util.debug('selection_criteria_id: ' || p_batch_rec.selection_criteria_id);
122: arp_util.debug('request_id: ' || p_batch_rec.request_id);
123: arp_util.debug('************** End ra_batches record **************');

Line 120: arp_util.debug('batch_process_status: ' || p_batch_rec.batch_process_status);

116: arp_util.debug('program_application_id: ' || p_batch_rec.program_application_id);
117: arp_util.debug('issue_date: ' || p_batch_rec.issue_date);
118: arp_util.debug('maturity_date: ' || p_batch_rec.maturity_date);
119: arp_util.debug('special_instructions: ' || p_batch_rec.special_instructions);
120: arp_util.debug('batch_process_status: ' || p_batch_rec.batch_process_status);
121: arp_util.debug('selection_criteria_id: ' || p_batch_rec.selection_criteria_id);
122: arp_util.debug('request_id: ' || p_batch_rec.request_id);
123: arp_util.debug('************** End ra_batches record **************');
124:

Line 121: arp_util.debug('selection_criteria_id: ' || p_batch_rec.selection_criteria_id);

117: arp_util.debug('issue_date: ' || p_batch_rec.issue_date);
118: arp_util.debug('maturity_date: ' || p_batch_rec.maturity_date);
119: arp_util.debug('special_instructions: ' || p_batch_rec.special_instructions);
120: arp_util.debug('batch_process_status: ' || p_batch_rec.batch_process_status);
121: arp_util.debug('selection_criteria_id: ' || p_batch_rec.selection_criteria_id);
122: arp_util.debug('request_id: ' || p_batch_rec.request_id);
123: arp_util.debug('************** End ra_batches record **************');
124:
125: arp_util.debug('arp_tbat_pgk.display_batch_rec()-');

Line 122: arp_util.debug('request_id: ' || p_batch_rec.request_id);

118: arp_util.debug('maturity_date: ' || p_batch_rec.maturity_date);
119: arp_util.debug('special_instructions: ' || p_batch_rec.special_instructions);
120: arp_util.debug('batch_process_status: ' || p_batch_rec.batch_process_status);
121: arp_util.debug('selection_criteria_id: ' || p_batch_rec.selection_criteria_id);
122: arp_util.debug('request_id: ' || p_batch_rec.request_id);
123: arp_util.debug('************** End ra_batches record **************');
124:
125: arp_util.debug('arp_tbat_pgk.display_batch_rec()-');
126:

Line 123: arp_util.debug(' End ra_batches record ');

119: arp_util.debug('special_instructions: ' || p_batch_rec.special_instructions);
120: arp_util.debug('batch_process_status: ' || p_batch_rec.batch_process_status);
121: arp_util.debug('selection_criteria_id: ' || p_batch_rec.selection_criteria_id);
122: arp_util.debug('request_id: ' || p_batch_rec.request_id);
123: arp_util.debug('************** End ra_batches record **************');
124:
125: arp_util.debug('arp_tbat_pgk.display_batch_rec()-');
126:
127: EXCEPTION

Line 125: arp_util.debug('arp_tbat_pgk.display_batch_rec()-');

121: arp_util.debug('selection_criteria_id: ' || p_batch_rec.selection_criteria_id);
122: arp_util.debug('request_id: ' || p_batch_rec.request_id);
123: arp_util.debug('************** End ra_batches record **************');
124:
125: arp_util.debug('arp_tbat_pgk.display_batch_rec()-');
126:
127: EXCEPTION
128: WHEN OTHERS THEN
129: arp_util.debug('EXCEPTION: arp_tbat_pgk.display_batch_rec()');

Line 129: arp_util.debug('EXCEPTION: arp_tbat_pgk.display_batch_rec()');

125: arp_util.debug('arp_tbat_pgk.display_batch_rec()-');
126:
127: EXCEPTION
128: WHEN OTHERS THEN
129: arp_util.debug('EXCEPTION: arp_tbat_pgk.display_batch_rec()');
130: RAISE;
131:
132: END;
133:

Line 146: | arp_util.debug |

142: | |
143: | SCOPE - PRIVATE |
144: | |
145: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
146: | arp_util.debug |
147: | |
148: | ARGUMENTS : IN: |
149: | p_batch_id |
150: | OUT: |

Line 171: arp_util.debug('arp_tbat_pgk.display_batch()+');

167: l_batch_rec ra_batches%rowtype;
168:
169: BEGIN
170:
171: arp_util.debug('arp_tbat_pgk.display_batch()+');
172:
173: arp_tbat_pkg.fetch_p(l_batch_rec, p_batch_id);
174:
175: arp_tbat_pkg.display_batch_rec (l_batch_rec);

Line 177: arp_util.debug('arp_tbat_pgk.display_batch()-');

173: arp_tbat_pkg.fetch_p(l_batch_rec, p_batch_id);
174:
175: arp_tbat_pkg.display_batch_rec (l_batch_rec);
176:
177: arp_util.debug('arp_tbat_pgk.display_batch()-');
178:
179: EXCEPTION
180: WHEN OTHERS THEN
181: arp_util.debug('EXCEPTION: arp_tbat_pgk.display_batch()');

Line 181: arp_util.debug('EXCEPTION: arp_tbat_pgk.display_batch()');

177: arp_util.debug('arp_tbat_pgk.display_batch()-');
178:
179: EXCEPTION
180: WHEN OTHERS THEN
181: arp_util.debug('EXCEPTION: arp_tbat_pgk.display_batch()');
182: RAISE;
183:
184: END;
185:

Line 199: | arp_util.debug |

195: | SCOPE - PRIVATE |
196: | |
197: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
198: | dbms_sql.bind_variable |
199: | arp_util.debug |
200: | |
201: | ARGUMENTS : IN: |
202: | p_update_cursor - ID of the update cursor |
203: | p_batch_rec - ra_batches record |

Line 232: arp_util.debug('arp_tbat_pkg.bind_batch_variables()+');

228: p_batch_rec IN ra_batches%rowtype) IS
229:
230: BEGIN
231:
232: arp_util.debug('arp_tbat_pkg.bind_batch_variables()+');
233:
234: /*------------------+
235: | Dummy constants |
236: +------------------*/

Line 359: arp_util.debug('arp_tbat_pkg.bind_batch_variables()-');

355: p_batch_rec.selection_criteria_id);
356: dbms_sql.bind_variable(p_update_cursor, ':request_id',
357: p_batch_rec.request_id);
358:
359: arp_util.debug('arp_tbat_pkg.bind_batch_variables()-');
360:
361: EXCEPTION
362: WHEN OTHERS THEN
363: arp_util.debug('EXCEPTION: arp_tbat_pkg.bind_batch_variables()');

Line 363: arp_util.debug('EXCEPTION: arp_tbat_pkg.bind_batch_variables()');

359: arp_util.debug('arp_tbat_pkg.bind_batch_variables()-');
360:
361: EXCEPTION
362: WHEN OTHERS THEN
363: arp_util.debug('EXCEPTION: arp_tbat_pkg.bind_batch_variables()');
364: RAISE;
365:
366: END;
367:

Line 381: | arp_util.debug |

377: | |
378: | SCOPE - PRIVATE |
379: | |
380: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
381: | arp_util.debug |
382: | |
383: | ARGUMENTS : IN: |
384: | None. |
385: | OUT: |

Line 412: arp_util.debug('arp_tbat_pkg.construct_batch_update_stmt()+');

408:
409: PROCEDURE construct_batch_update_stmt( update_text OUT NOCOPY varchar2) IS
410:
411: BEGIN
412: arp_util.debug('arp_tbat_pkg.construct_batch_update_stmt()+');
413:
414: update_text :=
415: 'update ra_batches
416: SET batch_id =

Line 602: arp_util.debug('arp_tbat_pkg.construct_batch_update_stmt()-');

598: DECODE(:request_id,
599: :ar_number_dummy, request_id,
600: :request_id) ';
601:
602: arp_util.debug('arp_tbat_pkg.construct_batch_update_stmt()-');
603:
604: EXCEPTION
605: WHEN OTHERS THEN
606: arp_util.debug('EXCEPTION: arp_tbat_pkg.construct_batch_update_stmt()');

Line 606: arp_util.debug('EXCEPTION: arp_tbat_pkg.construct_batch_update_stmt()');

602: arp_util.debug('arp_tbat_pkg.construct_batch_update_stmt()-');
603:
604: EXCEPTION
605: WHEN OTHERS THEN
606: arp_util.debug('EXCEPTION: arp_tbat_pkg.construct_batch_update_stmt()');
607: RAISE;
608:
609: END;
610:

Line 624: | arp_util.debug |

620: | |
621: | SCOPE - PRIVATE |
622: | |
623: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
624: | arp_util.debug |
625: | dbms_sql.open_cursor |
626: | dbms_sql.parse |
627: | dbms_sql.execute |
628: | dbms_sql.close_cursor |

Line 658: arp_util.debug('arp_tbat_pkg.generic_update()+');

654: l_ra_batch_key_value_list gl_ca_utility_pkg.r_key_value_arr;
655: ra_batch_array dbms_sql.number_table;
656:
657: BEGIN
658: arp_util.debug('arp_tbat_pkg.generic_update()+');
659:
660: /*--------------------------------------------------------------+
661: | If this update statement has not already been parsed, |
662: | construct the statement and parse it. |

Line 713: arp_util.debug( to_char(l_count) || ' rows updated');

709: p_where1);
710:
711: l_count := dbms_sql.execute(p_update_cursor);
712:
713: arp_util.debug( to_char(l_count) || ' rows updated');
714:
715: /*------------------------------------------+
716: | get RETURNING COLUMN into OUT NOCOPY bind array |
717: +------------------------------------------*/

Line 744: arp_util.debug('arp_tbat_pkg.generic_update()-');

740: -- p_key_value => ra_batch_array(I));
741: -- END LOOP;
742: --}
743:
744: arp_util.debug('arp_tbat_pkg.generic_update()-');
745:
746: EXCEPTION
747: WHEN OTHERS THEN
748: arp_util.debug('EXCEPTION: arp_tbat_pkg.generic_update()');

Line 748: arp_util.debug('EXCEPTION: arp_tbat_pkg.generic_update()');

744: arp_util.debug('arp_tbat_pkg.generic_update()-');
745:
746: EXCEPTION
747: WHEN OTHERS THEN
748: arp_util.debug('EXCEPTION: arp_tbat_pkg.generic_update()');
749: arp_util.debug(l_update_statement);
750: arp_util.debug('Error at character: ' ||
751: to_char(dbms_sql.last_error_position));
752: RAISE;

Line 749: arp_util.debug(l_update_statement);

745:
746: EXCEPTION
747: WHEN OTHERS THEN
748: arp_util.debug('EXCEPTION: arp_tbat_pkg.generic_update()');
749: arp_util.debug(l_update_statement);
750: arp_util.debug('Error at character: ' ||
751: to_char(dbms_sql.last_error_position));
752: RAISE;
753: END;

Line 750: arp_util.debug('Error at character: ' ||

746: EXCEPTION
747: WHEN OTHERS THEN
748: arp_util.debug('EXCEPTION: arp_tbat_pkg.generic_update()');
749: arp_util.debug(l_update_statement);
750: arp_util.debug('Error at character: ' ||
751: to_char(dbms_sql.last_error_position));
752: RAISE;
753: END;
754:

Line 772: | arp_util.debug |

768: | |
769: | SCOPE - PUBLIC |
770: | |
771: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
772: | arp_util.debug |
773: | |
774: | ARGUMENTS : IN: |
775: | None |
776: | OUT: |

Line 802: arp_util.debug('arp_tbat_pkg.set_to_dummy()+');

798: PROCEDURE set_to_dummy( p_batch_rec OUT NOCOPY ra_batches%rowtype) IS
799:
800: BEGIN
801:
802: arp_util.debug('arp_tbat_pkg.set_to_dummy()+');
803:
804: p_batch_rec.batch_id := AR_NUMBER_DUMMY;
805: p_batch_rec.last_update_date := AR_DATE_DUMMY;
806: p_batch_rec.last_updated_by := AR_NUMBER_DUMMY;

Line 851: arp_util.debug('arp_tbat_pkg.set_to_dummy()-');

847: p_batch_rec.batch_process_status := AR_TEXT_DUMMY;
848: p_batch_rec.selection_criteria_id := AR_NUMBER_DUMMY;
849: p_batch_rec.request_id := AR_NUMBER_DUMMY;
850:
851: arp_util.debug('arp_tbat_pkg.set_to_dummy()-');
852:
853: EXCEPTION
854: WHEN OTHERS THEN
855: arp_util.debug('EXCEPTION: arp_tbat_pkg.set_to_dummy()');

Line 855: arp_util.debug('EXCEPTION: arp_tbat_pkg.set_to_dummy()');

851: arp_util.debug('arp_tbat_pkg.set_to_dummy()-');
852:
853: EXCEPTION
854: WHEN OTHERS THEN
855: arp_util.debug('EXCEPTION: arp_tbat_pkg.set_to_dummy()');
856: RAISE;
857:
858: END;
859:

Line 871: | arp_util.debug |

867: | |
868: | SCOPE - PUBLIC |
869: | |
870: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
871: | arp_util.debug |
872: | |
873: | ARGUMENTS : IN: |
874: | p_batch_id - identifies the record to fetch |
875: | OUT: |

Line 891: arp_util.debug('arp_tbat_pkg.fetch_p()+');

887: PROCEDURE fetch_p( p_batch_rec OUT NOCOPY ra_batches%rowtype,
888: p_batch_id IN ra_batches.batch_id%type ) IS
889:
890: BEGIN
891: arp_util.debug('arp_tbat_pkg.fetch_p()+');
892:
893: SELECT *
894: INTO p_batch_rec
895: FROM ra_batches

Line 898: arp_util.debug('arp_tbat_pkg.fetch_p()-');

894: INTO p_batch_rec
895: FROM ra_batches
896: WHERE batch_id = p_batch_id;
897:
898: arp_util.debug('arp_tbat_pkg.fetch_p()-');
899:
900: EXCEPTION
901: WHEN OTHERS THEN
902: arp_util.debug('EXCEPTION: arp_tbat_pkg.fetch_p' );

Line 902: arp_util.debug('EXCEPTION: arp_tbat_pkg.fetch_p' );

898: arp_util.debug('arp_tbat_pkg.fetch_p()-');
899:
900: EXCEPTION
901: WHEN OTHERS THEN
902: arp_util.debug('EXCEPTION: arp_tbat_pkg.fetch_p' );
903: RAISE;
904: END;
905:
906: /*===========================================================================+

Line 917: | arp_util.debug |

913: | |
914: | SCOPE - PUBLIC |
915: | |
916: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
917: | arp_util.debug |
918: | |
919: | ARGUMENTS : IN: |
920: | p_batch_id - identifies the row to lock |
921: | OUT: |

Line 938: arp_util.debug('arp_tbat_pkg.lock_p()+');

934:
935: l_batch_id ra_batches.batch_id%type;
936:
937: BEGIN
938: arp_util.debug('arp_tbat_pkg.lock_p()+');
939:
940: SELECT batch_id
941: INTO l_batch_id
942: FROM ra_batches

Line 946: arp_util.debug('arp_tbat_pkg.lock_p()-');

942: FROM ra_batches
943: WHERE batch_id = p_batch_id
944: FOR UPDATE OF batch_id NOWAIT;
945:
946: arp_util.debug('arp_tbat_pkg.lock_p()-');
947:
948: EXCEPTION
949: WHEN OTHERS THEN
950: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_p' );

Line 950: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_p' );

946: arp_util.debug('arp_tbat_pkg.lock_p()-');
947:
948: EXCEPTION
949: WHEN OTHERS THEN
950: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_p' );
951: RAISE;
952: END;
953:
954: /*===========================================================================+

Line 966: | arp_util.debug |

962: | |
963: | SCOPE - PUBLIC |
964: | |
965: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
966: | arp_util.debug |
967: | |
968: | ARGUMENTS : IN: |
969: | p_batch_id - identifies the row to lock |
970: | OUT: |

Line 986: arp_util.debug('arp_tbat_pkg.lock_fetch_p()+');

982: PROCEDURE lock_fetch_p( p_batch_rec IN OUT NOCOPY ra_batches%rowtype,
983: p_batch_id IN ra_batches.batch_id%type ) IS
984:
985: BEGIN
986: arp_util.debug('arp_tbat_pkg.lock_fetch_p()+');
987:
988: SELECT *
989: INTO p_batch_rec
990: FROM ra_batches

Line 994: arp_util.debug('arp_tbat_pkg.lock_fetch_p()-');

990: FROM ra_batches
991: WHERE batch_id = p_batch_id
992: FOR UPDATE OF batch_id NOWAIT;
993:
994: arp_util.debug('arp_tbat_pkg.lock_fetch_p()-');
995:
996: EXCEPTION
997: WHEN OTHERS THEN
998: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_fetch_p' );

Line 998: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_fetch_p' );

994: arp_util.debug('arp_tbat_pkg.lock_fetch_p()-');
995:
996: EXCEPTION
997: WHEN OTHERS THEN
998: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_fetch_p' );
999: RAISE;
1000: END;
1001:
1002: /*===========================================================================+

Line 1014: | arp_util.debug |

1010: | |
1011: | SCOPE - PUBLIC |
1012: | |
1013: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1014: | arp_util.debug |
1015: | |
1016: | ARGUMENTS : IN: |
1017: | p_batch_id - identifies the row to lock |
1018: | p_batch_rec - batch record for comparison |

Line 1048: arp_util.debug('arp_tbat_pkg.lock_compare_p()+');

1044:
1045: l_new_batch_rec ra_batches%rowtype;
1046:
1047: BEGIN
1048: arp_util.debug('arp_tbat_pkg.lock_compare_p()+');
1049:
1050: SELECT *
1051: INTO l_new_batch_rec
1052: FROM ra_batches tbat

Line 1426: arp_util.debug('arp_tbat_pkg.lock_compare_p()-');

1422: )
1423: )
1424: FOR UPDATE OF batch_id NOWAIT;
1425:
1426: arp_util.debug('arp_tbat_pkg.lock_compare_p()-');
1427:
1428: EXCEPTION
1429: WHEN OTHERS THEN
1430: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_compare_p' );

Line 1430: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_compare_p' );

1426: arp_util.debug('arp_tbat_pkg.lock_compare_p()-');
1427:
1428: EXCEPTION
1429: WHEN OTHERS THEN
1430: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_compare_p' );
1431: RAISE;
1432: END;
1433:
1434: /*===========================================================================+

Line 1444: | arp_util.debug |

1440: | |
1441: | SCOPE - PRIVATE |
1442: | |
1443: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1444: | arp_util.debug |
1445: | |
1446: | ARGUMENTS : IN: |
1447: | p_form_name |
1448: | p_form_version |

Line 1519: arp_util.debug('arp_tbat_pkg.lock_compare_cover()+');

1515: p_attribute15 IN ra_batches.attribute15%type)
1516: IS
1517: l_batch_rec ra_batches%rowtype;
1518: BEGIN
1519: arp_util.debug('arp_tbat_pkg.lock_compare_cover()+');
1520:
1521: arp_tbat_pkg.set_to_dummy(l_batch_rec);
1522:
1523: l_batch_rec.batch_id := p_batch_id;

Line 1560: arp_util.debug('arp_tbat_pkg.lock_compare_cover()-');

1556:
1557: arp_tbat_pkg.lock_compare_p(l_batch_rec,
1558: p_batch_id);
1559:
1560: arp_util.debug('arp_tbat_pkg.lock_compare_cover()-');
1561:
1562: EXCEPTION
1563: WHEN OTHERS THEN
1564: arp_util.debug('EXCEPTION : arp_tbat_pkg.lock_compare_cover');

Line 1564: arp_util.debug('EXCEPTION : arp_tbat_pkg.lock_compare_cover');

1560: arp_util.debug('arp_tbat_pkg.lock_compare_cover()-');
1561:
1562: EXCEPTION
1563: WHEN OTHERS THEN
1564: arp_util.debug('EXCEPTION : arp_tbat_pkg.lock_compare_cover');
1565: arp_util.debug('p_batch_id : '||p_batch_id);
1566: arp_util.debug('p_name : '||p_name);
1567: arp_util.debug('p_batch_source_id : '||p_batch_source_id);
1568: arp_util.debug('p_batch_date : '||p_batch_date);

Line 1565: arp_util.debug('p_batch_id : '||p_batch_id);

1561:
1562: EXCEPTION
1563: WHEN OTHERS THEN
1564: arp_util.debug('EXCEPTION : arp_tbat_pkg.lock_compare_cover');
1565: arp_util.debug('p_batch_id : '||p_batch_id);
1566: arp_util.debug('p_name : '||p_name);
1567: arp_util.debug('p_batch_source_id : '||p_batch_source_id);
1568: arp_util.debug('p_batch_date : '||p_batch_date);
1569: arp_util.debug('p_gl_date : '||p_gl_date);

Line 1566: arp_util.debug('p_name : '||p_name);

1562: EXCEPTION
1563: WHEN OTHERS THEN
1564: arp_util.debug('EXCEPTION : arp_tbat_pkg.lock_compare_cover');
1565: arp_util.debug('p_batch_id : '||p_batch_id);
1566: arp_util.debug('p_name : '||p_name);
1567: arp_util.debug('p_batch_source_id : '||p_batch_source_id);
1568: arp_util.debug('p_batch_date : '||p_batch_date);
1569: arp_util.debug('p_gl_date : '||p_gl_date);
1570: arp_util.debug('p_status : '||p_status);

Line 1567: arp_util.debug('p_batch_source_id : '||p_batch_source_id);

1563: WHEN OTHERS THEN
1564: arp_util.debug('EXCEPTION : arp_tbat_pkg.lock_compare_cover');
1565: arp_util.debug('p_batch_id : '||p_batch_id);
1566: arp_util.debug('p_name : '||p_name);
1567: arp_util.debug('p_batch_source_id : '||p_batch_source_id);
1568: arp_util.debug('p_batch_date : '||p_batch_date);
1569: arp_util.debug('p_gl_date : '||p_gl_date);
1570: arp_util.debug('p_status : '||p_status);
1571: arp_util.debug('p_type : '||p_type);

Line 1568: arp_util.debug('p_batch_date : '||p_batch_date);

1564: arp_util.debug('EXCEPTION : arp_tbat_pkg.lock_compare_cover');
1565: arp_util.debug('p_batch_id : '||p_batch_id);
1566: arp_util.debug('p_name : '||p_name);
1567: arp_util.debug('p_batch_source_id : '||p_batch_source_id);
1568: arp_util.debug('p_batch_date : '||p_batch_date);
1569: arp_util.debug('p_gl_date : '||p_gl_date);
1570: arp_util.debug('p_status : '||p_status);
1571: arp_util.debug('p_type : '||p_type);
1572: arp_util.debug('p_currency_code : '||p_currency_code);

Line 1569: arp_util.debug('p_gl_date : '||p_gl_date);

1565: arp_util.debug('p_batch_id : '||p_batch_id);
1566: arp_util.debug('p_name : '||p_name);
1567: arp_util.debug('p_batch_source_id : '||p_batch_source_id);
1568: arp_util.debug('p_batch_date : '||p_batch_date);
1569: arp_util.debug('p_gl_date : '||p_gl_date);
1570: arp_util.debug('p_status : '||p_status);
1571: arp_util.debug('p_type : '||p_type);
1572: arp_util.debug('p_currency_code : '||p_currency_code);
1573: arp_util.debug('p_exchange_rate_type : '||p_exchange_rate_type);

Line 1570: arp_util.debug('p_status : '||p_status);

1566: arp_util.debug('p_name : '||p_name);
1567: arp_util.debug('p_batch_source_id : '||p_batch_source_id);
1568: arp_util.debug('p_batch_date : '||p_batch_date);
1569: arp_util.debug('p_gl_date : '||p_gl_date);
1570: arp_util.debug('p_status : '||p_status);
1571: arp_util.debug('p_type : '||p_type);
1572: arp_util.debug('p_currency_code : '||p_currency_code);
1573: arp_util.debug('p_exchange_rate_type : '||p_exchange_rate_type);
1574: arp_util.debug('p_exchange_date : '||p_exchange_date);

Line 1571: arp_util.debug('p_type : '||p_type);

1567: arp_util.debug('p_batch_source_id : '||p_batch_source_id);
1568: arp_util.debug('p_batch_date : '||p_batch_date);
1569: arp_util.debug('p_gl_date : '||p_gl_date);
1570: arp_util.debug('p_status : '||p_status);
1571: arp_util.debug('p_type : '||p_type);
1572: arp_util.debug('p_currency_code : '||p_currency_code);
1573: arp_util.debug('p_exchange_rate_type : '||p_exchange_rate_type);
1574: arp_util.debug('p_exchange_date : '||p_exchange_date);
1575: arp_util.debug('p_exchange_rate : '||p_exchange_rate);

Line 1572: arp_util.debug('p_currency_code : '||p_currency_code);

1568: arp_util.debug('p_batch_date : '||p_batch_date);
1569: arp_util.debug('p_gl_date : '||p_gl_date);
1570: arp_util.debug('p_status : '||p_status);
1571: arp_util.debug('p_type : '||p_type);
1572: arp_util.debug('p_currency_code : '||p_currency_code);
1573: arp_util.debug('p_exchange_rate_type : '||p_exchange_rate_type);
1574: arp_util.debug('p_exchange_date : '||p_exchange_date);
1575: arp_util.debug('p_exchange_rate : '||p_exchange_rate);
1576: arp_util.debug('p_control_count : '||p_control_count);

Line 1573: arp_util.debug('p_exchange_rate_type : '||p_exchange_rate_type);

1569: arp_util.debug('p_gl_date : '||p_gl_date);
1570: arp_util.debug('p_status : '||p_status);
1571: arp_util.debug('p_type : '||p_type);
1572: arp_util.debug('p_currency_code : '||p_currency_code);
1573: arp_util.debug('p_exchange_rate_type : '||p_exchange_rate_type);
1574: arp_util.debug('p_exchange_date : '||p_exchange_date);
1575: arp_util.debug('p_exchange_rate : '||p_exchange_rate);
1576: arp_util.debug('p_control_count : '||p_control_count);
1577: arp_util.debug('p_control_amount : '||p_control_amount);

Line 1574: arp_util.debug('p_exchange_date : '||p_exchange_date);

1570: arp_util.debug('p_status : '||p_status);
1571: arp_util.debug('p_type : '||p_type);
1572: arp_util.debug('p_currency_code : '||p_currency_code);
1573: arp_util.debug('p_exchange_rate_type : '||p_exchange_rate_type);
1574: arp_util.debug('p_exchange_date : '||p_exchange_date);
1575: arp_util.debug('p_exchange_rate : '||p_exchange_rate);
1576: arp_util.debug('p_control_count : '||p_control_count);
1577: arp_util.debug('p_control_amount : '||p_control_amount);
1578: arp_util.debug('p_comments : '||p_comments);

Line 1575: arp_util.debug('p_exchange_rate : '||p_exchange_rate);

1571: arp_util.debug('p_type : '||p_type);
1572: arp_util.debug('p_currency_code : '||p_currency_code);
1573: arp_util.debug('p_exchange_rate_type : '||p_exchange_rate_type);
1574: arp_util.debug('p_exchange_date : '||p_exchange_date);
1575: arp_util.debug('p_exchange_rate : '||p_exchange_rate);
1576: arp_util.debug('p_control_count : '||p_control_count);
1577: arp_util.debug('p_control_amount : '||p_control_amount);
1578: arp_util.debug('p_comments : '||p_comments);
1579: arp_util.debug('p_set_of_books_id : '||p_set_of_books_id);

Line 1576: arp_util.debug('p_control_count : '||p_control_count);

1572: arp_util.debug('p_currency_code : '||p_currency_code);
1573: arp_util.debug('p_exchange_rate_type : '||p_exchange_rate_type);
1574: arp_util.debug('p_exchange_date : '||p_exchange_date);
1575: arp_util.debug('p_exchange_rate : '||p_exchange_rate);
1576: arp_util.debug('p_control_count : '||p_control_count);
1577: arp_util.debug('p_control_amount : '||p_control_amount);
1578: arp_util.debug('p_comments : '||p_comments);
1579: arp_util.debug('p_set_of_books_id : '||p_set_of_books_id);
1580: arp_util.debug('p_purged_children_flag : '||p_purged_children_flag);

Line 1577: arp_util.debug('p_control_amount : '||p_control_amount);

1573: arp_util.debug('p_exchange_rate_type : '||p_exchange_rate_type);
1574: arp_util.debug('p_exchange_date : '||p_exchange_date);
1575: arp_util.debug('p_exchange_rate : '||p_exchange_rate);
1576: arp_util.debug('p_control_count : '||p_control_count);
1577: arp_util.debug('p_control_amount : '||p_control_amount);
1578: arp_util.debug('p_comments : '||p_comments);
1579: arp_util.debug('p_set_of_books_id : '||p_set_of_books_id);
1580: arp_util.debug('p_purged_children_flag : '||p_purged_children_flag);
1581: arp_util.debug('p_attribute_category : '||p_attribute_category);

Line 1578: arp_util.debug('p_comments : '||p_comments);

1574: arp_util.debug('p_exchange_date : '||p_exchange_date);
1575: arp_util.debug('p_exchange_rate : '||p_exchange_rate);
1576: arp_util.debug('p_control_count : '||p_control_count);
1577: arp_util.debug('p_control_amount : '||p_control_amount);
1578: arp_util.debug('p_comments : '||p_comments);
1579: arp_util.debug('p_set_of_books_id : '||p_set_of_books_id);
1580: arp_util.debug('p_purged_children_flag : '||p_purged_children_flag);
1581: arp_util.debug('p_attribute_category : '||p_attribute_category);
1582: arp_util.debug('p_attribute1 : '||p_attribute1);

Line 1579: arp_util.debug('p_set_of_books_id : '||p_set_of_books_id);

1575: arp_util.debug('p_exchange_rate : '||p_exchange_rate);
1576: arp_util.debug('p_control_count : '||p_control_count);
1577: arp_util.debug('p_control_amount : '||p_control_amount);
1578: arp_util.debug('p_comments : '||p_comments);
1579: arp_util.debug('p_set_of_books_id : '||p_set_of_books_id);
1580: arp_util.debug('p_purged_children_flag : '||p_purged_children_flag);
1581: arp_util.debug('p_attribute_category : '||p_attribute_category);
1582: arp_util.debug('p_attribute1 : '||p_attribute1);
1583: arp_util.debug('p_attribute2 : '||p_attribute2);

Line 1580: arp_util.debug('p_purged_children_flag : '||p_purged_children_flag);

1576: arp_util.debug('p_control_count : '||p_control_count);
1577: arp_util.debug('p_control_amount : '||p_control_amount);
1578: arp_util.debug('p_comments : '||p_comments);
1579: arp_util.debug('p_set_of_books_id : '||p_set_of_books_id);
1580: arp_util.debug('p_purged_children_flag : '||p_purged_children_flag);
1581: arp_util.debug('p_attribute_category : '||p_attribute_category);
1582: arp_util.debug('p_attribute1 : '||p_attribute1);
1583: arp_util.debug('p_attribute2 : '||p_attribute2);
1584: arp_util.debug('p_attribute3 : '||p_attribute3);

Line 1581: arp_util.debug('p_attribute_category : '||p_attribute_category);

1577: arp_util.debug('p_control_amount : '||p_control_amount);
1578: arp_util.debug('p_comments : '||p_comments);
1579: arp_util.debug('p_set_of_books_id : '||p_set_of_books_id);
1580: arp_util.debug('p_purged_children_flag : '||p_purged_children_flag);
1581: arp_util.debug('p_attribute_category : '||p_attribute_category);
1582: arp_util.debug('p_attribute1 : '||p_attribute1);
1583: arp_util.debug('p_attribute2 : '||p_attribute2);
1584: arp_util.debug('p_attribute3 : '||p_attribute3);
1585: arp_util.debug('p_attribute4 : '||p_attribute4);

Line 1582: arp_util.debug('p_attribute1 : '||p_attribute1);

1578: arp_util.debug('p_comments : '||p_comments);
1579: arp_util.debug('p_set_of_books_id : '||p_set_of_books_id);
1580: arp_util.debug('p_purged_children_flag : '||p_purged_children_flag);
1581: arp_util.debug('p_attribute_category : '||p_attribute_category);
1582: arp_util.debug('p_attribute1 : '||p_attribute1);
1583: arp_util.debug('p_attribute2 : '||p_attribute2);
1584: arp_util.debug('p_attribute3 : '||p_attribute3);
1585: arp_util.debug('p_attribute4 : '||p_attribute4);
1586: arp_util.debug('p_attribute5 : '||p_attribute5);

Line 1583: arp_util.debug('p_attribute2 : '||p_attribute2);

1579: arp_util.debug('p_set_of_books_id : '||p_set_of_books_id);
1580: arp_util.debug('p_purged_children_flag : '||p_purged_children_flag);
1581: arp_util.debug('p_attribute_category : '||p_attribute_category);
1582: arp_util.debug('p_attribute1 : '||p_attribute1);
1583: arp_util.debug('p_attribute2 : '||p_attribute2);
1584: arp_util.debug('p_attribute3 : '||p_attribute3);
1585: arp_util.debug('p_attribute4 : '||p_attribute4);
1586: arp_util.debug('p_attribute5 : '||p_attribute5);
1587: arp_util.debug('p_attribute6 : '||p_attribute6);

Line 1584: arp_util.debug('p_attribute3 : '||p_attribute3);

1580: arp_util.debug('p_purged_children_flag : '||p_purged_children_flag);
1581: arp_util.debug('p_attribute_category : '||p_attribute_category);
1582: arp_util.debug('p_attribute1 : '||p_attribute1);
1583: arp_util.debug('p_attribute2 : '||p_attribute2);
1584: arp_util.debug('p_attribute3 : '||p_attribute3);
1585: arp_util.debug('p_attribute4 : '||p_attribute4);
1586: arp_util.debug('p_attribute5 : '||p_attribute5);
1587: arp_util.debug('p_attribute6 : '||p_attribute6);
1588: arp_util.debug('p_attribute7 : '||p_attribute7);

Line 1585: arp_util.debug('p_attribute4 : '||p_attribute4);

1581: arp_util.debug('p_attribute_category : '||p_attribute_category);
1582: arp_util.debug('p_attribute1 : '||p_attribute1);
1583: arp_util.debug('p_attribute2 : '||p_attribute2);
1584: arp_util.debug('p_attribute3 : '||p_attribute3);
1585: arp_util.debug('p_attribute4 : '||p_attribute4);
1586: arp_util.debug('p_attribute5 : '||p_attribute5);
1587: arp_util.debug('p_attribute6 : '||p_attribute6);
1588: arp_util.debug('p_attribute7 : '||p_attribute7);
1589: arp_util.debug('p_attribute8 : '||p_attribute8);

Line 1586: arp_util.debug('p_attribute5 : '||p_attribute5);

1582: arp_util.debug('p_attribute1 : '||p_attribute1);
1583: arp_util.debug('p_attribute2 : '||p_attribute2);
1584: arp_util.debug('p_attribute3 : '||p_attribute3);
1585: arp_util.debug('p_attribute4 : '||p_attribute4);
1586: arp_util.debug('p_attribute5 : '||p_attribute5);
1587: arp_util.debug('p_attribute6 : '||p_attribute6);
1588: arp_util.debug('p_attribute7 : '||p_attribute7);
1589: arp_util.debug('p_attribute8 : '||p_attribute8);
1590: arp_util.debug('p_attribute9 : '||p_attribute9);

Line 1587: arp_util.debug('p_attribute6 : '||p_attribute6);

1583: arp_util.debug('p_attribute2 : '||p_attribute2);
1584: arp_util.debug('p_attribute3 : '||p_attribute3);
1585: arp_util.debug('p_attribute4 : '||p_attribute4);
1586: arp_util.debug('p_attribute5 : '||p_attribute5);
1587: arp_util.debug('p_attribute6 : '||p_attribute6);
1588: arp_util.debug('p_attribute7 : '||p_attribute7);
1589: arp_util.debug('p_attribute8 : '||p_attribute8);
1590: arp_util.debug('p_attribute9 : '||p_attribute9);
1591: arp_util.debug('p_attribute10 : '||p_attribute10);

Line 1588: arp_util.debug('p_attribute7 : '||p_attribute7);

1584: arp_util.debug('p_attribute3 : '||p_attribute3);
1585: arp_util.debug('p_attribute4 : '||p_attribute4);
1586: arp_util.debug('p_attribute5 : '||p_attribute5);
1587: arp_util.debug('p_attribute6 : '||p_attribute6);
1588: arp_util.debug('p_attribute7 : '||p_attribute7);
1589: arp_util.debug('p_attribute8 : '||p_attribute8);
1590: arp_util.debug('p_attribute9 : '||p_attribute9);
1591: arp_util.debug('p_attribute10 : '||p_attribute10);
1592: arp_util.debug('p_attribute11 : '||p_attribute11);

Line 1589: arp_util.debug('p_attribute8 : '||p_attribute8);

1585: arp_util.debug('p_attribute4 : '||p_attribute4);
1586: arp_util.debug('p_attribute5 : '||p_attribute5);
1587: arp_util.debug('p_attribute6 : '||p_attribute6);
1588: arp_util.debug('p_attribute7 : '||p_attribute7);
1589: arp_util.debug('p_attribute8 : '||p_attribute8);
1590: arp_util.debug('p_attribute9 : '||p_attribute9);
1591: arp_util.debug('p_attribute10 : '||p_attribute10);
1592: arp_util.debug('p_attribute11 : '||p_attribute11);
1593: arp_util.debug('p_attribute12 : '||p_attribute12);

Line 1590: arp_util.debug('p_attribute9 : '||p_attribute9);

1586: arp_util.debug('p_attribute5 : '||p_attribute5);
1587: arp_util.debug('p_attribute6 : '||p_attribute6);
1588: arp_util.debug('p_attribute7 : '||p_attribute7);
1589: arp_util.debug('p_attribute8 : '||p_attribute8);
1590: arp_util.debug('p_attribute9 : '||p_attribute9);
1591: arp_util.debug('p_attribute10 : '||p_attribute10);
1592: arp_util.debug('p_attribute11 : '||p_attribute11);
1593: arp_util.debug('p_attribute12 : '||p_attribute12);
1594: arp_util.debug('p_attribute13 : '||p_attribute13);

Line 1591: arp_util.debug('p_attribute10 : '||p_attribute10);

1587: arp_util.debug('p_attribute6 : '||p_attribute6);
1588: arp_util.debug('p_attribute7 : '||p_attribute7);
1589: arp_util.debug('p_attribute8 : '||p_attribute8);
1590: arp_util.debug('p_attribute9 : '||p_attribute9);
1591: arp_util.debug('p_attribute10 : '||p_attribute10);
1592: arp_util.debug('p_attribute11 : '||p_attribute11);
1593: arp_util.debug('p_attribute12 : '||p_attribute12);
1594: arp_util.debug('p_attribute13 : '||p_attribute13);
1595: arp_util.debug('p_attribute14 : '||p_attribute14);

Line 1592: arp_util.debug('p_attribute11 : '||p_attribute11);

1588: arp_util.debug('p_attribute7 : '||p_attribute7);
1589: arp_util.debug('p_attribute8 : '||p_attribute8);
1590: arp_util.debug('p_attribute9 : '||p_attribute9);
1591: arp_util.debug('p_attribute10 : '||p_attribute10);
1592: arp_util.debug('p_attribute11 : '||p_attribute11);
1593: arp_util.debug('p_attribute12 : '||p_attribute12);
1594: arp_util.debug('p_attribute13 : '||p_attribute13);
1595: arp_util.debug('p_attribute14 : '||p_attribute14);
1596: arp_util.debug('p_attribute15 : '||p_attribute15);

Line 1593: arp_util.debug('p_attribute12 : '||p_attribute12);

1589: arp_util.debug('p_attribute8 : '||p_attribute8);
1590: arp_util.debug('p_attribute9 : '||p_attribute9);
1591: arp_util.debug('p_attribute10 : '||p_attribute10);
1592: arp_util.debug('p_attribute11 : '||p_attribute11);
1593: arp_util.debug('p_attribute12 : '||p_attribute12);
1594: arp_util.debug('p_attribute13 : '||p_attribute13);
1595: arp_util.debug('p_attribute14 : '||p_attribute14);
1596: arp_util.debug('p_attribute15 : '||p_attribute15);
1597:

Line 1594: arp_util.debug('p_attribute13 : '||p_attribute13);

1590: arp_util.debug('p_attribute9 : '||p_attribute9);
1591: arp_util.debug('p_attribute10 : '||p_attribute10);
1592: arp_util.debug('p_attribute11 : '||p_attribute11);
1593: arp_util.debug('p_attribute12 : '||p_attribute12);
1594: arp_util.debug('p_attribute13 : '||p_attribute13);
1595: arp_util.debug('p_attribute14 : '||p_attribute14);
1596: arp_util.debug('p_attribute15 : '||p_attribute15);
1597:
1598: RAISE;

Line 1595: arp_util.debug('p_attribute14 : '||p_attribute14);

1591: arp_util.debug('p_attribute10 : '||p_attribute10);
1592: arp_util.debug('p_attribute11 : '||p_attribute11);
1593: arp_util.debug('p_attribute12 : '||p_attribute12);
1594: arp_util.debug('p_attribute13 : '||p_attribute13);
1595: arp_util.debug('p_attribute14 : '||p_attribute14);
1596: arp_util.debug('p_attribute15 : '||p_attribute15);
1597:
1598: RAISE;
1599: END;

Line 1596: arp_util.debug('p_attribute15 : '||p_attribute15);

1592: arp_util.debug('p_attribute11 : '||p_attribute11);
1593: arp_util.debug('p_attribute12 : '||p_attribute12);
1594: arp_util.debug('p_attribute13 : '||p_attribute13);
1595: arp_util.debug('p_attribute14 : '||p_attribute14);
1596: arp_util.debug('p_attribute15 : '||p_attribute15);
1597:
1598: RAISE;
1599: END;
1600:

Line 1612: | arp_util.debug |

1608: | |
1609: | SCOPE - PUBLIC |
1610: | |
1611: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1612: | arp_util.debug |
1613: | |
1614: | ARGUMENTS : IN: |
1615: | p_batch_id - identifies the row to delete |
1616: | OUT: |

Line 1634: arp_util.debug('arp_tbat_pkg.delete_p()+');

1630: l_count number;
1631:
1632: BEGIN
1633:
1634: arp_util.debug('arp_tbat_pkg.delete_p()+');
1635:
1636: /*-----------------------------------------------------+
1637: | Determine the number of transactions in the batch. |
1638: | The procedure only deletes batches that do not |

Line 1667: arp_util.debug('arp_tbat_pkg.delete_p()-');

1663: fnd_message.set_name('AR', '250');
1664: app_exception.raise_exception;
1665: END IF;
1666:
1667: arp_util.debug('arp_tbat_pkg.delete_p()-');
1668:
1669: EXCEPTION
1670: WHEN OTHERS THEN
1671: arp_util.debug('EXCEPTION: arp_tbat_pkg.delete_p()');

Line 1671: arp_util.debug('EXCEPTION: arp_tbat_pkg.delete_p()');

1667: arp_util.debug('arp_tbat_pkg.delete_p()-');
1668:
1669: EXCEPTION
1670: WHEN OTHERS THEN
1671: arp_util.debug('EXCEPTION: arp_tbat_pkg.delete_p()');
1672: RAISE;
1673:
1674: END;
1675:

Line 1687: | arp_util.debug |

1683: | |
1684: | SCOPE - PUBLIC |
1685: | |
1686: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1687: | arp_util.debug |
1688: | |
1689: | ARGUMENTS : IN: |
1690: | p_batch_source_id - identifies the rows to delete |
1691: | OUT: |

Line 1710: arp_util.debug('arp_tbat_pkg.delete_f_bs_id()+');

1706: l_count number;
1707:
1708: BEGIN
1709:
1710: arp_util.debug('arp_tbat_pkg.delete_f_bs_id()+');
1711:
1712: /*-----------------------------------------------------+
1713: | Determine the number of transactions in the batch. |
1714: | The procedure only deletes batches that do not |

Line 1743: arp_util.debug('arp_tbat_pkg.delete_f_bs_id()-');

1739: fnd_message.set_name('AR', '250');
1740: app_exception.raise_exception;
1741: END IF;
1742:
1743: arp_util.debug('arp_tbat_pkg.delete_f_bs_id()-');
1744:
1745: EXCEPTION
1746: WHEN OTHERS THEN
1747:

Line 1748: arp_util.debug('EXCEPTION: arp_tbat_pkg.delete_f_bs_id()');

1744:
1745: EXCEPTION
1746: WHEN OTHERS THEN
1747:
1748: arp_util.debug('EXCEPTION: arp_tbat_pkg.delete_f_bs_id()');
1749: RAISE;
1750:
1751: END;
1752:

Line 1764: | arp_util.debug |

1760: | |
1761: | SCOPE - PUBLIC |
1762: | |
1763: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1764: | arp_util.debug |
1765: | |
1766: | ARGUMENTS : IN: |
1767: | p_batch_id - identifies the row to update |
1768: | p_batch_rec - contains the new column values |

Line 1789: arp_util.debug('arp_tbat_pkg.update_p()+');

1785:
1786:
1787: BEGIN
1788:
1789: arp_util.debug('arp_tbat_pkg.update_p()+');
1790:
1791: arp_tbat_pkg.generic_update( pg_cursor1,
1792: ' WHERE batch_id = :where_1',
1793: p_batch_id,

Line 1796: arp_util.debug('arp_tbat_pkg.update_p()-');

1792: ' WHERE batch_id = :where_1',
1793: p_batch_id,
1794: p_batch_rec);
1795:
1796: arp_util.debug('arp_tbat_pkg.update_p()-');
1797:
1798:
1799: EXCEPTION
1800: WHEN OTHERS THEN

Line 1801: arp_util.debug('EXCEPTION: arp_tbat_pkg.update_p()');

1797:
1798:
1799: EXCEPTION
1800: WHEN OTHERS THEN
1801: arp_util.debug('EXCEPTION: arp_tbat_pkg.update_p()');
1802: RAISE;
1803: END;
1804:
1805: /*===========================================================================+

Line 1816: | arp_util.debug |

1812: | |
1813: | SCOPE - PUBLIC |
1814: | |
1815: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1816: | arp_util.debug |
1817: | |
1818: | ARGUMENTS : IN: |
1819: | p_batch_source_id - identifies the rows to delete |
1820: | p_batch_rec - contains the new column values |

Line 1842: arp_util.debug('arp_tbat_pkg.update_f_bs_id()+');

1838:
1839:
1840: BEGIN
1841:
1842: arp_util.debug('arp_tbat_pkg.update_f_bs_id()+');
1843:
1844: arp_tbat_pkg.generic_update( pg_cursor2,
1845: ' WHERE batch_source_id = :where_1',
1846: p_batch_source_id,

Line 1849: arp_util.debug('arp_tbat_pkg.update_f_bs_id()-');

1845: ' WHERE batch_source_id = :where_1',
1846: p_batch_source_id,
1847: p_batch_rec);
1848:
1849: arp_util.debug('arp_tbat_pkg.update_f_bs_id()-');
1850:
1851:
1852: EXCEPTION
1853: WHEN OTHERS THEN

Line 1854: arp_util.debug('EXCEPTION: arp_tbat_pkg.update_f_bs_id()');

1850:
1851:
1852: EXCEPTION
1853: WHEN OTHERS THEN
1854: arp_util.debug('EXCEPTION: arp_tbat_pkg.update_f_bs_id()');
1855: RAISE;
1856: END;
1857:
1858: /*===========================================================================+

Line 1869: | arp_util.debug |

1865: | |
1866: | SCOPE - PUBLIC |
1867: | |
1868: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1869: | arp_util.debug |
1870: | arp_global.set_of_books_id |
1871: | |
1872: | ARGUMENTS : IN: |
1873: | p_batch_rec - contains the new column values |

Line 1909: arp_util.debug('arp_tbat_pkg.insert_p()+');

1905: l_ra_batches_value_list gl_ca_utility_pkg.r_key_value_arr; /* MRC */
1906:
1907: BEGIN
1908:
1909: arp_util.debug('arp_tbat_pkg.insert_p()+');
1910:
1911: p_batch_id := '';
1912:
1913: /*---------------------------*

Line 2062: arp_util.debug('arp_tbat_pkg.insert_p()-');

2058: -- p_table_name => 'RA_BATCHES',
2059: -- p_mode => 'SINGLE',
2060: -- p_key_value => l_batch_id);
2061: --}
2062: arp_util.debug('arp_tbat_pkg.insert_p()-');
2063:
2064: EXCEPTION
2065: WHEN OTHERS THEN
2066: arp_util.debug('EXCEPTION: arp_tbat_pkg.insert_p()');

Line 2066: arp_util.debug('EXCEPTION: arp_tbat_pkg.insert_p()');

2062: arp_util.debug('arp_tbat_pkg.insert_p()-');
2063:
2064: EXCEPTION
2065: WHEN OTHERS THEN
2066: arp_util.debug('EXCEPTION: arp_tbat_pkg.insert_p()');
2067: RAISE;
2068: END;
2069:
2070: