APPS.IEU_WR_PUB dependencies on FND_MSG_PUB

Line 126: FND_MSG_PUB.INITIALIZE;

122: -- Initialize Message list
123:
124: IF fnd_api.to_boolean(p_init_msg_list)
125: THEN
126: FND_MSG_PUB.INITIALIZE;
127: END IF;
128:
129: -- Check for NOT NULL columns
130:

Line 192: fnd_msg_pub.ADD;

188:
189: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');
190: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
191: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
192: fnd_msg_pub.ADD;
193: fnd_msg_pub.Count_and_Get
194: (
195: p_count => x_msg_count,
196: p_data => x_msg_data

Line 193: fnd_msg_pub.Count_and_Get

189: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');
190: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
191: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
192: fnd_msg_pub.ADD;
193: fnd_msg_pub.Count_and_Get
194: (
195: p_count => x_msg_count,
196: p_data => x_msg_data
197: );

Line 235: fnd_msg_pub.ADD;

231:
232: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
233: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
234: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
235: fnd_msg_pub.ADD;
236: fnd_msg_pub.Count_and_Get
237: (
238: p_count => x_msg_count,
239: p_data => x_msg_data

Line 236: fnd_msg_pub.Count_and_Get

232: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
233: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
234: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
235: fnd_msg_pub.ADD;
236: fnd_msg_pub.Count_and_Get
237: (
238: p_count => x_msg_count,
239: p_data => x_msg_data
240: );

Line 274: fnd_msg_pub.ADD;

270:
271: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
272: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
273: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
274: fnd_msg_pub.ADD;
275: fnd_msg_pub.Count_and_Get
276: (
277: p_count => x_msg_count,
278: p_data => x_msg_data

Line 275: fnd_msg_pub.Count_and_Get

271: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
272: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
273: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
274: fnd_msg_pub.ADD;
275: fnd_msg_pub.Count_and_Get
276: (
277: p_count => x_msg_count,
278: p_data => x_msg_data
279: );

Line 306: fnd_msg_pub.ADD;

302:
303: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
304: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
305: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
306: fnd_msg_pub.ADD;
307: fnd_msg_pub.Count_and_Get
308: (
309: p_count => x_msg_count,
310: p_data => x_msg_data

Line 307: fnd_msg_pub.Count_and_Get

303: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
304: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
305: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
306: fnd_msg_pub.ADD;
307: fnd_msg_pub.Count_and_Get
308: (
309: p_count => x_msg_count,
310: p_data => x_msg_data
311: );

Line 325: fnd_msg_pub.ADD;

321:
322: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_PARAM_EXCEED_MAX');
323: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
324: FND_MESSAGE.SET_TOKEN('IEU_UWQ_PARAM_MAX',' TITLE ');
325: fnd_msg_pub.ADD;
326: fnd_msg_pub.Count_and_Get
327: (
328: p_count => x_msg_count,
329: p_data => x_msg_data

Line 326: fnd_msg_pub.Count_and_Get

322: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_PARAM_EXCEED_MAX');
323: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
324: FND_MESSAGE.SET_TOKEN('IEU_UWQ_PARAM_MAX',' TITLE ');
325: fnd_msg_pub.ADD;
326: fnd_msg_pub.Count_and_Get
327: (
328: p_count => x_msg_count,
329: p_data => x_msg_data
330: );

Line 397: fnd_msg_pub.ADD;

393: end if;
394: end if;
395: FND_MESSAGE.SET_TOKEN('ID_PARAM',l_token_str);
396: FND_MESSAGE.SET_TOKEN('TYPE_PARAM',l_token_str2);
397: fnd_msg_pub.ADD;
398: fnd_msg_pub.Count_and_Get
399: (
400: p_count => x_msg_count,
401: p_data => x_msg_data

Line 398: fnd_msg_pub.Count_and_Get

394: end if;
395: FND_MESSAGE.SET_TOKEN('ID_PARAM',l_token_str);
396: FND_MESSAGE.SET_TOKEN('TYPE_PARAM',l_token_str2);
397: fnd_msg_pub.ADD;
398: fnd_msg_pub.Count_and_Get
399: (
400: p_count => x_msg_count,
401: p_data => x_msg_data
402: );

Line 465: fnd_msg_pub.ADD;

461: l_token_str := 'OBJECT_CODE: '||p_workitem_obj_code;
462: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
463: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
464: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
465: fnd_msg_pub.ADD;
466: fnd_msg_pub.Count_and_Get
467: (
468: p_count => x_msg_count,
469: p_data => x_msg_data

Line 466: fnd_msg_pub.Count_and_Get

462: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
463: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
464: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
465: fnd_msg_pub.ADD;
466: fnd_msg_pub.Count_and_Get
467: (
468: p_count => x_msg_count,
469: p_data => x_msg_data
470: );

Line 545: fnd_msg_pub.ADD;

541: l_token_str := '';
542: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
543: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
544: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
545: fnd_msg_pub.ADD;
546: fnd_msg_pub.Count_and_Get
547: (
548: p_count => x_msg_count,
549: p_data => x_msg_data

Line 546: fnd_msg_pub.Count_and_Get

542: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
543: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
544: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
545: fnd_msg_pub.ADD;
546: fnd_msg_pub.Count_and_Get
547: (
548: p_count => x_msg_count,
549: p_data => x_msg_data
550: );

Line 577: fnd_msg_pub.ADD;

573: l_token_str := '';
574: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
575: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
576: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
577: fnd_msg_pub.ADD;
578: fnd_msg_pub.Count_and_Get
579: (
580: p_count => x_msg_count,
581: p_data => x_msg_data

Line 578: fnd_msg_pub.Count_and_Get

574: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
575: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
576: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
577: fnd_msg_pub.ADD;
578: fnd_msg_pub.Count_and_Get
579: (
580: p_count => x_msg_count,
581: p_data => x_msg_data
582: );

Line 803: fnd_msg_pub.ADD;

799: FND_MESSAGE.SET_NAME('IEU', 'IEU_CREATE_WR_ITEM_FAILED');
800: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
801: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
802:
803: fnd_msg_pub.ADD;
804: fnd_msg_pub.Count_and_Get
805: (
806: p_count => x_msg_count,
807: p_data => x_msg_data

Line 804: fnd_msg_pub.Count_and_Get

800: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
801: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
802:
803: fnd_msg_pub.ADD;
804: fnd_msg_pub.Count_and_Get
805: (
806: p_count => x_msg_count,
807: p_data => x_msg_data
808: );

Line 828: fnd_msg_pub.ADD;

824: FND_MESSAGE.SET_NAME('IEU', 'IEU_CREATE_WR_ITEM_FAILED');
825: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
826: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
827:
828: fnd_msg_pub.ADD;
829: fnd_msg_pub.Count_and_Get
830: (
831: p_count => x_msg_count,
832: p_data => x_msg_data

Line 829: fnd_msg_pub.Count_and_Get

825: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
826: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
827:
828: fnd_msg_pub.ADD;
829: fnd_msg_pub.Count_and_Get
830: (
831: p_count => x_msg_count,
832: p_data => x_msg_data
833: );

Line 851: fnd_msg_pub.Count_and_Get

847:
848: ROLLBACK TO insert_wr_items_sp;
849: x_return_status := fnd_api.g_ret_sts_error;
850:
851: fnd_msg_pub.Count_and_Get
852: (
853: p_count => x_msg_count,
854: p_data => x_msg_data
855: );

Line 862: fnd_msg_pub.Count_and_Get

858:
859: ROLLBACK TO insert_wr_items_sp;
860: x_return_status := fnd_api.g_ret_sts_unexp_error;
861:
862: fnd_msg_pub.Count_and_Get
863: (
864: p_count => x_msg_count,
865: p_data => x_msg_data
866: );

Line 874: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

870:
871: ROLLBACK TO insert_wr_items_sp;
872: x_return_status := fnd_api.g_ret_sts_unexp_error;
873:
874: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
875: THEN
876:
877: fnd_msg_pub.Count_and_Get
878: (

Line 877: fnd_msg_pub.Count_and_Get

873:
874: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
875: THEN
876:
877: fnd_msg_pub.Count_and_Get
878: (
879: p_count => x_msg_count,
880: p_data => x_msg_data
881: );

Line 1001: FND_MSG_PUB.INITIALIZE;

997: -- Initialize Message list
998:
999: IF fnd_api.to_boolean(p_init_msg_list)
1000: THEN
1001: FND_MSG_PUB.INITIALIZE;
1002: END IF;
1003:
1004: -- Check for NOT NULL columns
1005:

Line 1048: fnd_msg_pub.ADD;

1044:
1045: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');
1046: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
1047: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
1048: fnd_msg_pub.ADD;
1049: fnd_msg_pub.Count_and_Get
1050: (
1051: p_count => x_msg_count,
1052: p_data => x_msg_data

Line 1049: fnd_msg_pub.Count_and_Get

1045: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');
1046: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
1047: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
1048: fnd_msg_pub.ADD;
1049: fnd_msg_pub.Count_and_Get
1050: (
1051: p_count => x_msg_count,
1052: p_data => x_msg_data
1053: );

Line 1121: fnd_msg_pub.ADD;

1117:
1118: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
1119: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
1120: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
1121: fnd_msg_pub.ADD;
1122: fnd_msg_pub.Count_and_Get
1123: (
1124: p_count => x_msg_count,
1125: p_data => x_msg_data

Line 1122: fnd_msg_pub.Count_and_Get

1118: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
1119: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
1120: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
1121: fnd_msg_pub.ADD;
1122: fnd_msg_pub.Count_and_Get
1123: (
1124: p_count => x_msg_count,
1125: p_data => x_msg_data
1126: );

Line 1188: fnd_msg_pub.ADD;

1184:
1185: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
1186: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
1187: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
1188: fnd_msg_pub.ADD;
1189: fnd_msg_pub.Count_and_Get
1190: (
1191: p_count => x_msg_count,
1192: p_data => x_msg_data

Line 1189: fnd_msg_pub.Count_and_Get

1185: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
1186: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
1187: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
1188: fnd_msg_pub.ADD;
1189: fnd_msg_pub.Count_and_Get
1190: (
1191: p_count => x_msg_count,
1192: p_data => x_msg_data
1193: );

Line 1212: fnd_msg_pub.ADD;

1208:
1209: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
1210: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
1211: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
1212: fnd_msg_pub.ADD;
1213: fnd_msg_pub.Count_and_Get
1214: (
1215: p_count => x_msg_count,
1216: p_data => x_msg_data

Line 1213: fnd_msg_pub.Count_and_Get

1209: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
1210: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
1211: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
1212: fnd_msg_pub.ADD;
1213: fnd_msg_pub.Count_and_Get
1214: (
1215: p_count => x_msg_count,
1216: p_data => x_msg_data
1217: );

Line 1258: fnd_msg_pub.ADD;

1254:
1255: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
1256: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
1257: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
1258: fnd_msg_pub.ADD;
1259: fnd_msg_pub.Count_and_Get
1260: (
1261: p_count => x_msg_count,
1262: p_data => x_msg_data

Line 1259: fnd_msg_pub.Count_and_Get

1255: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
1256: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
1257: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
1258: fnd_msg_pub.ADD;
1259: fnd_msg_pub.Count_and_Get
1260: (
1261: p_count => x_msg_count,
1262: p_data => x_msg_data
1263: );

Line 1297: fnd_msg_pub.ADD;

1293:
1294: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
1295: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
1296: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
1297: fnd_msg_pub.ADD;
1298: fnd_msg_pub.Count_and_Get
1299: (
1300: p_count => x_msg_count,
1301: p_data => x_msg_data

Line 1298: fnd_msg_pub.Count_and_Get

1294: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
1295: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
1296: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
1297: fnd_msg_pub.ADD;
1298: fnd_msg_pub.Count_and_Get
1299: (
1300: p_count => x_msg_count,
1301: p_data => x_msg_data
1302: );

Line 1327: fnd_msg_pub.ADD;

1323:
1324: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
1325: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
1326: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
1327: fnd_msg_pub.ADD;
1328: fnd_msg_pub.Count_and_Get
1329: (
1330: p_count => x_msg_count,
1331: p_data => x_msg_data

Line 1328: fnd_msg_pub.Count_and_Get

1324: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
1325: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
1326: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
1327: fnd_msg_pub.ADD;
1328: fnd_msg_pub.Count_and_Get
1329: (
1330: p_count => x_msg_count,
1331: p_data => x_msg_data
1332: );

Line 1345: fnd_msg_pub.ADD;

1341:
1342: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_PARAM_EXCEED_MAX');
1343: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
1344: FND_MESSAGE.SET_TOKEN('IEU_UWQ_PARAM_MAX',' TITLE ');
1345: fnd_msg_pub.ADD;
1346: fnd_msg_pub.Count_and_Get
1347: (
1348: p_count => x_msg_count,
1349: p_data => x_msg_data

Line 1346: fnd_msg_pub.Count_and_Get

1342: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_PARAM_EXCEED_MAX');
1343: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
1344: FND_MESSAGE.SET_TOKEN('IEU_UWQ_PARAM_MAX',' TITLE ');
1345: fnd_msg_pub.ADD;
1346: fnd_msg_pub.Count_and_Get
1347: (
1348: p_count => x_msg_count,
1349: p_data => x_msg_data
1350: );

Line 1417: fnd_msg_pub.ADD;

1413: end if;
1414: end if;
1415: FND_MESSAGE.SET_TOKEN('ID_PARAM',l_token_str);
1416: FND_MESSAGE.SET_TOKEN('TYPE_PARAM',l_token_str2);
1417: fnd_msg_pub.ADD;
1418: fnd_msg_pub.Count_and_Get
1419: (
1420: p_count => x_msg_count,
1421: p_data => x_msg_data

Line 1418: fnd_msg_pub.Count_and_Get

1414: end if;
1415: FND_MESSAGE.SET_TOKEN('ID_PARAM',l_token_str);
1416: FND_MESSAGE.SET_TOKEN('TYPE_PARAM',l_token_str2);
1417: fnd_msg_pub.ADD;
1418: fnd_msg_pub.Count_and_Get
1419: (
1420: p_count => x_msg_count,
1421: p_data => x_msg_data
1422: );

Line 1483: fnd_msg_pub.ADD;

1479: l_token_str := 'OBJECT_CODE:' ||p_workitem_obj_code;
1480: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
1481: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
1482: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
1483: fnd_msg_pub.ADD;
1484: fnd_msg_pub.Count_and_Get
1485: (
1486: p_count => x_msg_count,
1487: p_data => x_msg_data

Line 1484: fnd_msg_pub.Count_and_Get

1480: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
1481: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
1482: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
1483: fnd_msg_pub.ADD;
1484: fnd_msg_pub.Count_and_Get
1485: (
1486: p_count => x_msg_count,
1487: p_data => x_msg_data
1488: );

Line 1563: fnd_msg_pub.ADD;

1559: l_token_str := 'OBJECT_CODE: '||p_workitem_obj_code;
1560: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
1561: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
1562: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
1563: fnd_msg_pub.ADD;
1564: fnd_msg_pub.Count_and_Get
1565: (
1566: p_count => x_msg_count,
1567: p_data => x_msg_data

Line 1564: fnd_msg_pub.Count_and_Get

1560: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
1561: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
1562: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
1563: fnd_msg_pub.ADD;
1564: fnd_msg_pub.Count_and_Get
1565: (
1566: p_count => x_msg_count,
1567: p_data => x_msg_data
1568: );

Line 1594: fnd_msg_pub.ADD;

1590: l_token_str := 'OBJECT_CODE: '||p_workitem_obj_code;
1591: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
1592: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
1593: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
1594: fnd_msg_pub.ADD;
1595: fnd_msg_pub.Count_and_Get
1596: (
1597: p_count => x_msg_count,
1598: p_data => x_msg_data

Line 1595: fnd_msg_pub.Count_and_Get

1591: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
1592: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
1593: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
1594: fnd_msg_pub.ADD;
1595: fnd_msg_pub.Count_and_Get
1596: (
1597: p_count => x_msg_count,
1598: p_data => x_msg_data
1599: );

Line 1814: fnd_msg_pub.ADD;

1810: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_WR_ITEM_FAILED');
1811: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
1812: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
1813:
1814: fnd_msg_pub.ADD;
1815: fnd_msg_pub.Count_and_Get
1816: (
1817: p_count => x_msg_count,
1818: p_data => x_msg_data

Line 1815: fnd_msg_pub.Count_and_Get

1811: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
1812: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
1813:
1814: fnd_msg_pub.ADD;
1815: fnd_msg_pub.Count_and_Get
1816: (
1817: p_count => x_msg_count,
1818: p_data => x_msg_data
1819: );

Line 1843: fnd_msg_pub.ADD;

1839: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_WR_ITEM_FAILED');
1840: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
1841: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
1842:
1843: fnd_msg_pub.ADD;
1844: fnd_msg_pub.Count_and_Get
1845: (
1846: p_count => x_msg_count,
1847: p_data => x_msg_data

Line 1844: fnd_msg_pub.Count_and_Get

1840: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
1841: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
1842:
1843: fnd_msg_pub.ADD;
1844: fnd_msg_pub.Count_and_Get
1845: (
1846: p_count => x_msg_count,
1847: p_data => x_msg_data
1848: );

Line 1866: fnd_msg_pub.Count_and_Get

1862:
1863: ROLLBACK TO update_wr_items_sp;
1864: x_return_status := fnd_api.g_ret_sts_error;
1865:
1866: fnd_msg_pub.Count_and_Get
1867: (
1868: p_count => x_msg_count,
1869: p_data => x_msg_data
1870: );

Line 1877: fnd_msg_pub.Count_and_Get

1873:
1874: ROLLBACK TO update_wr_items_sp;
1875: x_return_status := fnd_api.g_ret_sts_unexp_error;
1876:
1877: fnd_msg_pub.Count_and_Get
1878: (
1879: p_count => x_msg_count,
1880: p_data => x_msg_data
1881: );

Line 1889: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1885:
1886: ROLLBACK TO update_wr_items_sp;
1887: x_return_status := fnd_api.g_ret_sts_unexp_error;
1888:
1889: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1890: THEN
1891:
1892: fnd_msg_pub.Count_and_Get
1893: (

Line 1892: fnd_msg_pub.Count_and_Get

1888:
1889: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1890: THEN
1891:
1892: fnd_msg_pub.Count_and_Get
1893: (
1894: p_count => x_msg_count,
1895: p_data => x_msg_data
1896: );

Line 2056: FND_MSG_PUB.INITIALIZE;

2052: -- Initialize Message list
2053:
2054: IF fnd_api.to_boolean(p_init_msg_list)
2055: THEN
2056: FND_MSG_PUB.INITIALIZE;
2057: END IF;
2058:
2059:
2060: -- Set the Distribution states based on Business Rules

Line 2081: fnd_msg_pub.ADD;

2077: l_token_str := 'WS_CODE: '||p_ws_code;
2078: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
2079: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
2080: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
2081: fnd_msg_pub.ADD;
2082: fnd_msg_pub.Count_and_Get
2083: (
2084: p_count => x_msg_count,
2085: p_data => x_msg_data

Line 2082: fnd_msg_pub.Count_and_Get

2078: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
2079: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
2080: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
2081: fnd_msg_pub.ADD;
2082: fnd_msg_pub.Count_and_Get
2083: (
2084: p_count => x_msg_count,
2085: p_data => x_msg_data
2086: );

Line 2101: fnd_msg_pub.ADD;

2097: l_token_str := 'WORK_SOURCE:' ||p_ws_code;
2098: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
2099: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
2100: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
2101: fnd_msg_pub.ADD;
2102: fnd_msg_pub.Count_and_Get
2103: (
2104: p_count => x_msg_count,
2105: p_data => x_msg_data

Line 2102: fnd_msg_pub.Count_and_Get

2098: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
2099: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
2100: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
2101: fnd_msg_pub.ADD;
2102: fnd_msg_pub.Count_and_Get
2103: (
2104: p_count => x_msg_count,
2105: p_data => x_msg_data
2106: );

Line 2128: fnd_msg_pub.ADD;

2124: l_token_str := 'WS_CODE: '||p_ws_code;
2125: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
2126: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
2127: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
2128: fnd_msg_pub.ADD;
2129: fnd_msg_pub.Count_and_Get
2130: (
2131: p_count => x_msg_count,
2132: p_data => x_msg_data

Line 2129: fnd_msg_pub.Count_and_Get

2125: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
2126: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
2127: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
2128: fnd_msg_pub.ADD;
2129: fnd_msg_pub.Count_and_Get
2130: (
2131: p_count => x_msg_count,
2132: p_data => x_msg_data
2133: );

Line 2156: fnd_msg_pub.ADD;

2152: l_token_str := 'WS_CODE: '||p_ws_code;
2153: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
2154: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
2155: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
2156: fnd_msg_pub.ADD;
2157: fnd_msg_pub.Count_and_Get
2158: (
2159: p_count => x_msg_count,
2160: p_data => x_msg_data

Line 2157: fnd_msg_pub.Count_and_Get

2153: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
2154: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
2155: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
2156: fnd_msg_pub.ADD;
2157: fnd_msg_pub.Count_and_Get
2158: (
2159: p_count => x_msg_count,
2160: p_data => x_msg_data
2161: );

Line 2184: fnd_msg_pub.ADD;

2180: l_token_str := 'WS_CODE: '||p_ws_code;
2181: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
2182: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
2183: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
2184: fnd_msg_pub.ADD;
2185: fnd_msg_pub.Count_and_Get
2186: (
2187: p_count => x_msg_count,
2188: p_data => x_msg_data

Line 2185: fnd_msg_pub.Count_and_Get

2181: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
2182: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
2183: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
2184: fnd_msg_pub.ADD;
2185: fnd_msg_pub.Count_and_Get
2186: (
2187: p_count => x_msg_count,
2188: p_data => x_msg_data
2189: );

Line 2317: fnd_msg_pub.ADD;

2313: and assignee_role = 'OWNER';
2314: exception when others then
2315: -- Work Source does not exist for this Object Code
2316: l_token_str := sqlcode||' '||sqlerrm;
2317: fnd_msg_pub.ADD;
2318: fnd_msg_pub.Count_and_Get
2319: (
2320: p_count => x_msg_count,
2321: p_data => x_msg_data

Line 2318: fnd_msg_pub.Count_and_Get

2314: exception when others then
2315: -- Work Source does not exist for this Object Code
2316: l_token_str := sqlcode||' '||sqlerrm;
2317: fnd_msg_pub.ADD;
2318: fnd_msg_pub.Count_and_Get
2319: (
2320: p_count => x_msg_count,
2321: p_data => x_msg_data
2322: );

Line 2429: fnd_msg_pub.ADD;

2425: FND_MESSAGE.SET_NAME('IEU', 'IEU_SYNCH_WR_DIST_STATUS_SUM');
2426: FND_MESSAGE.SET_TOKEN('SUCCESS_COUNT', l_success_cnt);
2427: FND_MESSAGE.SET_TOKEN('FAILED_COUNT', (l_tot_cnt - l_success_cnt));
2428: FND_MESSAGE.SET_TOKEN('TOTAL_COUNT', l_tot_cnt );
2429: fnd_msg_pub.ADD;
2430: fnd_msg_pub.Count_and_Get
2431: (
2432: p_count => x_msg_count,
2433: p_data => x_msg_data

Line 2430: fnd_msg_pub.Count_and_Get

2426: FND_MESSAGE.SET_TOKEN('SUCCESS_COUNT', l_success_cnt);
2427: FND_MESSAGE.SET_TOKEN('FAILED_COUNT', (l_tot_cnt - l_success_cnt));
2428: FND_MESSAGE.SET_TOKEN('TOTAL_COUNT', l_tot_cnt );
2429: fnd_msg_pub.ADD;
2430: fnd_msg_pub.Count_and_Get
2431: (
2432: p_count => x_msg_count,
2433: p_data => x_msg_data
2434: );

Line 2557: fnd_msg_pub.ADD;

2553: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_status_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
2554:
2555: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
2556: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
2557: fnd_msg_pub.ADD;
2558: fnd_msg_pub.Count_and_Get
2559: (
2560: p_count => x_msg_count,
2561: p_data => x_msg_data

Line 2558: fnd_msg_pub.Count_and_Get

2554:
2555: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
2556: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
2557: fnd_msg_pub.ADD;
2558: fnd_msg_pub.Count_and_Get
2559: (
2560: p_count => x_msg_count,
2561: p_data => x_msg_data
2562: );

Line 2589: fnd_msg_pub.Count_and_Get

2585: ROLLBACK TO sync_ws_details_sp;
2586: x_return_status := fnd_api.g_ret_sts_error;
2587: x_msg_data := SQLCODE||' - '||SQLERRM;
2588:
2589: fnd_msg_pub.Count_and_Get
2590: (
2591: p_count => x_msg_count,
2592: p_data => x_msg_data
2593: );

Line 2601: fnd_msg_pub.Count_and_Get

2597: ROLLBACK TO sync_ws_details_sp;
2598: x_return_status := fnd_api.g_ret_sts_unexp_error;
2599: x_msg_data := SQLCODE||' - '||SQLERRM;
2600:
2601: fnd_msg_pub.Count_and_Get
2602: (
2603: p_count => x_msg_count,
2604: p_data => x_msg_data
2605: );

Line 2614: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2610: ROLLBACK TO sync_ws_details_sp;
2611: x_return_status := fnd_api.g_ret_sts_unexp_error;
2612: x_msg_data := SQLCODE||' - '||SQLERRM;
2613:
2614: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2615: THEN
2616:
2617: fnd_msg_pub.Count_and_Get
2618: (

Line 2617: fnd_msg_pub.Count_and_Get

2613:
2614: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2615: THEN
2616:
2617: fnd_msg_pub.Count_and_Get
2618: (
2619: p_count => x_msg_count,
2620: p_data => x_msg_data
2621: );

Line 2682: FND_MSG_PUB.INITIALIZE;

2678: -- Initialize Message list
2679:
2680: IF fnd_api.to_boolean(p_init_msg_list)
2681: THEN
2682: FND_MSG_PUB.INITIALIZE;
2683: END IF;
2684:
2685:
2686: for i in p_ws_det_list.first..p_ws_det_list.last

Line 2707: fnd_msg_pub.ADD;

2703: l_token_str := 'WS_CODE: '||p_ws_det_list(i).ws_code;
2704: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
2705: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.GET_NEXT_WORK_FOR_APPS');
2706: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
2707: fnd_msg_pub.ADD;
2708: fnd_msg_pub.Count_and_Get
2709: (
2710: p_count => x_msg_count,
2711: p_data => x_msg_data

Line 2708: fnd_msg_pub.Count_and_Get

2704: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
2705: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.GET_NEXT_WORK_FOR_APPS');
2706: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
2707: fnd_msg_pub.ADD;
2708: fnd_msg_pub.Count_and_Get
2709: (
2710: p_count => x_msg_count,
2711: p_data => x_msg_data
2712: );

Line 2756: fnd_msg_pub.Count_and_Get

2752:
2753: ROLLBACK TO next_work_for_apps;
2754: x_return_status := fnd_api.g_ret_sts_error;
2755:
2756: fnd_msg_pub.Count_and_Get
2757: (
2758: p_count => x_msg_count,
2759: p_data => x_msg_data
2760: );

Line 2767: fnd_msg_pub.Count_and_Get

2763:
2764: ROLLBACK TO next_work_for_apps;
2765: x_return_status := fnd_api.g_ret_sts_unexp_error;
2766:
2767: fnd_msg_pub.Count_and_Get
2768: (
2769: p_count => x_msg_count,
2770: p_data => x_msg_data
2771: );

Line 2779: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2775:
2776: ROLLBACK TO next_work_for_apps;
2777: x_return_status := fnd_api.g_ret_sts_unexp_error;
2778:
2779: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2780: THEN
2781:
2782: fnd_msg_pub.Count_and_Get
2783: (

Line 2782: fnd_msg_pub.Count_and_Get

2778:
2779: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2780: THEN
2781:
2782: fnd_msg_pub.Count_and_Get
2783: (
2784: p_count => x_msg_count,
2785: p_data => x_msg_data
2786: );

Line 2854: FND_MSG_PUB.INITIALIZE;

2850: -- Initialize Message list
2851:
2852: IF fnd_api.to_boolean(p_init_msg_list)
2853: THEN
2854: FND_MSG_PUB.INITIALIZE;
2855: END IF;
2856:
2857:
2858: for i in p_wr_item_list.first .. p_wr_item_list.last

Line 2884: fnd_msg_pub.ADD;

2880: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
2881: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
2882: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
2883:
2884: fnd_msg_pub.ADD;
2885: fnd_msg_pub.Count_and_Get
2886: (
2887: p_count => x_msg_count,
2888: p_data => x_msg_data

Line 2885: fnd_msg_pub.Count_and_Get

2881: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
2882: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
2883:
2884: fnd_msg_pub.ADD;
2885: fnd_msg_pub.Count_and_Get
2886: (
2887: p_count => x_msg_count,
2888: p_data => x_msg_data
2889: );

Line 2913: fnd_msg_pub.ADD;

2909: l_token_str := 'WS_CODE: '||l_ws_code;
2910: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
2911: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
2912: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
2913: fnd_msg_pub.ADD;
2914: fnd_msg_pub.Count_and_Get
2915: (
2916: p_count => x_msg_count,
2917: p_data => x_msg_data

Line 2914: fnd_msg_pub.Count_and_Get

2910: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
2911: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
2912: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
2913: fnd_msg_pub.ADD;
2914: fnd_msg_pub.Count_and_Get
2915: (
2916: p_count => x_msg_count,
2917: p_data => x_msg_data
2918: );

Line 2942: fnd_msg_pub.ADD;

2938: l_token_str := 'WS_CODE: '||l_ws_code;
2939: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
2940: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
2941: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
2942: fnd_msg_pub.ADD;
2943: fnd_msg_pub.Count_and_Get
2944: (
2945: p_count => x_msg_count,
2946: p_data => x_msg_data

Line 2943: fnd_msg_pub.Count_and_Get

2939: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
2940: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
2941: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
2942: fnd_msg_pub.ADD;
2943: fnd_msg_pub.Count_and_Get
2944: (
2945: p_count => x_msg_count,
2946: p_data => x_msg_data
2947: );

Line 3100: fnd_msg_pub.Count_and_Get

3096:
3097: ROLLBACK TO sync_dependent_wr_items_sp;
3098: x_return_status := fnd_api.g_ret_sts_error;
3099:
3100: fnd_msg_pub.Count_and_Get
3101: (
3102: p_count => x_msg_count,
3103: p_data => x_msg_data
3104: );

Line 3111: fnd_msg_pub.Count_and_Get

3107:
3108: ROLLBACK TO sync_dependent_wr_items_sp;
3109: x_return_status := fnd_api.g_ret_sts_unexp_error;
3110:
3111: fnd_msg_pub.Count_and_Get
3112: (
3113: p_count => x_msg_count,
3114: p_data => x_msg_data
3115: );

Line 3123: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3119:
3120: ROLLBACK TO sync_dependent_wr_items_sp;
3121: x_return_status := fnd_api.g_ret_sts_unexp_error;
3122:
3123: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3124: THEN
3125:
3126: fnd_msg_pub.Count_and_Get
3127: (

Line 3126: fnd_msg_pub.Count_and_Get

3122:
3123: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3124: THEN
3125:
3126: fnd_msg_pub.Count_and_Get
3127: (
3128: p_count => x_msg_count,
3129: p_data => x_msg_data
3130: );

Line 3283: FND_MSG_PUB.INITIALIZE;

3279: -- Initialize Message list
3280:
3281: IF fnd_api.to_boolean(p_init_msg_list)
3282: THEN
3283: FND_MSG_PUB.INITIALIZE;
3284: END IF;
3285:
3286: -- Check for NOT NULL columns
3287:

Line 3349: fnd_msg_pub.ADD;

3345:
3346: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');
3347: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
3348: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
3349: fnd_msg_pub.ADD;
3350: fnd_msg_pub.Count_and_Get
3351: (
3352: p_count => x_msg_count,
3353: p_data => x_msg_data

Line 3350: fnd_msg_pub.Count_and_Get

3346: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');
3347: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
3348: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
3349: fnd_msg_pub.ADD;
3350: fnd_msg_pub.Count_and_Get
3351: (
3352: p_count => x_msg_count,
3353: p_data => x_msg_data
3354: );

Line 3392: fnd_msg_pub.ADD;

3388:
3389: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
3390: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
3391: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
3392: fnd_msg_pub.ADD;
3393: fnd_msg_pub.Count_and_Get
3394: (
3395: p_count => x_msg_count,
3396: p_data => x_msg_data

Line 3393: fnd_msg_pub.Count_and_Get

3389: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
3390: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
3391: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
3392: fnd_msg_pub.ADD;
3393: fnd_msg_pub.Count_and_Get
3394: (
3395: p_count => x_msg_count,
3396: p_data => x_msg_data
3397: );

Line 3431: fnd_msg_pub.ADD;

3427:
3428: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
3429: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
3430: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
3431: fnd_msg_pub.ADD;
3432: fnd_msg_pub.Count_and_Get
3433: (
3434: p_count => x_msg_count,
3435: p_data => x_msg_data

Line 3432: fnd_msg_pub.Count_and_Get

3428: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
3429: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
3430: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
3431: fnd_msg_pub.ADD;
3432: fnd_msg_pub.Count_and_Get
3433: (
3434: p_count => x_msg_count,
3435: p_data => x_msg_data
3436: );

Line 3463: fnd_msg_pub.ADD;

3459:
3460: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
3461: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
3462: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
3463: fnd_msg_pub.ADD;
3464: fnd_msg_pub.Count_and_Get
3465: (
3466: p_count => x_msg_count,
3467: p_data => x_msg_data

Line 3464: fnd_msg_pub.Count_and_Get

3460: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
3461: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
3462: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
3463: fnd_msg_pub.ADD;
3464: fnd_msg_pub.Count_and_Get
3465: (
3466: p_count => x_msg_count,
3467: p_data => x_msg_data
3468: );

Line 3482: fnd_msg_pub.ADD;

3478:
3479: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_PARAM_EXCEED_MAX');
3480: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
3481: FND_MESSAGE.SET_TOKEN('IEU_UWQ_PARAM_MAX',' TITLE ');
3482: fnd_msg_pub.ADD;
3483: fnd_msg_pub.Count_and_Get
3484: (
3485: p_count => x_msg_count,
3486: p_data => x_msg_data

Line 3483: fnd_msg_pub.Count_and_Get

3479: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_PARAM_EXCEED_MAX');
3480: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
3481: FND_MESSAGE.SET_TOKEN('IEU_UWQ_PARAM_MAX',' TITLE ');
3482: fnd_msg_pub.ADD;
3483: fnd_msg_pub.Count_and_Get
3484: (
3485: p_count => x_msg_count,
3486: p_data => x_msg_data
3487: );

Line 3555: fnd_msg_pub.ADD;

3551: end if;
3552: end if;
3553: FND_MESSAGE.SET_TOKEN('ID_PARAM',l_token_str);
3554: FND_MESSAGE.SET_TOKEN('TYPE_PARAM',l_token_str2);
3555: fnd_msg_pub.ADD;
3556: fnd_msg_pub.Count_and_Get
3557: (
3558: p_count => x_msg_count,
3559: p_data => x_msg_data

Line 3556: fnd_msg_pub.Count_and_Get

3552: end if;
3553: FND_MESSAGE.SET_TOKEN('ID_PARAM',l_token_str);
3554: FND_MESSAGE.SET_TOKEN('TYPE_PARAM',l_token_str2);
3555: fnd_msg_pub.ADD;
3556: fnd_msg_pub.Count_and_Get
3557: (
3558: p_count => x_msg_count,
3559: p_data => x_msg_data
3560: );

Line 3623: fnd_msg_pub.ADD;

3619: l_token_str := 'OBJECT_CODE: '||p_workitem_obj_code;
3620: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
3621: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
3622: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
3623: fnd_msg_pub.ADD;
3624: fnd_msg_pub.Count_and_Get
3625: (
3626: p_count => x_msg_count,
3627: p_data => x_msg_data

Line 3624: fnd_msg_pub.Count_and_Get

3620: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
3621: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
3622: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
3623: fnd_msg_pub.ADD;
3624: fnd_msg_pub.Count_and_Get
3625: (
3626: p_count => x_msg_count,
3627: p_data => x_msg_data
3628: );

Line 3704: fnd_msg_pub.ADD;

3700: l_token_str := '';
3701: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
3702: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
3703: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
3704: fnd_msg_pub.ADD;
3705: fnd_msg_pub.Count_and_Get
3706: (
3707: p_count => x_msg_count,
3708: p_data => x_msg_data

Line 3705: fnd_msg_pub.Count_and_Get

3701: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
3702: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
3703: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
3704: fnd_msg_pub.ADD;
3705: fnd_msg_pub.Count_and_Get
3706: (
3707: p_count => x_msg_count,
3708: p_data => x_msg_data
3709: );

Line 3737: fnd_msg_pub.ADD;

3733: l_token_str := '';
3734: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
3735: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
3736: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
3737: fnd_msg_pub.ADD;
3738: fnd_msg_pub.Count_and_Get
3739: (
3740: p_count => x_msg_count,
3741: p_data => x_msg_data

Line 3738: fnd_msg_pub.Count_and_Get

3734: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
3735: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
3736: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
3737: fnd_msg_pub.ADD;
3738: fnd_msg_pub.Count_and_Get
3739: (
3740: p_count => x_msg_count,
3741: p_data => x_msg_data
3742: );

Line 4159: fnd_msg_pub.ADD;

4155: FND_MESSAGE.SET_NAME('IEU', 'IEU_CREATE_WR_ITEM_FAILED');
4156: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
4157: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
4158:
4159: fnd_msg_pub.ADD;
4160: fnd_msg_pub.Count_and_Get
4161: (
4162: p_count => x_msg_count,
4163: p_data => x_msg_data

Line 4160: fnd_msg_pub.Count_and_Get

4156: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
4157: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
4158:
4159: fnd_msg_pub.ADD;
4160: fnd_msg_pub.Count_and_Get
4161: (
4162: p_count => x_msg_count,
4163: p_data => x_msg_data
4164: );

Line 4184: fnd_msg_pub.ADD;

4180: FND_MESSAGE.SET_NAME('IEU', 'IEU_CREATE_WR_ITEM_FAILED');
4181: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
4182: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
4183:
4184: fnd_msg_pub.ADD;
4185: fnd_msg_pub.Count_and_Get
4186: (
4187: p_count => x_msg_count,
4188: p_data => x_msg_data

Line 4185: fnd_msg_pub.Count_and_Get

4181: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
4182: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
4183:
4184: fnd_msg_pub.ADD;
4185: fnd_msg_pub.Count_and_Get
4186: (
4187: p_count => x_msg_count,
4188: p_data => x_msg_data
4189: );

Line 4275: fnd_msg_pub.Count_and_Get

4271: X_MSG_DATA => l_msg_data,
4272: X_RETURN_STATUS => l_return_status); commit;
4273: end if;
4274:
4275: fnd_msg_pub.Count_and_Get
4276: (
4277: p_count => x_msg_count,
4278: p_data => x_msg_data
4279: );

Line 4354: fnd_msg_pub.Count_and_Get

4350: X_AUDIT_LOG_ID => l_audit_log_id,
4351: X_MSG_DATA => l_msg_data,
4352: X_RETURN_STATUS => l_return_status); commit;
4353: end if;
4354: fnd_msg_pub.Count_and_Get
4355: (
4356: p_count => x_msg_count,
4357: p_data => x_msg_data
4358: );

Line 4434: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4430: X_MSG_DATA => l_msg_data,
4431: X_RETURN_STATUS => l_return_status); commit;
4432: end if;
4433:
4434: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4435: THEN
4436:
4437: fnd_msg_pub.Count_and_Get
4438: (

Line 4437: fnd_msg_pub.Count_and_Get

4433:
4434: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4435: THEN
4436:
4437: fnd_msg_pub.Count_and_Get
4438: (
4439: p_count => x_msg_count,
4440: p_data => x_msg_data
4441: );

Line 4599: FND_MSG_PUB.INITIALIZE;

4595: -- Initialize Message list
4596:
4597: IF fnd_api.to_boolean(p_init_msg_list)
4598: THEN
4599: FND_MSG_PUB.INITIALIZE;
4600: END IF;
4601:
4602: -- Check for NOT NULL columns
4603:

Line 4646: fnd_msg_pub.ADD;

4642:
4643: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');
4644: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
4645: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
4646: fnd_msg_pub.ADD;
4647: fnd_msg_pub.Count_and_Get
4648: (
4649: p_count => x_msg_count,
4650: p_data => x_msg_data

Line 4647: fnd_msg_pub.Count_and_Get

4643: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');
4644: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
4645: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
4646: fnd_msg_pub.ADD;
4647: fnd_msg_pub.Count_and_Get
4648: (
4649: p_count => x_msg_count,
4650: p_data => x_msg_data
4651: );

Line 4694: fnd_msg_pub.ADD;

4690:
4691: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
4692: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
4693: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
4694: fnd_msg_pub.ADD;
4695: fnd_msg_pub.Count_and_Get
4696: (
4697: p_count => x_msg_count,
4698: p_data => x_msg_data

Line 4695: fnd_msg_pub.Count_and_Get

4691: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
4692: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
4693: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
4694: fnd_msg_pub.ADD;
4695: fnd_msg_pub.Count_and_Get
4696: (
4697: p_count => x_msg_count,
4698: p_data => x_msg_data
4699: );

Line 4740: fnd_msg_pub.ADD;

4736:
4737: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
4738: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
4739: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
4740: fnd_msg_pub.ADD;
4741: fnd_msg_pub.Count_and_Get
4742: (
4743: p_count => x_msg_count,
4744: p_data => x_msg_data

Line 4741: fnd_msg_pub.Count_and_Get

4737: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
4738: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
4739: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
4740: fnd_msg_pub.ADD;
4741: fnd_msg_pub.Count_and_Get
4742: (
4743: p_count => x_msg_count,
4744: p_data => x_msg_data
4745: );

Line 4812: fnd_msg_pub.ADD;

4808:
4809: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
4810: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
4811: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
4812: fnd_msg_pub.ADD;
4813: fnd_msg_pub.Count_and_Get
4814: (
4815: p_count => x_msg_count,
4816: p_data => x_msg_data

Line 4813: fnd_msg_pub.Count_and_Get

4809: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
4810: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
4811: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
4812: fnd_msg_pub.ADD;
4813: fnd_msg_pub.Count_and_Get
4814: (
4815: p_count => x_msg_count,
4816: p_data => x_msg_data
4817: );

Line 4837: fnd_msg_pub.ADD;

4833:
4834: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
4835: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
4836: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
4837: fnd_msg_pub.ADD;
4838: fnd_msg_pub.Count_and_Get
4839: (
4840: p_count => x_msg_count,
4841: p_data => x_msg_data

Line 4838: fnd_msg_pub.Count_and_Get

4834: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
4835: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
4836: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
4837: fnd_msg_pub.ADD;
4838: fnd_msg_pub.Count_and_Get
4839: (
4840: p_count => x_msg_count,
4841: p_data => x_msg_data
4842: );

Line 4885: fnd_msg_pub.ADD;

4881:
4882: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
4883: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
4884: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
4885: fnd_msg_pub.ADD;
4886: fnd_msg_pub.Count_and_Get
4887: (
4888: p_count => x_msg_count,
4889: p_data => x_msg_data

Line 4886: fnd_msg_pub.Count_and_Get

4882: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
4883: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
4884: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
4885: fnd_msg_pub.ADD;
4886: fnd_msg_pub.Count_and_Get
4887: (
4888: p_count => x_msg_count,
4889: p_data => x_msg_data
4890: );

Line 4924: fnd_msg_pub.ADD;

4920:
4921: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
4922: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
4923: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
4924: fnd_msg_pub.ADD;
4925: fnd_msg_pub.Count_and_Get
4926: (
4927: p_count => x_msg_count,
4928: p_data => x_msg_data

Line 4925: fnd_msg_pub.Count_and_Get

4921: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
4922: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
4923: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
4924: fnd_msg_pub.ADD;
4925: fnd_msg_pub.Count_and_Get
4926: (
4927: p_count => x_msg_count,
4928: p_data => x_msg_data
4929: );

Line 4954: fnd_msg_pub.ADD;

4950:
4951: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
4952: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
4953: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
4954: fnd_msg_pub.ADD;
4955: fnd_msg_pub.Count_and_Get
4956: (
4957: p_count => x_msg_count,
4958: p_data => x_msg_data

Line 4955: fnd_msg_pub.Count_and_Get

4951: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
4952: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
4953: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
4954: fnd_msg_pub.ADD;
4955: fnd_msg_pub.Count_and_Get
4956: (
4957: p_count => x_msg_count,
4958: p_data => x_msg_data
4959: );

Line 4972: fnd_msg_pub.ADD;

4968:
4969: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_PARAM_EXCEED_MAX');
4970: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
4971: FND_MESSAGE.SET_TOKEN('IEU_UWQ_PARAM_MAX',' TITLE ');
4972: fnd_msg_pub.ADD;
4973: fnd_msg_pub.Count_and_Get
4974: (
4975: p_count => x_msg_count,
4976: p_data => x_msg_data

Line 4973: fnd_msg_pub.Count_and_Get

4969: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_PARAM_EXCEED_MAX');
4970: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
4971: FND_MESSAGE.SET_TOKEN('IEU_UWQ_PARAM_MAX',' TITLE ');
4972: fnd_msg_pub.ADD;
4973: fnd_msg_pub.Count_and_Get
4974: (
4975: p_count => x_msg_count,
4976: p_data => x_msg_data
4977: );

Line 5044: fnd_msg_pub.ADD;

5040: end if;
5041: end if;
5042: FND_MESSAGE.SET_TOKEN('ID_PARAM',l_token_str);
5043: FND_MESSAGE.SET_TOKEN('TYPE_PARAM',l_token_str2);
5044: fnd_msg_pub.ADD;
5045: fnd_msg_pub.Count_and_Get
5046: (
5047: p_count => x_msg_count,
5048: p_data => x_msg_data

Line 5045: fnd_msg_pub.Count_and_Get

5041: end if;
5042: FND_MESSAGE.SET_TOKEN('ID_PARAM',l_token_str);
5043: FND_MESSAGE.SET_TOKEN('TYPE_PARAM',l_token_str2);
5044: fnd_msg_pub.ADD;
5045: fnd_msg_pub.Count_and_Get
5046: (
5047: p_count => x_msg_count,
5048: p_data => x_msg_data
5049: );

Line 5110: fnd_msg_pub.ADD;

5106: l_token_str := 'OBJECT_CODE:' ||p_workitem_obj_code;
5107: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
5108: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
5109: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
5110: fnd_msg_pub.ADD;
5111: fnd_msg_pub.Count_and_Get
5112: (
5113: p_count => x_msg_count,
5114: p_data => x_msg_data

Line 5111: fnd_msg_pub.Count_and_Get

5107: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
5108: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
5109: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
5110: fnd_msg_pub.ADD;
5111: fnd_msg_pub.Count_and_Get
5112: (
5113: p_count => x_msg_count,
5114: p_data => x_msg_data
5115: );

Line 5191: fnd_msg_pub.ADD;

5187: l_token_str := 'OBJECT_CODE: '||p_workitem_obj_code;
5188: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
5189: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
5190: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
5191: fnd_msg_pub.ADD;
5192: fnd_msg_pub.Count_and_Get
5193: (
5194: p_count => x_msg_count,
5195: p_data => x_msg_data

Line 5192: fnd_msg_pub.Count_and_Get

5188: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
5189: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
5190: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
5191: fnd_msg_pub.ADD;
5192: fnd_msg_pub.Count_and_Get
5193: (
5194: p_count => x_msg_count,
5195: p_data => x_msg_data
5196: );

Line 5223: fnd_msg_pub.ADD;

5219: l_token_str := 'OBJECT_CODE: '||p_workitem_obj_code;
5220: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
5221: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
5222: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
5223: fnd_msg_pub.ADD;
5224: fnd_msg_pub.Count_and_Get
5225: (
5226: p_count => x_msg_count,
5227: p_data => x_msg_data

Line 5224: fnd_msg_pub.Count_and_Get

5220: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
5221: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
5222: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
5223: fnd_msg_pub.ADD;
5224: fnd_msg_pub.Count_and_Get
5225: (
5226: p_count => x_msg_count,
5227: p_data => x_msg_data
5228: );

Line 5738: fnd_msg_pub.ADD;

5734: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_WR_ITEM_FAILED');
5735: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
5736: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
5737:
5738: fnd_msg_pub.ADD;
5739: fnd_msg_pub.Count_and_Get
5740: (
5741: p_count => x_msg_count,
5742: p_data => x_msg_data

Line 5739: fnd_msg_pub.Count_and_Get

5735: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
5736: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
5737:
5738: fnd_msg_pub.ADD;
5739: fnd_msg_pub.Count_and_Get
5740: (
5741: p_count => x_msg_count,
5742: p_data => x_msg_data
5743: );

Line 5767: fnd_msg_pub.ADD;

5763: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_WR_ITEM_FAILED');
5764: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
5765: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
5766:
5767: fnd_msg_pub.ADD;
5768: fnd_msg_pub.Count_and_Get
5769: (
5770: p_count => x_msg_count,
5771: p_data => x_msg_data

Line 5768: fnd_msg_pub.Count_and_Get

5764: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
5765: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
5766:
5767: fnd_msg_pub.ADD;
5768: fnd_msg_pub.Count_and_Get
5769: (
5770: p_count => x_msg_count,
5771: p_data => x_msg_data
5772: );

Line 5861: fnd_msg_pub.Count_and_Get

5857: commit;
5858:
5859: end if;
5860:
5861: fnd_msg_pub.Count_and_Get
5862: (
5863: p_count => x_msg_count,
5864: p_data => x_msg_data
5865: );

Line 5943: fnd_msg_pub.Count_and_Get

5939: commit;
5940:
5941: end if;
5942:
5943: fnd_msg_pub.Count_and_Get
5944: (
5945: p_count => x_msg_count,
5946: p_data => x_msg_data
5947: );

Line 6026: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6022: commit;
6023:
6024: end if;
6025:
6026: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6027: THEN
6028:
6029: fnd_msg_pub.Count_and_Get
6030: (

Line 6029: fnd_msg_pub.Count_and_Get

6025:
6026: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6027: THEN
6028:
6029: fnd_msg_pub.Count_and_Get
6030: (
6031: p_count => x_msg_count,
6032: p_data => x_msg_data
6033: );

Line 6141: FND_MSG_PUB.INITIALIZE;

6137: -- Initialize Message list
6138:
6139: IF fnd_api.to_boolean(p_init_msg_list)
6140: THEN
6141: FND_MSG_PUB.INITIALIZE;
6142: END IF;
6143:
6144: -- Check for NOT NULL columns
6145:

Line 6192: fnd_msg_pub.ADD;

6188:
6189: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');
6190: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_UWQM_PUB.RESCHEDULE_UWQM_ITEM');
6191: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
6192: fnd_msg_pub.ADD;
6193: fnd_msg_pub.Count_and_Get
6194: (
6195: p_count => x_msg_count,
6196: p_data => x_msg_data

Line 6193: fnd_msg_pub.Count_and_Get

6189: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');
6190: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_UWQM_PUB.RESCHEDULE_UWQM_ITEM');
6191: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
6192: fnd_msg_pub.ADD;
6193: fnd_msg_pub.Count_and_Get
6194: (
6195: p_count => x_msg_count,
6196: p_data => x_msg_data
6197: );

Line 6227: fnd_msg_pub.ADD;

6223: ' WORKITEM_OBJ_CODE: '||p_workitem_obj_code;
6224: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_COMBINATION');
6225: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_UWQM_PUB.RESCHEDULE_UWQM_ITEM');
6226: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
6227: fnd_msg_pub.ADD;
6228: fnd_msg_pub.Count_and_Get
6229: (
6230: p_count => x_msg_count,
6231: p_data => x_msg_data

Line 6228: fnd_msg_pub.Count_and_Get

6224: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_COMBINATION');
6225: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_UWQM_PUB.RESCHEDULE_UWQM_ITEM');
6226: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
6227: fnd_msg_pub.ADD;
6228: fnd_msg_pub.Count_and_Get
6229: (
6230: p_count => x_msg_count,
6231: p_data => x_msg_data
6232: );

Line 6278: fnd_msg_pub.ADD;

6274:
6275: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
6276: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_UWQM_PUB.RESCHEDULE_UWQM_ITEM');
6277: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
6278: fnd_msg_pub.ADD;
6279: fnd_msg_pub.Count_and_Get
6280: (
6281: p_count => x_msg_count,
6282: p_data => x_msg_data

Line 6279: fnd_msg_pub.Count_and_Get

6275: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
6276: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_UWQM_PUB.RESCHEDULE_UWQM_ITEM');
6277: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
6278: fnd_msg_pub.ADD;
6279: fnd_msg_pub.Count_and_Get
6280: (
6281: p_count => x_msg_count,
6282: p_data => x_msg_data
6283: );

Line 6440: fnd_msg_pub.ADD;

6436: ' WORKITEM_PK_ID : '||p_workitem_pk_id;
6437: FND_MESSAGE.SET_NAME('IEU', 'IEU_SUSPEND_UWQM_ITEM_FAILED');
6438: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_UWQM_PUB.RESCHEDULE_UWQM_ITEM');
6439: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
6440: fnd_msg_pub.ADD;
6441: fnd_msg_pub.Count_and_Get
6442: (
6443: p_count => x_msg_count,
6444: p_data => x_msg_data

Line 6441: fnd_msg_pub.Count_and_Get

6437: FND_MESSAGE.SET_NAME('IEU', 'IEU_SUSPEND_UWQM_ITEM_FAILED');
6438: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_UWQM_PUB.RESCHEDULE_UWQM_ITEM');
6439: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
6440: fnd_msg_pub.ADD;
6441: fnd_msg_pub.Count_and_Get
6442: (
6443: p_count => x_msg_count,
6444: p_data => x_msg_data
6445: );

Line 6530: fnd_msg_pub.Count_and_Get

6526: X_RETURN_STATUS => l_return_status); commit;
6527:
6528: end if;
6529:
6530: fnd_msg_pub.Count_and_Get
6531: (
6532: p_count => x_msg_count,
6533: p_data => x_msg_data
6534: );

Line 6609: fnd_msg_pub.Count_and_Get

6605: X_RETURN_STATUS => l_return_status); commit;
6606:
6607: end if;
6608:
6609: fnd_msg_pub.Count_and_Get
6610: (
6611: p_count => x_msg_count,
6612: p_data => x_msg_data
6613: );

Line 6688: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6684: X_RETURN_STATUS => l_return_status); commit;
6685:
6686: end if;
6687:
6688: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6689: THEN
6690:
6691: fnd_msg_pub.Count_and_Get
6692: (

Line 6691: fnd_msg_pub.Count_and_Get

6687:
6688: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6689: THEN
6690:
6691: fnd_msg_pub.Count_and_Get
6692: (
6693: p_count => x_msg_count,
6694: p_data => x_msg_data
6695: );

Line 6893: FND_MSG_PUB.INITIALIZE;

6889: -- Initialize Message list
6890:
6891: IF fnd_api.to_boolean(p_init_msg_list)
6892: THEN
6893: FND_MSG_PUB.INITIALIZE;
6894: END IF;
6895:
6896:
6897: -- Set the Distribution states based on Business Rules

Line 6918: fnd_msg_pub.ADD;

6914: l_token_str := 'WS_CODE: '||p_ws_code;
6915: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
6916: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
6917: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
6918: fnd_msg_pub.ADD;
6919: fnd_msg_pub.Count_and_Get
6920: (
6921: p_count => x_msg_count,
6922: p_data => x_msg_data

Line 6919: fnd_msg_pub.Count_and_Get

6915: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
6916: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
6917: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
6918: fnd_msg_pub.ADD;
6919: fnd_msg_pub.Count_and_Get
6920: (
6921: p_count => x_msg_count,
6922: p_data => x_msg_data
6923: );

Line 6938: fnd_msg_pub.ADD;

6934: l_token_str := 'WORK_SOURCE:' ||p_ws_code;
6935: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
6936: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
6937: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
6938: fnd_msg_pub.ADD;
6939: fnd_msg_pub.Count_and_Get
6940: (
6941: p_count => x_msg_count,
6942: p_data => x_msg_data

Line 6939: fnd_msg_pub.Count_and_Get

6935: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
6936: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
6937: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
6938: fnd_msg_pub.ADD;
6939: fnd_msg_pub.Count_and_Get
6940: (
6941: p_count => x_msg_count,
6942: p_data => x_msg_data
6943: );

Line 6965: fnd_msg_pub.ADD;

6961: l_token_str := 'WS_CODE: '||p_ws_code;
6962: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
6963: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
6964: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
6965: fnd_msg_pub.ADD;
6966: fnd_msg_pub.Count_and_Get
6967: (
6968: p_count => x_msg_count,
6969: p_data => x_msg_data

Line 6966: fnd_msg_pub.Count_and_Get

6962: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
6963: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
6964: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
6965: fnd_msg_pub.ADD;
6966: fnd_msg_pub.Count_and_Get
6967: (
6968: p_count => x_msg_count,
6969: p_data => x_msg_data
6970: );

Line 6993: fnd_msg_pub.ADD;

6989: l_token_str := 'WS_CODE: '||p_ws_code;
6990: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
6991: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
6992: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
6993: fnd_msg_pub.ADD;
6994: fnd_msg_pub.Count_and_Get
6995: (
6996: p_count => x_msg_count,
6997: p_data => x_msg_data

Line 6994: fnd_msg_pub.Count_and_Get

6990: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
6991: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
6992: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
6993: fnd_msg_pub.ADD;
6994: fnd_msg_pub.Count_and_Get
6995: (
6996: p_count => x_msg_count,
6997: p_data => x_msg_data
6998: );

Line 7021: fnd_msg_pub.ADD;

7017: l_token_str := 'WS_CODE: '||p_ws_code;
7018: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
7019: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
7020: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
7021: fnd_msg_pub.ADD;
7022: fnd_msg_pub.Count_and_Get
7023: (
7024: p_count => x_msg_count,
7025: p_data => x_msg_data

Line 7022: fnd_msg_pub.Count_and_Get

7018: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
7019: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
7020: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
7021: fnd_msg_pub.ADD;
7022: fnd_msg_pub.Count_and_Get
7023: (
7024: p_count => x_msg_count,
7025: p_data => x_msg_data
7026: );

Line 7192: fnd_msg_pub.ADD;

7188: and assignee_role = 'OWNER';
7189: exception when others then
7190: -- Work Source does not exist for this Object Code
7191: l_token_str := sqlcode||' '||sqlerrm;
7192: fnd_msg_pub.ADD;
7193: fnd_msg_pub.Count_and_Get
7194: (
7195: p_count => x_msg_count,
7196: p_data => x_msg_data

Line 7193: fnd_msg_pub.Count_and_Get

7189: exception when others then
7190: -- Work Source does not exist for this Object Code
7191: l_token_str := sqlcode||' '||sqlerrm;
7192: fnd_msg_pub.ADD;
7193: fnd_msg_pub.Count_and_Get
7194: (
7195: p_count => x_msg_count,
7196: p_data => x_msg_data
7197: );

Line 7562: fnd_msg_pub.ADD;

7558: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_status_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
7559:
7560: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
7561: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
7562: fnd_msg_pub.ADD;
7563: fnd_msg_pub.Count_and_Get
7564: (
7565: p_count => x_msg_count,
7566: p_data => x_msg_data

Line 7563: fnd_msg_pub.Count_and_Get

7559:
7560: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
7561: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
7562: fnd_msg_pub.ADD;
7563: fnd_msg_pub.Count_and_Get
7564: (
7565: p_count => x_msg_count,
7566: p_data => x_msg_data
7567: );

Line 7655: fnd_msg_pub.Count_and_Get

7651: X_MSG_DATA => l_msg_data,
7652: X_RETURN_STATUS => l_return_status); commit;
7653:
7654: end if;
7655: fnd_msg_pub.Count_and_Get
7656: (
7657: p_count => x_msg_count,
7658: p_data => x_msg_data
7659: );

Line 7727: fnd_msg_pub.Count_and_Get

7723: X_RETURN_STATUS => l_return_status); commit;
7724:
7725: end if;
7726:
7727: fnd_msg_pub.Count_and_Get
7728: (
7729: p_count => x_msg_count,
7730: p_data => x_msg_data
7731: );

Line 7799: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7795: X_RETURN_STATUS => l_return_status); commit;
7796:
7797: end if;
7798:
7799: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7800: THEN
7801:
7802: fnd_msg_pub.Count_and_Get
7803: (

Line 7802: fnd_msg_pub.Count_and_Get

7798:
7799: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7800: THEN
7801:
7802: fnd_msg_pub.Count_and_Get
7803: (
7804: p_count => x_msg_count,
7805: p_data => x_msg_data
7806: );

Line 7920: FND_MSG_PUB.INITIALIZE;

7916: -- Initialize Message list
7917:
7918: IF fnd_api.to_boolean(p_init_msg_list)
7919: THEN
7920: FND_MSG_PUB.INITIALIZE;
7921: END IF;
7922:
7923:
7924: for i in p_ws_det_list.first..p_ws_det_list.last

Line 7945: fnd_msg_pub.ADD;

7941: l_token_str := 'WS_CODE: '||p_ws_det_list(i).ws_code;
7942: FND_MESSAGE.SET_NAME('IEU', 'GET_NEXT_WORK_FOR_APPS');
7943: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','GET_NEXT_WORK_FOR_APPS');
7944: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
7945: fnd_msg_pub.ADD;
7946: fnd_msg_pub.Count_and_Get
7947: (
7948: p_count => x_msg_count,
7949: p_data => x_msg_data

Line 7946: fnd_msg_pub.Count_and_Get

7942: FND_MESSAGE.SET_NAME('IEU', 'GET_NEXT_WORK_FOR_APPS');
7943: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','GET_NEXT_WORK_FOR_APPS');
7944: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
7945: fnd_msg_pub.ADD;
7946: fnd_msg_pub.Count_and_Get
7947: (
7948: p_count => x_msg_count,
7949: p_data => x_msg_data
7950: );

Line 8091: l_message := l_message || FND_MSG_PUB.Get(p_msg_index => l_index,p_encoded => 'F');

8087:
8088: if x_msg_count > 0
8089: then
8090: FOR l_index IN 1..x_msg_count LOOP
8091: l_message := l_message || FND_MSG_PUB.Get(p_msg_index => l_index,p_encoded => 'F');
8092: END LOOP;
8093: end if;
8094:
8095: IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW

Line 8169: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_msg_index => l_index,p_encoded => 'F');

8165: l_event_key := null;
8166: l_module := 'IEU_WR_PUB.GET_NEXT_WORK_FOR_APPS';
8167:
8168: FOR l_index IN 1..x_msg_count LOOP
8169: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_msg_index => l_index,p_encoded => 'F');
8170: END LOOP;
8171:
8172: IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
8173: (

Line 8224: fnd_msg_pub.Count_and_Get

8220: X_MSG_DATA => l_msg_data,
8221: X_RETURN_STATUS => l_return_status); commit;
8222: end if;
8223:
8224: fnd_msg_pub.Count_and_Get
8225: (
8226: p_count => x_msg_count,
8227: p_data => x_msg_data
8228: );

Line 8243: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_msg_index => l_index,p_encoded => 'F');

8239: l_event_key := null;
8240: l_module := 'IEU_WR_PUB.GET_NEXT_WORK_FOR_APPS';
8241:
8242: FOR l_index IN 1..x_msg_count LOOP
8243: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_msg_index => l_index,p_encoded => 'F');
8244: END LOOP;
8245:
8246: IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
8247: (

Line 8299: fnd_msg_pub.Count_and_Get

8295: X_RETURN_STATUS => l_return_status); commit;
8296:
8297: end if;
8298:
8299: fnd_msg_pub.Count_and_Get
8300: (
8301: p_count => x_msg_count,
8302: p_data => x_msg_data
8303: );

Line 8319: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_msg_index => l_index,p_encoded => 'F');

8315: l_event_key := null;
8316: l_module := 'IEU_WR_PUB.GET_NEXT_WORK_FOR_APPS';
8317:
8318: FOR l_index IN 1..x_msg_count LOOP
8319: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_msg_index => l_index,p_encoded => 'F');
8320: END LOOP;
8321:
8322: IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
8323: (

Line 8375: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

8371: X_RETURN_STATUS => l_return_status);commit;
8372:
8373: end if;
8374:
8375: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8376: THEN
8377:
8378: fnd_msg_pub.Count_and_Get
8379: (

Line 8378: fnd_msg_pub.Count_and_Get

8374:
8375: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8376: THEN
8377:
8378: fnd_msg_pub.Count_and_Get
8379: (
8380: p_count => x_msg_count,
8381: p_data => x_msg_data
8382: );

Line 8497: FND_MSG_PUB.INITIALIZE;

8493: -- Initialize Message list
8494:
8495: IF fnd_api.to_boolean(p_init_msg_list)
8496: THEN
8497: FND_MSG_PUB.INITIALIZE;
8498: END IF;
8499:
8500:
8501: for i in p_wr_item_list.first .. p_wr_item_list.last

Line 8531: fnd_msg_pub.ADD;

8527: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
8528: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
8529: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
8530:
8531: fnd_msg_pub.ADD;
8532: fnd_msg_pub.Count_and_Get
8533: (
8534: p_count => x_msg_count,
8535: p_data => x_msg_data

Line 8532: fnd_msg_pub.Count_and_Get

8528: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
8529: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
8530:
8531: fnd_msg_pub.ADD;
8532: fnd_msg_pub.Count_and_Get
8533: (
8534: p_count => x_msg_count,
8535: p_data => x_msg_data
8536: );

Line 8561: fnd_msg_pub.ADD;

8557: l_token_str := 'WS_CODE: '||l_ws_code;
8558: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
8559: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
8560: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
8561: fnd_msg_pub.ADD;
8562: fnd_msg_pub.Count_and_Get
8563: (
8564: p_count => x_msg_count,
8565: p_data => x_msg_data

Line 8562: fnd_msg_pub.Count_and_Get

8558: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
8559: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
8560: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
8561: fnd_msg_pub.ADD;
8562: fnd_msg_pub.Count_and_Get
8563: (
8564: p_count => x_msg_count,
8565: p_data => x_msg_data
8566: );

Line 8589: fnd_msg_pub.ADD;

8585: l_token_str := 'WS_CODE: '||l_ws_code;
8586: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
8587: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
8588: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
8589: fnd_msg_pub.ADD;
8590: fnd_msg_pub.Count_and_Get
8591: (
8592: p_count => x_msg_count,
8593: p_data => x_msg_data

Line 8590: fnd_msg_pub.Count_and_Get

8586: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
8587: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');
8588: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
8589: fnd_msg_pub.ADD;
8590: fnd_msg_pub.Count_and_Get
8591: (
8592: p_count => x_msg_count,
8593: p_data => x_msg_data
8594: );

Line 8985: fnd_msg_pub.Count_and_Get

8981: X_RETURN_STATUS => l_return_status);
8982:
8983: end if;
8984:
8985: fnd_msg_pub.Count_and_Get
8986: (
8987: p_count => x_msg_count,
8988: p_data => x_msg_data
8989: );

Line 9077: fnd_msg_pub.Count_and_Get

9073: X_RETURN_STATUS => l_return_status);
9074:
9075: end if;
9076:
9077: fnd_msg_pub.Count_and_Get
9078: (
9079: p_count => x_msg_count,
9080: p_data => x_msg_data
9081: );

Line 9170: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9166: X_RETURN_STATUS => l_return_status);
9167:
9168: end if;
9169:
9170: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9171: THEN
9172:
9173: fnd_msg_pub.Count_and_Get
9174: (

Line 9173: fnd_msg_pub.Count_and_Get

9169:
9170: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9171: THEN
9172:
9173: fnd_msg_pub.Count_and_Get
9174: (
9175: p_count => x_msg_count,
9176: p_data => x_msg_data
9177: );

Line 9220: FND_MSG_PUB.INITIALIZE;

9216: -- Initialize Message list
9217:
9218: IF fnd_api.to_boolean(p_init_msg_list)
9219: THEN
9220: FND_MSG_PUB.INITIALIZE;
9221: END IF;
9222:
9223: -- validate parameters
9224:

Line 9237: fnd_msg_pub.ADD;

9233:
9234: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');
9235: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.ACTIVATE_WS');
9236: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
9237: fnd_msg_pub.ADD;
9238: fnd_msg_pub.Count_and_Get
9239: (
9240: p_count => x_msg_count,
9241: p_data => x_msg_data

Line 9238: fnd_msg_pub.Count_and_Get

9234: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');
9235: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.ACTIVATE_WS');
9236: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
9237: fnd_msg_pub.ADD;
9238: fnd_msg_pub.Count_and_Get
9239: (
9240: p_count => x_msg_count,
9241: p_data => x_msg_data
9242: );

Line 9271: fnd_msg_pub.ADD;

9267: l_token_str :=' WS_CODE:'||p_ws_code;
9268: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_COMBINATION');
9269: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.ACTIVATE_WS');
9270: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
9271: fnd_msg_pub.ADD;
9272: fnd_msg_pub.Count_and_Get
9273: (
9274: p_count => x_msg_count,
9275: p_data => x_msg_data

Line 9272: fnd_msg_pub.Count_and_Get

9268: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_COMBINATION');
9269: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.ACTIVATE_WS');
9270: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
9271: fnd_msg_pub.ADD;
9272: fnd_msg_pub.Count_and_Get
9273: (
9274: p_count => x_msg_count,
9275: p_data => x_msg_data
9276: );

Line 9303: fnd_msg_pub.Count_and_Get

9299:
9300: ROLLBACK TO activate_ws_sp;
9301: x_return_status := fnd_api.g_ret_sts_error;
9302:
9303: fnd_msg_pub.Count_and_Get
9304: (
9305: p_count => x_msg_count,
9306: p_data => x_msg_data
9307: );

Line 9314: fnd_msg_pub.Count_and_Get

9310:
9311: ROLLBACK TO activate_ws_sp;
9312: x_return_status := fnd_api.g_ret_sts_unexp_error;
9313:
9314: fnd_msg_pub.Count_and_Get
9315: (
9316: p_count => x_msg_count,
9317: p_data => x_msg_data
9318: );

Line 9325: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9321:
9322: ROLLBACK TO activate_ws_sp;
9323: x_return_status := fnd_api.g_ret_sts_unexp_error;
9324:
9325: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9326: THEN
9327:
9328: fnd_msg_pub.Count_and_Get
9329: (

Line 9328: fnd_msg_pub.Count_and_Get

9324:
9325: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9326: THEN
9327:
9328: fnd_msg_pub.Count_and_Get
9329: (
9330: p_count => x_msg_count,
9331: p_data => x_msg_data
9332: );

Line 9378: FND_MSG_PUB.INITIALIZE;

9374: -- Initialize Message list
9375:
9376: IF fnd_api.to_boolean(p_init_msg_list)
9377: THEN
9378: FND_MSG_PUB.INITIALIZE;
9379: END IF;
9380:
9381: -- validate parameters
9382:

Line 9395: fnd_msg_pub.ADD;

9391:
9392: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');
9393: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.ACTIVATE_WS');
9394: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
9395: fnd_msg_pub.ADD;
9396: fnd_msg_pub.Count_and_Get
9397: (
9398: p_count => x_msg_count,
9399: p_data => x_msg_data

Line 9396: fnd_msg_pub.Count_and_Get

9392: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');
9393: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.ACTIVATE_WS');
9394: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
9395: fnd_msg_pub.ADD;
9396: fnd_msg_pub.Count_and_Get
9397: (
9398: p_count => x_msg_count,
9399: p_data => x_msg_data
9400: );

Line 9429: fnd_msg_pub.ADD;

9425: l_token_str :=' WS_CODE:'||p_ws_code;
9426: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_COMBINATION');
9427: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.ACTIVATE_WS');
9428: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
9429: fnd_msg_pub.ADD;
9430: fnd_msg_pub.Count_and_Get
9431: (
9432: p_count => x_msg_count,
9433: p_data => x_msg_data

Line 9430: fnd_msg_pub.Count_and_Get

9426: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_COMBINATION');
9427: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.ACTIVATE_WS');
9428: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
9429: fnd_msg_pub.ADD;
9430: fnd_msg_pub.Count_and_Get
9431: (
9432: p_count => x_msg_count,
9433: p_data => x_msg_data
9434: );

Line 9452: fnd_msg_pub.Count_and_Get

9448:
9449: ROLLBACK TO check_ws_activation_status_sp;
9450: x_return_status := fnd_api.g_ret_sts_error;
9451:
9452: fnd_msg_pub.Count_and_Get
9453: (
9454: p_count => x_msg_count,
9455: p_data => x_msg_data
9456: );

Line 9463: fnd_msg_pub.Count_and_Get

9459:
9460: ROLLBACK TO check_ws_activation_status_sp;
9461: x_return_status := fnd_api.g_ret_sts_unexp_error;
9462:
9463: fnd_msg_pub.Count_and_Get
9464: (
9465: p_count => x_msg_count,
9466: p_data => x_msg_data
9467: );

Line 9474: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9470:
9471: ROLLBACK TO check_ws_activation_status_sp;
9472: x_return_status := fnd_api.g_ret_sts_unexp_error;
9473:
9474: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9475: THEN
9476:
9477: fnd_msg_pub.Count_and_Get
9478: (

Line 9477: fnd_msg_pub.Count_and_Get

9473:
9474: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9475: THEN
9476:
9477: fnd_msg_pub.Count_and_Get
9478: (
9479: p_count => x_msg_count,
9480: p_data => x_msg_data
9481: );

Line 9514: FND_MSG_PUB.INITIALIZE;

9510:
9511: -- Initialize Message list
9512: IF fnd_api.to_boolean(p_init_msg_list)
9513: THEN
9514: FND_MSG_PUB.INITIALIZE;
9515: END IF;
9516:
9517: -- Check for NOT NULL columns
9518:

Line 9536: fnd_msg_pub.ADD;

9532:
9533: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');
9534: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.PURGE_WR_ITEM');
9535: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
9536: fnd_msg_pub.ADD;
9537: fnd_msg_pub.Count_and_Get
9538: (
9539: p_count => x_msg_count,
9540: p_data => x_msg_data

Line 9537: fnd_msg_pub.Count_and_Get

9533: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');
9534: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.PURGE_WR_ITEM');
9535: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
9536: fnd_msg_pub.ADD;
9537: fnd_msg_pub.Count_and_Get
9538: (
9539: p_count => x_msg_count,
9540: p_data => x_msg_data
9541: );

Line 9579: fnd_msg_pub.ADD;

9575:
9576: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
9577: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.PURGE_WR_ITEM');
9578: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
9579: fnd_msg_pub.ADD;
9580: fnd_msg_pub.Count_and_Get
9581: (
9582: p_count => x_msg_count,
9583: p_data => x_msg_data

Line 9580: fnd_msg_pub.Count_and_Get

9576: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
9577: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.PURGE_WR_ITEM');
9578: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
9579: fnd_msg_pub.ADD;
9580: fnd_msg_pub.Count_and_Get
9581: (
9582: p_count => x_msg_count,
9583: p_data => x_msg_data
9584: );

Line 9627: fnd_msg_pub.ADD;

9623: FND_MESSAGE.SET_NAME('IEU', 'IEU_PURGE_WR_ITEM_FAILED');
9624: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.PURGE_WR_ITEM');
9625: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
9626:
9627: fnd_msg_pub.ADD;
9628: fnd_msg_pub.Count_and_Get
9629: (
9630: p_count => x_msg_count,
9631: p_data => x_msg_data

Line 9628: fnd_msg_pub.Count_and_Get

9624: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.PURGE_WR_ITEM');
9625: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
9626:
9627: fnd_msg_pub.ADD;
9628: fnd_msg_pub.Count_and_Get
9629: (
9630: p_count => x_msg_count,
9631: p_data => x_msg_data
9632: );

Line 9649: fnd_msg_pub.Count_and_Get

9645:
9646: x_return_status := fnd_api.g_ret_sts_error;
9647: fnd_file.put_line(FND_FILE.LOG, 'Inside WHEN FND_API.G_EXC_ERROR of ' || 'IEU_WR_PUB.PURGE_WR_ITEM');
9648:
9649: fnd_msg_pub.Count_and_Get
9650: (
9651: p_count => x_msg_count,
9652: p_data => x_msg_data
9653: );

Line 9660: fnd_msg_pub.Count_and_Get

9656:
9657: x_return_status := fnd_api.g_ret_sts_unexp_error;
9658: fnd_file.put_line(FND_FILE.LOG, 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || 'IEU_WR_PUB.PURGE_WR_ITEM');
9659:
9660: fnd_msg_pub.Count_and_Get
9661: (
9662: p_count => x_msg_count,
9663: p_data => x_msg_data
9664: );

Line 9674: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9670:
9671: fnd_file.put_line(FND_FILE.LOG, 'Inside WHEN OTHERS of ' || 'IEU_WR_PUB.PURGE_WR_ITEM' || '. Oracle Error was:');
9672: fnd_file.put_line(FND_FILE.LOG, l_sqlerrm);
9673:
9674: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9675: THEN
9676:
9677: fnd_msg_pub.Count_and_Get
9678: (

Line 9677: fnd_msg_pub.Count_and_Get

9673:
9674: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9675: THEN
9676:
9677: fnd_msg_pub.Count_and_Get
9678: (
9679: p_count => x_msg_count,
9680: p_data => x_msg_data
9681: );

Line 9796: FND_MSG_PUB.INITIALIZE;

9792: -- Initialize Message list
9793:
9794: IF fnd_api.to_boolean(p_init_msg_list)
9795: THEN
9796: FND_MSG_PUB.INITIALIZE;
9797: END IF;
9798:
9799: -- Check for NOT NULL columns
9800:

Line 9818: fnd_msg_pub.ADD;

9814:
9815: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');
9816: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.PURGE_WR_ITEM');
9817: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
9818: fnd_msg_pub.ADD;
9819: fnd_msg_pub.Count_and_Get
9820: (
9821: p_count => x_msg_count,
9822: p_data => x_msg_data

Line 9819: fnd_msg_pub.Count_and_Get

9815: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');
9816: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.PURGE_WR_ITEM');
9817: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
9818: fnd_msg_pub.ADD;
9819: fnd_msg_pub.Count_and_Get
9820: (
9821: p_count => x_msg_count,
9822: p_data => x_msg_data
9823: );

Line 9861: fnd_msg_pub.ADD;

9857:
9858: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
9859: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.PURGE_WR_ITEM');
9860: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
9861: fnd_msg_pub.ADD;
9862: fnd_msg_pub.Count_and_Get
9863: (
9864: p_count => x_msg_count,
9865: p_data => x_msg_data

Line 9862: fnd_msg_pub.Count_and_Get

9858: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');
9859: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.PURGE_WR_ITEM');
9860: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
9861: fnd_msg_pub.ADD;
9862: fnd_msg_pub.Count_and_Get
9863: (
9864: p_count => x_msg_count,
9865: p_data => x_msg_data
9866: );

Line 10032: fnd_msg_pub.ADD;

10028: FND_MESSAGE.SET_NAME('IEU', 'IEU_PURGE_WR_ITEM_FAILED');
10029: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.PURGE_WR_ITEM');
10030: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
10031:
10032: fnd_msg_pub.ADD;
10033: fnd_msg_pub.Count_and_Get
10034: (
10035: p_count => x_msg_count,
10036: p_data => x_msg_data

Line 10033: fnd_msg_pub.Count_and_Get

10029: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.PURGE_WR_ITEM');
10030: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);
10031:
10032: fnd_msg_pub.ADD;
10033: fnd_msg_pub.Count_and_Get
10034: (
10035: p_count => x_msg_count,
10036: p_data => x_msg_data
10037: );

Line 10111: fnd_msg_pub.Count_and_Get

10107: X_RETURN_STATUS => l_return_status);
10108: commit;
10109: end if;
10110:
10111: fnd_msg_pub.Count_and_Get
10112: (
10113: p_count => x_msg_count,
10114: p_data => x_msg_data
10115: );

Line 10179: fnd_msg_pub.Count_and_Get

10175: X_RETURN_STATUS => l_return_status);
10176: commit;
10177: end if;
10178:
10179: fnd_msg_pub.Count_and_Get
10180: (
10181: p_count => x_msg_count,
10182: p_data => x_msg_data
10183: );

Line 10247: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

10243: X_RETURN_STATUS => l_return_status);
10244: commit;
10245: end if;
10246:
10247: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10248: THEN
10249:
10250: fnd_msg_pub.Count_and_Get
10251: (

Line 10250: fnd_msg_pub.Count_and_Get

10246:
10247: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10248: THEN
10249:
10250: fnd_msg_pub.Count_and_Get
10251: (
10252: p_count => x_msg_count,
10253: p_data => x_msg_data
10254: );

Line 10336: FND_MSG_PUB.INITIALIZE;

10332: -- Initialize Message list
10333:
10334: IF fnd_api.to_boolean(p_init_msg_list)
10335: THEN
10336: FND_MSG_PUB.INITIALIZE;
10337: END IF;
10338:
10339: -- validate parameters
10340:

Line 10353: fnd_msg_pub.ADD;

10349:
10350: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');
10351: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.DEACTIVATE_WS');
10352: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
10353: fnd_msg_pub.ADD;
10354: fnd_msg_pub.Count_and_Get
10355: (
10356: p_count => x_msg_count,
10357: p_data => x_msg_data

Line 10354: fnd_msg_pub.Count_and_Get

10350: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');
10351: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.DEACTIVATE_WS');
10352: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
10353: fnd_msg_pub.ADD;
10354: fnd_msg_pub.Count_and_Get
10355: (
10356: p_count => x_msg_count,
10357: p_data => x_msg_data
10358: );

Line 10388: fnd_msg_pub.ADD;

10384: l_token_str :=' WS_CODE:'||p_ws_code;
10385: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_COMBINATION');
10386: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.DEACTIVATE_WS');
10387: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
10388: fnd_msg_pub.ADD;
10389: fnd_msg_pub.Count_and_Get
10390: (
10391: p_count => x_msg_count,
10392: p_data => x_msg_data

Line 10389: fnd_msg_pub.Count_and_Get

10385: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_COMBINATION');
10386: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.DEACTIVATE_WS');
10387: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
10388: fnd_msg_pub.ADD;
10389: fnd_msg_pub.Count_and_Get
10390: (
10391: p_count => x_msg_count,
10392: p_data => x_msg_data
10393: );

Line 10428: fnd_msg_pub.Count_and_Get

10424:
10425: ROLLBACK TO deactivate_ws_sp;
10426: x_return_status := fnd_api.g_ret_sts_error;
10427:
10428: fnd_msg_pub.Count_and_Get
10429: (
10430: p_count => x_msg_count,
10431: p_data => x_msg_data
10432: );

Line 10439: fnd_msg_pub.Count_and_Get

10435:
10436: ROLLBACK TO deactivate_ws_sp;
10437: x_return_status := fnd_api.g_ret_sts_unexp_error;
10438:
10439: fnd_msg_pub.Count_and_Get
10440: (
10441: p_count => x_msg_count,
10442: p_data => x_msg_data
10443: );

Line 10450: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

10446:
10447: ROLLBACK TO deactivate_ws_sp;
10448: x_return_status := fnd_api.g_ret_sts_unexp_error;
10449:
10450: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10451: THEN
10452:
10453: fnd_msg_pub.Count_and_Get
10454: (

Line 10453: fnd_msg_pub.Count_and_Get

10449:
10450: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10451: THEN
10452:
10453: fnd_msg_pub.Count_and_Get
10454: (
10455: p_count => x_msg_count,
10456: p_data => x_msg_data
10457: );

Line 10561: FND_MSG_PUB.INITIALIZE;

10557: -- Initialize Message list
10558:
10559: IF fnd_api.to_boolean(p_init_msg_list)
10560: THEN
10561: FND_MSG_PUB.INITIALIZE;
10562: END IF;
10563:
10564:
10565: -- Check for NOT NULL columns

Line 10591: fnd_msg_pub.ADD;

10587: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
10588: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
10589: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
10590:
10591: fnd_msg_pub.ADD;
10592: fnd_msg_pub.Count_and_Get
10593: (
10594: p_count => x_msg_count,
10595: p_data => x_msg_data

Line 10592: fnd_msg_pub.Count_and_Get

10588: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
10589: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
10590:
10591: fnd_msg_pub.ADD;
10592: fnd_msg_pub.Count_and_Get
10593: (
10594: p_count => x_msg_count,
10595: p_data => x_msg_data
10596: );

Line 10640: fnd_msg_pub.ADD;

10636: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
10637: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
10638: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
10639:
10640: fnd_msg_pub.ADD;
10641: fnd_msg_pub.Count_and_Get
10642: (
10643: p_count => x_msg_count,
10644: p_data => x_msg_data

Line 10641: fnd_msg_pub.Count_and_Get

10637: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
10638: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
10639:
10640: fnd_msg_pub.ADD;
10641: fnd_msg_pub.Count_and_Get
10642: (
10643: p_count => x_msg_count,
10644: p_data => x_msg_data
10645: );

Line 10696: fnd_msg_pub.ADD;

10692: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','WORKITEM_OBJ_CODE');
10693: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
10694: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
10695:
10696: fnd_msg_pub.ADD;
10697: fnd_msg_pub.Count_and_Get
10698: (
10699: p_count => x_msg_count,
10700: p_data => x_msg_data

Line 10697: fnd_msg_pub.Count_and_Get

10693: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
10694: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
10695:
10696: fnd_msg_pub.ADD;
10697: fnd_msg_pub.Count_and_Get
10698: (
10699: p_count => x_msg_count,
10700: p_data => x_msg_data
10701: );

Line 10751: fnd_msg_pub.ADD;

10747: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','PRIORITY_CODE');
10748: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
10749: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
10750:
10751: fnd_msg_pub.ADD;
10752: fnd_msg_pub.Count_and_Get
10753: (
10754: p_count => x_msg_count,
10755: p_data => x_msg_data

Line 10752: fnd_msg_pub.Count_and_Get

10748: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
10749: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
10750:
10751: fnd_msg_pub.ADD;
10752: fnd_msg_pub.Count_and_Get
10753: (
10754: p_count => x_msg_count,
10755: p_data => x_msg_data
10756: );

Line 10814: fnd_msg_pub.ADD;

10810: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
10811: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
10812: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
10813:
10814: fnd_msg_pub.ADD;
10815: fnd_msg_pub.Count_and_Get
10816: (
10817: p_count => x_msg_count,
10818: p_data => x_msg_data

Line 10815: fnd_msg_pub.Count_and_Get

10811: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
10812: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
10813:
10814: fnd_msg_pub.ADD;
10815: fnd_msg_pub.Count_and_Get
10816: (
10817: p_count => x_msg_count,
10818: p_data => x_msg_data
10819: );

Line 10892: fnd_msg_pub.ADD;

10888: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
10889: FND_MESSAGE.SET_TOKEN('DETAILS',l_token_str);
10890: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
10891:
10892: fnd_msg_pub.ADD;
10893: fnd_msg_pub.Count_and_Get
10894: (
10895: p_count => x_msg_count,
10896: p_data => x_msg_data

Line 10893: fnd_msg_pub.Count_and_Get

10889: FND_MESSAGE.SET_TOKEN('DETAILS',l_token_str);
10890: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
10891:
10892: fnd_msg_pub.ADD;
10893: fnd_msg_pub.Count_and_Get
10894: (
10895: p_count => x_msg_count,
10896: p_data => x_msg_data
10897: );

Line 11139: fnd_msg_pub.ADD;

11135: FND_MESSAGE.SET_TOKEN('DETAILS', 'WORKITEM_PK_ID:'||l_wr_items_rec.WORKITEM_PK_ID_LST(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11136: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11137: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11138:
11139: fnd_msg_pub.ADD;
11140: fnd_msg_pub.Count_and_Get
11141: (
11142: p_count => x_msg_count,
11143: p_data => x_msg_data

Line 11140: fnd_msg_pub.Count_and_Get

11136: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11137: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11138:
11139: fnd_msg_pub.ADD;
11140: fnd_msg_pub.Count_and_Get
11141: (
11142: p_count => x_msg_count,
11143: p_data => x_msg_data
11144: );

Line 11201: fnd_msg_pub.ADD;

11197:
11198: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11199: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11200:
11201: fnd_msg_pub.ADD;
11202: fnd_msg_pub.Count_and_Get
11203: (
11204: p_count => x_msg_count,
11205: p_data => x_msg_data

Line 11202: fnd_msg_pub.Count_and_Get

11198: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11199: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11200:
11201: fnd_msg_pub.ADD;
11202: fnd_msg_pub.Count_and_Get
11203: (
11204: p_count => x_msg_count,
11205: p_data => x_msg_data
11206: );

Line 11249: fnd_msg_pub.Count_and_Get

11245:
11246: ROLLBACK TO sync_wr_items_sp;
11247: x_return_status := fnd_api.g_ret_sts_error;
11248:
11249: fnd_msg_pub.Count_and_Get
11250: (
11251: p_count => x_msg_count,
11252: p_data => x_msg_data
11253: );

Line 11260: fnd_msg_pub.Count_and_Get

11256:
11257: ROLLBACK TO sync_wr_items_sp;
11258: x_return_status := fnd_api.g_ret_sts_unexp_error;
11259:
11260: fnd_msg_pub.Count_and_Get
11261: (
11262: p_count => x_msg_count,
11263: p_data => x_msg_data
11264: );

Line 11273: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

11269: ROLLBACK TO sync_wr_items_sp;
11270: x_return_status := fnd_api.g_ret_sts_unexp_error;
11271:
11272: FND_FILE.PUT_LINE(FND_FILE.LOG, x_msg_data);
11273: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11274: THEN
11275:
11276: fnd_msg_pub.Count_and_Get
11277: (

Line 11276: fnd_msg_pub.Count_and_Get

11272: FND_FILE.PUT_LINE(FND_FILE.LOG, x_msg_data);
11273: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11274: THEN
11275:
11276: fnd_msg_pub.Count_and_Get
11277: (
11278: p_count => x_msg_count,
11279: p_data => x_msg_data
11280: );

Line 11439: FND_MSG_PUB.INITIALIZE;

11435: -- Initialize Message list
11436:
11437: IF fnd_api.to_boolean(p_init_msg_list)
11438: THEN
11439: FND_MSG_PUB.INITIALIZE;
11440: END IF;
11441:
11442:
11443: -- Set the Distribution states based on Business Rules

Line 11467: fnd_msg_pub.ADD;

11463: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11464: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11465: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11466:
11467: fnd_msg_pub.ADD;
11468: fnd_msg_pub.Count_and_Get
11469: (
11470: p_count => x_msg_count,
11471: p_data => x_msg_data

Line 11468: fnd_msg_pub.Count_and_Get

11464: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11465: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11466:
11467: fnd_msg_pub.ADD;
11468: fnd_msg_pub.Count_and_Get
11469: (
11470: p_count => x_msg_count,
11471: p_data => x_msg_data
11472: );

Line 11491: fnd_msg_pub.ADD;

11487: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11488: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11489: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11490:
11491: fnd_msg_pub.ADD;
11492: fnd_msg_pub.Count_and_Get
11493: (
11494: p_count => x_msg_count,
11495: p_data => x_msg_data

Line 11492: fnd_msg_pub.Count_and_Get

11488: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11489: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11490:
11491: fnd_msg_pub.ADD;
11492: fnd_msg_pub.Count_and_Get
11493: (
11494: p_count => x_msg_count,
11495: p_data => x_msg_data
11496: );

Line 11522: fnd_msg_pub.ADD;

11518: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11519: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11520: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11521:
11522: fnd_msg_pub.ADD;
11523: fnd_msg_pub.Count_and_Get
11524: (
11525: p_count => x_msg_count,
11526: p_data => x_msg_data

Line 11523: fnd_msg_pub.Count_and_Get

11519: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11520: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11521:
11522: fnd_msg_pub.ADD;
11523: fnd_msg_pub.Count_and_Get
11524: (
11525: p_count => x_msg_count,
11526: p_data => x_msg_data
11527: );

Line 11558: fnd_msg_pub.ADD;

11554: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11555: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11556: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11557:
11558: fnd_msg_pub.ADD;
11559: fnd_msg_pub.Count_and_Get
11560: (
11561: p_count => x_msg_count,
11562: p_data => x_msg_data

Line 11559: fnd_msg_pub.Count_and_Get

11555: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11556: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11557:
11558: fnd_msg_pub.ADD;
11559: fnd_msg_pub.Count_and_Get
11560: (
11561: p_count => x_msg_count,
11562: p_data => x_msg_data
11563: );

Line 11584: fnd_msg_pub.ADD;

11580: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11581: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11582: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11583:
11584: fnd_msg_pub.ADD;
11585: fnd_msg_pub.Count_and_Get
11586: (
11587: p_count => x_msg_count,
11588: p_data => x_msg_data

Line 11585: fnd_msg_pub.Count_and_Get

11581: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11582: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11583:
11584: fnd_msg_pub.ADD;
11585: fnd_msg_pub.Count_and_Get
11586: (
11587: p_count => x_msg_count,
11588: p_data => x_msg_data
11589: );

Line 11605: fnd_msg_pub.ADD;

11601: FND_MESSAGE.SET_TOKEN('WS_NAME', l_ws_name);
11602: FND_MESSAGE.SET_TOKEN('PRIMARY_WS_NAME', l_parent_ws_name);
11603: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11604:
11605: fnd_msg_pub.ADD;
11606: fnd_msg_pub.Count_and_Get
11607: (
11608: p_count => x_msg_count,
11609: p_data => x_msg_data

Line 11606: fnd_msg_pub.Count_and_Get

11602: FND_MESSAGE.SET_TOKEN('PRIMARY_WS_NAME', l_parent_ws_name);
11603: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11604:
11605: fnd_msg_pub.ADD;
11606: fnd_msg_pub.Count_and_Get
11607: (
11608: p_count => x_msg_count,
11609: p_data => x_msg_data
11610: );

Line 11627: fnd_msg_pub.ADD;

11623: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11624: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11625: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11626:
11627: fnd_msg_pub.ADD;
11628: fnd_msg_pub.Count_and_Get
11629: (
11630: p_count => x_msg_count,
11631: p_data => x_msg_data

Line 11628: fnd_msg_pub.Count_and_Get

11624: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11625: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11626:
11627: fnd_msg_pub.ADD;
11628: fnd_msg_pub.Count_and_Get
11629: (
11630: p_count => x_msg_count,
11631: p_data => x_msg_data
11632: );

Line 11658: fnd_msg_pub.ADD;

11654: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11655: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11656: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11657:
11658: fnd_msg_pub.ADD;
11659: fnd_msg_pub.Count_and_Get
11660: (
11661: p_count => x_msg_count,
11662: p_data => x_msg_data

Line 11659: fnd_msg_pub.Count_and_Get

11655: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
11656: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11657:
11658: fnd_msg_pub.ADD;
11659: fnd_msg_pub.Count_and_Get
11660: (
11661: p_count => x_msg_count,
11662: p_data => x_msg_data
11663: );

Line 11810: fnd_msg_pub.ADD;

11806: FND_MESSAGE.SET_NAME('IEU', 'IEU_ERROR_THRESHOLD');
11807: FND_MESSAGE.SET_TOKEN('ERROR_COUNT', '1000');
11808: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');
11809: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11810: fnd_msg_pub.ADD;
11811: fnd_msg_pub.Count_and_Get
11812: (
11813: p_count => x_msg_count,
11814: p_data => x_msg_data

Line 11811: fnd_msg_pub.Count_and_Get

11807: FND_MESSAGE.SET_TOKEN('ERROR_COUNT', '1000');
11808: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');
11809: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11810: fnd_msg_pub.ADD;
11811: fnd_msg_pub.Count_and_Get
11812: (
11813: p_count => x_msg_count,
11814: p_data => x_msg_data
11815: );

Line 11827: fnd_msg_pub.ADD;

11823:
11824: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11825: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11826:
11827: fnd_msg_pub.ADD;
11828: fnd_msg_pub.Count_and_Get
11829: (
11830: p_count => x_msg_count,
11831: p_data => x_msg_data

Line 11828: fnd_msg_pub.Count_and_Get

11824: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11825: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11826:
11827: fnd_msg_pub.ADD;
11828: fnd_msg_pub.Count_and_Get
11829: (
11830: p_count => x_msg_count,
11831: p_data => x_msg_data
11832: );

Line 11859: fnd_msg_pub.ADD;

11855:
11856: fnd_file.put_line(FND_FILE.LOG, sqlcode||' - '||sqlerrm);
11857: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11858:
11859: fnd_msg_pub.ADD;
11860: fnd_msg_pub.Count_and_Get
11861: (
11862: p_count => x_msg_count,
11863: p_data => x_msg_data

Line 11860: fnd_msg_pub.Count_and_Get

11856: fnd_file.put_line(FND_FILE.LOG, sqlcode||' - '||sqlerrm);
11857: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11858:
11859: fnd_msg_pub.ADD;
11860: fnd_msg_pub.Count_and_Get
11861: (
11862: p_count => x_msg_count,
11863: p_data => x_msg_data
11864: );

Line 11929: fnd_msg_pub.ADD;

11925: FND_MESSAGE.SET_NAME('IEU', 'IEU_ERROR_THRESHOLD');
11926: FND_MESSAGE.SET_TOKEN('ERROR_COUNT', '1000');
11927: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');
11928: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11929: fnd_msg_pub.ADD;
11930: fnd_msg_pub.Count_and_Get
11931: (
11932: p_count => x_msg_count,
11933: p_data => x_msg_data

Line 11930: fnd_msg_pub.Count_and_Get

11926: FND_MESSAGE.SET_TOKEN('ERROR_COUNT', '1000');
11927: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');
11928: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11929: fnd_msg_pub.ADD;
11930: fnd_msg_pub.Count_and_Get
11931: (
11932: p_count => x_msg_count,
11933: p_data => x_msg_data
11934: );

Line 11946: fnd_msg_pub.ADD;

11942: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_status_rec.l_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11943:
11944: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11945: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11946: fnd_msg_pub.ADD;
11947: fnd_msg_pub.Count_and_Get
11948: (
11949: p_count => x_msg_count,
11950: p_data => x_msg_data

Line 11947: fnd_msg_pub.Count_and_Get

11943:
11944: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11945: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11946: fnd_msg_pub.ADD;
11947: fnd_msg_pub.Count_and_Get
11948: (
11949: p_count => x_msg_count,
11950: p_data => x_msg_data
11951: );

Line 11984: fnd_msg_pub.Count_and_Get

11980:
11981: ROLLBACK TO sync_assct_task_wr_items_sp;
11982: x_return_status := fnd_api.g_ret_sts_error;
11983:
11984: fnd_msg_pub.Count_and_Get
11985: (
11986: p_count => x_msg_count,
11987: p_data => x_msg_data
11988: );

Line 11995: fnd_msg_pub.Count_and_Get

11991:
11992: ROLLBACK TO sync_assct_task_wr_items_sp;
11993: x_return_status := fnd_api.g_ret_sts_unexp_error;
11994:
11995: fnd_msg_pub.Count_and_Get
11996: (
11997: p_count => x_msg_count,
11998: p_data => x_msg_data
11999: );

Line 12009: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

12005: ROLLBACK TO sync_assct_task_wr_items_sp;
12006: x_return_status := fnd_api.g_ret_sts_unexp_error;
12007:
12008: FND_FILE.PUT_LINE(FND_FILE.LOG, x_msg_data);
12009: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12010: THEN
12011:
12012: fnd_msg_pub.Count_and_Get
12013: (

Line 12012: fnd_msg_pub.Count_and_Get

12008: FND_FILE.PUT_LINE(FND_FILE.LOG, x_msg_data);
12009: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12010: THEN
12011:
12012: fnd_msg_pub.Count_and_Get
12013: (
12014: p_count => x_msg_count,
12015: p_data => x_msg_data
12016: );

Line 12110: fnd_msg_pub.ADD;

12106: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_task_asg_rec.l_asg_task_id_list(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12107:
12108: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12109: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12110: fnd_msg_pub.ADD;
12111: fnd_msg_pub.Count_and_Get
12112: (
12113: p_count => x_msg_count,
12114: p_data => x_msg_data

Line 12111: fnd_msg_pub.Count_and_Get

12107:
12108: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12109: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12110: fnd_msg_pub.ADD;
12111: fnd_msg_pub.Count_and_Get
12112: (
12113: p_count => x_msg_count,
12114: p_data => x_msg_data
12115: );

Line 12259: fnd_msg_pub.Count_and_Get

12255:
12256: EXCEPTION
12257: WHEN OTHERS THEN
12258: --insert into p_temp values('error in get work', 2); commit;
12259: fnd_msg_pub.Count_and_Get
12260: (
12261: p_count => x_msg_count,
12262: p_data => x_msg_data
12263: );

Line 12275: my_message := FND_MSG_PUB.Get(p_msg_index => l_index,p_encoded => 'F');

12271: IF x_return_status <> 'S' THEN
12272: --insert into p_temp(msg) values('Error: '|| x_return_status || '; ' ||
12273: -- x_msg_count || '; ' || x_msg_data);
12274: FOR l_index IN 1..x_msg_count LOOP
12275: my_message := FND_MSG_PUB.Get(p_msg_index => l_index,p_encoded => 'F');
12276: --insert into p_temp(msg) values (l_index || ' = ' || my_message);
12277: END LOOP;
12278: end if;
12279:

Line 12309: fnd_msg_pub.Count_and_Get

12305: Exception
12306:
12307: WHEN fnd_api.g_exc_error THEN
12308: x_return_status := 'E';
12309: fnd_msg_pub.Count_and_Get
12310: (
12311: p_count => x_msg_count,
12312: p_data => x_msg_data
12313: );

Line 12317: fnd_msg_pub.Count_and_Get

12313: );
12314:
12315: WHEN fnd_api.g_exc_unexpected_error THEN
12316: x_return_status := 'U';
12317: fnd_msg_pub.Count_and_Get
12318: (
12319: p_count => x_msg_count,
12320: p_data => x_msg_data
12321: );

Line 12398: FND_MSG_PUB.INITIALIZE;

12394: -- Initialize Message list
12395:
12396: IF fnd_api.to_boolean(p_init_msg_list)
12397: THEN
12398: FND_MSG_PUB.INITIALIZE;
12399: END IF;
12400:
12401:
12402: -- Check for NOT NULL columns

Line 12415: fnd_msg_pub.ADD;

12411: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12412: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
12413: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12414:
12415: fnd_msg_pub.ADD;
12416: fnd_msg_pub.Count_and_Get
12417: (
12418: p_count => x_msg_count,
12419: p_data => x_msg_data

Line 12416: fnd_msg_pub.Count_and_Get

12412: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);
12413: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12414:
12415: fnd_msg_pub.ADD;
12416: fnd_msg_pub.Count_and_Get
12417: (
12418: p_count => x_msg_count,
12419: p_data => x_msg_data
12420: );

Line 12448: fnd_msg_pub.ADD;

12444: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12445: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
12446: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12447:
12448: fnd_msg_pub.ADD;
12449: fnd_msg_pub.Count_and_Get
12450: (
12451: p_count => x_msg_count,
12452: p_data => x_msg_data

Line 12449: fnd_msg_pub.Count_and_Get

12445: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
12446: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12447:
12448: fnd_msg_pub.ADD;
12449: fnd_msg_pub.Count_and_Get
12450: (
12451: p_count => x_msg_count,
12452: p_data => x_msg_data
12453: );

Line 12502: fnd_msg_pub.ADD;

12498: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12499: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
12500: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12501:
12502: fnd_msg_pub.ADD;
12503: fnd_msg_pub.Count_and_Get
12504: (
12505: p_count => x_msg_count,
12506: p_data => x_msg_data

Line 12503: fnd_msg_pub.Count_and_Get

12499: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
12500: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12501:
12502: fnd_msg_pub.ADD;
12503: fnd_msg_pub.Count_and_Get
12504: (
12505: p_count => x_msg_count,
12506: p_data => x_msg_data
12507: );

Line 12533: fnd_msg_pub.ADD;

12529: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12530: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
12531: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12532:
12533: fnd_msg_pub.ADD;
12534: fnd_msg_pub.Count_and_Get
12535: (
12536: p_count => x_msg_count,
12537: p_data => x_msg_data

Line 12534: fnd_msg_pub.Count_and_Get

12530: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
12531: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12532:
12533: fnd_msg_pub.ADD;
12534: fnd_msg_pub.Count_and_Get
12535: (
12536: p_count => x_msg_count,
12537: p_data => x_msg_data
12538: );

Line 12562: fnd_msg_pub.ADD;

12558: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
12559: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12560: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
12561: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12562: fnd_msg_pub.ADD;
12563: fnd_msg_pub.Count_and_Get
12564: (
12565: p_count => x_msg_count,
12566: p_data => x_msg_data

Line 12563: fnd_msg_pub.Count_and_Get

12559: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12560: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
12561: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12562: fnd_msg_pub.ADD;
12563: fnd_msg_pub.Count_and_Get
12564: (
12565: p_count => x_msg_count,
12566: p_data => x_msg_data
12567: );

Line 12591: fnd_msg_pub.ADD;

12587: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
12588: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12589: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
12590: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12591: fnd_msg_pub.ADD;
12592: fnd_msg_pub.Count_and_Get
12593: (
12594: p_count => x_msg_count,
12595: p_data => x_msg_data

Line 12592: fnd_msg_pub.Count_and_Get

12588: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12589: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
12590: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12591: fnd_msg_pub.ADD;
12592: fnd_msg_pub.Count_and_Get
12593: (
12594: p_count => x_msg_count,
12595: p_data => x_msg_data
12596: );

Line 12642: fnd_msg_pub.ADD;

12638: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12639: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
12640: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12641:
12642: fnd_msg_pub.ADD;
12643: fnd_msg_pub.Count_and_Get
12644: (
12645: p_count => x_msg_count,
12646: p_data => x_msg_data

Line 12643: fnd_msg_pub.Count_and_Get

12639: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
12640: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12641:
12642: fnd_msg_pub.ADD;
12643: fnd_msg_pub.Count_and_Get
12644: (
12645: p_count => x_msg_count,
12646: p_data => x_msg_data
12647: );

Line 12692: fnd_msg_pub.ADD;

12688: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
12689: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
12690: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12691:
12692: fnd_msg_pub.ADD;
12693: fnd_msg_pub.Count_and_Get
12694: (
12695: p_count => x_msg_count,
12696: p_data => x_msg_data

Line 12693: fnd_msg_pub.Count_and_Get

12689: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);
12690: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12691:
12692: fnd_msg_pub.ADD;
12693: fnd_msg_pub.Count_and_Get
12694: (
12695: p_count => x_msg_count,
12696: p_data => x_msg_data
12697: );

Line 12744: fnd_msg_pub.ADD;

12740: FND_MESSAGE.SET_TOKEN('DETAILS', 'WORKITEM_PK_ID:'||l_wr_item_status_rec.WORKITEM_PK_ID_LST(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12741:
12742: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12743: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12744: fnd_msg_pub.ADD;
12745: fnd_msg_pub.Count_and_Get
12746: (
12747: p_count => x_msg_count,
12748: p_data => x_msg_data

Line 12745: fnd_msg_pub.Count_and_Get

12741:
12742: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12743: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12744: fnd_msg_pub.ADD;
12745: fnd_msg_pub.Count_and_Get
12746: (
12747: p_count => x_msg_count,
12748: p_data => x_msg_data
12749: );

Line 12771: fnd_msg_pub.Count_and_Get

12767:
12768: ROLLBACK TO SYNC_WR_ITEM_STATUS_SP;
12769: x_return_status := fnd_api.g_ret_sts_error;
12770:
12771: fnd_msg_pub.Count_and_Get
12772: (
12773: p_count => x_msg_count,
12774: p_data => x_msg_data
12775: );

Line 12782: fnd_msg_pub.Count_and_Get

12778:
12779: ROLLBACK TO SYNC_WR_ITEM_STATUS_SP;
12780: x_return_status := fnd_api.g_ret_sts_unexp_error;
12781:
12782: fnd_msg_pub.Count_and_Get
12783: (
12784: p_count => x_msg_count,
12785: p_data => x_msg_data
12786: );

Line 12795: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

12791: ROLLBACK TO SYNC_WR_ITEM_STATUS_SP;
12792: x_return_status := fnd_api.g_ret_sts_unexp_error;
12793:
12794: FND_FILE.PUT_LINE(FND_FILE.LOG, x_msg_data);
12795: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12796: THEN
12797:
12798: fnd_msg_pub.Count_and_Get
12799: (

Line 12798: fnd_msg_pub.Count_and_Get

12794: FND_FILE.PUT_LINE(FND_FILE.LOG, x_msg_data);
12795: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12796: THEN
12797:
12798: fnd_msg_pub.Count_and_Get
12799: (
12800: p_count => x_msg_count,
12801: p_data => x_msg_data
12802: );

Line 12875: FND_MSG_PUB.INITIALIZE;

12871: -- Initialize Message list
12872:
12873: IF fnd_api.to_boolean(p_init_msg_list)
12874: THEN
12875: FND_MSG_PUB.INITIALIZE;
12876: END IF;
12877:
12878:
12879: -- Get the Work_source_id

Line 12901: fnd_msg_pub.ADD;

12897: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM_STATUS');
12898: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
12899: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12900:
12901: fnd_msg_pub.ADD;
12902: fnd_msg_pub.Count_and_Get
12903: (
12904: p_count => x_msg_count,
12905: p_data => x_msg_data

Line 12902: fnd_msg_pub.Count_and_Get

12898: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);
12899: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12900:
12901: fnd_msg_pub.ADD;
12902: fnd_msg_pub.Count_and_Get
12903: (
12904: p_count => x_msg_count,
12905: p_data => x_msg_data
12906: );

Line 12949: fnd_msg_pub.ADD;

12945: FND_MESSAGE.SET_TOKEN('DETAILS', 'WORK_ITEM_ID:'||l_wr_item_status_rec.WORK_ITEM_ID_LIST(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12946:
12947: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12948: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12949: fnd_msg_pub.ADD;
12950: fnd_msg_pub.Count_and_Get
12951: (
12952: p_count => x_msg_count,
12953: p_data => x_msg_data

Line 12950: fnd_msg_pub.Count_and_Get

12946:
12947: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
12948: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
12949: fnd_msg_pub.ADD;
12950: fnd_msg_pub.Count_and_Get
12951: (
12952: p_count => x_msg_count,
12953: p_data => x_msg_data
12954: );

Line 12979: fnd_msg_pub.Count_and_Get

12975:
12976: ROLLBACK TO UPDATE_WR_ITEM_STATUS_SP;
12977: x_return_status := fnd_api.g_ret_sts_error;
12978:
12979: fnd_msg_pub.Count_and_Get
12980: (
12981: p_count => x_msg_count,
12982: p_data => x_msg_data
12983: );

Line 12990: fnd_msg_pub.Count_and_Get

12986:
12987: ROLLBACK TO UPDATE_WR_ITEM_STATUS_SP;
12988: x_return_status := fnd_api.g_ret_sts_unexp_error;
12989:
12990: fnd_msg_pub.Count_and_Get
12991: (
12992: p_count => x_msg_count,
12993: p_data => x_msg_data
12994: );

Line 13003: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

12999: ROLLBACK TO UPDATE_WR_ITEM_STATUS_SP;
13000: x_return_status := fnd_api.g_ret_sts_unexp_error;
13001:
13002: FND_FILE.PUT_LINE(FND_FILE.LOG, x_msg_data);
13003: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13004: THEN
13005:
13006: fnd_msg_pub.Count_and_Get
13007: (

Line 13006: fnd_msg_pub.Count_and_Get

13002: FND_FILE.PUT_LINE(FND_FILE.LOG, x_msg_data);
13003: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13004: THEN
13005:
13006: fnd_msg_pub.Count_and_Get
13007: (
13008: p_count => x_msg_count,
13009: p_data => x_msg_data
13010: );