61: | SCOPE - PRIVATE |
62: | |
63: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
64: | dbms_sql.bind_variable |
65: | arp_util.debug |
66: | |
67: | ARGUMENTS : IN: |
68: | OUT: |
69: | RETURNS : NONE |
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
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()');
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:
99: | |
100: | SCOPE - PRIVATE |
101: | |
102: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
103: | arp_util.debug |
104: | |
105: | ARGUMENTS : IN: |
106: | OUT: |
107: | RETURNS : NONE |
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:
138: l_srep_rec.customer_trx_id := p_customer_trx_id;
139: l_srep_rec.customer_trx_line_id := p_customer_trx_line_id;
140: l_srep_rec.salesrep_id := p_salesrep_id;
141: -- kmahajan - 08/25/2003 - added line below for Sales Group project
142: l_srep_rec.revenue_salesgroup_id := arp_util.Get_Default_SalesGroup(p_salesrep_id, p_customer_trx_id);
143: l_srep_rec.revenue_amount_split := p_extended_amount;
144: l_srep_rec.revenue_percent_split := 100;
145:
146: arp_ctls_pkg.insert_p(l_srep_rec,
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
153:
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:
170: | |
171: | SCOPE - PRIVATE |
172: | |
173: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
174: | arp_util.debug |
175: | |
176: | ARGUMENTS : IN: |
177: | OUT: |
178: | RETURNS : NONE |
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 |
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:
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',
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:
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
290: pg_msg_level_debug);
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
313: | SCOPE - PUBLIC |
314: | |
315: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
316: | dbms_sql.bind_variable |
317: | arp_util.debug |
318: | |
319: | ARGUMENTS : IN: |
320: | OUT: |
321: | RETURNS : NONE |
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: +-----------------------------------------*/
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()');
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:
453: | SCOPE - PRIVATE |
454: | |
455: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
456: | dbms_sql.bind_variable |
457: | arp_util.debug |
458: | |
459: | ARGUMENTS : IN: |
460: | OUT: |
461: | RETURNS : NONE |
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
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()');
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:
491: | |
492: | SCOPE - PRIVATE |
493: | |
494: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
495: | arp_util.debug |
496: | |
497: | ARGUMENTS : IN: |
498: | OUT: |
499: | IN/ OUT: |
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 );
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
929: pg_msg_level_debug);
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:
947: | |
948: | SCOPE - PUBLIC |
949: | |
950: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
951: | arp_util.debug |
952: | |
953: | ARGUMENTS : IN: |
954: | OUT: |
955: | RETURNS : NONE |
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:
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()');
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:
1204: | SCOPE - PRIVATE |
1205: | |
1206: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1207: | dbms_sql.bind_variable |
1208: | arp_util.debug |
1209: | |
1210: | ARGUMENTS : IN: |
1211: | OUT: |
1212: | RETURNS : NONE |
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
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()');
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:
1243: | |
1244: | SCOPE - PUBLIC |
1245: | |
1246: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1247: | arp_util.debug |
1248: | |
1249: | ARGUMENTS : IN: |
1250: | None |
1251: | OUT: |
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;
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
1309: pg_msg_level_debug);
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:
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;