DBA Data[Home] [Help]

APPS.ARP_PROCESS_COMMITMENT dependencies on ARP_PROCESS_COMMITMENT

Line 1: PACKAGE BODY ARP_PROCESS_COMMITMENT AS

1: PACKAGE BODY ARP_PROCESS_COMMITMENT AS
2: /* $Header: ARTECOMB.pls 115.7 2003/08/28 17:22:42 kmahajan ship $ */
3:
4: pg_msg_level_debug binary_integer;
5:

Line 82: arp_util.debug('arp_process_commitment.header_pre_insert()+');

78: PROCEDURE header_pre_insert IS
79:
80: BEGIN
81:
82: arp_util.debug('arp_process_commitment.header_pre_insert()+');
83:
84: arp_util.debug('arp_process_commitment.header_pre_insert()-');
85:
86: EXCEPTION

Line 84: arp_util.debug('arp_process_commitment.header_pre_insert()-');

80: BEGIN
81:
82: arp_util.debug('arp_process_commitment.header_pre_insert()+');
83:
84: arp_util.debug('arp_process_commitment.header_pre_insert()-');
85:
86: EXCEPTION
87: WHEN OTHERS THEN
88: arp_util.debug('EXCEPTION: arp_process_commitment.header_pre_insert()');

Line 88: arp_util.debug('EXCEPTION: arp_process_commitment.header_pre_insert()');

84: arp_util.debug('arp_process_commitment.header_pre_insert()-');
85:
86: EXCEPTION
87: WHEN OTHERS THEN
88: arp_util.debug('EXCEPTION: arp_process_commitment.header_pre_insert()');
89: RAISE;
90:
91: END;
92:

Line 133: arp_util.debug('arp_process_commitment.insert_line_salescredit()+',

129: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;
130:
131: BEGIN
132:
133: arp_util.debug('arp_process_commitment.insert_line_salescredit()+',
134: pg_msg_level_debug);
135:
136: IF p_salesrep_id is not null THEN
137:

Line 151: arp_util.debug('arp_process_commitment.insert_line_salescredit()-',

147: l_cust_trx_line_salesrep_id);
148:
149: END IF;
150:
151: arp_util.debug('arp_process_commitment.insert_line_salescredit()-',
152: pg_msg_level_debug);
153:
154:
155: EXCEPTION

Line 158: 'EXCEPTION: arp_process_commitment.insert_line_salescredit()',

154:
155: EXCEPTION
156: WHEN OTHERS THEN
157: arp_util.debug(
158: 'EXCEPTION: arp_process_commitment.insert_line_salescredit()',
159: pg_msg_level_debug);
160: RAISE;
161:
162: END;

Line 207: arp_util.debug('arp_process_commitment.insert_dist_line()+',

203:
204:
205: BEGIN
206:
207: arp_util.debug('arp_process_commitment.insert_dist_line()+',
208: pg_msg_level_debug);
209:
210: /*--------------------------------------------------+
211: | Call AutoAccounting to insert the distribution |

Line 270: arp_util.debug('EXCEPTION: arp_process_commitment.insert_dist_line()- no_ccid',

266: EXCEPTION
267: WHEN arp_auto_accounting.no_ccid THEN
268:
269: p_status := 'ARP_AUTO_ACCOUNTING.NO_CCID';
270: arp_util.debug('EXCEPTION: arp_process_commitment.insert_dist_line()- no_ccid',
271: pg_msg_level_debug);
272:
273: WHEN NO_DATA_FOUND THEN
274:

Line 276: arp_util.debug('EXCEPTION: arp_process_commitment.insert_dist_line()- NO_DATA_FOUND',

272:
273: WHEN NO_DATA_FOUND THEN
274:
275: null;
276: arp_util.debug('EXCEPTION: arp_process_commitment.insert_dist_line()- NO_DATA_FOUND',
277: pg_msg_level_debug);
278: WHEN OTHERS THEN
279:
280: arp_util.debug('EXCEPTION: arp_process_commitment.insert_dist_line()- OTHERS',

Line 280: arp_util.debug('EXCEPTION: arp_process_commitment.insert_dist_line()- OTHERS',

276: arp_util.debug('EXCEPTION: arp_process_commitment.insert_dist_line()- NO_DATA_FOUND',
277: pg_msg_level_debug);
278: WHEN OTHERS THEN
279:
280: arp_util.debug('EXCEPTION: arp_process_commitment.insert_dist_line()- OTHERS',
281: pg_msg_level_debug);
282: RAISE;
283: END;
284:

Line 289: arp_util.debug('arp_process_commitment.insert_dist_line()-',

285: IF arp_auto_accounting.g_deposit_flag is NOT NULL THEN
286: arp_auto_accounting.g_deposit_flag := '';
287: END IF;
288:
289: arp_util.debug('arp_process_commitment.insert_dist_line()-',
290: pg_msg_level_debug);
291:
292: EXCEPTION
293: WHEN OTHERS THEN

Line 295: 'EXCEPTION: arp_process_commitment.insert_dist_line- OTHERS',

291:
292: EXCEPTION
293: WHEN OTHERS THEN
294: arp_util.debug(
295: 'EXCEPTION: arp_process_commitment.insert_dist_line- OTHERS',
296: pg_msg_level_debug);
297:
298: IF arp_auto_accounting.g_deposit_flag is NOT NULL THEN
299: arp_auto_accounting.g_deposit_flag := '';

Line 348: arp_util.debug('arp_process_commitment.header_post_insert()+');

344: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
345:
346: BEGIN
347:
348: arp_util.debug('arp_process_commitment.header_post_insert()+');
349:
350: /*-----------------------------------------+
351: | Insert row into ra_customer_trx_lines |
352: +-----------------------------------------*/

Line 437: arp_util.debug('arp_process_commitment.header_post_insert()-');

433: l_customer_trx_line_id,
434: p_gl_date,
435: p_status);
436:
437: arp_util.debug('arp_process_commitment.header_post_insert()-');
438:
439: EXCEPTION
440: WHEN OTHERS THEN
441: arp_util.debug('EXCEPTION: arp_process_commitment.header_post_insert()');

Line 441: arp_util.debug('EXCEPTION: arp_process_commitment.header_post_insert()');

437: arp_util.debug('arp_process_commitment.header_post_insert()-');
438:
439: EXCEPTION
440: WHEN OTHERS THEN
441: arp_util.debug('EXCEPTION: arp_process_commitment.header_post_insert()');
442: RAISE;
443:
444: END;
445:

Line 474: arp_util.debug('arp_process_commitment.header_pre_update()+');

470: PROCEDURE header_pre_update IS
471:
472: BEGIN
473:
474: arp_util.debug('arp_process_commitment.header_pre_update()+');
475:
476: arp_util.debug('arp_process_commitment.header_pre_update()-');
477:
478: EXCEPTION

Line 476: arp_util.debug('arp_process_commitment.header_pre_update()-');

472: BEGIN
473:
474: arp_util.debug('arp_process_commitment.header_pre_update()+');
475:
476: arp_util.debug('arp_process_commitment.header_pre_update()-');
477:
478: EXCEPTION
479: WHEN OTHERS THEN
480: arp_util.debug('EXCEPTION: arp_process_commitment.header_pre_update()');

Line 480: arp_util.debug('EXCEPTION: arp_process_commitment.header_pre_update()');

476: arp_util.debug('arp_process_commitment.header_pre_update()-');
477:
478: EXCEPTION
479: WHEN OTHERS THEN
480: arp_util.debug('EXCEPTION: arp_process_commitment.header_pre_update()');
481: RAISE;
482:
483: END;
484:

Line 518: arp_util.debug('arp_process_commitment.set_flags()+',

514: l_old_commitment_rec ra_customer_trx_lines%rowtype;
515:
516: BEGIN
517:
518: arp_util.debug('arp_process_commitment.set_flags()+',
519: pg_msg_level_debug);
520:
521: arp_ctl_pkg.fetch_p( l_old_commitment_rec,
522: p_new_commitment_rec.customer_trx_line_id );

Line 928: arp_util.debug('arp_process_commitment.set_flags()-',

924: THEN p_changed_flags_rec.ussgl_trx_code_changed_flag := TRUE;
925: ELSE p_changed_flags_rec.ussgl_trx_code_changed_flag := FALSE;
926: END IF;
927:
928: arp_util.debug('arp_process_commitment.set_flags()-',
929: pg_msg_level_debug);
930:
931: EXCEPTION
932: WHEN OTHERS THEN

Line 934: 'EXCEPTION: arp_process_commitment.set_flags()',

930:
931: EXCEPTION
932: WHEN OTHERS THEN
933: arp_util.debug(
934: 'EXCEPTION: arp_process_commitment.set_flags()',
935: pg_msg_level_debug);
936: RAISE;
937:
938:

Line 977: arp_util.debug('arp_process_commitment.header_post_update()+');

973: l_line_rec ra_customer_trx_lines%rowtype;
974:
975: BEGIN
976:
977: arp_util.debug('arp_process_commitment.header_post_update()+');
978:
979: set_flags( p_commitment_rec,
980: l_changed_flags_rec );
981:

Line 1188: arp_util.debug('arp_process_commitment.header_post_update()-');

1184: pg_base_min_acc_unit);
1185: END IF;
1186: END IF;
1187:
1188: arp_util.debug('arp_process_commitment.header_post_update()-');
1189:
1190: EXCEPTION
1191: WHEN OTHERS THEN
1192: arp_util.debug('EXCEPTION: arp_process_commitment.header_post_update()');

Line 1192: arp_util.debug('EXCEPTION: arp_process_commitment.header_post_update()');

1188: arp_util.debug('arp_process_commitment.header_post_update()-');
1189:
1190: EXCEPTION
1191: WHEN OTHERS THEN
1192: arp_util.debug('EXCEPTION: arp_process_commitment.header_post_update()');
1193: RAISE;
1194:
1195: END;
1196:

Line 1225: arp_util.debug('arp_process_commitment.header_pre_delete()+');

1221: PROCEDURE header_pre_delete IS
1222:
1223: BEGIN
1224:
1225: arp_util.debug('arp_process_commitment.header_pre_delete()+');
1226:
1227: arp_util.debug('arp_process_commitment.header_pre_delete()-');
1228:
1229: EXCEPTION

Line 1227: arp_util.debug('arp_process_commitment.header_pre_delete()-');

1223: BEGIN
1224:
1225: arp_util.debug('arp_process_commitment.header_pre_delete()+');
1226:
1227: arp_util.debug('arp_process_commitment.header_pre_delete()-');
1228:
1229: EXCEPTION
1230: WHEN OTHERS THEN
1231: arp_util.debug('EXCEPTION: arp_process_commitment.header_pre_delete()');

Line 1231: arp_util.debug('EXCEPTION: arp_process_commitment.header_pre_delete()');

1227: arp_util.debug('arp_process_commitment.header_pre_delete()-');
1228:
1229: EXCEPTION
1230: WHEN OTHERS THEN
1231: arp_util.debug('EXCEPTION: arp_process_commitment.header_pre_delete()');
1232: RAISE;
1233:
1234: END;
1235:

Line 1267: arp_util.debug('arp_process_commitment.set_to_dummy()+',

1263: PROCEDURE set_to_dummy( p_commitment_rec OUT NOCOPY commitment_rec_type ) IS
1264:
1265: BEGIN
1266:
1267: arp_util.debug('arp_process_commitment.set_to_dummy()+',
1268: pg_msg_level_debug);
1269:
1270: p_commitment_rec.customer_trx_line_id := pg_number_dummy;
1271: p_commitment_rec.inventory_item_id := pg_number_dummy;

Line 1308: arp_util.debug('arp_process_commitment.set_to_dummy()-',

1304: p_commitment_rec.attribute13 := pg_text_dummy;
1305: p_commitment_rec.attribute14 := pg_text_dummy;
1306: p_commitment_rec.attribute15 := pg_text_dummy;
1307:
1308: arp_util.debug('arp_process_commitment.set_to_dummy()-',
1309: pg_msg_level_debug);
1310:
1311: EXCEPTION
1312: WHEN OTHERS THEN

Line 1314: 'EXCEPTION: arp_process_commitment.set_to_dummy()',

1310:
1311: EXCEPTION
1312: WHEN OTHERS THEN
1313: arp_util.debug(
1314: 'EXCEPTION: arp_process_commitment.set_to_dummy()',
1315: pg_msg_level_debug);
1316: RAISE;
1317:
1318: END;

Line 1337: arp_util.debug('EXCEPTION: arp_process_commitment.initialization');

1333: pg_base_min_acc_unit := arp_global.base_min_acc_unit;
1334:
1335: EXCEPTION
1336: WHEN OTHERS THEN
1337: arp_util.debug('EXCEPTION: arp_process_commitment.initialization');
1338: RAISE;
1339:
1340:
1341: END ARP_PROCESS_COMMITMENT;

Line 1341: END ARP_PROCESS_COMMITMENT;

1337: arp_util.debug('EXCEPTION: arp_process_commitment.initialization');
1338: RAISE;
1339:
1340:
1341: END ARP_PROCESS_COMMITMENT;