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

Line 9: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

5: G_FILE_NAME CONSTANT VARCHAR2(12):='pvxvhopb.pls';
6:
7: PROCEDURE Create_opp_header_Post(
8: P_Api_Version_Number IN NUMBER,
9: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
10: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
13: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

Line 10: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

6:
7: PROCEDURE Create_opp_header_Post(
8: P_Api_Version_Number IN NUMBER,
9: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
10: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
13: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
14: P_Admin_Group_Id IN NUMBER,

Line 11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

7: PROCEDURE Create_opp_header_Post(
8: P_Api_Version_Number IN NUMBER,
9: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
10: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
13: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
14: P_Admin_Group_Id IN NUMBER,
15: P_Identity_Salesforce_Id IN NUMBER := NULL,

Line 12: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,

8: P_Api_Version_Number IN NUMBER,
9: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
10: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
13: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
14: P_Admin_Group_Id IN NUMBER,
15: P_Identity_Salesforce_Id IN NUMBER := NULL,
16: P_salesgroup_id IN NUMBER := NULL,

Line 13: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,

9: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
10: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_FALSE,
13: P_Admin_Flag IN VARCHAR2 := FND_API.G_FALSE,
14: P_Admin_Group_Id IN NUMBER,
15: P_Identity_Salesforce_Id IN NUMBER := NULL,
16: P_salesgroup_id IN NUMBER := NULL,
17: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,

Line 18: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,

14: P_Admin_Group_Id IN NUMBER,
15: P_Identity_Salesforce_Id IN NUMBER := NULL,
16: P_salesgroup_id IN NUMBER := NULL,
17: P_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE,
18: P_Partner_Cont_Party_id IN NUMBER := FND_API.G_MISS_NUM,
19: P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type
20: := AS_OPPORTUNITY_PUB.G_MISS_Header_REC,
21: X_LEAD_ID OUT NOCOPY NUMBER,
22: X_Return_Status OUT NOCOPY VARCHAR2,

Line 33: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

29:
30: BEGIN
31:
32: -- Standard call to check for call compatibility.
33: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
34: p_api_version_number,
35: l_api_name,
36: G_PKG_NAME)
37: THEN

Line 38: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

34: p_api_version_number,
35: l_api_name,
36: G_PKG_NAME)
37: THEN
38: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
39: END IF;
40:
41: -- Initialize message list if p_init_msg_list is set to TRUE.
42: IF FND_API.to_Boolean( p_init_msg_list )

Line 42: IF FND_API.to_Boolean( p_init_msg_list )

38: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
39: END IF;
40:
41: -- Initialize message list if p_init_msg_list is set to TRUE.
42: IF FND_API.to_Boolean( p_init_msg_list )
43: THEN
44: FND_MSG_PUB.initialize;
45: END IF;
46:

Line 47: x_return_status := FND_API.G_RET_STS_SUCCESS ;

43: THEN
44: FND_MSG_PUB.initialize;
45: END IF;
46:
47: x_return_status := FND_API.G_RET_STS_SUCCESS ;
48:
49: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
50: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
51: fnd_message.Set_Token('TEXT', ' ********* Before calling PV_OPPORTUNITY_VHUK.Create_Opportunity_Post');

Line 72: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

68: fnd_message.Set_Token('TEXT', '********* After calling PV_OPPORTUNITY_VHUK.Create_Opportunity_Post');
69: fnd_msg_pub.Add;
70: END IF;
71:
72: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
73: RAISE FND_API.G_EXC_ERROR;
74: END IF;
75:
76: EXCEPTION

Line 73: RAISE FND_API.G_EXC_ERROR;

69: fnd_msg_pub.Add;
70: END IF;
71:
72: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
73: RAISE FND_API.G_EXC_ERROR;
74: END IF;
75:
76: EXCEPTION
77: WHEN FND_API.G_EXC_ERROR THEN

Line 77: WHEN FND_API.G_EXC_ERROR THEN

73: RAISE FND_API.G_EXC_ERROR;
74: END IF;
75:
76: EXCEPTION
77: WHEN FND_API.G_EXC_ERROR THEN
78: x_return_status := FND_API.G_RET_STS_ERROR ;
79: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
80: p_count => x_msg_count,
81: p_data => x_msg_data);

Line 78: x_return_status := FND_API.G_RET_STS_ERROR ;

74: END IF;
75:
76: EXCEPTION
77: WHEN FND_API.G_EXC_ERROR THEN
78: x_return_status := FND_API.G_RET_STS_ERROR ;
79: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
80: p_count => x_msg_count,
81: p_data => x_msg_data);
82: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 79: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

75:
76: EXCEPTION
77: WHEN FND_API.G_EXC_ERROR THEN
78: x_return_status := FND_API.G_RET_STS_ERROR ;
79: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
80: p_count => x_msg_count,
81: p_data => x_msg_data);
82: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 82: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

78: x_return_status := FND_API.G_RET_STS_ERROR ;
79: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
80: p_count => x_msg_count,
81: p_data => x_msg_data);
82: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
84: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
85: p_count => x_msg_count,
86: p_data => x_msg_data);

Line 83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

79: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
80: p_count => x_msg_count,
81: p_data => x_msg_data);
82: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
84: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
85: p_count => x_msg_count,
86: p_data => x_msg_data);
87: WHEN OTHERS THEN

Line 84: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

80: p_count => x_msg_count,
81: p_data => x_msg_data);
82: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
84: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
85: p_count => x_msg_count,
86: p_data => x_msg_data);
87: WHEN OTHERS THEN
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

84: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
85: p_count => x_msg_count,
86: p_data => x_msg_data);
87: WHEN OTHERS THEN
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
90: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
91: p_count => x_msg_count,
92: p_data => x_msg_data);

Line 90: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

86: p_data => x_msg_data);
87: WHEN OTHERS THEN
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
90: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
91: p_count => x_msg_count,
92: p_data => x_msg_data);
93:
94: END Create_opp_header_Post;

Line 99: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

95:
96:
97: PROCEDURE Update_Opp_Header_Pre
98: ( p_api_version_number IN NUMBER,
99: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
100: p_commit IN VARCHAR2 := FND_API.G_FALSE,
101: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
102: p_check_access_flag IN VARCHAR2,
103: p_admin_flag IN VARCHAR2,

Line 100: p_commit IN VARCHAR2 := FND_API.G_FALSE,

96:
97: PROCEDURE Update_Opp_Header_Pre
98: ( p_api_version_number IN NUMBER,
99: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
100: p_commit IN VARCHAR2 := FND_API.G_FALSE,
101: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
102: p_check_access_flag IN VARCHAR2,
103: p_admin_flag IN VARCHAR2,
104: p_admin_group_id IN NUMBER,

Line 101: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

97: PROCEDURE Update_Opp_Header_Pre
98: ( p_api_version_number IN NUMBER,
99: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
100: p_commit IN VARCHAR2 := FND_API.G_FALSE,
101: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
102: p_check_access_flag IN VARCHAR2,
103: p_admin_flag IN VARCHAR2,
104: p_admin_group_id IN NUMBER,
105: p_identity_salesforce_id IN NUMBER,

Line 149: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

145:
146: BEGIN
147:
148: -- Standard call to check for call compatibility.
149: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
150: p_api_version_number,
151: l_api_name,
152: G_PKG_NAME)
153: THEN

Line 154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

150: p_api_version_number,
151: l_api_name,
152: G_PKG_NAME)
153: THEN
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;
156:
157: -- Initialize message list if p_init_msg_list is set to TRUE.
158:

Line 159: IF FND_API.to_Boolean( p_init_msg_list )

155: END IF;
156:
157: -- Initialize message list if p_init_msg_list is set to TRUE.
158:
159: IF FND_API.to_Boolean( p_init_msg_list )
160: THEN
161: FND_MSG_PUB.initialize;
162: END IF;
163:

Line 164: x_return_status := FND_API.G_RET_STS_SUCCESS ;

160: THEN
161: FND_MSG_PUB.initialize;
162: END IF;
163:
164: x_return_status := FND_API.G_RET_STS_SUCCESS ;
165:
166: open lc_get_channel_type (pc_lead_id => p_header_rec.lead_id);
167: fetch lc_get_channel_type into l_user_type,
168: l_curr_channel_code,

Line 179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

175:
176: FND_MESSAGE.Set_Name('PV', 'PV_LEAD_NOT_FOUND');
177: FND_MESSAGE.Set_Token('LEAD_ID', p_header_rec.lead_id);
178: FND_MSG_PUB.Add;
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180:
181: end if;
182:
183: close lc_get_channel_type;

Line 190: if p_header_rec.channel_code <> FND_API.G_MISS_CHAR and p_header_rec.channel_code <> l_curr_channel_code then

186:
187: -- channel_code in the record type may be null if user has decided not to display
188: -- the column in the opportunity summary page. In that case it will be G_MISS_CHAR
189:
190: if p_header_rec.channel_code <> FND_API.G_MISS_CHAR and p_header_rec.channel_code <> l_curr_channel_code then
191:
192: open lc_chk_channel_code(pc_code => p_header_rec.channel_code);
193:
194: fetch lc_chk_channel_code into l_to_channel_meaning,

Line 205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

201: FND_MESSAGE.Set_Name('PV', 'PV_INVALID_CHANNEL_CODE');
202: FND_MESSAGE.Set_Token('P_CHANNEL', p_header_rec.channel_code);
203: FND_MSG_PUB.Add;
204:
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206:
207: end if;
208:
209: close lc_chk_channel_code;

Line 219: RAISE FND_API.G_EXC_ERROR;

215: FND_MESSAGE.Set_Name('PV', 'PV_OPP_ALREADY_ASSIGNED');
216: FND_MESSAGE.Set_Token('P_CHANNEL', l_to_channel_meaning);
217: FND_MSG_PUB.Add;
218:
219: RAISE FND_API.G_EXC_ERROR;
220:
221: end if;
222:
223: end if;

Line 240: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

236: x_msg_data => x_msg_data);
237:
238:
239: -- Standard call to get message count and if count is 1, get message info.
240: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
241: p_count => x_msg_count,
242: p_data => x_msg_data);
243:
244: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 244: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

240: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
241: p_count => x_msg_count,
242: p_data => x_msg_data);
243:
244: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;
247:
248: EXCEPTION

Line 245: RAISE FND_API.G_EXC_ERROR;

241: p_count => x_msg_count,
242: p_data => x_msg_data);
243:
244: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;
247:
248: EXCEPTION
249:

Line 250: WHEN FND_API.G_EXC_ERROR THEN

246: END IF;
247:
248: EXCEPTION
249:
250: WHEN FND_API.G_EXC_ERROR THEN
251: x_return_status := FND_API.G_RET_STS_ERROR ;
252: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
253: p_count => x_msg_count,
254: p_data => x_msg_data);

Line 251: x_return_status := FND_API.G_RET_STS_ERROR ;

247:
248: EXCEPTION
249:
250: WHEN FND_API.G_EXC_ERROR THEN
251: x_return_status := FND_API.G_RET_STS_ERROR ;
252: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
253: p_count => x_msg_count,
254: p_data => x_msg_data);
255:

Line 252: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

248: EXCEPTION
249:
250: WHEN FND_API.G_EXC_ERROR THEN
251: x_return_status := FND_API.G_RET_STS_ERROR ;
252: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
253: p_count => x_msg_count,
254: p_data => x_msg_data);
255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

252: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
253: p_count => x_msg_count,
254: p_data => x_msg_data);
255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
258: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
259: p_count => x_msg_count,
260: p_data => x_msg_data);

Line 257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

253: p_count => x_msg_count,
254: p_data => x_msg_data);
255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
258: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
259: p_count => x_msg_count,
260: p_data => x_msg_data);
261: WHEN OTHERS THEN

Line 258: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

254: p_data => x_msg_data);
255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
258: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
259: p_count => x_msg_count,
260: p_data => x_msg_data);
261: WHEN OTHERS THEN
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

258: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
259: p_count => x_msg_count,
260: p_data => x_msg_data);
261: WHEN OTHERS THEN
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
263: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
264: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
265: p_count => x_msg_count,
266: p_data => x_msg_data);

Line 264: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

260: p_data => x_msg_data);
261: WHEN OTHERS THEN
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
263: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
264: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
265: p_count => x_msg_count,
266: p_data => x_msg_data);
267: END update_opp_header_pre;
268:

Line 273: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

269: -- Added by Ajoy
270: -- Post hook is not used
271: PROCEDURE Update_Opp_Header_Post
272: ( p_api_version_number IN NUMBER,
273: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
274: p_commit IN VARCHAR2 := FND_API.G_FALSE,
275: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
276: p_check_access_flag IN VARCHAR2,
277: p_admin_flag IN VARCHAR2,

Line 274: p_commit IN VARCHAR2 := FND_API.G_FALSE,

270: -- Post hook is not used
271: PROCEDURE Update_Opp_Header_Post
272: ( p_api_version_number IN NUMBER,
273: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
274: p_commit IN VARCHAR2 := FND_API.G_FALSE,
275: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
276: p_check_access_flag IN VARCHAR2,
277: p_admin_flag IN VARCHAR2,
278: p_admin_group_id IN NUMBER,

Line 275: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

271: PROCEDURE Update_Opp_Header_Post
272: ( p_api_version_number IN NUMBER,
273: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
274: p_commit IN VARCHAR2 := FND_API.G_FALSE,
275: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
276: p_check_access_flag IN VARCHAR2,
277: p_admin_flag IN VARCHAR2,
278: p_admin_group_id IN NUMBER,
279: p_identity_salesforce_id IN NUMBER,

Line 306: IF FND_API.To_Boolean ( p_commit ) THEN

302: x_msg_count => x_msg_count,
303: x_msg_data => x_msg_data);
304:
305:
306: IF FND_API.To_Boolean ( p_commit ) THEN
307: COMMIT WORK;
308: END IF;
309: */
310:

Line 312: x_return_status := FND_API.G_RET_STS_SUCCESS ;

308: END IF;
309: */
310:
311: -- Added this code for bugfix : 1975105
312: x_return_status := FND_API.G_RET_STS_SUCCESS ;
313:
314: -- Standard call to get message count and if count is 1, get message info.
315: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
316: p_count => x_msg_count,

Line 315: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

311: -- Added this code for bugfix : 1975105
312: x_return_status := FND_API.G_RET_STS_SUCCESS ;
313:
314: -- Standard call to get message count and if count is 1, get message info.
315: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
316: p_count => x_msg_count,
317: p_data => x_msg_data);
318: EXCEPTION
319:

Line 320: WHEN FND_API.G_EXC_ERROR THEN

316: p_count => x_msg_count,
317: p_data => x_msg_data);
318: EXCEPTION
319:
320: WHEN FND_API.G_EXC_ERROR THEN
321: x_return_status := FND_API.G_RET_STS_ERROR ;
322: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
323: p_count => x_msg_count,
324: p_data => x_msg_data);

Line 321: x_return_status := FND_API.G_RET_STS_ERROR ;

317: p_data => x_msg_data);
318: EXCEPTION
319:
320: WHEN FND_API.G_EXC_ERROR THEN
321: x_return_status := FND_API.G_RET_STS_ERROR ;
322: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
323: p_count => x_msg_count,
324: p_data => x_msg_data);
325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 322: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

318: EXCEPTION
319:
320: WHEN FND_API.G_EXC_ERROR THEN
321: x_return_status := FND_API.G_RET_STS_ERROR ;
322: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
323: p_count => x_msg_count,
324: p_data => x_msg_data);
325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

321: x_return_status := FND_API.G_RET_STS_ERROR ;
322: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
323: p_count => x_msg_count,
324: p_data => x_msg_data);
325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
327: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
328: p_count => x_msg_count,
329: p_data => x_msg_data);

Line 326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

322: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
323: p_count => x_msg_count,
324: p_data => x_msg_data);
325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
327: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
328: p_count => x_msg_count,
329: p_data => x_msg_data);
330: WHEN OTHERS THEN

Line 327: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

323: p_count => x_msg_count,
324: p_data => x_msg_data);
325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
327: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
328: p_count => x_msg_count,
329: p_data => x_msg_data);
330: WHEN OTHERS THEN
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

327: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
328: p_count => x_msg_count,
329: p_data => x_msg_data);
330: WHEN OTHERS THEN
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
333: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
334: p_count => x_msg_count,
335: p_data => x_msg_data);

Line 333: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

329: p_data => x_msg_data);
330: WHEN OTHERS THEN
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
333: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
334: p_count => x_msg_count,
335: p_data => x_msg_data);
336: END update_opp_header_post;
337: