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.17 2012/01/03 17:15:49 nirprasa 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 51: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

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

Line 54: FND_MSG_PUB.add;

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

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

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

Line 64: FND_MSG_PUB.add;

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

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

70: -- For Rule Based Settlement
71: IF (p_sys_parameters_rec.credit_matching_thold_type is null
72: AND p_sys_parameters_rec.credit_tolerance_operand is not null )
73: THEN
74: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
75: THEN
76: FND_MESSAGE.set_name('OZF', 'OZF_CREDIT_THRES_TYPE_REQ');
77: FND_MSG_PUB.add;
78: END IF;

Line 77: FND_MSG_PUB.add;

73: THEN
74: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
75: THEN
76: FND_MESSAGE.set_name('OZF', 'OZF_CREDIT_THRES_TYPE_REQ');
77: FND_MSG_PUB.add;
78: END IF;
79: x_return_status := FND_API.g_ret_sts_error;
80: RETURN;
81: ELSIF (p_sys_parameters_rec.credit_tolerance_operand is null

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

80: RETURN;
81: ELSIF (p_sys_parameters_rec.credit_tolerance_operand is null
82: AND p_sys_parameters_rec.credit_matching_thold_type is not null)
83: THEN
84: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
85: THEN
86: FND_MESSAGE.set_name('OZF', 'OZF_CREDIT_THRES_VAL_REQ');
87: FND_MSG_PUB.add;
88: END IF;

Line 87: FND_MSG_PUB.add;

83: THEN
84: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
85: THEN
86: FND_MESSAGE.set_name('OZF', 'OZF_CREDIT_THRES_VAL_REQ');
87: FND_MSG_PUB.add;
88: END IF;
89: x_return_status := FND_API.g_ret_sts_error;
90: RETURN;
91: END IF;

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

93: -- For Rule Based Settlement
94: IF(p_sys_parameters_rec.credit_matching_thold_type = '%' AND
95: p_sys_parameters_rec.credit_tolerance_operand is not null AND p_sys_parameters_rec.credit_tolerance_operand > 100)
96: THEN
97: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
98: THEN
99: FND_MESSAGE.set_name('OZF', 'OZF_CREDIT_THRES_VALIDATION');
100: FND_MSG_PUB.add;
101: END IF;

Line 100: FND_MSG_PUB.add;

96: THEN
97: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
98: THEN
99: FND_MESSAGE.set_name('OZF', 'OZF_CREDIT_THRES_VALIDATION');
100: FND_MSG_PUB.add;
101: END IF;
102: x_return_status := FND_API.g_ret_sts_error;
103: RETURN;
104: END IF;

Line 170: FND_MSG_PUB.initialize;

166: OZF_Utility_PVT.debug_message(l_full_name||': start');
167: END IF;
168:
169: IF FND_API.to_boolean(p_init_msg_list) THEN
170: FND_MSG_PUB.initialize;
171: END IF;
172:
173: IF NOT FND_API.compatible_api_call(
174: l_api_version,

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

207: END IF;
208:
209: -- validate the uniqueness of the set_of_books_id
210: IF p_sys_parameters_rec.set_of_books_id IS NULL THEN
211: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
212: FND_MESSAGE.set_name('OZF', 'OZF_SET_OF_BOOKS_NULL');
213: FND_MSG_PUB.add;
214: END IF;
215: RAISE FND_API.g_exc_error;

Line 213: FND_MSG_PUB.add;

209: -- validate the uniqueness of the set_of_books_id
210: IF p_sys_parameters_rec.set_of_books_id IS NULL THEN
211: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
212: FND_MESSAGE.set_name('OZF', 'OZF_SET_OF_BOOKS_NULL');
213: FND_MSG_PUB.add;
214: END IF;
215: RAISE FND_API.g_exc_error;
216: ELSE
217: --OPEN c_books_id_count(p_sys_parameters_rec.set_of_books_id);

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

220: CLOSE c_books_id_count;
221:
222: -- R12 : Commented below condition, to add multiple system parameters.
223: /* IF l_books_id_count > 0 THEN
224: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
225: FND_MESSAGE.set_name('OZF', 'OZF_SET_OF_BOOKS_EXIST');
226: FND_MSG_PUB.add;
227: END IF;
228: RAISE FND_API.g_exc_error;

Line 226: FND_MSG_PUB.add;

222: -- R12 : Commented below condition, to add multiple system parameters.
223: /* IF l_books_id_count > 0 THEN
224: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
225: FND_MESSAGE.set_name('OZF', 'OZF_SET_OF_BOOKS_EXIST');
226: FND_MSG_PUB.add;
227: END IF;
228: RAISE FND_API.g_exc_error;
229: END IF; */
230: END IF;

Line 477: FND_MSG_PUB.count_and_get(

473: IF FND_API.to_boolean(p_commit) THEN
474: COMMIT;
475: END IF;
476:
477: FND_MSG_PUB.count_and_get(
478: p_encoded => FND_API.g_false,
479: p_count => x_msg_count,
480: p_data => x_msg_data
481: );

Line 491: FND_MSG_PUB.count_and_get (

487: EXCEPTION
488: WHEN FND_API.g_exc_error THEN
489: ROLLBACK TO Create_Sys_Parameters;
490: x_return_status := FND_API.g_ret_sts_error;
491: FND_MSG_PUB.count_and_get (
492: p_encoded => FND_API.g_false
493: ,p_count => x_msg_count
494: ,p_data => x_msg_data
495: );

Line 500: FND_MSG_PUB.count_and_get (

496:
497: WHEN FND_API.g_exc_unexpected_error THEN
498: ROLLBACK TO Create_Sys_Parameters;
499: x_return_status := FND_API.g_ret_sts_unexp_error ;
500: FND_MSG_PUB.count_and_get (
501: p_encoded => FND_API.g_false
502: ,p_count => x_msg_count
503: ,p_data => x_msg_data
504: );

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

506:
507: WHEN OTHERS THEN
508: ROLLBACK TO Create_Sys_Parameters;
509: x_return_status := FND_API.g_ret_sts_unexp_error ;
510: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
511: THEN
512: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
513: END IF;
514: FND_MSG_PUB.count_and_get(

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

508: ROLLBACK TO Create_Sys_Parameters;
509: x_return_status := FND_API.g_ret_sts_unexp_error ;
510: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
511: THEN
512: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
513: END IF;
514: FND_MSG_PUB.count_and_get(
515: p_encoded => FND_API.g_false
516: ,p_count => x_msg_count

Line 514: FND_MSG_PUB.count_and_get(

510: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
511: THEN
512: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
513: END IF;
514: FND_MSG_PUB.count_and_get(
515: p_encoded => FND_API.g_false
516: ,p_count => x_msg_count
517: ,p_data => x_msg_data
518: );

Line 559: FND_MSG_PUB.initialize;

555: OZF_Utility_PVT.debug_message(l_full_name||': start');
556: END IF;
557:
558: IF FND_API.to_boolean(p_init_msg_list) THEN
559: FND_MSG_PUB.initialize;
560: END IF;
561:
562: IF NOT FND_API.compatible_api_call(
563: l_api_version,

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

580: AND object_version_number = p_object_version
581: AND org_id = l_org_id; -- R12 Enhancements
582:
583: IF (SQL%NOTFOUND) THEN
584: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
585: THEN
586: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
587: FND_MSG_PUB.add;
588: END IF;

Line 587: FND_MSG_PUB.add;

583: IF (SQL%NOTFOUND) THEN
584: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
585: THEN
586: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
587: FND_MSG_PUB.add;
588: END IF;
589: RAISE FND_API.g_exc_error;
590: END IF;
591:

Line 597: FND_MSG_PUB.count_and_get(

593: IF FND_API.to_boolean(p_commit) THEN
594: COMMIT;
595: END IF;
596:
597: FND_MSG_PUB.count_and_get(
598: p_encoded => FND_API.g_false,
599: p_count => x_msg_count,
600: p_data => x_msg_data
601: );

Line 611: FND_MSG_PUB.count_and_get(

607: EXCEPTION
608: WHEN FND_API.g_exc_error THEN
609: ROLLBACK TO Delete_Sys_Parameters;
610: x_return_status := FND_API.g_ret_sts_error;
611: FND_MSG_PUB.count_and_get(
612: p_encoded => FND_API.g_false,
613: p_count => x_msg_count,
614: p_data => x_msg_data
615: );

Line 620: FND_MSG_PUB.count_and_get(

616:
617: WHEN FND_API.g_exc_unexpected_error THEN
618: ROLLBACK TO Delete_Sys_Parameters;
619: x_return_status := FND_API.g_ret_sts_unexp_error ;
620: FND_MSG_PUB.count_and_get(
621: p_encoded => FND_API.g_false,
622: p_count => x_msg_count,
623: p_data => x_msg_data
624: );

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

625:
626: WHEN OTHERS THEN
627: ROLLBACK TO Delete_Sys_Parameters;
628: x_return_status := FND_API.g_ret_sts_unexp_error ;
629: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
630: THEN
631: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
632: END IF;
633: FND_MSG_PUB.count_and_get(

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

627: ROLLBACK TO Delete_Sys_Parameters;
628: x_return_status := FND_API.g_ret_sts_unexp_error ;
629: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
630: THEN
631: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
632: END IF;
633: FND_MSG_PUB.count_and_get(
634: p_encoded => FND_API.g_false,
635: p_count => x_msg_count,

Line 633: FND_MSG_PUB.count_and_get(

629: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
630: THEN
631: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
632: END IF;
633: FND_MSG_PUB.count_and_get(
634: p_encoded => FND_API.g_false,
635: p_count => x_msg_count,
636: p_data => x_msg_data
637: );

Line 683: FND_MSG_PUB.initialize;

679: OZF_Utility_PVT.debug_message(l_full_name||': start');
680: END IF;
681:
682: IF FND_API.to_boolean(p_init_msg_list) THEN
683: FND_MSG_PUB.initialize;
684: END IF;
685:
686: IF NOT FND_API.compatible_api_call(
687: l_api_version,

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

702: OPEN c_sys_para;
703: FETCH c_sys_para INTO l_set_of_books_id;
704: IF (c_sys_para%NOTFOUND) THEN
705: CLOSE c_sys_para;
706: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
707: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
708: FND_MSG_PUB.add;
709: END IF;
710: RAISE FND_API.g_exc_error;

Line 708: FND_MSG_PUB.add;

704: IF (c_sys_para%NOTFOUND) THEN
705: CLOSE c_sys_para;
706: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
707: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
708: FND_MSG_PUB.add;
709: END IF;
710: RAISE FND_API.g_exc_error;
711: END IF;
712: CLOSE c_sys_para;

Line 715: FND_MSG_PUB.count_and_get(

711: END IF;
712: CLOSE c_sys_para;
713:
714: -------------------- finish --------------------------
715: FND_MSG_PUB.count_and_get(
716: p_encoded => FND_API.g_false,
717: p_count => x_msg_count,
718: p_data => x_msg_data
719: );

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

724:
725: EXCEPTION
726: WHEN OZF_Utility_PVT.resource_locked THEN
727: x_return_status := FND_API.g_ret_sts_error;
728: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
729: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
730: FND_MSG_PUB.add;
731: END IF;
732:

Line 730: FND_MSG_PUB.add;

726: WHEN OZF_Utility_PVT.resource_locked THEN
727: x_return_status := FND_API.g_ret_sts_error;
728: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
729: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
730: FND_MSG_PUB.add;
731: END IF;
732:
733: FND_MSG_PUB.count_and_get(
734: p_encoded => FND_API.g_false,

Line 733: FND_MSG_PUB.count_and_get(

729: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
730: FND_MSG_PUB.add;
731: END IF;
732:
733: FND_MSG_PUB.count_and_get(
734: p_encoded => FND_API.g_false,
735: p_count => x_msg_count,
736: p_data => x_msg_data
737: );

Line 741: FND_MSG_PUB.count_and_get(

737: );
738:
739: WHEN FND_API.g_exc_error THEN
740: x_return_status := FND_API.g_ret_sts_error;
741: FND_MSG_PUB.count_and_get(
742: p_encoded => FND_API.g_false,
743: p_count => x_msg_count,
744: p_data => x_msg_data
745: );

Line 749: FND_MSG_PUB.count_and_get(

745: );
746:
747: WHEN FND_API.g_exc_unexpected_error THEN
748: x_return_status := FND_API.g_ret_sts_unexp_error ;
749: FND_MSG_PUB.count_and_get(
750: p_encoded => FND_API.g_false,
751: p_count => x_msg_count,
752: p_data => x_msg_data
753: );

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

753: );
754:
755: WHEN OTHERS THEN
756: x_return_status := FND_API.g_ret_sts_unexp_error ;
757: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
758: THEN
759: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
760: END IF;
761: FND_MSG_PUB.count_and_get(

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

755: WHEN OTHERS THEN
756: x_return_status := FND_API.g_ret_sts_unexp_error ;
757: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
758: THEN
759: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
760: END IF;
761: FND_MSG_PUB.count_and_get(
762: p_encoded => FND_API.g_false,
763: p_count => x_msg_count,

Line 761: FND_MSG_PUB.count_and_get(

757: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
758: THEN
759: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
760: END IF;
761: FND_MSG_PUB.count_and_get(
762: p_encoded => FND_API.g_false,
763: p_count => x_msg_count,
764: p_data => x_msg_data
765: );

Line 822: FND_MSG_PUB.initialize;

818: OZF_Utility_PVT.debug_message(l_full_name||': start');
819: END IF;
820:
821: IF FND_API.to_boolean(p_init_msg_list) THEN
822: FND_MSG_PUB.initialize;
823: END IF;
824:
825: IF NOT FND_API.compatible_api_call(
826: l_api_version,

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

1010: --AND org_id = l_org_id; -- R12 Enhancements
1011: AND org_id = p_sys_parameters_rec.org_id;
1012:
1013: IF (SQL%NOTFOUND) THEN
1014: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1015: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1016: FND_MSG_PUB.add;
1017: END IF;
1018: RAISE FND_API.g_exc_error;

Line 1016: FND_MSG_PUB.add;

1012:
1013: IF (SQL%NOTFOUND) THEN
1014: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1015: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1016: FND_MSG_PUB.add;
1017: END IF;
1018: RAISE FND_API.g_exc_error;
1019: END IF;
1020:

Line 1030: FND_MSG_PUB.count_and_get(

1026: IF FND_API.to_boolean(p_commit) THEN
1027: COMMIT;
1028: END IF;
1029:
1030: FND_MSG_PUB.count_and_get(
1031: p_encoded => FND_API.g_false,
1032: p_count => x_msg_count,
1033: p_data => x_msg_data
1034: );

Line 1045: FND_MSG_PUB.count_and_get(

1041:
1042: WHEN FND_API.g_exc_error THEN
1043: ROLLBACK TO Update_Sys_Parameters;
1044: x_return_status := FND_API.g_ret_sts_error;
1045: FND_MSG_PUB.count_and_get(
1046: p_encoded => FND_API.g_false,
1047: p_count => x_msg_count,
1048: p_data => x_msg_data
1049: );

Line 1054: FND_MSG_PUB.count_and_get(

1050:
1051: WHEN FND_API.g_exc_unexpected_error THEN
1052: ROLLBACK TO Update_Sys_Parameters;
1053: x_return_status := FND_API.g_ret_sts_unexp_error ;
1054: FND_MSG_PUB.count_and_get(
1055: p_encoded => FND_API.g_false,
1056: p_count => x_msg_count,
1057: p_data => x_msg_data
1058: );

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

1059:
1060: WHEN OTHERS THEN
1061: ROLLBACK TO Update_Sys_Parameters;
1062: x_return_status := FND_API.g_ret_sts_unexp_error ;
1063: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1064: THEN
1065: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1066: END IF;
1067: FND_MSG_PUB.count_and_get(

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

1061: ROLLBACK TO Update_Sys_Parameters;
1062: x_return_status := FND_API.g_ret_sts_unexp_error ;
1063: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1064: THEN
1065: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1066: END IF;
1067: FND_MSG_PUB.count_and_get(
1068: p_encoded => FND_API.g_false,
1069: p_count => x_msg_count,

Line 1067: FND_MSG_PUB.count_and_get(

1063: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1064: THEN
1065: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1066: END IF;
1067: FND_MSG_PUB.count_and_get(
1068: p_encoded => FND_API.g_false,
1069: p_count => x_msg_count,
1070: p_data => x_msg_data
1071: );

Line 1110: FND_MSG_PUB.initialize;

1106: OZF_Utility_PVT.debug_message(l_full_name||': start');
1107: END IF;
1108:
1109: IF FND_API.to_boolean(p_init_msg_list) THEN
1110: FND_MSG_PUB.initialize;
1111: END IF;
1112:
1113: IF NOT FND_API.compatible_api_call(
1114: l_api_version,

Line 1175: FND_MSG_PUB.count_and_get(

1171: END IF;
1172:
1173:
1174: -------------------- finish --------------------------
1175: FND_MSG_PUB.count_and_get(
1176: p_encoded => FND_API.g_false,
1177: p_count => x_msg_count,
1178: p_data => x_msg_data
1179: );

Line 1189: FND_MSG_PUB.count_and_get(

1185: EXCEPTION
1186:
1187: WHEN FND_API.g_exc_error THEN
1188: x_return_status := FND_API.g_ret_sts_error;
1189: FND_MSG_PUB.count_and_get(
1190: p_encoded => FND_API.g_false,
1191: p_count => x_msg_count,
1192: p_data => x_msg_data
1193: );

Line 1197: FND_MSG_PUB.count_and_get(

1193: );
1194:
1195: WHEN FND_API.g_exc_unexpected_error THEN
1196: x_return_status := FND_API.g_ret_sts_unexp_error ;
1197: FND_MSG_PUB.count_and_get(
1198: p_encoded => FND_API.g_false,
1199: p_count => x_msg_count,
1200: p_data => x_msg_data
1201: );

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

1201: );
1202:
1203: WHEN OTHERS THEN
1204: x_return_status := FND_API.g_ret_sts_unexp_error;
1205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1206: THEN
1207: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1208: END IF;
1209: FND_MSG_PUB.count_and_get(

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

1203: WHEN OTHERS THEN
1204: x_return_status := FND_API.g_ret_sts_unexp_error;
1205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1206: THEN
1207: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1208: END IF;
1209: FND_MSG_PUB.count_and_get(
1210: p_encoded => FND_API.g_false,
1211: p_count => x_msg_count,

Line 1209: FND_MSG_PUB.count_and_get(

1205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1206: THEN
1207: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1208: END IF;
1209: FND_MSG_PUB.count_and_get(
1210: p_encoded => FND_API.g_false,
1211: p_count => x_msg_count,
1212: p_data => x_msg_data
1213: );

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

1320: THEN
1321: IF p_sys_parameters_rec.post_to_gl <> FND_API.g_true
1322: AND p_sys_parameters_rec.post_to_gl <> FND_API.g_false
1323: THEN
1324: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1325: THEN
1326: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
1327: FND_MESSAGE.set_token('FLAG', 'POST_TO_GL');
1328: FND_MSG_PUB.add;

Line 1328: FND_MSG_PUB.add;

1324: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1325: THEN
1326: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
1327: FND_MESSAGE.set_token('FLAG', 'POST_TO_GL');
1328: FND_MSG_PUB.add;
1329: END IF;
1330:
1331: x_return_status := FND_API.g_ret_sts_error;
1332: RETURN;

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

1339: THEN
1340: IF p_sys_parameters_rec.transfer_to_gl_in <> FND_API.g_true
1341: AND p_sys_parameters_rec.transfer_to_gl_in <> FND_API.g_false
1342: THEN
1343: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1344: THEN
1345: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
1346: FND_MESSAGE.set_token('FLAG', 'TRANSFER_TO_GL_IN');
1347: FND_MSG_PUB.add;

Line 1347: FND_MSG_PUB.add;

1343: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1344: THEN
1345: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
1346: FND_MESSAGE.set_token('FLAG', 'TRANSFER_TO_GL_IN');
1347: FND_MSG_PUB.add;
1348: END IF;
1349:
1350: x_return_status := FND_API.g_ret_sts_error;
1351: RETURN;

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

1358: THEN
1359: IF p_sys_parameters_rec.rounding_level_flag <> FND_API.g_true
1360: AND p_sys_parameters_rec.rounding_level_flag <> FND_API.g_false
1361: THEN
1362: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1363: THEN
1364: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
1365: FND_MESSAGE.set_token('FLAG', 'ROUNDING_LEVEL_FLAG');
1366: FND_MSG_PUB.add;

Line 1366: FND_MSG_PUB.add;

1362: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1363: THEN
1364: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
1365: FND_MESSAGE.set_token('FLAG', 'ROUNDING_LEVEL_FLAG');
1366: FND_MSG_PUB.add;
1367: END IF;
1368:
1369: x_return_status := FND_API.g_ret_sts_error;
1370: RETURN;

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

1377: THEN
1378: IF p_sys_parameters_rec.autopay_flag <> FND_API.g_true
1379: AND p_sys_parameters_rec.autopay_flag <> FND_API.g_false
1380: THEN
1381: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1382: THEN
1383: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
1384: FND_MESSAGE.set_token('FLAG', 'AUTOPAY_FLAG');
1385: FND_MSG_PUB.add;

Line 1385: FND_MSG_PUB.add;

1381: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1382: THEN
1383: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
1384: FND_MESSAGE.set_token('FLAG', 'AUTOPAY_FLAG');
1385: FND_MSG_PUB.add;
1386: END IF;
1387:
1388: x_return_status := FND_API.g_ret_sts_error;
1389: RETURN;

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

1471: FETCH c_order_trx_type INTO l_dummy;
1472: CLOSE c_order_trx_type;
1473:
1474: IF l_dummy <> 1 THEN
1475: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1476: THEN
1477: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INVALID_OM_TRX_TYPE');
1478: FND_MSG_PUB.add;
1479: END IF;

Line 1478: FND_MSG_PUB.add;

1474: IF l_dummy <> 1 THEN
1475: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1476: THEN
1477: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INVALID_OM_TRX_TYPE');
1478: FND_MSG_PUB.add;
1479: END IF;
1480: x_return_status := FND_API.g_ret_sts_error;
1481: RETURN;
1482: END IF;

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

1656: OPEN c_sys_para;
1657: FETCH c_sys_para INTO l_sys_parameters_rec;
1658: IF c_sys_para%NOTFOUND THEN
1659: CLOSE c_sys_para;
1660: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1661: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1662: FND_MSG_PUB.add;
1663: END IF;
1664: RAISE FND_API.g_exc_error;

Line 1662: FND_MSG_PUB.add;

1658: IF c_sys_para%NOTFOUND THEN
1659: CLOSE c_sys_para;
1660: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1661: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1662: FND_MSG_PUB.add;
1663: END IF;
1664: RAISE FND_API.g_exc_error;
1665: END IF;
1666: CLOSE c_sys_para;