DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_LINES_PUB dependencies on FND_MESSAGE

Line 98: FND_MESSAGE.SET_NAME ('INV', 'INV_INVALID_ITEM');

94: THEN
95: OPEN C_Get_Item_Id;
96: FETCH C_Get_Item_Id INTO l_inventory_item_id;
97: IF C_Get_Item_Id%NOTFOUND THEN
98: FND_MESSAGE.SET_NAME ('INV', 'INV_INVALID_ITEM');
99: FND_MSG_PUB.ADD;
100: RAISE EXCP_USER_DEFINED;
101: END IF;
102: CLOSE C_Get_Item_Id;

Line 175: fnd_message.set_name('CSP', 'CSP_INVALID_RQMT_HEADER');

171: INTO l_count
172: FROM csp_requirement_headers
173: WHERE requirement_header_id = l_pvt_RQL_Tbl(I).requirement_header_id;
174: IF (l_count <= 0) THEN
175: fnd_message.set_name('CSP', 'CSP_INVALID_RQMT_HEADER');
176: fnd_message.set_token('HEADER_ID', to_char(l_pvt_RQL_Tbl(I).requirement_header_id), FALSE);
177: FND_MSG_PUB.ADD;
178: RAISE EXCP_USER_DEFINED;
179: END IF;

Line 176: fnd_message.set_token('HEADER_ID', to_char(l_pvt_RQL_Tbl(I).requirement_header_id), FALSE);

172: FROM csp_requirement_headers
173: WHERE requirement_header_id = l_pvt_RQL_Tbl(I).requirement_header_id;
174: IF (l_count <= 0) THEN
175: fnd_message.set_name('CSP', 'CSP_INVALID_RQMT_HEADER');
176: fnd_message.set_token('HEADER_ID', to_char(l_pvt_RQL_Tbl(I).requirement_header_id), FALSE);
177: FND_MSG_PUB.ADD;
178: RAISE EXCP_USER_DEFINED;
179: END IF;
180: EXCEPTION

Line 193: FND_MESSAGE.SET_NAME ('INV', 'INV_INVALID_ITEM');

189: INTO l_count
190: FROM mtl_system_items_b
191: WHERE inventory_item_id = l_pvt_RQL_Tbl(I).inventory_item_id;
192: IF (l_count <= 0) THEN
193: FND_MESSAGE.SET_NAME ('INV', 'INV_INVALID_ITEM');
194: FND_MSG_PUB.ADD;
195: RAISE EXCP_USER_DEFINED;
196: END IF;
197: EXCEPTION

Line 210: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_SOURCE_ORG_ID');

206: INTO l_count
207: FROM mtl_parameters
208: WHERE organization_id = l_pvt_RQL_Tbl(I).source_organization_id;
209: IF (l_count <= 0) THEN
210: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_SOURCE_ORG_ID');
211: --FND_MESSAGE.SET_TOKEN ('PARAMETER', 'SOURCE_ORGANIZATION', FALSE);
212: FND_MSG_PUB.ADD;
213: RAISE EXCP_USER_DEFINED;
214: END IF;

Line 211: --FND_MESSAGE.SET_TOKEN ('PARAMETER', 'SOURCE_ORGANIZATION', FALSE);

207: FROM mtl_parameters
208: WHERE organization_id = l_pvt_RQL_Tbl(I).source_organization_id;
209: IF (l_count <= 0) THEN
210: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_SOURCE_ORG_ID');
211: --FND_MESSAGE.SET_TOKEN ('PARAMETER', 'SOURCE_ORGANIZATION', FALSE);
212: FND_MSG_PUB.ADD;
213: RAISE EXCP_USER_DEFINED;
214: END IF;
215: EXCEPTION

Line 231: FND_MESSAGE.SET_NAME ('WSH', 'WSH_OI_INVALID_UOM');

227: AND organization_id =
228: decode(nvl(l_pvt_RQL_Tbl(I).source_organization_id, FND_API.G_MISS_NUM), FND_API.G_MISS_NUM, organization_id, l_pvt_RQL_Tbl(I).source_organization_id)
229: AND uom_code = l_pvt_RQL_Tbl(I).uom_code;
230: IF (l_count <= 0) THEN
231: FND_MESSAGE.SET_NAME ('WSH', 'WSH_OI_INVALID_UOM');
232: FND_MSG_PUB.ADD;
233: RAISE EXCP_USER_DEFINED;
234: END IF;
235: EXCEPTION

Line 251: FND_MESSAGE.SET_NAME ('INV', 'INV_INT_REVCODE');

247: AND organization_id =
248: decode(nvl(l_pvt_RQL_Tbl(I).source_organization_id, FND_API.G_MISS_NUM), FND_API.G_MISS_NUM, organization_id, l_pvt_RQL_Tbl(I).source_organization_id)
249: AND revision = l_pvt_RQL_Tbl(I).revision;
250: IF (l_count <= 0) THEN
251: FND_MESSAGE.SET_NAME ('INV', 'INV_INT_REVCODE');
252: FND_MSG_PUB.ADD;
253: RAISE EXCP_USER_DEFINED;
254: END IF;
255: EXCEPTION

Line 642: FND_MESSAGE.SET_NAME ('CSP', 'CSP_RQMT_LINE_DELETE_ERROR');

638: FROM csp_Req_line_details
639: where requirement_line_id = P_RQL_Tbl(I).requirement_line_id;
640:
641: IF l_count > 0 THEN
642: FND_MESSAGE.SET_NAME ('CSP', 'CSP_RQMT_LINE_DELETE_ERROR');
643: FND_MESSAGE.SET_TOKEN ('PARAMETER', P_RQL_Tbl(I).requirement_line_id, FALSE);
644: FND_MSG_PUB.ADD;
645: RAISE EXCP_USER_DEFINED;
646: END IF;

Line 643: FND_MESSAGE.SET_TOKEN ('PARAMETER', P_RQL_Tbl(I).requirement_line_id, FALSE);

639: where requirement_line_id = P_RQL_Tbl(I).requirement_line_id;
640:
641: IF l_count > 0 THEN
642: FND_MESSAGE.SET_NAME ('CSP', 'CSP_RQMT_LINE_DELETE_ERROR');
643: FND_MESSAGE.SET_TOKEN ('PARAMETER', P_RQL_Tbl(I).requirement_line_id, FALSE);
644: FND_MSG_PUB.ADD;
645: RAISE EXCP_USER_DEFINED;
646: END IF;
647: EXCEPTION