[Home] [Help]
56:
57: IF C_Get_Task_Id%NOTFOUND THEN
58: FND_MESSAGE.SET_NAME ('JTF', 'JTF_TASK_INVALID_TASK_NUMBER');
59: FND_MESSAGE.SET_TOKEN ('P_TASK_NUMBER', P_RQH_Rec.task_number, FALSE);
60: FND_MSG_PUB.ADD;
61: RAISE EXCP_USER_DEFINED;
62: END IF;
63: CLOSE C_Get_Task_Id;
64: x_pvt_rqh_rec.task_id := l_task_id;
124: IF (l_pvt_RQH_rec.address_type IS NOT NULL
125: AND l_pvt_RQH_rec.address_type <> FND_API.G_MISS_CHAR
126: AND l_pvt_RQH_rec.address_type NOT IN ('R', 'T', 'C', 'S')) THEN
127: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_ADDRESS_TYPE');
128: FND_MSG_PUB.ADD;
129: RAISE EXCP_USER_DEFINED;
130: END IF;
131: IF (l_pvt_RQH_Rec.ship_to_location_id IS NOT NULL
132: AND l_pvt_RQH_rec.ship_to_location_id <> FND_API.G_MISS_NUM) THEN
136: FROM hr_locations
137: WHERE location_id = l_pvt_RQH_Rec.ship_to_location_id;
138: IF (l_count <= 0) THEN
139: FND_MESSAGE.SET_NAME ('PAY', 'HR_52034_DPF_LOCATION_EXIST');
140: FND_MSG_PUB.ADD;
141: RAISE EXCP_USER_DEFINED;
142: END IF;
143: EXCEPTION
144: when no_Data_found then
154: WHERE task_id = l_pvt_RQH_Rec.task_id;
155: IF (l_count <= 0) THEN
156: FND_MESSAGE.SET_NAME ('JTF', 'JTF_TASK_INVALID_TASK_ID');
157: FND_MESSAGE.SET_TOKEN ('P_TASK_ID', l_pvt_RQH_rec.task_id, FALSE);
158: FND_MSG_PUB.ADD;
159: RAISE EXCP_USER_DEFINED;
160: END IF;
161: EXCEPTION
162: when no_Data_found then
172: WHERE task_assignment_id = l_pvt_RQH_Rec.task_assignment_id;
173: IF (l_count <= 0) THEN
174: FND_MESSAGE.SET_NAME ('JTF', 'JTF_TASK_INV_TK_ASS');
175: FND_MESSAGE.SET_TOKEN ('P_TASK_ASSIGNMENT_ID', l_pvt_RQH_rec.task_assignment_id, FALSE);
176: FND_MSG_PUB.ADD;
177: RAISE EXCP_USER_DEFINED;
178: END IF;
179: EXCEPTION
180: when no_Data_found then
194: AND jou.object_user_code = 'RESOURCES'
195: AND jov.object_code = l_pvt_RQH_rec.resource_type;
196: IF (l_count <= 0) THEN
197: FND_MESSAGE.SET_NAME ('JTF', 'JTF_AM_INVALID_RESOURCE_TYPE');
198: FND_MSG_PUB.ADD;
199: RAISE EXCP_USER_DEFINED;
200: END IF;
201: EXCEPTION
202: when no_Data_found then
214: trunc(end_date_active) >= trunc(sysdate));
215: IF (l_count <= 0) THEN
216: FND_MESSAGE.SET_NAME ('JTF', 'JTF_TASK_INV_RES_ID');
217: FND_MESSAGE.SET_TOKEN ('P_RESOURCE_ID', l_pvt_RQH_rec.resource_id, FALSE);
218: FND_MSG_PUB.ADD;
219: RAISE EXCP_USER_DEFINED;
220: END IF;
221: EXCEPTION
222: when no_Data_found then
232: WHERE organization_id = l_pvt_RQH_rec.destination_organization_id;
233: IF (l_count <= 0) THEN
234: FND_MESSAGE.SET_NAME ('INV', 'INV_ENTER_VALID_TOORG');
235: --FND_MESSAGE.SET_TOKEN ('PARAMETER', 'DESTINATION_ORGANIZATION', FALSE);
236: FND_MSG_PUB.ADD;
237: RAISE EXCP_USER_DEFINED;
238: END IF;
239: EXCEPTION
240: when no_Data_found then
252: IF (l_count <= 0) THEN
253: FND_MESSAGE.SET_NAME ('INV', 'INV-NO SUBINVENTORY RECORD');
254: FND_MESSAGE.SET_TOKEN ('SUBINV', l_pvt_RQH_rec.destination_subinventory, FALSE);
255: FND_MESSAGE.SET_TOKEN ('ORG', l_pvt_RQH_rec.destination_organization_id, FALSE);
256: FND_MSG_PUB.ADD;
257: RAISE EXCP_USER_DEFINED;
258: END IF;
259: EXCEPTION
260: when no_Data_found then
264: IF (l_pvt_RQH_Rec.need_by_date IS NOT NULL
265: AND l_pvt_RQH_rec.need_by_date <> FND_API.G_MISS_DATE
266: AND trunc(l_pvt_RQH_rec.need_By_date) < trunc(sysdate)) THEN
267: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_NEED_BY_DATE');
268: FND_MSG_PUB.ADD;
269: RAISE EXCP_USER_DEFINED;
270: END IF;
271: END;
272:
303:
304: -- Initialize message list if p_init_msg_list is set to TRUE.
305: IF FND_API.to_Boolean( p_init_msg_list )
306: THEN
307: FND_MSG_PUB.initialize;
308: END IF;
309:
310:
311: -- Debug Message
308: END IF;
309:
310:
311: -- Debug Message
312: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
313:
314:
315: -- Initialize API return status to SUCCESS
316: x_return_status := FND_API.G_RET_STS_SUCCESS;
319: -- API body
320: --
321:
322: -- Debug Message
323: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_RQH_Values_To_Ids');
324:
325: -- Convert the values to ids
326: --
327: Convert_RQH_Values_To_Ids (
363: END IF;
364:
365:
366: -- Debug Message
367: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
368:
369:
370: -- Standard call to get message count and if count is 1, get message info.
371: FND_MSG_PUB.Count_And_Get
367: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
368:
369:
370: -- Standard call to get message count and if count is 1, get message info.
371: FND_MSG_PUB.Count_And_Get
372: ( p_count => x_msg_count,
373: p_data => x_msg_data
374: );
375:
377: WHEN FND_API.G_EXC_ERROR THEN
378: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
379: P_API_NAME => L_API_NAME
380: ,P_PKG_NAME => G_PKG_NAME
381: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
382: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
383: ,X_MSG_COUNT => X_MSG_COUNT
384: ,X_MSG_DATA => X_MSG_DATA
385: ,X_RETURN_STATUS => X_RETURN_STATUS);
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
389: P_API_NAME => L_API_NAME
390: ,P_PKG_NAME => G_PKG_NAME
391: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
392: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
393: ,X_MSG_COUNT => X_MSG_COUNT
394: ,X_MSG_DATA => X_MSG_DATA
395: ,X_RETURN_STATUS => X_RETURN_STATUS);
437:
438: -- Initialize message list if p_init_msg_list is set to TRUE.
439: IF FND_API.to_Boolean( p_init_msg_list )
440: THEN
441: FND_MSG_PUB.initialize;
442: END IF;
443:
444: -- Initialize API return status to SUCCESS
445: x_return_status := FND_API.G_RET_STS_SUCCESS;
487: END IF;
488:
489:
490: -- Debug Message
491: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
492:
493:
494: -- Standard call to get message count and if count is 1, get message info.
495: FND_MSG_PUB.Count_And_Get
491: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
492:
493:
494: -- Standard call to get message count and if count is 1, get message info.
495: FND_MSG_PUB.Count_And_Get
496: ( p_count => x_msg_count,
497: p_data => x_msg_data
498: );
499:
501: WHEN FND_API.G_EXC_ERROR THEN
502: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
503: P_API_NAME => L_API_NAME
504: ,P_PKG_NAME => G_PKG_NAME
505: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
506: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
507: ,X_MSG_COUNT => X_MSG_COUNT
508: ,X_MSG_DATA => X_MSG_DATA
509: ,X_RETURN_STATUS => X_RETURN_STATUS);
511: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
512: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
513: P_API_NAME => L_API_NAME
514: ,P_PKG_NAME => G_PKG_NAME
515: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
516: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
517: ,X_MSG_COUNT => X_MSG_COUNT
518: ,X_MSG_DATA => X_MSG_DATA
519: ,X_RETURN_STATUS => X_RETURN_STATUS);
610:
611: -- Initialize message list if p_init_msg_list is set to TRUE.
612: IF FND_API.to_Boolean( p_init_msg_list )
613: THEN
614: FND_MSG_PUB.initialize;
615: END IF;
616:
617:
618: -- Debug Message
615: END IF;
616:
617:
618: -- Debug Message
619: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
620:
621:
622: -- Initialize API return status to SUCCESS
623: x_return_status := FND_API.G_RET_STS_SUCCESS;
626: -- API body
627: --
628:
629: -- Debug Message
630: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_RQH_Values_To_Ids');
631:
632: -- Convert the values to ids
633: --
634: Convert_RQH_Values_To_Ids (
692: COMMIT WORK;
693: END IF;
694:
695: -- Debug Message
696: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
697:
698: -- Standard call to get message count and if count is 1, get message info.
699: FND_MSG_PUB.Count_And_Get
700: ( p_count => x_msg_count,
695: -- Debug Message
696: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
697:
698: -- Standard call to get message count and if count is 1, get message info.
699: FND_MSG_PUB.Count_And_Get
700: ( p_count => x_msg_count,
701: p_data => x_msg_data
702: );
703:
705: WHEN FND_API.G_EXC_ERROR THEN
706: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
707: P_API_NAME => L_API_NAME
708: ,P_PKG_NAME => G_PKG_NAME
709: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
710: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
711: ,X_MSG_COUNT => X_MSG_COUNT
712: ,X_MSG_DATA => X_MSG_DATA
713: ,X_RETURN_STATUS => X_RETURN_STATUS);
715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
716: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
717: P_API_NAME => L_API_NAME
718: ,P_PKG_NAME => G_PKG_NAME
719: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
720: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
721: ,X_MSG_COUNT => X_MSG_COUNT
722: ,X_MSG_DATA => X_MSG_DATA
723: ,X_RETURN_STATUS => X_RETURN_STATUS);