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 1041: IF fnd_log.level_error >= fnd_log.g_current_runtime_level

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

Line 1043: fnd_log.STRING (fnd_log.level_error,

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

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

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

Line 1060: fnd_log.STRING (fnd_log.level_statement,

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

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

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

Line 1075: fnd_log.STRING (fnd_log.level_error,

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

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

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

Line 1097: fnd_log.STRING (fnd_log.level_error,

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

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

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

Line 1123: fnd_log.STRING (fnd_log.level_statement,

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

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

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

Line 1139: fnd_log.STRING (fnd_log.level_event,

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

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

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

Line 1173: fnd_log.STRING (fnd_log.level_event,

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

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

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

Line 1201: fnd_log.STRING (fnd_log.level_statement,

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

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

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

Line 1220: fnd_log.STRING (fnd_log.level_error,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1380: g_sqlerrm_token,
1381: SQLERRM
1382: );
1383:
1384: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
1385: THEN
1386: fnd_log.STRING (fnd_log.level_unexpected,
1387: g_module_current
1388: || '.GET_WARRANTY_INFO.UNEXPECTED',

Line 1386: fnd_log.STRING (fnd_log.level_unexpected,

1382: );
1383:
1384: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
1385: THEN
1386: fnd_log.STRING (fnd_log.level_unexpected,
1387: g_module_current
1388: || '.GET_WARRANTY_INFO.UNEXPECTED',
1389: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
1390: || SQLERRM

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

1515: BEGIN
1516: x_return_status := l_return_status;
1517: p_hdr_id := get_order_header_id (p_order_line_id);
1518:
1519: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1520: THEN
1521: fnd_log.STRING (fnd_log.level_statement,
1522: g_module_current
1523: || '.GET_CONTRACT_HEADER_INFO.order header',

Line 1521: fnd_log.STRING (fnd_log.level_statement,

1517: p_hdr_id := get_order_header_id (p_order_line_id);
1518:
1519: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1520: THEN
1521: fnd_log.STRING (fnd_log.level_statement,
1522: g_module_current
1523: || '.GET_CONTRACT_HEADER_INFO.order header',
1524: 'Order header id = ' || p_hdr_id
1525: );

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

1526: END IF;
1527:
1528: IF p_hdr_id IS NULL
1529: THEN
1530: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1531: THEN
1532: fnd_log.STRING (fnd_log.level_error,
1533: g_module_current
1534: || '.GET_CONTRACT_HEADER_INFO.ERROR: ',

Line 1532: fnd_log.STRING (fnd_log.level_error,

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

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

1563: INTO l_ord_hdr_rec;
1564:
1565: IF l_ord_hdr_csr%NOTFOUND
1566: THEN
1567: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1568: THEN
1569: fnd_log.STRING (fnd_log.level_error,
1570: g_module_current
1571: || '.GET_CONTRACT_HEADER_INFO.ERROR: ',

Line 1569: fnd_log.STRING (fnd_log.level_error,

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

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

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

Line 1604: fnd_log.STRING (fnd_log.level_statement,

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

Line 1609: fnd_log.STRING (fnd_log.level_statement,

1605: g_module_current
1606: || '.GET_CONTRACT_HEADER_INFO.order header',
1607: 'After querying the header'
1608: );
1609: fnd_log.STRING (fnd_log.level_statement,
1610: g_module_current
1611: || '.GET_CONTRACT_HEADER_INFO.order header',
1612: 'l_Ord_hdr_rec.tax_point_code: '
1613: || l_ord_hdr_rec.tax_point_code

Line 1615: fnd_log.STRING (fnd_log.level_statement,

1611: || '.GET_CONTRACT_HEADER_INFO.order header',
1612: 'l_Ord_hdr_rec.tax_point_code: '
1613: || l_ord_hdr_rec.tax_point_code
1614: );
1615: fnd_log.STRING (fnd_log.level_statement,
1616: g_module_current
1617: || '.GET_CONTRACT_HEADER_INFO.order header',
1618: 'l_Ord_hdr_rec.tax_exempt_reason_code: '
1619: || l_ord_hdr_rec.tax_exempt_reason_code

Line 1621: fnd_log.STRING (fnd_log.level_statement,

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

Line 1627: fnd_log.STRING (fnd_log.level_statement,

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

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

1648: INTO l_party_id;
1649:
1650: IF l_party_csr%NOTFOUND
1651: THEN
1652: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1653: THEN
1654: fnd_log.STRING (fnd_log.level_error,
1655: g_module_current
1656: || '.GET_CONTRACT_HEADER_INFO.ERROR: ',

Line 1654: fnd_log.STRING (fnd_log.level_error,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1783: INTO l_tax_id2;
1784:
1785: IF l_tax_flag_csr%NOTFOUND
1786: THEN
1787: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1788: THEN
1789: fnd_log.STRING (fnd_log.level_error,
1790: g_module_current
1791: || '.GET_CONTRACT_HEADER_INFO.ERROR',

Line 1789: fnd_log.STRING (fnd_log.level_error,

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

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

1863: g_sqlerrm_token,
1864: SQLERRM
1865: );
1866:
1867: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
1868: THEN
1869: fnd_log.STRING (fnd_log.level_unexpected,
1870: g_module_current
1871: || '.GET_CONTRACT_HEADER_INFO.UNEXPECTED',

Line 1869: fnd_log.STRING (fnd_log.level_unexpected,

1865: );
1866:
1867: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
1868: THEN
1869: fnd_log.STRING (fnd_log.level_unexpected,
1870: g_module_current
1871: || '.GET_CONTRACT_HEADER_INFO.UNEXPECTED',
1872: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
1873: || SQLERRM

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

1942: IF l_ord_line_csr%NOTFOUND
1943: THEN
1944: CLOSE l_ord_line_csr;
1945:
1946: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1947: THEN
1948: fnd_log.STRING (fnd_log.level_error,
1949: g_module_current
1950: || '.GET_CONTRACT_LINE_INFO.ERROR',

Line 1948: fnd_log.STRING (fnd_log.level_error,

1944: CLOSE l_ord_line_csr;
1945:
1946: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1947: THEN
1948: fnd_log.STRING (fnd_log.level_error,
1949: g_module_current
1950: || '.GET_CONTRACT_LINE_INFO.ERROR',
1951: 'l_ord_line_csr not found for line id = '
1952: || p_order_line_id

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

1972: IF l_segment_csr%NOTFOUND
1973: THEN
1974: CLOSE l_segment_csr;
1975:
1976: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
1977: THEN
1978: fnd_log.STRING (fnd_log.level_error,
1979: g_module_current
1980: || '.GET_CONTRACT_LINE_INFO.ERROR',

Line 1978: fnd_log.STRING (fnd_log.level_error,

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

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

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

Line 2013: fnd_log.STRING (fnd_log.level_statement,

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

Line 2018: fnd_log.STRING (fnd_log.level_statement,

2014: g_module_current
2015: || '.GET_CONTRACT_LINE_INFO.order line',
2016: 'After querying the line'
2017: );
2018: fnd_log.STRING (fnd_log.level_statement,
2019: g_module_current
2020: || '.GET_CONTRACT_LINE_INFO.order line',
2021: 'l_ord_line_rec.tax_point_code: '
2022: || l_ord_line_rec.tax_point_code

Line 2024: fnd_log.STRING (fnd_log.level_statement,

2020: || '.GET_CONTRACT_LINE_INFO.order line',
2021: 'l_ord_line_rec.tax_point_code: '
2022: || l_ord_line_rec.tax_point_code
2023: );
2024: fnd_log.STRING (fnd_log.level_statement,
2025: g_module_current
2026: || '.GET_CONTRACT_LINE_INFO.order line',
2027: 'l_ord_line_rec.tax_exempt_reason_code: '
2028: || l_ord_line_rec.tax_exempt_reason_code

Line 2030: fnd_log.STRING (fnd_log.level_statement,

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

Line 2036: fnd_log.STRING (fnd_log.level_statement,

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

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

2069: g_sqlerrm_token,
2070: SQLERRM
2071: );
2072:
2073: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2074: THEN
2075: fnd_log.STRING (fnd_log.level_unexpected,
2076: g_module_current
2077: || '.GET_CONTRACT_LINE_INFO.UNEXPECTED',

Line 2075: fnd_log.STRING (fnd_log.level_unexpected,

2071: );
2072:
2073: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2074: THEN
2075: fnd_log.STRING (fnd_log.level_unexpected,
2076: g_module_current
2077: || '.GET_CONTRACT_LINE_INFO.UNEXPECTED',
2078: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
2079: || SQLERRM

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

2183: l_line_tax_status VARCHAR2 (40);
2184: BEGIN
2185: x_return_status := l_return_status;
2186:
2187: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2188: THEN
2189: fnd_log.STRING (fnd_log.level_statement,
2190: g_module_current || '.GET_K_SERVICE_LINE.Order line',
2191: ' *************************************************'

Line 2189: fnd_log.STRING (fnd_log.level_statement,

2185: x_return_status := l_return_status;
2186:
2187: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2188: THEN
2189: fnd_log.STRING (fnd_log.level_statement,
2190: g_module_current || '.GET_K_SERVICE_LINE.Order line',
2191: ' *************************************************'
2192: );
2193: fnd_log.STRING (fnd_log.level_statement,

Line 2193: fnd_log.STRING (fnd_log.level_statement,

2189: fnd_log.STRING (fnd_log.level_statement,
2190: g_module_current || '.GET_K_SERVICE_LINE.Order line',
2191: ' *************************************************'
2192: );
2193: fnd_log.STRING (fnd_log.level_statement,
2194: g_module_current || '.GET_K_SERVICE_LINE.Order line',
2195: 'Processing Order line id ' || p_order_line_id
2196: );
2197: fnd_log.STRING (fnd_log.level_statement,

Line 2197: fnd_log.STRING (fnd_log.level_statement,

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

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

2206: INTO l_ord_line_rec;
2207:
2208: IF l_ord_line_csr%NOTFOUND
2209: THEN
2210: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2211: THEN
2212: fnd_log.STRING (fnd_log.level_error,
2213: g_module_current || '.GET_K_SERVICE_LINE.ERROR',
2214: 'l_Ord_line_csr not found for Order Line = '

Line 2212: fnd_log.STRING (fnd_log.level_error,

2208: IF l_ord_line_csr%NOTFOUND
2209: THEN
2210: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2211: THEN
2212: fnd_log.STRING (fnd_log.level_error,
2213: g_module_current || '.GET_K_SERVICE_LINE.ERROR',
2214: 'l_Ord_line_csr not found for Order Line = '
2215: || p_order_line_id
2216: );

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

2244: IF l_ord_line_rec.service_end_date IS NULL
2245: AND l_ord_line_rec.service_period IS NULL
2246: AND l_ord_line_rec.service_duration IS NULL
2247: THEN
2248: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2249: THEN
2250: fnd_log.STRING (fnd_log.level_error,
2251: g_module_current || '.GET_K_SERVICE_LINE.ERROR',
2252: 'End Date, Duration, Period Required '

Line 2250: fnd_log.STRING (fnd_log.level_error,

2246: AND l_ord_line_rec.service_duration IS NULL
2247: THEN
2248: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2249: THEN
2250: fnd_log.STRING (fnd_log.level_error,
2251: g_module_current || '.GET_K_SERVICE_LINE.ERROR',
2252: 'End Date, Duration, Period Required '
2253: );
2254: END IF;

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

2287: l_ord_line_rec.service_duration
2288: );
2289: END IF;
2290:
2291: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2292: THEN
2293: fnd_log.STRING (fnd_log.level_statement,
2294: g_module_current
2295: || '.GET_K_SERVICE_LINE.Service Dates',

Line 2293: fnd_log.STRING (fnd_log.level_statement,

2289: END IF;
2290:
2291: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2292: THEN
2293: fnd_log.STRING (fnd_log.level_statement,
2294: g_module_current
2295: || '.GET_K_SERVICE_LINE.Service Dates',
2296: 'Start date = '
2297: || l_start_date

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

2322: l_ord_line_rec.service_period,
2323: l_ord_line_rec.service_duration
2324: );
2325:
2326: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2327: THEN
2328: fnd_log.STRING
2329: (fnd_log.level_statement,
2330: g_module_current

Line 2328: fnd_log.STRING

2324: );
2325:
2326: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2327: THEN
2328: fnd_log.STRING
2329: (fnd_log.level_statement,
2330: g_module_current
2331: || '.GET_K_SERVICE_LINE.Service Dates after cascading',
2332: 'Start date = '

Line 2329: (fnd_log.level_statement,

2325:
2326: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2327: THEN
2328: fnd_log.STRING
2329: (fnd_log.level_statement,
2330: g_module_current
2331: || '.GET_K_SERVICE_LINE.Service Dates after cascading',
2332: 'Start date = '
2333: || l_start_date

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

2335: || l_end_date
2336: );
2337: END IF;
2338: ELSE
2339: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2340: THEN
2341: fnd_log.STRING (fnd_log.level_procedure,
2342: g_module_current
2343: || '.GET_K_SERVICE_LINE.Install ship Dates',

Line 2341: fnd_log.STRING (fnd_log.level_procedure,

2337: END IF;
2338: ELSE
2339: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2340: THEN
2341: fnd_log.STRING (fnd_log.level_procedure,
2342: g_module_current
2343: || '.GET_K_SERVICE_LINE.Install ship Dates',
2344: 'Installation_date= '
2345: || p_installation_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- no warranty',
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- no warranty',
2372: 'Start date = '
2373: || l_start_date

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

2381: END IF;
2382:
2383: IF l_start_date IS NULL
2384: THEN
2385: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2386: THEN
2387: fnd_log.STRING (fnd_log.level_error,
2388: g_module_current || '.GET_K_SERVICE_LINE.ERROR',
2389: ' Null Start Date'

Line 2387: fnd_log.STRING (fnd_log.level_error,

2383: IF l_start_date IS NULL
2384: THEN
2385: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2386: THEN
2387: fnd_log.STRING (fnd_log.level_error,
2388: g_module_current || '.GET_K_SERVICE_LINE.ERROR',
2389: ' Null Start Date'
2390: );
2391: END IF;

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

2412: END IF;
2413:
2414: IF l_end_date IS NULL
2415: THEN
2416: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2417: THEN
2418: fnd_log.STRING (fnd_log.level_error,
2419: g_module_current || '.GET_K_SERVICE_LINE.ERROR',
2420: ' Null End Date'

Line 2418: fnd_log.STRING (fnd_log.level_error,

2414: IF l_end_date IS NULL
2415: THEN
2416: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2417: THEN
2418: fnd_log.STRING (fnd_log.level_error,
2419: g_module_current || '.GET_K_SERVICE_LINE.ERROR',
2420: ' Null End Date'
2421: );
2422: END IF;

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

2506: g_sqlerrm_token,
2507: SQLERRM
2508: );
2509:
2510: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2511: THEN
2512: fnd_log.STRING (fnd_log.level_unexpected,
2513: g_module_current
2514: || '.GET_K_SERVICE_LINE.UNEXPECTED',

Line 2512: fnd_log.STRING (fnd_log.level_unexpected,

2508: );
2509:
2510: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2511: THEN
2512: fnd_log.STRING (fnd_log.level_unexpected,
2513: g_module_current
2514: || '.GET_K_SERVICE_LINE.UNEXPECTED',
2515: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
2516: || SQLERRM

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

2559: THEN
2560: x_immediate_service_status := 'N';
2561: l_return_status := okc_api.g_ret_sts_error;
2562:
2563: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2564: THEN
2565: fnd_log.STRING (fnd_log.level_error,
2566: g_module_current
2567: || '.CHECK_IMMEDIATE_SERVICE.ERROR',

Line 2565: fnd_log.STRING (fnd_log.level_error,

2561: l_return_status := okc_api.g_ret_sts_error;
2562:
2563: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2564: THEN
2565: fnd_log.STRING (fnd_log.level_error,
2566: g_module_current
2567: || '.CHECK_IMMEDIATE_SERVICE.ERROR',
2568: 'Order Header Id NULL for Order line Id '
2569: || p_order_line_id

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

2619: g_sqlerrm_token,
2620: SQLERRM
2621: );
2622:
2623: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2624: THEN
2625: fnd_log.STRING (fnd_log.level_unexpected,
2626: g_module_current
2627: || '.CHECK_IMMEDIATE_SERVICE.UNEXPECTED',

Line 2625: fnd_log.STRING (fnd_log.level_unexpected,

2621: );
2622:
2623: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2624: THEN
2625: fnd_log.STRING (fnd_log.level_unexpected,
2626: g_module_current
2627: || '.CHECK_IMMEDIATE_SERVICE.UNEXPECTED',
2628: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
2629: || SQLERRM

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

2687: l_ord_hdr_id := get_order_header_id (p_order_line_id);
2688:
2689: IF l_ord_hdr_id IS NULL
2690: THEN
2691: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2692: THEN
2693: fnd_log.STRING (fnd_log.level_error,
2694: g_module_current || '.CHECK_DELAYED_SERVICE.ERROR',
2695: 'Invalid Order Line Id ' || p_order_line_id

Line 2693: fnd_log.STRING (fnd_log.level_error,

2689: IF l_ord_hdr_id IS NULL
2690: THEN
2691: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
2692: THEN
2693: fnd_log.STRING (fnd_log.level_error,
2694: g_module_current || '.CHECK_DELAYED_SERVICE.ERROR',
2695: 'Invalid Order Line Id ' || p_order_line_id
2696: );
2697: END IF;

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

2754: WHEN OTHERS
2755: THEN
2756: x_return_status := okc_api.g_ret_sts_unexp_error;
2757:
2758: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2759: THEN
2760: fnd_log.STRING (fnd_log.level_unexpected,
2761: g_module_current
2762: || '.CHECK_DELAYED_SERVICE.UNEXPECTED',

Line 2760: fnd_log.STRING (fnd_log.level_unexpected,

2756: x_return_status := okc_api.g_ret_sts_unexp_error;
2757:
2758: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2759: THEN
2760: fnd_log.STRING (fnd_log.level_unexpected,
2761: g_module_current
2762: || '.CHECK_DELAYED_SERVICE.UNEXPECTED',
2763: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
2764: || SQLERRM

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

3121: INTO l_rel_id;
3122:
3123: CLOSE l_rel_csr;
3124:
3125: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3126: THEN
3127: fnd_log.STRING (fnd_log.level_statement,
3128: g_module_current
3129: || '.GET_CONTRACT_DETAILS.After l_rel_csr',

Line 3127: fnd_log.STRING (fnd_log.level_statement,

3123: CLOSE l_rel_csr;
3124:
3125: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3126: THEN
3127: fnd_log.STRING (fnd_log.level_statement,
3128: g_module_current
3129: || '.GET_CONTRACT_DETAILS.After l_rel_csr',
3130: 'Service Order line id = ' || l_rel_id
3131: );

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

3264: g_sqlerrm_token,
3265: SQLERRM
3266: );
3267:
3268: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3269: THEN
3270: fnd_log.STRING (fnd_log.level_unexpected,
3271: g_module_current
3272: || '.GET_CONTRACT_DETAILS.UNEXPECTED',

Line 3270: fnd_log.STRING (fnd_log.level_unexpected,

3266: );
3267:
3268: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3269: THEN
3270: fnd_log.STRING (fnd_log.level_unexpected,
3271: g_module_current
3272: || '.GET_CONTRACT_DETAILS.UNEXPECTED',
3273: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
3274: || SQLERRM

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

3535:
3536: IF p_prod_item_id IS NULL
3537: THEN
3538: --or p_customer_product_id is NULL
3539: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
3540: THEN
3541: fnd_log.STRING (fnd_log.level_error,
3542: g_module_current || '.GET_WARRANTY_INFO.ERROR',
3543: 'Product Item Id Required'

Line 3541: fnd_log.STRING (fnd_log.level_error,

3537: THEN
3538: --or p_customer_product_id is NULL
3539: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
3540: THEN
3541: fnd_log.STRING (fnd_log.level_error,
3542: g_module_current || '.GET_WARRANTY_INFO.ERROR',
3543: 'Product Item Id Required'
3544: );
3545: END IF;

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

3555: x_war_item_tbl => l_warranty_tbl,
3556: x_common_bill_seq_id => l_comm_bill_seq_id
3557: );
3558:
3559: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3560: THEN
3561: fnd_log.STRING (fnd_log.level_event,
3562: g_module_current
3563: || '.GET_WARRANTY_INFO.Internal_call.after',

Line 3561: fnd_log.STRING (fnd_log.level_event,

3557: );
3558:
3559: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3560: THEN
3561: fnd_log.STRING (fnd_log.level_event,
3562: g_module_current
3563: || '.GET_WARRANTY_INFO.Internal_call.after',
3564: 'Get_war_item_id(Return status = '
3565: || l_return_status

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

3589: p_war_date => p_date,
3590: x_return_status => l_return_status
3591: );
3592:
3593: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3594: THEN
3595: fnd_log.STRING (fnd_log.level_event,
3596: g_module_current
3597: || '.GET_WARRANTY_INFO.Internal call.after',

Line 3595: fnd_log.STRING (fnd_log.level_event,

3591: );
3592:
3593: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3594: THEN
3595: fnd_log.STRING (fnd_log.level_event,
3596: g_module_current
3597: || '.GET_WARRANTY_INFO.Internal call.after',
3598: 'Get_War_Dur_Per(Return status = '
3599: || l_return_status

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

3634: g_sqlerrm_token,
3635: SQLERRM
3636: );
3637:
3638: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3639: THEN
3640: fnd_log.STRING (fnd_log.level_unexpected,
3641: g_module_current
3642: || '.GET_WARRANTY_INFO.UNEXPECTED',

Line 3640: fnd_log.STRING (fnd_log.level_unexpected,

3636: );
3637:
3638: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3639: THEN
3640: fnd_log.STRING (fnd_log.level_unexpected,
3641: g_module_current
3642: || '.GET_WARRANTY_INFO.UNEXPECTED',
3643: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
3644: || SQLERRM

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

3710: IF cust_csr%NOTFOUND
3711: THEN
3712: CLOSE cust_csr;
3713:
3714: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
3715: THEN
3716: fnd_log.STRING (fnd_log.level_error,
3717: g_module_current || '.GET_TRANSFER_DETAILS.ERROR',
3718: ' Cust_csr Not Found '

Line 3716: fnd_log.STRING (fnd_log.level_error,

3712: CLOSE cust_csr;
3713:
3714: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
3715: THEN
3716: fnd_log.STRING (fnd_log.level_error,
3717: g_module_current || '.GET_TRANSFER_DETAILS.ERROR',
3718: ' Cust_csr Not Found '
3719: );
3720: END IF;

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

3729: END IF;
3730:
3731: CLOSE cust_csr;
3732:
3733: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3734: THEN
3735: fnd_log.STRING (fnd_log.level_statement,
3736: g_module_current || '.GET_TRANSFER_DETAILS',
3737: ' Original order line Id = '

Line 3735: fnd_log.STRING (fnd_log.level_statement,

3731: CLOSE cust_csr;
3732:
3733: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3734: THEN
3735: fnd_log.STRING (fnd_log.level_statement,
3736: g_module_current || '.GET_TRANSFER_DETAILS',
3737: ' Original order line Id = '
3738: || cust_rec.original_order_line_id
3739: );

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

3823: g_sqlerrm_token,
3824: SQLERRM
3825: );
3826:
3827: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3828: THEN
3829: fnd_log.STRING (fnd_log.level_unexpected,
3830: g_module_current
3831: || '.GET_TRANSFER_DETAILS.UNEXPECTED',

Line 3829: fnd_log.STRING (fnd_log.level_unexpected,

3825: );
3826:
3827: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3828: THEN
3829: fnd_log.STRING (fnd_log.level_unexpected,
3830: g_module_current
3831: || '.GET_TRANSFER_DETAILS.UNEXPECTED',
3832: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
3833: || SQLERRM

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

4009: WHEN OTHERS
4010: THEN
4011: x_return_status := okc_api.g_ret_sts_unexp_error;
4012:
4013: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4014: THEN
4015: fnd_log.STRING (fnd_log.level_unexpected,
4016: g_module_current || '.SALESCREDIT.UNEXPECTED',
4017: 'sqlcode = ' || SQLCODE || ', sqlerrm = '

Line 4015: fnd_log.STRING (fnd_log.level_unexpected,

4011: x_return_status := okc_api.g_ret_sts_unexp_error;
4012:
4013: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4014: THEN
4015: fnd_log.STRING (fnd_log.level_unexpected,
4016: g_module_current || '.SALESCREDIT.UNEXPECTED',
4017: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
4018: || SQLERRM
4019: );

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

4063: WHEN OTHERS
4064: THEN
4065: x_return_status := okc_api.g_ret_sts_unexp_error;
4066:
4067: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4068: THEN
4069: fnd_log.STRING (fnd_log.level_unexpected,
4070: g_module_current || '.SALESCREDIT_HDR.UNEXPECTED',
4071: 'sqlcode = ' || SQLCODE || ', sqlerrm = '

Line 4069: fnd_log.STRING (fnd_log.level_unexpected,

4065: x_return_status := okc_api.g_ret_sts_unexp_error;
4066:
4067: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4068: THEN
4069: fnd_log.STRING (fnd_log.level_unexpected,
4070: g_module_current || '.SALESCREDIT_HDR.UNEXPECTED',
4071: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
4072: || SQLERRM
4073: );

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

4130: IF l_link_csr1%NOTFOUND
4131: THEN
4132: CLOSE l_link_csr1;
4133:
4134: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
4135: THEN
4136: fnd_log.STRING (fnd_log.level_error,
4137: g_module_current
4138: || '.UPDATE_CONTRACT_DETAILS.ERROR',

Line 4136: fnd_log.STRING (fnd_log.level_error,

4132: CLOSE l_link_csr1;
4133:
4134: IF fnd_log.level_error >= fnd_log.g_current_runtime_level
4135: THEN
4136: fnd_log.STRING (fnd_log.level_error,
4137: g_module_current
4138: || '.UPDATE_CONTRACT_DETAILS.ERROR',
4139: 'l_line_csr1 Not Found for Line Id = '
4140: || p_order_line_id

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

4173: p_codv_tbl => l_codv_tbl_in,
4174: x_codv_tbl => l_codv_tbl_out
4175: );
4176:
4177: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4178: THEN
4179: fnd_log.STRING (fnd_log.level_event,
4180: g_module_current
4181: || '.UPDATE_CONTRACT_DETAILS.External_call.after',

Line 4179: fnd_log.STRING (fnd_log.level_event,

4175: );
4176:
4177: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4178: THEN
4179: fnd_log.STRING (fnd_log.level_event,
4180: g_module_current
4181: || '.UPDATE_CONTRACT_DETAILS.External_call.after',
4182: 'OKS_COD_PVT.update_row(Return Status = '
4183: || l_return_status

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

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

Line 4223: fnd_log.STRING (fnd_log.level_event,

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

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

4252: g_sqlerrm_token,
4253: SQLERRM
4254: );
4255:
4256: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4257: THEN
4258: fnd_log.STRING (fnd_log.level_unexpected,
4259: g_module_current
4260: || '.UPDATE_CONTRACT_DETAILS.UNEXPECTED',

Line 4258: fnd_log.STRING (fnd_log.level_unexpected,

4254: );
4255:
4256: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4257: THEN
4258: fnd_log.STRING (fnd_log.level_unexpected,
4259: g_module_current
4260: || '.UPDATE_CONTRACT_DETAILS.UNEXPECTED',
4261: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
4262: || SQLERRM

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

4343: g_sqlerrm_token,
4344: SQLERRM
4345: );
4346:
4347: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4348: THEN
4349: fnd_log.STRING (fnd_log.level_unexpected,
4350: g_module_current
4351: || '.GET_PRICING_ATTRIBUTES.UNEXPECTED',

Line 4349: fnd_log.STRING (fnd_log.level_unexpected,

4345: );
4346:
4347: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4348: THEN
4349: fnd_log.STRING (fnd_log.level_unexpected,
4350: g_module_current
4351: || '.GET_PRICING_ATTRIBUTES.UNEXPECTED',
4352: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
4353: || SQLERRM

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

4434: g_sqlerrm_token,
4435: SQLERRM
4436: );
4437:
4438: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4439: THEN
4440: fnd_log.STRING (fnd_log.level_unexpected,
4441: g_module_current
4442: || '.GET_K_PRICING_ATTRIBUTES.UNEXPECTED',

Line 4440: fnd_log.STRING (fnd_log.level_unexpected,

4436: );
4437:
4438: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4439: THEN
4440: fnd_log.STRING (fnd_log.level_unexpected,
4441: g_module_current
4442: || '.GET_K_PRICING_ATTRIBUTES.UNEXPECTED',
4443: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
4444: || SQLERRM

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

4616: p_scrv_tbl => l_scrv_tbl_in,
4617: x_scrv_tbl => l_scrv_tbl_out
4618: );
4619:
4620: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4621: THEN
4622: fnd_log.STRING
4623: (fnd_log.level_event,
4624: g_module_current

Line 4622: fnd_log.STRING

4618: );
4619:
4620: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4621: THEN
4622: fnd_log.STRING
4623: (fnd_log.level_event,
4624: g_module_current
4625: || '.CREATE_SALES_CREDITS.External_call.after',
4626: 'OKS_SALES_CREDIT_PUB.Insert_Sales_credit(x_return_status = '

Line 4623: (fnd_log.level_event,

4619:
4620: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4621: THEN
4622: fnd_log.STRING
4623: (fnd_log.level_event,
4624: g_module_current
4625: || '.CREATE_SALES_CREDITS.External_call.after',
4626: 'OKS_SALES_CREDIT_PUB.Insert_Sales_credit(x_return_status = '
4627: || x_return_status

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

4649: g_sqlerrm_token,
4650: SQLERRM
4651: );
4652:
4653: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4654: THEN
4655: fnd_log.STRING (fnd_log.level_unexpected,
4656: g_module_current
4657: || '.CREATE_SALES_CREDITS.UNEXPECTED',

Line 4655: fnd_log.STRING (fnd_log.level_unexpected,

4651: );
4652:
4653: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
4654: THEN
4655: fnd_log.STRING (fnd_log.level_unexpected,
4656: g_module_current
4657: || '.CREATE_SALES_CREDITS.UNEXPECTED',
4658: 'sqlcode = ' || SQLCODE || ', sqlerrm = '
4659: || SQLERRM