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

Line 14: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_SHIPMENT_PVT';
11:
12: PROCEDURE Delete_shipment(
13: P_Api_Version_Number IN NUMBER,
14: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
15: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_qte_line_rec IN aso_quote_pub.qte_line_rec_type
17: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC,
18: p_shipment_rec IN aso_quote_pub.shipment_rec_type,

Line 15: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

11:
12: PROCEDURE Delete_shipment(
13: P_Api_Version_Number IN NUMBER,
14: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
15: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_qte_line_rec IN aso_quote_pub.qte_line_rec_type
17: := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC,
18: p_shipment_rec IN aso_quote_pub.shipment_rec_type,
19: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 37: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

33: -- Standard Start of API savepoint
34: SAVEPOINT DELETE_SHIPMENT_PVT;
35:
36: -- Standard call to check for call compatibility.
37: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
38: p_api_version_number,
39: l_api_name,
40: G_PKG_NAME)
41: THEN

Line 42: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

38: p_api_version_number,
39: l_api_name,
40: G_PKG_NAME)
41: THEN
42: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
43: END IF;
44:
45:
46: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 47: IF FND_API.to_Boolean( p_init_msg_list )

43: END IF;
44:
45:
46: -- Initialize message list if p_init_msg_list is set to TRUE.
47: IF FND_API.to_Boolean( p_init_msg_list )
48: THEN
49: FND_MSG_PUB.initialize;
50: END IF;
51:

Line 54: x_return_status := FND_API.G_RET_STS_SUCCESS;

50: END IF;
51:
52:
53: -- Initialize API return status to SUCCESS
54: x_return_status := FND_API.G_RET_STS_SUCCESS;
55:
56: --
57: -- Api body
58: --

Line 59: IF p_shipment_rec.reservation_id <> FND_API.G_MISS_NUM AND

55:
56: --
57: -- Api body
58: --
59: IF p_shipment_rec.reservation_id <> FND_API.G_MISS_NUM AND
60: p_shipment_rec.reservation_id IS NOT NULL THEN
61: ASO_RESERVATION_INT.Delete_Reservation(
62: P_Api_Version_Number => 1.0,
63: P_Init_Msg_List => FND_API.G_FALSE,

Line 63: P_Init_Msg_List => FND_API.G_FALSE,

59: IF p_shipment_rec.reservation_id <> FND_API.G_MISS_NUM AND
60: p_shipment_rec.reservation_id IS NOT NULL THEN
61: ASO_RESERVATION_INT.Delete_Reservation(
62: P_Api_Version_Number => 1.0,
63: P_Init_Msg_List => FND_API.G_FALSE,
64: P_Commit => FND_API.G_FALSE,
65: P_line_Rec => p_qte_line_rec,
66: p_shipment_rec => p_shipment_rec,
67: X_Return_Status => l_Return_Status,

Line 64: P_Commit => FND_API.G_FALSE,

60: p_shipment_rec.reservation_id IS NOT NULL THEN
61: ASO_RESERVATION_INT.Delete_Reservation(
62: P_Api_Version_Number => 1.0,
63: P_Init_Msg_List => FND_API.G_FALSE,
64: P_Commit => FND_API.G_FALSE,
65: P_line_Rec => p_qte_line_rec,
66: p_shipment_rec => p_shipment_rec,
67: X_Return_Status => l_Return_Status,
68: X_Msg_Count => X_Msg_Count,

Line 70: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

66: p_shipment_rec => p_shipment_rec,
67: X_Return_Status => l_Return_Status,
68: X_Msg_Count => X_Msg_Count,
69: X_Msg_Data => X_Msg_Data);
70: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
71: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
72: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_DELETE_RSV');
73: FND_MSG_PUB.ADD;
74: END IF;

Line 93: IF FND_API.to_Boolean( p_commit )

89: -- End of API body
90: --
91:
92: -- Standard check for p_commit
93: IF FND_API.to_Boolean( p_commit )
94: THEN
95: COMMIT WORK;
96: END IF;
97:

Line 105: WHEN FND_API.G_EXC_ERROR THEN

101: ( p_count => x_msg_count,
102: p_data => x_msg_data
103: );
104: EXCEPTION
105: WHEN FND_API.G_EXC_ERROR THEN
106: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
107: P_API_NAME => L_API_NAME
108: ,P_PKG_NAME => G_PKG_NAME
109: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

111: ,X_MSG_COUNT => X_MSG_COUNT
112: ,X_MSG_DATA => X_MSG_DATA
113: ,X_RETURN_STATUS => X_RETURN_STATUS);
114:
115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
116: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
117: P_API_NAME => L_API_NAME
118: ,P_PKG_NAME => G_PKG_NAME
119: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 176: IF c_inv_site1%FOUND and l_inv_site_id IS NOT NULL and l_inv_site_id <> FND_API.G_MISS_NUM THEN

172: BEGIN
173: OPEN c_inv_site1;
174: FETCH c_inv_site1 INTO l_inv_site_id;
175:
176: IF c_inv_site1%FOUND and l_inv_site_id IS NOT NULL and l_inv_site_id <> FND_API.G_MISS_NUM THEN
177:
178: CLOSE c_inv_site1;
179: return l_inv_site_id;
180:

Line 227: IF c_inv_site2%FOUND and l_inv_site_id IS NOT NULL and l_inv_site_id <> FND_API.G_MISS_NUM THEN

223:
224: OPEN c_inv_site2;
225: FETCH c_inv_site2 INTO l_inv_site_id;
226:
227: IF c_inv_site2%FOUND and l_inv_site_id IS NOT NULL and l_inv_site_id <> FND_API.G_MISS_NUM THEN
228:
229: CLOSE c_inv_site2;
230: return l_inv_site_id;
231:

Line 308: IF c_inv_site1%FOUND AND l_inv_site_id IS NOT NULL and l_inv_site_id <> FND_API.G_MISS_NUM THEN

304:
305: OPEN c_inv_site1;
306: FETCH c_inv_site1 INTO l_inv_site_id;
307:
308: IF c_inv_site1%FOUND AND l_inv_site_id IS NOT NULL and l_inv_site_id <> FND_API.G_MISS_NUM THEN
309:
310: CLOSE c_inv_site1;
311:
312: OPEN c_inv_cust_id;

Line 315: IF c_inv_cust_id%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN

311:
312: OPEN c_inv_cust_id;
313: FETCH c_inv_cust_id into l_cust_id;
314:
315: IF c_inv_cust_id%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN
316:
317: CLOSE c_inv_cust_id;
318:
319: OPEN c_inv_cust_id1;

Line 322: IF c_inv_cust_id1%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN

318:
319: OPEN c_inv_cust_id1;
320: FETCH c_inv_cust_id1 into l_cust_id;
321:
322: IF c_inv_cust_id1%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN
323:
324: CLOSE c_inv_cust_id1;
325:
326: --Get the Customer Account from the header

Line 407: IF c_inv_site2%FOUND AND l_inv_site_id IS NOT NULL and l_inv_site_id <> FND_API.G_MISS_NUM THEN

403:
404: OPEN c_inv_site2;
405: FETCH c_inv_site2 INTO l_inv_site_id;
406:
407: IF c_inv_site2%FOUND AND l_inv_site_id IS NOT NULL and l_inv_site_id <> FND_API.G_MISS_NUM THEN
408:
409: CLOSE c_inv_site2;
410:
411: OPEN c_inv_cust_id;

Line 414: IF c_inv_cust_id%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN

410:
411: OPEN c_inv_cust_id;
412: FETCH c_inv_cust_id into l_cust_id;
413:
414: IF c_inv_cust_id%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN
415:
416: CLOSE c_inv_cust_id;
417: OPEN c_inv_cust_id1;
418: FETCH c_inv_cust_id1 into l_cust_id;

Line 420: IF c_inv_cust_id1%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN

416: CLOSE c_inv_cust_id;
417: OPEN c_inv_cust_id1;
418: FETCH c_inv_cust_id1 into l_cust_id;
419:
420: IF c_inv_cust_id1%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN
421:
422: CLOSE c_inv_cust_id1;
423:
424: --Get the Customer Account from the header

Line 559: IF c_ship_site1%FOUND and l_ship_site_id IS NOT NULL and l_ship_site_id <> FND_API.G_MISS_NUM THEN

555: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_site1 l_ship_site_id ' || l_ship_site_id, 1, 'N');
556: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_site1 l_ship_cust_acct_id ' || l_ship_cust_acct_id, 1, 'N');
557: END IF;
558:
559: IF c_ship_site1%FOUND and l_ship_site_id IS NOT NULL and l_ship_site_id <> FND_API.G_MISS_NUM THEN
560:
561: CLOSE c_ship_site1;
562:
563: --Get the ship_to_cust_account if present

Line 571: IF c_ship_cust_id%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN

567: IF aso_debug_pub.g_debug_flag = 'Y' THEN
568: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_cust_id l_cust_id ' || l_cust_id, 1, 'N');
569: END IF;
570:
571: IF c_ship_cust_id%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN
572:
573: CLOSE c_ship_cust_id;
574:
575: OPEN c_ship_cust_id1;

Line 582: IF c_ship_cust_id1%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN

578: IF aso_debug_pub.g_debug_flag = 'Y' THEN
579: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_cust_id1 l_cust_id ' || l_cust_id, 1, 'N');
580: END IF;
581:
582: IF c_ship_cust_id1%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN
583:
584: CLOSE c_ship_cust_id1;
585:
586: -- Get the Customer Account from the header

Line 703: IF c_ship_site2%FOUND AND l_ship_site_id IS NOT NULL and l_ship_site_id <> FND_API.G_MISS_NUM THEN

699: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_site2 l_ship_site_id ' || l_ship_site_id, 1, 'N');
700: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_site2 l_ship_cust_acct_id ' || l_ship_cust_acct_id, 1, 'N');
701: END IF;
702:
703: IF c_ship_site2%FOUND AND l_ship_site_id IS NOT NULL and l_ship_site_id <> FND_API.G_MISS_NUM THEN
704:
705: CLOSE c_ship_site2;
706: --Get the ship_to_cust_account if present
707: OPEN c_ship_cust_id;

Line 714: IF c_ship_cust_id%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN

710: IF aso_debug_pub.g_debug_flag = 'Y' THEN
711: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_cust_id l_cust_id ' || l_cust_id, 1, 'N');
712: END IF;
713:
714: IF c_ship_cust_id%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN
715:
716: CLOSE c_ship_cust_id;
717: OPEN c_ship_cust_id1;
718:

Line 725: IF c_ship_cust_id1%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN

721: IF aso_debug_pub.g_debug_flag = 'Y' THEN
722: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_cust_id1 l_cust_id ' || l_cust_id, 1, 'N');
723: END IF;
724:
725: IF c_ship_cust_id1%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN
726:
727: CLOSE c_ship_cust_id1;
728: --Get the Customer Account from the header
729: OPEN c_cust_id;

Line 831: IF c_ship_site1%FOUND and l_ship_site_id IS NOT NULL and l_ship_site_id <> FND_API.G_MISS_NUM THEN

827:
828: OPEN c_ship_site1;
829: FETCH c_ship_site1 INTO l_ship_site_id;
830:
831: IF c_ship_site1%FOUND and l_ship_site_id IS NOT NULL and l_ship_site_id <> FND_API.G_MISS_NUM THEN
832:
833: CLOSE c_ship_site1;
834: return l_ship_site_id;
835:

Line 897: IF c_ship_site2%FOUND and l_ship_site_id IS NOT NULL and l_ship_site_id <> FND_API.G_MISS_NUM THEN

893:
894: OPEN c_ship_site2;
895: FETCH c_ship_site2 INTO l_ship_site_id;
896:
897: IF c_ship_site2%FOUND and l_ship_site_id IS NOT NULL and l_ship_site_id <> FND_API.G_MISS_NUM THEN
898:
899: CLOSE c_ship_site2;
900: return l_ship_site_id;
901:

Line 1113: IF c_line_shipment%NOTFOUND OR l_ship_from_org_id IS NULL OR l_ship_from_org_id = FND_API.G_MISS_NUM THEN

1109: END IF;
1110:
1111: -- Line-shipment level ship_from_org_id doesn't exist then look for header-shipment level ship_from_org_id
1112:
1113: IF c_line_shipment%NOTFOUND OR l_ship_from_org_id IS NULL OR l_ship_from_org_id = FND_API.G_MISS_NUM THEN
1114: open c_header_shipment;
1115: fetch c_header_shipment into l_ship_from_org_id;
1116:
1117: IF aso_debug_pub.g_debug_flag = 'Y' THEN