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 210: FND_MESSAGE.SET_NAME ('WIP','WIP_EAM_WR_DEPT_MANDATORY');

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

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

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

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

845: l_asset_num_reqd := 'Y';
846: END;
847:
848: IF (l_asset_num_reqd = 'Y' AND l_new_asset_number IS NULL) THEN
849: FND_MESSAGE.SET_NAME ('EAM','EAM_ENTER_ASSET_NUMBER_FIELD');
850: FND_MSG_PUB.ADD;
851: RAISE FND_API.G_EXC_ERROR;
852: END IF;
853:

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

1006: p_error_message => l_error_message
1007: ) ;
1008:
1009: IF (l_results_out <> FND_API.G_RET_STS_SUCCESS) THEN
1010: FND_MESSAGE.SET_NAME ('EAM','EAM_WR_ERROR');
1011: FND_MSG_PUB.ADD;
1012: RAISE FND_API.G_EXC_ERROR;
1013: ELSE
1014: commit ;

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

1029:
1030: IF (l_extended_log_flag = 'Y') THEN
1031: l_stmt_num := 140;
1032:
1033: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_DISPLAY_NULL');
1034: l_null := FND_MESSAGE.GET;
1035:
1036: IF ( isdifferent(l_old_asset_number, l_new_asset_number) = 1 OR
1037: isdifferent_number(l_old_asset_group_id, l_new_asset_group_id) = 1) THEN

Line 1034: l_null := FND_MESSAGE.GET;

1030: IF (l_extended_log_flag = 'Y') THEN
1031: l_stmt_num := 140;
1032:
1033: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_DISPLAY_NULL');
1034: l_null := FND_MESSAGE.GET;
1035:
1036: IF ( isdifferent(l_old_asset_number, l_new_asset_number) = 1 OR
1037: isdifferent_number(l_old_asset_group_id, l_new_asset_group_id) = 1) THEN
1038: l_stmt_num := 230;

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

1066: END;
1067: ELSE
1068: l_new_data := l_null;
1069: END IF;
1070: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_ASSET_GROUP_PROMPT');
1071: INSERT INTO wip_eam_work_req_notes(
1072: work_request_note_id,
1073: last_update_date,
1074: last_updated_by,

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

1087: sysdate,
1088: FND_GLOBAL.user_id,
1089: FND_GLOBAL.login_id,
1090: p_request_id,
1091: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1092: 1, -- 1 for request log, 2 for approver log
1093: null
1094: );
1095: END IF;

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

1096:
1097: SELECT wip_eam_work_req_notes_s.nextval
1098: INTO l_work_request_note_id
1099: FROM dual;
1100: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_ASSET_NUMBER_PROMPT');
1101: INSERT INTO wip_eam_work_req_notes(
1102: work_request_note_id,
1103: last_update_date,
1104: last_updated_by,

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

1117: sysdate,
1118: FND_GLOBAL.user_id,
1119: FND_GLOBAL.login_id,
1120: p_request_id,
1121: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_asset_number,l_null)||' -> '||nvl(l_new_asset_number,l_null),
1122: 1, -- 1 for request log, 2 for approver log
1123: null
1124: );
1125: END IF;

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

1150: EXCEPTION
1151: WHEN NO_DATA_FOUND THEN
1152: l_new_data := l_null;
1153: END;
1154: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_PRIORITY_PROMPT');
1155: l_stmt_num := 180;
1156: INSERT INTO wip_eam_work_req_notes(
1157: work_request_note_id,
1158: last_update_date,

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

1172: sysdate,
1173: FND_GLOBAL.user_id,
1174: FND_GLOBAL.login_id,
1175: p_request_id,
1176: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1177: 1, -- 1 for request log, 2 for approver log
1178: null
1179: );
1180: END IF;

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

1206: EXCEPTION
1207: When NO_DATA_FOUND then
1208: l_new_data := l_null;
1209: END;
1210: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_TYPE_PROMPT');
1211: l_stmt_num := 188;
1212: INSERT INTO wip_eam_work_req_notes(
1213: work_request_note_id,
1214: last_update_date,

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

1228: sysdate,
1229: FND_GLOBAL.user_id,
1230: FND_GLOBAL.login_id,
1231: p_request_id,
1232: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1233: 1, -- 1 for request log, 2 for approver log
1234: null
1235: );
1236: END IF;

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

1261: EXCEPTION
1262: WHEN NO_DATA_FOUND THEN
1263: l_new_data := l_null;
1264: END;
1265: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_STATUS_PROMPT');
1266: l_stmt_num := 220;
1267: INSERT INTO wip_eam_work_req_notes(
1268: work_request_note_id,
1269: last_update_date,

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

1283: sysdate,
1284: FND_GLOBAL.user_id,
1285: FND_GLOBAL.login_id,
1286: p_request_id,
1287: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1288: 1, -- 1 for request log, 2 for approver log
1289: null
1290: );
1291: END IF;

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

1316: EXCEPTION
1317: WHEN NO_DATA_FOUND THEN
1318: l_new_data := l_null;
1319: END;
1320: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_DEPT_PROMPT');
1321: l_stmt_num := 260;
1322: INSERT INTO wip_eam_work_req_notes(
1323: work_request_note_id,
1324: last_update_date,

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

1338: sysdate,
1339: FND_GLOBAL.user_id,
1340: FND_GLOBAL.login_id,
1341: p_request_id,
1342: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1343: 1, -- 1 for request log, 2 for approver log
1344: null
1345: );
1346: END IF;

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

1345: );
1346: END IF;
1347:
1348: IF (l_old_request_by_date <> l_new_request_by_date) THEN
1349: FND_MESSAGE.SET_NAME ('WIP','WIP_EAM_REQ_BY_DATE_PROMPT');
1350: l_stmt_num := 270;
1351: SELECT wip_eam_work_req_notes_s.nextval
1352: INTO l_work_request_note_id
1353: FROM DUAL;

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

1380: sysdate,
1381: FND_GLOBAL.user_id,
1382: FND_GLOBAL.login_id,
1383: p_request_id,
1384: '@@@ '||FND_MESSAGE.GET||l_timezone_code ||' : '||to_char(l_old_request_by_date, 'dd-MON-yyyy hh24:mi:ss')||' -> '
1385: ||to_char(l_new_request_by_date, 'dd-MON-yyyy hh24:mi:ss') ,
1386: 1, -- 1 for request log, 2 for approver log
1387: null
1388: );

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

1385: ||to_char(l_new_request_by_date, 'dd-MON-yyyy hh24:mi:ss') ,
1386: 1, -- 1 for request log, 2 for approver log
1387: null
1388: );
1389: --l_another_log := l_another_log ||chr(10) ||'@@@ '||FND_MESSAGE.GET||' : '||l_old_request_by_date||' -> ' ||p_request_by_date;
1390: END IF;
1391:
1392: IF (isdifferent_number(l_old_created_for, l_new_created_for) = 1) THEN
1393: l_stmt_num := 150;

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

1412: EXCEPTION
1413: When NO_DATA_FOUND then
1414: l_new_data := l_null;
1415: END;
1416: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_CREATED_FOR_PROMPT');
1417: INSERT INTO wip_eam_work_req_notes(
1418: work_request_note_id,
1419: last_update_date,
1420: last_updated_by,

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

1433: sysdate,
1434: FND_GLOBAL.user_id,
1435: FND_GLOBAL.login_id,
1436: p_request_id,
1437: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1438: 1, -- 1 for request log, 2 for approver log
1439: null
1440: );
1441: END IF;

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

1443: IF (isdifferent(l_old_email, l_new_email) = 1) THEN
1444: SELECT wip_eam_work_req_notes_s.nextval
1445: INTO l_work_request_note_id
1446: FROM DUAL;
1447: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_EMAIL_PROMPT');
1448: INSERT INTO wip_eam_work_req_notes(
1449: work_request_note_id,
1450: last_update_date,
1451: last_updated_by,

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

1464: sysdate,
1465: FND_GLOBAL.user_id,
1466: FND_GLOBAL.login_id,
1467: p_request_id,
1468: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_email,l_null)||' -> '||nvl(l_new_email,l_null),
1469: 1, -- 1 for request log, 2 for approver log
1470: null
1471: );
1472: END IF;

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

1474: IF (isdifferent(l_old_phone_number, l_new_phone_number) = 1) THEN
1475: SELECT wip_eam_work_req_notes_s.nextval
1476: INTO l_work_request_note_id
1477: FROM DUAL;
1478: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_PHONE_NUMBER_PROMPT');
1479: INSERT INTO wip_eam_work_req_notes(
1480: work_request_note_id,
1481: last_update_date,
1482: last_updated_by,

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

1495: sysdate,
1496: FND_GLOBAL.user_id,
1497: FND_GLOBAL.login_id,
1498: p_request_id,
1499: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_phone_number,l_null)||' -> '||nvl(l_new_phone_number,l_null),
1500: 1, /* 1 for request log, 2 for approver log*/
1501: null
1502: );
1503: END IF;

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

1525: EXCEPTION
1526: When NO_DATA_FOUND then
1527: l_new_data := l_null;
1528: END;
1529: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_NOTIFY_USER_PROMPT');
1530: INSERT INTO wip_eam_work_req_notes(
1531: work_request_note_id,
1532: last_update_date,
1533: last_updated_by,

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

1546: sysdate,
1547: FND_GLOBAL.user_id,
1548: FND_GLOBAL.login_id,
1549: p_request_id,
1550: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1551: 1, -- 1 for request log, 2 for approver log
1552: null
1553: );
1554: END IF;

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

1576: EXCEPTION
1577: When NO_DATA_FOUND then
1578: l_new_data := l_null;
1579: END;
1580: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_CONTACT_PREF_PROMPT');
1581: INSERT INTO wip_eam_work_req_notes(
1582: work_request_note_id,
1583: last_update_date,
1584: last_updated_by,

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

1597: sysdate,
1598: FND_GLOBAL.user_id,
1599: FND_GLOBAL.login_id,
1600: p_request_id,
1601: '@@@ '||FND_MESSAGE.GET||' : '||l_old_data||' -> '||l_new_data,
1602: 1, -- 1 for request log, 2 for approver log
1603: null
1604: );
1605: END IF;

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

1607: IF (isdifferent(l_new_attribute_category,l_old_attribute_category) = 1) THEN
1608: SELECT wip_eam_work_req_notes_s.nextval
1609: INTO l_work_request_note_id
1610: FROM DUAL;
1611: FND_MESSAGE.SET_NAME ('WIP', 'WIP_EAM_CONTEXT_VALUE_PROMPT');
1612: INSERT INTO wip_eam_work_req_notes(
1613: work_request_note_id,
1614: last_update_date,
1615: last_updated_by,

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

1628: sysdate,
1629: FND_GLOBAL.user_id,
1630: FND_GLOBAL.login_id,
1631: p_request_id,
1632: '@@@ '||FND_MESSAGE.GET||' : '||nvl(l_old_attribute_category,l_null)||' -> '||nvl(l_new_attribute_category,l_null),
1633: 1, -- 1 for request log, 2 for approver log
1634: null
1635: );
1636: END IF;

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

2408: END IF;
2409: END IF;
2410: END IF;
2411: IF (result = 0) THEN
2412: FND_MESSAGE.SET_NAME('EAM', p_msg);
2413: IF p_attr is not null then
2414: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || to_char(p_new_value));
2415: END IF;
2416: FND_MSG_PUB.ADD;

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

2410: END IF;
2411: IF (result = 0) THEN
2412: FND_MESSAGE.SET_NAME('EAM', p_msg);
2413: IF p_attr is not null then
2414: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || to_char(p_new_value));
2415: END IF;
2416: FND_MSG_PUB.ADD;
2417: x_return_flag := FALSE;
2418: RAISE FND_API.G_EXC_ERROR;

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

2436: END IF;
2437: END IF;
2438: END IF;
2439: IF (result = 0) THEN
2440: FND_MESSAGE.SET_NAME('EAM', p_msg);
2441: IF p_attr is not null then
2442: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || p_new_value);
2443: END IF;
2444: FND_MSG_PUB.ADD;

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

2438: END IF;
2439: IF (result = 0) THEN
2440: FND_MESSAGE.SET_NAME('EAM', p_msg);
2441: IF p_attr is not null then
2442: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || p_new_value);
2443: END IF;
2444: FND_MSG_PUB.ADD;
2445: x_return_flag := FALSE;
2446: RAISE FND_API.G_EXC_ERROR;

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

2464: END IF;
2465: END IF;
2466: END IF;
2467: IF (result = 0) THEN
2468: FND_MESSAGE.SET_NAME('EAM', p_msg);
2469: IF p_attr is not null then
2470: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || to_char(p_new_value, 'YYYY-MON-DD'));
2471: END IF;
2472: FND_MSG_PUB.ADD;

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

2466: END IF;
2467: IF (result = 0) THEN
2468: FND_MESSAGE.SET_NAME('EAM', p_msg);
2469: IF p_attr is not null then
2470: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', p_attr || to_char(p_new_value, 'YYYY-MON-DD'));
2471: END IF;
2472: FND_MSG_PUB.ADD;
2473: x_return_flag := FALSE;
2474: RAISE FND_API.G_EXC_ERROR;

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

2574:
2575: l_stmt_num := 30;
2576:
2577: IF p_org_id IS NULL THEN
2578: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2579: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_org_id');
2580: FND_MSG_PUB.ADD;
2581: x_return_flag := FALSE;
2582: RAISE FND_API.G_EXC_ERROR;

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

2575: l_stmt_num := 30;
2576:
2577: IF p_org_id IS NULL THEN
2578: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2579: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_org_id');
2580: FND_MSG_PUB.ADD;
2581: x_return_flag := FALSE;
2582: RAISE FND_API.G_EXC_ERROR;
2583: END IF;

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

2588: from wip_eam_parameters
2589: where organization_id = p_org_id;
2590: exception
2591: when others then
2592: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2593: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Organization Id: ' || p_org_id);
2594: FND_MSG_PUB.ADD;
2595: x_return_flag := FALSE;
2596: RAISE FND_API.G_EXC_ERROR;

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

2589: where organization_id = p_org_id;
2590: exception
2591: when others then
2592: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2593: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Organization Id: ' || p_org_id);
2594: FND_MSG_PUB.ADD;
2595: x_return_flag := FALSE;
2596: RAISE FND_API.G_EXC_ERROR;
2597: end;

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

2617: cii.inventory_item_id = msi.inventory_item_id ;
2618:
2619: EXCEPTION
2620: WHEN NO_DATA_FOUND THEN
2621: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2622: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || l_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2623: FND_MSG_PUB.ADD;
2624: x_return_flag := FALSE;
2625: RAISE FND_API.G_EXC_ERROR;

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

2618:
2619: EXCEPTION
2620: WHEN NO_DATA_FOUND THEN
2621: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2622: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || l_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2623: FND_MSG_PUB.ADD;
2624: x_return_flag := FALSE;
2625: RAISE FND_API.G_EXC_ERROR;
2626: END;

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

2625: RAISE FND_API.G_EXC_ERROR;
2626: END;
2627:
2628: IF (l_dummy_char <> 'Y' and (l_dummy_val = 1 OR l_dummy_val = 3)) THEN
2629: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');
2630: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'l_asset_number');
2631: FND_MSG_PUB.ADD;
2632: x_return_flag := FALSE;
2633: RAISE FND_API.G_EXC_ERROR;

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

2626: END;
2627:
2628: IF (l_dummy_char <> 'Y' and (l_dummy_val = 1 OR l_dummy_val = 3)) THEN
2629: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');
2630: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'l_asset_number');
2631: FND_MSG_PUB.ADD;
2632: x_return_flag := FALSE;
2633: RAISE FND_API.G_EXC_ERROR;
2634: END IF;

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

2651: cii.inventory_item_id = msi.inventory_item_id ;
2652:
2653: EXCEPTION
2654: WHEN NO_DATA_FOUND THEN
2655: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2656: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2657: FND_MSG_PUB.ADD;
2658: x_return_flag := FALSE;
2659: RAISE FND_API.G_EXC_ERROR;

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

2652:
2653: EXCEPTION
2654: WHEN NO_DATA_FOUND THEN
2655: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2656: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2657: FND_MSG_PUB.ADD;
2658: x_return_flag := FALSE;
2659: RAISE FND_API.G_EXC_ERROR;
2660: END;

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

2659: RAISE FND_API.G_EXC_ERROR;
2660: END;
2661:
2662: IF (l_dummy_char <> 'Y' and (l_dummy_val = 1 OR l_dummy_val = 3)) THEN
2663: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');
2664: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_asset_number');
2665: FND_MSG_PUB.ADD;
2666: x_return_flag := FALSE;
2667: RAISE FND_API.G_EXC_ERROR;

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

2660: END;
2661:
2662: IF (l_dummy_char <> 'Y' and (l_dummy_val = 1 OR l_dummy_val = 3)) THEN
2663: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');
2664: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_asset_number');
2665: FND_MSG_PUB.ADD;
2666: x_return_flag := FALSE;
2667: RAISE FND_API.G_EXC_ERROR;
2668: END IF;

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

2681: -- but will later change to WIP_EAM_JOB_REQ_PRIORITY
2682: IF p_priority_id IS NOT NULL THEN
2683: if validate_lookup(p_priority_id,'WIP_EAM_ACTIVITY_PRIORITY') = FALSE then
2684:
2685: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2686: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Priority Id: ' || to_char(p_priority_id));
2687: FND_MSG_PUB.ADD;
2688: x_return_flag := FALSE;
2689: RAISE FND_API.G_EXC_ERROR;

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

2682: IF p_priority_id IS NOT NULL THEN
2683: if validate_lookup(p_priority_id,'WIP_EAM_ACTIVITY_PRIORITY') = FALSE then
2684:
2685: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2686: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Priority Id: ' || to_char(p_priority_id));
2687: FND_MSG_PUB.ADD;
2688: x_return_flag := FALSE;
2689: RAISE FND_API.G_EXC_ERROR;
2690: end if;

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

2688: x_return_flag := FALSE;
2689: RAISE FND_API.G_EXC_ERROR;
2690: end if;
2691: ELSE
2692: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2693: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_priority_id');
2694: FND_MSG_PUB.ADD;
2695: x_return_flag := FALSE;
2696: RAISE FND_API.G_EXC_ERROR;

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

2689: RAISE FND_API.G_EXC_ERROR;
2690: end if;
2691: ELSE
2692: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2693: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_priority_id');
2694: FND_MSG_PUB.ADD;
2695: x_return_flag := FALSE;
2696: RAISE FND_API.G_EXC_ERROR;
2697: END IF;

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

2699: l_stmt_num := 80;
2700:
2701: IF p_request_by_date IS NOT NULL THEN
2702: IF p_request_by_date < sysdate THEN
2703: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2704: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Request By Date: ' || p_request_by_date);
2705: FND_MSG_PUB.ADD;
2706: x_return_flag := FALSE;
2707: RAISE FND_API.G_EXC_ERROR;

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

2700:
2701: IF p_request_by_date IS NOT NULL THEN
2702: IF p_request_by_date < sysdate THEN
2703: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2704: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Request By Date: ' || p_request_by_date);
2705: FND_MSG_PUB.ADD;
2706: x_return_flag := FALSE;
2707: RAISE FND_API.G_EXC_ERROR;
2708: END IF;

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

2706: x_return_flag := FALSE;
2707: RAISE FND_API.G_EXC_ERROR;
2708: END IF;
2709: ELSE
2710: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2711: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_by_date');
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_request_by_date');

2707: RAISE FND_API.G_EXC_ERROR;
2708: END IF;
2709: ELSE
2710: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2711: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_by_date');
2712: FND_MSG_PUB.ADD;
2713: x_return_flag := FALSE;
2714: RAISE FND_API.G_EXC_ERROR;
2715: END IF;

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

2717: l_stmt_num := 90;
2718:
2719: IF p_owning_dept_id IS NULL THEN
2720: if l_auto_approve is not null AND l_auto_approve ='N' then
2721: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2722: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_owning_dept_id');
2723: FND_MSG_PUB.ADD;
2724: x_return_flag := FALSE;
2725: RAISE FND_API.G_EXC_ERROR;

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

2718:
2719: IF p_owning_dept_id IS NULL THEN
2720: if l_auto_approve is not null AND l_auto_approve ='N' then
2721: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2722: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_owning_dept_id');
2723: FND_MSG_PUB.ADD;
2724: x_return_flag := FALSE;
2725: RAISE FND_API.G_EXC_ERROR;
2726: end if;

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

2726: end if;
2727: ELSE
2728: if validate_department(p_org_id,p_owning_dept_id) = FALSE then
2729:
2730: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2731: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Owning Dept. Id: ' || to_char(p_owning_dept_id));
2732: FND_MSG_PUB.ADD;
2733: x_return_flag := FALSE;
2734: RAISE FND_API.G_EXC_ERROR;

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

2727: ELSE
2728: if validate_department(p_org_id,p_owning_dept_id) = FALSE then
2729:
2730: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2731: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Owning Dept. Id: ' || to_char(p_owning_dept_id));
2732: FND_MSG_PUB.ADD;
2733: x_return_flag := FALSE;
2734: RAISE FND_API.G_EXC_ERROR;
2735: end if;

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

2738: l_stmt_num := 100;
2739:
2740: IF p_work_request_type_id IS NOT NULL THEN
2741: if validate_lookup(p_work_request_type_id,'WIP_EAM_WORK_REQ_TYPE') = FALSE then
2742: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2743: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Work Request Type Id: ' || to_char(p_work_request_type_id));
2744: FND_MSG_PUB.ADD;
2745: x_return_flag := FALSE;
2746: RAISE FND_API.G_EXC_ERROR;

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

2739:
2740: IF p_work_request_type_id IS NOT NULL THEN
2741: if validate_lookup(p_work_request_type_id,'WIP_EAM_WORK_REQ_TYPE') = FALSE then
2742: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2743: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Work Request Type Id: ' || to_char(p_work_request_type_id));
2744: FND_MSG_PUB.ADD;
2745: x_return_flag := FALSE;
2746: RAISE FND_API.G_EXC_ERROR;
2747: end if;

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

2753:
2754: IF (p_eam_linear_id IS NOT NULL) THEN
2755: l_validate := eam_common_utilities_pvt.validate_linear_id(p_eam_linear_id);
2756: IF (NOT l_validate) THEN
2757: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2758: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'EAM Linear Location Id: ' || to_char(p_eam_linear_id));
2759: FND_MSG_PUB.ADD;
2760: x_return_flag := FALSE;
2761: RAISE FND_API.G_EXC_ERROR;

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

2754: IF (p_eam_linear_id IS NOT NULL) THEN
2755: l_validate := eam_common_utilities_pvt.validate_linear_id(p_eam_linear_id);
2756: IF (NOT l_validate) THEN
2757: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2758: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'EAM Linear Location Id: ' || to_char(p_eam_linear_id));
2759: FND_MSG_PUB.ADD;
2760: x_return_flag := FALSE;
2761: RAISE FND_API.G_EXC_ERROR;
2762: END IF;

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

2786: ,x_error_segments => l_x_error_segments
2787: ,x_error_message => l_x_error_message
2788: )
2789: ) = FALSE then
2790: FND_MESSAGE.SET_NAME('WIP','WIP_INVALID_ATTRIBUTE');
2791: FND_MSG_PUB.ADD;
2792: RAISE FND_API.G_EXC_ERROR;
2793:
2794: end if;

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

2795:
2796: -- check created_for field
2797: IF (p_created_for is not null) then
2798: if validate_user_id(p_created_for) = FALSE then
2799: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_CREATED_FOR');
2800: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Created For: ' || p_created_for);
2801: FND_MSG_PUB.ADD;
2802: x_return_flag := FALSE;
2803: RAISE FND_API.G_EXC_ERROR;

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

2796: -- check created_for field
2797: IF (p_created_for is not null) then
2798: if validate_user_id(p_created_for) = FALSE then
2799: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_CREATED_FOR');
2800: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Created For: ' || p_created_for);
2801: FND_MSG_PUB.ADD;
2802: x_return_flag := FALSE;
2803: RAISE FND_API.G_EXC_ERROR;
2804: END IF;

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

2806:
2807: -- check contact preference
2808: IF p_contact_preference is not null then
2809: if validate_lookup(p_contact_preference,'WIP_EAM_CONTACT_PREFERENCE') = FALSE then
2810: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2811: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Contact Preference: ' || to_char(p_contact_preference));
2812: FND_MSG_PUB.ADD;
2813: x_return_flag := FALSE;
2814: RAISE FND_API.G_EXC_ERROR;

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

2807: -- check contact preference
2808: IF p_contact_preference is not null then
2809: if validate_lookup(p_contact_preference,'WIP_EAM_CONTACT_PREFERENCE') = FALSE then
2810: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2811: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Contact Preference: ' || to_char(p_contact_preference));
2812: FND_MSG_PUB.ADD;
2813: x_return_flag := FALSE;
2814: RAISE FND_API.G_EXC_ERROR;
2815: end if;

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

2818:
2819: -- check notify originator
2820: IF p_notify_originator is not null then
2821: if validate_lookup(p_notify_originator,'SYS_YES_NO') = FALSE then
2822: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2823: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Notify Originator: ' || to_char(p_notify_originator));
2824: FND_MSG_PUB.ADD;
2825: x_return_flag := FALSE;
2826: RAISE FND_API.G_EXC_ERROR;

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

2819: -- check notify originator
2820: IF p_notify_originator is not null then
2821: if validate_lookup(p_notify_originator,'SYS_YES_NO') = FALSE then
2822: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2823: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Notify Originator: ' || to_char(p_notify_originator));
2824: FND_MSG_PUB.ADD;
2825: x_return_flag := FALSE;
2826: RAISE FND_API.G_EXC_ERROR;
2827: end if;

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

2838:
2839: -- check if the required parameters are not null values
2840:
2841: IF p_request_id IS NULL THEN
2842: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2843: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_id');
2844: FND_MSG_PUB.ADD;
2845: x_return_flag := FALSE;
2846: RAISE FND_API.G_EXC_ERROR;

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

2839: -- check if the required parameters are not null values
2840:
2841: IF p_request_id IS NULL THEN
2842: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2843: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_id');
2844: FND_MSG_PUB.ADD;
2845: x_return_flag := FALSE;
2846: RAISE FND_API.G_EXC_ERROR;
2847: ELSE

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

2853: WHERE work_request_id = p_request_id;
2854:
2855: EXCEPTION
2856: WHEN NO_DATA_FOUND THEN
2857: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2858: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Request Id: ' || to_char(p_request_id));
2859: FND_MSG_PUB.ADD;
2860: x_return_flag := FALSE;
2861: RAISE FND_API.G_EXC_ERROR;

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

2854:
2855: EXCEPTION
2856: WHEN NO_DATA_FOUND THEN
2857: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2858: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Request Id: ' || to_char(p_request_id));
2859: FND_MSG_PUB.ADD;
2860: x_return_flag := FALSE;
2861: RAISE FND_API.G_EXC_ERROR;
2862: END;

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

2864:
2865: l_stmt_num := 130;
2866:
2867: IF p_org_id = FND_API.G_MISS_NUM THEN
2868: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2869: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_org_id');
2870: FND_MSG_PUB.ADD;
2871: x_return_flag := FALSE;
2872: RAISE FND_API.G_EXC_ERROR;

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

2865: l_stmt_num := 130;
2866:
2867: IF p_org_id = FND_API.G_MISS_NUM THEN
2868: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2869: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_org_id');
2870: FND_MSG_PUB.ADD;
2871: x_return_flag := FALSE;
2872: RAISE FND_API.G_EXC_ERROR;
2873: END IF;

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

2872: RAISE FND_API.G_EXC_ERROR;
2873: END IF;
2874:
2875: IF (p_org_id <> l_org_id) THEN
2876: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2877: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Org Id: ' || to_char(p_org_id));
2878: FND_MSG_PUB.ADD;
2879: x_return_flag := FALSE;
2880: RAISE FND_API.G_EXC_ERROR;

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

2873: END IF;
2874:
2875: IF (p_org_id <> l_org_id) THEN
2876: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2877: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Org Id: ' || to_char(p_org_id));
2878: FND_MSG_PUB.ADD;
2879: x_return_flag := FALSE;
2880: RAISE FND_API.G_EXC_ERROR;
2881: END IF;

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

2888: FROM WIP_EAM_PARAMETERS
2889: WHERE organization_id = p_org_id;
2890: EXCEPTION
2891: WHEN NO_DATA_FOUND THEN
2892: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2893: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Org Id: ' || to_char(p_org_id));
2894: FND_MSG_PUB.ADD;
2895: x_return_flag := FALSE;
2896: RAISE FND_API.G_EXC_ERROR;

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

2889: WHERE organization_id = p_org_id;
2890: EXCEPTION
2891: WHEN NO_DATA_FOUND THEN
2892: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2893: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Org Id: ' || to_char(p_org_id));
2894: FND_MSG_PUB.ADD;
2895: x_return_flag := FALSE;
2896: RAISE FND_API.G_EXC_ERROR;
2897: END;

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

2905: where inventory_item_id = p_asset_group_id
2906: and organization_id = p_org_id;
2907: exception
2908: when no_data_found then
2909: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2910: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2911: FND_MSG_PUB.ADD;
2912: x_return_flag := FALSE;
2913: RAISE FND_API.G_EXC_ERROR;

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

2906: and organization_id = p_org_id;
2907: exception
2908: when no_data_found then
2909: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2910: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2911: FND_MSG_PUB.ADD;
2912: x_return_flag := FALSE;
2913: RAISE FND_API.G_EXC_ERROR;
2914: end;

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

2914: end;
2915:
2916: if p_asset_number is null then
2917: --FILL error: Asset Number needs to be entered if Asset Group is entered
2918: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2919: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number');
2920: FND_MSG_PUB.ADD;
2921: x_return_flag := FALSE;
2922: RAISE FND_API.G_EXC_ERROR;

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

2915:
2916: if p_asset_number is null then
2917: --FILL error: Asset Number needs to be entered if Asset Group is entered
2918: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
2919: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number');
2920: FND_MSG_PUB.ADD;
2921: x_return_flag := FALSE;
2922: RAISE FND_API.G_EXC_ERROR;
2923: end if;

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

2933: cii.inventory_item_id = p_asset_group_id;
2934:
2935: EXCEPTION
2936: WHEN NO_DATA_FOUND THEN
2937: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2938: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2939: FND_MSG_PUB.ADD;
2940: x_return_flag := FALSE;
2941: RAISE FND_API.G_EXC_ERROR;

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

2934:
2935: EXCEPTION
2936: WHEN NO_DATA_FOUND THEN
2937: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2938: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2939: FND_MSG_PUB.ADD;
2940: x_return_flag := FALSE;
2941: RAISE FND_API.G_EXC_ERROR;
2942: END;

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

2941: RAISE FND_API.G_EXC_ERROR;
2942: END;
2943:
2944: IF (l_dummy_char <> 'Y') THEN
2945: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');
2946: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_asset_number');
2947: FND_MSG_PUB.ADD;
2948: x_return_flag := FALSE;
2949: RAISE FND_API.G_EXC_ERROR;

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

2942: END;
2943:
2944: IF (l_dummy_char <> 'Y') THEN
2945: FND_MESSAGE.SET_NAME('WIP', 'WIP_EAM_ASSET_NOT_MAINTAINABLE');
2946: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_asset_number');
2947: FND_MSG_PUB.ADD;
2948: x_return_flag := FALSE;
2949: RAISE FND_API.G_EXC_ERROR;
2950: END IF;

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

2949: RAISE FND_API.G_EXC_ERROR;
2950: END IF;
2951:
2952: else
2953: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2954: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2955: FND_MSG_PUB.ADD;
2956: x_return_flag := FALSE;
2957: RAISE FND_API.G_EXC_ERROR;

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

2950: END IF;
2951:
2952: else
2953: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2954: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2955: FND_MSG_PUB.ADD;
2956: x_return_flag := FALSE;
2957: RAISE FND_API.G_EXC_ERROR;
2958: END IF;

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

2956: x_return_flag := FALSE;
2957: RAISE FND_API.G_EXC_ERROR;
2958: END IF;
2959: ELSIF (p_asset_number is not null) then
2960: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2961: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2962: FND_MSG_PUB.ADD;
2963: x_return_flag := FALSE;
2964: RAISE FND_API.G_EXC_ERROR;

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

2957: RAISE FND_API.G_EXC_ERROR;
2958: END IF;
2959: ELSIF (p_asset_number is not null) then
2960: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2961: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Asset Number: ' || p_asset_number || ', '|| 'Org Id: ' || p_org_id || ' and Group Id: ' || p_asset_group_id);
2962: FND_MSG_PUB.ADD;
2963: x_return_flag := FALSE;
2964: RAISE FND_API.G_EXC_ERROR;
2965: end if;

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

2970:
2971: l_stmt_num := 160;
2972:
2973: IF p_request_by_date = FND_API.G_MISS_DATE THEN
2974: FND_MESSAGE.SET_NAME('INV', 'INV_ATTRIBUTE_REQUIRED');
2975: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_by_date');
2976: FND_MSG_PUB.ADD;
2977: x_return_flag := FALSE;
2978: RAISE FND_API.G_EXC_ERROR;

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

2971: l_stmt_num := 160;
2972:
2973: IF p_request_by_date = FND_API.G_MISS_DATE THEN
2974: FND_MESSAGE.SET_NAME('INV', 'INV_ATTRIBUTE_REQUIRED');
2975: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_by_date');
2976: FND_MSG_PUB.ADD;
2977: x_return_flag := FALSE;
2978: RAISE FND_API.G_EXC_ERROR;
2979: ELSE

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

2977: x_return_flag := FALSE;
2978: RAISE FND_API.G_EXC_ERROR;
2979: ELSE
2980: IF p_request_by_date < sysdate THEN
2981: FND_MESSAGE.SET_NAME('INV', 'INV_ATTRIBUTE_REQUIRED');
2982: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_by_date');
2983: FND_MSG_PUB.ADD;
2984: x_return_flag := FALSE;
2985: RAISE FND_API.G_EXC_ERROR;

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

2978: RAISE FND_API.G_EXC_ERROR;
2979: ELSE
2980: IF p_request_by_date < sysdate THEN
2981: FND_MESSAGE.SET_NAME('INV', 'INV_ATTRIBUTE_REQUIRED');
2982: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_request_by_date');
2983: FND_MSG_PUB.ADD;
2984: x_return_flag := FALSE;
2985: RAISE FND_API.G_EXC_ERROR;
2986: END IF;

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

2991:
2992: IF p_status_id is not null THEN
2993: if validate_lookup(p_status_id,'WIP_EAM_WORK_REQ_STATUS') = FALSE then
2994:
2995: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2996: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Status Id: ' || to_char(p_status_id));
2997: FND_MSG_PUB.ADD;
2998: x_return_flag := FALSE;
2999: RAISE FND_API.G_EXC_ERROR;

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

2992: IF p_status_id is not null THEN
2993: if validate_lookup(p_status_id,'WIP_EAM_WORK_REQ_STATUS') = FALSE then
2994:
2995: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
2996: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Status Id: ' || to_char(p_status_id));
2997: FND_MSG_PUB.ADD;
2998: x_return_flag := FALSE;
2999: RAISE FND_API.G_EXC_ERROR;
3000: END IF;

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

2999: RAISE FND_API.G_EXC_ERROR;
3000: END IF;
3001: ELSE
3002: IF p_status_id = FND_API.G_MISS_NUM THEN
3003: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3004: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Status Id: ' || to_char(p_status_id));
3005: FND_MSG_PUB.ADD;
3006: x_return_flag := FALSE;
3007: RAISE FND_API.G_EXC_ERROR;

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

3000: END IF;
3001: ELSE
3002: IF p_status_id = FND_API.G_MISS_NUM THEN
3003: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3004: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Status Id: ' || to_char(p_status_id));
3005: FND_MSG_PUB.ADD;
3006: x_return_flag := FALSE;
3007: RAISE FND_API.G_EXC_ERROR;
3008: END IF;

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

3014:
3015: IF p_priority_id is not null THEN
3016: if validate_lookup(p_priority_id, 'WIP_EAM_ACTIVITY_PRIORITY') = FALSE then
3017:
3018: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3019: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Priority Id: ' || to_char(p_priority_id));
3020: FND_MSG_PUB.ADD;
3021: x_return_flag := FALSE;
3022: RAISE FND_API.G_EXC_ERROR;

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

3015: IF p_priority_id is not null THEN
3016: if validate_lookup(p_priority_id, 'WIP_EAM_ACTIVITY_PRIORITY') = FALSE then
3017:
3018: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3019: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Priority Id: ' || to_char(p_priority_id));
3020: FND_MSG_PUB.ADD;
3021: x_return_flag := FALSE;
3022: RAISE FND_API.G_EXC_ERROR;
3023: END IF;

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

3022: RAISE FND_API.G_EXC_ERROR;
3023: END IF;
3024: ELSE
3025: IF p_priority_id = FND_API.G_MISS_NUM THEN
3026: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3027: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Priority Id: ' || to_char(p_priority_id));
3028: FND_MSG_PUB.ADD;
3029: x_return_flag := FALSE;
3030: RAISE FND_API.G_EXC_ERROR;

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

3023: END IF;
3024: ELSE
3025: IF p_priority_id = FND_API.G_MISS_NUM THEN
3026: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3027: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Priority Id: ' || to_char(p_priority_id));
3028: FND_MSG_PUB.ADD;
3029: x_return_flag := FALSE;
3030: RAISE FND_API.G_EXC_ERROR;
3031: END IF;

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

3036: -- check if the work request type id provided is valid
3037: IF p_work_request_type_id is not null THEN
3038: if validate_lookup(p_work_request_type_id,'WIP_EAM_WORK_REQ_TYPE') = FALSE then
3039:
3040: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3041: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Work Request Type Id: ' || to_char(p_work_request_type_id));
3042: FND_MSG_PUB.ADD;
3043: x_return_flag := FALSE;
3044: RAISE FND_API.G_EXC_ERROR;

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

3037: IF p_work_request_type_id is not null THEN
3038: if validate_lookup(p_work_request_type_id,'WIP_EAM_WORK_REQ_TYPE') = FALSE then
3039:
3040: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3041: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Work Request Type Id: ' || to_char(p_work_request_type_id));
3042: FND_MSG_PUB.ADD;
3043: x_return_flag := FALSE;
3044: RAISE FND_API.G_EXC_ERROR;
3045: END IF;

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

3050: -- check if the owning dept id provided is valid
3051:
3052: IF p_owning_dept_id is not null THEN
3053: IF p_owning_dept_id = FND_API.G_MISS_NUM THEN
3054: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
3055: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_owning_dept_id');
3056: FND_MSG_PUB.ADD;
3057: x_return_flag := FALSE;
3058: RAISE FND_API.G_EXC_ERROR;

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

3051:
3052: IF p_owning_dept_id is not null THEN
3053: IF p_owning_dept_id = FND_API.G_MISS_NUM THEN
3054: FND_MESSAGE.SET_NAME('WIP', 'WIP_ATTRIBUTE_REQUIRED');
3055: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'p_owning_dept_id');
3056: FND_MSG_PUB.ADD;
3057: x_return_flag := FALSE;
3058: RAISE FND_API.G_EXC_ERROR;
3059: ELSIF validate_department(p_org_id,p_owning_dept_id) = FALSE then

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

3056: FND_MSG_PUB.ADD;
3057: x_return_flag := FALSE;
3058: RAISE FND_API.G_EXC_ERROR;
3059: ELSIF validate_department(p_org_id,p_owning_dept_id) = FALSE then
3060: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3061: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Owning Dept. Id: ' || to_char(p_priority_id));
3062: FND_MSG_PUB.ADD;
3063: x_return_flag := FALSE;
3064: RAISE FND_API.G_EXC_ERROR;

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

3057: x_return_flag := FALSE;
3058: RAISE FND_API.G_EXC_ERROR;
3059: ELSIF validate_department(p_org_id,p_owning_dept_id) = FALSE then
3060: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3061: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Owning Dept. Id: ' || to_char(p_priority_id));
3062: FND_MSG_PUB.ADD;
3063: x_return_flag := FALSE;
3064: RAISE FND_API.G_EXC_ERROR;
3065: END IF;

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

3067:
3068: -- check the created for field
3069: if p_created_for is not null then
3070: if validate_user_id(p_created_for) = FALSE then
3071: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_CREATED_FOR');
3072: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Created For: ' || p_created_for);
3073: FND_MSG_PUB.ADD;
3074: x_return_flag := FALSE;
3075: RAISE FND_API.G_EXC_ERROR;

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

3068: -- check the created for field
3069: if p_created_for is not null then
3070: if validate_user_id(p_created_for) = FALSE then
3071: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_CREATED_FOR');
3072: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Created For: ' || p_created_for);
3073: FND_MSG_PUB.ADD;
3074: x_return_flag := FALSE;
3075: RAISE FND_API.G_EXC_ERROR;
3076: end if;

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

3078:
3079: -- check contact preference
3080: IF p_contact_preference is not null then
3081: if validate_lookup(p_contact_preference,'WIP_EAM_CONTACT_PREFERENCE') = FALSE then
3082: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3083: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Contact Preference: ' || to_char(p_contact_preference));
3084: FND_MSG_PUB.ADD;
3085: x_return_flag := FALSE;
3086: RAISE FND_API.G_EXC_ERROR;

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

3079: -- check contact preference
3080: IF p_contact_preference is not null then
3081: if validate_lookup(p_contact_preference,'WIP_EAM_CONTACT_PREFERENCE') = FALSE then
3082: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3083: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Contact Preference: ' || to_char(p_contact_preference));
3084: FND_MSG_PUB.ADD;
3085: x_return_flag := FALSE;
3086: RAISE FND_API.G_EXC_ERROR;
3087: end if;

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

3090:
3091: -- check notify originator
3092: IF p_notify_originator is not null then
3093: if validate_lookup(p_notify_originator,'SYS_YES_NO') = FALSE then
3094: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3095: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Notify Originator: ' || to_char(p_notify_originator));
3096: FND_MSG_PUB.ADD;
3097: x_return_flag := FALSE;
3098: RAISE FND_API.G_EXC_ERROR;

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

3091: -- check notify originator
3092: IF p_notify_originator is not null then
3093: if validate_lookup(p_notify_originator,'SYS_YES_NO') = FALSE then
3094: FND_MESSAGE.SET_NAME('WIP', 'WIP_INVALID_ATTRIBUTE');
3095: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Notify Originator: ' || to_char(p_notify_originator));
3096: FND_MSG_PUB.ADD;
3097: x_return_flag := FALSE;
3098: RAISE FND_API.G_EXC_ERROR;
3099: end if;

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

3123: ,x_error_segments => l_x_error_segments
3124: ,x_error_message => l_x_error_message
3125: )
3126: ) = FALSE then
3127: FND_MESSAGE.SET_NAME('WIP','WIP_INVALID_ATTRIBUTE');
3128: FND_MSG_PUB.ADD;
3129: RAISE FND_API.G_EXC_ERROR;
3130:
3131: end if;