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

Line 45: | arp_util.debug |

41: | |
42: | SCOPE - PUBLIC |
43: | |
44: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
45: | arp_util.debug |
46: | |
47: | ARGUMENTS : IN: |
48: | p_cust_trx_line_salesrep_id |
49: | p_customer_trx_id |

Line 77: arp_util.debug('arp_ctls_pkg.erase_foreign_key_references()+');

73: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
74:
75: BEGIN
76:
77: arp_util.debug('arp_ctls_pkg.erase_foreign_key_references()+');
78:
79:
80:
81: /*------------------------------------------------------------------+

Line 173: arp_util.debug(

169: EXCEPTION
170: WHEN NO_DATA_FOUND THEN NULL;
171: WHEN OTHERS THEN
172:
173: arp_util.debug(
174: 'EXCEPTION: arp_process_salescredit.delete_salescredit()');
175: RAISE;
176: END;
177:

Line 178: arp_util.debug('arp_ctls_pkg.erase_foreign_key_references()-');

174: 'EXCEPTION: arp_process_salescredit.delete_salescredit()');
175: RAISE;
176: END;
177:
178: arp_util.debug('arp_ctls_pkg.erase_foreign_key_references()-');
179:
180: EXCEPTION
181: WHEN OTHERS THEN
182: arp_util.debug(

Line 182: arp_util.debug(

178: arp_util.debug('arp_ctls_pkg.erase_foreign_key_references()-');
179:
180: EXCEPTION
181: WHEN OTHERS THEN
182: arp_util.debug(
183: 'EXCEPTION: arp_ctls_pkg.erase_foreign_key_references()');
184: RAISE;
185:
186: END;

Line 201: | arp_util.debug |

197: | SCOPE - PRIVATE |
198: | |
199: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
200: | dbms_sql.bind_variable |
201: | arp_util.debug |
202: | |
203: | ARGUMENTS : IN: |
204: | p_update_cursor - ID of the update cursor |
205: | p_srep_rec - ra_cust_trx_line_salesreps record |

Line 225: arp_util.debug('arp_ctls_pkg.bind_srep_variables()+');

221: IS
222:
223: BEGIN
224:
225: arp_util.debug('arp_ctls_pkg.bind_srep_variables()+');
226:
227: /*------------------+
228: | Dummy constants |
229: +------------------*/

Line 369: arp_util.debug('arp_ctls_pkg.bind_srep_variables()-');

365: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
366: p_srep_rec.program_update_date);
367:
368:
369: arp_util.debug('arp_ctls_pkg.bind_srep_variables()-');
370:
371: EXCEPTION
372: WHEN OTHERS THEN
373: arp_util.debug('EXCEPTION: arp_ctls_pkg.bind_srep_variables()');

Line 373: arp_util.debug('EXCEPTION: arp_ctls_pkg.bind_srep_variables()');

369: arp_util.debug('arp_ctls_pkg.bind_srep_variables()-');
370:
371: EXCEPTION
372: WHEN OTHERS THEN
373: arp_util.debug('EXCEPTION: arp_ctls_pkg.bind_srep_variables()');
374: RAISE;
375:
376: END;
377:

Line 391: | arp_util.debug |

387: | |
388: | SCOPE - PRIVATE |
389: | |
390: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
391: | arp_util.debug |
392: | |
393: | ARGUMENTS : IN: |
394: | None. |
395: | OUT: |

Line 412: arp_util.debug('arp_ctls_pkg.construct_srep_update_stmt()+');

408:
409: PROCEDURE construct_srep_update_stmt( update_text OUT NOCOPY varchar2) IS
410:
411: BEGIN
412: arp_util.debug('arp_ctls_pkg.construct_srep_update_stmt()+');
413:
414: update_text :=
415: 'UPDATE ra_cust_trx_line_salesreps
416: SET cust_trx_line_salesrep_id =

Line 560: arp_util.debug('arp_ctls_pkg.construct_srep_update_stmt()-');

556: DECODE(:program_update_date,
557: :ar_date_dummy, program_update_date,
558: :program_update_date)';
559:
560: arp_util.debug('arp_ctls_pkg.construct_srep_update_stmt()-');
561:
562: EXCEPTION
563: WHEN OTHERS THEN
564: arp_util.debug('EXCEPTION: arp_ctls_pkg.construct_srep_update_stmt()');

Line 564: arp_util.debug('EXCEPTION: arp_ctls_pkg.construct_srep_update_stmt()');

560: arp_util.debug('arp_ctls_pkg.construct_srep_update_stmt()-');
561:
562: EXCEPTION
563: WHEN OTHERS THEN
564: arp_util.debug('EXCEPTION: arp_ctls_pkg.construct_srep_update_stmt()');
565: RAISE;
566:
567: END;
568:

Line 582: | arp_util.debug |

578: | |
579: | SCOPE - PRIVATE |
580: | |
581: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
582: | arp_util.debug |
583: | dbms_sql.open_cursor |
584: | dbms_sql.parse |
585: | dbms_sql.execute |
586: | dbms_sql.close_cursor |

Line 615: arp_util.debug('arp_ctls_pkg.generic_update()+');

611: l_count number;
612: l_update_statement varchar2(25000);
613:
614: BEGIN
615: arp_util.debug('arp_ctls_pkg.generic_update()+');
616:
617: /*--------------------------------------------------------------+
618: | If this update statement has not already been parsed, |
619: | construct the statement and parse it. |

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

654: p_where1);
655:
656: l_count := dbms_sql.execute(p_update_cursor);
657:
658: arp_util.debug( to_char(l_count) || ' rows updated');
659:
660:
661: /*------------------------------------------------------------+
662: | Raise the NO_DATA_FOUND exception if no rows were updated |

Line 671: arp_util.debug('arp_ctls_pkg.generic_update()-');

667: END IF;
668:
669: dbms_sql.close_cursor(p_update_cursor);
670:
671: arp_util.debug('arp_ctls_pkg.generic_update()-');
672:
673: EXCEPTION
674: WHEN OTHERS THEN
675: arp_util.debug('EXCEPTION: arp_ctls_pkg.generic_update()');

Line 675: arp_util.debug('EXCEPTION: arp_ctls_pkg.generic_update()');

671: arp_util.debug('arp_ctls_pkg.generic_update()-');
672:
673: EXCEPTION
674: WHEN OTHERS THEN
675: arp_util.debug('EXCEPTION: arp_ctls_pkg.generic_update()');
676: arp_util.debug(l_update_statement);
677: arp_util.debug('Error at character: ' ||
678: to_char(dbms_sql.last_error_position));
679: IF dbms_sql.is_open( p_update_cursor ) THEN

Line 676: arp_util.debug(l_update_statement);

672:
673: EXCEPTION
674: WHEN OTHERS THEN
675: arp_util.debug('EXCEPTION: arp_ctls_pkg.generic_update()');
676: arp_util.debug(l_update_statement);
677: arp_util.debug('Error at character: ' ||
678: to_char(dbms_sql.last_error_position));
679: IF dbms_sql.is_open( p_update_cursor ) THEN
680: dbms_sql.close_cursor( p_update_cursor );

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

673: EXCEPTION
674: WHEN OTHERS THEN
675: arp_util.debug('EXCEPTION: arp_ctls_pkg.generic_update()');
676: arp_util.debug(l_update_statement);
677: arp_util.debug('Error at character: ' ||
678: to_char(dbms_sql.last_error_position));
679: IF dbms_sql.is_open( p_update_cursor ) THEN
680: dbms_sql.close_cursor( p_update_cursor );
681: END IF;

Line 698: | arp_util.debug |

694: | |
695: | SCOPE - PUBLIC |
696: | |
697: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
698: | arp_util.debug |
699: | |
700: | ARGUMENTS : IN: |
701: | p_customer_trx_id |
702: | p_customer_trx_line_id |

Line 733: arp_util.debug('arp_ctls_pkg.select_summary()+');

729:
730: BEGIN
731:
732: IF PG_DEBUG in ('Y', 'C') THEN
733: arp_util.debug('arp_ctls_pkg.select_summary()+');
734: END IF;
735:
736: SELECT NVL( SUM( NVL(revenue_amount_split, 0 ) ), 0),
737: NVL( SUM( NVL(revenue_amount_split, 0 ) ), 0),

Line 753: arp_util.debug('arp_ctls_pkg.select_summary()-');

749: 'ALL', customer_trx_line_id,
750: -10 );
751:
752: IF PG_DEBUG in ('Y', 'C') THEN
753: arp_util.debug('arp_ctls_pkg.select_summary()-');
754: END IF;
755:
756:
757: EXCEPTION

Line 760: arp_util.debug('EXCEPTION: arp_ctls_pkg.select_summary()');

756:
757: EXCEPTION
758: WHEN OTHERS THEN
759: IF PG_DEBUG in ('Y', 'C') THEN
760: arp_util.debug('EXCEPTION: arp_ctls_pkg.select_summary()');
761: END IF;
762: RAISE;
763:
764: END select_summary;

Line 778: | arp_util.debug |

774: | |
775: | SCOPE - PRIVATE |
776: | |
777: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
778: | arp_util.debug |
779: | |
780: | ARGUMENTS : IN: |
781: | p_cust_trx_line_salesrep_id |
782: | OUT: |

Line 804: arp_util.debug('arp_ctls_pkg.display_salescredit()+');

800: l_srep_rec ra_cust_trx_line_salesreps%rowtype;
801:
802: BEGIN
803:
804: arp_util.debug('arp_ctls_pkg.display_salescredit()+');
805:
806: arp_ctls_pkg.fetch_p(l_srep_rec, p_cust_trx_line_salesrep_id);
807:
808: arp_ctls_pkg.display_salescredit_rec(l_srep_rec);

Line 810: arp_util.debug('arp_ctls_pkg.display_salescredit()-');

806: arp_ctls_pkg.fetch_p(l_srep_rec, p_cust_trx_line_salesrep_id);
807:
808: arp_ctls_pkg.display_salescredit_rec(l_srep_rec);
809:
810: arp_util.debug('arp_ctls_pkg.display_salescredit()-');
811:
812: EXCEPTION
813: WHEN OTHERS THEN
814: arp_util.debug('EXCEPTION: arp_ctls_pkg.display_salescredit()');

Line 814: arp_util.debug('EXCEPTION: arp_ctls_pkg.display_salescredit()');

810: arp_util.debug('arp_ctls_pkg.display_salescredit()-');
811:
812: EXCEPTION
813: WHEN OTHERS THEN
814: arp_util.debug('EXCEPTION: arp_ctls_pkg.display_salescredit()');
815: RAISE;
816:
817: END;
818:

Line 830: | arp_util.debug |

826: | |
827: | SCOPE - PRIVATE |
828: | |
829: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
830: | arp_util.debug |
831: | |
832: | ARGUMENTS : IN: |
833: | p_srep_rec |
834: | OUT: |

Line 855: arp_util.debug('arp_ctls_pkg.display_salescredit_rec()+');

851:
852:
853: BEGIN
854:
855: arp_util.debug('arp_ctls_pkg.display_salescredit_rec()+');
856:
857: arp_util.debug('************** Dump of ra_cust_trx_line_salesreps record '||
858: '**************');
859:

Line 857: arp_util.debug('************** Dump of ra_cust_trx_line_salesreps record '||

853: BEGIN
854:
855: arp_util.debug('arp_ctls_pkg.display_salescredit_rec()+');
856:
857: arp_util.debug('************** Dump of ra_cust_trx_line_salesreps record '||
858: '**************');
859:
860: arp_util.debug('cust_trx_line_salesrep_id: ' ||
861: p_srep_rec.cust_trx_line_salesrep_id);

Line 860: arp_util.debug('cust_trx_line_salesrep_id: ' ||

856:
857: arp_util.debug('************** Dump of ra_cust_trx_line_salesreps record '||
858: '**************');
859:
860: arp_util.debug('cust_trx_line_salesrep_id: ' ||
861: p_srep_rec.cust_trx_line_salesrep_id);
862: arp_util.debug('customer_trx_id: ' || p_srep_rec.customer_trx_id);
863: arp_util.debug('customer_trx_line_id: ' || p_srep_rec.customer_trx_line_id);
864: arp_util.debug('salesrep_id: ' || p_srep_rec.salesrep_id);

Line 862: arp_util.debug('customer_trx_id: ' || p_srep_rec.customer_trx_id);

858: '**************');
859:
860: arp_util.debug('cust_trx_line_salesrep_id: ' ||
861: p_srep_rec.cust_trx_line_salesrep_id);
862: arp_util.debug('customer_trx_id: ' || p_srep_rec.customer_trx_id);
863: arp_util.debug('customer_trx_line_id: ' || p_srep_rec.customer_trx_line_id);
864: arp_util.debug('salesrep_id: ' || p_srep_rec.salesrep_id);
865: arp_util.debug('revenue_amount_split: ' || p_srep_rec.revenue_amount_split);
866: arp_util.debug('non_revenue_amount_split: ' ||

Line 863: arp_util.debug('customer_trx_line_id: ' || p_srep_rec.customer_trx_line_id);

859:
860: arp_util.debug('cust_trx_line_salesrep_id: ' ||
861: p_srep_rec.cust_trx_line_salesrep_id);
862: arp_util.debug('customer_trx_id: ' || p_srep_rec.customer_trx_id);
863: arp_util.debug('customer_trx_line_id: ' || p_srep_rec.customer_trx_line_id);
864: arp_util.debug('salesrep_id: ' || p_srep_rec.salesrep_id);
865: arp_util.debug('revenue_amount_split: ' || p_srep_rec.revenue_amount_split);
866: arp_util.debug('non_revenue_amount_split: ' ||
867: p_srep_rec.non_revenue_amount_split);

Line 864: arp_util.debug('salesrep_id: ' || p_srep_rec.salesrep_id);

860: arp_util.debug('cust_trx_line_salesrep_id: ' ||
861: p_srep_rec.cust_trx_line_salesrep_id);
862: arp_util.debug('customer_trx_id: ' || p_srep_rec.customer_trx_id);
863: arp_util.debug('customer_trx_line_id: ' || p_srep_rec.customer_trx_line_id);
864: arp_util.debug('salesrep_id: ' || p_srep_rec.salesrep_id);
865: arp_util.debug('revenue_amount_split: ' || p_srep_rec.revenue_amount_split);
866: arp_util.debug('non_revenue_amount_split: ' ||
867: p_srep_rec.non_revenue_amount_split);
868: arp_util.debug('non_revenue_percent_split: ' ||

Line 865: arp_util.debug('revenue_amount_split: ' || p_srep_rec.revenue_amount_split);

861: p_srep_rec.cust_trx_line_salesrep_id);
862: arp_util.debug('customer_trx_id: ' || p_srep_rec.customer_trx_id);
863: arp_util.debug('customer_trx_line_id: ' || p_srep_rec.customer_trx_line_id);
864: arp_util.debug('salesrep_id: ' || p_srep_rec.salesrep_id);
865: arp_util.debug('revenue_amount_split: ' || p_srep_rec.revenue_amount_split);
866: arp_util.debug('non_revenue_amount_split: ' ||
867: p_srep_rec.non_revenue_amount_split);
868: arp_util.debug('non_revenue_percent_split: ' ||
869: p_srep_rec.non_revenue_percent_split);

Line 866: arp_util.debug('non_revenue_amount_split: ' ||

862: arp_util.debug('customer_trx_id: ' || p_srep_rec.customer_trx_id);
863: arp_util.debug('customer_trx_line_id: ' || p_srep_rec.customer_trx_line_id);
864: arp_util.debug('salesrep_id: ' || p_srep_rec.salesrep_id);
865: arp_util.debug('revenue_amount_split: ' || p_srep_rec.revenue_amount_split);
866: arp_util.debug('non_revenue_amount_split: ' ||
867: p_srep_rec.non_revenue_amount_split);
868: arp_util.debug('non_revenue_percent_split: ' ||
869: p_srep_rec.non_revenue_percent_split);
870: arp_util.debug('revenue_percent_split: ' ||

Line 868: arp_util.debug('non_revenue_percent_split: ' ||

864: arp_util.debug('salesrep_id: ' || p_srep_rec.salesrep_id);
865: arp_util.debug('revenue_amount_split: ' || p_srep_rec.revenue_amount_split);
866: arp_util.debug('non_revenue_amount_split: ' ||
867: p_srep_rec.non_revenue_amount_split);
868: arp_util.debug('non_revenue_percent_split: ' ||
869: p_srep_rec.non_revenue_percent_split);
870: arp_util.debug('revenue_percent_split: ' ||
871: p_srep_rec.revenue_percent_split);
872: arp_util.debug('original_line_salesrep_id: ' ||

Line 870: arp_util.debug('revenue_percent_split: ' ||

866: arp_util.debug('non_revenue_amount_split: ' ||
867: p_srep_rec.non_revenue_amount_split);
868: arp_util.debug('non_revenue_percent_split: ' ||
869: p_srep_rec.non_revenue_percent_split);
870: arp_util.debug('revenue_percent_split: ' ||
871: p_srep_rec.revenue_percent_split);
872: arp_util.debug('original_line_salesrep_id: ' ||
873: p_srep_rec.original_line_salesrep_id);
874: arp_util.debug('prev_cust_trx_line_salesrep_id: ' ||

Line 872: arp_util.debug('original_line_salesrep_id: ' ||

868: arp_util.debug('non_revenue_percent_split: ' ||
869: p_srep_rec.non_revenue_percent_split);
870: arp_util.debug('revenue_percent_split: ' ||
871: p_srep_rec.revenue_percent_split);
872: arp_util.debug('original_line_salesrep_id: ' ||
873: p_srep_rec.original_line_salesrep_id);
874: arp_util.debug('prev_cust_trx_line_salesrep_id: ' ||
875: p_srep_rec.prev_cust_trx_line_salesrep_id);
876: arp_util.debug('attribute_category: ' || p_srep_rec.attribute_category);

Line 874: arp_util.debug('prev_cust_trx_line_salesrep_id: ' ||

870: arp_util.debug('revenue_percent_split: ' ||
871: p_srep_rec.revenue_percent_split);
872: arp_util.debug('original_line_salesrep_id: ' ||
873: p_srep_rec.original_line_salesrep_id);
874: arp_util.debug('prev_cust_trx_line_salesrep_id: ' ||
875: p_srep_rec.prev_cust_trx_line_salesrep_id);
876: arp_util.debug('attribute_category: ' || p_srep_rec.attribute_category);
877: arp_util.debug('attribute1: ' || p_srep_rec.attribute1);
878: arp_util.debug('attribute2: ' || p_srep_rec.attribute2);

Line 876: arp_util.debug('attribute_category: ' || p_srep_rec.attribute_category);

872: arp_util.debug('original_line_salesrep_id: ' ||
873: p_srep_rec.original_line_salesrep_id);
874: arp_util.debug('prev_cust_trx_line_salesrep_id: ' ||
875: p_srep_rec.prev_cust_trx_line_salesrep_id);
876: arp_util.debug('attribute_category: ' || p_srep_rec.attribute_category);
877: arp_util.debug('attribute1: ' || p_srep_rec.attribute1);
878: arp_util.debug('attribute2: ' || p_srep_rec.attribute2);
879: arp_util.debug('attribute3: ' || p_srep_rec.attribute3);
880: arp_util.debug('attribute4: ' || p_srep_rec.attribute4);

Line 877: arp_util.debug('attribute1: ' || p_srep_rec.attribute1);

873: p_srep_rec.original_line_salesrep_id);
874: arp_util.debug('prev_cust_trx_line_salesrep_id: ' ||
875: p_srep_rec.prev_cust_trx_line_salesrep_id);
876: arp_util.debug('attribute_category: ' || p_srep_rec.attribute_category);
877: arp_util.debug('attribute1: ' || p_srep_rec.attribute1);
878: arp_util.debug('attribute2: ' || p_srep_rec.attribute2);
879: arp_util.debug('attribute3: ' || p_srep_rec.attribute3);
880: arp_util.debug('attribute4: ' || p_srep_rec.attribute4);
881: arp_util.debug('attribute5: ' || p_srep_rec.attribute5);

Line 878: arp_util.debug('attribute2: ' || p_srep_rec.attribute2);

874: arp_util.debug('prev_cust_trx_line_salesrep_id: ' ||
875: p_srep_rec.prev_cust_trx_line_salesrep_id);
876: arp_util.debug('attribute_category: ' || p_srep_rec.attribute_category);
877: arp_util.debug('attribute1: ' || p_srep_rec.attribute1);
878: arp_util.debug('attribute2: ' || p_srep_rec.attribute2);
879: arp_util.debug('attribute3: ' || p_srep_rec.attribute3);
880: arp_util.debug('attribute4: ' || p_srep_rec.attribute4);
881: arp_util.debug('attribute5: ' || p_srep_rec.attribute5);
882: arp_util.debug('attribute6: ' || p_srep_rec.attribute6);

Line 879: arp_util.debug('attribute3: ' || p_srep_rec.attribute3);

875: p_srep_rec.prev_cust_trx_line_salesrep_id);
876: arp_util.debug('attribute_category: ' || p_srep_rec.attribute_category);
877: arp_util.debug('attribute1: ' || p_srep_rec.attribute1);
878: arp_util.debug('attribute2: ' || p_srep_rec.attribute2);
879: arp_util.debug('attribute3: ' || p_srep_rec.attribute3);
880: arp_util.debug('attribute4: ' || p_srep_rec.attribute4);
881: arp_util.debug('attribute5: ' || p_srep_rec.attribute5);
882: arp_util.debug('attribute6: ' || p_srep_rec.attribute6);
883: arp_util.debug('attribute7: ' || p_srep_rec.attribute7);

Line 880: arp_util.debug('attribute4: ' || p_srep_rec.attribute4);

876: arp_util.debug('attribute_category: ' || p_srep_rec.attribute_category);
877: arp_util.debug('attribute1: ' || p_srep_rec.attribute1);
878: arp_util.debug('attribute2: ' || p_srep_rec.attribute2);
879: arp_util.debug('attribute3: ' || p_srep_rec.attribute3);
880: arp_util.debug('attribute4: ' || p_srep_rec.attribute4);
881: arp_util.debug('attribute5: ' || p_srep_rec.attribute5);
882: arp_util.debug('attribute6: ' || p_srep_rec.attribute6);
883: arp_util.debug('attribute7: ' || p_srep_rec.attribute7);
884: arp_util.debug('attribute8: ' || p_srep_rec.attribute8);

Line 881: arp_util.debug('attribute5: ' || p_srep_rec.attribute5);

877: arp_util.debug('attribute1: ' || p_srep_rec.attribute1);
878: arp_util.debug('attribute2: ' || p_srep_rec.attribute2);
879: arp_util.debug('attribute3: ' || p_srep_rec.attribute3);
880: arp_util.debug('attribute4: ' || p_srep_rec.attribute4);
881: arp_util.debug('attribute5: ' || p_srep_rec.attribute5);
882: arp_util.debug('attribute6: ' || p_srep_rec.attribute6);
883: arp_util.debug('attribute7: ' || p_srep_rec.attribute7);
884: arp_util.debug('attribute8: ' || p_srep_rec.attribute8);
885: arp_util.debug('attribute9: ' || p_srep_rec.attribute9);

Line 882: arp_util.debug('attribute6: ' || p_srep_rec.attribute6);

878: arp_util.debug('attribute2: ' || p_srep_rec.attribute2);
879: arp_util.debug('attribute3: ' || p_srep_rec.attribute3);
880: arp_util.debug('attribute4: ' || p_srep_rec.attribute4);
881: arp_util.debug('attribute5: ' || p_srep_rec.attribute5);
882: arp_util.debug('attribute6: ' || p_srep_rec.attribute6);
883: arp_util.debug('attribute7: ' || p_srep_rec.attribute7);
884: arp_util.debug('attribute8: ' || p_srep_rec.attribute8);
885: arp_util.debug('attribute9: ' || p_srep_rec.attribute9);
886: arp_util.debug('attribute10: ' || p_srep_rec.attribute10);

Line 883: arp_util.debug('attribute7: ' || p_srep_rec.attribute7);

879: arp_util.debug('attribute3: ' || p_srep_rec.attribute3);
880: arp_util.debug('attribute4: ' || p_srep_rec.attribute4);
881: arp_util.debug('attribute5: ' || p_srep_rec.attribute5);
882: arp_util.debug('attribute6: ' || p_srep_rec.attribute6);
883: arp_util.debug('attribute7: ' || p_srep_rec.attribute7);
884: arp_util.debug('attribute8: ' || p_srep_rec.attribute8);
885: arp_util.debug('attribute9: ' || p_srep_rec.attribute9);
886: arp_util.debug('attribute10: ' || p_srep_rec.attribute10);
887: arp_util.debug('attribute11: ' || p_srep_rec.attribute11);

Line 884: arp_util.debug('attribute8: ' || p_srep_rec.attribute8);

880: arp_util.debug('attribute4: ' || p_srep_rec.attribute4);
881: arp_util.debug('attribute5: ' || p_srep_rec.attribute5);
882: arp_util.debug('attribute6: ' || p_srep_rec.attribute6);
883: arp_util.debug('attribute7: ' || p_srep_rec.attribute7);
884: arp_util.debug('attribute8: ' || p_srep_rec.attribute8);
885: arp_util.debug('attribute9: ' || p_srep_rec.attribute9);
886: arp_util.debug('attribute10: ' || p_srep_rec.attribute10);
887: arp_util.debug('attribute11: ' || p_srep_rec.attribute11);
888: arp_util.debug('attribute12: ' || p_srep_rec.attribute12);

Line 885: arp_util.debug('attribute9: ' || p_srep_rec.attribute9);

881: arp_util.debug('attribute5: ' || p_srep_rec.attribute5);
882: arp_util.debug('attribute6: ' || p_srep_rec.attribute6);
883: arp_util.debug('attribute7: ' || p_srep_rec.attribute7);
884: arp_util.debug('attribute8: ' || p_srep_rec.attribute8);
885: arp_util.debug('attribute9: ' || p_srep_rec.attribute9);
886: arp_util.debug('attribute10: ' || p_srep_rec.attribute10);
887: arp_util.debug('attribute11: ' || p_srep_rec.attribute11);
888: arp_util.debug('attribute12: ' || p_srep_rec.attribute12);
889: arp_util.debug('attribute13: ' || p_srep_rec.attribute13);

Line 886: arp_util.debug('attribute10: ' || p_srep_rec.attribute10);

882: arp_util.debug('attribute6: ' || p_srep_rec.attribute6);
883: arp_util.debug('attribute7: ' || p_srep_rec.attribute7);
884: arp_util.debug('attribute8: ' || p_srep_rec.attribute8);
885: arp_util.debug('attribute9: ' || p_srep_rec.attribute9);
886: arp_util.debug('attribute10: ' || p_srep_rec.attribute10);
887: arp_util.debug('attribute11: ' || p_srep_rec.attribute11);
888: arp_util.debug('attribute12: ' || p_srep_rec.attribute12);
889: arp_util.debug('attribute13: ' || p_srep_rec.attribute13);
890: arp_util.debug('attribute14: ' || p_srep_rec.attribute14);

Line 887: arp_util.debug('attribute11: ' || p_srep_rec.attribute11);

883: arp_util.debug('attribute7: ' || p_srep_rec.attribute7);
884: arp_util.debug('attribute8: ' || p_srep_rec.attribute8);
885: arp_util.debug('attribute9: ' || p_srep_rec.attribute9);
886: arp_util.debug('attribute10: ' || p_srep_rec.attribute10);
887: arp_util.debug('attribute11: ' || p_srep_rec.attribute11);
888: arp_util.debug('attribute12: ' || p_srep_rec.attribute12);
889: arp_util.debug('attribute13: ' || p_srep_rec.attribute13);
890: arp_util.debug('attribute14: ' || p_srep_rec.attribute14);
891: arp_util.debug('attribute15: ' || p_srep_rec.attribute15);

Line 888: arp_util.debug('attribute12: ' || p_srep_rec.attribute12);

884: arp_util.debug('attribute8: ' || p_srep_rec.attribute8);
885: arp_util.debug('attribute9: ' || p_srep_rec.attribute9);
886: arp_util.debug('attribute10: ' || p_srep_rec.attribute10);
887: arp_util.debug('attribute11: ' || p_srep_rec.attribute11);
888: arp_util.debug('attribute12: ' || p_srep_rec.attribute12);
889: arp_util.debug('attribute13: ' || p_srep_rec.attribute13);
890: arp_util.debug('attribute14: ' || p_srep_rec.attribute14);
891: arp_util.debug('attribute15: ' || p_srep_rec.attribute15);
892: /* BEGIN bug 3067675 */

Line 889: arp_util.debug('attribute13: ' || p_srep_rec.attribute13);

885: arp_util.debug('attribute9: ' || p_srep_rec.attribute9);
886: arp_util.debug('attribute10: ' || p_srep_rec.attribute10);
887: arp_util.debug('attribute11: ' || p_srep_rec.attribute11);
888: arp_util.debug('attribute12: ' || p_srep_rec.attribute12);
889: arp_util.debug('attribute13: ' || p_srep_rec.attribute13);
890: arp_util.debug('attribute14: ' || p_srep_rec.attribute14);
891: arp_util.debug('attribute15: ' || p_srep_rec.attribute15);
892: /* BEGIN bug 3067675 */
893: arp_util.debug('revenue_salesgroup_id: ' || p_srep_rec.revenue_salesgroup_id);

Line 890: arp_util.debug('attribute14: ' || p_srep_rec.attribute14);

886: arp_util.debug('attribute10: ' || p_srep_rec.attribute10);
887: arp_util.debug('attribute11: ' || p_srep_rec.attribute11);
888: arp_util.debug('attribute12: ' || p_srep_rec.attribute12);
889: arp_util.debug('attribute13: ' || p_srep_rec.attribute13);
890: arp_util.debug('attribute14: ' || p_srep_rec.attribute14);
891: arp_util.debug('attribute15: ' || p_srep_rec.attribute15);
892: /* BEGIN bug 3067675 */
893: arp_util.debug('revenue_salesgroup_id: ' || p_srep_rec.revenue_salesgroup_id);
894: arp_util.debug('non_revenue_salesgroup_id: ' || p_srep_rec.non_revenue_salesgroup_id);

Line 891: arp_util.debug('attribute15: ' || p_srep_rec.attribute15);

887: arp_util.debug('attribute11: ' || p_srep_rec.attribute11);
888: arp_util.debug('attribute12: ' || p_srep_rec.attribute12);
889: arp_util.debug('attribute13: ' || p_srep_rec.attribute13);
890: arp_util.debug('attribute14: ' || p_srep_rec.attribute14);
891: arp_util.debug('attribute15: ' || p_srep_rec.attribute15);
892: /* BEGIN bug 3067675 */
893: arp_util.debug('revenue_salesgroup_id: ' || p_srep_rec.revenue_salesgroup_id);
894: arp_util.debug('non_revenue_salesgroup_id: ' || p_srep_rec.non_revenue_salesgroup_id);
895: /* END bug 3067675 */

Line 893: arp_util.debug('revenue_salesgroup_id: ' || p_srep_rec.revenue_salesgroup_id);

889: arp_util.debug('attribute13: ' || p_srep_rec.attribute13);
890: arp_util.debug('attribute14: ' || p_srep_rec.attribute14);
891: arp_util.debug('attribute15: ' || p_srep_rec.attribute15);
892: /* BEGIN bug 3067675 */
893: arp_util.debug('revenue_salesgroup_id: ' || p_srep_rec.revenue_salesgroup_id);
894: arp_util.debug('non_revenue_salesgroup_id: ' || p_srep_rec.non_revenue_salesgroup_id);
895: /* END bug 3067675 */
896: arp_util.debug('last_updated_by: ' || p_srep_rec.last_updated_by);
897: arp_util.debug('created_by: ' || p_srep_rec.created_by);

Line 894: arp_util.debug('non_revenue_salesgroup_id: ' || p_srep_rec.non_revenue_salesgroup_id);

890: arp_util.debug('attribute14: ' || p_srep_rec.attribute14);
891: arp_util.debug('attribute15: ' || p_srep_rec.attribute15);
892: /* BEGIN bug 3067675 */
893: arp_util.debug('revenue_salesgroup_id: ' || p_srep_rec.revenue_salesgroup_id);
894: arp_util.debug('non_revenue_salesgroup_id: ' || p_srep_rec.non_revenue_salesgroup_id);
895: /* END bug 3067675 */
896: arp_util.debug('last_updated_by: ' || p_srep_rec.last_updated_by);
897: arp_util.debug('created_by: ' || p_srep_rec.created_by);
898: arp_util.debug('last_update_login: ' || p_srep_rec.last_update_login);

Line 896: arp_util.debug('last_updated_by: ' || p_srep_rec.last_updated_by);

892: /* BEGIN bug 3067675 */
893: arp_util.debug('revenue_salesgroup_id: ' || p_srep_rec.revenue_salesgroup_id);
894: arp_util.debug('non_revenue_salesgroup_id: ' || p_srep_rec.non_revenue_salesgroup_id);
895: /* END bug 3067675 */
896: arp_util.debug('last_updated_by: ' || p_srep_rec.last_updated_by);
897: arp_util.debug('created_by: ' || p_srep_rec.created_by);
898: arp_util.debug('last_update_login: ' || p_srep_rec.last_update_login);
899: arp_util.debug('program_application_id: ' ||
900: p_srep_rec.program_application_id);

Line 897: arp_util.debug('created_by: ' || p_srep_rec.created_by);

893: arp_util.debug('revenue_salesgroup_id: ' || p_srep_rec.revenue_salesgroup_id);
894: arp_util.debug('non_revenue_salesgroup_id: ' || p_srep_rec.non_revenue_salesgroup_id);
895: /* END bug 3067675 */
896: arp_util.debug('last_updated_by: ' || p_srep_rec.last_updated_by);
897: arp_util.debug('created_by: ' || p_srep_rec.created_by);
898: arp_util.debug('last_update_login: ' || p_srep_rec.last_update_login);
899: arp_util.debug('program_application_id: ' ||
900: p_srep_rec.program_application_id);
901: arp_util.debug('program_id: ' || p_srep_rec.program_id);

Line 898: arp_util.debug('last_update_login: ' || p_srep_rec.last_update_login);

894: arp_util.debug('non_revenue_salesgroup_id: ' || p_srep_rec.non_revenue_salesgroup_id);
895: /* END bug 3067675 */
896: arp_util.debug('last_updated_by: ' || p_srep_rec.last_updated_by);
897: arp_util.debug('created_by: ' || p_srep_rec.created_by);
898: arp_util.debug('last_update_login: ' || p_srep_rec.last_update_login);
899: arp_util.debug('program_application_id: ' ||
900: p_srep_rec.program_application_id);
901: arp_util.debug('program_id: ' || p_srep_rec.program_id);
902:

Line 899: arp_util.debug('program_application_id: ' ||

895: /* END bug 3067675 */
896: arp_util.debug('last_updated_by: ' || p_srep_rec.last_updated_by);
897: arp_util.debug('created_by: ' || p_srep_rec.created_by);
898: arp_util.debug('last_update_login: ' || p_srep_rec.last_update_login);
899: arp_util.debug('program_application_id: ' ||
900: p_srep_rec.program_application_id);
901: arp_util.debug('program_id: ' || p_srep_rec.program_id);
902:
903: arp_util.debug('************** End ra_cust_trx_line_salesreps record ' ||

Line 901: arp_util.debug('program_id: ' || p_srep_rec.program_id);

897: arp_util.debug('created_by: ' || p_srep_rec.created_by);
898: arp_util.debug('last_update_login: ' || p_srep_rec.last_update_login);
899: arp_util.debug('program_application_id: ' ||
900: p_srep_rec.program_application_id);
901: arp_util.debug('program_id: ' || p_srep_rec.program_id);
902:
903: arp_util.debug('************** End ra_cust_trx_line_salesreps record ' ||
904: '**************');
905:

Line 903: arp_util.debug('************** End ra_cust_trx_line_salesreps record ' ||

899: arp_util.debug('program_application_id: ' ||
900: p_srep_rec.program_application_id);
901: arp_util.debug('program_id: ' || p_srep_rec.program_id);
902:
903: arp_util.debug('************** End ra_cust_trx_line_salesreps record ' ||
904: '**************');
905:
906: arp_util.debug('arp_ctls_pkg.display_salescredit_rec()-');
907:

Line 906: arp_util.debug('arp_ctls_pkg.display_salescredit_rec()-');

902:
903: arp_util.debug('************** End ra_cust_trx_line_salesreps record ' ||
904: '**************');
905:
906: arp_util.debug('arp_ctls_pkg.display_salescredit_rec()-');
907:
908: EXCEPTION
909: WHEN OTHERS THEN
910: arp_util.debug('EXCEPTION: arp_ctls_pkg.display_salescredit_rec()');

Line 910: arp_util.debug('EXCEPTION: arp_ctls_pkg.display_salescredit_rec()');

906: arp_util.debug('arp_ctls_pkg.display_salescredit_rec()-');
907:
908: EXCEPTION
909: WHEN OTHERS THEN
910: arp_util.debug('EXCEPTION: arp_ctls_pkg.display_salescredit_rec()');
911: RAISE;
912:
913: END;
914:

Line 926: | arp_util.debug |

922: | |
923: | SCOPE - PUBLIC |
924: | |
925: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
926: | arp_util.debug |
927: | |
928: | ARGUMENTS : IN: |
929: | p_customer_trx_line_id |
930: | OUT: |

Line 962: arp_util.debug('arp_ctls_pkg.display_salescredit_f_ctl_id()+');

958:
959:
960: BEGIN
961:
962: arp_util.debug('arp_ctls_pkg.display_salescredit_f_ctl_id()+');
963:
964: arp_util.debug('=====================================================' ||
965: '==========================');
966: arp_util.debug('========= ' ||

Line 964: arp_util.debug('=====================================================' ||

960: BEGIN
961:
962: arp_util.debug('arp_ctls_pkg.display_salescredit_f_ctl_id()+');
963:
964: arp_util.debug('=====================================================' ||
965: '==========================');
966: arp_util.debug('========= ' ||
967: ' Dump of ra_cust_trx_line_salesreps records for ctlid: '||
968: to_char( p_customer_trx_line_id ) || ' ' ||

Line 966: arp_util.debug('========= ' ||

962: arp_util.debug('arp_ctls_pkg.display_salescredit_f_ctl_id()+');
963:
964: arp_util.debug('=====================================================' ||
965: '==========================');
966: arp_util.debug('========= ' ||
967: ' Dump of ra_cust_trx_line_salesreps records for ctlid: '||
968: to_char( p_customer_trx_line_id ) || ' ' ||
969: '=========');
970:

Line 975: arp_util.debug('===== End ' ||

971: FOR l_srep_rec IN srep_cursor LOOP
972: display_salescredit(l_srep_rec.cust_trx_line_salesrep_id);
973: END LOOP;
974:
975: arp_util.debug('===== End ' ||
976: ' Dump of ra_cust_trx_line_salesreps records for ctlid: '||
977: to_char( p_customer_trx_line_id ) || ' ' ||
978: '=========');
979: arp_util.debug('=====================================================' ||

Line 979: arp_util.debug('=====================================================' ||

975: arp_util.debug('===== End ' ||
976: ' Dump of ra_cust_trx_line_salesreps records for ctlid: '||
977: to_char( p_customer_trx_line_id ) || ' ' ||
978: '=========');
979: arp_util.debug('=====================================================' ||
980: '==========================');
981:
982: arp_util.debug('arp_ctls_pkg.display_salescredit_f_ctl_id()-');
983:

Line 982: arp_util.debug('arp_ctls_pkg.display_salescredit_f_ctl_id()-');

978: '=========');
979: arp_util.debug('=====================================================' ||
980: '==========================');
981:
982: arp_util.debug('arp_ctls_pkg.display_salescredit_f_ctl_id()-');
983:
984: EXCEPTION
985: WHEN OTHERS THEN
986: arp_util.debug('EXCEPTION: arp_ctls_pkg.display_salescredit_f_ctl_id()');

Line 986: arp_util.debug('EXCEPTION: arp_ctls_pkg.display_salescredit_f_ctl_id()');

982: arp_util.debug('arp_ctls_pkg.display_salescredit_f_ctl_id()-');
983:
984: EXCEPTION
985: WHEN OTHERS THEN
986: arp_util.debug('EXCEPTION: arp_ctls_pkg.display_salescredit_f_ctl_id()');
987: RAISE;
988:
989: END;
990:

Line 1003: | arp_util.debug |

999: | |
1000: | SCOPE - PRIVATE |
1001: | |
1002: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1003: | arp_util.debug |
1004: | |
1005: | ARGUMENTS : IN: |
1006: | p_old_srep_rec |
1007: | p_new_srep_rec |

Line 1032: arp_util.debug('arp_ctls_pkg.merge_srep_recs()+');

1028: IS
1029:
1030: BEGIN
1031:
1032: arp_util.debug('arp_ctls_pkg.merge_srep_recs()+');
1033:
1034:
1035: if (p_new_srep_rec.customer_trx_id = AR_NUMBER_DUMMY)
1036: then p_out_srep_rec.customer_trx_id := p_old_srep_rec.customer_trx_id;

Line 1183: arp_util.debug('arp_ctls_pkg.merge_srep_recs()-');

1179: end if;
1180:
1181: /* END bug 3067675 */
1182:
1183: arp_util.debug('arp_ctls_pkg.merge_srep_recs()-');
1184:
1185: EXCEPTION
1186: WHEN OTHERS THEN
1187: arp_util.debug('EXCEPTION: merge_srep_recs.backout_salesrep()');

Line 1187: arp_util.debug('EXCEPTION: merge_srep_recs.backout_salesrep()');

1183: arp_util.debug('arp_ctls_pkg.merge_srep_recs()-');
1184:
1185: EXCEPTION
1186: WHEN OTHERS THEN
1187: arp_util.debug('EXCEPTION: merge_srep_recs.backout_salesrep()');
1188: RAISE;
1189:
1190: END;
1191:

Line 1208: | arp_util.debug |

1204: | |
1205: | SCOPE - PUBLIC |
1206: | |
1207: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1208: | arp_util.debug |
1209: | |
1210: | ARGUMENTS : IN: |
1211: | None |
1212: | OUT: |

Line 1228: arp_util.debug('arp_ctls_pkg.set_to_dummy()+');

1224: PROCEDURE set_to_dummy( p_srep_rec OUT NOCOPY ra_cust_trx_line_salesreps%rowtype) IS
1225:
1226: BEGIN
1227:
1228: arp_util.debug('arp_ctls_pkg.set_to_dummy()+');
1229:
1230: p_srep_rec.cust_trx_line_salesrep_id := AR_NUMBER_DUMMY;
1231: p_srep_rec.customer_trx_id := AR_NUMBER_DUMMY;
1232: p_srep_rec.customer_trx_line_id := AR_NUMBER_DUMMY;

Line 1268: arp_util.debug('arp_ctls_pkg.set_to_dummy()-');

1264: p_srep_rec.program_application_id := AR_NUMBER_DUMMY;
1265: p_srep_rec.program_id := AR_NUMBER_DUMMY;
1266: p_srep_rec.program_update_date := AR_DATE_DUMMY;
1267:
1268: arp_util.debug('arp_ctls_pkg.set_to_dummy()-');
1269:
1270: EXCEPTION
1271: WHEN OTHERS THEN
1272: arp_util.debug('EXCEPTION: arp_ctls_pkg.set_to_dummy()');

Line 1272: arp_util.debug('EXCEPTION: arp_ctls_pkg.set_to_dummy()');

1268: arp_util.debug('arp_ctls_pkg.set_to_dummy()-');
1269:
1270: EXCEPTION
1271: WHEN OTHERS THEN
1272: arp_util.debug('EXCEPTION: arp_ctls_pkg.set_to_dummy()');
1273: RAISE;
1274:
1275: END;
1276:

Line 1287: | arp_util.debug |

1283: | |
1284: | SCOPE - PUBLIC |
1285: | |
1286: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1287: | arp_util.debug |
1288: | |
1289: | ARGUMENTS : IN: |
1290: | None |
1291: | OUT: |

Line 1307: arp_util.debug('arp_ctls_pkg.get_number_dummy()+');

1303: FUNCTION get_number_dummy(p_null IN NUMBER DEFAULT null) RETURN number IS
1304:
1305: BEGIN
1306:
1307: arp_util.debug('arp_ctls_pkg.get_number_dummy()+');
1308:
1309: arp_util.debug('arp_ctls_pkg.get_number_dummy()-');
1310:
1311: return(AR_NUMBER_DUMMY);

Line 1309: arp_util.debug('arp_ctls_pkg.get_number_dummy()-');

1305: BEGIN
1306:
1307: arp_util.debug('arp_ctls_pkg.get_number_dummy()+');
1308:
1309: arp_util.debug('arp_ctls_pkg.get_number_dummy()-');
1310:
1311: return(AR_NUMBER_DUMMY);
1312:
1313: EXCEPTION

Line 1315: arp_util.debug('EXCEPTION: arp_ctls_pkg.get_number_dummy()');

1311: return(AR_NUMBER_DUMMY);
1312:
1313: EXCEPTION
1314: WHEN OTHERS THEN
1315: arp_util.debug('EXCEPTION: arp_ctls_pkg.get_number_dummy()');
1316: RAISE;
1317:
1318: END;
1319:

Line 1332: | arp_util.debug |

1328: | |
1329: | SCOPE - PUBLIC |
1330: | |
1331: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1332: | arp_util.debug |
1333: | |
1334: | ARGUMENTS : IN: |
1335: | p_cust_trx_line_salesrep_id - identifies the row to lock |
1336: | OUT: |

Line 1357: arp_util.debug('arp_ctls_pkg.lock_p()+');

1353: l_cust_trx_line_salesrep_id
1354: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;
1355:
1356: BEGIN
1357: arp_util.debug('arp_ctls_pkg.lock_p()+');
1358:
1359:
1360: SELECT cust_trx_line_salesrep_id
1361: INTO l_cust_trx_line_salesrep_id

Line 1366: arp_util.debug('arp_ctls_pkg.lock_p()-');

1362: FROM ra_cust_trx_line_salesreps
1363: WHERE cust_trx_line_salesrep_id = p_cust_trx_line_salesrep_id
1364: FOR UPDATE OF cust_trx_line_salesrep_id NOWAIT;
1365:
1366: arp_util.debug('arp_ctls_pkg.lock_p()-');
1367:
1368: EXCEPTION
1369: WHEN OTHERS THEN
1370: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_p' );

Line 1370: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_p' );

1366: arp_util.debug('arp_ctls_pkg.lock_p()-');
1367:
1368: EXCEPTION
1369: WHEN OTHERS THEN
1370: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_p' );
1371: RAISE;
1372: END;
1373:
1374: /*===========================================================================+

Line 1385: | arp_util.debug |

1381: | |
1382: | SCOPE - PUBLIC |
1383: | |
1384: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1385: | arp_util.debug |
1386: | |
1387: | ARGUMENTS : IN: |
1388: | p_customer_trx_id - identifies the rows to lock |
1389: | OUT: |

Line 1413: arp_util.debug('arp_ctls_pkg.lock_f_ct_id()+');

1409: FOR UPDATE OF cust_trx_line_salesrep_id NOWAIT;
1410:
1411:
1412: BEGIN
1413: arp_util.debug('arp_ctls_pkg.lock_f_ct_id()+');
1414:
1415: OPEN lock_c;
1416: CLOSE lock_c;
1417:

Line 1418: arp_util.debug('arp_ctls_pkg.lock_f_ct_id()-');

1414:
1415: OPEN lock_c;
1416: CLOSE lock_c;
1417:
1418: arp_util.debug('arp_ctls_pkg.lock_f_ct_id()-');
1419:
1420: EXCEPTION
1421: WHEN OTHERS THEN
1422: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_f_ct_id' );

Line 1422: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_f_ct_id' );

1418: arp_util.debug('arp_ctls_pkg.lock_f_ct_id()-');
1419:
1420: EXCEPTION
1421: WHEN OTHERS THEN
1422: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_f_ct_id' );
1423: RAISE;
1424: END;
1425:
1426: /*===========================================================================+

Line 1437: | arp_util.debug |

1433: | |
1434: | SCOPE - PUBLIC |
1435: | |
1436: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1437: | arp_util.debug |
1438: | |
1439: | ARGUMENTS : IN: |
1440: | p_customer_trx_line_id - identifies the rows to lock |
1441: | OUT: |

Line 1464: arp_util.debug('arp_ctls_pkg.lock_f_ctl_id()+');

1460: WHERE customer_trx_line_id = p_customer_trx_line_id
1461: FOR UPDATE OF cust_trx_line_salesrep_id NOWAIT;
1462:
1463: BEGIN
1464: arp_util.debug('arp_ctls_pkg.lock_f_ctl_id()+');
1465:
1466: OPEN lock_c;
1467: CLOSE lock_c;
1468:

Line 1469: arp_util.debug('arp_ctls_pkg.lock_f_ctl_id()-');

1465:
1466: OPEN lock_c;
1467: CLOSE lock_c;
1468:
1469: arp_util.debug('arp_ctls_pkg.lock_f_ctl_id()-');
1470:
1471: EXCEPTION
1472: WHEN OTHERS THEN
1473: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_f_ctl_id' );

Line 1473: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_f_ctl_id' );

1469: arp_util.debug('arp_ctls_pkg.lock_f_ctl_id()-');
1470:
1471: EXCEPTION
1472: WHEN OTHERS THEN
1473: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_f_ctl_id' );
1474: RAISE;
1475: END;
1476:
1477: /*===========================================================================+

Line 1489: | arp_util.debug |

1485: | |
1486: | SCOPE - PUBLIC |
1487: | |
1488: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1489: | arp_util.debug |
1490: | |
1491: | ARGUMENTS : IN: |
1492: | p_cust_trx_line_salesrep_id - identifies the row to lock |
1493: | OUT: |

Line 1510: arp_util.debug('arp_ctls_pkg.lock_fetch_p()+');

1506: p_cust_trx_line_salesrep_id IN
1507: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type) IS
1508:
1509: BEGIN
1510: arp_util.debug('arp_ctls_pkg.lock_fetch_p()+');
1511:
1512: SELECT *
1513: INTO p_srep_rec
1514: FROM ra_cust_trx_line_salesreps

Line 1518: arp_util.debug('arp_ctls_pkg.lock_fetch_p()-');

1514: FROM ra_cust_trx_line_salesreps
1515: WHERE cust_trx_line_salesrep_id = p_cust_trx_line_salesrep_id
1516: FOR UPDATE OF cust_trx_line_salesrep_id NOWAIT;
1517:
1518: arp_util.debug('arp_ctls_pkg.lock_fetch_p()-');
1519:
1520: EXCEPTION
1521: WHEN OTHERS THEN
1522: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_fetch_p' );

Line 1522: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_fetch_p' );

1518: arp_util.debug('arp_ctls_pkg.lock_fetch_p()-');
1519:
1520: EXCEPTION
1521: WHEN OTHERS THEN
1522: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_fetch_p' );
1523: RAISE;
1524: END;
1525:
1526: /*===========================================================================+

Line 1538: | arp_util.debug |

1534: | |
1535: | SCOPE - PUBLIC |
1536: | |
1537: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1538: | arp_util.debug |
1539: | |
1540: | ARGUMENTS : IN: |
1541: | p_cust_trx_line_salesrep_id - identifies the row to lock |
1542: | p_srep_rec - srep record for comparison |

Line 1567: arp_util.debug('arp_ctls_pkg.lock_compare_p()+');

1563: l_temp_srep_rec ra_cust_trx_line_salesreps%rowtype;
1564: l_ignore_who_flag varchar2(2);
1565:
1566: BEGIN
1567: arp_util.debug('arp_ctls_pkg.lock_compare_p()+');
1568:
1569: IF (p_ignore_who_flag = TRUE)
1570: THEN l_ignore_who_flag := 'Y';
1571: ELSE l_ignore_who_flag := 'N';

Line 1932: arp_util.debug('arp_ctls_pkg.lock_compare_p()-');

1928: )
1929: FOR UPDATE OF cust_trx_line_salesrep_id NOWAIT;
1930:
1931:
1932: arp_util.debug('arp_ctls_pkg.lock_compare_p()-');
1933:
1934: EXCEPTION
1935: WHEN NO_DATA_FOUND THEN
1936:

Line 1937: arp_util.debug('');

1933:
1934: EXCEPTION
1935: WHEN NO_DATA_FOUND THEN
1936:
1937: arp_util.debug('');
1938: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
1939: p_cust_trx_line_salesrep_id );
1940: arp_util.debug('-------- new salescredit record --------');
1941: display_salescredit_rec( p_srep_rec );

Line 1938: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||

1934: EXCEPTION
1935: WHEN NO_DATA_FOUND THEN
1936:
1937: arp_util.debug('');
1938: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
1939: p_cust_trx_line_salesrep_id );
1940: arp_util.debug('-------- new salescredit record --------');
1941: display_salescredit_rec( p_srep_rec );
1942:

Line 1940: arp_util.debug('-------- new salescredit record --------');

1936:
1937: arp_util.debug('');
1938: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
1939: p_cust_trx_line_salesrep_id );
1940: arp_util.debug('-------- new salescredit record --------');
1941: display_salescredit_rec( p_srep_rec );
1942:
1943: arp_util.debug('');
1944:

Line 1943: arp_util.debug('');

1939: p_cust_trx_line_salesrep_id );
1940: arp_util.debug('-------- new salescredit record --------');
1941: display_salescredit_rec( p_srep_rec );
1942:
1943: arp_util.debug('');
1944:
1945: arp_util.debug('-------- old salescredit record --------');
1946:
1947: fetch_p( l_temp_srep_rec,

Line 1945: arp_util.debug('-------- old salescredit record --------');

1941: display_salescredit_rec( p_srep_rec );
1942:
1943: arp_util.debug('');
1944:
1945: arp_util.debug('-------- old salescredit record --------');
1946:
1947: fetch_p( l_temp_srep_rec,
1948: p_cust_trx_line_salesrep_id );
1949:

Line 1956: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_compare_p' );

1952: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1953: APP_EXCEPTION.Raise_Exception;
1954:
1955: WHEN OTHERS THEN
1956: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_compare_p' );
1957: arp_util.debug( SQLERRM );
1958:
1959: arp_util.debug('----- parameters for lock_compare_p -----');
1960:

Line 1957: arp_util.debug( SQLERRM );

1953: APP_EXCEPTION.Raise_Exception;
1954:
1955: WHEN OTHERS THEN
1956: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_compare_p' );
1957: arp_util.debug( SQLERRM );
1958:
1959: arp_util.debug('----- parameters for lock_compare_p -----');
1960:
1961: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||

Line 1959: arp_util.debug('----- parameters for lock_compare_p -----');

1955: WHEN OTHERS THEN
1956: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_compare_p' );
1957: arp_util.debug( SQLERRM );
1958:
1959: arp_util.debug('----- parameters for lock_compare_p -----');
1960:
1961: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
1962: p_cust_trx_line_salesrep_id );
1963: arp_util.debug('p_ignore_who_flag =' ||

Line 1961: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||

1957: arp_util.debug( SQLERRM );
1958:
1959: arp_util.debug('----- parameters for lock_compare_p -----');
1960:
1961: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
1962: p_cust_trx_line_salesrep_id );
1963: arp_util.debug('p_ignore_who_flag =' ||
1964: arp_trx_util.boolean_to_varchar2(p_ignore_who_flag));
1965:

Line 1963: arp_util.debug('p_ignore_who_flag =' ||

1959: arp_util.debug('----- parameters for lock_compare_p -----');
1960:
1961: arp_util.debug('p_cust_trx_line_salesrep_id = ' ||
1962: p_cust_trx_line_salesrep_id );
1963: arp_util.debug('p_ignore_who_flag =' ||
1964: arp_trx_util.boolean_to_varchar2(p_ignore_who_flag));
1965:
1966: arp_util.debug('');
1967: arp_util.debug('-------- new salescredit record --------');

Line 1966: arp_util.debug('');

1962: p_cust_trx_line_salesrep_id );
1963: arp_util.debug('p_ignore_who_flag =' ||
1964: arp_trx_util.boolean_to_varchar2(p_ignore_who_flag));
1965:
1966: arp_util.debug('');
1967: arp_util.debug('-------- new salescredit record --------');
1968: display_salescredit_rec( p_srep_rec );
1969:
1970: arp_util.debug('');

Line 1967: arp_util.debug('-------- new salescredit record --------');

1963: arp_util.debug('p_ignore_who_flag =' ||
1964: arp_trx_util.boolean_to_varchar2(p_ignore_who_flag));
1965:
1966: arp_util.debug('');
1967: arp_util.debug('-------- new salescredit record --------');
1968: display_salescredit_rec( p_srep_rec );
1969:
1970: arp_util.debug('');
1971:

Line 1970: arp_util.debug('');

1966: arp_util.debug('');
1967: arp_util.debug('-------- new salescredit record --------');
1968: display_salescredit_rec( p_srep_rec );
1969:
1970: arp_util.debug('');
1971:
1972: arp_util.debug('-------- old salescredit record --------');
1973:
1974: fetch_p( l_temp_srep_rec,

Line 1972: arp_util.debug('-------- old salescredit record --------');

1968: display_salescredit_rec( p_srep_rec );
1969:
1970: arp_util.debug('');
1971:
1972: arp_util.debug('-------- old salescredit record --------');
1973:
1974: fetch_p( l_temp_srep_rec,
1975: p_cust_trx_line_salesrep_id );
1976:

Line 1995: | arp_util.debug |

1991: | |
1992: | SCOPE - PUBLIC |
1993: | |
1994: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1995: | arp_util.debug |
1996: | |
1997: | ARGUMENTS : IN: |
1998: | p_cust_trx_line_salesrep_id - identifies the record to fetch |
1999: | OUT: |

Line 2017: arp_util.debug('arp_ctls_pkg.fetch_p()+');

2013: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type)
2014: IS
2015:
2016: BEGIN
2017: arp_util.debug('arp_ctls_pkg.fetch_p()+');
2018:
2019: SELECT *
2020: INTO p_srep_rec
2021: FROM ra_cust_trx_line_salesreps

Line 2024: arp_util.debug('arp_ctls_pkg.fetch_p()-');

2020: INTO p_srep_rec
2021: FROM ra_cust_trx_line_salesreps
2022: WHERE cust_trx_line_salesrep_id = p_cust_trx_line_salesrep_id;
2023:
2024: arp_util.debug('arp_ctls_pkg.fetch_p()-');
2025:
2026: EXCEPTION
2027: WHEN OTHERS THEN
2028: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.fetch_p' );

Line 2028: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.fetch_p' );

2024: arp_util.debug('arp_ctls_pkg.fetch_p()-');
2025:
2026: EXCEPTION
2027: WHEN OTHERS THEN
2028: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.fetch_p' );
2029: RAISE;
2030: END;
2031:
2032: /*===========================================================================+

Line 2043: | arp_util.debug |

2039: | |
2040: | SCOPE - PUBLIC |
2041: | |
2042: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2043: | arp_util.debug |
2044: | |
2045: | ARGUMENTS : IN: |
2046: | p_cust_trx_line_salesrep_id - identifies the rows to delete |
2047: | p_customer_trx_line_id |

Line 2071: arp_util.debug('arp_ctls_pkg.delete_p()+');

2067:
2068: BEGIN
2069:
2070:
2071: arp_util.debug('arp_ctls_pkg.delete_p()+');
2072:
2073: wf_event.raise(
2074: p_event_name => 'oracle.apps.ar.transaction.SalesCredit.delete',
2075: p_event_key => to_char(p_cust_trx_line_salesrep_id) || '_' ||

Line 2083: arp_util.debug( rows || ' records deleted');

2079: WHERE cust_trx_line_salesrep_id = p_cust_trx_line_salesrep_id;
2080:
2081: rows := SQL%ROWCOUNT;
2082:
2083: arp_util.debug( rows || ' records deleted');
2084:
2085: IF ( rows = 0 )
2086: THEN arp_util.debug('EXCEPTION: arp_ctls_pkg.delete_p()');
2087: RAISE NO_DATA_FOUND;

Line 2086: THEN arp_util.debug('EXCEPTION: arp_ctls_pkg.delete_p()');

2082:
2083: arp_util.debug( rows || ' records deleted');
2084:
2085: IF ( rows = 0 )
2086: THEN arp_util.debug('EXCEPTION: arp_ctls_pkg.delete_p()');
2087: RAISE NO_DATA_FOUND;
2088: END IF;
2089:
2090: /*---------------------------------------------------------------------+

Line 2102: arp_util.debug('arp_ctls_pkg.delete_p()-');

2098: NULL,
2099: NULL );
2100: END IF;
2101:
2102: arp_util.debug('arp_ctls_pkg.delete_p()-');
2103:
2104: EXCEPTION
2105: WHEN OTHERS THEN
2106: arp_util.debug('EXCEPTION: arp_ctls_pkg.delete_p()');

Line 2106: arp_util.debug('EXCEPTION: arp_ctls_pkg.delete_p()');

2102: arp_util.debug('arp_ctls_pkg.delete_p()-');
2103:
2104: EXCEPTION
2105: WHEN OTHERS THEN
2106: arp_util.debug('EXCEPTION: arp_ctls_pkg.delete_p()');
2107:
2108: RAISE;
2109:
2110: END;

Line 2123: | arp_util.debug |

2119: | |
2120: | SCOPE - PUBLIC |
2121: | |
2122: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2123: | arp_util.debug |
2124: | |
2125: | ARGUMENTS : IN: |
2126: | p_customer_trx_id - identifies the rows to delete |
2127: | p_delete_default_recs_flag |

Line 2157: arp_util.debug('arp_ctls_pkg.delete_f_ct_id()+');

2153:
2154: BEGIN
2155:
2156:
2157: arp_util.debug('arp_ctls_pkg.delete_f_ct_id()+');
2158:
2159: IF ( p_delete_default_recs_flag = TRUE )
2160: THEN
2161: FOR l_srep_rec IN srep_trx_cursor LOOP

Line 2190: arp_util.debug('arp_ctls_pkg.delete_f_ct_id()-');

2186: erase_foreign_key_references( NULL,
2187: p_customer_trx_id,
2188: NULL );
2189:
2190: arp_util.debug('arp_ctls_pkg.delete_f_ct_id()-');
2191:
2192: EXCEPTION
2193: WHEN OTHERS THEN
2194: arp_util.debug('EXCEPTION: arp_ctls_pkg.delete_f_ct_id()');

Line 2194: arp_util.debug('EXCEPTION: arp_ctls_pkg.delete_f_ct_id()');

2190: arp_util.debug('arp_ctls_pkg.delete_f_ct_id()-');
2191:
2192: EXCEPTION
2193: WHEN OTHERS THEN
2194: arp_util.debug('EXCEPTION: arp_ctls_pkg.delete_f_ct_id()');
2195:
2196: RAISE;
2197:
2198: END;

Line 2211: | arp_util.debug |

2207: | |
2208: | SCOPE - PUBLIC |
2209: | |
2210: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2211: | arp_util.debug |
2212: | |
2213: | ARGUMENTS : IN: |
2214: | p_customer_trx_line_id - identifies the rows to delete |
2215: | OUT: |

Line 2238: arp_util.debug('arp_ctls_pkg.delete_f_ctl_id()+');

2234:
2235: BEGIN
2236:
2237:
2238: arp_util.debug('arp_ctls_pkg.delete_f_ctl_id()+');
2239:
2240: FOR l_srep_rec IN srep_cursor LOOP
2241: wf_event.raise(
2242: p_event_name => 'transaction.SalesCredit.apps.ar.salescredits.delete',

Line 2254: arp_util.debug('arp_ctls_pkg.delete_f_ctl_id()-');

2250: erase_foreign_key_references( NULL,
2251: NULL,
2252: p_customer_trx_line_id );
2253:
2254: arp_util.debug('arp_ctls_pkg.delete_f_ctl_id()-');
2255:
2256: EXCEPTION
2257: WHEN OTHERS THEN
2258: arp_util.debug('EXCEPTION: arp_ctls_pkg.delete_f_ctl_id()');

Line 2258: arp_util.debug('EXCEPTION: arp_ctls_pkg.delete_f_ctl_id()');

2254: arp_util.debug('arp_ctls_pkg.delete_f_ctl_id()-');
2255:
2256: EXCEPTION
2257: WHEN OTHERS THEN
2258: arp_util.debug('EXCEPTION: arp_ctls_pkg.delete_f_ctl_id()');
2259:
2260: RAISE;
2261:
2262: END;

Line 2275: | arp_util.debug |

2271: | |
2272: | SCOPE - PUBLIC |
2273: | |
2274: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2275: | arp_util.debug |
2276: | |
2277: | ARGUMENTS : IN: |
2278: | p_cust_trx_line_salesrep_id - identifies the row to update |
2279: | p_srep_rec - contains the new column values |

Line 2302: arp_util.debug('arp_ctls_pkg.update_p()+ ' ||

2298:
2299:
2300: BEGIN
2301:
2302: arp_util.debug('arp_ctls_pkg.update_p()+ ' ||
2303: to_char(sysdate, 'HH:MI:SS'));
2304:
2305: wf_event.raise(
2306: p_event_name => 'oracle.apps.ar.transaction.SalesCredit.update',

Line 2315: arp_util.debug('arp_ctls_pkg.update_p()- ' ||

2311: ' WHERE cust_trx_line_salesrep_id = :where_1',
2312: p_cust_trx_line_salesrep_id,
2313: p_srep_rec);
2314:
2315: arp_util.debug('arp_ctls_pkg.update_p()- ' ||
2316: to_char(sysdate, 'HH:MI:SS'));
2317:
2318:
2319: EXCEPTION

Line 2321: arp_util.debug('EXCEPTION: arp_ctls_pkg.update_p()');

2317:
2318:
2319: EXCEPTION
2320: WHEN OTHERS THEN
2321: arp_util.debug('EXCEPTION: arp_ctls_pkg.update_p()');
2322: RAISE;
2323: END;
2324:
2325:

Line 2337: | arp_util.debug |

2333: | |
2334: | SCOPE - PUBLIC |
2335: | |
2336: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2337: | arp_util.debug |
2338: | |
2339: | ARGUMENTS : IN: |
2340: | p_customer_trx_id - identifies the rows to update |
2341: | p_srep_rec - contains the new column values |

Line 2366: arp_util.debug('arp_ctls_pkg.update_f_ct_id()+ ' ||

2362: where customer_trx_id = p_customer_trx_id;
2363:
2364: BEGIN
2365:
2366: arp_util.debug('arp_ctls_pkg.update_f_ct_id()+ ' ||
2367: to_char(sysdate, 'HH:MI:SS'));
2368:
2369: FOR l_srep_rec IN srep_trx_cursor LOOP
2370: wf_event.raise(

Line 2381: arp_util.debug('arp_ctls_pkg.update_f_ct_id()- ' ||

2377: ' WHERE customer_trx_id = :where_1',
2378: p_customer_trx_id,
2379: p_srep_rec);
2380:
2381: arp_util.debug('arp_ctls_pkg.update_f_ct_id()- ' ||
2382: to_char(sysdate, 'HH:MI:SS'));
2383:
2384:
2385: EXCEPTION

Line 2387: arp_util.debug('EXCEPTION: arp_ctls_pkg.update_f_ct_id()');

2383:
2384:
2385: EXCEPTION
2386: WHEN OTHERS THEN
2387: arp_util.debug('EXCEPTION: arp_ctls_pkg.update_f_ct_id()');
2388: RAISE;
2389: END;
2390:
2391:

Line 2403: | arp_util.debug |

2399: | |
2400: | SCOPE - PUBLIC |
2401: | |
2402: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2403: | arp_util.debug |
2404: | |
2405: | ARGUMENTS : IN: |
2406: | p_customer_trx_line_id - identifies the rows to update |
2407: | p_srep_rec - contains the new column values |

Line 2433: arp_util.debug('arp_ctls_pkg.update_f_ctl_id()+ ' ||

2429: where customer_trx_line_id = p_customer_trx_line_id;
2430:
2431: BEGIN
2432:
2433: arp_util.debug('arp_ctls_pkg.update_f_ctl_id()+ ' ||
2434: to_char(sysdate, 'HH:MI:SS'));
2435:
2436: FOR l_srep_rec IN srep_cursor LOOP
2437: wf_event.raise(

Line 2448: arp_util.debug('arp_ctls_pkg.update_f_ctl_id()- ' ||

2444: ' WHERE customer_trx_line_id = :where_1',
2445: p_customer_trx_line_id,
2446: p_srep_rec);
2447:
2448: arp_util.debug('arp_ctls_pkg.update_f_ctl_id()- ' ||
2449: to_char(sysdate, 'HH:MI:SS'));
2450:
2451:
2452: EXCEPTION

Line 2454: arp_util.debug('EXCEPTION: arp_ctls_pkg.update_f_ctl_id()');

2450:
2451:
2452: EXCEPTION
2453: WHEN OTHERS THEN
2454: arp_util.debug('EXCEPTION: arp_ctls_pkg.update_f_ctl_id()');
2455: RAISE;
2456: END;
2457:
2458: /*===========================================================================+

Line 2469: | arp_util.debug |

2465: | |
2466: | SCOPE - PUBLIC |
2467: | |
2468: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2469: | arp_util.debug |
2470: | |
2471: | ARGUMENTS : IN: |
2472: | p_prev_cust_trx_line_salesrep_id - identifies the rows |
2473: | to update |

Line 2500: arp_util.debug('arp_ctls_pkg.update_f_psr_id()+ ' ||

2496: where prev_cust_trx_line_salesrep_id = p_prev_cust_trx_line_srep_id;
2497:
2498: BEGIN
2499:
2500: arp_util.debug('arp_ctls_pkg.update_f_psr_id()+ ' ||
2501: to_char(sysdate, 'HH:MI:SS'));
2502:
2503: FOR l_srep_rec IN srep_cursor LOOP
2504: wf_event.raise(

Line 2516: arp_util.debug('arp_ctls_pkg.update_f_psr_id()- ' ||

2512: ' WHERE prev_cust_trx_line_salesrep_id = :where_1',
2513: p_prev_cust_trx_line_srep_id,
2514: p_srep_rec);
2515:
2516: arp_util.debug('arp_ctls_pkg.update_f_psr_id()- ' ||
2517: to_char(sysdate, 'HH:MI:SS'));
2518:
2519:
2520: EXCEPTION

Line 2522: arp_util.debug('EXCEPTION: arp_ctls_pkg.update_f_psr_id()');

2518:
2519:
2520: EXCEPTION
2521: WHEN OTHERS THEN
2522: arp_util.debug('EXCEPTION: arp_ctls_pkg.update_f_psr_id()');
2523: RAISE;
2524: END;
2525:
2526: /*===========================================================================+

Line 2537: | arp_util.debug |

2533: | |
2534: | SCOPE - PUBLIC |
2535: | |
2536: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2537: | arp_util.debug |
2538: | |
2539: | ARGUMENTS : IN: |
2540: | p_customer_trx_id - identifies the rows to update |
2541: | p_srep_rec - contains the new column values |

Line 2571: arp_util.debug('arp_ctls_pkg.update_amounts_f_ctl_id()+ ' ||

2567: where customer_trx_line_id = p_customer_trx_line_id;
2568:
2569: BEGIN
2570:
2571: arp_util.debug('arp_ctls_pkg.update_amounts_f_ctl_id()+ ' ||
2572: to_char(sysdate, 'HH:MI:SS'));
2573:
2574: arp_util.debug('p_line_amount = ' || p_line_amount );
2575: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id );

Line 2574: arp_util.debug('p_line_amount = ' || p_line_amount );

2570:
2571: arp_util.debug('arp_ctls_pkg.update_amounts_f_ctl_id()+ ' ||
2572: to_char(sysdate, 'HH:MI:SS'));
2573:
2574: arp_util.debug('p_line_amount = ' || p_line_amount );
2575: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id );
2576: arp_util.debug('p_foreign_currency_code = ' || p_foreign_currency_code );
2577:
2578: FOR l_srep_rec IN srep_cursor LOOP

Line 2575: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id );

2571: arp_util.debug('arp_ctls_pkg.update_amounts_f_ctl_id()+ ' ||
2572: to_char(sysdate, 'HH:MI:SS'));
2573:
2574: arp_util.debug('p_line_amount = ' || p_line_amount );
2575: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id );
2576: arp_util.debug('p_foreign_currency_code = ' || p_foreign_currency_code );
2577:
2578: FOR l_srep_rec IN srep_cursor LOOP
2579: wf_event.raise(

Line 2576: arp_util.debug('p_foreign_currency_code = ' || p_foreign_currency_code );

2572: to_char(sysdate, 'HH:MI:SS'));
2573:
2574: arp_util.debug('p_line_amount = ' || p_line_amount );
2575: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id );
2576: arp_util.debug('p_foreign_currency_code = ' || p_foreign_currency_code );
2577:
2578: FOR l_srep_rec IN srep_cursor LOOP
2579: wf_event.raise(
2580: p_event_name => 'transaction.SalesCredit.apps.ar.salescredits.update',

Line 2601: arp_util.debug(SQL%ROWCOUNT || ' rows updated');

2597: p_foreign_currency_code
2598: )
2599: where customer_trx_line_id = p_customer_trx_line_id;
2600:
2601: arp_util.debug(SQL%ROWCOUNT || ' rows updated');
2602:
2603: arp_util.debug('arp_ctls_pkg.update_amounts_f_ctl_id()- ' ||
2604: to_char(sysdate, 'HH:MI:SS'));
2605:

Line 2603: arp_util.debug('arp_ctls_pkg.update_amounts_f_ctl_id()- ' ||

2599: where customer_trx_line_id = p_customer_trx_line_id;
2600:
2601: arp_util.debug(SQL%ROWCOUNT || ' rows updated');
2602:
2603: arp_util.debug('arp_ctls_pkg.update_amounts_f_ctl_id()- ' ||
2604: to_char(sysdate, 'HH:MI:SS'));
2605:
2606:
2607: EXCEPTION

Line 2609: arp_util.debug('EXCEPTION: arp_ctls_pkg.update_amounts_f_ctl_id()');

2605:
2606:
2607: EXCEPTION
2608: WHEN OTHERS THEN
2609: arp_util.debug('EXCEPTION: arp_ctls_pkg.update_amounts_f_ctl_id()');
2610: RAISE;
2611: END;
2612:
2613:

Line 2625: | arp_util.debug |

2621: | |
2622: | SCOPE - PUBLIC |
2623: | |
2624: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2625: | arp_util.debug |
2626: | |
2627: | ARGUMENTS : IN: |
2628: | p_srep_rec - contains the new column values |
2629: | OUT: |

Line 2655: arp_util.debug('arp_ctls_pkg.insert_p()+');

2651:
2652:
2653: BEGIN
2654:
2655: arp_util.debug('arp_ctls_pkg.insert_p()+');
2656:
2657: p_cust_trx_line_salesrep_id := '';
2658:
2659: /*---------------------------*

Line 2760: arp_util.debug('arp_ctls_pkg.insert_p()-');

2756:
2757:
2758: p_cust_trx_line_salesrep_id := l_cust_trx_line_salesrep_id;
2759:
2760: arp_util.debug('arp_ctls_pkg.insert_p()-');
2761:
2762: EXCEPTION
2763: WHEN OTHERS THEN
2764: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_p()');

Line 2764: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_p()');

2760: arp_util.debug('arp_ctls_pkg.insert_p()-');
2761:
2762: EXCEPTION
2763: WHEN OTHERS THEN
2764: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_p()');
2765: RAISE;
2766: END;
2767:
2768: /*===========================================================================+

Line 2779: | arp_util.debug |

2775: | |
2776: | SCOPE - PUBLIC |
2777: | |
2778: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2779: | arp_util.debug |
2780: | |
2781: | ARGUMENTS : IN: |
2782: | p_customer_trx_line_id |
2783: | p_customer_trx_id |

Line 2808: arp_util.debug('arp_ctls_pkg.insert_f_ct_ctl_id()+');

2804:
2805:
2806: BEGIN
2807:
2808: arp_util.debug('arp_ctls_pkg.insert_f_ct_ctl_id()+');
2809:
2810: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
2811: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
2812:

Line 2810: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);

2806: BEGIN
2807:
2808: arp_util.debug('arp_ctls_pkg.insert_f_ct_ctl_id()+');
2809:
2810: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
2811: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
2812:
2813: ---- temporary! Remove for production. ---- moose
2814: SELECT salesrep_required_flag

Line 2811: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);

2807:
2808: arp_util.debug('arp_ctls_pkg.insert_f_ct_ctl_id()+');
2809:
2810: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
2811: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
2812:
2813: ---- temporary! Remove for production. ---- moose
2814: SELECT salesrep_required_flag
2815: INTO pg_salesrep_required_flag

Line 2881: null, arp_util.Get_Default_SalesGroup(ct.primary_salesrep_id, ct.org_id, ct.trx_date),

2877: NVL(
2878: ctls.revenue_salesgroup_id,
2879: DECODE(
2880: ctls.cust_trx_line_salesrep_id,
2881: null, arp_util.Get_Default_SalesGroup(ct.primary_salesrep_id, ct.org_id, ct.trx_date),
2882: null
2883: )
2884: ),
2885: ctls.non_revenue_percent_split,

Line 2975: null, arp_util.Get_Default_SalesGroup(ct.primary_salesrep_id, ct.org_id, ct.trx_date),

2971: NVL(
2972: ctls.revenue_salesgroup_id,
2973: DECODE(
2974: ctls.cust_trx_line_salesrep_id,
2975: null, arp_util.Get_Default_SalesGroup(ct.primary_salesrep_id, ct.org_id, ct.trx_date),
2976: null
2977: )
2978: ),
2979: ctls.non_revenue_percent_split,

Line 3011: arp_util.debug('arp_ctls_pkg.insert_f_ct_ctl_id()-');

3007: );
3008:
3009: END IF;
3010:
3011: arp_util.debug('arp_ctls_pkg.insert_f_ct_ctl_id()-');
3012:
3013: EXCEPTION
3014: WHEN OTHERS THEN
3015: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_f_ct_ctl_id()');

Line 3015: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_f_ct_ctl_id()');

3011: arp_util.debug('arp_ctls_pkg.insert_f_ct_ctl_id()-');
3012:
3013: EXCEPTION
3014: WHEN OTHERS THEN
3015: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_f_ct_ctl_id()');
3016: RAISE;
3017: END;
3018:
3019: /*===========================================================================+

Line 3031: | arp_util.debug |

3027: | |
3028: | SCOPE - PUBLIC |
3029: | |
3030: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3031: | arp_util.debug |
3032: | |
3033: | ARGUMENTS : IN: |
3034: | p_customer_trx_id |
3035: | p_customer_trx_line_id |

Line 3059: arp_util.debug('arp_ctls_pkg.insert_f_cm_ct_ctl_id()+');

3055: p_currency_code IN fnd_currencies.currency_code%type
3056: ) IS
3057: BEGIN
3058:
3059: arp_util.debug('arp_ctls_pkg.insert_f_cm_ct_ctl_id()+');
3060:
3061: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
3062: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
3063: arp_util.debug('p_currency_code = ' || p_currency_code);

Line 3061: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);

3057: BEGIN
3058:
3059: arp_util.debug('arp_ctls_pkg.insert_f_cm_ct_ctl_id()+');
3060:
3061: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
3062: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
3063: arp_util.debug('p_currency_code = ' || p_currency_code);
3064:
3065: INSERT INTO ra_cust_trx_line_salesreps

Line 3062: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);

3058:
3059: arp_util.debug('arp_ctls_pkg.insert_f_cm_ct_ctl_id()+');
3060:
3061: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
3062: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
3063: arp_util.debug('p_currency_code = ' || p_currency_code);
3064:
3065: INSERT INTO ra_cust_trx_line_salesreps
3066: (

Line 3063: arp_util.debug('p_currency_code = ' || p_currency_code);

3059: arp_util.debug('arp_ctls_pkg.insert_f_cm_ct_ctl_id()+');
3060:
3061: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
3062: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
3063: arp_util.debug('p_currency_code = ' || p_currency_code);
3064:
3065: INSERT INTO ra_cust_trx_line_salesreps
3066: (
3067: cust_trx_line_salesrep_id,

Line 3096: null, arp_util.Get_Default_SalesGroup(cm_ct.primary_salesrep_id, cm_ct.org_id, cm_ct.trx_date),

3092: ctl.customer_trx_id,
3093: ctl.customer_trx_line_id,
3094: nvl(prev_ctls.salesrep_id, cm_ct.primary_salesrep_id),
3095: decode(prev_ctls.cust_trx_line_salesrep_id,
3096: null, arp_util.Get_Default_SalesGroup(cm_ct.primary_salesrep_id, cm_ct.org_id, cm_ct.trx_date),
3097: prev_ctls.revenue_salesgroup_id),
3098: prev_ctls.non_revenue_salesgroup_id,
3099: prev_ctls.cust_trx_line_salesrep_id,
3100: decode(prev_ctls.cust_trx_line_salesrep_id,

Line 3129: arp_util.debug('arp_ctls_pkg.insert_f_cm_ct_ctl_id() : '||

3125: AND ctl.line_type = 'LINE'
3126: AND ctl.customer_trx_line_id = nvl(p_customer_trx_line_id,
3127: ctl.customer_trx_line_id);
3128:
3129: arp_util.debug('arp_ctls_pkg.insert_f_cm_ct_ctl_id() : '||
3130: SQL%ROWCOUNT||' rows inserted');
3131:
3132: arp_util.debug('arp_ctls_pkg.insert_f_cm_ct_ctl_id()-');
3133:

Line 3132: arp_util.debug('arp_ctls_pkg.insert_f_cm_ct_ctl_id()-');

3128:
3129: arp_util.debug('arp_ctls_pkg.insert_f_cm_ct_ctl_id() : '||
3130: SQL%ROWCOUNT||' rows inserted');
3131:
3132: arp_util.debug('arp_ctls_pkg.insert_f_cm_ct_ctl_id()-');
3133:
3134: EXCEPTION
3135: WHEN OTHERS THEN
3136: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_f_cm_ct_ctl_id()');

Line 3136: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_f_cm_ct_ctl_id()');

3132: arp_util.debug('arp_ctls_pkg.insert_f_cm_ct_ctl_id()-');
3133:
3134: EXCEPTION
3135: WHEN OTHERS THEN
3136: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_f_cm_ct_ctl_id()');
3137: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
3138: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
3139: arp_util.debug('p_currency_code = ' || p_currency_code);
3140:

Line 3137: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);

3133:
3134: EXCEPTION
3135: WHEN OTHERS THEN
3136: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_f_cm_ct_ctl_id()');
3137: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
3138: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
3139: arp_util.debug('p_currency_code = ' || p_currency_code);
3140:
3141: RAISE;

Line 3138: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);

3134: EXCEPTION
3135: WHEN OTHERS THEN
3136: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_f_cm_ct_ctl_id()');
3137: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
3138: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
3139: arp_util.debug('p_currency_code = ' || p_currency_code);
3140:
3141: RAISE;
3142: END;

Line 3139: arp_util.debug('p_currency_code = ' || p_currency_code);

3135: WHEN OTHERS THEN
3136: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_f_cm_ct_ctl_id()');
3137: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
3138: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
3139: arp_util.debug('p_currency_code = ' || p_currency_code);
3140:
3141: RAISE;
3142: END;
3143: /*===========================================================================+

Line 3155: | arp_util.debug |

3151: | |
3152: | SCOPE - PUBLIC |
3153: | |
3154: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3155: | arp_util.debug |
3156: | |
3157: | ARGUMENTS : IN: |
3158: | p_customer_trx_id |
3159: | p_customer_trx_line_id |

Line 3180: arp_util.debug('arp_ctls_pkg.insert_f_cmn_ct_ctl_id()+');

3176: ra_customer_trx_lines.customer_trx_line_id%type
3177: ) IS
3178: BEGIN
3179:
3180: arp_util.debug('arp_ctls_pkg.insert_f_cmn_ct_ctl_id()+');
3181:
3182: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
3183: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
3184:

Line 3182: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);

3178: BEGIN
3179:
3180: arp_util.debug('arp_ctls_pkg.insert_f_cmn_ct_ctl_id()+');
3181:
3182: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
3183: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
3184:
3185: INSERT INTO ra_cust_trx_line_salesreps
3186: (

Line 3183: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);

3179:
3180: arp_util.debug('arp_ctls_pkg.insert_f_cmn_ct_ctl_id()+');
3181:
3182: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
3183: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
3184:
3185: INSERT INTO ra_cust_trx_line_salesreps
3186: (
3187: cust_trx_line_salesrep_id,

Line 3219: null, arp_util.Get_Default_SalesGroup(cm_ct.primary_salesrep_id, cm_ct.org_id, cm_ct.trx_date),

3215: NVL(
3216: prev_ctls.revenue_salesgroup_id,
3217: DECODE(
3218: prev_ctls.cust_trx_line_salesrep_id,
3219: null, arp_util.Get_Default_SalesGroup(cm_ct.primary_salesrep_id, cm_ct.org_id, cm_ct.trx_date),
3220: null
3221: )
3222: ),
3223: prev_ctls.non_revenue_salesgroup_id,

Line 3266: arp_util.debug('arp_ctls_pkg.insert_f_cmn_ct_ctl_id() : '||

3262: AND ctl.line_type = 'LINE'
3263: AND ctl.customer_trx_line_id = nvl(p_customer_trx_line_id,
3264: ctl.customer_trx_line_id);
3265:
3266: arp_util.debug('arp_ctls_pkg.insert_f_cmn_ct_ctl_id() : '||
3267: SQL%ROWCOUNT||' rows inserted');
3268:
3269: arp_util.debug('arp_ctls_pkg.insert_f_cmn_ct_ctl_id()-');
3270:

Line 3269: arp_util.debug('arp_ctls_pkg.insert_f_cmn_ct_ctl_id()-');

3265:
3266: arp_util.debug('arp_ctls_pkg.insert_f_cmn_ct_ctl_id() : '||
3267: SQL%ROWCOUNT||' rows inserted');
3268:
3269: arp_util.debug('arp_ctls_pkg.insert_f_cmn_ct_ctl_id()-');
3270:
3271: EXCEPTION
3272: WHEN OTHERS THEN
3273: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_f_cmn_ct_ctl_id()');

Line 3273: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_f_cmn_ct_ctl_id()');

3269: arp_util.debug('arp_ctls_pkg.insert_f_cmn_ct_ctl_id()-');
3270:
3271: EXCEPTION
3272: WHEN OTHERS THEN
3273: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_f_cmn_ct_ctl_id()');
3274: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
3275: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
3276:
3277:

Line 3274: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);

3270:
3271: EXCEPTION
3272: WHEN OTHERS THEN
3273: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_f_cmn_ct_ctl_id()');
3274: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
3275: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
3276:
3277:
3278: RAISE;

Line 3275: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);

3271: EXCEPTION
3272: WHEN OTHERS THEN
3273: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_f_cmn_ct_ctl_id()');
3274: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
3275: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
3276:
3277:
3278: RAISE;
3279: END;

Line 3291: | arp_util.debug |

3287: | |
3288: | SCOPE - PUBLIC |
3289: | |
3290: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3291: | arp_util.debug |
3292: | |
3293: | ARGUMENTS : IN: |
3294: | p_cust_trx_line_salesrep_id |
3295: | p_customer_trx_id |

Line 3398: arp_util.debug('arp_ctls_pkg.lock_compare_cover()+');

3394: l_srep_rec ra_cust_trx_line_salesreps%rowtype;
3395:
3396: BEGIN
3397:
3398: arp_util.debug('arp_ctls_pkg.lock_compare_cover()+');
3399:
3400: /*------------------------------------------------+
3401: | Populate the salescredit record group with |
3402: | the values passed in as parameters. |

Line 3449: arp_util.debug('arp_ctls_pkg.lock_compare_cover()-');

3445: p_cust_trx_line_salesrep_id,
3446: TRUE -- ignore who columns
3447: );
3448:
3449: arp_util.debug('arp_ctls_pkg.lock_compare_cover()-');
3450:
3451: EXCEPTION
3452: WHEN OTHERS THEN
3453:

Line 3454: arp_util.debug(

3450:
3451: EXCEPTION
3452: WHEN OTHERS THEN
3453:
3454: arp_util.debug(
3455: 'EXCEPTION: arp_ctls_pkg.lock_compare_cover()');
3456:
3457: arp_util.debug('------- parameters for lock_compare_cover() ' ||
3458: '---------');

Line 3457: arp_util.debug('------- parameters for lock_compare_cover() ' ||

3453:
3454: arp_util.debug(
3455: 'EXCEPTION: arp_ctls_pkg.lock_compare_cover()');
3456:
3457: arp_util.debug('------- parameters for lock_compare_cover() ' ||
3458: '---------');
3459: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
3460: arp_util.debug('p_customer_trx_line_id = ' ||
3461: p_customer_trx_line_id );

Line 3459: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );

3455: 'EXCEPTION: arp_ctls_pkg.lock_compare_cover()');
3456:
3457: arp_util.debug('------- parameters for lock_compare_cover() ' ||
3458: '---------');
3459: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
3460: arp_util.debug('p_customer_trx_line_id = ' ||
3461: p_customer_trx_line_id );
3462: arp_util.debug('p_salesrep_id = ' ||
3463: p_salesrep_id );

Line 3460: arp_util.debug('p_customer_trx_line_id = ' ||

3456:
3457: arp_util.debug('------- parameters for lock_compare_cover() ' ||
3458: '---------');
3459: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
3460: arp_util.debug('p_customer_trx_line_id = ' ||
3461: p_customer_trx_line_id );
3462: arp_util.debug('p_salesrep_id = ' ||
3463: p_salesrep_id );
3464: arp_util.debug('p_revenue_amount_split = ' ||

Line 3462: arp_util.debug('p_salesrep_id = ' ||

3458: '---------');
3459: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
3460: arp_util.debug('p_customer_trx_line_id = ' ||
3461: p_customer_trx_line_id );
3462: arp_util.debug('p_salesrep_id = ' ||
3463: p_salesrep_id );
3464: arp_util.debug('p_revenue_amount_split = ' ||
3465: p_revenue_amount_split );
3466: arp_util.debug('p_non_revenue_amount_split = ' ||

Line 3464: arp_util.debug('p_revenue_amount_split = ' ||

3460: arp_util.debug('p_customer_trx_line_id = ' ||
3461: p_customer_trx_line_id );
3462: arp_util.debug('p_salesrep_id = ' ||
3463: p_salesrep_id );
3464: arp_util.debug('p_revenue_amount_split = ' ||
3465: p_revenue_amount_split );
3466: arp_util.debug('p_non_revenue_amount_split = ' ||
3467: p_non_revenue_amount_split );
3468: arp_util.debug('p_non_revenue_percent_split = ' ||

Line 3466: arp_util.debug('p_non_revenue_amount_split = ' ||

3462: arp_util.debug('p_salesrep_id = ' ||
3463: p_salesrep_id );
3464: arp_util.debug('p_revenue_amount_split = ' ||
3465: p_revenue_amount_split );
3466: arp_util.debug('p_non_revenue_amount_split = ' ||
3467: p_non_revenue_amount_split );
3468: arp_util.debug('p_non_revenue_percent_split = ' ||
3469: p_non_revenue_percent_split );
3470: arp_util.debug('p_revenue_percent_split = ' ||

Line 3468: arp_util.debug('p_non_revenue_percent_split = ' ||

3464: arp_util.debug('p_revenue_amount_split = ' ||
3465: p_revenue_amount_split );
3466: arp_util.debug('p_non_revenue_amount_split = ' ||
3467: p_non_revenue_amount_split );
3468: arp_util.debug('p_non_revenue_percent_split = ' ||
3469: p_non_revenue_percent_split );
3470: arp_util.debug('p_revenue_percent_split = ' ||
3471: p_revenue_percent_split );
3472: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||

Line 3470: arp_util.debug('p_revenue_percent_split = ' ||

3466: arp_util.debug('p_non_revenue_amount_split = ' ||
3467: p_non_revenue_amount_split );
3468: arp_util.debug('p_non_revenue_percent_split = ' ||
3469: p_non_revenue_percent_split );
3470: arp_util.debug('p_revenue_percent_split = ' ||
3471: p_revenue_percent_split );
3472: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||
3473: p_prev_cust_trx_line_srep_id );
3474: arp_util.debug('p_attribute_category = ' ||

Line 3472: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||

3468: arp_util.debug('p_non_revenue_percent_split = ' ||
3469: p_non_revenue_percent_split );
3470: arp_util.debug('p_revenue_percent_split = ' ||
3471: p_revenue_percent_split );
3472: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||
3473: p_prev_cust_trx_line_srep_id );
3474: arp_util.debug('p_attribute_category = ' ||
3475: p_attribute_category );
3476: arp_util.debug('p_attribute1 = ' || p_attribute1 );

Line 3474: arp_util.debug('p_attribute_category = ' ||

3470: arp_util.debug('p_revenue_percent_split = ' ||
3471: p_revenue_percent_split );
3472: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||
3473: p_prev_cust_trx_line_srep_id );
3474: arp_util.debug('p_attribute_category = ' ||
3475: p_attribute_category );
3476: arp_util.debug('p_attribute1 = ' || p_attribute1 );
3477: arp_util.debug('p_attribute2 = ' || p_attribute2 );
3478: arp_util.debug('p_attribute3 = ' || p_attribute3 );

Line 3476: arp_util.debug('p_attribute1 = ' || p_attribute1 );

3472: arp_util.debug('p_prev_cust_trx_line_srep_id = ' ||
3473: p_prev_cust_trx_line_srep_id );
3474: arp_util.debug('p_attribute_category = ' ||
3475: p_attribute_category );
3476: arp_util.debug('p_attribute1 = ' || p_attribute1 );
3477: arp_util.debug('p_attribute2 = ' || p_attribute2 );
3478: arp_util.debug('p_attribute3 = ' || p_attribute3 );
3479: arp_util.debug('p_attribute4 = ' || p_attribute4 );
3480: arp_util.debug('p_attribute5 = ' || p_attribute5 );

Line 3477: arp_util.debug('p_attribute2 = ' || p_attribute2 );

3473: p_prev_cust_trx_line_srep_id );
3474: arp_util.debug('p_attribute_category = ' ||
3475: p_attribute_category );
3476: arp_util.debug('p_attribute1 = ' || p_attribute1 );
3477: arp_util.debug('p_attribute2 = ' || p_attribute2 );
3478: arp_util.debug('p_attribute3 = ' || p_attribute3 );
3479: arp_util.debug('p_attribute4 = ' || p_attribute4 );
3480: arp_util.debug('p_attribute5 = ' || p_attribute5 );
3481: arp_util.debug('p_attribute6 = ' || p_attribute6 );

Line 3478: arp_util.debug('p_attribute3 = ' || p_attribute3 );

3474: arp_util.debug('p_attribute_category = ' ||
3475: p_attribute_category );
3476: arp_util.debug('p_attribute1 = ' || p_attribute1 );
3477: arp_util.debug('p_attribute2 = ' || p_attribute2 );
3478: arp_util.debug('p_attribute3 = ' || p_attribute3 );
3479: arp_util.debug('p_attribute4 = ' || p_attribute4 );
3480: arp_util.debug('p_attribute5 = ' || p_attribute5 );
3481: arp_util.debug('p_attribute6 = ' || p_attribute6 );
3482: arp_util.debug('p_attribute7 = ' || p_attribute7 );

Line 3479: arp_util.debug('p_attribute4 = ' || p_attribute4 );

3475: p_attribute_category );
3476: arp_util.debug('p_attribute1 = ' || p_attribute1 );
3477: arp_util.debug('p_attribute2 = ' || p_attribute2 );
3478: arp_util.debug('p_attribute3 = ' || p_attribute3 );
3479: arp_util.debug('p_attribute4 = ' || p_attribute4 );
3480: arp_util.debug('p_attribute5 = ' || p_attribute5 );
3481: arp_util.debug('p_attribute6 = ' || p_attribute6 );
3482: arp_util.debug('p_attribute7 = ' || p_attribute7 );
3483: arp_util.debug('p_attribute8 = ' || p_attribute8 );

Line 3480: arp_util.debug('p_attribute5 = ' || p_attribute5 );

3476: arp_util.debug('p_attribute1 = ' || p_attribute1 );
3477: arp_util.debug('p_attribute2 = ' || p_attribute2 );
3478: arp_util.debug('p_attribute3 = ' || p_attribute3 );
3479: arp_util.debug('p_attribute4 = ' || p_attribute4 );
3480: arp_util.debug('p_attribute5 = ' || p_attribute5 );
3481: arp_util.debug('p_attribute6 = ' || p_attribute6 );
3482: arp_util.debug('p_attribute7 = ' || p_attribute7 );
3483: arp_util.debug('p_attribute8 = ' || p_attribute8 );
3484: arp_util.debug('p_attribute9 = ' || p_attribute9 );

Line 3481: arp_util.debug('p_attribute6 = ' || p_attribute6 );

3477: arp_util.debug('p_attribute2 = ' || p_attribute2 );
3478: arp_util.debug('p_attribute3 = ' || p_attribute3 );
3479: arp_util.debug('p_attribute4 = ' || p_attribute4 );
3480: arp_util.debug('p_attribute5 = ' || p_attribute5 );
3481: arp_util.debug('p_attribute6 = ' || p_attribute6 );
3482: arp_util.debug('p_attribute7 = ' || p_attribute7 );
3483: arp_util.debug('p_attribute8 = ' || p_attribute8 );
3484: arp_util.debug('p_attribute9 = ' || p_attribute9 );
3485: arp_util.debug('p_attribute10 = ' || p_attribute10 );

Line 3482: arp_util.debug('p_attribute7 = ' || p_attribute7 );

3478: arp_util.debug('p_attribute3 = ' || p_attribute3 );
3479: arp_util.debug('p_attribute4 = ' || p_attribute4 );
3480: arp_util.debug('p_attribute5 = ' || p_attribute5 );
3481: arp_util.debug('p_attribute6 = ' || p_attribute6 );
3482: arp_util.debug('p_attribute7 = ' || p_attribute7 );
3483: arp_util.debug('p_attribute8 = ' || p_attribute8 );
3484: arp_util.debug('p_attribute9 = ' || p_attribute9 );
3485: arp_util.debug('p_attribute10 = ' || p_attribute10 );
3486: arp_util.debug('p_attribute11 = ' || p_attribute11 );

Line 3483: arp_util.debug('p_attribute8 = ' || p_attribute8 );

3479: arp_util.debug('p_attribute4 = ' || p_attribute4 );
3480: arp_util.debug('p_attribute5 = ' || p_attribute5 );
3481: arp_util.debug('p_attribute6 = ' || p_attribute6 );
3482: arp_util.debug('p_attribute7 = ' || p_attribute7 );
3483: arp_util.debug('p_attribute8 = ' || p_attribute8 );
3484: arp_util.debug('p_attribute9 = ' || p_attribute9 );
3485: arp_util.debug('p_attribute10 = ' || p_attribute10 );
3486: arp_util.debug('p_attribute11 = ' || p_attribute11 );
3487: arp_util.debug('p_attribute12 = ' || p_attribute12 );

Line 3484: arp_util.debug('p_attribute9 = ' || p_attribute9 );

3480: arp_util.debug('p_attribute5 = ' || p_attribute5 );
3481: arp_util.debug('p_attribute6 = ' || p_attribute6 );
3482: arp_util.debug('p_attribute7 = ' || p_attribute7 );
3483: arp_util.debug('p_attribute8 = ' || p_attribute8 );
3484: arp_util.debug('p_attribute9 = ' || p_attribute9 );
3485: arp_util.debug('p_attribute10 = ' || p_attribute10 );
3486: arp_util.debug('p_attribute11 = ' || p_attribute11 );
3487: arp_util.debug('p_attribute12 = ' || p_attribute12 );
3488: arp_util.debug('p_attribute13 = ' || p_attribute13 );

Line 3485: arp_util.debug('p_attribute10 = ' || p_attribute10 );

3481: arp_util.debug('p_attribute6 = ' || p_attribute6 );
3482: arp_util.debug('p_attribute7 = ' || p_attribute7 );
3483: arp_util.debug('p_attribute8 = ' || p_attribute8 );
3484: arp_util.debug('p_attribute9 = ' || p_attribute9 );
3485: arp_util.debug('p_attribute10 = ' || p_attribute10 );
3486: arp_util.debug('p_attribute11 = ' || p_attribute11 );
3487: arp_util.debug('p_attribute12 = ' || p_attribute12 );
3488: arp_util.debug('p_attribute13 = ' || p_attribute13 );
3489: arp_util.debug('p_attribute14 = ' || p_attribute14 );

Line 3486: arp_util.debug('p_attribute11 = ' || p_attribute11 );

3482: arp_util.debug('p_attribute7 = ' || p_attribute7 );
3483: arp_util.debug('p_attribute8 = ' || p_attribute8 );
3484: arp_util.debug('p_attribute9 = ' || p_attribute9 );
3485: arp_util.debug('p_attribute10 = ' || p_attribute10 );
3486: arp_util.debug('p_attribute11 = ' || p_attribute11 );
3487: arp_util.debug('p_attribute12 = ' || p_attribute12 );
3488: arp_util.debug('p_attribute13 = ' || p_attribute13 );
3489: arp_util.debug('p_attribute14 = ' || p_attribute14 );
3490: arp_util.debug('p_attribute15 = ' || p_attribute15 );

Line 3487: arp_util.debug('p_attribute12 = ' || p_attribute12 );

3483: arp_util.debug('p_attribute8 = ' || p_attribute8 );
3484: arp_util.debug('p_attribute9 = ' || p_attribute9 );
3485: arp_util.debug('p_attribute10 = ' || p_attribute10 );
3486: arp_util.debug('p_attribute11 = ' || p_attribute11 );
3487: arp_util.debug('p_attribute12 = ' || p_attribute12 );
3488: arp_util.debug('p_attribute13 = ' || p_attribute13 );
3489: arp_util.debug('p_attribute14 = ' || p_attribute14 );
3490: arp_util.debug('p_attribute15 = ' || p_attribute15 );
3491: /* BEGIN bug 3067675 */

Line 3488: arp_util.debug('p_attribute13 = ' || p_attribute13 );

3484: arp_util.debug('p_attribute9 = ' || p_attribute9 );
3485: arp_util.debug('p_attribute10 = ' || p_attribute10 );
3486: arp_util.debug('p_attribute11 = ' || p_attribute11 );
3487: arp_util.debug('p_attribute12 = ' || p_attribute12 );
3488: arp_util.debug('p_attribute13 = ' || p_attribute13 );
3489: arp_util.debug('p_attribute14 = ' || p_attribute14 );
3490: arp_util.debug('p_attribute15 = ' || p_attribute15 );
3491: /* BEGIN bug 3067675 */
3492: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );

Line 3489: arp_util.debug('p_attribute14 = ' || p_attribute14 );

3485: arp_util.debug('p_attribute10 = ' || p_attribute10 );
3486: arp_util.debug('p_attribute11 = ' || p_attribute11 );
3487: arp_util.debug('p_attribute12 = ' || p_attribute12 );
3488: arp_util.debug('p_attribute13 = ' || p_attribute13 );
3489: arp_util.debug('p_attribute14 = ' || p_attribute14 );
3490: arp_util.debug('p_attribute15 = ' || p_attribute15 );
3491: /* BEGIN bug 3067675 */
3492: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );
3493: arp_util.debug('p_non_revenue_salesgroup_id = ' || p_non_revenue_salesgroup_id );

Line 3490: arp_util.debug('p_attribute15 = ' || p_attribute15 );

3486: arp_util.debug('p_attribute11 = ' || p_attribute11 );
3487: arp_util.debug('p_attribute12 = ' || p_attribute12 );
3488: arp_util.debug('p_attribute13 = ' || p_attribute13 );
3489: arp_util.debug('p_attribute14 = ' || p_attribute14 );
3490: arp_util.debug('p_attribute15 = ' || p_attribute15 );
3491: /* BEGIN bug 3067675 */
3492: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );
3493: arp_util.debug('p_non_revenue_salesgroup_id = ' || p_non_revenue_salesgroup_id );
3494: /* END bug 3067675 */

Line 3492: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );

3488: arp_util.debug('p_attribute13 = ' || p_attribute13 );
3489: arp_util.debug('p_attribute14 = ' || p_attribute14 );
3490: arp_util.debug('p_attribute15 = ' || p_attribute15 );
3491: /* BEGIN bug 3067675 */
3492: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );
3493: arp_util.debug('p_non_revenue_salesgroup_id = ' || p_non_revenue_salesgroup_id );
3494: /* END bug 3067675 */
3495:
3496: RAISE;

Line 3493: arp_util.debug('p_non_revenue_salesgroup_id = ' || p_non_revenue_salesgroup_id );

3489: arp_util.debug('p_attribute14 = ' || p_attribute14 );
3490: arp_util.debug('p_attribute15 = ' || p_attribute15 );
3491: /* BEGIN bug 3067675 */
3492: arp_util.debug('p_revenue_salesgroup_id = ' || p_revenue_salesgroup_id );
3493: arp_util.debug('p_non_revenue_salesgroup_id = ' || p_non_revenue_salesgroup_id );
3494: /* END bug 3067675 */
3495:
3496: RAISE;
3497: