DBA Data[Home] [Help]

APPS.CSFW_REQ_PUB dependencies on FND_API

Line 142: P_Init_Msg_List => FND_API.G_FALSE,

138: END IF;
139:
140: CSP_Requirement_headers_PVT.Create_requirement_headers(
141: P_Api_Version_Number => 1.0 ,
142: P_Init_Msg_List => FND_API.G_FALSE,
143: P_Commit => FND_API.G_TRUE,
144: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
145: P_REQUIREMENT_HEADER_Rec => l_req_hdr_rec,
146: X_REQUIREMENT_HEADER_ID => x_header_id ,

Line 143: P_Commit => FND_API.G_TRUE,

139:
140: CSP_Requirement_headers_PVT.Create_requirement_headers(
141: P_Api_Version_Number => 1.0 ,
142: P_Init_Msg_List => FND_API.G_FALSE,
143: P_Commit => FND_API.G_TRUE,
144: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
145: P_REQUIREMENT_HEADER_Rec => l_req_hdr_rec,
146: X_REQUIREMENT_HEADER_ID => x_header_id ,
147: X_Return_Status => l_Return_Status,

Line 144: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

140: CSP_Requirement_headers_PVT.Create_requirement_headers(
141: P_Api_Version_Number => 1.0 ,
142: P_Init_Msg_List => FND_API.G_FALSE,
143: P_Commit => FND_API.G_TRUE,
144: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
145: P_REQUIREMENT_HEADER_Rec => l_req_hdr_rec,
146: X_REQUIREMENT_HEADER_ID => x_header_id ,
147: X_Return_Status => l_Return_Status,
148: X_Msg_Count => l_Msg_Count ,

Line 152: IF l_Return_Status = FND_API.G_RET_STS_SUCCESS

148: X_Msg_Count => l_Msg_Count ,
149: X_Msg_Data => l_Msg_Data
150: );
151:
152: IF l_Return_Status = FND_API.G_RET_STS_SUCCESS
153: THEN
154: /* API-call was successfull */
155: x_error_id := 0;
156: x_error := FND_API.G_RET_STS_SUCCESS;

Line 156: x_error := FND_API.G_RET_STS_SUCCESS;

152: IF l_Return_Status = FND_API.G_RET_STS_SUCCESS
153: THEN
154: /* API-call was successfull */
155: x_error_id := 0;
156: x_error := FND_API.G_RET_STS_SUCCESS;
157: commit work;
158: ELSE
159: FOR l_counter IN 1 .. l_msg_count
160: LOOP

Line 163: , p_encoded => FND_API.G_FALSE

159: FOR l_counter IN 1 .. l_msg_count
160: LOOP
161: fnd_msg_pub.get
162: ( p_msg_index => l_counter
163: , p_encoded => FND_API.G_FALSE
164: , p_data => l_Msg_Data
165: , p_msg_index_out => l_msg_index_out
166: );
167: --dbms_output.put_line( 'Message: '||l_data );

Line 201: P_Init_Msg_List => FND_API.G_FALSE,

197: l_req_hdr_rec.REQUIREMENT_HEADER_ID := p_header_id;
198:
199: CSP_Requirement_headers_PVT.Delete_requirement_headers(
200: P_Api_Version_Number => 1.0,
201: P_Init_Msg_List => FND_API.G_FALSE,
202: P_Commit => FND_API.G_TRUE,
203: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
204: P_REQUIREMENT_HEADER_Rec => l_req_hdr_rec,
205: X_Return_Status => l_Return_Status,

Line 202: P_Commit => FND_API.G_TRUE,

198:
199: CSP_Requirement_headers_PVT.Delete_requirement_headers(
200: P_Api_Version_Number => 1.0,
201: P_Init_Msg_List => FND_API.G_FALSE,
202: P_Commit => FND_API.G_TRUE,
203: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
204: P_REQUIREMENT_HEADER_Rec => l_req_hdr_rec,
205: X_Return_Status => l_Return_Status,
206: X_Msg_Count => l_Msg_Count,

Line 203: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

199: CSP_Requirement_headers_PVT.Delete_requirement_headers(
200: P_Api_Version_Number => 1.0,
201: P_Init_Msg_List => FND_API.G_FALSE,
202: P_Commit => FND_API.G_TRUE,
203: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
204: P_REQUIREMENT_HEADER_Rec => l_req_hdr_rec,
205: X_Return_Status => l_Return_Status,
206: X_Msg_Count => l_Msg_Count,
207: X_Msg_Data => l_Msg_Data

Line 210: IF l_Return_Status = FND_API.G_RET_STS_SUCCESS

206: X_Msg_Count => l_Msg_Count,
207: X_Msg_Data => l_Msg_Data
208: );
209:
210: IF l_Return_Status = FND_API.G_RET_STS_SUCCESS
211: THEN
212: /* API-call was successfull */
213: x_error_id := 0;
214: x_error := FND_API.G_RET_STS_SUCCESS;

Line 214: x_error := FND_API.G_RET_STS_SUCCESS;

210: IF l_Return_Status = FND_API.G_RET_STS_SUCCESS
211: THEN
212: /* API-call was successfull */
213: x_error_id := 0;
214: x_error := FND_API.G_RET_STS_SUCCESS;
215: commit work;
216: ELSE
217: FOR l_counter IN 1 .. l_msg_count
218: LOOP

Line 221: , p_encoded => FND_API.G_FALSE

217: FOR l_counter IN 1 .. l_msg_count
218: LOOP
219: fnd_msg_pub.get
220: ( p_msg_index => l_counter
221: , p_encoded => FND_API.G_FALSE
222: , p_data => l_Msg_Data
223: , p_msg_index_out => l_msg_index_out
224: );
225: --dbms_output.put_line( 'Message: '||l_data );

Line 385: P_Init_Msg_List => FND_API.G_FALSE,

381: -- CALL API
382:
383: CSP_Requirement_Lines_PVT.Create_requirement_lines(
384: P_Api_Version_Number => 1.0,
385: P_Init_Msg_List => FND_API.G_FALSE,
386: P_Commit => FND_API.G_TRUE,
387: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
388: P_Requirement_Line_Tbl => l_req_table,
389: x_Requirement_Line_tbl => l_req_table_tmp,

Line 386: P_Commit => FND_API.G_TRUE,

382:
383: CSP_Requirement_Lines_PVT.Create_requirement_lines(
384: P_Api_Version_Number => 1.0,
385: P_Init_Msg_List => FND_API.G_FALSE,
386: P_Commit => FND_API.G_TRUE,
387: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
388: P_Requirement_Line_Tbl => l_req_table,
389: x_Requirement_Line_tbl => l_req_table_tmp,
390: X_Return_Status => l_Return_Status,

Line 387: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

383: CSP_Requirement_Lines_PVT.Create_requirement_lines(
384: P_Api_Version_Number => 1.0,
385: P_Init_Msg_List => FND_API.G_FALSE,
386: P_Commit => FND_API.G_TRUE,
387: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
388: P_Requirement_Line_Tbl => l_req_table,
389: x_Requirement_Line_tbl => l_req_table_tmp,
390: X_Return_Status => l_Return_Status,
391: X_Msg_Count => l_Msg_Count,

Line 394: IF l_Return_Status = FND_API.G_RET_STS_SUCCESS

390: X_Return_Status => l_Return_Status,
391: X_Msg_Count => l_Msg_Count,
392: X_Msg_Data => l_Msg_Data
393: );
394: IF l_Return_Status = FND_API.G_RET_STS_SUCCESS
395: THEN
396: /* API-call was successfull */
397: x_error_id := 0;
398: x_error := FND_API.G_RET_STS_SUCCESS;

Line 398: x_error := FND_API.G_RET_STS_SUCCESS;

394: IF l_Return_Status = FND_API.G_RET_STS_SUCCESS
395: THEN
396: /* API-call was successfull */
397: x_error_id := 0;
398: x_error := FND_API.G_RET_STS_SUCCESS;
399: l_req_line_rec := l_req_table_tmp(1);
400: x_line_id := l_req_line_rec.REQUIREMENT_LINE_ID;
401: commit work;
402: ELSE

Line 407: , p_encoded => FND_API.G_FALSE

403: FOR l_counter IN 1 .. l_msg_count
404: LOOP
405: fnd_msg_pub.get
406: ( p_msg_index => l_counter
407: , p_encoded => FND_API.G_FALSE
408: , p_data => l_data
409: , p_msg_index_out => l_msg_index_out
410: );
411: -- dbms_output.put_line( 'Message: '||l_data );

Line 450: P_Init_Msg_List => FND_API.G_FALSE,

446:
447: --dbms_output.put_line( 'Calling API');
448: CSP_Requirement_Lines_PVT.Delete_requirement_lines(
449: P_Api_Version_Number => 1.0,
450: P_Init_Msg_List => FND_API.G_FALSE,
451: P_Commit => FND_API.G_TRUE,
452: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
453: P_Requirement_Line_Tbl => l_req_table,
454: X_Return_Status => l_Return_Status,

Line 451: P_Commit => FND_API.G_TRUE,

447: --dbms_output.put_line( 'Calling API');
448: CSP_Requirement_Lines_PVT.Delete_requirement_lines(
449: P_Api_Version_Number => 1.0,
450: P_Init_Msg_List => FND_API.G_FALSE,
451: P_Commit => FND_API.G_TRUE,
452: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
453: P_Requirement_Line_Tbl => l_req_table,
454: X_Return_Status => l_Return_Status,
455: X_Msg_Count => l_Msg_Count,

Line 452: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

448: CSP_Requirement_Lines_PVT.Delete_requirement_lines(
449: P_Api_Version_Number => 1.0,
450: P_Init_Msg_List => FND_API.G_FALSE,
451: P_Commit => FND_API.G_TRUE,
452: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
453: P_Requirement_Line_Tbl => l_req_table,
454: X_Return_Status => l_Return_Status,
455: X_Msg_Count => l_Msg_Count,
456: X_Msg_Data => l_data

Line 460: IF l_Return_Status = FND_API.G_RET_STS_SUCCESS

456: X_Msg_Data => l_data
457: );
458:
459:
460: IF l_Return_Status = FND_API.G_RET_STS_SUCCESS
461: THEN
462: x_error_id := 0;
463: x_error := FND_API.G_RET_STS_SUCCESS;
464: ELSE

Line 463: x_error := FND_API.G_RET_STS_SUCCESS;

459:
460: IF l_Return_Status = FND_API.G_RET_STS_SUCCESS
461: THEN
462: x_error_id := 0;
463: x_error := FND_API.G_RET_STS_SUCCESS;
464: ELSE
465: FOR l_counter IN 1 .. l_msg_count
466: LOOP
467: fnd_msg_pub.get

Line 469: , p_encoded => FND_API.G_FALSE

465: FOR l_counter IN 1 .. l_msg_count
466: LOOP
467: fnd_msg_pub.get
468: ( p_msg_index => l_counter
469: , p_encoded => FND_API.G_FALSE
470: , p_data => l_data
471: , p_msg_index_out => l_msg_index_out
472: );
473: --dbms_output.put_line( 'Message: '||l_data);