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_SALES_LEAD_REFERRAL dependencies on FND_API

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

15: ----------------------------------------------------------------------
16:
17: PROCEDURE Update_sales_referral_lead(
18: P_Api_Version_Number IN NUMBER,
19: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
20: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
21: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
22: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

16:
17: PROCEDURE Update_sales_referral_lead(
18: P_Api_Version_Number IN NUMBER,
19: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
20: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
21: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
22: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 21: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

17: PROCEDURE Update_sales_referral_lead(
18: P_Api_Version_Number IN NUMBER,
19: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
20: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
21: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
22: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
25: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 22: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

18: P_Api_Version_Number IN NUMBER,
19: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
20: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
21: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
22: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
25: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
26: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 23: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

19: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
20: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
21: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
22: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
25: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
26: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
27: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type

Line 24: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

20: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
21: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
22: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
25: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
26: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
27: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
28: DEFAULT AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,

Line 25: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

21: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
22: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
24: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
25: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
26: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
27: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
28: DEFAULT AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
29: p_overriding_usernames IN t_overriding_usernames,

Line 62: IF FND_API.to_boolean(p_init_msg_list) THEN

58: SAVEPOINT Update_sales_referral_lead;
59:
60: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': start');
61:
62: IF FND_API.to_boolean(p_init_msg_list) THEN
63: FND_MSG_PUB.initialize;
64: END IF;
65:
66: IF NOT FND_API.compatible_api_call(

Line 66: IF NOT FND_API.compatible_api_call(

62: IF FND_API.to_boolean(p_init_msg_list) THEN
63: FND_MSG_PUB.initialize;
64: END IF;
65:
66: IF NOT FND_API.compatible_api_call(
67: l_api_version,
68: P_Api_Version_Number,
69: l_api_name,
70: g_pkg_name

Line 72: RAISE FND_API.g_exc_unexpected_error;

68: P_Api_Version_Number,
69: l_api_name,
70: g_pkg_name
71: ) THEN
72: RAISE FND_API.g_exc_unexpected_error;
73: END IF;
74:
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76:

Line 75: x_return_status := FND_API.G_RET_STS_SUCCESS;

71: ) THEN
72: RAISE FND_API.g_exc_unexpected_error;
73: END IF;
74:
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76:
77:
78: ----------------------- validate ----------------------
79: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': validate');

Line 86: RAISE FND_API.g_exc_error;

82: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
83: FND_MESSAGE.set_name('PV', 'PV_NO_LEAD_FOUND');
84: FND_MSG_PUB.add;
85: END IF;
86: RAISE FND_API.g_exc_error;
87: END IF;
88:
89:
90: OPEN lc_sales_lead (pc_sales_lead_id => P_SALES_LEAD_Rec.sales_lead_id);

Line 144: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

140: p_qualified_flag => P_SALES_LEAD_Rec.qualified_flag,
141: p_category => g_log_lead_referral_category
142: );
143:
144: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147: -- l_msg_data:=l_msg_data || '** after inserted log row';
148: IF (--l_lead_referral_status = g_referral_status_sub or

Line 145: RAISE FND_API.G_EXC_ERROR;

141: p_category => g_log_lead_referral_category
142: );
143:
144: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147: -- l_msg_data:=l_msg_data || '** after inserted log row';
148: IF (--l_lead_referral_status = g_referral_status_sub or
149: l_lead_referral_status = g_referral_status_acc or

Line 162: ,p_init_msg_list => FND_API.g_false

158: l_msg_data:=l_msg_data || '** while notifying';
159:
160: AS_SALES_LEAD_REFERRAL.Notify_Party (
161: p_api_version => 1.0
162: ,p_init_msg_list => FND_API.g_false
163: ,p_commit => FND_API.g_false
164: ,p_validation_level => FND_API.g_valid_level_full
165:
166: ,p_lead_id => P_SALES_LEAD_Rec.sales_lead_id

Line 163: ,p_commit => FND_API.g_false

159:
160: AS_SALES_LEAD_REFERRAL.Notify_Party (
161: p_api_version => 1.0
162: ,p_init_msg_list => FND_API.g_false
163: ,p_commit => FND_API.g_false
164: ,p_validation_level => FND_API.g_valid_level_full
165:
166: ,p_lead_id => P_SALES_LEAD_Rec.sales_lead_id
167: ,p_lead_status => l_lead_referral_status

Line 164: ,p_validation_level => FND_API.g_valid_level_full

160: AS_SALES_LEAD_REFERRAL.Notify_Party (
161: p_api_version => 1.0
162: ,p_init_msg_list => FND_API.g_false
163: ,p_commit => FND_API.g_false
164: ,p_validation_level => FND_API.g_valid_level_full
165:
166: ,p_lead_id => P_SALES_LEAD_Rec.sales_lead_id
167: ,p_lead_status => l_lead_referral_status
168: ,p_salesforce_id => P_identity_salesforce_id

Line 177: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

173: ,x_Return_Status => x_return_status
174: );
175:
176: l_msg_data:=l_msg_data || x_msg_Data;
177: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
180: END IF;
181:

Line 178: RAISE FND_API.G_EXC_ERROR;

174: );
175:
176: l_msg_data:=l_msg_data || x_msg_Data;
177: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
180: END IF;
181:
182: END IF;

Line 191: P_Init_Msg_List => FND_API.G_FALSE,

187:
188: as_sales_leads_pub.update_sales_lead(
189:
190: P_Api_Version_Number => l_api_version,
191: P_Init_Msg_List => FND_API.G_FALSE,
192: P_Commit => FND_API.G_FALSE,
193: P_Validation_Level => P_Validation_Level,
194: P_Check_Access_Flag => P_Check_Access_Flag,
195: P_Admin_Flag => P_Admin_Flag,

Line 192: P_Commit => FND_API.G_FALSE,

188: as_sales_leads_pub.update_sales_lead(
189:
190: P_Api_Version_Number => l_api_version,
191: P_Init_Msg_List => FND_API.G_FALSE,
192: P_Commit => FND_API.G_FALSE,
193: P_Validation_Level => P_Validation_Level,
194: P_Check_Access_Flag => P_Check_Access_Flag,
195: P_Admin_Flag => P_Admin_Flag,
196: P_Admin_Group_Id => P_Admin_Group_Id,

Line 206: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

202: X_Msg_Data => x_msg_data
203: );
204: l_msg_data:=l_msg_data || x_msg_Data;
205:
206: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
207: RAISE FND_API.G_EXC_ERROR;
208: END IF;
209: END IF; -- end of main if (referral type is not null)
210:

Line 207: RAISE FND_API.G_EXC_ERROR;

203: );
204: l_msg_data:=l_msg_data || x_msg_Data;
205:
206: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
207: RAISE FND_API.G_EXC_ERROR;
208: END IF;
209: END IF; -- end of main if (referral type is not null)
210:
211:

Line 213: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

209: END IF; -- end of main if (referral type is not null)
210:
211:
212:
213: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
214: RAISE FND_API.g_exc_unexpected_error;
215: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
216: RAISE FND_API.g_exc_error;
217: END IF;

Line 214: RAISE FND_API.g_exc_unexpected_error;

210:
211:
212:
213: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
214: RAISE FND_API.g_exc_unexpected_error;
215: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
216: RAISE FND_API.g_exc_error;
217: END IF;
218:

Line 215: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

211:
212:
213: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
214: RAISE FND_API.g_exc_unexpected_error;
215: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
216: RAISE FND_API.g_exc_error;
217: END IF;
218:
219: -------------------- finish --------------------------

Line 216: RAISE FND_API.g_exc_error;

212:
213: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
214: RAISE FND_API.g_exc_unexpected_error;
215: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
216: RAISE FND_API.g_exc_error;
217: END IF;
218:
219: -------------------- finish --------------------------
220:

Line 223: IF FND_API.to_boolean(p_commit) THEN

219: -------------------- finish --------------------------
220:
221:
222: -- Check for commit
223: IF FND_API.to_boolean(p_commit) THEN
224: COMMIT;
225: END IF;
226:
227: FND_MSG_PUB.count_and_get(

Line 228: p_encoded => FND_API.g_false,

224: COMMIT;
225: END IF;
226:
227: FND_MSG_PUB.count_and_get(
228: p_encoded => FND_API.g_false,
229: p_count => x_msg_count,
230: p_data => x_msg_data
231: );
232:

Line 238: WHEN FND_API.g_exc_error THEN

234: -- x_msg_data:=l_msg_data;
235:
236: EXCEPTION
237:
238: WHEN FND_API.g_exc_error THEN
239: ROLLBACK TO Update_sales_referral_lead;
240: x_return_status := FND_API.g_ret_sts_error;
241: FND_MSG_PUB.count_and_get(
242: p_encoded => FND_API.g_false,

Line 240: x_return_status := FND_API.g_ret_sts_error;

236: EXCEPTION
237:
238: WHEN FND_API.g_exc_error THEN
239: ROLLBACK TO Update_sales_referral_lead;
240: x_return_status := FND_API.g_ret_sts_error;
241: FND_MSG_PUB.count_and_get(
242: p_encoded => FND_API.g_false,
243: p_count => x_msg_count,
244: p_data => x_msg_data

Line 242: p_encoded => FND_API.g_false,

238: WHEN FND_API.g_exc_error THEN
239: ROLLBACK TO Update_sales_referral_lead;
240: x_return_status := FND_API.g_ret_sts_error;
241: FND_MSG_PUB.count_and_get(
242: p_encoded => FND_API.g_false,
243: p_count => x_msg_count,
244: p_data => x_msg_data
245: );
246: /*FOR l_index IN 1..FND_MSG_PUB.Count_Msg LOOP

Line 249: p_encoded => FND_API.G_FALSE);

245: );
246: /*FOR l_index IN 1..FND_MSG_PUB.Count_Msg LOOP
247: my_message := FND_MSG_PUB.Get(
248: p_msg_index => l_index,
249: p_encoded => FND_API.G_FALSE);
250:
251: loop
252: exit when my_message is null;
253: l_msg_data:= l_msg_data || substr( my_message, 1, 250 );

Line 259: WHEN FND_API.g_exc_unexpected_error THEN

255: end loop;
256:
257: END LOOP;*/
258: --x_msg_data:=l_msg_data;
259: WHEN FND_API.g_exc_unexpected_error THEN
260: ROLLBACK TO Update_sales_referral_lead;
261: x_return_status := FND_API.g_ret_sts_unexp_error ;
262: FND_MSG_PUB.count_and_get(
263: p_encoded => FND_API.g_false,

Line 261: x_return_status := FND_API.g_ret_sts_unexp_error ;

257: END LOOP;*/
258: --x_msg_data:=l_msg_data;
259: WHEN FND_API.g_exc_unexpected_error THEN
260: ROLLBACK TO Update_sales_referral_lead;
261: x_return_status := FND_API.g_ret_sts_unexp_error ;
262: FND_MSG_PUB.count_and_get(
263: p_encoded => FND_API.g_false,
264: p_count => x_msg_count,
265: p_data => x_msg_data

Line 263: p_encoded => FND_API.g_false,

259: WHEN FND_API.g_exc_unexpected_error THEN
260: ROLLBACK TO Update_sales_referral_lead;
261: x_return_status := FND_API.g_ret_sts_unexp_error ;
262: FND_MSG_PUB.count_and_get(
263: p_encoded => FND_API.g_false,
264: p_count => x_msg_count,
265: p_data => x_msg_data
266: );
267:

Line 271: x_return_status := FND_API.g_ret_sts_unexp_error ;

267:
268: --x_msg_data:=l_msg_data;
269: WHEN OTHERS THEN
270: ROLLBACK TO Update_sales_referral_lead;
271: x_return_status := FND_API.g_ret_sts_unexp_error ;
272:
273: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
274: THEN
275: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 279: p_encoded => FND_API.g_false,

275: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
276: END IF;
277:
278: FND_MSG_PUB.count_and_get(
279: p_encoded => FND_API.g_false,
280: p_count => x_msg_count,
281: p_data => x_msg_data
282: );
283: --x_msg_data:=l_msg_data;

Line 302: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

298: ---------------------------------------------------------------------
299:
300: PROCEDURE Notify_Party (
301: p_api_version IN NUMBER := 1.0
302: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
303: ,p_commit IN VARCHAR2 := FND_API.g_false
304: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
305: ,p_lead_id IN NUMBER
306: ,p_lead_status IN VARCHAR2

Line 303: ,p_commit IN VARCHAR2 := FND_API.g_false

299:
300: PROCEDURE Notify_Party (
301: p_api_version IN NUMBER := 1.0
302: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
303: ,p_commit IN VARCHAR2 := FND_API.g_false
304: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
305: ,p_lead_id IN NUMBER
306: ,p_lead_status IN VARCHAR2
307: ,p_salesforce_id IN NUMBER

Line 304: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

300: PROCEDURE Notify_Party (
301: p_api_version IN NUMBER := 1.0
302: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
303: ,p_commit IN VARCHAR2 := FND_API.g_false
304: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
305: ,p_lead_id IN NUMBER
306: ,p_lead_status IN VARCHAR2
307: ,p_salesforce_id IN NUMBER
308: ,p_overriding_usernames IN t_overriding_usernames default G_MISS_OVER_USERNAMES_TBL

Line 490: IF NOT FND_API.Compatible_API_Call ( l_api_version,

486:
487: BEGIN
488: l_mesg_data := l_mesg_data ||'start notify party';
489: -- Standard call to check for call compatibility.
490: IF NOT FND_API.Compatible_API_Call ( l_api_version,
491: p_api_version,
492: l_api_name,
493: G_PKG_NAME)
494: THEN

Line 495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

491: p_api_version,
492: l_api_name,
493: G_PKG_NAME)
494: THEN
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: END IF;
497:
498: -- Initialize message list if p_init_msg_list is set to TRUE.
499: IF FND_API.to_Boolean( p_init_msg_list )

Line 499: IF FND_API.to_Boolean( p_init_msg_list )

495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: END IF;
497:
498: -- Initialize message list if p_init_msg_list is set to TRUE.
499: IF FND_API.to_Boolean( p_init_msg_list )
500: THEN
501: FND_MSG_PUB.initialize;
502: END IF;
503:

Line 514: x_return_status := FND_API.G_RET_STS_SUCCESS;

510:
511:
512:
513: -- Initialize API return status to SUCCESS
514: x_return_status := FND_API.G_RET_STS_SUCCESS;
515:
516: -- Notify_Party processing steps
517: -- Get Lead Details using sales_lead_id from as_sales_leads
518: -- Get a workflow item key from the sequence

Line 922: WHEN FND_API.G_EXC_ERROR THEN

918: );
919: -- x_msg_data := l_mesg_data;
920: EXCEPTION
921:
922: WHEN FND_API.G_EXC_ERROR THEN
923:
924: x_return_status := FND_API.G_RET_STS_ERROR ;
925: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
926: p_count => x_msg_count,

Line 924: x_return_status := FND_API.G_RET_STS_ERROR ;

920: EXCEPTION
921:
922: WHEN FND_API.G_EXC_ERROR THEN
923:
924: x_return_status := FND_API.G_RET_STS_ERROR ;
925: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
926: p_count => x_msg_count,
927: p_data => x_msg_data);
928: --x_msg_data := 'SWKHANNA1'||l_mesg_data;

Line 925: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

921:
922: WHEN FND_API.G_EXC_ERROR THEN
923:
924: x_return_status := FND_API.G_RET_STS_ERROR ;
925: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
926: p_count => x_msg_count,
927: p_data => x_msg_data);
928: --x_msg_data := 'SWKHANNA1'||l_mesg_data;
929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

925: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
926: p_count => x_msg_count,
927: p_data => x_msg_data);
928: --x_msg_data := 'SWKHANNA1'||l_mesg_data;
929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
930:
931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
932: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
933: p_count => x_msg_count,

Line 931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

927: p_data => x_msg_data);
928: --x_msg_data := 'SWKHANNA1'||l_mesg_data;
929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
930:
931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
932: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
933: p_count => x_msg_count,
934: p_data => x_msg_data);
935: --x_msg_data := 'SWKHANNA2'||l_mesg_data;

Line 932: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,

928: --x_msg_data := 'SWKHANNA1'||l_mesg_data;
929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
930:
931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
932: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_TRUE,
933: p_count => x_msg_count,
934: p_data => x_msg_data);
935: --x_msg_data := 'SWKHANNA2'||l_mesg_data;
936: WHEN OTHERS THEN

Line 938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

934: p_data => x_msg_data);
935: --x_msg_data := 'SWKHANNA2'||l_mesg_data;
936: WHEN OTHERS THEN
937:
938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
939: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
940: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
941: p_count => x_msg_count,
942: p_data => x_msg_data);

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

936: WHEN OTHERS THEN
937:
938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
939: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
940: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
941: p_count => x_msg_count,
942: p_data => x_msg_data);
943: --x_msg_data :='SWKHANNA3'|| l_mesg_data;
944: End Notify_Party;