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.OKL_PAY_INVOICES_CONS_PVT dependencies on FND_FILE

Line 99: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_Disbursement_term: p_vendor_id/p_vendor_site_id/p_stream_type_purpose/'

95: p_stream_type_purpose => p_stream_type_purpose,
96: p_transaction_date => p_transaction_date);
97: FETCH c_disb_rules into r_disb_rules;
98:
99: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_Disbursement_term: p_vendor_id/p_vendor_site_id/p_stream_type_purpose/'
100: || p_vendor_id || '/' || p_vendor_site_id || '/' || p_stream_type_purpose || '/');
101:
102: IF c_disb_rules%FOUND THEN
103:

Line 104: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_Disbursement_term: rule_name:' || r_disb_rules.rule_name);

100: || p_vendor_id || '/' || p_vendor_site_id || '/' || p_stream_type_purpose || '/');
101:
102: IF c_disb_rules%FOUND THEN
103:
104: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_Disbursement_term: rule_name:' || r_disb_rules.rule_name);
105: x_rule_found := TRUE;
106: lx_disb_rules.dra_rec.disb_rule_id := r_disb_rules.disb_rule_id;
107: lx_disb_rules.dra_rec.rule_name := r_disb_rules.rule_name;
108: lx_disb_rules.dra_rec.fee_option := r_disb_rules.fee_option;

Line 228: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'handle_next_invoice_seq: p_vendor_id/p_vendor_site_id/p_stream_type_purpose/'

224: END IF;
225:
226: x_next_inv_seq := NULL; -- initial to null
227:
228: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'handle_next_invoice_seq: p_vendor_id/p_vendor_site_id/p_stream_type_purpose/'
229: || p_vendor_id || '/' || p_vendor_site_id || '/' || p_stream_type_purpose || '/');
230: IF p_adv_grouping_flag = 'Y' THEN -- reserved for future use
231:
232: l_disb_rules := get_Disbursement_term(

Line 328: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'handle_next_invoice_seq: l_next_inv_seq:' || l_next_inv_seq);

324: AND disb_rule_id = l_disb_rules.dra_rec.disb_rule_id;
325: END IF;
326:
327: --end: bug: 6662247
328: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'handle_next_invoice_seq: l_next_inv_seq:' || l_next_inv_seq);
329: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'handle_next_invoice_seq: l_new_next_inv_seq:' || l_new_next_inv_seq);
330:
331: END IF; -- if vendor invoice sequence has been set
332: END IF; -- if rule found

Line 329: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'handle_next_invoice_seq: l_new_next_inv_seq:' || l_new_next_inv_seq);

325: END IF;
326:
327: --end: bug: 6662247
328: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'handle_next_invoice_seq: l_next_inv_seq:' || l_next_inv_seq);
329: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'handle_next_invoice_seq: l_new_next_inv_seq:' || l_new_next_inv_seq);
330:
331: END IF; -- if vendor invoice sequence has been set
332: END IF; -- if rule found
333: END IF; --IF p_adv_grouping_flag = 'Y' THEN

Line 350: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'handle_next_invoice_seq*=> ERROR: '||SQLERRM);

346: ------------------------------------------------------------
347: -- Exception handling
348: ------------------------------------------------------------
349: WHEN OKL_API.G_EXCEPTION_ERROR THEN
350: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'handle_next_invoice_seq*=> ERROR: '||SQLERRM);
351: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
352: p_api_name => l_api_name,
353: p_pkg_name => G_PKG_NAME,
354: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 360: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'handle_next_invoice_seq*=> ERROR: '||SQLERRM);

356: x_msg_data => x_msg_data,
357: p_api_type => '_PVT');
358:
359: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
360: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'handle_next_invoice_seq*=> ERROR: '||SQLERRM);
361: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
362: p_api_name => l_api_name,
363: p_pkg_name => G_PKG_NAME,
364: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 370: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'handle_next_invoice_seq*=> ERROR: '||SQLERRM);

366: x_msg_data => x_msg_data,
367: p_api_type => '_PVT');
368:
369: WHEN OTHERS THEN
370: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'handle_next_invoice_seq*=> ERROR: '||SQLERRM);
371: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
372: p_api_name => l_api_name,
373: p_pkg_name => G_PKG_NAME,
374: p_exc_name => 'OTHERS',

Line 557: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_ap_invoice_date: p_vendor_id/p_vendor_site_id/p_stream_type_purpose/consolidate_by_due_date'

553: set inoice date as pass in transaction date;
554: end if;
555: */
556:
557: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_ap_invoice_date: p_vendor_id/p_vendor_site_id/p_stream_type_purpose/consolidate_by_due_date'
558: || p_vendor_id || '/' || p_vendor_site_id || '/' || p_stream_type_purpose || '/'|| l_disb_rules.dra_rec.consolidate_by_due_date);
559: IF p_adv_grouping_flag = 'Y' THEN -- reserved for future use
560:
561: l_disb_rules := get_Disbursement_term(

Line 573: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_ap_invoice_date: p_invoiced_date/p_frequency/p_day_of_month/p_scheduled_month'

569: IF lx_return_status = G_RET_STS_SUCCESS AND lx_rule_found = TRUE THEN
570:
571: IF l_disb_rules.dra_rec.consolidate_by_due_date = 'Y' THEN
572:
573: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_ap_invoice_date: p_invoiced_date/p_frequency/p_day_of_month/p_scheduled_month'
574: || p_transaction_date || '/' || l_disb_rules.dra_rec.frequency || '/' || l_disb_rules.dra_rec.day_of_month || '/'|| l_disb_rules.dra_rec.scheduled_month);
575: -- getting the invoice date for the consolidated invoice based on the schedule setup on the rule (ssiruvol 5/10/2007)
576: l_invoice_date := get_cnsld_invoiced_date (p_invoiced_date => p_transaction_date,
577: p_frequency => l_disb_rules.dra_rec.frequency,

Line 584: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_ap_invoice_date: l_invoice_date' || l_invoice_date);

580: END IF;
581: END IF;
582: END IF; --IF p_adv_grouping_flag = 'Y' THEN
583:
584: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_ap_invoice_date: l_invoice_date' || l_invoice_date);
585:
586: return l_invoice_date;
587:
588: EXCEPTION

Line 646: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_Disbursement_group: p_vendor_id/p_vendor_site_id/p_stream_type_purpose/consolidate_strm_type '

642: set l_disb_term := null;
643: end if;
644: */
645:
646: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_Disbursement_group: p_vendor_id/p_vendor_site_id/p_stream_type_purpose/consolidate_strm_type '
647: || p_vendor_id || '/' || p_vendor_site_id || '/' || p_stream_type_purpose || '/'|| l_disb_rules.dra_rec.consolidate_strm_type );
648: IF p_adv_grouping_flag = 'Y' THEN -- reserved for future use
649:
650: l_disb_rules := get_Disbursement_term(

Line 669: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_Disbursement_group:l_disb_group' || l_disb_group);

665: END IF;
666: END IF;
667: END IF; --IF p_adv_grouping_flag = 'Y' THEN
668:
669: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_Disbursement_group:l_disb_group' || l_disb_group);
670:
671: return l_disb_group;
672:
673: EXCEPTION

Line 801: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_Disbursement_rule: p_vendor_id/p_vendor_site_id/p_stream_type_purpose/'

797: okl_txl_ap_inv_lns_all_b.id as a grouping criteria.
798:
799: */
800:
801: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_Disbursement_rule: p_vendor_id/p_vendor_site_id/p_stream_type_purpose/'
802: || p_vendor_id || '/' || p_vendor_site_id || '/' || p_stream_type_purpose || '/');
803: IF p_adv_grouping_flag = 'Y' THEN -- reserved for future use
804:
805: l_disb_rules := get_Disbursement_term(

Line 818: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_Disbursement_rule: l_disb_rule' || l_disb_rule);

814: l_disb_rule := l_disb_rules.dra_rec.rule_name; -- set disb group as Term name
815: END IF;
816: END IF; --IF p_adv_grouping_flag = 'Y' THEN
817:
818: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_Disbursement_rule: l_disb_rule' || l_disb_rule);
819: return l_disb_rule;
820:
821: EXCEPTION
822: WHEN OTHERS THEN

Line 1201: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 1');

1197: ------------------------------------------------------------
1198: -- Start processing
1199: ------------------------------------------------------------
1200:
1201: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 1');
1202:
1203: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1204:
1205: l_return_status := OKL_API.START_ACTIVITY(

Line 1222: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 2');

1218: END IF;
1219:
1220: i := 0;
1221:
1222: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 2');
1223:
1224: FOR r_invoice IN c_invoice LOOP -- loop through all invoices ordered by the header values (ssiruvol 5/10/2007)
1225:
1226: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 3');

Line 1226: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 3');

1222: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 2');
1223:
1224: FOR r_invoice IN c_invoice LOOP -- loop through all invoices ordered by the header values (ssiruvol 5/10/2007)
1225:
1226: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 3');
1227:
1228: l_consolidate_yn := 'N'; -- Flag to know whether current invoice is being consolidated or not (ssiruvol 5/10/2007)
1229:
1230: l_curr_vendor_id := r_invoice.vendor_id;

Line 1262: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 3.1 vendor id ' || to_char(l_curr_vendor_id));

1258: l_inv_seq_end := 0;
1259: l_next_inv_seq := 0;
1260: l_new_next_inv_seq := 0;
1261:
1262: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 3.1 vendor id ' || to_char(l_curr_vendor_id));
1263: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 3.1 vendor site id ' || to_char(l_curr_vendor_site_id));
1264: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 3.1 sty id ' || to_char(l_curr_sty_id));
1265:
1266: -- Checking if a rule exists on the an invoice (ssiruvol 5/10/2007)

Line 1263: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 3.1 vendor site id ' || to_char(l_curr_vendor_site_id));

1259: l_next_inv_seq := 0;
1260: l_new_next_inv_seq := 0;
1261:
1262: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 3.1 vendor id ' || to_char(l_curr_vendor_id));
1263: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 3.1 vendor site id ' || to_char(l_curr_vendor_site_id));
1264: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 3.1 sty id ' || to_char(l_curr_sty_id));
1265:
1266: -- Checking if a rule exists on the an invoice (ssiruvol 5/10/2007)
1267: OPEN c_disb_rules(vId => l_curr_vendor_id,

Line 1264: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 3.1 sty id ' || to_char(l_curr_sty_id));

1260: l_new_next_inv_seq := 0;
1261:
1262: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 3.1 vendor id ' || to_char(l_curr_vendor_id));
1263: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 3.1 vendor site id ' || to_char(l_curr_vendor_site_id));
1264: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 3.1 sty id ' || to_char(l_curr_sty_id));
1265:
1266: -- Checking if a rule exists on the an invoice (ssiruvol 5/10/2007)
1267: OPEN c_disb_rules(vId => l_curr_vendor_id,
1268: vSiteid => l_curr_vendor_site_id,

Line 1275: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4 found rule ' );

1271: FETCH c_disb_rules into r_disb_rules;
1272:
1273: If c_disb_rules%FOUND THEN
1274:
1275: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4 found rule ' );
1276: l_found_rule_YN := 'Y';
1277:
1278: -- getting the correct seqence number (ssiruvol 5/10/2007)
1279: l_inv_seq_start := nvl(r_disb_rules.invoice_seq_start,0);

Line 1289: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1 l_inv_seq_start ' || to_char(l_inv_seq_start) );

1285: l_neW_next_inv_seq := l_inv_seq_end;
1286: l_next_inv_seq := NULL;
1287: End If;
1288:
1289: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1 l_inv_seq_start ' || to_char(l_inv_seq_start) );
1290: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1 l_inv_seq_end ' || to_char(l_inv_seq_end) );
1291: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1 l_next_inv_seq ' || to_char(l_next_inv_seq) );
1292: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1 l_new_next_inv_seq ' || to_char(l_new_next_inv_seq) );
1293:

Line 1290: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1 l_inv_seq_end ' || to_char(l_inv_seq_end) );

1286: l_next_inv_seq := NULL;
1287: End If;
1288:
1289: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1 l_inv_seq_start ' || to_char(l_inv_seq_start) );
1290: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1 l_inv_seq_end ' || to_char(l_inv_seq_end) );
1291: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1 l_next_inv_seq ' || to_char(l_next_inv_seq) );
1292: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1 l_new_next_inv_seq ' || to_char(l_new_next_inv_seq) );
1293:
1294: IF r_disb_rules.consolidate_by_due_date = 'Y' THEN

Line 1291: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1 l_next_inv_seq ' || to_char(l_next_inv_seq) );

1287: End If;
1288:
1289: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1 l_inv_seq_start ' || to_char(l_inv_seq_start) );
1290: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1 l_inv_seq_end ' || to_char(l_inv_seq_end) );
1291: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1 l_next_inv_seq ' || to_char(l_next_inv_seq) );
1292: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1 l_new_next_inv_seq ' || to_char(l_new_next_inv_seq) );
1293:
1294: IF r_disb_rules.consolidate_by_due_date = 'Y' THEN
1295:

Line 1292: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1 l_new_next_inv_seq ' || to_char(l_new_next_inv_seq) );

1288:
1289: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1 l_inv_seq_start ' || to_char(l_inv_seq_start) );
1290: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1 l_inv_seq_end ' || to_char(l_inv_seq_end) );
1291: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1 l_next_inv_seq ' || to_char(l_next_inv_seq) );
1292: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1 l_new_next_inv_seq ' || to_char(l_new_next_inv_seq) );
1293:
1294: IF r_disb_rules.consolidate_by_due_date = 'Y' THEN
1295:
1296: -- getting the invoice date for the consolidated invoice based on the schedule setup on the rule (ssiruvol 5/10/2007)

Line 1310: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 5 cnsld inv date ' || to_char(l_curr_inv_date) );

1306: l_curr_inv_date := l_curr_invoiced_date;
1307: END If;
1308: CLOSE c_disb_rules;
1309:
1310: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 5 cnsld inv date ' || to_char(l_curr_inv_date) );
1311:
1312: /*
1313: If ( l_curr_vendor_id <> nvl(l_last_vendor_id, -99)
1314: AND l_curr_vendor_site_id <> nvl(l_last_vendor_site_id, -99)

Line 1368: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' last ccd ' || to_char(nvl(l_last_code_combination_id, -99)) );

1364:
1365: END If;
1366:
1367: */
1368: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' last ccd ' || to_char(nvl(l_last_code_combination_id, -99)) );
1369: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' curr ccd ' || to_char(l_curr_code_combination_id) );
1370:
1371: If ( nvl(l_curr_vendor_id, -99) = nvl(l_last_vendor_id, -99)
1372: AND nvl(l_curr_vendor_site_id, -99) = nvl(l_last_vendor_site_id, -99)

Line 1369: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' curr ccd ' || to_char(l_curr_code_combination_id) );

1365: END If;
1366:
1367: */
1368: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' last ccd ' || to_char(nvl(l_last_code_combination_id, -99)) );
1369: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' curr ccd ' || to_char(l_curr_code_combination_id) );
1370:
1371: If ( nvl(l_curr_vendor_id, -99) = nvl(l_last_vendor_id, -99)
1372: AND nvl(l_curr_vendor_site_id, -99) = nvl(l_last_vendor_site_id, -99)
1373: AND nvl(l_curr_ipvs_id, -99) = nvl(l_last_ipvs_id, -99)

Line 1391: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 6 tyrig to cnsld inv date ' || to_char(l_curr_inv_date) );

1387: -- If any one of the above header values is different than we cannot consolidate (ssiruvol 5/10/2007)
1388:
1389: AND l_found_rule_YN = 'Y') Then
1390:
1391: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 6 tyrig to cnsld inv date ' || to_char(l_curr_inv_date) );
1392:
1393: -- date rule (ssiruvol 5/10/2007)
1394: If ( l_curr_invoiced_date = l_last_invoiced_date OR r_disb_rules.consolidate_by_due_date = 'Y' ) Then
1395:

Line 1417: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 7 tyrig to cnsld inv date ' || to_char(l_curr_inv_date) );

1413: END If;
1414:
1415: If l_consolidate_yn = 'Y' and l_curr_inv_date = nvl(l_last_inv_date,sysdate-10000) Then
1416:
1417: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 7 tyrig to cnsld inv date ' || to_char(l_curr_inv_date) );
1418:
1419: l_cnsld_invs(i).cin_rec.amount := l_cnsld_invs(i).cin_rec.amount + r_invoice.invoice_amount;
1420: l_cnsld_invs(i).cin_rec.vendor_invoice_number := NULL;
1421:

Line 1424: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 8 ' );

1420: l_cnsld_invs(i).cin_rec.vendor_invoice_number := NULL;
1421:
1422: ElsIf l_consolidate_yn = 'Y' and l_curr_inv_date <> nvl(l_last_inv_date,sysdate-10000) Then
1423:
1424: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 8 ' );
1425:
1426: l := nvl(l_cnsld_invs.FIRST, l_cnsld_invs.COUNT + 1);
1427: i := l_cnsld_invs.COUNT + 1; -- making sure to create a new consld transaction incase the while loop is missed
1428:

Line 1453: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 9 ' );

1449: End If;
1450:
1451: If l_consolidate_yn = 'N' Then -- processing a brand new transaction
1452:
1453: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 9 ' );
1454:
1455: i := l_cnsld_invs.COUNT + 1;
1456: l_cnsld_invs(i).cin_rec.amount := r_invoice.invoice_amount;
1457:

Line 1502: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1.1 updating self_bill_inv_num ' || to_char(l_next_inv_seq) );

1498: set next_inv_seq = l_new_next_inv_seq
1499: where disb_rule_vendor_site_id = r_disb_rules.disb_rule_vendor_site_id
1500: and disb_rule_id = r_disb_rules.disb_rule_id;
1501:
1502: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1.1 updating self_bill_inv_num ' || to_char(l_next_inv_seq) );
1503: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1.2 updating next_inv_seq ' || to_char( l_new_next_inv_seq) );
1504:
1505: END IF;
1506:

Line 1503: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1.2 updating next_inv_seq ' || to_char( l_new_next_inv_seq) );

1499: where disb_rule_vendor_site_id = r_disb_rules.disb_rule_vendor_site_id
1500: and disb_rule_id = r_disb_rules.disb_rule_id;
1501:
1502: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1.1 updating self_bill_inv_num ' || to_char(l_next_inv_seq) );
1503: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 4.1.2 updating next_inv_seq ' || to_char( l_new_next_inv_seq) );
1504:
1505: END IF;
1506:
1507: End If;

Line 1567: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 100');

1563: l_last_ipt_frequency := l_curr_ipt_frequency;
1564:
1565: END LOOP;
1566:
1567: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 100');
1568:
1569: If ( l_cnsld_invs.COUNT > 0 ) then
1570:
1571: i := 0;

Line 1575: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 102');

1571: i := 0;
1572: FOR i in l_cnsld_invs.FIRST..l_cnsld_invs.LAST
1573: LOOP
1574:
1575: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 102');
1576: l_gen_seq := NULL;
1577:
1578: l_gen_seq := fnd_seqnum.get_next_sequence
1579: (appid => l_okl_application_id,

Line 1596: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 103');

1592: END LOOP;
1593:
1594: end If;
1595:
1596: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 103');
1597: x_cnsld_invs := l_cnsld_invs;
1598:
1599: ------------------------------------------------------------
1600: -- End processing

Line 1613: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

1609: ------------------------------------------------------------
1610: -- Exception handling
1611: ------------------------------------------------------------
1612: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1613: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
1614: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1615: p_api_name => l_api_name,
1616: p_pkg_name => G_PKG_NAME,
1617: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1623: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

1619: x_msg_data => x_msg_data,
1620: p_api_type => '_PVT');
1621:
1622: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1623: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
1624: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1625: p_api_name => l_api_name,
1626: p_pkg_name => G_PKG_NAME,
1627: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1633: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

1629: x_msg_data => x_msg_data,
1630: p_api_type => '_PVT');
1631:
1632: WHEN OTHERS THEN
1633: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
1634: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1635: p_api_name => l_api_name,
1636: p_pkg_name => G_PKG_NAME,
1637: p_exc_name => 'OTHERS',

Line 2045: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 1');

2041: ------------------------------------------------------------
2042: -- Start processing
2043: ------------------------------------------------------------
2044:
2045: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 1');
2046:
2047: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2048:
2049: l_return_status := OKL_API.START_ACTIVITY(

Line 2071: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 1.1');

2067: FOR r_cin_invoice IN c_cin_invoice LOOP
2068:
2069: cin_cnt := 0; -- initial to 0
2070:
2071: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 1.1');
2072:
2073:
2074: -- FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 cin_cnt:' || cin_cnt);
2075: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2');

Line 2074: -- FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 cin_cnt:' || cin_cnt);

2070:
2071: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 1.1');
2072:
2073:
2074: -- FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 cin_cnt:' || cin_cnt);
2075: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2');
2076: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_contract_id => '|| p_contract_id);
2077: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_from_date => '|| p_from_date);
2078: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_to_date => '|| p_to_date);

Line 2075: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2');

2071: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 1.1');
2072:
2073:
2074: -- FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 cin_cnt:' || cin_cnt);
2075: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2');
2076: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_contract_id => '|| p_contract_id);
2077: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_from_date => '|| p_from_date);
2078: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_to_date => '|| p_to_date);
2079: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_stream_type_purpose => '|| p_stream_type_purpose);

Line 2076: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_contract_id => '|| p_contract_id);

2072:
2073:
2074: -- FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 cin_cnt:' || cin_cnt);
2075: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2');
2076: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_contract_id => '|| p_contract_id);
2077: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_from_date => '|| p_from_date);
2078: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_to_date => '|| p_to_date);
2079: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_stream_type_purpose => '|| p_stream_type_purpose);
2080:

Line 2077: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_from_date => '|| p_from_date);

2073:
2074: -- FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 cin_cnt:' || cin_cnt);
2075: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2');
2076: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_contract_id => '|| p_contract_id);
2077: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_from_date => '|| p_from_date);
2078: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_to_date => '|| p_to_date);
2079: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_stream_type_purpose => '|| p_stream_type_purpose);
2080:
2081: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_vendor_id => '|| r_cin_invoice.vendor_id);

Line 2078: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_to_date => '|| p_to_date);

2074: -- FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 cin_cnt:' || cin_cnt);
2075: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2');
2076: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_contract_id => '|| p_contract_id);
2077: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_from_date => '|| p_from_date);
2078: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_to_date => '|| p_to_date);
2079: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_stream_type_purpose => '|| p_stream_type_purpose);
2080:
2081: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_vendor_id => '|| r_cin_invoice.vendor_id);
2082: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_ipvs_id =>'|| r_cin_invoice.ipvs_id);

Line 2079: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_stream_type_purpose => '|| p_stream_type_purpose);

2075: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2');
2076: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_contract_id => '|| p_contract_id);
2077: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_from_date => '|| p_from_date);
2078: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_to_date => '|| p_to_date);
2079: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_stream_type_purpose => '|| p_stream_type_purpose);
2080:
2081: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_vendor_id => '|| r_cin_invoice.vendor_id);
2082: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_ipvs_id =>'|| r_cin_invoice.ipvs_id);
2083: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_pay_group_lookup_code =>'|| r_cin_invoice.pay_group_lookup_code);

Line 2081: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_vendor_id => '|| r_cin_invoice.vendor_id);

2077: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_from_date => '|| p_from_date);
2078: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_to_date => '|| p_to_date);
2079: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_stream_type_purpose => '|| p_stream_type_purpose);
2080:
2081: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_vendor_id => '|| r_cin_invoice.vendor_id);
2082: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_ipvs_id =>'|| r_cin_invoice.ipvs_id);
2083: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_pay_group_lookup_code =>'|| r_cin_invoice.pay_group_lookup_code);
2084: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_payment_method_code =>'|| r_cin_invoice.payment_method_code);
2085: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_ippt_id =>'|| r_cin_invoice.ippt_id);

Line 2082: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_ipvs_id =>'|| r_cin_invoice.ipvs_id);

2078: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_to_date => '|| p_to_date);
2079: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_stream_type_purpose => '|| p_stream_type_purpose);
2080:
2081: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_vendor_id => '|| r_cin_invoice.vendor_id);
2082: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_ipvs_id =>'|| r_cin_invoice.ipvs_id);
2083: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_pay_group_lookup_code =>'|| r_cin_invoice.pay_group_lookup_code);
2084: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_payment_method_code =>'|| r_cin_invoice.payment_method_code);
2085: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_ippt_id =>'|| r_cin_invoice.ippt_id);
2086: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_set_of_books_id =>'|| r_cin_invoice.sob_id);

Line 2083: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_pay_group_lookup_code =>'|| r_cin_invoice.pay_group_lookup_code);

2079: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_stream_type_purpose => '|| p_stream_type_purpose);
2080:
2081: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_vendor_id => '|| r_cin_invoice.vendor_id);
2082: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_ipvs_id =>'|| r_cin_invoice.ipvs_id);
2083: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_pay_group_lookup_code =>'|| r_cin_invoice.pay_group_lookup_code);
2084: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_payment_method_code =>'|| r_cin_invoice.payment_method_code);
2085: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_ippt_id =>'|| r_cin_invoice.ippt_id);
2086: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_set_of_books_id =>'|| r_cin_invoice.sob_id);
2087: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_code_combination_id =>'|| r_cin_invoice.code_combination_id);

Line 2084: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_payment_method_code =>'|| r_cin_invoice.payment_method_code);

2080:
2081: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_vendor_id => '|| r_cin_invoice.vendor_id);
2082: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_ipvs_id =>'|| r_cin_invoice.ipvs_id);
2083: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_pay_group_lookup_code =>'|| r_cin_invoice.pay_group_lookup_code);
2084: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_payment_method_code =>'|| r_cin_invoice.payment_method_code);
2085: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_ippt_id =>'|| r_cin_invoice.ippt_id);
2086: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_set_of_books_id =>'|| r_cin_invoice.sob_id);
2087: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_code_combination_id =>'|| r_cin_invoice.code_combination_id);
2088: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_code =>'|| r_cin_invoice.currency_code);

Line 2085: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_ippt_id =>'|| r_cin_invoice.ippt_id);

2081: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 p_vendor_id => '|| r_cin_invoice.vendor_id);
2082: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_ipvs_id =>'|| r_cin_invoice.ipvs_id);
2083: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_pay_group_lookup_code =>'|| r_cin_invoice.pay_group_lookup_code);
2084: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_payment_method_code =>'|| r_cin_invoice.payment_method_code);
2085: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_ippt_id =>'|| r_cin_invoice.ippt_id);
2086: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_set_of_books_id =>'|| r_cin_invoice.sob_id);
2087: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_code_combination_id =>'|| r_cin_invoice.code_combination_id);
2088: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_code =>'|| r_cin_invoice.currency_code);
2089: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_type =>'|| r_cin_invoice.currency_conversion_type);

Line 2086: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_set_of_books_id =>'|| r_cin_invoice.sob_id);

2082: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_ipvs_id =>'|| r_cin_invoice.ipvs_id);
2083: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_pay_group_lookup_code =>'|| r_cin_invoice.pay_group_lookup_code);
2084: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_payment_method_code =>'|| r_cin_invoice.payment_method_code);
2085: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_ippt_id =>'|| r_cin_invoice.ippt_id);
2086: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_set_of_books_id =>'|| r_cin_invoice.sob_id);
2087: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_code_combination_id =>'|| r_cin_invoice.code_combination_id);
2088: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_code =>'|| r_cin_invoice.currency_code);
2089: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_type =>'|| r_cin_invoice.currency_conversion_type);
2090: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_rate =>'|| r_cin_invoice.currency_conversion_rate);

Line 2087: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_code_combination_id =>'|| r_cin_invoice.code_combination_id);

2083: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_pay_group_lookup_code =>'|| r_cin_invoice.pay_group_lookup_code);
2084: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_payment_method_code =>'|| r_cin_invoice.payment_method_code);
2085: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_ippt_id =>'|| r_cin_invoice.ippt_id);
2086: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_set_of_books_id =>'|| r_cin_invoice.sob_id);
2087: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_code_combination_id =>'|| r_cin_invoice.code_combination_id);
2088: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_code =>'|| r_cin_invoice.currency_code);
2089: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_type =>'|| r_cin_invoice.currency_conversion_type);
2090: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_rate =>'|| r_cin_invoice.currency_conversion_rate);
2091: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_date =>'|| r_cin_invoice.currency_conversion_date);

Line 2088: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_code =>'|| r_cin_invoice.currency_code);

2084: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_payment_method_code =>'|| r_cin_invoice.payment_method_code);
2085: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_ippt_id =>'|| r_cin_invoice.ippt_id);
2086: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_set_of_books_id =>'|| r_cin_invoice.sob_id);
2087: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_code_combination_id =>'|| r_cin_invoice.code_combination_id);
2088: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_code =>'|| r_cin_invoice.currency_code);
2089: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_type =>'|| r_cin_invoice.currency_conversion_type);
2090: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_rate =>'|| r_cin_invoice.currency_conversion_rate);
2091: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_date =>'|| r_cin_invoice.currency_conversion_date);
2092: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_legal_entity_id =>'|| r_cin_invoice.legal_entity_id);

Line 2089: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_type =>'|| r_cin_invoice.currency_conversion_type);

2085: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_ippt_id =>'|| r_cin_invoice.ippt_id);
2086: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_set_of_books_id =>'|| r_cin_invoice.sob_id);
2087: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_code_combination_id =>'|| r_cin_invoice.code_combination_id);
2088: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_code =>'|| r_cin_invoice.currency_code);
2089: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_type =>'|| r_cin_invoice.currency_conversion_type);
2090: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_rate =>'|| r_cin_invoice.currency_conversion_rate);
2091: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_date =>'|| r_cin_invoice.currency_conversion_date);
2092: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_legal_entity_id =>'|| r_cin_invoice.legal_entity_id);
2093: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_vpa_id =>'|| r_cin_invoice.vpa_id);

Line 2090: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_rate =>'|| r_cin_invoice.currency_conversion_rate);

2086: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_set_of_books_id =>'|| r_cin_invoice.sob_id);
2087: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_code_combination_id =>'|| r_cin_invoice.code_combination_id);
2088: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_code =>'|| r_cin_invoice.currency_code);
2089: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_type =>'|| r_cin_invoice.currency_conversion_type);
2090: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_rate =>'|| r_cin_invoice.currency_conversion_rate);
2091: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_date =>'|| r_cin_invoice.currency_conversion_date);
2092: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_legal_entity_id =>'|| r_cin_invoice.legal_entity_id);
2093: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_vpa_id =>'|| r_cin_invoice.vpa_id);
2094: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_invoice_type =>'|| r_cin_invoice.invoice_type);

Line 2091: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_date =>'|| r_cin_invoice.currency_conversion_date);

2087: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_code_combination_id =>'|| r_cin_invoice.code_combination_id);
2088: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_code =>'|| r_cin_invoice.currency_code);
2089: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_type =>'|| r_cin_invoice.currency_conversion_type);
2090: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_rate =>'|| r_cin_invoice.currency_conversion_rate);
2091: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_date =>'|| r_cin_invoice.currency_conversion_date);
2092: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_legal_entity_id =>'|| r_cin_invoice.legal_entity_id);
2093: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_vpa_id =>'|| r_cin_invoice.vpa_id);
2094: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_invoice_type =>'|| r_cin_invoice.invoice_type);
2095: -- ,p_contract_group => r_cin_invoice.contract_group

Line 2092: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_legal_entity_id =>'|| r_cin_invoice.legal_entity_id);

2088: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_code =>'|| r_cin_invoice.currency_code);
2089: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_type =>'|| r_cin_invoice.currency_conversion_type);
2090: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_rate =>'|| r_cin_invoice.currency_conversion_rate);
2091: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_date =>'|| r_cin_invoice.currency_conversion_date);
2092: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_legal_entity_id =>'|| r_cin_invoice.legal_entity_id);
2093: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_vpa_id =>'|| r_cin_invoice.vpa_id);
2094: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_invoice_type =>'|| r_cin_invoice.invoice_type);
2095: -- ,p_contract_group => r_cin_invoice.contract_group
2096: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_disbursement_rule =>'|| r_cin_invoice.disbursement_rule);

Line 2093: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_vpa_id =>'|| r_cin_invoice.vpa_id);

2089: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_type =>'|| r_cin_invoice.currency_conversion_type);
2090: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_rate =>'|| r_cin_invoice.currency_conversion_rate);
2091: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_date =>'|| r_cin_invoice.currency_conversion_date);
2092: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_legal_entity_id =>'|| r_cin_invoice.legal_entity_id);
2093: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_vpa_id =>'|| r_cin_invoice.vpa_id);
2094: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_invoice_type =>'|| r_cin_invoice.invoice_type);
2095: -- ,p_contract_group => r_cin_invoice.contract_group
2096: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_disbursement_rule =>'|| r_cin_invoice.disbursement_rule);
2097: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_disbursement_group =>'|| r_cin_invoice.disbursement_group);

Line 2094: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_invoice_type =>'|| r_cin_invoice.invoice_type);

2090: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_rate =>'|| r_cin_invoice.currency_conversion_rate);
2091: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_currency_conversion_date =>'|| r_cin_invoice.currency_conversion_date);
2092: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_legal_entity_id =>'|| r_cin_invoice.legal_entity_id);
2093: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_vpa_id =>'|| r_cin_invoice.vpa_id);
2094: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_invoice_type =>'|| r_cin_invoice.invoice_type);
2095: -- ,p_contract_group => r_cin_invoice.contract_group
2096: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_disbursement_rule =>'|| r_cin_invoice.disbursement_rule);
2097: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_disbursement_group =>'|| r_cin_invoice.disbursement_group);
2098: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_cin_date_invoiced =>'|| r_cin_invoice.cin_date_invoiced);

Line 2096: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_disbursement_rule =>'|| r_cin_invoice.disbursement_rule);

2092: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_legal_entity_id =>'|| r_cin_invoice.legal_entity_id);
2093: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_vpa_id =>'|| r_cin_invoice.vpa_id);
2094: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_invoice_type =>'|| r_cin_invoice.invoice_type);
2095: -- ,p_contract_group => r_cin_invoice.contract_group
2096: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_disbursement_rule =>'|| r_cin_invoice.disbursement_rule);
2097: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_disbursement_group =>'|| r_cin_invoice.disbursement_group);
2098: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_cin_date_invoiced =>'|| r_cin_invoice.cin_date_invoiced);
2099:
2100: -- go through all cin lines

Line 2097: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_disbursement_group =>'|| r_cin_invoice.disbursement_group);

2093: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_vpa_id =>'|| r_cin_invoice.vpa_id);
2094: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_invoice_type =>'|| r_cin_invoice.invoice_type);
2095: -- ,p_contract_group => r_cin_invoice.contract_group
2096: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_disbursement_rule =>'|| r_cin_invoice.disbursement_rule);
2097: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_disbursement_group =>'|| r_cin_invoice.disbursement_group);
2098: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_cin_date_invoiced =>'|| r_cin_invoice.cin_date_invoiced);
2099:
2100: -- go through all cin lines
2101: FOR r_invoice IN c_invoice(

Line 2098: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_cin_date_invoiced =>'|| r_cin_invoice.cin_date_invoiced);

2094: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_invoice_type =>'|| r_cin_invoice.invoice_type);
2095: -- ,p_contract_group => r_cin_invoice.contract_group
2096: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_disbursement_rule =>'|| r_cin_invoice.disbursement_rule);
2097: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_disbursement_group =>'|| r_cin_invoice.disbursement_group);
2098: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2 ,p_cin_date_invoiced =>'|| r_cin_invoice.cin_date_invoiced);
2099:
2100: -- go through all cin lines
2101: FOR r_invoice IN c_invoice(
2102: p_vendor_id => r_cin_invoice.vendor_id

Line 2122: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2: in loop:cin_cnt<' || cin_cnt || '>');

2118: ,p_disbursement_group => r_cin_invoice.disbursement_group
2119: ,p_cin_date_invoiced => r_cin_invoice.cin_date_invoiced
2120: ) LOOP
2121:
2122: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 2: in loop:cin_cnt<' || cin_cnt || '>');
2123: -- 1. create cin header
2124: IF cin_cnt = 0 THEN
2125: -- get all attributes and assign to cin record
2126: l_cin_rec.amount := r_cin_invoice.cin_invoice_amount;

Line 2132: -- FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 3r_cin_invoice.line_count: '

2128: l_cin_rec.date_invoiced := r_cin_invoice.cin_date_invoiced;
2129:
2130: --start:| 30-Nov-2007 cklee -- bug: 6628542 fixed |
2131: -- 1 header and 1 line case
2132: -- FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 3r_cin_invoice.line_count: '
2133: -- || r_cin_invoice.line_count );
2134: -- IF r_cin_invoice.line_count = 1 THEN
2135: -- l_cin_rec.vendor_invoice_number := r_invoice.vendor_invoice_number;
2136: -- l_cin_rec.invoice_number := r_invoice.invoice_number;

Line 2139: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 4 fnd_seqnum.get_next_sequence: r_invoice.sob_id' || r_invoice.sob_id );

2135: -- l_cin_rec.vendor_invoice_number := r_invoice.vendor_invoice_number;
2136: -- l_cin_rec.invoice_number := r_invoice.invoice_number;
2137: -- ELSE -- 1 header and multiple lines case
2138: l_gen_seq := NULL;
2139: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 4 fnd_seqnum.get_next_sequence: r_invoice.sob_id' || r_invoice.sob_id );
2140:
2141: FOR v_cnt In 1..2 LOOP
2142: l_gen_seq := fnd_seqnum.get_next_sequence
2143: (appid => l_okl_application_id,

Line 2152: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 5 fnd_seqnum.get_next_sequence: l_gen_seq(l_cin_rec.vendor_invoice_number- AP invoice number)' || l_gen_seq );

2148: dbseqnm => lx_dbseqnm,
2149: dbseqid => lx_dbseqid);
2150:
2151: IF v_cnt = 1 THEN
2152: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 5 fnd_seqnum.get_next_sequence: l_gen_seq(l_cin_rec.vendor_invoice_number- AP invoice number)' || l_gen_seq );
2153: l_cin_rec.vendor_invoice_number := l_gen_seq;
2154: ELSE
2155: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 5 fnd_seqnum.get_next_sequence: l_gen_seq(l_cin_rec.invoice_number- AP voucher number)' || l_gen_seq );
2156: l_cin_rec.invoice_number := l_gen_seq;

Line 2155: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 5 fnd_seqnum.get_next_sequence: l_gen_seq(l_cin_rec.invoice_number- AP voucher number)' || l_gen_seq );

2151: IF v_cnt = 1 THEN
2152: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 5 fnd_seqnum.get_next_sequence: l_gen_seq(l_cin_rec.vendor_invoice_number- AP invoice number)' || l_gen_seq );
2153: l_cin_rec.vendor_invoice_number := l_gen_seq;
2154: ELSE
2155: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 5 fnd_seqnum.get_next_sequence: l_gen_seq(l_cin_rec.invoice_number- AP voucher number)' || l_gen_seq );
2156: l_cin_rec.invoice_number := l_gen_seq;
2157: END IF;
2158: END LOOP;
2159:

Line 2181: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get and set vendor invoice sequence.');

2177: x_next_inv_seq => l_cin_rec.self_bill_inv_num);
2178:
2179:
2180: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2181: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get and set vendor invoice sequence.');
2182: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2183: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2184: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get and set vendor invoice sequence.');
2185: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2184: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get and set vendor invoice sequence.');

2180: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2181: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get and set vendor invoice sequence.');
2182: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2183: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2184: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get and set vendor invoice sequence.');
2185: RAISE OKL_API.G_EXCEPTION_ERROR;
2186: ELSIF (x_return_status ='S') THEN
2187: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' handle_next_invoice_seq: ' || l_cin_rec.self_bill_inv_num);
2188: END IF;

Line 2187: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' handle_next_invoice_seq: ' || l_cin_rec.self_bill_inv_num);

2183: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2184: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get and set vendor invoice sequence.');
2185: RAISE OKL_API.G_EXCEPTION_ERROR;
2186: ELSIF (x_return_status ='S') THEN
2187: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' handle_next_invoice_seq: ' || l_cin_rec.self_bill_inv_num);
2188: END IF;
2189:
2190: l_cin_rec.org_id := r_invoice.org_id;
2191: l_cin_rec.trx_status_code := 'ENTERED';--r_invoice.trx_status_code;

Line 2225: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' (apply_consolidation_rules)ERROR: Creating Consolidated invoices.');

2221: p_cin_rec => l_cin_rec,
2222: x_cin_rec => lx_cin_rec);
2223:
2224: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2225: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' (apply_consolidation_rules)ERROR: Creating Consolidated invoices.');
2226: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2227: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2228: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' (apply_consolidation_rules)ERROR: Creating Consolidated invoices.');
2229: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2228: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' (apply_consolidation_rules)ERROR: Creating Consolidated invoices.');

2224: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2225: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' (apply_consolidation_rules)ERROR: Creating Consolidated invoices.');
2226: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2227: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2228: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' (apply_consolidation_rules)ERROR: Creating Consolidated invoices.');
2229: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2230: ELSIF (x_return_status ='S') THEN
2231: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' (apply_consolidation_rules)Created Consolidated invoices: '||lx_cin_rec.cnsld_ap_inv_id);
2232: END IF;

Line 2231: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' (apply_consolidation_rules)Created Consolidated invoices: '||lx_cin_rec.cnsld_ap_inv_id);

2227: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2228: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' (apply_consolidation_rules)ERROR: Creating Consolidated invoices.');
2229: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2230: ELSIF (x_return_status ='S') THEN
2231: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' (apply_consolidation_rules)Created Consolidated invoices: '||lx_cin_rec.cnsld_ap_inv_id);
2232: END IF;
2233:
2234: cin_cnt := cin_cnt + 1; -- create header only once
2235: END IF; -- IF cin_cnt = 0 THEN

Line 2246: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' update okl_txl_ap_inv_lns_all_b with FK: cnsld_ap_inv_id and cnsld_line_number. cin_ln_cnt:<'

2242: txl.LAST_UPDATED_BY = fnd_global.user_id,
2243: txl.LAST_UPDATE_DATE = sysdate,
2244: txl.REQUEST_ID = Fnd_Global.CONC_REQUEST_ID -- 11-Dec-2007 cklee -- Fixed bug: 6682348 -- stamped request_id when insert/UPDATE
2245: WHERE txl.id = r_invoice.tpl_id;
2246: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' update okl_txl_ap_inv_lns_all_b with FK: cnsld_ap_inv_id and cnsld_line_number. cin_ln_cnt:<'
2247: || cin_ln_cnt || '>r_invoice.tpl_id:' ||r_invoice.tpl_id || 'lx_cin_rec.cnsld_ap_inv_id:'|| lx_cin_rec.cnsld_ap_inv_id);
2248:
2249: l_tplv_tbl(cin_ln_cnt).tap_id := r_invoice.tap_id;
2250: END LOOP; -- end of c_invoice loop

Line 2267: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' UPDATE OKL_TRX_AP_INVS_ALL_B with Processed status.l_tplv_tbl('

2263: SET trx.TRX_STATUS_CODE = 'PROCESSED',
2264: trx.REQUEST_ID = Fnd_Global.CONC_REQUEST_ID -- 11-Dec-2007 cklee -- Fixed bug: 6682348 -- stamped request_id when insert/UPDATE
2265: WHERE trx.ID = l_tplv_tbl(k).tap_id
2266: AND trx.TRX_STATUS_CODE IN ('ENTERED', 'APPROVED');
2267: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' UPDATE OKL_TRX_AP_INVS_ALL_B with Processed status.l_tplv_tbl('
2268: ||k||').tap_id'|| l_tplv_tbl(k).tap_id);
2269:
2270: END LOOP;
2271: END IF;

Line 2285: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' UPDATE OKL_TRX_AP_INVS_ALL_B with Error status.l_tplv_tbl(' ||j||').tap_id'|| l_tplv_tbl(j).tap_id);

2281: SET trx.TRX_STATUS_CODE = 'ERROR',
2282: trx.REQUEST_ID = Fnd_Global.CONC_REQUEST_ID -- 11-Dec-2007 cklee -- Fixed bug: 6682348 -- stamped request_id when insert/UPDATE
2283: WHERE trx.ID = l_tplv_tbl(j).tap_id
2284: AND trx.TRX_STATUS_CODE IN ('ENTERED', 'APPROVED');
2285: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' UPDATE OKL_TRX_AP_INVS_ALL_B with Error status.l_tplv_tbl(' ||j||').tap_id'|| l_tplv_tbl(j).tap_id);
2286:
2287: END LOOP;
2288: END IF;
2289: END;

Line 2305: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

2301: ------------------------------------------------------------
2302: -- Exception handling
2303: ------------------------------------------------------------
2304: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2305: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2306: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2307: p_api_name => l_api_name,
2308: p_pkg_name => G_PKG_NAME,
2309: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2315: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

2311: x_msg_data => x_msg_data,
2312: p_api_type => '_PVT');
2313:
2314: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2315: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2316: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2317: p_api_name => l_api_name,
2318: p_pkg_name => G_PKG_NAME,
2319: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2325: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

2321: x_msg_data => x_msg_data,
2322: p_api_type => '_PVT');
2323:
2324: WHEN OTHERS THEN
2325: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2326: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2327: p_api_name => l_api_name,
2328: p_pkg_name => G_PKG_NAME,
2329: p_exc_name => 'OTHERS',

Line 2506: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');

2502: END LOOP; --> Header
2503:
2504: COMMIT;
2505:
2506: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
2507: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* End Processing Records ******* ');
2508: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
2509:
2510: ------------------------------------------------------------

Line 2507: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' * End Processing Records * ');

2503:
2504: COMMIT;
2505:
2506: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
2507: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* End Processing Records ******* ');
2508: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
2509:
2510: ------------------------------------------------------------
2511: -- End processing

Line 2508: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');

2504: COMMIT;
2505:
2506: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
2507: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* End Processing Records ******* ');
2508: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
2509:
2510: ------------------------------------------------------------
2511: -- End processing
2512: ------------------------------------------------------------

Line 2523: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

2519: ------------------------------------------------------------
2520: -- Exception handling
2521: ------------------------------------------------------------
2522: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2523: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2524: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2525: p_api_name => l_api_name,
2526: p_pkg_name => G_PKG_NAME,
2527: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2533: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

2529: x_msg_data => x_msg_data,
2530: p_api_type => '_PVT');
2531:
2532: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2533: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2534: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2535: p_api_name => l_api_name,
2536: p_pkg_name => G_PKG_NAME,
2537: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2543: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

2539: x_msg_data => x_msg_data,
2540: p_api_type => '_PVT');
2541:
2542: WHEN OTHERS THEN
2543: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2544: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2545: p_api_name => l_api_name,
2546: p_pkg_name => G_PKG_NAME,
2547: p_exc_name => 'OTHERS',

Line 2708: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');

2704: l_xpiv_rec.vendor_invoice_number := r_cnsld_hdr.vendor_invoice_number;
2705: l_xpiv_rec.invoice_num := r_cnsld_hdr.invoice_number;
2706:
2707:
2708: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
2709: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Invoice Number: '||r_cnsld_hdr.vendor_invoice_number);
2710: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
2711:
2712: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

Line 2709: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Invoice Number: '||r_cnsld_hdr.vendor_invoice_number);

2705: l_xpiv_rec.invoice_num := r_cnsld_hdr.invoice_number;
2706:
2707:
2708: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
2709: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Invoice Number: '||r_cnsld_hdr.vendor_invoice_number);
2710: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
2711:
2712: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
2713: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||r_cnsld_hdr.set_of_books_id||' Org Id: '||r_cnsld_hdr.org_id||' Invoice Number: '||r_cnsld_hdr.invoice_number );

Line 2710: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');

2706:
2707:
2708: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
2709: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Invoice Number: '||r_cnsld_hdr.vendor_invoice_number);
2710: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
2711:
2712: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
2713: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||r_cnsld_hdr.set_of_books_id||' Org Id: '||r_cnsld_hdr.org_id||' Invoice Number: '||r_cnsld_hdr.invoice_number );
2714: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||r_cnsld_hdr.ipvs_id||' Terms Id(ippt_id): '||r_cnsld_hdr.ippt_id||' Payment Method Code: '||r_cnsld_hdr.payment_method_code );

Line 2712: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

2708: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
2709: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Invoice Number: '||r_cnsld_hdr.vendor_invoice_number);
2710: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
2711:
2712: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
2713: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||r_cnsld_hdr.set_of_books_id||' Org Id: '||r_cnsld_hdr.org_id||' Invoice Number: '||r_cnsld_hdr.invoice_number );
2714: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||r_cnsld_hdr.ipvs_id||' Terms Id(ippt_id): '||r_cnsld_hdr.ippt_id||' Payment Method Code: '||r_cnsld_hdr.payment_method_code );
2715: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||r_cnsld_hdr.currency_code||' GL Date: '||r_cnsld_hdr.date_gl );
2716: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ try_id: '||r_cnsld_hdr.try_id);

Line 2713: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||r_cnsld_hdr.set_of_books_id||' Org Id: '||r_cnsld_hdr.org_id||' Invoice Number: '||r_cnsld_hdr.invoice_number );

2709: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Invoice Number: '||r_cnsld_hdr.vendor_invoice_number);
2710: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
2711:
2712: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
2713: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||r_cnsld_hdr.set_of_books_id||' Org Id: '||r_cnsld_hdr.org_id||' Invoice Number: '||r_cnsld_hdr.invoice_number );
2714: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||r_cnsld_hdr.ipvs_id||' Terms Id(ippt_id): '||r_cnsld_hdr.ippt_id||' Payment Method Code: '||r_cnsld_hdr.payment_method_code );
2715: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||r_cnsld_hdr.currency_code||' GL Date: '||r_cnsld_hdr.date_gl );
2716: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ try_id: '||r_cnsld_hdr.try_id);
2717: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ ccid: '||r_cnsld_hdr.accts_pay_cc_id);

Line 2714: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||r_cnsld_hdr.ipvs_id||' Terms Id(ippt_id): '||r_cnsld_hdr.ippt_id||' Payment Method Code: '||r_cnsld_hdr.payment_method_code );

2710: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
2711:
2712: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
2713: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||r_cnsld_hdr.set_of_books_id||' Org Id: '||r_cnsld_hdr.org_id||' Invoice Number: '||r_cnsld_hdr.invoice_number );
2714: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||r_cnsld_hdr.ipvs_id||' Terms Id(ippt_id): '||r_cnsld_hdr.ippt_id||' Payment Method Code: '||r_cnsld_hdr.payment_method_code );
2715: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||r_cnsld_hdr.currency_code||' GL Date: '||r_cnsld_hdr.date_gl );
2716: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ try_id: '||r_cnsld_hdr.try_id);
2717: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ ccid: '||r_cnsld_hdr.accts_pay_cc_id);
2718: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ invoice_amount: '||r_cnsld_hdr.amount||' Vendor Id: '||r_cnsld_hdr.vendor_id);

Line 2715: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||r_cnsld_hdr.currency_code||' GL Date: '||r_cnsld_hdr.date_gl );

2711:
2712: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
2713: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||r_cnsld_hdr.set_of_books_id||' Org Id: '||r_cnsld_hdr.org_id||' Invoice Number: '||r_cnsld_hdr.invoice_number );
2714: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||r_cnsld_hdr.ipvs_id||' Terms Id(ippt_id): '||r_cnsld_hdr.ippt_id||' Payment Method Code: '||r_cnsld_hdr.payment_method_code );
2715: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||r_cnsld_hdr.currency_code||' GL Date: '||r_cnsld_hdr.date_gl );
2716: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ try_id: '||r_cnsld_hdr.try_id);
2717: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ ccid: '||r_cnsld_hdr.accts_pay_cc_id);
2718: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ invoice_amount: '||r_cnsld_hdr.amount||' Vendor Id: '||r_cnsld_hdr.vendor_id);
2719: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

Line 2716: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ try_id: '||r_cnsld_hdr.try_id);

2712: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
2713: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||r_cnsld_hdr.set_of_books_id||' Org Id: '||r_cnsld_hdr.org_id||' Invoice Number: '||r_cnsld_hdr.invoice_number );
2714: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||r_cnsld_hdr.ipvs_id||' Terms Id(ippt_id): '||r_cnsld_hdr.ippt_id||' Payment Method Code: '||r_cnsld_hdr.payment_method_code );
2715: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||r_cnsld_hdr.currency_code||' GL Date: '||r_cnsld_hdr.date_gl );
2716: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ try_id: '||r_cnsld_hdr.try_id);
2717: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ ccid: '||r_cnsld_hdr.accts_pay_cc_id);
2718: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ invoice_amount: '||r_cnsld_hdr.amount||' Vendor Id: '||r_cnsld_hdr.vendor_id);
2719: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
2720:

Line 2717: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ ccid: '||r_cnsld_hdr.accts_pay_cc_id);

2713: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||r_cnsld_hdr.set_of_books_id||' Org Id: '||r_cnsld_hdr.org_id||' Invoice Number: '||r_cnsld_hdr.invoice_number );
2714: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||r_cnsld_hdr.ipvs_id||' Terms Id(ippt_id): '||r_cnsld_hdr.ippt_id||' Payment Method Code: '||r_cnsld_hdr.payment_method_code );
2715: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||r_cnsld_hdr.currency_code||' GL Date: '||r_cnsld_hdr.date_gl );
2716: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ try_id: '||r_cnsld_hdr.try_id);
2717: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ ccid: '||r_cnsld_hdr.accts_pay_cc_id);
2718: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ invoice_amount: '||r_cnsld_hdr.amount||' Vendor Id: '||r_cnsld_hdr.vendor_id);
2719: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
2720:
2721:

Line 2718: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ invoice_amount: '||r_cnsld_hdr.amount||' Vendor Id: '||r_cnsld_hdr.vendor_id);

2714: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||r_cnsld_hdr.ipvs_id||' Terms Id(ippt_id): '||r_cnsld_hdr.ippt_id||' Payment Method Code: '||r_cnsld_hdr.payment_method_code );
2715: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||r_cnsld_hdr.currency_code||' GL Date: '||r_cnsld_hdr.date_gl );
2716: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ try_id: '||r_cnsld_hdr.try_id);
2717: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ ccid: '||r_cnsld_hdr.accts_pay_cc_id);
2718: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ invoice_amount: '||r_cnsld_hdr.amount||' Vendor Id: '||r_cnsld_hdr.vendor_id);
2719: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
2720:
2721:
2722:

Line 2719: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

2715: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||r_cnsld_hdr.currency_code||' GL Date: '||r_cnsld_hdr.date_gl );
2716: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ try_id: '||r_cnsld_hdr.try_id);
2717: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ ccid: '||r_cnsld_hdr.accts_pay_cc_id);
2718: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ invoice_amount: '||r_cnsld_hdr.amount||' Vendor Id: '||r_cnsld_hdr.vendor_id);
2719: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
2720:
2721:
2722:
2723: OPEN seq_csr;

Line 2727: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Invoice id: '||l_xpiv_rec.invoice_id);

2723: OPEN seq_csr;
2724: FETCH seq_csr INTO l_xpiv_rec.invoice_id;
2725: CLOSE seq_csr;
2726:
2727: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Invoice id: '||l_xpiv_rec.invoice_id);
2728:
2729: l_xpiv_rec.invoice_type := r_cnsld_hdr.invoice_type;
2730: l_xpiv_rec.invoice_date := r_cnsld_hdr.date_invoiced;
2731: l_xpiv_rec.vendor_id := r_cnsld_hdr.vendor_id;

Line 2775: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Creating External AP Invoice Header..');

2771: l_xpiv_rec.cnsld_ap_inv_id := r_cnsld_hdr.cnsld_ap_inv_id;
2772: l_xpiv_rec.REQUEST_ID := Fnd_Global.CONC_REQUEST_ID ; -- 11-Dec-2007 cklee -- Fixed bug: 6682348 -- stamped request_id when insert
2773:
2774:
2775: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Creating External AP Invoice Header..');
2776:
2777: -- Start of wraper code generated automatically by Debug code generator for OKL_EXT_PAY_INVS_PUB.insert_ext_pay_invs
2778: IF(L_DEBUG_ENABLED='Y') THEN
2779: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;

Line 2806: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');

2802: END IF;
2803: -- End of wraper code generated automatically by Debug code generator for OKL_EXT_PAY_INVS_PUB.insert_ext_pay_invs
2804: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2805: l_conc_status := 'E';
2806: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
2807: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2808: l_conc_status := 'E';
2809: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
2810: ELSIF (x_return_status ='S') THEN

Line 2809: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');

2805: l_conc_status := 'E';
2806: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
2807: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2808: l_conc_status := 'E';
2809: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
2810: ELSIF (x_return_status ='S') THEN
2811: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Header with Id: '||lx_xpiv_rec.id);
2812: END IF;
2813:

Line 2811: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Header with Id: '||lx_xpiv_rec.id);

2807: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2808: l_conc_status := 'E';
2809: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
2810: ELSIF (x_return_status ='S') THEN
2811: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Header with Id: '||lx_xpiv_rec.id);
2812: END IF;
2813:
2814: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Creating External AP Invoice Lines..');
2815: --Processing the Consolidated lines for transfer to external lines table

Line 2814: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Creating External AP Invoice Lines..');

2810: ELSIF (x_return_status ='S') THEN
2811: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Header with Id: '||lx_xpiv_rec.id);
2812: END IF;
2813:
2814: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Creating External AP Invoice Lines..');
2815: --Processing the Consolidated lines for transfer to external lines table
2816: FOR r_cnsld_lns IN c_cnsld_lns(r_cnsld_hdr.cnsld_ap_inv_id) LOOP
2817: l_commit_cnt := l_commit_cnt + 1;
2818: IF nvl(r_cnsld_lns.CR_DR_FLAG, 'D') = 'D' THEN

Line 2894: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');

2890: -- End of wraper code generated automatically by Debug code generator for okl_xtl_pay_invs_pub.insert_xtl_pay_invs
2891:
2892: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2893: l_conc_status := 'E';
2894: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
2895: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2896: l_conc_status := 'E';
2897: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
2898: ELSIF (x_return_status ='S') THEN

Line 2897: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');

2893: l_conc_status := 'E';
2894: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
2895: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2896: l_conc_status := 'E';
2897: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
2898: ELSIF (x_return_status ='S') THEN
2899: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Line with Id: '||lx_xlpv_rec.id);
2900: END IF;
2901:

Line 2899: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Line with Id: '||lx_xlpv_rec.id);

2895: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2896: l_conc_status := 'E';
2897: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
2898: ELSIF (x_return_status ='S') THEN
2899: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Line with Id: '||lx_xlpv_rec.id);
2900: END IF;
2901:
2902: IF l_commit_cnt > l_MAX_commit_cnt THEN
2903: COMMIT;

Line 2913: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Successfully Prepared Invoice Number : ' || r_cnsld_hdr.invoice_number);

2909: IF ( NVL(l_conc_status, 'E') = okl_api.g_ret_sts_success ) THEN
2910: -----------------------------------------------------------------
2911: -- Update internal AP table for Success
2912: -----------------------------------------------------------------
2913: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Successfully Prepared Invoice Number : ' || r_cnsld_hdr.invoice_number);
2914:
2915: UPDATE OKL_CNSLD_AP_INVS
2916: SET TRX_STATUS_CODE = 'PROCESSED'
2917: WHERE CNSLD_AP_INV_ID = r_cnsld_hdr.cnsld_ap_inv_id;

Line 2922: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'*=>ERROR: Processing Invoice Number : ' || r_cnsld_hdr.invoice_number);

2918: ELSE
2919: -----------------------------------------------------------------
2920: -- Update internal AP table for Error
2921: -----------------------------------------------------------------
2922: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'*=>ERROR: Processing Invoice Number : ' || r_cnsld_hdr.invoice_number);
2923: IF x_msg_count >= 1 THEN
2924: FOR i in 1..x_msg_count LOOP
2925: fnd_msg_pub.get (p_msg_index => i,
2926: p_encoded => 'F',

Line 2930: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,to_char(i) || ': ' || x_msg_data);

2926: p_encoded => 'F',
2927: p_data => x_msg_data,
2928: p_msg_index_out => l_msg_index_out);
2929:
2930: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,to_char(i) || ': ' || x_msg_data);
2931:
2932: END LOOP;
2933: END IF;
2934: --start: cklee 4/26/07

Line 2949: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');

2945: END LOOP; --> Header
2946:
2947: COMMIT;
2948:
2949: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
2950: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* End Processing Records ******* ');
2951: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
2952:
2953: ------------------------------------------------------------

Line 2950: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' * End Processing Records * ');

2946:
2947: COMMIT;
2948:
2949: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
2950: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* End Processing Records ******* ');
2951: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
2952:
2953: ------------------------------------------------------------
2954: -- End processing

Line 2951: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');

2947: COMMIT;
2948:
2949: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
2950: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* End Processing Records ******* ');
2951: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
2952:
2953: ------------------------------------------------------------
2954: -- End processing
2955: ------------------------------------------------------------

Line 2966: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

2962: ------------------------------------------------------------
2963: -- Exception handling
2964: ------------------------------------------------------------
2965: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2966: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2967: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2968: p_api_name => l_api_name,
2969: p_pkg_name => G_PKG_NAME,
2970: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2976: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

2972: x_msg_data => x_msg_data,
2973: p_api_type => '_PVT');
2974:
2975: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2976: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2977: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2978: p_api_name => l_api_name,
2979: p_pkg_name => G_PKG_NAME,
2980: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2986: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

2982: x_msg_data => x_msg_data,
2983: p_api_type => '_PVT');
2984:
2985: WHEN OTHERS THEN
2986: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2987: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2988: p_api_name => l_api_name,
2989: p_pkg_name => G_PKG_NAME,
2990: p_exc_name => 'OTHERS',

Line 3322: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');

3318:
3319: r_invoice.vendor_invoice_number := NVL(r_invoice.vendor_invoice_number,l_gen_seq);
3320: r_invoice.invoice_number := NVL(r_invoice.invoice_number,l_gen_seq);
3321:
3322: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3323: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Invoice Number: '||r_invoice.vendor_invoice_number);
3324: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3325:
3326: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

Line 3323: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Invoice Number: '||r_invoice.vendor_invoice_number);

3319: r_invoice.vendor_invoice_number := NVL(r_invoice.vendor_invoice_number,l_gen_seq);
3320: r_invoice.invoice_number := NVL(r_invoice.invoice_number,l_gen_seq);
3321:
3322: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3323: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Invoice Number: '||r_invoice.vendor_invoice_number);
3324: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3325:
3326: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
3327: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||r_invoice.sob_id||' Org Id: '||r_invoice.org_id||' Invoice Number: '||r_invoice.invoice_number );

Line 3324: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');

3320: r_invoice.invoice_number := NVL(r_invoice.invoice_number,l_gen_seq);
3321:
3322: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3323: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Invoice Number: '||r_invoice.vendor_invoice_number);
3324: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3325:
3326: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
3327: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||r_invoice.sob_id||' Org Id: '||r_invoice.org_id||' Invoice Number: '||r_invoice.invoice_number );
3328: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||r_invoice.ipvs_id||' Terms Id(ippt_id): '||r_invoice.ippt_id||' Payment Method Code: '||r_invoice.payment_method_code );

Line 3326: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

3322: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3323: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Invoice Number: '||r_invoice.vendor_invoice_number);
3324: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3325:
3326: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
3327: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||r_invoice.sob_id||' Org Id: '||r_invoice.org_id||' Invoice Number: '||r_invoice.invoice_number );
3328: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||r_invoice.ipvs_id||' Terms Id(ippt_id): '||r_invoice.ippt_id||' Payment Method Code: '||r_invoice.payment_method_code );
3329: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||r_invoice.currency_code||' GL Date: '||r_invoice.gl_date||' Nettable: '||r_invoice.nettable_yn );
3330: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ khr_id: '||r_invoice.khr_id||' try_id: '||r_invoice.try_id);

Line 3327: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||r_invoice.sob_id||' Org Id: '||r_invoice.org_id||' Invoice Number: '||r_invoice.invoice_number );

3323: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Invoice Number: '||r_invoice.vendor_invoice_number);
3324: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3325:
3326: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
3327: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||r_invoice.sob_id||' Org Id: '||r_invoice.org_id||' Invoice Number: '||r_invoice.invoice_number );
3328: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||r_invoice.ipvs_id||' Terms Id(ippt_id): '||r_invoice.ippt_id||' Payment Method Code: '||r_invoice.payment_method_code );
3329: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||r_invoice.currency_code||' GL Date: '||r_invoice.gl_date||' Nettable: '||r_invoice.nettable_yn );
3330: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ khr_id: '||r_invoice.khr_id||' try_id: '||r_invoice.try_id);
3331: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ db_ccid: '||r_invoice.db_ccid||' cr_ccid: '||r_invoice.cr_ccid);

Line 3328: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||r_invoice.ipvs_id||' Terms Id(ippt_id): '||r_invoice.ippt_id||' Payment Method Code: '||r_invoice.payment_method_code );

3324: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3325:
3326: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
3327: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||r_invoice.sob_id||' Org Id: '||r_invoice.org_id||' Invoice Number: '||r_invoice.invoice_number );
3328: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||r_invoice.ipvs_id||' Terms Id(ippt_id): '||r_invoice.ippt_id||' Payment Method Code: '||r_invoice.payment_method_code );
3329: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||r_invoice.currency_code||' GL Date: '||r_invoice.gl_date||' Nettable: '||r_invoice.nettable_yn );
3330: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ khr_id: '||r_invoice.khr_id||' try_id: '||r_invoice.try_id);
3331: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ db_ccid: '||r_invoice.db_ccid||' cr_ccid: '||r_invoice.cr_ccid);
3332: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ invoice_amount: '||r_invoice.invoice_amount||' Vendor Id: '||r_invoice.vendor_id);

Line 3329: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||r_invoice.currency_code||' GL Date: '||r_invoice.gl_date||' Nettable: '||r_invoice.nettable_yn );

3325:
3326: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
3327: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||r_invoice.sob_id||' Org Id: '||r_invoice.org_id||' Invoice Number: '||r_invoice.invoice_number );
3328: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||r_invoice.ipvs_id||' Terms Id(ippt_id): '||r_invoice.ippt_id||' Payment Method Code: '||r_invoice.payment_method_code );
3329: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||r_invoice.currency_code||' GL Date: '||r_invoice.gl_date||' Nettable: '||r_invoice.nettable_yn );
3330: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ khr_id: '||r_invoice.khr_id||' try_id: '||r_invoice.try_id);
3331: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ db_ccid: '||r_invoice.db_ccid||' cr_ccid: '||r_invoice.cr_ccid);
3332: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ invoice_amount: '||r_invoice.invoice_amount||' Vendor Id: '||r_invoice.vendor_id);
3333: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

Line 3330: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ khr_id: '||r_invoice.khr_id||' try_id: '||r_invoice.try_id);

3326: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
3327: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||r_invoice.sob_id||' Org Id: '||r_invoice.org_id||' Invoice Number: '||r_invoice.invoice_number );
3328: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||r_invoice.ipvs_id||' Terms Id(ippt_id): '||r_invoice.ippt_id||' Payment Method Code: '||r_invoice.payment_method_code );
3329: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||r_invoice.currency_code||' GL Date: '||r_invoice.gl_date||' Nettable: '||r_invoice.nettable_yn );
3330: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ khr_id: '||r_invoice.khr_id||' try_id: '||r_invoice.try_id);
3331: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ db_ccid: '||r_invoice.db_ccid||' cr_ccid: '||r_invoice.cr_ccid);
3332: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ invoice_amount: '||r_invoice.invoice_amount||' Vendor Id: '||r_invoice.vendor_id);
3333: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
3334: END IF;

Line 3331: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ db_ccid: '||r_invoice.db_ccid||' cr_ccid: '||r_invoice.cr_ccid);

3327: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||r_invoice.sob_id||' Org Id: '||r_invoice.org_id||' Invoice Number: '||r_invoice.invoice_number );
3328: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||r_invoice.ipvs_id||' Terms Id(ippt_id): '||r_invoice.ippt_id||' Payment Method Code: '||r_invoice.payment_method_code );
3329: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||r_invoice.currency_code||' GL Date: '||r_invoice.gl_date||' Nettable: '||r_invoice.nettable_yn );
3330: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ khr_id: '||r_invoice.khr_id||' try_id: '||r_invoice.try_id);
3331: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ db_ccid: '||r_invoice.db_ccid||' cr_ccid: '||r_invoice.cr_ccid);
3332: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ invoice_amount: '||r_invoice.invoice_amount||' Vendor Id: '||r_invoice.vendor_id);
3333: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
3334: END IF;
3335:

Line 3332: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ invoice_amount: '||r_invoice.invoice_amount||' Vendor Id: '||r_invoice.vendor_id);

3328: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||r_invoice.ipvs_id||' Terms Id(ippt_id): '||r_invoice.ippt_id||' Payment Method Code: '||r_invoice.payment_method_code );
3329: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||r_invoice.currency_code||' GL Date: '||r_invoice.gl_date||' Nettable: '||r_invoice.nettable_yn );
3330: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ khr_id: '||r_invoice.khr_id||' try_id: '||r_invoice.try_id);
3331: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ db_ccid: '||r_invoice.db_ccid||' cr_ccid: '||r_invoice.cr_ccid);
3332: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ invoice_amount: '||r_invoice.invoice_amount||' Vendor Id: '||r_invoice.vendor_id);
3333: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
3334: END IF;
3335:
3336: -- SAVEPOINT C_INVOICE_POINT;

Line 3333: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

3329: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||r_invoice.currency_code||' GL Date: '||r_invoice.gl_date||' Nettable: '||r_invoice.nettable_yn );
3330: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ khr_id: '||r_invoice.khr_id||' try_id: '||r_invoice.try_id);
3331: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ db_ccid: '||r_invoice.db_ccid||' cr_ccid: '||r_invoice.cr_ccid);
3332: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ invoice_amount: '||r_invoice.invoice_amount||' Vendor Id: '||r_invoice.vendor_id);
3333: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
3334: END IF;
3335:
3336: -- SAVEPOINT C_INVOICE_POINT;
3337:

Line 3340: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Creating Payables Invoice');

3336: -- SAVEPOINT C_INVOICE_POINT;
3337:
3338: IF NVL(r_invoice.nettable_yn, 'N') = 'N' OR r_invoice.invoice_amount > 0 THEN
3339: IF (NVL(l_previous_tap_id, -99) <> r_invoice.tap_id) THEN
3340: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Creating Payables Invoice');
3341:
3342: -----------------------------------------------------------------
3343: -- Populate and insert external AP invoice header
3344: -----------------------------------------------------------------

Line 3351: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Invoice id: '||l_xpiv_rec.invoice_id);

3347: OPEN seq_csr;
3348: FETCH seq_csr INTO l_xpiv_rec.invoice_id;
3349: CLOSE seq_csr;
3350:
3351: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Invoice id: '||l_xpiv_rec.invoice_id);
3352:
3353: l_xpiv_rec.doc_category_code := r_invoice.invoice_category_code;
3354: l_xpiv_rec.invoice_num := r_invoice.invoice_number;
3355: l_xpiv_rec.vendor_invoice_number:= r_invoice.vendor_invoice_number;

Line 3440: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Creating External AP Invoice Header..');

3436: p_con_type => l_xpiv_rec.currency_conversion_type);
3437: */
3438: END IF;
3439:
3440: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Creating External AP Invoice Header..');
3441:
3442: -- Start of wraper code generated automatically by Debug code generator for OKL_EXT_PAY_INVS_PUB.insert_ext_pay_invs
3443: IF(L_DEBUG_ENABLED='Y') THEN
3444: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;

Line 3470: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');

3466: END IF;
3467: -- End of wraper code generated automatically by Debug code generator for OKL_EXT_PAY_INVS_PUB.insert_ext_pay_invs
3468: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3469: l_conc_status := 'E';
3470: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
3471: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3472: l_conc_status := 'E';
3473: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
3474: ELSIF (x_return_status ='S') THEN

Line 3473: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');

3469: l_conc_status := 'E';
3470: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
3471: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3472: l_conc_status := 'E';
3473: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
3474: ELSIF (x_return_status ='S') THEN
3475: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Header with Id: '||lx_xpiv_rec.id);
3476: END IF;
3477:

Line 3475: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Header with Id: '||lx_xpiv_rec.id);

3471: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3472: l_conc_status := 'E';
3473: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
3474: ELSIF (x_return_status ='S') THEN
3475: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Header with Id: '||lx_xpiv_rec.id);
3476: END IF;
3477:
3478: l_previous_tap_id := r_invoice.tap_id;
3479: l_previous_xpi_id := lx_xpiv_rec.id;

Line 3493: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Creating External AP Invoice Lines..');

3489: l_xlpv_rec.dist_code_combination_id := NVL(r_invoice.tpl_ccid,r_invoice.db_ccid);
3490: l_xlpv_rec.tpl_id := r_invoice.tpl_id;
3491:
3492:
3493: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Creating External AP Invoice Lines..');
3494: -- Start of wraper code generated automatically by Debug code generator for okl_xtl_pay_invs_pub.insert_xtl_pay_invs
3495: IF(IS_DEBUG_PROCEDURE_ON) THEN
3496: BEGIN
3497: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPICB.pls call okl_xtl_pay_invs_pub.insert_xtl_pay_invs ');

Line 3517: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');

3513: -- End of wraper code generated automatically by Debug code generator for okl_xtl_pay_invs_pub.insert_xtl_pay_invs
3514:
3515: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3516: l_conc_status := 'E';
3517: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
3518: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3519: l_conc_status := 'E';
3520: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
3521: ELSIF (x_return_status ='S') THEN

Line 3520: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');

3516: l_conc_status := 'E';
3517: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
3518: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3519: l_conc_status := 'E';
3520: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
3521: ELSIF (x_return_status ='S') THEN
3522: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Line with Id: '||lx_xlpv_rec.id);
3523: END IF;
3524:

Line 3522: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Line with Id: '||lx_xlpv_rec.id);

3518: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3519: l_conc_status := 'E';
3520: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
3521: ELSIF (x_return_status ='S') THEN
3522: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Line with Id: '||lx_xlpv_rec.id);
3523: END IF;
3524:
3525: ELSE
3526: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Creating Receviables Invoice');

Line 3526: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Creating Receviables Invoice');

3522: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Line with Id: '||lx_xlpv_rec.id);
3523: END IF;
3524:
3525: ELSE
3526: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Creating Receviables Invoice');
3527:
3528: -----------------------------------------------------------------
3529: -- Populate external AR invoice header and line record
3530: -----------------------------------------------------------------

Line 3544: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Creating Internal AR Invoice Header..');

3540: l_taiv_rec.trx_status_code := 'ENTERED';
3541: l_taiv_rec.try_id := r_invoice.try_id ;
3542:
3543:
3544: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Creating Internal AR Invoice Header..');
3545:
3546: -- Start of wraper code generated automatically by Debug code generator for okl_trx_ar_invoices_pub.insert_trx_ar_invoices
3547: IF(IS_DEBUG_PROCEDURE_ON) THEN
3548: BEGIN

Line 3569: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Header.');

3565: -- End of wraper code generated automatically by Debug code generator for okl_trx_ar_invoices_pub.insert_trx_ar_invoices
3566:
3567: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3568: l_conc_status := 'E';
3569: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Header.');
3570: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3571: l_conc_status := 'E';
3572: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Header.');
3573: ELSIF (x_return_status ='S') THEN

Line 3572: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Header.');

3568: l_conc_status := 'E';
3569: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Header.');
3570: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3571: l_conc_status := 'E';
3572: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Header.');
3573: ELSIF (x_return_status ='S') THEN
3574: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Internal AR Invoice Header with Id: '||lx_taiv_rec.id);
3575: END IF;
3576:

Line 3574: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Internal AR Invoice Header with Id: '||lx_taiv_rec.id);

3570: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3571: l_conc_status := 'E';
3572: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Header.');
3573: ELSIF (x_return_status ='S') THEN
3574: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Internal AR Invoice Header with Id: '||lx_taiv_rec.id);
3575: END IF;
3576:
3577: -----------------------------------------------------------------
3578: -- Insert external AR invoice line

Line 3590: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Creating Internal AR Invoice Line..');

3586: l_tilv_rec.inv_receiv_line_code := 'LINE';
3587: l_taiv_rec.attribute1 := 'AUTO_DISBURSEMENT';
3588: l_tilv_rec.attribute1 := 'AUTO_DISBURSEMENT';
3589:
3590: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Creating Internal AR Invoice Line..');
3591: -- Start of wraper code generated automatically by Debug code generator for okl_txl_ar_inv_lns_pub.insert_txl_ar_inv_lns
3592: IF(IS_DEBUG_PROCEDURE_ON) THEN
3593: BEGIN
3594: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPICB.pls call okl_txl_ar_inv_lns_pub.insert_txl_ar_inv_lns ');

Line 3614: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Line.');

3610: -- End of wraper code generated automatically by Debug code generator for okl_txl_ar_inv_lns_pub.insert_txl_ar_inv_lns
3611:
3612: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3613: l_conc_status := 'E';
3614: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Line.');
3615: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3616: l_conc_status := 'E';
3617: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Line.');
3618: ELSIF (x_return_status ='S') THEN

Line 3617: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Line.');

3613: l_conc_status := 'E';
3614: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Line.');
3615: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3616: l_conc_status := 'E';
3617: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Line.');
3618: ELSIF (x_return_status ='S') THEN
3619: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Internal AR Invoice Line with Id: '||lx_tilv_rec.id);
3620: END IF;
3621:

Line 3619: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Internal AR Invoice Line with Id: '||lx_tilv_rec.id);

3615: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3616: l_conc_status := 'E';
3617: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Line.');
3618: ELSIF (x_return_status ='S') THEN
3619: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Internal AR Invoice Line with Id: '||lx_tilv_rec.id);
3620: END IF;
3621:
3622: p_bpd_acc_rec.id := lx_tilv_rec.id;
3623: p_bpd_acc_rec.source_table := 'OKL_TXL_AR_INV_LNS_B';

Line 3649: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Accounting Distributions.');

3645: END IF;
3646: -- End of wraper code generated automatically by Debug code generator for Okl_Acc_Call_Pub.CREATE_ACC_TRANS
3647: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3648: l_conc_status := 'E';
3649: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Accounting Distributions.');
3650: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3651: l_conc_status := 'E';
3652: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Accounting Distributions.');
3653: ELSIF (x_return_status ='S') THEN

Line 3652: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Accounting Distributions.');

3648: l_conc_status := 'E';
3649: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Accounting Distributions.');
3650: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3651: l_conc_status := 'E';
3652: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Accounting Distributions.');
3653: ELSIF (x_return_status ='S') THEN
3654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ... Accounting Distributions Created.');
3655: END IF;
3656:

Line 3654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ... Accounting Distributions Created.');

3650: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3651: l_conc_status := 'E';
3652: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Accounting Distributions.');
3653: ELSIF (x_return_status ='S') THEN
3654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ... Accounting Distributions Created.');
3655: END IF;
3656:
3657: END IF;
3658:

Line 3664: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Successfully Prepared Invoice Number : ' || r_invoice.invoice_number);

3660: THEN
3661: -----------------------------------------------------------------
3662: -- Update internal AP table for Success
3663: -----------------------------------------------------------------
3664: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Successfully Prepared Invoice Number : ' || r_invoice.invoice_number);
3665:
3666: UPDATE okl_trx_ap_invoices_b
3667: SET trx_status_code = 'PROCESSED'
3668: WHERE id = r_invoice.tap_id;

Line 3674: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'*=>ERROR: Processing Invoice Number : ' || r_invoice.invoice_number);

3670: ELSE
3671: -----------------------------------------------------------------
3672: -- Update internal AP table for Error
3673: -----------------------------------------------------------------
3674: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'*=>ERROR: Processing Invoice Number : ' || r_invoice.invoice_number);
3675:
3676: IF x_msg_count >= 1 THEN
3677:
3678: FOR i in 1..x_msg_count LOOP

Line 3684: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,to_char(i) || ': ' || x_msg_data);

3680: p_encoded => 'F',
3681: p_data => x_msg_data,
3682: p_msg_index_out => l_msg_index_out);
3683:
3684: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,to_char(i) || ': ' || x_msg_data);
3685:
3686: END LOOP;
3687: END IF;
3688:

Line 3719: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');

3715: l_previous_xpi_id := null;
3716:
3717: -- FUNDING CURSOR
3718:
3719: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3720: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* Begin Funding Records ******* ');
3721: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3722:
3723: FOR fund_rec IN c_funding_csr LOOP

Line 3720: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' * Begin Funding Records * ');

3716:
3717: -- FUNDING CURSOR
3718:
3719: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3720: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* Begin Funding Records ******* ');
3721: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3722:
3723: FOR fund_rec IN c_funding_csr LOOP
3724: IF (NVL(l_previous_tap_id, -99) <> fund_rec.tap_id) THEN

Line 3721: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');

3717: -- FUNDING CURSOR
3718:
3719: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3720: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* Begin Funding Records ******* ');
3721: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3722:
3723: FOR fund_rec IN c_funding_csr LOOP
3724: IF (NVL(l_previous_tap_id, -99) <> fund_rec.tap_id) THEN
3725:

Line 3765: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');

3761:
3762: fund_rec.vendor_invoice_number := NVL(fund_rec.vendor_invoice_number,l_gen_seq);
3763: fund_rec.invoice_number := NVL(fund_rec.invoice_number,l_gen_seq);
3764:
3765: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3766: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Invoice Number: '||fund_rec.vendor_invoice_number);
3767: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3768:
3769: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

Line 3766: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Invoice Number: '||fund_rec.vendor_invoice_number);

3762: fund_rec.vendor_invoice_number := NVL(fund_rec.vendor_invoice_number,l_gen_seq);
3763: fund_rec.invoice_number := NVL(fund_rec.invoice_number,l_gen_seq);
3764:
3765: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3766: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Invoice Number: '||fund_rec.vendor_invoice_number);
3767: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3768:
3769: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
3770: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||fund_rec.sob_id||' Org Id: '||fund_rec.org_id||' Invoice Number: '||fund_rec.invoice_number );

Line 3767: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');

3763: fund_rec.invoice_number := NVL(fund_rec.invoice_number,l_gen_seq);
3764:
3765: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3766: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Invoice Number: '||fund_rec.vendor_invoice_number);
3767: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3768:
3769: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
3770: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||fund_rec.sob_id||' Org Id: '||fund_rec.org_id||' Invoice Number: '||fund_rec.invoice_number );
3771: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||fund_rec.ipvs_id||' Terms Id(ippt_id): '||fund_rec.ippt_id||' Payment Method Code: '||fund_rec.payment_method_code );

Line 3769: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

3765: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3766: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Invoice Number: '||fund_rec.vendor_invoice_number);
3767: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3768:
3769: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
3770: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||fund_rec.sob_id||' Org Id: '||fund_rec.org_id||' Invoice Number: '||fund_rec.invoice_number );
3771: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||fund_rec.ipvs_id||' Terms Id(ippt_id): '||fund_rec.ippt_id||' Payment Method Code: '||fund_rec.payment_method_code );
3772: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||fund_rec.currency_code||' GL Date: '||fund_rec.gl_date||' Nettable: '||fund_rec.nettable_yn );
3773: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ khr_id: '||fund_rec.khr_id||' try_id: '||fund_rec.try_id);

Line 3770: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||fund_rec.sob_id||' Org Id: '||fund_rec.org_id||' Invoice Number: '||fund_rec.invoice_number );

3766: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Processing Vendor Invoice Number: '||fund_rec.vendor_invoice_number);
3767: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3768:
3769: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
3770: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||fund_rec.sob_id||' Org Id: '||fund_rec.org_id||' Invoice Number: '||fund_rec.invoice_number );
3771: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||fund_rec.ipvs_id||' Terms Id(ippt_id): '||fund_rec.ippt_id||' Payment Method Code: '||fund_rec.payment_method_code );
3772: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||fund_rec.currency_code||' GL Date: '||fund_rec.gl_date||' Nettable: '||fund_rec.nettable_yn );
3773: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ khr_id: '||fund_rec.khr_id||' try_id: '||fund_rec.try_id);
3774: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ db_ccid: '||fund_rec.db_ccid||' cr_ccid: '||fund_rec.cr_ccid);

Line 3771: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||fund_rec.ipvs_id||' Terms Id(ippt_id): '||fund_rec.ippt_id||' Payment Method Code: '||fund_rec.payment_method_code );

3767: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
3768:
3769: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
3770: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||fund_rec.sob_id||' Org Id: '||fund_rec.org_id||' Invoice Number: '||fund_rec.invoice_number );
3771: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||fund_rec.ipvs_id||' Terms Id(ippt_id): '||fund_rec.ippt_id||' Payment Method Code: '||fund_rec.payment_method_code );
3772: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||fund_rec.currency_code||' GL Date: '||fund_rec.gl_date||' Nettable: '||fund_rec.nettable_yn );
3773: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ khr_id: '||fund_rec.khr_id||' try_id: '||fund_rec.try_id);
3774: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ db_ccid: '||fund_rec.db_ccid||' cr_ccid: '||fund_rec.cr_ccid);
3775: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ invoice_amount: '||fund_rec.invoice_amount||' Vendor Id: '||fund_rec.vendor_id);

Line 3772: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||fund_rec.currency_code||' GL Date: '||fund_rec.gl_date||' Nettable: '||fund_rec.nettable_yn );

3768:
3769: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
3770: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||fund_rec.sob_id||' Org Id: '||fund_rec.org_id||' Invoice Number: '||fund_rec.invoice_number );
3771: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||fund_rec.ipvs_id||' Terms Id(ippt_id): '||fund_rec.ippt_id||' Payment Method Code: '||fund_rec.payment_method_code );
3772: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||fund_rec.currency_code||' GL Date: '||fund_rec.gl_date||' Nettable: '||fund_rec.nettable_yn );
3773: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ khr_id: '||fund_rec.khr_id||' try_id: '||fund_rec.try_id);
3774: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ db_ccid: '||fund_rec.db_ccid||' cr_ccid: '||fund_rec.cr_ccid);
3775: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ invoice_amount: '||fund_rec.invoice_amount||' Vendor Id: '||fund_rec.vendor_id);
3776: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

Line 3773: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ khr_id: '||fund_rec.khr_id||' try_id: '||fund_rec.try_id);

3769: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
3770: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||fund_rec.sob_id||' Org Id: '||fund_rec.org_id||' Invoice Number: '||fund_rec.invoice_number );
3771: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||fund_rec.ipvs_id||' Terms Id(ippt_id): '||fund_rec.ippt_id||' Payment Method Code: '||fund_rec.payment_method_code );
3772: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||fund_rec.currency_code||' GL Date: '||fund_rec.gl_date||' Nettable: '||fund_rec.nettable_yn );
3773: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ khr_id: '||fund_rec.khr_id||' try_id: '||fund_rec.try_id);
3774: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ db_ccid: '||fund_rec.db_ccid||' cr_ccid: '||fund_rec.cr_ccid);
3775: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ invoice_amount: '||fund_rec.invoice_amount||' Vendor Id: '||fund_rec.vendor_id);
3776: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
3777: END IF;

Line 3774: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ db_ccid: '||fund_rec.db_ccid||' cr_ccid: '||fund_rec.cr_ccid);

3770: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Set of Books: '||fund_rec.sob_id||' Org Id: '||fund_rec.org_id||' Invoice Number: '||fund_rec.invoice_number );
3771: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||fund_rec.ipvs_id||' Terms Id(ippt_id): '||fund_rec.ippt_id||' Payment Method Code: '||fund_rec.payment_method_code );
3772: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||fund_rec.currency_code||' GL Date: '||fund_rec.gl_date||' Nettable: '||fund_rec.nettable_yn );
3773: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ khr_id: '||fund_rec.khr_id||' try_id: '||fund_rec.try_id);
3774: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ db_ccid: '||fund_rec.db_ccid||' cr_ccid: '||fund_rec.cr_ccid);
3775: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ invoice_amount: '||fund_rec.invoice_amount||' Vendor Id: '||fund_rec.vendor_id);
3776: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
3777: END IF;
3778:

Line 3775: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ invoice_amount: '||fund_rec.invoice_amount||' Vendor Id: '||fund_rec.vendor_id);

3771: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Vendor Site (ipvs_id): '||fund_rec.ipvs_id||' Terms Id(ippt_id): '||fund_rec.ippt_id||' Payment Method Code: '||fund_rec.payment_method_code );
3772: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||fund_rec.currency_code||' GL Date: '||fund_rec.gl_date||' Nettable: '||fund_rec.nettable_yn );
3773: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ khr_id: '||fund_rec.khr_id||' try_id: '||fund_rec.try_id);
3774: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ db_ccid: '||fund_rec.db_ccid||' cr_ccid: '||fund_rec.cr_ccid);
3775: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ invoice_amount: '||fund_rec.invoice_amount||' Vendor Id: '||fund_rec.vendor_id);
3776: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
3777: END IF;
3778:
3779: -- SAVEPOINT C_INVOICE_POINT;

Line 3776: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');

3772: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ Currency: '||fund_rec.currency_code||' GL Date: '||fund_rec.gl_date||' Nettable: '||fund_rec.nettable_yn );
3773: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ khr_id: '||fund_rec.khr_id||' try_id: '||fund_rec.try_id);
3774: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ db_ccid: '||fund_rec.db_ccid||' cr_ccid: '||fund_rec.cr_ccid);
3775: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++ invoice_amount: '||fund_rec.invoice_amount||' Vendor Id: '||fund_rec.vendor_id);
3776: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++');
3777: END IF;
3778:
3779: -- SAVEPOINT C_INVOICE_POINT;
3780:

Line 3783: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Creating Payables Invoice');

3779: -- SAVEPOINT C_INVOICE_POINT;
3780:
3781: IF NVL(fund_rec.nettable_yn, 'N') = 'N' OR fund_rec.invoice_amount > 0 THEN
3782: IF (NVL(l_previous_tap_id, -99) <> fund_rec.tap_id) THEN
3783: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Creating Payables Invoice');
3784:
3785: -----------------------------------------------------------------
3786: -- Populate and insert external AP invoice header
3787: -----------------------------------------------------------------

Line 3794: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Invoice id: '||l_xpiv_rec.invoice_id);

3790: OPEN seq_csr;
3791: FETCH seq_csr INTO l_xpiv_rec.invoice_id;
3792: CLOSE seq_csr;
3793:
3794: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Invoice id: '||l_xpiv_rec.invoice_id);
3795:
3796: l_xpiv_rec.doc_category_code := fund_rec.invoice_category_code;
3797: l_xpiv_rec.invoice_num := fund_rec.invoice_number;
3798: l_xpiv_rec.vendor_invoice_number:= fund_rec.vendor_invoice_number;

Line 3885: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Creating External AP Invoice Header..');

3881: */
3882: END IF;
3883:
3884:
3885: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Creating External AP Invoice Header..');
3886:
3887: -- Start of wraper code generated automatically by Debug code generator for OKL_EXT_PAY_INVS_PUB.insert_ext_pay_invs
3888: IF(IS_DEBUG_PROCEDURE_ON) THEN
3889: BEGIN

Line 3912: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');

3908: -- End of wraper code generated automatically by Debug code generator for OKL_EXT_PAY_INVS_PUB.insert_ext_pay_invs
3909:
3910: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3911: l_conc_status := 'E';
3912: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
3913: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3914: l_conc_status := 'E';
3915: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
3916: ELSIF (x_return_status ='S') THEN

Line 3915: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');

3911: l_conc_status := 'E';
3912: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
3913: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3914: l_conc_status := 'E';
3915: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
3916: ELSIF (x_return_status ='S') THEN
3917: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Header with Id: '||lx_xpiv_rec.id);
3918: END IF;
3919:

Line 3917: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Header with Id: '||lx_xpiv_rec.id);

3913: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3914: l_conc_status := 'E';
3915: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
3916: ELSIF (x_return_status ='S') THEN
3917: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Header with Id: '||lx_xpiv_rec.id);
3918: END IF;
3919:
3920: l_previous_tap_id := fund_rec.tap_id;
3921: l_previous_xpi_id := lx_xpiv_rec.id;

Line 3941: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Creating External AP Invoice Lines..');

3937: -- ELSE
3938: l_xlpv_rec.tap_id := fund_rec.tap_id;
3939: -- END IF;
3940:
3941: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Creating External AP Invoice Lines..');
3942: okl_xtl_pay_invs_pub.insert_xtl_pay_invs(
3943: p_api_version => p_api_version
3944: ,p_init_msg_list => p_init_msg_list
3945: ,x_return_status => x_return_status

Line 3954: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');

3950:
3951:
3952: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3953: l_conc_status := 'E';
3954: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
3955: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3956: l_conc_status := 'E';
3957: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
3958: ELSIF (x_return_status ='S') THEN

Line 3957: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');

3953: l_conc_status := 'E';
3954: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
3955: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3956: l_conc_status := 'E';
3957: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
3958: ELSIF (x_return_status ='S') THEN
3959: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Line with Id: '||lx_xlpv_rec.id);
3960: END IF;
3961:

Line 3959: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Line with Id: '||lx_xlpv_rec.id);

3955: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3956: l_conc_status := 'E';
3957: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
3958: ELSIF (x_return_status ='S') THEN
3959: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Line with Id: '||lx_xlpv_rec.id);
3960: END IF;
3961:
3962: ELSE
3963: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Creating Receviables Invoice');

Line 3963: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Creating Receviables Invoice');

3959: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Line with Id: '||lx_xlpv_rec.id);
3960: END IF;
3961:
3962: ELSE
3963: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Creating Receviables Invoice');
3964:
3965: -----------------------------------------------------------------
3966: -- Populate external AR invoice header and line record
3967: -----------------------------------------------------------------

Line 3981: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Creating Internal AR Invoice Header..');

3977: l_taiv_rec.trx_status_code := 'ENTERED';
3978: l_taiv_rec.try_id := fund_rec.try_id ;
3979:
3980:
3981: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Creating Internal AR Invoice Header..');
3982:
3983: -- Start of wraper code generated automatically by Debug code generator for okl_trx_ar_invoices_pub.insert_trx_ar_invoices
3984: IF(IS_DEBUG_PROCEDURE_ON) THEN
3985: BEGIN

Line 4006: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Header.');

4002: -- End of wraper code generated automatically by Debug code generator for okl_trx_ar_invoices_pub.insert_trx_ar_invoices
4003:
4004: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4005: l_conc_status := 'E';
4006: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Header.');
4007: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4008: l_conc_status := 'E';
4009: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Header.');
4010: ELSIF (x_return_status ='S') THEN

Line 4009: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Header.');

4005: l_conc_status := 'E';
4006: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Header.');
4007: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4008: l_conc_status := 'E';
4009: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Header.');
4010: ELSIF (x_return_status ='S') THEN
4011: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Internal AR Invoice Header with Id: '||lx_taiv_rec.id);
4012: END IF;
4013:

Line 4011: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Internal AR Invoice Header with Id: '||lx_taiv_rec.id);

4007: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4008: l_conc_status := 'E';
4009: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Header.');
4010: ELSIF (x_return_status ='S') THEN
4011: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Internal AR Invoice Header with Id: '||lx_taiv_rec.id);
4012: END IF;
4013:
4014: -----------------------------------------------------------------
4015: -- Insert external AR invoice line

Line 4027: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Creating Internal AR Invoice Line..');

4023: l_tilv_rec.inv_receiv_line_code := 'LINE';
4024: l_taiv_rec.attribute1 := 'AUTO_DISBURSEMENT';
4025: l_tilv_rec.attribute1 := 'AUTO_DISBURSEMENT';
4026:
4027: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Creating Internal AR Invoice Line..');
4028: -- Start of wraper code generated automatically by Debug code generator for okl_txl_ar_inv_lns_pub.insert_txl_ar_inv_lns
4029: IF(IS_DEBUG_PROCEDURE_ON) THEN
4030: BEGIN
4031: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRPICB.pls call okl_txl_ar_inv_lns_pub.insert_txl_ar_inv_lns ');

Line 4051: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Line.');

4047: -- End of wraper code generated automatically by Debug code generator for okl_txl_ar_inv_lns_pub.insert_txl_ar_inv_lns
4048:
4049: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4050: l_conc_status := 'E';
4051: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Line.');
4052: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4053: l_conc_status := 'E';
4054: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Line.');
4055: ELSIF (x_return_status ='S') THEN

Line 4054: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Line.');

4050: l_conc_status := 'E';
4051: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Line.');
4052: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4053: l_conc_status := 'E';
4054: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Line.');
4055: ELSIF (x_return_status ='S') THEN
4056: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Internal AR Invoice Line with Id: '||lx_tilv_rec.id);
4057: END IF;
4058:

Line 4056: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Internal AR Invoice Line with Id: '||lx_tilv_rec.id);

4052: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4053: l_conc_status := 'E';
4054: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Line.');
4055: ELSIF (x_return_status ='S') THEN
4056: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Internal AR Invoice Line with Id: '||lx_tilv_rec.id);
4057: END IF;
4058:
4059: p_bpd_acc_rec.id := lx_tilv_rec.id;
4060: p_bpd_acc_rec.source_table := 'OKL_TXL_AR_INV_LNS_B';

Line 4087: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Accounting Distributions.');

4083: -- End of wraper code generated automatically by Debug code generator for Okl_Acc_Call_Pub.CREATE_ACC_TRANS
4084:
4085: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4086: l_conc_status := 'E';
4087: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Accounting Distributions.');
4088: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4089: l_conc_status := 'E';
4090: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Accounting Distributions.');
4091: ELSIF (x_return_status ='S') THEN

Line 4090: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Accounting Distributions.');

4086: l_conc_status := 'E';
4087: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Accounting Distributions.');
4088: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4089: l_conc_status := 'E';
4090: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Accounting Distributions.');
4091: ELSIF (x_return_status ='S') THEN
4092: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ... Accounting Distributions Created.');
4093: END IF;
4094: END IF;

Line 4092: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ... Accounting Distributions Created.');

4088: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4089: l_conc_status := 'E';
4090: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Accounting Distributions.');
4091: ELSIF (x_return_status ='S') THEN
4092: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ... Accounting Distributions Created.');
4093: END IF;
4094: END IF;
4095:
4096:

Line 4102: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Successfully Prepared Invoice Number : ' || fund_rec.invoice_number);

4098: THEN
4099: -----------------------------------------------------------------
4100: -- Update internal AP table for Success
4101: -----------------------------------------------------------------
4102: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Successfully Prepared Invoice Number : ' || fund_rec.invoice_number);
4103:
4104: UPDATE okl_trx_ap_invoices_b
4105: SET trx_status_code = 'PROCESSED'
4106: WHERE id = fund_rec.tap_id;

Line 4111: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'*=>ERROR: Processing Invoice Number : ' || fund_rec.invoice_number);

4107: ELSE
4108: -----------------------------------------------------------------
4109: -- Update internal AP table for Error
4110: -----------------------------------------------------------------
4111: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'*=>ERROR: Processing Invoice Number : ' || fund_rec.invoice_number);
4112:
4113: IF x_msg_count >= 1 THEN
4114:
4115: FOR i in 1..x_msg_count LOOP

Line 4121: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,to_char(i) || ': ' || x_msg_data);

4117: p_encoded => 'F',
4118: p_data => x_msg_data,
4119: p_msg_index_out => l_msg_index_out);
4120:
4121: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,to_char(i) || ': ' || x_msg_data);
4122:
4123: END LOOP;
4124: END IF;
4125:

Line 4147: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');

4143: END IF;
4144:
4145: END LOOP; -- End Funding Cursor
4146:
4147: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
4148: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* End Funding Records ******* ');
4149: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
4150:
4151: ------------------------------------------------------------

Line 4148: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' * End Funding Records * ');

4144:
4145: END LOOP; -- End Funding Cursor
4146:
4147: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
4148: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* End Funding Records ******* ');
4149: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
4150:
4151: ------------------------------------------------------------
4152: -- End processing

Line 4149: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');

4145: END LOOP; -- End Funding Cursor
4146:
4147: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
4148: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ******* End Funding Records ******* ');
4149: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '============================================================');
4150:
4151: ------------------------------------------------------------
4152: -- End processing
4153: ------------------------------------------------------------

Line 4165: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

4161: ------------------------------------------------------------
4162: -- Exception handling
4163: ------------------------------------------------------------
4164: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4165: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4166: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4167: p_api_name => l_api_name,
4168: p_pkg_name => G_PKG_NAME,
4169: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 4175: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

4171: x_msg_data => x_msg_data,
4172: p_api_type => '_PVT');
4173:
4174: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4175: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4176: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4177: p_api_name => l_api_name,
4178: p_pkg_name => G_PKG_NAME,
4179: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 4185: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

4181: x_msg_data => x_msg_data,
4182: p_api_type => '_PVT');
4183:
4184: WHEN OTHERS THEN
4185: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4186: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4187: p_api_name => l_api_name,
4188: p_pkg_name => G_PKG_NAME,
4189: p_exc_name => 'OTHERS',

Line 4345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Prepare Payables Invoices IN pvt consol');

4341: ------------------------------------------------------------
4342: -- Start processing
4343: ------------------------------------------------------------
4344:
4345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Prepare Payables Invoices IN pvt consol');
4346:
4347: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4348:
4349: l_return_status := OKL_API.START_ACTIVITY(

Line 4375: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol getting contarct id for contarct ' || p_contract_number);

4371: -----------------------------------------------------------------
4372:
4373: l_commit_cnt := 0;
4374:
4375: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol getting contarct id for contarct ' || p_contract_number);
4376:
4377: OPEN l_contract_id_csr(p_contract_number);
4378: FETCH l_contract_id_csr into l_contract_id_rec;
4379: If l_contract_id_csr%FOUND THEN

Line 4386: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol got contarct id ' || to_char(nvl(l_contract_id, -1)));

4382: l_contract_id := NULL;
4383: END IF;
4384: CLOSE l_contract_id_csr;
4385:
4386: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol got contarct id ' || to_char(nvl(l_contract_id, -1)));
4387:
4388: l_contract_id_rec := NULL;
4389: OPEN l_contract_id_csr(p_vpa_number);
4390: FETCH l_contract_id_csr into l_contract_id_rec;

Line 4398: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol got vpa_id id ' || to_char(nvl(l_vpa_id, -1)));

4394: l_vpa_id := NULL;
4395: END IF;
4396: CLOSE l_contract_id_csr;
4397:
4398: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol got vpa_id id ' || to_char(nvl(l_vpa_id, -1)));
4399:
4400: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol getting vendor program ' || nvl(p_vpa_number, 'XXX'));
4401: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol getting vendor name ' || nvl(p_vendor, 'XXX'));
4402: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol getting vendor site ' || nvl(p_vendor_site, 'XXX'));

Line 4400: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol getting vendor program ' || nvl(p_vpa_number, 'XXX'));

4396: CLOSE l_contract_id_csr;
4397:
4398: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol got vpa_id id ' || to_char(nvl(l_vpa_id, -1)));
4399:
4400: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol getting vendor program ' || nvl(p_vpa_number, 'XXX'));
4401: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol getting vendor name ' || nvl(p_vendor, 'XXX'));
4402: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol getting vendor site ' || nvl(p_vendor_site, 'XXX'));
4403:
4404: /*

Line 4401: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol getting vendor name ' || nvl(p_vendor, 'XXX'));

4397:
4398: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol got vpa_id id ' || to_char(nvl(l_vpa_id, -1)));
4399:
4400: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol getting vendor program ' || nvl(p_vpa_number, 'XXX'));
4401: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol getting vendor name ' || nvl(p_vendor, 'XXX'));
4402: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol getting vendor site ' || nvl(p_vendor_site, 'XXX'));
4403:
4404: /*
4405: OPEN l_vendor_csr(p_vendor);

Line 4402: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol getting vendor site ' || nvl(p_vendor_site, 'XXX'));

4398: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol got vpa_id id ' || to_char(nvl(l_vpa_id, -1)));
4399:
4400: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol getting vendor program ' || nvl(p_vpa_number, 'XXX'));
4401: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol getting vendor name ' || nvl(p_vendor, 'XXX'));
4402: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol getting vendor site ' || nvl(p_vendor_site, 'XXX'));
4403:
4404: /*
4405: OPEN l_vendor_csr(p_vendor);
4406: FETCH l_vendor_csr into l_vendor_rec;

Line 4418: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol got vendor name id ' || to_char(nvl(l_vendor_id, -1)));

4414:
4415: l_vendor_id := to_number(p_vendor);
4416:
4417:
4418: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol got vendor name id ' || to_char(nvl(l_vendor_id, -1)));
4419: /*
4420:
4421: OPEN l_vendor_site_csr(l_vendor_id, p_vendor_site );
4422: FETCH l_vendor_site_csr into l_vendor_site_rec;

Line 4434: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol got vendor site id ' || to_char(nvl(l_vendor_site_id, -1)));

4430: */
4431:
4432: l_vendor_site_id := to_number(p_vendor_site);
4433:
4434: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'IN pvt consol got vendor site id ' || to_char(nvl(l_vendor_site_id, -1)));
4435:
4436: apply_consolidation_rules_ssir(
4437: p_api_version => p_api_version,
4438: p_init_msg_list => p_init_msg_list,

Line 4455: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Cannot Consolidate.');

4451:
4452:
4453: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4454: l_conc_status := 'E';
4455: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Cannot Consolidate.');
4456: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4457: l_conc_status := 'E';
4458: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Cannot Consolidate.');
4459: ELSIF (x_return_status ='S') THEN

Line 4458: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Cannot Consolidate.');

4454: l_conc_status := 'E';
4455: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Cannot Consolidate.');
4456: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4457: l_conc_status := 'E';
4458: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Cannot Consolidate.');
4459: ELSIF (x_return_status ='S') THEN
4460: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Consolidated invoices: ');
4461: END IF;
4462:

Line 4460: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Consolidated invoices: ');

4456: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4457: l_conc_status := 'E';
4458: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Cannot Consolidate.');
4459: ELSIF (x_return_status ='S') THEN
4460: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Consolidated invoices: ');
4461: END IF;
4462:
4463: if l_cnsld_invs.count > 0 Then
4464:

Line 4482: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Consolidated invoices.');

4478:
4479:
4480: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4481: l_conc_status := 'E';
4482: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Consolidated invoices.');
4483: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4484: l_conc_status := 'E';
4485: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Consolidated invoices.');
4486: ELSIF (x_return_status ='S') THEN

Line 4485: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Consolidated invoices.');

4481: l_conc_status := 'E';
4482: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Consolidated invoices.');
4483: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4484: l_conc_status := 'E';
4485: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Consolidated invoices.');
4486: ELSIF (x_return_status ='S') THEN
4487: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Consolidated invoices: '||to_char(l_cin_rec.cnsld_ap_inv_id));
4488: END IF;
4489:

Line 4487: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Consolidated invoices: '||to_char(l_cin_rec.cnsld_ap_inv_id));

4483: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4484: l_conc_status := 'E';
4485: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Consolidated invoices.');
4486: ELSIF (x_return_status ='S') THEN
4487: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Consolidated invoices: '||to_char(l_cin_rec.cnsld_ap_inv_id));
4488: END IF;
4489:
4490: l_tplv_tbl := l_cnsld_invs(i).tplv_tbl;
4491: l_cnsld_line_number := 0;

Line 4512: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Consolidated invoices lines.');

4508:
4509:
4510: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4511: l_conc_status := 'E';
4512: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Consolidated invoices lines.');
4513: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4514: l_conc_status := 'E';
4515: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Consolidated invoices lines.');
4516: ELSIF (x_return_status ='S') THEN

Line 4515: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Consolidated invoices lines.');

4511: l_conc_status := 'E';
4512: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Consolidated invoices lines.');
4513: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4514: l_conc_status := 'E';
4515: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Consolidated invoices lines.');
4516: ELSIF (x_return_status ='S') THEN
4517: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Consolidated invoices lines: '||to_char(lx_tplv_rec.id));
4518: END IF;
4519:

Line 4517: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Consolidated invoices lines: '||to_char(lx_tplv_rec.id));

4513: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4514: l_conc_status := 'E';
4515: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Consolidated invoices lines.');
4516: ELSIF (x_return_status ='S') THEN
4517: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Consolidated invoices lines: '||to_char(lx_tplv_rec.id));
4518: END IF;
4519:
4520: If (x_return_status ='S') THEN
4521:

Line 4562: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: transferring invoices lines.');

4558: -- p_to_date => p_to_date);
4559:
4560: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4561: l_conc_status := 'E';
4562: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: transferring invoices lines.');
4563: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4564: l_conc_status := 'E';
4565: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: transferring invoices lines.');
4566: ELSIF (x_return_status ='S') THEN

Line 4565: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: transferring invoices lines.');

4561: l_conc_status := 'E';
4562: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: transferring invoices lines.');
4563: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4564: l_conc_status := 'E';
4565: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: transferring invoices lines.');
4566: ELSIF (x_return_status ='S') THEN
4567: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' transferring invoices lines: ');
4568: END IF;
4569:

Line 4567: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' transferring invoices lines: ');

4563: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4564: l_conc_status := 'E';
4565: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: transferring invoices lines.');
4566: ELSIF (x_return_status ='S') THEN
4567: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' transferring invoices lines: ');
4568: END IF;
4569:
4570: ------------------------------------------------------------
4571: -- End processing

Line 4584: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

4580: ------------------------------------------------------------
4581: -- Exception handling
4582: ------------------------------------------------------------
4583: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4584: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4585: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4586: p_api_name => l_api_name,
4587: p_pkg_name => G_PKG_NAME,
4588: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 4594: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

4590: x_msg_data => x_msg_data,
4591: p_api_type => '_PVT');
4592:
4593: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4594: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4595: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4596: p_api_name => l_api_name,
4597: p_pkg_name => G_PKG_NAME,
4598: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 4604: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

4600: x_msg_data => x_msg_data,
4601: p_api_type => '_PVT');
4602:
4603: WHEN OTHERS THEN
4604: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4605: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4606: p_api_name => l_api_name,
4607: p_pkg_name => G_PKG_NAME,
4608: p_exc_name => 'OTHERS',

Line 4689: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 1');

4685: ------------------------------------------------------------
4686: -- Start processing
4687: ------------------------------------------------------------
4688:
4689: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 1');
4690:
4691: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4692:
4693: l_return_status := OKL_API.START_ACTIVITY(

Line 4712: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 2 contarct number:' || p_contract_number);

4708: -- Open Invoice cursor in block
4709: -----------------------------------------------------------------
4710:
4711: -- l_commit_cnt := 0;
4712: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 2 contarct number:' || p_contract_number);
4713:
4714: OPEN l_contract_id_csr(p_contract_number);
4715: FETCH l_contract_id_csr into x_contract_id;
4716: CLOSE l_contract_id_csr;

Line 4718: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 3 got contarct id ' || to_char(nvl(x_contract_id, -1)));

4714: OPEN l_contract_id_csr(p_contract_number);
4715: FETCH l_contract_id_csr into x_contract_id;
4716: CLOSE l_contract_id_csr;
4717:
4718: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 3 got contarct id ' || to_char(nvl(x_contract_id, -1)));
4719:
4720: -- l_contract_id_rec := NULL;
4721: OPEN l_contract_id_csr(p_vpa_number);
4722: FETCH l_contract_id_csr into x_vpa_id;

Line 4725: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 4 got vpa_id id ' || to_char(nvl(x_vpa_id, -1)));

4721: OPEN l_contract_id_csr(p_vpa_number);
4722: FETCH l_contract_id_csr into x_vpa_id;
4723: CLOSE l_contract_id_csr;
4724:
4725: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 4 got vpa_id id ' || to_char(nvl(x_vpa_id, -1)));
4726:
4727: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 5 getting vendor program ' || nvl(p_vpa_number, 'XXX'));
4728: --start:| 26-Nov-2007 cklee -- bug: 6620557 fixed |
4729: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 6 getting vendor ID ' || nvl(p_vendor, 'XXX'));

Line 4727: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 5 getting vendor program ' || nvl(p_vpa_number, 'XXX'));

4723: CLOSE l_contract_id_csr;
4724:
4725: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 4 got vpa_id id ' || to_char(nvl(x_vpa_id, -1)));
4726:
4727: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 5 getting vendor program ' || nvl(p_vpa_number, 'XXX'));
4728: --start:| 26-Nov-2007 cklee -- bug: 6620557 fixed |
4729: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 6 getting vendor ID ' || nvl(p_vendor, 'XXX'));
4730: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 7 getting vendor site ID ' || nvl(p_vendor_site, 'XXX'));
4731: x_vendor_id := p_vendor;

Line 4729: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 6 getting vendor ID ' || nvl(p_vendor, 'XXX'));

4725: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 4 got vpa_id id ' || to_char(nvl(x_vpa_id, -1)));
4726:
4727: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 5 getting vendor program ' || nvl(p_vpa_number, 'XXX'));
4728: --start:| 26-Nov-2007 cklee -- bug: 6620557 fixed |
4729: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 6 getting vendor ID ' || nvl(p_vendor, 'XXX'));
4730: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 7 getting vendor site ID ' || nvl(p_vendor_site, 'XXX'));
4731: x_vendor_id := p_vendor;
4732: x_vendor_site_id := p_vendor_site;
4733: /*

Line 4730: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 7 getting vendor site ID ' || nvl(p_vendor_site, 'XXX'));

4726:
4727: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 5 getting vendor program ' || nvl(p_vpa_number, 'XXX'));
4728: --start:| 26-Nov-2007 cklee -- bug: 6620557 fixed |
4729: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 6 getting vendor ID ' || nvl(p_vendor, 'XXX'));
4730: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 7 getting vendor site ID ' || nvl(p_vendor_site, 'XXX'));
4731: x_vendor_id := p_vendor;
4732: x_vendor_site_id := p_vendor_site;
4733: /*
4734: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 6 getting vendor name ' || nvl(p_vendor, 'XXX'));

Line 4734: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 6 getting vendor name ' || nvl(p_vendor, 'XXX'));

4730: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 7 getting vendor site ID ' || nvl(p_vendor_site, 'XXX'));
4731: x_vendor_id := p_vendor;
4732: x_vendor_site_id := p_vendor_site;
4733: /*
4734: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 6 getting vendor name ' || nvl(p_vendor, 'XXX'));
4735: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 7 getting vendor site ' || nvl(p_vendor_site, 'XXX'));
4736:
4737: OPEN l_vendor_csr(p_vendor);
4738: FETCH l_vendor_csr into x_vendor_id;

Line 4735: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 7 getting vendor site ' || nvl(p_vendor_site, 'XXX'));

4731: x_vendor_id := p_vendor;
4732: x_vendor_site_id := p_vendor_site;
4733: /*
4734: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 6 getting vendor name ' || nvl(p_vendor, 'XXX'));
4735: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 7 getting vendor site ' || nvl(p_vendor_site, 'XXX'));
4736:
4737: OPEN l_vendor_csr(p_vendor);
4738: FETCH l_vendor_csr into x_vendor_id;
4739: CLOSE l_vendor_csr;

Line 4741: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 8 got vendor name id ' || to_char(nvl(x_vendor_id, -1)));

4737: OPEN l_vendor_csr(p_vendor);
4738: FETCH l_vendor_csr into x_vendor_id;
4739: CLOSE l_vendor_csr;
4740:
4741: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 8 got vendor name id ' || to_char(nvl(x_vendor_id, -1)));
4742:
4743: OPEN l_vendor_site_csr(p_vendor_site);
4744: FETCH l_vendor_site_csr into x_vendor_site_id;
4745: CLOSE l_vendor_site_csr;

Line 4747: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 9 got vendor site id ' || to_char(nvl(x_vendor_site_id, -1)));*/

4743: OPEN l_vendor_site_csr(p_vendor_site);
4744: FETCH l_vendor_site_csr into x_vendor_site_id;
4745: CLOSE l_vendor_site_csr;
4746:
4747: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 9 got vendor site id ' || to_char(nvl(x_vendor_site_id, -1)));*/
4748: --end:| 26-Nov-2007 cklee -- bug: 6620557 fixed |
4749:
4750: ------------------------------------------------------------
4751: -- End processing

Line 4764: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

4760: ------------------------------------------------------------
4761: -- Exception handling
4762: ------------------------------------------------------------
4763: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4764: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4765: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4766: p_api_name => l_api_name,
4767: p_pkg_name => G_PKG_NAME,
4768: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 4774: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

4770: x_msg_data => x_msg_data,
4771: p_api_type => '_PVT');
4772:
4773: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4774: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4775: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4776: p_api_name => l_api_name,
4777: p_pkg_name => G_PKG_NAME,
4778: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 4784: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

4780: x_msg_data => x_msg_data,
4781: p_api_type => '_PVT');
4782:
4783: WHEN OTHERS THEN
4784: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4785: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4786: p_api_name => l_api_name,
4787: p_pkg_name => G_PKG_NAME,
4788: p_exc_name => 'OTHERS',

Line 4842: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'consolidation 1');

4838: ------------------------------------------------------------
4839: -- Start processing
4840: ------------------------------------------------------------
4841:
4842: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'consolidation 1');
4843:
4844: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4845:
4846: l_return_status := OKL_API.START_ACTIVITY(

Line 4878: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get_con_parameters failed.');

4874: x_vpa_id => l_vpa_id);
4875:
4876: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4877: l_conc_status := 'E';
4878: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get_con_parameters failed.');
4879: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4880: l_conc_status := 'E';
4881: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get_con_parameters failed.');
4882: ELSIF (x_return_status ='S') THEN

Line 4881: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get_con_parameters failed.');

4877: l_conc_status := 'E';
4878: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get_con_parameters failed.');
4879: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4880: l_conc_status := 'E';
4881: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get_con_parameters failed.');
4882: ELSIF (x_return_status ='S') THEN
4883: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' get_con_parameters done: ');
4884: END IF;
4885:

Line 4883: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' get_con_parameters done: ');

4879: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4880: l_conc_status := 'E';
4881: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get_con_parameters failed.');
4882: ELSIF (x_return_status ='S') THEN
4883: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' get_con_parameters done: ');
4884: END IF;
4885:
4886: apply_consolidation_rules(
4887: p_api_version => p_api_version,

Line 4902: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: apply_consolidation_rules failed.');

4898: p_to_date => p_to_date);
4899:
4900: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4901: l_conc_status := 'E';
4902: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: apply_consolidation_rules failed.');
4903: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4904: l_conc_status := 'E';
4905: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: apply_consolidation_rules failed.');
4906: ELSIF (x_return_status ='S') THEN

Line 4905: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: apply_consolidation_rules failed.');

4901: l_conc_status := 'E';
4902: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: apply_consolidation_rules failed.');
4903: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4904: l_conc_status := 'E';
4905: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: apply_consolidation_rules failed.');
4906: ELSIF (x_return_status ='S') THEN
4907: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Consolidated invoices: ');
4908: END IF;
4909: /* future release

Line 4907: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Consolidated invoices: ');

4903: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4904: l_conc_status := 'E';
4905: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: apply_consolidation_rules failed.');
4906: ELSIF (x_return_status ='S') THEN
4907: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Consolidated invoices: ');
4908: END IF;
4909: /* future release
4910: handle_processing_fee(
4911: p_api_version => p_api_version,

Line 4919: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Handle porcessing feet.');

4915: x_msg_data => x_msg_data);
4916:
4917: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4918: l_conc_status := 'E';
4919: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Handle porcessing feet.');
4920: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4921: l_conc_status := 'E';
4922: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Handle porcessing feet.');
4923: ELSIF (x_return_status ='S') THEN

Line 4922: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Handle porcessing feet.');

4918: l_conc_status := 'E';
4919: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Handle porcessing feet.');
4920: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4921: l_conc_status := 'E';
4922: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Handle porcessing feet.');
4923: ELSIF (x_return_status ='S') THEN
4924: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Handle porcessing feet.');
4925: END IF;
4926: */

Line 4924: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Handle porcessing feet.');

4920: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4921: l_conc_status := 'E';
4922: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Handle porcessing feet.');
4923: ELSIF (x_return_status ='S') THEN
4924: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Handle porcessing feet.');
4925: END IF;
4926: */
4927: transfer_to_external(
4928: p_api_version => p_api_version,

Line 4936: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: transferring invoices lines.');

4932: x_msg_data => x_msg_data);
4933:
4934: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4935: l_conc_status := 'E';
4936: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: transferring invoices lines.');
4937: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4938: l_conc_status := 'E';
4939: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: transferring invoices lines.');
4940: ELSIF (x_return_status ='S') THEN

Line 4939: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: transferring invoices lines.');

4935: l_conc_status := 'E';
4936: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: transferring invoices lines.');
4937: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4938: l_conc_status := 'E';
4939: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: transferring invoices lines.');
4940: ELSIF (x_return_status ='S') THEN
4941: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' transferring invoices lines: ');
4942: END IF;
4943:

Line 4941: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' transferring invoices lines: ');

4937: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4938: l_conc_status := 'E';
4939: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: transferring invoices lines.');
4940: ELSIF (x_return_status ='S') THEN
4941: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' transferring invoices lines: ');
4942: END IF;
4943:
4944: ------------------------------------------------------------
4945: -- End processing

Line 4958: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

4954: ------------------------------------------------------------
4955: -- Exception handling
4956: ------------------------------------------------------------
4957: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4958: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4959: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4960: p_api_name => l_api_name,
4961: p_pkg_name => G_PKG_NAME,
4962: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 4968: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

4964: x_msg_data => x_msg_data,
4965: p_api_type => '_PVT');
4966:
4967: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4968: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4969: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4970: p_api_name => l_api_name,
4971: p_pkg_name => G_PKG_NAME,
4972: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 4978: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);

4974: x_msg_data => x_msg_data,
4975: p_api_type => '_PVT');
4976:
4977: WHEN OTHERS THEN
4978: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4979: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4980: p_api_name => l_api_name,
4981: p_pkg_name => G_PKG_NAME,
4982: p_exc_name => 'OTHERS',