DBA Data[Home] [Help]

APPS.ARP_PROCESS_COMMITMENT dependencies on ARP_UTIL

Line 65: | arp_util.debug |

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 |

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 103: | arp_util.debug |

99: | |
100: | SCOPE - PRIVATE |
101: | |
102: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
103: | arp_util.debug |
104: | |
105: | ARGUMENTS : IN: |
106: | OUT: |
107: | RETURNS : NONE |

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 142: l_srep_rec.revenue_salesgroup_id := arp_util.Get_Default_SalesGroup(p_salesrep_id, p_customer_trx_id);

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,

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 157: arp_util.debug(

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:

Line 174: | arp_util.debug |

170: | |
171: | SCOPE - PRIVATE |
172: | |
173: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
174: | arp_util.debug |
175: | |
176: | ARGUMENTS : IN: |
177: | OUT: |
178: | RETURNS : NONE |

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 294: arp_util.debug(

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

Line 317: | arp_util.debug |

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 |

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 457: | arp_util.debug |

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 |

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 495: | arp_util.debug |

491: | |
492: | SCOPE - PRIVATE |
493: | |
494: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
495: | arp_util.debug |
496: | |
497: | ARGUMENTS : IN: |
498: | OUT: |
499: | IN/ OUT: |

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 933: arp_util.debug(

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:

Line 951: | arp_util.debug |

947: | |
948: | SCOPE - PUBLIC |
949: | |
950: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
951: | arp_util.debug |
952: | |
953: | ARGUMENTS : IN: |
954: | OUT: |
955: | RETURNS : NONE |

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 1208: | arp_util.debug |

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 |

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 1247: | arp_util.debug |

1243: | |
1244: | SCOPE - PUBLIC |
1245: | |
1246: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1247: | arp_util.debug |
1248: | |
1249: | ARGUMENTS : IN: |
1250: | None |
1251: | OUT: |

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 1313: arp_util.debug(

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:

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;