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.OKE_FORM_PVT dependencies on FND_LOG

Line 259: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

255: l_api_name CONSTANT VARCHAR2(30) := 'null_out_defaults';
256:
257: BEGIN
258:
259: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
260: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'call from null out defaults');
261: END IF;
262:
263: IF l_form_rec.K_HEADER_ID = OKE_API.G_MISS_NUM THEN

Line 260: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'call from null out defaults');

256:
257: BEGIN
258:
259: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
260: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'call from null out defaults');
261: END IF;
262:
263: IF l_form_rec.K_HEADER_ID = OKE_API.G_MISS_NUM THEN
264: l_form_rec.K_HEADER_ID := NULL;

Line 371: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

367: IF l_form_rec.LAST_UPDATE_DATE = OKE_API.G_MISS_DATE THEN
368: l_form_rec.LAST_UPDATE_DATE := NULL;
369: END IF;
370:
371: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
372: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'all through null out defaults');
373: END IF;
374:
375: RETURN(l_form_rec);

Line 372: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'all through null out defaults');

368: l_form_rec.LAST_UPDATE_DATE := NULL;
369: END IF;
370:
371: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
372: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'all through null out defaults');
373: END IF;
374:
375: RETURN(l_form_rec);
376:

Line 432: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

428: BEGIN
429: x_no_data_found := TRUE;
430:
431: -- get current database value
432: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
433: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'get rec-pos 1');
434: END IF;
435:
436: OPEN form_pk_csr(p_form_rec.K_HEADER_ID,p_form_rec.K_LINE_ID,p_form_rec.PRINT_FORM_CODE);

Line 433: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'get rec-pos 1');

429: x_no_data_found := TRUE;
430:
431: -- get current database value
432: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
433: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'get rec-pos 1');
434: END IF;
435:
436: OPEN form_pk_csr(p_form_rec.K_HEADER_ID,p_form_rec.K_LINE_ID,p_form_rec.PRINT_FORM_CODE);
437: FETCH form_pk_csr INTO

Line 466: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

462: l_form_rec.ATTRIBUTE13 ,
463: l_form_rec.ATTRIBUTE14 ,
464: l_form_rec.ATTRIBUTE15 ;
465:
466: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
467: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'get rec-pos 2');
468: x_no_data_found := form_pk_csr%NOTFOUND;
469: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'get rec-pos 3');
470: CLOSE form_pk_csr;

Line 467: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'get rec-pos 2');

463: l_form_rec.ATTRIBUTE14 ,
464: l_form_rec.ATTRIBUTE15 ;
465:
466: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
467: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'get rec-pos 2');
468: x_no_data_found := form_pk_csr%NOTFOUND;
469: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'get rec-pos 3');
470: CLOSE form_pk_csr;
471: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'get rec-pos 4');

Line 469: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'get rec-pos 3');

465:
466: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
467: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'get rec-pos 2');
468: x_no_data_found := form_pk_csr%NOTFOUND;
469: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'get rec-pos 3');
470: CLOSE form_pk_csr;
471: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'get rec-pos 4');
472: END IF;
473: IF(x_no_data_found) THEN

Line 471: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'get rec-pos 4');

467: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'get rec-pos 2');
468: x_no_data_found := form_pk_csr%NOTFOUND;
469: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'get rec-pos 3');
470: CLOSE form_pk_csr;
471: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'get rec-pos 4');
472: END IF;
473: IF(x_no_data_found) THEN
474: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
475: END IF;

Line 476: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

472: END IF;
473: IF(x_no_data_found) THEN
474: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
475: END IF;
476: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
477: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'get rec-pos 5');
478: END IF;
479:
480: RETURN(l_form_rec);

Line 477: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'get rec-pos 5');

473: IF(x_no_data_found) THEN
474: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
475: END IF;
476: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
477: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'get rec-pos 5');
478: END IF;
479:
480: RETURN(l_form_rec);
481:

Line 545: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

541:
542:
543: BEGIN -- insert
544:
545: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
546: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call insert api');
547: END IF;
548:
549: l_return_status := OKE_API.START_ACTIVITY(l_api_name,

Line 546: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call insert api');

542:
543: BEGIN -- insert
544:
545: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
546: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call insert api');
547: END IF;
548:
549: l_return_status := OKE_API.START_ACTIVITY(l_api_name,
550: G_PKG_NAME,

Line 564: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

560: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
561: RAISE OKE_API.G_EXCEPTION_ERROR;
562: END IF;
563:
564: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
565: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call null out defaults');
566: END IF;
567: l_form_rec := null_out_defaults(p_form_rec);
568:

Line 565: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call null out defaults');

561: RAISE OKE_API.G_EXCEPTION_ERROR;
562: END IF;
563:
564: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
565: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call null out defaults');
566: END IF;
567: l_form_rec := null_out_defaults(p_form_rec);
568:
569: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 569: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

565: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call null out defaults');
566: END IF;
567: l_form_rec := null_out_defaults(p_form_rec);
568:
569: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
570: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,' called null out defaults');
571: END IF;
572:
573: --- Setting item attributes

Line 570: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,' called null out defaults');

566: END IF;
567: l_form_rec := null_out_defaults(p_form_rec);
568:
569: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
570: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,' called null out defaults');
571: END IF;
572:
573: --- Setting item attributes
574: l_return_status := Set_Attributes(

Line 585: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

581: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
582: RAISE OKE_API.G_EXCEPTION_ERROR;
583: END IF;
584:
585: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
586: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'attributes set for insert');
587: END IF;
588:
589: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

Line 586: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'attributes set for insert');

582: RAISE OKE_API.G_EXCEPTION_ERROR;
583: END IF;
584:
585: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
586: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'attributes set for insert');
587: END IF;
588:
589: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
590: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 595: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

591: END IF;
592:
593: l_def_form_rec := fill_who_columns(l_def_form_rec);
594:
595: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
596: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'who column filled for insert');
597: END IF;
598:
599: --- Validate all non-missing attributes (Item Level Validation)

Line 596: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'who column filled for insert');

592:
593: l_def_form_rec := fill_who_columns(l_def_form_rec);
594:
595: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
596: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'who column filled for insert');
597: END IF;
598:
599: --- Validate all non-missing attributes (Item Level Validation)
600: l_return_status := Validate_Attributes(l_def_form_rec);

Line 610: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

606: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
607: RAISE OKE_API.G_EXCEPTION_ERROR;
608: END IF;
609:
610: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
611: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'attributes validated for insert');
612: END IF;
613: l_return_status := Validate_Record(l_def_form_rec);
614:

Line 611: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'attributes validated for insert');

607: RAISE OKE_API.G_EXCEPTION_ERROR;
608: END IF;
609:
610: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
611: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'attributes validated for insert');
612: END IF;
613: l_return_status := Validate_Record(l_def_form_rec);
614:
615: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

Line 682: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

678: l_def_form_rec.ATTRIBUTE14 ,
679: l_def_form_rec.ATTRIBUTE15
680: );
681:
682: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
683: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'record inserted');
684: END IF;
685: -- Set OUT values
686: x_form_rec := l_def_form_rec;

Line 683: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'record inserted');

679: l_def_form_rec.ATTRIBUTE15
680: );
681:
682: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
683: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'record inserted');
684: END IF;
685: -- Set OUT values
686: x_form_rec := l_def_form_rec;
687:

Line 860: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

856: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
857:
858: BEGIN
859:
860: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
861: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call populate new record');
862: END IF;
863:
864: x_form_rec := p_form_rec;

Line 861: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call populate new record');

857:
858: BEGIN
859:
860: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
861: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call populate new record');
862: END IF;
863:
864: x_form_rec := p_form_rec;
865:

Line 866: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

862: END IF;
863:
864: x_form_rec := p_form_rec;
865:
866: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
867: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call get rec');
868: END IF;
869: -- Get current database values
870:

Line 867: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call get rec');

863:
864: x_form_rec := p_form_rec;
865:
866: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
867: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call get rec');
868: END IF;
869: -- Get current database values
870:
871: l_form_rec := get_rec(p_form_rec, l_row_notfound);

Line 877: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

873: IF (l_row_notfound) THEN
874: l_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
875: END IF;
876:
877: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
878: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'record got');
879: END IF;
880:
881: IF x_form_rec.CREATION_DATE = OKE_API.G_MISS_DATE THEN

Line 878: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'record got');

874: l_return_status := OKE_API.G_RET_STS_UNEXP_ERROR;
875: END IF;
876:
877: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
878: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'record got');
879: END IF;
880:
881: IF x_form_rec.CREATION_DATE = OKE_API.G_MISS_DATE THEN
882: x_form_rec.CREATION_DATE := l_form_rec.CREATION_DATE;

Line 978: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

974: x_form_rec.ATTRIBUTE15 := l_form_rec.ATTRIBUTE15;
975: END IF;
976:
977: RETURN(l_return_status);
978: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
979: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'all the way through populate new record');
980: END IF;
981:
982: END populate_new_record;

Line 979: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'all the way through populate new record');

975: END IF;
976:
977: RETURN(l_return_status);
978: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
979: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'all the way through populate new record');
980: END IF;
981:
982: END populate_new_record;
983:

Line 1003: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

999: END Set_Attributes;
1000:
1001:
1002: BEGIN -- update row
1003: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1004: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call api initialization');
1005: END IF;
1006:
1007: l_return_status := OKE_API.START_ACTIVITY(l_api_name,

Line 1004: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call api initialization');

1000:
1001:
1002: BEGIN -- update row
1003: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1004: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call api initialization');
1005: END IF;
1006:
1007: l_return_status := OKE_API.START_ACTIVITY(l_api_name,
1008: G_PKG_NAME,

Line 1022: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1018: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1019: RAISE OKE_API.G_EXCEPTION_ERROR;
1020: END IF;
1021:
1022: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1023: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call not pvt');
1024: END IF;
1025:
1026: l_return_status := Set_Attributes(

Line 1023: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call not pvt');

1019: RAISE OKE_API.G_EXCEPTION_ERROR;
1020: END IF;
1021:
1022: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1023: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'start call not pvt');
1024: END IF;
1025:
1026: l_return_status := Set_Attributes(
1027: p_form_rec, -- IN

Line 1036: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1032: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1033: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1034: RAISE OKE_API.G_EXCEPTION_ERROR;
1035: END IF;
1036: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1037: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'attributes set');
1038: END IF;
1039:
1040: l_return_status := populate_new_record(l_form_rec, l_def_form_rec);

Line 1037: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'attributes set');

1033: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1034: RAISE OKE_API.G_EXCEPTION_ERROR;
1035: END IF;
1036: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1037: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'attributes set');
1038: END IF;
1039:
1040: l_return_status := populate_new_record(l_form_rec, l_def_form_rec);
1041:

Line 1047: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1043: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1044: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1045: RAISE OKE_API.G_EXCEPTION_ERROR;
1046: END IF;
1047: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1048: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'record populated');
1049: END IF;
1050:
1051: l_def_form_rec := fill_who_columns(l_def_form_rec);

Line 1048: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'record populated');

1044: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1045: RAISE OKE_API.G_EXCEPTION_ERROR;
1046: END IF;
1047: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1048: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'record populated');
1049: END IF;
1050:
1051: l_def_form_rec := fill_who_columns(l_def_form_rec);
1052: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1052: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1048: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'record populated');
1049: END IF;
1050:
1051: l_def_form_rec := fill_who_columns(l_def_form_rec);
1052: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1053: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'who column filled');
1054: END IF;
1055:
1056: --- Validate all non-missing attributes (Item Level Validation)

Line 1053: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'who column filled');

1049: END IF;
1050:
1051: l_def_form_rec := fill_who_columns(l_def_form_rec);
1052: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1053: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'who column filled');
1054: END IF;
1055:
1056: --- Validate all non-missing attributes (Item Level Validation)
1057: l_return_status := Validate_Attributes(l_def_form_rec);

Line 1065: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1061: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
1062: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1063: RAISE OKE_API.G_EXCEPTION_ERROR;
1064: END IF;
1065: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1066: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'attributes validated');
1067: END IF;
1068: l_return_status := Validate_Record(l_def_form_rec);
1069: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1066: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'attributes validated');

1062: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1063: RAISE OKE_API.G_EXCEPTION_ERROR;
1064: END IF;
1065: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1066: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'attributes validated');
1067: END IF;
1068: l_return_status := Validate_Record(l_def_form_rec);
1069: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
1070: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1075: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1071: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1072: RAISE OKE_API.G_EXCEPTION_ERROR;
1073: END IF;
1074:
1075: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1076: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'update base table');
1077: END IF;
1078:
1079: UPDATE OKE_K_PRINT_FORMS

Line 1076: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'update base table');

1072: RAISE OKE_API.G_EXCEPTION_ERROR;
1073: END IF;
1074:
1075: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1076: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'update base table');
1077: END IF;
1078:
1079: UPDATE OKE_K_PRINT_FORMS
1080: SET

Line 1169: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1165: l_overall_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1166: i NUMBER := 0;
1167: BEGIN
1168:
1169: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1170: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'begin table type of update in pvt');
1171: END IF;
1172:
1173: OKE_API.init_msg_list(p_init_msg_list);

Line 1170: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'begin table type of update in pvt');

1166: i NUMBER := 0;
1167: BEGIN
1168:
1169: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1170: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'begin table type of update in pvt');
1171: END IF;
1172:
1173: OKE_API.init_msg_list(p_init_msg_list);
1174: -- Make sure PL/SQL table has records in it before passing