DBA Data[Home] [Help]

APPS.CSP_PARTS_REPAIR dependencies on FND_API

Line 18: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

14:
15:
16: PROCEDURE create_orders
17: ( p_api_version IN NUMBER
18: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
19: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
20: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
21: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
22: ,p_Repair_supplier_id IN NUMBER

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

15:
16: PROCEDURE create_orders
17: ( p_api_version IN NUMBER
18: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
19: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
20: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
21: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
22: ,p_Repair_supplier_id IN NUMBER
23: ,x_return_status OUT NOCOPY VARCHAR2

Line 29: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

25: ,x_msg_data OUT NOCOPY VARCHAR2)
26: IS
27: l_api_version_number CONSTANT NUMBER := 1.0;
28: l_api_name CONSTANT VARCHAR2(30) := 'create_orders';
29: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
30: l_msg_count NUMBER;
31: l_msg_data VARCHAR2(2000);
32: l_line_Rec csp_parts_Requirement.line_rec_type;
33: l_order_hdr_rec csp_parts_requirement.header_rec_type;

Line 59: x_return_status := FND_API.G_RET_STS_SUCCESS;

55:
56: BEGIN
57: SAVEPOINT Create_Orders_PUB;
58: -- initialize return status
59: x_return_status := FND_API.G_RET_STS_SUCCESS;
60:
61: l_line_Rec := px_line_Table(1);
62:
63: IF p_repair_supplier_id IS NOT NULL THEN

Line 91: ,p_Init_Msg_List => FND_API.G_TRUE

87:
88: -- call process order
89: csp_parts_order.process_order(
90: p_api_version => l_api_Version_number
91: ,p_Init_Msg_List => FND_API.G_TRUE
92: ,p_commit => FND_API.G_FALSE
93: ,px_header_rec => l_order_hdr_Rec
94: ,px_line_table => l_order_Line_Tbl
95: ,p_process_type => 'BOTH'

Line 92: ,p_commit => FND_API.G_FALSE

88: -- call process order
89: csp_parts_order.process_order(
90: p_api_version => l_api_Version_number
91: ,p_Init_Msg_List => FND_API.G_TRUE
92: ,p_commit => FND_API.G_FALSE
93: ,px_header_rec => l_order_hdr_Rec
94: ,px_line_table => l_order_Line_Tbl
95: ,p_process_type => 'BOTH'
96: ,x_return_status => l_return_status

Line 101: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

97: ,x_msg_count => l_msg_count
98: ,x_msg_data => l_msg_data
99: );
100:
101: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
102: RAISE FND_API.G_EXC_ERROR;
103: ELSE
104: l_IO1_header_id := l_order_hdr_Rec.order_header_id;
105: l_IR1_requisition_id := l_order_hdr_rec.requisition_header_id;

Line 102: RAISE FND_API.G_EXC_ERROR;

98: ,x_msg_data => l_msg_data
99: );
100:
101: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
102: RAISE FND_API.G_EXC_ERROR;
103: ELSE
104: l_IO1_header_id := l_order_hdr_Rec.order_header_id;
105: l_IR1_requisition_id := l_order_hdr_rec.requisition_header_id;
106: END IF;

Line 145: ,p_Init_Msg_List => FND_API.G_TRUE

141:
142: -- call process order
143: csp_parts_order.process_order(
144: p_api_version => l_api_Version_number
145: ,p_Init_Msg_List => FND_API.G_TRUE
146: ,p_commit => FND_API.G_FALSE
147: ,px_header_rec => l_order_hdr_Rec
148: ,px_line_table => l_order_Line_Tbl
149: ,p_process_type => 'BOTH'

Line 146: ,p_commit => FND_API.G_FALSE

142: -- call process order
143: csp_parts_order.process_order(
144: p_api_version => l_api_Version_number
145: ,p_Init_Msg_List => FND_API.G_TRUE
146: ,p_commit => FND_API.G_FALSE
147: ,px_header_rec => l_order_hdr_Rec
148: ,px_line_table => l_order_Line_Tbl
149: ,p_process_type => 'BOTH'
150: ,x_return_status => l_return_status

Line 155: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

151: ,x_msg_count => l_msg_count
152: ,x_msg_data => l_msg_data
153: );
154:
155: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
156: RAISE FND_API.G_EXC_ERROR;
157: ELSE
158: l_IO2_header_id := l_order_hdr_Rec.order_header_id;
159: l_IR2_requisition_id := l_order_hdr_rec.requisition_header_id;

Line 156: RAISE FND_API.G_EXC_ERROR;

152: ,x_msg_data => l_msg_data
153: );
154:
155: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
156: RAISE FND_API.G_EXC_ERROR;
157: ELSE
158: l_IO2_header_id := l_order_hdr_Rec.order_header_id;
159: l_IR2_requisition_id := l_order_hdr_rec.requisition_header_id;
160: END IF;

Line 165: P_init_msg_list => FND_API.G_FALSE,

161:
162: -- create repair order
163: CSD_Refurbish_IRO_GRP.Create_InternalRO(
164: P_api_version => l_api_Version_number,
165: P_init_msg_list => FND_API.G_FALSE,
166: P_commit => FND_API.G_TRUE,
167: P_validation_level => FND_API.G_VALID_LEVEL_FULL,
168: x_return_status => l_return_status,
169: x_msg_count => l_msg_count,

Line 166: P_commit => FND_API.G_TRUE,

162: -- create repair order
163: CSD_Refurbish_IRO_GRP.Create_InternalRO(
164: P_api_version => l_api_Version_number,
165: P_init_msg_list => FND_API.G_FALSE,
166: P_commit => FND_API.G_TRUE,
167: P_validation_level => FND_API.G_VALID_LEVEL_FULL,
168: x_return_status => l_return_status,
169: x_msg_count => l_msg_count,
170: x_msg_data => l_msg_data,

Line 167: P_validation_level => FND_API.G_VALID_LEVEL_FULL,

163: CSD_Refurbish_IRO_GRP.Create_InternalRO(
164: P_api_version => l_api_Version_number,
165: P_init_msg_list => FND_API.G_FALSE,
166: P_commit => FND_API.G_TRUE,
167: P_validation_level => FND_API.G_VALID_LEVEL_FULL,
168: x_return_status => l_return_status,
169: x_msg_count => l_msg_count,
170: x_msg_data => l_msg_data,
171: P_req_header_id_in => l_IR1_requisition_id,

Line 177: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

173: P_req_header_id_out => l_IR2_requisition_id,
174: P_ISO_header_id_out => l_IO2_header_id,
175: x_service_request_number => l_service_Request_number);
176:
177: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
180: px_header_rec.order_header_id := l_IO2_header_id;
181: x_Return_status := FND_API.G_RET_STS_SUCCESS;

Line 178: RAISE FND_API.G_EXC_ERROR;

174: P_ISO_header_id_out => l_IO2_header_id,
175: x_service_request_number => l_service_Request_number);
176:
177: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
180: px_header_rec.order_header_id := l_IO2_header_id;
181: x_Return_status := FND_API.G_RET_STS_SUCCESS;
182: END IF;

Line 181: x_Return_status := FND_API.G_RET_STS_SUCCESS;

177: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
180: px_header_rec.order_header_id := l_IO2_header_id;
181: x_Return_status := FND_API.G_RET_STS_SUCCESS;
182: END IF;
183:
184: EXCEPTION
185: WHEN FND_API.G_EXC_ERROR THEN

Line 185: WHEN FND_API.G_EXC_ERROR THEN

181: x_Return_status := FND_API.G_RET_STS_SUCCESS;
182: END IF;
183:
184: EXCEPTION
185: WHEN FND_API.G_EXC_ERROR THEN
186: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
187: P_API_NAME => L_API_NAME
188: ,P_PKG_NAME => G_PKG_NAME
189: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

190: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
191: ,X_MSG_COUNT => X_MSG_COUNT
192: ,X_MSG_DATA => X_MSG_DATA
193: ,X_RETURN_STATUS => X_RETURN_STATUS);
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
196: P_API_NAME => L_API_NAME
197: ,P_PKG_NAME => G_PKG_NAME
198: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 212: x_return_status := FND_API.G_RET_STS_ERROR;

208: FND_MSG_PUB.ADD;
209: fnd_msg_pub.count_and_get
210: ( p_count => x_msg_count
211: , p_data => x_msg_data);
212: x_return_status := FND_API.G_RET_STS_ERROR;
213: END;
214: END;