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.OKE_IMPORT_CONTRACT_PUB dependencies on FND_MESSAGE

Line 812: fnd_message.set_name('OKE', 'OKE_DTS_DATA_ITEM');

808:
809:
810:
811: if p_del_Rec.item_id is null then
812: fnd_message.set_name('OKE', 'OKE_DTS_DATA_ITEM');
813: l_msg := fnd_message.get;
814:
815: if l_count = 0 then
816: l_message := l_msg;

Line 813: l_msg := fnd_message.get;

809:
810:
811: if p_del_Rec.item_id is null then
812: fnd_message.set_name('OKE', 'OKE_DTS_DATA_ITEM');
813: l_msg := fnd_message.get;
814:
815: if l_count = 0 then
816: l_message := l_msg;
817: l_count := 1;

Line 825: fnd_message.set_name('OKE', 'OKE_DTS_DATA_UOM_CODE');

821:
822: end if;
823:
824: if p_del_Rec.uom_code is null then
825: fnd_message.set_name('OKE', 'OKE_DTS_DATA_UOM_CODE');
826: l_msg := fnd_message.get;
827:
828: if l_count = 0 then
829: l_message := l_msg;

Line 826: l_msg := fnd_message.get;

822: end if;
823:
824: if p_del_Rec.uom_code is null then
825: fnd_message.set_name('OKE', 'OKE_DTS_DATA_UOM_CODE');
826: l_msg := fnd_message.get;
827:
828: if l_count = 0 then
829: l_message := l_msg;
830: l_count := 1;

Line 838: fnd_message.set_name('OKE', 'OKE_DTS_DATA_QTY');

834:
835: end if;
836:
837: if p_del_Rec.quantity is null then
838: fnd_message.set_name('OKE', 'OKE_DTS_DATA_QTY');
839: l_msg := fnd_message.get;
840: if l_count = 0 then
841: l_message := l_msg;
842: l_count := 1;

Line 839: l_msg := fnd_message.get;

835: end if;
836:
837: if p_del_Rec.quantity is null then
838: fnd_message.set_name('OKE', 'OKE_DTS_DATA_QTY');
839: l_msg := fnd_message.get;
840: if l_count = 0 then
841: l_message := l_msg;
842: l_count := 1;
843: else

Line 850: fnd_message.set_name('OKE', 'OKE_DTS_DATA_INV');

846:
847: end if;
848:
849: if p_del_Rec.inventory_org_id is null then
850: fnd_message.set_name('OKE', 'OKE_DTS_DATA_INV');
851: l_msg := fnd_message.get;
852:
853: if l_count = 0 then
854: l_message := l_msg;

Line 851: l_msg := fnd_message.get;

847: end if;
848:
849: if p_del_Rec.inventory_org_id is null then
850: fnd_message.set_name('OKE', 'OKE_DTS_DATA_INV');
851: l_msg := fnd_message.get;
852:
853: if l_count = 0 then
854: l_message := l_msg;
855: l_count := 1;

Line 863: fnd_message.set_name('OKE', 'OKE_DTS_DATA_DATE');

859:
860: end if;
861:
862: if p_del_Rec.expected_shipment_date is null then
863: fnd_message.set_name('OKE', 'OKE_DTS_DATA_DATE');
864: l_msg := fnd_message.get;
865: if l_count = 0 then
866: l_message := l_msg;
867: l_count := 1;

Line 864: l_msg := fnd_message.get;

860: end if;
861:
862: if p_del_Rec.expected_shipment_date is null then
863: fnd_message.set_name('OKE', 'OKE_DTS_DATA_DATE');
864: l_msg := fnd_message.get;
865: if l_count = 0 then
866: l_message := l_msg;
867: l_count := 1;
868: else

Line 875: fnd_message.set_name('OKE', 'OKE_DTS_DATA_PLAN');

871: end if;
872:
873:
874: if p_del_Rec.ndb_schedule_designator is null then
875: fnd_message.set_name('OKE', 'OKE_DTS_DATA_PLAN');
876: l_msg := fnd_message.get;
877: if l_count = 0 then
878: l_message := l_msg;
879: l_count := 1;

Line 876: l_msg := fnd_message.get;

872:
873:
874: if p_del_Rec.ndb_schedule_designator is null then
875: fnd_message.set_name('OKE', 'OKE_DTS_DATA_PLAN');
876: l_msg := fnd_message.get;
877: if l_count = 0 then
878: l_message := l_msg;
879: l_count := 1;
880: else

Line 950: fnd_message.set_name('OKE', 'OKE_DTS_DATA_ITEM_DESC');

946:
947:
948:
949: if p_del_rec.item_id is null and p_del_rec.description is null then
950: fnd_message.set_name('OKE', 'OKE_DTS_DATA_ITEM_DESC');
951: l_msg := fnd_message.get;
952: if l_count = 0 then
953: l_message := l_msg;
954: l_count := 1;

Line 951: l_msg := fnd_message.get;

947:
948:
949: if p_del_rec.item_id is null and p_del_rec.description is null then
950: fnd_message.set_name('OKE', 'OKE_DTS_DATA_ITEM_DESC');
951: l_msg := fnd_message.get;
952: if l_count = 0 then
953: l_message := l_msg;
954: l_count := 1;
955: else

Line 962: fnd_message.set_name('OKE', 'OKE_DTS_DATA_UOM_CODE');

958:
959: end if;
960:
961: if p_del_rec.uom_code is null then
962: fnd_message.set_name('OKE', 'OKE_DTS_DATA_UOM_CODE');
963: l_msg := fnd_message.get;
964: if l_count = 0 then
965: l_message := l_msg;
966: l_count := 1;

Line 963: l_msg := fnd_message.get;

959: end if;
960:
961: if p_del_rec.uom_code is null then
962: fnd_message.set_name('OKE', 'OKE_DTS_DATA_UOM_CODE');
963: l_msg := fnd_message.get;
964: if l_count = 0 then
965: l_message := l_msg;
966: l_count := 1;
967: else

Line 974: fnd_message.set_name('OKE', 'OKE_DTS_DATA_DATE');

970:
971: end if;
972:
973: if p_del_rec.expected_shipment_date is null then
974: fnd_message.set_name('OKE', 'OKE_DTS_DATA_DATE');
975: l_msg := fnd_message.get;
976: if l_count = 0 then
977: l_message := l_msg;
978: l_count := 1;

Line 975: l_msg := fnd_message.get;

971: end if;
972:
973: if p_del_rec.expected_shipment_date is null then
974: fnd_message.set_name('OKE', 'OKE_DTS_DATA_DATE');
975: l_msg := fnd_message.get;
976: if l_count = 0 then
977: l_message := l_msg;
978: l_count := 1;
979: else

Line 987: fnd_message.set_name('OKE', 'OKE_DTS_DATA_QTY');

983:
984:
985:
986: if p_del_rec.quantity is null then
987: fnd_message.set_name('OKE', 'OKE_DTS_DATA_QTY');
988: l_msg := fnd_message.get;
989: if l_count = 0 then
990: l_message := l_msg;
991: l_count := 1;

Line 988: l_msg := fnd_message.get;

984:
985:
986: if p_del_rec.quantity is null then
987: fnd_message.set_name('OKE', 'OKE_DTS_DATA_QTY');
988: l_msg := fnd_message.get;
989: if l_count = 0 then
990: l_message := l_msg;
991: l_count := 1;
992: else

Line 999: fnd_message.set_name('OKE', 'OKE_DTS_DATA_TO_LOCATION');

995:
996: end if;
997:
998: if p_del_rec.ship_to_location_id is null then
999: fnd_message.set_name('OKE', 'OKE_DTS_DATA_TO_LOCATION');
1000: l_msg := fnd_message.get;
1001: if l_count = 0 then
1002: l_message := l_msg;
1003: l_count := 1;

Line 1000: l_msg := fnd_message.get;

996: end if;
997:
998: if p_del_rec.ship_to_location_id is null then
999: fnd_message.set_name('OKE', 'OKE_DTS_DATA_TO_LOCATION');
1000: l_msg := fnd_message.get;
1001: if l_count = 0 then
1002: l_message := l_msg;
1003: l_count := 1;
1004: else

Line 1011: fnd_message.set_name('OKE', 'OKE_DTS_DATA_FROM_LOCATION');

1007:
1008: end if;
1009:
1010: if p_del_rec.ship_from_location_id is null then
1011: fnd_message.set_name('OKE', 'OKE_DTS_DATA_FROM_LOCATION');
1012: l_msg := fnd_message.get;
1013: if l_count = 0 then
1014: l_message := l_msg;
1015: l_count := 1;

Line 1012: l_msg := fnd_message.get;

1008: end if;
1009:
1010: if p_del_rec.ship_from_location_id is null then
1011: fnd_message.set_name('OKE', 'OKE_DTS_DATA_FROM_LOCATION');
1012: l_msg := fnd_message.get;
1013: if l_count = 0 then
1014: l_message := l_msg;
1015: l_count := 1;
1016: else

Line 1039: fnd_message.set_name('OKE', 'OKE_DTS_NOT_SHIPPABLE');

1035: FETCH ship_c INTO l_value;
1036: CLOSE ship_c;
1037:
1038: if l_value <> 'X' OR l_value is null then
1039: fnd_message.set_name('OKE', 'OKE_DTS_NOT_SHIPPABLE');
1040: l_msg := fnd_message.get;
1041:
1042: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
1043: p_msg_name => 'OKE_INVALID_ITEM',

Line 1040: l_msg := fnd_message.get;

1036: CLOSE ship_c;
1037:
1038: if l_value <> 'X' OR l_value is null then
1039: fnd_message.set_name('OKE', 'OKE_DTS_NOT_SHIPPABLE');
1040: l_msg := fnd_message.get;
1041:
1042: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
1043: p_msg_name => 'OKE_INVALID_ITEM',
1044: p_token1 => 'TOKEN',

Line 1090: fnd_message.set_name('OKE', 'OKE_DTS_SHIPPABLE');

1086: end if; --available for ship
1087:
1088: ELSE
1089: IF p_del_rec.available_for_ship_flag = 'Y' THEN
1090: fnd_message.set_name('OKE', 'OKE_DTS_SHIPPABLE');
1091: l_msg := fnd_message.get;
1092:
1093:
1094:

Line 1091: l_msg := fnd_message.get;

1087:
1088: ELSE
1089: IF p_del_rec.available_for_ship_flag = 'Y' THEN
1090: fnd_message.set_name('OKE', 'OKE_DTS_SHIPPABLE');
1091: l_msg := fnd_message.get;
1092:
1093:
1094:
1095: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

Line 1109: fnd_message.set_name('OKE', 'OKE_DTS_BILLABLE');

1105:
1106: if p_del_rec.ready_to_bill = 'Y' then
1107:
1108: if nvl(p_del_rec.billable_flag, 'N') = 'N' then
1109: fnd_message.set_name('OKE', 'OKE_DTS_BILLABLE');
1110: l_msg := fnd_message.get;
1111:
1112:
1113:

Line 1110: l_msg := fnd_message.get;

1106: if p_del_rec.ready_to_bill = 'Y' then
1107:
1108: if nvl(p_del_rec.billable_flag, 'N') = 'N' then
1109: fnd_message.set_name('OKE', 'OKE_DTS_BILLABLE');
1110: l_msg := fnd_message.get;
1111:
1112:
1113:
1114: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

Line 1130: fnd_message.set_name('OKE', 'OKE_DTS_NOT_BILLABLE');

1126: fetch bill_c into l_value;
1127: close bill_c;
1128:
1129: if l_value <> 'X' or l_value is null then
1130: fnd_message.set_name('OKE', 'OKE_DTS_NOT_BILLABLE');
1131: l_msg := fnd_message.get;
1132:
1133:
1134: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

Line 1131: l_msg := fnd_message.get;

1127: close bill_c;
1128:
1129: if l_value <> 'X' or l_value is null then
1130: fnd_message.set_name('OKE', 'OKE_DTS_NOT_BILLABLE');
1131: l_msg := fnd_message.get;
1132:
1133:
1134: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
1135: p_msg_name => 'OKE_INVALID_ITEM',

Line 1150: fnd_message.set_name('OKE', 'OKE_DTS_NOT_SHIPPABLE');

1146: open ship_c;
1147: fetch ship_c into l_value;
1148: close ship_c;
1149: if l_value <> 'X' or l_value is null then
1150: fnd_message.set_name('OKE', 'OKE_DTS_NOT_SHIPPABLE');
1151: l_msg := fnd_message.get;
1152:
1153: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
1154: p_msg_name => 'OKE_INVALID_ITEM',

Line 1151: l_msg := fnd_message.get;

1147: fetch ship_c into l_value;
1148: close ship_c;
1149: if l_value <> 'X' or l_value is null then
1150: fnd_message.set_name('OKE', 'OKE_DTS_NOT_SHIPPABLE');
1151: l_msg := fnd_message.get;
1152:
1153: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
1154: p_msg_name => 'OKE_INVALID_ITEM',
1155: p_token1 => 'TOKEN',

Line 1180: fnd_message.set_name('OKE', 'OKE_DTS_DATA_DESC');

1176:
1177: if p_del_rec.item_id is null then
1178: if p_del_rec.DESTINATION_TYPE_CODE = 'EXPENSE' then
1179: if p_del_rec.description is null then
1180: fnd_message.set_name('OKE', 'OKE_DTS_DATA_DESC');
1181: l_msg := fnd_message.get;
1182: if l_count = 0 then
1183: l_message := l_msg;
1184: l_count := 1;

Line 1181: l_msg := fnd_message.get;

1177: if p_del_rec.item_id is null then
1178: if p_del_rec.DESTINATION_TYPE_CODE = 'EXPENSE' then
1179: if p_del_rec.description is null then
1180: fnd_message.set_name('OKE', 'OKE_DTS_DATA_DESC');
1181: l_msg := fnd_message.get;
1182: if l_count = 0 then
1183: l_message := l_msg;
1184: l_count := 1;
1185: else

Line 1193: fnd_message.set_name('OKE', 'OKE_DTS_DATA_PO_CATEGORY');

1189:
1190:
1191:
1192: if p_del_rec.po_category_id is null then
1193: fnd_message.set_name('OKE', 'OKE_DTS_DATA_PO_CATEGORY');
1194: l_msg := fnd_message.get;
1195: if l_count = 0 then
1196: l_message := l_msg;
1197: l_count := 1;

Line 1194: l_msg := fnd_message.get;

1190:
1191:
1192: if p_del_rec.po_category_id is null then
1193: fnd_message.set_name('OKE', 'OKE_DTS_DATA_PO_CATEGORY');
1194: l_msg := fnd_message.get;
1195: if l_count = 0 then
1196: l_message := l_msg;
1197: l_count := 1;
1198: else

Line 1204: fnd_message.set_name('OKE', 'OKE_DTS_DATA_UNIT_PRICE');

1200: end if;
1201: end if;
1202:
1203: if p_del_rec.unit_price is null then
1204: fnd_message.set_name('OKE', 'OKE_DTS_DATA_UNIT_PRICE');
1205: l_msg := fnd_message.get;
1206: if l_count = 0 then
1207: l_message := l_msg;
1208: l_count := 1;

Line 1205: l_msg := fnd_message.get;

1201: end if;
1202:
1203: if p_del_rec.unit_price is null then
1204: fnd_message.set_name('OKE', 'OKE_DTS_DATA_UNIT_PRICE');
1205: l_msg := fnd_message.get;
1206: if l_count = 0 then
1207: l_message := l_msg;
1208: l_count := 1;
1209: else

Line 1215: fnd_message.set_name('OKE', 'OKE_DTS_DATA_ITEM_DESC');

1211: end if;
1212: end if;
1213:
1214: else
1215: fnd_message.set_name('OKE', 'OKE_DTS_DATA_ITEM_DESC');
1216: l_msg := fnd_message.get;
1217: if l_count = 0 then
1218: l_message := l_msg;
1219: l_count := 1;

Line 1216: l_msg := fnd_message.get;

1212: end if;
1213:
1214: else
1215: fnd_message.set_name('OKE', 'OKE_DTS_DATA_ITEM_DESC');
1216: l_msg := fnd_message.get;
1217: if l_count = 0 then
1218: l_message := l_msg;
1219: l_count := 1;
1220: else

Line 1227: fnd_message.set_name('OKE', 'OKE_DTS_DATA_QTY');

1223: end if;
1224: end if;
1225:
1226: if p_del_rec.quantity is null then
1227: fnd_message.set_name('OKE', 'OKE_DTS_DATA_QTY');
1228: l_msg := fnd_message.get;
1229: if l_count = 0 then
1230: l_message := l_msg;
1231: l_count := 1;

Line 1228: l_msg := fnd_message.get;

1224: end if;
1225:
1226: if p_del_rec.quantity is null then
1227: fnd_message.set_name('OKE', 'OKE_DTS_DATA_QTY');
1228: l_msg := fnd_message.get;
1229: if l_count = 0 then
1230: l_message := l_msg;
1231: l_count := 1;
1232: else

Line 1239: fnd_message.set_name('OKE', 'OKE_DTS_DATA_TO_LOCATION');

1235:
1236: end if;
1237:
1238: if p_del_rec.ship_to_location_id is null then
1239: fnd_message.set_name('OKE', 'OKE_DTS_DATA_TO_LOCATION');
1240: l_msg := fnd_message.get;
1241: if l_count = 0 then
1242: l_message := l_msg;
1243: l_count := 1;

Line 1240: l_msg := fnd_message.get;

1236: end if;
1237:
1238: if p_del_rec.ship_to_location_id is null then
1239: fnd_message.set_name('OKE', 'OKE_DTS_DATA_TO_LOCATION');
1240: l_msg := fnd_message.get;
1241: if l_count = 0 then
1242: l_message := l_msg;
1243: l_count := 1;
1244: else

Line 1250: fnd_message.set_name('OKE', 'OKE_DTS_DATA_PO_DATE');

1246: end if;
1247: end if;
1248:
1249: if p_del_rec.need_by_date is null then
1250: fnd_message.set_name('OKE', 'OKE_DTS_DATA_PO_DATE');
1251: l_msg := fnd_message.get;
1252: if l_count = 0 then
1253: l_message := l_msg;
1254: l_count := 1;

Line 1251: l_msg := fnd_message.get;

1247: end if;
1248:
1249: if p_del_rec.need_by_date is null then
1250: fnd_message.set_name('OKE', 'OKE_DTS_DATA_PO_DATE');
1251: l_msg := fnd_message.get;
1252: if l_count = 0 then
1253: l_message := l_msg;
1254: l_count := 1;
1255: else

Line 1261: Fnd_Message.Set_Name('OKE', 'OKE_DTS_DATA_DES_CODE');

1257: end if;
1258: end if;
1259:
1260: IF p_del_rec.Destination_Type_Code Is Null Then
1261: Fnd_Message.Set_Name('OKE', 'OKE_DTS_DATA_DES_CODE');
1262: l_msg := fnd_message.get;
1263: If L_Count = 0 Then
1264: L_Message := L_Msg;
1265: L_Count := 1;

Line 1262: l_msg := fnd_message.get;

1258: end if;
1259:
1260: IF p_del_rec.Destination_Type_Code Is Null Then
1261: Fnd_Message.Set_Name('OKE', 'OKE_DTS_DATA_DES_CODE');
1262: l_msg := fnd_message.get;
1263: If L_Count = 0 Then
1264: L_Message := L_Msg;
1265: L_Count := 1;
1266: Else

Line 1277: FND_MESSAGE.Set_Name('OKE', 'OKE_DTS_DATA_TASK');

1273:
1274: IF p_del_rec.PROJECT_ID IS NOT NULL THEN
1275:
1276: IF p_del_rec.TASK_ID IS NULL THEN
1277: FND_MESSAGE.Set_Name('OKE', 'OKE_DTS_DATA_TASK');
1278: L_Msg := FND_MESSAGE.Get;
1279: IF L_Count = 0 THEN
1280: L_Message := L_Msg;
1281: L_Count := 1;

Line 1278: L_Msg := FND_MESSAGE.Get;

1274: IF p_del_rec.PROJECT_ID IS NOT NULL THEN
1275:
1276: IF p_del_rec.TASK_ID IS NULL THEN
1277: FND_MESSAGE.Set_Name('OKE', 'OKE_DTS_DATA_TASK');
1278: L_Msg := FND_MESSAGE.Get;
1279: IF L_Count = 0 THEN
1280: L_Message := L_Msg;
1281: L_Count := 1;
1282: ELSE

Line 1288: Fnd_Message.Set_Name('OKE', 'OKE_DTS_DATA_EXP_ORG_ID');

1284: END IF;
1285: END IF;
1286:
1287: If p_del_rec.Expenditure_Organization_Id Is Null Then
1288: Fnd_Message.Set_Name('OKE', 'OKE_DTS_DATA_EXP_ORG_ID');
1289: L_Msg := Fnd_Message.Get;
1290: If L_Count = 0 Then
1291: L_Message := L_Msg;
1292: L_Count := 1;

Line 1289: L_Msg := Fnd_Message.Get;

1285: END IF;
1286:
1287: If p_del_rec.Expenditure_Organization_Id Is Null Then
1288: Fnd_Message.Set_Name('OKE', 'OKE_DTS_DATA_EXP_ORG_ID');
1289: L_Msg := Fnd_Message.Get;
1290: If L_Count = 0 Then
1291: L_Message := L_Msg;
1292: L_Count := 1;
1293: Else

Line 1299: Fnd_Message.Set_Name('OKE', 'OKE_DTS_DATA_EXP_TYPE');

1295: End If;
1296: End If;
1297:
1298: If p_del_rec.Expenditure_Type Is Null Then
1299: Fnd_Message.Set_Name('OKE', 'OKE_DTS_DATA_EXP_TYPE');
1300: L_Msg := Fnd_Message.Get;
1301: If L_Count = 0 Then
1302: L_Message := L_Msg;
1303: L_Count := 1;

Line 1300: L_Msg := Fnd_Message.Get;

1296: End If;
1297:
1298: If p_del_rec.Expenditure_Type Is Null Then
1299: Fnd_Message.Set_Name('OKE', 'OKE_DTS_DATA_EXP_TYPE');
1300: L_Msg := Fnd_Message.Get;
1301: If L_Count = 0 Then
1302: L_Message := L_Msg;
1303: L_Count := 1;
1304: Else

Line 1310: Fnd_Message.Set_Name('OKE', 'OKE_DTS_DATA_EXP_ITEM_DATE');

1306: End If;
1307: End If;
1308:
1309: If p_del_rec.Expenditure_Item_Date Is Null Then
1310: Fnd_Message.Set_Name('OKE', 'OKE_DTS_DATA_EXP_ITEM_DATE');
1311: L_Msg := Fnd_Message.Get;
1312: If L_Count = 0 Then
1313: L_Message := L_Msg;
1314: L_Count := 1;

Line 1311: L_Msg := Fnd_Message.Get;

1307: End If;
1308:
1309: If p_del_rec.Expenditure_Item_Date Is Null Then
1310: Fnd_Message.Set_Name('OKE', 'OKE_DTS_DATA_EXP_ITEM_DATE');
1311: L_Msg := Fnd_Message.Get;
1312: If L_Count = 0 Then
1313: L_Message := L_Msg;
1314: L_Count := 1;
1315: Else

Line 1344: fnd_message.set_name('OKE', 'OKE_DTS_NOT_PURCHASABLE');

1340: FETCH req_c INTO l_value;
1341: CLOSE req_c;
1342:
1343: if l_value is null or l_value <> 'X' then
1344: fnd_message.set_name('OKE', 'OKE_DTS_NOT_PURCHASABLE');
1345: l_msg := fnd_message.get;
1346:
1347:
1348: OKE_API.SET_MESSAGE(p_app_name => g_app_name,

Line 1345: l_msg := fnd_message.get;

1341: CLOSE req_c;
1342:
1343: if l_value is null or l_value <> 'X' then
1344: fnd_message.set_name('OKE', 'OKE_DTS_NOT_PURCHASABLE');
1345: l_msg := fnd_message.get;
1346:
1347:
1348: OKE_API.SET_MESSAGE(p_app_name => g_app_name,
1349: p_msg_name => 'OKE_INVALID_ITEM',

Line 6445: fnd_message.set_name('OKE', 'OKE_DTS_PROGRESS_MDS');

6441: l_found := c1%found;
6442: close c1;
6443:
6444: if l_found then
6445: fnd_message.set_name('OKE', 'OKE_DTS_PROGRESS_MDS');
6446: l_msg := fnd_message.get;
6447: if l_count = 0 then
6448:
6449: l_message := l_msg;

Line 6446: l_msg := fnd_message.get;

6442: close c1;
6443:
6444: if l_found then
6445: fnd_message.set_name('OKE', 'OKE_DTS_PROGRESS_MDS');
6446: l_msg := fnd_message.get;
6447: if l_count = 0 then
6448:
6449: l_message := l_msg;
6450: l_count := 1;

Line 6482: fnd_message.set_name('OKE', 'OKE_DTS_PROGRESS_REQ');

6478: end if;
6479:
6480:
6481: if l_found then -- interface/po/req rec found
6482: fnd_message.set_name('OKE', 'OKE_DTS_PROGRESS_REQ');
6483: l_msg := fnd_message.get;
6484: if l_count = 0 then
6485: l_message := l_msg;
6486: l_count := 1;

Line 6483: l_msg := fnd_message.get;

6479:
6480:
6481: if l_found then -- interface/po/req rec found
6482: fnd_message.set_name('OKE', 'OKE_DTS_PROGRESS_REQ');
6483: l_msg := fnd_message.get;
6484: if l_count = 0 then
6485: l_message := l_msg;
6486: l_count := 1;
6487: else

Line 6502: fnd_message.set_name('OKE', 'OKE_DTS_PROGRESS_WSH');

6498: l_found := c2%found;
6499: close c2;
6500:
6501: if l_found then
6502: fnd_message.set_name('OKE', 'OKE_DTS_PROGRESS_WSH');
6503: l_msg := fnd_message.get;
6504: if l_count = 0 then
6505: l_message := l_msg;
6506: l_count := 1;

Line 6503: l_msg := fnd_message.get;

6499: close c2;
6500:
6501: if l_found then
6502: fnd_message.set_name('OKE', 'OKE_DTS_PROGRESS_WSH');
6503: l_msg := fnd_message.get;
6504: if l_count = 0 then
6505: l_message := l_msg;
6506: l_count := 1;
6507: else

Line 6516: fnd_message.set_name('OKE', 'OKE_DTS_DATA_COMPLETED');

6512: end if;
6513: end if;
6514:
6515: if nvl(l_completed_flag,'N') = 'Y' then
6516: fnd_message.set_name('OKE', 'OKE_DTS_DATA_COMPLETED');
6517: l_msg := fnd_message.get;
6518: if l_count = 0 then
6519: l_message := l_msg;
6520: l_count := 1;

Line 6517: l_msg := fnd_message.get;

6513: end if;
6514:
6515: if nvl(l_completed_flag,'N') = 'Y' then
6516: fnd_message.set_name('OKE', 'OKE_DTS_DATA_COMPLETED');
6517: l_msg := fnd_message.get;
6518: if l_count = 0 then
6519: l_message := l_msg;
6520: l_count := 1;
6521: else