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 596: IF c_ship_site1%FOUND and l_ship_site_id IS NOT NULL and l_ship_site_id <> FND_API.G_MISS_NUM THEN

592: aso_debug_pub.add('ASO_SHIPMENT_PVT: At the start , l_shipment_id : '||l_shipment_id);
593:
594: /* End : Code change for Bug 12938390(11i Bug 12426838) */
595:
596: IF c_ship_site1%FOUND and l_ship_site_id IS NOT NULL and l_ship_site_id <> FND_API.G_MISS_NUM THEN
597:
598: CLOSE c_ship_site1;
599:
600: --Get the ship_to_cust_account if present

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

604: IF aso_debug_pub.g_debug_flag = 'Y' THEN
605: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_cust_id l_cust_id ' || l_cust_id, 1, 'N');
606: END IF;
607:
608: IF c_ship_cust_id%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN
609:
610: CLOSE c_ship_cust_id;
611:
612: --OPEN c_ship_cust_id1;

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

616: IF aso_debug_pub.g_debug_flag = 'Y' THEN
617: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_cust_id1 l_cust_id ' || l_cust_id, 1, 'N');
618: END IF;
619:
620: IF c_ship_cust_id1%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN
621:
622: CLOSE c_ship_cust_id1;
623:
624: -- Get the Customer Account from the header

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

746: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_site2 l_ship_site_id ' || l_ship_site_id, 1, 'N');
747: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_site2 l_ship_cust_acct_id ' || l_ship_cust_acct_id, 1, 'N');
748: END IF;
749:
750: IF c_ship_site2%FOUND AND l_ship_site_id IS NOT NULL and l_ship_site_id <> FND_API.G_MISS_NUM THEN
751:
752: CLOSE c_ship_site2;
753: --Get the ship_to_cust_account if present
754: OPEN c_ship_cust_id;

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

757: IF aso_debug_pub.g_debug_flag = 'Y' THEN
758: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_cust_id l_cust_id ' || l_cust_id, 1, 'N');
759: END IF;
760:
761: IF c_ship_cust_id%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN
762:
763: CLOSE c_ship_cust_id;
764:
765: -- OPEN c_ship_cust_id1;

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

770: IF aso_debug_pub.g_debug_flag = 'Y' THEN
771: aso_debug_pub.add('ASO_SHIPMENT_PVT:c_ship_cust_id1 l_cust_id ' || l_cust_id, 1, 'N');
772: END IF;
773:
774: IF c_ship_cust_id1%NOTFOUND or l_cust_id IS NULL or l_cust_id = FND_API.G_MISS_NUM THEN
775:
776: CLOSE c_ship_cust_id1;
777: --Get the Customer Account from the header
778: OPEN c_cust_id;

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

876:
877: OPEN c_ship_site1;
878: FETCH c_ship_site1 INTO l_ship_site_id;
879:
880: IF c_ship_site1%FOUND and l_ship_site_id IS NOT NULL and l_ship_site_id <> FND_API.G_MISS_NUM THEN
881:
882: CLOSE c_ship_site1;
883: return l_ship_site_id;
884:

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

942:
943: OPEN c_ship_site2;
944: FETCH c_ship_site2 INTO l_ship_site_id;
945:
946: IF c_ship_site2%FOUND and l_ship_site_id IS NOT NULL and l_ship_site_id <> FND_API.G_MISS_NUM THEN
947:
948: CLOSE c_ship_site2;
949: return l_ship_site_id;
950:

Line 1167: 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

1163: END IF;
1164:
1165: -- Line-shipment level ship_from_org_id doesn't exist then look for header-shipment level ship_from_org_id
1166:
1167: 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
1168: open c_header_shipment;
1169: fetch c_header_shipment into l_ship_from_org_id;
1170:
1171: IF aso_debug_pub.g_debug_flag = 'Y' THEN