eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_REP_CONTRACT_IMP_PVT dependencies on OKC_DEBUG

Line 766: okc_debug.log('200: Org row not found', 2);

762: CLOSE c_org_info_csr ;
763:
764: IF (l_row_notfound) THEN
765: IF (l_debug = 'Y') THEN
766: okc_debug.log('200: Org row not found', 2);
767: END IF;
768: FND_MESSAGE.SET_NAME(G_APP_NAME, 'OKC_REP_IMP_INV_ORG');
769: FND_MSG_PUB.add;
770: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));

Line 785: okc_debug.log('300: Contract Type not found', 2);

781: CLOSE c_contract_type_valid_csr ;
782:
783: IF (l_row_notfound) THEN
784: IF (l_debug = 'Y') THEN
785: okc_debug.log('300: Contract Type not found', 2);
786: END IF;
787: FND_MESSAGE.SET_NAME(G_APP_NAME, 'OKC_REP_INV_CONTRACT_TYPE');
788: FND_MSG_PUB.add;
789: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));

Line 824: okc_debug.log('400: Before Execute Immediate l_update_query: '|| l_update_query, 2);

820: ' WHERE nvl(valid_flag, ''U'') IN (''U'', ''Y'')
821: AND run_id IS NULL ' || l_where_clause;
822:
823: IF (l_debug = 'Y') THEN
824: okc_debug.log('400: Before Execute Immediate l_update_query: '|| l_update_query, 2);
825: END IF;
826:
827: EXECUTE IMMEDIATE (l_update_query);
828:

Line 832: okc_debug.log('500: After Execute Immediate l_count: '|| l_count, 2);

828:
829: l_count := SQL%ROWCOUNT;
830:
831: IF (l_debug = 'Y') THEN
832: okc_debug.log('500: After Execute Immediate l_count: '|| l_count, 2);
833: END IF;
834:
835: IF l_count <= 0 THEN
836: IF (l_debug = 'Y') THEN

Line 837: okc_debug.log('600: No Rows found to import');

833: END IF;
834:
835: IF l_count <= 0 THEN
836: IF (l_debug = 'Y') THEN
837: okc_debug.log('600: No Rows found to import');
838: END IF;
839: FND_MESSAGE.SET_NAME(G_APP_NAME, 'OKC_REP_IMP_NO_VALID_ROWS');
840: FND_MSG_PUB.add;
841: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(1, p_encoded =>FND_API.G_FALSE ));

Line 864: okc_debug.log('700: After UPDATE okc_rep_imp_parties_t ', 1);

860: FROM OKC_REP_IMP_CONTRACTS_T
861: WHERE run_id = l_run_id);
862:
863: IF (l_debug = 'Y') THEN
864: okc_debug.log('700: After UPDATE okc_rep_imp_parties_t ', 1);
865: END IF;
866:
867: --update okc_rep_imp_contacts_t
868: UPDATE okc_rep_imp_contacts_t

Line 876: okc_debug.log('800: After UPDATE okc_rep_imp_contacts_t ', 1);

872: FROM OKC_REP_IMP_CONTRACTS_T
873: WHERE run_id = l_run_id);
874:
875: IF (l_debug = 'Y') THEN
876: okc_debug.log('800: After UPDATE okc_rep_imp_contacts_t ', 1);
877: END IF;
878:
879: --update okc_rep_imp_risks_t
880: UPDATE okc_rep_imp_risks_t

Line 888: okc_debug.log('900: After UPDATE okc_rep_imp_risks_t ', 1);

884: FROM OKC_REP_IMP_CONTRACTS_T
885: WHERE run_id = l_run_id);
886:
887: IF (l_debug = 'Y') THEN
888: okc_debug.log('900: After UPDATE okc_rep_imp_risks_t ', 1);
889: END IF;
890:
891:
892: --update OKC_REP_IMP_DOCUMENTS_T

Line 901: okc_debug.log('1000: After UPDATE OKC_REP_IMP_DOCUMENTS_T ', 1);

897: FROM OKC_REP_IMP_CONTRACTS_T
898: WHERE run_id = l_run_id);
899:
900: IF (l_debug = 'Y') THEN
901: okc_debug.log('1000: After UPDATE OKC_REP_IMP_DOCUMENTS_T ', 1);
902: END IF;
903:
904: --call the OKC_REP_UTIL_PVT.validate_and_insert_contracts
905:

Line 916: okc_debug.log('1100: After okc_rep_util_pvt.validate_and_insert_contracts l_msg_data: '|| l_msg_data, 1);

912: x_msg_count => l_msg_count,
913: x_return_status => l_return_status,
914: x_number_inserted => l_number_inserted);
915: IF (l_debug = 'Y') THEN
916: okc_debug.log('1100: After okc_rep_util_pvt.validate_and_insert_contracts l_msg_data: '|| l_msg_data, 1);
917: okc_debug.log('1100: After okc_rep_util_pvt.validate_and_insert_contracts l_msg_count: '|| l_msg_count, 1);
918: okc_debug.log('1100: After okc_rep_util_pvt.validate_and_insert_contracts l_return_status: '||l_return_status, 1);
919: okc_debug.log('1100: After okc_rep_util_pvt.validate_and_insert_contracts l_number_inserted: ' ||l_number_inserted, 1);
920: END IF;

Line 917: okc_debug.log('1100: After okc_rep_util_pvt.validate_and_insert_contracts l_msg_count: '|| l_msg_count, 1);

913: x_return_status => l_return_status,
914: x_number_inserted => l_number_inserted);
915: IF (l_debug = 'Y') THEN
916: okc_debug.log('1100: After okc_rep_util_pvt.validate_and_insert_contracts l_msg_data: '|| l_msg_data, 1);
917: okc_debug.log('1100: After okc_rep_util_pvt.validate_and_insert_contracts l_msg_count: '|| l_msg_count, 1);
918: okc_debug.log('1100: After okc_rep_util_pvt.validate_and_insert_contracts l_return_status: '||l_return_status, 1);
919: okc_debug.log('1100: After okc_rep_util_pvt.validate_and_insert_contracts l_number_inserted: ' ||l_number_inserted, 1);
920: END IF;
921:

Line 918: okc_debug.log('1100: After okc_rep_util_pvt.validate_and_insert_contracts l_return_status: '||l_return_status, 1);

914: x_number_inserted => l_number_inserted);
915: IF (l_debug = 'Y') THEN
916: okc_debug.log('1100: After okc_rep_util_pvt.validate_and_insert_contracts l_msg_data: '|| l_msg_data, 1);
917: okc_debug.log('1100: After okc_rep_util_pvt.validate_and_insert_contracts l_msg_count: '|| l_msg_count, 1);
918: okc_debug.log('1100: After okc_rep_util_pvt.validate_and_insert_contracts l_return_status: '||l_return_status, 1);
919: okc_debug.log('1100: After okc_rep_util_pvt.validate_and_insert_contracts l_number_inserted: ' ||l_number_inserted, 1);
920: END IF;
921:
922: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 919: okc_debug.log('1100: After okc_rep_util_pvt.validate_and_insert_contracts l_number_inserted: ' ||l_number_inserted, 1);

915: IF (l_debug = 'Y') THEN
916: okc_debug.log('1100: After okc_rep_util_pvt.validate_and_insert_contracts l_msg_data: '|| l_msg_data, 1);
917: okc_debug.log('1100: After okc_rep_util_pvt.validate_and_insert_contracts l_msg_count: '|| l_msg_count, 1);
918: okc_debug.log('1100: After okc_rep_util_pvt.validate_and_insert_contracts l_return_status: '||l_return_status, 1);
919: okc_debug.log('1100: After okc_rep_util_pvt.validate_and_insert_contracts l_number_inserted: ' ||l_number_inserted, 1);
920: END IF;
921:
922: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
923: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 930: okc_debug.log('1500: Leaving validate_and_insert_con_cp because of EXCEPTION: '||sqlerrm);

926:
927: EXCEPTION
928: WHEN OTHERS THEN
929: IF (l_debug = 'Y') THEN
930: okc_debug.log('1500: Leaving validate_and_insert_con_cp because of EXCEPTION: '||sqlerrm);
931: END IF;
932: l_return_status := G_RET_STS_UNEXP_ERROR ;
933: IF c_org_info_csr%ISOPEN Then
934: close c_org_info_csr;