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 842: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

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

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

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

939: || p_end_date,
940: 1,
941: 450
942: );
943: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
944: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'oks_mass_update.get_invoice_text',
945: 'l_formatted_invoice_text = ('|| l_formatted_invoice_text || ')' );
946: END IF;
947:

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

940: 1,
941: 450
942: );
943: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
944: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'oks_mass_update.get_invoice_text',
945: 'l_formatted_invoice_text = ('|| l_formatted_invoice_text || ')' );
946: END IF;
947:
948: RETURN (l_formatted_invoice_text);

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

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

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

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

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

991: setup_attr.pdf_id := l_rnrl_rec_out.pdf_id;
992: setup_attr.qcl_id := l_rnrl_rec_out.qcl_id;
993: setup_attr.rle_code := l_rnrl_rec_out.rle_code;
994:
995: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
996: THEN
997: fnd_log.STRING (fnd_log.level_event,
998: g_module_current || '.get_setup_attr',
999: 'get_renew_rules: values = ( group ='

Line 997: fnd_log.STRING (fnd_log.level_event,

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

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

1042: INTO x_from_version;
1043:
1044: CLOSE l_cvm_csr;
1045:
1046: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1047: THEN
1048: fnd_log.STRING (fnd_log.level_event,
1049: g_module_current || '.get_major_version',
1050: 'version = ( ' || x_from_version || ' )'

Line 1048: fnd_log.STRING (fnd_log.level_event,

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

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

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

Line 1087: fnd_log.STRING (fnd_log.level_event,

1083: WHERE ID = p_chr_id;
1084: BEGIN
1085: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1086: THEN
1087: fnd_log.STRING (fnd_log.level_event,
1088: g_module_current || 'oks_mass_update.set_attach_ses_vars',
1089: 'Begin'
1090: );
1091: END IF;

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

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

Line 1134: fnd_log.STRING (fnd_log.level_event,

1130: BEGIN
1131: x_return_status := okc_api.g_ret_sts_success;
1132: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1133: THEN
1134: fnd_log.STRING (fnd_log.level_event,
1135: g_module_current || '.create_csi_note',
1136: 'note = ( ' || p_note || ' )'
1137: );
1138: END IF;

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

1177: p_attribute15 => NULL,
1178: p_context => NULL,
1179: p_jtf_note_contexts_tab => l_jtf_note_contexts_tab
1180: );
1181: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1182: THEN
1183: fnd_log.STRING (fnd_log.level_event,
1184: g_module_current || '.create_csi_note',
1185: 'status = ( ' || x_return_status || ' )'

Line 1183: fnd_log.STRING (fnd_log.level_event,

1179: p_jtf_note_contexts_tab => l_jtf_note_contexts_tab
1180: );
1181: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1182: THEN
1183: fnd_log.STRING (fnd_log.level_event,
1184: g_module_current || '.create_csi_note',
1185: 'status = ( ' || x_return_status || ' )'
1186: );
1187: END IF;

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

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

Line 1247: fnd_log.STRING (fnd_log.level_event,

1243: i NUMBER := 0;
1244: BEGIN
1245: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1246: THEN
1247: fnd_log.STRING (fnd_log.level_event,
1248: g_module_current || 'oks_mass_update.get_notes_details',
1249: 'Begin'
1250: );
1251: END IF;

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

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

Line 1334: fnd_log.STRING (fnd_log.level_event,

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

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

2017: -- Main
2018: BEGIN
2019:
2020: l_return_status := okc_api.g_ret_sts_success;
2021: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2022: THEN
2023: fnd_log.STRING (fnd_log.level_event,
2024: g_module_current || 'oks_mass_update.creat_contract_header',
2025: 'Begin'

Line 2023: fnd_log.STRING (fnd_log.level_event,

2019:
2020: l_return_status := okc_api.g_ret_sts_success;
2021: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2022: THEN
2023: fnd_log.STRING (fnd_log.level_event,
2024: g_module_current || 'oks_mass_update.creat_contract_header',
2025: 'Begin'
2026: );
2027: END IF;

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

2059: price_uom;
2060:
2061: CLOSE get_hdr_details_csr;
2062:
2063: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2064: THEN
2065: fnd_log.STRING (fnd_log.level_event,
2066: g_module_current || 'oks_mass_update.create_contract_header',
2067: 'Contracts count = (' || hdr_id.COUNT ||')');

Line 2065: fnd_log.STRING (fnd_log.level_event,

2061: CLOSE get_hdr_details_csr;
2062:
2063: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2064: THEN
2065: fnd_log.STRING (fnd_log.level_event,
2066: g_module_current || 'oks_mass_update.create_contract_header',
2067: 'Contracts count = (' || hdr_id.COUNT ||')');
2068: END IF;
2069:

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

2079: FOR i IN 1 .. hdr_id.COUNT
2080: LOOP
2081: l_valid_shipto := Null;
2082: l_valid_billto := Null;
2083: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2084: THEN
2085: fnd_log.STRING (fnd_log.level_event,
2086: g_module_current || 'oks_mass_update.create_contract_header',
2087: 'Process Contract id = (' ||i|| '--->'|| hdr_id(i)

Line 2085: fnd_log.STRING (fnd_log.level_event,

2081: l_valid_shipto := Null;
2082: l_valid_billto := Null;
2083: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2084: THEN
2085: fnd_log.STRING (fnd_log.level_event,
2086: g_module_current || 'oks_mass_update.create_contract_header',
2087: 'Process Contract id = (' ||i|| '--->'|| hdr_id(i)
2088: ||'). Set org context( authoring_org_id ='|| hdr_authoring_org_id(i)
2089: ||', org id = '||hdr_inv_org_id (i)|| ')' );

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

2105: OPEN l_app_csr (hdr_scs_code (i));
2106: FETCH l_app_csr INTO l_chrv_tbl_in (i).application_id;
2107: CLOSE l_app_csr;
2108:
2109: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2110: THEN
2111: fnd_log.STRING (fnd_log.level_event,
2112: g_module_current || 'oks_mass_update.create_contract_header',
2113: 'Application org id = '||l_chrv_tbl_in (i).application_id );

Line 2111: fnd_log.STRING (fnd_log.level_event,

2107: CLOSE l_app_csr;
2108:
2109: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2110: THEN
2111: fnd_log.STRING (fnd_log.level_event,
2112: g_module_current || 'oks_mass_update.create_contract_header',
2113: 'Application org id = '||l_chrv_tbl_in (i).application_id );
2114: END IF;
2115:

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

2186:
2187: IF NOT l_return_status = okc_api.g_ret_sts_success THEN
2188: Raise G_EXCEPTION_HALT_VALIDATION;
2189: End if;
2190: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2191: THEN
2192: fnd_log.STRING (fnd_log.level_event,
2193: g_module_current || 'oks_mass_update.create_contract_header',
2194: 'After generate contract number, status = ('

Line 2192: fnd_log.STRING (fnd_log.level_event,

2188: Raise G_EXCEPTION_HALT_VALIDATION;
2189: End if;
2190: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2191: THEN
2192: fnd_log.STRING (fnd_log.level_event,
2193: g_module_current || 'oks_mass_update.create_contract_header',
2194: 'After generate contract number, status = ('
2195: || l_return_status|| '). Contract Number = ('
2196: ||l_chrv_tbl_in (i).contract_number || ')');

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

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

Line 2285: fnd_log.STRING (fnd_log.level_event,

2281: fnd_file.put_line(fnd_file.log,l_chrv_tbl_in (i).contract_number ||l_chrv_tbl_in (i).contract_number_modifier);
2282: fnd_file.put_line(fnd_file.log,l_chrv_tbl_in (i).id);
2283: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2284: THEN
2285: fnd_log.STRING (fnd_log.level_event,
2286: g_module_current || 'oks_mass_update.create_contract_header',
2287: 'After contract Modifier ('
2288: || l_chrv_tbl_in (i).contract_number_modifier || ')');
2289: END IF;

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

2293: p_contract_number => l_chrv_tbl_in (i).contract_number,
2294: x_return_status => l_return_status
2295: );
2296: fnd_file.put_line(fnd_file.log,'validate_contract_number'||l_return_status);
2297: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2298: THEN
2299: fnd_log.STRING (fnd_log.level_event,
2300: g_module_current || 'oks_mass_update.create_contract_header',
2301: 'after Validate contract number status = ('

Line 2299: fnd_log.STRING (fnd_log.level_event,

2295: );
2296: fnd_file.put_line(fnd_file.log,'validate_contract_number'||l_return_status);
2297: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2298: THEN
2299: fnd_log.STRING (fnd_log.level_event,
2300: g_module_current || 'oks_mass_update.create_contract_header',
2301: 'after Validate contract number status = ('
2302: || l_return_status || ')');
2303: END IF;

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

2446:
2447: -- create wf process
2448: IF setup_attr.pdf_id IS NOT NULL and l_lse_id <> 14
2449: THEN
2450: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2451: THEN
2452: fnd_log.STRING (fnd_log.level_event,
2453: g_module_current || 'oks_mass_update.create_contract_header',
2454: 'Inside pdf assignment');

Line 2452: fnd_log.STRING (fnd_log.level_event,

2448: IF setup_attr.pdf_id IS NOT NULL and l_lse_id <> 14
2449: THEN
2450: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2451: THEN
2452: fnd_log.STRING (fnd_log.level_event,
2453: g_module_current || 'oks_mass_update.create_contract_header',
2454: 'Inside pdf assignment');
2455: END IF;
2456:

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

2487: -- create contract group
2488: IF setup_attr.cgp_new_id IS NOT NULL
2489: THEN
2490:
2491: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2492: THEN
2493: fnd_log.STRING (fnd_log.level_event,
2494: g_module_current || 'oks_mass_update.create_contract_header',
2495: 'Inside contract group assignment');

Line 2493: fnd_log.STRING (fnd_log.level_event,

2489: THEN
2490:
2491: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2492: THEN
2493: fnd_log.STRING (fnd_log.level_event,
2494: g_module_current || 'oks_mass_update.create_contract_header',
2495: 'Inside contract group assignment');
2496: END IF;
2497:

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

2506: l_cgcv_tbl_in (i).last_update_date := SYSDATE;
2507: l_cgcv_tbl_in (i).last_update_login := fnd_global.login_id;
2508: END IF;
2509:
2510: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2511: THEN
2512: fnd_log.STRING (fnd_log.level_event,
2513: g_module_current || 'oks_mass_update.create_contract_header',
2514: 'Party roles assignment, Vendor = '|| hdr_authoring_org_id (i)

Line 2512: fnd_log.STRING (fnd_log.level_event,

2508: END IF;
2509:
2510: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2511: THEN
2512: fnd_log.STRING (fnd_log.level_event,
2513: g_module_current || 'oks_mass_update.create_contract_header',
2514: 'Party roles assignment, Vendor = '|| hdr_authoring_org_id (i)
2515: || 'Customer = '|| p_batch_rules.new_party_id );
2516: END IF;

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

2599: End If;
2600: End Loop;
2601:
2602:
2603: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2604: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT,
2605: 'Salesrep ID is : ' || l_salesrep_id );
2606: END IF;
2607: IF l_salesrep_id Is Null THEN

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

2600: End Loop;
2601:
2602:
2603: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2604: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT,
2605: 'Salesrep ID is : ' || l_salesrep_id );
2606: END IF;
2607: IF l_salesrep_id Is Null THEN
2608: fnd_file.put_line(fnd_file.log,'SEND_NOTIFICATION 1');

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

2746: THEN
2747: get_party_id (p_cust_id => p_batch_rules.bill_account_id,
2748: x_party_id => l_third_party_id
2749: );
2750: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2751: THEN
2752: fnd_log.STRING (fnd_log.level_event,
2753: g_module_current || 'oks_mass_update.create_contract_header',
2754: 'Billing account not related, create billing contact.'

Line 2752: fnd_log.STRING (fnd_log.level_event,

2748: x_party_id => l_third_party_id
2749: );
2750: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2751: THEN
2752: fnd_log.STRING (fnd_log.level_event,
2753: g_module_current || 'oks_mass_update.create_contract_header',
2754: 'Billing account not related, create billing contact.'
2755: || l_third_party_id);
2756: END IF;

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

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

Line 2842: fnd_log.STRING (fnd_log.level_event,

2838: j := j + 3;
2839: ELSE
2840: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2841: THEN
2842: fnd_log.STRING (fnd_log.level_event,
2843: g_module_current || 'oks_mass_update.create_contract_header',
2844: 'Billing account are related, create billing contact.');
2845: END IF;
2846:

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

2900:
2901: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_chr_pvt.insert_row_upg , status = ( '
2902: || l_return_status || ' )');
2903:
2904: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2905: THEN
2906: fnd_log.STRING (fnd_log.level_event,
2907: g_module_current || 'oks_mass_update.create_contract_header',
2908: 'okc_chr_pvt.insert_row_upg, status = ('

Line 2906: fnd_log.STRING (fnd_log.level_event,

2902: || l_return_status || ' )');
2903:
2904: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2905: THEN
2906: fnd_log.STRING (fnd_log.level_event,
2907: g_module_current || 'oks_mass_update.create_contract_header',
2908: 'okc_chr_pvt.insert_row_upg, status = ('
2909: || l_return_status || ')');
2910: END IF;

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

2965: price_uom(i));
2966:
2967: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks header table records sucessfully');
2968:
2969: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2970: THEN
2971: fnd_log.STRING (fnd_log.level_event,
2972: g_module_current || 'oks_mass_update.create_contract_header',
2973: 'oks_chr_pvt.insert_row_upg, status = ('

Line 2971: fnd_log.STRING (fnd_log.level_event,

2967: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks header table records sucessfully');
2968:
2969: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2970: THEN
2971: fnd_log.STRING (fnd_log.level_event,
2972: g_module_current || 'oks_mass_update.create_contract_header',
2973: 'oks_chr_pvt.insert_row_upg, status = ('
2974: || l_return_status || ')');
2975: END IF;

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

2984:
2985: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_cpl_pvt.insert_row_upg , status = ( '
2986: || l_return_status || ' )');
2987:
2988: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2989: THEN
2990: fnd_log.STRING (fnd_log.level_event,
2991: g_module_current || 'oks_mass_update.create_contract_header',
2992: 'okc_cpl_pvt.insert_row_upg, status = ('

Line 2990: fnd_log.STRING (fnd_log.level_event,

2986: || l_return_status || ' )');
2987:
2988: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
2989: THEN
2990: fnd_log.STRING (fnd_log.level_event,
2991: g_module_current || 'oks_mass_update.create_contract_header',
2992: 'okc_cpl_pvt.insert_row_upg, status = ('
2993: || l_return_status || ')');
2994: END IF;

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

3008:
3009: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_ctc_pvt.insert_row_upg , status = ( '
3010: || l_return_status || ' )');
3011:
3012: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3013: THEN
3014: fnd_log.STRING (fnd_log.level_event,
3015: g_module_current || 'oks_mass_update.create_contract_header',
3016: 'okc_ctc_pvt.insert_row_upg, status = ('

Line 3014: fnd_log.STRING (fnd_log.level_event,

3010: || l_return_status || ' )');
3011:
3012: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3013: THEN
3014: fnd_log.STRING (fnd_log.level_event,
3015: g_module_current || 'oks_mass_update.create_contract_header',
3016: 'okc_ctc_pvt.insert_row_upg, status = ('
3017: || l_return_status || ')');
3018: END IF;

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

3032:
3033: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_gve_pvt.insert_row_upg , status = ( '
3034: || l_return_status || ' )');
3035:
3036: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3037: THEN
3038: fnd_log.STRING (fnd_log.level_event,
3039: g_module_current || 'oks_mass_update.create_contract_header',
3040: 'okc_gve_pvt.insert_row_upg, status = ('

Line 3038: fnd_log.STRING (fnd_log.level_event,

3034: || l_return_status || ' )');
3035:
3036: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3037: THEN
3038: fnd_log.STRING (fnd_log.level_event,
3039: g_module_current || 'oks_mass_update.create_contract_header',
3040: 'okc_gve_pvt.insert_row_upg, status = ('
3041: || l_return_status || ')');
3042: END IF;

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

3055:
3056: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_cps_pvt.insert_row_upg , status = ( '
3057: || l_return_status || ' )');
3058:
3059: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3060: THEN
3061: fnd_log.STRING (fnd_log.level_event,
3062: g_module_current || 'oks_mass_update.create_contract_header',
3063: 'okc_cps_pvt.insert_row_upg, status = ('

Line 3061: fnd_log.STRING (fnd_log.level_event,

3057: || l_return_status || ' )');
3058:
3059: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3060: THEN
3061: fnd_log.STRING (fnd_log.level_event,
3062: g_module_current || 'oks_mass_update.create_contract_header',
3063: 'okc_cps_pvt.insert_row_upg, status = ('
3064: || l_return_status || ')');
3065: END IF;

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

3078:
3079: fnd_file.put_line(fnd_file.log,'(OKS) -> Call to okc_cgc_pvt.insert_row_upg , status = ( '
3080: || l_return_status || ' )');
3081:
3082: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3083: THEN
3084: fnd_log.STRING (fnd_log.level_event,
3085: g_module_current || 'oks_mass_update.create_contract_header',
3086: 'okc_cgc_pvt.insert_row_upg, status = ('

Line 3084: fnd_log.STRING (fnd_log.level_event,

3080: || l_return_status || ' )');
3081:
3082: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3083: THEN
3084: fnd_log.STRING (fnd_log.level_event,
3085: g_module_current || 'oks_mass_update.create_contract_header',
3086: 'okc_cgc_pvt.insert_row_upg, status = ('
3087: || l_return_status || ')');
3088: END IF;

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

3133: fnd_global.user_id
3134: );
3135: fnd_file.put_line(fnd_file.log,'(OKS) -> Created access sucessfully');
3136:
3137: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3138: THEN
3139: fnd_log.STRING (fnd_log.level_event,
3140: g_module_current || 'oks_mass_update.create_contract_header',
3141: 'AFter creating the access for each contract');

Line 3139: fnd_log.STRING (fnd_log.level_event,

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

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

3187: SYSDATE
3188: );
3189: fnd_file.put_line(fnd_file.log,'(OKS) -> Created sales credits sucessfully');
3190:
3191: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3192: THEN
3193: fnd_log.STRING (fnd_log.level_event,
3194: g_module_current || 'oks_mass_update.create_contract_header',
3195: 'AFter inserting sales credits for header');

Line 3193: fnd_log.STRING (fnd_log.level_event,

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

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

3361: BEGIN
3362: l_return_status := okc_api.g_ret_sts_success;
3363:
3364: l_Tlineno_new := 0;
3365: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3366: THEN
3367: fnd_log.STRING (fnd_log.level_event,
3368: g_module_current || 'oks_mass_update.create_contract_Line',
3369: 'Begin');

Line 3367: fnd_log.STRING (fnd_log.level_event,

3363:
3364: l_Tlineno_new := 0;
3365: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3366: THEN
3367: fnd_log.STRING (fnd_log.level_event,
3368: g_module_current || 'oks_mass_update.create_contract_Line',
3369: 'Begin');
3370: END IF;
3371:

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

3400:
3401: ;
3402:
3403: CLOSE get_srv_details_csr;
3404: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3405: THEN
3406: fnd_log.STRING (fnd_log.level_event,
3407: g_module_current || 'oks_mass_update.create_contract_Line',
3408: 'Impacted lines count = ( ' || srvline_id.COUNT ||')');

Line 3406: fnd_log.STRING (fnd_log.level_event,

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

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

3490:
3491: );
3492: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc line table records sucessfully');
3493:
3494: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3495: THEN
3496: fnd_log.STRING (fnd_log.level_event,
3497: g_module_current || 'oks_mass_update.create_contract_Line',
3498: 'After insert into okc_k_lines_b table ');

Line 3496: fnd_log.STRING (fnd_log.level_event,

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

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

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

Line 3537: fnd_log.STRING (fnd_log.level_event,

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

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

3594: );
3595:
3596: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc item records sucessfully');
3597:
3598: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3599: THEN
3600: fnd_log.STRING (fnd_log.level_event,
3601: g_module_current || 'oks_mass_update.create_contract_Line',
3602: 'After insert into okc_k_items table ');

Line 3600: fnd_log.STRING (fnd_log.level_event,

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

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

3637: );
3638:
3639: fnd_file.put_line(fnd_file.log,'(OKS) -> Created oks line table records sucessfully');
3640:
3641: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3642: THEN
3643: fnd_log.STRING (fnd_log.level_event,
3644: g_module_current || 'oks_mass_update.create_contract_Line',
3645: 'After insert into oks_lines table ');

Line 3643: fnd_log.STRING (fnd_log.level_event,

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

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

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

Line 3681: fnd_log.STRING (fnd_log.level_event,

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

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

3726: SYSDATE
3727: );
3728: fnd_file.put_line(fnd_file.log,'(OKS) -> Created sales credits sucessfully');
3729:
3730: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3731: THEN
3732: fnd_log.STRING (fnd_log.level_event,
3733: g_module_current || 'oks_mass_update.create_contract_header',
3734: 'AFter inserting sales credits for header');

Line 3732: fnd_log.STRING (fnd_log.level_event,

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

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

3874: BEGIN
3875: l_return_status := okc_api.g_ret_sts_success;
3876:
3877: l_lineno_new := 0;
3878: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3879: THEN
3880: fnd_log.STRING (fnd_log.level_event,
3881: g_module_current || 'oks_mass_update.create_contract_subLine',
3882: 'Begin');

Line 3880: fnd_log.STRING (fnd_log.level_event,

3876:
3877: l_lineno_new := 0;
3878: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3879: THEN
3880: fnd_log.STRING (fnd_log.level_event,
3881: g_module_current || 'oks_mass_update.create_contract_subLine',
3882: 'Begin');
3883: END IF;
3884:

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

3975:
3976: );
3977: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc line table records sucessfully');
3978:
3979: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3980: THEN
3981: fnd_log.STRING (fnd_log.level_event,
3982: g_module_current || 'oks_mass_update.create_contract_Line',
3983: 'after insert into okc_k_lines table');

Line 3981: fnd_log.STRING (fnd_log.level_event,

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

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

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

Line 4020: fnd_log.STRING (fnd_log.level_event,

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

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

4076: NULL
4077: );
4078: fnd_file.put_line(fnd_file.log,'(OKS) -> Created okc items table records sucessfully');
4079:
4080: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4081: THEN
4082: fnd_log.STRING (fnd_log.level_event,
4083: g_module_current || 'oks_mass_update.create_contract_Line',
4084: 'after insert into okc_k_items table');

Line 4082: fnd_log.STRING (fnd_log.level_event,

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

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

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

Line 4122: fnd_log.STRING (fnd_log.level_event,

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

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

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

Line 4162: fnd_log.STRING (fnd_log.level_event,

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

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

4681:
4682: fnd_file.put_line(fnd_file.log,'(OKS) -> Create coverage for line = ( '
4683: ||Line_ctr||'-> ' ||srvline_id (Line_ctr)||' ) status = ( '||l_return_status || ' )' );
4684:
4685: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4686: THEN
4687: fnd_log.STRING (fnd_log.level_event,
4688: g_module_current || 'oks_mass_update.create_contract_Line',
4689: 'create coverage status = ('|| x_return_status || ')');

Line 4687: fnd_log.STRING (fnd_log.level_event,

4683: ||Line_ctr||'-> ' ||srvline_id (Line_ctr)||' ) status = ( '||l_return_status || ' )' );
4684:
4685: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4686: THEN
4687: fnd_log.STRING (fnd_log.level_event,
4688: g_module_current || 'oks_mass_update.create_contract_Line',
4689: 'create coverage status = ('|| x_return_status || ')');
4690: END IF;
4691: IF NOT l_return_status = okc_api.g_ret_sts_success

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

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

Line 4717: fnd_log.STRING (fnd_log.level_event,

4713: ||Line_ctr||'-> ' ||srvline_id (Line_ctr)||' ) status = ( ' ||l_return_status || ' )' );
4714:
4715: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4716: THEN
4717: fnd_log.STRING (fnd_log.level_event,
4718: g_module_current || 'oks_mass_update.create_contract_Line',
4719: 'create coverage extension status = ('|| x_return_status || ')');
4720: END IF;
4721:

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

4752:
4753: fnd_file.put_line(fnd_file.log,'(OKS) -> Instantiate counters for line = ( '
4754: ||Line_ctr||'-> ' ||srvline_id (Line_ctr)||', '|| srvitm_id (Line_ctr) ||' ) status = ( '||l_return_status || ' )' );
4755:
4756: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4757: THEN
4758: fnd_log.STRING (fnd_log.level_event,
4759: g_module_current || 'oks_mass_update.create_contract_Line',
4760: 'Instantiate counters status = ('|| l_return_status || ')');

Line 4758: fnd_log.STRING (fnd_log.level_event,

4754: ||Line_ctr||'-> ' ||srvline_id (Line_ctr)||', '|| srvitm_id (Line_ctr) ||' ) status = ( '||l_return_status || ' )' );
4755:
4756: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4757: THEN
4758: fnd_log.STRING (fnd_log.level_event,
4759: g_module_current || 'oks_mass_update.create_contract_Line',
4760: 'Instantiate counters status = ('|| l_return_status || ')');
4761: END IF;
4762:

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

4790:
4791: fnd_file.put_line(fnd_file.log,'(OKS) -> Instantiate events for line = ( '
4792: ||Line_ctr||'-> ' ||srvline_id (Line_ctr)||' ) status = ( '||l_return_status || ' )' );
4793:
4794: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4795: THEN
4796: fnd_log.STRING (fnd_log.level_event,
4797: g_module_current || 'oks_mass_update.create_contract_Line',
4798: 'create events status = ('|| l_return_status || ')');

Line 4796: fnd_log.STRING (fnd_log.level_event,

4792: ||Line_ctr||'-> ' ||srvline_id (Line_ctr)||' ) status = ( '||l_return_status || ' )' );
4793:
4794: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4795: THEN
4796: fnd_log.STRING (fnd_log.level_event,
4797: g_module_current || 'oks_mass_update.create_contract_Line',
4798: 'create events status = ('|| l_return_status || ')');
4799: END IF;
4800:

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

4831: x_sll_tbl_out => l_sll_tbl_out,
4832: x_return_status => l_return_status,
4833: x_msg_count => x_msg_count,
4834: x_msg_data => x_msg_data);
4835: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4836: THEN
4837: fnd_log.STRING (fnd_log.level_event,
4838: g_module_current || 'oks_mass_update.create_billing_schedule',
4839: 'get_billing_schedule'|| x_return_status);

Line 4837: fnd_log.STRING (fnd_log.level_event,

4833: x_msg_count => x_msg_count,
4834: x_msg_data => x_msg_data);
4835: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4836: THEN
4837: fnd_log.STRING (fnd_log.level_event,
4838: g_module_current || 'oks_mass_update.create_billing_schedule',
4839: 'get_billing_schedule'|| x_return_status);
4840: END IF;
4841: IF NOT l_return_status = 'S'

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

4886: x_duration => l_duration,
4887: x_timeunit => l_timeunit,
4888: x_return_status => l_return_status
4889: );
4890: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4891: THEN
4892: fnd_log.STRING (fnd_log.level_event,
4893: g_module_current || 'oks_mass_update.create_billing_schedule',
4894: 'get_duration'|| l_return_status);

Line 4892: fnd_log.STRING (fnd_log.level_event,

4888: x_return_status => l_return_status
4889: );
4890: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4891: THEN
4892: fnd_log.STRING (fnd_log.level_event,
4893: g_module_current || 'oks_mass_update.create_billing_schedule',
4894: 'get_duration'|| l_return_status);
4895: END IF;
4896: IF NOT l_return_status = 'S'

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

4924: x_return_status => l_return_status);
4925:
4926: fnd_file.put_line(fnd_file.log,'(OKS) -> OKS_BILL_SCH.create_bill_sch_rules:'||l_return_status );
4927:
4928: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4929: THEN
4930: fnd_log.STRING (fnd_log.level_event,
4931: g_module_current || 'oks_mass_update.create_billing_schedule',
4932: 'create_bill_sch_rules'|| x_return_status);

Line 4930: fnd_log.STRING (fnd_log.level_event,

4926: fnd_file.put_line(fnd_file.log,'(OKS) -> OKS_BILL_SCH.create_bill_sch_rules:'||l_return_status );
4927:
4928: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4929: THEN
4930: fnd_log.STRING (fnd_log.level_event,
4931: g_module_current || 'oks_mass_update.create_billing_schedule',
4932: 'create_bill_sch_rules'|| x_return_status);
4933: END IF;
4934: IF NOT l_return_status = 'S'

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

4970: x_msg_data => x_msg_data,
4971: x_return_status => l_return_status
4972: );
4973:
4974: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4975: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.after_tax',
4976: 'oks_tax_util_pvt.get_tax(Return status = ' ||l_return_status || ')' );
4977: END IF;
4978:

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

4971: x_return_status => l_return_status
4972: );
4973:
4974: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4975: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.after_tax',
4976: 'oks_tax_util_pvt.get_tax(Return status = ' ||l_return_status || ')' );
4977: END IF;
4978:
4979:

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

6816: IF Check_batch_csr%NOTFOUND
6817: THEN
6818: fnd_file.put_line(fnd_file.log,'(OKS) -> No batch rules defined');
6819:
6820: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
6821: THEN
6822: fnd_log.STRING (fnd_log.level_event,
6823: g_module_current || 'oks_mass_update.Update_contracts',
6824: 'No Batch rules defined' );

Line 6822: fnd_log.STRING (fnd_log.level_event,

6818: fnd_file.put_line(fnd_file.log,'(OKS) -> No batch rules defined');
6819:
6820: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
6821: THEN
6822: fnd_log.STRING (fnd_log.level_event,
6823: g_module_current || 'oks_mass_update.Update_contracts',
6824: 'No Batch rules defined' );
6825: END IF;
6826:

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

6866: );
6867:
6868: RAISE G_EXCEPTION_HALT_VALIDATION ;
6869:
6870: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
6871: THEN
6872: fnd_log.STRING (fnd_log.level_event,
6873: g_module_current || 'oks_mass_update.Update_contracts',
6874: 'No Batch rules created' );

Line 6872: fnd_log.STRING (fnd_log.level_event,

6868: RAISE G_EXCEPTION_HALT_VALIDATION ;
6869:
6870: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
6871: THEN
6872: fnd_log.STRING (fnd_log.level_event,
6873: g_module_current || 'oks_mass_update.Update_contracts',
6874: 'No Batch rules created' );
6875: END IF;
6876:

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

6890: P_batch_id
6891: );
6892:
6893: RAISE G_EXCEPTION_HALT_VALIDATION ;
6894: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
6895: THEN
6896: fnd_log.STRING (fnd_log.level_event,
6897: g_module_current || 'oks_mass_update.Update_contracts',
6898: 'No Batch rules created' );

Line 6896: fnd_log.STRING (fnd_log.level_event,

6892:
6893: RAISE G_EXCEPTION_HALT_VALIDATION ;
6894: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
6895: THEN
6896: fnd_log.STRING (fnd_log.level_event,
6897: g_module_current || 'oks_mass_update.Update_contracts',
6898: 'No Batch rules created' );
6899: END IF;
6900: END IF;

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

6903:
6904: fnd_file.put_line(fnd_file.log,'(OKS) -> Batch Type = ( ' || p_batch_type
6905: || ' ) Batch id = ( ' || p_batch_id || ' ) Transfer Option = ( ' || batch_rules_rec.transfer_option|| ' )');
6906:
6907: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
6908: THEN
6909: fnd_log.STRING (fnd_log.level_event,
6910: g_module_current || 'oks_mass_update.Update_contracts',
6911: 'Batch Type = ( '|| p_batch_type || ') Batch id = ( '

Line 6909: fnd_log.STRING (fnd_log.level_event,

6905: || ' ) Batch id = ( ' || p_batch_id || ' ) Transfer Option = ( ' || batch_rules_rec.transfer_option|| ' )');
6906:
6907: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
6908: THEN
6909: fnd_log.STRING (fnd_log.level_event,
6910: g_module_current || 'oks_mass_update.Update_contracts',
6911: 'Batch Type = ( '|| p_batch_type || ') Batch id = ( '
6912: || p_batch_id || ')' );
6913: END IF;

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

6993: LOOP
6994: IF hdr_ste(i) = 'HOLD'
6995: THEN
6996: l_found := TRUE;
6997: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6998: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.oks_mass_update.Update_contracts',
6999: ' Contract '||contract_number(i) ||' in QA_HOLD status' );
7000: END IF;
7001:

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

6994: IF hdr_ste(i) = 'HOLD'
6995: THEN
6996: l_found := TRUE;
6997: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6998: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.oks_mass_update.Update_contracts',
6999: ' Contract '||contract_number(i) ||' in QA_HOLD status' );
7000: END IF;
7001:
7002: OKC_API.SET_MESSAGE(

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

7102: p_full_credit => l_full_credit,
7103: x_return_status => l_return_status
7104: );
7105:
7106: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
7107: THEN
7108: fnd_log.STRING (fnd_log.level_event,
7109: g_module_current || 'oks_mass_update.Update_contracts',
7110: 'Terminate_subline status = ( '|| l_return_status);

Line 7108: fnd_log.STRING (fnd_log.level_event,

7104: );
7105:
7106: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
7107: THEN
7108: fnd_log.STRING (fnd_log.level_event,
7109: g_module_current || 'oks_mass_update.Update_contracts',
7110: 'Terminate_subline status = ( '|| l_return_status);
7111: END IF;
7112:

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

7347: LOOP
7348: IF hdr_ste(i) = 'HOLD'
7349: THEN
7350: l_found := TRUE;
7351: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7352: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.oks_mass_update.Update_contracts',
7353: ' Contract '||contract_number(i) ||' in QA_HOLD status' );
7354: END IF;
7355:

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

7348: IF hdr_ste(i) = 'HOLD'
7349: THEN
7350: l_found := TRUE;
7351: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7352: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.oks_mass_update.Update_contracts',
7353: ' Contract '||contract_number(i) ||' in QA_HOLD status' );
7354: END IF;
7355:
7356:

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

7472: );
7473:
7474: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate_subline status = ( '|| l_return_status|| ' )');
7475:
7476: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
7477: THEN
7478: fnd_log.STRING (fnd_log.level_event,
7479: g_module_current || 'oks_mass_update.Update_contracts',
7480: 'Terminate_subline status = ( '|| l_return_status);

Line 7478: fnd_log.STRING (fnd_log.level_event,

7474: fnd_file.put_line(fnd_file.log,'(OKS) -> Terminate_subline status = ( '|| l_return_status|| ' )');
7475:
7476: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
7477: THEN
7478: fnd_log.STRING (fnd_log.level_event,
7479: g_module_current || 'oks_mass_update.Update_contracts',
7480: 'Terminate_subline status = ( '|| l_return_status);
7481: END IF;
7482:

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

7510: x_msg_data => x_msg_data,
7511: x_msg_count => x_msg_count
7512: );
7513:
7514: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
7515: THEN
7516: fnd_log.STRING (fnd_log.level_event,
7517: g_module_current || 'oks_mass_update.Update_contracts',
7518: 'create_contract status = ( '|| l_return_status || ')');

Line 7516: fnd_log.STRING (fnd_log.level_event,

7512: );
7513:
7514: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
7515: THEN
7516: fnd_log.STRING (fnd_log.level_event,
7517: g_module_current || 'oks_mass_update.Update_contracts',
7518: 'create_contract status = ( '|| l_return_status || ')');
7519: END IF;
7520:

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

7594: x_return_status => l_return_status,
7595: x_msg_count => l_msg_count,
7596: x_msg_data => l_msg_data
7597: );
7598: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
7599: THEN
7600: fnd_log.STRING (fnd_log.level_event,
7601: g_module_current || 'oks_mass_update.Update_contracts',
7602: 'create_transaction_source(transfer) status = ( '|| l_return_status || ')');

Line 7600: fnd_log.STRING (fnd_log.level_event,

7596: x_msg_data => l_msg_data
7597: );
7598: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
7599: THEN
7600: fnd_log.STRING (fnd_log.level_event,
7601: g_module_current || 'oks_mass_update.Update_contracts',
7602: 'create_transaction_source(transfer) status = ( '|| l_return_status || ')');
7603: END IF;
7604:

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

7639: x_msg_count => l_msg_count,
7640: x_msg_data => l_msg_data
7641: );
7642:
7643: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
7644: THEN
7645: fnd_log.STRING (fnd_log.level_statement,
7646: g_module_current || 'oks_mass_update.Update_contracts',
7647: 'create_transaction_source (Renewal) status = ( '|| l_return_status || ')');

Line 7645: fnd_log.STRING (fnd_log.level_statement,

7641: );
7642:
7643: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
7644: THEN
7645: fnd_log.STRING (fnd_log.level_statement,
7646: g_module_current || 'oks_mass_update.Update_contracts',
7647: 'create_transaction_source (Renewal) status = ( '|| l_return_status || ')');
7648: END IF;
7649:

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

7982: LOOP
7983: IF idc_date(i) IS NULL
7984: THEN
7985: l_return_status := OKC_API.G_RET_STS_WARNING;
7986: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7987: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.IB_INTERFACE',
7988: 'Installation date changed to null ' );
7989: End If;
7990: OKC_API.set_message(G_APP_NAME,'OKS_NULL_INSTALLATION_DATE');

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

7983: IF idc_date(i) IS NULL
7984: THEN
7985: l_return_status := OKC_API.G_RET_STS_WARNING;
7986: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7987: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.IB_INTERFACE',
7988: 'Installation date changed to null ' );
7989: End If;
7990: OKC_API.set_message(G_APP_NAME,'OKS_NULL_INSTALLATION_DATE');
7991: Raise G_EXCEPTION_HALT_VALIDATION;

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

8001: ,'CONTRACTLINE',line_number(i)
8002: ,'INSTANCE',custprod_id (i)
8003: );
8004:
8005: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8006: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.UPDATE_CONTRACT_IDC.ERROR',
8007: 'SR is logged '||',status = ' || l_return_status);
8008: END IF;
8009:

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

8002: ,'INSTANCE',custprod_id (i)
8003: );
8004:
8005: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8006: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.UPDATE_CONTRACT_IDC.ERROR',
8007: 'SR is logged '||',status = ' || l_return_status);
8008: END IF;
8009:
8010:

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

8354: LOOP
8355: IF hdr_ste(i) = 'HOLD'
8356: THEN
8357: l_found := TRUE;
8358: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8359: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.oks_mass_update.Update_contracts',
8360: ' Contract '||contract_number(i) ||' in QA_HOLD status' );
8361: END IF;
8362:

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

8355: IF hdr_ste(i) = 'HOLD'
8356: THEN
8357: l_found := TRUE;
8358: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
8359: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.oks_mass_update.Update_contracts',
8360: ' Contract '||contract_number(i) ||' in QA_HOLD status' );
8361: END IF;
8362:
8363: OKC_API.SET_MESSAGE(