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_OSP_SERV_ITEM_RELS_PVT dependencies on FND_API

Line 31: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE

27: -- Parameters :
28: --
29: -- Standard IN Parameters :
30: -- p_api_version IN NUMBER Default 1.0
31: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
32: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
33: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
34: -- Standard OUT Parameters :
35: -- x_return_status OUT NOCOPY VARCHAR2 Required

Line 32: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

28: --
29: -- Standard IN Parameters :
30: -- p_api_version IN NUMBER Default 1.0
31: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
32: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
33: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
34: -- Standard OUT Parameters :
35: -- x_return_status OUT NOCOPY VARCHAR2 Required
36: -- x_msg_count OUT NOCOPY NUMBER Required

Line 33: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

29: -- Standard IN Parameters :
30: -- p_api_version IN NUMBER Default 1.0
31: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
32: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
33: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
34: -- Standard OUT Parameters :
35: -- x_return_status OUT NOCOPY VARCHAR2 Required
36: -- x_msg_count OUT NOCOPY NUMBER Required
37: -- x_msg_data OUT NOCOPY VARCHAR2 Required

Line 51: * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE

47: -- End of Comments.
48: /*#
49: * This procedure is used to process a Shipment order related to an OSP Order.
50: * @param p_api_version API Version Number
51: * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
52: * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
53: * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
54: * @param p_module_type Module type of the caller
55: * @param p_x_header_rec Contains the attributes of the Shipment header, of type AHL_OSP_SHIPMENT_PUB.Ship_Header_Rec_Type

Line 52: * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE

48: /*#
49: * This procedure is used to process a Shipment order related to an OSP Order.
50: * @param p_api_version API Version Number
51: * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
52: * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
53: * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
54: * @param p_module_type Module type of the caller
55: * @param p_x_header_rec Contains the attributes of the Shipment header, of type AHL_OSP_SHIPMENT_PUB.Ship_Header_Rec_Type
56: * @param x_return_status return status

Line 53: * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL

49: * This procedure is used to process a Shipment order related to an OSP Order.
50: * @param p_api_version API Version Number
51: * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
52: * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
53: * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
54: * @param p_module_type Module type of the caller
55: * @param p_x_header_rec Contains the attributes of the Shipment header, of type AHL_OSP_SHIPMENT_PUB.Ship_Header_Rec_Type
56: * @param x_return_status return status
57: * @param x_msg_count return message count

Line 65: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

61: * @rep:displayname Process Inv Item Service Item Relations
62: */
63: PROCEDURE PROCESS_SERV_ITM_RELS (
64: p_api_version IN NUMBER := 1.0,
65: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
66: p_commit IN VARCHAR2 := FND_API.G_FALSE,
67: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68: p_module_type IN VARCHAR2 := NULL,
69: p_x_Inv_serv_item_rec IN OUT NOCOPY AHL_OSP_SERV_ITEM_RELS_PVT.Inv_Serv_Item_Rels_Rec_Type,

Line 66: p_commit IN VARCHAR2 := FND_API.G_FALSE,

62: */
63: PROCEDURE PROCESS_SERV_ITM_RELS (
64: p_api_version IN NUMBER := 1.0,
65: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
66: p_commit IN VARCHAR2 := FND_API.G_FALSE,
67: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68: p_module_type IN VARCHAR2 := NULL,
69: p_x_Inv_serv_item_rec IN OUT NOCOPY AHL_OSP_SERV_ITEM_RELS_PVT.Inv_Serv_Item_Rels_Rec_Type,
70: x_return_status OUT NOCOPY VARCHAR2,

Line 67: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

63: PROCEDURE PROCESS_SERV_ITM_RELS (
64: p_api_version IN NUMBER := 1.0,
65: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
66: p_commit IN VARCHAR2 := FND_API.G_FALSE,
67: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68: p_module_type IN VARCHAR2 := NULL,
69: p_x_Inv_serv_item_rec IN OUT NOCOPY AHL_OSP_SERV_ITEM_RELS_PVT.Inv_Serv_Item_Rels_Rec_Type,
70: x_return_status OUT NOCOPY VARCHAR2,
71: x_msg_count OUT NOCOPY NUMBER,

Line 221: x_return_status := FND_API.G_RET_STS_SUCCESS;

217: -- Standard start of API savepoint
218: SAVEPOINT process_serv_items_pvt;
219:
220: -- Initialize API return status to success
221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222:
223: -- Standard call to check for call compatibility
224: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
225: G_PKG_NAME) THEN

Line 224: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

220: -- Initialize API return status to success
221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222:
223: -- Standard call to check for call compatibility
224: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
225: G_PKG_NAME) THEN
226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
227: END IF;
228:

Line 226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

222:
223: -- Standard call to check for call compatibility
224: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
225: G_PKG_NAME) THEN
226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
227: END IF;
228:
229: -- Initialize message list if p_init_msg_list is set to TRUE
230: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 230: IF FND_API.To_Boolean(p_init_msg_list) THEN

226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
227: END IF;
228:
229: -- Initialize message list if p_init_msg_list is set to TRUE
230: IF FND_API.To_Boolean(p_init_msg_list) THEN
231: FND_MSG_PUB.Initialize;
232: END IF;
233:
234: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 244: RAISE Fnd_Api.g_exc_error;

240: FND_MSG_PUB.ADD;
241: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
242: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
243: END IF;
244: RAISE Fnd_Api.g_exc_error;
245: END IF;
246:
247: IF p_x_Inv_serv_item_rec.operation_flag = 'C' THEN
248:

Line 250: p_x_Inv_serv_item_rec.inv_org_id = FND_API.G_MISS_NUM) AND

246:
247: IF p_x_Inv_serv_item_rec.operation_flag = 'C' THEN
248:
249: IF (p_x_Inv_serv_item_rec.inv_org_id IS NULL OR
250: p_x_Inv_serv_item_rec.inv_org_id = FND_API.G_MISS_NUM) AND
251: (p_x_Inv_serv_item_rec.inv_org_name IS NULL OR
252: p_x_Inv_serv_item_rec.inv_org_name = FND_API.G_MISS_CHAR) THEN
253: FND_MESSAGE.set_name('AHL', 'AHL_OSP_ORG_NAME_NULL');
254: FND_MSG_PUB.ADD;

Line 252: p_x_Inv_serv_item_rec.inv_org_name = FND_API.G_MISS_CHAR) THEN

248:
249: IF (p_x_Inv_serv_item_rec.inv_org_id IS NULL OR
250: p_x_Inv_serv_item_rec.inv_org_id = FND_API.G_MISS_NUM) AND
251: (p_x_Inv_serv_item_rec.inv_org_name IS NULL OR
252: p_x_Inv_serv_item_rec.inv_org_name = FND_API.G_MISS_CHAR) THEN
253: FND_MESSAGE.set_name('AHL', 'AHL_OSP_ORG_NAME_NULL');
254: FND_MSG_PUB.ADD;
255: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
256: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);

Line 261: p_x_Inv_serv_item_rec.inv_item_id = FND_API.G_MISS_NUM) AND

257: END IF;
258: END IF;
259:
260: IF (p_x_Inv_serv_item_rec.inv_item_id IS NULL OR
261: p_x_Inv_serv_item_rec.inv_item_id = FND_API.G_MISS_NUM) AND
262: (p_x_Inv_serv_item_rec.inv_item_name IS NULL OR
263: p_x_Inv_serv_item_rec.inv_item_name = FND_API.G_MISS_CHAR) THEN
264: FND_MESSAGE.set_name('AHL', 'AHL_OSP_INV_ITEM_NULL');
265: FND_MSG_PUB.ADD;

Line 263: p_x_Inv_serv_item_rec.inv_item_name = FND_API.G_MISS_CHAR) THEN

259:
260: IF (p_x_Inv_serv_item_rec.inv_item_id IS NULL OR
261: p_x_Inv_serv_item_rec.inv_item_id = FND_API.G_MISS_NUM) AND
262: (p_x_Inv_serv_item_rec.inv_item_name IS NULL OR
263: p_x_Inv_serv_item_rec.inv_item_name = FND_API.G_MISS_CHAR) THEN
264: FND_MESSAGE.set_name('AHL', 'AHL_OSP_INV_ITEM_NULL');
265: FND_MSG_PUB.ADD;
266: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
267: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);

Line 272: p_x_Inv_serv_item_rec.service_item_id = FND_API.G_MISS_NUM) AND

268: END IF;
269: END IF;
270:
271: IF (p_x_Inv_serv_item_rec.service_item_id IS NULL OR
272: p_x_Inv_serv_item_rec.service_item_id = FND_API.G_MISS_NUM) AND
273: (p_x_Inv_serv_item_rec.service_item_name IS NULL OR
274: p_x_Inv_serv_item_rec.service_item_name = FND_API.G_MISS_CHAR) THEN
275: FND_MESSAGE.set_name('AHL', 'AHL_OSP_SER_ITEM_NULL');
276: FND_MSG_PUB.ADD;

Line 274: p_x_Inv_serv_item_rec.service_item_name = FND_API.G_MISS_CHAR) THEN

270:
271: IF (p_x_Inv_serv_item_rec.service_item_id IS NULL OR
272: p_x_Inv_serv_item_rec.service_item_id = FND_API.G_MISS_NUM) AND
273: (p_x_Inv_serv_item_rec.service_item_name IS NULL OR
274: p_x_Inv_serv_item_rec.service_item_name = FND_API.G_MISS_CHAR) THEN
275: FND_MESSAGE.set_name('AHL', 'AHL_OSP_SER_ITEM_NULL');
276: FND_MSG_PUB.ADD;
277: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
278: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);

Line 296: RAISE Fnd_Api.g_exc_error;

292: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
293: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
294: END IF;
295: CLOSE get_Item_info_csr;
296: RAISE Fnd_Api.g_exc_error;
297: END IF;
298: CLOSE get_Item_info_csr;
299: ELSE
300: OPEN get_Item_info_id_csr(p_x_Inv_serv_item_rec.inv_org_id,

Line 311: RAISE Fnd_Api.g_exc_error;

307: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
308: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
309: END IF;
310: CLOSE get_Item_info_id_csr;
311: RAISE Fnd_Api.g_exc_error;
312: END IF;
313: CLOSE get_Item_info_id_csr;
314:
315: END IF;

Line 339: RAISE Fnd_Api.g_exc_error;

335: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
336: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
337: END IF;
338: CLOSE get_Item_info_csr;
339: RAISE Fnd_Api.g_exc_error;
340: END IF;
341: CLOSE get_Item_info_csr;
342: ELSE
343: OPEN get_Item_info_id_csr(p_x_Inv_serv_item_rec.inv_org_id,

Line 354: RAISE Fnd_Api.g_exc_error;

350: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
351: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
352: END IF;
353: CLOSE get_Item_info_id_csr;
354: RAISE Fnd_Api.g_exc_error;
355: END IF;
356: CLOSE get_Item_info_id_csr;
357:
358: END IF;

Line 372: RAISE Fnd_Api.g_exc_error;

368: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
369: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
370: END IF;
371: CLOSE Item_Ser_rel_exists_csr;
372: RAISE Fnd_Api.g_exc_error;
373: END IF;
374: CLOSE Item_Ser_rel_exists_csr;
375:
376:

Line 384: p_x_Inv_serv_item_rec.rank = FND_API.G_MISS_NUM) THEN

380:
381: IF p_x_Inv_serv_item_rec.operation_flag <> 'D' THEN
382:
383: IF (p_x_Inv_serv_item_rec.rank IS NULL OR
384: p_x_Inv_serv_item_rec.rank = FND_API.G_MISS_NUM) THEN
385: FND_MESSAGE.set_name('AHL', 'AHL_OSP_RANK_NULL');
386: FND_MSG_PUB.ADD;
387: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);

Line 390: RAISE Fnd_Api.g_exc_error;

386: FND_MSG_PUB.ADD;
387: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
389: END IF;
390: RAISE Fnd_Api.g_exc_error;
391: ELSIF ( p_x_Inv_serv_item_rec.rank < 1 OR
392: FLOOR(p_x_Inv_serv_item_rec.rank) <> p_x_Inv_serv_item_rec.rank) THEN
393: FND_MESSAGE.set_name('AHL', 'AHL_OSP_RANK_INVALID_NUM');
394: FND_MSG_PUB.ADD;

Line 398: RAISE Fnd_Api.g_exc_error;

394: FND_MSG_PUB.ADD;
395: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
396: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
397: END IF;
398: RAISE Fnd_Api.g_exc_error;
399: END IF;
400:
401:
402: IF (p_x_Inv_serv_item_rec.active_start_date IS NULL OR

Line 403: p_x_Inv_serv_item_rec.active_start_date = FND_API.G_MISS_DATE) THEN

399: END IF;
400:
401:
402: IF (p_x_Inv_serv_item_rec.active_start_date IS NULL OR
403: p_x_Inv_serv_item_rec.active_start_date = FND_API.G_MISS_DATE) THEN
404: FND_MESSAGE.set_name('AHL', 'AHL_OSP_START_DATE_NULL');
405: FND_MSG_PUB.ADD;
406: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
407: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);

Line 438: RAISE Fnd_Api.g_exc_error;

434: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
435: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, FALSE);
436: END IF;
437: CLOSE Item_rank_exists_csr;
438: RAISE Fnd_Api.g_exc_error;
439: END IF;
440: CLOSE Item_rank_exists_csr;
441:
442:

Line 451: RAISE Fnd_Api.g_exc_error;

447:
448: IF p_x_Inv_serv_item_rec.inv_ser_item_rel_id IS NULL THEN
449: FND_MESSAGE.set_name('AHL', 'AHL_OSP_REL_ID_NULL');
450: FND_MSG_PUB.ADD;
451: RAISE Fnd_Api.g_exc_error;
452: END IF;
453:
454: OPEN Item_Ser_rel_det_csr(p_x_Inv_serv_item_rec.inv_ser_item_rel_id);
455: FETCH Item_Ser_rel_det_csr INTO l_Item_Ser_rel_det;

Line 460: RAISE Fnd_Api.g_exc_error;

456: IF Item_Ser_rel_det_csr%NOTFOUND THEN
457: FND_MESSAGE.set_name('AHL', 'AHL_OSP_REL_NOTFOUND');
458: FND_MSG_PUB.ADD;
459: CLOSE Item_Ser_rel_det_csr;
460: RAISE Fnd_Api.g_exc_error;
461: END IF;
462: CLOSE Item_Ser_rel_det_csr;
463:
464: IF NVL(l_Item_Ser_rel_det.object_version_number,-9) <> p_x_Inv_serv_item_rec.obj_ver_num THEN

Line 467: RAISE Fnd_Api.g_exc_error;

463:
464: IF NVL(l_Item_Ser_rel_det.object_version_number,-9) <> p_x_Inv_serv_item_rec.obj_ver_num THEN
465: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_MODIFIED');
466: FND_MSG_PUB.ADD;
467: RAISE Fnd_Api.g_exc_error;
468: END IF;
469:
470: END IF;
471:

Line 475: RAISE FND_API.G_EXC_ERROR;

471:
472: -- Check Error Message stack.
473: x_msg_count := FND_MSG_PUB.count_msg;
474: IF x_msg_count > 0 THEN
475: RAISE FND_API.G_EXC_ERROR;
476: END IF;
477:
478: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
479: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'p_x_Inv_serv_item_rec.operation_flag: ' || p_x_Inv_serv_item_rec.operation_flag );

Line 523: RAISE Fnd_Api.g_exc_error;

519: IF(l_count > 0) THEN
520: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
521: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Validation for Org, Inventory, Rank Check failed');
522: END IF;
523: RAISE Fnd_Api.g_exc_error;
524: END IF;
525:
526: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
527: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Validation for Org, Inventory, Rank Check sucessful');

Line 692: RAISE Fnd_Api.g_exc_error;

688: fnd_log.string(fnd_log.level_statement, L_DEBUG_KEY, 'End Date is in Past');
689: END IF;
690: FND_MESSAGE.set_name('AHL', 'AHL_VENDOR_CER_END_DATE_PAST');
691: FND_MSG_PUB.ADD;
692: RAISE Fnd_Api.g_exc_error;
693: END IF;
694: -- mpothuku End
695:
696: UPDATE ahl_inv_service_item_rels

Line 707: RAISE Fnd_Api.g_exc_error;

703:
704: IF SQL%ROWCOUNT = 0 THEN
705: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_MODIFIED');
706: FND_MSG_PUB.ADD;
707: RAISE Fnd_Api.g_exc_error;
708: END IF;
709:
710:
711: ELSIF p_x_Inv_serv_item_rec.operation_flag = 'D' THEN

Line 720: RAISE Fnd_Api.g_exc_error;

716:
717: IF SQL%ROWCOUNT = 0 THEN
718: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_MODIFIED');
719: FND_MSG_PUB.ADD;
720: RAISE Fnd_Api.g_exc_error;
721: END IF;
722:
723: DELETE FROM ahl_item_vendor_rels
724: WHERE inv_service_item_rel_id = p_x_Inv_serv_item_rec.inv_ser_item_rel_id;

Line 731: IF FND_API.To_Boolean(p_commit) THEN

727: END IF; -- operation flag C
728:
729:
730: -- Standard check of p_commit
731: IF FND_API.To_Boolean(p_commit) THEN
732: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
733: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to commit work');
734: END IF;
735: COMMIT WORK;

Line 743: p_encoded => fnd_api.g_false);

739: -- Standard call to get message count and if count is 1, get message
740: FND_MSG_PUB.Count_And_Get
741: ( p_count => x_msg_count,
742: p_data => x_msg_data,
743: p_encoded => fnd_api.g_false);
744: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
745: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
746: END IF;
747:

Line 749: WHEN FND_API.G_EXC_ERROR THEN

745: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
746: END IF;
747:
748: EXCEPTION
749: WHEN FND_API.G_EXC_ERROR THEN
750: x_return_status := FND_API.G_RET_STS_ERROR;
751: Rollback to process_serv_items_pvt;
752: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
753: p_data => x_msg_data,

Line 750: x_return_status := FND_API.G_RET_STS_ERROR;

746: END IF;
747:
748: EXCEPTION
749: WHEN FND_API.G_EXC_ERROR THEN
750: x_return_status := FND_API.G_RET_STS_ERROR;
751: Rollback to process_serv_items_pvt;
752: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
753: p_data => x_msg_data,
754: p_encoded => fnd_api.g_false);

Line 754: p_encoded => fnd_api.g_false);

750: x_return_status := FND_API.G_RET_STS_ERROR;
751: Rollback to process_serv_items_pvt;
752: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
753: p_data => x_msg_data,
754: p_encoded => fnd_api.g_false);
755:
756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
758: Rollback to process_serv_items_pvt;

Line 756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

752: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
753: p_data => x_msg_data,
754: p_encoded => fnd_api.g_false);
755:
756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
758: Rollback to process_serv_items_pvt;
759: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
760: p_data => x_msg_data,

Line 757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

753: p_data => x_msg_data,
754: p_encoded => fnd_api.g_false);
755:
756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
758: Rollback to process_serv_items_pvt;
759: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
760: p_data => x_msg_data,
761: p_encoded => fnd_api.g_false);

Line 761: p_encoded => fnd_api.g_false);

757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
758: Rollback to process_serv_items_pvt;
759: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
760: p_data => x_msg_data,
761: p_encoded => fnd_api.g_false);
762: WHEN OTHERS THEN
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: Rollback to process_serv_items_pvt;
765: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

Line 763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

759: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
760: p_data => x_msg_data,
761: p_encoded => fnd_api.g_false);
762: WHEN OTHERS THEN
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: Rollback to process_serv_items_pvt;
765: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
766: p_procedure_name => l_api_name,
767: p_error_text => SQLERRM);

Line 771: p_encoded => fnd_api.g_false);

767: p_error_text => SQLERRM);
768:
769: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
770: p_data => x_msg_data,
771: p_encoded => fnd_api.g_false);
772:
773: END PROCESS_SERV_ITM_RELS;
774:
775: