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.CSD_LOGISTICS_PVT dependencies on FND_API

Line 26: p_commit IN VARCHAR2 := fnd_api.g_false,

22:
23:
24: PROCEDURE Create_Logistics_Line(
25: p_api_version IN NUMBER,
26: p_commit IN VARCHAR2 := fnd_api.g_false,
27: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
28: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,

Line 27: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

23:
24: PROCEDURE Create_Logistics_Line(
25: p_api_version IN NUMBER,
26: p_commit IN VARCHAR2 := fnd_api.g_false,
27: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
28: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2,

Line 28: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

24: PROCEDURE Create_Logistics_Line(
25: p_api_version IN NUMBER,
26: p_commit IN VARCHAR2 := fnd_api.g_false,
27: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
28: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2,
32: p_product_txn_rec IN OUT NOCOPY csd_process_pvt.product_txn_rec,

Line 52: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

48: p_product_txn_rec => p_product_txn_rec,
49: p_add_to_order_flag => p_add_to_order_flag
50: );
51:
52: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
53: RAISE FND_API.G_EXC_ERROR;
54: END IF;
55:
56:

Line 53: RAISE FND_API.G_EXC_ERROR;

49: p_add_to_order_flag => p_add_to_order_flag
50: );
51:
52: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
53: RAISE FND_API.G_EXC_ERROR;
54: END IF;
55:
56:
57: End Create_Logistics_Line;

Line 62: p_commit IN VARCHAR2 := fnd_api.g_false,

58:
59:
60: PROCEDURE Create_Default_Logistics
61: ( p_api_version IN NUMBER,
62: p_commit IN VARCHAR2 := fnd_api.g_false,
63: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
64: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
65: p_repair_line_id IN NUMBER,
66: x_return_status OUT NOCOPY VARCHAR2,

Line 63: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

59:
60: PROCEDURE Create_Default_Logistics
61: ( p_api_version IN NUMBER,
62: p_commit IN VARCHAR2 := fnd_api.g_false,
63: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
64: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
65: p_repair_line_id IN NUMBER,
66: x_return_status OUT NOCOPY VARCHAR2,
67: x_msg_count OUT NOCOPY NUMBER,

Line 64: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

60: PROCEDURE Create_Default_Logistics
61: ( p_api_version IN NUMBER,
62: p_commit IN VARCHAR2 := fnd_api.g_false,
63: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
64: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
65: p_repair_line_id IN NUMBER,
66: x_return_status OUT NOCOPY VARCHAR2,
67: x_msg_count OUT NOCOPY NUMBER,
68: x_msg_data OUT NOCOPY VARCHAR2

Line 86: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

82: x_return_status => x_return_status,
83: x_msg_count => x_msg_count,
84: x_msg_data => x_msg_data);
85:
86: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
87: RAISE FND_API.G_EXC_ERROR;
88: END IF;
89:
90:

Line 87: RAISE FND_API.G_EXC_ERROR;

83: x_msg_count => x_msg_count,
84: x_msg_data => x_msg_data);
85:
86: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
87: RAISE FND_API.G_EXC_ERROR;
88: END IF;
89:
90:
91: End Create_Default_Logistics;

Line 223: x_return_status := FND_API.G_RET_STS_SUCCESS;

219: -- Create a Save Point before calling Update program
220: SAVEPOINT Update_Logistics_Line_Pvt;
221:
222: -- Initialize API return status to success
223: x_return_status := FND_API.G_RET_STS_SUCCESS;
224:
225: -- Standard call to check for API Version compatibility.
226: IF Not (FND_API.Compatible_API_Call(c_api_version,
227: p_api_version,

Line 226: IF Not (FND_API.Compatible_API_Call(c_api_version,

222: -- Initialize API return status to success
223: x_return_status := FND_API.G_RET_STS_SUCCESS;
224:
225: -- Standard call to check for API Version compatibility.
226: IF Not (FND_API.Compatible_API_Call(c_api_version,
227: p_api_version,
228: c_api_name,
229: G_PKG_NAME))
230: THEN

Line 231: RAISE FND_API.G_Exc_UnExpected_Error;

227: p_api_version,
228: c_api_name,
229: G_PKG_NAME))
230: THEN
231: RAISE FND_API.G_Exc_UnExpected_Error;
232: END IF;
233:
234: -- Initialize message list if p_init_msg_list is set to TRUE.
235: IF FND_API.to_Boolean(p_init_msg_list)

Line 235: IF FND_API.to_Boolean(p_init_msg_list)

231: RAISE FND_API.G_Exc_UnExpected_Error;
232: END IF;
233:
234: -- Initialize message list if p_init_msg_list is set to TRUE.
235: IF FND_API.to_Boolean(p_init_msg_list)
236: THEN
237: FND_MSG_PUB.initialize;
238: END IF;
239:

Line 294: RAISE FND_API.G_EXC_ERROR;

290: -- Validate the Product_Transaction_Id exists in csd_product_transactions
291: IF NOT
292: (CSD_PROCESS_UTIL.Validate_prod_txn_id(p_prod_txn_id => p_Upd_ProdTxn_Rec.Product_Transaction_id))
293: THEN
294: RAISE FND_API.G_EXC_ERROR;
295: END IF;
296:
297: debug('ro status check...');
298: -- Check Repair Order Status if it Hold or Closed then raise exception

Line 311: RAISE FND_API.G_EXC_ERROR;

307: FND_MESSAGE.SET_NAME('CSD', 'CSD_RO_NOT_OPEN_NO_PRODTXN_UPD');
308: FND_MESSAGE.SET_TOKEN('RO_NUMBER', l_RO_NUMBER);
309: FND_MESSAGE.SET_TOKEN('RO_STATUS', l_RO_Status_Meaning);
310: FND_MSG_PUB.ADD;
311: RAISE FND_API.G_EXC_ERROR;
312:
313: END IF;
314:
315: debug('object version number check, db['||l_Product_Txn_Rec.Object_Version_NUMBER||']');

Line 324: RAISE FND_API.G_EXC_ERROR;

320: THEN
321:
322: FND_MESSAGE.SET_NAME('CSD', 'CSD_OBJECT_VERSION_NUMBER');
323: FND_MSG_PUB.ADD;
324: RAISE FND_API.G_EXC_ERROR;
325:
326: END IF;
327:
328: -- Set flag attributes values for record UpdateProdTrxn_Rec

Line 346: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS

342: x_Return_Status => x_Return_Status,
343: x_Msg_Data => x_Msg_Data,
344: x_Msg_Count => x_Msg_Count);
345:
346: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS
347: THEN
348: RAISE FND_API.G_EXC_ERROR;
349: END IF;
350:

Line 348: RAISE FND_API.G_EXC_ERROR;

344: x_Msg_Count => x_Msg_Count);
345:
346: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS
347: THEN
348: RAISE FND_API.G_EXC_ERROR;
349: END IF;
350:
351: END IF;
352:

Line 367: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS

363: x_Return_Status => x_Return_Status,
364: x_Msg_Data => x_Msg_Data,
365: x_Msg_Count => x_Msg_Count);
366:
367: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS
368: THEN
369: --dbms_output.put_line('Validation failed');
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;

Line 370: RAISE FND_API.G_EXC_ERROR;

366:
367: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS
368: THEN
369: --dbms_output.put_line('Validation failed');
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372: */
373: --Get Currency Code for a given Price List Id
374: Open PL_CurrencyCOde_Cur_Type(l_Product_Txn_Rec.Price_List_ID);

Line 383: p_commit => fnd_api.g_false,

379: -- Call Private API to Update Product Transaction Record
380: -- CSD_LOGISTICS_PVT.Update_product_txn
381: --dbms_output.put_line('Calling update');
382: CSD_LOGISTICS_PVT.Update_product_txn(p_api_version => 1.0,
383: p_commit => fnd_api.g_false,
384: p_init_msg_list => fnd_api.g_false,
385: p_validation_level => fnd_api.g_valid_level_full,
386: x_product_txn_rec => l_Product_Txn_Rec,
387: x_return_status => x_Return_Status,

Line 384: p_init_msg_list => fnd_api.g_false,

380: -- CSD_LOGISTICS_PVT.Update_product_txn
381: --dbms_output.put_line('Calling update');
382: CSD_LOGISTICS_PVT.Update_product_txn(p_api_version => 1.0,
383: p_commit => fnd_api.g_false,
384: p_init_msg_list => fnd_api.g_false,
385: p_validation_level => fnd_api.g_valid_level_full,
386: x_product_txn_rec => l_Product_Txn_Rec,
387: x_return_status => x_Return_Status,
388: x_msg_count => x_Msg_Count,

Line 385: p_validation_level => fnd_api.g_valid_level_full,

381: --dbms_output.put_line('Calling update');
382: CSD_LOGISTICS_PVT.Update_product_txn(p_api_version => 1.0,
383: p_commit => fnd_api.g_false,
384: p_init_msg_list => fnd_api.g_false,
385: p_validation_level => fnd_api.g_valid_level_full,
386: x_product_txn_rec => l_Product_Txn_Rec,
387: x_return_status => x_Return_Status,
388: x_msg_count => x_Msg_Count,
389: x_msg_data => x_Msg_Data);

Line 391: IF x_Return_Status = FND_API.G_RET_STS_ERROR

387: x_return_status => x_Return_Status,
388: x_msg_count => x_Msg_Count,
389: x_msg_data => x_Msg_Data);
390:
391: IF x_Return_Status = FND_API.G_RET_STS_ERROR
392: THEN
393: RAISE FND_API.G_EXC_ERROR;
394: ELSIF x_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR
395: THEN

Line 393: RAISE FND_API.G_EXC_ERROR;

389: x_msg_data => x_Msg_Data);
390:
391: IF x_Return_Status = FND_API.G_RET_STS_ERROR
392: THEN
393: RAISE FND_API.G_EXC_ERROR;
394: ELSIF x_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR
395: THEN
396: RAISE Fnd_Api.G_Exc_UnExpected_Error;
397: END IF;

Line 394: ELSIF x_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR

390:
391: IF x_Return_Status = FND_API.G_RET_STS_ERROR
392: THEN
393: RAISE FND_API.G_EXC_ERROR;
394: ELSIF x_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR
395: THEN
396: RAISE Fnd_Api.G_Exc_UnExpected_Error;
397: END IF;
398:

Line 396: RAISE Fnd_Api.G_Exc_UnExpected_Error;

392: THEN
393: RAISE FND_API.G_EXC_ERROR;
394: ELSIF x_Return_Status = FND_API.G_RET_STS_UNEXP_ERROR
395: THEN
396: RAISE Fnd_Api.G_Exc_UnExpected_Error;
397: END IF;
398:
399: x_object_version_number := l_Product_Txn_Rec.object_version_number;
400: x_order_header_id := l_Product_Txn_Rec.order_header_id;

Line 406: WHEN Fnd_Api.G_Exc_Error THEN

402:
403:
404: EXCEPTION
405:
406: WHEN Fnd_Api.G_Exc_Error THEN
407:
408: x_return_status := Fnd_Api.G_Ret_Sts_Error;
409:
410: ROLLBACK TO Update_Logistics_Line_pvt;

Line 408: x_return_status := Fnd_Api.G_Ret_Sts_Error;

404: EXCEPTION
405:
406: WHEN Fnd_Api.G_Exc_Error THEN
407:
408: x_return_status := Fnd_Api.G_Ret_Sts_Error;
409:
410: ROLLBACK TO Update_Logistics_Line_pvt;
411:
412: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

Line 415: WHEN Fnd_Api.G_Exc_UnExpected_Error THEN

411:
412: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
413: p_data => x_msg_data);
414:
415: WHEN Fnd_Api.G_Exc_UnExpected_Error THEN
416:
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418:
419: ROLLBACK TO Update_Logistics_Line_pvt;

Line 417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

413: p_data => x_msg_data);
414:
415: WHEN Fnd_Api.G_Exc_UnExpected_Error THEN
416:
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418:
419: ROLLBACK TO Update_Logistics_Line_pvt;
420:
421: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

422: p_data => x_msg_data);
423:
424: WHEN OTHERS THEN
425:
426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
427:
428: ROLLBACK TO Update_Logistics_Line_pvt;
429:
430: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_Unexp_Error)

Line 535: if NOT (l_Return_status = FND_API.G_RET_STS_SUCCESS) THEN

531: CSD_LOGISTICS_UTIL.interface_prodtxn( x_return_status => l_return_status,
532: p_product_txn_rec => x_product_txn_rec,
533: p_prodtxn_db_attr => l_prodtxn_db_attr,
534: px_order_rec => l_order_rec);
535: if NOT (l_Return_status = FND_API.G_RET_STS_SUCCESS) THEN
536: raise create_order;
537: END IF;
538:
539: IF l_prodtxn_db_attr.curr_book_order_flag <>

Line 547: if NOT (l_Return_status = FND_API.G_RET_STS_SUCCESS) THEN

543: CSD_LOGISTICS_UTIL.book_prodtxn( x_return_status => l_return_status,
544: p_product_txn_rec => x_product_txn_rec,
545: p_prodtxn_db_attr => l_prodtxn_db_attr,
546: px_order_rec => l_order_rec);
547: if NOT (l_Return_status = FND_API.G_RET_STS_SUCCESS) THEN
548: raise book_order;
549: END IF;
550:
551:

Line 562: if(l_Return_status = FND_API.G_RET_STS_SUCCESS) THEN

558: CSD_LOGISTICS_UTIL.pickrelease_prodtxn( x_return_status => l_return_status,
559: p_product_txn_rec => x_product_txn_rec,
560: p_prodtxn_db_attr => l_prodtxn_db_attr,
561: px_order_rec => l_order_rec);
562: if(l_Return_status = FND_API.G_RET_STS_SUCCESS) THEN
563: raise release_order;
564: END IF;
565: END IF; --end of pick-release sales order
566:

Line 576: if(l_Return_status = FND_API.G_RET_STS_SUCCESS) THEN

572: p_product_txn_rec => x_product_txn_rec,
573: p_prodtxn_db_attr => l_prodtxn_db_attr,
574: px_order_rec => l_order_rec);
575:
576: if(l_Return_status = FND_API.G_RET_STS_SUCCESS) THEN
577: raise ship_order;
578: END IF;
579: END IF; -- end of ship sales order
580:

Line 586: IF FND_API.To_Boolean(p_commit)

582:
583: -- Api body ends here
584:
585: -- Standard check of p_commit.
586: IF FND_API.To_Boolean(p_commit)
587: THEN
588: COMMIT WORK;
589: END IF;
590:

Line 597: x_return_status := FND_API.G_RET_STS_ERROR;

593: p_data => x_msg_data);
594: EXCEPTION
595: WHEN CREATE_ORDER THEN
596: rollback to UPDATE_PRODUCT_TXN_PVT;
597: x_return_status := FND_API.G_RET_STS_ERROR;
598: WHEN BOOK_ORDER THEN
599: rollback to UPDATE_PRODUCT_TXN_PVT;
600: x_return_status := FND_API.G_RET_STS_ERROR;
601: WHEN RELEASE_ORDER THEN

Line 600: x_return_status := FND_API.G_RET_STS_ERROR;

596: rollback to UPDATE_PRODUCT_TXN_PVT;
597: x_return_status := FND_API.G_RET_STS_ERROR;
598: WHEN BOOK_ORDER THEN
599: rollback to UPDATE_PRODUCT_TXN_PVT;
600: x_return_status := FND_API.G_RET_STS_ERROR;
601: WHEN RELEASE_ORDER THEN
602: rollback to UPDATE_PRODUCT_TXN_PVT;
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: WHEN SHIP_ORDER THEN

Line 603: x_return_status := FND_API.G_RET_STS_ERROR;

599: rollback to UPDATE_PRODUCT_TXN_PVT;
600: x_return_status := FND_API.G_RET_STS_ERROR;
601: WHEN RELEASE_ORDER THEN
602: rollback to UPDATE_PRODUCT_TXN_PVT;
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: WHEN SHIP_ORDER THEN
605: rollback to UPDATE_PRODUCT_TXN_PVT;
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: WHEN FND_API.G_EXC_ERROR THEN

Line 606: x_return_status := FND_API.G_RET_STS_ERROR;

602: rollback to UPDATE_PRODUCT_TXN_PVT;
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: WHEN SHIP_ORDER THEN
605: rollback to UPDATE_PRODUCT_TXN_PVT;
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: WHEN FND_API.G_EXC_ERROR THEN
608: rollback to UPDATE_PRODUCT_TXN_PVT;
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

Line 607: WHEN FND_API.G_EXC_ERROR THEN

603: x_return_status := FND_API.G_RET_STS_ERROR;
604: WHEN SHIP_ORDER THEN
605: rollback to UPDATE_PRODUCT_TXN_PVT;
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: WHEN FND_API.G_EXC_ERROR THEN
608: rollback to UPDATE_PRODUCT_TXN_PVT;
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
611: p_data => x_msg_data);

Line 609: x_return_status := FND_API.G_RET_STS_ERROR;

605: rollback to UPDATE_PRODUCT_TXN_PVT;
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: WHEN FND_API.G_EXC_ERROR THEN
608: rollback to UPDATE_PRODUCT_TXN_PVT;
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
611: p_data => x_msg_data);
612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
613: rollback to UPDATE_PRODUCT_TXN_PVT;

Line 612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

608: rollback to UPDATE_PRODUCT_TXN_PVT;
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
611: p_data => x_msg_data);
612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
613: rollback to UPDATE_PRODUCT_TXN_PVT;
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
616: p_data => x_msg_data);

Line 614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

610: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
611: p_data => x_msg_data);
612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
613: rollback to UPDATE_PRODUCT_TXN_PVT;
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
616: p_data => x_msg_data);
617: WHEN OTHERS THEN
618: rollback to UPDATE_PRODUCT_TXN_PVT;

Line 619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

615: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
616: p_data => x_msg_data);
617: WHEN OTHERS THEN
618: rollback to UPDATE_PRODUCT_TXN_PVT;
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
620: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
621: THEN
622: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
623: END IF;