DBA Data[Home] [Help]

APPS.ASO_EDUCATION_INT dependencies on FND_API

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

8: -- End of Comments
9:
10:
11: PROCEDURE Delete_OTA_Line(
12: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
13: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
14: P_Qte_Line_Id IN NUMBER,
15: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
16: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

9:
10:
11: PROCEDURE Delete_OTA_Line(
12: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
13: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
14: P_Qte_Line_Id IN NUMBER,
15: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
16: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
17: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )

Line 35: IF FND_API.to_Boolean( P_Init_Msg_List ) THEN

31: aso_debug_pub.add('Delete_OTA_Line- P_Qte_Line_Id: '||P_Qte_Line_Id, 1, 'N');
32: END IF;
33:
34: -- Initialize message list if p_init_msg_list is set to TRUE.
35: IF FND_API.to_Boolean( P_Init_Msg_List ) THEN
36: FND_MSG_PUB.initialize;
37: END IF;
38:
39: -- Initialize API return status to success

Line 40: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

36: FND_MSG_PUB.initialize;
37: END IF;
38:
39: -- Initialize API return status to success
40: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
41:
42: OPEN C_Get_UOM(P_Qte_Line_Id);
43: FETCH C_Get_UOM INTO l_UOM_Code;
44: CLOSE C_Get_UOM;

Line 58: P_Init_Msg_List => FND_API.G_FALSE,

54: END IF;
55: /*
56: OTA_ASO_INTERFACE.ota_aso_del(
57: P_Api_Version => 1.0,
58: P_Init_Msg_List => FND_API.G_FALSE,
59: P_Commit => FND_API.G_FALSE,
60: P_Quote_Line_Id => P_Qte_Line_Id,
61: X_Return_Status => X_Return_Status,
62: X_Msg_Count => X_Msg_Count,

Line 59: P_Commit => FND_API.G_FALSE,

55: /*
56: OTA_ASO_INTERFACE.ota_aso_del(
57: P_Api_Version => 1.0,
58: P_Init_Msg_List => FND_API.G_FALSE,
59: P_Commit => FND_API.G_FALSE,
60: P_Quote_Line_Id => P_Qte_Line_Id,
61: X_Return_Status => X_Return_Status,
62: X_Msg_Count => X_Msg_Count,
63: X_Msg_Data => X_Msg_Data);

Line 65: IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

61: X_Return_Status => X_Return_Status,
62: X_Msg_Count => X_Msg_Count,
63: X_Msg_Data => X_Msg_Data);
64: aso_debug_pub.add('Delete_OTA_Line- after OTA_ASO_INTERFACE.ota_aso_del: '||X_Return_Status, 1, 'N');
65: IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
66: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
67: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_DELETE_OTA_LINE');
68: FND_MSG_PUB.ADD;
69: END IF;

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

74: END Delete_OTA_Line;
75:
76:
77: PROCEDURE Update_OTA_With_OrderLine(
78: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
79: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
80: P_Order_Line_Tbl IN ASO_ORDER_INT.Order_Line_Tbl_Type,
81: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
82: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

75:
76:
77: PROCEDURE Update_OTA_With_OrderLine(
78: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
79: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
80: P_Order_Line_Tbl IN ASO_ORDER_INT.Order_Line_Tbl_Type,
81: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
82: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
83: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )

Line 104: IF FND_API.to_Boolean( P_Init_Msg_List ) THEN

100: aso_debug_pub.add('Update_OTA_Line- P_Order_Line_Tbl.count: '||P_Order_Line_Tbl.count, 1, 'N');
101: END IF;
102:
103: -- Initialize message list if p_init_msg_list is set to TRUE.
104: IF FND_API.to_Boolean( P_Init_Msg_List ) THEN
105: FND_MSG_PUB.initialize;
106: END IF;
107:
108: -- Initialize API return status to success

Line 109: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

105: FND_MSG_PUB.initialize;
106: END IF;
107:
108: -- Initialize API return status to success
109: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
110:
111: FOR i IN 1..P_Order_Line_Tbl.count LOOP
112:
113: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 134: P_Init_Msg_List => FND_API.G_FALSE,

130: END IF;
131: /*
132: OTA_ASO_INTERFACE.ota_aso_upd(
133: P_Api_Version => 1.0,
134: P_Init_Msg_List => FND_API.G_FALSE,
135: P_Commit => FND_API.G_FALSE,
136: P_Quote_Line_Id => l_Qte_Line_Id,
137: P_Order_Line_Id => P_Order_Line_Tbl(i).Order_Line_Id,
138: X_Return_Status => X_Return_Status,

Line 135: P_Commit => FND_API.G_FALSE,

131: /*
132: OTA_ASO_INTERFACE.ota_aso_upd(
133: P_Api_Version => 1.0,
134: P_Init_Msg_List => FND_API.G_FALSE,
135: P_Commit => FND_API.G_FALSE,
136: P_Quote_Line_Id => l_Qte_Line_Id,
137: P_Order_Line_Id => P_Order_Line_Tbl(i).Order_Line_Id,
138: X_Return_Status => X_Return_Status,
139: X_Msg_Count => X_Msg_Count,

Line 142: IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

138: X_Return_Status => X_Return_Status,
139: X_Msg_Count => X_Msg_Count,
140: X_Msg_Data => X_Msg_Data);
141: aso_debug_pub.add('Update_OTA_Line- after OTA_ASO_INTERFACE.ota_aso_upd: '||X_Return_Status, 1, 'N');
142: IF X_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
144: FND_MESSAGE.Set_Name('ASO', 'ASO_ERR_UPDATE_OTA_LINE');
145: FND_MSG_PUB.ADD;
146: END IF;