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_DISTRIBUTIONS_PKG dependencies on ARP_STANDARD

Line 14: arp_standard.debug( 'arp_distributions_pkg.insert_p()+' );

10: exp_null_insert exception;
11: pragma exception_init(exp_null_insert, -1400);
12: BEGIN
13: IF PG_DEBUG in ('Y', 'C') THEN
14: arp_standard.debug( 'arp_distributions_pkg.insert_p()+' );
15: END IF;
16: --
17: SELECT ar_distributions_s.nextval
18: INTO l_line_id

Line 22: arp_standard.debug( 'LINE ID '|| l_line_id);

18: INTO l_line_id
19: FROM dual;
20: --
21: IF PG_DEBUG in ('Y', 'C') THEN
22: arp_standard.debug( 'LINE ID '|| l_line_id);
23: arp_standard.debug( 'SOURCE_ID ' || p_dist_rec.SOURCE_ID);
24: arp_standard.debug( 'SOURCE_TABLE ' || p_dist_rec.SOURCE_TABLE);
25: arp_standard.debug( 'SOURCE_TYPE ' || p_dist_rec.SOURCE_TYPE);
26: arp_standard.debug( 'SOURCE_TYPE_SECONDARY ' || p_dist_rec.SOURCE_TYPE_SECONDARY);

Line 23: arp_standard.debug( 'SOURCE_ID ' || p_dist_rec.SOURCE_ID);

19: FROM dual;
20: --
21: IF PG_DEBUG in ('Y', 'C') THEN
22: arp_standard.debug( 'LINE ID '|| l_line_id);
23: arp_standard.debug( 'SOURCE_ID ' || p_dist_rec.SOURCE_ID);
24: arp_standard.debug( 'SOURCE_TABLE ' || p_dist_rec.SOURCE_TABLE);
25: arp_standard.debug( 'SOURCE_TYPE ' || p_dist_rec.SOURCE_TYPE);
26: arp_standard.debug( 'SOURCE_TYPE_SECONDARY ' || p_dist_rec.SOURCE_TYPE_SECONDARY);
27: arp_standard.debug( 'CODE_COMBINATION_ID '||p_dist_rec.CODE_COMBINATION_ID);

Line 24: arp_standard.debug( 'SOURCE_TABLE ' || p_dist_rec.SOURCE_TABLE);

20: --
21: IF PG_DEBUG in ('Y', 'C') THEN
22: arp_standard.debug( 'LINE ID '|| l_line_id);
23: arp_standard.debug( 'SOURCE_ID ' || p_dist_rec.SOURCE_ID);
24: arp_standard.debug( 'SOURCE_TABLE ' || p_dist_rec.SOURCE_TABLE);
25: arp_standard.debug( 'SOURCE_TYPE ' || p_dist_rec.SOURCE_TYPE);
26: arp_standard.debug( 'SOURCE_TYPE_SECONDARY ' || p_dist_rec.SOURCE_TYPE_SECONDARY);
27: arp_standard.debug( 'CODE_COMBINATION_ID '||p_dist_rec.CODE_COMBINATION_ID);
28: arp_standard.debug( 'AMOUNT_DR ' || p_dist_rec.AMOUNT_DR);

Line 25: arp_standard.debug( 'SOURCE_TYPE ' || p_dist_rec.SOURCE_TYPE);

21: IF PG_DEBUG in ('Y', 'C') THEN
22: arp_standard.debug( 'LINE ID '|| l_line_id);
23: arp_standard.debug( 'SOURCE_ID ' || p_dist_rec.SOURCE_ID);
24: arp_standard.debug( 'SOURCE_TABLE ' || p_dist_rec.SOURCE_TABLE);
25: arp_standard.debug( 'SOURCE_TYPE ' || p_dist_rec.SOURCE_TYPE);
26: arp_standard.debug( 'SOURCE_TYPE_SECONDARY ' || p_dist_rec.SOURCE_TYPE_SECONDARY);
27: arp_standard.debug( 'CODE_COMBINATION_ID '||p_dist_rec.CODE_COMBINATION_ID);
28: arp_standard.debug( 'AMOUNT_DR ' || p_dist_rec.AMOUNT_DR);
29: arp_standard.debug( 'AMOUNT_CR ' || p_dist_rec.AMOUNT_CR);

Line 26: arp_standard.debug( 'SOURCE_TYPE_SECONDARY ' || p_dist_rec.SOURCE_TYPE_SECONDARY);

22: arp_standard.debug( 'LINE ID '|| l_line_id);
23: arp_standard.debug( 'SOURCE_ID ' || p_dist_rec.SOURCE_ID);
24: arp_standard.debug( 'SOURCE_TABLE ' || p_dist_rec.SOURCE_TABLE);
25: arp_standard.debug( 'SOURCE_TYPE ' || p_dist_rec.SOURCE_TYPE);
26: arp_standard.debug( 'SOURCE_TYPE_SECONDARY ' || p_dist_rec.SOURCE_TYPE_SECONDARY);
27: arp_standard.debug( 'CODE_COMBINATION_ID '||p_dist_rec.CODE_COMBINATION_ID);
28: arp_standard.debug( 'AMOUNT_DR ' || p_dist_rec.AMOUNT_DR);
29: arp_standard.debug( 'AMOUNT_CR ' || p_dist_rec.AMOUNT_CR);
30: arp_standard.debug( 'ACCTD_AMOUNT_DR ' || p_dist_rec.ACCTD_AMOUNT_DR);

Line 27: arp_standard.debug( 'CODE_COMBINATION_ID '||p_dist_rec.CODE_COMBINATION_ID);

23: arp_standard.debug( 'SOURCE_ID ' || p_dist_rec.SOURCE_ID);
24: arp_standard.debug( 'SOURCE_TABLE ' || p_dist_rec.SOURCE_TABLE);
25: arp_standard.debug( 'SOURCE_TYPE ' || p_dist_rec.SOURCE_TYPE);
26: arp_standard.debug( 'SOURCE_TYPE_SECONDARY ' || p_dist_rec.SOURCE_TYPE_SECONDARY);
27: arp_standard.debug( 'CODE_COMBINATION_ID '||p_dist_rec.CODE_COMBINATION_ID);
28: arp_standard.debug( 'AMOUNT_DR ' || p_dist_rec.AMOUNT_DR);
29: arp_standard.debug( 'AMOUNT_CR ' || p_dist_rec.AMOUNT_CR);
30: arp_standard.debug( 'ACCTD_AMOUNT_DR ' || p_dist_rec.ACCTD_AMOUNT_DR);
31: arp_standard.debug( 'ACCTD_AMOUNT_CR ' ||p_dist_rec.ACCTD_AMOUNT_CR);

Line 28: arp_standard.debug( 'AMOUNT_DR ' || p_dist_rec.AMOUNT_DR);

24: arp_standard.debug( 'SOURCE_TABLE ' || p_dist_rec.SOURCE_TABLE);
25: arp_standard.debug( 'SOURCE_TYPE ' || p_dist_rec.SOURCE_TYPE);
26: arp_standard.debug( 'SOURCE_TYPE_SECONDARY ' || p_dist_rec.SOURCE_TYPE_SECONDARY);
27: arp_standard.debug( 'CODE_COMBINATION_ID '||p_dist_rec.CODE_COMBINATION_ID);
28: arp_standard.debug( 'AMOUNT_DR ' || p_dist_rec.AMOUNT_DR);
29: arp_standard.debug( 'AMOUNT_CR ' || p_dist_rec.AMOUNT_CR);
30: arp_standard.debug( 'ACCTD_AMOUNT_DR ' || p_dist_rec.ACCTD_AMOUNT_DR);
31: arp_standard.debug( 'ACCTD_AMOUNT_CR ' ||p_dist_rec.ACCTD_AMOUNT_CR);
32: arp_standard.debug( 'SOURCE_TABLE_SECONDARY ' || p_dist_rec.SOURCE_TABLE_SECONDARY);

Line 29: arp_standard.debug( 'AMOUNT_CR ' || p_dist_rec.AMOUNT_CR);

25: arp_standard.debug( 'SOURCE_TYPE ' || p_dist_rec.SOURCE_TYPE);
26: arp_standard.debug( 'SOURCE_TYPE_SECONDARY ' || p_dist_rec.SOURCE_TYPE_SECONDARY);
27: arp_standard.debug( 'CODE_COMBINATION_ID '||p_dist_rec.CODE_COMBINATION_ID);
28: arp_standard.debug( 'AMOUNT_DR ' || p_dist_rec.AMOUNT_DR);
29: arp_standard.debug( 'AMOUNT_CR ' || p_dist_rec.AMOUNT_CR);
30: arp_standard.debug( 'ACCTD_AMOUNT_DR ' || p_dist_rec.ACCTD_AMOUNT_DR);
31: arp_standard.debug( 'ACCTD_AMOUNT_CR ' ||p_dist_rec.ACCTD_AMOUNT_CR);
32: arp_standard.debug( 'SOURCE_TABLE_SECONDARY ' || p_dist_rec.SOURCE_TABLE_SECONDARY);
33: arp_standard.debug( 'SOURCE_ID_SECONDARY ' || p_dist_rec.SOURCE_ID_SECONDARY);

Line 30: arp_standard.debug( 'ACCTD_AMOUNT_DR ' || p_dist_rec.ACCTD_AMOUNT_DR);

26: arp_standard.debug( 'SOURCE_TYPE_SECONDARY ' || p_dist_rec.SOURCE_TYPE_SECONDARY);
27: arp_standard.debug( 'CODE_COMBINATION_ID '||p_dist_rec.CODE_COMBINATION_ID);
28: arp_standard.debug( 'AMOUNT_DR ' || p_dist_rec.AMOUNT_DR);
29: arp_standard.debug( 'AMOUNT_CR ' || p_dist_rec.AMOUNT_CR);
30: arp_standard.debug( 'ACCTD_AMOUNT_DR ' || p_dist_rec.ACCTD_AMOUNT_DR);
31: arp_standard.debug( 'ACCTD_AMOUNT_CR ' ||p_dist_rec.ACCTD_AMOUNT_CR);
32: arp_standard.debug( 'SOURCE_TABLE_SECONDARY ' || p_dist_rec.SOURCE_TABLE_SECONDARY);
33: arp_standard.debug( 'SOURCE_ID_SECONDARY ' || p_dist_rec.SOURCE_ID_SECONDARY);
34: arp_standard.debug( 'CURRENCY_CODE ' || p_dist_rec.CURRENCY_CODE);

Line 31: arp_standard.debug( 'ACCTD_AMOUNT_CR ' ||p_dist_rec.ACCTD_AMOUNT_CR);

27: arp_standard.debug( 'CODE_COMBINATION_ID '||p_dist_rec.CODE_COMBINATION_ID);
28: arp_standard.debug( 'AMOUNT_DR ' || p_dist_rec.AMOUNT_DR);
29: arp_standard.debug( 'AMOUNT_CR ' || p_dist_rec.AMOUNT_CR);
30: arp_standard.debug( 'ACCTD_AMOUNT_DR ' || p_dist_rec.ACCTD_AMOUNT_DR);
31: arp_standard.debug( 'ACCTD_AMOUNT_CR ' ||p_dist_rec.ACCTD_AMOUNT_CR);
32: arp_standard.debug( 'SOURCE_TABLE_SECONDARY ' || p_dist_rec.SOURCE_TABLE_SECONDARY);
33: arp_standard.debug( 'SOURCE_ID_SECONDARY ' || p_dist_rec.SOURCE_ID_SECONDARY);
34: arp_standard.debug( 'CURRENCY_CODE ' || p_dist_rec.CURRENCY_CODE);
35: arp_standard.debug( 'CURRENCY_CONVERSION_RATE ' || p_dist_rec.CURRENCY_CONVERSION_RATE);

Line 32: arp_standard.debug( 'SOURCE_TABLE_SECONDARY ' || p_dist_rec.SOURCE_TABLE_SECONDARY);

28: arp_standard.debug( 'AMOUNT_DR ' || p_dist_rec.AMOUNT_DR);
29: arp_standard.debug( 'AMOUNT_CR ' || p_dist_rec.AMOUNT_CR);
30: arp_standard.debug( 'ACCTD_AMOUNT_DR ' || p_dist_rec.ACCTD_AMOUNT_DR);
31: arp_standard.debug( 'ACCTD_AMOUNT_CR ' ||p_dist_rec.ACCTD_AMOUNT_CR);
32: arp_standard.debug( 'SOURCE_TABLE_SECONDARY ' || p_dist_rec.SOURCE_TABLE_SECONDARY);
33: arp_standard.debug( 'SOURCE_ID_SECONDARY ' || p_dist_rec.SOURCE_ID_SECONDARY);
34: arp_standard.debug( 'CURRENCY_CODE ' || p_dist_rec.CURRENCY_CODE);
35: arp_standard.debug( 'CURRENCY_CONVERSION_RATE ' || p_dist_rec.CURRENCY_CONVERSION_RATE);
36: arp_standard.debug( 'CURRENCY_CONVERSION_TYPE ' || p_dist_rec.CURRENCY_CONVERSION_TYPE);

Line 33: arp_standard.debug( 'SOURCE_ID_SECONDARY ' || p_dist_rec.SOURCE_ID_SECONDARY);

29: arp_standard.debug( 'AMOUNT_CR ' || p_dist_rec.AMOUNT_CR);
30: arp_standard.debug( 'ACCTD_AMOUNT_DR ' || p_dist_rec.ACCTD_AMOUNT_DR);
31: arp_standard.debug( 'ACCTD_AMOUNT_CR ' ||p_dist_rec.ACCTD_AMOUNT_CR);
32: arp_standard.debug( 'SOURCE_TABLE_SECONDARY ' || p_dist_rec.SOURCE_TABLE_SECONDARY);
33: arp_standard.debug( 'SOURCE_ID_SECONDARY ' || p_dist_rec.SOURCE_ID_SECONDARY);
34: arp_standard.debug( 'CURRENCY_CODE ' || p_dist_rec.CURRENCY_CODE);
35: arp_standard.debug( 'CURRENCY_CONVERSION_RATE ' || p_dist_rec.CURRENCY_CONVERSION_RATE);
36: arp_standard.debug( 'CURRENCY_CONVERSION_TYPE ' || p_dist_rec.CURRENCY_CONVERSION_TYPE);
37: arp_standard.debug( 'CURRENCY_CONVERSION_DATE ' || p_dist_rec.CURRENCY_CONVERSION_DATE);

Line 34: arp_standard.debug( 'CURRENCY_CODE ' || p_dist_rec.CURRENCY_CODE);

30: arp_standard.debug( 'ACCTD_AMOUNT_DR ' || p_dist_rec.ACCTD_AMOUNT_DR);
31: arp_standard.debug( 'ACCTD_AMOUNT_CR ' ||p_dist_rec.ACCTD_AMOUNT_CR);
32: arp_standard.debug( 'SOURCE_TABLE_SECONDARY ' || p_dist_rec.SOURCE_TABLE_SECONDARY);
33: arp_standard.debug( 'SOURCE_ID_SECONDARY ' || p_dist_rec.SOURCE_ID_SECONDARY);
34: arp_standard.debug( 'CURRENCY_CODE ' || p_dist_rec.CURRENCY_CODE);
35: arp_standard.debug( 'CURRENCY_CONVERSION_RATE ' || p_dist_rec.CURRENCY_CONVERSION_RATE);
36: arp_standard.debug( 'CURRENCY_CONVERSION_TYPE ' || p_dist_rec.CURRENCY_CONVERSION_TYPE);
37: arp_standard.debug( 'CURRENCY_CONVERSION_DATE ' || p_dist_rec.CURRENCY_CONVERSION_DATE);
38: arp_standard.debug( 'TAXABLE_ENTERED_DR ' || p_dist_rec.TAXABLE_ENTERED_DR);

Line 35: arp_standard.debug( 'CURRENCY_CONVERSION_RATE ' || p_dist_rec.CURRENCY_CONVERSION_RATE);

31: arp_standard.debug( 'ACCTD_AMOUNT_CR ' ||p_dist_rec.ACCTD_AMOUNT_CR);
32: arp_standard.debug( 'SOURCE_TABLE_SECONDARY ' || p_dist_rec.SOURCE_TABLE_SECONDARY);
33: arp_standard.debug( 'SOURCE_ID_SECONDARY ' || p_dist_rec.SOURCE_ID_SECONDARY);
34: arp_standard.debug( 'CURRENCY_CODE ' || p_dist_rec.CURRENCY_CODE);
35: arp_standard.debug( 'CURRENCY_CONVERSION_RATE ' || p_dist_rec.CURRENCY_CONVERSION_RATE);
36: arp_standard.debug( 'CURRENCY_CONVERSION_TYPE ' || p_dist_rec.CURRENCY_CONVERSION_TYPE);
37: arp_standard.debug( 'CURRENCY_CONVERSION_DATE ' || p_dist_rec.CURRENCY_CONVERSION_DATE);
38: arp_standard.debug( 'TAXABLE_ENTERED_DR ' || p_dist_rec.TAXABLE_ENTERED_DR);
39: arp_standard.debug( 'TAXABLE_ENTERED_CR ' || p_dist_rec.TAXABLE_ENTERED_CR);

Line 36: arp_standard.debug( 'CURRENCY_CONVERSION_TYPE ' || p_dist_rec.CURRENCY_CONVERSION_TYPE);

32: arp_standard.debug( 'SOURCE_TABLE_SECONDARY ' || p_dist_rec.SOURCE_TABLE_SECONDARY);
33: arp_standard.debug( 'SOURCE_ID_SECONDARY ' || p_dist_rec.SOURCE_ID_SECONDARY);
34: arp_standard.debug( 'CURRENCY_CODE ' || p_dist_rec.CURRENCY_CODE);
35: arp_standard.debug( 'CURRENCY_CONVERSION_RATE ' || p_dist_rec.CURRENCY_CONVERSION_RATE);
36: arp_standard.debug( 'CURRENCY_CONVERSION_TYPE ' || p_dist_rec.CURRENCY_CONVERSION_TYPE);
37: arp_standard.debug( 'CURRENCY_CONVERSION_DATE ' || p_dist_rec.CURRENCY_CONVERSION_DATE);
38: arp_standard.debug( 'TAXABLE_ENTERED_DR ' || p_dist_rec.TAXABLE_ENTERED_DR);
39: arp_standard.debug( 'TAXABLE_ENTERED_CR ' || p_dist_rec.TAXABLE_ENTERED_CR);
40: arp_standard.debug( 'TAXABLE_ACCOUNTED_DR ' || p_dist_rec.TAXABLE_ACCOUNTED_DR);

Line 37: arp_standard.debug( 'CURRENCY_CONVERSION_DATE ' || p_dist_rec.CURRENCY_CONVERSION_DATE);

33: arp_standard.debug( 'SOURCE_ID_SECONDARY ' || p_dist_rec.SOURCE_ID_SECONDARY);
34: arp_standard.debug( 'CURRENCY_CODE ' || p_dist_rec.CURRENCY_CODE);
35: arp_standard.debug( 'CURRENCY_CONVERSION_RATE ' || p_dist_rec.CURRENCY_CONVERSION_RATE);
36: arp_standard.debug( 'CURRENCY_CONVERSION_TYPE ' || p_dist_rec.CURRENCY_CONVERSION_TYPE);
37: arp_standard.debug( 'CURRENCY_CONVERSION_DATE ' || p_dist_rec.CURRENCY_CONVERSION_DATE);
38: arp_standard.debug( 'TAXABLE_ENTERED_DR ' || p_dist_rec.TAXABLE_ENTERED_DR);
39: arp_standard.debug( 'TAXABLE_ENTERED_CR ' || p_dist_rec.TAXABLE_ENTERED_CR);
40: arp_standard.debug( 'TAXABLE_ACCOUNTED_DR ' || p_dist_rec.TAXABLE_ACCOUNTED_DR);
41: arp_standard.debug( 'TAXABLE_ACCOUNTED_CR ' || p_dist_rec.TAXABLE_ACCOUNTED_CR);

Line 38: arp_standard.debug( 'TAXABLE_ENTERED_DR ' || p_dist_rec.TAXABLE_ENTERED_DR);

34: arp_standard.debug( 'CURRENCY_CODE ' || p_dist_rec.CURRENCY_CODE);
35: arp_standard.debug( 'CURRENCY_CONVERSION_RATE ' || p_dist_rec.CURRENCY_CONVERSION_RATE);
36: arp_standard.debug( 'CURRENCY_CONVERSION_TYPE ' || p_dist_rec.CURRENCY_CONVERSION_TYPE);
37: arp_standard.debug( 'CURRENCY_CONVERSION_DATE ' || p_dist_rec.CURRENCY_CONVERSION_DATE);
38: arp_standard.debug( 'TAXABLE_ENTERED_DR ' || p_dist_rec.TAXABLE_ENTERED_DR);
39: arp_standard.debug( 'TAXABLE_ENTERED_CR ' || p_dist_rec.TAXABLE_ENTERED_CR);
40: arp_standard.debug( 'TAXABLE_ACCOUNTED_DR ' || p_dist_rec.TAXABLE_ACCOUNTED_DR);
41: arp_standard.debug( 'TAXABLE_ACCOUNTED_CR ' || p_dist_rec.TAXABLE_ACCOUNTED_CR);
42: arp_standard.debug( 'TAX_LINK_ID ' || p_dist_rec.TAX_LINK_ID);

Line 39: arp_standard.debug( 'TAXABLE_ENTERED_CR ' || p_dist_rec.TAXABLE_ENTERED_CR);

35: arp_standard.debug( 'CURRENCY_CONVERSION_RATE ' || p_dist_rec.CURRENCY_CONVERSION_RATE);
36: arp_standard.debug( 'CURRENCY_CONVERSION_TYPE ' || p_dist_rec.CURRENCY_CONVERSION_TYPE);
37: arp_standard.debug( 'CURRENCY_CONVERSION_DATE ' || p_dist_rec.CURRENCY_CONVERSION_DATE);
38: arp_standard.debug( 'TAXABLE_ENTERED_DR ' || p_dist_rec.TAXABLE_ENTERED_DR);
39: arp_standard.debug( 'TAXABLE_ENTERED_CR ' || p_dist_rec.TAXABLE_ENTERED_CR);
40: arp_standard.debug( 'TAXABLE_ACCOUNTED_DR ' || p_dist_rec.TAXABLE_ACCOUNTED_DR);
41: arp_standard.debug( 'TAXABLE_ACCOUNTED_CR ' || p_dist_rec.TAXABLE_ACCOUNTED_CR);
42: arp_standard.debug( 'TAX_LINK_ID ' || p_dist_rec.TAX_LINK_ID);
43: arp_standard.debug( 'THIRD_PARTY_ID ' || p_dist_rec.THIRD_PARTY_ID);

Line 40: arp_standard.debug( 'TAXABLE_ACCOUNTED_DR ' || p_dist_rec.TAXABLE_ACCOUNTED_DR);

36: arp_standard.debug( 'CURRENCY_CONVERSION_TYPE ' || p_dist_rec.CURRENCY_CONVERSION_TYPE);
37: arp_standard.debug( 'CURRENCY_CONVERSION_DATE ' || p_dist_rec.CURRENCY_CONVERSION_DATE);
38: arp_standard.debug( 'TAXABLE_ENTERED_DR ' || p_dist_rec.TAXABLE_ENTERED_DR);
39: arp_standard.debug( 'TAXABLE_ENTERED_CR ' || p_dist_rec.TAXABLE_ENTERED_CR);
40: arp_standard.debug( 'TAXABLE_ACCOUNTED_DR ' || p_dist_rec.TAXABLE_ACCOUNTED_DR);
41: arp_standard.debug( 'TAXABLE_ACCOUNTED_CR ' || p_dist_rec.TAXABLE_ACCOUNTED_CR);
42: arp_standard.debug( 'TAX_LINK_ID ' || p_dist_rec.TAX_LINK_ID);
43: arp_standard.debug( 'THIRD_PARTY_ID ' || p_dist_rec.THIRD_PARTY_ID);
44: arp_standard.debug( 'THIRD_PARTY_SUB_ID ' || p_dist_rec.THIRD_PARTY_SUB_ID);

Line 41: arp_standard.debug( 'TAXABLE_ACCOUNTED_CR ' || p_dist_rec.TAXABLE_ACCOUNTED_CR);

37: arp_standard.debug( 'CURRENCY_CONVERSION_DATE ' || p_dist_rec.CURRENCY_CONVERSION_DATE);
38: arp_standard.debug( 'TAXABLE_ENTERED_DR ' || p_dist_rec.TAXABLE_ENTERED_DR);
39: arp_standard.debug( 'TAXABLE_ENTERED_CR ' || p_dist_rec.TAXABLE_ENTERED_CR);
40: arp_standard.debug( 'TAXABLE_ACCOUNTED_DR ' || p_dist_rec.TAXABLE_ACCOUNTED_DR);
41: arp_standard.debug( 'TAXABLE_ACCOUNTED_CR ' || p_dist_rec.TAXABLE_ACCOUNTED_CR);
42: arp_standard.debug( 'TAX_LINK_ID ' || p_dist_rec.TAX_LINK_ID);
43: arp_standard.debug( 'THIRD_PARTY_ID ' || p_dist_rec.THIRD_PARTY_ID);
44: arp_standard.debug( 'THIRD_PARTY_SUB_ID ' || p_dist_rec.THIRD_PARTY_SUB_ID);
45: arp_standard.debug( 'REVERSED_SOURCE_ID ' || p_dist_rec.REVERSED_SOURCE_ID);

Line 42: arp_standard.debug( 'TAX_LINK_ID ' || p_dist_rec.TAX_LINK_ID);

38: arp_standard.debug( 'TAXABLE_ENTERED_DR ' || p_dist_rec.TAXABLE_ENTERED_DR);
39: arp_standard.debug( 'TAXABLE_ENTERED_CR ' || p_dist_rec.TAXABLE_ENTERED_CR);
40: arp_standard.debug( 'TAXABLE_ACCOUNTED_DR ' || p_dist_rec.TAXABLE_ACCOUNTED_DR);
41: arp_standard.debug( 'TAXABLE_ACCOUNTED_CR ' || p_dist_rec.TAXABLE_ACCOUNTED_CR);
42: arp_standard.debug( 'TAX_LINK_ID ' || p_dist_rec.TAX_LINK_ID);
43: arp_standard.debug( 'THIRD_PARTY_ID ' || p_dist_rec.THIRD_PARTY_ID);
44: arp_standard.debug( 'THIRD_PARTY_SUB_ID ' || p_dist_rec.THIRD_PARTY_SUB_ID);
45: arp_standard.debug( 'REVERSED_SOURCE_ID ' || p_dist_rec.REVERSED_SOURCE_ID);
46: arp_standard.debug( 'TAX_GROUP_CODE_ID ' || p_dist_rec.TAX_GROUP_CODE_ID);

Line 43: arp_standard.debug( 'THIRD_PARTY_ID ' || p_dist_rec.THIRD_PARTY_ID);

39: arp_standard.debug( 'TAXABLE_ENTERED_CR ' || p_dist_rec.TAXABLE_ENTERED_CR);
40: arp_standard.debug( 'TAXABLE_ACCOUNTED_DR ' || p_dist_rec.TAXABLE_ACCOUNTED_DR);
41: arp_standard.debug( 'TAXABLE_ACCOUNTED_CR ' || p_dist_rec.TAXABLE_ACCOUNTED_CR);
42: arp_standard.debug( 'TAX_LINK_ID ' || p_dist_rec.TAX_LINK_ID);
43: arp_standard.debug( 'THIRD_PARTY_ID ' || p_dist_rec.THIRD_PARTY_ID);
44: arp_standard.debug( 'THIRD_PARTY_SUB_ID ' || p_dist_rec.THIRD_PARTY_SUB_ID);
45: arp_standard.debug( 'REVERSED_SOURCE_ID ' || p_dist_rec.REVERSED_SOURCE_ID);
46: arp_standard.debug( 'TAX_GROUP_CODE_ID ' || p_dist_rec.TAX_GROUP_CODE_ID);
47: arp_standard.debug( 'TAX_CODE_ID ' || p_dist_rec.TAX_CODE_ID);

Line 44: arp_standard.debug( 'THIRD_PARTY_SUB_ID ' || p_dist_rec.THIRD_PARTY_SUB_ID);

40: arp_standard.debug( 'TAXABLE_ACCOUNTED_DR ' || p_dist_rec.TAXABLE_ACCOUNTED_DR);
41: arp_standard.debug( 'TAXABLE_ACCOUNTED_CR ' || p_dist_rec.TAXABLE_ACCOUNTED_CR);
42: arp_standard.debug( 'TAX_LINK_ID ' || p_dist_rec.TAX_LINK_ID);
43: arp_standard.debug( 'THIRD_PARTY_ID ' || p_dist_rec.THIRD_PARTY_ID);
44: arp_standard.debug( 'THIRD_PARTY_SUB_ID ' || p_dist_rec.THIRD_PARTY_SUB_ID);
45: arp_standard.debug( 'REVERSED_SOURCE_ID ' || p_dist_rec.REVERSED_SOURCE_ID);
46: arp_standard.debug( 'TAX_GROUP_CODE_ID ' || p_dist_rec.TAX_GROUP_CODE_ID);
47: arp_standard.debug( 'TAX_CODE_ID ' || p_dist_rec.TAX_CODE_ID);
48: arp_standard.debug( 'LOCATION_SEGMENT_ID ' || p_dist_rec.LOCATION_SEGMENT_ID);

Line 45: arp_standard.debug( 'REVERSED_SOURCE_ID ' || p_dist_rec.REVERSED_SOURCE_ID);

41: arp_standard.debug( 'TAXABLE_ACCOUNTED_CR ' || p_dist_rec.TAXABLE_ACCOUNTED_CR);
42: arp_standard.debug( 'TAX_LINK_ID ' || p_dist_rec.TAX_LINK_ID);
43: arp_standard.debug( 'THIRD_PARTY_ID ' || p_dist_rec.THIRD_PARTY_ID);
44: arp_standard.debug( 'THIRD_PARTY_SUB_ID ' || p_dist_rec.THIRD_PARTY_SUB_ID);
45: arp_standard.debug( 'REVERSED_SOURCE_ID ' || p_dist_rec.REVERSED_SOURCE_ID);
46: arp_standard.debug( 'TAX_GROUP_CODE_ID ' || p_dist_rec.TAX_GROUP_CODE_ID);
47: arp_standard.debug( 'TAX_CODE_ID ' || p_dist_rec.TAX_CODE_ID);
48: arp_standard.debug( 'LOCATION_SEGMENT_ID ' || p_dist_rec.LOCATION_SEGMENT_ID);
49: --HYU--{

Line 46: arp_standard.debug( 'TAX_GROUP_CODE_ID ' || p_dist_rec.TAX_GROUP_CODE_ID);

42: arp_standard.debug( 'TAX_LINK_ID ' || p_dist_rec.TAX_LINK_ID);
43: arp_standard.debug( 'THIRD_PARTY_ID ' || p_dist_rec.THIRD_PARTY_ID);
44: arp_standard.debug( 'THIRD_PARTY_SUB_ID ' || p_dist_rec.THIRD_PARTY_SUB_ID);
45: arp_standard.debug( 'REVERSED_SOURCE_ID ' || p_dist_rec.REVERSED_SOURCE_ID);
46: arp_standard.debug( 'TAX_GROUP_CODE_ID ' || p_dist_rec.TAX_GROUP_CODE_ID);
47: arp_standard.debug( 'TAX_CODE_ID ' || p_dist_rec.TAX_CODE_ID);
48: arp_standard.debug( 'LOCATION_SEGMENT_ID ' || p_dist_rec.LOCATION_SEGMENT_ID);
49: --HYU--{
50: arp_standard.debug( 'FROM_AMOUNT_DR ' || p_dist_rec.FROM_AMOUNT_DR);

Line 47: arp_standard.debug( 'TAX_CODE_ID ' || p_dist_rec.TAX_CODE_ID);

43: arp_standard.debug( 'THIRD_PARTY_ID ' || p_dist_rec.THIRD_PARTY_ID);
44: arp_standard.debug( 'THIRD_PARTY_SUB_ID ' || p_dist_rec.THIRD_PARTY_SUB_ID);
45: arp_standard.debug( 'REVERSED_SOURCE_ID ' || p_dist_rec.REVERSED_SOURCE_ID);
46: arp_standard.debug( 'TAX_GROUP_CODE_ID ' || p_dist_rec.TAX_GROUP_CODE_ID);
47: arp_standard.debug( 'TAX_CODE_ID ' || p_dist_rec.TAX_CODE_ID);
48: arp_standard.debug( 'LOCATION_SEGMENT_ID ' || p_dist_rec.LOCATION_SEGMENT_ID);
49: --HYU--{
50: arp_standard.debug( 'FROM_AMOUNT_DR ' || p_dist_rec.FROM_AMOUNT_DR);
51: arp_standard.debug( 'FROM_AMOUNT_CR ' || p_dist_rec.FROM_AMOUNT_CR);

Line 48: arp_standard.debug( 'LOCATION_SEGMENT_ID ' || p_dist_rec.LOCATION_SEGMENT_ID);

44: arp_standard.debug( 'THIRD_PARTY_SUB_ID ' || p_dist_rec.THIRD_PARTY_SUB_ID);
45: arp_standard.debug( 'REVERSED_SOURCE_ID ' || p_dist_rec.REVERSED_SOURCE_ID);
46: arp_standard.debug( 'TAX_GROUP_CODE_ID ' || p_dist_rec.TAX_GROUP_CODE_ID);
47: arp_standard.debug( 'TAX_CODE_ID ' || p_dist_rec.TAX_CODE_ID);
48: arp_standard.debug( 'LOCATION_SEGMENT_ID ' || p_dist_rec.LOCATION_SEGMENT_ID);
49: --HYU--{
50: arp_standard.debug( 'FROM_AMOUNT_DR ' || p_dist_rec.FROM_AMOUNT_DR);
51: arp_standard.debug( 'FROM_AMOUNT_CR ' || p_dist_rec.FROM_AMOUNT_CR);
52: arp_standard.debug( 'FROM_ACCTD_AMOUNT_DR ' || p_dist_rec.FROM_ACCTD_AMOUNT_DR);

Line 50: arp_standard.debug( 'FROM_AMOUNT_DR ' || p_dist_rec.FROM_AMOUNT_DR);

46: arp_standard.debug( 'TAX_GROUP_CODE_ID ' || p_dist_rec.TAX_GROUP_CODE_ID);
47: arp_standard.debug( 'TAX_CODE_ID ' || p_dist_rec.TAX_CODE_ID);
48: arp_standard.debug( 'LOCATION_SEGMENT_ID ' || p_dist_rec.LOCATION_SEGMENT_ID);
49: --HYU--{
50: arp_standard.debug( 'FROM_AMOUNT_DR ' || p_dist_rec.FROM_AMOUNT_DR);
51: arp_standard.debug( 'FROM_AMOUNT_CR ' || p_dist_rec.FROM_AMOUNT_CR);
52: arp_standard.debug( 'FROM_ACCTD_AMOUNT_DR ' || p_dist_rec.FROM_ACCTD_AMOUNT_DR);
53: arp_standard.debug( 'FROMACCTD_AMOUNT_CR ' || p_dist_rec.FROM_ACCTD_AMOUNT_CR);
54: arp_standard.debug( 'ref_customer_trx_line_id ' || p_dist_rec.ref_customer_trx_line_id);

Line 51: arp_standard.debug( 'FROM_AMOUNT_CR ' || p_dist_rec.FROM_AMOUNT_CR);

47: arp_standard.debug( 'TAX_CODE_ID ' || p_dist_rec.TAX_CODE_ID);
48: arp_standard.debug( 'LOCATION_SEGMENT_ID ' || p_dist_rec.LOCATION_SEGMENT_ID);
49: --HYU--{
50: arp_standard.debug( 'FROM_AMOUNT_DR ' || p_dist_rec.FROM_AMOUNT_DR);
51: arp_standard.debug( 'FROM_AMOUNT_CR ' || p_dist_rec.FROM_AMOUNT_CR);
52: arp_standard.debug( 'FROM_ACCTD_AMOUNT_DR ' || p_dist_rec.FROM_ACCTD_AMOUNT_DR);
53: arp_standard.debug( 'FROMACCTD_AMOUNT_CR ' || p_dist_rec.FROM_ACCTD_AMOUNT_CR);
54: arp_standard.debug( 'ref_customer_trx_line_id ' || p_dist_rec.ref_customer_trx_line_id);
55: arp_standard.debug( 'ref_prev_cust_trx_line_id ' || p_dist_rec.ref_prev_cust_trx_line_id);

Line 52: arp_standard.debug( 'FROM_ACCTD_AMOUNT_DR ' || p_dist_rec.FROM_ACCTD_AMOUNT_DR);

48: arp_standard.debug( 'LOCATION_SEGMENT_ID ' || p_dist_rec.LOCATION_SEGMENT_ID);
49: --HYU--{
50: arp_standard.debug( 'FROM_AMOUNT_DR ' || p_dist_rec.FROM_AMOUNT_DR);
51: arp_standard.debug( 'FROM_AMOUNT_CR ' || p_dist_rec.FROM_AMOUNT_CR);
52: arp_standard.debug( 'FROM_ACCTD_AMOUNT_DR ' || p_dist_rec.FROM_ACCTD_AMOUNT_DR);
53: arp_standard.debug( 'FROMACCTD_AMOUNT_CR ' || p_dist_rec.FROM_ACCTD_AMOUNT_CR);
54: arp_standard.debug( 'ref_customer_trx_line_id ' || p_dist_rec.ref_customer_trx_line_id);
55: arp_standard.debug( 'ref_prev_cust_trx_line_id ' || p_dist_rec.ref_prev_cust_trx_line_id);
56: arp_standard.debug( 'ref_cust_trx_line_gl_dist_id ' || p_dist_rec.ref_cust_trx_line_gl_dist_id);

Line 53: arp_standard.debug( 'FROMACCTD_AMOUNT_CR ' || p_dist_rec.FROM_ACCTD_AMOUNT_CR);

49: --HYU--{
50: arp_standard.debug( 'FROM_AMOUNT_DR ' || p_dist_rec.FROM_AMOUNT_DR);
51: arp_standard.debug( 'FROM_AMOUNT_CR ' || p_dist_rec.FROM_AMOUNT_CR);
52: arp_standard.debug( 'FROM_ACCTD_AMOUNT_DR ' || p_dist_rec.FROM_ACCTD_AMOUNT_DR);
53: arp_standard.debug( 'FROMACCTD_AMOUNT_CR ' || p_dist_rec.FROM_ACCTD_AMOUNT_CR);
54: arp_standard.debug( 'ref_customer_trx_line_id ' || p_dist_rec.ref_customer_trx_line_id);
55: arp_standard.debug( 'ref_prev_cust_trx_line_id ' || p_dist_rec.ref_prev_cust_trx_line_id);
56: arp_standard.debug( 'ref_cust_trx_line_gl_dist_id ' || p_dist_rec.ref_cust_trx_line_gl_dist_id);
57: arp_standard.debug( 'ref_account_class ' || p_dist_rec.ref_account_class);

Line 54: arp_standard.debug( 'ref_customer_trx_line_id ' || p_dist_rec.ref_customer_trx_line_id);

50: arp_standard.debug( 'FROM_AMOUNT_DR ' || p_dist_rec.FROM_AMOUNT_DR);
51: arp_standard.debug( 'FROM_AMOUNT_CR ' || p_dist_rec.FROM_AMOUNT_CR);
52: arp_standard.debug( 'FROM_ACCTD_AMOUNT_DR ' || p_dist_rec.FROM_ACCTD_AMOUNT_DR);
53: arp_standard.debug( 'FROMACCTD_AMOUNT_CR ' || p_dist_rec.FROM_ACCTD_AMOUNT_CR);
54: arp_standard.debug( 'ref_customer_trx_line_id ' || p_dist_rec.ref_customer_trx_line_id);
55: arp_standard.debug( 'ref_prev_cust_trx_line_id ' || p_dist_rec.ref_prev_cust_trx_line_id);
56: arp_standard.debug( 'ref_cust_trx_line_gl_dist_id ' || p_dist_rec.ref_cust_trx_line_gl_dist_id);
57: arp_standard.debug( 'ref_account_class ' || p_dist_rec.ref_account_class);
58: arp_standard.debug( 'activity_bucket ' || p_dist_rec.activity_bucket);

Line 55: arp_standard.debug( 'ref_prev_cust_trx_line_id ' || p_dist_rec.ref_prev_cust_trx_line_id);

51: arp_standard.debug( 'FROM_AMOUNT_CR ' || p_dist_rec.FROM_AMOUNT_CR);
52: arp_standard.debug( 'FROM_ACCTD_AMOUNT_DR ' || p_dist_rec.FROM_ACCTD_AMOUNT_DR);
53: arp_standard.debug( 'FROMACCTD_AMOUNT_CR ' || p_dist_rec.FROM_ACCTD_AMOUNT_CR);
54: arp_standard.debug( 'ref_customer_trx_line_id ' || p_dist_rec.ref_customer_trx_line_id);
55: arp_standard.debug( 'ref_prev_cust_trx_line_id ' || p_dist_rec.ref_prev_cust_trx_line_id);
56: arp_standard.debug( 'ref_cust_trx_line_gl_dist_id ' || p_dist_rec.ref_cust_trx_line_gl_dist_id);
57: arp_standard.debug( 'ref_account_class ' || p_dist_rec.ref_account_class);
58: arp_standard.debug( 'activity_bucket ' || p_dist_rec.activity_bucket);
59: arp_standard.debug( 'REF_DIST_CCID ' || p_dist_rec.ref_dist_ccid);

Line 56: arp_standard.debug( 'ref_cust_trx_line_gl_dist_id ' || p_dist_rec.ref_cust_trx_line_gl_dist_id);

52: arp_standard.debug( 'FROM_ACCTD_AMOUNT_DR ' || p_dist_rec.FROM_ACCTD_AMOUNT_DR);
53: arp_standard.debug( 'FROMACCTD_AMOUNT_CR ' || p_dist_rec.FROM_ACCTD_AMOUNT_CR);
54: arp_standard.debug( 'ref_customer_trx_line_id ' || p_dist_rec.ref_customer_trx_line_id);
55: arp_standard.debug( 'ref_prev_cust_trx_line_id ' || p_dist_rec.ref_prev_cust_trx_line_id);
56: arp_standard.debug( 'ref_cust_trx_line_gl_dist_id ' || p_dist_rec.ref_cust_trx_line_gl_dist_id);
57: arp_standard.debug( 'ref_account_class ' || p_dist_rec.ref_account_class);
58: arp_standard.debug( 'activity_bucket ' || p_dist_rec.activity_bucket);
59: arp_standard.debug( 'REF_DIST_CCID ' || p_dist_rec.ref_dist_ccid);
60: arp_standard.debug( 'REF_MF_DIST_FLAG ' || p_dist_rec.ref_mf_dist_flag);

Line 57: arp_standard.debug( 'ref_account_class ' || p_dist_rec.ref_account_class);

53: arp_standard.debug( 'FROMACCTD_AMOUNT_CR ' || p_dist_rec.FROM_ACCTD_AMOUNT_CR);
54: arp_standard.debug( 'ref_customer_trx_line_id ' || p_dist_rec.ref_customer_trx_line_id);
55: arp_standard.debug( 'ref_prev_cust_trx_line_id ' || p_dist_rec.ref_prev_cust_trx_line_id);
56: arp_standard.debug( 'ref_cust_trx_line_gl_dist_id ' || p_dist_rec.ref_cust_trx_line_gl_dist_id);
57: arp_standard.debug( 'ref_account_class ' || p_dist_rec.ref_account_class);
58: arp_standard.debug( 'activity_bucket ' || p_dist_rec.activity_bucket);
59: arp_standard.debug( 'REF_DIST_CCID ' || p_dist_rec.ref_dist_ccid);
60: arp_standard.debug( 'REF_MF_DIST_FLAG ' || p_dist_rec.ref_mf_dist_flag);
61: --HYU--}

Line 58: arp_standard.debug( 'activity_bucket ' || p_dist_rec.activity_bucket);

54: arp_standard.debug( 'ref_customer_trx_line_id ' || p_dist_rec.ref_customer_trx_line_id);
55: arp_standard.debug( 'ref_prev_cust_trx_line_id ' || p_dist_rec.ref_prev_cust_trx_line_id);
56: arp_standard.debug( 'ref_cust_trx_line_gl_dist_id ' || p_dist_rec.ref_cust_trx_line_gl_dist_id);
57: arp_standard.debug( 'ref_account_class ' || p_dist_rec.ref_account_class);
58: arp_standard.debug( 'activity_bucket ' || p_dist_rec.activity_bucket);
59: arp_standard.debug( 'REF_DIST_CCID ' || p_dist_rec.ref_dist_ccid);
60: arp_standard.debug( 'REF_MF_DIST_FLAG ' || p_dist_rec.ref_mf_dist_flag);
61: --HYU--}
62: END IF;

Line 59: arp_standard.debug( 'REF_DIST_CCID ' || p_dist_rec.ref_dist_ccid);

55: arp_standard.debug( 'ref_prev_cust_trx_line_id ' || p_dist_rec.ref_prev_cust_trx_line_id);
56: arp_standard.debug( 'ref_cust_trx_line_gl_dist_id ' || p_dist_rec.ref_cust_trx_line_gl_dist_id);
57: arp_standard.debug( 'ref_account_class ' || p_dist_rec.ref_account_class);
58: arp_standard.debug( 'activity_bucket ' || p_dist_rec.activity_bucket);
59: arp_standard.debug( 'REF_DIST_CCID ' || p_dist_rec.ref_dist_ccid);
60: arp_standard.debug( 'REF_MF_DIST_FLAG ' || p_dist_rec.ref_mf_dist_flag);
61: --HYU--}
62: END IF;
63:

Line 60: arp_standard.debug( 'REF_MF_DIST_FLAG ' || p_dist_rec.ref_mf_dist_flag);

56: arp_standard.debug( 'ref_cust_trx_line_gl_dist_id ' || p_dist_rec.ref_cust_trx_line_gl_dist_id);
57: arp_standard.debug( 'ref_account_class ' || p_dist_rec.ref_account_class);
58: arp_standard.debug( 'activity_bucket ' || p_dist_rec.activity_bucket);
59: arp_standard.debug( 'REF_DIST_CCID ' || p_dist_rec.ref_dist_ccid);
60: arp_standard.debug( 'REF_MF_DIST_FLAG ' || p_dist_rec.ref_mf_dist_flag);
61: --HYU--}
62: END IF;
63:
64: INSERT INTO ar_distributions (

Line 123: arp_standard.profile.user_id,

119: p_dist_rec.amount_dr,
120: p_dist_rec.amount_cr,
121: p_dist_rec.acctd_amount_dr,
122: p_dist_rec.acctd_amount_cr,
123: arp_standard.profile.user_id,
124: SYSDATE,
125: arp_standard.profile.user_id,
126: SYSDATE,
127: NVL( arp_standard.profile.last_update_login,

Line 125: arp_standard.profile.user_id,

121: p_dist_rec.acctd_amount_dr,
122: p_dist_rec.acctd_amount_cr,
123: arp_standard.profile.user_id,
124: SYSDATE,
125: arp_standard.profile.user_id,
126: SYSDATE,
127: NVL( arp_standard.profile.last_update_login,
128: p_dist_rec.last_update_login ),
129: p_dist_rec.source_id_secondary,

Line 127: NVL( arp_standard.profile.last_update_login,

123: arp_standard.profile.user_id,
124: SYSDATE,
125: arp_standard.profile.user_id,
126: SYSDATE,
127: NVL( arp_standard.profile.last_update_login,
128: p_dist_rec.last_update_login ),
129: p_dist_rec.source_id_secondary,
130: p_dist_rec.source_table_secondary,
131: p_dist_rec.currency_code ,

Line 146: ,arp_standard.sysparm.org_id /* SSA changes anuj */

142: p_dist_rec.taxable_accounted_cr,
143: p_dist_rec.tax_link_id,
144: p_dist_rec.reversed_source_id,
145: p_dist_rec.tax_group_code_id
146: ,arp_standard.sysparm.org_id /* SSA changes anuj */
147: --{BUG#2979254
148: ,p_dist_rec.ref_customer_trx_line_id
149: ,p_dist_rec.ref_prev_cust_trx_line_id
150: ,p_dist_rec.ref_cust_trx_line_gl_dist_id

Line 166: arp_standard.debug( 'arp_distributions_pkg.insert_p()-' );

162: --
163: p_line_id := l_line_id;
164: --
165: IF PG_DEBUG in ('Y', 'C') THEN
166: arp_standard.debug( 'arp_distributions_pkg.insert_p()-' );
167: END IF;
168: EXCEPTION
169: WHEN exp_null_insert THEN
170: FND_MESSAGE.SET_NAME('AR','AR_INS_NULL_INTO_NOTNULL');

Line 174: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.insert_p' );

170: FND_MESSAGE.SET_NAME('AR','AR_INS_NULL_INTO_NOTNULL');
171: APP_EXCEPTION.RAISE_EXCEPTION;
172: WHEN OTHERS THEN
173: IF PG_DEBUG in ('Y', 'C') THEN
174: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.insert_p' );
175: END IF;
176: RAISE;
177: END insert_p;
178: --

Line 183: arp_standard.debug( 'arp_distributions_pkg.update_p()+' );

179: PROCEDURE update_p(
180: p_dist_rec IN ar_distributions%ROWTYPE ) IS
181: BEGIN
182: IF PG_DEBUG in ('Y', 'C') THEN
183: arp_standard.debug( 'arp_distributions_pkg.update_p()+' );
184: END IF;
185: --
186: UPDATE ar_distributions SET
187: source_id = p_dist_rec.source_id,

Line 196: last_updated_by = arp_standard.profile.user_id,

192: amount_dr = p_dist_rec.amount_dr,
193: amount_cr = p_dist_rec.amount_cr,
194: acctd_amount_dr = p_dist_rec.acctd_amount_dr,
195: acctd_amount_cr = p_dist_rec.acctd_amount_cr,
196: last_updated_by = arp_standard.profile.user_id,
197: last_update_date = SYSDATE,
198: last_update_login = NVL( arp_standard.profile.last_update_login,
199: p_dist_rec.last_update_login ),
200: source_id_secondary = p_dist_rec.source_id_secondary,

Line 198: last_update_login = NVL( arp_standard.profile.last_update_login,

194: acctd_amount_dr = p_dist_rec.acctd_amount_dr,
195: acctd_amount_cr = p_dist_rec.acctd_amount_cr,
196: last_updated_by = arp_standard.profile.user_id,
197: last_update_date = SYSDATE,
198: last_update_login = NVL( arp_standard.profile.last_update_login,
199: p_dist_rec.last_update_login ),
200: source_id_secondary = p_dist_rec.source_id_secondary,
201: source_table_secondary = p_dist_rec.source_table_secondary,
202: currency_code = p_dist_rec.currency_code,

Line 233: arp_standard.debug( 'arp_distributions_pkg.update_p()-' );

229: --}
230: WHERE line_id = p_dist_rec.line_id;
231: --
232: IF PG_DEBUG in ('Y', 'C') THEN
233: arp_standard.debug( 'arp_distributions_pkg.update_p()-' );
234: END IF;
235: EXCEPTION
236: WHEN OTHERS THEN
237: IF PG_DEBUG in ('Y', 'C') THEN

Line 238: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.update_p' );

234: END IF;
235: EXCEPTION
236: WHEN OTHERS THEN
237: IF PG_DEBUG in ('Y', 'C') THEN
238: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.update_p' );
239: END IF;
240: RAISE;
241: END update_p;
242: --

Line 247: arp_standard.debug( 'arp_distributions_pkg.delete_p()+' );

243: PROCEDURE delete_p(
244: p_line_id IN ar_distributions.line_id%TYPE ) IS
245: BEGIN
246: IF PG_DEBUG in ('Y', 'C') THEN
247: arp_standard.debug( 'arp_distributions_pkg.delete_p()+' );
248: END IF;
249: --
250: DELETE FROM ar_distributions
251: WHERE line_id = p_line_id;

Line 254: arp_standard.debug( 'arp_distributions_pkg.delete_p()-' );

250: DELETE FROM ar_distributions
251: WHERE line_id = p_line_id;
252: --
253: IF PG_DEBUG in ('Y', 'C') THEN
254: arp_standard.debug( 'arp_distributions_pkg.delete_p()-' );
255: END IF;
256: EXCEPTION
257: WHEN OTHERS THEN
258: IF PG_DEBUG in ('Y', 'C') THEN

Line 259: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.delete_p' );

255: END IF;
256: EXCEPTION
257: WHEN OTHERS THEN
258: IF PG_DEBUG in ('Y', 'C') THEN
259: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.delete_p' );
260: END IF;
261: RAISE;
262: END delete_p;
263: --

Line 269: arp_standard.debug( 'arp_distributions_pkg.lock_p()+' );

265: p_line_id IN ar_distributions.line_id%TYPE ) IS
266: l_line_id ar_distributions.line_id%TYPE;
267: BEGIN
268: IF PG_DEBUG in ('Y', 'C') THEN
269: arp_standard.debug( 'arp_distributions_pkg.lock_p()+' );
270: END IF;
271: SELECT line_id
272: INTO l_line_id
273: FROM ar_distributions

Line 278: arp_standard.debug( 'arp_distributions_pkg.lock_p()-' );

274: WHERE line_id = p_line_id
275: FOR UPDATE OF line_id;
276: --
277: IF PG_DEBUG in ('Y', 'C') THEN
278: arp_standard.debug( 'arp_distributions_pkg.lock_p()-' );
279: END IF;
280: EXCEPTION
281: WHEN OTHERS THEN
282: IF PG_DEBUG in ('Y', 'C') THEN

Line 283: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.lock_p' );

279: END IF;
280: EXCEPTION
281: WHEN OTHERS THEN
282: IF PG_DEBUG in ('Y', 'C') THEN
283: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.lock_p' );
284: END IF;
285: RAISE;
286: END lock_p;
287: --

Line 293: arp_standard.debug( 'arp_distributions_pkg.fetch_p()+' );

289: p_line_id IN ar_distributions.line_id%TYPE,
290: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS
291: BEGIN
292: IF PG_DEBUG in ('Y', 'C') THEN
293: arp_standard.debug( 'arp_distributions_pkg.fetch_p()+' );
294: END IF;
295: SELECT *
296: INTO p_dist_rec
297: FROM ar_distributions

Line 300: arp_standard.debug( 'arp_distributions_pkg.fetch_p()-' );

296: INTO p_dist_rec
297: FROM ar_distributions
298: WHERE line_id = p_line_id;
299: IF PG_DEBUG in ('Y', 'C') THEN
300: arp_standard.debug( 'arp_distributions_pkg.fetch_p()-' );
301: END IF;
302: --
303: EXCEPTION
304: --

Line 307: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.fetch_p' );

303: EXCEPTION
304: --
305: WHEN OTHERS THEN
306: IF PG_DEBUG in ('Y', 'C') THEN
307: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.fetch_p' );
308: END IF;
309: RAISE;
310: END fetch_p;
311: --

Line 319: arp_standard.debug( 'arp_distributions_pkg.fetch_pk()+' );

315: p_source_type IN ar_distributions.source_type%TYPE,
316: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS
317: BEGIN
318: IF PG_DEBUG in ('Y', 'C') THEN
319: arp_standard.debug( 'arp_distributions_pkg.fetch_pk()+' );
320: END IF;
321: SELECT *
322: INTO p_dist_rec
323: FROM ar_distributions

Line 328: arp_standard.debug( 'arp_distributions_pkg.fetch_pk()-' );

324: WHERE source_id = p_source_id
325: AND source_table = p_source_table
326: AND source_type = p_source_type;
327: IF PG_DEBUG in ('Y', 'C') THEN
328: arp_standard.debug( 'arp_distributions_pkg.fetch_pk()-' );
329: END IF;
330: --
331: EXCEPTION
332: --

Line 335: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.fetch_pk' );

331: EXCEPTION
332: --
333: WHEN OTHERS THEN
334: IF PG_DEBUG in ('Y', 'C') THEN
335: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.fetch_pk' );
336: END IF;
337: RAISE;
338: END fetch_pk;
339: --

Line 347: arp_standard.debug( 'arp_distributions_pkg.lock_fetch_pk()+' );

343: p_source_type IN ar_distributions.source_type%TYPE,
344: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS
345: BEGIN
346: IF PG_DEBUG in ('Y', 'C') THEN
347: arp_standard.debug( 'arp_distributions_pkg.lock_fetch_pk()+' );
348: END IF;
349: SELECT *
350: INTO p_dist_rec
351: FROM ar_distributions

Line 358: arp_standard.debug( 'arp_distributions_pkg.lock_fetch_pk()-' );

354: AND source_type = p_source_type
355: FOR UPDATE OF line_id;
356:
357: IF PG_DEBUG in ('Y', 'C') THEN
358: arp_standard.debug( 'arp_distributions_pkg.lock_fetch_pk()-' );
359: END IF;
360: --
361: EXCEPTION
362: --

Line 365: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.lock_fetch_pk' );

361: EXCEPTION
362: --
363: WHEN OTHERS THEN
364: IF PG_DEBUG in ('Y', 'C') THEN
365: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.lock_fetch_pk' );
366: END IF;
367: RAISE;
368: END lock_fetch_pk;
369: --

Line 377: arp_standard.debug( 'arp_distributions_pkg.nowaitlock_fetch_pk()+' );

373: p_source_type IN ar_distributions.source_type%TYPE,
374: p_dist_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS
375: BEGIN
376: IF PG_DEBUG in ('Y', 'C') THEN
377: arp_standard.debug( 'arp_distributions_pkg.nowaitlock_fetch_pk()+' );
378: END IF;
379: SELECT *
380: INTO p_dist_rec
381: FROM ar_distributions

Line 388: arp_standard.debug( 'arp_distributions_pkg.nowaitlock_fetch_pk()-' );

384: AND source_type = p_source_type
385: FOR UPDATE OF line_id NOWAIT;
386:
387: IF PG_DEBUG in ('Y', 'C') THEN
388: arp_standard.debug( 'arp_distributions_pkg.nowaitlock_fetch_pk()-' );
389: END IF;
390: --
391: EXCEPTION
392: --

Line 395: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.nowaitlock_fetch_pk' );

391: EXCEPTION
392: --
393: WHEN OTHERS THEN
394: IF PG_DEBUG in ('Y', 'C') THEN
395: arp_standard.debug( 'EXCEPTION: arp_distributions_pkg.nowaitlock_fetch_pk' );
396: END IF;
397: RAISE;
398: END nowaitlock_fetch_pk;
399: --