eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEU_WR_PUB dependencies on FND_MESSAGE

Line 189: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');

185:
186: If (l_miss_param_flag = 1)
187: THEN
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

Line 190: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

186: If (l_miss_param_flag = 1)
187: THEN
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: (

Line 191: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);

187: THEN
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,

Line 232: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');

228:
229: IF (l_param_valid_flag = 1)
230: THEN
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

Line 233: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

229: IF (l_param_valid_flag = 1)
230: THEN
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: (

Line 234: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

230: THEN
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,

Line 271: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');

267:
268: IF (l_param_valid_flag = 1)
269: THEN
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

Line 272: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

268: IF (l_param_valid_flag = 1)
269: THEN
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: (

Line 273: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

269: THEN
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,

Line 303: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');

299:
300: IF (l_work_item_status_valid_flag = 'F')
301: THEN
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

Line 304: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

300: IF (l_work_item_status_valid_flag = 'F')
301: THEN
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: (

Line 305: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

301: THEN
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,

Line 322: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_PARAM_EXCEED_MAX');

318: IF (length(p_title) > l_title_len)
319: THEN
320:
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

Line 323: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

319: THEN
320:
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: (

Line 324: FND_MESSAGE.SET_TOKEN('IEU_UWQ_PARAM_MAX',' TITLE ');

320:
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,

Line 371: FND_MESSAGE.SET_NAME('IEU', 'IEU_WR_OWN_OR_ASG_ID_NULL');

367: ( (p_assignee_type is not null) and (p_assignee_id is null) )
368: then
369: l_token_str := '';
370: l_token_str2 := '';
371: FND_MESSAGE.SET_NAME('IEU', 'IEU_WR_OWN_OR_ASG_ID_NULL');
372: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
373: if ( (p_owner_id is null) and (p_owner_type is not null) OR
374: (p_owner_id is not null) and (p_owner_type is null) )
375: then

Line 372: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

368: then
369: l_token_str := '';
370: l_token_str2 := '';
371: FND_MESSAGE.SET_NAME('IEU', 'IEU_WR_OWN_OR_ASG_ID_NULL');
372: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
373: if ( (p_owner_id is null) and (p_owner_type is not null) OR
374: (p_owner_id is not null) and (p_owner_type is null) )
375: then
376: l_token_str := ' OWNER_ID';

Line 395: FND_MESSAGE.SET_TOKEN('ID_PARAM',l_token_str);

391: else
392: l_token_str2 := ' ASSINGEE_TYPE - '||p_assignee_type;
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: (

Line 396: FND_MESSAGE.SET_TOKEN('TYPE_PARAM',l_token_str2);

392: l_token_str2 := ' ASSINGEE_TYPE - '||p_assignee_type;
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,

Line 462: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');

458: WHEN OTHERS THEN
459:
460: -- Work Source does not exist for this Object Code
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

Line 463: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

459:
460: -- Work Source does not exist for this Object Code
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: (

Line 464: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

460: -- Work Source does not exist for this Object Code
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,

Line 542: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

538: EXCEPTION
539: WHEN OTHERS THEN
540: -- Work Source Details does not exist for this Object Code
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

Line 543: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

539: WHEN OTHERS THEN
540: -- Work Source Details does not exist for this Object Code
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: (

Line 544: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

540: -- Work Source Details does not exist for this Object Code
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,

Line 574: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

570: EXCEPTION
571: WHEN OTHERS THEN
572: -- Work Source Details does not exist for this Object Code
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

Line 575: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

571: WHEN OTHERS THEN
572: -- Work Source Details does not exist for this Object Code
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: (

Line 576: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

572: -- Work Source Details does not exist for this Object Code
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,

Line 799: FND_MESSAGE.SET_NAME('IEU', 'IEU_CREATE_WR_ITEM_FAILED');

795: then
796: x_return_status := fnd_api.g_ret_sts_error;
797: l_token_str := l_msg_data;
798:
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;

Line 800: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

796: x_return_status := fnd_api.g_ret_sts_error;
797: l_token_str := l_msg_data;
798:
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

Line 801: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);

797: l_token_str := l_msg_data;
798:
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: (

Line 824: FND_MESSAGE.SET_NAME('IEU', 'IEU_CREATE_WR_ITEM_FAILED');

820:
821: x_return_status := fnd_api.g_ret_sts_error;
822: l_token_str := l_msg_data;
823:
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;

Line 825: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

821: x_return_status := fnd_api.g_ret_sts_error;
822: l_token_str := l_msg_data;
823:
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

Line 826: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);

822: l_token_str := l_msg_data;
823:
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: (

Line 1045: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');

1041:
1042: If (l_miss_param_flag = 1)
1043: THEN
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

Line 1046: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

1042: If (l_miss_param_flag = 1)
1043: THEN
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: (

Line 1047: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);

1043: THEN
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,

Line 1118: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');

1114: EXCEPTION WHEN OTHERS THEN
1115: l_token_str := 'TITLE, PARTY_ID, DUE_DATE, OWNER_ID, OWNER_TYPE, ';
1116: l_token_str := l_token_str || 'ASSIGNEE_ID, APPLICATION_ID, SOURCE_OBJECT_ID, SOURCE_OBJ_TYPE';
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

Line 1119: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

1115: l_token_str := 'TITLE, PARTY_ID, DUE_DATE, OWNER_ID, OWNER_TYPE, ';
1116: l_token_str := l_token_str || 'ASSIGNEE_ID, APPLICATION_ID, SOURCE_OBJECT_ID, SOURCE_OBJ_TYPE';
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: (

Line 1120: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

1116: l_token_str := l_token_str || 'ASSIGNEE_ID, APPLICATION_ID, SOURCE_OBJECT_ID, SOURCE_OBJ_TYPE';
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,

Line 1185: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');

1181: WHEN OTHERS THEN
1182:
1183: l_token_str := 'PRIORITY_CODE : '||p_priority_code;
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

Line 1186: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

1182:
1183: l_token_str := 'PRIORITY_CODE : '||p_priority_code;
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: (

Line 1187: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

1183: l_token_str := 'PRIORITY_CODE : '||p_priority_code;
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,

Line 1209: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');

1205: EXCEPTION
1206: WHEN OTHERS THEN
1207: l_token_str := 'WORK_ITEM_STATUS : '||p_work_item_status;
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

Line 1210: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

1206: WHEN OTHERS THEN
1207: l_token_str := 'WORK_ITEM_STATUS : '||p_work_item_status;
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: (

Line 1211: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

1207: l_token_str := 'WORK_ITEM_STATUS : '||p_work_item_status;
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,

Line 1255: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');

1251:
1252: IF (l_param_valid_flag = 1)
1253: THEN
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

Line 1256: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

1252: IF (l_param_valid_flag = 1)
1253: THEN
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: (

Line 1257: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

1253: THEN
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,

Line 1294: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');

1290:
1291: IF (l_param_valid_flag = 1)
1292: THEN
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

Line 1295: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

1291: IF (l_param_valid_flag = 1)
1292: THEN
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: (

Line 1296: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

1292: THEN
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,

Line 1324: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');

1320:
1321: IF (l_work_item_status_valid_flag = 'F')
1322: THEN
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

Line 1325: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

1321: IF (l_work_item_status_valid_flag = 'F')
1322: THEN
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: (

Line 1326: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

1322: THEN
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,

Line 1342: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_PARAM_EXCEED_MAX');

1338: IF (length(m_title) > l_title_len)
1339: THEN
1340:
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

Line 1343: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

1339: THEN
1340:
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: (

Line 1344: FND_MESSAGE.SET_TOKEN('IEU_UWQ_PARAM_MAX',' TITLE ');

1340:
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,

Line 1391: FND_MESSAGE.SET_NAME('IEU', 'IEU_WR_OWN_OR_ASG_ID_NULL');

1387: ( (m_assignee_type is not null) and (m_assignee_id is null) )
1388: then
1389: l_token_str := '';
1390: l_token_str2 := '';
1391: FND_MESSAGE.SET_NAME('IEU', 'IEU_WR_OWN_OR_ASG_ID_NULL');
1392: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
1393: if ( (m_owner_id is null) and (m_owner_type is not null) OR
1394: (m_owner_id is not null) and (m_owner_type is null) )
1395: then

Line 1392: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

1388: then
1389: l_token_str := '';
1390: l_token_str2 := '';
1391: FND_MESSAGE.SET_NAME('IEU', 'IEU_WR_OWN_OR_ASG_ID_NULL');
1392: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
1393: if ( (m_owner_id is null) and (m_owner_type is not null) OR
1394: (m_owner_id is not null) and (m_owner_type is null) )
1395: then
1396: l_token_str := ' OWNER_ID';

Line 1415: FND_MESSAGE.SET_TOKEN('ID_PARAM',l_token_str);

1411: else
1412: l_token_str2 := ' ASSINGEE_TYPE - '||m_assignee_type;
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: (

Line 1416: FND_MESSAGE.SET_TOKEN('TYPE_PARAM',l_token_str2);

1412: l_token_str2 := ' ASSINGEE_TYPE - '||m_assignee_type;
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,

Line 1480: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');

1476: WHEN OTHERS THEN
1477:
1478: -- Work Source does not exist for this Object Code
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

Line 1481: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

1477:
1478: -- Work Source does not exist for this Object Code
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: (

Line 1482: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

1478: -- Work Source does not exist for this Object Code
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,

Line 1560: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');

1556: EXCEPTION
1557: WHEN OTHERS THEN
1558: -- Work Source does not exist for this Object Code
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

Line 1561: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

1557: WHEN OTHERS THEN
1558: -- Work Source does not exist for this Object Code
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: (

Line 1562: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

1558: -- Work Source does not exist for this Object Code
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,

Line 1591: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');

1587: EXCEPTION
1588: WHEN OTHERS THEN
1589: -- Work Source does not exist for this Object Code
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

Line 1592: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

1588: WHEN OTHERS THEN
1589: -- Work Source does not exist for this Object Code
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: (

Line 1593: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

1589: -- Work Source does not exist for this Object Code
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,

Line 1810: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_WR_ITEM_FAILED');

1806: then
1807: x_return_status := fnd_api.g_ret_sts_error;
1808: l_token_str := l_msg_data;
1809:
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;

Line 1811: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

1807: x_return_status := fnd_api.g_ret_sts_error;
1808: l_token_str := l_msg_data;
1809:
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

Line 1812: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);

1808: l_token_str := l_msg_data;
1809:
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: (

Line 1839: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_WR_ITEM_FAILED');

1835:
1836: x_return_status := fnd_api.g_ret_sts_error;
1837: l_token_str := l_msg_data;
1838:
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;

Line 1840: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

1836: x_return_status := fnd_api.g_ret_sts_error;
1837: l_token_str := l_msg_data;
1838:
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

Line 1841: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);

1837: l_token_str := l_msg_data;
1838:
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: (

Line 2078: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

2074: WHEN OTHERS THEN
2075:
2076: -- Work Source does not exist for this Object Code
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

Line 2079: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');

2075:
2076: -- Work Source does not exist for this Object Code
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: (

Line 2080: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

2076: -- Work Source does not exist for this Object Code
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,

Line 2098: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');

2094: -- The Sync script works only for Association Work Source
2095: -- If a primary Work Source is passed then it will throw an exception and exit
2096: -- Work Source does not exist for this Object Code
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

Line 2099: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');

2095: -- If a primary Work Source is passed then it will throw an exception and exit
2096: -- Work Source does not exist for this Object Code
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: (

Line 2100: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

2096: -- Work Source does not exist for this Object Code
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,

Line 2125: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

2121: WHEN NO_DATA_FOUND THEN
2122:
2123: -- Work Source does not exist for this Object Code
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

Line 2126: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');

2122:
2123: -- Work Source does not exist for this Object Code
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: (

Line 2127: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

2123: -- Work Source does not exist for this Object Code
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,

Line 2153: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

2149: WHEN NO_DATA_FOUND THEN
2150:
2151: -- Work Source does not exist for this Object Code
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

Line 2154: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');

2150:
2151: -- Work Source does not exist for this Object Code
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: (

Line 2155: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

2151: -- Work Source does not exist for this Object Code
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,

Line 2181: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

2177: WHEN NO_DATA_FOUND THEN
2178:
2179: -- Work Source does not exist for this Object Code
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

Line 2182: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');

2178:
2179: -- Work Source does not exist for this Object Code
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: (

Line 2183: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

2179: -- Work Source does not exist for this Object Code
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,

Line 2402: FND_MESSAGE.SET_NAME('IEU', 'IEU_SYNCH_WR_DIST_STATUS_FAIL');

2398: if (l_failure_cnt < 20)
2399: then
2400:
2401: fnd_file.new_line(FND_FILE.LOG, 1);
2402: FND_MESSAGE.SET_NAME('IEU', 'IEU_SYNCH_WR_DIST_STATUS_FAIL');
2403: FND_MESSAGE.SET_TOKEN('OBJ_CODE', 'TASK');
2404: FND_MESSAGE.SET_TOKEN('WORKITEM_NUM', l_task_id);
2405: FND_MESSAGE.SET_TOKEN('DETAILS', l_msg_data);
2406: l_final_msg := FND_MESSAGE.GET;

Line 2403: FND_MESSAGE.SET_TOKEN('OBJ_CODE', 'TASK');

2399: then
2400:
2401: fnd_file.new_line(FND_FILE.LOG, 1);
2402: FND_MESSAGE.SET_NAME('IEU', 'IEU_SYNCH_WR_DIST_STATUS_FAIL');
2403: FND_MESSAGE.SET_TOKEN('OBJ_CODE', 'TASK');
2404: FND_MESSAGE.SET_TOKEN('WORKITEM_NUM', l_task_id);
2405: FND_MESSAGE.SET_TOKEN('DETAILS', l_msg_data);
2406: l_final_msg := FND_MESSAGE.GET;
2407: fnd_file.put_line(FND_FILE.LOG, l_final_msg);

Line 2404: FND_MESSAGE.SET_TOKEN('WORKITEM_NUM', l_task_id);

2400:
2401: fnd_file.new_line(FND_FILE.LOG, 1);
2402: FND_MESSAGE.SET_NAME('IEU', 'IEU_SYNCH_WR_DIST_STATUS_FAIL');
2403: FND_MESSAGE.SET_TOKEN('OBJ_CODE', 'TASK');
2404: FND_MESSAGE.SET_TOKEN('WORKITEM_NUM', l_task_id);
2405: FND_MESSAGE.SET_TOKEN('DETAILS', l_msg_data);
2406: l_final_msg := FND_MESSAGE.GET;
2407: fnd_file.put_line(FND_FILE.LOG, l_final_msg);
2408:

Line 2405: FND_MESSAGE.SET_TOKEN('DETAILS', l_msg_data);

2401: fnd_file.new_line(FND_FILE.LOG, 1);
2402: FND_MESSAGE.SET_NAME('IEU', 'IEU_SYNCH_WR_DIST_STATUS_FAIL');
2403: FND_MESSAGE.SET_TOKEN('OBJ_CODE', 'TASK');
2404: FND_MESSAGE.SET_TOKEN('WORKITEM_NUM', l_task_id);
2405: FND_MESSAGE.SET_TOKEN('DETAILS', l_msg_data);
2406: l_final_msg := FND_MESSAGE.GET;
2407: fnd_file.put_line(FND_FILE.LOG, l_final_msg);
2408:
2409: end if;

Line 2406: l_final_msg := FND_MESSAGE.GET;

2402: FND_MESSAGE.SET_NAME('IEU', 'IEU_SYNCH_WR_DIST_STATUS_FAIL');
2403: FND_MESSAGE.SET_TOKEN('OBJ_CODE', 'TASK');
2404: FND_MESSAGE.SET_TOKEN('WORKITEM_NUM', l_task_id);
2405: FND_MESSAGE.SET_TOKEN('DETAILS', l_msg_data);
2406: l_final_msg := FND_MESSAGE.GET;
2407: fnd_file.put_line(FND_FILE.LOG, l_final_msg);
2408:
2409: end if;
2410:

Line 2425: FND_MESSAGE.SET_NAME('IEU', 'IEU_SYNCH_WR_DIST_STATUS_SUM');

2421: x_return_status := 'S';
2422: end if;
2423:
2424: l_tot_cnt := c_task%ROWCOUNT;
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;

Line 2426: FND_MESSAGE.SET_TOKEN('SUCCESS_COUNT', l_success_cnt);

2422: end if;
2423:
2424: l_tot_cnt := c_task%ROWCOUNT;
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

Line 2427: FND_MESSAGE.SET_TOKEN('FAILED_COUNT', (l_tot_cnt - l_success_cnt));

2423:
2424: l_tot_cnt := c_task%ROWCOUNT;
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: (

Line 2428: FND_MESSAGE.SET_TOKEN('TOTAL_COUNT', l_tot_cnt );

2424: l_tot_cnt := c_task%ROWCOUNT;
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,

Line 2437: FND_MESSAGE.SET_NAME('IEU', 'IEU_SYNCH_WR_DIST_STATUS_SUM');

2433: p_data => x_msg_data
2434: );
2435:
2436: -- Write to log. Have to set msg again as its been removed from stack.
2437: FND_MESSAGE.SET_NAME('IEU', 'IEU_SYNCH_WR_DIST_STATUS_SUM');
2438: FND_MESSAGE.SET_TOKEN('SUCCESS_COUNT', l_success_cnt);
2439: FND_MESSAGE.SET_TOKEN('FAILED_COUNT', (l_tot_cnt - l_success_cnt));
2440: FND_MESSAGE.SET_TOKEN('TOTAL_COUNT', l_tot_cnt );
2441: l_final_msg := FND_MESSAGE.GET;

Line 2438: FND_MESSAGE.SET_TOKEN('SUCCESS_COUNT', l_success_cnt);

2434: );
2435:
2436: -- Write to log. Have to set msg again as its been removed from stack.
2437: FND_MESSAGE.SET_NAME('IEU', 'IEU_SYNCH_WR_DIST_STATUS_SUM');
2438: FND_MESSAGE.SET_TOKEN('SUCCESS_COUNT', l_success_cnt);
2439: FND_MESSAGE.SET_TOKEN('FAILED_COUNT', (l_tot_cnt - l_success_cnt));
2440: FND_MESSAGE.SET_TOKEN('TOTAL_COUNT', l_tot_cnt );
2441: l_final_msg := FND_MESSAGE.GET;
2442: fnd_file.put_line(FND_FILE.LOG, l_final_msg);

Line 2439: FND_MESSAGE.SET_TOKEN('FAILED_COUNT', (l_tot_cnt - l_success_cnt));

2435:
2436: -- Write to log. Have to set msg again as its been removed from stack.
2437: FND_MESSAGE.SET_NAME('IEU', 'IEU_SYNCH_WR_DIST_STATUS_SUM');
2438: FND_MESSAGE.SET_TOKEN('SUCCESS_COUNT', l_success_cnt);
2439: FND_MESSAGE.SET_TOKEN('FAILED_COUNT', (l_tot_cnt - l_success_cnt));
2440: FND_MESSAGE.SET_TOKEN('TOTAL_COUNT', l_tot_cnt );
2441: l_final_msg := FND_MESSAGE.GET;
2442: fnd_file.put_line(FND_FILE.LOG, l_final_msg);
2443:

Line 2440: FND_MESSAGE.SET_TOKEN('TOTAL_COUNT', l_tot_cnt );

2436: -- Write to log. Have to set msg again as its been removed from stack.
2437: FND_MESSAGE.SET_NAME('IEU', 'IEU_SYNCH_WR_DIST_STATUS_SUM');
2438: FND_MESSAGE.SET_TOKEN('SUCCESS_COUNT', l_success_cnt);
2439: FND_MESSAGE.SET_TOKEN('FAILED_COUNT', (l_tot_cnt - l_success_cnt));
2440: FND_MESSAGE.SET_TOKEN('TOTAL_COUNT', l_tot_cnt );
2441: l_final_msg := FND_MESSAGE.GET;
2442: fnd_file.put_line(FND_FILE.LOG, l_final_msg);
2443:
2444: --dbms_output.put_line('msg: '||l_final_msg);

Line 2441: l_final_msg := FND_MESSAGE.GET;

2437: FND_MESSAGE.SET_NAME('IEU', 'IEU_SYNCH_WR_DIST_STATUS_SUM');
2438: FND_MESSAGE.SET_TOKEN('SUCCESS_COUNT', l_success_cnt);
2439: FND_MESSAGE.SET_TOKEN('FAILED_COUNT', (l_tot_cnt - l_success_cnt));
2440: FND_MESSAGE.SET_TOKEN('TOTAL_COUNT', l_tot_cnt );
2441: l_final_msg := FND_MESSAGE.GET;
2442: fnd_file.put_line(FND_FILE.LOG, l_final_msg);
2443:
2444: --dbms_output.put_line('msg: '||l_final_msg);
2445:

Line 2551: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');

2547: errors := SQL%BULK_EXCEPTIONS.COUNT;
2548: FOR i IN 1..errors LOOP
2549:
2550: fnd_file.new_line(FND_FILE.LOG, 1);
2551: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
2552: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WS_DETAILS');
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));

Line 2552: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WS_DETAILS');

2548: FOR i IN 1..errors LOOP
2549:
2550: fnd_file.new_line(FND_FILE.LOG, 1);
2551: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
2552: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WS_DETAILS');
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);

Line 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));

2549:
2550: fnd_file.new_line(FND_FILE.LOG, 1);
2551: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
2552: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WS_DETAILS');
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;

Line 2556: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

2552: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WS_DETAILS');
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,

Line 2704: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

2700: WHEN OTHERS THEN
2701:
2702: -- Work Source does not exist for this Object Code
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

Line 2705: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.GET_NEXT_WORK_FOR_APPS');

2701:
2702: -- Work Source does not exist for this Object Code
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: (

Line 2706: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

2702: -- Work Source does not exist for this Object Code
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,

Line 2880: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');

2876: x_return_status := fnd_api.g_ret_sts_error;
2877:
2878: l_token_str := p_wr_item_list(i).workitem_obj_code ||' WORKITEM_PK_ID : '|| p_wr_item_list(i).workitem_pk_id ||' - '||l_msg_data;
2879:
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;

Line 2881: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

2877:
2878: l_token_str := p_wr_item_list(i).workitem_obj_code ||' WORKITEM_PK_ID : '|| p_wr_item_list(i).workitem_pk_id ||' - '||l_msg_data;
2879:
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

Line 2882: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);

2878: l_token_str := p_wr_item_list(i).workitem_obj_code ||' WORKITEM_PK_ID : '|| p_wr_item_list(i).workitem_pk_id ||' - '||l_msg_data;
2879:
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: (

Line 2910: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

2906: WHEN OTHERS THEN
2907:
2908: -- Work Source does not exist for this Object Code
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

Line 2911: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');

2907:
2908: -- Work Source does not exist for this Object Code
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: (

Line 2912: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

2908: -- Work Source does not exist for this Object Code
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,

Line 2939: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

2935: WHEN NO_DATA_FOUND THEN
2936:
2937: -- Work Source does not exist for this Object Code
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

Line 2940: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');

2936:
2937: -- Work Source does not exist for this Object Code
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: (

Line 2941: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

2937: -- Work Source does not exist for this Object Code
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,

Line 3346: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');

3342:
3343: If (l_miss_param_flag = 1)
3344: THEN
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

Line 3347: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

3343: If (l_miss_param_flag = 1)
3344: THEN
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: (

Line 3348: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);

3344: THEN
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,

Line 3389: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');

3385:
3386: IF (l_param_valid_flag = 1)
3387: THEN
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

Line 3390: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

3386: IF (l_param_valid_flag = 1)
3387: THEN
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: (

Line 3391: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

3387: THEN
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,

Line 3428: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');

3424:
3425: IF (l_param_valid_flag = 1)
3426: THEN
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

Line 3429: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

3425: IF (l_param_valid_flag = 1)
3426: THEN
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: (

Line 3430: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

3426: THEN
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,

Line 3460: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');

3456:
3457: IF (l_work_item_status_valid_flag = 'F')
3458: THEN
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

Line 3461: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

3457: IF (l_work_item_status_valid_flag = 'F')
3458: THEN
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: (

Line 3462: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

3458: THEN
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,

Line 3479: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_PARAM_EXCEED_MAX');

3475: IF (length(p_title) > l_title_len)
3476: THEN
3477:
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

Line 3480: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

3476: THEN
3477:
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: (

Line 3481: FND_MESSAGE.SET_TOKEN('IEU_UWQ_PARAM_MAX',' TITLE ');

3477:
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,

Line 3528: FND_MESSAGE.SET_NAME('IEU', 'IEU_WR_OWN_OR_ASG_ID_NULL');

3524: ( (p_assignee_type is not null) and (p_assignee_id is null) )
3525: then
3526: l_token_str := '';
3527: l_token_str2 := '';
3528: FND_MESSAGE.SET_NAME('IEU', 'IEU_WR_OWN_OR_ASG_ID_NULL');
3529: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
3530: if ( (p_owner_id is null) and (p_owner_type is not null) OR
3531: (p_owner_id is not null) and (p_owner_type is null) )
3532: then

Line 3529: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

3525: then
3526: l_token_str := '';
3527: l_token_str2 := '';
3528: FND_MESSAGE.SET_NAME('IEU', 'IEU_WR_OWN_OR_ASG_ID_NULL');
3529: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');
3530: if ( (p_owner_id is null) and (p_owner_type is not null) OR
3531: (p_owner_id is not null) and (p_owner_type is null) )
3532: then
3533: l_token_str := ' OWNER_ID';

Line 3553: FND_MESSAGE.SET_TOKEN('ID_PARAM',l_token_str);

3549: else
3550: l_token_str2 := ' ASSINGEE_TYPE - '||p_assignee_type;
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: (

Line 3554: FND_MESSAGE.SET_TOKEN('TYPE_PARAM',l_token_str2);

3550: l_token_str2 := ' ASSINGEE_TYPE - '||p_assignee_type;
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,

Line 3620: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');

3616: WHEN OTHERS THEN
3617:
3618: -- Work Source does not exist for this Object Code
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

Line 3621: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

3617:
3618: -- Work Source does not exist for this Object Code
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: (

Line 3622: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

3618: -- Work Source does not exist for this Object Code
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,

Line 3701: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

3697: EXCEPTION
3698: WHEN OTHERS THEN
3699: -- Work Source Details does not exist for this Object Code
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

Line 3702: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

3698: WHEN OTHERS THEN
3699: -- Work Source Details does not exist for this Object Code
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: (

Line 3703: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

3699: -- Work Source Details does not exist for this Object Code
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,

Line 3734: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

3730: EXCEPTION
3731: WHEN OTHERS THEN
3732: -- Work Source Details does not exist for this Object Code
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

Line 3735: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

3731: WHEN OTHERS THEN
3732: -- Work Source Details does not exist for this Object Code
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: (

Line 3736: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

3732: -- Work Source Details does not exist for this Object Code
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,

Line 4155: FND_MESSAGE.SET_NAME('IEU', 'IEU_CREATE_WR_ITEM_FAILED');

4151: then
4152: x_return_status := fnd_api.g_ret_sts_error;
4153: l_token_str := l_msg_data;
4154:
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;

Line 4156: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

4152: x_return_status := fnd_api.g_ret_sts_error;
4153: l_token_str := l_msg_data;
4154:
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

Line 4157: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);

4153: l_token_str := l_msg_data;
4154:
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: (

Line 4180: FND_MESSAGE.SET_NAME('IEU', 'IEU_CREATE_WR_ITEM_FAILED');

4176:
4177: x_return_status := fnd_api.g_ret_sts_error;
4178: l_token_str := l_msg_data;
4179:
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;

Line 4181: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

4177: x_return_status := fnd_api.g_ret_sts_error;
4178: l_token_str := l_msg_data;
4179:
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

Line 4182: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);

4178: l_token_str := l_msg_data;
4179:
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: (

Line 4643: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');

4639:
4640: If (l_miss_param_flag = 1)
4641: THEN
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

Line 4644: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

4640: If (l_miss_param_flag = 1)
4641: THEN
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: (

Line 4645: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);

4641: THEN
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,

Line 4691: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');

4687:
4688: l_token_str := 'TITLE, PARTY_ID, DUE_DATE, OWNER_ID, OWNER_TYPE, ';
4689: l_token_str := l_token_str || 'ASSIGNEE_ID, APPLICATION_ID, SOURCE_OBJECT_ID, SOURCE_OBJ_TYPE';
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

Line 4692: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

4688: l_token_str := 'TITLE, PARTY_ID, DUE_DATE, OWNER_ID, OWNER_TYPE, ';
4689: l_token_str := l_token_str || 'ASSIGNEE_ID, APPLICATION_ID, SOURCE_OBJECT_ID, SOURCE_OBJ_TYPE';
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: (

Line 4693: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

4689: l_token_str := l_token_str || 'ASSIGNEE_ID, APPLICATION_ID, SOURCE_OBJECT_ID, SOURCE_OBJ_TYPE';
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,

Line 4737: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');

4733: EXCEPTION WHEN OTHERS THEN
4734: l_token_str := 'TITLE, PARTY_ID, DUE_DATE, OWNER_ID, OWNER_TYPE, ';
4735: l_token_str := l_token_str || 'ASSIGNEE_ID, APPLICATION_ID, SOURCE_OBJECT_ID, SOURCE_OBJ_TYPE';
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

Line 4738: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

4734: l_token_str := 'TITLE, PARTY_ID, DUE_DATE, OWNER_ID, OWNER_TYPE, ';
4735: l_token_str := l_token_str || 'ASSIGNEE_ID, APPLICATION_ID, SOURCE_OBJECT_ID, SOURCE_OBJ_TYPE';
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: (

Line 4739: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

4735: l_token_str := l_token_str || 'ASSIGNEE_ID, APPLICATION_ID, SOURCE_OBJECT_ID, SOURCE_OBJ_TYPE';
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,

Line 4809: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');

4805: WHEN OTHERS THEN
4806:
4807: l_token_str := 'PRIORITY_CODE : '||p_priority_code;
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

Line 4810: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

4806:
4807: l_token_str := 'PRIORITY_CODE : '||p_priority_code;
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: (

Line 4811: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

4807: l_token_str := 'PRIORITY_CODE : '||p_priority_code;
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,

Line 4834: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');

4830: EXCEPTION
4831: WHEN OTHERS THEN
4832: l_token_str := 'WORK_ITEM_STATUS : '||p_work_item_status;
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

Line 4835: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

4831: WHEN OTHERS THEN
4832: l_token_str := 'WORK_ITEM_STATUS : '||p_work_item_status;
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: (

Line 4836: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

4832: l_token_str := 'WORK_ITEM_STATUS : '||p_work_item_status;
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,

Line 4882: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');

4878:
4879: IF (l_param_valid_flag = 1)
4880: THEN
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

Line 4883: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

4879: IF (l_param_valid_flag = 1)
4880: THEN
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: (

Line 4884: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

4880: THEN
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,

Line 4921: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');

4917:
4918: IF (l_param_valid_flag = 1)
4919: THEN
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

Line 4922: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

4918: IF (l_param_valid_flag = 1)
4919: THEN
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: (

Line 4923: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

4919: THEN
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,

Line 4951: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');

4947:
4948: IF (l_work_item_status_valid_flag = 'F')
4949: THEN
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

Line 4952: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

4948: IF (l_work_item_status_valid_flag = 'F')
4949: THEN
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: (

Line 4953: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

4949: THEN
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,

Line 4969: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_PARAM_EXCEED_MAX');

4965: IF (length(m_title) > l_title_len)
4966: THEN
4967:
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

Line 4970: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

4966: THEN
4967:
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: (

Line 4971: FND_MESSAGE.SET_TOKEN('IEU_UWQ_PARAM_MAX',' TITLE ');

4967:
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,

Line 5018: FND_MESSAGE.SET_NAME('IEU', 'IEU_WR_OWN_OR_ASG_ID_NULL');

5014: ( (m_assignee_type is not null) and (m_assignee_id is null) )
5015: then
5016: l_token_str := '';
5017: l_token_str2 := '';
5018: FND_MESSAGE.SET_NAME('IEU', 'IEU_WR_OWN_OR_ASG_ID_NULL');
5019: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
5020: if ( (m_owner_id is null) and (m_owner_type is not null) OR
5021: (m_owner_id is not null) and (m_owner_type is null) )
5022: then

Line 5019: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

5015: then
5016: l_token_str := '';
5017: l_token_str2 := '';
5018: FND_MESSAGE.SET_NAME('IEU', 'IEU_WR_OWN_OR_ASG_ID_NULL');
5019: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');
5020: if ( (m_owner_id is null) and (m_owner_type is not null) OR
5021: (m_owner_id is not null) and (m_owner_type is null) )
5022: then
5023: l_token_str := ' OWNER_ID';

Line 5042: FND_MESSAGE.SET_TOKEN('ID_PARAM',l_token_str);

5038: else
5039: l_token_str2 := ' ASSINGEE_TYPE - '||m_assignee_type;
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: (

Line 5043: FND_MESSAGE.SET_TOKEN('TYPE_PARAM',l_token_str2);

5039: l_token_str2 := ' ASSINGEE_TYPE - '||m_assignee_type;
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,

Line 5107: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');

5103: WHEN OTHERS THEN
5104:
5105: -- Work Source does not exist for this Object Code
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

Line 5108: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

5104:
5105: -- Work Source does not exist for this Object Code
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: (

Line 5109: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

5105: -- Work Source does not exist for this Object Code
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,

Line 5188: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');

5184: EXCEPTION
5185: WHEN OTHERS THEN
5186: -- Work Source does not exist for this Object Code
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

Line 5189: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

5185: WHEN OTHERS THEN
5186: -- Work Source does not exist for this Object Code
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: (

Line 5190: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

5186: -- Work Source does not exist for this Object Code
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,

Line 5220: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');

5216: EXCEPTION
5217: WHEN OTHERS THEN
5218: -- Work Source does not exist for this Object Code
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

Line 5221: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.CREATE_WR_ITEM');

5217: WHEN OTHERS THEN
5218: -- Work Source does not exist for this Object Code
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: (

Line 5222: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

5218: -- Work Source does not exist for this Object Code
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,

Line 5734: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_WR_ITEM_FAILED');

5730: then
5731: x_return_status := fnd_api.g_ret_sts_error;
5732: l_token_str := l_msg_data;
5733:
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;

Line 5735: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

5731: x_return_status := fnd_api.g_ret_sts_error;
5732: l_token_str := l_msg_data;
5733:
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

Line 5736: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);

5732: l_token_str := l_msg_data;
5733:
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: (

Line 5763: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_WR_ITEM_FAILED');

5759:
5760: x_return_status := fnd_api.g_ret_sts_error;
5761: l_token_str := l_msg_data;
5762:
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;

Line 5764: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

5760: x_return_status := fnd_api.g_ret_sts_error;
5761: l_token_str := l_msg_data;
5762:
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

Line 5765: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);

5761: l_token_str := l_msg_data;
5762:
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: (

Line 6189: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');

6185:
6186: If (l_miss_param_flag = 1)
6187: THEN
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

Line 6190: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_UWQM_PUB.RESCHEDULE_UWQM_ITEM');

6186: If (l_miss_param_flag = 1)
6187: THEN
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: (

Line 6191: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);

6187: THEN
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,

Line 6224: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_COMBINATION');

6220:
6221: l_token_str :=' WORKITEM_ID :'||
6222: p_work_item_id||' WORKITEM_PK_ID: '||p_workitem_pk_id||
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

Line 6225: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_UWQM_PUB.RESCHEDULE_UWQM_ITEM');

6221: l_token_str :=' WORKITEM_ID :'||
6222: p_work_item_id||' WORKITEM_PK_ID: '||p_workitem_pk_id||
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: (

Line 6226: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

6222: p_work_item_id||' WORKITEM_PK_ID: '||p_workitem_pk_id||
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,

Line 6275: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');

6271:
6272: IF (l_param_valid_flag = 1)
6273: THEN
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

Line 6276: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_UWQM_PUB.RESCHEDULE_UWQM_ITEM');

6272: IF (l_param_valid_flag = 1)
6273: THEN
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: (

Line 6277: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

6273: THEN
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,

Line 6437: FND_MESSAGE.SET_NAME('IEU', 'IEU_SUSPEND_UWQM_ITEM_FAILED');

6433: x_return_status := fnd_api.g_ret_sts_error;
6434:
6435: l_token_str := 'WORKITEM_OBJ_CODE : '||p_workitem_obj_code||
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

Line 6438: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_UWQM_PUB.RESCHEDULE_UWQM_ITEM');

6434:
6435: l_token_str := 'WORKITEM_OBJ_CODE : '||p_workitem_obj_code||
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: (

Line 6439: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);

6435: l_token_str := 'WORKITEM_OBJ_CODE : '||p_workitem_obj_code||
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,

Line 6915: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

6911: WHEN OTHERS THEN
6912:
6913: -- Work Source does not exist for this Object Code
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

Line 6916: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');

6912:
6913: -- Work Source does not exist for this Object Code
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: (

Line 6917: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

6913: -- Work Source does not exist for this Object Code
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,

Line 6935: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');

6931: -- The Sync script works only for Association Work Source
6932: -- If a primary Work Source is passed then it will throw an exception and exit
6933: -- Work Source does not exist for this Object Code
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

Line 6936: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');

6932: -- If a primary Work Source is passed then it will throw an exception and exit
6933: -- Work Source does not exist for this Object Code
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: (

Line 6937: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

6933: -- Work Source does not exist for this Object Code
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,

Line 6962: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

6958: WHEN NO_DATA_FOUND THEN
6959:
6960: -- Work Source does not exist for this Object Code
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

Line 6963: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');

6959:
6960: -- Work Source does not exist for this Object Code
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: (

Line 6964: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

6960: -- Work Source does not exist for this Object Code
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,

Line 6990: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

6986: WHEN NO_DATA_FOUND THEN
6987:
6988: -- Work Source does not exist for this Object Code
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

Line 6991: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');

6987:
6988: -- Work Source does not exist for this Object Code
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: (

Line 6992: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

6988: -- Work Source does not exist for this Object Code
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,

Line 7018: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

7014: WHEN NO_DATA_FOUND THEN
7015:
7016: -- Work Source does not exist for this Object Code
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

Line 7019: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');

7015:
7016: -- Work Source does not exist for this Object Code
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: (

Line 7020: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

7016: -- Work Source does not exist for this Object Code
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,

Line 7556: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');

7552: errors := SQL%BULK_EXCEPTIONS.COUNT;
7553: FOR i IN 1..errors LOOP
7554:
7555: fnd_file.new_line(FND_FILE.LOG, 1);
7556: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
7557: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WS_DETAILS');
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));

Line 7557: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WS_DETAILS');

7553: FOR i IN 1..errors LOOP
7554:
7555: fnd_file.new_line(FND_FILE.LOG, 1);
7556: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
7557: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WS_DETAILS');
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);

Line 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));

7554:
7555: fnd_file.new_line(FND_FILE.LOG, 1);
7556: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
7557: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WS_DETAILS');
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;

Line 7561: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

7557: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WS_DETAILS');
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,

Line 7942: FND_MESSAGE.SET_NAME('IEU', 'GET_NEXT_WORK_FOR_APPS');

7938: WHEN OTHERS THEN
7939:
7940: -- Work Source does not exist for this Object Code
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

Line 7943: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','GET_NEXT_WORK_FOR_APPS');

7939:
7940: -- Work Source does not exist for this Object Code
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: (

Line 7944: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

7940: -- Work Source does not exist for this Object Code
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,

Line 8527: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');

8523: x_return_status := fnd_api.g_ret_sts_error;
8524:
8525: l_token_str := p_wr_item_list(i).workitem_obj_code ||' WORKITEM_PK_ID : '|| p_wr_item_list(i).workitem_pk_id ||' - '||l_msg_data;
8526:
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;

Line 8528: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM');

8524:
8525: l_token_str := p_wr_item_list(i).workitem_obj_code ||' WORKITEM_PK_ID : '|| p_wr_item_list(i).workitem_pk_id ||' - '||l_msg_data;
8526:
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

Line 8529: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);

8525: l_token_str := p_wr_item_list(i).workitem_obj_code ||' WORKITEM_PK_ID : '|| p_wr_item_list(i).workitem_pk_id ||' - '||l_msg_data;
8526:
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: (

Line 8558: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

8554: WHEN OTHERS THEN
8555:
8556: -- Work Source does not exist for this Object Code
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

Line 8559: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');

8555:
8556: -- Work Source does not exist for this Object Code
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: (

Line 8560: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

8556: -- Work Source does not exist for this Object Code
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,

Line 8586: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

8582: WHEN NO_DATA_FOUND THEN
8583:
8584: -- Work Source does not exist for this Object Code
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

Line 8587: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WS_DETAILS');

8583:
8584: -- Work Source does not exist for this Object Code
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: (

Line 8588: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

8584: -- Work Source does not exist for this Object Code
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,

Line 9234: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');

9230:
9231: If (l_miss_param_flag = 1)
9232: THEN
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

Line 9235: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.ACTIVATE_WS');

9231: If (l_miss_param_flag = 1)
9232: THEN
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: (

Line 9236: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);

9232: THEN
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,

Line 9268: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_COMBINATION');

9264:
9265: IF (p_ws_code <> nvl(l_ws_code, '-1'))
9266: THEN
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

Line 9269: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.ACTIVATE_WS');

9265: IF (p_ws_code <> nvl(l_ws_code, '-1'))
9266: THEN
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: (

Line 9270: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

9266: THEN
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,

Line 9392: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');

9388:
9389: If (l_miss_param_flag = 1)
9390: THEN
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

Line 9393: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.ACTIVATE_WS');

9389: If (l_miss_param_flag = 1)
9390: THEN
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: (

Line 9394: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);

9390: THEN
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,

Line 9426: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_COMBINATION');

9422:
9423: IF (p_ws_code <> nvl(l_ws_code, '-1'))
9424: THEN
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

Line 9427: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.ACTIVATE_WS');

9423: IF (p_ws_code <> nvl(l_ws_code, '-1'))
9424: THEN
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: (

Line 9428: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

9424: THEN
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,

Line 9533: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');

9529:
9530: If (l_miss_param_flag = 1)
9531: THEN
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

Line 9534: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.PURGE_WR_ITEM');

9530: If (l_miss_param_flag = 1)
9531: THEN
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: (

Line 9535: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);

9531: THEN
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,

Line 9576: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');

9572:
9573: IF (l_param_valid_flag = 1)
9574: THEN
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

Line 9577: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.PURGE_WR_ITEM');

9573: IF (l_param_valid_flag = 1)
9574: THEN
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: (

Line 9578: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

9574: THEN
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,

Line 9623: FND_MESSAGE.SET_NAME('IEU', 'IEU_PURGE_WR_ITEM_FAILED');

9619:
9620: x_return_status := fnd_api.g_ret_sts_error;
9621: l_token_str := l_msg_data;
9622:
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;

Line 9624: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.PURGE_WR_ITEM');

9620: x_return_status := fnd_api.g_ret_sts_error;
9621: l_token_str := l_msg_data;
9622:
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

Line 9625: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);

9621: l_token_str := l_msg_data;
9622:
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: (

Line 9815: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');

9811:
9812: If (l_miss_param_flag = 1)
9813: THEN
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

Line 9816: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.PURGE_WR_ITEM');

9812: If (l_miss_param_flag = 1)
9813: THEN
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: (

Line 9817: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);

9813: THEN
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,

Line 9858: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_VALUE');

9854:
9855: IF (l_param_valid_flag = 1)
9856: THEN
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

Line 9859: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.PURGE_WR_ITEM');

9855: IF (l_param_valid_flag = 1)
9856: THEN
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: (

Line 9860: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

9856: THEN
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,

Line 10028: FND_MESSAGE.SET_NAME('IEU', 'IEU_PURGE_WR_ITEM_FAILED');

10024:
10025: x_return_status := fnd_api.g_ret_sts_error;
10026: l_token_str := l_msg_data;
10027:
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;

Line 10029: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.PURGE_WR_ITEM');

10025: x_return_status := fnd_api.g_ret_sts_error;
10026: l_token_str := l_msg_data;
10027:
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

Line 10030: FND_MESSAGE.SET_TOKEN('DETAILS', l_token_str);

10026: l_token_str := l_msg_data;
10027:
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: (

Line 10350: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_REQUIRED_PARAM_NULL');

10346:
10347: If (l_miss_param_flag = 1)
10348: THEN
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

Line 10351: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.DEACTIVATE_WS');

10347: If (l_miss_param_flag = 1)
10348: THEN
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: (

Line 10352: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);

10348: THEN
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,

Line 10385: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_COMBINATION');

10381:
10382: IF (p_ws_code <> nvl(l_ws_code, '-1'))
10383: THEN
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

Line 10386: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.DEACTIVATE_WS');

10382: IF (p_ws_code <> nvl(l_ws_code, '-1'))
10383: THEN
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: (

Line 10387: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

10383: THEN
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,

Line 10586: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_RQD_VALUE_NULL');

10582: If (l_miss_param_flag = 1)
10583: THEN
10584:
10585: fnd_file.new_line(FND_FILE.LOG, 1);
10586: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_RQD_VALUE_NULL');
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:

Line 10587: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');

10583: THEN
10584:
10585: fnd_file.new_line(FND_FILE.LOG, 1);
10586: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_RQD_VALUE_NULL');
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;

Line 10588: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);

10584:
10585: fnd_file.new_line(FND_FILE.LOG, 1);
10586: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_RQD_VALUE_NULL');
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

Line 10589: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

10585: fnd_file.new_line(FND_FILE.LOG, 1);
10586: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_RQD_VALUE_NULL');
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: (

Line 10635: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_STATUS');

10631: l_token_str := l_token_str||WORKITEM_OBJ_CODE_LIST(i)||'-'||TO_CHAR(WORKITEM_PK_ID_LIST(i))||' ';
10632: END LOOP;
10633:
10634: fnd_file.new_line(FND_FILE.LOG, 1);
10635: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_STATUS');
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:

Line 10636: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');

10632: END LOOP;
10633:
10634: fnd_file.new_line(FND_FILE.LOG, 1);
10635: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_STATUS');
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;

Line 10637: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);

10633:
10634: fnd_file.new_line(FND_FILE.LOG, 1);
10635: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_STATUS');
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

Line 10638: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

10634: fnd_file.new_line(FND_FILE.LOG, 1);
10635: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_STATUS');
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: (

Line 10690: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_VALUE');

10686: l_token_str := l_token_str||WORKITEM_OBJ_CODE_LIST(i)||'-'||TO_CHAR(WORKITEM_PK_ID_LIST(i))||' ';
10687: END LOOP;
10688:
10689: fnd_file.new_line(FND_FILE.LOG, 1);
10690: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_VALUE');
10691: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
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);

Line 10691: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');

10687: END LOOP;
10688:
10689: fnd_file.new_line(FND_FILE.LOG, 1);
10690: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_VALUE');
10691: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
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:

Line 10692: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','WORKITEM_OBJ_CODE');

10688:
10689: fnd_file.new_line(FND_FILE.LOG, 1);
10690: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_VALUE');
10691: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
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;

Line 10693: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);

10689: fnd_file.new_line(FND_FILE.LOG, 1);
10690: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_VALUE');
10691: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
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

Line 10694: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

10690: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_VALUE');
10691: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
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: (

Line 10745: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_VALUE');

10741: l_token_str := l_token_str||WORKITEM_OBJ_CODE_LIST(i)||'-'||TO_CHAR(WORKITEM_PK_ID_LIST(i))||' ';
10742: END LOOP;
10743:
10744: fnd_file.new_line(FND_FILE.LOG, 1);
10745: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_VALUE');
10746: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
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);

Line 10746: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');

10742: END LOOP;
10743:
10744: fnd_file.new_line(FND_FILE.LOG, 1);
10745: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_VALUE');
10746: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
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:

Line 10747: FND_MESSAGE.SET_TOKEN('COLUMN_NAME','PRIORITY_CODE');

10743:
10744: fnd_file.new_line(FND_FILE.LOG, 1);
10745: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_VALUE');
10746: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
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;

Line 10748: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);

10744: fnd_file.new_line(FND_FILE.LOG, 1);
10745: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_VALUE');
10746: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
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

Line 10749: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

10745: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_VALUE');
10746: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');
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: (

Line 10809: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_WS');

10805:
10806: -- Work Source does not exist for this Object Code
10807:
10808: fnd_file.new_line(FND_FILE.LOG, 1);
10809: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_WS');
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:

Line 10810: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');

10806: -- Work Source does not exist for this Object Code
10807:
10808: fnd_file.new_line(FND_FILE.LOG, 1);
10809: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_WS');
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;

Line 10811: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);

10807:
10808: fnd_file.new_line(FND_FILE.LOG, 1);
10809: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_WS');
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

Line 10812: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

10808: fnd_file.new_line(FND_FILE.LOG, 1);
10809: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_WS');
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: (

Line 10887: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_WS_DTLS_NULL');

10883: -- Work Source Details does not exist for this Object Code
10884: l_token_str := '(IEU_UWQ_SYNC_WR_WS_DTLS_NULL) '||sqlcode||' '||sqlerrm;
10885:
10886: fnd_file.new_line(FND_FILE.LOG, 1);
10887: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_WS_DTLS_NULL');
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:

Line 10888: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEMS');

10884: l_token_str := '(IEU_UWQ_SYNC_WR_WS_DTLS_NULL) '||sqlcode||' '||sqlerrm;
10885:
10886: fnd_file.new_line(FND_FILE.LOG, 1);
10887: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_WS_DTLS_NULL');
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;

Line 10889: FND_MESSAGE.SET_TOKEN('DETAILS',l_token_str);

10885:
10886: fnd_file.new_line(FND_FILE.LOG, 1);
10887: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_WS_DTLS_NULL');
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

Line 10890: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

10886: fnd_file.new_line(FND_FILE.LOG, 1);
10887: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_WS_DTLS_NULL');
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: (

Line 11133: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INSERT_FAILED');

11129: IF SQL%BULK_EXCEPTIONS(i).ERROR_CODE <> 1 then
11130: err_flag := 'Y';
11131:
11132: fnd_file.new_line(FND_FILE.LOG, 1);
11133: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INSERT_FAILED');
11134: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEMS');
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);

Line 11134: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEMS');

11130: err_flag := 'Y';
11131:
11132: fnd_file.new_line(FND_FILE.LOG, 1);
11133: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INSERT_FAILED');
11134: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEMS');
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:

Line 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));

11131:
11132: fnd_file.new_line(FND_FILE.LOG, 1);
11133: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INSERT_FAILED');
11134: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEMS');
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;

Line 11137: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11133: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INSERT_FAILED');
11134: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEMS');
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: (

Line 11194: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_UPDATE_FAILED');

11190: errors := SQL%BULK_EXCEPTIONS.COUNT;
11191:
11192: FOR i IN 1..errors LOOP
11193: fnd_file.new_line(FND_FILE.LOG, 1);
11194: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_UPDATE_FAILED');
11195: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEMS');
11196: 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));
11197:
11198: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));

Line 11195: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEMS');

11191:
11192: FOR i IN 1..errors LOOP
11193: fnd_file.new_line(FND_FILE.LOG, 1);
11194: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_UPDATE_FAILED');
11195: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEMS');
11196: 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));
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);

Line 11196: 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));

11192: FOR i IN 1..errors LOOP
11193: fnd_file.new_line(FND_FILE.LOG, 1);
11194: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_UPDATE_FAILED');
11195: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEMS');
11196: 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));
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:

Line 11199: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11195: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEMS');
11196: 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));
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: (

Line 11462: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

11458: -- Work Source does not exist for this Object Code
11459: l_token_str := 'WS_CODE: '||p_ws_code;
11460:
11461: fnd_file.new_line(FND_FILE.LOG, 1);
11462: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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:

Line 11463: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');

11459: l_token_str := 'WS_CODE: '||p_ws_code;
11460:
11461: fnd_file.new_line(FND_FILE.LOG, 1);
11462: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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;

Line 11464: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

11460:
11461: fnd_file.new_line(FND_FILE.LOG, 1);
11462: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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

Line 11465: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11461: fnd_file.new_line(FND_FILE.LOG, 1);
11462: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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: (

Line 11486: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');

11482: -- Work Source does not exist for this Object Code
11483: l_token_str := 'WORK_SOURCE:' ||p_ws_code;
11484:
11485: fnd_file.new_line(FND_FILE.LOG, 1);
11486: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
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:

Line 11487: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');

11483: l_token_str := 'WORK_SOURCE:' ||p_ws_code;
11484:
11485: fnd_file.new_line(FND_FILE.LOG, 1);
11486: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
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;

Line 11488: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

11484:
11485: fnd_file.new_line(FND_FILE.LOG, 1);
11486: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
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

Line 11489: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11485: fnd_file.new_line(FND_FILE.LOG, 1);
11486: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_INVALID_WORK_SOURCE');
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: (

Line 11517: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

11513: -- Work Source does not exist for this Object Code
11514: l_token_str := 'WS_CODE: '||p_ws_code;
11515:
11516: fnd_file.new_line(FND_FILE.LOG, 1);
11517: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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:

Line 11518: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');

11514: l_token_str := 'WS_CODE: '||p_ws_code;
11515:
11516: fnd_file.new_line(FND_FILE.LOG, 1);
11517: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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;

Line 11519: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

11515:
11516: fnd_file.new_line(FND_FILE.LOG, 1);
11517: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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

Line 11520: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11516: fnd_file.new_line(FND_FILE.LOG, 1);
11517: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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: (

Line 11553: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

11549: WHEN NO_DATA_FOUND THEN
11550: l_token_str := 'WS_CODE: '||p_ws_code;
11551:
11552: fnd_file.new_line(FND_FILE.LOG, 1);
11553: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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:

Line 11554: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');

11550: l_token_str := 'WS_CODE: '||p_ws_code;
11551:
11552: fnd_file.new_line(FND_FILE.LOG, 1);
11553: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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;

Line 11555: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

11551:
11552: fnd_file.new_line(FND_FILE.LOG, 1);
11553: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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

Line 11556: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11552: fnd_file.new_line(FND_FILE.LOG, 1);
11553: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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: (

Line 11579: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

11575: WHEN NO_DATA_FOUND THEN
11576: l_token_str := 'WS_CODE: '||p_ws_code;
11577:
11578: fnd_file.new_line(FND_FILE.LOG, 1);
11579: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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:

Line 11580: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');

11576: l_token_str := 'WS_CODE: '||p_ws_code;
11577:
11578: fnd_file.new_line(FND_FILE.LOG, 1);
11579: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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;

Line 11581: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

11577:
11578: fnd_file.new_line(FND_FILE.LOG, 1);
11579: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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

Line 11582: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11578: fnd_file.new_line(FND_FILE.LOG, 1);
11579: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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: (

Line 11599: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_PRNT_WS_INACTIVE');

11595: -- The Sync script works only if Parent Work Source is ACTIVE
11596: -- Else it will throw an exception and exit
11597:
11598: fnd_file.new_line(FND_FILE.LOG, 1);
11599: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_PRNT_WS_INACTIVE');
11600: FND_MESSAGE.SET_TOKEN('PACKAGE.PROCEDURE','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
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);

Line 11600: FND_MESSAGE.SET_TOKEN('PACKAGE.PROCEDURE','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');

11596: -- Else it will throw an exception and exit
11597:
11598: fnd_file.new_line(FND_FILE.LOG, 1);
11599: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_PRNT_WS_INACTIVE');
11600: FND_MESSAGE.SET_TOKEN('PACKAGE.PROCEDURE','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
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:

Line 11601: FND_MESSAGE.SET_TOKEN('WS_NAME', l_ws_name);

11597:
11598: fnd_file.new_line(FND_FILE.LOG, 1);
11599: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_PRNT_WS_INACTIVE');
11600: FND_MESSAGE.SET_TOKEN('PACKAGE.PROCEDURE','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
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;

Line 11602: FND_MESSAGE.SET_TOKEN('PRIMARY_WS_NAME', l_parent_ws_name);

11598: fnd_file.new_line(FND_FILE.LOG, 1);
11599: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_PRNT_WS_INACTIVE');
11600: FND_MESSAGE.SET_TOKEN('PACKAGE.PROCEDURE','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
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

Line 11603: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11599: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_PRNT_WS_INACTIVE');
11600: FND_MESSAGE.SET_TOKEN('PACKAGE.PROCEDURE','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
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: (

Line 11622: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

11618: -- Work Source does not exist for this Object Code
11619: l_token_str := 'WS_CODE: '||p_ws_code;
11620:
11621: fnd_file.new_line(FND_FILE.LOG, 1);
11622: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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:

Line 11623: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');

11619: l_token_str := 'WS_CODE: '||p_ws_code;
11620:
11621: fnd_file.new_line(FND_FILE.LOG, 1);
11622: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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;

Line 11624: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

11620:
11621: fnd_file.new_line(FND_FILE.LOG, 1);
11622: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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

Line 11625: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11621: fnd_file.new_line(FND_FILE.LOG, 1);
11622: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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: (

Line 11653: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

11649: -- Work Source does not exist for this Object Code
11650: l_token_str := 'WS_CODE: '||p_ws_code;
11651:
11652: fnd_file.new_line(FND_FILE.LOG, 1);
11653: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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:

Line 11654: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');

11650: l_token_str := 'WS_CODE: '||p_ws_code;
11651:
11652: fnd_file.new_line(FND_FILE.LOG, 1);
11653: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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;

Line 11655: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

11651:
11652: fnd_file.new_line(FND_FILE.LOG, 1);
11653: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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

Line 11656: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11652: fnd_file.new_line(FND_FILE.LOG, 1);
11653: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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: (

Line 11806: FND_MESSAGE.SET_NAME('IEU', 'IEU_ERROR_THRESHOLD');

11802: --** checking for error threshold **--
11803:
11804: l_error_count := l_error_count + 1;
11805: IF l_error_count > 1000 THEN
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;

Line 11807: FND_MESSAGE.SET_TOKEN('ERROR_COUNT', '1000');

11803:
11804: l_error_count := l_error_count + 1;
11805: IF l_error_count > 1000 THEN
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

Line 11808: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');

11804: l_error_count := l_error_count + 1;
11805: IF l_error_count > 1000 THEN
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: (

Line 11809: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11805: IF l_error_count > 1000 THEN
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,

Line 11820: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INSERT_FAILED');

11816:
11817: RAISE fnd_api.g_exc_error;
11818: END IF;
11819: fnd_file.new_line(FND_FILE.LOG, 1);
11820: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INSERT_FAILED');
11821: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11822: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_ws_details_rec.WORKITEM_PK_ID_LIST(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
11823:
11824: fnd_file.put_line(FND_FILE.LOG,SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));

Line 11821: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');

11817: RAISE fnd_api.g_exc_error;
11818: END IF;
11819: fnd_file.new_line(FND_FILE.LOG, 1);
11820: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INSERT_FAILED');
11821: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11822: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_ws_details_rec.WORKITEM_PK_ID_LIST(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
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);

Line 11822: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_ws_details_rec.WORKITEM_PK_ID_LIST(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));

11818: END IF;
11819: fnd_file.new_line(FND_FILE.LOG, 1);
11820: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INSERT_FAILED');
11821: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11822: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_ws_details_rec.WORKITEM_PK_ID_LIST(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
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:

Line 11825: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11821: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11822: FND_MESSAGE.SET_TOKEN('DETAILS', ' WORKITEM_PK_ID:'||l_ws_details_rec.WORKITEM_PK_ID_LIST(SQL%BULK_EXCEPTIONS(i).ERROR_INDEX) ||' Error: '||SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
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: (

Line 11852: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_UPDATE_FAILED');

11848: and asg.assignee_role= 'OWNER');
11849: EXCEPTION
11850: WHEN OTHERS THEN
11851: fnd_file.new_line(FND_FILE.LOG, 1);
11852: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_UPDATE_FAILED');
11853: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11854: FND_MESSAGE.SET_TOKEN('DETAILS', sqlcode||' - '||sqlerrm);
11855:
11856: fnd_file.put_line(FND_FILE.LOG, sqlcode||' - '||sqlerrm);

Line 11853: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');

11849: EXCEPTION
11850: WHEN OTHERS THEN
11851: fnd_file.new_line(FND_FILE.LOG, 1);
11852: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_UPDATE_FAILED');
11853: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11854: FND_MESSAGE.SET_TOKEN('DETAILS', sqlcode||' - '||sqlerrm);
11855:
11856: fnd_file.put_line(FND_FILE.LOG, sqlcode||' - '||sqlerrm);
11857: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

Line 11854: FND_MESSAGE.SET_TOKEN('DETAILS', sqlcode||' - '||sqlerrm);

11850: WHEN OTHERS THEN
11851: fnd_file.new_line(FND_FILE.LOG, 1);
11852: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_UPDATE_FAILED');
11853: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11854: FND_MESSAGE.SET_TOKEN('DETAILS', sqlcode||' - '||sqlerrm);
11855:
11856: fnd_file.put_line(FND_FILE.LOG, sqlcode||' - '||sqlerrm);
11857: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
11858:

Line 11857: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11853: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
11854: FND_MESSAGE.SET_TOKEN('DETAILS', sqlcode||' - '||sqlerrm);
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: (

Line 11925: FND_MESSAGE.SET_NAME('IEU', 'IEU_ERROR_THRESHOLD');

11921: --** checking for error threshold **--
11922:
11923: l_error_count := l_error_count + 1;
11924: IF l_error_count > 1000 THEN
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;

Line 11926: FND_MESSAGE.SET_TOKEN('ERROR_COUNT', '1000');

11922:
11923: l_error_count := l_error_count + 1;
11924: IF l_error_count > 1000 THEN
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

Line 11927: FND_MESSAGE.SET_TOKEN('WS_CODE', 'TASK');

11923: l_error_count := l_error_count + 1;
11924: IF l_error_count > 1000 THEN
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: (

Line 11928: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11924: IF l_error_count > 1000 THEN
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,

Line 11940: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');

11936: RAISE fnd_api.g_exc_error;
11937: END IF;
11938:
11939: fnd_file.new_line(FND_FILE.LOG, 1);
11940: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
11941: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
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));

Line 11941: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');

11937: END IF;
11938:
11939: fnd_file.new_line(FND_FILE.LOG, 1);
11940: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
11941: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
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);

Line 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));

11938:
11939: fnd_file.new_line(FND_FILE.LOG, 1);
11940: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
11941: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
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;

Line 11945: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

11941: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_ASSCT_TASK_WR_ITEMS');
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,

Line 12104: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');

12100: errors := SQL%BULK_EXCEPTIONS.COUNT;
12101: FOR i IN 1..errors
12102: LOOP
12103: fnd_file.new_line(FND_FILE.LOG, 1);
12104: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
12105: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_DEF_TASKS_RULES_FUNC');
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));

Line 12105: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_DEF_TASKS_RULES_FUNC');

12101: FOR i IN 1..errors
12102: LOOP
12103: fnd_file.new_line(FND_FILE.LOG, 1);
12104: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
12105: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_DEF_TASKS_RULES_FUNC');
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);

Line 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));

12102: LOOP
12103: fnd_file.new_line(FND_FILE.LOG, 1);
12104: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
12105: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_DEF_TASKS_RULES_FUNC');
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;

Line 12109: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12105: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_DEF_TASKS_RULES_FUNC');
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,

Line 12410: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_RQD_VALUE_NULL');

12406: THEN
12407: l_token_str := l_token_str || ' PROCESSING_SET_ID ';
12408:
12409: fnd_file.new_line(FND_FILE.LOG, 1);
12410: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_RQD_VALUE_NULL');
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:

Line 12411: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');

12407: l_token_str := l_token_str || ' PROCESSING_SET_ID ';
12408:
12409: fnd_file.new_line(FND_FILE.LOG, 1);
12410: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_RQD_VALUE_NULL');
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;

Line 12412: FND_MESSAGE.SET_TOKEN('IEU_UWQ_REQ_PARAM',l_token_str);

12408:
12409: fnd_file.new_line(FND_FILE.LOG, 1);
12410: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_RQD_VALUE_NULL');
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

Line 12413: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12409: fnd_file.new_line(FND_FILE.LOG, 1);
12410: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_RQD_VALUE_NULL');
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: (

Line 12443: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

12439: -- Work Source does not exist for this Object Code
12440: l_token_str := 'WS_CODE: '||p_ws_code;
12441:
12442: fnd_file.new_line(FND_FILE.LOG, 1);
12443: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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:

Line 12444: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');

12440: l_token_str := 'WS_CODE: '||p_ws_code;
12441:
12442: fnd_file.new_line(FND_FILE.LOG, 1);
12443: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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;

Line 12445: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

12441:
12442: fnd_file.new_line(FND_FILE.LOG, 1);
12443: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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

Line 12446: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12442: fnd_file.new_line(FND_FILE.LOG, 1);
12443: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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: (

Line 12497: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_WS');

12493:
12494: -- Work Source does not exist for this Object Code
12495:
12496: fnd_file.new_line(FND_FILE.LOG, 1);
12497: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_WS');
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:

Line 12498: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');

12494: -- Work Source does not exist for this Object Code
12495:
12496: fnd_file.new_line(FND_FILE.LOG, 1);
12497: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_WS');
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;

Line 12499: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);

12495:
12496: fnd_file.new_line(FND_FILE.LOG, 1);
12497: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_WS');
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

Line 12500: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12496: fnd_file.new_line(FND_FILE.LOG, 1);
12497: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_WS');
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: (

Line 12528: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

12524:
12525: -- Work Source does not exist for this Object Code
12526: l_token_str := 'WS_CODE: '||p_ws_code;
12527: fnd_file.new_line(FND_FILE.LOG, 1);
12528: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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:

Line 12529: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');

12525: -- Work Source does not exist for this Object Code
12526: l_token_str := 'WS_CODE: '||p_ws_code;
12527: fnd_file.new_line(FND_FILE.LOG, 1);
12528: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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;

Line 12530: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

12526: l_token_str := 'WS_CODE: '||p_ws_code;
12527: fnd_file.new_line(FND_FILE.LOG, 1);
12528: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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

Line 12531: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12527: fnd_file.new_line(FND_FILE.LOG, 1);
12528: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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: (

Line 12558: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

12554:
12555: -- Work Source does not exist for this Object Code
12556: l_token_str := 'WS_CODE: '||p_ws_code;
12557: fnd_file.new_line(FND_FILE.LOG, 1);
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;

Line 12559: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');

12555: -- Work Source does not exist for this Object Code
12556: l_token_str := 'WS_CODE: '||p_ws_code;
12557: fnd_file.new_line(FND_FILE.LOG, 1);
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

Line 12560: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

12556: l_token_str := 'WS_CODE: '||p_ws_code;
12557: fnd_file.new_line(FND_FILE.LOG, 1);
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: (

Line 12561: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12557: fnd_file.new_line(FND_FILE.LOG, 1);
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,

Line 12587: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

12583:
12584: -- Work Source does not exist for this Object Code
12585: l_token_str := 'WS_CODE: '||p_ws_code;
12586: fnd_file.new_line(FND_FILE.LOG, 1);
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;

Line 12588: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');

12584: -- Work Source does not exist for this Object Code
12585: l_token_str := 'WS_CODE: '||p_ws_code;
12586: fnd_file.new_line(FND_FILE.LOG, 1);
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

Line 12589: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

12585: l_token_str := 'WS_CODE: '||p_ws_code;
12586: fnd_file.new_line(FND_FILE.LOG, 1);
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: (

Line 12590: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12586: fnd_file.new_line(FND_FILE.LOG, 1);
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,

Line 12637: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_WS');

12633:
12634: -- Work Source does not exist for this Object Code
12635:
12636: fnd_file.new_line(FND_FILE.LOG, 1);
12637: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_WS');
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:

Line 12638: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');

12634: -- Work Source does not exist for this Object Code
12635:
12636: fnd_file.new_line(FND_FILE.LOG, 1);
12637: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_WS');
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;

Line 12639: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);

12635:
12636: fnd_file.new_line(FND_FILE.LOG, 1);
12637: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_WS');
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

Line 12640: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12636: fnd_file.new_line(FND_FILE.LOG, 1);
12637: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_WS');
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: (

Line 12687: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_STATUS');

12683: l_token_str := l_token_str||WORKITEM_OBJ_CODE_LIST(i)||'-'||TO_CHAR(WORKITEM_PK_ID_LIST(i))||' ';
12684: END LOOP;
12685:
12686: fnd_file.new_line(FND_FILE.LOG, 1);
12687: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_STATUS');
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:

Line 12688: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.SYNC_WR_ITEM_STATUS');

12684: END LOOP;
12685:
12686: fnd_file.new_line(FND_FILE.LOG, 1);
12687: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_STATUS');
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;

Line 12689: FND_MESSAGE.SET_TOKEN('WORKITEM_OBJ_CODE_AND_PK_ID',l_token_str);

12685:
12686: fnd_file.new_line(FND_FILE.LOG, 1);
12687: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_STATUS');
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

Line 12690: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12686: fnd_file.new_line(FND_FILE.LOG, 1);
12687: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_INVALID_STATUS');
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: (

Line 12738: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_UPDATE_FAILED');

12734: errors := SQL%BULK_EXCEPTIONS.COUNT;
12735:
12736: FOR i IN 1..errors LOOP
12737: fnd_file.new_line(FND_FILE.LOG, 1);
12738: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_UPDATE_FAILED');
12739: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
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));

Line 12739: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEM_STATUS');

12735:
12736: FOR i IN 1..errors LOOP
12737: fnd_file.new_line(FND_FILE.LOG, 1);
12738: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_UPDATE_FAILED');
12739: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
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);

Line 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));

12736: FOR i IN 1..errors LOOP
12737: fnd_file.new_line(FND_FILE.LOG, 1);
12738: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_SYNC_WR_UPDATE_FAILED');
12739: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
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;

Line 12743: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12739: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.SYNC_WR_ITEM_STATUS');
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,

Line 12896: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');

12892: -- Work Source does not exist for this Object Code
12893: l_token_str := 'WS_CODE: '||p_ws_code;
12894:
12895: fnd_file.new_line(FND_FILE.LOG, 1);
12896: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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:

Line 12897: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME','IEU_WR_PUB.UPDATE_WR_ITEM_STATUS');

12893: l_token_str := 'WS_CODE: '||p_ws_code;
12894:
12895: fnd_file.new_line(FND_FILE.LOG, 1);
12896: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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;

Line 12898: FND_MESSAGE.SET_TOKEN('COLUMN_VALUE',l_token_str);

12894:
12895: fnd_file.new_line(FND_FILE.LOG, 1);
12896: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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

Line 12899: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12895: fnd_file.new_line(FND_FILE.LOG, 1);
12896: FND_MESSAGE.SET_NAME('IEU', 'IEU_UWQ_WS_DETAILS_NULL');
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: (

Line 12943: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');

12939: errors := SQL%BULK_EXCEPTIONS.COUNT;
12940: FOR i IN 1..errors LOOP
12941:
12942: fnd_file.new_line(FND_FILE.LOG, 1);
12943: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
12944: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.UPDATE_WR_ITEM_STATUS');
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));

Line 12944: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.UPDATE_WR_ITEM_STATUS');

12940: FOR i IN 1..errors LOOP
12941:
12942: fnd_file.new_line(FND_FILE.LOG, 1);
12943: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
12944: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.UPDATE_WR_ITEM_STATUS');
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);

Line 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));

12941:
12942: fnd_file.new_line(FND_FILE.LOG, 1);
12943: FND_MESSAGE.SET_NAME('IEU', 'IEU_UPDATE_UWQM_ITEM_FAILED');
12944: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.UPDATE_WR_ITEM_STATUS');
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;

Line 12948: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

12944: FND_MESSAGE.SET_TOKEN('PACKAGE_NAME', 'IEU_WR_PUB.UPDATE_WR_ITEM_STATUS');
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,