DBA Data[Home] [Help]

APPS.OZF_SYS_PARAMETERS_PVT dependencies on FND_MSG_PUB

Line 6: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

2: /* $Header: ozfvsysb.pls 120.13 2007/12/21 07:47:54 gdeepika ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30):='OZF_Sys_Parameters_PVT';
5:
6: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
7:
8:
9:
10:

Line 29: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

25:
26: IF (p_sys_parameters_rec.header_tolerance_calc_code is null
27: AND p_sys_parameters_rec.header_tolerance_operand is not null)
28: THEN
29: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
30: THEN
31: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BATCH_TOL_TYPE_REQ');
32: FND_MSG_PUB.add;
33: END IF;

Line 32: FND_MSG_PUB.add;

28: THEN
29: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
30: THEN
31: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BATCH_TOL_TYPE_REQ');
32: FND_MSG_PUB.add;
33: END IF;
34: x_return_status := FND_API.g_ret_sts_error;
35: RETURN;
36: ELSIF (p_sys_parameters_rec.header_tolerance_calc_code is not null

Line 39: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

35: RETURN;
36: ELSIF (p_sys_parameters_rec.header_tolerance_calc_code is not null
37: AND p_sys_parameters_rec.header_tolerance_operand is null)
38: THEN
39: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
40: THEN
41: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BATCH_TOL_VAL_REQ');
42: FND_MSG_PUB.add;
43: END IF;

Line 42: FND_MSG_PUB.add;

38: THEN
39: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
40: THEN
41: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BATCH_TOL_VAL_REQ');
42: FND_MSG_PUB.add;
43: END IF;
44: x_return_status := FND_API.g_ret_sts_error;
45: RETURN;
46: END IF;

Line 53: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

49:
50: IF (p_sys_parameters_rec.line_tolerance_calc_code is null
51: AND p_sys_parameters_rec.line_tolerance_operand is not null )
52: THEN
53: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
54: THEN
55: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TOL_TYPE_REQ');
56: FND_MSG_PUB.add;
57: END IF;

Line 56: FND_MSG_PUB.add;

52: THEN
53: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
54: THEN
55: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TOL_TYPE_REQ');
56: FND_MSG_PUB.add;
57: END IF;
58: x_return_status := FND_API.g_ret_sts_error;
59: RETURN;
60: ELSIF (p_sys_parameters_rec.line_tolerance_calc_code is not null

Line 63: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

59: RETURN;
60: ELSIF (p_sys_parameters_rec.line_tolerance_calc_code is not null
61: AND p_sys_parameters_rec.line_tolerance_operand is null)
62: THEN
63: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
64: THEN
65: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TOL_VAL_REQ');
66: FND_MSG_PUB.add;
67: END IF;

Line 66: FND_MSG_PUB.add;

62: THEN
63: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
64: THEN
65: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TOL_VAL_REQ');
66: FND_MSG_PUB.add;
67: END IF;
68: x_return_status := FND_API.g_ret_sts_error;
69: RETURN;
70: END IF;

Line 135: FND_MSG_PUB.initialize;

131: OZF_Utility_PVT.debug_message(l_full_name||': start');
132: END IF;
133:
134: IF FND_API.to_boolean(p_init_msg_list) THEN
135: FND_MSG_PUB.initialize;
136: END IF;
137:
138: IF NOT FND_API.compatible_api_call(
139: l_api_version,

Line 176: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

172: END IF;
173:
174: -- validate the uniqueness of the set_of_books_id
175: IF p_sys_parameters_rec.set_of_books_id IS NULL THEN
176: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
177: FND_MESSAGE.set_name('OZF', 'OZF_SET_OF_BOOKS_NULL');
178: FND_MSG_PUB.add;
179: END IF;
180: RAISE FND_API.g_exc_error;

Line 178: FND_MSG_PUB.add;

174: -- validate the uniqueness of the set_of_books_id
175: IF p_sys_parameters_rec.set_of_books_id IS NULL THEN
176: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
177: FND_MESSAGE.set_name('OZF', 'OZF_SET_OF_BOOKS_NULL');
178: FND_MSG_PUB.add;
179: END IF;
180: RAISE FND_API.g_exc_error;
181: ELSE
182: --OPEN c_books_id_count(p_sys_parameters_rec.set_of_books_id);

Line 189: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

185: CLOSE c_books_id_count;
186:
187: -- R12 : Commented below condition, to add multiple system parameters.
188: /* IF l_books_id_count > 0 THEN
189: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
190: FND_MESSAGE.set_name('OZF', 'OZF_SET_OF_BOOKS_EXIST');
191: FND_MSG_PUB.add;
192: END IF;
193: RAISE FND_API.g_exc_error;

Line 191: FND_MSG_PUB.add;

187: -- R12 : Commented below condition, to add multiple system parameters.
188: /* IF l_books_id_count > 0 THEN
189: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
190: FND_MESSAGE.set_name('OZF', 'OZF_SET_OF_BOOKS_EXIST');
191: FND_MSG_PUB.add;
192: END IF;
193: RAISE FND_API.g_exc_error;
194: END IF; */
195: END IF;

Line 419: FND_MSG_PUB.count_and_get(

415: IF FND_API.to_boolean(p_commit) THEN
416: COMMIT;
417: END IF;
418:
419: FND_MSG_PUB.count_and_get(
420: p_encoded => FND_API.g_false,
421: p_count => x_msg_count,
422: p_data => x_msg_data
423: );

Line 433: FND_MSG_PUB.count_and_get (

429: EXCEPTION
430: WHEN FND_API.g_exc_error THEN
431: ROLLBACK TO Create_Sys_Parameters;
432: x_return_status := FND_API.g_ret_sts_error;
433: FND_MSG_PUB.count_and_get (
434: p_encoded => FND_API.g_false
435: ,p_count => x_msg_count
436: ,p_data => x_msg_data
437: );

Line 442: FND_MSG_PUB.count_and_get (

438:
439: WHEN FND_API.g_exc_unexpected_error THEN
440: ROLLBACK TO Create_Sys_Parameters;
441: x_return_status := FND_API.g_ret_sts_unexp_error ;
442: FND_MSG_PUB.count_and_get (
443: p_encoded => FND_API.g_false
444: ,p_count => x_msg_count
445: ,p_data => x_msg_data
446: );

Line 452: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

448:
449: WHEN OTHERS THEN
450: ROLLBACK TO Create_Sys_Parameters;
451: x_return_status := FND_API.g_ret_sts_unexp_error ;
452: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
453: THEN
454: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
455: END IF;
456: FND_MSG_PUB.count_and_get(

Line 454: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

450: ROLLBACK TO Create_Sys_Parameters;
451: x_return_status := FND_API.g_ret_sts_unexp_error ;
452: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
453: THEN
454: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
455: END IF;
456: FND_MSG_PUB.count_and_get(
457: p_encoded => FND_API.g_false
458: ,p_count => x_msg_count

Line 456: FND_MSG_PUB.count_and_get(

452: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
453: THEN
454: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
455: END IF;
456: FND_MSG_PUB.count_and_get(
457: p_encoded => FND_API.g_false
458: ,p_count => x_msg_count
459: ,p_data => x_msg_data
460: );

Line 501: FND_MSG_PUB.initialize;

497: OZF_Utility_PVT.debug_message(l_full_name||': start');
498: END IF;
499:
500: IF FND_API.to_boolean(p_init_msg_list) THEN
501: FND_MSG_PUB.initialize;
502: END IF;
503:
504: IF NOT FND_API.compatible_api_call(
505: l_api_version,

Line 526: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

522: AND object_version_number = p_object_version
523: AND org_id = l_org_id; -- R12 Enhancements
524:
525: IF (SQL%NOTFOUND) THEN
526: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
527: THEN
528: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
529: FND_MSG_PUB.add;
530: END IF;

Line 529: FND_MSG_PUB.add;

525: IF (SQL%NOTFOUND) THEN
526: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
527: THEN
528: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
529: FND_MSG_PUB.add;
530: END IF;
531: RAISE FND_API.g_exc_error;
532: END IF;
533:

Line 539: FND_MSG_PUB.count_and_get(

535: IF FND_API.to_boolean(p_commit) THEN
536: COMMIT;
537: END IF;
538:
539: FND_MSG_PUB.count_and_get(
540: p_encoded => FND_API.g_false,
541: p_count => x_msg_count,
542: p_data => x_msg_data
543: );

Line 553: FND_MSG_PUB.count_and_get(

549: EXCEPTION
550: WHEN FND_API.g_exc_error THEN
551: ROLLBACK TO Delete_Sys_Parameters;
552: x_return_status := FND_API.g_ret_sts_error;
553: FND_MSG_PUB.count_and_get(
554: p_encoded => FND_API.g_false,
555: p_count => x_msg_count,
556: p_data => x_msg_data
557: );

Line 562: FND_MSG_PUB.count_and_get(

558:
559: WHEN FND_API.g_exc_unexpected_error THEN
560: ROLLBACK TO Delete_Sys_Parameters;
561: x_return_status := FND_API.g_ret_sts_unexp_error ;
562: FND_MSG_PUB.count_and_get(
563: p_encoded => FND_API.g_false,
564: p_count => x_msg_count,
565: p_data => x_msg_data
566: );

Line 571: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

567:
568: WHEN OTHERS THEN
569: ROLLBACK TO Delete_Sys_Parameters;
570: x_return_status := FND_API.g_ret_sts_unexp_error ;
571: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
572: THEN
573: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
574: END IF;
575: FND_MSG_PUB.count_and_get(

Line 573: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

569: ROLLBACK TO Delete_Sys_Parameters;
570: x_return_status := FND_API.g_ret_sts_unexp_error ;
571: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
572: THEN
573: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
574: END IF;
575: FND_MSG_PUB.count_and_get(
576: p_encoded => FND_API.g_false,
577: p_count => x_msg_count,

Line 575: FND_MSG_PUB.count_and_get(

571: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
572: THEN
573: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
574: END IF;
575: FND_MSG_PUB.count_and_get(
576: p_encoded => FND_API.g_false,
577: p_count => x_msg_count,
578: p_data => x_msg_data
579: );

Line 625: FND_MSG_PUB.initialize;

621: OZF_Utility_PVT.debug_message(l_full_name||': start');
622: END IF;
623:
624: IF FND_API.to_boolean(p_init_msg_list) THEN
625: FND_MSG_PUB.initialize;
626: END IF;
627:
628: IF NOT FND_API.compatible_api_call(
629: l_api_version,

Line 648: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

644: OPEN c_sys_para;
645: FETCH c_sys_para INTO l_set_of_books_id;
646: IF (c_sys_para%NOTFOUND) THEN
647: CLOSE c_sys_para;
648: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
649: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
650: FND_MSG_PUB.add;
651: END IF;
652: RAISE FND_API.g_exc_error;

Line 650: FND_MSG_PUB.add;

646: IF (c_sys_para%NOTFOUND) THEN
647: CLOSE c_sys_para;
648: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
649: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
650: FND_MSG_PUB.add;
651: END IF;
652: RAISE FND_API.g_exc_error;
653: END IF;
654: CLOSE c_sys_para;

Line 657: FND_MSG_PUB.count_and_get(

653: END IF;
654: CLOSE c_sys_para;
655:
656: -------------------- finish --------------------------
657: FND_MSG_PUB.count_and_get(
658: p_encoded => FND_API.g_false,
659: p_count => x_msg_count,
660: p_data => x_msg_data
661: );

Line 670: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

666:
667: EXCEPTION
668: WHEN OZF_Utility_PVT.resource_locked THEN
669: x_return_status := FND_API.g_ret_sts_error;
670: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
671: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
672: FND_MSG_PUB.add;
673: END IF;
674:

Line 672: FND_MSG_PUB.add;

668: WHEN OZF_Utility_PVT.resource_locked THEN
669: x_return_status := FND_API.g_ret_sts_error;
670: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
671: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
672: FND_MSG_PUB.add;
673: END IF;
674:
675: FND_MSG_PUB.count_and_get(
676: p_encoded => FND_API.g_false,

Line 675: FND_MSG_PUB.count_and_get(

671: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
672: FND_MSG_PUB.add;
673: END IF;
674:
675: FND_MSG_PUB.count_and_get(
676: p_encoded => FND_API.g_false,
677: p_count => x_msg_count,
678: p_data => x_msg_data
679: );

Line 683: FND_MSG_PUB.count_and_get(

679: );
680:
681: WHEN FND_API.g_exc_error THEN
682: x_return_status := FND_API.g_ret_sts_error;
683: FND_MSG_PUB.count_and_get(
684: p_encoded => FND_API.g_false,
685: p_count => x_msg_count,
686: p_data => x_msg_data
687: );

Line 691: FND_MSG_PUB.count_and_get(

687: );
688:
689: WHEN FND_API.g_exc_unexpected_error THEN
690: x_return_status := FND_API.g_ret_sts_unexp_error ;
691: FND_MSG_PUB.count_and_get(
692: p_encoded => FND_API.g_false,
693: p_count => x_msg_count,
694: p_data => x_msg_data
695: );

Line 699: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

695: );
696:
697: WHEN OTHERS THEN
698: x_return_status := FND_API.g_ret_sts_unexp_error ;
699: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
700: THEN
701: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
702: END IF;
703: FND_MSG_PUB.count_and_get(

Line 701: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

697: WHEN OTHERS THEN
698: x_return_status := FND_API.g_ret_sts_unexp_error ;
699: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
700: THEN
701: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
702: END IF;
703: FND_MSG_PUB.count_and_get(
704: p_encoded => FND_API.g_false,
705: p_count => x_msg_count,

Line 703: FND_MSG_PUB.count_and_get(

699: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
700: THEN
701: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
702: END IF;
703: FND_MSG_PUB.count_and_get(
704: p_encoded => FND_API.g_false,
705: p_count => x_msg_count,
706: p_data => x_msg_data
707: );

Line 764: FND_MSG_PUB.initialize;

760: OZF_Utility_PVT.debug_message(l_full_name||': start');
761: END IF;
762:
763: IF FND_API.to_boolean(p_init_msg_list) THEN
764: FND_MSG_PUB.initialize;
765: END IF;
766:
767: IF NOT FND_API.compatible_api_call(
768: l_api_version,

Line 943: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

939: --AND org_id = l_org_id; -- R12 Enhancements
940: AND org_id = p_sys_parameters_rec.org_id;
941:
942: IF (SQL%NOTFOUND) THEN
943: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
944: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
945: FND_MSG_PUB.add;
946: END IF;
947: RAISE FND_API.g_exc_error;

Line 945: FND_MSG_PUB.add;

941:
942: IF (SQL%NOTFOUND) THEN
943: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
944: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
945: FND_MSG_PUB.add;
946: END IF;
947: RAISE FND_API.g_exc_error;
948: END IF;
949:

Line 959: FND_MSG_PUB.count_and_get(

955: IF FND_API.to_boolean(p_commit) THEN
956: COMMIT;
957: END IF;
958:
959: FND_MSG_PUB.count_and_get(
960: p_encoded => FND_API.g_false,
961: p_count => x_msg_count,
962: p_data => x_msg_data
963: );

Line 974: FND_MSG_PUB.count_and_get(

970:
971: WHEN FND_API.g_exc_error THEN
972: ROLLBACK TO Update_Sys_Parameters;
973: x_return_status := FND_API.g_ret_sts_error;
974: FND_MSG_PUB.count_and_get(
975: p_encoded => FND_API.g_false,
976: p_count => x_msg_count,
977: p_data => x_msg_data
978: );

Line 983: FND_MSG_PUB.count_and_get(

979:
980: WHEN FND_API.g_exc_unexpected_error THEN
981: ROLLBACK TO Update_Sys_Parameters;
982: x_return_status := FND_API.g_ret_sts_unexp_error ;
983: FND_MSG_PUB.count_and_get(
984: p_encoded => FND_API.g_false,
985: p_count => x_msg_count,
986: p_data => x_msg_data
987: );

Line 992: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

988:
989: WHEN OTHERS THEN
990: ROLLBACK TO Update_Sys_Parameters;
991: x_return_status := FND_API.g_ret_sts_unexp_error ;
992: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
993: THEN
994: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
995: END IF;
996: FND_MSG_PUB.count_and_get(

Line 994: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

990: ROLLBACK TO Update_Sys_Parameters;
991: x_return_status := FND_API.g_ret_sts_unexp_error ;
992: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
993: THEN
994: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
995: END IF;
996: FND_MSG_PUB.count_and_get(
997: p_encoded => FND_API.g_false,
998: p_count => x_msg_count,

Line 996: FND_MSG_PUB.count_and_get(

992: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
993: THEN
994: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
995: END IF;
996: FND_MSG_PUB.count_and_get(
997: p_encoded => FND_API.g_false,
998: p_count => x_msg_count,
999: p_data => x_msg_data
1000: );

Line 1039: FND_MSG_PUB.initialize;

1035: OZF_Utility_PVT.debug_message(l_full_name||': start');
1036: END IF;
1037:
1038: IF FND_API.to_boolean(p_init_msg_list) THEN
1039: FND_MSG_PUB.initialize;
1040: END IF;
1041:
1042: IF NOT FND_API.compatible_api_call(
1043: l_api_version,

Line 1104: FND_MSG_PUB.count_and_get(

1100: END IF;
1101:
1102:
1103: -------------------- finish --------------------------
1104: FND_MSG_PUB.count_and_get(
1105: p_encoded => FND_API.g_false,
1106: p_count => x_msg_count,
1107: p_data => x_msg_data
1108: );

Line 1118: FND_MSG_PUB.count_and_get(

1114: EXCEPTION
1115:
1116: WHEN FND_API.g_exc_error THEN
1117: x_return_status := FND_API.g_ret_sts_error;
1118: FND_MSG_PUB.count_and_get(
1119: p_encoded => FND_API.g_false,
1120: p_count => x_msg_count,
1121: p_data => x_msg_data
1122: );

Line 1126: FND_MSG_PUB.count_and_get(

1122: );
1123:
1124: WHEN FND_API.g_exc_unexpected_error THEN
1125: x_return_status := FND_API.g_ret_sts_unexp_error ;
1126: FND_MSG_PUB.count_and_get(
1127: p_encoded => FND_API.g_false,
1128: p_count => x_msg_count,
1129: p_data => x_msg_data
1130: );

Line 1134: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

1130: );
1131:
1132: WHEN OTHERS THEN
1133: x_return_status := FND_API.g_ret_sts_unexp_error;
1134: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1135: THEN
1136: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1137: END IF;
1138: FND_MSG_PUB.count_and_get(

Line 1136: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1132: WHEN OTHERS THEN
1133: x_return_status := FND_API.g_ret_sts_unexp_error;
1134: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1135: THEN
1136: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1137: END IF;
1138: FND_MSG_PUB.count_and_get(
1139: p_encoded => FND_API.g_false,
1140: p_count => x_msg_count,

Line 1138: FND_MSG_PUB.count_and_get(

1134: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1135: THEN
1136: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1137: END IF;
1138: FND_MSG_PUB.count_and_get(
1139: p_encoded => FND_API.g_false,
1140: p_count => x_msg_count,
1141: p_data => x_msg_data
1142: );

Line 1253: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1249: THEN
1250: IF p_sys_parameters_rec.post_to_gl <> FND_API.g_true
1251: AND p_sys_parameters_rec.post_to_gl <> FND_API.g_false
1252: THEN
1253: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1254: THEN
1255: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
1256: FND_MESSAGE.set_token('FLAG', 'POST_TO_GL');
1257: FND_MSG_PUB.add;

Line 1257: FND_MSG_PUB.add;

1253: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1254: THEN
1255: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
1256: FND_MESSAGE.set_token('FLAG', 'POST_TO_GL');
1257: FND_MSG_PUB.add;
1258: END IF;
1259:
1260: x_return_status := FND_API.g_ret_sts_error;
1261: RETURN;

Line 1272: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1268: THEN
1269: IF p_sys_parameters_rec.transfer_to_gl_in <> FND_API.g_true
1270: AND p_sys_parameters_rec.transfer_to_gl_in <> FND_API.g_false
1271: THEN
1272: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1273: THEN
1274: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
1275: FND_MESSAGE.set_token('FLAG', 'TRANSFER_TO_GL_IN');
1276: FND_MSG_PUB.add;

Line 1276: FND_MSG_PUB.add;

1272: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1273: THEN
1274: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
1275: FND_MESSAGE.set_token('FLAG', 'TRANSFER_TO_GL_IN');
1276: FND_MSG_PUB.add;
1277: END IF;
1278:
1279: x_return_status := FND_API.g_ret_sts_error;
1280: RETURN;

Line 1291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1287: THEN
1288: IF p_sys_parameters_rec.rounding_level_flag <> FND_API.g_true
1289: AND p_sys_parameters_rec.rounding_level_flag <> FND_API.g_false
1290: THEN
1291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1292: THEN
1293: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
1294: FND_MESSAGE.set_token('FLAG', 'ROUNDING_LEVEL_FLAG');
1295: FND_MSG_PUB.add;

Line 1295: FND_MSG_PUB.add;

1291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1292: THEN
1293: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
1294: FND_MESSAGE.set_token('FLAG', 'ROUNDING_LEVEL_FLAG');
1295: FND_MSG_PUB.add;
1296: END IF;
1297:
1298: x_return_status := FND_API.g_ret_sts_error;
1299: RETURN;

Line 1310: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1306: THEN
1307: IF p_sys_parameters_rec.autopay_flag <> FND_API.g_true
1308: AND p_sys_parameters_rec.autopay_flag <> FND_API.g_false
1309: THEN
1310: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1311: THEN
1312: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
1313: FND_MESSAGE.set_token('FLAG', 'AUTOPAY_FLAG');
1314: FND_MSG_PUB.add;

Line 1314: FND_MSG_PUB.add;

1310: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1311: THEN
1312: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
1313: FND_MESSAGE.set_token('FLAG', 'AUTOPAY_FLAG');
1314: FND_MSG_PUB.add;
1315: END IF;
1316:
1317: x_return_status := FND_API.g_ret_sts_error;
1318: RETURN;

Line 1404: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1400: FETCH c_order_trx_type INTO l_dummy;
1401: CLOSE c_order_trx_type;
1402:
1403: IF l_dummy <> 1 THEN
1404: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1405: THEN
1406: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INVALID_OM_TRX_TYPE');
1407: FND_MSG_PUB.add;
1408: END IF;

Line 1407: FND_MSG_PUB.add;

1403: IF l_dummy <> 1 THEN
1404: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1405: THEN
1406: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INVALID_OM_TRX_TYPE');
1407: FND_MSG_PUB.add;
1408: END IF;
1409: x_return_status := FND_API.g_ret_sts_error;
1410: RETURN;
1411: END IF;

Line 1576: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1572: OPEN c_sys_para;
1573: FETCH c_sys_para INTO l_sys_parameters_rec;
1574: IF c_sys_para%NOTFOUND THEN
1575: CLOSE c_sys_para;
1576: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1577: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1578: FND_MSG_PUB.add;
1579: END IF;
1580: RAISE FND_API.g_exc_error;

Line 1578: FND_MSG_PUB.add;

1574: IF c_sys_para%NOTFOUND THEN
1575: CLOSE c_sys_para;
1576: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1577: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1578: FND_MSG_PUB.add;
1579: END IF;
1580: RAISE FND_API.g_exc_error;
1581: END IF;
1582: CLOSE c_sys_para;