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

Line 277: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

273: null,
274: null,
275: p_batch_id
276: );
277: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
278: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.OKS_IB_UTIL_UB.Create_transaction_source',
279: '.Create_Operation_Instance(Return status = '||l_return_status ||')' );
280: END IF;
281:

Line 278: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.OKS_IB_UTIL_UB.Create_transaction_source',

274: null,
275: p_batch_id
276: );
277: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
278: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.OKS_IB_UTIL_UB.Create_transaction_source',
279: '.Create_Operation_Instance(Return status = '||l_return_status ||')' );
280: END IF;
281:
282: End If;

Line 331: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

327: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
328: null);
329:
330:
331: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
332: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.OKS_IB_UTIL_UB.Create_transaction_source',
333: 'OKC_OPER_INST_PUB.Create_Operation_Line(Return status = '||l_return_status ||')' );
334: END IF;
335: If p_transaction = 'RENEWAL' Then

Line 332: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.OKS_IB_UTIL_UB.Create_transaction_source',

328: null);
329:
330:
331: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
332: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.OKS_IB_UTIL_UB.Create_transaction_source',
333: 'OKC_OPER_INST_PUB.Create_Operation_Line(Return status = '||l_return_status ||')' );
334: END IF;
335: If p_transaction = 'RENEWAL' Then
336: Open check_rec_exists(l_oper_instance_id);

Line 386: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

382: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
383: null);
384:
385:
386: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
387: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.OKS_IB_UTIL_UB.Create_transaction_source',
388: 'OKC_OPER_INST_PUB.Create_Operation_Line(Return status = '||l_return_status ||')' );
389: END IF;
390: End If;

Line 387: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.OKS_IB_UTIL_UB.Create_transaction_source',

383: null);
384:
385:
386: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
387: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.OKS_IB_UTIL_UB.Create_transaction_source',
388: 'OKC_OPER_INST_PUB.Create_Operation_Line(Return status = '||l_return_status ||')' );
389: END IF;
390: End If;
391:

Line 400: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

396: THEN
397: x_return_status := l_return_status;
398: fnd_file.put_line(fnd_file.log,' Error while creating the transaction sourec : '
399: || SQLCODE||':'|| SQLERRM );
400: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
401: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.OKS_IB_UTIL_UB.Create_transaction_source',
402: 'Error while creating the transaction sourec :( sqlcode = '||SQLCODE
403: ||') sqlerrm = ( '|| SQLERRM || ')' );
404: END IF;

Line 401: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.OKS_IB_UTIL_UB.Create_transaction_source',

397: x_return_status := l_return_status;
398: fnd_file.put_line(fnd_file.log,' Error while creating the transaction sourec : '
399: || SQLCODE||':'|| SQLERRM );
400: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
401: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.OKS_IB_UTIL_UB.Create_transaction_source',
402: 'Error while creating the transaction sourec :( sqlcode = '||SQLCODE
403: ||') sqlerrm = ( '|| SQLERRM || ')' );
404: END IF;
405:

Line 605: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

601: p_index NUMBER DEFAULT g_num_one
602: )
603: IS
604: BEGIN
605: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
606: THEN
607: fnd_log.STRING (fnd_log.level_event,
608: g_module_current || 'oks_mass_update.initialize_okc_tbl',
609: 'Begin'

Line 607: fnd_log.STRING (fnd_log.level_event,

603: IS
604: BEGIN
605: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
606: THEN
607: fnd_log.STRING (fnd_log.level_event,
608: g_module_current || 'oks_mass_update.initialize_okc_tbl',
609: 'Begin'
610: );
611: END IF;

Line 740: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

736: p_index NUMBER DEFAULT g_num_one
737: )
738: IS
739: BEGIN
740: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
741: THEN
742: fnd_log.STRING (fnd_log.level_event,
743: g_module_current || 'oks_mass_update.initialize_oks_tbl',
744: 'Begin'

Line 742: fnd_log.STRING (fnd_log.level_event,

738: IS
739: BEGIN
740: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
741: THEN
742: fnd_log.STRING (fnd_log.level_event,
743: g_module_current || 'oks_mass_update.initialize_oks_tbl',
744: 'Begin'
745: );
746: END IF;

Line 846: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

842: WHERE cle_id = p_cle_id;
843:
844: l_strmlvl_id NUMBER;
845: BEGIN
846: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
847: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'oks_mass_update.check_strmlvl_exists',
848: 'Begin' );
849: END IF;
850:

Line 847: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'oks_mass_update.check_strmlvl_exists',

843:
844: l_strmlvl_id NUMBER;
845: BEGIN
846: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
847: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'oks_mass_update.check_strmlvl_exists',
848: 'Begin' );
849: END IF;
850:
851: OPEN l_billsch_csr (p_cle_id);

Line 947: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

943: || p_end_date,
944: 1,
945: 450
946: );
947: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
948: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'oks_mass_update.get_invoice_text',
949: 'l_formatted_invoice_text = ('|| l_formatted_invoice_text || ')' );
950: END IF;
951:

Line 948: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'oks_mass_update.get_invoice_text',

944: 1,
945: 450
946: );
947: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
948: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'oks_mass_update.get_invoice_text',
949: 'l_formatted_invoice_text = ('|| l_formatted_invoice_text || ')' );
950: END IF;
951:
952: RETURN (l_formatted_invoice_text);

Line 986: IF (Fnd_Log.LEVEL_EVENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN

982: p_rnrl_rec => NULL,
983: x_rnrl_rec => l_rnrl_rec_out
984: );
985:
986: IF (Fnd_Log.LEVEL_EVENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
987: Fnd_Log.string(Fnd_Log.LEVEL_EVENT,G_MODULE_CURRENT||'.get_setup_attr',
988: 'get_renew_rules: status = ( '|| x_return_status|| ' )' );
989: END IF;
990: If Not x_return_status = 'S' Then

Line 987: Fnd_Log.string(Fnd_Log.LEVEL_EVENT,G_MODULE_CURRENT||'.get_setup_attr',

983: x_rnrl_rec => l_rnrl_rec_out
984: );
985:
986: IF (Fnd_Log.LEVEL_EVENT >= Fnd_Log.G_CURRENT_RUNTIME_LEVEL) THEN
987: Fnd_Log.string(Fnd_Log.LEVEL_EVENT,G_MODULE_CURRENT||'.get_setup_attr',
988: 'get_renew_rules: status = ( '|| x_return_status|| ' )' );
989: END IF;
990: If Not x_return_status = 'S' Then
991:

Line 999: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

995: setup_attr.pdf_id := l_rnrl_rec_out.pdf_id;
996: setup_attr.qcl_id := l_rnrl_rec_out.qcl_id;
997: setup_attr.rle_code := l_rnrl_rec_out.rle_code;
998:
999: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1000: THEN
1001: fnd_log.STRING (fnd_log.level_event,
1002: g_module_current || '.get_setup_attr',
1003: 'get_renew_rules: values = ( group ='

Line 1001: fnd_log.STRING (fnd_log.level_event,

997: setup_attr.rle_code := l_rnrl_rec_out.rle_code;
998:
999: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1000: THEN
1001: fnd_log.STRING (fnd_log.level_event,
1002: g_module_current || '.get_setup_attr',
1003: 'get_renew_rules: values = ( group ='
1004: || setup_attr.cgp_new_id
1005: || 'pdf id ='

Line 1050: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

1046: INTO x_from_version;
1047:
1048: CLOSE l_cvm_csr;
1049:
1050: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1051: THEN
1052: fnd_log.STRING (fnd_log.level_event,
1053: g_module_current || '.get_major_version',
1054: 'version = ( ' || x_from_version || ' )'

Line 1052: fnd_log.STRING (fnd_log.level_event,

1048: CLOSE l_cvm_csr;
1049:
1050: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1051: THEN
1052: fnd_log.STRING (fnd_log.level_event,
1053: g_module_current || '.get_major_version',
1054: 'version = ( ' || x_from_version || ' )'
1055: );
1056: END IF;

Line 1089: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

1085: SELECT application_id
1086: FROM okc_k_headers_all_b
1087: WHERE ID = p_chr_id;
1088: BEGIN
1089: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1090: THEN
1091: fnd_log.STRING (fnd_log.level_event,
1092: g_module_current || 'oks_mass_update.set_attach_ses_vars',
1093: 'Begin'

Line 1091: fnd_log.STRING (fnd_log.level_event,

1087: WHERE ID = p_chr_id;
1088: BEGIN
1089: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1090: THEN
1091: fnd_log.STRING (fnd_log.level_event,
1092: g_module_current || 'oks_mass_update.set_attach_ses_vars',
1093: 'Begin'
1094: );
1095: END IF;

Line 1136: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

1132: l_jtf_note_contexts_tab jtf_notes_pub.jtf_note_contexts_tbl_type;
1133:
1134: BEGIN
1135: x_return_status := okc_api.g_ret_sts_success;
1136: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1137: THEN
1138: fnd_log.STRING (fnd_log.level_event,
1139: g_module_current || '.create_csi_note',
1140: 'note = ( ' || p_note || ' )'

Line 1138: fnd_log.STRING (fnd_log.level_event,

1134: BEGIN
1135: x_return_status := okc_api.g_ret_sts_success;
1136: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1137: THEN
1138: fnd_log.STRING (fnd_log.level_event,
1139: g_module_current || '.create_csi_note',
1140: 'note = ( ' || p_note || ' )'
1141: );
1142: END IF;

Line 1185: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

1181: p_attribute15 => NULL,
1182: p_context => NULL,
1183: p_jtf_note_contexts_tab => l_jtf_note_contexts_tab
1184: );
1185: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1186: THEN
1187: fnd_log.STRING (fnd_log.level_event,
1188: g_module_current || '.create_csi_note',
1189: 'status = ( ' || x_return_status || ' )'

Line 1187: fnd_log.STRING (fnd_log.level_event,

1183: p_jtf_note_contexts_tab => l_jtf_note_contexts_tab
1184: );
1185: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1186: THEN
1187: fnd_log.STRING (fnd_log.level_event,
1188: g_module_current || '.create_csi_note',
1189: 'status = ( ' || x_return_status || ' )'
1190: );
1191: END IF;

Line 1249: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

1245: WHERE b.source_object_id = l_id;
1246:
1247: i NUMBER := 0;
1248: BEGIN
1249: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1250: THEN
1251: fnd_log.STRING (fnd_log.level_event,
1252: g_module_current || 'oks_mass_update.get_notes_details',
1253: 'Begin'

Line 1251: fnd_log.STRING (fnd_log.level_event,

1247: i NUMBER := 0;
1248: BEGIN
1249: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1250: THEN
1251: fnd_log.STRING (fnd_log.level_event,
1252: g_module_current || 'oks_mass_update.get_notes_details',
1253: 'Begin'
1254: );
1255: END IF;

Line 1336: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

1332: FETCH check_acct_csr INTO l_dummy_var;
1333: IF check_acct_csr%FOUND
1334: THEN
1335: RETURN (FALSE);
1336: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1337: THEN
1338: fnd_log.STRING (fnd_log.level_event,
1339: g_module_current || 'oks_mass_update.create_csi_note',
1340: 'Account = '|| p_acct_id || 'is related to '|| p_party_id );

Line 1338: fnd_log.STRING (fnd_log.level_event,

1334: THEN
1335: RETURN (FALSE);
1336: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1337: THEN
1338: fnd_log.STRING (fnd_log.level_event,
1339: g_module_current || 'oks_mass_update.create_csi_note',
1340: 'Account = '|| p_acct_id || 'is related to '|| p_party_id );
1341: END IF;
1342:

Line 2026: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

2022: -- Main
2023: BEGIN
2024:
2025: l_return_status := okc_api.g_ret_sts_success;
2026: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2027: THEN
2028: fnd_log.STRING (fnd_log.level_event,
2029: g_module_current || 'oks_mass_update.creat_contract_header',
2030: 'Begin'

Line 2028: fnd_log.STRING (fnd_log.level_event,

2024:
2025: l_return_status := okc_api.g_ret_sts_success;
2026: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2027: THEN
2028: fnd_log.STRING (fnd_log.level_event,
2029: g_module_current || 'oks_mass_update.creat_contract_header',
2030: 'Begin'
2031: );
2032: END IF;

Line 2068: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

2064: price_uom;
2065:
2066: CLOSE get_hdr_details_csr;
2067:
2068: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2069: THEN
2070: fnd_log.STRING (fnd_log.level_event,
2071: g_module_current || 'oks_mass_update.create_contract_header',
2072: 'Contracts count = (' || hdr_id.COUNT ||')');

Line 2070: fnd_log.STRING (fnd_log.level_event,

2066: CLOSE get_hdr_details_csr;
2067:
2068: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2069: THEN
2070: fnd_log.STRING (fnd_log.level_event,
2071: g_module_current || 'oks_mass_update.create_contract_header',
2072: 'Contracts count = (' || hdr_id.COUNT ||')');
2073: END IF;
2074:

Line 2088: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

2084: FOR i IN 1 .. hdr_id.COUNT
2085: LOOP
2086: l_valid_shipto := Null;
2087: l_valid_billto := Null;
2088: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2089: THEN
2090: fnd_log.STRING (fnd_log.level_event,
2091: g_module_current || 'oks_mass_update.create_contract_header',
2092: 'Process Contract id = (' ||i|| '--->'|| hdr_id(i)

Line 2090: fnd_log.STRING (fnd_log.level_event,

2086: l_valid_shipto := Null;
2087: l_valid_billto := Null;
2088: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2089: THEN
2090: fnd_log.STRING (fnd_log.level_event,
2091: g_module_current || 'oks_mass_update.create_contract_header',
2092: 'Process Contract id = (' ||i|| '--->'|| hdr_id(i)
2093: ||'). Set org context( authoring_org_id ='|| hdr_authoring_org_id(i)
2094: ||', org id = '||hdr_inv_org_id (i)|| ')' );

Line 2114: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

2110: OPEN l_app_csr (hdr_scs_code (i));
2111: FETCH l_app_csr INTO l_chrv_tbl_in (i).application_id;
2112: CLOSE l_app_csr;
2113:
2114: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2115: THEN
2116: fnd_log.STRING (fnd_log.level_event,
2117: g_module_current || 'oks_mass_update.create_contract_header',
2118: 'Application org id = '||l_chrv_tbl_in (i).application_id );

Line 2116: fnd_log.STRING (fnd_log.level_event,

2112: CLOSE l_app_csr;
2113:
2114: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2115: THEN
2116: fnd_log.STRING (fnd_log.level_event,
2117: g_module_current || 'oks_mass_update.create_contract_header',
2118: 'Application org id = '||l_chrv_tbl_in (i).application_id );
2119: END IF;
2120:

Line 2195: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

2191:
2192: IF NOT l_return_status = okc_api.g_ret_sts_success THEN
2193: Raise G_EXCEPTION_HALT_VALIDATION;
2194: End if;
2195: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2196: THEN
2197: fnd_log.STRING (fnd_log.level_event,
2198: g_module_current || 'oks_mass_update.create_contract_header',
2199: 'After generate contract number, status = ('

Line 2197: fnd_log.STRING (fnd_log.level_event,

2193: Raise G_EXCEPTION_HALT_VALIDATION;
2194: End if;
2195: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2196: THEN
2197: fnd_log.STRING (fnd_log.level_event,
2198: g_module_current || 'oks_mass_update.create_contract_header',
2199: 'After generate contract number, status = ('
2200: || l_return_status|| '). Contract Number = ('
2201: ||l_chrv_tbl_in (i).contract_number || ')');

Line 2288: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

2284: l_time := l_time + 1/(24 * 60 * 60) ;
2285:
2286: fnd_file.put_line(fnd_file.log,l_chrv_tbl_in (i).contract_number ||l_chrv_tbl_in (i).contract_number_modifier);
2287: fnd_file.put_line(fnd_file.log,l_chrv_tbl_in (i).id);
2288: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2289: THEN
2290: fnd_log.STRING (fnd_log.level_event,
2291: g_module_current || 'oks_mass_update.create_contract_header',
2292: 'After contract Modifier ('

Line 2290: fnd_log.STRING (fnd_log.level_event,

2286: fnd_file.put_line(fnd_file.log,l_chrv_tbl_in (i).contract_number ||l_chrv_tbl_in (i).contract_number_modifier);
2287: fnd_file.put_line(fnd_file.log,l_chrv_tbl_in (i).id);
2288: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2289: THEN
2290: fnd_log.STRING (fnd_log.level_event,
2291: g_module_current || 'oks_mass_update.create_contract_header',
2292: 'After contract Modifier ('
2293: || l_chrv_tbl_in (i).contract_number_modifier || ')');
2294: END IF;

Line 2302: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

2298: p_contract_number => l_chrv_tbl_in (i).contract_number,
2299: x_return_status => l_return_status
2300: );
2301: fnd_file.put_line(fnd_file.log,'validate_contract_number'||l_return_status);
2302: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2303: THEN
2304: fnd_log.STRING (fnd_log.level_event,
2305: g_module_current || 'oks_mass_update.create_contract_header',
2306: 'after Validate contract number status = ('

Line 2304: fnd_log.STRING (fnd_log.level_event,

2300: );
2301: fnd_file.put_line(fnd_file.log,'validate_contract_number'||l_return_status);
2302: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2303: THEN
2304: fnd_log.STRING (fnd_log.level_event,
2305: g_module_current || 'oks_mass_update.create_contract_header',
2306: 'after Validate contract number status = ('
2307: || l_return_status || ')');
2308: END IF;

Line 2455: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

2451:
2452: -- create wf process
2453: IF setup_attr.pdf_id IS NOT NULL and l_lse_id <> 14
2454: THEN
2455: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2456: THEN
2457: fnd_log.STRING (fnd_log.level_event,
2458: g_module_current || 'oks_mass_update.create_contract_header',
2459: 'Inside pdf assignment');

Line 2457: fnd_log.STRING (fnd_log.level_event,

2453: IF setup_attr.pdf_id IS NOT NULL and l_lse_id <> 14
2454: THEN
2455: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2456: THEN
2457: fnd_log.STRING (fnd_log.level_event,
2458: g_module_current || 'oks_mass_update.create_contract_header',
2459: 'Inside pdf assignment');
2460: END IF;
2461:

Line 2496: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

2492: -- create contract group
2493: IF setup_attr.cgp_new_id IS NOT NULL
2494: THEN
2495:
2496: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2497: THEN
2498: fnd_log.STRING (fnd_log.level_event,
2499: g_module_current || 'oks_mass_update.create_contract_header',
2500: 'Inside contract group assignment');

Line 2498: fnd_log.STRING (fnd_log.level_event,

2494: THEN
2495:
2496: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2497: THEN
2498: fnd_log.STRING (fnd_log.level_event,
2499: g_module_current || 'oks_mass_update.create_contract_header',
2500: 'Inside contract group assignment');
2501: END IF;
2502:

Line 2515: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

2511: l_cgcv_tbl_in (i).last_update_date := SYSDATE;
2512: l_cgcv_tbl_in (i).last_update_login := fnd_global.login_id;
2513: END IF;
2514:
2515: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2516: THEN
2517: fnd_log.STRING (fnd_log.level_event,
2518: g_module_current || 'oks_mass_update.create_contract_header',
2519: 'Party roles assignment, Vendor = '|| hdr_authoring_org_id (i)

Line 2517: fnd_log.STRING (fnd_log.level_event,

2513: END IF;
2514:
2515: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2516: THEN
2517: fnd_log.STRING (fnd_log.level_event,
2518: g_module_current || 'oks_mass_update.create_contract_header',
2519: 'Party roles assignment, Vendor = '|| hdr_authoring_org_id (i)
2520: || 'Customer = '|| p_batch_rules.new_party_id );
2521: END IF;

Line 2608: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2604: End If;
2605: End Loop;
2606:
2607:
2608: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2609: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT,
2610: 'Salesrep ID is : ' || l_salesrep_id );
2611: END IF;
2612: IF l_salesrep_id Is Null THEN

Line 2609: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT,

2605: End Loop;
2606:
2607:
2608: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2609: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT,
2610: 'Salesrep ID is : ' || l_salesrep_id );
2611: END IF;
2612: IF l_salesrep_id Is Null THEN
2613: fnd_file.put_line(fnd_file.log,'SEND_NOTIFICATION 1');

Line 2755: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

2751: THEN
2752: get_party_id (p_cust_id => p_batch_rules.bill_account_id,
2753: x_party_id => l_third_party_id
2754: );
2755: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2756: THEN
2757: fnd_log.STRING (fnd_log.level_event,
2758: g_module_current || 'oks_mass_update.create_contract_header',
2759: 'Billing account not related, create billing contact.'

Line 2757: fnd_log.STRING (fnd_log.level_event,

2753: x_party_id => l_third_party_id
2754: );
2755: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2756: THEN
2757: fnd_log.STRING (fnd_log.level_event,
2758: g_module_current || 'oks_mass_update.create_contract_header',
2759: 'Billing account not related, create billing contact.'
2760: || l_third_party_id);
2761: END IF;

Line 2845: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

2841: l_ctcv_tbl_in (k).start_date := hdr_start_date (i);
2842: l_ctcv_tbl_in (k).end_date := hdr_end_date (i);
2843: j := j + 3;
2844: ELSE
2845: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2846: THEN
2847: fnd_log.STRING (fnd_log.level_event,
2848: g_module_current || 'oks_mass_update.create_contract_header',
2849: 'Billing account are related, create billing contact.');

Line 2847: fnd_log.STRING (fnd_log.level_event,

2843: j := j + 3;
2844: ELSE
2845: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2846: THEN
2847: fnd_log.STRING (fnd_log.level_event,
2848: g_module_current || 'oks_mass_update.create_contract_header',
2849: 'Billing account are related, create billing contact.');
2850: END IF;
2851:

Line 2909: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

2905:
2906: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_chr_pvt.insert_row_upg , status = ( '
2907: || l_return_status || ' )');
2908:
2909: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2910: THEN
2911: fnd_log.STRING (fnd_log.level_event,
2912: g_module_current || 'oks_mass_update.create_contract_header',
2913: 'okc_chr_pvt.insert_row_upg, status = ('

Line 2911: fnd_log.STRING (fnd_log.level_event,

2907: || l_return_status || ' )');
2908:
2909: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2910: THEN
2911: fnd_log.STRING (fnd_log.level_event,
2912: g_module_current || 'oks_mass_update.create_contract_header',
2913: 'okc_chr_pvt.insert_row_upg, status = ('
2914: || l_return_status || ')');
2915: END IF;

Line 2974: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

2970: price_uom(i));
2971:
2972: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks header table records sucessfully');
2973:
2974: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2975: THEN
2976: fnd_log.STRING (fnd_log.level_event,
2977: g_module_current || 'oks_mass_update.create_contract_header',
2978: 'oks_chr_pvt.insert_row_upg, status = ('

Line 2976: fnd_log.STRING (fnd_log.level_event,

2972: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks header table records sucessfully');
2973:
2974: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2975: THEN
2976: fnd_log.STRING (fnd_log.level_event,
2977: g_module_current || 'oks_mass_update.create_contract_header',
2978: 'oks_chr_pvt.insert_row_upg, status = ('
2979: || l_return_status || ')');
2980: END IF;

Line 2993: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

2989:
2990: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_cpl_pvt.insert_row_upg , status = ( '
2991: || l_return_status || ' )');
2992:
2993: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2994: THEN
2995: fnd_log.STRING (fnd_log.level_event,
2996: g_module_current || 'oks_mass_update.create_contract_header',
2997: 'okc_cpl_pvt.insert_row_upg, status = ('

Line 2995: fnd_log.STRING (fnd_log.level_event,

2991: || l_return_status || ' )');
2992:
2993: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2994: THEN
2995: fnd_log.STRING (fnd_log.level_event,
2996: g_module_current || 'oks_mass_update.create_contract_header',
2997: 'okc_cpl_pvt.insert_row_upg, status = ('
2998: || l_return_status || ')');
2999: END IF;

Line 3017: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

3013:
3014: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_ctc_pvt.insert_row_upg , status = ( '
3015: || l_return_status || ' )');
3016:
3017: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3018: THEN
3019: fnd_log.STRING (fnd_log.level_event,
3020: g_module_current || 'oks_mass_update.create_contract_header',
3021: 'okc_ctc_pvt.insert_row_upg, status = ('

Line 3019: fnd_log.STRING (fnd_log.level_event,

3015: || l_return_status || ' )');
3016:
3017: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3018: THEN
3019: fnd_log.STRING (fnd_log.level_event,
3020: g_module_current || 'oks_mass_update.create_contract_header',
3021: 'okc_ctc_pvt.insert_row_upg, status = ('
3022: || l_return_status || ')');
3023: END IF;

Line 3041: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

3037:
3038: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_gve_pvt.insert_row_upg , status = ( '
3039: || l_return_status || ' )');
3040:
3041: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3042: THEN
3043: fnd_log.STRING (fnd_log.level_event,
3044: g_module_current || 'oks_mass_update.create_contract_header',
3045: 'okc_gve_pvt.insert_row_upg, status = ('

Line 3043: fnd_log.STRING (fnd_log.level_event,

3039: || l_return_status || ' )');
3040:
3041: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3042: THEN
3043: fnd_log.STRING (fnd_log.level_event,
3044: g_module_current || 'oks_mass_update.create_contract_header',
3045: 'okc_gve_pvt.insert_row_upg, status = ('
3046: || l_return_status || ')');
3047: END IF;

Line 3064: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

3060:
3061: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_cps_pvt.insert_row_upg , status = ( '
3062: || l_return_status || ' )');
3063:
3064: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3065: THEN
3066: fnd_log.STRING (fnd_log.level_event,
3067: g_module_current || 'oks_mass_update.create_contract_header',
3068: 'okc_cps_pvt.insert_row_upg, status = ('

Line 3066: fnd_log.STRING (fnd_log.level_event,

3062: || l_return_status || ' )');
3063:
3064: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3065: THEN
3066: fnd_log.STRING (fnd_log.level_event,
3067: g_module_current || 'oks_mass_update.create_contract_header',
3068: 'okc_cps_pvt.insert_row_upg, status = ('
3069: || l_return_status || ')');
3070: END IF;

Line 3087: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

3083:
3084: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_cgc_pvt.insert_row_upg , status = ( '
3085: || l_return_status || ' )');
3086:
3087: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3088: THEN
3089: fnd_log.STRING (fnd_log.level_event,
3090: g_module_current || 'oks_mass_update.create_contract_header',
3091: 'okc_cgc_pvt.insert_row_upg, status = ('

Line 3089: fnd_log.STRING (fnd_log.level_event,

3085: || l_return_status || ' )');
3086:
3087: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3088: THEN
3089: fnd_log.STRING (fnd_log.level_event,
3090: g_module_current || 'oks_mass_update.create_contract_header',
3091: 'okc_cgc_pvt.insert_row_upg, status = ('
3092: || l_return_status || ')');
3093: END IF;

Line 3142: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

3138: fnd_global.user_id
3139: );
3140: fnd_file.put_line(fnd_file.log,'(OKS) -> Created access sucessfully');
3141:
3142: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3143: THEN
3144: fnd_log.STRING (fnd_log.level_event,
3145: g_module_current || 'oks_mass_update.create_contract_header',
3146: 'AFter creating the access for each contract');

Line 3144: fnd_log.STRING (fnd_log.level_event,

3140: fnd_file.put_line(fnd_file.log,'(OKS) -> Created access sucessfully');
3141:
3142: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3143: THEN
3144: fnd_log.STRING (fnd_log.level_event,
3145: g_module_current || 'oks_mass_update.create_contract_header',
3146: 'AFter creating the access for each contract');
3147: END IF;
3148: END IF;

Line 3196: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

3192: SYSDATE
3193: );
3194: fnd_file.put_line(fnd_file.log,'(OKS) -> Created sales credits sucessfully');
3195:
3196: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3197: THEN
3198: fnd_log.STRING (fnd_log.level_event,
3199: g_module_current || 'oks_mass_update.create_contract_header',
3200: 'AFter inserting sales credits for header');

Line 3198: fnd_log.STRING (fnd_log.level_event,

3194: fnd_file.put_line(fnd_file.log,'(OKS) -> Created sales credits sucessfully');
3195:
3196: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3197: THEN
3198: fnd_log.STRING (fnd_log.level_event,
3199: g_module_current || 'oks_mass_update.create_contract_header',
3200: 'AFter inserting sales credits for header');
3201: END IF;
3202:

Line 3370: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

3366: BEGIN
3367: l_return_status := okc_api.g_ret_sts_success;
3368:
3369: l_Tlineno_new := 0;
3370: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3371: THEN
3372: fnd_log.STRING (fnd_log.level_event,
3373: g_module_current || 'oks_mass_update.create_contract_Line',
3374: 'Begin');

Line 3372: fnd_log.STRING (fnd_log.level_event,

3368:
3369: l_Tlineno_new := 0;
3370: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3371: THEN
3372: fnd_log.STRING (fnd_log.level_event,
3373: g_module_current || 'oks_mass_update.create_contract_Line',
3374: 'Begin');
3375: END IF;
3376:

Line 3409: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

3405:
3406: ;
3407:
3408: CLOSE get_srv_details_csr;
3409: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3410: THEN
3411: fnd_log.STRING (fnd_log.level_event,
3412: g_module_current || 'oks_mass_update.create_contract_Line',
3413: 'Impacted lines count = ( ' || srvline_id.COUNT ||')');

Line 3411: fnd_log.STRING (fnd_log.level_event,

3407:
3408: CLOSE get_srv_details_csr;
3409: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3410: THEN
3411: fnd_log.STRING (fnd_log.level_event,
3412: g_module_current || 'oks_mass_update.create_contract_Line',
3413: 'Impacted lines count = ( ' || srvline_id.COUNT ||')');
3414: END IF;
3415:

Line 3499: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

3495:
3496: );
3497: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc line table records sucessfully');
3498:
3499: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3500: THEN
3501: fnd_log.STRING (fnd_log.level_event,
3502: g_module_current || 'oks_mass_update.create_contract_Line',
3503: 'After insert into okc_k_lines_b table ');

Line 3501: fnd_log.STRING (fnd_log.level_event,

3497: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc line table records sucessfully');
3498:
3499: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3500: THEN
3501: fnd_log.STRING (fnd_log.level_event,
3502: g_module_current || 'oks_mass_update.create_contract_Line',
3503: 'After insert into okc_k_lines_b table ');
3504: END IF;
3505:

Line 3540: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

3536: );
3537: END LOOP;
3538: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc tl table records sucessfully');
3539:
3540: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3541: THEN
3542: fnd_log.STRING (fnd_log.level_event,
3543: g_module_current || 'oks_mass_update.create_contract_Line',
3544: 'After insert into okc_k_lines_tl table ');

Line 3542: fnd_log.STRING (fnd_log.level_event,

3538: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc tl table records sucessfully');
3539:
3540: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3541: THEN
3542: fnd_log.STRING (fnd_log.level_event,
3543: g_module_current || 'oks_mass_update.create_contract_Line',
3544: 'After insert into okc_k_lines_tl table ');
3545: END IF;
3546:

Line 3603: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

3599: );
3600:
3601: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc item records sucessfully');
3602:
3603: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3604: THEN
3605: fnd_log.STRING (fnd_log.level_event,
3606: g_module_current || 'oks_mass_update.create_contract_Line',
3607: 'After insert into okc_k_items table ');

Line 3605: fnd_log.STRING (fnd_log.level_event,

3601: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc item records sucessfully');
3602:
3603: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3604: THEN
3605: fnd_log.STRING (fnd_log.level_event,
3606: g_module_current || 'oks_mass_update.create_contract_Line',
3607: 'After insert into okc_k_items table ');
3608: END IF;
3609:

Line 3646: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

3642: );
3643:
3644: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks line table records sucessfully');
3645:
3646: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3647: THEN
3648: fnd_log.STRING (fnd_log.level_event,
3649: g_module_current || 'oks_mass_update.create_contract_Line',
3650: 'After insert into oks_lines table ');

Line 3648: fnd_log.STRING (fnd_log.level_event,

3644: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks line table records sucessfully');
3645:
3646: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3647: THEN
3648: fnd_log.STRING (fnd_log.level_event,
3649: g_module_current || 'oks_mass_update.create_contract_Line',
3650: 'After insert into oks_lines table ');
3651: END IF;
3652: -- insert invoice text in oks tl table

Line 3684: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

3680: END LOOP;
3681:
3682: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks tl table records sucessfully');
3683:
3684: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3685: THEN
3686: fnd_log.STRING (fnd_log.level_event,
3687: g_module_current || 'oks_mass_update.create_contract_Line',
3688: 'After insert into okc_lines_tl table ');

Line 3686: fnd_log.STRING (fnd_log.level_event,

3682: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks tl table records sucessfully');
3683:
3684: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3685: THEN
3686: fnd_log.STRING (fnd_log.level_event,
3687: g_module_current || 'oks_mass_update.create_contract_Line',
3688: 'After insert into okc_lines_tl table ');
3689: END IF;
3690:

Line 3735: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

3731: SYSDATE
3732: );
3733: fnd_file.put_line(fnd_file.log,'(OKS) -> Created sales credits sucessfully');
3734:
3735: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3736: THEN
3737: fnd_log.STRING (fnd_log.level_event,
3738: g_module_current || 'oks_mass_update.create_contract_header',
3739: 'AFter inserting sales credits for header');

Line 3737: fnd_log.STRING (fnd_log.level_event,

3733: fnd_file.put_line(fnd_file.log,'(OKS) -> Created sales credits sucessfully');
3734:
3735: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3736: THEN
3737: fnd_log.STRING (fnd_log.level_event,
3738: g_module_current || 'oks_mass_update.create_contract_header',
3739: 'AFter inserting sales credits for header');
3740: END IF;
3741: END IF; --For Bug#14183916

Line 3883: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

3879: BEGIN
3880: l_return_status := okc_api.g_ret_sts_success;
3881:
3882: l_lineno_new := 0;
3883: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3884: THEN
3885: fnd_log.STRING (fnd_log.level_event,
3886: g_module_current || 'oks_mass_update.create_contract_subLine',
3887: 'Begin');

Line 3885: fnd_log.STRING (fnd_log.level_event,

3881:
3882: l_lineno_new := 0;
3883: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3884: THEN
3885: fnd_log.STRING (fnd_log.level_event,
3886: g_module_current || 'oks_mass_update.create_contract_subLine',
3887: 'Begin');
3888: END IF;
3889:

Line 3984: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

3980:
3981: );
3982: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc line table records sucessfully');
3983:
3984: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3985: THEN
3986: fnd_log.STRING (fnd_log.level_event,
3987: g_module_current || 'oks_mass_update.create_contract_Line',
3988: 'after insert into okc_k_lines table');

Line 3986: fnd_log.STRING (fnd_log.level_event,

3982: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc line table records sucessfully');
3983:
3984: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3985: THEN
3986: fnd_log.STRING (fnd_log.level_event,
3987: g_module_current || 'oks_mass_update.create_contract_Line',
3988: 'after insert into okc_k_lines table');
3989: END IF;
3990:

Line 4023: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

4019: );
4020: END LOOP;
4021: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc line tl table records sucessfully');
4022:
4023: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4024: THEN
4025: fnd_log.STRING (fnd_log.level_event,
4026: g_module_current || 'oks_mass_update.create_contract_Line',
4027: 'after insert into okc_k_lines_tl table');

Line 4025: fnd_log.STRING (fnd_log.level_event,

4021: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc line tl table records sucessfully');
4022:
4023: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4024: THEN
4025: fnd_log.STRING (fnd_log.level_event,
4026: g_module_current || 'oks_mass_update.create_contract_Line',
4027: 'after insert into okc_k_lines_tl table');
4028: END IF;
4029:

Line 4085: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

4081: NULL
4082: );
4083: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc items table records sucessfully');
4084:
4085: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4086: THEN
4087: fnd_log.STRING (fnd_log.level_event,
4088: g_module_current || 'oks_mass_update.create_contract_Line',
4089: 'after insert into okc_k_items table');

Line 4087: fnd_log.STRING (fnd_log.level_event,

4083: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc items table records sucessfully');
4084:
4085: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4086: THEN
4087: fnd_log.STRING (fnd_log.level_event,
4088: g_module_current || 'oks_mass_update.create_contract_Line',
4089: 'after insert into okc_k_items table');
4090: END IF;
4091:

Line 4125: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

4121: fnd_global.user_id
4122: );
4123: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks line table records sucessfully');
4124:
4125: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4126: THEN
4127: fnd_log.STRING (fnd_log.level_event,
4128: g_module_current || 'oks_mass_update.create_contract_Line',
4129: 'after insert into oks_k_lines table');

Line 4127: fnd_log.STRING (fnd_log.level_event,

4123: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks line table records sucessfully');
4124:
4125: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4126: THEN
4127: fnd_log.STRING (fnd_log.level_event,
4128: g_module_current || 'oks_mass_update.create_contract_Line',
4129: 'after insert into oks_k_lines table');
4130: END IF;
4131:

Line 4165: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

4161: END LOOP;
4162:
4163: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks line tl table records sucessfully');
4164:
4165: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4166: THEN
4167: fnd_log.STRING (fnd_log.level_event,
4168: g_module_current || 'oks_mass_update.create_contract_Line',
4169: 'after insert into oks_k_lines_tl table');

Line 4167: fnd_log.STRING (fnd_log.level_event,

4163: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks line tl table records sucessfully');
4164:
4165: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4166: THEN
4167: fnd_log.STRING (fnd_log.level_event,
4168: g_module_current || 'oks_mass_update.create_contract_Line',
4169: 'after insert into oks_k_lines_tl table');
4170: END IF;
4171:

Line 4690: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

4686:
4687: fnd_file.put_line(fnd_file.log,'(OKS) -> Create coverage for line = ( '
4688: ||Line_ctr||'-> ' ||srvline_id (Line_ctr)||' ) status = ( '||l_return_status || ' )' );
4689:
4690: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4691: THEN
4692: fnd_log.STRING (fnd_log.level_event,
4693: g_module_current || 'oks_mass_update.create_contract_Line',
4694: 'create coverage status = ('|| x_return_status || ')');

Line 4692: fnd_log.STRING (fnd_log.level_event,

4688: ||Line_ctr||'-> ' ||srvline_id (Line_ctr)||' ) status = ( '||l_return_status || ' )' );
4689:
4690: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4691: THEN
4692: fnd_log.STRING (fnd_log.level_event,
4693: g_module_current || 'oks_mass_update.create_contract_Line',
4694: 'create coverage status = ('|| x_return_status || ')');
4695: END IF;
4696: IF NOT l_return_status = okc_api.g_ret_sts_success

Line 4720: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

4716: );
4717: fnd_file.put_line(fnd_file.log,'(OKS) -> Create standard coverage for line = ( '
4718: ||Line_ctr||'-> ' ||srvline_id (Line_ctr)||' ) status = ( ' ||l_return_status || ' )' );
4719:
4720: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4721: THEN
4722: fnd_log.STRING (fnd_log.level_event,
4723: g_module_current || 'oks_mass_update.create_contract_Line',
4724: 'create coverage extension status = ('|| x_return_status || ')');

Line 4722: fnd_log.STRING (fnd_log.level_event,

4718: ||Line_ctr||'-> ' ||srvline_id (Line_ctr)||' ) status = ( ' ||l_return_status || ' )' );
4719:
4720: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4721: THEN
4722: fnd_log.STRING (fnd_log.level_event,
4723: g_module_current || 'oks_mass_update.create_contract_Line',
4724: 'create coverage extension status = ('|| x_return_status || ')');
4725: END IF;
4726:

Line 4761: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

4757:
4758: fnd_file.put_line(fnd_file.log,'(OKS) -> Instantiate counters for line = ( '
4759: ||Line_ctr||'-> ' ||srvline_id (Line_ctr)||', '|| srvitm_id (Line_ctr) ||' ) status = ( '||l_return_status || ' )' );
4760:
4761: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4762: THEN
4763: fnd_log.STRING (fnd_log.level_event,
4764: g_module_current || 'oks_mass_update.create_contract_Line',
4765: 'Instantiate counters status = ('|| l_return_status || ')');

Line 4763: fnd_log.STRING (fnd_log.level_event,

4759: ||Line_ctr||'-> ' ||srvline_id (Line_ctr)||', '|| srvitm_id (Line_ctr) ||' ) status = ( '||l_return_status || ' )' );
4760:
4761: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4762: THEN
4763: fnd_log.STRING (fnd_log.level_event,
4764: g_module_current || 'oks_mass_update.create_contract_Line',
4765: 'Instantiate counters status = ('|| l_return_status || ')');
4766: END IF;
4767:

Line 4799: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

4795:
4796: fnd_file.put_line(fnd_file.log,'(OKS) -> Instantiate events for line = ( '
4797: ||Line_ctr||'-> ' ||srvline_id (Line_ctr)||' ) status = ( '||l_return_status || ' )' );
4798:
4799: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4800: THEN
4801: fnd_log.STRING (fnd_log.level_event,
4802: g_module_current || 'oks_mass_update.create_contract_Line',
4803: 'create events status = ('|| l_return_status || ')');

Line 4801: fnd_log.STRING (fnd_log.level_event,

4797: ||Line_ctr||'-> ' ||srvline_id (Line_ctr)||' ) status = ( '||l_return_status || ' )' );
4798:
4799: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4800: THEN
4801: fnd_log.STRING (fnd_log.level_event,
4802: g_module_current || 'oks_mass_update.create_contract_Line',
4803: 'create events status = ('|| l_return_status || ')');
4804: END IF;
4805:

Line 4840: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

4836: x_sll_tbl_out => l_sll_tbl_out,
4837: x_return_status => l_return_status,
4838: x_msg_count => x_msg_count,
4839: x_msg_data => x_msg_data);
4840: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4841: THEN
4842: fnd_log.STRING (fnd_log.level_event,
4843: g_module_current || 'oks_mass_update.create_billing_schedule',
4844: 'get_billing_schedule'|| x_return_status);

Line 4842: fnd_log.STRING (fnd_log.level_event,

4838: x_msg_count => x_msg_count,
4839: x_msg_data => x_msg_data);
4840: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4841: THEN
4842: fnd_log.STRING (fnd_log.level_event,
4843: g_module_current || 'oks_mass_update.create_billing_schedule',
4844: 'get_billing_schedule'|| x_return_status);
4845: END IF;
4846: IF NOT l_return_status = 'S'

Line 4895: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

4891: x_duration => l_duration,
4892: x_timeunit => l_timeunit,
4893: x_return_status => l_return_status
4894: );
4895: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4896: THEN
4897: fnd_log.STRING (fnd_log.level_event,
4898: g_module_current || 'oks_mass_update.create_billing_schedule',
4899: 'get_duration'|| l_return_status);

Line 4897: fnd_log.STRING (fnd_log.level_event,

4893: x_return_status => l_return_status
4894: );
4895: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4896: THEN
4897: fnd_log.STRING (fnd_log.level_event,
4898: g_module_current || 'oks_mass_update.create_billing_schedule',
4899: 'get_duration'|| l_return_status);
4900: END IF;
4901: IF NOT l_return_status = 'S'

Line 4933: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

4929: x_return_status => l_return_status);
4930:
4931: fnd_file.put_line(fnd_file.log,'(OKS) -> OKS_BILL_SCH.create_bill_sch_rules:'||l_return_status );
4932:
4933: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4934: THEN
4935: fnd_log.STRING (fnd_log.level_event,
4936: g_module_current || 'oks_mass_update.create_billing_schedule',
4937: 'create_bill_sch_rules'|| x_return_status);

Line 4935: fnd_log.STRING (fnd_log.level_event,

4931: fnd_file.put_line(fnd_file.log,'(OKS) -> OKS_BILL_SCH.create_bill_sch_rules:'||l_return_status );
4932:
4933: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4934: THEN
4935: fnd_log.STRING (fnd_log.level_event,
4936: g_module_current || 'oks_mass_update.create_billing_schedule',
4937: 'create_bill_sch_rules'|| x_return_status);
4938: END IF;
4939: IF NOT l_return_status = 'S'

Line 4979: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4975: x_msg_data => x_msg_data,
4976: x_return_status => l_return_status
4977: );
4978:
4979: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4980: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.after_tax',
4981: 'oks_tax_util_pvt.get_tax(Return status = ' ||l_return_status || ')' );
4982: END IF;
4983:

Line 4980: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.after_tax',

4976: x_return_status => l_return_status
4977: );
4978:
4979: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4980: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.after_tax',
4981: 'oks_tax_util_pvt.get_tax(Return status = ' ||l_return_status || ')' );
4982: END IF;
4983:
4984:

Line 6837: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

6833: IF Check_batch_csr%NOTFOUND
6834: THEN
6835: fnd_file.put_line(fnd_file.log,'(OKS) -> No batch rules defined');
6836:
6837: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
6838: THEN
6839: fnd_log.STRING (fnd_log.level_event,
6840: g_module_current || 'oks_mass_update.Update_contracts',
6841: 'No Batch rules defined' );

Line 6839: fnd_log.STRING (fnd_log.level_event,

6835: fnd_file.put_line(fnd_file.log,'(OKS) -> No batch rules defined');
6836:
6837: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
6838: THEN
6839: fnd_log.STRING (fnd_log.level_event,
6840: g_module_current || 'oks_mass_update.Update_contracts',
6841: 'No Batch rules defined' );
6842: END IF;
6843:

Line 6887: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

6883: );
6884:
6885: RAISE G_EXCEPTION_HALT_VALIDATION ;
6886:
6887: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
6888: THEN
6889: fnd_log.STRING (fnd_log.level_event,
6890: g_module_current || 'oks_mass_update.Update_contracts',
6891: 'No Batch rules created' );

Line 6889: fnd_log.STRING (fnd_log.level_event,

6885: RAISE G_EXCEPTION_HALT_VALIDATION ;
6886:
6887: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
6888: THEN
6889: fnd_log.STRING (fnd_log.level_event,
6890: g_module_current || 'oks_mass_update.Update_contracts',
6891: 'No Batch rules created' );
6892: END IF;
6893:

Line 6911: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

6907: P_batch_id
6908: );
6909:
6910: RAISE G_EXCEPTION_HALT_VALIDATION ;
6911: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
6912: THEN
6913: fnd_log.STRING (fnd_log.level_event,
6914: g_module_current || 'oks_mass_update.Update_contracts',
6915: 'No Batch rules created' );

Line 6913: fnd_log.STRING (fnd_log.level_event,

6909:
6910: RAISE G_EXCEPTION_HALT_VALIDATION ;
6911: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
6912: THEN
6913: fnd_log.STRING (fnd_log.level_event,
6914: g_module_current || 'oks_mass_update.Update_contracts',
6915: 'No Batch rules created' );
6916: END IF;
6917: END IF;

Line 6924: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

6920:
6921: fnd_file.put_line(fnd_file.log,'(OKS) -> Batch Type = ( ' || p_batch_type
6922: || ' ) Batch id = ( ' || p_batch_id || ' ) Transfer Option = ( ' || batch_rules_rec.transfer_option|| ' )');
6923:
6924: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
6925: THEN
6926: fnd_log.STRING (fnd_log.level_event,
6927: g_module_current || 'oks_mass_update.Update_contracts',
6928: 'Batch Type = ( '|| p_batch_type || ') Batch id = ( '

Line 6926: fnd_log.STRING (fnd_log.level_event,

6922: || ' ) Batch id = ( ' || p_batch_id || ' ) Transfer Option = ( ' || batch_rules_rec.transfer_option|| ' )');
6923:
6924: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
6925: THEN
6926: fnd_log.STRING (fnd_log.level_event,
6927: g_module_current || 'oks_mass_update.Update_contracts',
6928: 'Batch Type = ( '|| p_batch_type || ') Batch id = ( '
6929: || p_batch_id || ')' );
6930: END IF;

Line 7014: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

7010: LOOP
7011: IF hdr_ste(i) = 'HOLD'
7012: THEN
7013: l_found := TRUE;
7014: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7015: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.oks_mass_update.Update_contracts',
7016: ' Contract '||contract_number(i) ||' in QA_HOLD status' );
7017: END IF;
7018:

Line 7015: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.oks_mass_update.Update_contracts',

7011: IF hdr_ste(i) = 'HOLD'
7012: THEN
7013: l_found := TRUE;
7014: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7015: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.oks_mass_update.Update_contracts',
7016: ' Contract '||contract_number(i) ||' in QA_HOLD status' );
7017: END IF;
7018:
7019: OKC_API.SET_MESSAGE(

Line 7123: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

7119: p_full_credit => l_full_credit,
7120: x_return_status => l_return_status
7121: );
7122:
7123: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
7124: THEN
7125: fnd_log.STRING (fnd_log.level_event,
7126: g_module_current || 'oks_mass_update.Update_contracts',
7127: 'Terminate_subline status = ( '|| l_return_status);

Line 7125: fnd_log.STRING (fnd_log.level_event,

7121: );
7122:
7123: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
7124: THEN
7125: fnd_log.STRING (fnd_log.level_event,
7126: g_module_current || 'oks_mass_update.Update_contracts',
7127: 'Terminate_subline status = ( '|| l_return_status);
7128: END IF;
7129:

Line 7368: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

7364: LOOP
7365: IF hdr_ste(i) = 'HOLD'
7366: THEN
7367: l_found := TRUE;
7368: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7369: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.oks_mass_update.Update_contracts',
7370: ' Contract '||contract_number(i) ||' in QA_HOLD status' );
7371: END IF;
7372:

Line 7369: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.oks_mass_update.Update_contracts',

7365: IF hdr_ste(i) = 'HOLD'
7366: THEN
7367: l_found := TRUE;
7368: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7369: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.oks_mass_update.Update_contracts',
7370: ' Contract '||contract_number(i) ||' in QA_HOLD status' );
7371: END IF;
7372:
7373:

Line 7493: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

7489: );
7490:
7491: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate_subline status = ( '|| l_return_status|| ' )');
7492:
7493: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
7494: THEN
7495: fnd_log.STRING (fnd_log.level_event,
7496: g_module_current || 'oks_mass_update.Update_contracts',
7497: 'Terminate_subline status = ( '|| l_return_status);

Line 7495: fnd_log.STRING (fnd_log.level_event,

7491: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate_subline status = ( '|| l_return_status|| ' )');
7492:
7493: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
7494: THEN
7495: fnd_log.STRING (fnd_log.level_event,
7496: g_module_current || 'oks_mass_update.Update_contracts',
7497: 'Terminate_subline status = ( '|| l_return_status);
7498: END IF;
7499:

Line 7531: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

7527: x_msg_data => x_msg_data,
7528: x_msg_count => x_msg_count
7529: );
7530:
7531: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
7532: THEN
7533: fnd_log.STRING (fnd_log.level_event,
7534: g_module_current || 'oks_mass_update.Update_contracts',
7535: 'create_contract status = ( '|| l_return_status || ')');

Line 7533: fnd_log.STRING (fnd_log.level_event,

7529: );
7530:
7531: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
7532: THEN
7533: fnd_log.STRING (fnd_log.level_event,
7534: g_module_current || 'oks_mass_update.Update_contracts',
7535: 'create_contract status = ( '|| l_return_status || ')');
7536: END IF;
7537:

Line 7615: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

7611: x_return_status => l_return_status,
7612: x_msg_count => l_msg_count,
7613: x_msg_data => l_msg_data
7614: );
7615: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
7616: THEN
7617: fnd_log.STRING (fnd_log.level_event,
7618: g_module_current || 'oks_mass_update.Update_contracts',
7619: 'create_transaction_source(transfer) status = ( '|| l_return_status || ')');

Line 7617: fnd_log.STRING (fnd_log.level_event,

7613: x_msg_data => l_msg_data
7614: );
7615: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
7616: THEN
7617: fnd_log.STRING (fnd_log.level_event,
7618: g_module_current || 'oks_mass_update.Update_contracts',
7619: 'create_transaction_source(transfer) status = ( '|| l_return_status || ')');
7620: END IF;
7621:

Line 7660: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

7656: x_msg_count => l_msg_count,
7657: x_msg_data => l_msg_data
7658: );
7659:
7660: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
7661: THEN
7662: fnd_log.STRING (fnd_log.level_statement,
7663: g_module_current || 'oks_mass_update.Update_contracts',
7664: 'create_transaction_source (Renewal) status = ( '|| l_return_status || ')');

Line 7662: fnd_log.STRING (fnd_log.level_statement,

7658: );
7659:
7660: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
7661: THEN
7662: fnd_log.STRING (fnd_log.level_statement,
7663: g_module_current || 'oks_mass_update.Update_contracts',
7664: 'create_transaction_source (Renewal) status = ( '|| l_return_status || ')');
7665: END IF;
7666:

Line 8003: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

7999: LOOP
8000: IF idc_date(i) IS NULL
8001: THEN
8002: l_return_status := OKC_API.G_RET_STS_WARNING;
8003: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8004: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.IB_INTERFACE',
8005: 'Installation date changed to null ' );
8006: End If;
8007: OKC_API.set_message(G_APP_NAME,'OKS_NULL_INSTALLATION_DATE');

Line 8004: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.IB_INTERFACE',

8000: IF idc_date(i) IS NULL
8001: THEN
8002: l_return_status := OKC_API.G_RET_STS_WARNING;
8003: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8004: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.IB_INTERFACE',
8005: 'Installation date changed to null ' );
8006: End If;
8007: OKC_API.set_message(G_APP_NAME,'OKS_NULL_INSTALLATION_DATE');
8008: Raise G_EXCEPTION_HALT_VALIDATION;

Line 8022: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

8018: ,'CONTRACTLINE',line_number(i)
8019: ,'INSTANCE',custprod_id (i)
8020: );
8021:
8022: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8023: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.UPDATE_CONTRACT_IDC.ERROR',
8024: 'SR is logged '||',status = ' || l_return_status);
8025: END IF;
8026:

Line 8023: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.UPDATE_CONTRACT_IDC.ERROR',

8019: ,'INSTANCE',custprod_id (i)
8020: );
8021:
8022: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8023: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.UPDATE_CONTRACT_IDC.ERROR',
8024: 'SR is logged '||',status = ' || l_return_status);
8025: END IF;
8026:
8027:

Line 8401: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

8397: LOOP
8398: IF hdr_ste(i) = 'HOLD'
8399: THEN
8400: l_found := TRUE;
8401: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8402: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.oks_mass_update.Update_contracts',
8403: ' Contract '||contract_number(i) ||' in QA_HOLD status' );
8404: END IF;
8405:

Line 8402: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.oks_mass_update.Update_contracts',

8398: IF hdr_ste(i) = 'HOLD'
8399: THEN
8400: l_found := TRUE;
8401: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8402: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.oks_mass_update.Update_contracts',
8403: ' Contract '||contract_number(i) ||' in QA_HOLD status' );
8404: END IF;
8405:
8406: OKC_API.SET_MESSAGE(