APPS.OKL_AM_ARINV_PUB dependencies on FND_API

Line 43: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

39: ,x_return_status => l_return_status
40: ,p_ariv_tbl => lp_ariv_tbl) ;
41:
42:
43: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
44: RAISE FND_API.G_EXC_ERROR;
45: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
47: END IF;

Line 44: RAISE FND_API.G_EXC_ERROR;

40: ,p_ariv_tbl => lp_ariv_tbl) ;
41:
42:
43: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
44: RAISE FND_API.G_EXC_ERROR;
45: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
47: END IF;
48:

Line 45: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

41:
42:
43: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
44: RAISE FND_API.G_EXC_ERROR;
45: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
47: END IF;
48:
49:

Line 46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

42:
43: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
44: RAISE FND_API.G_EXC_ERROR;
45: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
47: END IF;
48:
49:
50:

Line 59: WHEN FND_API.G_EXC_ERROR THEN

55: x_msg_data := l_msg_data ;
56:
57: EXCEPTION
58:
59: WHEN FND_API.G_EXC_ERROR THEN
60: ROLLBACK TO create_asset_repair_invoice;
61: x_return_status := FND_API.G_RET_STS_ERROR;
62: x_msg_count := l_msg_count ;
63: x_msg_data := l_msg_data ;

Line 61: x_return_status := FND_API.G_RET_STS_ERROR;

57: EXCEPTION
58:
59: WHEN FND_API.G_EXC_ERROR THEN
60: ROLLBACK TO create_asset_repair_invoice;
61: x_return_status := FND_API.G_RET_STS_ERROR;
62: x_msg_count := l_msg_count ;
63: x_msg_data := l_msg_data ;
64: FND_MSG_PUB.count_and_get(
65: p_count => x_msg_count

Line 67: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

63: x_msg_data := l_msg_data ;
64: FND_MSG_PUB.count_and_get(
65: p_count => x_msg_count
66: ,p_data => x_msg_data);
67: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
68: ROLLBACK TO create_asset_repair_invoice;
69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
70: x_msg_count := l_msg_count ;
71: x_msg_data := l_msg_data ;

Line 69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

65: p_count => x_msg_count
66: ,p_data => x_msg_data);
67: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
68: ROLLBACK TO create_asset_repair_invoice;
69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
70: x_msg_count := l_msg_count ;
71: x_msg_data := l_msg_data ;
72: FND_MSG_PUB.count_and_get(
73: p_count => x_msg_count

Line 77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

73: p_count => x_msg_count
74: ,p_data => x_msg_data);
75: WHEN OTHERS THEN
76: ROLLBACK TO create_asset_repair_invoice;
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78: x_msg_count := l_msg_count ;
79: x_msg_data := l_msg_data ;
80: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_ARINV_PUB','create_asset_repair_invoice');
81: FND_MSG_PUB.count_and_get(

Line 133: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

129: ,p_ariv_tbl => lp_ariv_tbl
130: ,x_ariv_tbl => lx_ariv_tbl) ;
131:
132:
133: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
134: RAISE FND_API.G_EXC_ERROR;
135: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: END IF;

Line 134: RAISE FND_API.G_EXC_ERROR;

130: ,x_ariv_tbl => lx_ariv_tbl) ;
131:
132:
133: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
134: RAISE FND_API.G_EXC_ERROR;
135: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: END IF;
138:

Line 135: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

131:
132:
133: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
134: RAISE FND_API.G_EXC_ERROR;
135: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: END IF;
138:
139:

Line 136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

132:
133: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
134: RAISE FND_API.G_EXC_ERROR;
135: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: END IF;
138:
139:
140: lp_ariv_tbl := lx_ariv_tbl;

Line 153: WHEN FND_API.G_EXC_ERROR THEN

149: x_msg_data := l_msg_data ;
150:
151: EXCEPTION
152:
153: WHEN FND_API.G_EXC_ERROR THEN
154: ROLLBACK TO trx_Approve_Asset_Repair;
155: x_return_status := FND_API.G_RET_STS_ERROR;
156: x_msg_count := l_msg_count ;
157: x_msg_data := l_msg_data ;

Line 155: x_return_status := FND_API.G_RET_STS_ERROR;

151: EXCEPTION
152:
153: WHEN FND_API.G_EXC_ERROR THEN
154: ROLLBACK TO trx_Approve_Asset_Repair;
155: x_return_status := FND_API.G_RET_STS_ERROR;
156: x_msg_count := l_msg_count ;
157: x_msg_data := l_msg_data ;
158: FND_MSG_PUB.count_and_get(
159: p_count => x_msg_count

Line 161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

157: x_msg_data := l_msg_data ;
158: FND_MSG_PUB.count_and_get(
159: p_count => x_msg_count
160: ,p_data => x_msg_data);
161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
162: ROLLBACK TO trx_Approve_Asset_Repair;
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: x_msg_count := l_msg_count ;
165: x_msg_data := l_msg_data ;

Line 163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

159: p_count => x_msg_count
160: ,p_data => x_msg_data);
161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
162: ROLLBACK TO trx_Approve_Asset_Repair;
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: x_msg_count := l_msg_count ;
165: x_msg_data := l_msg_data ;
166: FND_MSG_PUB.count_and_get(
167: p_count => x_msg_count

Line 171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

167: p_count => x_msg_count
168: ,p_data => x_msg_data);
169: WHEN OTHERS THEN
170: ROLLBACK TO trx_Approve_Asset_Repair;
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: x_msg_count := l_msg_count ;
173: x_msg_data := l_msg_data ;
174: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_ARINV_PUB','Approve_Asset_Repair');
175: FND_MSG_PUB.count_and_get(