APPS.PO_CONTERMS_UTL_GRP dependencies on FND_LOG

Line 129: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

125: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
126: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
127: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
128: IF (g_fnd_debug='Y') THEN
129: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
130: FND_LOG.string(log_level => FND_LOG.level_unexpected
131: ,module => g_module_prefix ||l_api_name
132: ,message => SQLERRM);
133: END IF;

Line 130: FND_LOG.string(log_level => FND_LOG.level_unexpected

126: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
127: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
128: IF (g_fnd_debug='Y') THEN
129: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
130: FND_LOG.string(log_level => FND_LOG.level_unexpected
131: ,module => g_module_prefix ||l_api_name
132: ,message => SQLERRM);
133: END IF;
134: END IF;

Line 346: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

342: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
344: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
345: IF (g_fnd_debug='Y') THEN
346: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
347: FND_LOG.string(log_level => FND_LOG.level_unexpected
348: ,module => g_module_prefix ||l_api_name
349: ,message => SQLERRM);
350: END IF;

Line 347: FND_LOG.string(log_level => FND_LOG.level_unexpected

343: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
344: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
345: IF (g_fnd_debug='Y') THEN
346: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
347: FND_LOG.string(log_level => FND_LOG.level_unexpected
348: ,module => g_module_prefix ||l_api_name
349: ,message => SQLERRM);
350: END IF;
351: END IF;

Line 493: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

489: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
491: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
492: IF (g_fnd_debug='Y') THEN
493: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
494: FND_LOG.string(log_level => FND_LOG.level_unexpected
495: ,module => g_module_prefix ||l_api_name
496: ,message => SQLERRM);
497: END IF;

Line 494: FND_LOG.string(log_level => FND_LOG.level_unexpected

490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
491: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
492: IF (g_fnd_debug='Y') THEN
493: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
494: FND_LOG.string(log_level => FND_LOG.level_unexpected
495: ,module => g_module_prefix ||l_api_name
496: ,message => SQLERRM);
497: END IF;
498: END IF;

Line 671: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
668: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
669: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
670: IF (g_fnd_debug='Y') THEN
671: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
672: FND_LOG.string(log_level => FND_LOG.level_unexpected
673: ,module => g_module_prefix ||l_api_name
674: ,message => SQLERRM);
675: END IF;

Line 672: FND_LOG.string(log_level => FND_LOG.level_unexpected

668: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
669: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
670: IF (g_fnd_debug='Y') THEN
671: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
672: FND_LOG.string(log_level => FND_LOG.level_unexpected
673: ,module => g_module_prefix ||l_api_name
674: ,message => SQLERRM);
675: END IF;
676: END IF;

Line 787: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

783: l_is_mod VARCHAR2(1) := 'N'; -- CLM Mod
784:
785: BEGIN
786: If g_fnd_debug = 'Y' then
787: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
788: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
789: MODULE =>g_module_prefix||l_api_name,
790: MESSAGE =>'10: Start' ||l_api_name);
791: END IF;

Line 788: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

784:
785: BEGIN
786: If g_fnd_debug = 'Y' then
787: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
788: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
789: MODULE =>g_module_prefix||l_api_name,
790: MESSAGE =>'10: Start' ||l_api_name);
791: END IF;
792: End if;

Line 814: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

810: x_return_status := FND_API.G_RET_STS_SUCCESS;
811: X_update_allowed := 'Y';
812:
813: If g_fnd_debug = 'Y' then
814: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
815: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
816: MODULE =>g_module_prefix||l_api_name,
817: MESSAGE =>'50: Do basic validations');
818: END IF;

Line 815: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

811: X_update_allowed := 'Y';
812:
813: If g_fnd_debug = 'Y' then
814: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
815: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
816: MODULE =>g_module_prefix||l_api_name,
817: MESSAGE =>'50: Do basic validations');
818: END IF;
819: End if;

Line 856: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

852: RAISE FND_API.G_EXC_ERROR;
853:
854: END IF;-- p_callout _string
855: If g_fnd_debug = 'Y' then
856: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
857: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
858: MODULE =>g_module_prefix||l_api_name,
859: MESSAGE =>'100: callout status '||l_callout_status);
860: END IF;

Line 857: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

853:
854: END IF;-- p_callout _string
855: If g_fnd_debug = 'Y' then
856: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
857: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
858: MODULE =>g_module_prefix||l_api_name,
859: MESSAGE =>'100: callout status '||l_callout_status);
860: END IF;
861: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 861: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

857: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
858: MODULE =>g_module_prefix||l_api_name,
859: MESSAGE =>'100: callout status '||l_callout_status);
860: END IF;
861: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
862: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
863: MODULE =>g_module_prefix||l_api_name,
864: MESSAGE =>'110:callout revision '||l_callout_revision);
865: END IF;

Line 862: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

858: MODULE =>g_module_prefix||l_api_name,
859: MESSAGE =>'100: callout status '||l_callout_status);
860: END IF;
861: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
862: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
863: MODULE =>g_module_prefix||l_api_name,
864: MESSAGE =>'110:callout revision '||l_callout_revision);
865: END IF;
866: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 866: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

862: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
863: MODULE =>g_module_prefix||l_api_name,
864: MESSAGE =>'110:callout revision '||l_callout_revision);
865: END IF;
866: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
867: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
868: MODULE =>g_module_prefix||l_api_name,
869: MESSAGE =>'120:callout employee '||l_emp_id);
870: END IF;

Line 867: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

863: MODULE =>g_module_prefix||l_api_name,
864: MESSAGE =>'110:callout revision '||l_callout_revision);
865: END IF;
866: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
867: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
868: MODULE =>g_module_prefix||l_api_name,
869: MESSAGE =>'120:callout employee '||l_emp_id);
870: END IF;
871: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 871: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

867: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
868: MODULE =>g_module_prefix||l_api_name,
869: MESSAGE =>'120:callout employee '||l_emp_id);
870: END IF;
871: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
872: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
873: MODULE =>g_module_prefix||l_api_name,
874: MESSAGE =>'140:Header id '||p_header_id);
875: END IF;

Line 872: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

868: MODULE =>g_module_prefix||l_api_name,
869: MESSAGE =>'120:callout employee '||l_emp_id);
870: END IF;
871: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
872: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
873: MODULE =>g_module_prefix||l_api_name,
874: MESSAGE =>'140:Header id '||p_header_id);
875: END IF;
876: END IF;

Line 930: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

926:
927: END;
928:
929: IF g_fnd_debug = 'Y' then
930: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
931: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
932: MODULE =>g_module_prefix||l_api_name,
933: MESSAGE =>'200:current status '||l_po_status);
934: END IF;

Line 931: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

927: END;
928:
929: IF g_fnd_debug = 'Y' then
930: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
931: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
932: MODULE =>g_module_prefix||l_api_name,
933: MESSAGE =>'200:current status '||l_po_status);
934: END IF;
935: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 935: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

931: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
932: MODULE =>g_module_prefix||l_api_name,
933: MESSAGE =>'200:current status '||l_po_status);
934: END IF;
935: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
936: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
937: MODULE =>g_module_prefix||l_api_name,
938: MESSAGE =>'220:current revision '||l_po_revision);
939: END IF;

Line 936: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

932: MODULE =>g_module_prefix||l_api_name,
933: MESSAGE =>'200:current status '||l_po_status);
934: END IF;
935: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
936: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
937: MODULE =>g_module_prefix||l_api_name,
938: MESSAGE =>'220:current revision '||l_po_revision);
939: END IF;
940:

Line 956: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

952: RAISE FND_API.G_EXC_ERROR;
953: End if;--emp id is null
954: --Check if current user is the current approver for the PO
955: IF g_fnd_debug = 'Y' then
956: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
957: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
958: MODULE =>g_module_prefix||l_api_name,
959: MESSAGE =>'250:doc type '||l_doc_type_code);
960: END IF;

Line 957: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

953: End if;--emp id is null
954: --Check if current user is the current approver for the PO
955: IF g_fnd_debug = 'Y' then
956: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
957: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
958: MODULE =>g_module_prefix||l_api_name,
959: MESSAGE =>'250:doc type '||l_doc_type_code);
960: END IF;
961: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 961: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

957: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
958: MODULE =>g_module_prefix||l_api_name,
959: MESSAGE =>'250:doc type '||l_doc_type_code);
960: END IF;
961: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
962: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
963: MODULE =>g_module_prefix||l_api_name,
964: MESSAGE =>'255:before Call to PO_DOCUMENT_CHECKS_GRP.PO_STATUS_CHECK. l_emp_id '||l_emp_id);
965: END IF;

Line 962: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

958: MODULE =>g_module_prefix||l_api_name,
959: MESSAGE =>'250:doc type '||l_doc_type_code);
960: END IF;
961: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
962: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
963: MODULE =>g_module_prefix||l_api_name,
964: MESSAGE =>'255:before Call to PO_DOCUMENT_CHECKS_GRP.PO_STATUS_CHECK. l_emp_id '||l_emp_id);
965: END IF;
966: END IF;

Line 974: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

970: x_logged_emp_id => l_emp_id,
971: x_modify_action => l_modify_action
972: );
973: IF g_fnd_debug = 'Y' then
974: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
975: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
976: MODULE =>g_module_prefix||l_api_name,
977: MESSAGE =>'260:After Call to PO_DOCUMENT_CHECKS_GRP.PO_STATUS_CHECK. modify action ');
978: END IF;

Line 975: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

971: x_modify_action => l_modify_action
972: );
973: IF g_fnd_debug = 'Y' then
974: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
975: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
976: MODULE =>g_module_prefix||l_api_name,
977: MESSAGE =>'260:After Call to PO_DOCUMENT_CHECKS_GRP.PO_STATUS_CHECK. modify action ');
978: END IF;
979: END IF;

Line 983: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

979: END IF;
980: --This API suppresses the exception. So if something fails, we won't be able to catch it.
981: IF l_modify_action then
982: IF g_fnd_debug = 'Y' then
983: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
984: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
985: MODULE =>g_module_prefix||l_api_name,
986: MESSAGE =>'270:modify action true ');
987: END IF;

Line 984: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

980: --This API suppresses the exception. So if something fails, we won't be able to catch it.
981: IF l_modify_action then
982: IF g_fnd_debug = 'Y' then
983: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
984: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
985: MODULE =>g_module_prefix||l_api_name,
986: MESSAGE =>'270:modify action true ');
987: END IF;
988: END IF;

Line 993: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

989:
990: ELSE
991: x_update_allowed := 'N';
992: IF g_fnd_debug = 'Y' then
993: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
994: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
995: MODULE =>g_module_prefix||l_api_name,
996: MESSAGE =>'290:modify action false ');
997: END IF;

Line 994: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

990: ELSE
991: x_update_allowed := 'N';
992: IF g_fnd_debug = 'Y' then
993: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
994: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
995: MODULE =>g_module_prefix||l_api_name,
996: MESSAGE =>'290:modify action false ');
997: END IF;
998: END IF;

Line 1004: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1000:
1001: END IF;
1002: END IF; -- po status INPROCESS
1003: IF g_fnd_debug = 'Y' then
1004: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1005: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1006: MODULE =>g_module_prefix||l_api_name,
1007: MESSAGE =>'292:before status check po id -update allowed '||p_header_id||x_update_allowed);
1008: END IF;

Line 1005: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1001: END IF;
1002: END IF; -- po status INPROCESS
1003: IF g_fnd_debug = 'Y' then
1004: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1005: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1006: MODULE =>g_module_prefix||l_api_name,
1007: MESSAGE =>'292:before status check po id -update allowed '||p_header_id||x_update_allowed);
1008: END IF;
1009: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1009: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1005: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1006: MODULE =>g_module_prefix||l_api_name,
1007: MESSAGE =>'292:before status check po id -update allowed '||p_header_id||x_update_allowed);
1008: END IF;
1009: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1010: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1011: MODULE =>g_module_prefix||l_api_name,
1012: MESSAGE =>'295:before status check lock '||p_lock_flag);
1013: END IF;

Line 1010: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1006: MODULE =>g_module_prefix||l_api_name,
1007: MESSAGE =>'292:before status check po id -update allowed '||p_header_id||x_update_allowed);
1008: END IF;
1009: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1010: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1011: MODULE =>g_module_prefix||l_api_name,
1012: MESSAGE =>'295:before status check lock '||p_lock_flag);
1013: END IF;
1014: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1014: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1010: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1011: MODULE =>g_module_prefix||l_api_name,
1012: MESSAGE =>'295:before status check lock '||p_lock_flag);
1013: END IF;
1014: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1015: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1016: MODULE =>g_module_prefix||l_api_name,
1017: MESSAGE =>'297:before status check doc type '||l_document_type);
1018: END IF;

Line 1015: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1011: MODULE =>g_module_prefix||l_api_name,
1012: MESSAGE =>'295:before status check lock '||p_lock_flag);
1013: END IF;
1014: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1015: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1016: MODULE =>g_module_prefix||l_api_name,
1017: MESSAGE =>'297:before status check doc type '||l_document_type);
1018: END IF;
1019: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1019: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1015: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1016: MODULE =>g_module_prefix||l_api_name,
1017: MESSAGE =>'297:before status check doc type '||l_document_type);
1018: END IF;
1019: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1020: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1021: MODULE =>g_module_prefix||l_api_name,
1022: MESSAGE =>'299:Before Call to PO_DOCUMENT_CHECKS_GRP.PO_STATUS_CHECK');
1023: END IF;

Line 1020: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1016: MODULE =>g_module_prefix||l_api_name,
1017: MESSAGE =>'297:before status check doc type '||l_document_type);
1018: END IF;
1019: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1020: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1021: MODULE =>g_module_prefix||l_api_name,
1022: MESSAGE =>'299:Before Call to PO_DOCUMENT_CHECKS_GRP.PO_STATUS_CHECK');
1023: END IF;
1024: END IF;

Line 1036: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1032: x_po_status_rec => l_po_status_rec,
1033: x_return_status => x_return_status
1034: );
1035: IF g_fnd_debug = 'Y' then
1036: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1037: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1038: MODULE =>g_module_prefix||l_api_name,
1039: MESSAGE =>'295:After Call to PO_DOCUMENT_CHECKS_GRP.PO_STATUS_CHECK. Return status '||x_return_status);
1040: END IF;

Line 1037: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1033: x_return_status => x_return_status
1034: );
1035: IF g_fnd_debug = 'Y' then
1036: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1037: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1038: MODULE =>g_module_prefix||l_api_name,
1039: MESSAGE =>'295:After Call to PO_DOCUMENT_CHECKS_GRP.PO_STATUS_CHECK. Return status '||x_return_status);
1040: END IF;
1041: END IF;

Line 1070: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1066: END IF; -- if po_status and revision same
1067: /* TODO Status check and Security check for mod*/
1068: END IF; -- (l_is_mod = 'N') then -- CLM Mod
1069: IF g_fnd_debug = 'Y' then
1070: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1071: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1072: MODULE =>g_module_prefix||l_api_name,
1073: MESSAGE =>'400:End '||l_api_name);
1074: END IF;

Line 1071: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1067: /* TODO Status check and Security check for mod*/
1068: END IF; -- (l_is_mod = 'N') then -- CLM Mod
1069: IF g_fnd_debug = 'Y' then
1070: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1071: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1072: MODULE =>g_module_prefix||l_api_name,
1073: MESSAGE =>'400:End '||l_api_name);
1074: END IF;
1075: END IF;

Line 1086: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1082: FND_MSG_PUB.Count_And_Get
1083: (p_count => x_msg_count,
1084: p_data => x_msg_data );
1085: IF g_fnd_debug = 'Y' then
1086: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1087: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1088: MODULE =>g_module_prefix||l_api_name,
1089: MESSAGE =>'500:Exception l_status_changed ');
1090: END IF;

Line 1087: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

1083: (p_count => x_msg_count,
1084: p_data => x_msg_data );
1085: IF g_fnd_debug = 'Y' then
1086: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1087: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1088: MODULE =>g_module_prefix||l_api_name,
1089: MESSAGE =>'500:Exception l_status_changed ');
1090: END IF;
1091: END IF;

Line 1103: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1099: FND_MSG_PUB.Count_And_Get
1100: (p_count => x_msg_count,
1101: p_data => x_msg_data );
1102: IF g_fnd_debug = 'Y' then
1103: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1104: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1105: MODULE =>g_module_prefix||l_api_name,
1106: MESSAGE =>'550:Exception l_donot_update ');
1107: END IF;

Line 1104: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

1100: (p_count => x_msg_count,
1101: p_data => x_msg_data );
1102: IF g_fnd_debug = 'Y' then
1103: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1104: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1105: MODULE =>g_module_prefix||l_api_name,
1106: MESSAGE =>'550:Exception l_donot_update ');
1107: END IF;
1108: END IF;

Line 1117: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1113: FND_MSG_PUB.Count_And_Get
1114: (p_count => x_msg_count,
1115: p_data => x_msg_data );
1116: IF g_fnd_debug = 'Y' then
1117: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1118: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1119: MODULE =>g_module_prefix||l_api_name,
1120: MESSAGE =>'600:Exception Expected error ');
1121: END IF;

Line 1118: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

1114: (p_count => x_msg_count,
1115: p_data => x_msg_data );
1116: IF g_fnd_debug = 'Y' then
1117: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1118: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1119: MODULE =>g_module_prefix||l_api_name,
1120: MESSAGE =>'600:Exception Expected error ');
1121: END IF;
1122: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

Line 1123: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1119: MODULE =>g_module_prefix||l_api_name,
1120: MESSAGE =>'600:Exception Expected error ');
1121: END IF;
1122: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1123: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1124: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1125: MODULE =>g_module_prefix||l_api_name,
1126: MESSAGE =>'600:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
1127: END IF;

Line 1124: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

1120: MESSAGE =>'600:Exception Expected error ');
1121: END IF;
1122: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1123: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1124: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1125: MODULE =>g_module_prefix||l_api_name,
1126: MESSAGE =>'600:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
1127: END IF;
1128: END LOOP;

Line 1138: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1134: FND_MSG_PUB.Count_And_Get
1135: (p_count => x_msg_count,
1136: p_data => x_msg_data );
1137: IF g_fnd_debug = 'Y' then
1138: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1139: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1140: MODULE =>g_module_prefix||l_api_name,
1141: MESSAGE =>'610:Exception UnExpected error ');
1142: END IF;

Line 1139: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

1135: (p_count => x_msg_count,
1136: p_data => x_msg_data );
1137: IF g_fnd_debug = 'Y' then
1138: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1139: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1140: MODULE =>g_module_prefix||l_api_name,
1141: MESSAGE =>'610:Exception UnExpected error ');
1142: END IF;
1143: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

Line 1144: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1140: MODULE =>g_module_prefix||l_api_name,
1141: MESSAGE =>'610:Exception UnExpected error ');
1142: END IF;
1143: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1144: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1145: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1146: MODULE =>g_module_prefix||l_api_name,
1147: MESSAGE =>'610:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
1148: END IF;

Line 1145: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

1141: MESSAGE =>'610:Exception UnExpected error ');
1142: END IF;
1143: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1144: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1145: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1146: MODULE =>g_module_prefix||l_api_name,
1147: MESSAGE =>'610:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
1148: END IF;
1149: END LOOP;

Line 1168: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1164: FND_MSG_PUB.Count_And_Get
1165: (p_count => x_msg_count,
1166: p_data => x_msg_data );
1167: IF g_fnd_debug = 'Y' then
1168: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1169: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1170: MODULE =>g_module_prefix||l_api_name,
1171: MESSAGE =>'650:Exception UnExpected error '||sqlcode||':'||sqlerrm);
1172: END IF;

Line 1169: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

1165: (p_count => x_msg_count,
1166: p_data => x_msg_data );
1167: IF g_fnd_debug = 'Y' then
1168: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1169: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1170: MODULE =>g_module_prefix||l_api_name,
1171: MESSAGE =>'650:Exception UnExpected error '||sqlcode||':'||sqlerrm);
1172: END IF;
1173: End if;

Line 1287: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1283: l_end NUMBER;
1284: l_is_mod VARCHAR2(1) := 'N'; -- CLM Mod
1285: BEGIN
1286: IF g_fnd_debug = 'Y' then
1287: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1288: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1289: MODULE =>g_module_prefix||l_api_name,
1290: MESSAGE =>'10: Start' ||l_api_name);
1291: END IF;

Line 1288: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1284: l_is_mod VARCHAR2(1) := 'N'; -- CLM Mod
1285: BEGIN
1286: IF g_fnd_debug = 'Y' then
1287: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1288: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1289: MODULE =>g_module_prefix||l_api_name,
1290: MESSAGE =>'10: Start' ||l_api_name);
1291: END IF;
1292: End if;

Line 1314: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1310: x_return_status := FND_API.G_RET_STS_SUCCESS;
1311: x_update_allowed := 'N';
1312:
1313: IF g_fnd_debug = 'Y' then
1314: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1315: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1316: MODULE =>g_module_prefix||l_api_name,
1317: MESSAGE =>'50: x_update_allowed' ||x_update_allowed);
1318: END IF;

Line 1315: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1311: x_update_allowed := 'N';
1312:
1313: IF g_fnd_debug = 'Y' then
1314: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1315: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1316: MODULE =>g_module_prefix||l_api_name,
1317: MESSAGE =>'50: x_update_allowed' ||x_update_allowed);
1318: END IF;
1319: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1319: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1315: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1316: MODULE =>g_module_prefix||l_api_name,
1317: MESSAGE =>'50: x_update_allowed' ||x_update_allowed);
1318: END IF;
1319: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1320: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1321: MODULE =>g_module_prefix||l_api_name,
1322: MESSAGE =>'70: p_template_changed' ||p_template_changed);
1323: END IF;

Line 1320: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1316: MODULE =>g_module_prefix||l_api_name,
1317: MESSAGE =>'50: x_update_allowed' ||x_update_allowed);
1318: END IF;
1319: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1320: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1321: MODULE =>g_module_prefix||l_api_name,
1322: MESSAGE =>'70: p_template_changed' ||p_template_changed);
1323: END IF;
1324: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1324: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1320: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1321: MODULE =>g_module_prefix||l_api_name,
1322: MESSAGE =>'70: p_template_changed' ||p_template_changed);
1323: END IF;
1324: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1325: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1326: MODULE =>g_module_prefix||l_api_name,
1327: MESSAGE =>'100: p_callout_string' ||p_callout_string);
1328: END IF;

Line 1325: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1321: MODULE =>g_module_prefix||l_api_name,
1322: MESSAGE =>'70: p_template_changed' ||p_template_changed);
1323: END IF;
1324: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1325: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1326: MODULE =>g_module_prefix||l_api_name,
1327: MESSAGE =>'100: p_callout_string' ||p_callout_string);
1328: END IF;
1329: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1329: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1325: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1326: MODULE =>g_module_prefix||l_api_name,
1327: MESSAGE =>'100: p_callout_string' ||p_callout_string);
1328: END IF;
1329: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1330: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1331: MODULE =>g_module_prefix||l_api_name,
1332: MESSAGE =>'120: p_header_id' ||p_header_id);
1333: END IF;

Line 1330: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1326: MODULE =>g_module_prefix||l_api_name,
1327: MESSAGE =>'100: p_callout_string' ||p_callout_string);
1328: END IF;
1329: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1330: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1331: MODULE =>g_module_prefix||l_api_name,
1332: MESSAGE =>'120: p_header_id' ||p_header_id);
1333: END IF;
1334:

Line 1365: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1361: RAISE FND_API.G_EXC_ERROR;
1362:
1363: END IF;-- p_callout _string
1364: IF g_fnd_debug = 'Y' then
1365: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1366: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1367: MODULE =>g_module_prefix||l_api_name,
1368: MESSAGE =>'150: po status should be Incomplete/rejected-'||l_callout_status);
1369: END IF;

Line 1366: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1362:
1363: END IF;-- p_callout _string
1364: IF g_fnd_debug = 'Y' then
1365: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1366: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1367: MODULE =>g_module_prefix||l_api_name,
1368: MESSAGE =>'150: po status should be Incomplete/rejected-'||l_callout_status);
1369: END IF;
1370: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1370: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1366: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1367: MODULE =>g_module_prefix||l_api_name,
1368: MESSAGE =>'150: po status should be Incomplete/rejected-'||l_callout_status);
1369: END IF;
1370: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1371: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1372: MODULE =>g_module_prefix||l_api_name,
1373: MESSAGE =>'155: po revision should be 0-'||l_callout_revision);
1374: END IF;

Line 1371: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1367: MODULE =>g_module_prefix||l_api_name,
1368: MESSAGE =>'150: po status should be Incomplete/rejected-'||l_callout_status);
1369: END IF;
1370: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1371: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1372: MODULE =>g_module_prefix||l_api_name,
1373: MESSAGE =>'155: po revision should be 0-'||l_callout_revision);
1374: END IF;
1375: End if;

Line 1438: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1434: /* TODO Status check and Security check for mod*/
1435: x_update_allowed := 'Y';
1436: END IF; -- l_is_mod = 'N' THEN -- CLM Mod
1437: IF g_fnd_debug = 'Y' then
1438: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1439: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1440: MODULE =>g_module_prefix||l_api_name,
1441: MESSAGE =>'200:update allowed after calling is_po_update_allowed'||x_update_allowed);
1442: END IF;

Line 1439: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1435: x_update_allowed := 'Y';
1436: END IF; -- l_is_mod = 'N' THEN -- CLM Mod
1437: IF g_fnd_debug = 'Y' then
1438: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1439: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1440: MODULE =>g_module_prefix||l_api_name,
1441: MESSAGE =>'200:update allowed after calling is_po_update_allowed'||x_update_allowed);
1442: END IF;
1443: End if;

Line 1458: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1454: If (p_template_changed = 'Y') then -- set flag to Y if template is added
1455: L_date := Sysdate;
1456: L_conterms_exist_flag := 'Y';
1457: IF g_fnd_debug = 'Y' then
1458: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1459: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1460: MODULE =>g_module_prefix||l_api_name,
1461: MESSAGE =>'250:Procurement Contract. id'||p_header_id);
1462: END IF;

Line 1459: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1455: L_date := Sysdate;
1456: L_conterms_exist_flag := 'Y';
1457: IF g_fnd_debug = 'Y' then
1458: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1459: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1460: MODULE =>g_module_prefix||l_api_name,
1461: MESSAGE =>'250:Procurement Contract. id'||p_header_id);
1462: END IF;
1463: End if;

Line 1468: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1464: ELSE -- if template is being deleted set dates to null, flag to N;
1465: L_date := null;
1466: L_conterms_exist_flag := 'N';
1467: IF g_fnd_debug = 'Y' then
1468: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1469: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1470: MODULE =>g_module_prefix||l_api_name,
1471: MESSAGE =>'270:No More Procurement Contract. id'||p_header_id);
1472: END IF;

Line 1469: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1465: L_date := null;
1466: L_conterms_exist_flag := 'N';
1467: IF g_fnd_debug = 'Y' then
1468: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1469: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1470: MODULE =>g_module_prefix||l_api_name,
1471: MESSAGE =>'270:No More Procurement Contract. id'||p_header_id);
1472: END IF;
1473: End if;

Line 1503: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1499: WHERE draft_id= p_header_id;
1500: END IF; --CLM Mod
1501:
1502: IF g_fnd_debug = 'Y' then
1503: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1504: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1505: MODULE =>g_module_prefix||l_api_name,
1506: MESSAGE =>'300:Po headers all updated for header id'||p_header_id);
1507: END IF;

Line 1504: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1500: END IF; --CLM Mod
1501:
1502: IF g_fnd_debug = 'Y' then
1503: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1504: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1505: MODULE =>g_module_prefix||l_api_name,
1506: MESSAGE =>'300:Po headers all updated for header id'||p_header_id);
1507: END IF;
1508: End if;

Line 1524: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1520:
1521: -- Commit the transaction if p_commit set true
1522: IF FND_API.TO_BOOLEAN(p_commit) then
1523: IF g_fnd_debug = 'Y' then
1524: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1525: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1526: MODULE =>g_module_prefix||l_api_name,
1527: MESSAGE =>'390: Commit set to true');
1528: END IF;

Line 1525: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1521: -- Commit the transaction if p_commit set true
1522: IF FND_API.TO_BOOLEAN(p_commit) then
1523: IF g_fnd_debug = 'Y' then
1524: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1525: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1526: MODULE =>g_module_prefix||l_api_name,
1527: MESSAGE =>'390: Commit set to true');
1528: END IF;
1529: End if;

Line 1533: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1529: End if;
1530: COMMIT;
1531: END IF;
1532: IF g_fnd_debug = 'Y' then
1533: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1534: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1535: MODULE =>g_module_prefix||l_api_name,
1536: MESSAGE =>'400: End' ||l_api_name);
1537: END IF;

Line 1534: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1530: COMMIT;
1531: END IF;
1532: IF g_fnd_debug = 'Y' then
1533: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1534: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1535: MODULE =>g_module_prefix||l_api_name,
1536: MESSAGE =>'400: End' ||l_api_name);
1537: END IF;
1538: End if;

Line 1550: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1546: FND_MSG_PUB.Count_And_Get
1547: (p_count => x_msg_count,
1548: p_data => x_msg_data );
1549: IF g_fnd_debug = 'Y' then
1550: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1551: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1552: MODULE =>g_module_prefix||l_api_name,
1553: MESSAGE =>'450:Exception l_update_not_allowed ');
1554: END IF;

Line 1551: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

1547: (p_count => x_msg_count,
1548: p_data => x_msg_data );
1549: IF g_fnd_debug = 'Y' then
1550: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1551: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1552: MODULE =>g_module_prefix||l_api_name,
1553: MESSAGE =>'450:Exception l_update_not_allowed ');
1554: END IF;
1555: END IF;

Line 1563: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1559: FND_MSG_PUB.Count_And_Get
1560: (p_count => x_msg_count,
1561: p_data => x_msg_data );
1562: IF g_fnd_debug = 'Y' then
1563: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1564: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1565: MODULE =>g_module_prefix||l_api_name,
1566: MESSAGE =>'470: expected error ');
1567: END IF;

Line 1564: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

1560: (p_count => x_msg_count,
1561: p_data => x_msg_data );
1562: IF g_fnd_debug = 'Y' then
1563: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1564: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1565: MODULE =>g_module_prefix||l_api_name,
1566: MESSAGE =>'470: expected error ');
1567: END IF;
1568: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

Line 1569: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1565: MODULE =>g_module_prefix||l_api_name,
1566: MESSAGE =>'470: expected error ');
1567: END IF;
1568: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1569: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1570: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1571: MODULE =>g_module_prefix||l_api_name,
1572: MESSAGE =>'470:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
1573: END IF;

Line 1570: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

1566: MESSAGE =>'470: expected error ');
1567: END IF;
1568: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1569: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1570: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1571: MODULE =>g_module_prefix||l_api_name,
1572: MESSAGE =>'470:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
1573: END IF;
1574: END LOOP;

Line 1583: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1579: FND_MSG_PUB.Count_And_Get
1580: (p_count => x_msg_count,
1581: p_data => x_msg_data );
1582: IF g_fnd_debug = 'Y' then
1583: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1584: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1585: MODULE =>g_module_prefix||l_api_name,
1586: MESSAGE =>'480:Exception UnExpected error ');
1587: END IF;

Line 1584: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

1580: (p_count => x_msg_count,
1581: p_data => x_msg_data );
1582: IF g_fnd_debug = 'Y' then
1583: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1584: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1585: MODULE =>g_module_prefix||l_api_name,
1586: MESSAGE =>'480:Exception UnExpected error ');
1587: END IF;
1588: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

Line 1589: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1585: MODULE =>g_module_prefix||l_api_name,
1586: MESSAGE =>'480:Exception UnExpected error ');
1587: END IF;
1588: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1589: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1590: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1591: MODULE =>g_module_prefix||l_api_name,
1592: MESSAGE =>'480:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
1593: END IF;

Line 1590: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

1586: MESSAGE =>'480:Exception UnExpected error ');
1587: END IF;
1588: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1589: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1590: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1591: MODULE =>g_module_prefix||l_api_name,
1592: MESSAGE =>'480:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
1593: END IF;
1594: END LOOP;

Line 1612: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1608: FND_MSG_PUB.Count_And_Get
1609: (p_count => x_msg_count,
1610: p_data => x_msg_data );
1611: IF g_fnd_debug = 'Y' then
1612: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1613: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1614: MODULE =>g_module_prefix||l_api_name,
1615: MESSAGE =>'500:Exception UnExpected error '||sqlcode||':'||sqlerrm);
1616: END IF;

Line 1613: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

1609: (p_count => x_msg_count,
1610: p_data => x_msg_data );
1611: IF g_fnd_debug = 'Y' then
1612: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1613: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1614: MODULE =>g_module_prefix||l_api_name,
1615: MESSAGE =>'500:Exception UnExpected error '||sqlcode||':'||sqlerrm);
1616: END IF;
1617: END IF;

Line 1692: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1688: l_archived_spo_amt NUMBER;
1689: l_is_mod VARCHAR2(1) := 'N'; -- CLM Mod
1690: BEGIN
1691: IF g_fnd_debug = 'Y' then
1692: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1693: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1694: MODULE =>g_module_prefix||l_api_name,
1695: MESSAGE =>'10: Start API' ||l_api_name);
1696: END IF;

Line 1693: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1689: l_is_mod VARCHAR2(1) := 'N'; -- CLM Mod
1690: BEGIN
1691: IF g_fnd_debug = 'Y' then
1692: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1693: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1694: MODULE =>g_module_prefix||l_api_name,
1695: MESSAGE =>'10: Start API' ||l_api_name);
1696: END IF;
1697: END IF;

Line 1811: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1807: AND poh.po_header_id = poha.po_header_id
1808: AND poha.latest_external_flag = 'Y';
1809:
1810: IF g_fnd_debug = 'Y' then
1811: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1812: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1813: MODULE =>g_module_prefix||l_api_name,
1814: MESSAGE =>'120: selected columns with changed values');
1815: END IF;

Line 1812: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1808: AND poha.latest_external_flag = 'Y';
1809:
1810: IF g_fnd_debug = 'Y' then
1811: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1812: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1813: MODULE =>g_module_prefix||l_api_name,
1814: MESSAGE =>'120: selected columns with changed values');
1815: END IF;
1816: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1816: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1812: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1813: MODULE =>g_module_prefix||l_api_name,
1814: MESSAGE =>'120: selected columns with changed values');
1815: END IF;
1816: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1817: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1818: MODULE =>g_module_prefix||l_api_name,
1819: MESSAGE =>'130: document type '||l_type_lookup_code);
1820: END IF;

Line 1817: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1813: MODULE =>g_module_prefix||l_api_name,
1814: MESSAGE =>'120: selected columns with changed values');
1815: END IF;
1816: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1817: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1818: MODULE =>g_module_prefix||l_api_name,
1819: MESSAGE =>'130: document type '||l_type_lookup_code);
1820: END IF;
1821:

Line 1845: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1841: END IF; -- l_spo_amt <> l_archived_spo_amt
1842:
1843:
1844: IF g_fnd_debug = 'Y' then
1845: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1846: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1847: MODULE =>g_module_prefix||l_api_name,
1848: MESSAGE =>'150: Got header amount differnce');
1849: END IF;

Line 1846: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1842:
1843:
1844: IF g_fnd_debug = 'Y' then
1845: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1846: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1847: MODULE =>g_module_prefix||l_api_name,
1848: MESSAGE =>'150: Got header amount differnce');
1849: END IF;
1850: END IF;

Line 1853: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1849: END IF;
1850: END IF;
1851: END IF;-- type_lookup_code='STANDARD'
1852: IF g_fnd_debug = 'Y' then
1853: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1854: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1855: MODULE =>g_module_prefix||l_api_name,
1856: MESSAGE =>'160: First p_sys_var'||p_sys_var_tbl.FIRST);
1857: END IF;

Line 1854: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1850: END IF;
1851: END IF;-- type_lookup_code='STANDARD'
1852: IF g_fnd_debug = 'Y' then
1853: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1854: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1855: MODULE =>g_module_prefix||l_api_name,
1856: MESSAGE =>'160: First p_sys_var'||p_sys_var_tbl.FIRST);
1857: END IF;
1858: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1858: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1854: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1855: MODULE =>g_module_prefix||l_api_name,
1856: MESSAGE =>'160: First p_sys_var'||p_sys_var_tbl.FIRST);
1857: END IF;
1858: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1859: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1860: MODULE =>g_module_prefix||l_api_name,
1861: MESSAGE =>'165: Last p_sys_var'||p_sys_var_tbl.LAST);
1862: END IF;

Line 1859: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1855: MODULE =>g_module_prefix||l_api_name,
1856: MESSAGE =>'160: First p_sys_var'||p_sys_var_tbl.FIRST);
1857: END IF;
1858: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1859: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1860: MODULE =>g_module_prefix||l_api_name,
1861: MESSAGE =>'165: Last p_sys_var'||p_sys_var_tbl.LAST);
1862: END IF;
1863: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1863: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1859: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1860: MODULE =>g_module_prefix||l_api_name,
1861: MESSAGE =>'165: Last p_sys_var'||p_sys_var_tbl.LAST);
1862: END IF;
1863: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1864: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1865: MODULE =>g_module_prefix||l_api_name,
1866: MESSAGE =>'170: first l_po_var'||p_sys_var_tbl.FIRST);
1867: END IF;

Line 1864: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1860: MODULE =>g_module_prefix||l_api_name,
1861: MESSAGE =>'165: Last p_sys_var'||p_sys_var_tbl.LAST);
1862: END IF;
1863: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1864: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1865: MODULE =>g_module_prefix||l_api_name,
1866: MESSAGE =>'170: first l_po_var'||p_sys_var_tbl.FIRST);
1867: END IF;
1868: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1868: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1864: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1865: MODULE =>g_module_prefix||l_api_name,
1866: MESSAGE =>'170: first l_po_var'||p_sys_var_tbl.FIRST);
1867: END IF;
1868: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1869: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1870: MODULE =>g_module_prefix||l_api_name,
1871: MESSAGE =>'175: last l_po_var'||p_sys_var_tbl.LAST);
1872: END IF;

Line 1869: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1865: MODULE =>g_module_prefix||l_api_name,
1866: MESSAGE =>'170: first l_po_var'||p_sys_var_tbl.FIRST);
1867: END IF;
1868: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1869: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1870: MODULE =>g_module_prefix||l_api_name,
1871: MESSAGE =>'175: last l_po_var'||p_sys_var_tbl.LAST);
1872: END IF;
1873: END IF;

Line 1883: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1879: l_sys_var_index := p_sys_var_tbl.FIRST;
1880: While l_sys_var_index <= p_sys_var_tbl.last
1881: LOOP
1882: IF g_fnd_debug = 'Y' then
1883: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1884: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1885: MODULE =>g_module_prefix||l_api_name,
1886: MESSAGE =>'180: current p_sys_var index'||l_sys_var_index);
1887: END IF;

Line 1884: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1880: While l_sys_var_index <= p_sys_var_tbl.last
1881: LOOP
1882: IF g_fnd_debug = 'Y' then
1883: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1884: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1885: MODULE =>g_module_prefix||l_api_name,
1886: MESSAGE =>'180: current p_sys_var index'||l_sys_var_index);
1887: END IF;
1888: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1888: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1884: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1885: MODULE =>g_module_prefix||l_api_name,
1886: MESSAGE =>'180: current p_sys_var index'||l_sys_var_index);
1887: END IF;
1888: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1889: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1890: MODULE =>g_module_prefix||l_api_name,
1891: MESSAGE =>'185: current p_sys_var value'||p_sys_var_tbl(l_sys_var_index));
1892: END IF;

Line 1889: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1885: MODULE =>g_module_prefix||l_api_name,
1886: MESSAGE =>'180: current p_sys_var index'||l_sys_var_index);
1887: END IF;
1888: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1889: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1890: MODULE =>g_module_prefix||l_api_name,
1891: MESSAGE =>'185: current p_sys_var value'||p_sys_var_tbl(l_sys_var_index));
1892: END IF;
1893: END IF;

Line 1899: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1895: l_po_attribute_index := l_po_attrib_tbl.FIRST;
1896: While l_po_attribute_index <= l_po_attrib_tbl.LAST
1897: LOOP
1898: IF g_fnd_debug = 'Y' then
1899: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1900: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1901: MODULE =>g_module_prefix||l_api_name,
1902: MESSAGE =>'190: current l_po_var index'||l_po_attribute_index);
1903: END IF;

Line 1900: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1896: While l_po_attribute_index <= l_po_attrib_tbl.LAST
1897: LOOP
1898: IF g_fnd_debug = 'Y' then
1899: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1900: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1901: MODULE =>g_module_prefix||l_api_name,
1902: MESSAGE =>'190: current l_po_var index'||l_po_attribute_index);
1903: END IF;
1904: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1904: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1900: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1901: MODULE =>g_module_prefix||l_api_name,
1902: MESSAGE =>'190: current l_po_var index'||l_po_attribute_index);
1903: END IF;
1904: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1905: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1906: MODULE =>g_module_prefix||l_api_name,
1907: MESSAGE =>'200: current l_po_var value'||l_po_attrib_tbl(l_po_attribute_index));
1908: END IF;

Line 1905: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1901: MODULE =>g_module_prefix||l_api_name,
1902: MESSAGE =>'190: current l_po_var index'||l_po_attribute_index);
1903: END IF;
1904: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1905: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1906: MODULE =>g_module_prefix||l_api_name,
1907: MESSAGE =>'200: current l_po_var value'||l_po_attrib_tbl(l_po_attribute_index));
1908: END IF;
1909:

Line 1913: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1909:
1910: END IF;
1911: IF l_po_attrib_tbl(l_po_attribute_index)= 'N' then
1912: IF g_fnd_debug = 'Y' then
1913: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1914: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1915: MODULE =>g_module_prefix||l_api_name,
1916: MESSAGE =>'210: Delete l_po_var'||l_po_attrib_tbl(l_po_attribute_index));
1917: END IF;

Line 1914: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1910: END IF;
1911: IF l_po_attrib_tbl(l_po_attribute_index)= 'N' then
1912: IF g_fnd_debug = 'Y' then
1913: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1914: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1915: MODULE =>g_module_prefix||l_api_name,
1916: MESSAGE =>'210: Delete l_po_var'||l_po_attrib_tbl(l_po_attribute_index));
1917: END IF;
1918: END IF;

Line 1921: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1917: END IF;
1918: END IF;
1919: l_po_attrib_tbl.DELETE(l_po_attribute_index);
1920: IF g_fnd_debug = 'Y' then
1921: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1922: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1923: MODULE =>g_module_prefix||l_api_name,
1924: MESSAGE =>'215: Deleted');
1925: END IF;

Line 1922: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1918: END IF;
1919: l_po_attrib_tbl.DELETE(l_po_attribute_index);
1920: IF g_fnd_debug = 'Y' then
1921: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1922: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1923: MODULE =>g_module_prefix||l_api_name,
1924: MESSAGE =>'215: Deleted');
1925: END IF;
1926: END IF;

Line 1936: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1932: l_po_attribute_index := l_po_attrib_tbl.next(l_po_attribute_index);
1933: END LOOP;-- l_po_attribute_index inner loop
1934: If NOT l_found then
1935: IF g_fnd_debug = 'Y' then
1936: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1937: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1938: MODULE =>g_module_prefix||l_api_name,
1939: MESSAGE =>'220: Delete p_sys_var'||p_sys_var_tbl(l_sys_var_index));
1940: END IF;

Line 1937: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1933: END LOOP;-- l_po_attribute_index inner loop
1934: If NOT l_found then
1935: IF g_fnd_debug = 'Y' then
1936: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1937: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1938: MODULE =>g_module_prefix||l_api_name,
1939: MESSAGE =>'220: Delete p_sys_var'||p_sys_var_tbl(l_sys_var_index));
1940: END IF;
1941: END IF;

Line 1944: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1940: END IF;
1941: END IF;
1942: p_sys_var_tbl.delete(l_sys_var_index);
1943: IF g_fnd_debug = 'Y' then
1944: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1945: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1946: MODULE =>g_module_prefix||l_api_name,
1947: MESSAGE =>'225: Deleted');
1948: END IF;

Line 1945: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1941: END IF;
1942: p_sys_var_tbl.delete(l_sys_var_index);
1943: IF g_fnd_debug = 'Y' then
1944: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1945: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1946: MODULE =>g_module_prefix||l_api_name,
1947: MESSAGE =>'225: Deleted');
1948: END IF;
1949: END IF;

Line 1955: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1951: l_sys_var_index := p_sys_var_tbl.next(l_sys_var_index);
1952:
1953: END LOOP;-- l_sys_var_index outer loop
1954: IF g_fnd_debug = 'Y' then
1955: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1956: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1957: MODULE =>g_module_prefix||l_api_name,
1958: MESSAGE =>'230: Filtering ended. element in p_sys_var'||p_sys_var_tbl.count);
1959: END IF;

Line 1956: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1952:
1953: END LOOP;-- l_sys_var_index outer loop
1954: IF g_fnd_debug = 'Y' then
1955: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1956: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1957: MODULE =>g_module_prefix||l_api_name,
1958: MESSAGE =>'230: Filtering ended. element in p_sys_var'||p_sys_var_tbl.count);
1959: END IF;
1960:

Line 1964: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1960:
1961: l_sys_var_index := p_sys_var_tbl.FIRST;
1962: While l_sys_var_index <= p_sys_var_tbl.last
1963: LOOP
1964: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1965: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1966: MODULE =>g_module_prefix||l_api_name,
1967: MESSAGE =>'240: current index' ||l_sys_var_index);
1968: END IF;

Line 1965: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1961: l_sys_var_index := p_sys_var_tbl.FIRST;
1962: While l_sys_var_index <= p_sys_var_tbl.last
1963: LOOP
1964: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1965: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1966: MODULE =>g_module_prefix||l_api_name,
1967: MESSAGE =>'240: current index' ||l_sys_var_index);
1968: END IF;
1969: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1969: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1965: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1966: MODULE =>g_module_prefix||l_api_name,
1967: MESSAGE =>'240: current index' ||l_sys_var_index);
1968: END IF;
1969: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1970: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1971: MODULE =>g_module_prefix||l_api_name,
1972: MESSAGE =>'250: column being sent'||p_sys_var_tbl(l_sys_var_index));
1973: END IF;

Line 1970: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1966: MODULE =>g_module_prefix||l_api_name,
1967: MESSAGE =>'240: current index' ||l_sys_var_index);
1968: END IF;
1969: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1970: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1971: MODULE =>g_module_prefix||l_api_name,
1972: MESSAGE =>'250: column being sent'||p_sys_var_tbl(l_sys_var_index));
1973: END IF;
1974:

Line 1977: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1973: END IF;
1974:
1975: l_sys_var_index := p_sys_var_tbl.next(l_sys_var_index);
1976: END LOOP;
1977: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1978: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1979: MODULE =>g_module_prefix||l_api_name,
1980: MESSAGE =>'500: End API ' ||l_api_name);
1981: END IF;

Line 1978: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1974:
1975: l_sys_var_index := p_sys_var_tbl.next(l_sys_var_index);
1976: END LOOP;
1977: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1978: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1979: MODULE =>g_module_prefix||l_api_name,
1980: MESSAGE =>'500: End API ' ||l_api_name);
1981: END IF;
1982: END IF; -- if fnd debug

Line 1991: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1987: FND_MSG_PUB.Count_And_Get
1988: (p_count => x_msg_count,
1989: p_data => x_msg_data );
1990: IF g_fnd_debug = 'Y' then
1991: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1992: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1993: MODULE =>g_module_prefix||l_api_name,
1994: MESSAGE =>'600:Exception Expected error ');
1995: END IF;

Line 1992: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

1988: (p_count => x_msg_count,
1989: p_data => x_msg_data );
1990: IF g_fnd_debug = 'Y' then
1991: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1992: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1993: MODULE =>g_module_prefix||l_api_name,
1994: MESSAGE =>'600:Exception Expected error ');
1995: END IF;
1996: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

Line 1997: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1993: MODULE =>g_module_prefix||l_api_name,
1994: MESSAGE =>'600:Exception Expected error ');
1995: END IF;
1996: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1997: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1998: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1999: MODULE =>g_module_prefix||l_api_name,
2000: MESSAGE =>'600:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
2001: END IF;

Line 1998: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

1994: MESSAGE =>'600:Exception Expected error ');
1995: END IF;
1996: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1997: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1998: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1999: MODULE =>g_module_prefix||l_api_name,
2000: MESSAGE =>'600:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
2001: END IF;
2002: END LOOP;

Line 2011: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2007: FND_MSG_PUB.Count_And_Get
2008: (p_count => x_msg_count,
2009: p_data => x_msg_data );
2010: IF g_fnd_debug = 'Y' then
2011: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2012: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2013: MODULE =>g_module_prefix||l_api_name,
2014: MESSAGE =>'610:Exception UnExpected error ');
2015: END IF;

Line 2012: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

2008: (p_count => x_msg_count,
2009: p_data => x_msg_data );
2010: IF g_fnd_debug = 'Y' then
2011: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2012: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2013: MODULE =>g_module_prefix||l_api_name,
2014: MESSAGE =>'610:Exception UnExpected error ');
2015: END IF;
2016: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

Line 2017: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2013: MODULE =>g_module_prefix||l_api_name,
2014: MESSAGE =>'610:Exception UnExpected error ');
2015: END IF;
2016: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
2017: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2018: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2019: MODULE =>g_module_prefix||l_api_name,
2020: MESSAGE =>'610:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
2021: END IF;

Line 2018: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

2014: MESSAGE =>'610:Exception UnExpected error ');
2015: END IF;
2016: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
2017: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2018: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2019: MODULE =>g_module_prefix||l_api_name,
2020: MESSAGE =>'610:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
2021: END IF;
2022: END LOOP;

Line 2039: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2035: FND_MSG_PUB.Count_And_Get
2036: (p_count => x_msg_count,
2037: p_data => x_msg_data );
2038: IF g_fnd_debug = 'Y' then
2039: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2040: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2041: MODULE =>g_module_prefix||l_api_name,
2042: MESSAGE =>'700:Exception UnExpected error '||sqlcode||':'||sqlerrm);
2043: END IF;

Line 2040: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

2036: (p_count => x_msg_count,
2037: p_data => x_msg_data );
2038: IF g_fnd_debug = 'Y' then
2039: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2040: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2041: MODULE =>g_module_prefix||l_api_name,
2042: MESSAGE =>'700:Exception UnExpected error '||sqlcode||':'||sqlerrm);
2043: END IF;
2044: END IF;

Line 2144: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2140: l_dummy_value VARCHAR2(10) := 'NOT_NULL';
2141: l_is_mod VARCHAR2(1) := 'N'; -- CLM Mod
2142: BEGIN
2143: IF g_fnd_debug = 'Y' then
2144: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2145: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2146: MODULE =>g_module_prefix||l_api_name,
2147: MESSAGE =>'10: Start API' ||l_api_name);
2148: END IF;

Line 2145: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

2141: l_is_mod VARCHAR2(1) := 'N'; -- CLM Mod
2142: BEGIN
2143: IF g_fnd_debug = 'Y' then
2144: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2145: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2146: MODULE =>g_module_prefix||l_api_name,
2147: MESSAGE =>'10: Start API' ||l_api_name);
2148: END IF;
2149: END IF;

Line 2686: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2682: END IF;
2683: --Bug#3809298.End of bug.
2684:
2685: IF g_fnd_debug = 'Y' then
2686: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2687: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2688: MODULE =>g_module_prefix||l_api_name,
2689: MESSAGE =>'50: First p_sys_var'||p_sys_var_value_tbl.FIRST);
2690: END IF;

Line 2687: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

2683: --Bug#3809298.End of bug.
2684:
2685: IF g_fnd_debug = 'Y' then
2686: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2687: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2688: MODULE =>g_module_prefix||l_api_name,
2689: MESSAGE =>'50: First p_sys_var'||p_sys_var_value_tbl.FIRST);
2690: END IF;
2691: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 2691: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2687: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2688: MODULE =>g_module_prefix||l_api_name,
2689: MESSAGE =>'50: First p_sys_var'||p_sys_var_value_tbl.FIRST);
2690: END IF;
2691: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2692: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2693: MODULE =>g_module_prefix||l_api_name,
2694: MESSAGE =>'60: Last p_sys_var'||p_sys_var_value_tbl.LAST);
2695: END IF;

Line 2692: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

2688: MODULE =>g_module_prefix||l_api_name,
2689: MESSAGE =>'50: First p_sys_var'||p_sys_var_value_tbl.FIRST);
2690: END IF;
2691: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2692: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2693: MODULE =>g_module_prefix||l_api_name,
2694: MESSAGE =>'60: Last p_sys_var'||p_sys_var_value_tbl.LAST);
2695: END IF;
2696: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 2696: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2692: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2693: MODULE =>g_module_prefix||l_api_name,
2694: MESSAGE =>'60: Last p_sys_var'||p_sys_var_value_tbl.LAST);
2695: END IF;
2696: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2697: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2698: MODULE =>g_module_prefix||l_api_name,
2699: MESSAGE =>'70: first l_po_var'||p_sys_var_value_tbl.FIRST);
2700: END IF;

Line 2697: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

2693: MODULE =>g_module_prefix||l_api_name,
2694: MESSAGE =>'60: Last p_sys_var'||p_sys_var_value_tbl.LAST);
2695: END IF;
2696: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2697: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2698: MODULE =>g_module_prefix||l_api_name,
2699: MESSAGE =>'70: first l_po_var'||p_sys_var_value_tbl.FIRST);
2700: END IF;
2701: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 2701: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2697: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2698: MODULE =>g_module_prefix||l_api_name,
2699: MESSAGE =>'70: first l_po_var'||p_sys_var_value_tbl.FIRST);
2700: END IF;
2701: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2702: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2703: MODULE =>g_module_prefix||l_api_name,
2704: MESSAGE =>'80: last l_po_var'||p_sys_var_value_tbl.LAST);
2705: END IF;

Line 2702: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

2698: MODULE =>g_module_prefix||l_api_name,
2699: MESSAGE =>'70: first l_po_var'||p_sys_var_value_tbl.FIRST);
2700: END IF;
2701: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2702: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2703: MODULE =>g_module_prefix||l_api_name,
2704: MESSAGE =>'80: last l_po_var'||p_sys_var_value_tbl.LAST);
2705: END IF;
2706: END IF;

Line 2712: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2708: l_sys_var_index := p_sys_var_value_tbl.FIRST;
2709: While l_sys_var_index <= p_sys_var_value_tbl.last
2710: LOOP
2711: IF g_fnd_debug = 'Y' then
2712: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2713: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2714: MODULE =>g_module_prefix||l_api_name,
2715: MESSAGE =>'100: current p_sys_var index'||l_sys_var_index);
2716: END IF;

Line 2713: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

2709: While l_sys_var_index <= p_sys_var_value_tbl.last
2710: LOOP
2711: IF g_fnd_debug = 'Y' then
2712: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2713: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2714: MODULE =>g_module_prefix||l_api_name,
2715: MESSAGE =>'100: current p_sys_var index'||l_sys_var_index);
2716: END IF;
2717: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 2717: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2713: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2714: MODULE =>g_module_prefix||l_api_name,
2715: MESSAGE =>'100: current p_sys_var index'||l_sys_var_index);
2716: END IF;
2717: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2718: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2719: MODULE =>g_module_prefix||l_api_name,
2720: MESSAGE =>'110: current p_sys_var value code'
2721: ||p_sys_var_value_tbl(l_sys_var_index).variable_code);

Line 2718: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

2714: MODULE =>g_module_prefix||l_api_name,
2715: MESSAGE =>'100: current p_sys_var index'||l_sys_var_index);
2716: END IF;
2717: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2718: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2719: MODULE =>g_module_prefix||l_api_name,
2720: MESSAGE =>'110: current p_sys_var value code'
2721: ||p_sys_var_value_tbl(l_sys_var_index).variable_code);
2722: END IF;

Line 2729: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2725: l_po_attribute_index := l_po_attrib_tbl.FIRST;
2726: While l_po_attribute_index <= l_po_attrib_tbl.LAST
2727: LOOP
2728: IF g_fnd_debug = 'Y' then
2729: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2730: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2731: MODULE =>g_module_prefix||l_api_name,
2732: MESSAGE =>'160: current l_po_var index'||l_po_attribute_index);
2733: END IF;

Line 2730: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

2726: While l_po_attribute_index <= l_po_attrib_tbl.LAST
2727: LOOP
2728: IF g_fnd_debug = 'Y' then
2729: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2730: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2731: MODULE =>g_module_prefix||l_api_name,
2732: MESSAGE =>'160: current l_po_var index'||l_po_attribute_index);
2733: END IF;
2734: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 2734: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2730: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2731: MODULE =>g_module_prefix||l_api_name,
2732: MESSAGE =>'160: current l_po_var index'||l_po_attribute_index);
2733: END IF;
2734: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2735: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2736: MODULE =>g_module_prefix||l_api_name,
2737: MESSAGE =>'165: next l_po_var value'||l_po_attrib_tbl.next(l_po_attribute_index));
2738: END IF;

Line 2735: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

2731: MODULE =>g_module_prefix||l_api_name,
2732: MESSAGE =>'160: current l_po_var index'||l_po_attribute_index);
2733: END IF;
2734: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2735: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2736: MODULE =>g_module_prefix||l_api_name,
2737: MESSAGE =>'165: next l_po_var value'||l_po_attrib_tbl.next(l_po_attribute_index));
2738: END IF;
2739: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 2739: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2735: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2736: MODULE =>g_module_prefix||l_api_name,
2737: MESSAGE =>'165: next l_po_var value'||l_po_attrib_tbl.next(l_po_attribute_index));
2738: END IF;
2739: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2740: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2741: MODULE =>g_module_prefix||l_api_name,
2742: MESSAGE =>'165: current l_po_var value'||l_po_attrib_tbl(l_po_attribute_index).variable_code);
2743: END IF;

Line 2740: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

2736: MODULE =>g_module_prefix||l_api_name,
2737: MESSAGE =>'165: next l_po_var value'||l_po_attrib_tbl.next(l_po_attribute_index));
2738: END IF;
2739: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2740: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2741: MODULE =>g_module_prefix||l_api_name,
2742: MESSAGE =>'165: current l_po_var value'||l_po_attrib_tbl(l_po_attribute_index).variable_code);
2743: END IF;
2744: END IF;

Line 2749: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2745:
2746: If l_po_attrib_tbl(l_po_attribute_index).variable_code =
2747: p_sys_var_value_tbl(l_sys_var_index).variable_code then
2748: IF g_fnd_debug = 'Y' then
2749: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2750: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2751: MODULE =>g_module_prefix||l_api_name,
2752: MESSAGE =>'180: value found for'||l_po_attrib_tbl(l_po_attribute_index).variable_code);
2753: END IF;

Line 2750: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

2746: If l_po_attrib_tbl(l_po_attribute_index).variable_code =
2747: p_sys_var_value_tbl(l_sys_var_index).variable_code then
2748: IF g_fnd_debug = 'Y' then
2749: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2750: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2751: MODULE =>g_module_prefix||l_api_name,
2752: MESSAGE =>'180: value found for'||l_po_attrib_tbl(l_po_attribute_index).variable_code);
2753: END IF;
2754: END IF;

Line 2765: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2761: END LOOP;-- l_po_attribute_index inner loop
2762: If NOT l_found then
2763:
2764: IF g_fnd_debug = 'Y' then
2765: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2766: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2767: MODULE =>g_module_prefix||l_api_name,
2768: MESSAGE =>'190: Po does not have the variable code'||
2769: p_sys_var_value_tbl(l_sys_var_index).variable_code);

Line 2766: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

2762: If NOT l_found then
2763:
2764: IF g_fnd_debug = 'Y' then
2765: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2766: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2767: MODULE =>g_module_prefix||l_api_name,
2768: MESSAGE =>'190: Po does not have the variable code'||
2769: p_sys_var_value_tbl(l_sys_var_index).variable_code);
2770: END IF;

Line 2780: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2776: l_sys_var_index := p_sys_var_value_tbl.next(l_sys_var_index);
2777:
2778: END LOOP;-- l_sys_var_index outer loop
2779: IF g_fnd_debug = 'Y' then
2780: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2781: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2782: MODULE =>g_module_prefix||l_api_name,
2783: MESSAGE =>'220: Filtering ended. element in p_sys_var_value'||p_sys_var_value_tbl.count);
2784: END IF;

Line 2781: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

2777:
2778: END LOOP;-- l_sys_var_index outer loop
2779: IF g_fnd_debug = 'Y' then
2780: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2781: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2782: MODULE =>g_module_prefix||l_api_name,
2783: MESSAGE =>'220: Filtering ended. element in p_sys_var_value'||p_sys_var_value_tbl.count);
2784: END IF;
2785:

Line 2789: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2785:
2786: l_sys_var_index := p_sys_var_Value_tbl.FIRST;
2787: While l_sys_var_index <= p_sys_var_value_tbl.last
2788: LOOP
2789: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2790: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2791: MODULE =>g_module_prefix||l_api_name,
2792: MESSAGE =>'240: current index' ||l_sys_var_index);
2793: END IF;

Line 2790: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

2786: l_sys_var_index := p_sys_var_Value_tbl.FIRST;
2787: While l_sys_var_index <= p_sys_var_value_tbl.last
2788: LOOP
2789: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2790: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2791: MODULE =>g_module_prefix||l_api_name,
2792: MESSAGE =>'240: current index' ||l_sys_var_index);
2793: END IF;
2794: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 2794: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2790: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2791: MODULE =>g_module_prefix||l_api_name,
2792: MESSAGE =>'240: current index' ||l_sys_var_index);
2793: END IF;
2794: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2795: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2796: MODULE =>g_module_prefix||l_api_name,
2797: MESSAGE =>'250: column being sent'||p_sys_var_value_tbl(l_sys_var_index).variable_code);
2798: END IF;

Line 2795: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

2791: MODULE =>g_module_prefix||l_api_name,
2792: MESSAGE =>'240: current index' ||l_sys_var_index);
2793: END IF;
2794: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2795: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2796: MODULE =>g_module_prefix||l_api_name,
2797: MESSAGE =>'250: column being sent'||p_sys_var_value_tbl(l_sys_var_index).variable_code);
2798: END IF;
2799: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 2799: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2795: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2796: MODULE =>g_module_prefix||l_api_name,
2797: MESSAGE =>'250: column being sent'||p_sys_var_value_tbl(l_sys_var_index).variable_code);
2798: END IF;
2799: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2800: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2801: MODULE =>g_module_prefix||l_api_name,
2802: MESSAGE =>'270: value being sent'||p_sys_var_value_tbl(l_sys_var_index).variable_value_id);
2803: END IF;

Line 2800: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

2796: MODULE =>g_module_prefix||l_api_name,
2797: MESSAGE =>'250: column being sent'||p_sys_var_value_tbl(l_sys_var_index).variable_code);
2798: END IF;
2799: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2800: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2801: MODULE =>g_module_prefix||l_api_name,
2802: MESSAGE =>'270: value being sent'||p_sys_var_value_tbl(l_sys_var_index).variable_value_id);
2803: END IF;
2804: l_sys_var_index := p_sys_var_value_tbl.next(l_sys_var_index);

Line 2806: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

2802: MESSAGE =>'270: value being sent'||p_sys_var_value_tbl(l_sys_var_index).variable_value_id);
2803: END IF;
2804: l_sys_var_index := p_sys_var_value_tbl.next(l_sys_var_index);
2805: end loop;
2806: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2807: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2808: MODULE =>g_module_prefix||l_api_name,
2809: MESSAGE =>'300: End API ' ||l_api_name);
2810: END IF;

Line 2807: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

2803: END IF;
2804: l_sys_var_index := p_sys_var_value_tbl.next(l_sys_var_index);
2805: end loop;
2806: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
2807: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
2808: MODULE =>g_module_prefix||l_api_name,
2809: MESSAGE =>'300: End API ' ||l_api_name);
2810: END IF;
2811: END IF;-- if fnd debug

Line 2820: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2816: FND_MSG_PUB.Count_And_Get
2817: (p_count => x_msg_count,
2818: p_data => x_msg_data );
2819: IF g_fnd_debug = 'Y' then
2820: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2821: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2822: MODULE =>g_module_prefix||l_api_name,
2823: MESSAGE =>'400:Exception Expected error ');
2824: END IF;

Line 2821: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

2817: (p_count => x_msg_count,
2818: p_data => x_msg_data );
2819: IF g_fnd_debug = 'Y' then
2820: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2821: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2822: MODULE =>g_module_prefix||l_api_name,
2823: MESSAGE =>'400:Exception Expected error ');
2824: END IF;
2825: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

Line 2826: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2822: MODULE =>g_module_prefix||l_api_name,
2823: MESSAGE =>'400:Exception Expected error ');
2824: END IF;
2825: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
2826: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2827: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2828: MODULE =>g_module_prefix||l_api_name,
2829: MESSAGE =>'610:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
2830: END IF;

Line 2827: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

2823: MESSAGE =>'400:Exception Expected error ');
2824: END IF;
2825: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
2826: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2827: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2828: MODULE =>g_module_prefix||l_api_name,
2829: MESSAGE =>'610:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
2830: END IF;
2831: END LOOP;

Line 2839: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2835: FND_MSG_PUB.Count_And_Get
2836: (p_count => x_msg_count,
2837: p_data => x_msg_data );
2838: IF g_fnd_debug = 'Y' then
2839: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2840: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2841: MODULE =>g_module_prefix||l_api_name,
2842: MESSAGE =>'410:Exception Expected error ');
2843: END IF;

Line 2840: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

2836: (p_count => x_msg_count,
2837: p_data => x_msg_data );
2838: IF g_fnd_debug = 'Y' then
2839: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2840: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2841: MODULE =>g_module_prefix||l_api_name,
2842: MESSAGE =>'410:Exception Expected error ');
2843: END IF;
2844: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

Line 2845: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2841: MODULE =>g_module_prefix||l_api_name,
2842: MESSAGE =>'410:Exception Expected error ');
2843: END IF;
2844: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
2845: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2846: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2847: MODULE =>g_module_prefix||l_api_name,
2848: MESSAGE =>'410:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
2849: END IF;

Line 2846: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

2842: MESSAGE =>'410:Exception Expected error ');
2843: END IF;
2844: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
2845: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2846: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2847: MODULE =>g_module_prefix||l_api_name,
2848: MESSAGE =>'410:errors '||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
2849: END IF;
2850: END LOOP;

Line 2867: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

2863: FND_MSG_PUB.Count_And_Get
2864: (p_count => x_msg_count,
2865: p_data => x_msg_data );
2866: IF g_fnd_debug = 'Y' then
2867: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2868: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2869: MODULE =>g_module_prefix||l_api_name,
2870: MESSAGE =>'500:Exception UnExpected error '||sqlcode||':'||sqlerrm);
2871: END IF;

Line 2868: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

2864: (p_count => x_msg_count,
2865: p_data => x_msg_data );
2866: IF g_fnd_debug = 'Y' then
2867: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
2868: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
2869: MODULE =>g_module_prefix||l_api_name,
2870: MESSAGE =>'500:Exception UnExpected error '||sqlcode||':'||sqlerrm);
2871: END IF;
2872: END IF;

Line 3020: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

3016: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3017: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3018: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3019: IF (g_fnd_debug='Y') THEN
3020: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3021: FND_LOG.string(log_level => FND_LOG.level_unexpected
3022: ,module => g_module_prefix ||l_api_name
3023: ,message => SQLERRM);
3024: END IF;

Line 3021: FND_LOG.string(log_level => FND_LOG.level_unexpected

3017: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3018: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3019: IF (g_fnd_debug='Y') THEN
3020: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3021: FND_LOG.string(log_level => FND_LOG.level_unexpected
3022: ,module => g_module_prefix ||l_api_name
3023: ,message => SQLERRM);
3024: END IF;
3025: END IF;

Line 3106: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3102: g_auto_apply_template = 'N' THEN
3103:
3104: l_progress := 30;
3105: IF g_debug_stmt THEN
3106: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3107: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3108: || l_progress,'Auto Apply Template is off or contracts in not enabled');
3109: END IF;
3110: END IF;

Line 3107: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'

3103:
3104: l_progress := 30;
3105: IF g_debug_stmt THEN
3106: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3107: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3108: || l_progress,'Auto Apply Template is off or contracts in not enabled');
3109: END IF;
3110: END IF;
3111:

Line 3117: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3113: END IF;
3114:
3115: l_progress := 35;
3116: IF g_debug_stmt THEN
3117: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3118: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3119: || l_progress,'Derive parameters for OKC calls');
3120: END IF;
3121: END IF;

Line 3118: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'

3114:
3115: l_progress := 35;
3116: IF g_debug_stmt THEN
3117: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3118: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3119: || l_progress,'Derive parameters for OKC calls');
3120: END IF;
3121: END IF;
3122:

Line 3160: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3156: nvl(l_conterms_flag,'N') = 'Y' THEN
3157:
3158: l_progress := 40;
3159: IF g_debug_stmt THEN
3160: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3161: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3162: || l_progress,'not the compatible doc type');
3163: END IF;
3164: END IF;

Line 3161: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'

3157:
3158: l_progress := 40;
3159: IF g_debug_stmt THEN
3160: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3161: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3162: || l_progress,'not the compatible doc type');
3163: END IF;
3164: END IF;
3165:

Line 3182: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3178: IF p_template_id is null THEN
3179:
3180: l_progress := 50;
3181: IF g_debug_stmt THEN
3182: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3183: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3184: || l_progress,'Call OKC API to get default template');
3185: END IF;
3186: END IF;

Line 3183: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'

3179:
3180: l_progress := 50;
3181: IF g_debug_stmt THEN
3182: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3183: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3184: || l_progress,'Call OKC API to get default template');
3185: END IF;
3186: END IF;
3187:

Line 3202: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3198: x_template_name => l_template_name,
3199: x_template_description => l_template_desc);
3200:
3201: IF g_debug_stmt THEN
3202: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3203: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3204: || l_progress,'Return status from get default template:'||x_return_status );
3205: END IF;
3206: END IF;

Line 3203: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'

3199: x_template_description => l_template_desc);
3200:
3201: IF g_debug_stmt THEN
3202: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3203: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3204: || l_progress,'Return status from get default template:'||x_return_status );
3205: END IF;
3206: END IF;
3207:

Line 3215: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3211:
3212: ELSE
3213: l_progress := 60;
3214: IF g_debug_stmt THEN
3215: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3216: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3217: || l_progress,'Default template passed in from the client side');
3218: END IF;
3219: END IF;

Line 3216: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'

3212: ELSE
3213: l_progress := 60;
3214: IF g_debug_stmt THEN
3215: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3216: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3217: || l_progress,'Default template passed in from the client side');
3218: END IF;
3219: END IF;
3220:

Line 3228: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3224: IF l_template_id is not null THEN
3225:
3226: l_progress := 70;
3227: IF g_debug_stmt THEN
3228: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3229: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3230: || l_progress,'Call the OKC API to apply terms');
3231: END IF;
3232: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 3229: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'

3225:
3226: l_progress := 70;
3227: IF g_debug_stmt THEN
3228: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3229: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3230: || l_progress,'Call the OKC API to apply terms');
3231: END IF;
3232: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3233: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'

Line 3232: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3228: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3229: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3230: || l_progress,'Call the OKC API to apply terms');
3231: END IF;
3232: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3233: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3234: || l_progress ,'Template: ' || l_template_id);
3235: END IF;
3236: END IF;

Line 3233: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'

3229: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3230: || l_progress,'Call the OKC API to apply terms');
3231: END IF;
3232: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3233: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3234: || l_progress ,'Template: ' || l_template_id);
3235: END IF;
3236: END IF;
3237:

Line 3262: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3258: p_validation_string => l_status ||','||l_revision||','|| null
3259: );
3260:
3261: IF g_debug_stmt THEN
3262: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3263: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3264: || l_progress,'Return status from copy terms:'||x_return_status );
3265: END IF;
3266: END IF;

Line 3263: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'

3259: );
3260:
3261: IF g_debug_stmt THEN
3262: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3263: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3264: || l_progress,'Return status from copy terms:'||x_return_status );
3265: END IF;
3266: END IF;
3267: ELSE

Line 3289: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

3285: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3287: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3288: IF (g_fnd_debug='Y') THEN
3289: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3290: FND_LOG.string(log_level => FND_LOG.level_unexpected
3291: ,module => g_module_prefix ||l_api_name
3292: ,message => SQLERRM);
3293: END IF;

Line 3290: FND_LOG.string(log_level => FND_LOG.level_unexpected

3286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3287: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3288: IF (g_fnd_debug='Y') THEN
3289: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3290: FND_LOG.string(log_level => FND_LOG.level_unexpected
3291: ,module => g_module_prefix ||l_api_name
3292: ,message => SQLERRM);
3293: END IF;
3294: END IF;

Line 3383: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3379: END IF;
3380:
3381: l_progress := 35;
3382: IF g_debug_stmt THEN
3383: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3384: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3385: || l_progress,'Derive parameters for OKC calls');
3386: END IF;
3387: END IF;

Line 3384: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'

3380:
3381: l_progress := 35;
3382: IF g_debug_stmt THEN
3383: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3384: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3385: || l_progress,'Derive parameters for OKC calls');
3386: END IF;
3387: END IF;
3388:

Line 3430: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3426: (p_to_mod = 'Y' AND l_conterms_flag = 'N') THEN
3427:
3428: l_progress := 40;
3429: IF g_debug_stmt THEN
3430: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3431: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3432: || l_progress,'nothing to copy');
3433: END IF;
3434: END IF;

Line 3431: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'

3427:
3428: l_progress := 40;
3429: IF g_debug_stmt THEN
3430: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3431: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3432: || l_progress,'nothing to copy');
3433: END IF;
3434: END IF;
3435:

Line 3491: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3487: deliverables_exist := OKC_TERMS_UTIL_GRP.has_deliverables(l_k_doc_type_target, l_doc_target);
3488: IF terms_exist = 'Y' OR deliverables_exist = 'Y' then
3489: l_progress := 50;
3490: IF g_debug_stmt THEN
3491: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3492: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3493: || l_progress,'already copied');
3494: END IF;
3495: END IF;

Line 3492: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'

3488: IF terms_exist = 'Y' OR deliverables_exist = 'Y' then
3489: l_progress := 50;
3490: IF g_debug_stmt THEN
3491: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3492: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || '.'||l_api_name||'.'
3493: || l_progress,'already copied');
3494: END IF;
3495: END IF;
3496: return;

Line 3525: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

3521: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3522: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3523: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3524: IF (g_fnd_debug='Y') THEN
3525: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3526: FND_LOG.string(log_level => FND_LOG.level_unexpected
3527: ,module => g_module_prefix ||l_api_name
3528: ,message => SQLERRM);
3529: END IF;

Line 3526: FND_LOG.string(log_level => FND_LOG.level_unexpected

3522: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3523: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3524: IF (g_fnd_debug='Y') THEN
3525: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3526: FND_LOG.string(log_level => FND_LOG.level_unexpected
3527: ,module => g_module_prefix ||l_api_name
3528: ,message => SQLERRM);
3529: END IF;
3530: END IF;

Line 3606: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3602: l_progress := 30;
3603:
3604: IF g_debug_stmt
3605: THEN
3606: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3607: fnd_log.STRING (fnd_log.level_statement,
3608: g_log_head || '.' || l_api_name || '.' || l_progress,
3609: 'Auto Apply Template is off or contracts in not enabled'
3610: );

Line 3607: fnd_log.STRING (fnd_log.level_statement,

3603:
3604: IF g_debug_stmt
3605: THEN
3606: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3607: fnd_log.STRING (fnd_log.level_statement,
3608: g_log_head || '.' || l_api_name || '.' || l_progress,
3609: 'Auto Apply Template is off or contracts in not enabled'
3610: );
3611: END IF;

Line 3625: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3621: l_progress := 40;
3622:
3623: IF g_debug_stmt
3624: THEN
3625: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3626: fnd_log.STRING (fnd_log.level_statement,
3627: g_log_head || '.' || l_api_name || '.' || l_progress,
3628: 'not the compatible doc type'
3629: );

Line 3626: fnd_log.STRING (fnd_log.level_statement,

3622:
3623: IF g_debug_stmt
3624: THEN
3625: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3626: fnd_log.STRING (fnd_log.level_statement,
3627: g_log_head || '.' || l_api_name || '.' || l_progress,
3628: 'not the compatible doc type'
3629: );
3630: END IF;

Line 3646: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3642: l_progress := 50;
3643:
3644: IF g_debug_stmt
3645: THEN
3646: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3647: fnd_log.STRING (fnd_log.level_statement,
3648: g_log_head || '.' || l_api_name || '.' || l_progress,
3649: 'Call OKC API to get default template'
3650: );

Line 3647: fnd_log.STRING (fnd_log.level_statement,

3643:
3644: IF g_debug_stmt
3645: THEN
3646: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3647: fnd_log.STRING (fnd_log.level_statement,
3648: g_log_head || '.' || l_api_name || '.' || l_progress,
3649: 'Call OKC API to get default template'
3650: );
3651: END IF;

Line 3670: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3666: );
3667:
3668: IF g_debug_stmt
3669: THEN
3670: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3671: fnd_log.STRING (fnd_log.level_statement,
3672: g_log_head || '.' || l_api_name || '.' || l_progress,
3673: 'Return status from get default template:'
3674: || x_return_status

Line 3671: fnd_log.STRING (fnd_log.level_statement,

3667:
3668: IF g_debug_stmt
3669: THEN
3670: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3671: fnd_log.STRING (fnd_log.level_statement,
3672: g_log_head || '.' || l_api_name || '.' || l_progress,
3673: 'Return status from get default template:'
3674: || x_return_status
3675: );

Line 3728: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

3724: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3725:
3726: IF (g_fnd_debug = 'Y')
3727: THEN
3728: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3729: fnd_log.STRING (log_level => fnd_log.level_unexpected,
3730: module => g_module_prefix || l_api_name,
3731: MESSAGE => SQLERRM
3732: );

Line 3729: fnd_log.STRING (log_level => fnd_log.level_unexpected,

3725:
3726: IF (g_fnd_debug = 'Y')
3727: THEN
3728: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3729: fnd_log.STRING (log_level => fnd_log.level_unexpected,
3730: module => g_module_prefix || l_api_name,
3731: MESSAGE => SQLERRM
3732: );
3733: END IF;

Line 3801: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3797: THEN
3798: l_progress := 20;
3799: IF g_debug_stmt
3800: THEN
3801: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3802: fnd_log.STRING (fnd_log.level_statement,
3803: g_log_head || '.' || l_api_name || '.' || l_progress,
3804: 'not the compatible doc type'
3805: );

Line 3802: fnd_log.STRING (fnd_log.level_statement,

3798: l_progress := 20;
3799: IF g_debug_stmt
3800: THEN
3801: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3802: fnd_log.STRING (fnd_log.level_statement,
3803: g_log_head || '.' || l_api_name || '.' || l_progress,
3804: 'not the compatible doc type'
3805: );
3806: END IF;

Line 3820: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3816: l_progress := 10;
3817:
3818: IF g_debug_stmt
3819: THEN
3820: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3821: fnd_log.STRING (fnd_log.level_statement,
3822: g_log_head || '.' || l_api_name || '.' || l_progress,
3823: 'Call OKC API to get contract details'
3824: );

Line 3821: fnd_log.STRING (fnd_log.level_statement,

3817:
3818: IF g_debug_stmt
3819: THEN
3820: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3821: fnd_log.STRING (fnd_log.level_statement,
3822: g_log_head || '.' || l_api_name || '.' || l_progress,
3823: 'Call OKC API to get contract details'
3824: );
3825: END IF;

Line 3846: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

3842: l_progress := 20;
3843:
3844: IF g_debug_stmt
3845: THEN
3846: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3847: fnd_log.STRING (fnd_log.level_statement,
3848: g_log_head || '.' || l_api_name || '.' || l_progress,
3849: 'Return status from get contract details:'
3850: || x_return_status

Line 3847: fnd_log.STRING (fnd_log.level_statement,

3843:
3844: IF g_debug_stmt
3845: THEN
3846: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3847: fnd_log.STRING (fnd_log.level_statement,
3848: g_log_head || '.' || l_api_name || '.' || l_progress,
3849: 'Return status from get contract details:'
3850: || x_return_status
3851: );

Line 3894: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

3890: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3891:
3892: IF (g_fnd_debug = 'Y')
3893: THEN
3894: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3895: fnd_log.STRING (log_level => fnd_log.level_unexpected,
3896: module => g_module_prefix || l_api_name,
3897: MESSAGE => SQLERRM
3898: );

Line 3895: fnd_log.STRING (log_level => fnd_log.level_unexpected,

3891:
3892: IF (g_fnd_debug = 'Y')
3893: THEN
3894: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
3895: fnd_log.STRING (log_level => fnd_log.level_unexpected,
3896: module => g_module_prefix || l_api_name,
3897: MESSAGE => SQLERRM
3898: );
3899: END IF;