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_RENCPY_PVT dependencies on FND_LOG

Line 979: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN

975: -- end added bug 5139719
976:
977: BEGIN
978:
979: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
980: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_old_cle_id='||p_old_cle_id||' ,p_cle_id='||p_cle_id||' ,p_chr_id='||p_chr_id);
981: END IF;
982:
983: x_return_status := l_return_status;

Line 980: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_old_cle_id='||p_old_cle_id||' ,p_cle_id='||p_cle_id||' ,p_chr_id='||p_chr_id);

976:
977: BEGIN
978:
979: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
980: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_old_cle_id='||p_old_cle_id||' ,p_cle_id='||p_cle_id||' ,p_chr_id='||p_chr_id);
981: END IF;
982:
983: x_return_status := l_return_status;
984: IF FND_API.to_boolean(p_init_msg_list ) THEN

Line 996: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

992: ELSE
993: l_dnz_chr_id := p_chr_id;
994: END IF;
995:
996: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
997: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.get_line_details', 'calling get_klnv_rec' );
998: END IF;
999:
1000: l_return_status := get_klnv_rec(

Line 997: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.get_line_details', 'calling get_klnv_rec' );

993: l_dnz_chr_id := p_chr_id;
994: END IF;
995:
996: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
997: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.get_line_details', 'calling get_klnv_rec' );
998: END IF;
999:
1000: l_return_status := get_klnv_rec(
1001: p_old_cle_id => p_old_cle_id,

Line 1019: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1015: CLOSE cur_hdr_uom;
1016: l_klnv_rec.price_uom := l_price_uom;
1017: -- end added bug 5139719
1018:
1019: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1020: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_oks_line', 'calling OKS_CONTRACT_LINE_PUB.create_line' );
1021: END IF;
1022:
1023: OKS_CONTRACT_LINE_PUB.create_line(

Line 1020: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_oks_line', 'calling OKS_CONTRACT_LINE_PUB.create_line' );

1016: l_klnv_rec.price_uom := l_price_uom;
1017: -- end added bug 5139719
1018:
1019: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1020: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_oks_line', 'calling OKS_CONTRACT_LINE_PUB.create_line' );
1021: END IF;
1022:
1023: OKS_CONTRACT_LINE_PUB.create_line(
1024: p_api_version => 1.0,

Line 1033: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1029: p_klnv_rec => l_klnv_rec,
1030: x_klnv_rec => x_klnv_rec,
1031: p_validate_yn => 'N');
1032:
1033: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1034: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_oks_line', 'after call to OKS_CONTRACT_LINE_PUB.create_line, l_return_status='||l_return_status);
1035: END IF;
1036:
1037: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

Line 1034: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_oks_line', 'after call to OKS_CONTRACT_LINE_PUB.create_line, l_return_status='||l_return_status);

1030: x_klnv_rec => x_klnv_rec,
1031: p_validate_yn => 'N');
1032:
1033: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1034: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_oks_line', 'after call to OKS_CONTRACT_LINE_PUB.create_line, l_return_status='||l_return_status);
1035: END IF;
1036:
1037: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1038: x_return_status := l_return_status;

Line 1047: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1043:
1044: --add call to copy trxn_extension_id
1045: IF (l_klnv_rec.trxn_extension_id IS NOT NULL) THEN
1046:
1047: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1048: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.copy_cc', 'calling create_tansaction_extension, p_order_id='||p_cle_id||' ,p_old_trx_ext_id='||l_klnv_rec.trxn_extension_id||
1049: ' ,p_cust_acct_id='||p_cust_acct_id||' ,p_bill_to_site_use_id='||p_bill_to_site_use_id);
1050: END IF;
1051:

Line 1048: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.copy_cc', 'calling create_tansaction_extension, p_order_id='||p_cle_id||' ,p_old_trx_ext_id='||l_klnv_rec.trxn_extension_id||

1044: --add call to copy trxn_extension_id
1045: IF (l_klnv_rec.trxn_extension_id IS NOT NULL) THEN
1046:
1047: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1048: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.copy_cc', 'calling create_tansaction_extension, p_order_id='||p_cle_id||' ,p_old_trx_ext_id='||l_klnv_rec.trxn_extension_id||
1049: ' ,p_cust_acct_id='||p_cust_acct_id||' ,p_bill_to_site_use_id='||p_bill_to_site_use_id);
1050: END IF;
1051:
1052: create_trxn_extn(

Line 1064: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1060: p_cust_acct_id => p_cust_acct_id,
1061: p_bill_to_site_use_id => p_bill_to_site_use_id,
1062: x_trx_ext_id => l_trx_ext_id);
1063:
1064: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1065: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.copy_cc', 'after call to create_tansaction_extension, x_return_status='||l_return_status||' ,x_trx_ext_id='||l_trx_ext_id);
1066: END IF;
1067:
1068: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

Line 1065: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.copy_cc', 'after call to create_tansaction_extension, x_return_status='||l_return_status||' ,x_trx_ext_id='||l_trx_ext_id);

1061: p_bill_to_site_use_id => p_bill_to_site_use_id,
1062: x_trx_ext_id => l_trx_ext_id);
1063:
1064: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1065: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.copy_cc', 'after call to create_tansaction_extension, x_return_status='||l_return_status||' ,x_trx_ext_id='||l_trx_ext_id);
1066: END IF;
1067:
1068: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1069: x_return_status := l_return_status;

Line 1081: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN

1077: WHERE cle_id = p_cle_id;
1078:
1079: END IF;
1080:
1081: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1082: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);
1083: END IF;
1084:
1085: EXCEPTION

Line 1082: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);

1078:
1079: END IF;
1080:
1081: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1082: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);
1083: END IF;
1084:
1085: EXCEPTION
1086: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 1094: IF(FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level)THEN

1090: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR, G_SQLCODE_TOKEN, SQLCODE, G_SQLERRM_TOKEN, SQLERRM);
1091: -- notify caller of an UNEXPECTED error
1092: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1093:
1094: IF(FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level)THEN
1095: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name||'.end_other_error','x_return_status='||x_return_status);
1096: END IF;
1097:
1098: END copy_rules;

Line 1095: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name||'.end_other_error','x_return_status='||x_return_status);

1091: -- notify caller of an UNEXPECTED error
1092: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1093:
1094: IF(FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level)THEN
1095: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name||'.end_other_error','x_return_status='||x_return_status);
1096: END IF;
1097:
1098: END copy_rules;
1099:

Line 1137: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN

1133: WHERE cle_id = p_from_cle_id;
1134:
1135: BEGIN
1136:
1137: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1138: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin', 'p_from_cle_id='||p_from_cle_id||' ,p_to_cle_id='||p_to_cle_id||' ,p_copy_reference='||p_copy_reference);
1139: END IF;
1140:
1141: x_return_status := l_return_status;

Line 1138: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin', 'p_from_cle_id='||p_from_cle_id||' ,p_to_cle_id='||p_to_cle_id||' ,p_copy_reference='||p_copy_reference);

1134:
1135: BEGIN
1136:
1137: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1138: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin', 'p_from_cle_id='||p_from_cle_id||' ,p_to_cle_id='||p_to_cle_id||' ,p_copy_reference='||p_copy_reference);
1139: END IF;
1140:
1141: x_return_status := l_return_status;
1142: IF FND_API.to_boolean(p_init_msg_list ) THEN

Line 1169: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1165: l_cimv_rec.priced_item_yn := 'N';
1166: END IF;
1167:
1168:
1169: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1170: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.item_details','l_dnz_chr_id='|| l_dnz_chr_id||' ,object1_id1='||l_cimv_rec.OBJECT1_ID1||' ,object1_id2='||l_cimv_rec.OBJECT1_ID2||
1171: ' ,jtot_object1_code='||l_cimv_rec.JTOT_OBJECT1_CODE||' ,uom_code='|| l_cimv_rec.UOM_CODE||' ,exception_yn='||l_cimv_rec.EXCEPTION_YN||' ,number_of_items='||l_cimv_rec.NUMBER_OF_ITEMS||' ,priced_item_yn='||l_cimv_rec.PRICED_ITEM_YN);
1172: END IF;
1173:

Line 1170: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.item_details','l_dnz_chr_id='|| l_dnz_chr_id||' ,object1_id1='||l_cimv_rec.OBJECT1_ID1||' ,object1_id2='||l_cimv_rec.OBJECT1_ID2||

1166: END IF;
1167:
1168:
1169: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1170: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.item_details','l_dnz_chr_id='|| l_dnz_chr_id||' ,object1_id1='||l_cimv_rec.OBJECT1_ID1||' ,object1_id2='||l_cimv_rec.OBJECT1_ID2||
1171: ' ,jtot_object1_code='||l_cimv_rec.JTOT_OBJECT1_CODE||' ,uom_code='|| l_cimv_rec.UOM_CODE||' ,exception_yn='||l_cimv_rec.EXCEPTION_YN||' ,number_of_items='||l_cimv_rec.NUMBER_OF_ITEMS||' ,priced_item_yn='||l_cimv_rec.PRICED_ITEM_YN);
1172: END IF;
1173:
1174: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

Line 1174: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1170: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.item_details','l_dnz_chr_id='|| l_dnz_chr_id||' ,object1_id1='||l_cimv_rec.OBJECT1_ID1||' ,object1_id2='||l_cimv_rec.OBJECT1_ID2||
1171: ' ,jtot_object1_code='||l_cimv_rec.JTOT_OBJECT1_CODE||' ,uom_code='|| l_cimv_rec.UOM_CODE||' ,exception_yn='||l_cimv_rec.EXCEPTION_YN||' ,number_of_items='||l_cimv_rec.NUMBER_OF_ITEMS||' ,priced_item_yn='||l_cimv_rec.PRICED_ITEM_YN);
1172: END IF;
1173:
1174: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1175: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_item','calling OKC_CONTRACT_ITEM_PUB.create_contract_item');
1176: END IF;
1177:
1178: OKC_CONTRACT_ITEM_PUB.create_contract_item(

Line 1175: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_item','calling OKC_CONTRACT_ITEM_PUB.create_contract_item');

1171: ' ,jtot_object1_code='||l_cimv_rec.JTOT_OBJECT1_CODE||' ,uom_code='|| l_cimv_rec.UOM_CODE||' ,exception_yn='||l_cimv_rec.EXCEPTION_YN||' ,number_of_items='||l_cimv_rec.NUMBER_OF_ITEMS||' ,priced_item_yn='||l_cimv_rec.PRICED_ITEM_YN);
1172: END IF;
1173:
1174: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1175: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_item','calling OKC_CONTRACT_ITEM_PUB.create_contract_item');
1176: END IF;
1177:
1178: OKC_CONTRACT_ITEM_PUB.create_contract_item(
1179: p_api_version => p_api_version,

Line 1187: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1183: x_msg_data => x_msg_data,
1184: p_cimv_rec => l_cimv_rec,
1185: x_cimv_rec => x_cimv_rec);
1186:
1187: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1188: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_item','after call to OKC_CONTRACT_ITEM_PUB.create_contract_item, l_return_status='||l_return_status);
1189: END IF;
1190:
1191: x_return_status := l_return_status;

Line 1188: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_item','after call to OKC_CONTRACT_ITEM_PUB.create_contract_item, l_return_status='||l_return_status);

1184: p_cimv_rec => l_cimv_rec,
1185: x_cimv_rec => x_cimv_rec);
1186:
1187: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1188: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_item','after call to OKC_CONTRACT_ITEM_PUB.create_contract_item, l_return_status='||l_return_status);
1189: END IF;
1190:
1191: x_return_status := l_return_status;
1192: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

Line 1203: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1199: p_id2 => l_cimv_rec.object1_id2,
1200: x_name => l_item_name,
1201: x_description => l_item_desc);
1202:
1203: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1204: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_item_error','okc_util.get_name_desc_from_jtfv l_item_name='|| l_item_name);
1205: END IF;
1206:
1207: OKC_API.set_message(G_APP_NAME, 'OKC_ITEM_NOT_COPIED', 'ITEM_NAME', l_item_name);

Line 1204: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_item_error','okc_util.get_name_desc_from_jtfv l_item_name='|| l_item_name);

1200: x_name => l_item_name,
1201: x_description => l_item_desc);
1202:
1203: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1204: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_item_error','okc_util.get_name_desc_from_jtfv l_item_name='|| l_item_name);
1205: END IF;
1206:
1207: OKC_API.set_message(G_APP_NAME, 'OKC_ITEM_NOT_COPIED', 'ITEM_NAME', l_item_name);
1208:

Line 1215: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN

1211: END IF;
1212: END IF;
1213: END LOOP;
1214:
1215: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1216: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);
1217: END IF;
1218:
1219: EXCEPTION

Line 1216: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);

1212: END IF;
1213: END LOOP;
1214:
1215: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1216: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);
1217: END IF;
1218:
1219: EXCEPTION
1220: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 1228: IF(FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level)THEN

1224: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR, G_SQLCODE_TOKEN, SQLCODE, G_SQLERRM_TOKEN, SQLERRM);
1225: -- notify caller of an UNEXPECTED error
1226: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1227:
1228: IF(FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level)THEN
1229: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name||'.end_other_error','x_return_status='||x_return_status);
1230: END IF;
1231:
1232: END copy_items;

Line 1229: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name||'.end_other_error','x_return_status='||x_return_status);

1225: -- notify caller of an UNEXPECTED error
1226: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1227:
1228: IF(FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level)THEN
1229: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name||'.end_other_error','x_return_status='||x_return_status);
1230: END IF;
1231:
1232: END copy_items;
1233:

Line 1396: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN

1392: AND priced_item_yn = 'Y';
1393:
1394: BEGIN
1395:
1396: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1397: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','begin');
1398: END IF;
1399:
1400: OPEN c_lse(px_clev_rec.lse_id);

Line 1397: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','begin');

1393:
1394: BEGIN
1395:
1396: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1397: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','begin');
1398: END IF;
1399:
1400: OPEN c_lse(px_clev_rec.lse_id);
1401: FETCH c_lse INTO l_lty_code, l_priced_yn;

Line 1429: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1425: IF l_cim_id IS NOT NULL THEN
1426: l_return_status := get_cimv_rec(p_cim_id => l_cim_id,
1427: x_cimv_rec => l_cimv_rec);
1428:
1429: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1430: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.validate_item','calling OKC_CONTRACT_ITEM_PUB.validate_contract_item');
1431: END IF;
1432:
1433: OKC_CONTRACT_ITEM_PUB.validate_contract_item(

Line 1430: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.validate_item','calling OKC_CONTRACT_ITEM_PUB.validate_contract_item');

1426: l_return_status := get_cimv_rec(p_cim_id => l_cim_id,
1427: x_cimv_rec => l_cimv_rec);
1428:
1429: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1430: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.validate_item','calling OKC_CONTRACT_ITEM_PUB.validate_contract_item');
1431: END IF;
1432:
1433: OKC_CONTRACT_ITEM_PUB.validate_contract_item(
1434: p_api_version => 1.0,

Line 1441: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1437: x_msg_count => x_msg_count,
1438: x_msg_data => x_msg_data,
1439: p_cimv_rec => l_cimv_rec);
1440:
1441: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1442: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.validate_item','after call to OKC_CONTRACT_ITEM_PUB.validate_contract_item, x_return_status='||l_return_status);
1443: END IF;
1444:
1445: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

Line 1442: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.validate_item','after call to OKC_CONTRACT_ITEM_PUB.validate_contract_item, x_return_status='||l_return_status);

1438: x_msg_data => x_msg_data,
1439: p_cimv_rec => l_cimv_rec);
1440:
1441: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1442: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.validate_item','after call to OKC_CONTRACT_ITEM_PUB.validate_contract_item, x_return_status='||l_return_status);
1443: END IF;
1444:
1445: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1446: px_clev_rec.price_negotiated := NULL;

Line 1455: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN

1451: END IF;
1452: END IF;
1453: --x_clev_rec := l_clev_rec;
1454:
1455: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1456: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','l_return_status='||l_return_status);
1457: END IF;
1458:
1459: EXCEPTION

Line 1456: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','l_return_status='||l_return_status);

1452: END IF;
1453: --x_clev_rec := l_clev_rec;
1454:
1455: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1456: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','l_return_status='||l_return_status);
1457: END IF;
1458:
1459: EXCEPTION
1460: WHEN OTHERS THEN

Line 1464: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

1460: WHEN OTHERS THEN
1461: --x_clev_rec := l_clev_rec;
1462: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1463:
1464: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1465: l_error_text := substr (SQLERRM, 1, 512);
1466: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1467: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1468: END IF;

Line 1466: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

1462: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1463:
1464: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1465: l_error_text := substr (SQLERRM, 1, 512);
1466: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1467: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1468: END IF;
1469:
1470: END get_priced_line_rec;

Line 1512: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN

1508: WHERE Source_Object_Id = p_id;
1509:
1510: BEGIN
1511:
1512: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1513: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_old_cle_id='||p_old_cle_id||' ,p_old_lse_id='||p_old_lse_id||' ,p_start_date='||p_start_date||' ,p_end_date='||p_end_date||' ,p_new_cle_id='||p_new_cle_id);
1514: END IF;
1515:
1516: x_return_status := l_return_status;

Line 1513: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_old_cle_id='||p_old_cle_id||' ,p_old_lse_id='||p_old_lse_id||' ,p_start_date='||p_start_date||' ,p_end_date='||p_end_date||' ,p_new_cle_id='||p_new_cle_id);

1509:
1510: BEGIN
1511:
1512: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1513: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_old_cle_id='||p_old_cle_id||' ,p_old_lse_id='||p_old_lse_id||' ,p_start_date='||p_start_date||' ,p_end_date='||p_end_date||' ,p_new_cle_id='||p_new_cle_id);
1514: END IF;
1515:
1516: x_return_status := l_return_status;
1517: OPEN c_item;

Line 1532: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1528:
1529:
1530: IF (l_found) THEN -- if counter attachted, instantiate it
1531:
1532: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1533: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.inst_ctrs', 'Calling CS_COUNTERS_PUB.autoinstantiate_counters, p_source_object_id_template='||l_item_id||
1534: ' ,p_source_object_id_instance='||p_new_cle_id);
1535: END IF;
1536:

Line 1533: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.inst_ctrs', 'Calling CS_COUNTERS_PUB.autoinstantiate_counters, p_source_object_id_template='||l_item_id||

1529:
1530: IF (l_found) THEN -- if counter attachted, instantiate it
1531:
1532: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1533: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.inst_ctrs', 'Calling CS_COUNTERS_PUB.autoinstantiate_counters, p_source_object_id_template='||l_item_id||
1534: ' ,p_source_object_id_instance='||p_new_cle_id);
1535: END IF;
1536:
1537: CS_COUNTERS_PUB.autoinstantiate_counters(

Line 1549: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1545: p_source_object_id_instance => p_new_cle_id,
1546: x_ctr_grp_id_template => l_ctr_grp_id_template,
1547: x_ctr_grp_id_instance => l_ctr_grp_id_instance);
1548:
1549: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1550: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.inst_ctrs', 'After call to CS_COUNTERS_PUB.autoinstantiate_counters, x_return_status='||l_return_status||' ,x_ctr_grp_id_template='||l_ctr_grp_id_template||
1551: ' ,x_ctr_grp_id_instance='||l_ctr_grp_id_instance);
1552: END IF;
1553:

Line 1550: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.inst_ctrs', 'After call to CS_COUNTERS_PUB.autoinstantiate_counters, x_return_status='||l_return_status||' ,x_ctr_grp_id_template='||l_ctr_grp_id_template||

1546: x_ctr_grp_id_template => l_ctr_grp_id_template,
1547: x_ctr_grp_id_instance => l_ctr_grp_id_instance);
1548:
1549: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1550: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.inst_ctrs', 'After call to CS_COUNTERS_PUB.autoinstantiate_counters, x_return_status='||l_return_status||' ,x_ctr_grp_id_template='||l_ctr_grp_id_template||
1551: ' ,x_ctr_grp_id_instance='||l_ctr_grp_id_instance);
1552: END IF;
1553:
1554: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

Line 1564: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1560: l_instcnd_inp_rec.tmp_ctr_grp_id := l_ctr_grp_id_template;
1561: l_instcnd_inp_rec.jtot_object_code := 'OKC_K_LINE';
1562: l_instcnd_inp_rec.cle_id := p_new_cle_id;
1563:
1564: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1565: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.inst_cond', 'Calling OKC_INST_CND_PUB.inst_condition');
1566: END IF;
1567:
1568: OKC_INST_CND_PUB.inst_condition(

Line 1565: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.inst_cond', 'Calling OKC_INST_CND_PUB.inst_condition');

1561: l_instcnd_inp_rec.jtot_object_code := 'OKC_K_LINE';
1562: l_instcnd_inp_rec.cle_id := p_new_cle_id;
1563:
1564: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1565: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.inst_cond', 'Calling OKC_INST_CND_PUB.inst_condition');
1566: END IF;
1567:
1568: OKC_INST_CND_PUB.inst_condition(
1569: p_api_version => 1.0,

Line 1576: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1572: x_msg_count => x_msg_count,
1573: x_msg_data => x_msg_data,
1574: p_instcnd_inp_rec => l_instcnd_inp_rec);
1575:
1576: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1577: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.inst_cond', 'After call to OKC_INST_CND_PUB.inst_condition, x_return_status='||l_return_status);
1578: END IF;
1579:
1580: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

Line 1577: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.inst_cond', 'After call to OKC_INST_CND_PUB.inst_condition, x_return_status='||l_return_status);

1573: x_msg_data => x_msg_data,
1574: p_instcnd_inp_rec => l_instcnd_inp_rec);
1575:
1576: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1577: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.inst_cond', 'After call to OKC_INST_CND_PUB.inst_condition, x_return_status='||l_return_status);
1578: END IF;
1579:
1580: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1581: x_return_status := l_return_status;

Line 1589: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1585: END IF;
1586: END IF;
1587:
1588:
1589: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1590: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.chk_cov_type','p_old_lse_id='||p_old_lse_id||' ,l_standard_cov_yn='||l_standard_cov_yn);
1591: END IF;
1592:
1593: IF p_old_lse_id IN (1,19) THEN

Line 1590: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.chk_cov_type','p_old_lse_id='||p_old_lse_id||' ,l_standard_cov_yn='||l_standard_cov_yn);

1586: END IF;
1587:
1588:
1589: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1590: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.chk_cov_type','p_old_lse_id='||p_old_lse_id||' ,l_standard_cov_yn='||l_standard_cov_yn);
1591: END IF;
1592:
1593: IF p_old_lse_id IN (1,19) THEN
1594:

Line 1598: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1594:
1595: --Instantiate the coverage, if only if it's a non standard coverage
1596: IF (l_standard_cov_yn = 'N') THEN
1597:
1598: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1599: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_adj_cov','calling OKS_COVERAGES_PUB.create_adjusted_coverage, P_Source_contract_Line_Id='||p_old_cle_id||' ,P_Target_contract_Line_Id='||p_new_cle_id);
1600: END IF;
1601:
1602: OKS_COVERAGES_PUB.create_adjusted_coverage(

Line 1599: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_adj_cov','calling OKS_COVERAGES_PUB.create_adjusted_coverage, P_Source_contract_Line_Id='||p_old_cle_id||' ,P_Target_contract_Line_Id='||p_new_cle_id);

1595: --Instantiate the coverage, if only if it's a non standard coverage
1596: IF (l_standard_cov_yn = 'N') THEN
1597:
1598: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1599: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_adj_cov','calling OKS_COVERAGES_PUB.create_adjusted_coverage, P_Source_contract_Line_Id='||p_old_cle_id||' ,P_Target_contract_Line_Id='||p_new_cle_id);
1600: END IF;
1601:
1602: OKS_COVERAGES_PUB.create_adjusted_coverage(
1603: p_api_version => 1.0,

Line 1612: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1608: P_Source_contract_Line_Id => p_old_cle_id,
1609: P_Target_contract_Line_Id => p_new_cle_id,
1610: x_Actual_coverage_id => l_actual_coverage_id);
1611:
1612: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1613: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_adj_cov','after call to OKS_COVERAGES_PUB.create_adjusted_coverage, x_return_status='||l_return_status||' ,x_Actual_coverage_id='||l_actual_coverage_id);
1614: END IF;
1615:
1616: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

Line 1613: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_adj_cov','after call to OKS_COVERAGES_PUB.create_adjusted_coverage, x_return_status='||l_return_status||' ,x_Actual_coverage_id='||l_actual_coverage_id);

1609: P_Target_contract_Line_Id => p_new_cle_id,
1610: x_Actual_coverage_id => l_actual_coverage_id);
1611:
1612: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1613: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_adj_cov','after call to OKS_COVERAGES_PUB.create_adjusted_coverage, x_return_status='||l_return_status||' ,x_Actual_coverage_id='||l_actual_coverage_id);
1614: END IF;
1615:
1616: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1617: x_return_status := l_return_status;

Line 1633: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1629: --for both standard and non standard coverage, need to copy
1630: --coverage notes and pm schedules. These coverage entities are
1631: --associated to the topline and the not the coverage
1632:
1633: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1634: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_cov_extn','calling OKS_COVERAGES_PVT.create_k_coverage_ext, p_src_line_id='||p_old_cle_id||' ,p_tgt_line_id='||p_new_cle_id);
1635: END IF;
1636:
1637: OKS_COVERAGES_PVT.create_k_coverage_ext(

Line 1634: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_cov_extn','calling OKS_COVERAGES_PVT.create_k_coverage_ext, p_src_line_id='||p_old_cle_id||' ,p_tgt_line_id='||p_new_cle_id);

1630: --coverage notes and pm schedules. These coverage entities are
1631: --associated to the topline and the not the coverage
1632:
1633: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1634: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_cov_extn','calling OKS_COVERAGES_PVT.create_k_coverage_ext, p_src_line_id='||p_old_cle_id||' ,p_tgt_line_id='||p_new_cle_id);
1635: END IF;
1636:
1637: OKS_COVERAGES_PVT.create_k_coverage_ext(
1638: p_api_version => 1.0,

Line 1646: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1642: x_msg_data => x_msg_data,
1643: p_src_line_id => p_old_cle_id,
1644: p_tgt_line_id => p_new_cle_id);
1645:
1646: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1647: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_cov_extn','after call to OKS_COVERAGES_PVT.create_k_coverage_ext, x_return_status='||l_return_status);
1648: END IF;
1649:
1650: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

Line 1647: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_cov_extn','after call to OKS_COVERAGES_PVT.create_k_coverage_ext, x_return_status='||l_return_status);

1643: p_src_line_id => p_old_cle_id,
1644: p_tgt_line_id => p_new_cle_id);
1645:
1646: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1647: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_cov_extn','after call to OKS_COVERAGES_PVT.create_k_coverage_ext, x_return_status='||l_return_status);
1648: END IF;
1649:
1650: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1651: x_return_status := l_return_status;

Line 1657: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN

1653: END IF;
1654:
1655: END IF;
1656:
1657: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1658: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end', 'x_return_status='||x_return_status);
1659: END IF;
1660:
1661: EXCEPTION

Line 1658: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end', 'x_return_status='||x_return_status);

1654:
1655: END IF;
1656:
1657: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1658: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end', 'x_return_status='||x_return_status);
1659: END IF;
1660:
1661: EXCEPTION
1662: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 1663: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

1659: END IF;
1660:
1661: EXCEPTION
1662: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1663: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1664: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_error', 'x_return_status='||x_return_status);
1665: END IF;
1666:
1667: WHEN OTHERS THEN

Line 1664: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_error', 'x_return_status='||x_return_status);

1660:
1661: EXCEPTION
1662: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1663: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1664: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_error', 'x_return_status='||x_return_status);
1665: END IF;
1666:
1667: WHEN OTHERS THEN
1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1670: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

1666:
1667: WHEN OTHERS THEN
1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1669:
1670: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1671: l_error_text := substr (SQLERRM, 1, 512);
1672: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1673: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1674: END IF;

Line 1672: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1669:
1670: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1671: l_error_text := substr (SQLERRM, 1, 512);
1672: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1673: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1674: END IF;
1675:
1676: END instantiate_counters_events;

Line 1715: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN

1711: WHERE id = p_to_chr_id;
1712:
1713: BEGIN
1714:
1715: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1716: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_from_start_date='||p_from_start_date||' ,p_from_end_date='||p_from_end_date||' ,p_to_cle_id='||p_to_cle_id||' ,p_to_chr_id='||p_to_chr_id);
1717: END IF;
1718:
1719: IF NOT (p_to_cle_id IS NULL OR p_to_cle_id = OKC_API.G_MISS_NUM) THEN

Line 1716: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_from_start_date='||p_from_start_date||' ,p_from_end_date='||p_from_end_date||' ,p_to_cle_id='||p_to_cle_id||' ,p_to_chr_id='||p_to_chr_id);

1712:
1713: BEGIN
1714:
1715: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1716: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_from_start_date='||p_from_start_date||' ,p_from_end_date='||p_from_end_date||' ,p_to_cle_id='||p_to_cle_id||' ,p_to_chr_id='||p_to_chr_id);
1717: END IF;
1718:
1719: IF NOT (p_to_cle_id IS NULL OR p_to_cle_id = OKC_API.G_MISS_NUM) THEN
1720: OPEN c_cle;

Line 1733: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN

1729: x_start_date := p_from_end_date + 1;
1730: x_end_date := l_parent_end_date;
1731: END IF;
1732:
1733: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1734: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_start_date='||x_start_date||' ,x_end_date='||x_end_date);
1735: END IF;
1736:
1737: RETURN(TRUE);

Line 1734: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_start_date='||x_start_date||' ,x_end_date='||x_end_date);

1730: x_end_date := l_parent_end_date;
1731: END IF;
1732:
1733: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1734: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_start_date='||x_start_date||' ,x_end_date='||x_end_date);
1735: END IF;
1736:
1737: RETURN(TRUE);
1738:

Line 1793: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1789: l_cvn_type_exists BOOLEAN := FALSE;
1790: BEGIN
1791: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1792:
1793: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1794: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.GET_CVN_DTLS.begin', 'p_chr_id='||p_chr_id);
1795: END IF;
1796:
1797: FOR cvn_rec IN cvn_cur

Line 1794: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.GET_CVN_DTLS.begin', 'p_chr_id='||p_chr_id);

1790: BEGIN
1791: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1792:
1793: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1794: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.GET_CVN_DTLS.begin', 'p_chr_id='||p_chr_id);
1795: END IF;
1796:
1797: FOR cvn_rec IN cvn_cur
1798: LOOP

Line 1809: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1805:
1806: IF l_cvn_type_exists THEN
1807: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1808: ELSE
1809: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1810: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.GET_CVN_DTLS.cvn_type_chk','no cvn rule');
1811: END IF;
1812: RAISE G_EXCEPTION_HALT_VALIDATION;
1813: END IF;

Line 1810: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.GET_CVN_DTLS.cvn_type_chk','no cvn rule');

1806: IF l_cvn_type_exists THEN
1807: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1808: ELSE
1809: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1810: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.GET_CVN_DTLS.cvn_type_chk','no cvn rule');
1811: END IF;
1812: RAISE G_EXCEPTION_HALT_VALIDATION;
1813: END IF;
1814:

Line 1815: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1811: END IF;
1812: RAISE G_EXCEPTION_HALT_VALIDATION;
1813: END IF;
1814:
1815: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1816: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.GET_CVN_DTLS.end', 'x_return_status='||x_return_status||' ,x_cvn_type='||x_cvn_type||' ,x_cvn_date='||x_cvn_date||' ,x_cvn_rate='||x_cvn_rate);
1817: END IF;
1818:
1819: EXCEPTION

Line 1816: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.GET_CVN_DTLS.end', 'x_return_status='||x_return_status||' ,x_cvn_type='||x_cvn_type||' ,x_cvn_date='||x_cvn_date||' ,x_cvn_rate='||x_cvn_rate);

1812: RAISE G_EXCEPTION_HALT_VALIDATION;
1813: END IF;
1814:
1815: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1816: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.GET_CVN_DTLS.end', 'x_return_status='||x_return_status||' ,x_cvn_type='||x_cvn_type||' ,x_cvn_date='||x_cvn_date||' ,x_cvn_rate='||x_cvn_rate);
1817: END IF;
1818:
1819: EXCEPTION
1820: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 1822: IF(FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level)THEN

1818:
1819: EXCEPTION
1820: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1821: x_return_status := OKC_API.G_RET_STS_ERROR;
1822: IF(FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level)THEN
1823: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name||'.GET_CVN_DTLS.end_error', 'x_return_status='||x_return_status);
1824: END IF;
1825: WHEN OTHERS THEN
1826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1823: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name||'.GET_CVN_DTLS.end_error', 'x_return_status='||x_return_status);

1819: EXCEPTION
1820: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1821: x_return_status := OKC_API.G_RET_STS_ERROR;
1822: IF(FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level)THEN
1823: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name||'.GET_CVN_DTLS.end_error', 'x_return_status='||x_return_status);
1824: END IF;
1825: WHEN OTHERS THEN
1826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1827:

Line 1828: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

1824: END IF;
1825: WHEN OTHERS THEN
1826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1827:
1828: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1829: l_error_text := substr (SQLERRM, 1, 512);
1830: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.GET_CVN_DTLS.end_other_error', l_error_text);
1831: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1832: END IF;

Line 1830: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.GET_CVN_DTLS.end_other_error', l_error_text);

1826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1827:
1828: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1829: l_error_text := substr (SQLERRM, 1, 512);
1830: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.GET_CVN_DTLS.end_other_error', l_error_text);
1831: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1832: END IF;
1833:
1834: END GET_CVN_DTLS;

Line 1838: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN

1834: END GET_CVN_DTLS;
1835:
1836: BEGIN
1837:
1838: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1839: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_from_cle_id='||p_from_cle_id);
1840: END IF;
1841:
1842: l_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1839: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_from_cle_id='||p_from_cle_id);

1835:
1836: BEGIN
1837:
1838: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1839: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_from_cle_id='||p_from_cle_id);
1840: END IF;
1841:
1842: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1843:

Line 1855: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1851: x_cvn_date => l_cvn_date,
1852: x_cvn_rate => l_cvn_rate,
1853: x_return_status => l_return_status);
1854:
1855: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1856: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_cvn_dtls','l_return_status='|| l_return_status);
1857: END IF;
1858:
1859: x_return_status := l_return_status;

Line 1856: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_cvn_dtls','l_return_status='|| l_return_status);

1852: x_cvn_rate => l_cvn_rate,
1853: x_return_status => l_return_status);
1854:
1855: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1856: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_cvn_dtls','l_return_status='|| l_return_status);
1857: END IF;
1858:
1859: x_return_status := l_return_status;
1860:

Line 1863: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1859: x_return_status := l_return_status;
1860:
1861: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1862:
1863: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1864: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.convert','Calling OKC_CURRENCY_API.convert_amount, p_from_currency='||l_curr_code||' ,p_to_currency=EUR ,p_conversion_date='||l_cvn_date||
1865: ' ,p_conversion_type='||l_cvn_type||' ,p_amount='||l_old_amount);
1866: END IF;
1867:

Line 1864: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.convert','Calling OKC_CURRENCY_API.convert_amount, p_from_currency='||l_curr_code||' ,p_to_currency=EUR ,p_conversion_date='||l_cvn_date||

1860:
1861: IF l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
1862:
1863: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1864: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.convert','Calling OKC_CURRENCY_API.convert_amount, p_from_currency='||l_curr_code||' ,p_to_currency=EUR ,p_conversion_date='||l_cvn_date||
1865: ' ,p_conversion_type='||l_cvn_type||' ,p_amount='||l_old_amount);
1866: END IF;
1867:
1868: OKC_CURRENCY_API.convert_amount(

Line 1879: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1875: x_converted_amount => px_clev_rec.price_negotiated);
1876:
1877: px_clev_rec.currency_code := 'EUR';
1878:
1879: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1880: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.convert','after call to OKC_CURRENCY_API.convert_amount, x_conversion_rate='||l_cvn_rate||' ,x_converted_amount='||px_clev_rec.price_negotiated);
1881: END IF;
1882:
1883: END IF;

Line 1880: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.convert','after call to OKC_CURRENCY_API.convert_amount, x_conversion_rate='||l_cvn_rate||' ,x_converted_amount='||px_clev_rec.price_negotiated);

1876:
1877: px_clev_rec.currency_code := 'EUR';
1878:
1879: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1880: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.convert','after call to OKC_CURRENCY_API.convert_amount, x_conversion_rate='||l_cvn_rate||' ,x_converted_amount='||px_clev_rec.price_negotiated);
1881: END IF;
1882:
1883: END IF;
1884:

Line 1885: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN

1881: END IF;
1882:
1883: END IF;
1884:
1885: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1886: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);
1887: END IF;
1888:
1889: EXCEPTION

Line 1886: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);

1882:
1883: END IF;
1884:
1885: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1886: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);
1887: END IF;
1888:
1889: EXCEPTION
1890:

Line 1894: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

1890:
1891: WHEN OTHERS THEN
1892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1893:
1894: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1895: l_error_text := substr (SQLERRM, 1, 512);
1896: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1897: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1898: END IF;

Line 1896: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

1892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1893:
1894: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1895: l_error_text := substr (SQLERRM, 1, 512);
1896: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1897: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1898: END IF;
1899:
1900: END do_price_conversion;

Line 1904: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN

1900: END do_price_conversion;
1901:
1902: BEGIN
1903:
1904: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1905: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_from_cle_id='||p_from_cle_id||' ,p_from_chr_id='||p_from_chr_id||' ,p_to_cle_id='||p_to_cle_id||' ,p_to_chr_id='||p_to_chr_id||' ,p_lse_id='||p_lse_id||
1906: ' ,p_to_template_yn='||p_to_template_yn||' ,p_copy_reference='||p_copy_reference||' ,p_copy_line_party_yn='||p_copy_line_party_yn||' ,p_renew_ref_yn='||p_renew_ref_yn||' ,p_need_conversion='||p_need_conversion);
1907: END IF;
1908:

Line 1905: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_from_cle_id='||p_from_cle_id||' ,p_from_chr_id='||p_from_chr_id||' ,p_to_cle_id='||p_to_cle_id||' ,p_to_chr_id='||p_to_chr_id||' ,p_lse_id='||p_lse_id||

1901:
1902: BEGIN
1903:
1904: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
1905: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_from_cle_id='||p_from_cle_id||' ,p_from_chr_id='||p_from_chr_id||' ,p_to_cle_id='||p_to_cle_id||' ,p_to_chr_id='||p_to_chr_id||' ,p_lse_id='||p_lse_id||
1906: ' ,p_to_template_yn='||p_to_template_yn||' ,p_copy_reference='||p_copy_reference||' ,p_copy_line_party_yn='||p_copy_line_party_yn||' ,p_renew_ref_yn='||p_renew_ref_yn||' ,p_need_conversion='||p_need_conversion);
1907: END IF;
1908:
1909: --standard api initilization and checks

Line 1919: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1915: FND_MSG_PUB.initialize;
1916: END IF;
1917: x_return_status := FND_API.G_RET_STS_SUCCESS;
1918:
1919: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1920: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.get_clev_rec', 'Calling get_clev_rec p_cle_id='||p_from_cle_id);
1921: END IF;
1922:
1923: l_return_status := get_clev_rec(p_cle_id => p_from_cle_id,

Line 1920: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.get_clev_rec', 'Calling get_clev_rec p_cle_id='||p_from_cle_id);

1916: END IF;
1917: x_return_status := FND_API.G_RET_STS_SUCCESS;
1918:
1919: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1920: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.get_clev_rec', 'Calling get_clev_rec p_cle_id='||p_from_cle_id);
1921: END IF;
1922:
1923: l_return_status := get_clev_rec(p_cle_id => p_from_cle_id,
1924: x_clev_rec => l_clev_rec);

Line 1926: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1922:
1923: l_return_status := get_clev_rec(p_cle_id => p_from_cle_id,
1924: x_clev_rec => l_clev_rec);
1925:
1926: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1927: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.get_clev_rec', 'After get_clev_rec l_clev_rec.date_renewed='||l_clev_rec.date_renewed);
1928: END IF;
1929:
1930: --

Line 1927: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.get_clev_rec', 'After get_clev_rec l_clev_rec.date_renewed='||l_clev_rec.date_renewed);

1923: l_return_status := get_clev_rec(p_cle_id => p_from_cle_id,
1924: x_clev_rec => l_clev_rec);
1925:
1926: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1927: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.get_clev_rec', 'After get_clev_rec l_clev_rec.date_renewed='||l_clev_rec.date_renewed);
1928: END IF;
1929:
1930: --
1931: -- If copy called for renewal, do not copy renewed lines

Line 1970: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1966: l_clev_rec.line_number := nvl(l_clev_rec.line_number, 0) + 1;
1967:
1968: END; -- End of line numbering
1969:
1970: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1971: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.line_numbering', 'l_clev_rec.line_number='||l_clev_rec.line_number);
1972: END IF;
1973:
1974: l_clev_rec.payment_instruction_type := NULL; --null out the payment instructions

Line 1971: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.line_numbering', 'l_clev_rec.line_number='||l_clev_rec.line_number);

1967:
1968: END; -- End of line numbering
1969:
1970: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1971: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.line_numbering', 'l_clev_rec.line_number='||l_clev_rec.line_number);
1972: END IF;
1973:
1974: l_clev_rec.payment_instruction_type := NULL; --null out the payment instructions
1975: l_clev_rec.orig_system_id1 := l_clev_rec.id;

Line 1990: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

1986: x_return_status => l_return_status,
1987: p_status_type => 'ENTERED',
1988: x_status_code => l_sts_code);
1989:
1990: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1991: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.default_status', 'after call to OKC_ASSENT_PUB.get_default_status, p_status_type=ENTERED, x_status_code='||l_sts_code);
1992: END IF;
1993:
1994: l_clev_rec.sts_code := l_sts_code;

Line 1991: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.default_status', 'after call to OKC_ASSENT_PUB.get_default_status, p_status_type=ENTERED, x_status_code='||l_sts_code);

1987: p_status_type => 'ENTERED',
1988: x_status_code => l_sts_code);
1989:
1990: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
1991: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.default_status', 'after call to OKC_ASSENT_PUB.get_default_status, p_status_type=ENTERED, x_status_code='||l_sts_code);
1992: END IF;
1993:
1994: l_clev_rec.sts_code := l_sts_code;
1995:

Line 2035: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

2031: IF p_need_conversion = 'Y' THEN
2032: IF (l_clev_rec.price_negotiated IS NULL OR
2033: l_clev_rec.price_negotiated = 0 ) THEN
2034: --- only change the currency code
2035: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2036: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.curr_conv','price_negotiated is 0, only changing currency code to EUR');
2037: END IF;
2038: l_clev_rec.currency_code := 'EUR';
2039: ELSE

Line 2036: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.curr_conv','price_negotiated is 0, only changing currency code to EUR');

2032: IF (l_clev_rec.price_negotiated IS NULL OR
2033: l_clev_rec.price_negotiated = 0 ) THEN
2034: --- only change the currency code
2035: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2036: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.curr_conv','price_negotiated is 0, only changing currency code to EUR');
2037: END IF;
2038: l_clev_rec.currency_code := 'EUR';
2039: ELSE
2040:

Line 2041: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

2037: END IF;
2038: l_clev_rec.currency_code := 'EUR';
2039: ELSE
2040:
2041: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2042: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.curr_conv','Calling do_price_conversion');
2043: END IF;
2044: do_price_conversion(l_clev_rec, l_return_status);
2045:

Line 2042: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.curr_conv','Calling do_price_conversion');

2038: l_clev_rec.currency_code := 'EUR';
2039: ELSE
2040:
2041: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2042: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.curr_conv','Calling do_price_conversion');
2043: END IF;
2044: do_price_conversion(l_clev_rec, l_return_status);
2045:
2046: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

Line 2046: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

2042: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.curr_conv','Calling do_price_conversion');
2043: END IF;
2044: do_price_conversion(l_clev_rec, l_return_status);
2045:
2046: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2047: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.curr_conv','after call to do_price_conversion, l_return_status='||l_return_status);
2048: END IF;
2049:
2050: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

Line 2047: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.curr_conv','after call to do_price_conversion, l_return_status='||l_return_status);

2043: END IF;
2044: do_price_conversion(l_clev_rec, l_return_status);
2045:
2046: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2047: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.curr_conv','after call to do_price_conversion, l_return_status='||l_return_status);
2048: END IF;
2049:
2050: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2051: x_return_status := l_return_status;

Line 2058: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

2054: END IF;
2055: END IF;
2056: -- For EURO CONVERSION
2057:
2058: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2059: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_okc_line','calling OKC_CONTRACT_PUB.create_contract_line, l_clev_rec: lse_id='||l_clev_rec.lse_id||
2060: ' ,start_date='||l_clev_rec.start_date||' ,end_date='||l_clev_rec.end_date||' ,cle_id='||l_clev_rec.cle_id||' ,dnz_chr_id='||l_clev_rec.dnz_chr_id);
2061: END IF;
2062:

Line 2059: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_okc_line','calling OKC_CONTRACT_PUB.create_contract_line, l_clev_rec: lse_id='||l_clev_rec.lse_id||

2055: END IF;
2056: -- For EURO CONVERSION
2057:
2058: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2059: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_okc_line','calling OKC_CONTRACT_PUB.create_contract_line, l_clev_rec: lse_id='||l_clev_rec.lse_id||
2060: ' ,start_date='||l_clev_rec.start_date||' ,end_date='||l_clev_rec.end_date||' ,cle_id='||l_clev_rec.cle_id||' ,dnz_chr_id='||l_clev_rec.dnz_chr_id);
2061: END IF;
2062:
2063: OKC_CONTRACT_PUB.create_contract_line(

Line 2072: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

2068: x_msg_data => x_msg_data,
2069: p_clev_rec => l_clev_rec,
2070: x_clev_rec => x_clev_rec);
2071:
2072: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2073: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_okc_line','after call to OKC_CONTRACT_PUB.create_contract_line, x_return_status='|| l_return_status||' ,x_clev_rec.id='||x_clev_rec.id);
2074: END IF;
2075:
2076: IF (l_return_status NOT IN (OKC_API.G_RET_STS_SUCCESS, OKC_API.G_RET_STS_WARNING)) THEN

Line 2073: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_okc_line','after call to OKC_CONTRACT_PUB.create_contract_line, x_return_status='|| l_return_status||' ,x_clev_rec.id='||x_clev_rec.id);

2069: p_clev_rec => l_clev_rec,
2070: x_clev_rec => x_clev_rec);
2071:
2072: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2073: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_okc_line','after call to OKC_CONTRACT_PUB.create_contract_line, x_return_status='|| l_return_status||' ,x_clev_rec.id='||x_clev_rec.id);
2074: END IF;
2075:
2076: IF (l_return_status NOT IN (OKC_API.G_RET_STS_SUCCESS, OKC_API.G_RET_STS_WARNING)) THEN
2077: x_return_status := l_return_status;

Line 2091: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

2087: x_cle_id := x_clev_rec.id; -- passes the new generated id to the caller.
2088:
2089: --we need to create the oks line before creating non-std cov in the following call to
2090: --instantiate_counters_events
2091: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2092: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_oks_line','Calling copy_rules, p_old_cle_id='||p_from_cle_id||' ,p_cle_id='||x_clev_rec.id||' ,p_chr_id='||l_clev_rec.dnz_chr_id||' ,p_to_template_yn='||p_to_template_yn);
2093: END IF;
2094:
2095: copy_rules (

Line 2092: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_oks_line','Calling copy_rules, p_old_cle_id='||p_from_cle_id||' ,p_cle_id='||x_clev_rec.id||' ,p_chr_id='||l_clev_rec.dnz_chr_id||' ,p_to_template_yn='||p_to_template_yn);

2088:
2089: --we need to create the oks line before creating non-std cov in the following call to
2090: --instantiate_counters_events
2091: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2092: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_oks_line','Calling copy_rules, p_old_cle_id='||p_from_cle_id||' ,p_cle_id='||x_clev_rec.id||' ,p_chr_id='||l_clev_rec.dnz_chr_id||' ,p_to_template_yn='||p_to_template_yn);
2093: END IF;
2094:
2095: copy_rules (
2096: p_api_version => 1.0,

Line 2108: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

2104: p_cust_acct_id => l_clev_rec.cust_acct_id,
2105: p_bill_to_site_use_id => l_clev_rec.bill_to_site_use_id,
2106: p_to_template_yn => p_to_template_yn);
2107:
2108: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2109: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_oks_line','after call to copy_rules, x_return_status='||l_return_status);
2110: END IF;
2111:
2112: IF (l_return_status NOT IN (OKC_API.G_RET_STS_SUCCESS, OKC_API.G_RET_STS_WARNING)) THEN

Line 2109: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_oks_line','after call to copy_rules, x_return_status='||l_return_status);

2105: p_bill_to_site_use_id => l_clev_rec.bill_to_site_use_id,
2106: p_to_template_yn => p_to_template_yn);
2107:
2108: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2109: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.create_oks_line','after call to copy_rules, x_return_status='||l_return_status);
2110: END IF;
2111:
2112: IF (l_return_status NOT IN (OKC_API.G_RET_STS_SUCCESS, OKC_API.G_RET_STS_WARNING)) THEN
2113: x_return_status := l_return_status;

Line 2126: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

2122:
2123: -- instantiate counters
2124: IF l_clev_rec.lse_id IN (1, 14, 19) THEN
2125:
2126: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2127: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.instantiate_ctr_evts','Calling instantiate_counters_events, p_old_cle_id='||l_clev_rec.id||' ,p_old_lse_id='||l_old_lse_id||
2128: ' ,p_start_date='||x_clev_rec.start_date||' ,p_end_date='||x_clev_rec.end_date||' ,p_new_cle_id='||x_clev_rec.id);
2129: END IF;
2130:

Line 2127: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.instantiate_ctr_evts','Calling instantiate_counters_events, p_old_cle_id='||l_clev_rec.id||' ,p_old_lse_id='||l_old_lse_id||

2123: -- instantiate counters
2124: IF l_clev_rec.lse_id IN (1, 14, 19) THEN
2125:
2126: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2127: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.instantiate_ctr_evts','Calling instantiate_counters_events, p_old_cle_id='||l_clev_rec.id||' ,p_old_lse_id='||l_old_lse_id||
2128: ' ,p_start_date='||x_clev_rec.start_date||' ,p_end_date='||x_clev_rec.end_date||' ,p_new_cle_id='||x_clev_rec.id);
2129: END IF;
2130:
2131: instantiate_counters_events(

Line 2141: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

2137: p_start_date => x_clev_rec.start_date,
2138: p_end_date => x_clev_rec.end_date,
2139: p_new_cle_id => x_clev_rec.id);
2140:
2141: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2142: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'instantiate_ctr_evts','after call to instantiate_counters_events, x_return_status='||l_return_status);
2143: END IF;
2144:
2145: IF (l_return_status NOT IN (OKC_API.G_RET_STS_SUCCESS, OKC_API.G_RET_STS_WARNING)) THEN

Line 2142: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'instantiate_ctr_evts','after call to instantiate_counters_events, x_return_status='||l_return_status);

2138: p_end_date => x_clev_rec.end_date,
2139: p_new_cle_id => x_clev_rec.id);
2140:
2141: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2142: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'instantiate_ctr_evts','after call to instantiate_counters_events, x_return_status='||l_return_status);
2143: END IF;
2144:
2145: IF (l_return_status NOT IN (OKC_API.G_RET_STS_SUCCESS, OKC_API.G_RET_STS_WARNING)) THEN
2146: x_return_status := l_return_status;

Line 2161: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

2157:
2158:
2159: FOR l_c_pavv IN c_pavv LOOP
2160:
2161: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2162: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.price_att_values','Calling copy_price_att_values, p_pav_id='||l_c_pavv.id||' ,p_cle_id='||x_clev_rec.id||' ,p_chr_id=NULL');
2163: END IF;
2164:
2165: copy_price_att_values(

Line 2162: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.price_att_values','Calling copy_price_att_values, p_pav_id='||l_c_pavv.id||' ,p_cle_id='||x_clev_rec.id||' ,p_chr_id=NULL');

2158:
2159: FOR l_c_pavv IN c_pavv LOOP
2160:
2161: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2162: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.price_att_values','Calling copy_price_att_values, p_pav_id='||l_c_pavv.id||' ,p_cle_id='||x_clev_rec.id||' ,p_chr_id=NULL');
2163: END IF;
2164:
2165: copy_price_att_values(
2166: p_api_version => 1.0,

Line 2176: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

2172: p_cle_id => x_clev_rec.id,
2173: p_chr_id => NULL,
2174: x_pav_id => l_pav_id);
2175:
2176: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2177: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.price_att_values','after call to copy_price_att_values, x_return_status='||l_return_status||' ,x_pav_id='||l_pav_id);
2178: END IF;
2179:
2180: IF (l_return_status NOT IN (OKC_API.G_RET_STS_SUCCESS, OKC_API.G_RET_STS_WARNING)) THEN

Line 2177: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.price_att_values','after call to copy_price_att_values, x_return_status='||l_return_status||' ,x_pav_id='||l_pav_id);

2173: p_chr_id => NULL,
2174: x_pav_id => l_pav_id);
2175:
2176: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2177: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.price_att_values','after call to copy_price_att_values, x_return_status='||l_return_status||' ,x_pav_id='||l_pav_id);
2178: END IF;
2179:
2180: IF (l_return_status NOT IN (OKC_API.G_RET_STS_SUCCESS, OKC_API.G_RET_STS_WARNING)) THEN
2181: x_return_status := l_return_status;

Line 2197: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

2193:
2194: FOR l_c_cplv IN c_cplv LOOP
2195: l_old_return_status := l_return_status;
2196:
2197: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2198: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.party_roles', 'Calling copy_party_roles, p_cpl_id='||l_c_cplv.id||' p_cle_id='||x_clev_rec.id||' ,p_chr_id=NULL ,p_rle_code=NULL');
2199: END IF;
2200:
2201: copy_party_roles(

Line 2198: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.party_roles', 'Calling copy_party_roles, p_cpl_id='||l_c_cplv.id||' p_cle_id='||x_clev_rec.id||' ,p_chr_id=NULL ,p_rle_code=NULL');

2194: FOR l_c_cplv IN c_cplv LOOP
2195: l_old_return_status := l_return_status;
2196:
2197: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2198: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.party_roles', 'Calling copy_party_roles, p_cpl_id='||l_c_cplv.id||' p_cle_id='||x_clev_rec.id||' ,p_chr_id=NULL ,p_rle_code=NULL');
2199: END IF;
2200:
2201: copy_party_roles(
2202: p_api_version => 1.0,

Line 2213: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

2209: p_chr_id => NULL,
2210: p_rle_code => NULL,
2211: x_cpl_id => l_cpl_id);
2212:
2213: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2214: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.party_roles', 'after call to copy_party_roles, x_return_status='||l_return_status||' ,x_cpl_id='||l_cpl_id);
2215: END IF;
2216:
2217: IF (l_return_status NOT IN (OKC_API.G_RET_STS_SUCCESS, OKC_API.G_RET_STS_WARNING)) THEN

Line 2214: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.party_roles', 'after call to copy_party_roles, x_return_status='||l_return_status||' ,x_cpl_id='||l_cpl_id);

2210: p_rle_code => NULL,
2211: x_cpl_id => l_cpl_id);
2212:
2213: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2214: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.party_roles', 'after call to copy_party_roles, x_return_status='||l_return_status||' ,x_cpl_id='||l_cpl_id);
2215: END IF;
2216:
2217: IF (l_return_status NOT IN (OKC_API.G_RET_STS_SUCCESS, OKC_API.G_RET_STS_WARNING)) THEN
2218: x_return_status := l_return_status;

Line 2230: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN

2226: END IF;
2227:
2228: END LOOP;
2229:
2230: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2231: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.items', 'Calling copy_items, p_from_cle_id='||p_from_cle_id||' ,p_copy_reference='||p_copy_reference||' ,p_to_cle_id='||x_clev_rec.id);
2232: END IF;
2233:
2234: copy_items(

Line 2231: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.items', 'Calling copy_items, p_from_cle_id='||p_from_cle_id||' ,p_copy_reference='||p_copy_reference||' ,p_to_cle_id='||x_clev_rec.id);

2227:
2228: END LOOP;
2229:
2230: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2231: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.items', 'Calling copy_items, p_from_cle_id='||p_from_cle_id||' ,p_copy_reference='||p_copy_reference||' ,p_to_cle_id='||x_clev_rec.id);
2232: END IF;
2233:
2234: copy_items(
2235: p_api_version => 1.0,

Line 2257: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN

2253: END IF;
2254:
2255: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2256:
2257: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
2258: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end', 'x_return_status='||x_return_status);
2259: END IF;
2260:
2261: EXCEPTION

Line 2258: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end', 'x_return_status='||x_return_status);

2254:
2255: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2256:
2257: IF(FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level)THEN
2258: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end', 'x_return_status='||x_return_status);
2259: END IF;
2260:
2261: EXCEPTION
2262: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 2265: IF(FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level)THEN

2261: EXCEPTION
2262: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2263: ROLLBACK TO copy_contract_line_PVT;
2264:
2265: IF(FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level)THEN
2266: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name||'.end_halt_validation', 'x_return_status='||x_return_status);
2267: END IF;
2268: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2269:

Line 2266: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name||'.end_halt_validation', 'x_return_status='||x_return_status);

2262: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2263: ROLLBACK TO copy_contract_line_PVT;
2264:
2265: IF(FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level)THEN
2266: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name||'.end_halt_validation', 'x_return_status='||x_return_status);
2267: END IF;
2268: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2269:
2270: WHEN OTHERS THEN

Line 2275: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

2271: ROLLBACK TO copy_contract_line_PVT;
2272:
2273: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2274:
2275: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2276: l_error_text := substr (SQLERRM, 1, 512);
2277: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
2278: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2279: END IF;

Line 2277: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

2273: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2274:
2275: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2276: l_error_text := substr (SQLERRM, 1, 512);
2277: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
2278: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2279: END IF;
2280: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2281:

Line 4274: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

4270:
4271: BEGIN
4272:
4273: --log key input parameters
4274: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
4275: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_old_trx_ext_id='||p_old_trx_ext_id||' ,p_order_id='||p_order_id||' ,p_cust_acct_id='||p_cust_acct_id||' ,p_bill_to_site_use_id='||p_bill_to_site_use_id);
4276: END IF;
4277:
4278: --standard api initilization and checks

Line 4275: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_old_trx_ext_id='||p_old_trx_ext_id||' ,p_order_id='||p_order_id||' ,p_cust_acct_id='||p_cust_acct_id||' ,p_bill_to_site_use_id='||p_bill_to_site_use_id);

4271: BEGIN
4272:
4273: --log key input parameters
4274: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
4275: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_old_trx_ext_id='||p_old_trx_ext_id||' ,p_order_id='||p_order_id||' ,p_cust_acct_id='||p_cust_acct_id||' ,p_bill_to_site_use_id='||p_bill_to_site_use_id);
4276: END IF;
4277:
4278: --standard api initilization and checks
4279: SAVEPOINT create_trxn_extn_PVT;

Line 4322: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

4318: l_trxn_attribs.originating_application_id := 515; --service contracts OKS
4319: l_trxn_attribs.order_id := p_order_id; --contract id or line id
4320: l_trxn_attribs.trxn_ref_number1 := to_char(SYSDATE,'ddmmyyyyhhmmssss'); --to make order id and trx ref 1 unique
4321:
4322: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4323: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.create_trxn_extn', 'calling IBY_FNDCPT_TRXN_PUB.create_transaction_extension, p_payer.party_id='||l_party_id||' ,p_payer.cust_account_id='||l_cust_account_id||
4324: ' ,p_instr_assignment='||l_instr_assignment||' ,p_trxn_attribs.originating_application_id=515'||' ,p_trxn_attribs.order_id='||p_order_id);
4325: END IF;
4326:

Line 4323: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.create_trxn_extn', 'calling IBY_FNDCPT_TRXN_PUB.create_transaction_extension, p_payer.party_id='||l_party_id||' ,p_payer.cust_account_id='||l_cust_account_id||

4319: l_trxn_attribs.order_id := p_order_id; --contract id or line id
4320: l_trxn_attribs.trxn_ref_number1 := to_char(SYSDATE,'ddmmyyyyhhmmssss'); --to make order id and trx ref 1 unique
4321:
4322: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4323: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.create_trxn_extn', 'calling IBY_FNDCPT_TRXN_PUB.create_transaction_extension, p_payer.party_id='||l_party_id||' ,p_payer.cust_account_id='||l_cust_account_id||
4324: ' ,p_instr_assignment='||l_instr_assignment||' ,p_trxn_attribs.originating_application_id=515'||' ,p_trxn_attribs.order_id='||p_order_id);
4325: END IF;
4326:
4327:

Line 4343: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

4339: p_trxn_attribs => l_trxn_attribs,
4340: x_entity_id => x_trx_ext_id,
4341: x_response => l_response);
4342:
4343: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4344: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.create_trxn_extn', 'after call to IBY_FNDCPT_TRXN_PUB.create_transaction_extension, x_return_status='||x_return_status||' ,x_entity_id='||x_trx_ext_id||
4345: ' ,result_code='||l_response.result_code||' ,result_category='||l_response.result_category||' ,result_message='||l_response.result_message);
4346: END IF;
4347:

Line 4344: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.create_trxn_extn', 'after call to IBY_FNDCPT_TRXN_PUB.create_transaction_extension, x_return_status='||x_return_status||' ,x_entity_id='||x_trx_ext_id||

4340: x_entity_id => x_trx_ext_id,
4341: x_response => l_response);
4342:
4343: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4344: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.create_trxn_extn', 'after call to IBY_FNDCPT_TRXN_PUB.create_transaction_extension, x_return_status='||x_return_status||' ,x_entity_id='||x_trx_ext_id||
4345: ' ,result_code='||l_response.result_code||' ,result_category='||l_response.result_category||' ,result_message='||l_response.result_message);
4346: END IF;
4347:
4348: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 4360: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

4356: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_response.result_message||'('||l_response.result_code||':'||l_response.result_category||')');
4357: RAISE FND_API.g_exc_error;
4358: END IF;
4359:
4360: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
4361: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status||' ,x_trx_ext_id='||x_trx_ext_id);
4362: END IF;
4363: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4364:

Line 4361: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status||' ,x_trx_ext_id='||x_trx_ext_id);

4357: RAISE FND_API.g_exc_error;
4358: END IF;
4359:
4360: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
4361: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status||' ,x_trx_ext_id='||x_trx_ext_id);
4362: END IF;
4363: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4364:
4365: EXCEPTION

Line 4370: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

4366: WHEN FND_API.g_exc_error THEN
4367: ROLLBACK TO create_trxn_extn_PVT;
4368: x_return_status := FND_API.g_ret_sts_error ;
4369:
4370: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
4371: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
4372: END IF;
4373: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4374:

Line 4371: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);

4367: ROLLBACK TO create_trxn_extn_PVT;
4368: x_return_status := FND_API.g_ret_sts_error ;
4369:
4370: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
4371: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
4372: END IF;
4373: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4374:
4375: IF (c_party_from_billto%isopen) THEN

Line 4389: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

4385: WHEN FND_API.g_exc_unexpected_error THEN
4386: ROLLBACK TO create_trxn_extn_PVT;
4387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4388:
4389: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
4390: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
4391: END IF;
4392: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4393:

Line 4390: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);

4386: ROLLBACK TO create_trxn_extn_PVT;
4387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4388:
4389: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
4390: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
4391: END IF;
4392: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4393:
4394: IF (c_party_from_billto%isopen) THEN

Line 4408: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

4404: WHEN OTHERS THEN
4405: ROLLBACK TO create_trxn_extn_PVT;
4406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4407:
4408: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
4409: l_error_text := substr (SQLERRM, 1, 240);
4410: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
4411: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
4412: END IF;

Line 4410: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

4406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4407:
4408: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
4409: l_error_text := substr (SQLERRM, 1, 240);
4410: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
4411: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
4412: END IF;
4413: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
4414: