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_VR_DOCUMENT_PVT dependencies on OKL_VARIABLE_INTEREST_PVT

Line 321: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure CREATE_STREAM_INVOICE using following parameters : ');

317: lx_rep_selv_rec Okl_Streams_Pub.selv_rec_type;
318:
319:
320: BEGIN
321: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure CREATE_STREAM_INVOICE using following parameters : ');
322: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_contract_id : '|| p_contract_id );
323: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_line_id : '|| p_line_id);
324: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_amount : '|| p_amount );
325: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_due_date: '|| p_due_date);

Line 322: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_contract_id : '|| p_contract_id );

318:
319:
320: BEGIN
321: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure CREATE_STREAM_INVOICE using following parameters : ');
322: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_contract_id : '|| p_contract_id );
323: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_line_id : '|| p_line_id);
324: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_amount : '|| p_amount );
325: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_due_date: '|| p_due_date);
326: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_stream_type_purpose : '||p_stream_type_purpose);

Line 323: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_line_id : '|| p_line_id);

319:
320: BEGIN
321: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure CREATE_STREAM_INVOICE using following parameters : ');
322: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_contract_id : '|| p_contract_id );
323: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_line_id : '|| p_line_id);
324: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_amount : '|| p_amount );
325: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_due_date: '|| p_due_date);
326: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_stream_type_purpose : '||p_stream_type_purpose);
327: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_create_invoice_flag: '|| p_create_invoice_flag);

Line 324: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_amount : '|| p_amount );

320: BEGIN
321: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure CREATE_STREAM_INVOICE using following parameters : ');
322: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_contract_id : '|| p_contract_id );
323: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_line_id : '|| p_line_id);
324: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_amount : '|| p_amount );
325: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_due_date: '|| p_due_date);
326: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_stream_type_purpose : '||p_stream_type_purpose);
327: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_create_invoice_flag: '|| p_create_invoice_flag);
328: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_process_flag : '|| p_process_flag);

Line 325: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_due_date: '|| p_due_date);

321: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure CREATE_STREAM_INVOICE using following parameters : ');
322: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_contract_id : '|| p_contract_id );
323: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_line_id : '|| p_line_id);
324: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_amount : '|| p_amount );
325: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_due_date: '|| p_due_date);
326: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_stream_type_purpose : '||p_stream_type_purpose);
327: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_create_invoice_flag: '|| p_create_invoice_flag);
328: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_process_flag : '|| p_process_flag);
329: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_parent_strm_element_id : '|| p_parent_strm_element_id);

Line 326: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_stream_type_purpose : '||p_stream_type_purpose);

322: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_contract_id : '|| p_contract_id );
323: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_line_id : '|| p_line_id);
324: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_amount : '|| p_amount );
325: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_due_date: '|| p_due_date);
326: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_stream_type_purpose : '||p_stream_type_purpose);
327: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_create_invoice_flag: '|| p_create_invoice_flag);
328: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_process_flag : '|| p_process_flag);
329: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_parent_strm_element_id : '|| p_parent_strm_element_id);
330:

Line 327: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_create_invoice_flag: '|| p_create_invoice_flag);

323: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_line_id : '|| p_line_id);
324: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_amount : '|| p_amount );
325: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_due_date: '|| p_due_date);
326: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_stream_type_purpose : '||p_stream_type_purpose);
327: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_create_invoice_flag: '|| p_create_invoice_flag);
328: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_process_flag : '|| p_process_flag);
329: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_parent_strm_element_id : '|| p_parent_strm_element_id);
330:
331: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 328: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_process_flag : '|| p_process_flag);

324: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_amount : '|| p_amount );
325: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_due_date: '|| p_due_date);
326: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_stream_type_purpose : '||p_stream_type_purpose);
327: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_create_invoice_flag: '|| p_create_invoice_flag);
328: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_process_flag : '|| p_process_flag);
329: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_parent_strm_element_id : '|| p_parent_strm_element_id);
330:
331: x_return_status := OKL_API.G_RET_STS_SUCCESS;
332:

Line 329: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_parent_strm_element_id : '|| p_parent_strm_element_id);

325: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_due_date: '|| p_due_date);
326: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_stream_type_purpose : '||p_stream_type_purpose);
327: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_create_invoice_flag: '|| p_create_invoice_flag);
328: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_process_flag : '|| p_process_flag);
329: OKL_VARIABLE_INTEREST_PVT.print_debug(' p_parent_strm_element_id : '|| p_parent_strm_element_id);
330:
331: x_return_status := OKL_API.G_RET_STS_SUCCESS;
332:
333: -- Get sty_id for the contract

Line 352: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Stream Id for purpose '|| p_stream_type_purpose || 'retrieved.');

348: );
349: END IF;
350:
351: IF (x_return_status = 'S' ) THEN
352: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Stream Id for purpose '|| p_stream_type_purpose || 'retrieved.');
353: ELSE
354: OKL_VARIABLE_INTEREST_PVT.print_debug( ' -- ERROR: Could not retrieve Stream Id for purpose '|| p_stream_type_purpose );
355: END IF;
356:

Line 354: OKL_VARIABLE_INTEREST_PVT.print_debug( ' -- ERROR: Could not retrieve Stream Id for purpose '|| p_stream_type_purpose );

350:
351: IF (x_return_status = 'S' ) THEN
352: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Stream Id for purpose '|| p_stream_type_purpose || 'retrieved.');
353: ELSE
354: OKL_VARIABLE_INTEREST_PVT.print_debug( ' -- ERROR: Could not retrieve Stream Id for purpose '|| p_stream_type_purpose );
355: END IF;
356:
357: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
358: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Util.get_primary/dependent_stream_type');

Line 358: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Util.get_primary/dependent_stream_type');

354: OKL_VARIABLE_INTEREST_PVT.print_debug( ' -- ERROR: Could not retrieve Stream Id for purpose '|| p_stream_type_purpose );
355: END IF;
356:
357: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
358: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Util.get_primary/dependent_stream_type');
359: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
360: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
361: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Util.get_primary/dependent_stream_type');
362: RAISE create_stream_invoice_failed;

Line 361: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Util.get_primary/dependent_stream_type');

357: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
358: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Util.get_primary/dependent_stream_type');
359: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
360: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
361: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Util.get_primary/dependent_stream_type');
362: RAISE create_stream_invoice_failed;
363: END IF;
364:
365: l_selv_rec.stm_id := NULL;

Line 371: OKL_VARIABLE_INTEREST_PVT.print_debug('Stream Not Found : Creating a new stream');

367: OPEN stream_csr (p_contract_id, p_line_id, l_sty_id);
368: FETCH stream_csr INTO l_selv_rec.stm_id;
369: IF (stream_csr%NOTFOUND) THEN
370: NULL;
371: OKL_VARIABLE_INTEREST_PVT.print_debug('Stream Not Found : Creating a new stream');
372: END IF;
373: CLOSE stream_csr;
374:
375: IF (l_selv_rec.stm_id IS NULL) THEN

Line 394: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAMS');

390: ELSE
391: l_stmv_rec.comments := 'Variable Interest';
392: END IF;
393:
394: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAMS');
395:
396: Okl_Streams_Pub.create_streams(
397: p_api_version => p_api_version,
398: p_init_msg_list => p_init_msg_list,

Line 407: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Success in Stream Creation.');

403: x_stmv_rec => lx_stmv_rec);
404:
405:
406: IF (x_return_status = 'S' ) THEN
407: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Success in Stream Creation.');
408: ELSE
409: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Error: '||x_msg_data);
410: END IF;
411:

Line 409: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Error: '||x_msg_data);

405:
406: IF (x_return_status = 'S' ) THEN
407: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Success in Stream Creation.');
408: ELSE
409: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Error: '||x_msg_data);
410: END IF;
411:
412: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
413: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_streams');

Line 413: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_streams');

409: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Error: '||x_msg_data);
410: END IF;
411:
412: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
413: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_streams');
414: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
415: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
416: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_streams');
417: RAISE create_stream_invoice_failed;

Line 416: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_streams');

412: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
413: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_streams');
414: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
415: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
416: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_streams');
417: RAISE create_stream_invoice_failed;
418: END IF;
419:
420: l_stream_created := OKL_API.G_TRUE;

Line 422: OKL_VARIABLE_INTEREST_PVT.print_debug ('Stm ID: '||lx_stmv_rec.id);

418: END IF;
419:
420: l_stream_created := OKL_API.G_TRUE;
421:
422: OKL_VARIABLE_INTEREST_PVT.print_debug ('Stm ID: '||lx_stmv_rec.id);
423: l_selv_rec.stm_id := lx_stmv_rec.id;
424: OKL_VARIABLE_INTEREST_PVT.print_debug ('Stm ID: '||l_selv_rec.stm_id);
425:
426: END IF;

Line 424: OKL_VARIABLE_INTEREST_PVT.print_debug ('Stm ID: '||l_selv_rec.stm_id);

420: l_stream_created := OKL_API.G_TRUE;
421:
422: OKL_VARIABLE_INTEREST_PVT.print_debug ('Stm ID: '||lx_stmv_rec.id);
423: l_selv_rec.stm_id := lx_stmv_rec.id;
424: OKL_VARIABLE_INTEREST_PVT.print_debug ('Stm ID: '||l_selv_rec.stm_id);
425:
426: END IF;
427:
428: --change on 16 Nov 2005 by pgomes for bug fix 4740008

Line 440: OKL_VARIABLE_INTEREST_PVT.print_debug ('Stream Elements do not exist');

436: l_selv_rec.se_line_number := NULL;
437: OPEN c_stm_id_line_number(l_selv_rec.stm_id);
438: FETCH c_stm_id_line_number INTO l_selv_rec.se_line_number;
439: IF (c_stm_id_line_number%NOTFOUND) THEN
440: OKL_VARIABLE_INTEREST_PVT.print_debug ('Stream Elements do not exist');
441: l_selv_rec.se_line_number := 1;
442: ELSE
443: l_selv_rec.se_line_number := l_selv_rec.se_line_number + 1;
444: END IF;

Line 454: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAM_ELEMENTS');

450: l_selv_rec.comments := 'Variable Interest';
451: END IF;
452:
453:
454: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAM_ELEMENTS');
455:
456: Okl_Streams_Pub.create_stream_elements(
457: p_api_version => p_api_version,
458: p_init_msg_list => p_init_msg_list,

Line 466: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Success in Creating Stream Elements.');

462: p_selv_rec => l_selv_rec,
463: x_selv_rec => lx_selv_rec);
464:
465: IF (x_return_status = 'S' ) THEN
466: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Success in Creating Stream Elements.');
467: ELSE
468: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Error: '||x_msg_data);
469: END IF;
470:

Line 468: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Error: '||x_msg_data);

464:
465: IF (x_return_status = 'S' ) THEN
466: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Success in Creating Stream Elements.');
467: ELSE
468: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Error: '||x_msg_data);
469: END IF;
470:
471: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
472: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_stream_elements');

Line 472: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_stream_elements');

468: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Error: '||x_msg_data);
469: END IF;
470:
471: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
472: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_stream_elements');
473: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
474: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
475: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_stream_elements');
476: RAISE create_stream_invoice_failed;

Line 475: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_stream_elements');

471: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
472: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_stream_elements');
473: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
474: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
475: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_stream_elements');
476: RAISE create_stream_invoice_failed;
477: END IF;
478:
479: l_strm_element_created := OKL_API.G_TRUE;

Line 544: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Reporting Stream Id for purpose '|| p_stream_type_purpose || 'retrieved.');

540: );
541: END IF;
542:
543: IF (x_return_status = 'S' ) THEN
544: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Reporting Stream Id for purpose '|| p_stream_type_purpose || 'retrieved.');
545: ELSE
546: OKL_VARIABLE_INTEREST_PVT.print_debug( ' -- ERROR: Could not retrieve Reporting Stream Id for purpose '|| p_stream_type_purpose );
547: END IF;
548:

Line 546: OKL_VARIABLE_INTEREST_PVT.print_debug( ' -- ERROR: Could not retrieve Reporting Stream Id for purpose '|| p_stream_type_purpose );

542:
543: IF (x_return_status = 'S' ) THEN
544: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Reporting Stream Id for purpose '|| p_stream_type_purpose || 'retrieved.');
545: ELSE
546: OKL_VARIABLE_INTEREST_PVT.print_debug( ' -- ERROR: Could not retrieve Reporting Stream Id for purpose '|| p_stream_type_purpose );
547: END IF;
548:
549: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
550: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Util.get_primary/dependent_stream_type_rep');

Line 550: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Util.get_primary/dependent_stream_type_rep');

546: OKL_VARIABLE_INTEREST_PVT.print_debug( ' -- ERROR: Could not retrieve Reporting Stream Id for purpose '|| p_stream_type_purpose );
547: END IF;
548:
549: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
550: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Util.get_primary/dependent_stream_type_rep');
551: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
552: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
553: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Util.get_primary/dependent_stream_type_rep');
554: RAISE create_stream_invoice_failed;

Line 553: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Util.get_primary/dependent_stream_type_rep');

549: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
550: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Util.get_primary/dependent_stream_type_rep');
551: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
552: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
553: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Util.get_primary/dependent_stream_type_rep');
554: RAISE create_stream_invoice_failed;
555: END IF;
556:
557: l_rep_selv_rec.stm_id := NULL;

Line 563: OKL_VARIABLE_INTEREST_PVT.print_debug('Reporting Stream Not Found : Creating a new stream');

559: OPEN rep_stream_csr (p_contract_id, p_line_id, l_rep_sty_id);
560: FETCH rep_stream_csr INTO l_rep_selv_rec.stm_id;
561: IF (rep_stream_csr%NOTFOUND) THEN
562: NULL;
563: OKL_VARIABLE_INTEREST_PVT.print_debug('Reporting Stream Not Found : Creating a new stream');
564: END IF;
565: CLOSE rep_stream_csr;
566:
567: IF (l_rep_selv_rec.stm_id IS NULL) THEN

Line 582: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAMS');

578: l_rep_stmv_rec.date_current := sysdate;
579: l_rep_stmv_rec.purpose_code := 'REPORT';
580: l_rep_stmv_rec.comments := 'Variable Interest';
581:
582: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAMS');
583:
584: Okl_Streams_Pub.create_streams(
585: p_api_version => p_api_version,
586: p_init_msg_list => p_init_msg_list,

Line 594: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Success in Reporting Stream Creation.');

590: p_stmv_rec => l_rep_stmv_rec,
591: x_stmv_rec => lx_rep_stmv_rec);
592:
593: IF (x_return_status = 'S' ) THEN
594: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Success in Reporting Stream Creation.');
595: ELSE
596: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Error: '||x_msg_data);
597: END IF;
598:

Line 596: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Error: '||x_msg_data);

592:
593: IF (x_return_status = 'S' ) THEN
594: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Success in Reporting Stream Creation.');
595: ELSE
596: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Error: '||x_msg_data);
597: END IF;
598:
599: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
600: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_streams for reporting streams');

Line 600: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_streams for reporting streams');

596: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Error: '||x_msg_data);
597: END IF;
598:
599: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
600: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_streams for reporting streams');
601: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
602: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
603: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_streams for reporting streams');
604: RAISE create_stream_invoice_failed;

Line 603: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_streams for reporting streams');

599: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
600: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_streams for reporting streams');
601: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
602: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
603: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_streams for reporting streams');
604: RAISE create_stream_invoice_failed;
605: END IF;
606:
607: l_rep_stream_created := OKL_API.G_TRUE;

Line 609: OKL_VARIABLE_INTEREST_PVT.print_debug ('Stm ID: '||lx_rep_stmv_rec.id);

605: END IF;
606:
607: l_rep_stream_created := OKL_API.G_TRUE;
608:
609: OKL_VARIABLE_INTEREST_PVT.print_debug ('Stm ID: '||lx_rep_stmv_rec.id);
610: l_rep_selv_rec.stm_id := lx_rep_stmv_rec.id;
611: OKL_VARIABLE_INTEREST_PVT.print_debug ('Stm ID: '||l_rep_selv_rec.stm_id);
612:
613: END IF;

Line 611: OKL_VARIABLE_INTEREST_PVT.print_debug ('Stm ID: '||l_rep_selv_rec.stm_id);

607: l_rep_stream_created := OKL_API.G_TRUE;
608:
609: OKL_VARIABLE_INTEREST_PVT.print_debug ('Stm ID: '||lx_rep_stmv_rec.id);
610: l_rep_selv_rec.stm_id := lx_rep_stmv_rec.id;
611: OKL_VARIABLE_INTEREST_PVT.print_debug ('Stm ID: '||l_rep_selv_rec.stm_id);
612:
613: END IF;
614:
615: --setting the value of accrued_yn to NULL instead of 'N'

Line 632: OKL_VARIABLE_INTEREST_PVT.print_debug ('Reporting Stream Elements do not exist');

628:
629: OPEN c_stm_id_line_number(l_rep_selv_rec.stm_id);
630: FETCH c_stm_id_line_number INTO l_rep_selv_rec.se_line_number;
631: IF (c_stm_id_line_number%NOTFOUND) THEN
632: OKL_VARIABLE_INTEREST_PVT.print_debug ('Reporting Stream Elements do not exist');
633: l_rep_selv_rec.se_line_number := 1;
634: ELSE
635: l_rep_selv_rec.se_line_number := l_rep_selv_rec.se_line_number + 1;
636: END IF;

Line 642: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAM_ELEMENTS for reporting streams');

638:
639: l_rep_selv_rec.comments := 'Variable Interest';
640:
641:
642: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_STREAMS_PUB.CREATE_STREAM_ELEMENTS for reporting streams');
643:
644: Okl_Streams_Pub.create_stream_elements(
645: p_api_version => p_api_version,
646: p_init_msg_list => p_init_msg_list,

Line 654: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Success in Creating Reporing Stream Elements.');

650: p_selv_rec => l_rep_selv_rec,
651: x_selv_rec => lx_rep_selv_rec);
652:
653: IF (x_return_status = 'S' ) THEN
654: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Success in Creating Reporing Stream Elements.');
655: ELSE
656: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Error: '||x_msg_data);
657: END IF;
658:

Line 656: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Error: '||x_msg_data);

652:
653: IF (x_return_status = 'S' ) THEN
654: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Success in Creating Reporing Stream Elements.');
655: ELSE
656: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Error: '||x_msg_data);
657: END IF;
658:
659: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
660: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_stream_elements for reporting streams');

Line 660: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_stream_elements for reporting streams');

656: OKL_VARIABLE_INTEREST_PVT.print_debug (' -- Error: '||x_msg_data);
657: END IF;
658:
659: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
660: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_stream_elements for reporting streams');
661: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
662: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
663: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_stream_elements for reporting streams');
664: RAISE create_stream_invoice_failed;

Line 663: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_stream_elements for reporting streams');

659: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
660: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Streams_Pub.create_stream_elements for reporting streams');
661: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
662: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
663: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Streams_Pub.create_stream_elements for reporting streams');
664: RAISE create_stream_invoice_failed;
665: END IF;
666:
667: l_rep_strm_element_created := OKL_API.G_TRUE;

Line 678: OKL_VARIABLE_INTEREST_PVT.print_error_message('Set of books cursor did not return any records');

674:
675: OPEN set_of_books_csr;
676: FETCH set_of_books_csr INTO l_set_of_books_id;
677: IF (set_of_books_csr%NOTFOUND) THEN
678: OKL_VARIABLE_INTEREST_PVT.print_error_message('Set of books cursor did not return any records');
679: RAISE create_stream_invoice_failed;
680: END IF;
681: CLOSE set_of_books_csr;
682:

Line 684: IF (OKL_VARIABLE_INTEREST_PVT.G_BILLING_TRX_TYPE_ID IS NULL) THEN

680: END IF;
681: CLOSE set_of_books_csr;
682:
683: IF (p_create_invoice_flag = OKL_API.G_TRUE) THEN
684: IF (OKL_VARIABLE_INTEREST_PVT.G_BILLING_TRX_TYPE_ID IS NULL) THEN
685: OPEN trx_type_csr ('Billing');
686: FETCH trx_type_csr INTO OKL_VARIABLE_INTEREST_PVT.G_BILLING_TRX_TYPE_ID, OKL_VARIABLE_INTEREST_PVT.G_BILLING_TRX_TRY_ID, OKL_VARIABLE_INTEREST_PVT.G_BILLING_TRX_DESC;
687: IF (trx_type_csr%NOTFOUND) THEN
688: OKL_VARIABLE_INTEREST_PVT.print_error_message('Transaction type cursor did not return any records');

Line 686: FETCH trx_type_csr INTO OKL_VARIABLE_INTEREST_PVT.G_BILLING_TRX_TYPE_ID, OKL_VARIABLE_INTEREST_PVT.G_BILLING_TRX_TRY_ID, OKL_VARIABLE_INTEREST_PVT.G_BILLING_TRX_DESC;

682:
683: IF (p_create_invoice_flag = OKL_API.G_TRUE) THEN
684: IF (OKL_VARIABLE_INTEREST_PVT.G_BILLING_TRX_TYPE_ID IS NULL) THEN
685: OPEN trx_type_csr ('Billing');
686: FETCH trx_type_csr INTO OKL_VARIABLE_INTEREST_PVT.G_BILLING_TRX_TYPE_ID, OKL_VARIABLE_INTEREST_PVT.G_BILLING_TRX_TRY_ID, OKL_VARIABLE_INTEREST_PVT.G_BILLING_TRX_DESC;
687: IF (trx_type_csr%NOTFOUND) THEN
688: OKL_VARIABLE_INTEREST_PVT.print_error_message('Transaction type cursor did not return any records');
689: RAISE create_stream_invoice_failed;
690: END IF;

Line 688: OKL_VARIABLE_INTEREST_PVT.print_error_message('Transaction type cursor did not return any records');

684: IF (OKL_VARIABLE_INTEREST_PVT.G_BILLING_TRX_TYPE_ID IS NULL) THEN
685: OPEN trx_type_csr ('Billing');
686: FETCH trx_type_csr INTO OKL_VARIABLE_INTEREST_PVT.G_BILLING_TRX_TYPE_ID, OKL_VARIABLE_INTEREST_PVT.G_BILLING_TRX_TRY_ID, OKL_VARIABLE_INTEREST_PVT.G_BILLING_TRX_DESC;
687: IF (trx_type_csr%NOTFOUND) THEN
688: OKL_VARIABLE_INTEREST_PVT.print_error_message('Transaction type cursor did not return any records');
689: RAISE create_stream_invoice_failed;
690: END IF;
691: CLOSE trx_type_csr;
692: END IF;

Line 694: OKL_VARIABLE_INTEREST_PVT.print_debug('G_CONTRACT_ID : '|| OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID);

690: END IF;
691: CLOSE trx_type_csr;
692: END IF;
693:
694: OKL_VARIABLE_INTEREST_PVT.print_debug('G_CONTRACT_ID : '|| OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID);
695: -- Begin - Billing Inline changes - Bug#5898792 - varangan - 28/2/2007
696: lp_taiv_rec.khr_id := p_contract_id;
697: lp_taiv_rec.date_invoiced := p_due_date;
698: lp_taiv_rec.try_id := OKL_VARIABLE_INTEREST_PVT.G_BILLING_TRX_TYPE_ID;

Line 698: lp_taiv_rec.try_id := OKL_VARIABLE_INTEREST_PVT.G_BILLING_TRX_TYPE_ID;

694: OKL_VARIABLE_INTEREST_PVT.print_debug('G_CONTRACT_ID : '|| OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID);
695: -- Begin - Billing Inline changes - Bug#5898792 - varangan - 28/2/2007
696: lp_taiv_rec.khr_id := p_contract_id;
697: lp_taiv_rec.date_invoiced := p_due_date;
698: lp_taiv_rec.try_id := OKL_VARIABLE_INTEREST_PVT.G_BILLING_TRX_TYPE_ID;
699: lp_taiv_rec.date_entered := l_date_entered;
700: lp_taiv_rec.description := l_def_desc;
701: lp_taiv_rec.trx_status_code := l_final_status;
702: lp_taiv_rec.amount := p_amount;

Line 703: lp_taiv_rec.currency_code := OKL_VARIABLE_INTEREST_PVT.G_CURRENCY_CODE;

699: lp_taiv_rec.date_entered := l_date_entered;
700: lp_taiv_rec.description := l_def_desc;
701: lp_taiv_rec.trx_status_code := l_final_status;
702: lp_taiv_rec.amount := p_amount;
703: lp_taiv_rec.currency_code := OKL_VARIABLE_INTEREST_PVT.G_CURRENCY_CODE;
704: lp_taiv_rec.org_id := OKL_VARIABLE_INTEREST_PVT.G_AUTHORING_ORG_ID;
705: lp_taiv_rec.set_of_books_id := l_set_of_books_id;
706: lp_taiv_rec.OKL_SOURCE_BILLING_TRX := G_SOURCE_BILLING_TRX;
707: -- Added by dpsingh for LE Uptake

Line 704: lp_taiv_rec.org_id := OKL_VARIABLE_INTEREST_PVT.G_AUTHORING_ORG_ID;

700: lp_taiv_rec.description := l_def_desc;
701: lp_taiv_rec.trx_status_code := l_final_status;
702: lp_taiv_rec.amount := p_amount;
703: lp_taiv_rec.currency_code := OKL_VARIABLE_INTEREST_PVT.G_CURRENCY_CODE;
704: lp_taiv_rec.org_id := OKL_VARIABLE_INTEREST_PVT.G_AUTHORING_ORG_ID;
705: lp_taiv_rec.set_of_books_id := l_set_of_books_id;
706: lp_taiv_rec.OKL_SOURCE_BILLING_TRX := G_SOURCE_BILLING_TRX;
707: -- Added by dpsingh for LE Uptake
708: l_legal_entity_id := OKL_LEGAL_ENTITY_UTIL.get_khr_le_id(p_contract_id) ;

Line 723: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_TRX_AR_INVOICES_PUB.INSERT_TRX_AR_INVOICES');

719: p_token1_value => l_cntrct_number);
720: RAISE OKL_API.G_EXCEPTION_ERROR;
721: END IF;
722:
723: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_TRX_AR_INVOICES_PUB.INSERT_TRX_AR_INVOICES');
724:
725:
726: -- Populate the Line record
727: lp_tilv_rec.org_id := OKL_VARIABLE_INTEREST_PVT.G_AUTHORING_ORG_ID;

Line 727: lp_tilv_rec.org_id := OKL_VARIABLE_INTEREST_PVT.G_AUTHORING_ORG_ID;

723: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_TRX_AR_INVOICES_PUB.INSERT_TRX_AR_INVOICES');
724:
725:
726: -- Populate the Line record
727: lp_tilv_rec.org_id := OKL_VARIABLE_INTEREST_PVT.G_AUTHORING_ORG_ID;
728: lp_tilv_rec.line_number := 1;
729: lp_tilv_rec.kle_id := p_line_id;
730: -- x_invoice_id := r_taiv_rec.id;
731: lp_tilv_rec.description := l_def_desc;

Line 755: lp_tldv_rec.org_id := OKL_VARIABLE_INTEREST_PVT.G_AUTHORING_ORG_ID; --r_taiv_rec.org_id;

751: lp_tldv_rec.sel_id := lx_selv_rec.id;
752: --i_tldv_rec.til_id_details := r_tilv_rec.id;
753: lp_tldv_rec.line_detail_number := 1;
754: lp_tldv_rec.date_calculation := SYSDATE;
755: lp_tldv_rec.org_id := OKL_VARIABLE_INTEREST_PVT.G_AUTHORING_ORG_ID; --r_taiv_rec.org_id;
756: --sosharma added for billing issues
757: lp_tldv_rec.txl_ar_line_number := 1;
758: lp_tldv_tbl(1) := lp_tldv_rec;
759:

Line 776: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to okl_internal_billing_pvt.create_billing_trx');

772: x_tilv_tbl => lx_tilv_tbl,
773: x_tldv_tbl => lx_tldv_tbl);
774:
775: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
776: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to okl_internal_billing_pvt.create_billing_trx');
777: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
778: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
779: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to okl_internal_billing_pvt.create_billing_trx');
780: RAISE create_stream_invoice_failed;

Line 779: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to okl_internal_billing_pvt.create_billing_trx');

775: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
776: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to okl_internal_billing_pvt.create_billing_trx');
777: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
778: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
779: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to okl_internal_billing_pvt.create_billing_trx');
780: RAISE create_stream_invoice_failed;
781: END IF;
782: --sosharma added for billing changes
783: x_invoice_id := lx_taiv_rec.id;

Line 793: OKL_VARIABLE_INTEREST_PVT.print_debug('Stream Type Purpose: '|| p_stream_type_purpose);

789:
790: END IF;
791:
792: IF (p_process_flag in ('DAILY_INTEREST', 'PRINCIPAL_CATCHUP')) THEN
793: OKL_VARIABLE_INTEREST_PVT.print_debug('Stream Type Purpose: '|| p_stream_type_purpose);
794: IF (p_stream_type_purpose IN ('DAILY_INTEREST_PRINCIPAL', 'DAILY_INTEREST_INTEREST')) THEN
795: ------------------------------------------------------------
796: -- Create Contract Transaction Header and Line
797: -- in Submitted Status

Line 799: IF (OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_TYPE_ID IS NULL) THEN

795: ------------------------------------------------------------
796: -- Create Contract Transaction Header and Line
797: -- in Submitted Status
798: ------------------------------------------------------------
799: IF (OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_TYPE_ID IS NULL) THEN
800: OPEN trx_type_csr('Receipt Application');
801: FETCH trx_type_csr INTO OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_TYPE_ID, OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_TRY_ID, OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_DESC;
802: IF (trx_type_csr%NOTFOUND) THEN
803: CLOSE trx_type_csr;

Line 801: FETCH trx_type_csr INTO OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_TYPE_ID, OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_TRY_ID, OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_DESC;

797: -- in Submitted Status
798: ------------------------------------------------------------
799: IF (OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_TYPE_ID IS NULL) THEN
800: OPEN trx_type_csr('Receipt Application');
801: FETCH trx_type_csr INTO OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_TYPE_ID, OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_TRY_ID, OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_DESC;
802: IF (trx_type_csr%NOTFOUND) THEN
803: CLOSE trx_type_csr;
804: OKL_VARIABLE_INTEREST_PVT.print_error_message('Transaction type cursor did not return any records');
805: RAISE create_stream_invoice_failed;

Line 804: OKL_VARIABLE_INTEREST_PVT.print_error_message('Transaction type cursor did not return any records');

800: OPEN trx_type_csr('Receipt Application');
801: FETCH trx_type_csr INTO OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_TYPE_ID, OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_TRY_ID, OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_DESC;
802: IF (trx_type_csr%NOTFOUND) THEN
803: CLOSE trx_type_csr;
804: OKL_VARIABLE_INTEREST_PVT.print_error_message('Transaction type cursor did not return any records');
805: RAISE create_stream_invoice_failed;
806: END IF;
807: CLOSE trx_type_csr;
808: END IF;

Line 809: l_trx_type_id := OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_TYPE_ID;

805: RAISE create_stream_invoice_failed;
806: END IF;
807: CLOSE trx_type_csr;
808: END IF;
809: l_trx_type_id := OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_TYPE_ID;
810: l_trx_try_id := OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_TRY_ID;
811: l_trx_desc := OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_DESC;
812:
813: IF (OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_TYPE IS NULL) THEN

Line 810: l_trx_try_id := OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_TRY_ID;

806: END IF;
807: CLOSE trx_type_csr;
808: END IF;
809: l_trx_type_id := OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_TYPE_ID;
810: l_trx_try_id := OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_TRY_ID;
811: l_trx_desc := OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_DESC;
812:
813: IF (OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_TYPE IS NULL) THEN
814: OPEN fnd_lookup_csr('OKL_TCN_TYPE', 'RAP');

Line 811: l_trx_desc := OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_DESC;

807: CLOSE trx_type_csr;
808: END IF;
809: l_trx_type_id := OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_TYPE_ID;
810: l_trx_try_id := OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_TRY_ID;
811: l_trx_desc := OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_DESC;
812:
813: IF (OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_TYPE IS NULL) THEN
814: OPEN fnd_lookup_csr('OKL_TCN_TYPE', 'RAP');
815: FETCH fnd_lookup_csr INTO OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_TYPE,OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_MEANING, OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_DESC;

Line 813: IF (OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_TYPE IS NULL) THEN

809: l_trx_type_id := OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_TYPE_ID;
810: l_trx_try_id := OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_TRY_ID;
811: l_trx_desc := OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_DESC;
812:
813: IF (OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_TYPE IS NULL) THEN
814: OPEN fnd_lookup_csr('OKL_TCN_TYPE', 'RAP');
815: FETCH fnd_lookup_csr INTO OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_TYPE,OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_MEANING, OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_DESC;
816: IF (fnd_lookup_csr%NOTFOUND) THEN
817: CLOSE fnd_lookup_csr;

Line 815: FETCH fnd_lookup_csr INTO OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_TYPE,OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_MEANING, OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_DESC;

811: l_trx_desc := OKL_VARIABLE_INTEREST_PVT.G_RCPT_APP_TRX_DESC;
812:
813: IF (OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_TYPE IS NULL) THEN
814: OPEN fnd_lookup_csr('OKL_TCN_TYPE', 'RAP');
815: FETCH fnd_lookup_csr INTO OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_TYPE,OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_MEANING, OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_DESC;
816: IF (fnd_lookup_csr%NOTFOUND) THEN
817: CLOSE fnd_lookup_csr;
818: OKL_VARIABLE_INTEREST_PVT.print_error_message('FND lookup cursor did not return any records');
819: RAISE create_stream_invoice_failed;

Line 818: OKL_VARIABLE_INTEREST_PVT.print_error_message('FND lookup cursor did not return any records');

814: OPEN fnd_lookup_csr('OKL_TCN_TYPE', 'RAP');
815: FETCH fnd_lookup_csr INTO OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_TYPE,OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_MEANING, OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_DESC;
816: IF (fnd_lookup_csr%NOTFOUND) THEN
817: CLOSE fnd_lookup_csr;
818: OKL_VARIABLE_INTEREST_PVT.print_error_message('FND lookup cursor did not return any records');
819: RAISE create_stream_invoice_failed;
820: END IF;
821: CLOSE fnd_lookup_csr;
822: END IF;

Line 824: l_tcn_type := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_TYPE;

820: END IF;
821: CLOSE fnd_lookup_csr;
822: END IF;
823:
824: l_tcn_type := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_TYPE;
825: l_tcn_meaning := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_MEANING;
826: l_tcn_desc := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_DESC;
827: -- new
828: ELSIF (p_stream_type_purpose IN ('PRINCIPAL_CATCHUP')) THEN

Line 825: l_tcn_meaning := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_MEANING;

821: CLOSE fnd_lookup_csr;
822: END IF;
823:
824: l_tcn_type := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_TYPE;
825: l_tcn_meaning := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_MEANING;
826: l_tcn_desc := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_DESC;
827: -- new
828: ELSIF (p_stream_type_purpose IN ('PRINCIPAL_CATCHUP')) THEN
829: ------------------------------------------------------------

Line 826: l_tcn_desc := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_DESC;

822: END IF;
823:
824: l_tcn_type := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_TYPE;
825: l_tcn_meaning := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_MEANING;
826: l_tcn_desc := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCN_DESC;
827: -- new
828: ELSIF (p_stream_type_purpose IN ('PRINCIPAL_CATCHUP')) THEN
829: ------------------------------------------------------------
830: -- Create Contract Transaction Header and Line for Principal Adjustment

Line 833: IF (OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_TYPE_ID IS NULL) THEN

829: ------------------------------------------------------------
830: -- Create Contract Transaction Header and Line for Principal Adjustment
831: -- in Submitted Status
832: ------------------------------------------------------------
833: IF (OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_TYPE_ID IS NULL) THEN
834: OPEN trx_type_csr('Principal Adjustment');
835: FETCH trx_type_csr INTO OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_TYPE_ID, OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_TRY_ID, OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_DESC;
836: IF (trx_type_csr%NOTFOUND) THEN
837: CLOSE trx_type_csr;

Line 835: FETCH trx_type_csr INTO OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_TYPE_ID, OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_TRY_ID, OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_DESC;

831: -- in Submitted Status
832: ------------------------------------------------------------
833: IF (OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_TYPE_ID IS NULL) THEN
834: OPEN trx_type_csr('Principal Adjustment');
835: FETCH trx_type_csr INTO OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_TYPE_ID, OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_TRY_ID, OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_DESC;
836: IF (trx_type_csr%NOTFOUND) THEN
837: CLOSE trx_type_csr;
838: OKL_VARIABLE_INTEREST_PVT.print_error_message('Transaction type cursor did not return any records');
839: RAISE create_stream_invoice_failed;

Line 838: OKL_VARIABLE_INTEREST_PVT.print_error_message('Transaction type cursor did not return any records');

834: OPEN trx_type_csr('Principal Adjustment');
835: FETCH trx_type_csr INTO OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_TYPE_ID, OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_TRY_ID, OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_DESC;
836: IF (trx_type_csr%NOTFOUND) THEN
837: CLOSE trx_type_csr;
838: OKL_VARIABLE_INTEREST_PVT.print_error_message('Transaction type cursor did not return any records');
839: RAISE create_stream_invoice_failed;
840: END IF;
841: CLOSE trx_type_csr;
842: END IF;

Line 843: l_trx_type_id := OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_TYPE_ID;

839: RAISE create_stream_invoice_failed;
840: END IF;
841: CLOSE trx_type_csr;
842: END IF;
843: l_trx_type_id := OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_TYPE_ID;
844: l_trx_try_id := OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_TRY_ID;
845: l_trx_desc := OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_DESC;
846:
847: IF (OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_TYPE IS NULL) THEN

Line 844: l_trx_try_id := OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_TRY_ID;

840: END IF;
841: CLOSE trx_type_csr;
842: END IF;
843: l_trx_type_id := OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_TYPE_ID;
844: l_trx_try_id := OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_TRY_ID;
845: l_trx_desc := OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_DESC;
846:
847: IF (OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_TYPE IS NULL) THEN
848: OPEN fnd_lookup_csr('OKL_TCN_TYPE', 'PAD');

Line 845: l_trx_desc := OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_DESC;

841: CLOSE trx_type_csr;
842: END IF;
843: l_trx_type_id := OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_TYPE_ID;
844: l_trx_try_id := OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_TRY_ID;
845: l_trx_desc := OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_DESC;
846:
847: IF (OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_TYPE IS NULL) THEN
848: OPEN fnd_lookup_csr('OKL_TCN_TYPE', 'PAD');
849: FETCH fnd_lookup_csr INTO OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_TYPE,OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_MEANING, OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_DESC;

Line 847: IF (OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_TYPE IS NULL) THEN

843: l_trx_type_id := OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_TYPE_ID;
844: l_trx_try_id := OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_TRY_ID;
845: l_trx_desc := OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_DESC;
846:
847: IF (OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_TYPE IS NULL) THEN
848: OPEN fnd_lookup_csr('OKL_TCN_TYPE', 'PAD');
849: FETCH fnd_lookup_csr INTO OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_TYPE,OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_MEANING, OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_DESC;
850: IF (fnd_lookup_csr%NOTFOUND) THEN
851: CLOSE fnd_lookup_csr;

Line 849: FETCH fnd_lookup_csr INTO OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_TYPE,OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_MEANING, OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_DESC;

845: l_trx_desc := OKL_VARIABLE_INTEREST_PVT.G_PAD_TRX_DESC;
846:
847: IF (OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_TYPE IS NULL) THEN
848: OPEN fnd_lookup_csr('OKL_TCN_TYPE', 'PAD');
849: FETCH fnd_lookup_csr INTO OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_TYPE,OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_MEANING, OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_DESC;
850: IF (fnd_lookup_csr%NOTFOUND) THEN
851: CLOSE fnd_lookup_csr;
852: OKL_VARIABLE_INTEREST_PVT.print_error_message('FND lookup cursor did not return any records');
853: RAISE create_stream_invoice_failed;

Line 852: OKL_VARIABLE_INTEREST_PVT.print_error_message('FND lookup cursor did not return any records');

848: OPEN fnd_lookup_csr('OKL_TCN_TYPE', 'PAD');
849: FETCH fnd_lookup_csr INTO OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_TYPE,OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_MEANING, OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_DESC;
850: IF (fnd_lookup_csr%NOTFOUND) THEN
851: CLOSE fnd_lookup_csr;
852: OKL_VARIABLE_INTEREST_PVT.print_error_message('FND lookup cursor did not return any records');
853: RAISE create_stream_invoice_failed;
854: END IF;
855: CLOSE fnd_lookup_csr;
856: END IF;

Line 858: l_tcn_type := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_TYPE;

854: END IF;
855: CLOSE fnd_lookup_csr;
856: END IF;
857:
858: l_tcn_type := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_TYPE;
859: l_tcn_meaning := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_MEANING;
860: l_tcn_desc := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_DESC;
861:
862: END IF; -- new

Line 859: l_tcn_meaning := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_MEANING;

855: CLOSE fnd_lookup_csr;
856: END IF;
857:
858: l_tcn_type := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_TYPE;
859: l_tcn_meaning := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_MEANING;
860: l_tcn_desc := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_DESC;
861:
862: END IF; -- new
863:

Line 860: l_tcn_desc := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_DESC;

856: END IF;
857:
858: l_tcn_type := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_TYPE;
859: l_tcn_meaning := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_MEANING;
860: l_tcn_desc := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_DESC;
861:
862: END IF; -- new
863:
864: OKL_VARIABLE_INTEREST_PVT.print_debug('G_CONTRACT_ID : '|| OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID);

Line 864: OKL_VARIABLE_INTEREST_PVT.print_debug('G_CONTRACT_ID : '|| OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID);

860: l_tcn_desc := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCN_DESC;
861:
862: END IF; -- new
863:
864: OKL_VARIABLE_INTEREST_PVT.print_debug('G_CONTRACT_ID : '|| OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID);
865: OKL_VARIABLE_INTEREST_PVT.print_debug('l_tcn_type: '|| l_tcn_type);
866: OKL_VARIABLE_INTEREST_PVT.print_debug('l_trx_desc: '|| l_trx_desc);
867: OKL_VARIABLE_INTEREST_PVT.print_debug('l_trx_type_id: '|| l_trx_type_id);
868:

Line 865: OKL_VARIABLE_INTEREST_PVT.print_debug('l_tcn_type: '|| l_tcn_type);

861:
862: END IF; -- new
863:
864: OKL_VARIABLE_INTEREST_PVT.print_debug('G_CONTRACT_ID : '|| OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID);
865: OKL_VARIABLE_INTEREST_PVT.print_debug('l_tcn_type: '|| l_tcn_type);
866: OKL_VARIABLE_INTEREST_PVT.print_debug('l_trx_desc: '|| l_trx_desc);
867: OKL_VARIABLE_INTEREST_PVT.print_debug('l_trx_type_id: '|| l_trx_type_id);
868:
869: l_trxH_in_rec.khr_id := p_contract_id;

Line 866: OKL_VARIABLE_INTEREST_PVT.print_debug('l_trx_desc: '|| l_trx_desc);

862: END IF; -- new
863:
864: OKL_VARIABLE_INTEREST_PVT.print_debug('G_CONTRACT_ID : '|| OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID);
865: OKL_VARIABLE_INTEREST_PVT.print_debug('l_tcn_type: '|| l_tcn_type);
866: OKL_VARIABLE_INTEREST_PVT.print_debug('l_trx_desc: '|| l_trx_desc);
867: OKL_VARIABLE_INTEREST_PVT.print_debug('l_trx_type_id: '|| l_trx_type_id);
868:
869: l_trxH_in_rec.khr_id := p_contract_id;
870: l_trxH_in_rec.pdt_id := OKL_VARIABLE_INTEREST_PVT.G_PRODUCT_ID;

Line 867: OKL_VARIABLE_INTEREST_PVT.print_debug('l_trx_type_id: '|| l_trx_type_id);

863:
864: OKL_VARIABLE_INTEREST_PVT.print_debug('G_CONTRACT_ID : '|| OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID);
865: OKL_VARIABLE_INTEREST_PVT.print_debug('l_tcn_type: '|| l_tcn_type);
866: OKL_VARIABLE_INTEREST_PVT.print_debug('l_trx_desc: '|| l_trx_desc);
867: OKL_VARIABLE_INTEREST_PVT.print_debug('l_trx_type_id: '|| l_trx_type_id);
868:
869: l_trxH_in_rec.khr_id := p_contract_id;
870: l_trxH_in_rec.pdt_id := OKL_VARIABLE_INTEREST_PVT.G_PRODUCT_ID;
871: l_trxH_in_rec.set_of_books_id := l_set_of_books_id;

Line 870: l_trxH_in_rec.pdt_id := OKL_VARIABLE_INTEREST_PVT.G_PRODUCT_ID;

866: OKL_VARIABLE_INTEREST_PVT.print_debug('l_trx_desc: '|| l_trx_desc);
867: OKL_VARIABLE_INTEREST_PVT.print_debug('l_trx_type_id: '|| l_trx_type_id);
868:
869: l_trxH_in_rec.khr_id := p_contract_id;
870: l_trxH_in_rec.pdt_id := OKL_VARIABLE_INTEREST_PVT.G_PRODUCT_ID;
871: l_trxH_in_rec.set_of_books_id := l_set_of_books_id;
872: l_trxH_in_rec.tsu_code := 'PROCESSED';
873: l_trxH_in_rec.tcn_type := l_tcn_type; --G_RAP_TCN_TYPE;
874: l_trxH_in_rec.description := l_trx_desc; --G_RCPT_APP_TRX_DESC;

Line 878: l_trxH_in_rec.currency_code := OKL_VARIABLE_INTEREST_PVT.G_CURRENCY_CODE;

874: l_trxH_in_rec.description := l_trx_desc; --G_RCPT_APP_TRX_DESC;
875: l_trxH_in_rec.date_transaction_occurred := p_due_date;
876: l_trxH_in_rec.try_id := l_trx_type_id; --G_RCPT_APP_TRX_TYPE_ID;
877: l_trxH_in_rec.amount := p_amount;
878: l_trxH_in_rec.currency_code := OKL_VARIABLE_INTEREST_PVT.G_CURRENCY_CODE;
879: l_trxH_in_rec.org_id := OKL_VARIABLE_INTEREST_PVT.G_AUTHORING_ORG_ID;
880: l_trxH_in_rec.request_id := OKL_VARIABLE_INTEREST_PVT.g_request_id;
881: -- Bug 5964482 dpsingh for AE signature Uptake start
882: OPEN get_dff_fields(p_contract_id);

Line 879: l_trxH_in_rec.org_id := OKL_VARIABLE_INTEREST_PVT.G_AUTHORING_ORG_ID;

875: l_trxH_in_rec.date_transaction_occurred := p_due_date;
876: l_trxH_in_rec.try_id := l_trx_type_id; --G_RCPT_APP_TRX_TYPE_ID;
877: l_trxH_in_rec.amount := p_amount;
878: l_trxH_in_rec.currency_code := OKL_VARIABLE_INTEREST_PVT.G_CURRENCY_CODE;
879: l_trxH_in_rec.org_id := OKL_VARIABLE_INTEREST_PVT.G_AUTHORING_ORG_ID;
880: l_trxH_in_rec.request_id := OKL_VARIABLE_INTEREST_PVT.g_request_id;
881: -- Bug 5964482 dpsingh for AE signature Uptake start
882: OPEN get_dff_fields(p_contract_id);
883: FETCH get_dff_fields into l_trxH_in_rec.ATTRIBUTE_CATEGORY,

Line 880: l_trxH_in_rec.request_id := OKL_VARIABLE_INTEREST_PVT.g_request_id;

876: l_trxH_in_rec.try_id := l_trx_type_id; --G_RCPT_APP_TRX_TYPE_ID;
877: l_trxH_in_rec.amount := p_amount;
878: l_trxH_in_rec.currency_code := OKL_VARIABLE_INTEREST_PVT.G_CURRENCY_CODE;
879: l_trxH_in_rec.org_id := OKL_VARIABLE_INTEREST_PVT.G_AUTHORING_ORG_ID;
880: l_trxH_in_rec.request_id := OKL_VARIABLE_INTEREST_PVT.g_request_id;
881: -- Bug 5964482 dpsingh for AE signature Uptake start
882: OPEN get_dff_fields(p_contract_id);
883: FETCH get_dff_fields into l_trxH_in_rec.ATTRIBUTE_CATEGORY,
884: l_trxH_in_rec.ATTRIBUTE1,

Line 906: IF (OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_TYPE IS NULL) THEN

902: l_trxH_in_rec.legal_entity_id := l_legal_entity_id;
903:
904: IF (p_stream_type_purpose IN ('DAILY_INTEREST_PRINCIPAL', 'DAILY_INTEREST_INTEREST')) THEN
905:
906: IF (OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_TYPE IS NULL) THEN
907: OPEN fnd_lookup_csr('OKL_TCL_TYPE', 'RAP');
908: FETCH fnd_lookup_csr INTO OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_TYPE,OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_MEANING, OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_DESC;
909: IF (fnd_lookup_csr%NOTFOUND) THEN
910: CLOSE fnd_lookup_csr;

Line 908: FETCH fnd_lookup_csr INTO OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_TYPE,OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_MEANING, OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_DESC;

904: IF (p_stream_type_purpose IN ('DAILY_INTEREST_PRINCIPAL', 'DAILY_INTEREST_INTEREST')) THEN
905:
906: IF (OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_TYPE IS NULL) THEN
907: OPEN fnd_lookup_csr('OKL_TCL_TYPE', 'RAP');
908: FETCH fnd_lookup_csr INTO OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_TYPE,OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_MEANING, OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_DESC;
909: IF (fnd_lookup_csr%NOTFOUND) THEN
910: CLOSE fnd_lookup_csr;
911: OKL_VARIABLE_INTEREST_PVT.print_error_message('FND lookup cursor did not return any records');
912: RAISE create_stream_invoice_failed;

Line 911: OKL_VARIABLE_INTEREST_PVT.print_error_message('FND lookup cursor did not return any records');

907: OPEN fnd_lookup_csr('OKL_TCL_TYPE', 'RAP');
908: FETCH fnd_lookup_csr INTO OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_TYPE,OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_MEANING, OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_DESC;
909: IF (fnd_lookup_csr%NOTFOUND) THEN
910: CLOSE fnd_lookup_csr;
911: OKL_VARIABLE_INTEREST_PVT.print_error_message('FND lookup cursor did not return any records');
912: RAISE create_stream_invoice_failed;
913: END IF;
914: CLOSE fnd_lookup_csr;
915: END IF;

Line 916: l_tcl_type := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_TYPE;

912: RAISE create_stream_invoice_failed;
913: END IF;
914: CLOSE fnd_lookup_csr;
915: END IF;
916: l_tcl_type := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_TYPE;
917: l_tcl_meaning := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_MEANING;
918: l_tcl_desc := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_DESC;
919: ELSIF (p_stream_type_purpose = 'PRINCIPAL_CATCHUP') THEN
920: IF (OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_TYPE IS NULL) THEN

Line 917: l_tcl_meaning := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_MEANING;

913: END IF;
914: CLOSE fnd_lookup_csr;
915: END IF;
916: l_tcl_type := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_TYPE;
917: l_tcl_meaning := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_MEANING;
918: l_tcl_desc := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_DESC;
919: ELSIF (p_stream_type_purpose = 'PRINCIPAL_CATCHUP') THEN
920: IF (OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_TYPE IS NULL) THEN
921: OPEN fnd_lookup_csr('OKL_TCL_TYPE', 'PAD');

Line 918: l_tcl_desc := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_DESC;

914: CLOSE fnd_lookup_csr;
915: END IF;
916: l_tcl_type := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_TYPE;
917: l_tcl_meaning := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_MEANING;
918: l_tcl_desc := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_DESC;
919: ELSIF (p_stream_type_purpose = 'PRINCIPAL_CATCHUP') THEN
920: IF (OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_TYPE IS NULL) THEN
921: OPEN fnd_lookup_csr('OKL_TCL_TYPE', 'PAD');
922: FETCH fnd_lookup_csr INTO OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_TYPE,OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_MEANING, OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_DESC;

Line 920: IF (OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_TYPE IS NULL) THEN

916: l_tcl_type := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_TYPE;
917: l_tcl_meaning := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_MEANING;
918: l_tcl_desc := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_DESC;
919: ELSIF (p_stream_type_purpose = 'PRINCIPAL_CATCHUP') THEN
920: IF (OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_TYPE IS NULL) THEN
921: OPEN fnd_lookup_csr('OKL_TCL_TYPE', 'PAD');
922: FETCH fnd_lookup_csr INTO OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_TYPE,OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_MEANING, OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_DESC;
923: IF (fnd_lookup_csr%NOTFOUND) THEN
924: CLOSE fnd_lookup_csr;

Line 922: FETCH fnd_lookup_csr INTO OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_TYPE,OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_MEANING, OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_DESC;

918: l_tcl_desc := OKL_VARIABLE_INTEREST_PVT.G_RAP_TCL_DESC;
919: ELSIF (p_stream_type_purpose = 'PRINCIPAL_CATCHUP') THEN
920: IF (OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_TYPE IS NULL) THEN
921: OPEN fnd_lookup_csr('OKL_TCL_TYPE', 'PAD');
922: FETCH fnd_lookup_csr INTO OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_TYPE,OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_MEANING, OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_DESC;
923: IF (fnd_lookup_csr%NOTFOUND) THEN
924: CLOSE fnd_lookup_csr;
925: OKL_VARIABLE_INTEREST_PVT.print_error_message('FND lookup cursor did not return any records');
926: RAISE create_stream_invoice_failed;

Line 925: OKL_VARIABLE_INTEREST_PVT.print_error_message('FND lookup cursor did not return any records');

921: OPEN fnd_lookup_csr('OKL_TCL_TYPE', 'PAD');
922: FETCH fnd_lookup_csr INTO OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_TYPE,OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_MEANING, OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_DESC;
923: IF (fnd_lookup_csr%NOTFOUND) THEN
924: CLOSE fnd_lookup_csr;
925: OKL_VARIABLE_INTEREST_PVT.print_error_message('FND lookup cursor did not return any records');
926: RAISE create_stream_invoice_failed;
927: END IF;
928: CLOSE fnd_lookup_csr;
929: END IF;

Line 930: l_tcl_type := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_TYPE;

926: RAISE create_stream_invoice_failed;
927: END IF;
928: CLOSE fnd_lookup_csr;
929: END IF;
930: l_tcl_type := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_TYPE;
931: l_tcl_meaning := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_MEANING;
932: l_tcl_desc := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_DESC;
933: END IF;
934:

Line 931: l_tcl_meaning := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_MEANING;

927: END IF;
928: CLOSE fnd_lookup_csr;
929: END IF;
930: l_tcl_type := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_TYPE;
931: l_tcl_meaning := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_MEANING;
932: l_tcl_desc := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_DESC;
933: END IF;
934:
935: OKL_VARIABLE_INTEREST_PVT.print_debug('l_tcl_type : '||l_tcl_type);

Line 932: l_tcl_desc := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_DESC;

928: CLOSE fnd_lookup_csr;
929: END IF;
930: l_tcl_type := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_TYPE;
931: l_tcl_meaning := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_MEANING;
932: l_tcl_desc := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_DESC;
933: END IF;
934:
935: OKL_VARIABLE_INTEREST_PVT.print_debug('l_tcl_type : '||l_tcl_type);
936: OKL_VARIABLE_INTEREST_PVT.print_debug('l_tcl_desc : '||l_tcl_desc);

Line 935: OKL_VARIABLE_INTEREST_PVT.print_debug('l_tcl_type : '||l_tcl_type);

931: l_tcl_meaning := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_MEANING;
932: l_tcl_desc := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_DESC;
933: END IF;
934:
935: OKL_VARIABLE_INTEREST_PVT.print_debug('l_tcl_type : '||l_tcl_type);
936: OKL_VARIABLE_INTEREST_PVT.print_debug('l_tcl_desc : '||l_tcl_desc);
937:
938: l_trxL_in_tbl(1).line_number := 1;
939: l_trxL_in_tbl(1).khr_id := p_contract_id;

Line 936: OKL_VARIABLE_INTEREST_PVT.print_debug('l_tcl_desc : '||l_tcl_desc);

932: l_tcl_desc := OKL_VARIABLE_INTEREST_PVT.G_PAD_TCL_DESC;
933: END IF;
934:
935: OKL_VARIABLE_INTEREST_PVT.print_debug('l_tcl_type : '||l_tcl_type);
936: OKL_VARIABLE_INTEREST_PVT.print_debug('l_tcl_desc : '||l_tcl_desc);
937:
938: l_trxL_in_tbl(1).line_number := 1;
939: l_trxL_in_tbl(1).khr_id := p_contract_id;
940: l_trxL_in_tbl(1).sty_id := l_sty_id;

Line 944: l_trxL_in_tbl(1).currency_code := OKL_VARIABLE_INTEREST_PVT.G_CURRENCY_CODE;

940: l_trxL_in_tbl(1).sty_id := l_sty_id;
941: l_trxL_in_tbl(1).tcl_type := l_tcl_type; --G_RAP_TCL_TYPE;
942: l_trxL_in_tbl(1).description := l_tcl_desc; --G_RAP_TCL_DESC;
943: l_trxL_in_tbl(1).amount := p_amount;
944: l_trxL_in_tbl(1).currency_code := OKL_VARIABLE_INTEREST_PVT.G_CURRENCY_CODE;
945:
946: OKL_VARIABLE_INTEREST_PVT.print_debug('Creating Contract Transaction.');
947: Okl_Trx_Contracts_Pub.create_trx_contracts(
948: p_api_version => l_api_version,

Line 946: OKL_VARIABLE_INTEREST_PVT.print_debug('Creating Contract Transaction.');

942: l_trxL_in_tbl(1).description := l_tcl_desc; --G_RAP_TCL_DESC;
943: l_trxL_in_tbl(1).amount := p_amount;
944: l_trxL_in_tbl(1).currency_code := OKL_VARIABLE_INTEREST_PVT.G_CURRENCY_CODE;
945:
946: OKL_VARIABLE_INTEREST_PVT.print_debug('Creating Contract Transaction.');
947: Okl_Trx_Contracts_Pub.create_trx_contracts(
948: p_api_version => l_api_version,
949: p_init_msg_list => p_init_msg_list,
950: x_return_status => x_return_status,

Line 959: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Trx_Contracts_Pub.create_trx_contracts');

955: x_tcnv_rec => l_trxH_out_rec,
956: x_tclv_tbl => l_trxL_out_tbl);
957:
958: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
959: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Trx_Contracts_Pub.create_trx_contracts');
960: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
961: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
962: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Trx_Contracts_Pub.create_trx_contracts');
963: RAISE create_stream_invoice_failed;

Line 962: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Trx_Contracts_Pub.create_trx_contracts');

958: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
959: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Trx_Contracts_Pub.create_trx_contracts');
960: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
961: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
962: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Trx_Contracts_Pub.create_trx_contracts');
963: RAISE create_stream_invoice_failed;
964: END IF;
965:
966: IF ((l_trxH_out_rec.id = OKL_API.G_MISS_NUM) OR

Line 969: OKL_VARIABLE_INTEREST_PVT.print_error_message ('ERROR : OKL transaction ID is NULL');

965:
966: IF ((l_trxH_out_rec.id = OKL_API.G_MISS_NUM) OR
967: (l_trxH_out_rec.id IS NULL) ) THEN
968: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'TRANSACTION_ID');
969: OKL_VARIABLE_INTEREST_PVT.print_error_message ('ERROR : OKL transaction ID is NULL');
970: RAISE create_stream_invoice_failed;
971: END IF;
972:
973: l_okl_trx_created := OKL_API.G_TRUE;

Line 979: OKL_VARIABLE_INTEREST_PVT.print_debug(' -- Creating Distributions. Supplied parameters:');

975: ------------------------------------------------------------
976: -- Derive and Insert Distribution Line
977: ------------------------------------------------------------
978:
979: OKL_VARIABLE_INTEREST_PVT.print_debug(' -- Creating Distributions. Supplied parameters:');
980:
981: ------------------ Accounting Engine Calls --------------------------
982: --START: Changes by dpsingh for SLA Uptake, Bug #5964482
983: Okl_Acc_Call_Pvt.Okl_Populate_Acc_Gen (

Line 989: OKL_VARIABLE_INTEREST_PVT.print_debug('End Debug OKLRVARB.pls call Okl_Acc_Call_Pvt.Okl_Populate_Acc_Gen ');

985: p_contract_line_id => p_line_id,
986: x_acc_gen_tbl => l_acc_gen_primary_key_tbl,
987: x_return_status => x_return_status);
988:
989: OKL_VARIABLE_INTEREST_PVT.print_debug('End Debug OKLRVARB.pls call Okl_Acc_Call_Pvt.Okl_Populate_Acc_Gen ');
990: IF ( x_return_status = okl_api.g_ret_sts_success) THEN
991: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Accounting engine called successfully ');
992: ELSE
993: FND_FILE.PUT_LINE (FND_FILE.LOG, '*=> ERROR : Calling Accounting engine.');

Line 995: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Acc_Call_Pvt.Okl_Populate_Acc_Gen');

991: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Accounting engine called successfully ');
992: ELSE
993: FND_FILE.PUT_LINE (FND_FILE.LOG, '*=> ERROR : Calling Accounting engine.');
994: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
995: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Acc_Call_Pvt.Okl_Populate_Acc_Gen');
996: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
997: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
998: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Acc_Call_Pvt.Okl_Populate_Acc_Gen');
999: RAISE create_stream_invoice_failed;

Line 998: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Acc_Call_Pvt.Okl_Populate_Acc_Gen');

994: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
995: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Acc_Call_Pvt.Okl_Populate_Acc_Gen');
996: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
997: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
998: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Acc_Call_Pvt.Okl_Populate_Acc_Gen');
999: RAISE create_stream_invoice_failed;
1000: END IF;
1001: END IF;
1002: l_tcn_id := l_trxH_out_rec.id;

Line 1009: l_tmpl_identify_tbl(i).product_id := OKL_VARIABLE_INTEREST_PVT.G_PRODUCT_ID;

1005: LOOP
1006: l_acc_gen_tbl(i).acc_gen_key_tbl := l_acc_gen_primary_key_tbl;
1007: l_acc_gen_tbl(i).source_id := l_trxL_out_tbl(i).id;
1008:
1009: l_tmpl_identify_tbl(i).product_id := OKL_VARIABLE_INTEREST_PVT.G_PRODUCT_ID;
1010: l_tmpl_identify_tbl(i).transaction_type_id := l_trx_type_id; --G_RCPT_APP_TRX_TYPE_ID;
1011: l_tmpl_identify_tbl(i).stream_type_id := l_sty_id;
1012: l_tmpl_identify_tbl(i).ADVANCE_ARREARS := NULL;
1013: l_tmpl_identify_tbl(i).FACTORING_SYND_FLAG := NULL;

Line 1027: OKL_VARIABLE_INTEREST_PVT.G_CURRENCY_CODE;

1023: l_dist_info_tbl(i).gl_reversal_flag := 'N';
1024: l_dist_info_tbl(i).post_to_gl := 'Y';
1025: l_dist_info_tbl(i).amount := p_amount;
1026: l_dist_info_tbl(i).currency_code :=
1027: OKL_VARIABLE_INTEREST_PVT.G_CURRENCY_CODE;
1028: l_dist_info_tbl(i).contract_id := p_contract_id;
1029: l_dist_info_tbl(i).contract_line_id := p_line_id;
1030: END LOOP;
1031: END IF;

Line 1033: OKL_VARIABLE_INTEREST_PVT.print_debug('Begin Debug OKLRVARB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');

1029: l_dist_info_tbl(i).contract_line_id := p_line_id;
1030: END LOOP;
1031: END IF;
1032:
1033: OKL_VARIABLE_INTEREST_PVT.print_debug('Begin Debug OKLRVARB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
1034:
1035: -- Call new signature
1036: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(
1037: p_api_version => p_api_version,

Line 1052: OKL_VARIABLE_INTEREST_PVT.print_debug('End Debug OKLRVARB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');

1048: p_trx_header_id => l_tcn_id);
1049:
1050: --END: Changes by dpsingh for SLA Uptake, Bug #5964482
1051:
1052: OKL_VARIABLE_INTEREST_PVT.print_debug('End Debug OKLRVARB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
1053:
1054: IF ( x_return_status = okl_api.g_ret_sts_success) THEN
1055: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Accounting distributions created. ');
1056: ELSE

Line 1059: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST');

1055: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Accounting distributions created. ');
1056: ELSE
1057: FND_FILE.PUT_LINE (FND_FILE.LOG, '*=> ERROR : Accounting distributions not created.'||x_msg_count || x_msg_data);
1058: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1059: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST');
1060: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1061: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1062: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST');
1063: RAISE create_stream_invoice_failed;

Line 1062: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST');

1058: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1059: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST');
1060: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1061: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1062: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST');
1063: RAISE create_stream_invoice_failed;
1064: END IF;
1065: END IF;
1066: -- END IF;

Line 1082: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to OKL_MULTIGAAP_ENGINE_PVT.CREATE_SEC_REP_TRX');

1078: ,p_ctxt_val_tbl => l_ctxt_tbl
1079: ,p_acc_gen_primary_key_tbl => l_acc_gen_primary_key_tbl);
1080:
1081: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1082: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to OKL_MULTIGAAP_ENGINE_PVT.CREATE_SEC_REP_TRX');
1083: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1084: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1085: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to OKL_MULTIGAAP_ENGINE_PVT.CREATE_SEC_REP_TRX');
1086: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1085: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to OKL_MULTIGAAP_ENGINE_PVT.CREATE_SEC_REP_TRX');

1081: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1082: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to OKL_MULTIGAAP_ENGINE_PVT.CREATE_SEC_REP_TRX');
1083: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1084: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1085: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to OKL_MULTIGAAP_ENGINE_PVT.CREATE_SEC_REP_TRX');
1086: RAISE Okl_Api.G_EXCEPTION_ERROR;
1087: END IF;
1088: -- end the call to MG engine .. racheruv. Bug 7690456
1089: END IF;

Line 1094: OKL_VARIABLE_INTEREST_PVT.print_error_message('Exception create_stream_invoice_failed raised in procedure CREATE_STREAM_INVOICE');

1090:
1091:
1092: EXCEPTION
1093: WHEN create_stream_invoice_failed THEN
1094: OKL_VARIABLE_INTEREST_PVT.print_error_message('Exception create_stream_invoice_failed raised in procedure CREATE_STREAM_INVOICE');
1095: IF (stream_csr%ISOPEN) THEN
1096: CLOSE stream_csr;
1097: END IF;
1098:

Line 1150: OKL_VARIABLE_INTEREST_PVT.print_error_message('Exception raised in procedure CREATE_STREAM_INVOICE');

1146: END IF;
1147: x_return_status := OKL_API.G_RET_STS_ERROR;
1148:
1149: WHEN OTHERS THEN
1150: OKL_VARIABLE_INTEREST_PVT.print_error_message('Exception raised in procedure CREATE_STREAM_INVOICE');
1151: IF (stream_csr%ISOPEN) THEN
1152: CLOSE stream_csr;
1153: END IF;
1154: