27: ,x_msg_data => x_msg_data
28: ,p_man_inv_rec => p_man_inv_rec
29: ,x_man_inv_rec => x_man_inv_rec);
30:
31: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
32: RAISE Fnd_Api.G_EXC_ERROR;
33: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
34: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
35: END IF;
28: ,p_man_inv_rec => p_man_inv_rec
29: ,x_man_inv_rec => x_man_inv_rec);
30:
31: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
32: RAISE Fnd_Api.G_EXC_ERROR;
33: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
34: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
35: END IF;
36:
29: ,x_man_inv_rec => x_man_inv_rec);
30:
31: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
32: RAISE Fnd_Api.G_EXC_ERROR;
33: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
34: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
35: END IF;
36:
37: EXCEPTION
30:
31: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
32: RAISE Fnd_Api.G_EXC_ERROR;
33: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
34: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
35: END IF;
36:
37: EXCEPTION
38:
35: END IF;
36:
37: EXCEPTION
38:
39: WHEN Fnd_Api.G_EXC_ERROR THEN
40: ROLLBACK TO manual_entry;
41: x_return_status := Fnd_Api.G_RET_STS_ERROR;
42: x_msg_count := l_msg_count ;
43: x_msg_data := l_msg_data ;
37: EXCEPTION
38:
39: WHEN Fnd_Api.G_EXC_ERROR THEN
40: ROLLBACK TO manual_entry;
41: x_return_status := Fnd_Api.G_RET_STS_ERROR;
42: x_msg_count := l_msg_count ;
43: x_msg_data := l_msg_data ;
44: Fnd_Msg_Pub.count_and_get(
45: p_count => x_msg_count
43: x_msg_data := l_msg_data ;
44: Fnd_Msg_Pub.count_and_get(
45: p_count => x_msg_count
46: ,p_data => x_msg_data);
47: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
48: ROLLBACK TO manual_entry;
49: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
50: x_msg_count := l_msg_count ;
51: x_msg_data := l_msg_data ;
45: p_count => x_msg_count
46: ,p_data => x_msg_data);
47: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
48: ROLLBACK TO manual_entry;
49: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
50: x_msg_count := l_msg_count ;
51: x_msg_data := l_msg_data ;
52: Fnd_Msg_Pub.count_and_get(
53: p_count => x_msg_count
53: p_count => x_msg_count
54: ,p_data => x_msg_data);
55: WHEN OTHERS THEN
56: ROLLBACK TO manual_entry;
57: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
58: x_msg_count := l_msg_count ;
59: x_msg_data := l_msg_data ;
60: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_INVOICES_MAN_PUB','MANUAL_ENTRY');
61: Fnd_Msg_Pub.count_and_get(
95: ,x_msg_data => x_msg_data
96: ,p_man_inv_tbl => p_man_inv_tbl
97: ,x_man_inv_tbl => x_man_inv_tbl);
98:
99: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
100: RAISE Fnd_Api.G_EXC_ERROR;
101: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
102: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
103: END IF;
96: ,p_man_inv_tbl => p_man_inv_tbl
97: ,x_man_inv_tbl => x_man_inv_tbl);
98:
99: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
100: RAISE Fnd_Api.G_EXC_ERROR;
101: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
102: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
103: END IF;
104:
97: ,x_man_inv_tbl => x_man_inv_tbl);
98:
99: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
100: RAISE Fnd_Api.G_EXC_ERROR;
101: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
102: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
103: END IF;
104:
105:
98:
99: IF ( x_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
100: RAISE Fnd_Api.G_EXC_ERROR;
101: ELSIF (x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
102: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
103: END IF;
104:
105:
106:
107:
108:
109: EXCEPTION
110:
111: WHEN Fnd_Api.G_EXC_ERROR THEN
112: ROLLBACK TO manual_entry;
113: x_return_status := Fnd_Api.G_RET_STS_ERROR;
114: x_msg_count := l_msg_count ;
115: x_msg_data := l_msg_data ;
109: EXCEPTION
110:
111: WHEN Fnd_Api.G_EXC_ERROR THEN
112: ROLLBACK TO manual_entry;
113: x_return_status := Fnd_Api.G_RET_STS_ERROR;
114: x_msg_count := l_msg_count ;
115: x_msg_data := l_msg_data ;
116: Fnd_Msg_Pub.count_and_get(
117: p_count => x_msg_count
115: x_msg_data := l_msg_data ;
116: Fnd_Msg_Pub.count_and_get(
117: p_count => x_msg_count
118: ,p_data => x_msg_data);
119: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
120: ROLLBACK TO manual_entry;
121: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
122: x_msg_count := l_msg_count ;
123: x_msg_data := l_msg_data ;
117: p_count => x_msg_count
118: ,p_data => x_msg_data);
119: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
120: ROLLBACK TO manual_entry;
121: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
122: x_msg_count := l_msg_count ;
123: x_msg_data := l_msg_data ;
124: Fnd_Msg_Pub.count_and_get(
125: p_count => x_msg_count
125: p_count => x_msg_count
126: ,p_data => x_msg_data);
127: WHEN OTHERS THEN
128: ROLLBACK TO manual_entry;
129: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
130: x_msg_count := l_msg_count ;
131: x_msg_data := l_msg_data ;
132: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_INVOICES_MAN_PUB','MANUAL_ENTRY');
133: Fnd_Msg_Pub.count_and_get(