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

Line 8: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

4: g_pkg_name CONSTANT VARCHAR2(30):= 'QA_SKIPLOT_RCV_GRP';
5:
6: PROCEDURE CHECK_AVAILABILITY
7: (p_api_version IN NUMBER, -- 1.0
8: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
9: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
11: p_organization_id IN NUMBER,
12: x_qa_availability OUT NOCOPY VARCHAR2, -- return fnd_api.g_true/false

Line 9: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

5:
6: PROCEDURE CHECK_AVAILABILITY
7: (p_api_version IN NUMBER, -- 1.0
8: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
9: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
11: p_organization_id IN NUMBER,
12: x_qa_availability OUT NOCOPY VARCHAR2, -- return fnd_api.g_true/false
13: x_return_status OUT NOCOPY VARCHAR2,

Line 10: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,

6: PROCEDURE CHECK_AVAILABILITY
7: (p_api_version IN NUMBER, -- 1.0
8: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
9: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
11: p_organization_id IN NUMBER,
12: x_qa_availability OUT NOCOPY VARCHAR2, -- return fnd_api.g_true/false
13: x_return_status OUT NOCOPY VARCHAR2,
14: x_msg_count OUT NOCOPY NUMBER,

Line 12: x_qa_availability OUT NOCOPY VARCHAR2, -- return fnd_api.g_true/false

8: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
9: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
11: p_organization_id IN NUMBER,
12: x_qa_availability OUT NOCOPY VARCHAR2, -- return fnd_api.g_true/false
13: x_return_status OUT NOCOPY VARCHAR2,
14: x_msg_count OUT NOCOPY NUMBER,
15: x_msg_data OUT NOCOPY VARCHAR2) IS
16:

Line 20: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

16:
17:
18: l_api_version CONSTANT NUMBER := 1.0;
19: l_api_name CONSTANT VARCHAR2(30):= 'CHECK_AVAILABILITY';
20: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
21: l_msg_count NUMBER;
22: l_msg_data VARCHAR2(240);
23:
24: BEGIN

Line 34: if not fnd_api.compatible_api_call (

30:
31: --
32: -- standard call to check for call compatibility.
33: --
34: if not fnd_api.compatible_api_call (
35: l_api_version,
36: p_api_version,
37: l_api_name,
38: g_pkg_name) then

Line 39: raise fnd_api.g_exc_unexpected_error;

35: l_api_version,
36: p_api_version,
37: l_api_name,
38: g_pkg_name) then
39: raise fnd_api.g_exc_unexpected_error;
40: end if;
41:
42: --
43: -- initialize message list if p_init_msg_list is set to TRUE.

Line 45: if fnd_api.to_boolean(p_init_msg_list) then

41:
42: --
43: -- initialize message list if p_init_msg_list is set to TRUE.
44: --
45: if fnd_api.to_boolean(p_init_msg_list) then
46: fnd_msg_pub.initialize;
47: end if;
48:
49:

Line 53: x_return_status := fnd_api.g_ret_sts_success;

49:
50: --
51: -- Initialize API return status to success
52: --
53: x_return_status := fnd_api.g_ret_sts_success;
54:
55: x_qa_availability := qa_skiplot_utility.check_skiplot_availability(
56: qa_skiplot_utility.RCV,
57: p_organization_id);

Line 68: WHEN FND_API.G_EXC_ERROR THEN

64:
65:
66: EXCEPTION
67:
68: WHEN FND_API.G_EXC_ERROR THEN
69: x_return_status := fnd_api.g_ret_sts_error;
70:
71: qa_skiplot_utility.insert_error_log (
72: p_module_name => 'QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY',

Line 69: x_return_status := fnd_api.g_ret_sts_error;

65:
66: EXCEPTION
67:
68: WHEN FND_API.G_EXC_ERROR THEN
69: x_return_status := fnd_api.g_ret_sts_error;
70:
71: qa_skiplot_utility.insert_error_log (
72: p_module_name => 'QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY',
73: p_error_message => 'FND_API.G_EXC_ERROR ',

Line 73: p_error_message => 'FND_API.G_EXC_ERROR ',

69: x_return_status := fnd_api.g_ret_sts_error;
70:
71: qa_skiplot_utility.insert_error_log (
72: p_module_name => 'QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY',
73: p_error_message => 'FND_API.G_EXC_ERROR ',
74: p_comments => SUBSTR (SQLERRM , 1 , 240));
75:
76: --
77: -- get message count and data

Line 83: x_qa_availability := fnd_api.g_false;

79: fnd_msg_pub.count_and_get (
80: p_count => x_msg_count,
81: p_data => x_msg_data);
82:
83: x_qa_availability := fnd_api.g_false;
84:
85: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
86: x_return_status := fnd_api.g_ret_sts_unexp_error ;
87:

Line 85: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

81: p_data => x_msg_data);
82:
83: x_qa_availability := fnd_api.g_false;
84:
85: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
86: x_return_status := fnd_api.g_ret_sts_unexp_error ;
87:
88: qa_skiplot_utility.insert_error_log (
89: p_module_name => 'QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY',

Line 86: x_return_status := fnd_api.g_ret_sts_unexp_error ;

82:
83: x_qa_availability := fnd_api.g_false;
84:
85: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
86: x_return_status := fnd_api.g_ret_sts_unexp_error ;
87:
88: qa_skiplot_utility.insert_error_log (
89: p_module_name => 'QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY',
90: p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR',

Line 90: p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR',

86: x_return_status := fnd_api.g_ret_sts_unexp_error ;
87:
88: qa_skiplot_utility.insert_error_log (
89: p_module_name => 'QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY',
90: p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR',
91: p_comments => SUBSTR (SQLERRM , 1 , 240));
92:
93: --
94: -- get message count and data

Line 100: x_qa_availability := fnd_api.g_false;

96: fnd_msg_pub.count_and_get (
97: p_count => x_msg_count,
98: p_data => x_msg_data);
99:
100: x_qa_availability := fnd_api.g_false;
101:
102: WHEN OTHERS THEN
103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
104:

Line 103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

99:
100: x_qa_availability := fnd_api.g_false;
101:
102: WHEN OTHERS THEN
103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
104:
105: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
106: fnd_msg_pub.add_exc_msg (g_pkg_name , l_api_name);
107: end if;

Line 121: x_qa_availability := fnd_api.g_false;

117: fnd_msg_pub.count_and_get (
118: p_count => x_msg_count,
119: p_data => x_msg_data);
120:
121: x_qa_availability := fnd_api.g_false;
122:
123: END CHECK_AVAILABILITY;
124:
125: --

Line 198: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

194: end get_project_task;
195:
196: PROCEDURE EVALUATE_LOT
197: (p_api_version IN NUMBER, -- 1.0
198: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
199: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
200: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
201: p_interface_txn_id IN NUMBER,
202: p_organization_id IN NUMBER,

Line 199: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

195:
196: PROCEDURE EVALUATE_LOT
197: (p_api_version IN NUMBER, -- 1.0
198: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
199: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
200: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
201: p_interface_txn_id IN NUMBER,
202: p_organization_id IN NUMBER,
203: p_vendor_id IN NUMBER,

Line 200: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,

196: PROCEDURE EVALUATE_LOT
197: (p_api_version IN NUMBER, -- 1.0
198: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
199: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
200: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
201: p_interface_txn_id IN NUMBER,
202: p_organization_id IN NUMBER,
203: p_vendor_id IN NUMBER,
204: p_vendor_site_id IN NUMBER,

Line 231: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

227: PRAGMA AUTONOMOUS_TRANSACTION;
228:
229: l_api_version CONSTANT NUMBER := 1.0;
230: l_api_name CONSTANT VARCHAR2(30):= 'EVALUATE_LOT';
231: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
232: l_msg_count NUMBER;
233: l_msg_data VARCHAR2(500);
234:
235: SOURCE_INSPECTED CONSTANT NUMBER := 1;

Line 255: if not fnd_api.compatible_api_call (

251:
252: --
253: -- standard call to check for call compatibility.
254: --
255: if not fnd_api.compatible_api_call (
256: l_api_version,
257: p_api_version,
258: l_api_name,
259: g_pkg_name) then

Line 260: raise fnd_api.g_exc_unexpected_error;

256: l_api_version,
257: p_api_version,
258: l_api_name,
259: g_pkg_name) then
260: raise fnd_api.g_exc_unexpected_error;
261: end if;
262:
263: --
264: -- initialize message list if p_init_msg_list is set to TRUE.

Line 266: if fnd_api.to_boolean(p_init_msg_list) then

262:
263: --
264: -- initialize message list if p_init_msg_list is set to TRUE.
265: --
266: if fnd_api.to_boolean(p_init_msg_list) then
267: fnd_msg_pub.initialize;
268: end if;
269:
270:

Line 274: x_return_status := fnd_api.g_ret_sts_success;

270:
271: --
272: -- Initialize API return status to success
273: --
274: x_return_status := fnd_api.g_ret_sts_success;
275:
276:
277: --
278: -- if skip lot not available, use normal inspection

Line 281: (qa_skiplot_utility.RCV, p_organization_id ) = fnd_api.g_false then

277: --
278: -- if skip lot not available, use normal inspection
279: --
280: if qa_skiplot_utility.check_skiplot_availability
281: (qa_skiplot_utility.RCV, p_organization_id ) = fnd_api.g_false then
282: x_evaluation_result := 'INSPECT';
283:
284: --
285: -- if source inspected, skip the lot

Line 395: WHEN FND_API.G_EXC_ERROR THEN

391: COMMIT;
392:
393: EXCEPTION
394:
395: WHEN FND_API.G_EXC_ERROR THEN
396: x_return_status := fnd_api.g_ret_sts_error;
397:
398: --
399: -- get message count and data

Line 396: x_return_status := fnd_api.g_ret_sts_error;

392:
393: EXCEPTION
394:
395: WHEN FND_API.G_EXC_ERROR THEN
396: x_return_status := fnd_api.g_ret_sts_error;
397:
398: --
399: -- get message count and data
400: --

Line 407: p_error_message => 'FND_API.G_EXC_ERROR',

403: p_data => x_msg_data);
404:
405: qa_skiplot_utility.insert_error_log (
406: p_module_name => 'QA_SKIPLOT_RCV_GRP.EVALUATE_LOT',
407: p_error_message => 'FND_API.G_EXC_ERROR',
408: p_comments => SUBSTR (SQLERRM , 1 , 240));
409:
410: x_evaluation_result := 'INSPECT';
411:

Line 412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

408: p_comments => SUBSTR (SQLERRM , 1 , 240));
409:
410: x_evaluation_result := 'INSPECT';
411:
412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
413: x_return_status := fnd_api.g_ret_sts_unexp_error ;
414:
415: --
416: -- get message count and data

Line 413: x_return_status := fnd_api.g_ret_sts_unexp_error ;

409:
410: x_evaluation_result := 'INSPECT';
411:
412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
413: x_return_status := fnd_api.g_ret_sts_unexp_error ;
414:
415: --
416: -- get message count and data
417: --

Line 424: p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR',

420: p_data => x_msg_data);
421:
422: qa_skiplot_utility.insert_error_log (
423: p_module_name => 'QA_SKIPLOT_RCV_GRP.EVALUATE_LOT',
424: p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR',
425: p_comments => SUBSTR (SQLERRM , 1 , 240));
426:
427: x_evaluation_result := 'INSPECT';
428:

Line 430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

426:
427: x_evaluation_result := 'INSPECT';
428:
429: WHEN OTHERS THEN
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
431:
432: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
433: fnd_msg_pub.add_exc_msg (g_pkg_name , l_api_name);
434: end if;

Line 455: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

451: END EVALUATE_LOT;
452:
453: PROCEDURE MATCH_SHIPMENT
454: (p_api_version IN NUMBER,
455: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
456: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
457: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
458: p_interface_txn_id IN NUMBER,
459: p_shipment_header_id IN NUMBER,

Line 456: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

452:
453: PROCEDURE MATCH_SHIPMENT
454: (p_api_version IN NUMBER,
455: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
456: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
457: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
458: p_interface_txn_id IN NUMBER,
459: p_shipment_header_id IN NUMBER,
460: p_shipment_line_id IN NUMBER,

Line 457: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,

453: PROCEDURE MATCH_SHIPMENT
454: (p_api_version IN NUMBER,
455: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
456: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
457: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
458: p_interface_txn_id IN NUMBER,
459: p_shipment_header_id IN NUMBER,
460: p_shipment_line_id IN NUMBER,
461: x_return_status OUT NOCOPY VARCHAR2,

Line 467: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

463: x_msg_data OUT NOCOPY VARCHAR2) IS
464:
465: l_api_version CONSTANT NUMBER := 1.0;
466: l_api_name CONSTANT VARCHAR2(30):= 'MATCH_SHIPMENT';
467: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
468: l_msg_count NUMBER;
469: l_msg_data VARCHAR2(2400);
470:
471: lotID NUMBER := null;

Line 483: if not fnd_api.compatible_api_call (

479:
480: --
481: -- standard call to check for call compatibility.
482: --
483: if not fnd_api.compatible_api_call (
484: l_api_version,
485: p_api_version,
486: l_api_name,
487: g_pkg_name) then

Line 488: raise fnd_api.g_exc_unexpected_error;

484: l_api_version,
485: p_api_version,
486: l_api_name,
487: g_pkg_name) then
488: raise fnd_api.g_exc_unexpected_error;
489: end if;
490:
491: --
492: -- initialize message list if p_init_msg_list is set to TRUE.

Line 494: if fnd_api.to_boolean(p_init_msg_list) then

490:
491: --
492: -- initialize message list if p_init_msg_list is set to TRUE.
493: --
494: if fnd_api.to_boolean(p_init_msg_list) then
495: fnd_msg_pub.initialize;
496: end if;
497:
498:

Line 502: x_return_status := fnd_api.g_ret_sts_success;

498:
499: --
500: -- Initialize API return status to success
501: --
502: x_return_status := fnd_api.g_ret_sts_success;
503:
504:
505: --
506: -- update lot plans table and results table

Line 526: WHEN FND_API.G_EXC_ERROR THEN

522: end if;
523:
524: EXCEPTION
525:
526: WHEN FND_API.G_EXC_ERROR THEN
527: x_return_status := fnd_api.g_ret_sts_error;
528:
529: qa_skiplot_utility.insert_error_log (
530: p_module_name => 'QA_SKIPLOT_RCV_GRP.MATCH_SHIPMENT',

Line 527: x_return_status := fnd_api.g_ret_sts_error;

523:
524: EXCEPTION
525:
526: WHEN FND_API.G_EXC_ERROR THEN
527: x_return_status := fnd_api.g_ret_sts_error;
528:
529: qa_skiplot_utility.insert_error_log (
530: p_module_name => 'QA_SKIPLOT_RCV_GRP.MATCH_SHIPMENT',
531: p_error_message => 'FND_API.G_EXC_ERROR ',

Line 531: p_error_message => 'FND_API.G_EXC_ERROR ',

527: x_return_status := fnd_api.g_ret_sts_error;
528:
529: qa_skiplot_utility.insert_error_log (
530: p_module_name => 'QA_SKIPLOT_RCV_GRP.MATCH_SHIPMENT',
531: p_error_message => 'FND_API.G_EXC_ERROR ',
532: p_comments => SUBSTR (SQLERRM , 1 , 240));
533:
534: --
535: -- get message count and data

Line 541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

537: fnd_msg_pub.count_and_get (
538: p_count => x_msg_count,
539: p_data => x_msg_data);
540:
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
542: x_return_status := fnd_api.g_ret_sts_unexp_error ;
543:
544: qa_skiplot_utility.insert_error_log (
545: p_module_name => 'QA_SKIPLOT_RCV_GRP.MATCH_SHIPMENT',

Line 542: x_return_status := fnd_api.g_ret_sts_unexp_error ;

538: p_count => x_msg_count,
539: p_data => x_msg_data);
540:
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
542: x_return_status := fnd_api.g_ret_sts_unexp_error ;
543:
544: qa_skiplot_utility.insert_error_log (
545: p_module_name => 'QA_SKIPLOT_RCV_GRP.MATCH_SHIPMENT',
546: p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR ',

Line 546: p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR ',

542: x_return_status := fnd_api.g_ret_sts_unexp_error ;
543:
544: qa_skiplot_utility.insert_error_log (
545: p_module_name => 'QA_SKIPLOT_RCV_GRP.MATCH_SHIPMENT',
546: p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR ',
547: p_comments => SUBSTR (SQLERRM , 1 , 240));
548:
549: --
550: -- get message count and data

Line 557: x_return_status := fnd_api.g_ret_sts_unexp_error ;

553: p_count => x_msg_count,
554: p_data => x_msg_data);
555:
556: WHEN OTHERS THEN
557: x_return_status := fnd_api.g_ret_sts_unexp_error ;
558:
559: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
560: fnd_msg_pub.add_exc_msg (g_pkg_name , l_api_name);
561: end if;

Line 579: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

575: END MATCH_SHIPMENT;
576:
577: PROCEDURE IS_QA_RESULT_PRESENT
578: (p_api_version IN NUMBER, -- 1.0
579: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
580: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
581: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
582: p_collection_id IN NUMBER,
583: x_result_present OUT NOCOPY VARCHAR2,

Line 580: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

576:
577: PROCEDURE IS_QA_RESULT_PRESENT
578: (p_api_version IN NUMBER, -- 1.0
579: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
580: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
581: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
582: p_collection_id IN NUMBER,
583: x_result_present OUT NOCOPY VARCHAR2,
584: x_return_status OUT NOCOPY VARCHAR2,

Line 581: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,

577: PROCEDURE IS_QA_RESULT_PRESENT
578: (p_api_version IN NUMBER, -- 1.0
579: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
580: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
581: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
582: p_collection_id IN NUMBER,
583: x_result_present OUT NOCOPY VARCHAR2,
584: x_return_status OUT NOCOPY VARCHAR2,
585: x_msg_count OUT NOCOPY NUMBER,

Line 590: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

586: x_msg_data OUT NOCOPY VARCHAR2) IS
587:
588: l_api_version CONSTANT NUMBER := 1.0;
589: l_api_name CONSTANT VARCHAR2(30):= 'IS_QA_RESULT_PRESENT';
590: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
591: l_msg_count NUMBER;
592: l_msg_data VARCHAR2(2400);
593:
594: --uses qa_pc_results_relationship to ensure we don't count orphan child rows

Line 611: if not fnd_api.compatible_api_call (

607:
608: --
609: -- standard call to check for call compatibility.
610: --
611: if not fnd_api.compatible_api_call (
612: l_api_version,
613: p_api_version,
614: l_api_name,
615: g_pkg_name) then

Line 616: raise fnd_api.g_exc_unexpected_error;

612: l_api_version,
613: p_api_version,
614: l_api_name,
615: g_pkg_name) then
616: raise fnd_api.g_exc_unexpected_error;
617: end if;
618:
619: --
620: -- initialize message list if p_init_msg_list is set to TRUE.

Line 622: if fnd_api.to_boolean(p_init_msg_list) then

618:
619: --
620: -- initialize message list if p_init_msg_list is set to TRUE.
621: --
622: if fnd_api.to_boolean(p_init_msg_list) then
623: fnd_msg_pub.initialize;
624: end if;
625:
626: --

Line 630: x_return_status := fnd_api.g_ret_sts_success;

626: --
627: -- Initialize API return status to success and
628: -- data found result to false
629: --
630: x_return_status := fnd_api.g_ret_sts_success;
631: x_result_present := fnd_api.g_false;
632:
633: --
634: -- do a lookup on qa_results to check for the collection_id

Line 631: x_result_present := fnd_api.g_false;

627: -- Initialize API return status to success and
628: -- data found result to false
629: --
630: x_return_status := fnd_api.g_ret_sts_success;
631: x_result_present := fnd_api.g_false;
632:
633: --
634: -- do a lookup on qa_results to check for the collection_id
635: -- in a non-child plan

Line 640: x_result_present := fnd_api.g_true;

636: --
637: OPEN C1;
638: FETCH C1 INTO l_res_count;
639: IF l_res_count > 0 THEN
640: x_result_present := fnd_api.g_true;
641: END IF;
642: CLOSE C1;
643:
644: EXCEPTION

Line 646: WHEN FND_API.G_EXC_ERROR THEN

642: CLOSE C1;
643:
644: EXCEPTION
645:
646: WHEN FND_API.G_EXC_ERROR THEN
647: x_return_status := fnd_api.g_ret_sts_error;
648:
649: qa_skiplot_utility.insert_error_log (
650: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_QA_RESULT_PRESENT',

Line 647: x_return_status := fnd_api.g_ret_sts_error;

643:
644: EXCEPTION
645:
646: WHEN FND_API.G_EXC_ERROR THEN
647: x_return_status := fnd_api.g_ret_sts_error;
648:
649: qa_skiplot_utility.insert_error_log (
650: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_QA_RESULT_PRESENT',
651: p_error_message => 'FND_API.G_EXC_ERROR ',

Line 651: p_error_message => 'FND_API.G_EXC_ERROR ',

647: x_return_status := fnd_api.g_ret_sts_error;
648:
649: qa_skiplot_utility.insert_error_log (
650: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_QA_RESULT_PRESENT',
651: p_error_message => 'FND_API.G_EXC_ERROR ',
652: p_comments => SUBSTR (SQLERRM , 1 , 240));
653:
654: --
655: -- get message count and data

Line 661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

657: fnd_msg_pub.count_and_get (
658: p_count => x_msg_count,
659: p_data => x_msg_data);
660:
661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
662: x_return_status := fnd_api.g_ret_sts_unexp_error ;
663:
664: qa_skiplot_utility.insert_error_log (
665: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_QA_RESULT_PRESENT',

Line 662: x_return_status := fnd_api.g_ret_sts_unexp_error ;

658: p_count => x_msg_count,
659: p_data => x_msg_data);
660:
661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
662: x_return_status := fnd_api.g_ret_sts_unexp_error ;
663:
664: qa_skiplot_utility.insert_error_log (
665: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_QA_RESULT_PRESENT',
666: p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR ',

Line 666: p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR ',

662: x_return_status := fnd_api.g_ret_sts_unexp_error ;
663:
664: qa_skiplot_utility.insert_error_log (
665: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_QA_RESULT_PRESENT',
666: p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR ',
667: p_comments => SUBSTR (SQLERRM , 1 , 240));
668:
669: --
670: -- get message count and data

Line 677: x_return_status := fnd_api.g_ret_sts_unexp_error ;

673: p_count => x_msg_count,
674: p_data => x_msg_data);
675:
676: WHEN OTHERS THEN
677: x_return_status := fnd_api.g_ret_sts_unexp_error ;
678:
679: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
680: fnd_msg_pub.add_exc_msg (g_pkg_name , l_api_name);
681: end if;

Line 707: -- returns x_skip_status = {fnd_api.g_true | fnd_api.g_false}

703: -- with 4 Way Match with Receipt. This happens because
704: -- AP calls Receiving API to get the quantity details
705: -- from rcv_transactions but rcv_transactions does
706: -- not maintain details of Skipped lots.
707: -- returns x_skip_status = {fnd_api.g_true | fnd_api.g_false}
708: -- bhsankar Thu Jul 5 04:09:04 PDT 2007
709: --
710: PROCEDURE IS_LOT_SKIPPED(p_api_version IN NUMBER, -- 1.0
711: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 711: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

707: -- returns x_skip_status = {fnd_api.g_true | fnd_api.g_false}
708: -- bhsankar Thu Jul 5 04:09:04 PDT 2007
709: --
710: PROCEDURE IS_LOT_SKIPPED(p_api_version IN NUMBER, -- 1.0
711: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
712: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
713: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
714: p_transaction_id IN NUMBER,
715: x_skip_status OUT NOCOPY VARCHAR2,

Line 712: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

708: -- bhsankar Thu Jul 5 04:09:04 PDT 2007
709: --
710: PROCEDURE IS_LOT_SKIPPED(p_api_version IN NUMBER, -- 1.0
711: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
712: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
713: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
714: p_transaction_id IN NUMBER,
715: x_skip_status OUT NOCOPY VARCHAR2,
716: x_return_status OUT NOCOPY VARCHAR2,

Line 713: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,

709: --
710: PROCEDURE IS_LOT_SKIPPED(p_api_version IN NUMBER, -- 1.0
711: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
712: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
713: p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL,
714: p_transaction_id IN NUMBER,
715: x_skip_status OUT NOCOPY VARCHAR2,
716: x_return_status OUT NOCOPY VARCHAR2,
717: x_msg_count OUT NOCOPY NUMBER,

Line 723: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

719:
720:
721: l_api_version CONSTANT NUMBER := 1.0;
722: l_api_name CONSTANT VARCHAR2(30):= 'IS_LOT_SKIPPED';
723: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
724: l_msg_count NUMBER;
725: l_msg_data VARCHAR2(2400);
726:
727: CURSOR C1 IS

Line 745: if not fnd_api.compatible_api_call (

741:
742: --
743: -- standard call to check for call compatibility.
744: --
745: if not fnd_api.compatible_api_call (
746: l_api_version,
747: p_api_version,
748: l_api_name,
749: g_pkg_name) then

Line 750: raise fnd_api.g_exc_unexpected_error;

746: l_api_version,
747: p_api_version,
748: l_api_name,
749: g_pkg_name) then
750: raise fnd_api.g_exc_unexpected_error;
751: end if;
752:
753: --
754: -- initialize message list if p_init_msg_list is set to TRUE.

Line 756: if fnd_api.to_boolean(p_init_msg_list) then

752:
753: --
754: -- initialize message list if p_init_msg_list is set to TRUE.
755: --
756: if fnd_api.to_boolean(p_init_msg_list) then
757: fnd_msg_pub.initialize;
758: end if;
759:
760: --

Line 764: x_return_status := fnd_api.g_ret_sts_success;

760: --
761: -- Initialize API return status to success and
762: -- data found result to false
763: --
764: x_return_status := fnd_api.g_ret_sts_success;
765: x_skip_status := fnd_api.g_false;
766:
767: --
768: -- do a lookup in qa_skiplot_rcv_results and check

Line 765: x_skip_status := fnd_api.g_false;

761: -- Initialize API return status to success and
762: -- data found result to false
763: --
764: x_return_status := fnd_api.g_ret_sts_success;
765: x_skip_status := fnd_api.g_false;
766:
767: --
768: -- do a lookup in qa_skiplot_rcv_results and check
769: -- if the lot pertaining to the rcv_transaction_id

Line 775: x_skip_status := fnd_api.g_true;

771: --
772: OPEN C1;
773: FETCH C1 INTO l_skip_count;
774: IF l_skip_count > 0 THEN
775: x_skip_status := fnd_api.g_true;
776: END IF;
777: CLOSE C1;
778:
779: EXCEPTION

Line 781: WHEN FND_API.G_EXC_ERROR THEN

777: CLOSE C1;
778:
779: EXCEPTION
780:
781: WHEN FND_API.G_EXC_ERROR THEN
782: x_return_status := fnd_api.g_ret_sts_error;
783:
784: qa_skiplot_utility.insert_error_log (
785: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_LOT_SKIPPED',

Line 782: x_return_status := fnd_api.g_ret_sts_error;

778:
779: EXCEPTION
780:
781: WHEN FND_API.G_EXC_ERROR THEN
782: x_return_status := fnd_api.g_ret_sts_error;
783:
784: qa_skiplot_utility.insert_error_log (
785: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_LOT_SKIPPED',
786: p_error_message => 'FND_API.G_EXC_ERROR ',

Line 786: p_error_message => 'FND_API.G_EXC_ERROR ',

782: x_return_status := fnd_api.g_ret_sts_error;
783:
784: qa_skiplot_utility.insert_error_log (
785: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_LOT_SKIPPED',
786: p_error_message => 'FND_API.G_EXC_ERROR ',
787: p_comments => SUBSTR (SQLERRM , 1 , 240));
788:
789: --
790: -- get message count and data

Line 796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

792: fnd_msg_pub.count_and_get (
793: p_count => x_msg_count,
794: p_data => x_msg_data);
795:
796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
797: x_return_status := fnd_api.g_ret_sts_unexp_error ;
798:
799: qa_skiplot_utility.insert_error_log (
800: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_LOT_SKIPPED',

Line 797: x_return_status := fnd_api.g_ret_sts_unexp_error ;

793: p_count => x_msg_count,
794: p_data => x_msg_data);
795:
796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
797: x_return_status := fnd_api.g_ret_sts_unexp_error ;
798:
799: qa_skiplot_utility.insert_error_log (
800: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_LOT_SKIPPED',
801: p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR ',

Line 801: p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR ',

797: x_return_status := fnd_api.g_ret_sts_unexp_error ;
798:
799: qa_skiplot_utility.insert_error_log (
800: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_LOT_SKIPPED',
801: p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR ',
802: p_comments => SUBSTR (SQLERRM , 1 , 240));
803:
804: --
805: -- get message count and data

Line 812: x_return_status := fnd_api.g_ret_sts_unexp_error ;

808: p_count => x_msg_count,
809: p_data => x_msg_data);
810:
811: WHEN OTHERS THEN
812: x_return_status := fnd_api.g_ret_sts_unexp_error ;
813:
814: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
815: fnd_msg_pub.add_exc_msg (g_pkg_name , l_api_name);
816: end if;