APPS.RCV_GARBAGE_COLLECTOR_SV dependencies on ASN_DEBUG

Line 5: g_asn_debug VARCHAR2(1) := asn_debug.is_debug_on; -- Bug 9152790

1: PACKAGE BODY RCV_GARBAGE_COLLECTOR_SV AS
2: /* $Header: RCVGARBB.pls 120.0.12010000.2 2010/01/25 22:40:03 vthevark ship $ */
3:
4: -- Read the profile option that enables/disables the debug log
5: g_asn_debug VARCHAR2(1) := asn_debug.is_debug_on; -- Bug 9152790
6:
7: /*===========================================================================
8:
9: PROCEDURE NAME: collect_garbage()

Line 98: IF (g_asn_debug = 'Y') THEN

94: rti.header_interface_id = c1_rec.header_interface_id;
95:
96: if c1_rec.error_count = v_total_count then
97:
98: IF (g_asn_debug = 'Y') THEN
99: asn_debug.put_line('The ASN ' || to_char(c1_rec.header_interface_id) || ' has only errored rows');
100: asn_debug.put_line('Need to mark the ASN and all transactions to RUNNING');
101: END IF;
102:

Line 99: asn_debug.put_line('The ASN ' || to_char(c1_rec.header_interface_id) || ' has only errored rows');

95:
96: if c1_rec.error_count = v_total_count then
97:
98: IF (g_asn_debug = 'Y') THEN
99: asn_debug.put_line('The ASN ' || to_char(c1_rec.header_interface_id) || ' has only errored rows');
100: asn_debug.put_line('Need to mark the ASN and all transactions to RUNNING');
101: END IF;
102:
103: -- update the header to running with the right request_id

Line 100: asn_debug.put_line('Need to mark the ASN and all transactions to RUNNING');

96: if c1_rec.error_count = v_total_count then
97:
98: IF (g_asn_debug = 'Y') THEN
99: asn_debug.put_line('The ASN ' || to_char(c1_rec.header_interface_id) || ' has only errored rows');
100: asn_debug.put_line('Need to mark the ASN and all transactions to RUNNING');
101: END IF;
102:
103: -- update the header to running with the right request_id
104:

Line 133: IF (g_asn_debug = 'Y') THEN

129: AND header_interface_id = c1_rec.header_interface_id;
130:
131: else
132:
133: IF (g_asn_debug = 'Y') THEN
134: asn_debug.put_line('Should be picked up in some other session');
135: asn_debug.put_line('The ASN ' || to_char(c1_rec.header_interface_id) || ' may have some valid rows');
136: asn_debug.put_line('We do nothing in this case');
137: END IF;

Line 134: asn_debug.put_line('Should be picked up in some other session');

130:
131: else
132:
133: IF (g_asn_debug = 'Y') THEN
134: asn_debug.put_line('Should be picked up in some other session');
135: asn_debug.put_line('The ASN ' || to_char(c1_rec.header_interface_id) || ' may have some valid rows');
136: asn_debug.put_line('We do nothing in this case');
137: END IF;
138:

Line 135: asn_debug.put_line('The ASN ' || to_char(c1_rec.header_interface_id) || ' may have some valid rows');

131: else
132:
133: IF (g_asn_debug = 'Y') THEN
134: asn_debug.put_line('Should be picked up in some other session');
135: asn_debug.put_line('The ASN ' || to_char(c1_rec.header_interface_id) || ' may have some valid rows');
136: asn_debug.put_line('We do nothing in this case');
137: END IF;
138:
139: end if;

Line 136: asn_debug.put_line('We do nothing in this case');

132:
133: IF (g_asn_debug = 'Y') THEN
134: asn_debug.put_line('Should be picked up in some other session');
135: asn_debug.put_line('The ASN ' || to_char(c1_rec.header_interface_id) || ' may have some valid rows');
136: asn_debug.put_line('We do nothing in this case');
137: END IF;
138:
139: end if;
140: