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

Line 34: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

30: -- Parameters :
31: --
32: -- Standard IN Parameters :
33: -- p_api_version IN NUMBER Required
34: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
35: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
36: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
37: -- Based on this flag, the API will set the default attributes.
38: -- p_module_type In VARCHAR2 Default NULL

Line 35: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

31: --
32: -- Standard IN Parameters :
33: -- p_api_version IN NUMBER Required
34: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
35: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
36: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
37: -- Based on this flag, the API will set the default attributes.
38: -- p_module_type In VARCHAR2 Default NULL
39: -- This will be null.

Line 36: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

32: -- Standard IN Parameters :
33: -- p_api_version IN NUMBER Required
34: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
35: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
36: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
37: -- Based on this flag, the API will set the default attributes.
38: -- p_module_type In VARCHAR2 Default NULL
39: -- This will be null.
40: -- Standard OUT Parameters :

Line 51: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

47: -- List of item attributes associated to visit task
48: --
49: PROCEDURE Check_Material_Aval (
50: p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
52: p_commit IN VARCHAR2 := FND_API.g_false,
53: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
54: p_module_type IN VARCHAR2 := 'JSP',
55: p_x_material_avl_tbl IN OUT NOCOPY Material_Availability_Tbl,

Line 52: p_commit IN VARCHAR2 := FND_API.g_false,

48: --
49: PROCEDURE Check_Material_Aval (
50: p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
52: p_commit IN VARCHAR2 := FND_API.g_false,
53: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
54: p_module_type IN VARCHAR2 := 'JSP',
55: p_x_material_avl_tbl IN OUT NOCOPY Material_Availability_Tbl,
56: x_return_status OUT NOCOPY VARCHAR2,

Line 53: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

49: PROCEDURE Check_Material_Aval (
50: p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
52: p_commit IN VARCHAR2 := FND_API.g_false,
53: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
54: p_module_type IN VARCHAR2 := 'JSP',
55: p_x_material_avl_tbl IN OUT NOCOPY Material_Availability_Tbl,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,

Line 66: l_commit VARCHAR2(10) := FND_API.g_false;

62: l_api_version CONSTANT NUMBER := 1.0;
63: l_msg_count NUMBER;
64: l_return_status VARCHAR2(1);
65: l_msg_data VARCHAR2(2000);
66: l_commit VARCHAR2(10) := FND_API.g_false;
67: l_material_avl_tbl Material_Availability_Tbl := p_x_material_avl_tbl;
68: BEGIN
69:
70: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 84: IF FND_API.to_boolean(p_init_msg_list)

80: --------------------Initialize ----------------------------------
81: -- Standard Start of API savepoint
82: SAVEPOINT check_material_aval;
83: -- Standard call to check for call compatibility.
84: IF FND_API.to_boolean(p_init_msg_list)
85: THEN
86: FND_MSG_PUB.initialize;
87: END IF;
88: -- Initialize API return status to success

Line 89: x_return_status := FND_API.G_RET_STS_SUCCESS;

85: THEN
86: FND_MSG_PUB.initialize;
87: END IF;
88: -- Initialize API return status to success
89: x_return_status := FND_API.G_RET_STS_SUCCESS;
90: -- Initialize message list if p_init_msg_list is set to TRUE.
91: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
92: p_api_version,
93: l_api_name,G_PKG_NAME)

Line 91: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

87: END IF;
88: -- Initialize API return status to success
89: x_return_status := FND_API.G_RET_STS_SUCCESS;
90: -- Initialize message list if p_init_msg_list is set to TRUE.
91: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
92: p_api_version,
93: l_api_name,G_PKG_NAME)
94: THEN
95: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 95: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

91: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
92: p_api_version,
93: l_api_name,G_PKG_NAME)
94: THEN
95: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
96: END IF;
97: --------------------Start of API Body-----------------------------------
98: IF l_material_avl_tbl.COUNT > 0 THEN
99: --

Line 138: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

134: );
135: END IF;
136:
137: -- Check Error Message stack.
138: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
139: l_msg_count := FND_MSG_PUB.count_msg;
140: IF l_msg_count > 0 THEN
141: RAISE FND_API.G_EXC_ERROR;
142: END IF;

Line 141: RAISE FND_API.G_EXC_ERROR;

137: -- Check Error Message stack.
138: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
139: l_msg_count := FND_MSG_PUB.count_msg;
140: IF l_msg_count > 0 THEN
141: RAISE FND_API.G_EXC_ERROR;
142: END IF;
143: END IF;
144: --Assign derived values
145: IF l_material_avl_tbl.COUNT > 0 THEN

Line 201: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

197: END LOOP;
198: END IF;
199: ------------------------End of Body---------------------------------------
200: --Standard check to count messages
201: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
202: l_msg_count := FND_MSG_PUB.count_msg;
203: IF l_msg_count > 0 THEN
204: RAISE FND_API.G_EXC_ERROR;
205: END IF;

Line 204: RAISE FND_API.G_EXC_ERROR;

200: --Standard check to count messages
201: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
202: l_msg_count := FND_MSG_PUB.count_msg;
203: IF l_msg_count > 0 THEN
204: RAISE FND_API.G_EXC_ERROR;
205: END IF;
206: END IF;
207:
208: --Standard check for commit

Line 209: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

205: END IF;
206: END IF;
207:
208: --Standard check for commit
209: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
210: COMMIT;
211: END IF;
212:
213: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

219: );
220: END IF;
221:
222: EXCEPTION
223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
224: ROLLBACK TO check_material_aval;
225: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
227: p_count => x_msg_count,

Line 225: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

221:
222: EXCEPTION
223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
224: ROLLBACK TO check_material_aval;
225: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
227: p_count => x_msg_count,
228: p_data => x_msg_data);
229:

Line 226: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

222: EXCEPTION
223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
224: ROLLBACK TO check_material_aval;
225: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
227: p_count => x_msg_count,
228: p_data => x_msg_data);
229:
230: WHEN FND_API.G_EXC_ERROR THEN

Line 230: WHEN FND_API.G_EXC_ERROR THEN

226: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
227: p_count => x_msg_count,
228: p_data => x_msg_data);
229:
230: WHEN FND_API.G_EXC_ERROR THEN
231: ROLLBACK TO check_material_aval;
232: X_return_status := FND_API.G_RET_STS_ERROR;
233: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
234: p_count => x_msg_count,

Line 232: X_return_status := FND_API.G_RET_STS_ERROR;

228: p_data => x_msg_data);
229:
230: WHEN FND_API.G_EXC_ERROR THEN
231: ROLLBACK TO check_material_aval;
232: X_return_status := FND_API.G_RET_STS_ERROR;
233: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
234: p_count => x_msg_count,
235: p_data => X_msg_data);
236:

Line 233: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

229:
230: WHEN FND_API.G_EXC_ERROR THEN
231: ROLLBACK TO check_material_aval;
232: X_return_status := FND_API.G_RET_STS_ERROR;
233: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
234: p_count => x_msg_count,
235: p_data => X_msg_data);
236:
237: WHEN OTHERS THEN

Line 239: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

235: p_data => X_msg_data);
236:
237: WHEN OTHERS THEN
238: ROLLBACK TO check_material_aval;
239: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
241: THEN
242: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
243: p_procedure_name => 'CHECK_MATERIAL_AVAL',

Line 246: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

242: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
243: p_procedure_name => 'CHECK_MATERIAL_AVAL',
244: p_error_text => SUBSTR(SQLERRM,1,240));
245: END IF;
246: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
247: p_count => x_msg_count,
248: p_data => X_msg_data);
249:
250: END Check_Material_Aval;

Line 262: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

258: -- Parameters :
259: --
260: -- Standard IN Parameters :
261: -- p_api_version IN NUMBER Required
262: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
263: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
264: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
265: -- Based on this flag, the API will set the default attributes.
266: -- p_module_type In VARCHAR2 Default NULL

Line 263: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

259: --
260: -- Standard IN Parameters :
261: -- p_api_version IN NUMBER Required
262: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
263: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
264: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
265: -- Based on this flag, the API will set the default attributes.
266: -- p_module_type In VARCHAR2 Default NULL
267: -- This will be null.

Line 264: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

260: -- Standard IN Parameters :
261: -- p_api_version IN NUMBER Required
262: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
263: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
264: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
265: -- Based on this flag, the API will set the default attributes.
266: -- p_module_type In VARCHAR2 Default NULL
267: -- This will be null.
268: -- Standard OUT Parameters :

Line 278: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

274: -- p_visit_id IN NUMBER,Required
275: --
276: PROCEDURE Get_Visit_Task_Materials (
277: p_api_version IN NUMBER,
278: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
279: p_commit IN VARCHAR2 := FND_API.g_false,
280: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
281: p_module_type IN VARCHAR2 := 'JSP',
282: p_visit_id IN NUMBER,

Line 279: p_commit IN VARCHAR2 := FND_API.g_false,

275: --
276: PROCEDURE Get_Visit_Task_Materials (
277: p_api_version IN NUMBER,
278: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
279: p_commit IN VARCHAR2 := FND_API.g_false,
280: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
281: p_module_type IN VARCHAR2 := 'JSP',
282: p_visit_id IN NUMBER,
283: x_task_req_matrl_tbl OUT NOCOPY Task_Req_Matrl_Tbl,

Line 280: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

276: PROCEDURE Get_Visit_Task_Materials (
277: p_api_version IN NUMBER,
278: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
279: p_commit IN VARCHAR2 := FND_API.g_false,
280: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
281: p_module_type IN VARCHAR2 := 'JSP',
282: p_visit_id IN NUMBER,
283: x_task_req_matrl_tbl OUT NOCOPY Task_Req_Matrl_Tbl,
284: x_return_status OUT NOCOPY VARCHAR2,

Line 310: IF FND_API.to_boolean(p_init_msg_list)

306: END IF;
307: -- Standard Start of API savepoint
308: SAVEPOINT get_visit_task_materials;
309: -- Initialize message list if p_init_msg_list is set to TRUE.
310: IF FND_API.to_boolean(p_init_msg_list)
311: THEN
312: FND_MSG_PUB.initialize;
313: END IF;
314: -- Initialize API return status to success

Line 315: x_return_status := FND_API.G_RET_STS_SUCCESS;

311: THEN
312: FND_MSG_PUB.initialize;
313: END IF;
314: -- Initialize API return status to success
315: x_return_status := FND_API.G_RET_STS_SUCCESS;
316: -- Standard call to check for call compatibility.
317: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
318: p_api_version,
319: l_api_name,G_PKG_NAME)

Line 317: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

313: END IF;
314: -- Initialize API return status to success
315: x_return_status := FND_API.G_RET_STS_SUCCESS;
316: -- Standard call to check for call compatibility.
317: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
318: p_api_version,
319: l_api_name,G_PKG_NAME)
320: THEN
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

317: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
318: p_api_version,
319: l_api_name,G_PKG_NAME)
320: THEN
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
322: END IF;
323:
324: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
325: fnd_log.string

Line 344: IF p_visit_id IS NOT NULL AND p_visit_id <> FND_API.G_MISS_NUM

340: );
341:
342: END IF;
343:
344: IF p_visit_id IS NOT NULL AND p_visit_id <> FND_API.G_MISS_NUM
345: THEN
346:
347: AHL_LTP_MATRL_AVAL_PVT.Get_Visit_Task_Materials
348: (p_api_version => p_api_version,

Line 367: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

363: );
364: END IF;
365:
366: -- Check Error Message stack.
367: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
368: l_msg_count := FND_MSG_PUB.count_msg;
369: IF l_msg_count > 0 THEN
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;

Line 370: RAISE FND_API.G_EXC_ERROR;

366: -- Check Error Message stack.
367: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
368: l_msg_count := FND_MSG_PUB.count_msg;
369: IF l_msg_count > 0 THEN
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372: END IF;
373:
374: IF l_task_req_matrl_tbl.COUNT > 0 THEN

Line 461: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

457: END IF;
458: END IF;
459:
460: -- Check Error Message stack.
461: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
462: l_msg_count := FND_MSG_PUB.count_msg;
463: IF l_msg_count > 0 THEN
464: RAISE FND_API.G_EXC_ERROR;
465: END IF;

Line 464: RAISE FND_API.G_EXC_ERROR;

460: -- Check Error Message stack.
461: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
462: l_msg_count := FND_MSG_PUB.count_msg;
463: IF l_msg_count > 0 THEN
464: RAISE FND_API.G_EXC_ERROR;
465: END IF;
466: END IF;
467:
468: --Standard check for commit

Line 469: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

465: END IF;
466: END IF;
467:
468: --Standard check for commit
469: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
470: COMMIT;
471: END IF;
472:
473: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

479: );
480: END IF;
481:
482: EXCEPTION
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO get_visit_task_materials;
485: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
487: p_count => x_msg_count,

Line 485: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

481:
482: EXCEPTION
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO get_visit_task_materials;
485: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
487: p_count => x_msg_count,
488: p_data => x_msg_data);
489:

Line 486: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

482: EXCEPTION
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO get_visit_task_materials;
485: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
487: p_count => x_msg_count,
488: p_data => x_msg_data);
489:
490: WHEN FND_API.G_EXC_ERROR THEN

Line 490: WHEN FND_API.G_EXC_ERROR THEN

486: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
487: p_count => x_msg_count,
488: p_data => x_msg_data);
489:
490: WHEN FND_API.G_EXC_ERROR THEN
491: ROLLBACK TO get_visit_task_materials;
492: X_return_status := FND_API.G_RET_STS_ERROR;
493: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
494: p_count => x_msg_count,

Line 492: X_return_status := FND_API.G_RET_STS_ERROR;

488: p_data => x_msg_data);
489:
490: WHEN FND_API.G_EXC_ERROR THEN
491: ROLLBACK TO get_visit_task_materials;
492: X_return_status := FND_API.G_RET_STS_ERROR;
493: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
494: p_count => x_msg_count,
495: p_data => X_msg_data);
496:

Line 493: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

489:
490: WHEN FND_API.G_EXC_ERROR THEN
491: ROLLBACK TO get_visit_task_materials;
492: X_return_status := FND_API.G_RET_STS_ERROR;
493: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
494: p_count => x_msg_count,
495: p_data => X_msg_data);
496:
497: WHEN OTHERS THEN

Line 499: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

495: p_data => X_msg_data);
496:
497: WHEN OTHERS THEN
498: ROLLBACK TO get_visit_task_materials;
499: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
501: THEN
502: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
503: p_procedure_name => 'GET_VISIT_TASK_MATERIALS',

Line 506: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

502: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
503: p_procedure_name => 'GET_VISIT_TASK_MATERIALS',
504: p_error_text => SUBSTR(SQLERRM,1,240));
505: END IF;
506: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
507: p_count => x_msg_count,
508: p_data => X_msg_data);
509: END Get_Visit_Task_Materials;
510:

Line 521: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

517: -- Parameters :
518: --
519: -- Standard IN Parameters :
520: -- p_api_version IN NUMBER Required
521: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
522: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
523: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
524: -- Based on this flag, the API will set the default attributes.
525: -- p_module_type In VARCHAR2 Default NULL

Line 522: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

518: --
519: -- Standard IN Parameters :
520: -- p_api_version IN NUMBER Required
521: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
522: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
523: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
524: -- Based on this flag, the API will set the default attributes.
525: -- p_module_type In VARCHAR2 Default NULL
526: -- This will be null.

Line 523: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

519: -- Standard IN Parameters :
520: -- p_api_version IN NUMBER Required
521: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
522: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
523: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
524: -- Based on this flag, the API will set the default attributes.
525: -- p_module_type In VARCHAR2 Default NULL
526: -- This will be null.
527: -- Standard OUT Parameters :

Line 538: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

534: -- List of item attributes associated to visit task
535: --
536: PROCEDURE Check_Materials_For_All (
537: p_api_version IN NUMBER,
538: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
539: p_commit IN VARCHAR2 := FND_API.g_false,
540: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
541: p_module_type IN VARCHAR2 := 'JSP',
542: p_visit_id IN NUMBER,

Line 539: p_commit IN VARCHAR2 := FND_API.g_false,

535: --
536: PROCEDURE Check_Materials_For_All (
537: p_api_version IN NUMBER,
538: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
539: p_commit IN VARCHAR2 := FND_API.g_false,
540: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
541: p_module_type IN VARCHAR2 := 'JSP',
542: p_visit_id IN NUMBER,
543: x_task_matrl_aval_tbl OUT NOCOPY Material_Availability_Tbl,

Line 540: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

536: PROCEDURE Check_Materials_For_All (
537: p_api_version IN NUMBER,
538: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
539: p_commit IN VARCHAR2 := FND_API.g_false,
540: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
541: p_module_type IN VARCHAR2 := 'JSP',
542: p_visit_id IN NUMBER,
543: x_task_matrl_aval_tbl OUT NOCOPY Material_Availability_Tbl,
544: x_return_status OUT NOCOPY VARCHAR2,

Line 585: IF FND_API.to_boolean(p_init_msg_list)

581: --------------------Initialize ----------------------------------
582: -- Standard Start of API savepoint
583: SAVEPOINT check_materials_for_all;
584: -- Standard call to check for call compatibility.
585: IF FND_API.to_boolean(p_init_msg_list)
586: THEN
587: FND_MSG_PUB.initialize;
588: END IF;
589: -- Initialize API return status to success

Line 590: x_return_status := FND_API.G_RET_STS_SUCCESS;

586: THEN
587: FND_MSG_PUB.initialize;
588: END IF;
589: -- Initialize API return status to success
590: x_return_status := FND_API.G_RET_STS_SUCCESS;
591: -- Initialize message list if p_init_msg_list is set to TRUE.
592: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
593: p_api_version,
594: l_api_name,G_PKG_NAME)

Line 592: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

588: END IF;
589: -- Initialize API return status to success
590: x_return_status := FND_API.G_RET_STS_SUCCESS;
591: -- Initialize message list if p_init_msg_list is set to TRUE.
592: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
593: p_api_version,
594: l_api_name,G_PKG_NAME)
595: THEN
596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

592: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
593: p_api_version,
594: l_api_name,G_PKG_NAME)
595: THEN
596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
597: END IF;
598: --------------------Start of API Body-----------------------------------
599: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
600: fnd_log.string

Line 609: IF p_visit_id IS NOT NULL AND p_visit_id <> FND_API.G_MISS_NUM

605: );
606:
607: END IF;
608:
609: IF p_visit_id IS NOT NULL AND p_visit_id <> FND_API.G_MISS_NUM
610: THEN
611:
612: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
613: fnd_log.string

Line 629: RAISE Fnd_Api.G_EXC_ERROR;

625: IF c_any_task_in_planning%NOTFOUND THEN
626: Fnd_Message.SET_NAME('AHL','AHL_LTP_CHK_AVL_ALL_NONE_PLAN');
627: Fnd_Msg_Pub.ADD;
628: CLOSE c_any_task_in_planning;
629: RAISE Fnd_Api.G_EXC_ERROR;
630: END IF;
631: CLOSE c_any_task_in_planning;
632:
633:

Line 654: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

650: );
651: END IF;
652:
653: -- Check Error Message stack.
654: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
655: l_msg_count := FND_MSG_PUB.count_msg;
656: IF l_msg_count > 0 THEN
657: RAISE FND_API.G_EXC_ERROR;
658: END IF;

Line 657: RAISE FND_API.G_EXC_ERROR;

653: -- Check Error Message stack.
654: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
655: l_msg_count := FND_MSG_PUB.count_msg;
656: IF l_msg_count > 0 THEN
657: RAISE FND_API.G_EXC_ERROR;
658: END IF;
659: END IF;
660:
661: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 723: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

719: );
720: END IF;
721:
722: -- Check Error Message stack.
723: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
724: l_msg_count := FND_MSG_PUB.count_msg;
725: IF l_msg_count > 0 THEN
726: RAISE FND_API.G_EXC_ERROR;
727: END IF;

Line 726: RAISE FND_API.G_EXC_ERROR;

722: -- Check Error Message stack.
723: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
724: l_msg_count := FND_MSG_PUB.count_msg;
725: IF l_msg_count > 0 THEN
726: RAISE FND_API.G_EXC_ERROR;
727: END IF;
728: END IF;
729:
730: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 801: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

797: END IF;
798:
799: ------------------------End of Body---------------------------------------
800: --Standard check to count messages
801: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
802: l_msg_count := FND_MSG_PUB.count_msg;
803: IF l_msg_count > 0 THEN
804: RAISE FND_API.G_EXC_ERROR;
805: END IF;

Line 804: RAISE FND_API.G_EXC_ERROR;

800: --Standard check to count messages
801: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
802: l_msg_count := FND_MSG_PUB.count_msg;
803: IF l_msg_count > 0 THEN
804: RAISE FND_API.G_EXC_ERROR;
805: END IF;
806: END IF;
807:
808: --Standard check for commit

Line 809: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

805: END IF;
806: END IF;
807:
808: --Standard check for commit
809: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
810: COMMIT;
811: END IF;
812: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
813: fnd_log.string

Line 822: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

818: );
819: END IF;
820:
821: EXCEPTION
822: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
823: ROLLBACK TO check_materials_for_all;
824: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
825: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
826: p_count => x_msg_count,

Line 824: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

820:
821: EXCEPTION
822: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
823: ROLLBACK TO check_materials_for_all;
824: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
825: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
826: p_count => x_msg_count,
827: p_data => x_msg_data);
828:

Line 825: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

821: EXCEPTION
822: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
823: ROLLBACK TO check_materials_for_all;
824: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
825: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
826: p_count => x_msg_count,
827: p_data => x_msg_data);
828:
829: WHEN FND_API.G_EXC_ERROR THEN

Line 829: WHEN FND_API.G_EXC_ERROR THEN

825: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
826: p_count => x_msg_count,
827: p_data => x_msg_data);
828:
829: WHEN FND_API.G_EXC_ERROR THEN
830: ROLLBACK TO check_materials_for_all;
831: X_return_status := FND_API.G_RET_STS_ERROR;
832: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
833: p_count => x_msg_count,

Line 831: X_return_status := FND_API.G_RET_STS_ERROR;

827: p_data => x_msg_data);
828:
829: WHEN FND_API.G_EXC_ERROR THEN
830: ROLLBACK TO check_materials_for_all;
831: X_return_status := FND_API.G_RET_STS_ERROR;
832: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
833: p_count => x_msg_count,
834: p_data => X_msg_data);
835:

Line 832: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

828:
829: WHEN FND_API.G_EXC_ERROR THEN
830: ROLLBACK TO check_materials_for_all;
831: X_return_status := FND_API.G_RET_STS_ERROR;
832: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
833: p_count => x_msg_count,
834: p_data => X_msg_data);
835:
836: WHEN OTHERS THEN

Line 838: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

834: p_data => X_msg_data);
835:
836: WHEN OTHERS THEN
837: ROLLBACK TO check_materials_for_all;
838: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
840: THEN
841: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
842: p_procedure_name => 'CHECK_MATERIALS_FOR_ALL',

Line 845: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

841: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
842: p_procedure_name => 'CHECK_MATERIALS_FOR_ALL',
843: p_error_text => SUBSTR(SQLERRM,1,240));
844: END IF;
845: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
846: p_count => x_msg_count,
847: p_data => X_msg_data);
848:
849: END Check_Materials_For_All;

Line 861: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

857: -- Parameters :
858: --
859: -- Standard IN Parameters :
860: -- p_api_version IN NUMBER Required
861: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
862: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
863: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
864: -- Based on this flag, the API will set the default attributes.
865: -- p_module_type In VARCHAR2 Default NULL

Line 862: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

858: --
859: -- Standard IN Parameters :
860: -- p_api_version IN NUMBER Required
861: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
862: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
863: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
864: -- Based on this flag, the API will set the default attributes.
865: -- p_module_type In VARCHAR2 Default NULL
866: -- This will be null.

Line 863: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

859: -- Standard IN Parameters :
860: -- p_api_version IN NUMBER Required
861: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
862: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
863: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
864: -- Based on this flag, the API will set the default attributes.
865: -- p_module_type In VARCHAR2 Default NULL
866: -- This will be null.
867: -- Standard OUT Parameters :

Line 878: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

874: -- List of item attributes associated to visit task
875: --
876: PROCEDURE Schedule_Planned_Matrls (
877: p_api_version IN NUMBER,
878: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
879: p_commit IN VARCHAR2 := FND_API.g_false,
880: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
881: p_module_type IN VARCHAR2 := 'JSP',
882: p_x_planned_matrl_tbl IN OUT NOCOPY Planned_Matrl_Tbl,

Line 879: p_commit IN VARCHAR2 := FND_API.g_false,

875: --
876: PROCEDURE Schedule_Planned_Matrls (
877: p_api_version IN NUMBER,
878: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
879: p_commit IN VARCHAR2 := FND_API.g_false,
880: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
881: p_module_type IN VARCHAR2 := 'JSP',
882: p_x_planned_matrl_tbl IN OUT NOCOPY Planned_Matrl_Tbl,
883: x_return_status OUT NOCOPY VARCHAR2,

Line 880: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

876: PROCEDURE Schedule_Planned_Matrls (
877: p_api_version IN NUMBER,
878: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
879: p_commit IN VARCHAR2 := FND_API.g_false,
880: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
881: p_module_type IN VARCHAR2 := 'JSP',
882: p_x_planned_matrl_tbl IN OUT NOCOPY Planned_Matrl_Tbl,
883: x_return_status OUT NOCOPY VARCHAR2,
884: x_msg_count OUT NOCOPY NUMBER,

Line 895: l_commit VARCHAR2(10) := FND_API.g_false;

891: l_msg_count NUMBER;
892: l_return_status VARCHAR2(1);
893: l_mat_return_status VARCHAR2(1);
894: l_msg_data VARCHAR2(2000);
895: l_commit VARCHAR2(10) := FND_API.g_false;
896: --
897: l_planned_matrl_tbl Planned_Matrl_Tbl := p_x_planned_matrl_tbl;
898:
899: BEGIN

Line 913: IF FND_API.to_boolean(p_init_msg_list)

909:
910: -- Standard Start of API savepoint
911: SAVEPOINT Schedule_Planned_Matrls;
912: -- Initialize message list if p_init_msg_list is set to TRUE.
913: IF FND_API.to_boolean(p_init_msg_list)
914: THEN
915: FND_MSG_PUB.initialize;
916: END IF;
917: -- Initialize API return status to success

Line 918: x_return_status := FND_API.G_RET_STS_SUCCESS;

914: THEN
915: FND_MSG_PUB.initialize;
916: END IF;
917: -- Initialize API return status to success
918: x_return_status := FND_API.G_RET_STS_SUCCESS;
919: -- Standard call to check for call compatibility.
920: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
921: p_api_version,
922: l_api_name,G_PKG_NAME)

Line 920: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

916: END IF;
917: -- Initialize API return status to success
918: x_return_status := FND_API.G_RET_STS_SUCCESS;
919: -- Standard call to check for call compatibility.
920: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
921: p_api_version,
922: l_api_name,G_PKG_NAME)
923: THEN
924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

920: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
921: p_api_version,
922: l_api_name,G_PKG_NAME)
923: THEN
924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
925: END IF;
926:
927: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
928: fnd_log.string

Line 968: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

964: );
965: END IF;
966:
967: -- Check Error Message stack.
968: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
969: l_msg_count := FND_MSG_PUB.count_msg;
970: IF l_msg_count > 0 THEN
971: RAISE FND_API.G_EXC_ERROR;
972: END IF;

Line 971: RAISE FND_API.G_EXC_ERROR;

967: -- Check Error Message stack.
968: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
969: l_msg_count := FND_MSG_PUB.count_msg;
970: IF l_msg_count > 0 THEN
971: RAISE FND_API.G_EXC_ERROR;
972: END IF;
973: END IF;
974: IF l_planned_matrl_tbl.COUNT > 0 THEN
975: FOR i IN l_planned_matrl_tbl.FIRST..l_planned_matrl_tbl.LAST

Line 1021: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

1017:
1018: END LOOP;
1019: END IF;
1020: --Standard check for commit
1021: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1022: COMMIT;
1023: END IF;
1024:
1025: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 1036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1032: END IF;
1033:
1034: EXCEPTION
1035:
1036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1037: ROLLBACK TO Schedule_Planned_Matrls;
1038: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1039: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1040: p_count => x_msg_count,

Line 1038: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1034: EXCEPTION
1035:
1036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1037: ROLLBACK TO Schedule_Planned_Matrls;
1038: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1039: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1040: p_count => x_msg_count,
1041: p_data => x_msg_data);
1042:

Line 1039: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1035:
1036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1037: ROLLBACK TO Schedule_Planned_Matrls;
1038: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1039: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1040: p_count => x_msg_count,
1041: p_data => x_msg_data);
1042:
1043: WHEN FND_API.G_EXC_ERROR THEN

Line 1043: WHEN FND_API.G_EXC_ERROR THEN

1039: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1040: p_count => x_msg_count,
1041: p_data => x_msg_data);
1042:
1043: WHEN FND_API.G_EXC_ERROR THEN
1044: ROLLBACK TO Schedule_Planned_Matrls;
1045: X_return_status := FND_API.G_RET_STS_ERROR;
1046: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1047: p_count => x_msg_count,

Line 1045: X_return_status := FND_API.G_RET_STS_ERROR;

1041: p_data => x_msg_data);
1042:
1043: WHEN FND_API.G_EXC_ERROR THEN
1044: ROLLBACK TO Schedule_Planned_Matrls;
1045: X_return_status := FND_API.G_RET_STS_ERROR;
1046: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1047: p_count => x_msg_count,
1048: p_data => X_msg_data);
1049:

Line 1046: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1042:
1043: WHEN FND_API.G_EXC_ERROR THEN
1044: ROLLBACK TO Schedule_Planned_Matrls;
1045: X_return_status := FND_API.G_RET_STS_ERROR;
1046: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1047: p_count => x_msg_count,
1048: p_data => X_msg_data);
1049:
1050: WHEN OTHERS THEN

Line 1052: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1048: p_data => X_msg_data);
1049:
1050: WHEN OTHERS THEN
1051: ROLLBACK TO Schedule_Planned_Matrls;
1052: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1054: THEN
1055: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
1056: p_procedure_name => 'SCHEDULE_PLANNED_MATRLS',

Line 1059: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1055: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
1056: p_procedure_name => 'SCHEDULE_PLANNED_MATRLS',
1057: p_error_text => SUBSTR(SQLERRM,1,240));
1058: END IF;
1059: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1060: p_count => x_msg_count,
1061: p_data => X_msg_data);
1062:
1063: END Schedule_Planned_Matrls;

Line 1075: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

1071: -- Parameters :
1072: --
1073: -- Standard IN Parameters :
1074: -- p_api_version IN NUMBER Required
1075: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1076: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1077: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1078: -- Based on this flag, the API will set the default attributes.
1079: -- p_module_type In VARCHAR2 Default NULL

Line 1076: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

1072: --
1073: -- Standard IN Parameters :
1074: -- p_api_version IN NUMBER Required
1075: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1076: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1077: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1078: -- Based on this flag, the API will set the default attributes.
1079: -- p_module_type In VARCHAR2 Default NULL
1080: -- This will be null.

Line 1077: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

1073: -- Standard IN Parameters :
1074: -- p_api_version IN NUMBER Required
1075: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1076: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1077: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1078: -- Based on this flag, the API will set the default attributes.
1079: -- p_module_type In VARCHAR2 Default NULL
1080: -- This will be null.
1081: -- Standard OUT Parameters :

Line 1092: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1088: -- List of item attributes associated to visit task
1089: --
1090: PROCEDURE Schedule_All_Materials (
1091: p_api_version IN NUMBER,
1092: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1093: p_commit IN VARCHAR2 := FND_API.g_false,
1094: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1095: p_module_type IN VARCHAR2 := 'JSP',
1096: p_visit_id IN NUMBER,

Line 1093: p_commit IN VARCHAR2 := FND_API.g_false,

1089: --
1090: PROCEDURE Schedule_All_Materials (
1091: p_api_version IN NUMBER,
1092: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1093: p_commit IN VARCHAR2 := FND_API.g_false,
1094: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1095: p_module_type IN VARCHAR2 := 'JSP',
1096: p_visit_id IN NUMBER,
1097: x_planned_matrl_tbl OUT NOCOPY Planned_Matrl_Tbl,

Line 1094: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

1090: PROCEDURE Schedule_All_Materials (
1091: p_api_version IN NUMBER,
1092: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1093: p_commit IN VARCHAR2 := FND_API.g_false,
1094: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1095: p_module_type IN VARCHAR2 := 'JSP',
1096: p_visit_id IN NUMBER,
1097: x_planned_matrl_tbl OUT NOCOPY Planned_Matrl_Tbl,
1098: x_return_status OUT NOCOPY VARCHAR2,

Line 1118: l_commit VARCHAR2(10) := FND_API.g_false;

1114: l_api_version CONSTANT NUMBER := 1.0;
1115: l_msg_count NUMBER;
1116: l_return_status VARCHAR2(1);
1117: l_msg_data VARCHAR2(2000);
1118: l_commit VARCHAR2(10) := FND_API.g_false;
1119: l_planned_matrl_tbl Planned_Matrl_Tbl;
1120:
1121: BEGIN
1122:

Line 1135: IF FND_API.to_boolean(p_init_msg_list)

1131:
1132: -- Standard Start of API savepoint
1133: SAVEPOINT Schedule_All_Materials;
1134: -- Initialize message list if p_init_msg_list is set to TRUE.
1135: IF FND_API.to_boolean(p_init_msg_list)
1136: THEN
1137: FND_MSG_PUB.initialize;
1138: END IF;
1139: -- Initialize API return status to success

Line 1140: x_return_status := FND_API.G_RET_STS_SUCCESS;

1136: THEN
1137: FND_MSG_PUB.initialize;
1138: END IF;
1139: -- Initialize API return status to success
1140: x_return_status := FND_API.G_RET_STS_SUCCESS;
1141: -- Standard call to check for call compatibility.
1142: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1143: p_api_version,
1144: l_api_name,G_PKG_NAME)

Line 1142: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

1138: END IF;
1139: -- Initialize API return status to success
1140: x_return_status := FND_API.G_RET_STS_SUCCESS;
1141: -- Standard call to check for call compatibility.
1142: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1143: p_api_version,
1144: l_api_name,G_PKG_NAME)
1145: THEN
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1142: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1143: p_api_version,
1144: l_api_name,G_PKG_NAME)
1145: THEN
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: END IF;
1148:
1149: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1150: fnd_log.string

Line 1176: RAISE Fnd_Api.G_EXC_ERROR;

1172: IF c_any_task_in_planning%NOTFOUND THEN
1173: Fnd_Message.SET_NAME('AHL','AHL_LTP_SCHEDULE_ALL_NONE_PLAN');
1174: Fnd_Msg_Pub.ADD;
1175: CLOSE c_any_task_in_planning;
1176: RAISE Fnd_Api.G_EXC_ERROR;
1177: END IF;
1178: CLOSE c_any_task_in_planning;
1179:
1180:

Line 1204: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

1200: );
1201: END IF;
1202:
1203: -- Check Error Message stack.
1204: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
1205: l_msg_count := FND_MSG_PUB.count_msg;
1206: IF l_msg_count > 0 THEN
1207: RAISE FND_API.G_EXC_ERROR;
1208: END IF;

Line 1207: RAISE FND_API.G_EXC_ERROR;

1203: -- Check Error Message stack.
1204: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
1205: l_msg_count := FND_MSG_PUB.count_msg;
1206: IF l_msg_count > 0 THEN
1207: RAISE FND_API.G_EXC_ERROR;
1208: END IF;
1209: END IF;
1210:
1211: IF l_Planned_Matrl_Tbl.COUNT > 0 THEN

Line 1263: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

1259: END LOOP;
1260: END IF;
1261:
1262: --Standard check for commit
1263: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1264: COMMIT;
1265: END IF;
1266:
1267: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 1277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1273: );
1274: END IF;
1275:
1276: EXCEPTION
1277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1278: ROLLBACK TO Schedule_All_Materials;
1279: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1280: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1281: p_count => x_msg_count,

Line 1279: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1275:
1276: EXCEPTION
1277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1278: ROLLBACK TO Schedule_All_Materials;
1279: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1280: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1281: p_count => x_msg_count,
1282: p_data => x_msg_data);
1283:

Line 1280: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1276: EXCEPTION
1277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1278: ROLLBACK TO Schedule_All_Materials;
1279: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1280: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1281: p_count => x_msg_count,
1282: p_data => x_msg_data);
1283:
1284: WHEN FND_API.G_EXC_ERROR THEN

Line 1284: WHEN FND_API.G_EXC_ERROR THEN

1280: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1281: p_count => x_msg_count,
1282: p_data => x_msg_data);
1283:
1284: WHEN FND_API.G_EXC_ERROR THEN
1285: ROLLBACK TO Schedule_All_Materials;
1286: X_return_status := FND_API.G_RET_STS_ERROR;
1287: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1288: p_count => x_msg_count,

Line 1286: X_return_status := FND_API.G_RET_STS_ERROR;

1282: p_data => x_msg_data);
1283:
1284: WHEN FND_API.G_EXC_ERROR THEN
1285: ROLLBACK TO Schedule_All_Materials;
1286: X_return_status := FND_API.G_RET_STS_ERROR;
1287: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1288: p_count => x_msg_count,
1289: p_data => X_msg_data);
1290:

Line 1287: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1283:
1284: WHEN FND_API.G_EXC_ERROR THEN
1285: ROLLBACK TO Schedule_All_Materials;
1286: X_return_status := FND_API.G_RET_STS_ERROR;
1287: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1288: p_count => x_msg_count,
1289: p_data => X_msg_data);
1290:
1291: WHEN OTHERS THEN

Line 1293: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1289: p_data => X_msg_data);
1290:
1291: WHEN OTHERS THEN
1292: ROLLBACK TO Schedule_All_Materials;
1293: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1294: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1295: THEN
1296: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
1297: p_procedure_name => 'SCHEDULE_ALL_MATERIALS',

Line 1300: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1296: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
1297: p_procedure_name => 'SCHEDULE_ALL_MATERIALS',
1298: p_error_text => SUBSTR(SQLERRM,1,240));
1299: END IF;
1300: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1301: p_count => x_msg_count,
1302: p_data => X_msg_data);
1303:
1304: END Schedule_All_Materials;