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 IEU_WR_PUB

Line 1: PACKAGE BODY IEU_WR_PUB AS

1: PACKAGE BODY IEU_WR_PUB AS
2: /* $Header: IEUPUWRB.pls 120.31 2006/08/18 05:10:53 msathyan noship $ */
3:
4: -- *******
5: --

Line 92: l_wr_item_list IEU_WR_PUB.IEU_WR_ITEM_LIST;

88: l_parent_status_id NUMBER;
89: l_ws_id NUMBER;
90: l_ctr NUMBER;
91: l_msg_count NUMBER;
92: l_wr_item_list IEU_WR_PUB.IEU_WR_ITEM_LIST;
93:
94: cursor c1(p_source_object_id IN NUMBER, p_source_object_type_code IN VARCHAR2) is
95: select work_item_id, workitem_pk_id, workitem_obj_code
96: from ieu_uwqm_items

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 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 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 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 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 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 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 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 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 785: IEU_WR_PUB.SYNC_DEPENDENT_WR_ITEMS

781:
782: if ( l_wr_item_list.count > 0)
783: then
784:
785: IEU_WR_PUB.SYNC_DEPENDENT_WR_ITEMS
786: ( p_api_version => 1,
787: p_init_msg_list => 'T',
788: p_commit => 'F',
789: p_wr_item_list => l_wr_item_list,

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 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 955: l_wr_item_list IEU_WR_PUB.IEU_WR_ITEM_LIST;

951: l_parent_status_id NUMBER;
952: l_ws_id NUMBER;
953: l_ctr NUMBER;
954: l_msg_count NUMBER;
955: l_wr_item_list IEU_WR_PUB.IEU_WR_ITEM_LIST;
956:
957: cursor c1(p_source_object_id IN NUMBER, p_source_object_type_code IN VARCHAR2) is
958: select work_item_id, workitem_pk_id, workitem_obj_code
959: from ieu_uwqm_items

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 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 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 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 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 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 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 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 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 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 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 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 1796: IEU_WR_PUB.SYNC_DEPENDENT_WR_ITEMS

1792: end loop;
1793:
1794: if ( l_wr_item_list.count > 0)
1795: then
1796: IEU_WR_PUB.SYNC_DEPENDENT_WR_ITEMS
1797: ( p_api_version => 1,
1798: p_init_msg_list => 'T',
1799: p_commit => 'F',
1800: p_wr_item_list => l_wr_item_list,

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 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 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 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 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 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 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 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 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 2797: p_wr_item_list IN IEU_WR_PUB.IEU_WR_ITEM_LIST ,

2793: PROCEDURE SYNC_DEPENDENT_WR_ITEMS
2794: ( p_api_version IN NUMBER,
2795: p_init_msg_list IN VARCHAR2 DEFAULT NULL,
2796: p_commit IN VARCHAR2 DEFAULT NULL,
2797: p_wr_item_list IN IEU_WR_PUB.IEU_WR_ITEM_LIST ,
2798: x_msg_count OUT NOCOPY NUMBER,
2799: x_msg_data OUT NOCOPY VARCHAR2,
2800: x_return_status OUT NOCOPY VARCHAR2) AS
2801:

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 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 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 3220: l_wr_item_list IEU_WR_PUB.IEU_WR_ITEM_LIST;

3216: l_parent_status_id NUMBER;
3217: l_ws_id NUMBER;
3218: l_ctr NUMBER;
3219: l_msg_count NUMBER;
3220: l_wr_item_list IEU_WR_PUB.IEU_WR_ITEM_LIST;
3221:
3222: cursor c1(p_source_object_id IN NUMBER, p_source_object_type_code IN VARCHAR2) is
3223: select work_item_id, workitem_pk_id, workitem_obj_code
3224: from ieu_uwqm_items

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 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 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 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 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 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 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 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 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 4133: 'IEU_WR_PUB.CREATE_WR_ITEM',

4129: l_audit_trail_rec(l_audit_trail_rec.LAST) := SYSTEM.WR_AUDIT_TRAIL_OBJ
4130: (l_action_key,
4131: l_event_key,
4132: p_application_id,
4133: 'IEU_WR_PUB.CREATE_WR_ITEM',
4134: null,
4135: null,
4136: null,
4137: null,

Line 4140: IEU_WR_PUB.SYNC_DEPENDENT_WR_ITEMS

4136: null,
4137: null,
4138: null);
4139:
4140: IEU_WR_PUB.SYNC_DEPENDENT_WR_ITEMS
4141: ( p_api_version => 1,
4142: p_init_msg_list => 'T',
4143: p_commit => 'F',
4144: p_wr_item_list => l_wr_item_list,

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 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 4516: l_wr_item_list IEU_WR_PUB.IEU_WR_ITEM_LIST;

4512: l_parent_status_id NUMBER;
4513: l_ws_id NUMBER;
4514: l_ctr NUMBER;
4515: l_msg_count NUMBER;
4516: l_wr_item_list IEU_WR_PUB.IEU_WR_ITEM_LIST;
4517:
4518: cursor c1(p_source_object_id IN NUMBER, p_source_object_type_code IN VARCHAR2) is
4519: select work_item_id, workitem_pk_id, workitem_obj_code
4520: from ieu_uwqm_items

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 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 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 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 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 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 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 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 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 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 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 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 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 5707: 'IEU_WR_PUB.UPDATE_WR_ITEM',

5703: l_audit_trail_rec(l_audit_trail_rec.LAST) := SYSTEM.WR_AUDIT_TRAIL_OBJ
5704: (l_action_key,
5705: l_event_key,
5706: p_application_id,
5707: 'IEU_WR_PUB.UPDATE_WR_ITEM',
5708: null,
5709: null,
5710: null,
5711: null,

Line 5719: IEU_WR_PUB.SYNC_DEPENDENT_WR_ITEMS

5715: --dbms_output.put_line('err: '||SQLERRM||' '||SQLCODE);
5716: null;
5717: END;
5718:
5719: IEU_WR_PUB.SYNC_DEPENDENT_WR_ITEMS
5720: ( p_api_version => 1,
5721: p_init_msg_list => 'T',
5722: p_commit => 'F',
5723: p_wr_item_list => l_wr_item_list,

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 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 6357: -- l_module := 'IEU_WR_PUB.RESCEDULE_WR_ITEM';

6353: l_event_key := 'RESCHEDULE_WR_ITEM';
6354: else
6355: l_event_key := null;
6356: end if;
6357: -- l_module := 'IEU_WR_PUB.RESCEDULE_WR_ITEM';
6358: l_module := 'IEU_WR_PUB.SNOOZE_UWQM_ITEM';
6359:
6360: if ( (l_audit_log_val = 'FULL') OR (l_audit_log_val = 'DETAILED') OR (l_audit_log_val = 'MINIMAL') )
6361: then

Line 6358: l_module := 'IEU_WR_PUB.SNOOZE_UWQM_ITEM';

6354: else
6355: l_event_key := null;
6356: end if;
6357: -- l_module := 'IEU_WR_PUB.RESCEDULE_WR_ITEM';
6358: l_module := 'IEU_WR_PUB.SNOOZE_UWQM_ITEM';
6359:
6360: if ( (l_audit_log_val = 'FULL') OR (l_audit_log_val = 'DETAILED') OR (l_audit_log_val = 'MINIMAL') )
6361: then
6362:

Line 6472: -- l_module := 'IEU_WR_PUB.RESCEDULE_WR_ITEM';

6468: l_event_key := 'RESCHEDULE_WR_ITEM';
6469: else
6470: l_event_key := null;
6471: end if;
6472: -- l_module := 'IEU_WR_PUB.RESCEDULE_WR_ITEM';
6473: l_module := 'IEU_WR_PUB.SNOOZE_UWQM_ITEM';
6474:
6475: IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
6476: (

Line 6473: l_module := 'IEU_WR_PUB.SNOOZE_UWQM_ITEM';

6469: else
6470: l_event_key := null;
6471: end if;
6472: -- l_module := 'IEU_WR_PUB.RESCEDULE_WR_ITEM';
6473: l_module := 'IEU_WR_PUB.SNOOZE_UWQM_ITEM';
6474:
6475: IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
6476: (
6477: P_ACTION_KEY => l_action_key,

Line 6551: -- l_module := 'IEU_WR_PUB.RESCEDULE_WR_ITEM';

6547: l_event_key := 'RESCHEDULE_WR_ITEM';
6548: else
6549: l_event_key := null;
6550: end if;
6551: -- l_module := 'IEU_WR_PUB.RESCEDULE_WR_ITEM';
6552: l_module := 'IEU_WR_PUB.SNOOZE_UWQM_ITEM';
6553:
6554: IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
6555: (

Line 6552: l_module := 'IEU_WR_PUB.SNOOZE_UWQM_ITEM';

6548: else
6549: l_event_key := null;
6550: end if;
6551: -- l_module := 'IEU_WR_PUB.RESCEDULE_WR_ITEM';
6552: l_module := 'IEU_WR_PUB.SNOOZE_UWQM_ITEM';
6553:
6554: IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
6555: (
6556: P_ACTION_KEY => l_action_key,

Line 6630: -- l_module := 'IEU_WR_PUB.RESCEDULE_WR_ITEM';

6626: l_event_key := 'RESCHEDULE_WR_ITEM';
6627: else
6628: l_event_key := null;
6629: end if;
6630: -- l_module := 'IEU_WR_PUB.RESCEDULE_WR_ITEM';
6631: l_module := 'IEU_WR_PUB.SNOOZE_UWQM_ITEM';
6632:
6633: IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
6634: (

Line 6631: l_module := 'IEU_WR_PUB.SNOOZE_UWQM_ITEM';

6627: else
6628: l_event_key := null;
6629: end if;
6630: -- l_module := 'IEU_WR_PUB.RESCEDULE_WR_ITEM';
6631: l_module := 'IEU_WR_PUB.SNOOZE_UWQM_ITEM';
6632:
6633: IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
6634: (
6635: P_ACTION_KEY => l_action_key,

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 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 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 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 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 7147: l_module := 'IEU_WR_PUB.SYNC_WS_DETAILS';

7143: then
7144:
7145: l_action_key := 'SYNC_ASSCT_WS';
7146: l_event_key := null;
7147: l_module := 'IEU_WR_PUB.SYNC_WS_DETAILS';
7148:
7149: -- Get the values of App Distribute From and To for Audit Logging
7150: if (l_audit_log_val = 'DETAILED')
7151: then

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 7601: l_module := 'IEU_WR_PUB.SYNC_WS_DETAILS';

7597: then
7598:
7599: l_action_key := 'SYNC_ASSCT_WS';
7600: l_event_key := null;
7601: l_module := 'IEU_WR_PUB.SYNC_WS_DETAILS';
7602:
7603: IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
7604: (
7605: P_ACTION_KEY => l_action_key,

Line 7672: l_module := 'IEU_WR_PUB.SYNC_WS_DETAILS';

7668: then
7669:
7670: l_action_key := 'SYNC_ASSCT_WS';
7671: l_event_key := null;
7672: l_module := 'IEU_WR_PUB.SYNC_WS_DETAILS';
7673:
7674: IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
7675: (
7676: P_ACTION_KEY => l_action_key,

Line 7744: l_module := 'IEU_WR_PUB.SYNC_WS_DETAILS';

7740: then
7741:
7742: l_action_key := 'SYNC_ASSCT_WS';
7743: l_event_key := null;
7744: l_module := 'IEU_WR_PUB.SYNC_WS_DETAILS';
7745:
7746: IEU_UWQM_AUDIT_LOG_PKG.INSERT_ROW
7747: (
7748: P_ACTION_KEY => l_action_key,

Line 8086: l_module := 'IEU_WR_PUB.GET_NEXT_WORK_FOR_APPS';

8082: then
8083:
8084: l_action_key := 'DELIVERY';
8085: l_event_key := null;
8086: l_module := 'IEU_WR_PUB.GET_NEXT_WORK_FOR_APPS';
8087:
8088: if x_msg_count > 0
8089: then
8090: FOR l_index IN 1..x_msg_count LOOP

Line 8166: l_module := 'IEU_WR_PUB.GET_NEXT_WORK_FOR_APPS';

8162: then
8163:
8164: l_action_key := 'DELIVERY';
8165: l_event_key := null;
8166: l_module := 'IEU_WR_PUB.GET_NEXT_WORK_FOR_APPS';
8167:
8168: FOR l_index IN 1..x_msg_count LOOP
8169: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_msg_index => l_index,p_encoded => 'F');
8170: END LOOP;

Line 8240: l_module := 'IEU_WR_PUB.GET_NEXT_WORK_FOR_APPS';

8236: then
8237:
8238: l_action_key := 'DELIVERY';
8239: l_event_key := null;
8240: l_module := 'IEU_WR_PUB.GET_NEXT_WORK_FOR_APPS';
8241:
8242: FOR l_index IN 1..x_msg_count LOOP
8243: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_msg_index => l_index,p_encoded => 'F');
8244: END LOOP;

Line 8316: l_module := 'IEU_WR_PUB.GET_NEXT_WORK_FOR_APPS';

8312: then
8313:
8314: l_action_key := 'DELIVERY';
8315: l_event_key := null;
8316: l_module := 'IEU_WR_PUB.GET_NEXT_WORK_FOR_APPS';
8317:
8318: FOR l_index IN 1..x_msg_count LOOP
8319: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_msg_index => l_index,p_encoded => 'F');
8320: END LOOP;

Line 8393: p_wr_item_list IN IEU_WR_PUB.IEU_WR_ITEM_LIST ,

8389: PROCEDURE SYNC_DEPENDENT_WR_ITEMS
8390: ( p_api_version IN NUMBER,
8391: p_init_msg_list IN VARCHAR2 DEFAULT NULL,
8392: p_commit IN VARCHAR2 DEFAULT NULL,
8393: p_wr_item_list IN IEU_WR_PUB.IEU_WR_ITEM_LIST ,
8394: p_audit_trail_rec IN SYSTEM.WR_AUDIT_TRAIL_NST,
8395: x_msg_count OUT NOCOPY NUMBER,
8396: x_msg_data OUT NOCOPY VARCHAR2,
8397: x_return_status OUT NOCOPY VARCHAR2) AS

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 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 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 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 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 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 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 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 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 9614: fnd_file.put_line(FND_FILE.LOG, 'Completed work in ' || 'IEU_WR_PUB.PURGE_WR_ITEM' || ' with return status ' || x_return_status);

9610: fnd_file.put_line(FND_FILE.LOG, 'After deleting data from table IEU_UWQM_ITEMS ' || l_row_count || ' rows');
9611:
9612: x_return_status := fnd_api.g_ret_sts_success;
9613:
9614: fnd_file.put_line(FND_FILE.LOG, 'Completed work in ' || 'IEU_WR_PUB.PURGE_WR_ITEM' || ' with return status ' || x_return_status);
9615: fnd_file.put_line(FND_FILE.LOG, '--------------------------------------------------------------------------------');
9616:
9617: IF (x_return_status <> fnd_api.g_ret_sts_success)
9618: THEN

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 9647: fnd_file.put_line(FND_FILE.LOG, 'Inside WHEN FND_API.G_EXC_ERROR of ' || 'IEU_WR_PUB.PURGE_WR_ITEM');

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

Line 9658: fnd_file.put_line(FND_FILE.LOG, 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || 'IEU_WR_PUB.PURGE_WR_ITEM');

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

Line 9671: fnd_file.put_line(FND_FILE.LOG, 'Inside WHEN OTHERS of ' || 'IEU_WR_PUB.PURGE_WR_ITEM' || '. Oracle Error was:');

9667:
9668: x_return_status := fnd_api.g_ret_sts_unexp_error;
9669: l_sqlerrm := SQLERRM;
9670:
9671: fnd_file.put_line(FND_FILE.LOG, 'Inside WHEN OTHERS of ' || 'IEU_WR_PUB.PURGE_WR_ITEM' || '. Oracle Error was:');
9672: fnd_file.put_line(FND_FILE.LOG, l_sqlerrm);
9673:
9674: IF FND_MSG_PUB.Check_msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9675: THEN

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 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 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 10276: IEU_WR_PUB.RESCHEDULE_UWQM_ITEM

10272: x_msg_count OUT NOCOPY NUMBER,
10273: x_msg_data OUT NOCOPY VARCHAR2,
10274: x_return_status OUT NOCOPY VARCHAR2) AS
10275: BEGIN
10276: IEU_WR_PUB.RESCHEDULE_UWQM_ITEM
10277: ( p_api_version,
10278: p_init_msg_list,
10279: p_commit,
10280: p_workitem_obj_code,

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 11877: IEU_WR_PUB.IEU_DEF_TASKS_RULES_FUNC (

11873: execute immediate
11874: 'BEGIN '||l_tasks_rules_func ||' ( :1, :2, :3, :4); END ; '
11875: USING IN l_processing_set_id, OUT l_msg_count, OUT l_msg_data, OUT l_return_status;
11876: else
11877: IEU_WR_PUB.IEU_DEF_TASKS_RULES_FUNC (
11878: p_processing_set_id => L_PROCESSING_SET_ID,
11879: x_msg_count => l_msg_count,
11880: x_msg_data => l_msg_data,
11881: x_return_status => l_return_status);

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 12132: IEU_WR_PUB.SYNC_WR_ITEMS (

12128: l_msg_count := null;
12129: l_msg_data := null;
12130: l_return_status := null;
12131:
12132: IEU_WR_PUB.SYNC_WR_ITEMS (
12133: p_api_version => 1.0,
12134: p_init_msg_list => FND_API.G_TRUE,
12135: p_commit => FND_API.G_FALSE,
12136: p_processing_set_id => P_PROCESSING_SET_ID,

Line 12245: IEU_WR_PUB.GET_NEXT_WORK_FOR_APPS

12241: j :=0;
12242:
12243: BEGIN
12244: -- Invoke the IEU API to get the incident Id
12245: IEU_WR_PUB.GET_NEXT_WORK_FOR_APPS
12246: ( p_api_version => 1,
12247: p_resource_id => p_resource_id,
12248: p_language => l_language,
12249: p_source_lang => l_source_lang,

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 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 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 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 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 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 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 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 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 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 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 13016: END IEU_WR_PUB;

13012: END IF;
13013:
13014: END UPDATE_WR_ITEM_STATUS;
13015:
13016: END IEU_WR_PUB;