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

Line 600: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level

596: l_service_dup VARCHAR2(30);
597:
598: BEGIN
599:
600: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
601: THEN
602: fnd_log.STRING (fnd_log.level_procedure,
603: g_module_current || '.CHECK_SERVICE_DUPLICATE.begin',
604: 'Order Line Id = '

Line 602: fnd_log.STRING (fnd_log.level_procedure,

598: BEGIN
599:
600: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
601: THEN
602: fnd_log.STRING (fnd_log.level_procedure,
603: g_module_current || '.CHECK_SERVICE_DUPLICATE.begin',
604: 'Order Line Id = '
605: || p_order_line_id
606: || ',Service Id = '

Line 625: IF fnd_log.level_error >= fnd_log.g_current_runtime_level

621: THEN
622: x_service_status := NULL;
623: l_return_status := okc_api.g_ret_sts_error;
624:
625: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
626: THEN
627: fnd_log.STRING (fnd_log.level_error,
628: g_module_current
629: || '.CHECK_SERVICE_DUPLICATE.ERROR',

Line 627: fnd_log.STRING (fnd_log.level_error,

623: l_return_status := okc_api.g_ret_sts_error;
624:
625: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
626: THEN
627: fnd_log.STRING (fnd_log.level_error,
628: g_module_current
629: || '.CHECK_SERVICE_DUPLICATE.ERROR',
630: 'Order Header Id NULL'
631: );

Line 672: -- IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

668: -- x_return_status => l_return_status
669: -- );
670: --
671: -- -- to be confirmed
672: -- IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
673: -- THEN
674: -- fnd_log.STRING (fnd_log.level_event,
675: -- g_module_current
676: -- || '.CHECK_SERVICE_DUPLICATE.Internal_Call.after',

Line 674: -- fnd_log.STRING (fnd_log.level_event,

670: --
671: -- -- to be confirmed
672: -- IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
673: -- THEN
674: -- fnd_log.STRING (fnd_log.level_event,
675: -- g_module_current
676: -- || '.CHECK_SERVICE_DUPLICATE.Internal_Call.after',
677: -- 'Get_K_Line_Id(Return status = '
678: -- || l_return_status

Line 711: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level

707: x_return_status := l_return_status;
708: NULL;
709: WHEN OTHERS
710: THEN
711: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
712: THEN
713: fnd_log.STRING (fnd_log.level_unexpected,
714: g_module_current
715: || '.CHECK_SERVICE_DUPLICATE.UNEXPECTED',

Line 713: fnd_log.STRING (fnd_log.level_unexpected,

709: WHEN OTHERS
710: THEN
711: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
712: THEN
713: fnd_log.STRING (fnd_log.level_unexpected,
714: g_module_current
715: || '.CHECK_SERVICE_DUPLICATE.UNEXPECTED',
716: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
717: || SQLERRM

Line 794: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

790: CLOSE bill_seq_csr;
791:
792: x_common_bill_seq_id := l_comm_bill_seq_id;
793:
794: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
795: THEN
796: fnd_log.STRING (fnd_log.level_statement,
797: g_module_current
798: || '.GET_WAR_ITEM_ID.after bill_seq_csr',

Line 796: fnd_log.STRING (fnd_log.level_statement,

792: x_common_bill_seq_id := l_comm_bill_seq_id;
793:
794: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
795: THEN
796: fnd_log.STRING (fnd_log.level_statement,
797: g_module_current
798: || '.GET_WAR_ITEM_ID.after bill_seq_csr',
799: 'Common bill Sequence Id =' || x_common_bill_seq_id
800: );

Line 809: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

805: FOR c_war_items_rec IN c_war_items_csr (l_comm_bill_seq_id)
806: LOOP
807: x_war_item_tbl (l_ptr2).war_item_id := c_war_items_rec.war_item_id;
808:
809: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
810: THEN
811: fnd_log.STRING (fnd_log.level_statement,
812: g_module_current
813: || '.GET_WAR_ITEM_ID.loop c_war_items_csr',

Line 811: fnd_log.STRING (fnd_log.level_statement,

807: x_war_item_tbl (l_ptr2).war_item_id := c_war_items_rec.war_item_id;
808:
809: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
810: THEN
811: fnd_log.STRING (fnd_log.level_statement,
812: g_module_current
813: || '.GET_WAR_ITEM_ID.loop c_war_items_csr',
814: 'War Item Id('
815: || l_ptr2

Line 840: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level

836: g_sqlerrm_token,
837: SQLERRM
838: );
839:
840: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
841: THEN
842: fnd_log.STRING (fnd_log.level_unexpected,
843: g_module_current || '.GET_WAR_ITEM_ID.UNEXPECTED',
844: 'sqlcode = ' || SQLCODE || ', sqlerrm = '

Line 842: fnd_log.STRING (fnd_log.level_unexpected,

838: );
839:
840: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
841: THEN
842: fnd_log.STRING (fnd_log.level_unexpected,
843: g_module_current || '.GET_WAR_ITEM_ID.UNEXPECTED',
844: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
845: || SQLERRM
846: );

Line 910: IF fnd_log.level_error >= fnd_log.g_current_runtime_level

906: CLOSE bom_dtls_csr;
907:
908: l_return_status := okc_api.g_ret_sts_unexp_error;
909:
910: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
911: THEN
912: fnd_log.STRING
913: (fnd_log.level_error,
914: g_module_current || '.GET_WAR_DUR_PER.ERROR',

Line 912: fnd_log.STRING

908: l_return_status := okc_api.g_ret_sts_unexp_error;
909:
910: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
911: THEN
912: fnd_log.STRING
913: (fnd_log.level_error,
914: g_module_current || '.GET_WAR_DUR_PER.ERROR',
915: 'Bom_dtl_csr not Found: Mising Duration And Coverage '
916: );

Line 913: (fnd_log.level_error,

909:
910: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
911: THEN
912: fnd_log.STRING
913: (fnd_log.level_error,
914: g_module_current || '.GET_WAR_DUR_PER.ERROR',
915: 'Bom_dtl_csr not Found: Mising Duration And Coverage '
916: );
917: END IF;

Line 925: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

921: END IF;
922:
923: CLOSE bom_dtls_csr;
924:
925: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
926: THEN
927: fnd_log.STRING (fnd_log.level_statement,
928: g_module_current
929: || '.GET_WAR_DUR_PER.After bom_dtls_csr',

Line 927: fnd_log.STRING (fnd_log.level_statement,

923: CLOSE bom_dtls_csr;
924:
925: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
926: THEN
927: fnd_log.STRING (fnd_log.level_statement,
928: g_module_current
929: || '.GET_WAR_DUR_PER.After bom_dtls_csr',
930: 'Warranty Duration' || x_duration || ':'
931: || x_uom_code

Line 950: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level

946: g_sqlerrm_token,
947: SQLERRM
948: );
949:
950: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
951: THEN
952: fnd_log.STRING (fnd_log.level_unexpected,
953: g_module_current || '.GET_WAR_DUR_PER.UNEXPECTED',
954: 'sqlcode = ' || SQLCODE || ', sqlerrm = '

Line 952: fnd_log.STRING (fnd_log.level_unexpected,

948: );
949:
950: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
951: THEN
952: fnd_log.STRING (fnd_log.level_unexpected,
953: g_module_current || '.GET_WAR_DUR_PER.UNEXPECTED',
954: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
955: || SQLERRM
956: );

Line 1042: IF fnd_log.level_error >= fnd_log.g_current_runtime_level

1038: IF p_prod_item_id IS NULL
1039: THEN
1040: x_return_status := okc_api.g_ret_sts_error;
1041:
1042: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1043: THEN
1044: fnd_log.STRING (fnd_log.level_error,
1045: g_module_current || '.GET_WARRANTY_INFO.ERROR',
1046: 'Product Item Id Required'

Line 1044: fnd_log.STRING (fnd_log.level_error,

1040: x_return_status := okc_api.g_ret_sts_error;
1041:
1042: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1043: THEN
1044: fnd_log.STRING (fnd_log.level_error,
1045: g_module_current || '.GET_WARRANTY_INFO.ERROR',
1046: 'Product Item Id Required'
1047: );
1048: END IF;

Line 1059: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

1055:
1056: FETCH get_ship_csr
1057: INTO l_start_delay;
1058:
1059: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1060: THEN
1061: fnd_log.STRING (fnd_log.level_statement,
1062: g_module_current
1063: || '.GET_WARRANTY_INFO.after get_chip_csr',

Line 1061: fnd_log.STRING (fnd_log.level_statement,

1057: INTO l_start_delay;
1058:
1059: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1060: THEN
1061: fnd_log.STRING (fnd_log.level_statement,
1062: g_module_current
1063: || '.GET_WARRANTY_INFO.after get_chip_csr',
1064: 'Start Delay = ' || l_start_delay
1065: );

Line 1074: IF fnd_log.level_error >= fnd_log.g_current_runtime_level

1070: CLOSE get_ship_csr;
1071:
1072: l_return_status := okc_api.g_ret_sts_error;
1073:
1074: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1075: THEN
1076: fnd_log.STRING (fnd_log.level_error,
1077: g_module_current || '.GET_WARRANTY_INFO.ERROR',
1078: 'Get_Ship_Csr not Found'

Line 1076: fnd_log.STRING (fnd_log.level_error,

1072: l_return_status := okc_api.g_ret_sts_error;
1073:
1074: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1075: THEN
1076: fnd_log.STRING (fnd_log.level_error,
1077: g_module_current || '.GET_WARRANTY_INFO.ERROR',
1078: 'Get_Ship_Csr not Found'
1079: );
1080: END IF;

Line 1096: IF fnd_log.level_error >= fnd_log.g_current_runtime_level

1092: IF p_installation_date IS NULL AND p_ship_date IS NULL
1093: THEN
1094: l_return_status := okc_api.g_ret_sts_error;
1095:
1096: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1097: THEN
1098: fnd_log.STRING (fnd_log.level_error,
1099: g_module_current || '.GET_WARRANTY_INFO.ERROR',
1100: 'Installation date and Ship Date not Set'

Line 1098: fnd_log.STRING (fnd_log.level_error,

1094: l_return_status := okc_api.g_ret_sts_error;
1095:
1096: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1097: THEN
1098: fnd_log.STRING (fnd_log.level_error,
1099: g_module_current || '.GET_WARRANTY_INFO.ERROR',
1100: 'Installation date and Ship Date not Set'
1101: );
1102: END IF;

Line 1122: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

1118: l_ship_date := p_ship_date;
1119: p_date := NVL (l_start_delay, 0) + l_ship_date;
1120: END IF;
1121:
1122: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1123: THEN
1124: fnd_log.STRING (fnd_log.level_statement,
1125: g_module_current || '.GET_WARRANTY_INFO.ship dates',
1126: 'Ship Date = ' || l_ship_date || 'p_date = '

Line 1124: fnd_log.STRING (fnd_log.level_statement,

1120: END IF;
1121:
1122: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1123: THEN
1124: fnd_log.STRING (fnd_log.level_statement,
1125: g_module_current || '.GET_WARRANTY_INFO.ship dates',
1126: 'Ship Date = ' || l_ship_date || 'p_date = '
1127: || p_date
1128: );

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

1134: x_war_item_tbl => l_warranty_tbl,
1135: x_common_bill_seq_id => l_comm_bill_seq_id
1136: );
1137:
1138: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1139: THEN
1140: fnd_log.STRING (fnd_log.level_event,
1141: g_module_current
1142: || '.GET_WARRANTY_INFO.Internal_call.after',

Line 1140: fnd_log.STRING (fnd_log.level_event,

1136: );
1137:
1138: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1139: THEN
1140: fnd_log.STRING (fnd_log.level_event,
1141: g_module_current
1142: || '.GET_WARRANTY_INFO.Internal_call.after',
1143: ' Get_War_Item_Id(Return status = '
1144: || l_return_status

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

1168: p_war_date => p_date,
1169: x_return_status => l_return_status
1170: );
1171:
1172: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1173: THEN
1174: fnd_log.STRING (fnd_log.level_event,
1175: g_module_current
1176: || '.GET_WARRANTY_INFO.Internal_call.after',

Line 1174: fnd_log.STRING (fnd_log.level_event,

1170: );
1171:
1172: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1173: THEN
1174: fnd_log.STRING (fnd_log.level_event,
1175: g_module_current
1176: || '.GET_WARRANTY_INFO.Internal_call.after',
1177: ' Get_War_Dur_Per(Return status = '
1178: || l_return_status

Line 1200: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

1196: p_timeunit => x_warranty_tbl (l_ptr).duration_period
1197: )
1198: );
1199:
1200: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1201: THEN
1202: fnd_log.STRING (fnd_log.level_statement,
1203: g_module_current
1204: || '.GET_WARRANTY_INFO.Warranty details:',

Line 1202: fnd_log.STRING (fnd_log.level_statement,

1198: );
1199:
1200: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1201: THEN
1202: fnd_log.STRING (fnd_log.level_statement,
1203: g_module_current
1204: || '.GET_WARRANTY_INFO.Warranty details:',
1205: 'start Date = '
1206: || x_warranty_tbl (l_ptr).warranty_start_date

Line 1219: IF fnd_log.level_error >= fnd_log.g_current_runtime_level

1215:
1216: -- Fixed bug# 2414184 -12Jun2002
1217: IF x_warranty_tbl (l_ptr).warranty_end_date IS NULL
1218: THEN
1219: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1220: THEN
1221: fnd_log.STRING (fnd_log.level_error,
1222: g_module_current
1223: || '.GET_WARRANTY_INFO.ERROR',

Line 1221: fnd_log.STRING (fnd_log.level_error,

1217: IF x_warranty_tbl (l_ptr).warranty_end_date IS NULL
1218: THEN
1219: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1220: THEN
1221: fnd_log.STRING (fnd_log.level_error,
1222: g_module_current
1223: || '.GET_WARRANTY_INFO.ERROR',
1224: 'Null Warranty End Date'
1225: );

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

1240: -- Added to check the warranty item associated to the item even before checking the start delay in Inventory. --
1241:
1242: If p_prod_item_id is Null then
1243: x_return_status := OKC_API.G_RET_STS_ERROR;
1244: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1245: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.ERROR','Product Item Id Required');
1246: END IF;
1247: OKC_API.set_message(G_APP_NAME,'OKS_ORG_ID_INV_ID REQUIRED');
1248: Raise G_EXCEPTION_HALT_VALIDATION;

Line 1245: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.ERROR','Product Item Id Required');

1241:
1242: If p_prod_item_id is Null then
1243: x_return_status := OKC_API.G_RET_STS_ERROR;
1244: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1245: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.ERROR','Product Item Id Required');
1246: END IF;
1247: OKC_API.set_message(G_APP_NAME,'OKS_ORG_ID_INV_ID REQUIRED');
1248: Raise G_EXCEPTION_HALT_VALIDATION;
1249: End If;

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

1251: Open Bill_Seq_Csr;
1252: Fetch Bill_Seq_Csr into l_comm_bill_seq_id;
1253: Close bill_seq_csr;
1254:
1255: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1256: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_WAR_ITEM_ID.after bill_seq_csr','Common bill Sequence Id ='
1257: || l_Comm_bill_Seq_ID);
1258: END IF;
1259:

Line 1256: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_WAR_ITEM_ID.after bill_seq_csr','Common bill Sequence Id ='

1252: Fetch Bill_Seq_Csr into l_comm_bill_seq_id;
1253: Close bill_seq_csr;
1254:
1255: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1256: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_WAR_ITEM_ID.after bill_seq_csr','Common bill Sequence Id ='
1257: || l_Comm_bill_Seq_ID);
1258: END IF;
1259:
1260: open c_war_items_csr(l_comm_bill_seq_id);

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

1266: Open Get_Ship_Csr;
1267: Fetch Get_Ship_Csr into l_start_delay;
1268: Close Get_ship_Csr;
1269:
1270: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1271: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.after get_chip_csr',
1272: 'Start Delay = '||l_start_delay );
1273: END IF;
1274:

Line 1271: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.after get_chip_csr',

1267: Fetch Get_Ship_Csr into l_start_delay;
1268: Close Get_ship_Csr;
1269:
1270: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1271: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.after get_chip_csr',
1272: 'Start Delay = '||l_start_delay );
1273: END IF;
1274:
1275: If p_installation_date Is Null AND p_ship_date Is Null Then

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

1273: END IF;
1274:
1275: If p_installation_date Is Null AND p_ship_date Is Null Then
1276: l_return_status := OKC_API.G_RET_STS_ERROR;
1277: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1278: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.ERROR','Installation date and Ship Date not Set');
1279: END IF;
1280: OKC_API.set_message(G_APP_NAME,'OKS_SHIPFLG_SHIPDT_NOT_SET','P_ITEM_ID',p_prod_item_id);
1281: Raise G_EXCEPTION_HALT_VALIDATION;

Line 1278: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.ERROR','Installation date and Ship Date not Set');

1274:
1275: If p_installation_date Is Null AND p_ship_date Is Null Then
1276: l_return_status := OKC_API.G_RET_STS_ERROR;
1277: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1278: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.ERROR','Installation date and Ship Date not Set');
1279: END IF;
1280: OKC_API.set_message(G_APP_NAME,'OKS_SHIPFLG_SHIPDT_NOT_SET','P_ITEM_ID',p_prod_item_id);
1281: Raise G_EXCEPTION_HALT_VALIDATION;
1282: End If;

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

1291: P_date := Nvl(l_start_delay,0) + l_ship_date;
1292:
1293: End If;
1294:
1295: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1296: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.ship dates',
1297: 'Ship Date = '||l_ship_date || 'p_date = '|| p_date );
1298: END IF;
1299:

Line 1296: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.ship dates',

1292:
1293: End If;
1294:
1295: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1296: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.ship dates',
1297: 'Ship Date = '||l_ship_date || 'p_date = '|| p_date );
1298: END IF;
1299:
1300: l_ptr := l_warranty_tbl.FIRST;

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

1317: X_return_status => l_return_status
1318: ) ;
1319:
1320:
1321: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1322: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.Internal_call.after',
1323: ' Get_War_Dur_Per(Return status = '||l_return_status ||')');
1324: END IF;
1325:

Line 1322: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.Internal_call.after',

1318: ) ;
1319:
1320:
1321: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1322: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.Internal_call.after',
1323: ' Get_War_Dur_Per(Return status = '||l_return_status ||')');
1324: END IF;
1325:
1326: If Not l_return_status = OKC_API.G_RET_STS_SUCCESS Then

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

1336: p_timeunit => X_warranty_tbl(l_ptr2).Duration_period
1337: ));
1338:
1339:
1340: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1341: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.Warranty details:',
1342: 'start Date = '||X_warranty_tbl(l_ptr2).warranty_start_date
1343: || ',End date = '|| X_warranty_tbl(l_ptr2).Warranty_end_date
1344: || ',Duration = '|| X_warranty_tbl(l_ptr2).Duration_Quantity

Line 1341: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.Warranty details:',

1337: ));
1338:
1339:
1340: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1341: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.Warranty details:',
1342: 'start Date = '||X_warranty_tbl(l_ptr2).warranty_start_date
1343: || ',End date = '|| X_warranty_tbl(l_ptr2).Warranty_end_date
1344: || ',Duration = '|| X_warranty_tbl(l_ptr2).Duration_Quantity
1345: || ',Period = '|| X_warranty_tbl(l_ptr2).Duration_period);

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

1346: END IF;
1347:
1348: -- Fixed bug# 2414184 -12Jun2002
1349: If x_warranty_tbl(l_ptr2).warranty_end_date Is Null Then
1350: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1351: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.ERROR','Null Warranty End Date');
1352: END IF;
1353: OKC_API.set_message(G_APP_NAME,'OKS_END_DT_DUR_REQUIRED');
1354: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 1351: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.ERROR','Null Warranty End Date');

1347:
1348: -- Fixed bug# 2414184 -12Jun2002
1349: If x_warranty_tbl(l_ptr2).warranty_end_date Is Null Then
1350: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1351: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.GET_WARRANTY_INFO.ERROR','Null Warranty End Date');
1352: END IF;
1353: OKC_API.set_message(G_APP_NAME,'OKS_END_DT_DUR_REQUIRED');
1354: l_return_status := OKC_API.G_RET_STS_ERROR;
1355: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1388: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level

1384: g_sqlerrm_token,
1385: SQLERRM
1386: );
1387:
1388: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
1389: THEN
1390: fnd_log.STRING (fnd_log.level_unexpected,
1391: g_module_current
1392: || '.GET_WARRANTY_INFO.UNEXPECTED',

Line 1390: fnd_log.STRING (fnd_log.level_unexpected,

1386: );
1387:
1388: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
1389: THEN
1390: fnd_log.STRING (fnd_log.level_unexpected,
1391: g_module_current
1392: || '.GET_WARRANTY_INFO.UNEXPECTED',
1393: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
1394: || SQLERRM

Line 1523: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

1519: BEGIN
1520: x_return_status := l_return_status;
1521: p_hdr_id := get_order_header_id (p_order_line_id);
1522:
1523: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1524: THEN
1525: fnd_log.STRING (fnd_log.level_statement,
1526: g_module_current
1527: || '.GET_CONTRACT_HEADER_INFO.order header',

Line 1525: fnd_log.STRING (fnd_log.level_statement,

1521: p_hdr_id := get_order_header_id (p_order_line_id);
1522:
1523: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1524: THEN
1525: fnd_log.STRING (fnd_log.level_statement,
1526: g_module_current
1527: || '.GET_CONTRACT_HEADER_INFO.order header',
1528: 'Order header id = ' || p_hdr_id
1529: );

Line 1534: IF fnd_log.level_error >= fnd_log.g_current_runtime_level

1530: END IF;
1531:
1532: IF p_hdr_id IS NULL
1533: THEN
1534: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1535: THEN
1536: fnd_log.STRING (fnd_log.level_error,
1537: g_module_current
1538: || '.GET_CONTRACT_HEADER_INFO.ERROR: ',

Line 1536: fnd_log.STRING (fnd_log.level_error,

1532: IF p_hdr_id IS NULL
1533: THEN
1534: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1535: THEN
1536: fnd_log.STRING (fnd_log.level_error,
1537: g_module_current
1538: || '.GET_CONTRACT_HEADER_INFO.ERROR: ',
1539: 'Header Id NULL for line ' || p_order_line_id
1540: );

Line 1571: IF fnd_log.level_error >= fnd_log.g_current_runtime_level

1567: INTO l_ord_hdr_rec;
1568:
1569: IF l_ord_hdr_csr%NOTFOUND
1570: THEN
1571: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1572: THEN
1573: fnd_log.STRING (fnd_log.level_error,
1574: g_module_current
1575: || '.GET_CONTRACT_HEADER_INFO.ERROR: ',

Line 1573: fnd_log.STRING (fnd_log.level_error,

1569: IF l_ord_hdr_csr%NOTFOUND
1570: THEN
1571: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1572: THEN
1573: fnd_log.STRING (fnd_log.level_error,
1574: g_module_current
1575: || '.GET_CONTRACT_HEADER_INFO.ERROR: ',
1576: 'Header record not found for header ' || p_hdr_id
1577: );

Line 1606: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

1602:
1603: CLOSE l_ord_hdr_csr;
1604:
1605: -- Added in R12 by rsu
1606: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1607: THEN
1608: fnd_log.STRING (fnd_log.level_statement,
1609: g_module_current
1610: || '.GET_CONTRACT_HEADER_INFO.order header',

Line 1608: fnd_log.STRING (fnd_log.level_statement,

1604:
1605: -- Added in R12 by rsu
1606: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1607: THEN
1608: fnd_log.STRING (fnd_log.level_statement,
1609: g_module_current
1610: || '.GET_CONTRACT_HEADER_INFO.order header',
1611: 'After querying the header'
1612: );

Line 1613: fnd_log.STRING (fnd_log.level_statement,

1609: g_module_current
1610: || '.GET_CONTRACT_HEADER_INFO.order header',
1611: 'After querying the header'
1612: );
1613: fnd_log.STRING (fnd_log.level_statement,
1614: g_module_current
1615: || '.GET_CONTRACT_HEADER_INFO.order header',
1616: 'l_Ord_hdr_rec.tax_point_code: '
1617: || l_ord_hdr_rec.tax_point_code

Line 1619: fnd_log.STRING (fnd_log.level_statement,

1615: || '.GET_CONTRACT_HEADER_INFO.order header',
1616: 'l_Ord_hdr_rec.tax_point_code: '
1617: || l_ord_hdr_rec.tax_point_code
1618: );
1619: fnd_log.STRING (fnd_log.level_statement,
1620: g_module_current
1621: || '.GET_CONTRACT_HEADER_INFO.order header',
1622: 'l_Ord_hdr_rec.tax_exempt_reason_code: '
1623: || l_ord_hdr_rec.tax_exempt_reason_code

Line 1625: fnd_log.STRING (fnd_log.level_statement,

1621: || '.GET_CONTRACT_HEADER_INFO.order header',
1622: 'l_Ord_hdr_rec.tax_exempt_reason_code: '
1623: || l_ord_hdr_rec.tax_exempt_reason_code
1624: );
1625: fnd_log.STRING (fnd_log.level_statement,
1626: g_module_current
1627: || '.GET_CONTRACT_HEADER_INFO.order header',
1628: 'l_Ord_hdr_rec.tax_exempt_number: '
1629: || l_ord_hdr_rec.tax_exempt_number

Line 1631: fnd_log.STRING (fnd_log.level_statement,

1627: || '.GET_CONTRACT_HEADER_INFO.order header',
1628: 'l_Ord_hdr_rec.tax_exempt_number: '
1629: || l_ord_hdr_rec.tax_exempt_number
1630: );
1631: fnd_log.STRING (fnd_log.level_statement,
1632: g_module_current
1633: || '.GET_CONTRACT_HEADER_INFO.order header',
1634: 'l_Ord_hdr_rec.tax_exempt_flag: '
1635: || l_ord_hdr_rec.tax_exempt_flag

Line 1656: IF fnd_log.level_error >= fnd_log.g_current_runtime_level

1652: INTO l_party_id;
1653:
1654: IF l_party_csr%NOTFOUND
1655: THEN
1656: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1657: THEN
1658: fnd_log.STRING (fnd_log.level_error,
1659: g_module_current
1660: || '.GET_CONTRACT_HEADER_INFO.ERROR: ',

Line 1658: fnd_log.STRING (fnd_log.level_error,

1654: IF l_party_csr%NOTFOUND
1655: THEN
1656: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1657: THEN
1658: fnd_log.STRING (fnd_log.level_error,
1659: g_module_current
1660: || '.GET_CONTRACT_HEADER_INFO.ERROR: ',
1661: 'Party Record Not Found For Cust Id '
1662: || l_ord_hdr_rec.sold_to_org_id

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

1681: -- Bug# 1619850 : get tax id using Invoice to org, and then Sold to org and
1682: -- and then Ship to org
1683: -- Invoice and ship to Org are at the site level must
1684: -- access okx_cust_site_uses all
1685: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1686: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_CONTRACT_HEADER_INFO.tax calculation',
1687: 'Tax Exemption Number = '||l_ord_hdr_rec.tax_exempt_number ||
1688: 'Tax Exemption Flag = '||l_ord_hdr_rec.tax_exempt_flag ||
1689: 'Invoice To Org Id = ' ||l_ord_hdr_rec.invoice_to_org_id ||

Line 1686: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_CONTRACT_HEADER_INFO.tax calculation',

1682: -- and then Ship to org
1683: -- Invoice and ship to Org are at the site level must
1684: -- access okx_cust_site_uses all
1685: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1686: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_CONTRACT_HEADER_INFO.tax calculation',
1687: 'Tax Exemption Number = '||l_ord_hdr_rec.tax_exempt_number ||
1688: 'Tax Exemption Flag = '||l_ord_hdr_rec.tax_exempt_flag ||
1689: 'Invoice To Org Id = ' ||l_ord_hdr_rec.invoice_to_org_id ||
1690: 'Sold To Org Id = '||l_ord_hdr_rec.sold_to_org_id ||

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

1711: End if;
1712:
1713: Close l_cust_csr;
1714:
1715: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1716: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_CONTRACT_HEADER_INFO.clflag status',
1717: 'For Invoice Org '|| l_clflag);
1718: END IF;
1719:

Line 1716: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_CONTRACT_HEADER_INFO.clflag status',

1712:
1713: Close l_cust_csr;
1714:
1715: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1716: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_CONTRACT_HEADER_INFO.clflag status',
1717: 'For Invoice Org '|| l_clflag);
1718: END IF;
1719:
1720:

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

1730: close l_tax_csr;
1731:
1732: End if;
1733:
1734: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1735: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_CONTRACT_HEADER_INFO.clflag status',
1736: 'For Sold Org '|| l_clflag);
1737: END IF;
1738:

Line 1735: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_CONTRACT_HEADER_INFO.clflag status',

1731:
1732: End if;
1733:
1734: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1735: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_CONTRACT_HEADER_INFO.clflag status',
1736: 'For Sold Org '|| l_clflag);
1737: END IF;
1738:
1739: l_cust_id := NULL;

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

1757: Close l_cust_csr;
1758:
1759: End if;
1760:
1761: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1762: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_CONTRACT_HEADER_INFO.clflag status',
1763: 'For hip Org '|| l_clflag);
1764: END IF;
1765:

Line 1762: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_CONTRACT_HEADER_INFO.clflag status',

1758:
1759: End if;
1760:
1761: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1762: fnd_log.string(FND_LOG.LEVEL_STATEMENT,G_MODULE_CURRENT||'.GET_CONTRACT_HEADER_INFO.clflag status',
1763: 'For hip Org '|| l_clflag);
1764: END IF;
1765:
1766: If l_clflag = 1 THEN

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

1763: 'For hip Org '|| l_clflag);
1764: END IF;
1765:
1766: If l_clflag = 1 THEN
1767: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1768: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.GET_CONTRACT_HEADER_INFO.ERROR',
1769: 'Tax Exemption Record Not Found');
1770: END IF;
1771: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 1768: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.GET_CONTRACT_HEADER_INFO.ERROR',

1764: END IF;
1765:
1766: If l_clflag = 1 THEN
1767: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1768: fnd_log.string(FND_LOG.LEVEL_ERROR,G_MODULE_CURRENT||'.GET_CONTRACT_HEADER_INFO.ERROR',
1769: 'Tax Exemption Record Not Found');
1770: END IF;
1771: l_return_status := OKC_API.G_RET_STS_ERROR;
1772: OKC_API.set_message(G_APP_NAME,'OKS_TAX_DTLS_NOT_FOUND');

Line 1791: IF fnd_log.level_error >= fnd_log.g_current_runtime_level

1787: INTO l_tax_id2;
1788:
1789: IF l_tax_flag_csr%NOTFOUND
1790: THEN
1791: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1792: THEN
1793: fnd_log.STRING (fnd_log.level_error,
1794: g_module_current
1795: || '.GET_CONTRACT_HEADER_INFO.ERROR',

Line 1793: fnd_log.STRING (fnd_log.level_error,

1789: IF l_tax_flag_csr%NOTFOUND
1790: THEN
1791: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1792: THEN
1793: fnd_log.STRING (fnd_log.level_error,
1794: g_module_current
1795: || '.GET_CONTRACT_HEADER_INFO.ERROR',
1796: ' Tax Exempt Flag Record Not Found '
1797: );

Line 1871: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level

1867: g_sqlerrm_token,
1868: SQLERRM
1869: );
1870:
1871: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
1872: THEN
1873: fnd_log.STRING (fnd_log.level_unexpected,
1874: g_module_current
1875: || '.GET_CONTRACT_HEADER_INFO.UNEXPECTED',

Line 1873: fnd_log.STRING (fnd_log.level_unexpected,

1869: );
1870:
1871: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
1872: THEN
1873: fnd_log.STRING (fnd_log.level_unexpected,
1874: g_module_current
1875: || '.GET_CONTRACT_HEADER_INFO.UNEXPECTED',
1876: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
1877: || SQLERRM

Line 1950: IF fnd_log.level_error >= fnd_log.g_current_runtime_level

1946: IF l_ord_line_csr%NOTFOUND
1947: THEN
1948: CLOSE l_ord_line_csr;
1949:
1950: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1951: THEN
1952: fnd_log.STRING (fnd_log.level_error,
1953: g_module_current
1954: || '.GET_CONTRACT_LINE_INFO.ERROR',

Line 1952: fnd_log.STRING (fnd_log.level_error,

1948: CLOSE l_ord_line_csr;
1949:
1950: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1951: THEN
1952: fnd_log.STRING (fnd_log.level_error,
1953: g_module_current
1954: || '.GET_CONTRACT_LINE_INFO.ERROR',
1955: 'l_ord_line_csr not found for line id = '
1956: || p_order_line_id

Line 1980: IF fnd_log.level_error >= fnd_log.g_current_runtime_level

1976: IF l_segment_csr%NOTFOUND
1977: THEN
1978: CLOSE l_segment_csr;
1979:
1980: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1981: THEN
1982: fnd_log.STRING (fnd_log.level_error,
1983: g_module_current
1984: || '.GET_CONTRACT_LINE_INFO.ERROR',

Line 1982: fnd_log.STRING (fnd_log.level_error,

1978: CLOSE l_segment_csr;
1979:
1980: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1981: THEN
1982: fnd_log.STRING (fnd_log.level_error,
1983: g_module_current
1984: || '.GET_CONTRACT_LINE_INFO.ERROR',
1985: 'l_segment_csr not found for org id = '
1986: || l_ord_line_rec.org_id

Line 2015: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

2011:
2012: -- X_line_rec.commitment_id := l_ord_line_rec.commitment_id;
2013:
2014: --Added in R12 by rsu
2015: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2016: THEN
2017: fnd_log.STRING (fnd_log.level_statement,
2018: g_module_current
2019: || '.GET_CONTRACT_LINE_INFO.order line',

Line 2017: fnd_log.STRING (fnd_log.level_statement,

2013:
2014: --Added in R12 by rsu
2015: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2016: THEN
2017: fnd_log.STRING (fnd_log.level_statement,
2018: g_module_current
2019: || '.GET_CONTRACT_LINE_INFO.order line',
2020: 'After querying the line'
2021: );

Line 2022: fnd_log.STRING (fnd_log.level_statement,

2018: g_module_current
2019: || '.GET_CONTRACT_LINE_INFO.order line',
2020: 'After querying the line'
2021: );
2022: fnd_log.STRING (fnd_log.level_statement,
2023: g_module_current
2024: || '.GET_CONTRACT_LINE_INFO.order line',
2025: 'l_ord_line_rec.tax_point_code: '
2026: || l_ord_line_rec.tax_point_code

Line 2028: fnd_log.STRING (fnd_log.level_statement,

2024: || '.GET_CONTRACT_LINE_INFO.order line',
2025: 'l_ord_line_rec.tax_point_code: '
2026: || l_ord_line_rec.tax_point_code
2027: );
2028: fnd_log.STRING (fnd_log.level_statement,
2029: g_module_current
2030: || '.GET_CONTRACT_LINE_INFO.order line',
2031: 'l_ord_line_rec.tax_exempt_reason_code: '
2032: || l_ord_line_rec.tax_exempt_reason_code

Line 2034: fnd_log.STRING (fnd_log.level_statement,

2030: || '.GET_CONTRACT_LINE_INFO.order line',
2031: 'l_ord_line_rec.tax_exempt_reason_code: '
2032: || l_ord_line_rec.tax_exempt_reason_code
2033: );
2034: fnd_log.STRING (fnd_log.level_statement,
2035: g_module_current
2036: || '.GET_CONTRACT_LINE_INFO.order line',
2037: 'l_ord_line_rec.tax_exempt_number: '
2038: || l_ord_line_rec.tax_exempt_number

Line 2040: fnd_log.STRING (fnd_log.level_statement,

2036: || '.GET_CONTRACT_LINE_INFO.order line',
2037: 'l_ord_line_rec.tax_exempt_number: '
2038: || l_ord_line_rec.tax_exempt_number
2039: );
2040: fnd_log.STRING (fnd_log.level_statement,
2041: g_module_current
2042: || '.GET_CONTRACT_LINE_INFO.order line',
2043: 'l_ord_line_rec.tax_exempt_flag: '
2044: || l_ord_line_rec.tax_exempt_flag

Line 2077: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level

2073: g_sqlerrm_token,
2074: SQLERRM
2075: );
2076:
2077: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2078: THEN
2079: fnd_log.STRING (fnd_log.level_unexpected,
2080: g_module_current
2081: || '.GET_CONTRACT_LINE_INFO.UNEXPECTED',

Line 2079: fnd_log.STRING (fnd_log.level_unexpected,

2075: );
2076:
2077: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2078: THEN
2079: fnd_log.STRING (fnd_log.level_unexpected,
2080: g_module_current
2081: || '.GET_CONTRACT_LINE_INFO.UNEXPECTED',
2082: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
2083: || SQLERRM

Line 2192: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

2188: l_line_tax_status VARCHAR2 (40);
2189: BEGIN
2190: x_return_status := l_return_status;
2191:
2192: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2193: THEN
2194: fnd_log.STRING (fnd_log.level_statement,
2195: g_module_current || '.GET_K_SERVICE_LINE.Order line',
2196: ' *************************************************'

Line 2194: fnd_log.STRING (fnd_log.level_statement,

2190: x_return_status := l_return_status;
2191:
2192: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2193: THEN
2194: fnd_log.STRING (fnd_log.level_statement,
2195: g_module_current || '.GET_K_SERVICE_LINE.Order line',
2196: ' *************************************************'
2197: );
2198: fnd_log.STRING (fnd_log.level_statement,

Line 2198: fnd_log.STRING (fnd_log.level_statement,

2194: fnd_log.STRING (fnd_log.level_statement,
2195: g_module_current || '.GET_K_SERVICE_LINE.Order line',
2196: ' *************************************************'
2197: );
2198: fnd_log.STRING (fnd_log.level_statement,
2199: g_module_current || '.GET_K_SERVICE_LINE.Order line',
2200: 'Processing Order line id ' || p_order_line_id
2201: );
2202: fnd_log.STRING (fnd_log.level_statement,

Line 2202: fnd_log.STRING (fnd_log.level_statement,

2198: fnd_log.STRING (fnd_log.level_statement,
2199: g_module_current || '.GET_K_SERVICE_LINE.Order line',
2200: 'Processing Order line id ' || p_order_line_id
2201: );
2202: fnd_log.STRING (fnd_log.level_statement,
2203: g_module_current || '.GET_K_SERVICE_LINE.Order line',
2204: ' '
2205: );
2206: END IF;

Line 2215: IF fnd_log.level_error >= fnd_log.g_current_runtime_level

2211: INTO l_ord_line_rec;
2212:
2213: IF l_ord_line_csr%NOTFOUND
2214: THEN
2215: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2216: THEN
2217: fnd_log.STRING (fnd_log.level_error,
2218: g_module_current || '.GET_K_SERVICE_LINE.ERROR',
2219: 'l_Ord_line_csr not found for Order Line = '

Line 2217: fnd_log.STRING (fnd_log.level_error,

2213: IF l_ord_line_csr%NOTFOUND
2214: THEN
2215: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2216: THEN
2217: fnd_log.STRING (fnd_log.level_error,
2218: g_module_current || '.GET_K_SERVICE_LINE.ERROR',
2219: 'l_Ord_line_csr not found for Order Line = '
2220: || p_order_line_id
2221: );

Line 2253: IF fnd_log.level_error >= fnd_log.g_current_runtime_level

2249: IF l_ord_line_rec.service_end_date IS NULL
2250: AND l_ord_line_rec.service_period IS NULL
2251: AND l_ord_line_rec.service_duration IS NULL
2252: THEN
2253: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2254: THEN
2255: fnd_log.STRING (fnd_log.level_error,
2256: g_module_current || '.GET_K_SERVICE_LINE.ERROR',
2257: 'End Date, Duration, Period Required '

Line 2255: fnd_log.STRING (fnd_log.level_error,

2251: AND l_ord_line_rec.service_duration IS NULL
2252: THEN
2253: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2254: THEN
2255: fnd_log.STRING (fnd_log.level_error,
2256: g_module_current || '.GET_K_SERVICE_LINE.ERROR',
2257: 'End Date, Duration, Period Required '
2258: );
2259: END IF;

Line 2280: IF fnd_log.level_error >= fnd_log.g_current_runtime_level

2276: /*Added for CLOUD ER 16039680*/
2277: IF l_ord_line_rec.service_start_date IS NULL
2278: AND l_ord_line_rec.service_end_date IS NULL AND l_ord_line_rec.contract_item_type_code = 'SUBSCRIPTION'
2279: THEN
2280: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2281: THEN
2282: fnd_log.STRING (fnd_log.level_error,
2283: g_module_current || '.GET_K_SERVICE_LINE.ERROR',
2284: 'Start_Date,End_Date are required for Subscription line '

Line 2282: fnd_log.STRING (fnd_log.level_error,

2278: AND l_ord_line_rec.service_end_date IS NULL AND l_ord_line_rec.contract_item_type_code = 'SUBSCRIPTION'
2279: THEN
2280: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2281: THEN
2282: fnd_log.STRING (fnd_log.level_error,
2283: g_module_current || '.GET_K_SERVICE_LINE.ERROR',
2284: 'Start_Date,End_Date are required for Subscription line '
2285: );
2286: END IF;

Line 2330: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

2326: l_ord_line_rec.service_duration
2327: );
2328: END IF;
2329:
2330: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2331: THEN
2332: fnd_log.STRING (fnd_log.level_statement,
2333: g_module_current
2334: || '.GET_K_SERVICE_LINE.Service Dates',

Line 2332: fnd_log.STRING (fnd_log.level_statement,

2328: END IF;
2329:
2330: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2331: THEN
2332: fnd_log.STRING (fnd_log.level_statement,
2333: g_module_current
2334: || '.GET_K_SERVICE_LINE.Service Dates',
2335: 'Start date = '
2336: || l_start_date

Line 2366: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

2362: l_ord_line_rec.service_period,
2363: l_ord_line_rec.service_duration
2364: );
2365:
2366: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2367: THEN
2368: fnd_log.STRING
2369: (fnd_log.level_statement,
2370: g_module_current

Line 2368: fnd_log.STRING

2364: );
2365:
2366: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2367: THEN
2368: fnd_log.STRING
2369: (fnd_log.level_statement,
2370: g_module_current
2371: || '.GET_K_SERVICE_LINE.Service Dates after cascading',
2372: 'Start date = '

Line 2369: (fnd_log.level_statement,

2365:
2366: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2367: THEN
2368: fnd_log.STRING
2369: (fnd_log.level_statement,
2370: g_module_current
2371: || '.GET_K_SERVICE_LINE.Service Dates after cascading',
2372: 'Start date = '
2373: || l_start_date

Line 2379: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level

2375: || l_end_date
2376: );
2377: END IF;
2378: ELSE
2379: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2380: THEN
2381: fnd_log.STRING (fnd_log.level_procedure,
2382: g_module_current
2383: || '.GET_K_SERVICE_LINE.Install ship Dates',

Line 2381: fnd_log.STRING (fnd_log.level_procedure,

2377: END IF;
2378: ELSE
2379: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2380: THEN
2381: fnd_log.STRING (fnd_log.level_procedure,
2382: g_module_current
2383: || '.GET_K_SERVICE_LINE.Install ship Dates',
2384: 'Installation_date= '
2385: || p_installation_date

Line 2406: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

2402: l_ord_line_rec.service_period,
2403: l_ord_line_rec.service_duration
2404: );
2405:
2406: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2407: THEN
2408: fnd_log.STRING
2409: (fnd_log.level_statement,
2410: g_module_current

Line 2408: fnd_log.STRING

2404: );
2405:
2406: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2407: THEN
2408: fnd_log.STRING
2409: (fnd_log.level_statement,
2410: g_module_current
2411: || '.GET_K_SERVICE_LINE.Service Dates after cascading- no warranty',
2412: 'Start date = '

Line 2409: (fnd_log.level_statement,

2405:
2406: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2407: THEN
2408: fnd_log.STRING
2409: (fnd_log.level_statement,
2410: g_module_current
2411: || '.GET_K_SERVICE_LINE.Service Dates after cascading- no warranty',
2412: 'Start date = '
2413: || l_start_date

Line 2425: IF fnd_log.level_error >= fnd_log.g_current_runtime_level

2421: END IF;
2422:
2423: IF l_start_date IS NULL
2424: THEN
2425: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2426: THEN
2427: fnd_log.STRING (fnd_log.level_error,
2428: g_module_current || '.GET_K_SERVICE_LINE.ERROR',
2429: ' Null Start Date'

Line 2427: fnd_log.STRING (fnd_log.level_error,

2423: IF l_start_date IS NULL
2424: THEN
2425: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2426: THEN
2427: fnd_log.STRING (fnd_log.level_error,
2428: g_module_current || '.GET_K_SERVICE_LINE.ERROR',
2429: ' Null Start Date'
2430: );
2431: END IF;

Line 2456: IF fnd_log.level_error >= fnd_log.g_current_runtime_level

2452: END IF;
2453:
2454: IF l_end_date IS NULL
2455: THEN
2456: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2457: THEN
2458: fnd_log.STRING (fnd_log.level_error,
2459: g_module_current || '.GET_K_SERVICE_LINE.ERROR',
2460: ' Null End Date'

Line 2458: fnd_log.STRING (fnd_log.level_error,

2454: IF l_end_date IS NULL
2455: THEN
2456: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2457: THEN
2458: fnd_log.STRING (fnd_log.level_error,
2459: g_module_current || '.GET_K_SERVICE_LINE.ERROR',
2460: ' Null End Date'
2461: );
2462: END IF;

Line 2556: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level

2552: g_sqlerrm_token,
2553: SQLERRM
2554: );
2555:
2556: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2557: THEN
2558: fnd_log.STRING (fnd_log.level_unexpected,
2559: g_module_current
2560: || '.GET_K_SERVICE_LINE.UNEXPECTED',

Line 2558: fnd_log.STRING (fnd_log.level_unexpected,

2554: );
2555:
2556: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2557: THEN
2558: fnd_log.STRING (fnd_log.level_unexpected,
2559: g_module_current
2560: || '.GET_K_SERVICE_LINE.UNEXPECTED',
2561: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
2562: || SQLERRM

Line 2609: IF fnd_log.level_error >= fnd_log.g_current_runtime_level

2605: THEN
2606: x_immediate_service_status := 'N';
2607: l_return_status := okc_api.g_ret_sts_error;
2608:
2609: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2610: THEN
2611: fnd_log.STRING (fnd_log.level_error,
2612: g_module_current
2613: || '.CHECK_IMMEDIATE_SERVICE.ERROR',

Line 2611: fnd_log.STRING (fnd_log.level_error,

2607: l_return_status := okc_api.g_ret_sts_error;
2608:
2609: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2610: THEN
2611: fnd_log.STRING (fnd_log.level_error,
2612: g_module_current
2613: || '.CHECK_IMMEDIATE_SERVICE.ERROR',
2614: 'Order Header Id NULL for Order line Id '
2615: || p_order_line_id

Line 2669: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level

2665: g_sqlerrm_token,
2666: SQLERRM
2667: );
2668:
2669: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2670: THEN
2671: fnd_log.STRING (fnd_log.level_unexpected,
2672: g_module_current
2673: || '.CHECK_IMMEDIATE_SERVICE.UNEXPECTED',

Line 2671: fnd_log.STRING (fnd_log.level_unexpected,

2667: );
2668:
2669: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2670: THEN
2671: fnd_log.STRING (fnd_log.level_unexpected,
2672: g_module_current
2673: || '.CHECK_IMMEDIATE_SERVICE.UNEXPECTED',
2674: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
2675: || SQLERRM

Line 2737: IF fnd_log.level_error >= fnd_log.g_current_runtime_level

2733: l_ord_hdr_id := get_order_header_id (p_order_line_id);
2734:
2735: IF l_ord_hdr_id IS NULL
2736: THEN
2737: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2738: THEN
2739: fnd_log.STRING (fnd_log.level_error,
2740: g_module_current || '.CHECK_DELAYED_SERVICE.ERROR',
2741: 'Invalid Order Line Id ' || p_order_line_id

Line 2739: fnd_log.STRING (fnd_log.level_error,

2735: IF l_ord_hdr_id IS NULL
2736: THEN
2737: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2738: THEN
2739: fnd_log.STRING (fnd_log.level_error,
2740: g_module_current || '.CHECK_DELAYED_SERVICE.ERROR',
2741: 'Invalid Order Line Id ' || p_order_line_id
2742: );
2743: END IF;

Line 2804: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level

2800: WHEN OTHERS
2801: THEN
2802: x_return_status := okc_api.g_ret_sts_unexp_error;
2803:
2804: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2805: THEN
2806: fnd_log.STRING (fnd_log.level_unexpected,
2807: g_module_current
2808: || '.CHECK_DELAYED_SERVICE.UNEXPECTED',

Line 2806: fnd_log.STRING (fnd_log.level_unexpected,

2802: x_return_status := okc_api.g_ret_sts_unexp_error;
2803:
2804: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2805: THEN
2806: fnd_log.STRING (fnd_log.level_unexpected,
2807: g_module_current
2808: || '.CHECK_DELAYED_SERVICE.UNEXPECTED',
2809: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
2810: || SQLERRM

Line 3171: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

3167: INTO l_rel_id;
3168:
3169: CLOSE l_rel_csr;
3170:
3171: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3172: THEN
3173: fnd_log.STRING (fnd_log.level_statement,
3174: g_module_current
3175: || '.GET_CONTRACT_DETAILS.After l_rel_csr',

Line 3173: fnd_log.STRING (fnd_log.level_statement,

3169: CLOSE l_rel_csr;
3170:
3171: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3172: THEN
3173: fnd_log.STRING (fnd_log.level_statement,
3174: g_module_current
3175: || '.GET_CONTRACT_DETAILS.After l_rel_csr',
3176: 'Service Order line id = ' || l_rel_id
3177: );

Line 3314: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level

3310: g_sqlerrm_token,
3311: SQLERRM
3312: );
3313:
3314: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3315: THEN
3316: fnd_log.STRING (fnd_log.level_unexpected,
3317: g_module_current
3318: || '.GET_CONTRACT_DETAILS.UNEXPECTED',

Line 3316: fnd_log.STRING (fnd_log.level_unexpected,

3312: );
3313:
3314: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3315: THEN
3316: fnd_log.STRING (fnd_log.level_unexpected,
3317: g_module_current
3318: || '.GET_CONTRACT_DETAILS.UNEXPECTED',
3319: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
3320: || SQLERRM

Line 3585: IF fnd_log.level_error >= fnd_log.g_current_runtime_level

3581:
3582: IF p_prod_item_id IS NULL
3583: THEN
3584: --or p_customer_product_id is NULL
3585: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
3586: THEN
3587: fnd_log.STRING (fnd_log.level_error,
3588: g_module_current || '.GET_WARRANTY_INFO.ERROR',
3589: 'Product Item Id Required'

Line 3587: fnd_log.STRING (fnd_log.level_error,

3583: THEN
3584: --or p_customer_product_id is NULL
3585: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
3586: THEN
3587: fnd_log.STRING (fnd_log.level_error,
3588: g_module_current || '.GET_WARRANTY_INFO.ERROR',
3589: 'Product Item Id Required'
3590: );
3591: END IF;

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

3601: x_war_item_tbl => l_warranty_tbl,
3602: x_common_bill_seq_id => l_comm_bill_seq_id
3603: );
3604:
3605: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3606: THEN
3607: fnd_log.STRING (fnd_log.level_event,
3608: g_module_current
3609: || '.GET_WARRANTY_INFO.Internal_call.after',

Line 3607: fnd_log.STRING (fnd_log.level_event,

3603: );
3604:
3605: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3606: THEN
3607: fnd_log.STRING (fnd_log.level_event,
3608: g_module_current
3609: || '.GET_WARRANTY_INFO.Internal_call.after',
3610: 'Get_war_item_id(Return status = '
3611: || l_return_status

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

3635: p_war_date => p_date,
3636: x_return_status => l_return_status
3637: );
3638:
3639: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3640: THEN
3641: fnd_log.STRING (fnd_log.level_event,
3642: g_module_current
3643: || '.GET_WARRANTY_INFO.Internal call.after',

Line 3641: fnd_log.STRING (fnd_log.level_event,

3637: );
3638:
3639: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3640: THEN
3641: fnd_log.STRING (fnd_log.level_event,
3642: g_module_current
3643: || '.GET_WARRANTY_INFO.Internal call.after',
3644: 'Get_War_Dur_Per(Return status = '
3645: || l_return_status

Line 3684: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level

3680: g_sqlerrm_token,
3681: SQLERRM
3682: );
3683:
3684: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3685: THEN
3686: fnd_log.STRING (fnd_log.level_unexpected,
3687: g_module_current
3688: || '.GET_WARRANTY_INFO.UNEXPECTED',

Line 3686: fnd_log.STRING (fnd_log.level_unexpected,

3682: );
3683:
3684: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3685: THEN
3686: fnd_log.STRING (fnd_log.level_unexpected,
3687: g_module_current
3688: || '.GET_WARRANTY_INFO.UNEXPECTED',
3689: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
3690: || SQLERRM

Line 3760: IF fnd_log.level_error >= fnd_log.g_current_runtime_level

3756: IF cust_csr%NOTFOUND
3757: THEN
3758: CLOSE cust_csr;
3759:
3760: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
3761: THEN
3762: fnd_log.STRING (fnd_log.level_error,
3763: g_module_current || '.GET_TRANSFER_DETAILS.ERROR',
3764: ' Cust_csr Not Found '

Line 3762: fnd_log.STRING (fnd_log.level_error,

3758: CLOSE cust_csr;
3759:
3760: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
3761: THEN
3762: fnd_log.STRING (fnd_log.level_error,
3763: g_module_current || '.GET_TRANSFER_DETAILS.ERROR',
3764: ' Cust_csr Not Found '
3765: );
3766: END IF;

Line 3779: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

3775: END IF;
3776:
3777: CLOSE cust_csr;
3778:
3779: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3780: THEN
3781: fnd_log.STRING (fnd_log.level_statement,
3782: g_module_current || '.GET_TRANSFER_DETAILS',
3783: ' Original order line Id = '

Line 3781: fnd_log.STRING (fnd_log.level_statement,

3777: CLOSE cust_csr;
3778:
3779: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3780: THEN
3781: fnd_log.STRING (fnd_log.level_statement,
3782: g_module_current || '.GET_TRANSFER_DETAILS',
3783: ' Original order line Id = '
3784: || cust_rec.original_order_line_id
3785: );

Line 3873: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level

3869: g_sqlerrm_token,
3870: SQLERRM
3871: );
3872:
3873: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3874: THEN
3875: fnd_log.STRING (fnd_log.level_unexpected,
3876: g_module_current
3877: || '.GET_TRANSFER_DETAILS.UNEXPECTED',

Line 3875: fnd_log.STRING (fnd_log.level_unexpected,

3871: );
3872:
3873: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3874: THEN
3875: fnd_log.STRING (fnd_log.level_unexpected,
3876: g_module_current
3877: || '.GET_TRANSFER_DETAILS.UNEXPECTED',
3878: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
3879: || SQLERRM

Line 4059: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level

4055: WHEN OTHERS
4056: THEN
4057: x_return_status := okc_api.g_ret_sts_unexp_error;
4058:
4059: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4060: THEN
4061: fnd_log.STRING (fnd_log.level_unexpected,
4062: g_module_current || '.SALESCREDIT.UNEXPECTED',
4063: 'sqlcode = ' || SQLCODE || ', sqlerrm = '

Line 4061: fnd_log.STRING (fnd_log.level_unexpected,

4057: x_return_status := okc_api.g_ret_sts_unexp_error;
4058:
4059: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4060: THEN
4061: fnd_log.STRING (fnd_log.level_unexpected,
4062: g_module_current || '.SALESCREDIT.UNEXPECTED',
4063: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
4064: || SQLERRM
4065: );

Line 4113: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level

4109: WHEN OTHERS
4110: THEN
4111: x_return_status := okc_api.g_ret_sts_unexp_error;
4112:
4113: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4114: THEN
4115: fnd_log.STRING (fnd_log.level_unexpected,
4116: g_module_current || '.SALESCREDIT_HDR.UNEXPECTED',
4117: 'sqlcode = ' || SQLCODE || ', sqlerrm = '

Line 4115: fnd_log.STRING (fnd_log.level_unexpected,

4111: x_return_status := okc_api.g_ret_sts_unexp_error;
4112:
4113: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4114: THEN
4115: fnd_log.STRING (fnd_log.level_unexpected,
4116: g_module_current || '.SALESCREDIT_HDR.UNEXPECTED',
4117: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
4118: || SQLERRM
4119: );

Line 4180: IF fnd_log.level_error >= fnd_log.g_current_runtime_level

4176: IF l_link_csr1%NOTFOUND
4177: THEN
4178: CLOSE l_link_csr1;
4179:
4180: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
4181: THEN
4182: fnd_log.STRING (fnd_log.level_error,
4183: g_module_current
4184: || '.UPDATE_CONTRACT_DETAILS.ERROR',

Line 4182: fnd_log.STRING (fnd_log.level_error,

4178: CLOSE l_link_csr1;
4179:
4180: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
4181: THEN
4182: fnd_log.STRING (fnd_log.level_error,
4183: g_module_current
4184: || '.UPDATE_CONTRACT_DETAILS.ERROR',
4185: 'l_line_csr1 Not Found for Line Id = '
4186: || p_order_line_id

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

4219: p_codv_tbl => l_codv_tbl_in,
4220: x_codv_tbl => l_codv_tbl_out
4221: );
4222:
4223: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4224: THEN
4225: fnd_log.STRING (fnd_log.level_event,
4226: g_module_current
4227: || '.UPDATE_CONTRACT_DETAILS.External_call.after',

Line 4225: fnd_log.STRING (fnd_log.level_event,

4221: );
4222:
4223: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4224: THEN
4225: fnd_log.STRING (fnd_log.level_event,
4226: g_module_current
4227: || '.UPDATE_CONTRACT_DETAILS.External_call.after',
4228: 'OKS_COD_PVT.update_row(Return Status = '
4229: || l_return_status

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

4263: p_codv_tbl => l_codv_tbl_in,
4264: x_codv_tbl => l_codv_tbl_out
4265: );
4266:
4267: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4268: THEN
4269: fnd_log.STRING (fnd_log.level_event,
4270: g_module_current
4271: || '.UPDATE_CONTRACT_DETAILS.External_call.after',

Line 4269: fnd_log.STRING (fnd_log.level_event,

4265: );
4266:
4267: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4268: THEN
4269: fnd_log.STRING (fnd_log.level_event,
4270: g_module_current
4271: || '.UPDATE_CONTRACT_DETAILS.External_call.after',
4272: 'OKS_COD_PVT.update_row(Return Status = '
4273: || l_return_status

Line 4302: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level

4298: g_sqlerrm_token,
4299: SQLERRM
4300: );
4301:
4302: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4303: THEN
4304: fnd_log.STRING (fnd_log.level_unexpected,
4305: g_module_current
4306: || '.UPDATE_CONTRACT_DETAILS.UNEXPECTED',

Line 4304: fnd_log.STRING (fnd_log.level_unexpected,

4300: );
4301:
4302: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4303: THEN
4304: fnd_log.STRING (fnd_log.level_unexpected,
4305: g_module_current
4306: || '.UPDATE_CONTRACT_DETAILS.UNEXPECTED',
4307: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
4308: || SQLERRM

Line 4393: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level

4389: g_sqlerrm_token,
4390: SQLERRM
4391: );
4392:
4393: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4394: THEN
4395: fnd_log.STRING (fnd_log.level_unexpected,
4396: g_module_current
4397: || '.GET_PRICING_ATTRIBUTES.UNEXPECTED',

Line 4395: fnd_log.STRING (fnd_log.level_unexpected,

4391: );
4392:
4393: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4394: THEN
4395: fnd_log.STRING (fnd_log.level_unexpected,
4396: g_module_current
4397: || '.GET_PRICING_ATTRIBUTES.UNEXPECTED',
4398: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
4399: || SQLERRM

Line 4484: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level

4480: g_sqlerrm_token,
4481: SQLERRM
4482: );
4483:
4484: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4485: THEN
4486: fnd_log.STRING (fnd_log.level_unexpected,
4487: g_module_current
4488: || '.GET_K_PRICING_ATTRIBUTES.UNEXPECTED',

Line 4486: fnd_log.STRING (fnd_log.level_unexpected,

4482: );
4483:
4484: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4485: THEN
4486: fnd_log.STRING (fnd_log.level_unexpected,
4487: g_module_current
4488: || '.GET_K_PRICING_ATTRIBUTES.UNEXPECTED',
4489: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
4490: || SQLERRM

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

4662: p_scrv_tbl => l_scrv_tbl_in,
4663: x_scrv_tbl => l_scrv_tbl_out
4664: );
4665:
4666: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4667: THEN
4668: fnd_log.STRING
4669: (fnd_log.level_event,
4670: g_module_current

Line 4668: fnd_log.STRING

4664: );
4665:
4666: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4667: THEN
4668: fnd_log.STRING
4669: (fnd_log.level_event,
4670: g_module_current
4671: || '.CREATE_SALES_CREDITS.External_call.after',
4672: 'OKS_SALES_CREDIT_PUB.Insert_Sales_credit(x_return_status = '

Line 4669: (fnd_log.level_event,

4665:
4666: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4667: THEN
4668: fnd_log.STRING
4669: (fnd_log.level_event,
4670: g_module_current
4671: || '.CREATE_SALES_CREDITS.External_call.after',
4672: 'OKS_SALES_CREDIT_PUB.Insert_Sales_credit(x_return_status = '
4673: || x_return_status

Line 4699: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level

4695: g_sqlerrm_token,
4696: SQLERRM
4697: );
4698:
4699: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4700: THEN
4701: fnd_log.STRING (fnd_log.level_unexpected,
4702: g_module_current
4703: || '.CREATE_SALES_CREDITS.UNEXPECTED',

Line 4701: fnd_log.STRING (fnd_log.level_unexpected,

4697: );
4698:
4699: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4700: THEN
4701: fnd_log.STRING (fnd_log.level_unexpected,
4702: g_module_current
4703: || '.CREATE_SALES_CREDITS.UNEXPECTED',
4704: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
4705: || SQLERRM