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

Line 79: Fnd_Message.SET_NAME('AHL','AHL_VWP_SPACE_ST_END_DT_MND');

75: IF p_space_assign_rec.START_FROM is NULL THEN
76: IF p_space_assign_rec.END_TO is NULL THEN -- No need to validate, since both dates are null
77: RETURN;
78: ELSE -- Raise error, If one among the space start from and end to is entered, the other is mandatory.
79: Fnd_Message.SET_NAME('AHL','AHL_VWP_SPACE_ST_END_DT_MND');
80: Fnd_message.SET_TOKEN( 'SPACE_NAME', p_space_assign_rec.SPACE_NAME );-- PRAKKUM :: 02/06/2011 :: VWPE :: Added token
81: Fnd_Msg_Pub.ADD;
82: RAISE Fnd_Api.G_EXC_ERROR;
83: END IF; /* end to null comparison */

Line 80: Fnd_message.SET_TOKEN( 'SPACE_NAME', p_space_assign_rec.SPACE_NAME );-- PRAKKUM :: 02/06/2011 :: VWPE :: Added token

76: IF p_space_assign_rec.END_TO is NULL THEN -- No need to validate, since both dates are null
77: RETURN;
78: ELSE -- Raise error, If one among the space start from and end to is entered, the other is mandatory.
79: Fnd_Message.SET_NAME('AHL','AHL_VWP_SPACE_ST_END_DT_MND');
80: Fnd_message.SET_TOKEN( 'SPACE_NAME', p_space_assign_rec.SPACE_NAME );-- PRAKKUM :: 02/06/2011 :: VWPE :: Added token
81: Fnd_Msg_Pub.ADD;
82: RAISE Fnd_Api.G_EXC_ERROR;
83: END IF; /* end to null comparison */
84: ELSE

Line 86: Fnd_Message.SET_NAME('AHL','AHL_VWP_SPACE_ST_END_DT_MND');

82: RAISE Fnd_Api.G_EXC_ERROR;
83: END IF; /* end to null comparison */
84: ELSE
85: IF p_space_assign_rec.END_TO is NULL THEN -- Raise error, If one among the space start from and end to is entered, the other is mandatory.
86: Fnd_Message.SET_NAME('AHL','AHL_VWP_SPACE_ST_END_DT_MND');
87: Fnd_message.SET_TOKEN( 'SPACE_NAME', p_space_assign_rec.SPACE_NAME );-- PRAKKUM :: 02/06/2011 :: VWPE :: Added token
88: Fnd_Msg_Pub.ADD;
89: RAISE Fnd_Api.G_EXC_ERROR;
90: ELSE -- Both dates are not null

Line 87: Fnd_message.SET_TOKEN( 'SPACE_NAME', p_space_assign_rec.SPACE_NAME );-- PRAKKUM :: 02/06/2011 :: VWPE :: Added token

83: END IF; /* end to null comparison */
84: ELSE
85: IF p_space_assign_rec.END_TO is NULL THEN -- Raise error, If one among the space start from and end to is entered, the other is mandatory.
86: Fnd_Message.SET_NAME('AHL','AHL_VWP_SPACE_ST_END_DT_MND');
87: Fnd_message.SET_TOKEN( 'SPACE_NAME', p_space_assign_rec.SPACE_NAME );-- PRAKKUM :: 02/06/2011 :: VWPE :: Added token
88: Fnd_Msg_Pub.ADD;
89: RAISE Fnd_Api.G_EXC_ERROR;
90: ELSE -- Both dates are not null
91:

Line 93: Fnd_Message.SET_NAME('AHL','AHL_VWP_SPACE_ST_DT_GT_END_DT');

89: RAISE Fnd_Api.G_EXC_ERROR;
90: ELSE -- Both dates are not null
91:
92: IF ( p_space_assign_rec.START_FROM > p_space_assign_rec.END_TO ) THEN -- Start_from > End_To
93: Fnd_Message.SET_NAME('AHL','AHL_VWP_SPACE_ST_DT_GT_END_DT');
94: Fnd_message.SET_TOKEN( 'SPACE_NAME', p_space_assign_rec.SPACE_NAME );-- PRAKKUM :: 02/06/2011 :: VWPE :: Added token
95: Fnd_Msg_Pub.ADD;
96: RAISE Fnd_Api.G_EXC_ERROR;
97: END IF; /* start from and end to comparision */

Line 94: Fnd_message.SET_TOKEN( 'SPACE_NAME', p_space_assign_rec.SPACE_NAME );-- PRAKKUM :: 02/06/2011 :: VWPE :: Added token

90: ELSE -- Both dates are not null
91:
92: IF ( p_space_assign_rec.START_FROM > p_space_assign_rec.END_TO ) THEN -- Start_from > End_To
93: Fnd_Message.SET_NAME('AHL','AHL_VWP_SPACE_ST_DT_GT_END_DT');
94: Fnd_message.SET_TOKEN( 'SPACE_NAME', p_space_assign_rec.SPACE_NAME );-- PRAKKUM :: 02/06/2011 :: VWPE :: Added token
95: Fnd_Msg_Pub.ADD;
96: RAISE Fnd_Api.G_EXC_ERROR;
97: END IF; /* start from and end to comparision */
98:

Line 105: Fnd_Message.SET_NAME('AHL','AHL_VWP_SPACE_ST_DATE_INVLD');

101: FETCH validate_with_visit_dets INTO l_visit_dets_rec;
102: IF validate_with_visit_dets%FOUND THEN
103: l_isValidationFailed := false;
104: IF ( l_visit_dets_rec.START_DATE IS NOT NULL AND p_space_assign_rec.START_FROM < l_visit_dets_rec.START_DATE ) THEN -- Validation failed
105: Fnd_Message.SET_NAME('AHL','AHL_VWP_SPACE_ST_DATE_INVLD');
106: Fnd_message.SET_TOKEN( 'SPACE_NAME', p_space_assign_rec.SPACE_NAME );-- PRAKKUM :: 02/06/2011 :: VWPE :: Added token
107: Fnd_Msg_Pub.ADD;
108: l_isValidationFailed := true;
109: END IF;

Line 106: Fnd_message.SET_TOKEN( 'SPACE_NAME', p_space_assign_rec.SPACE_NAME );-- PRAKKUM :: 02/06/2011 :: VWPE :: Added token

102: IF validate_with_visit_dets%FOUND THEN
103: l_isValidationFailed := false;
104: IF ( l_visit_dets_rec.START_DATE IS NOT NULL AND p_space_assign_rec.START_FROM < l_visit_dets_rec.START_DATE ) THEN -- Validation failed
105: Fnd_Message.SET_NAME('AHL','AHL_VWP_SPACE_ST_DATE_INVLD');
106: Fnd_message.SET_TOKEN( 'SPACE_NAME', p_space_assign_rec.SPACE_NAME );-- PRAKKUM :: 02/06/2011 :: VWPE :: Added token
107: Fnd_Msg_Pub.ADD;
108: l_isValidationFailed := true;
109: END IF;
110:

Line 112: Fnd_Message.SET_NAME('AHL','AHL_VWP_SPACE_END_DATE_INVLD');

108: l_isValidationFailed := true;
109: END IF;
110:
111: IF ( l_visit_dets_rec.PLANNED_END_DATE IS NOT NULL AND p_space_assign_rec.END_TO > l_visit_dets_rec.PLANNED_END_DATE ) THEN -- Validation failed
112: Fnd_Message.SET_NAME('AHL','AHL_VWP_SPACE_END_DATE_INVLD');
113: Fnd_message.SET_TOKEN( 'SPACE_NAME', p_space_assign_rec.SPACE_NAME );-- PRAKKUM :: 02/06/2011 :: VWPE :: Added token
114: Fnd_Msg_Pub.ADD;
115: l_isValidationFailed := true;
116: END IF;

Line 113: Fnd_message.SET_TOKEN( 'SPACE_NAME', p_space_assign_rec.SPACE_NAME );-- PRAKKUM :: 02/06/2011 :: VWPE :: Added token

109: END IF;
110:
111: IF ( l_visit_dets_rec.PLANNED_END_DATE IS NOT NULL AND p_space_assign_rec.END_TO > l_visit_dets_rec.PLANNED_END_DATE ) THEN -- Validation failed
112: Fnd_Message.SET_NAME('AHL','AHL_VWP_SPACE_END_DATE_INVLD');
113: Fnd_message.SET_TOKEN( 'SPACE_NAME', p_space_assign_rec.SPACE_NAME );-- PRAKKUM :: 02/06/2011 :: VWPE :: Added token
114: Fnd_Msg_Pub.ADD;
115: l_isValidationFailed := true;
116: END IF;
117: END IF;

Line 231: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_SPACE_DATES');

227:
228: FOR l_invalid_space_dates IN c_validate_space_dates(p_visit_id)
229: LOOP
230:
231: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_SPACE_DATES');
232: FND_MESSAGE.SET_TOKEN('SPACE_NAME',l_invalid_space_dates.SPACE_NAME);
233: Fnd_Msg_Pub.ADD;
234: l_isValidationFailed := true;
235:

Line 232: FND_MESSAGE.SET_TOKEN('SPACE_NAME',l_invalid_space_dates.SPACE_NAME);

228: FOR l_invalid_space_dates IN c_validate_space_dates(p_visit_id)
229: LOOP
230:
231: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_SPACE_DATES');
232: FND_MESSAGE.SET_TOKEN('SPACE_NAME',l_invalid_space_dates.SPACE_NAME);
233: Fnd_Msg_Pub.ADD;
234: l_isValidationFailed := true;
235:
236: END LOOP;

Line 597: FND_MESSAGE.set_name('AHL', 'AHL_LTP_RECORD_NOT_FOUND');

593: OPEN c_space_assign_rec;
594: FETCH c_space_assign_rec INTO l_space_assign_rec;
595: IF c_space_assign_rec%NOTFOUND THEN
596: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
597: FND_MESSAGE.set_name('AHL', 'AHL_LTP_RECORD_NOT_FOUND');
598: FND_MSG_PUB.add;
599: CLOSE c_space_assign_rec;
600: RAISE Fnd_Api.G_EXC_ERROR;
601: END IF;

Line 607: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

603: CLOSE c_space_assign_rec;
604: --Check for object version number
605: IF (l_space_assign_rec.object_version_number <> p_space_assign_rec.object_version_number)
606: THEN
607: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
608: Fnd_Msg_Pub.ADD;
609: RAISE Fnd_Api.G_EXC_ERROR;
610: END IF;
611:

Line 839: Fnd_Message.set_name('AHL', 'AHL_LTP_SPACE_ID_NOT_EXIST');

835: THEN
836: -- missing required fields
837: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
838: THEN
839: Fnd_Message.set_name('AHL', 'AHL_LTP_SPACE_ID_NOT_EXIST');
840: Fnd_Msg_Pub.ADD;
841: RAISE Fnd_Api.G_EXC_ERROR;
842: END IF;
843: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 852: Fnd_Message.set_name('AHL', 'AHL_LTP_VISIT_ID_NOT_EXIST');

848: THEN
849: -- missing required fields
850: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
851: THEN
852: Fnd_Message.set_name('AHL', 'AHL_LTP_VISIT_ID_NOT_EXIST');
853: Fnd_Msg_Pub.ADD;
854: END IF;
855: x_return_status := Fnd_Api.G_RET_STS_ERROR;
856: END IF;

Line 877: Fnd_Message.set_name('AHL', 'AHL_LTP_SP_ASSIGN_DUP_RECORD');

873: FETCH check_unique INTO l_dummy;
874: CLOSE check_unique;
875: --
876: IF l_dummy IS NOT NULL THEN
877: Fnd_Message.set_name('AHL', 'AHL_LTP_SP_ASSIGN_DUP_RECORD');
878: Fnd_Msg_Pub.ADD;
879: END IF;
880: --- Validation for visit type and inventory item
881: OPEN visit_item_cur(p_space_assign_rec.visit_id);

Line 909: Fnd_Message.set_name('AHL', 'AHL_LTP_SP_UNAVAL_PERIOD');

905: END IF;
906:
907: EXIT WHEN space_unavailable_cur%NOTFOUND;
908: IF space_unavailable_cur%FOUND THEN
909: Fnd_Message.set_name('AHL', 'AHL_LTP_SP_UNAVAL_PERIOD');
910: Fnd_message.set_token( 'PERIOD', l_start_date ||' '||'to'||' '||l_end_date );
911: Fnd_Msg_Pub.ADD;
912: END IF;
913: END LOOP;

Line 910: Fnd_message.set_token( 'PERIOD', l_start_date ||' '||'to'||' '||l_end_date );

906:
907: EXIT WHEN space_unavailable_cur%NOTFOUND;
908: IF space_unavailable_cur%FOUND THEN
909: Fnd_Message.set_name('AHL', 'AHL_LTP_SP_UNAVAL_PERIOD');
910: Fnd_message.set_token( 'PERIOD', l_start_date ||' '||'to'||' '||l_end_date );
911: Fnd_Msg_Pub.ADD;
912: END IF;
913: END LOOP;
914: CLOSE space_unavailable_cur;

Line 927: Fnd_Message.set_name('AHL', 'AHL_LTP_SP_UNAVAL_PERIOD');

923: FETCH space_available_cur INTO l_start_date,l_end_date;
924: EXIT WHEN space_available_cur%NOTFOUND;
925: IF (l_start_date_time >= l_start_date AND
926: l_start_date_time <= l_end_date) THEN
927: Fnd_Message.set_name('AHL', 'AHL_LTP_SP_UNAVAL_PERIOD');
928: Fnd_message.set_token( 'PERIOD', l_start_date ||' '||'to'||' '||l_end_date );
929: Fnd_Msg_Pub.ADD;
930: END IF;
931: END LOOP;

Line 928: Fnd_message.set_token( 'PERIOD', l_start_date ||' '||'to'||' '||l_end_date );

924: EXIT WHEN space_available_cur%NOTFOUND;
925: IF (l_start_date_time >= l_start_date AND
926: l_start_date_time <= l_end_date) THEN
927: Fnd_Message.set_name('AHL', 'AHL_LTP_SP_UNAVAL_PERIOD');
928: Fnd_message.set_token( 'PERIOD', l_start_date ||' '||'to'||' '||l_end_date );
929: Fnd_Msg_Pub.ADD;
930: END IF;
931: END LOOP;
932: CLOSE space_available_cur;

Line 941: Fnd_Message.set_name('AHL', 'AHL_LTP_VISIT_ITEM_NOT_EXIST');

937: l_visit_type_code,
938: l_inventory_item_id);
939: FETCH space_capable_cur INTO l_space_capability_id;
940: IF l_space_capability_id IS NULL THEN
941: Fnd_Message.set_name('AHL', 'AHL_LTP_VISIT_ITEM_NOT_EXIST');
942: Fnd_Msg_Pub.ADD;
943: END IF;
944: CLOSE space_capable_cur;
945:

Line 1184: Fnd_Message.SET_NAME('AHL','AHL_LTP_SPACE_NOT_EXISTS');

1180: x_error_msg_code => l_msg_data);
1181:
1182: IF NVL(l_return_status,'x') <> 'S'
1183: THEN
1184: Fnd_Message.SET_NAME('AHL','AHL_LTP_SPACE_NOT_EXISTS');
1185: Fnd_Message.SET_TOKEN('SPACEID',p_x_space_assign_rec.space_name);
1186: Fnd_Msg_Pub.ADD;
1187: END IF;
1188: END IF;

Line 1185: Fnd_Message.SET_TOKEN('SPACEID',p_x_space_assign_rec.space_name);

1181:
1182: IF NVL(l_return_status,'x') <> 'S'
1183: THEN
1184: Fnd_Message.SET_NAME('AHL','AHL_LTP_SPACE_NOT_EXISTS');
1185: Fnd_Message.SET_TOKEN('SPACEID',p_x_space_assign_rec.space_name);
1186: Fnd_Msg_Pub.ADD;
1187: END IF;
1188: END IF;
1189: --Assign the returned value

Line 1207: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_ID_NOT_EXIST');

1203: x_error_msg_code => l_msg_data);
1204:
1205: IF NVL(l_return_status,'x') <> 'S'
1206: THEN
1207: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_ID_NOT_EXIST');
1208: Fnd_Msg_Pub.ADD;
1209: RAISE Fnd_Api.G_EXC_ERROR;
1210: END IF;
1211: END IF;

Line 1289: Fnd_Message.SET_NAME('AHL','AHL_LTP_SEQUENCE_NOT_EXISTS');

1285:
1286: END IF;
1287:
1288: IF l_space_assignment_id IS NULL THEN
1289: Fnd_Message.SET_NAME('AHL','AHL_LTP_SEQUENCE_NOT_EXISTS');
1290: Fnd_Msg_Pub.ADD;
1291: RAISE Fnd_Api.G_EXC_ERROR;
1292: END IF;
1293:

Line 1303: Fnd_Message.SET_NAME('AHL','AHL_LTP_SEQUENCE_NOT_EXISTS');

1299: -- If the value for the ID already exists, then
1300: -- l_dummy would be populated with '1', otherwise,
1301: -- it receives NULL.
1302: IF l_dummy IS NOT NULL THEN
1303: Fnd_Message.SET_NAME('AHL','AHL_LTP_SEQUENCE_NOT_EXISTS');
1304: Fnd_Msg_Pub.ADD;
1305: END IF;
1306:
1307: -- PRAKKUM :: VWPE :: ER 12424063 :: 22-FEB-2011 :: END :: Changes to handle seq from page

Line 1655: Fnd_Message.SET_NAME('AHL','AHL_LTP_SPACE_NOT_EXISTS');

1651: x_error_msg_code => l_msg_data);
1652:
1653: IF NVL(l_return_status,'x') <> 'S'
1654: THEN
1655: Fnd_Message.SET_NAME('AHL','AHL_LTP_SPACE_NOT_EXISTS');
1656: Fnd_Message.SET_TOKEN('SPACEID',p_space_assign_rec.space_name);
1657: Fnd_Msg_Pub.ADD;
1658: END IF;
1659: END IF;

Line 1656: Fnd_Message.SET_TOKEN('SPACEID',p_space_assign_rec.space_name);

1652:
1653: IF NVL(l_return_status,'x') <> 'S'
1654: THEN
1655: Fnd_Message.SET_NAME('AHL','AHL_LTP_SPACE_NOT_EXISTS');
1656: Fnd_Message.SET_TOKEN('SPACEID',p_space_assign_rec.space_name);
1657: Fnd_Msg_Pub.ADD;
1658: END IF;
1659: END IF;
1660: --Assign the returned value

Line 1678: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_NOT_EXISTS');

1674: x_error_msg_code => l_msg_data);
1675:
1676: IF NVL(l_return_status,'x') <> 'S'
1677: THEN
1678: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_NOT_EXISTS');
1679: Fnd_Message.SET_TOKEN('VISITID',p_space_assign_rec.visit_number);
1680: Fnd_Msg_Pub.ADD;
1681: END IF;
1682: END IF;

Line 1679: Fnd_Message.SET_TOKEN('VISITID',p_space_assign_rec.visit_number);

1675:
1676: IF NVL(l_return_status,'x') <> 'S'
1677: THEN
1678: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_NOT_EXISTS');
1679: Fnd_Message.SET_TOKEN('VISITID',p_space_assign_rec.visit_number);
1680: Fnd_Msg_Pub.ADD;
1681: END IF;
1682: END IF;
1683: --Assign the returned value

Line 1983: FND_MESSAGE.set_name('AHL', 'AHL_LTP_RECORD_NOT_FOUND');

1979: FETCH c_space_assign_cur INTO l_space_assignment_id,
1980: l_object_version_number;
1981: IF c_space_assign_cur%NOTFOUND THEN
1982: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1983: FND_MESSAGE.set_name('AHL', 'AHL_LTP_RECORD_NOT_FOUND');
1984: FND_MSG_PUB.add;
1985: END IF;
1986: CLOSE c_space_assign_cur;
1987: RAISE FND_API.g_exc_error;

Line 2001: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');

1997:
1998: --Check for object version number
1999: IF l_object_version_number <> p_space_assign_rec.object_version_number
2000: THEN
2001: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
2002: FND_MSG_PUB.add;
2003: RAISE FND_API.g_exc_error;
2004: END IF;
2005: -------------------Call Table handler generated procedure------------

Line 2255: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_NOT_EXISTS');

2251: x_error_msg_code => l_msg_data);
2252:
2253: IF NVL(l_return_status,'x') <> 'S'
2254: THEN
2255: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_NOT_EXISTS');
2256: Fnd_Message.SET_TOKEN('VISITID',p_x_schedule_visit_rec.visit_number);
2257: Fnd_Msg_Pub.ADD;
2258: END IF;
2259: END IF;

Line 2256: Fnd_Message.SET_TOKEN('VISITID',p_x_schedule_visit_rec.visit_number);

2252:
2253: IF NVL(l_return_status,'x') <> 'S'
2254: THEN
2255: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_NOT_EXISTS');
2256: Fnd_Message.SET_TOKEN('VISITID',p_x_schedule_visit_rec.visit_number);
2257: Fnd_Msg_Pub.ADD;
2258: END IF;
2259: END IF;
2260:

Line 2276: Fnd_Message.SET_NAME('AHL','AHL_LTP_ORG_REQUIRED');

2272: IF ( p_x_schedule_visit_rec.org_name IS NULL OR
2273: p_x_schedule_visit_rec.org_name = FND_API.G_MISS_CHAR) THEN
2274: -- anraj: if visit is in planning Organization is not mandatory
2275: IF (l_schedule_visit_rec.status_code <> 'PLANNING') THEN
2276: Fnd_Message.SET_NAME('AHL','AHL_LTP_ORG_REQUIRED');
2277: Fnd_Msg_Pub.ADD;
2278: END IF;
2279: END IF;
2280:

Line 2289: Fnd_Message.SET_NAME('AHL','AHL_LTP_DEPT_REQUIRED');

2285: IF ( p_x_schedule_visit_rec.dept_name IS NULL OR
2286: p_x_schedule_visit_rec.dept_name = FND_API.G_MISS_CHAR) THEN
2287: -- anraj: if visit is in planning Department is not mandatory
2288: IF (l_schedule_visit_rec.status_code <> 'PLANNING') THEN
2289: Fnd_Message.SET_NAME('AHL','AHL_LTP_DEPT_REQUIRED');
2290: Fnd_Msg_Pub.ADD;
2291: END IF;
2292: END IF;
2293: --

Line 2299: Fnd_Message.SET_NAME('AHL','AHL_LTP_START_DATE_INVALID');

2295: -- Check for visit start date
2296: IF ( p_x_schedule_visit_rec.start_date IS NULL AND
2297: p_x_schedule_visit_rec.start_date = FND_API.G_MISS_DATE)
2298: THEN
2299: Fnd_Message.SET_NAME('AHL','AHL_LTP_START_DATE_INVALID');
2300: Fnd_Msg_Pub.ADD;
2301: RAISE Fnd_Api.G_EXC_ERROR;
2302: END IF;
2303: --

Line 2324: Fnd_Message.SET_NAME('AHL','AHL_LTP_SP_CATEGORY_NOT_EXIST');

2320: x_return_status => l_return_status);
2321:
2322: IF NVL(l_return_status, 'X') <> 'S'
2323: THEN
2324: Fnd_Message.SET_NAME('AHL','AHL_LTP_SP_CATEGORY_NOT_EXIST');
2325: Fnd_Msg_Pub.ADD;
2326: RAISE Fnd_Api.G_EXC_ERROR;
2327: END IF;
2328: ELSE

Line 2356: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_TYPE_NOT_EXISTS');

2352: x_return_status => l_return_status);
2353:
2354: IF NVL(l_return_status, 'X') <> 'S'
2355: THEN
2356: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_TYPE_NOT_EXISTS');
2357: Fnd_Message.SET_TOKEN('VISIT',p_x_schedule_visit_rec.visit_type_mean);
2358: Fnd_Msg_Pub.ADD;
2359: END IF;
2360: ELSE

Line 2357: Fnd_Message.SET_TOKEN('VISIT',p_x_schedule_visit_rec.visit_type_mean);

2353:
2354: IF NVL(l_return_status, 'X') <> 'S'
2355: THEN
2356: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_TYPE_NOT_EXISTS');
2357: Fnd_Message.SET_TOKEN('VISIT',p_x_schedule_visit_rec.visit_type_mean);
2358: Fnd_Msg_Pub.ADD;
2359: END IF;
2360: ELSE
2361: -- Id presents

Line 2371: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_TYPE_REQUIRED');

2367: --Commented by mpothuku on 02/25/04 as Visit type in not mandatory
2368: /*
2369: ELSIF (l_schedule_visit_rec.status_code <> 'PLANNING' )
2370: THEN
2371: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_TYPE_REQUIRED');
2372: Fnd_Msg_Pub.ADD;
2373: RAISE Fnd_Api.G_EXC_ERROR;
2374: */
2375: END IF;

Line 2381: Fnd_Message.SET_NAME('AHL','AHL_LTP_INVALID_RECORD');

2377: END IF;
2378: --
2379: IF p_x_schedule_visit_rec.object_version_number <> l_schedule_visit_rec.object_version_number
2380: THEN
2381: Fnd_Message.SET_NAME('AHL','AHL_LTP_INVALID_RECORD');
2382: Fnd_Msg_Pub.ADD;
2383: END IF;
2384:
2385: -- Check for visit status

Line 2388: Fnd_Message.SET_NAME('AHL','AHL_VISIT_NOT_PLANNED');

2384:
2385: -- Check for visit status
2386: -- anraj : Commented the following block as Impelmented/Partially Implemented visits can also be updated.
2387: /* IF (l_schedule_visit_rec.status_code <> 'PLANNING' )THEN
2388: Fnd_Message.SET_NAME('AHL','AHL_VISIT_NOT_PLANNED');
2389: Fnd_Msg_Pub.ADD;
2390: RAISE Fnd_Api.G_EXC_ERROR;
2391: END IF;
2392: */

Line 2827: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_NOT_EXISTS');

2823: x_error_msg_code => l_msg_data);
2824:
2825: IF NVL(l_return_status,'x') <> 'S'
2826: THEN
2827: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_NOT_EXISTS');
2828: Fnd_Message.SET_TOKEN('VISITID',p_x_schedule_visit_rec.visit_number);
2829: Fnd_Msg_Pub.ADD;
2830: END IF;
2831: END IF;

Line 2828: Fnd_Message.SET_TOKEN('VISITID',p_x_schedule_visit_rec.visit_number);

2824:
2825: IF NVL(l_return_status,'x') <> 'S'
2826: THEN
2827: Fnd_Message.SET_NAME('AHL','AHL_LTP_VISIT_NOT_EXISTS');
2828: Fnd_Message.SET_TOKEN('VISITID',p_x_schedule_visit_rec.visit_number);
2829: Fnd_Msg_Pub.ADD;
2830: END IF;
2831: END IF;
2832: --Assign the returned value

Line 2842: Fnd_Message.SET_NAME('AHL','AHL_LTP_INAVLID_RECORD');

2838: CLOSE c_schedule_visit_cur;
2839: --
2840: IF p_x_schedule_visit_rec.object_version_number <> l_object_version_number
2841: THEN
2842: Fnd_Message.SET_NAME('AHL','AHL_LTP_INAVLID_RECORD');
2843: Fnd_Msg_Pub.ADD;
2844: RAISE Fnd_Api.G_EXC_ERROR;
2845: END IF;
2846: -- Check for visit status

Line 2848: Fnd_Message.SET_NAME('AHL','AHL_VISIT_NOT_PLANNED');

2844: RAISE Fnd_Api.G_EXC_ERROR;
2845: END IF;
2846: -- Check for visit status
2847: IF (l_visit_status_code <> 'PLANNING' )THEN
2848: Fnd_Message.SET_NAME('AHL','AHL_VISIT_NOT_PLANNED');
2849: Fnd_Msg_Pub.ADD;
2850: RAISE Fnd_Api.G_EXC_ERROR;
2851: END IF;
2852: --

Line 2868: Fnd_Message.SET_NAME('AHL','AHL_LTP_MRP_SCHEDUl_ITEM');

2864: --Check for Item scheduled
2865: OPEN c_visit_task_matrl_cur(l_schedule_material_id);
2866: FETCH c_visit_task_matrl_cur INTO l_scheduled_date,l_scheduled_quantity;
2867: IF l_scheduled_date IS NOT NULL THEN
2868: Fnd_Message.SET_NAME('AHL','AHL_LTP_MRP_SCHEDUl_ITEM');
2869: Fnd_Msg_Pub.ADD;
2870: CLOSE c_visit_task_matrl_cur;
2871: RAISE Fnd_Api.G_EXC_ERROR;
2872: ELSE