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.XTR_JOURNAL_PROCESS_P dependencies on XTR_DEBUG_PKG

Line 252: -- xtr_debug_pkg.enable_file_debug; -- RV 2293339 issue# 8

248: l_sub_retcode NUMBER := 0; -- Added for 1336492.
249:
250: BEGIN
251:
252: -- xtr_debug_pkg.enable_file_debug; -- RV 2293339 issue# 8
253: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
254: xtr_debug_pkg.debug ('Do_Journal_Process: ' || '>> Do Journal Process.');
255: END IF;
256:

Line 253: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

249:
250: BEGIN
251:
252: -- xtr_debug_pkg.enable_file_debug; -- RV 2293339 issue# 8
253: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
254: xtr_debug_pkg.debug ('Do_Journal_Process: ' || '>> Do Journal Process.');
255: END IF;
256:
257: If (p_source_option is null) then

Line 254: xtr_debug_pkg.debug ('Do_Journal_Process: ' || '>> Do Journal Process.');

250: BEGIN
251:
252: -- xtr_debug_pkg.enable_file_debug; -- RV 2293339 issue# 8
253: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
254: xtr_debug_pkg.debug ('Do_Journal_Process: ' || '>> Do Journal Process.');
255: END IF;
256:
257: If (p_source_option is null) then
258:

Line 279: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

275: Open BATCH_PERIOD;
276: Fetch BATCH_PERIOD into p_period_start, p_period_end, p_upgrade_batch;
277: Close BATCH_PERIOD;
278:
279: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
280: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_company_code = ' || p_company_code);
281: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_curr_batch_id = ' || p_curr_batch_id);
282: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_period_start = ' || p_period_start);
283: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_period_end = ' || p_period_end);

Line 280: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_company_code = ' || p_company_code);

276: Fetch BATCH_PERIOD into p_period_start, p_period_end, p_upgrade_batch;
277: Close BATCH_PERIOD;
278:
279: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
280: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_company_code = ' || p_company_code);
281: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_curr_batch_id = ' || p_curr_batch_id);
282: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_period_start = ' || p_period_start);
283: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_period_end = ' || p_period_end);
284: END IF;

Line 281: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_curr_batch_id = ' || p_curr_batch_id);

277: Close BATCH_PERIOD;
278:
279: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
280: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_company_code = ' || p_company_code);
281: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_curr_batch_id = ' || p_curr_batch_id);
282: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_period_start = ' || p_period_start);
283: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_period_end = ' || p_period_end);
284: END IF;
285:

Line 282: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_period_start = ' || p_period_start);

278:
279: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
280: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_company_code = ' || p_company_code);
281: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_curr_batch_id = ' || p_curr_batch_id);
282: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_period_start = ' || p_period_start);
283: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_period_end = ' || p_period_end);
284: END IF;
285:
286: -- Issue warning if journals have already been generated for the current batch id.

Line 283: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_period_end = ' || p_period_end);

279: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
280: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_company_code = ' || p_company_code);
281: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_curr_batch_id = ' || p_curr_batch_id);
282: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_period_start = ' || p_period_start);
283: xtr_debug_pkg.debug('Do_Journal_Process: ' || 'p_period_end = ' || p_period_end);
284: END IF;
285:
286: -- Issue warning if journals have already been generated for the current batch id.
287: -- Proceed to next batch id in range.

Line 346: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

342: Open FIND_USER(fnd_user_id);
343: Fetch FIND_USER into G_user;
344: Close FIND_USER;
345:
346: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
347: xtr_debug_pkg.debug ('Do_Journal_Process: ' || 'FND_GLOBAL.user_id = ' || to_char(fnd_user_id));
348: END IF;
349: --
350: -- Set sob info.

Line 347: xtr_debug_pkg.debug ('Do_Journal_Process: ' || 'FND_GLOBAL.user_id = ' || to_char(fnd_user_id));

343: Fetch FIND_USER into G_user;
344: Close FIND_USER;
345:
346: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
347: xtr_debug_pkg.debug ('Do_Journal_Process: ' || 'FND_GLOBAL.user_id = ' || to_char(fnd_user_id));
348: END IF;
349: --
350: -- Set sob info.
351: --

Line 377: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

373: else
374: l_retcode := greatest(l_retcode,g_gen_journal_retcode);
375: End If;
376: */
377: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
378: xtr_debug_pkg.debug ('Do_Journal_Process: ' || '<< Do Journal Process.');
379: END IF;
380: -- xtr_debug_pkg.disable_file_debug; -- RV 2293339 issue# 8
381:

Line 378: xtr_debug_pkg.debug ('Do_Journal_Process: ' || '<< Do Journal Process.');

374: l_retcode := greatest(l_retcode,g_gen_journal_retcode);
375: End If;
376: */
377: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
378: xtr_debug_pkg.debug ('Do_Journal_Process: ' || '<< Do Journal Process.');
379: END IF;
380: -- xtr_debug_pkg.disable_file_debug; -- RV 2293339 issue# 8
381:
382: End If; -- (NOT l_warn_flag)

Line 380: -- xtr_debug_pkg.disable_file_debug; -- RV 2293339 issue# 8

376: */
377: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
378: xtr_debug_pkg.debug ('Do_Journal_Process: ' || '<< Do Journal Process.');
379: END IF;
380: -- xtr_debug_pkg.disable_file_debug; -- RV 2293339 issue# 8
381:
382: End If; -- (NOT l_warn_flag)
383:
384: -- Added for flex journals. 2404342. ekl

Line 427: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

423: Open FIND_USER(fnd_user_id);
424: Fetch FIND_USER into G_user;
425: Close FIND_USER;
426:
427: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
428: xtr_debug_pkg.debug ('Do_Journal_Process: ' || 'FND_GLOBAL.user_id = ' || to_char(fnd_user_id));
429: END IF;
430: --
431: -- Set sob info.

Line 428: xtr_debug_pkg.debug ('Do_Journal_Process: ' || 'FND_GLOBAL.user_id = ' || to_char(fnd_user_id));

424: Fetch FIND_USER into G_user;
425: Close FIND_USER;
426:
427: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
428: xtr_debug_pkg.debug ('Do_Journal_Process: ' || 'FND_GLOBAL.user_id = ' || to_char(fnd_user_id));
429: END IF;
430: --
431: -- Set sob info.
432: --

Line 1283: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1279:
1280: -- End 1336492 additions.
1281:
1282: begin
1283: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1284: xtr_debug_pkg.debug('GEN_JOURNALS: ' || '>> Gen Journals.');
1285: END IF;
1286:
1287: -- Begin 1336492 additions.

Line 1284: xtr_debug_pkg.debug('GEN_JOURNALS: ' || '>> Gen Journals.');

1280: -- End 1336492 additions.
1281:
1282: begin
1283: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1284: xtr_debug_pkg.debug('GEN_JOURNALS: ' || '>> Gen Journals.');
1285: END IF;
1286:
1287: -- Begin 1336492 additions.
1288:

Line 1317: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1313:
1314: ----------------------------------------------------------
1315: -- Start processing Q2 for all deal types except 'EXP'.
1316: ----------------------------------------------------------
1317: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1318: xtr_debug_pkg.debug('GEN_JOURNALS: ' || 'Opening Q2');
1319: END IF;
1320:
1321: Open Q2;

Line 1318: xtr_debug_pkg.debug('GEN_JOURNALS: ' || 'Opening Q2');

1314: ----------------------------------------------------------
1315: -- Start processing Q2 for all deal types except 'EXP'.
1316: ----------------------------------------------------------
1317: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1318: xtr_debug_pkg.debug('GEN_JOURNALS: ' || 'Opening Q2');
1319: END IF;
1320:
1321: Open Q2;
1322: Fetch Q2 INTO Q2_REC;

Line 1331: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1327: l_prev_transaction_nbr := Q2_REC.transaction_number;
1328: l_prev_date_type := Q2_REC.date_type;
1329: l_prev_amount_date := Q2_REC.amount_date;
1330:
1331: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1332: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q2 loop.');
1333: END IF;
1334:
1335: WHILE Q2%FOUND LOOP

Line 1332: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q2 loop.');

1328: l_prev_date_type := Q2_REC.date_type;
1329: l_prev_amount_date := Q2_REC.amount_date;
1330:
1331: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1332: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q2 loop.');
1333: END IF;
1334:
1335: WHILE Q2%FOUND LOOP
1336:

Line 1337: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1333: END IF;
1334:
1335: WHILE Q2%FOUND LOOP
1336:
1337: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1338: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q2_REC.company_code);
1339: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q2_REC.deal_type);
1340: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q2_REC.deal_number));
1341: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q2_REC.transaction_number));

Line 1338: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q2_REC.company_code);

1334:
1335: WHILE Q2%FOUND LOOP
1336:
1337: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1338: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q2_REC.company_code);
1339: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q2_REC.deal_type);
1340: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q2_REC.deal_number));
1341: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q2_REC.transaction_number));
1342: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q2_REC.amount_date,'MM/DD/RRRR'));

Line 1339: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q2_REC.deal_type);

1335: WHILE Q2%FOUND LOOP
1336:
1337: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1338: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q2_REC.company_code);
1339: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q2_REC.deal_type);
1340: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q2_REC.deal_number));
1341: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q2_REC.transaction_number));
1342: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q2_REC.amount_date,'MM/DD/RRRR'));
1343: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q2_REC.currency);

Line 1340: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q2_REC.deal_number));

1336:
1337: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1338: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q2_REC.company_code);
1339: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q2_REC.deal_type);
1340: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q2_REC.deal_number));
1341: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q2_REC.transaction_number));
1342: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q2_REC.amount_date,'MM/DD/RRRR'));
1343: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q2_REC.currency);
1344: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q2_REC.deal_subtype);

Line 1341: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q2_REC.transaction_number));

1337: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1338: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q2_REC.company_code);
1339: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q2_REC.deal_type);
1340: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q2_REC.deal_number));
1341: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q2_REC.transaction_number));
1342: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q2_REC.amount_date,'MM/DD/RRRR'));
1343: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q2_REC.currency);
1344: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q2_REC.deal_subtype);
1345: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q2_REC.product_type);

Line 1342: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q2_REC.amount_date,'MM/DD/RRRR'));

1338: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q2_REC.company_code);
1339: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q2_REC.deal_type);
1340: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q2_REC.deal_number));
1341: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q2_REC.transaction_number));
1342: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q2_REC.amount_date,'MM/DD/RRRR'));
1343: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q2_REC.currency);
1344: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q2_REC.deal_subtype);
1345: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q2_REC.product_type);
1346: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q2_REC.portfolio_code);

Line 1343: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q2_REC.currency);

1339: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q2_REC.deal_type);
1340: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q2_REC.deal_number));
1341: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q2_REC.transaction_number));
1342: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q2_REC.amount_date,'MM/DD/RRRR'));
1343: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q2_REC.currency);
1344: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q2_REC.deal_subtype);
1345: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q2_REC.product_type);
1346: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q2_REC.portfolio_code);
1347: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q2_REC.date_type);

Line 1344: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q2_REC.deal_subtype);

1340: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q2_REC.deal_number));
1341: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q2_REC.transaction_number));
1342: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q2_REC.amount_date,'MM/DD/RRRR'));
1343: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q2_REC.currency);
1344: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q2_REC.deal_subtype);
1345: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q2_REC.product_type);
1346: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q2_REC.portfolio_code);
1347: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q2_REC.date_type);
1348: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q2_REC.amount_type);

Line 1345: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q2_REC.product_type);

1341: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q2_REC.transaction_number));
1342: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q2_REC.amount_date,'MM/DD/RRRR'));
1343: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q2_REC.currency);
1344: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q2_REC.deal_subtype);
1345: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q2_REC.product_type);
1346: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q2_REC.portfolio_code);
1347: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q2_REC.date_type);
1348: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q2_REC.amount_type);
1349: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q2_REC.dr_amount));

Line 1346: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q2_REC.portfolio_code);

1342: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q2_REC.amount_date,'MM/DD/RRRR'));
1343: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q2_REC.currency);
1344: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q2_REC.deal_subtype);
1345: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q2_REC.product_type);
1346: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q2_REC.portfolio_code);
1347: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q2_REC.date_type);
1348: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q2_REC.amount_type);
1349: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q2_REC.dr_amount));
1350: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q2_REC.cr_amount));

Line 1347: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q2_REC.date_type);

1343: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q2_REC.currency);
1344: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q2_REC.deal_subtype);
1345: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q2_REC.product_type);
1346: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q2_REC.portfolio_code);
1347: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q2_REC.date_type);
1348: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q2_REC.amount_type);
1349: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q2_REC.dr_amount));
1350: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q2_REC.cr_amount));
1351: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q2_REC.ccid));

Line 1348: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q2_REC.amount_type);

1344: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q2_REC.deal_subtype);
1345: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q2_REC.product_type);
1346: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q2_REC.portfolio_code);
1347: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q2_REC.date_type);
1348: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q2_REC.amount_type);
1349: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q2_REC.dr_amount));
1350: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q2_REC.cr_amount));
1351: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q2_REC.ccid));
1352: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Client Clr Acct = ' || Q2_REC.client_broker_clracct);

Line 1349: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q2_REC.dr_amount));

1345: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q2_REC.product_type);
1346: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q2_REC.portfolio_code);
1347: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q2_REC.date_type);
1348: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q2_REC.amount_type);
1349: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q2_REC.dr_amount));
1350: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q2_REC.cr_amount));
1351: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q2_REC.ccid));
1352: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Client Clr Acct = ' || Q2_REC.client_broker_clracct);
1353: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement Number = ' || to_char(Q2_REC.settlement_number));

Line 1350: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q2_REC.cr_amount));

1346: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q2_REC.portfolio_code);
1347: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q2_REC.date_type);
1348: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q2_REC.amount_type);
1349: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q2_REC.dr_amount));
1350: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q2_REC.cr_amount));
1351: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q2_REC.ccid));
1352: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Client Clr Acct = ' || Q2_REC.client_broker_clracct);
1353: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement Number = ' || to_char(Q2_REC.settlement_number));
1354: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Prin CCID flag = ' || Q2_REC.use_prin_ccid_flag);

Line 1351: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q2_REC.ccid));

1347: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q2_REC.date_type);
1348: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q2_REC.amount_type);
1349: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q2_REC.dr_amount));
1350: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q2_REC.cr_amount));
1351: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q2_REC.ccid));
1352: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Client Clr Acct = ' || Q2_REC.client_broker_clracct);
1353: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement Number = ' || to_char(Q2_REC.settlement_number));
1354: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Prin CCID flag = ' || Q2_REC.use_prin_ccid_flag);
1355: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Int CCID flag = ' || Q2_REC.use_int_ccid_flag);

Line 1352: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Client Clr Acct = ' || Q2_REC.client_broker_clracct);

1348: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q2_REC.amount_type);
1349: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q2_REC.dr_amount));
1350: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q2_REC.cr_amount));
1351: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q2_REC.ccid));
1352: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Client Clr Acct = ' || Q2_REC.client_broker_clracct);
1353: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement Number = ' || to_char(Q2_REC.settlement_number));
1354: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Prin CCID flag = ' || Q2_REC.use_prin_ccid_flag);
1355: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Int CCID flag = ' || Q2_REC.use_int_ccid_flag);
1356: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Bank Acct Nbr = ' || Q2_REC.cparty_account_no);

Line 1353: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement Number = ' || to_char(Q2_REC.settlement_number));

1349: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q2_REC.dr_amount));
1350: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q2_REC.cr_amount));
1351: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q2_REC.ccid));
1352: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Client Clr Acct = ' || Q2_REC.client_broker_clracct);
1353: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement Number = ' || to_char(Q2_REC.settlement_number));
1354: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Prin CCID flag = ' || Q2_REC.use_prin_ccid_flag);
1355: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Int CCID flag = ' || Q2_REC.use_int_ccid_flag);
1356: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Bank Acct Nbr = ' || Q2_REC.cparty_account_no);
1357: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Code = ' || Q2_REC.cparty_code);

Line 1354: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Prin CCID flag = ' || Q2_REC.use_prin_ccid_flag);

1350: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q2_REC.cr_amount));
1351: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q2_REC.ccid));
1352: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Client Clr Acct = ' || Q2_REC.client_broker_clracct);
1353: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement Number = ' || to_char(Q2_REC.settlement_number));
1354: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Prin CCID flag = ' || Q2_REC.use_prin_ccid_flag);
1355: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Int CCID flag = ' || Q2_REC.use_int_ccid_flag);
1356: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Bank Acct Nbr = ' || Q2_REC.cparty_account_no);
1357: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Code = ' || Q2_REC.cparty_code);
1358: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q2_REC.action_code);

Line 1355: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Int CCID flag = ' || Q2_REC.use_int_ccid_flag);

1351: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q2_REC.ccid));
1352: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Client Clr Acct = ' || Q2_REC.client_broker_clracct);
1353: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement Number = ' || to_char(Q2_REC.settlement_number));
1354: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Prin CCID flag = ' || Q2_REC.use_prin_ccid_flag);
1355: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Int CCID flag = ' || Q2_REC.use_int_ccid_flag);
1356: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Bank Acct Nbr = ' || Q2_REC.cparty_account_no);
1357: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Code = ' || Q2_REC.cparty_code);
1358: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q2_REC.action_code);
1359: END IF;

Line 1356: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Bank Acct Nbr = ' || Q2_REC.cparty_account_no);

1352: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Client Clr Acct = ' || Q2_REC.client_broker_clracct);
1353: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement Number = ' || to_char(Q2_REC.settlement_number));
1354: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Prin CCID flag = ' || Q2_REC.use_prin_ccid_flag);
1355: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Int CCID flag = ' || Q2_REC.use_int_ccid_flag);
1356: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Bank Acct Nbr = ' || Q2_REC.cparty_account_no);
1357: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Code = ' || Q2_REC.cparty_code);
1358: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q2_REC.action_code);
1359: END IF;
1360:

Line 1357: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Code = ' || Q2_REC.cparty_code);

1353: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement Number = ' || to_char(Q2_REC.settlement_number));
1354: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Prin CCID flag = ' || Q2_REC.use_prin_ccid_flag);
1355: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Int CCID flag = ' || Q2_REC.use_int_ccid_flag);
1356: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Bank Acct Nbr = ' || Q2_REC.cparty_account_no);
1357: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Code = ' || Q2_REC.cparty_code);
1358: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q2_REC.action_code);
1359: END IF;
1360:
1361: -- Begin bug 1336492 additions.

Line 1358: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q2_REC.action_code);

1354: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Prin CCID flag = ' || Q2_REC.use_prin_ccid_flag);
1355: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Use Int CCID flag = ' || Q2_REC.use_int_ccid_flag);
1356: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Bank Acct Nbr = ' || Q2_REC.cparty_account_no);
1357: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Cpty Code = ' || Q2_REC.cparty_code);
1358: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q2_REC.action_code);
1359: END IF;
1360:
1361: -- Begin bug 1336492 additions.
1362: -- Added condition to prevent cashflow entry creation when deal has not been validated and

Line 1614: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1610: Q2_REC.transaction_number <> nvl(l_prev_transaction_nbr,-1) or
1611: Q2_REC.date_type <> nvl(l_prev_date_type,'@@@@@@@') or
1612: Q2_REC.amount_date <> l_prev_amount_date) then
1613:
1614: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1615: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Change in deal type, deal #, trans #, date type, or amt date.');
1616: END IF;
1617:
1618: --1336492 If (nvl(l_error_flag,'N') <> 'Y') then

Line 1615: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Change in deal type, deal #, trans #, date type, or amt date.');

1611: Q2_REC.date_type <> nvl(l_prev_date_type,'@@@@@@@') or
1612: Q2_REC.amount_date <> l_prev_amount_date) then
1613:
1614: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1615: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Change in deal type, deal #, trans #, date type, or amt date.');
1616: END IF;
1617:
1618: --1336492 If (nvl(l_error_flag,'N') <> 'Y') then
1619:

Line 1623: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1619:
1620: -- 1336492 modification, replaces above l_error_flag condition.
1621: If (nvl(l_updt_flag,'Y') = 'Y') then
1622:
1623: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1624: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Update DDA journal created flag.');
1625: END IF;
1626:
1627: -- Update DDA to put BATCH_ID value once journal is generated

Line 1624: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Update DDA journal created flag.');

1620: -- 1336492 modification, replaces above l_error_flag condition.
1621: If (nvl(l_updt_flag,'Y') = 'Y') then
1622:
1623: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1624: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Update DDA journal created flag.');
1625: END IF;
1626:
1627: -- Update DDA to put BATCH_ID value once journal is generated
1628:

Line 1651: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1647: Else
1648: -- Begin 1336492 additions.
1649: -- Deal/Trans not validated, bypass journal creation for this group of deal type, deal nbr, and trans nbr.
1650:
1651: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1652: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal/Trans not validated. Bypass entry creation.');
1653: END IF;
1654:
1655: --1336492 l_error_flag := 'Y';

Line 1652: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal/Trans not validated. Bypass entry creation.');

1648: -- Begin 1336492 additions.
1649: -- Deal/Trans not validated, bypass journal creation for this group of deal type, deal nbr, and trans nbr.
1650:
1651: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1652: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal/Trans not validated. Bypass entry creation.');
1653: END IF;
1654:
1655: --1336492 l_error_flag := 'Y';
1656:

Line 1684: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1680: End If; -- deal/trans validated or no validation required.
1681: END LOOP;
1682: Close Q2;
1683:
1684: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1685: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Exiting Q2.');
1686: END IF;
1687:
1688: --1336492 If (l_prev_deal_nbr is NOT NULL and nvl(l_error_flag,'N') <> 'Y') then

Line 1685: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Exiting Q2.');

1681: END LOOP;
1682: Close Q2;
1683:
1684: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1685: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Exiting Q2.');
1686: END IF;
1687:
1688: --1336492 If (l_prev_deal_nbr is NOT NULL and nvl(l_error_flag,'N') <> 'Y') then
1689:

Line 1694: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1690: -- 1336492.
1691: -- Modified condition to use l_updt_flag instead of l_error_flag.
1692: If (l_prev_deal_nbr is NOT NULL and nvl(l_updt_flag,'Y') = 'Y') then
1693:
1694: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1695: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Update last batch of Q2 data.');
1696: END IF;
1697:
1698: Update XTR_DEAL_DATE_AMOUNTS

Line 1695: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Update last batch of Q2 data.');

1691: -- Modified condition to use l_updt_flag instead of l_error_flag.
1692: If (l_prev_deal_nbr is NOT NULL and nvl(l_updt_flag,'Y') = 'Y') then
1693:
1694: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1695: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Update last batch of Q2 data.');
1696: END IF;
1697:
1698: Update XTR_DEAL_DATE_AMOUNTS
1699: set batch_id = l_batch_id

Line 1736: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1732: Fetch Q3 INTO Q3_REC;
1733:
1734: l_batch_id := in_batch_id;
1735:
1736: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1737: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q3 loop.');
1738: END IF;
1739:
1740: While Q3%FOUND LOOP

Line 1737: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q3 loop.');

1733:
1734: l_batch_id := in_batch_id;
1735:
1736: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1737: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q3 loop.');
1738: END IF;
1739:
1740: While Q3%FOUND LOOP
1741: --

Line 1742: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

1738: END IF;
1739:
1740: While Q3%FOUND LOOP
1741: --
1742: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1743: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q3_REC.company_code);
1744: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q3_REC.deal_type);
1745: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q3_REC.deal_number));
1746: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q3_REC.trans_number));

Line 1743: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q3_REC.company_code);

1739:
1740: While Q3%FOUND LOOP
1741: --
1742: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1743: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q3_REC.company_code);
1744: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q3_REC.deal_type);
1745: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q3_REC.deal_number));
1746: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q3_REC.trans_number));
1747: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q3_REC.amount_date,'MM/DD/RRRR'));

Line 1744: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q3_REC.deal_type);

1740: While Q3%FOUND LOOP
1741: --
1742: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1743: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q3_REC.company_code);
1744: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q3_REC.deal_type);
1745: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q3_REC.deal_number));
1746: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q3_REC.trans_number));
1747: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q3_REC.amount_date,'MM/DD/RRRR'));
1748: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q3_REC.currency);

Line 1745: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q3_REC.deal_number));

1741: --
1742: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1743: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q3_REC.company_code);
1744: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q3_REC.deal_type);
1745: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q3_REC.deal_number));
1746: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q3_REC.trans_number));
1747: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q3_REC.amount_date,'MM/DD/RRRR'));
1748: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q3_REC.currency);
1749: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q3_REC.deal_subtype);

Line 1746: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q3_REC.trans_number));

1742: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1743: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q3_REC.company_code);
1744: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q3_REC.deal_type);
1745: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q3_REC.deal_number));
1746: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q3_REC.trans_number));
1747: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q3_REC.amount_date,'MM/DD/RRRR'));
1748: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q3_REC.currency);
1749: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q3_REC.deal_subtype);
1750: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q3_REC.product_type);

Line 1747: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q3_REC.amount_date,'MM/DD/RRRR'));

1743: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q3_REC.company_code);
1744: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q3_REC.deal_type);
1745: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q3_REC.deal_number));
1746: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q3_REC.trans_number));
1747: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q3_REC.amount_date,'MM/DD/RRRR'));
1748: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q3_REC.currency);
1749: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q3_REC.deal_subtype);
1750: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q3_REC.product_type);
1751: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q3_REC.amount_type);

Line 1748: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q3_REC.currency);

1744: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q3_REC.deal_type);
1745: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q3_REC.deal_number));
1746: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q3_REC.trans_number));
1747: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q3_REC.amount_date,'MM/DD/RRRR'));
1748: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q3_REC.currency);
1749: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q3_REC.deal_subtype);
1750: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q3_REC.product_type);
1751: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q3_REC.amount_type);
1752: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q3_REC.debit_amount));

Line 1749: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q3_REC.deal_subtype);

1745: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q3_REC.deal_number));
1746: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q3_REC.trans_number));
1747: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q3_REC.amount_date,'MM/DD/RRRR'));
1748: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q3_REC.currency);
1749: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q3_REC.deal_subtype);
1750: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q3_REC.product_type);
1751: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q3_REC.amount_type);
1752: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q3_REC.debit_amount));
1753: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q3_REC.credit_amount));

Line 1750: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q3_REC.product_type);

1746: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q3_REC.trans_number));
1747: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q3_REC.amount_date,'MM/DD/RRRR'));
1748: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q3_REC.currency);
1749: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q3_REC.deal_subtype);
1750: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q3_REC.product_type);
1751: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q3_REC.amount_type);
1752: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q3_REC.debit_amount));
1753: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q3_REC.credit_amount));
1754: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q3_REC.type_ccid));

Line 1751: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q3_REC.amount_type);

1747: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q3_REC.amount_date,'MM/DD/RRRR'));
1748: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q3_REC.currency);
1749: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q3_REC.deal_subtype);
1750: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q3_REC.product_type);
1751: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q3_REC.amount_type);
1752: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q3_REC.debit_amount));
1753: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q3_REC.credit_amount));
1754: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q3_REC.type_ccid));
1755: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Bank CCID = ' || to_char(Q3_REC.bank_ccid));

Line 1752: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q3_REC.debit_amount));

1748: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q3_REC.currency);
1749: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q3_REC.deal_subtype);
1750: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q3_REC.product_type);
1751: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q3_REC.amount_type);
1752: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q3_REC.debit_amount));
1753: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q3_REC.credit_amount));
1754: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q3_REC.type_ccid));
1755: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Bank CCID = ' || to_char(Q3_REC.bank_ccid));
1756: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement # = ' || to_char(Q3_REC.settlement_number));

Line 1753: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q3_REC.credit_amount));

1749: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q3_REC.deal_subtype);
1750: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q3_REC.product_type);
1751: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q3_REC.amount_type);
1752: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q3_REC.debit_amount));
1753: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q3_REC.credit_amount));
1754: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q3_REC.type_ccid));
1755: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Bank CCID = ' || to_char(Q3_REC.bank_ccid));
1756: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement # = ' || to_char(Q3_REC.settlement_number));
1757: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q3_REC.date_type);

Line 1754: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q3_REC.type_ccid));

1750: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q3_REC.product_type);
1751: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q3_REC.amount_type);
1752: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q3_REC.debit_amount));
1753: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q3_REC.credit_amount));
1754: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q3_REC.type_ccid));
1755: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Bank CCID = ' || to_char(Q3_REC.bank_ccid));
1756: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement # = ' || to_char(Q3_REC.settlement_number));
1757: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q3_REC.date_type);
1758: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q3_REC.action_code);

Line 1755: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Bank CCID = ' || to_char(Q3_REC.bank_ccid));

1751: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q3_REC.amount_type);
1752: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q3_REC.debit_amount));
1753: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q3_REC.credit_amount));
1754: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q3_REC.type_ccid));
1755: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Bank CCID = ' || to_char(Q3_REC.bank_ccid));
1756: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement # = ' || to_char(Q3_REC.settlement_number));
1757: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q3_REC.date_type);
1758: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q3_REC.action_code);
1759: END IF;

Line 1756: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement # = ' || to_char(Q3_REC.settlement_number));

1752: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Debit Amount = ' || to_char(Q3_REC.debit_amount));
1753: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q3_REC.credit_amount));
1754: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q3_REC.type_ccid));
1755: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Bank CCID = ' || to_char(Q3_REC.bank_ccid));
1756: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement # = ' || to_char(Q3_REC.settlement_number));
1757: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q3_REC.date_type);
1758: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q3_REC.action_code);
1759: END IF;
1760:

Line 1757: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q3_REC.date_type);

1753: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Credit Amount = ' || to_char(Q3_REC.credit_amount));
1754: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q3_REC.type_ccid));
1755: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Bank CCID = ' || to_char(Q3_REC.bank_ccid));
1756: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement # = ' || to_char(Q3_REC.settlement_number));
1757: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q3_REC.date_type);
1758: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q3_REC.action_code);
1759: END IF;
1760:
1761: -- 1336492 additions.

Line 1758: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q3_REC.action_code);

1754: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q3_REC.type_ccid));
1755: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Bank CCID = ' || to_char(Q3_REC.bank_ccid));
1756: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Settlement # = ' || to_char(Q3_REC.settlement_number));
1757: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q3_REC.date_type);
1758: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q3_REC.action_code);
1759: END IF;
1760:
1761: -- 1336492 additions.
1762: -- Added logic to determine validation status of EXP transaction.

Line 2060: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

2056: Fetch Q4 INTO Q4_REC;
2057:
2058: l_prev_rowid := l_row_id;
2059:
2060: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2061: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q4 loop.');
2062: END IF;
2063:
2064: While Q4%FOUND LOOP

Line 2061: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q4 loop.');

2057:
2058: l_prev_rowid := l_row_id;
2059:
2060: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2061: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q4 loop.');
2062: END IF;
2063:
2064: While Q4%FOUND LOOP
2065: --

Line 2066: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

2062: END IF;
2063:
2064: While Q4%FOUND LOOP
2065: --
2066: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2067: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q4_REC.company_code);
2068: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q4_REC.deal_type);
2069: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q4_REC.deal_number));
2070: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q4_REC.trans_number));

Line 2067: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q4_REC.company_code);

2063:
2064: While Q4%FOUND LOOP
2065: --
2066: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2067: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q4_REC.company_code);
2068: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q4_REC.deal_type);
2069: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q4_REC.deal_number));
2070: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q4_REC.trans_number));
2071: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q4_REC.amount_date,'MM/DD/RRRR'));

Line 2068: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q4_REC.deal_type);

2064: While Q4%FOUND LOOP
2065: --
2066: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2067: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q4_REC.company_code);
2068: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q4_REC.deal_type);
2069: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q4_REC.deal_number));
2070: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q4_REC.trans_number));
2071: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q4_REC.amount_date,'MM/DD/RRRR'));
2072: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q4_REC.currency);

Line 2069: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q4_REC.deal_number));

2065: --
2066: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2067: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q4_REC.company_code);
2068: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q4_REC.deal_type);
2069: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q4_REC.deal_number));
2070: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q4_REC.trans_number));
2071: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q4_REC.amount_date,'MM/DD/RRRR'));
2072: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q4_REC.currency);
2073: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q4_REC.deal_subtype);

Line 2070: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q4_REC.trans_number));

2066: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2067: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q4_REC.company_code);
2068: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q4_REC.deal_type);
2069: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q4_REC.deal_number));
2070: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q4_REC.trans_number));
2071: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q4_REC.amount_date,'MM/DD/RRRR'));
2072: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q4_REC.currency);
2073: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q4_REC.deal_subtype);
2074: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q4_REC.product_type);

Line 2071: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q4_REC.amount_date,'MM/DD/RRRR'));

2067: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q4_REC.company_code);
2068: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q4_REC.deal_type);
2069: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q4_REC.deal_number));
2070: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q4_REC.trans_number));
2071: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q4_REC.amount_date,'MM/DD/RRRR'));
2072: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q4_REC.currency);
2073: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q4_REC.deal_subtype);
2074: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q4_REC.product_type);
2075: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q4_REC.portfolio_code);

Line 2072: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q4_REC.currency);

2068: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q4_REC.deal_type);
2069: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q4_REC.deal_number));
2070: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q4_REC.trans_number));
2071: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q4_REC.amount_date,'MM/DD/RRRR'));
2072: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q4_REC.currency);
2073: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q4_REC.deal_subtype);
2074: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q4_REC.product_type);
2075: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q4_REC.portfolio_code);
2076: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q4_REC.amount_type);

Line 2073: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q4_REC.deal_subtype);

2069: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q4_REC.deal_number));
2070: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q4_REC.trans_number));
2071: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q4_REC.amount_date,'MM/DD/RRRR'));
2072: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q4_REC.currency);
2073: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q4_REC.deal_subtype);
2074: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q4_REC.product_type);
2075: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q4_REC.portfolio_code);
2076: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q4_REC.amount_type);
2077: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount = ' || to_char(Q4_REC.accrls_amount));

Line 2074: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q4_REC.product_type);

2070: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q4_REC.trans_number));
2071: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q4_REC.amount_date,'MM/DD/RRRR'));
2072: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q4_REC.currency);
2073: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q4_REC.deal_subtype);
2074: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q4_REC.product_type);
2075: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q4_REC.portfolio_code);
2076: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q4_REC.amount_type);
2077: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount = ' || to_char(Q4_REC.accrls_amount));
2078: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q4_REC.credit_or_debit);

Line 2075: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q4_REC.portfolio_code);

2071: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q4_REC.amount_date,'MM/DD/RRRR'));
2072: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q4_REC.currency);
2073: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q4_REC.deal_subtype);
2074: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q4_REC.product_type);
2075: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q4_REC.portfolio_code);
2076: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q4_REC.amount_type);
2077: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount = ' || to_char(Q4_REC.accrls_amount));
2078: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q4_REC.credit_or_debit);
2079: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q4_REC.ccid));

Line 2076: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q4_REC.amount_type);

2072: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q4_REC.currency);
2073: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q4_REC.deal_subtype);
2074: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q4_REC.product_type);
2075: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q4_REC.portfolio_code);
2076: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q4_REC.amount_type);
2077: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount = ' || to_char(Q4_REC.accrls_amount));
2078: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q4_REC.credit_or_debit);
2079: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q4_REC.ccid));
2080: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q4_REC.date_type);

Line 2077: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount = ' || to_char(Q4_REC.accrls_amount));

2073: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q4_REC.deal_subtype);
2074: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q4_REC.product_type);
2075: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q4_REC.portfolio_code);
2076: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q4_REC.amount_type);
2077: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount = ' || to_char(Q4_REC.accrls_amount));
2078: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q4_REC.credit_or_debit);
2079: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q4_REC.ccid));
2080: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q4_REC.date_type);
2081: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q4_REC.action_code);

Line 2078: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q4_REC.credit_or_debit);

2074: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q4_REC.product_type);
2075: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q4_REC.portfolio_code);
2076: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q4_REC.amount_type);
2077: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount = ' || to_char(Q4_REC.accrls_amount));
2078: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q4_REC.credit_or_debit);
2079: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q4_REC.ccid));
2080: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q4_REC.date_type);
2081: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q4_REC.action_code);
2082: END IF;

Line 2079: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q4_REC.ccid));

2075: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q4_REC.portfolio_code);
2076: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q4_REC.amount_type);
2077: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount = ' || to_char(Q4_REC.accrls_amount));
2078: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q4_REC.credit_or_debit);
2079: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q4_REC.ccid));
2080: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q4_REC.date_type);
2081: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q4_REC.action_code);
2082: END IF;
2083:

Line 2080: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q4_REC.date_type);

2076: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q4_REC.amount_type);
2077: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount = ' || to_char(Q4_REC.accrls_amount));
2078: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q4_REC.credit_or_debit);
2079: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q4_REC.ccid));
2080: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q4_REC.date_type);
2081: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q4_REC.action_code);
2082: END IF;
2083:
2084: If (Q4_REC.accrls_amount = 0) then

Line 2081: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q4_REC.action_code);

2077: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount = ' || to_char(Q4_REC.accrls_amount));
2078: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q4_REC.credit_or_debit);
2079: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q4_REC.ccid));
2080: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q4_REC.date_type);
2081: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q4_REC.action_code);
2082: END IF;
2083:
2084: If (Q4_REC.accrls_amount = 0) then
2085: NULL;

Line 2253: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

2249: Fetch Q5 INTO Q5_REC;
2250:
2251: l_prev_rowid := l_row_id;
2252:
2253: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2254: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q5 loop.');
2255: END IF;
2256:
2257: While Q5%FOUND LOOP

Line 2254: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q5 loop.');

2250:
2251: l_prev_rowid := l_row_id;
2252:
2253: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2254: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q5 loop.');
2255: END IF;
2256:
2257: While Q5%FOUND LOOP
2258: --

Line 2259: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

2255: END IF;
2256:
2257: While Q5%FOUND LOOP
2258: --
2259: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2260: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q5_REC.company_code);
2261: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q5_REC.deal_type);
2262: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q5_REC.deal_number));
2263: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q5_REC.trans_number));

Line 2260: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q5_REC.company_code);

2256:
2257: While Q5%FOUND LOOP
2258: --
2259: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2260: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q5_REC.company_code);
2261: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q5_REC.deal_type);
2262: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q5_REC.deal_number));
2263: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q5_REC.trans_number));
2264: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q5_REC.journal_date,'MM/DD/RRRR'));

Line 2261: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q5_REC.deal_type);

2257: While Q5%FOUND LOOP
2258: --
2259: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2260: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q5_REC.company_code);
2261: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q5_REC.deal_type);
2262: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q5_REC.deal_number));
2263: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q5_REC.trans_number));
2264: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q5_REC.journal_date,'MM/DD/RRRR'));
2265: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q5_REC.reval_currency);

Line 2262: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q5_REC.deal_number));

2258: --
2259: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2260: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q5_REC.company_code);
2261: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q5_REC.deal_type);
2262: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q5_REC.deal_number));
2263: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q5_REC.trans_number));
2264: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q5_REC.journal_date,'MM/DD/RRRR'));
2265: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q5_REC.reval_currency);
2266: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q5_REC.deal_subtype);

Line 2263: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q5_REC.trans_number));

2259: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2260: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q5_REC.company_code);
2261: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q5_REC.deal_type);
2262: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q5_REC.deal_number));
2263: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q5_REC.trans_number));
2264: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q5_REC.journal_date,'MM/DD/RRRR'));
2265: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q5_REC.reval_currency);
2266: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q5_REC.deal_subtype);
2267: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q5_REC.product_type);

Line 2264: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q5_REC.journal_date,'MM/DD/RRRR'));

2260: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Company Code = ' || Q5_REC.company_code);
2261: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q5_REC.deal_type);
2262: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q5_REC.deal_number));
2263: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q5_REC.trans_number));
2264: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q5_REC.journal_date,'MM/DD/RRRR'));
2265: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q5_REC.reval_currency);
2266: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q5_REC.deal_subtype);
2267: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q5_REC.product_type);
2268: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q5_REC.portfolio_code);

Line 2265: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q5_REC.reval_currency);

2261: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Type = ' || Q5_REC.deal_type);
2262: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q5_REC.deal_number));
2263: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q5_REC.trans_number));
2264: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q5_REC.journal_date,'MM/DD/RRRR'));
2265: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q5_REC.reval_currency);
2266: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q5_REC.deal_subtype);
2267: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q5_REC.product_type);
2268: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q5_REC.portfolio_code);
2269: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q5_REC.amount_type);

Line 2266: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q5_REC.deal_subtype);

2262: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Number = ' || to_char(Q5_REC.deal_number));
2263: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q5_REC.trans_number));
2264: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q5_REC.journal_date,'MM/DD/RRRR'));
2265: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q5_REC.reval_currency);
2266: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q5_REC.deal_subtype);
2267: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q5_REC.product_type);
2268: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q5_REC.portfolio_code);
2269: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q5_REC.amount_type);
2270: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q5_REC.action_code);

Line 2267: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q5_REC.product_type);

2263: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Transaction Nbr = ' || to_char(Q5_REC.trans_number));
2264: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q5_REC.journal_date,'MM/DD/RRRR'));
2265: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q5_REC.reval_currency);
2266: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q5_REC.deal_subtype);
2267: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q5_REC.product_type);
2268: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q5_REC.portfolio_code);
2269: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q5_REC.amount_type);
2270: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q5_REC.action_code);
2271: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = ' || to_char(Q5_REC.amount));

Line 2268: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q5_REC.portfolio_code);

2264: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Date = ' || to_char(Q5_REC.journal_date,'MM/DD/RRRR'));
2265: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q5_REC.reval_currency);
2266: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q5_REC.deal_subtype);
2267: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q5_REC.product_type);
2268: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q5_REC.portfolio_code);
2269: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q5_REC.amount_type);
2270: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q5_REC.action_code);
2271: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = ' || to_char(Q5_REC.amount));
2272: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q5_REC.ccid));

Line 2269: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q5_REC.amount_type);

2265: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Currency = ' || Q5_REC.reval_currency);
2266: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q5_REC.deal_subtype);
2267: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q5_REC.product_type);
2268: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q5_REC.portfolio_code);
2269: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q5_REC.amount_type);
2270: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q5_REC.action_code);
2271: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = ' || to_char(Q5_REC.amount));
2272: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q5_REC.ccid));
2273: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q5_REC.credit_or_debit);

Line 2270: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q5_REC.action_code);

2266: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Deal Subtype = ' || Q5_REC.deal_subtype);
2267: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q5_REC.product_type);
2268: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q5_REC.portfolio_code);
2269: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q5_REC.amount_type);
2270: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q5_REC.action_code);
2271: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = ' || to_char(Q5_REC.amount));
2272: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q5_REC.ccid));
2273: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q5_REC.credit_or_debit);
2274: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q5_REC.date_type);

Line 2271: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = ' || to_char(Q5_REC.amount));

2267: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Product Type = ' || Q5_REC.product_type);
2268: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q5_REC.portfolio_code);
2269: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q5_REC.amount_type);
2270: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q5_REC.action_code);
2271: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = ' || to_char(Q5_REC.amount));
2272: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q5_REC.ccid));
2273: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q5_REC.credit_or_debit);
2274: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q5_REC.date_type);
2275: END IF;

Line 2272: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q5_REC.ccid));

2268: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Portfolio = ' || Q5_REC.portfolio_code);
2269: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q5_REC.amount_type);
2270: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q5_REC.action_code);
2271: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = ' || to_char(Q5_REC.amount));
2272: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q5_REC.ccid));
2273: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q5_REC.credit_or_debit);
2274: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q5_REC.date_type);
2275: END IF;
2276:

Line 2273: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q5_REC.credit_or_debit);

2269: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Amount Type = ' || Q5_REC.amount_type);
2270: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q5_REC.action_code);
2271: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = ' || to_char(Q5_REC.amount));
2272: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q5_REC.ccid));
2273: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q5_REC.credit_or_debit);
2274: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q5_REC.date_type);
2275: END IF;
2276:
2277: If (nvl(Q5_REC.amount,0) = 0) then

Line 2274: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q5_REC.date_type);

2270: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = ' || Q5_REC.action_code);
2271: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = ' || to_char(Q5_REC.amount));
2272: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = ' || to_char(Q5_REC.ccid));
2273: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = ' || Q5_REC.credit_or_debit);
2274: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = ' || Q5_REC.date_type);
2275: END IF;
2276:
2277: If (nvl(Q5_REC.amount,0) = 0) then
2278: NULL;

Line 2532: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

2528: Fetch Q6 INTO Q6_REC;
2529:
2530: l_prev_rowid := l_row_id;
2531:
2532: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2533: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q6 loop.');
2534: END IF;
2535:
2536: While Q6%FOUND LOOP

Line 2533: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q6 loop.');

2529:
2530: l_prev_rowid := l_row_id;
2531:
2532: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2533: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q6 loop.');
2534: END IF;
2535:
2536: While Q6%FOUND LOOP
2537: If nvl(l_q6_deal_no, -1) <> Q6_REC.deal_number then

Line 2577: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

2573: and l_CCYREAL = TRUE)) then
2574: NULL; -- Do not process this Revaluations record
2575: Else -- existing code
2576:
2577: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2578: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q6_REC.company_code);
2579: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q6_REC.deal_type);
2580: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q6_REC.deal_number));
2581: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q6_REC.trans_number));

Line 2578: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q6_REC.company_code);

2574: NULL; -- Do not process this Revaluations record
2575: Else -- existing code
2576:
2577: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2578: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q6_REC.company_code);
2579: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q6_REC.deal_type);
2580: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q6_REC.deal_number));
2581: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q6_REC.trans_number));
2582: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q6_REC.journal_date,'MM/DD/RRRR'));

Line 2579: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q6_REC.deal_type);

2575: Else -- existing code
2576:
2577: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2578: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q6_REC.company_code);
2579: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q6_REC.deal_type);
2580: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q6_REC.deal_number));
2581: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q6_REC.trans_number));
2582: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q6_REC.journal_date,'MM/DD/RRRR'));
2583: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q6_REC.reval_currency);

Line 2580: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q6_REC.deal_number));

2576:
2577: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2578: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q6_REC.company_code);
2579: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q6_REC.deal_type);
2580: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q6_REC.deal_number));
2581: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q6_REC.trans_number));
2582: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q6_REC.journal_date,'MM/DD/RRRR'));
2583: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q6_REC.reval_currency);
2584: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q6_REC.deal_subtype);

Line 2581: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q6_REC.trans_number));

2577: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2578: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q6_REC.company_code);
2579: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q6_REC.deal_type);
2580: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q6_REC.deal_number));
2581: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q6_REC.trans_number));
2582: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q6_REC.journal_date,'MM/DD/RRRR'));
2583: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q6_REC.reval_currency);
2584: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q6_REC.deal_subtype);
2585: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q6_REC.product_type);

Line 2582: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q6_REC.journal_date,'MM/DD/RRRR'));

2578: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q6_REC.company_code);
2579: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q6_REC.deal_type);
2580: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q6_REC.deal_number));
2581: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q6_REC.trans_number));
2582: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q6_REC.journal_date,'MM/DD/RRRR'));
2583: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q6_REC.reval_currency);
2584: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q6_REC.deal_subtype);
2585: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q6_REC.product_type);
2586: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q6_REC.portfolio_code);

Line 2583: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q6_REC.reval_currency);

2579: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q6_REC.deal_type);
2580: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q6_REC.deal_number));
2581: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q6_REC.trans_number));
2582: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q6_REC.journal_date,'MM/DD/RRRR'));
2583: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q6_REC.reval_currency);
2584: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q6_REC.deal_subtype);
2585: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q6_REC.product_type);
2586: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q6_REC.portfolio_code);
2587: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q6_REC.amount_type);

Line 2584: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q6_REC.deal_subtype);

2580: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q6_REC.deal_number));
2581: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q6_REC.trans_number));
2582: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q6_REC.journal_date,'MM/DD/RRRR'));
2583: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q6_REC.reval_currency);
2584: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q6_REC.deal_subtype);
2585: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q6_REC.product_type);
2586: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q6_REC.portfolio_code);
2587: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q6_REC.amount_type);
2588: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q6_REC.action_code);

Line 2585: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q6_REC.product_type);

2581: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q6_REC.trans_number));
2582: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q6_REC.journal_date,'MM/DD/RRRR'));
2583: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q6_REC.reval_currency);
2584: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q6_REC.deal_subtype);
2585: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q6_REC.product_type);
2586: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q6_REC.portfolio_code);
2587: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q6_REC.amount_type);
2588: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q6_REC.action_code);
2589: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q6_REC.amount));

Line 2586: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q6_REC.portfolio_code);

2582: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q6_REC.journal_date,'MM/DD/RRRR'));
2583: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q6_REC.reval_currency);
2584: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q6_REC.deal_subtype);
2585: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q6_REC.product_type);
2586: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q6_REC.portfolio_code);
2587: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q6_REC.amount_type);
2588: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q6_REC.action_code);
2589: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q6_REC.amount));
2590: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q6_REC.ccid));

Line 2587: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q6_REC.amount_type);

2583: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q6_REC.reval_currency);
2584: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q6_REC.deal_subtype);
2585: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q6_REC.product_type);
2586: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q6_REC.portfolio_code);
2587: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q6_REC.amount_type);
2588: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q6_REC.action_code);
2589: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q6_REC.amount));
2590: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q6_REC.ccid));
2591: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q6_REC.credit_or_debit);

Line 2588: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q6_REC.action_code);

2584: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q6_REC.deal_subtype);
2585: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q6_REC.product_type);
2586: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q6_REC.portfolio_code);
2587: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q6_REC.amount_type);
2588: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q6_REC.action_code);
2589: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q6_REC.amount));
2590: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q6_REC.ccid));
2591: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q6_REC.credit_or_debit);
2592: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = '|| Q6_REC.date_type);

Line 2589: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q6_REC.amount));

2585: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q6_REC.product_type);
2586: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q6_REC.portfolio_code);
2587: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q6_REC.amount_type);
2588: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q6_REC.action_code);
2589: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q6_REC.amount));
2590: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q6_REC.ccid));
2591: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q6_REC.credit_or_debit);
2592: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = '|| Q6_REC.date_type);
2593: END IF;

Line 2590: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q6_REC.ccid));

2586: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q6_REC.portfolio_code);
2587: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q6_REC.amount_type);
2588: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q6_REC.action_code);
2589: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q6_REC.amount));
2590: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q6_REC.ccid));
2591: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q6_REC.credit_or_debit);
2592: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = '|| Q6_REC.date_type);
2593: END IF;
2594:

Line 2591: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q6_REC.credit_or_debit);

2587: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q6_REC.amount_type);
2588: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q6_REC.action_code);
2589: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q6_REC.amount));
2590: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q6_REC.ccid));
2591: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q6_REC.credit_or_debit);
2592: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = '|| Q6_REC.date_type);
2593: END IF;
2594:
2595: If (nvl(Q6_REC.amount,0) = 0) then

Line 2592: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = '|| Q6_REC.date_type);

2588: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q6_REC.action_code);
2589: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q6_REC.amount));
2590: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q6_REC.ccid));
2591: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q6_REC.credit_or_debit);
2592: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = '|| Q6_REC.date_type);
2593: END IF;
2594:
2595: If (nvl(Q6_REC.amount,0) = 0) then
2596: NULL;

Line 2822: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

2818: Fetch Q7 INTO Q7_REC;
2819:
2820: l_prev_rowid := l_row_id;
2821:
2822: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2823: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q7 loop.');
2824: END IF;
2825:
2826: While Q7%FOUND LOOP

Line 2823: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q7 loop.');

2819:
2820: l_prev_rowid := l_row_id;
2821:
2822: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2823: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Entering Q7 loop.');
2824: END IF;
2825:
2826: While Q7%FOUND LOOP
2827: --

Line 2828: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

2824: END IF;
2825:
2826: While Q7%FOUND LOOP
2827: --
2828: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2829: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q7_REC.company_code);
2830: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q7_REC.deal_type);
2831: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q7_REC.deal_number));
2832: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q7_REC.trans_number));

Line 2829: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q7_REC.company_code);

2825:
2826: While Q7%FOUND LOOP
2827: --
2828: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2829: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q7_REC.company_code);
2830: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q7_REC.deal_type);
2831: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q7_REC.deal_number));
2832: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q7_REC.trans_number));
2833: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q7_REC.journal_date,'MM/DD/RRRR'));

Line 2830: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q7_REC.deal_type);

2826: While Q7%FOUND LOOP
2827: --
2828: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2829: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q7_REC.company_code);
2830: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q7_REC.deal_type);
2831: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q7_REC.deal_number));
2832: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q7_REC.trans_number));
2833: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q7_REC.journal_date,'MM/DD/RRRR'));
2834: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q7_REC.reval_currency);

Line 2831: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q7_REC.deal_number));

2827: --
2828: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2829: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q7_REC.company_code);
2830: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q7_REC.deal_type);
2831: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q7_REC.deal_number));
2832: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q7_REC.trans_number));
2833: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q7_REC.journal_date,'MM/DD/RRRR'));
2834: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q7_REC.reval_currency);
2835: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q7_REC.deal_subtype);

Line 2832: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q7_REC.trans_number));

2828: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
2829: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q7_REC.company_code);
2830: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q7_REC.deal_type);
2831: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q7_REC.deal_number));
2832: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q7_REC.trans_number));
2833: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q7_REC.journal_date,'MM/DD/RRRR'));
2834: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q7_REC.reval_currency);
2835: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q7_REC.deal_subtype);
2836: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q7_REC.product_type);

Line 2833: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q7_REC.journal_date,'MM/DD/RRRR'));

2829: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Company Code = '|| Q7_REC.company_code);
2830: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q7_REC.deal_type);
2831: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q7_REC.deal_number));
2832: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q7_REC.trans_number));
2833: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q7_REC.journal_date,'MM/DD/RRRR'));
2834: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q7_REC.reval_currency);
2835: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q7_REC.deal_subtype);
2836: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q7_REC.product_type);
2837: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q7_REC.portfolio_code);

Line 2834: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q7_REC.reval_currency);

2830: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Type = ' || Q7_REC.deal_type);
2831: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q7_REC.deal_number));
2832: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q7_REC.trans_number));
2833: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q7_REC.journal_date,'MM/DD/RRRR'));
2834: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q7_REC.reval_currency);
2835: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q7_REC.deal_subtype);
2836: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q7_REC.product_type);
2837: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q7_REC.portfolio_code);
2838: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q7_REC.amount_type);

Line 2835: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q7_REC.deal_subtype);

2831: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Number = '|| to_char(Q7_REC.deal_number));
2832: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q7_REC.trans_number));
2833: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q7_REC.journal_date,'MM/DD/RRRR'));
2834: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q7_REC.reval_currency);
2835: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q7_REC.deal_subtype);
2836: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q7_REC.product_type);
2837: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q7_REC.portfolio_code);
2838: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q7_REC.amount_type);
2839: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q7_REC.action_code);

Line 2836: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q7_REC.product_type);

2832: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Transaction Nbr = '|| to_char(Q7_REC.trans_number));
2833: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q7_REC.journal_date,'MM/DD/RRRR'));
2834: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q7_REC.reval_currency);
2835: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q7_REC.deal_subtype);
2836: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q7_REC.product_type);
2837: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q7_REC.portfolio_code);
2838: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q7_REC.amount_type);
2839: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q7_REC.action_code);
2840: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q7_REC.amount));

Line 2837: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q7_REC.portfolio_code);

2833: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Date = '|| to_char(Q7_REC.journal_date,'MM/DD/RRRR'));
2834: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q7_REC.reval_currency);
2835: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q7_REC.deal_subtype);
2836: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q7_REC.product_type);
2837: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q7_REC.portfolio_code);
2838: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q7_REC.amount_type);
2839: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q7_REC.action_code);
2840: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q7_REC.amount));
2841: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q7_REC.ccid));

Line 2838: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q7_REC.amount_type);

2834: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Currency = '|| Q7_REC.reval_currency);
2835: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q7_REC.deal_subtype);
2836: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q7_REC.product_type);
2837: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q7_REC.portfolio_code);
2838: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q7_REC.amount_type);
2839: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q7_REC.action_code);
2840: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q7_REC.amount));
2841: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q7_REC.ccid));
2842: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q7_REC.credit_or_debit);

Line 2839: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q7_REC.action_code);

2835: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Deal Subtype = '|| Q7_REC.deal_subtype);
2836: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q7_REC.product_type);
2837: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q7_REC.portfolio_code);
2838: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q7_REC.amount_type);
2839: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q7_REC.action_code);
2840: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q7_REC.amount));
2841: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q7_REC.ccid));
2842: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q7_REC.credit_or_debit);
2843: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = '|| Q7_REC.date_type);

Line 2840: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q7_REC.amount));

2836: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Product Type = '|| Q7_REC.product_type);
2837: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q7_REC.portfolio_code);
2838: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q7_REC.amount_type);
2839: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q7_REC.action_code);
2840: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q7_REC.amount));
2841: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q7_REC.ccid));
2842: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q7_REC.credit_or_debit);
2843: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = '|| Q7_REC.date_type);
2844: END IF;

Line 2841: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q7_REC.ccid));

2837: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Portfolio = '|| Q7_REC.portfolio_code);
2838: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q7_REC.amount_type);
2839: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q7_REC.action_code);
2840: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q7_REC.amount));
2841: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q7_REC.ccid));
2842: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q7_REC.credit_or_debit);
2843: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = '|| Q7_REC.date_type);
2844: END IF;
2845:

Line 2842: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q7_REC.credit_or_debit);

2838: xtr_debug_pkg.debug ('GEN_JOURNALS: ' ||'Amount Type = '|| Q7_REC.amount_type);
2839: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q7_REC.action_code);
2840: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q7_REC.amount));
2841: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q7_REC.ccid));
2842: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q7_REC.credit_or_debit);
2843: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = '|| Q7_REC.date_type);
2844: END IF;
2845:
2846: If (nvl(Q7_REC.amount,0) = 0) then

Line 2843: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = '|| Q7_REC.date_type);

2839: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Action Code = '|| Q7_REC.action_code);
2840: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Revaluation Amount = '|| to_char(Q7_REC.amount));
2841: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'CCID = '|| to_char(Q7_REC.ccid));
2842: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'DR/CR = '|| Q7_REC.credit_or_debit);
2843: xtr_debug_pkg.debug ('GEN_JOURNALS: ' || 'Date Type = '|| Q7_REC.date_type);
2844: END IF;
2845:
2846: If (nvl(Q7_REC.amount,0) = 0) then
2847: NULL;

Line 3385: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

3381:
3382:
3383: BEGIN
3384:
3385: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
3386: xtr_debug_pkg.debug ('>> PROCEDURE Journals.');
3387: END IF;
3388:
3389: l_cutoff_date := FND_DATE.Canonical_To_Date(p_cutoff_date);

Line 3386: xtr_debug_pkg.debug ('>> PROCEDURE Journals.');

3382:
3383: BEGIN
3384:
3385: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
3386: xtr_debug_pkg.debug ('>> PROCEDURE Journals.');
3387: END IF;
3388:
3389: l_cutoff_date := FND_DATE.Canonical_To_Date(p_cutoff_date);
3390: