11: | SCOPE - PRIVATE |
12: | |
13: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
14: | dbms_sql.bind_variable |
15: | arp_util.debug |
16: | |
17: | ARGUMENTS : IN: |
18: | OUT: |
19: | RETURNS : NONE |
40:
41:
42: BEGIN
43:
44: arp_util.debug('arp_process_invoice.header_post_insert()+');
45:
46: IF (p_primary_salesrep_id <> -3) AND
47: (p_primary_salesrep_id is not null) AND
48: (p_create_default_sc_flag = 'Y')
50:
51: l_srep_rec.customer_trx_id := p_customer_trx_id;
52: l_srep_rec.salesrep_id := p_primary_salesrep_id;
53: -- kmahajan - 08/25/2003 - added line below for Sales Group project
54: l_srep_rec.revenue_salesgroup_id := arp_util.Get_Default_SalesGroup(p_primary_salesrep_id, p_customer_trx_id);
55: l_srep_rec.revenue_percent_split := 100;
56:
57: arp_ctls_pkg.insert_p(l_srep_rec,
58: l_cust_trx_line_salesrep_id);
57: arp_ctls_pkg.insert_p(l_srep_rec,
58: l_cust_trx_line_salesrep_id);
59: END IF;
60:
61: arp_util.debug('arp_process_invoice.header_post_insert()-');
62:
63: EXCEPTION
64: WHEN OTHERS THEN
65: arp_util.debug('EXCEPTION: arp_process_invoice.header_post_insert()');
61: arp_util.debug('arp_process_invoice.header_post_insert()-');
62:
63: EXCEPTION
64: WHEN OTHERS THEN
65: arp_util.debug('EXCEPTION: arp_process_invoice.header_post_insert()');
66: RAISE;
67:
68: END;
69:
77: | SCOPE - PRIVATE |
78: | |
79: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
80: | dbms_sql.bind_variable |
81: | arp_util.debug |
82: | |
83: | ARGUMENTS : IN: |
84: | OUT: |
85: | RETURNS : NONE |
94: PROCEDURE tax_post_update IS
95:
96: BEGIN
97:
98: arp_util.debug('arp_process_invoice.tax_post_update()+');
99:
100: arp_util.debug('arp_process_invoice.tax_post_update()-');
101:
102: EXCEPTION
96: BEGIN
97:
98: arp_util.debug('arp_process_invoice.tax_post_update()+');
99:
100: arp_util.debug('arp_process_invoice.tax_post_update()-');
101:
102: EXCEPTION
103: WHEN OTHERS THEN
104: arp_util.debug('EXCEPTION: arp_process_invoice.tax_post_update()');
100: arp_util.debug('arp_process_invoice.tax_post_update()-');
101:
102: EXCEPTION
103: WHEN OTHERS THEN
104: arp_util.debug('EXCEPTION: arp_process_invoice.tax_post_update()');
105: RAISE;
106:
107: END;
108:
116: | SCOPE - PRIVATE |
117: | |
118: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
119: | dbms_sql.bind_variable |
120: | arp_util.debug |
121: | |
122: | ARGUMENTS : IN: |
123: | p_frt_rec |
124: | p_gl_date |
149: l_errorbuf varchar2(200);
150: l_result number;
151: BEGIN
152:
153: arp_util.debug('arp_process_invoice.freight_post_update()+');
154:
155: p_status := 'OK';
156:
157: BEGIN
184: RAISE;
185: END;
186:
187:
188: arp_util.debug('arp_process_invoice.freight_post_update()-');
189:
190: EXCEPTION
191: WHEN OTHERS THEN
192: arp_util.debug('EXCEPTION: arp_process_invoice.freight_post_update()');
188: arp_util.debug('arp_process_invoice.freight_post_update()-');
189:
190: EXCEPTION
191: WHEN OTHERS THEN
192: arp_util.debug('EXCEPTION: arp_process_invoice.freight_post_update()');
193: arp_util.debug('p_customer_trx_line_id : '||p_frt_rec.customer_trx_line_id);
194: arp_util.debug('p_frt_ccid : '||p_frt_ccid);
195: arp_util.debug('p_gl_date : '||p_gl_date);
196: RAISE;
189:
190: EXCEPTION
191: WHEN OTHERS THEN
192: arp_util.debug('EXCEPTION: arp_process_invoice.freight_post_update()');
193: arp_util.debug('p_customer_trx_line_id : '||p_frt_rec.customer_trx_line_id);
194: arp_util.debug('p_frt_ccid : '||p_frt_ccid);
195: arp_util.debug('p_gl_date : '||p_gl_date);
196: RAISE;
197:
190: EXCEPTION
191: WHEN OTHERS THEN
192: arp_util.debug('EXCEPTION: arp_process_invoice.freight_post_update()');
193: arp_util.debug('p_customer_trx_line_id : '||p_frt_rec.customer_trx_line_id);
194: arp_util.debug('p_frt_ccid : '||p_frt_ccid);
195: arp_util.debug('p_gl_date : '||p_gl_date);
196: RAISE;
197:
198: END;
191: WHEN OTHERS THEN
192: arp_util.debug('EXCEPTION: arp_process_invoice.freight_post_update()');
193: arp_util.debug('p_customer_trx_line_id : '||p_frt_rec.customer_trx_line_id);
194: arp_util.debug('p_frt_ccid : '||p_frt_ccid);
195: arp_util.debug('p_gl_date : '||p_gl_date);
196: RAISE;
197:
198: END;
199: