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.PA_MC_RETN_INV_DETAIL_PKG dependencies on PA_RETENTION_UTIL

Line 51: pa_retention_util.write_log('Entering pa_mc_retn_inv_detail_pkg.Process_RetnInvDetails');

47:
48:
49: BEGIN
50: IF g1_debug_mode = 'Y' THEN
51: pa_retention_util.write_log('Entering pa_mc_retn_inv_detail_pkg.Process_RetnInvDetails');
52: END IF;
53:
54: IF NOT gl_mc_currency_pkg.G_PA_UPGRADE_MODE THEN
55:

Line 58: -- pa_retention_util.write_log('Leaving pa_mc_retn_inv_detail_pkg.Process_RetnInvDetails');

54: IF NOT gl_mc_currency_pkg.G_PA_UPGRADE_MODE THEN
55:
56: IF p_action ='INSERT' THEN /* Inserting new record */
57:
58: -- pa_retention_util.write_log('Leaving pa_mc_retn_inv_detail_pkg.Process_RetnInvDetails');
59:
60: SELECT p.org_id, p.projfunc_currency_code ,
61: imp.set_of_books_id sob,
62: di.invoice_date invoice_date

Line 97: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Primary SOB : ' || sob );

93: l_exchange_rate_date := l_invoice_date;
94: l_exchange_rate_type := v_rsob.conversion_type;
95:
96: IF g1_debug_mode = 'Y' THEN
97: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Primary SOB : ' || sob );
98: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Reporting SOB : ' || v_rsob.reporting_set_of_books_id );
99: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Completion date : ' || to_char(l_invoice_date) );
100: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Org Id : ' || l_org_id);
101: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Projfunc Currency: ' || currency );

Line 98: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Reporting SOB : ' || v_rsob.reporting_set_of_books_id );

94: l_exchange_rate_type := v_rsob.conversion_type;
95:
96: IF g1_debug_mode = 'Y' THEN
97: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Primary SOB : ' || sob );
98: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Reporting SOB : ' || v_rsob.reporting_set_of_books_id );
99: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Completion date : ' || to_char(l_invoice_date) );
100: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Org Id : ' || l_org_id);
101: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Projfunc Currency: ' || currency );
102: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate Type : ' ||l_exchange_rate_type );

Line 99: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Completion date : ' || to_char(l_invoice_date) );

95:
96: IF g1_debug_mode = 'Y' THEN
97: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Primary SOB : ' || sob );
98: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Reporting SOB : ' || v_rsob.reporting_set_of_books_id );
99: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Completion date : ' || to_char(l_invoice_date) );
100: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Org Id : ' || l_org_id);
101: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Projfunc Currency: ' || currency );
102: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate Type : ' ||l_exchange_rate_type );
103: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate : ' ||l_exchange_rate );

Line 100: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Org Id : ' || l_org_id);

96: IF g1_debug_mode = 'Y' THEN
97: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Primary SOB : ' || sob );
98: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Reporting SOB : ' || v_rsob.reporting_set_of_books_id );
99: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Completion date : ' || to_char(l_invoice_date) );
100: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Org Id : ' || l_org_id);
101: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Projfunc Currency: ' || currency );
102: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate Type : ' ||l_exchange_rate_type );
103: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate : ' ||l_exchange_rate );
104: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange date : ' ||to_char(l_exchange_rate_date));

Line 101: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Projfunc Currency: ' || currency );

97: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Primary SOB : ' || sob );
98: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Reporting SOB : ' || v_rsob.reporting_set_of_books_id );
99: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Completion date : ' || to_char(l_invoice_date) );
100: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Org Id : ' || l_org_id);
101: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Projfunc Currency: ' || currency );
102: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate Type : ' ||l_exchange_rate_type );
103: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate : ' ||l_exchange_rate );
104: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange date : ' ||to_char(l_exchange_rate_date));
105: END IF;

Line 102: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate Type : ' ||l_exchange_rate_type );

98: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Reporting SOB : ' || v_rsob.reporting_set_of_books_id );
99: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Completion date : ' || to_char(l_invoice_date) );
100: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Org Id : ' || l_org_id);
101: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Projfunc Currency: ' || currency );
102: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate Type : ' ||l_exchange_rate_type );
103: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate : ' ||l_exchange_rate );
104: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange date : ' ||to_char(l_exchange_rate_date));
105: END IF;
106:

Line 103: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate : ' ||l_exchange_rate );

99: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Completion date : ' || to_char(l_invoice_date) );
100: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Org Id : ' || l_org_id);
101: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Projfunc Currency: ' || currency );
102: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate Type : ' ||l_exchange_rate_type );
103: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate : ' ||l_exchange_rate );
104: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange date : ' ||to_char(l_exchange_rate_date));
105: END IF;
106:
107:

Line 104: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange date : ' ||to_char(l_exchange_rate_date));

100: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Org Id : ' || l_org_id);
101: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Projfunc Currency: ' || currency );
102: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate Type : ' ||l_exchange_rate_type );
103: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate : ' ||l_exchange_rate );
104: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange date : ' ||to_char(l_exchange_rate_date));
105: END IF;
106:
107:
108:

Line 126: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'After the Rate API ');

122: p_denominator_rate => l_denominator_rate,
123: p_numerator_rate => l_numerator_rate);
124:
125: IF g1_debug_mode = 'Y' THEN
126: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'After the Rate API ');
127: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate Type : ' ||l_exchange_rate_type );
128: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate : ' ||l_exchange_rate );
129: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange date : ' ||to_char(l_exchange_rate_date));
130: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'p_draft_invoice_num : '|| p_draft_invoice_num);

Line 127: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate Type : ' ||l_exchange_rate_type );

123: p_numerator_rate => l_numerator_rate);
124:
125: IF g1_debug_mode = 'Y' THEN
126: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'After the Rate API ');
127: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate Type : ' ||l_exchange_rate_type );
128: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate : ' ||l_exchange_rate );
129: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange date : ' ||to_char(l_exchange_rate_date));
130: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'p_draft_invoice_num : '|| p_draft_invoice_num);
131: END IF;

Line 128: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate : ' ||l_exchange_rate );

124:
125: IF g1_debug_mode = 'Y' THEN
126: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'After the Rate API ');
127: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate Type : ' ||l_exchange_rate_type );
128: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate : ' ||l_exchange_rate );
129: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange date : ' ||to_char(l_exchange_rate_date));
130: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'p_draft_invoice_num : '|| p_draft_invoice_num);
131: END IF;
132:

Line 129: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange date : ' ||to_char(l_exchange_rate_date));

125: IF g1_debug_mode = 'Y' THEN
126: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'After the Rate API ');
127: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate Type : ' ||l_exchange_rate_type );
128: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate : ' ||l_exchange_rate );
129: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange date : ' ||to_char(l_exchange_rate_date));
130: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'p_draft_invoice_num : '|| p_draft_invoice_num);
131: END IF;
132:
133: FOR InvDetRec IN (SELECT

Line 130: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'p_draft_invoice_num : '|| p_draft_invoice_num);

126: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'After the Rate API ');
127: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate Type : ' ||l_exchange_rate_type );
128: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange rate : ' ||l_exchange_rate );
129: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Exchange date : ' ||to_char(l_exchange_rate_date));
130: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'p_draft_invoice_num : '|| p_draft_invoice_num);
131: END IF;
132:
133: FOR InvDetRec IN (SELECT
134: retn_invoice_detail_id,

Line 152: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Before inserting into pa_mc_retn_inv_details');

148: (InvDetRec.projfunc_total_retained/ l_denominator_rate)*
149: l_numerator_rate),v_rsob.reporting_currency_code);
150:
151: IF g1_debug_mode = 'Y' THEN
152: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Before inserting into pa_mc_retn_inv_details');
153: pa_retention_util.write_log('Process_RetnInvDetails: ' || '------------------------------');
154: END IF;
155:
156: /* Bug 2976939: Added set_of_books_id check in the select below.Since this check was not there

Line 153: pa_retention_util.write_log('Process_RetnInvDetails: ' || '------------------------------');

149: l_numerator_rate),v_rsob.reporting_currency_code);
150:
151: IF g1_debug_mode = 'Y' THEN
152: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Before inserting into pa_mc_retn_inv_details');
153: pa_retention_util.write_log('Process_RetnInvDetails: ' || '------------------------------');
154: END IF;
155:
156: /* Bug 2976939: Added set_of_books_id check in the select below.Since this check was not there
157: only for one RSOB record will be inserted. */

Line 163: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'After inserting into pa_mc_retn_inv_details');

159: BEGIN
160: NULL;
161: END;
162: IF g1_debug_mode = 'Y' THEN
163: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'After inserting into pa_mc_retn_inv_details');
164: END IF;
165:
166: END LOOP; -- End of invoice loop
167:

Line 175: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Delete Invoice Details');

171:
172: ELSIF p_action='DELETE' THEN
173:
174: IF g1_debug_mode = 'Y' THEN
175: pa_retention_util.write_log('Process_RetnInvDetails: ' || 'Delete Invoice Details');
176: END IF;
177: END IF;
178:
179: END IF; /* Not MRC Upgrade */

Line 181: pa_retention_util.write_log('Leaving pa_mc_retn_inv_detail_pkg.Process_RetnInvDetails');

177: END IF;
178:
179: END IF; /* Not MRC Upgrade */
180: IF g1_debug_mode = 'Y' THEN
181: pa_retention_util.write_log('Leaving pa_mc_retn_inv_detail_pkg.Process_RetnInvDetails');
182: END IF;
183:
184: END Process_RetnInvDetails;
185: