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

Line 211: FND_MESSAGE.SET_NAME ('WIP','WIP_EAM_WR_DEPT_MANDATORY');

207: l_asset_num_reqd := 'Y';
208: END;
209:
210: IF (l_work_request_auto_approve = 'N' AND l_owning_dept_id IS NULL) THEN
211: FND_MESSAGE.SET_NAME ('WIP','WIP_EAM_WR_DEPT_MANDATORY');
212: FND_MSG_PUB.ADD;
213: RAISE FND_API.G_EXC_ERROR;
214: END IF;
215:

Line 218: FND_MESSAGE.SET_NAME ('EAM','EAM_ENTER_ASSET_NUMBER_FIELD');

214: END IF;
215:
216: -- Bug # 3574258
217: IF (l_asset_num_reqd = 'Y' AND l_maintenance_object_id IS NULL) THEN
218: FND_MESSAGE.SET_NAME ('EAM','EAM_ENTER_ASSET_NUMBER_FIELD');
219: FND_MSG_PUB.ADD;
220: RAISE FND_API.G_EXC_ERROR;
221: END IF;
222:

Line 867: FND_MESSAGE.SET_NAME ('EAM','EAM_ENTER_ASSET_NUMBER_FIELD');

863: l_asset_num_reqd := 'Y';
864: END;
865:
866: IF (l_asset_num_reqd = 'Y' AND l_new_asset_number IS NULL) THEN
867: FND_MESSAGE.SET_NAME ('EAM','EAM_ENTER_ASSET_NUMBER_FIELD');
868: FND_MSG_PUB.ADD;
869: RAISE FND_API.G_EXC_ERROR;
870: END IF;
871:

Line 1006: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_DISPLAY_NULL');

1002:
1003: IF (l_extended_log_flag = 'Y') THEN
1004: l_stmt_num := 140;
1005:
1006: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_DISPLAY_NULL');
1007: l_null := FND_MESSAGE.GET;
1008:
1009: IF ( isdifferent(l_old_asset_number, l_new_asset_number) = 1 OR
1010: isdifferent_number(l_old_asset_group_id, l_new_asset_group_id) = 1) THEN

Line 1007: l_null := FND_MESSAGE.GET;

1003: IF (l_extended_log_flag = 'Y') THEN
1004: l_stmt_num := 140;
1005:
1006: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_DISPLAY_NULL');
1007: l_null := FND_MESSAGE.GET;
1008:
1009: IF ( isdifferent(l_old_asset_number, l_new_asset_number) = 1 OR
1010: isdifferent_number(l_old_asset_group_id, l_new_asset_group_id) = 1) THEN
1011: l_stmt_num := 230;

Line 1043: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_ASSET_GROUP_PROMPT');

1039: END;
1040: ELSE
1041: l_new_data := l_null;
1042: END IF;
1043: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_ASSET_GROUP_PROMPT');
1044:
1045: INSERT INTO wip_eam_work_req_notes(
1046: work_request_note_id,
1047: last_update_date,

Line 1065: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,

1061: sysdate,
1062: NVL(p_user_id,FND_GLOBAL.user_id),
1063: NVL(p_user_id,FND_GLOBAL.login_id),
1064: p_request_id,
1065: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1066: 1, -- 1 for request log, 2 for approver log
1067: null
1068: );
1069: END IF;

Line 1073: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_ASSET_NUMBER_PROMPT');

1069: END IF;
1070: SELECT wip_eam_work_req_notes_s.nextval
1071: INTO l_work_request_note_id
1072: FROM dual;
1073: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_ASSET_NUMBER_PROMPT');
1074:
1075: INSERT INTO wip_eam_work_req_notes(
1076: work_request_note_id,
1077: last_update_date,

Line 1095: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_asset_number,l_null)||' -> '||nvl(l_new_asset_number,l_null),

1091: sysdate,
1092: NVL(p_user_id,FND_GLOBAL.user_id),
1093: NVL(p_user_id,FND_GLOBAL.login_id),
1094: p_request_id,
1095: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_asset_number,l_null)||' -> '||nvl(l_new_asset_number,l_null),
1096: 1, -- 1 for request log, 2 for approver log
1097: null
1098: );
1099: END IF;

Line 1128: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_PRIORITY_PROMPT');

1124: EXCEPTION
1125: WHEN NO_DATA_FOUND THEN
1126: l_new_data := l_null;
1127: END;
1128: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_PRIORITY_PROMPT');
1129: l_stmt_num := 180;
1130:
1131: INSERT INTO wip_eam_work_req_notes(
1132: work_request_note_id,

Line 1151: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,

1147: sysdate,
1148: NVL(p_user_id,FND_GLOBAL.user_id),
1149: NVL(p_user_id,FND_GLOBAL.login_id),
1150: p_request_id,
1151: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1152: 1, -- 1 for request log, 2 for approver log
1153: null
1154: );
1155: END IF;

Line 1185: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_TYPE_PROMPT');

1181: EXCEPTION
1182: When NO_DATA_FOUND then
1183: l_new_data := l_null;
1184: END;
1185: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_TYPE_PROMPT');
1186: l_stmt_num := 188;
1187:
1188: INSERT INTO wip_eam_work_req_notes(
1189: work_request_note_id,

Line 1208: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,

1204: sysdate,
1205: NVL(p_user_id,FND_GLOBAL.user_id),
1206: NVL(p_user_id,FND_GLOBAL.login_id),
1207: p_request_id,
1208: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1209: 1, -- 1 for request log, 2 for approver log
1210: null
1211: );
1212: END IF;

Line 1242: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_STATUS_PROMPT');

1238: WHEN NO_DATA_FOUND THEN
1239: l_new_data := l_null;
1240: END;
1241:
1242: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_STATUS_PROMPT');
1243: l_stmt_num := 220;
1244: INSERT INTO wip_eam_work_req_notes(
1245: work_request_note_id,
1246: last_update_date,

Line 1264: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,

1260: sysdate,
1261: NVL(p_user_id,FND_GLOBAL.user_id),
1262: NVL(p_user_id,FND_GLOBAL.login_id),
1263: p_request_id,
1264: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1265: 1, -- 1 for request log, 2 for approver log
1266: null
1267: );
1268: END IF;

Line 1297: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_DEPT_PROMPT');

1293: EXCEPTION
1294: WHEN NO_DATA_FOUND THEN
1295: l_new_data := l_null;
1296: END;
1297: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_DEPT_PROMPT');
1298: l_stmt_num := 260;
1299:
1300: INSERT INTO wip_eam_work_req_notes(
1301: work_request_note_id,

Line 1320: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,

1316: sysdate,
1317: NVL(p_user_id,FND_GLOBAL.user_id),
1318: NVL(p_user_id,FND_GLOBAL.login_id),
1319: p_request_id,
1320: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1321: 1, -- 1 for request log, 2 for approver log
1322: null
1323: );
1324: END IF;

Line 1327: FND_MESSAGE.SET_NAME ('WIP','WIP_EAM_REQ_BY_DATE_PROMPT');

1323: );
1324: END IF;
1325:
1326: IF (l_old_request_by_date <> l_new_request_by_date) THEN
1327: FND_MESSAGE.SET_NAME ('WIP','WIP_EAM_REQ_BY_DATE_PROMPT');
1328: l_stmt_num := 270;
1329: SELECT wip_eam_work_req_notes_s.nextval
1330: INTO l_work_request_note_id
1331: FROM DUAL;

Line 1362: '@@@ '||FND_MESSAGE.GET||l_timezone_code ||' : '||to_char(l_old_request_by_date, 'dd-MON-yyyy hh24:mi:ss')||' -> '

1358: sysdate,
1359: NVL(p_user_id,FND_GLOBAL.user_id),
1360: NVL(p_user_id,FND_GLOBAL.login_id),
1361: p_request_id,
1362: '@@@ '||FND_MESSAGE.GET||l_timezone_code ||' : '||to_char(l_old_request_by_date, 'dd-MON-yyyy hh24:mi:ss')||' -> '
1363: ||to_char(l_new_request_by_date, 'dd-MON-yyyy hh24:mi:ss') ,
1364: 1, -- 1 for request log, 2 for approver log
1365: null
1366: );

Line 1367: --l_another_log := l_another_log ||chr(10) ||'@@@ '||FND_MESSAGE.GET||' : '||l_old_request_by_date||' -> ' ||p_request_by_date;

1363: ||to_char(l_new_request_by_date, 'dd-MON-yyyy hh24:mi:ss') ,
1364: 1, -- 1 for request log, 2 for approver log
1365: null
1366: );
1367: --l_another_log := l_another_log ||chr(10) ||'@@@ '||FND_MESSAGE.GET||' : '||l_old_request_by_date||' -> ' ||p_request_by_date;
1368: END IF;
1369:
1370: IF (isdifferent_number(l_old_created_for, l_new_created_for) = 1) THEN
1371: l_stmt_num := 150;

Line 1394: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_CREATED_FOR_PROMPT');

1390: EXCEPTION
1391: When NO_DATA_FOUND then
1392: l_new_data := l_null;
1393: END;
1394: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_CREATED_FOR_PROMPT');
1395:
1396: INSERT INTO wip_eam_work_req_notes(
1397: work_request_note_id,
1398: last_update_date,

Line 1416: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,

1412: sysdate,
1413: NVL(p_user_id,FND_GLOBAL.user_id),
1414: NVL(p_user_id,FND_GLOBAL.login_id),
1415: p_request_id,
1416: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1417: 1, -- 1 for request log, 2 for approver log
1418: null
1419: );
1420: END IF;

Line 1426: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_EMAIL_PROMPT');

1422: IF (isdifferent(l_old_email, l_new_email) = 1) THEN
1423: SELECT wip_eam_work_req_notes_s.nextval
1424: INTO l_work_request_note_id
1425: FROM DUAL;
1426: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_EMAIL_PROMPT');
1427: INSERT INTO wip_eam_work_req_notes(
1428: work_request_note_id,
1429: last_update_date,
1430: last_updated_by,

Line 1447: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_email,l_null)||' -> '||nvl(l_new_email,l_null),

1443: sysdate,
1444: NVL(p_user_id,FND_GLOBAL.user_id),
1445: NVL(p_user_id,FND_GLOBAL.login_id),
1446: p_request_id,
1447: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_email,l_null)||' -> '||nvl(l_new_email,l_null),
1448: 1, -- 1 for request log, 2 for approver log
1449: null
1450: );
1451: END IF;

Line 1457: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_PHONE_NUMBER_PROMPT');

1453: IF (isdifferent(l_old_phone_number, l_new_phone_number) = 1) THEN
1454: SELECT wip_eam_work_req_notes_s.nextval
1455: INTO l_work_request_note_id
1456: FROM DUAL;
1457: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_PHONE_NUMBER_PROMPT');
1458: INSERT INTO wip_eam_work_req_notes(
1459: work_request_note_id,
1460: last_update_date,
1461: last_updated_by,

Line 1478: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_phone_number,l_null)||' -> '||nvl(l_new_phone_number,l_null),

1474: sysdate,
1475: NVL(p_user_id,FND_GLOBAL.user_id),
1476: NVL(p_user_id,FND_GLOBAL.login_id),
1477: p_request_id,
1478: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_phone_number,l_null)||' -> '||nvl(l_new_phone_number,l_null),
1479: 1, /* 1 for request log, 2 for approver log*/
1480: null
1481: );
1482: END IF;

Line 1508: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_NOTIFY_USER_PROMPT');

1504: EXCEPTION
1505: When NO_DATA_FOUND then
1506: l_new_data := l_null;
1507: END;
1508: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_NOTIFY_USER_PROMPT');
1509: INSERT INTO wip_eam_work_req_notes(
1510: work_request_note_id,
1511: last_update_date,
1512: last_updated_by,

Line 1529: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,

1525: sysdate,
1526: NVL(p_user_id,FND_GLOBAL.user_id),
1527: NVL(p_user_id,FND_GLOBAL.login_id),
1528: p_request_id,
1529: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1530: 1, -- 1 for request log, 2 for approver log
1531: null
1532: );
1533: END IF;

Line 1559: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_CONTACT_PREF_PROMPT');

1555: EXCEPTION
1556: When NO_DATA_FOUND then
1557: l_new_data := l_null;
1558: END;
1559: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_CONTACT_PREF_PROMPT');
1560: INSERT INTO wip_eam_work_req_notes(
1561: work_request_note_id,
1562: last_update_date,
1563: last_updated_by,

Line 1580: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,

1576: sysdate,
1577: NVL(p_user_id,FND_GLOBAL.user_id),
1578: NVL(p_user_id,FND_GLOBAL.login_id),
1579: p_request_id,
1580: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1581: 1, -- 1 for request log, 2 for approver log
1582: null
1583: );
1584: END IF;

Line 1590: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_CONTEXT_VALUE_PROMPT');

1586: IF (isdifferent(l_new_attribute_category,l_old_attribute_category) = 1) THEN
1587: SELECT wip_eam_work_req_notes_s.nextval
1588: INTO l_work_request_note_id
1589: FROM DUAL;
1590: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_CONTEXT_VALUE_PROMPT');
1591: INSERT INTO wip_eam_work_req_notes(
1592: work_request_note_id,
1593: last_update_date,
1594: last_updated_by,

Line 1611: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_attribute_category,l_null)||' -> '||nvl(l_new_attribute_category,l_null),

1607: sysdate,
1608: NVL(p_user_id,FND_GLOBAL.user_id),
1609: NVL(p_user_id,FND_GLOBAL.login_id),
1610: p_request_id,
1611: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_attribute_category,l_null)||' -> '||nvl(l_new_attribute_category,l_null),
1612: 1, -- 1 for request log, 2 for approver log
1613: null
1614: );
1615: END IF;

Line 2274: FND_MESSAGE.SET_NAME ('EAM','EAM_WR_ERROR');

2270: p_error_message => l_error_message
2271: ) ;
2272:
2273: IF (l_results_out <> FND_API.G_RET_STS_SUCCESS) THEN
2274: FND_MESSAGE.SET_NAME ('EAM','EAM_WR_ERROR');
2275: FND_MSG_PUB.ADD;
2276: RAISE FND_API.G_EXC_ERROR;
2277: -- ELSE for bug # 13355580
2278: -- commit ; for bug # 13355580

Line 2452: FND_MESSAGE.SET_NAME('EAM', p_msg);

2448: END IF;
2449: END IF;
2450: END IF;
2451: IF (result = 0) THEN
2452: FND_MESSAGE.SET_NAME('EAM', p_msg);
2453: IF p_attr is not null then
2454: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || to_char(p_new_value));
2455: END IF;
2456: FND_MSG_PUB.ADD;

Line 2454: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || to_char(p_new_value));

2450: END IF;
2451: IF (result = 0) THEN
2452: FND_MESSAGE.SET_NAME('EAM', p_msg);
2453: IF p_attr is not null then
2454: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || to_char(p_new_value));
2455: END IF;
2456: FND_MSG_PUB.ADD;
2457: x_return_flag := FALSE;
2458: RAISE FND_API.G_EXC_ERROR;

Line 2480: FND_MESSAGE.SET_NAME('EAM', p_msg);

2476: END IF;
2477: END IF;
2478: END IF;
2479: IF (result = 0) THEN
2480: FND_MESSAGE.SET_NAME('EAM', p_msg);
2481: IF p_attr is not null then
2482: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || p_new_value);
2483: END IF;
2484: FND_MSG_PUB.ADD;

Line 2482: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || p_new_value);

2478: END IF;
2479: IF (result = 0) THEN
2480: FND_MESSAGE.SET_NAME('EAM', p_msg);
2481: IF p_attr is not null then
2482: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || p_new_value);
2483: END IF;
2484: FND_MSG_PUB.ADD;
2485: x_return_flag := FALSE;
2486: RAISE FND_API.G_EXC_ERROR;

Line 2508: FND_MESSAGE.SET_NAME('EAM', p_msg);

2504: END IF;
2505: END IF;
2506: END IF;
2507: IF (result = 0) THEN
2508: FND_MESSAGE.SET_NAME('EAM', p_msg);
2509: IF p_attr is not null then
2510: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || to_char(p_new_value, 'YYYY-MON-DD'));
2511: END IF;
2512: FND_MSG_PUB.ADD;

Line 2510: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || to_char(p_new_value, 'YYYY-MON-DD'));

2506: END IF;
2507: IF (result = 0) THEN
2508: FND_MESSAGE.SET_NAME('EAM', p_msg);
2509: IF p_attr is not null then
2510: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || to_char(p_new_value, 'YYYY-MON-DD'));
2511: END IF;
2512: FND_MSG_PUB.ADD;
2513: x_return_flag := FALSE;
2514: RAISE FND_API.G_EXC_ERROR;

Line 2625: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');

2621:
2622: l_stmt_num := 30;
2623:
2624: IF p_org_id IS NULL THEN
2625: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2626: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_org_id');
2627: FND_MSG_PUB.ADD;
2628: x_return_flag := FALSE;
2629: RAISE FND_API.G_EXC_ERROR;

Line 2626: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_org_id');

2622: l_stmt_num := 30;
2623:
2624: IF p_org_id IS NULL THEN
2625: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2626: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_org_id');
2627: FND_MSG_PUB.ADD;
2628: x_return_flag := FALSE;
2629: RAISE FND_API.G_EXC_ERROR;
2630: END IF;

Line 2639: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

2635: from wip_eam_parameters
2636: where organization_id = p_org_id;
2637: exception
2638: when others then
2639: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2640: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Organization Id: ' || p_org_id);
2641: FND_MSG_PUB.ADD;
2642: x_return_flag := FALSE;
2643: RAISE FND_API.G_EXC_ERROR;

Line 2640: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Organization Id: ' || p_org_id);

2636: where organization_id = p_org_id;
2637: exception
2638: when others then
2639: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2640: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Organization Id: ' || p_org_id);
2641: FND_MSG_PUB.ADD;
2642: x_return_flag := FALSE;
2643: RAISE FND_API.G_EXC_ERROR;
2644: end;

Line 2668: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

2664: cii.inventory_item_id = msi.inventory_item_id ;
2665:
2666: EXCEPTION
2667: WHEN NO_DATA_FOUND THEN
2668: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2669: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || l_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2670: FND_MSG_PUB.ADD;
2671: x_return_flag := FALSE;
2672: RAISE FND_API.G_EXC_ERROR;

Line 2669: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || l_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);

2665:
2666: EXCEPTION
2667: WHEN NO_DATA_FOUND THEN
2668: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2669: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || l_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2670: FND_MSG_PUB.ADD;
2671: x_return_flag := FALSE;
2672: RAISE FND_API.G_EXC_ERROR;
2673: END;

Line 2676: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');

2672: RAISE FND_API.G_EXC_ERROR;
2673: END;
2674:
2675: IF (l_dummy_char <> 'Y' and (l_dummy_val = 1 OR l_dummy_val = 3)) THEN
2676: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');
2677: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'l_asset_number');
2678: FND_MSG_PUB.ADD;
2679: x_return_flag := FALSE;
2680: RAISE FND_API.G_EXC_ERROR;

Line 2677: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'l_asset_number');

2673: END;
2674:
2675: IF (l_dummy_char <> 'Y' and (l_dummy_val = 1 OR l_dummy_val = 3)) THEN
2676: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');
2677: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'l_asset_number');
2678: FND_MSG_PUB.ADD;
2679: x_return_flag := FALSE;
2680: RAISE FND_API.G_EXC_ERROR;
2681: END IF;

Line 2702: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

2698: cii.inventory_item_id = msi.inventory_item_id ;
2699:
2700: EXCEPTION
2701: WHEN NO_DATA_FOUND THEN
2702: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2703: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2704: FND_MSG_PUB.ADD;
2705: x_return_flag := FALSE;
2706: RAISE FND_API.G_EXC_ERROR;

Line 2703: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);

2699:
2700: EXCEPTION
2701: WHEN NO_DATA_FOUND THEN
2702: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2703: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2704: FND_MSG_PUB.ADD;
2705: x_return_flag := FALSE;
2706: RAISE FND_API.G_EXC_ERROR;
2707: END;

Line 2710: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');

2706: RAISE FND_API.G_EXC_ERROR;
2707: END;
2708:
2709: IF (l_dummy_char <> 'Y' and (l_dummy_val = 1 OR l_dummy_val = 3)) THEN
2710: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');
2711: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_asset_number');
2712: FND_MSG_PUB.ADD;
2713: x_return_flag := FALSE;
2714: RAISE FND_API.G_EXC_ERROR;

Line 2711: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_asset_number');

2707: END;
2708:
2709: IF (l_dummy_char <> 'Y' and (l_dummy_val = 1 OR l_dummy_val = 3)) THEN
2710: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');
2711: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_asset_number');
2712: FND_MSG_PUB.ADD;
2713: x_return_flag := FALSE;
2714: RAISE FND_API.G_EXC_ERROR;
2715: END IF;

Line 2732: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

2728: -- but will later change to WIP_EAM_JOB_REQ_PRIORITY
2729: IF p_priority_id IS NOT NULL THEN
2730: if validate_lookup(p_priority_id,'WIP_EAM_ACTIVITY_PRIORITY') = FALSE then
2731:
2732: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2733: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Priority Id: ' || to_char(p_priority_id));
2734: FND_MSG_PUB.ADD;
2735: x_return_flag := FALSE;
2736: RAISE FND_API.G_EXC_ERROR;

Line 2733: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Priority Id: ' || to_char(p_priority_id));

2729: IF p_priority_id IS NOT NULL THEN
2730: if validate_lookup(p_priority_id,'WIP_EAM_ACTIVITY_PRIORITY') = FALSE then
2731:
2732: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2733: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Priority Id: ' || to_char(p_priority_id));
2734: FND_MSG_PUB.ADD;
2735: x_return_flag := FALSE;
2736: RAISE FND_API.G_EXC_ERROR;
2737: end if;

Line 2739: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');

2735: x_return_flag := FALSE;
2736: RAISE FND_API.G_EXC_ERROR;
2737: end if;
2738: ELSE
2739: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2740: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_priority_id');
2741: FND_MSG_PUB.ADD;
2742: x_return_flag := FALSE;
2743: RAISE FND_API.G_EXC_ERROR;

Line 2740: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_priority_id');

2736: RAISE FND_API.G_EXC_ERROR;
2737: end if;
2738: ELSE
2739: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2740: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_priority_id');
2741: FND_MSG_PUB.ADD;
2742: x_return_flag := FALSE;
2743: RAISE FND_API.G_EXC_ERROR;
2744: END IF;

Line 2750: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

2746: l_stmt_num := 80;
2747:
2748: IF p_request_by_date IS NOT NULL THEN
2749: IF p_request_by_date < sysdate THEN
2750: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2751: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Request By Date: ' || p_request_by_date);
2752: FND_MSG_PUB.ADD;
2753: x_return_flag := FALSE;
2754: RAISE FND_API.G_EXC_ERROR;

Line 2751: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Request By Date: ' || p_request_by_date);

2747:
2748: IF p_request_by_date IS NOT NULL THEN
2749: IF p_request_by_date < sysdate THEN
2750: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2751: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Request By Date: ' || p_request_by_date);
2752: FND_MSG_PUB.ADD;
2753: x_return_flag := FALSE;
2754: RAISE FND_API.G_EXC_ERROR;
2755: END IF;

Line 2757: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');

2753: x_return_flag := FALSE;
2754: RAISE FND_API.G_EXC_ERROR;
2755: END IF;
2756: ELSE
2757: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2758: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_by_date');
2759: FND_MSG_PUB.ADD;
2760: x_return_flag := FALSE;
2761: RAISE FND_API.G_EXC_ERROR;

Line 2758: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_by_date');

2754: RAISE FND_API.G_EXC_ERROR;
2755: END IF;
2756: ELSE
2757: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2758: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_by_date');
2759: FND_MSG_PUB.ADD;
2760: x_return_flag := FALSE;
2761: RAISE FND_API.G_EXC_ERROR;
2762: END IF;

Line 2768: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');

2764: l_stmt_num := 90;
2765:
2766: IF p_owning_dept_id IS NULL THEN
2767: if l_auto_approve is not null AND l_auto_approve ='N' then
2768: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2769: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_owning_dept_id');
2770: FND_MSG_PUB.ADD;
2771: x_return_flag := FALSE;
2772: RAISE FND_API.G_EXC_ERROR;

Line 2769: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_owning_dept_id');

2765:
2766: IF p_owning_dept_id IS NULL THEN
2767: if l_auto_approve is not null AND l_auto_approve ='N' then
2768: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2769: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_owning_dept_id');
2770: FND_MSG_PUB.ADD;
2771: x_return_flag := FALSE;
2772: RAISE FND_API.G_EXC_ERROR;
2773: end if;

Line 2777: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

2773: end if;
2774: ELSE
2775: if validate_department(p_org_id,p_owning_dept_id) = FALSE then
2776:
2777: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2778: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Owning Dept. Id: ' || to_char(p_owning_dept_id));
2779: FND_MSG_PUB.ADD;
2780: x_return_flag := FALSE;
2781: RAISE FND_API.G_EXC_ERROR;

Line 2778: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Owning Dept. Id: ' || to_char(p_owning_dept_id));

2774: ELSE
2775: if validate_department(p_org_id,p_owning_dept_id) = FALSE then
2776:
2777: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2778: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Owning Dept. Id: ' || to_char(p_owning_dept_id));
2779: FND_MSG_PUB.ADD;
2780: x_return_flag := FALSE;
2781: RAISE FND_API.G_EXC_ERROR;
2782: end if;

Line 2789: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

2785: l_stmt_num := 100;
2786:
2787: IF p_work_request_type_id IS NOT NULL THEN
2788: if validate_lookup(p_work_request_type_id,'WIP_EAM_WORK_REQ_TYPE') = FALSE then
2789: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2790: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Work Request Type Id: ' || to_char(p_work_request_type_id));
2791: FND_MSG_PUB.ADD;
2792: x_return_flag := FALSE;
2793: RAISE FND_API.G_EXC_ERROR;

Line 2790: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Work Request Type Id: ' || to_char(p_work_request_type_id));

2786:
2787: IF p_work_request_type_id IS NOT NULL THEN
2788: if validate_lookup(p_work_request_type_id,'WIP_EAM_WORK_REQ_TYPE') = FALSE then
2789: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2790: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Work Request Type Id: ' || to_char(p_work_request_type_id));
2791: FND_MSG_PUB.ADD;
2792: x_return_flag := FALSE;
2793: RAISE FND_API.G_EXC_ERROR;
2794: end if;

Line 2804: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

2800:
2801: IF (p_eam_linear_id IS NOT NULL) THEN
2802: l_validate := eam_common_utilities_pvt.validate_linear_id(p_eam_linear_id);
2803: IF (NOT l_validate) THEN
2804: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2805: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'EAM Linear Location Id: ' || to_char(p_eam_linear_id));
2806: FND_MSG_PUB.ADD;
2807: x_return_flag := FALSE;
2808: RAISE FND_API.G_EXC_ERROR;

Line 2805: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'EAM Linear Location Id: ' || to_char(p_eam_linear_id));

2801: IF (p_eam_linear_id IS NOT NULL) THEN
2802: l_validate := eam_common_utilities_pvt.validate_linear_id(p_eam_linear_id);
2803: IF (NOT l_validate) THEN
2804: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2805: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'EAM Linear Location Id: ' || to_char(p_eam_linear_id));
2806: FND_MSG_PUB.ADD;
2807: x_return_flag := FALSE;
2808: RAISE FND_API.G_EXC_ERROR;
2809: END IF;

Line 2837: FND_MESSAGE.SET_NAME('WIP','WIP_INVALID_ATTRIBUTE');

2833: ,x_error_segments => l_x_error_segments
2834: ,x_error_message => l_x_error_message
2835: )
2836: ) = FALSE then
2837: FND_MESSAGE.SET_NAME('WIP','WIP_INVALID_ATTRIBUTE');
2838: FND_MSG_PUB.ADD;
2839: RAISE FND_API.G_EXC_ERROR;
2840:
2841: end if;

Line 2845: FND_MESSAGE.SET_NAME('WIP', 'WIP_ML_CREATED_BY');

2841: end if;
2842:
2843: -- check user_id field
2844: if l_valid_user_id = FALSE then
2845: FND_MESSAGE.SET_NAME('WIP', 'WIP_ML_CREATED_BY');
2846: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Created By: ' || p_user_id);
2847: FND_MSG_PUB.ADD;
2848: x_return_flag := FALSE;
2849: RAISE FND_API.G_EXC_ERROR;

Line 2846: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Created By: ' || p_user_id);

2842:
2843: -- check user_id field
2844: if l_valid_user_id = FALSE then
2845: FND_MESSAGE.SET_NAME('WIP', 'WIP_ML_CREATED_BY');
2846: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Created By: ' || p_user_id);
2847: FND_MSG_PUB.ADD;
2848: x_return_flag := FALSE;
2849: RAISE FND_API.G_EXC_ERROR;
2850: end if;

Line 2855: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_CREATED_FOR');

2851:
2852: -- check created_for field
2853: IF (p_created_for is not null) then
2854: if validate_user_id(p_created_for) = FALSE then
2855: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_CREATED_FOR');
2856: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Created For: ' || p_created_for);
2857: FND_MSG_PUB.ADD;
2858: x_return_flag := FALSE;
2859: RAISE FND_API.G_EXC_ERROR;

Line 2856: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Created For: ' || p_created_for);

2852: -- check created_for field
2853: IF (p_created_for is not null) then
2854: if validate_user_id(p_created_for) = FALSE then
2855: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_CREATED_FOR');
2856: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Created For: ' || p_created_for);
2857: FND_MSG_PUB.ADD;
2858: x_return_flag := FALSE;
2859: RAISE FND_API.G_EXC_ERROR;
2860: END IF;

Line 2866: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

2862:
2863: -- check contact preference
2864: IF p_contact_preference is not null then
2865: if validate_lookup(p_contact_preference,'WIP_EAM_CONTACT_PREFERENCE') = FALSE then
2866: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2867: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Contact Preference: ' || to_char(p_contact_preference));
2868: FND_MSG_PUB.ADD;
2869: x_return_flag := FALSE;
2870: RAISE FND_API.G_EXC_ERROR;

Line 2867: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Contact Preference: ' || to_char(p_contact_preference));

2863: -- check contact preference
2864: IF p_contact_preference is not null then
2865: if validate_lookup(p_contact_preference,'WIP_EAM_CONTACT_PREFERENCE') = FALSE then
2866: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2867: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Contact Preference: ' || to_char(p_contact_preference));
2868: FND_MSG_PUB.ADD;
2869: x_return_flag := FALSE;
2870: RAISE FND_API.G_EXC_ERROR;
2871: end if;

Line 2878: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

2874:
2875: -- check notify originator
2876: IF p_notify_originator is not null then
2877: if validate_lookup(p_notify_originator,'SYS_YES_NO') = FALSE then
2878: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2879: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Notify Originator: ' || to_char(p_notify_originator));
2880: FND_MSG_PUB.ADD;
2881: x_return_flag := FALSE;
2882: RAISE FND_API.G_EXC_ERROR;

Line 2879: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Notify Originator: ' || to_char(p_notify_originator));

2875: -- check notify originator
2876: IF p_notify_originator is not null then
2877: if validate_lookup(p_notify_originator,'SYS_YES_NO') = FALSE then
2878: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2879: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Notify Originator: ' || to_char(p_notify_originator));
2880: FND_MSG_PUB.ADD;
2881: x_return_flag := FALSE;
2882: RAISE FND_API.G_EXC_ERROR;
2883: end if;

Line 2898: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');

2894:
2895: -- check if the required parameters are not null values
2896:
2897: IF p_request_id IS NULL THEN
2898: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2899: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_id');
2900: FND_MSG_PUB.ADD;
2901: x_return_flag := FALSE;
2902: RAISE FND_API.G_EXC_ERROR;

Line 2899: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_id');

2895: -- check if the required parameters are not null values
2896:
2897: IF p_request_id IS NULL THEN
2898: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2899: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_id');
2900: FND_MSG_PUB.ADD;
2901: x_return_flag := FALSE;
2902: RAISE FND_API.G_EXC_ERROR;
2903: ELSE

Line 2913: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

2909: WHERE work_request_id = p_request_id;
2910:
2911: EXCEPTION
2912: WHEN NO_DATA_FOUND THEN
2913: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2914: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Request Id: ' || to_char(p_request_id));
2915: FND_MSG_PUB.ADD;
2916: x_return_flag := FALSE;
2917: RAISE FND_API.G_EXC_ERROR;

Line 2914: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Request Id: ' || to_char(p_request_id));

2910:
2911: EXCEPTION
2912: WHEN NO_DATA_FOUND THEN
2913: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2914: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Request Id: ' || to_char(p_request_id));
2915: FND_MSG_PUB.ADD;
2916: x_return_flag := FALSE;
2917: RAISE FND_API.G_EXC_ERROR;
2918: END;

Line 2924: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');

2920:
2921: l_stmt_num := 130;
2922:
2923: IF p_org_id = FND_API.G_MISS_NUM THEN
2924: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2925: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_org_id');
2926: FND_MSG_PUB.ADD;
2927: x_return_flag := FALSE;
2928: RAISE FND_API.G_EXC_ERROR;

Line 2925: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_org_id');

2921: l_stmt_num := 130;
2922:
2923: IF p_org_id = FND_API.G_MISS_NUM THEN
2924: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2925: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_org_id');
2926: FND_MSG_PUB.ADD;
2927: x_return_flag := FALSE;
2928: RAISE FND_API.G_EXC_ERROR;
2929: END IF;

Line 2932: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

2928: RAISE FND_API.G_EXC_ERROR;
2929: END IF;
2930:
2931: IF (p_org_id <> l_org_id) THEN
2932: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2933: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Org Id: ' || to_char(p_org_id));
2934: FND_MSG_PUB.ADD;
2935: x_return_flag := FALSE;
2936: RAISE FND_API.G_EXC_ERROR;

Line 2933: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Org Id: ' || to_char(p_org_id));

2929: END IF;
2930:
2931: IF (p_org_id <> l_org_id) THEN
2932: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2933: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Org Id: ' || to_char(p_org_id));
2934: FND_MSG_PUB.ADD;
2935: x_return_flag := FALSE;
2936: RAISE FND_API.G_EXC_ERROR;
2937: END IF;

Line 2948: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

2944: FROM WIP_EAM_PARAMETERS
2945: WHERE organization_id = p_org_id;
2946: EXCEPTION
2947: WHEN NO_DATA_FOUND THEN
2948: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2949: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Org Id: ' || to_char(p_org_id));
2950: FND_MSG_PUB.ADD;
2951: x_return_flag := FALSE;
2952: RAISE FND_API.G_EXC_ERROR;

Line 2949: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Org Id: ' || to_char(p_org_id));

2945: WHERE organization_id = p_org_id;
2946: EXCEPTION
2947: WHEN NO_DATA_FOUND THEN
2948: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2949: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Org Id: ' || to_char(p_org_id));
2950: FND_MSG_PUB.ADD;
2951: x_return_flag := FALSE;
2952: RAISE FND_API.G_EXC_ERROR;
2953: END;

Line 2965: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

2961: where inventory_item_id = p_asset_group_id
2962: and organization_id = p_org_id;
2963: exception
2964: when no_data_found then
2965: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2966: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2967: FND_MSG_PUB.ADD;
2968: x_return_flag := FALSE;
2969: RAISE FND_API.G_EXC_ERROR;

Line 2966: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);

2962: and organization_id = p_org_id;
2963: exception
2964: when no_data_found then
2965: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2966: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2967: FND_MSG_PUB.ADD;
2968: x_return_flag := FALSE;
2969: RAISE FND_API.G_EXC_ERROR;
2970: end;

Line 2974: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');

2970: end;
2971:
2972: if p_asset_number is null then
2973: --FILL error: Asset Number needs to be entered if Asset Group is entered
2974: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2975: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number');
2976: FND_MSG_PUB.ADD;
2977: x_return_flag := FALSE;
2978: RAISE FND_API.G_EXC_ERROR;

Line 2975: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number');

2971:
2972: if p_asset_number is null then
2973: --FILL error: Asset Number needs to be entered if Asset Group is entered
2974: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2975: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number');
2976: FND_MSG_PUB.ADD;
2977: x_return_flag := FALSE;
2978: RAISE FND_API.G_EXC_ERROR;
2979: end if;

Line 2993: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

2989: cii.inventory_item_id = p_asset_group_id;
2990:
2991: EXCEPTION
2992: WHEN NO_DATA_FOUND THEN
2993: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2994: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2995: FND_MSG_PUB.ADD;
2996: x_return_flag := FALSE;
2997: RAISE FND_API.G_EXC_ERROR;

Line 2994: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);

2990:
2991: EXCEPTION
2992: WHEN NO_DATA_FOUND THEN
2993: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2994: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2995: FND_MSG_PUB.ADD;
2996: x_return_flag := FALSE;
2997: RAISE FND_API.G_EXC_ERROR;
2998: END;

Line 3001: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');

2997: RAISE FND_API.G_EXC_ERROR;
2998: END;
2999:
3000: IF (l_dummy_char <> 'Y') THEN
3001: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');
3002: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_asset_number');
3003: FND_MSG_PUB.ADD;
3004: x_return_flag := FALSE;
3005: RAISE FND_API.G_EXC_ERROR;

Line 3002: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_asset_number');

2998: END;
2999:
3000: IF (l_dummy_char <> 'Y') THEN
3001: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');
3002: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_asset_number');
3003: FND_MSG_PUB.ADD;
3004: x_return_flag := FALSE;
3005: RAISE FND_API.G_EXC_ERROR;
3006: END IF;

Line 3009: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

3005: RAISE FND_API.G_EXC_ERROR;
3006: END IF;
3007:
3008: else
3009: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3010: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
3011: FND_MSG_PUB.ADD;
3012: x_return_flag := FALSE;
3013: RAISE FND_API.G_EXC_ERROR;

Line 3010: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);

3006: END IF;
3007:
3008: else
3009: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3010: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
3011: FND_MSG_PUB.ADD;
3012: x_return_flag := FALSE;
3013: RAISE FND_API.G_EXC_ERROR;
3014: END IF;

Line 3016: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

3012: x_return_flag := FALSE;
3013: RAISE FND_API.G_EXC_ERROR;
3014: END IF;
3015: ELSIF (p_asset_number is not null) then
3016: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3017: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
3018: FND_MSG_PUB.ADD;
3019: x_return_flag := FALSE;
3020: RAISE FND_API.G_EXC_ERROR;

Line 3017: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);

3013: RAISE FND_API.G_EXC_ERROR;
3014: END IF;
3015: ELSIF (p_asset_number is not null) then
3016: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3017: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
3018: FND_MSG_PUB.ADD;
3019: x_return_flag := FALSE;
3020: RAISE FND_API.G_EXC_ERROR;
3021: end if;

Line 3030: FND_MESSAGE.SET_NAME('INV', 'INV_ATTRIBUTE_REQUIRED');

3026:
3027: l_stmt_num := 160;
3028:
3029: IF p_request_by_date = FND_API.G_MISS_DATE THEN
3030: FND_MESSAGE.SET_NAME('INV', 'INV_ATTRIBUTE_REQUIRED');
3031: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_by_date');
3032: FND_MSG_PUB.ADD;
3033: x_return_flag := FALSE;
3034: RAISE FND_API.G_EXC_ERROR;

Line 3031: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_by_date');

3027: l_stmt_num := 160;
3028:
3029: IF p_request_by_date = FND_API.G_MISS_DATE THEN
3030: FND_MESSAGE.SET_NAME('INV', 'INV_ATTRIBUTE_REQUIRED');
3031: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_by_date');
3032: FND_MSG_PUB.ADD;
3033: x_return_flag := FALSE;
3034: RAISE FND_API.G_EXC_ERROR;
3035: ELSE

Line 3047: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

3043:
3044: IF p_status_id is not null THEN
3045: if validate_lookup(p_status_id,'WIP_EAM_WORK_REQ_STATUS') = FALSE then
3046:
3047: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3048: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Status Id: ' || to_char(p_status_id));
3049: FND_MSG_PUB.ADD;
3050: x_return_flag := FALSE;
3051: RAISE FND_API.G_EXC_ERROR;

Line 3048: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Status Id: ' || to_char(p_status_id));

3044: IF p_status_id is not null THEN
3045: if validate_lookup(p_status_id,'WIP_EAM_WORK_REQ_STATUS') = FALSE then
3046:
3047: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3048: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Status Id: ' || to_char(p_status_id));
3049: FND_MSG_PUB.ADD;
3050: x_return_flag := FALSE;
3051: RAISE FND_API.G_EXC_ERROR;
3052: END IF;

Line 3055: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

3051: RAISE FND_API.G_EXC_ERROR;
3052: END IF;
3053: ELSE
3054: IF p_status_id = FND_API.G_MISS_NUM THEN
3055: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3056: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Status Id: ' || to_char(p_status_id));
3057: FND_MSG_PUB.ADD;
3058: x_return_flag := FALSE;
3059: RAISE FND_API.G_EXC_ERROR;

Line 3056: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Status Id: ' || to_char(p_status_id));

3052: END IF;
3053: ELSE
3054: IF p_status_id = FND_API.G_MISS_NUM THEN
3055: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3056: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Status Id: ' || to_char(p_status_id));
3057: FND_MSG_PUB.ADD;
3058: x_return_flag := FALSE;
3059: RAISE FND_API.G_EXC_ERROR;
3060: END IF;

Line 3070: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

3066:
3067: IF p_priority_id is not null THEN
3068: if validate_lookup(p_priority_id, 'WIP_EAM_ACTIVITY_PRIORITY') = FALSE then
3069:
3070: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3071: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Priority Id: ' || to_char(p_priority_id));
3072: FND_MSG_PUB.ADD;
3073: x_return_flag := FALSE;
3074: RAISE FND_API.G_EXC_ERROR;

Line 3071: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Priority Id: ' || to_char(p_priority_id));

3067: IF p_priority_id is not null THEN
3068: if validate_lookup(p_priority_id, 'WIP_EAM_ACTIVITY_PRIORITY') = FALSE then
3069:
3070: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3071: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Priority Id: ' || to_char(p_priority_id));
3072: FND_MSG_PUB.ADD;
3073: x_return_flag := FALSE;
3074: RAISE FND_API.G_EXC_ERROR;
3075: END IF;

Line 3078: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

3074: RAISE FND_API.G_EXC_ERROR;
3075: END IF;
3076: ELSE
3077: IF p_priority_id = FND_API.G_MISS_NUM THEN
3078: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3079: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Priority Id: ' || to_char(p_priority_id));
3080: FND_MSG_PUB.ADD;
3081: x_return_flag := FALSE;
3082: RAISE FND_API.G_EXC_ERROR;

Line 3079: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Priority Id: ' || to_char(p_priority_id));

3075: END IF;
3076: ELSE
3077: IF p_priority_id = FND_API.G_MISS_NUM THEN
3078: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3079: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Priority Id: ' || to_char(p_priority_id));
3080: FND_MSG_PUB.ADD;
3081: x_return_flag := FALSE;
3082: RAISE FND_API.G_EXC_ERROR;
3083: END IF;

Line 3092: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

3088: -- check if the work request type id provided is valid
3089: IF p_work_request_type_id is not null THEN
3090: if validate_lookup(p_work_request_type_id,'WIP_EAM_WORK_REQ_TYPE') = FALSE then
3091:
3092: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3093: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Work Request Type Id: ' || to_char(p_work_request_type_id));
3094: FND_MSG_PUB.ADD;
3095: x_return_flag := FALSE;
3096: RAISE FND_API.G_EXC_ERROR;

Line 3093: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Work Request Type Id: ' || to_char(p_work_request_type_id));

3089: IF p_work_request_type_id is not null THEN
3090: if validate_lookup(p_work_request_type_id,'WIP_EAM_WORK_REQ_TYPE') = FALSE then
3091:
3092: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3093: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Work Request Type Id: ' || to_char(p_work_request_type_id));
3094: FND_MSG_PUB.ADD;
3095: x_return_flag := FALSE;
3096: RAISE FND_API.G_EXC_ERROR;
3097: END IF;

Line 3106: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');

3102: -- check if the owning dept id provided is valid
3103:
3104: IF p_owning_dept_id is not null THEN
3105: IF p_owning_dept_id = FND_API.G_MISS_NUM THEN
3106: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
3107: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_owning_dept_id');
3108: FND_MSG_PUB.ADD;
3109: x_return_flag := FALSE;
3110: RAISE FND_API.G_EXC_ERROR;

Line 3107: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_owning_dept_id');

3103:
3104: IF p_owning_dept_id is not null THEN
3105: IF p_owning_dept_id = FND_API.G_MISS_NUM THEN
3106: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
3107: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_owning_dept_id');
3108: FND_MSG_PUB.ADD;
3109: x_return_flag := FALSE;
3110: RAISE FND_API.G_EXC_ERROR;
3111: ELSIF validate_department(p_org_id,p_owning_dept_id) = FALSE then

Line 3112: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

3108: FND_MSG_PUB.ADD;
3109: x_return_flag := FALSE;
3110: RAISE FND_API.G_EXC_ERROR;
3111: ELSIF validate_department(p_org_id,p_owning_dept_id) = FALSE then
3112: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3113: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Owning Dept. Id: ' || to_char(p_priority_id));
3114: FND_MSG_PUB.ADD;
3115: x_return_flag := FALSE;
3116: RAISE FND_API.G_EXC_ERROR;

Line 3113: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Owning Dept. Id: ' || to_char(p_priority_id));

3109: x_return_flag := FALSE;
3110: RAISE FND_API.G_EXC_ERROR;
3111: ELSIF validate_department(p_org_id,p_owning_dept_id) = FALSE then
3112: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3113: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Owning Dept. Id: ' || to_char(p_priority_id));
3114: FND_MSG_PUB.ADD;
3115: x_return_flag := FALSE;
3116: RAISE FND_API.G_EXC_ERROR;
3117: END IF;

Line 3122: FND_MESSAGE.SET_NAME('WIP', 'WIP_ML_LAST_UPDATED_BY');

3118: END IF;
3119:
3120: -- check user_id field
3121: if l_valid_user_id = FALSE then
3122: FND_MESSAGE.SET_NAME('WIP', 'WIP_ML_LAST_UPDATED_BY');
3123: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Last Updated By: ' || p_user_id);
3124: FND_MSG_PUB.ADD;
3125: x_return_flag := FALSE;
3126: RAISE FND_API.G_EXC_ERROR;

Line 3123: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Last Updated By: ' || p_user_id);

3119:
3120: -- check user_id field
3121: if l_valid_user_id = FALSE then
3122: FND_MESSAGE.SET_NAME('WIP', 'WIP_ML_LAST_UPDATED_BY');
3123: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Last Updated By: ' || p_user_id);
3124: FND_MSG_PUB.ADD;
3125: x_return_flag := FALSE;
3126: RAISE FND_API.G_EXC_ERROR;
3127: end if;

Line 3132: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_CREATED_FOR');

3128:
3129: -- check the created for field
3130: if p_created_for is not null then
3131: if validate_user_id(p_created_for) = FALSE then
3132: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_CREATED_FOR');
3133: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Created For: ' || p_created_for);
3134: FND_MSG_PUB.ADD;
3135: x_return_flag := FALSE;
3136: RAISE FND_API.G_EXC_ERROR;

Line 3133: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Created For: ' || p_created_for);

3129: -- check the created for field
3130: if p_created_for is not null then
3131: if validate_user_id(p_created_for) = FALSE then
3132: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_CREATED_FOR');
3133: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Created For: ' || p_created_for);
3134: FND_MSG_PUB.ADD;
3135: x_return_flag := FALSE;
3136: RAISE FND_API.G_EXC_ERROR;
3137: end if;

Line 3143: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

3139:
3140: -- check contact preference
3141: IF p_contact_preference is not null then
3142: if validate_lookup(p_contact_preference,'WIP_EAM_CONTACT_PREFERENCE') = FALSE then
3143: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3144: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Contact Preference: ' || to_char(p_contact_preference));
3145: FND_MSG_PUB.ADD;
3146: x_return_flag := FALSE;
3147: RAISE FND_API.G_EXC_ERROR;

Line 3144: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Contact Preference: ' || to_char(p_contact_preference));

3140: -- check contact preference
3141: IF p_contact_preference is not null then
3142: if validate_lookup(p_contact_preference,'WIP_EAM_CONTACT_PREFERENCE') = FALSE then
3143: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3144: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Contact Preference: ' || to_char(p_contact_preference));
3145: FND_MSG_PUB.ADD;
3146: x_return_flag := FALSE;
3147: RAISE FND_API.G_EXC_ERROR;
3148: end if;

Line 3155: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');

3151:
3152: -- check notify originator
3153: IF p_notify_originator is not null then
3154: if validate_lookup(p_notify_originator,'SYS_YES_NO') = FALSE then
3155: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3156: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Notify Originator: ' || to_char(p_notify_originator));
3157: FND_MSG_PUB.ADD;
3158: x_return_flag := FALSE;
3159: RAISE FND_API.G_EXC_ERROR;

Line 3156: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Notify Originator: ' || to_char(p_notify_originator));

3152: -- check notify originator
3153: IF p_notify_originator is not null then
3154: if validate_lookup(p_notify_originator,'SYS_YES_NO') = FALSE then
3155: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3156: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Notify Originator: ' || to_char(p_notify_originator));
3157: FND_MSG_PUB.ADD;
3158: x_return_flag := FALSE;
3159: RAISE FND_API.G_EXC_ERROR;
3160: end if;

Line 3188: FND_MESSAGE.SET_NAME('WIP','WIP_INVALID_ATTRIBUTE');

3184: ,x_error_segments => l_x_error_segments
3185: ,x_error_message => l_x_error_message
3186: )
3187: ) = FALSE then
3188: FND_MESSAGE.SET_NAME('WIP','WIP_INVALID_ATTRIBUTE');
3189: FND_MSG_PUB.ADD;
3190: RAISE FND_API.G_EXC_ERROR;
3191:
3192: end if;