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

Line 40: x_return_status := FND_API.G_RET_STS_SUCCESS;

36: l_loading_status varchar2(50);
37:
38: BEGIN
39: -- Initialize API return status to success
40: x_return_status := FND_API.G_RET_STS_SUCCESS;
41: x_loading_status := p_loading_status;
42: -- API body
43: -- Check payment plan cannot null or missing
44: IF (cn_api.chk_miss_null_char_para

Line 48: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN

44: IF (cn_api.chk_miss_null_char_para
45: (p_char_para => p_srp_pmt_plans_rec.pmt_plan_name,
46: p_obj_name => G_PMT_PLAN,
47: p_loading_status => x_loading_status,
48: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN
49: RAISE FND_API.G_EXC_ERROR ;
50: END IF;
51:
52: -- migrate org ID

Line 49: RAISE FND_API.G_EXC_ERROR ;

45: (p_char_para => p_srp_pmt_plans_rec.pmt_plan_name,
46: p_obj_name => G_PMT_PLAN,
47: p_loading_status => x_loading_status,
48: x_loading_status => x_loading_status) = FND_API.G_TRUE) THEN
49: RAISE FND_API.G_EXC_ERROR ;
50: END IF;
51:
52: -- migrate org ID
53: x_srp_pmt_plans_row.org_id := p_srp_pmt_plans_rec.org_id;

Line 73: RAISE FND_API.G_EXC_ERROR ;

69: FND_MESSAGE.SET_TOKEN('PP_NAME',p_srp_pmt_plans_rec.pmt_plan_name);
70: FND_MSG_PUB.Add;
71: END IF;
72: x_loading_status := 'CN_PP_NOT_EXIST';
73: RAISE FND_API.G_EXC_ERROR ;
74: END;
75: -- Check if Salesrep exist
76: cn_api.chk_and_get_salesrep_id
77: (p_emp_num => p_srp_pmt_plans_rec.emp_num

Line 83: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

79: ,p_org_id => p_srp_pmt_plans_rec.org_id
80: ,x_salesrep_id => x_srp_pmt_plans_row.salesrep_id
81: ,x_return_status => x_return_status
82: ,x_loading_status => l_loading_status);
83: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
84: x_loading_status := l_loading_status;
85: RAISE FND_API.G_EXC_ERROR ;
86: END IF;
87:

Line 85: RAISE FND_API.G_EXC_ERROR ;

81: ,x_return_status => x_return_status
82: ,x_loading_status => l_loading_status);
83: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
84: x_loading_status := l_loading_status;
85: RAISE FND_API.G_EXC_ERROR ;
86: END IF;
87:
88: -- get salesrep start date, end date
89: BEGIN

Line 102: RAISE FND_API.G_EXC_ERROR ;

98: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_NOT_EXIST');
99: FND_MSG_PUB.Add;
100: END IF;
101: x_loading_status := 'CN_SRP_NOT_EXIST';
102: RAISE FND_API.G_EXC_ERROR ;
103: END;
104:
105: -- If p_action = 'GETOLDREC'
106: -- called by update(), need to get old_rec data

Line 123: WHEN FND_API.G_EXC_ERROR THEN

119: x_srp_pmt_plans_row.srp_pmt_plan_id := NULL;
120: END;
121: -- End of API body.
122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: x_return_status := FND_API.G_RET_STS_ERROR ;
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
127: x_loading_status := 'UNEXPECTED_ERR';

Line 124: x_return_status := FND_API.G_RET_STS_ERROR ;

120: END;
121: -- End of API body.
122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: x_return_status := FND_API.G_RET_STS_ERROR ;
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
127: x_loading_status := 'UNEXPECTED_ERR';
128: WHEN OTHERS THEN

Line 125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

121: -- End of API body.
122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: x_return_status := FND_API.G_RET_STS_ERROR ;
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
127: x_loading_status := 'UNEXPECTED_ERR';
128: WHEN OTHERS THEN
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: x_return_status := FND_API.G_RET_STS_ERROR ;
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
127: x_loading_status := 'UNEXPECTED_ERR';
128: WHEN OTHERS THEN
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
130: x_loading_status := 'UNEXPECTED_ERR';

Line 129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
127: x_loading_status := 'UNEXPECTED_ERR';
128: WHEN OTHERS THEN
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
130: x_loading_status := 'UNEXPECTED_ERR';
131: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
132: THEN
133: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

Line 183: x_return_status := FND_API.G_RET_STS_SUCCESS;

179: AND csqa.quota_id = cq.quota_id;
180:
181: BEGIN
182: -- Initialize API return status to success
183: x_return_status := FND_API.G_RET_STS_SUCCESS;
184: x_loading_status := p_loading_status;
185:
186: -- API body
187: -- Get IDs by using Names. Also check the existence

Line 202: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

198: p_action => p_action,
199: p_loading_status => x_loading_status,
200: x_loading_status => x_loading_status
201: );
202: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
203: RAISE FND_API.G_EXC_ERROR ;
204: ELSIF x_srp_pmt_plans_row.srp_pmt_plan_id IS NOT NULL AND
205: p_action <> 'UPDATE' THEN
206: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 203: RAISE FND_API.G_EXC_ERROR ;

199: p_loading_status => x_loading_status,
200: x_loading_status => x_loading_status
201: );
202: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
203: RAISE FND_API.G_EXC_ERROR ;
204: ELSIF x_srp_pmt_plans_row.srp_pmt_plan_id IS NOT NULL AND
205: p_action <> 'UPDATE' THEN
206: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
207: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PMT_PLAN_EXIST');

Line 211: RAISE FND_API.G_EXC_ERROR ;

207: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PMT_PLAN_EXIST');
208: FND_MSG_PUB.Add;
209: END IF;
210: x_loading_status := 'CN_SRP_PMT_PLAN_EXIST';
211: RAISE FND_API.G_EXC_ERROR ;
212: END IF;
213:
214: -- Get correct start date if it's null
215: IF p_srp_pmt_plans_rec.start_date IS NULL THEN

Line 235: Decode(p_srp_pmt_plans_rec.minimum_amount,FND_API.G_MISS_NUM,l_pp_min,

231: FROM cn_pmt_plans
232: WHERE pmt_plan_id = x_srp_pmt_plans_row.pmt_plan_id;
233:
234: SELECT
235: Decode(p_srp_pmt_plans_rec.minimum_amount,FND_API.G_MISS_NUM,l_pp_min,
236: p_srp_pmt_plans_rec.minimum_amount),
237: Decode(p_srp_pmt_plans_rec.maximum_amount,FND_API.G_MISS_NUM,l_pp_max,
238: p_srp_pmt_plans_rec.maximum_amount)
239: INTO

Line 237: Decode(p_srp_pmt_plans_rec.maximum_amount,FND_API.G_MISS_NUM,l_pp_max,

233:
234: SELECT
235: Decode(p_srp_pmt_plans_rec.minimum_amount,FND_API.G_MISS_NUM,l_pp_min,
236: p_srp_pmt_plans_rec.minimum_amount),
237: Decode(p_srp_pmt_plans_rec.maximum_amount,FND_API.G_MISS_NUM,l_pp_max,
238: p_srp_pmt_plans_rec.maximum_amount)
239: INTO
240: x_srp_pmt_plans_row.minimum_amount,
241: x_srp_pmt_plans_row.maximum_amount

Line 246: WHEN FND_API.G_EXC_ERROR THEN

242: FROM dual;
243:
244: -- End of API body.
245: EXCEPTION
246: WHEN FND_API.G_EXC_ERROR THEN
247: x_return_status := FND_API.G_RET_STS_ERROR ;
248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
250: x_loading_status := 'UNEXPECTED_ERR';

Line 247: x_return_status := FND_API.G_RET_STS_ERROR ;

243:
244: -- End of API body.
245: EXCEPTION
246: WHEN FND_API.G_EXC_ERROR THEN
247: x_return_status := FND_API.G_RET_STS_ERROR ;
248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
250: x_loading_status := 'UNEXPECTED_ERR';
251: WHEN OTHERS THEN

Line 248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

244: -- End of API body.
245: EXCEPTION
246: WHEN FND_API.G_EXC_ERROR THEN
247: x_return_status := FND_API.G_RET_STS_ERROR ;
248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
250: x_loading_status := 'UNEXPECTED_ERR';
251: WHEN OTHERS THEN
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

245: EXCEPTION
246: WHEN FND_API.G_EXC_ERROR THEN
247: x_return_status := FND_API.G_RET_STS_ERROR ;
248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
250: x_loading_status := 'UNEXPECTED_ERR';
251: WHEN OTHERS THEN
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
253: x_loading_status := 'UNEXPECTED_ERR';

Line 252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
250: x_loading_status := 'UNEXPECTED_ERR';
251: WHEN OTHERS THEN
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
253: x_loading_status := 'UNEXPECTED_ERR';
254: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
255: THEN
256: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

Line 301: IF NOT FND_API.compatible_api_call

297: BEGIN
298: -- Standard Start of API savepoint
299: SAVEPOINT Create_Srp_Pmt_Plan;
300: -- Standard call to check for call compatibility.
301: IF NOT FND_API.compatible_api_call
302: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
303: THEN
304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305: END IF;

Line 304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

300: -- Standard call to check for call compatibility.
301: IF NOT FND_API.compatible_api_call
302: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
303: THEN
304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305: END IF;
306: -- Initialize message list if p_init_msg_list is set to TRUE.
307: IF FND_API.to_Boolean( p_init_msg_list ) THEN
308: FND_MSG_PUB.initialize;

Line 307: IF FND_API.to_Boolean( p_init_msg_list ) THEN

303: THEN
304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305: END IF;
306: -- Initialize message list if p_init_msg_list is set to TRUE.
307: IF FND_API.to_Boolean( p_init_msg_list ) THEN
308: FND_MSG_PUB.initialize;
309: END IF;
310: -- Initialize API return status to success
311: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 311: x_return_status := FND_API.G_RET_STS_SUCCESS;

307: IF FND_API.to_Boolean( p_init_msg_list ) THEN
308: FND_MSG_PUB.initialize;
309: END IF;
310: -- Initialize API return status to success
311: x_return_status := FND_API.G_RET_STS_SUCCESS;
312: x_loading_status := 'CN_INSERTED';
313: -- Assign the parameter to a local variable
314: l_spp_rec := p_srp_pmt_plans_rec;
315:

Line 338: FND_API.G_MISS_CHAR, NULL ,

334:
335: -- Trim spaces before/after user input string, get Value-Id para assigned
336: SELECT
337: Decode(p_srp_pmt_plans_rec.pmt_plan_name,
338: FND_API.G_MISS_CHAR, NULL ,
339: Ltrim(Rtrim(p_srp_pmt_plans_rec.pmt_plan_name))),
340: Decode(p_srp_pmt_plans_rec.salesrep_type,
341: FND_API.G_MISS_CHAR, NULL ,
342: Ltrim(Rtrim(p_srp_pmt_plans_rec.salesrep_type))),

Line 341: FND_API.G_MISS_CHAR, NULL ,

337: Decode(p_srp_pmt_plans_rec.pmt_plan_name,
338: FND_API.G_MISS_CHAR, NULL ,
339: Ltrim(Rtrim(p_srp_pmt_plans_rec.pmt_plan_name))),
340: Decode(p_srp_pmt_plans_rec.salesrep_type,
341: FND_API.G_MISS_CHAR, NULL ,
342: Ltrim(Rtrim(p_srp_pmt_plans_rec.salesrep_type))),
343: Decode(p_srp_pmt_plans_rec.emp_num,
344: FND_API.G_MISS_CHAR, NULL ,
345: Ltrim(Rtrim(p_srp_pmt_plans_rec.emp_num))),

Line 344: FND_API.G_MISS_CHAR, NULL ,

340: Decode(p_srp_pmt_plans_rec.salesrep_type,
341: FND_API.G_MISS_CHAR, NULL ,
342: Ltrim(Rtrim(p_srp_pmt_plans_rec.salesrep_type))),
343: Decode(p_srp_pmt_plans_rec.emp_num,
344: FND_API.G_MISS_CHAR, NULL ,
345: Ltrim(Rtrim(p_srp_pmt_plans_rec.emp_num))),
346: Decode(p_srp_pmt_plans_rec.start_date,
347: FND_API.G_MISS_DATE,To_date(NULL) ,
348: trunc(p_srp_pmt_plans_rec.start_date)),

Line 347: FND_API.G_MISS_DATE,To_date(NULL) ,

343: Decode(p_srp_pmt_plans_rec.emp_num,
344: FND_API.G_MISS_CHAR, NULL ,
345: Ltrim(Rtrim(p_srp_pmt_plans_rec.emp_num))),
346: Decode(p_srp_pmt_plans_rec.start_date,
347: FND_API.G_MISS_DATE,To_date(NULL) ,
348: trunc(p_srp_pmt_plans_rec.start_date)),
349: Decode(p_srp_pmt_plans_rec.end_date,
350: FND_API.G_MISS_DATE,To_date(NULL) ,
351: trunc(p_srp_pmt_plans_rec.end_date))

Line 350: FND_API.G_MISS_DATE,To_date(NULL) ,

346: Decode(p_srp_pmt_plans_rec.start_date,
347: FND_API.G_MISS_DATE,To_date(NULL) ,
348: trunc(p_srp_pmt_plans_rec.start_date)),
349: Decode(p_srp_pmt_plans_rec.end_date,
350: FND_API.G_MISS_DATE,To_date(NULL) ,
351: trunc(p_srp_pmt_plans_rec.end_date))
352: INTO
353: l_spp_rec.pmt_plan_name,
354: l_spp_rec.salesrep_type,

Line 372: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

368: p_action => l_action,
369: p_loading_status => x_loading_status,
370: x_loading_status => x_loading_status
371: );
372: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
373: RAISE FND_API.G_EXC_ERROR ;
374: END IF;
375:
376: --

Line 373: RAISE FND_API.G_EXC_ERROR ;

369: p_loading_status => x_loading_status,
370: x_loading_status => x_loading_status
371: );
372: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
373: RAISE FND_API.G_EXC_ERROR ;
374: END IF;
375:
376: --
377: -- User hooks

Line 386: p_init_msg_list => fnd_api.g_false,

382: 'C')
383: THEN
384: cn_srp_pmt_plans_pub_cuhk.create_srp_pmt_plan_pre
385: (p_api_version => p_api_version,
386: p_init_msg_list => fnd_api.g_false,
387: p_commit => fnd_api.g_false,
388: p_validation_level => p_validation_level,
389: x_return_status => x_return_status,
390: x_msg_count => x_msg_count,

Line 387: p_commit => fnd_api.g_false,

383: THEN
384: cn_srp_pmt_plans_pub_cuhk.create_srp_pmt_plan_pre
385: (p_api_version => p_api_version,
386: p_init_msg_list => fnd_api.g_false,
387: p_commit => fnd_api.g_false,
388: p_validation_level => p_validation_level,
389: x_return_status => x_return_status,
390: x_msg_count => x_msg_count,
391: x_msg_data => x_msg_data,

Line 397: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

393: x_srp_pmt_plan_id => x_srp_pmt_plan_id,
394: x_loading_status => x_loading_status
395: );
396:
397: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
398: THEN
399: RAISE FND_API.G_EXC_ERROR;
400: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
401: THEN

Line 399: RAISE FND_API.G_EXC_ERROR;

395: );
396:
397: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
398: THEN
399: RAISE FND_API.G_EXC_ERROR;
400: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
401: THEN
402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: END IF;

Line 400: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

396:
397: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
398: THEN
399: RAISE FND_API.G_EXC_ERROR;
400: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
401: THEN
402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: END IF;
404: END IF;

Line 402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

398: THEN
399: RAISE FND_API.G_EXC_ERROR;
400: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
401: THEN
402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: END IF;
404: END IF;
405:
406: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

Line 413: p_init_msg_list => fnd_api.g_false,

409: 'V')
410: THEN
411: cn_srp_pmt_plans_pub_vuhk.create_srp_pmt_plan_pre
412: (p_api_version => p_api_version,
413: p_init_msg_list => fnd_api.g_false,
414: p_commit => fnd_api.g_false,
415: p_validation_level => p_validation_level,
416: x_return_status => x_return_status,
417: x_msg_count => x_msg_count,

Line 414: p_commit => fnd_api.g_false,

410: THEN
411: cn_srp_pmt_plans_pub_vuhk.create_srp_pmt_plan_pre
412: (p_api_version => p_api_version,
413: p_init_msg_list => fnd_api.g_false,
414: p_commit => fnd_api.g_false,
415: p_validation_level => p_validation_level,
416: x_return_status => x_return_status,
417: x_msg_count => x_msg_count,
418: x_msg_data => x_msg_data,

Line 424: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

420: x_srp_pmt_plan_id => x_srp_pmt_plan_id,
421: x_loading_status => x_loading_status
422: );
423:
424: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
425: THEN
426: RAISE FND_API.G_EXC_ERROR;
427: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
428: THEN

Line 426: RAISE FND_API.G_EXC_ERROR;

422: );
423:
424: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
425: THEN
426: RAISE FND_API.G_EXC_ERROR;
427: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
428: THEN
429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: END IF;

Line 427: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

423:
424: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
425: THEN
426: RAISE FND_API.G_EXC_ERROR;
427: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
428: THEN
429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: END IF;
431: END IF;

Line 429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

425: THEN
426: RAISE FND_API.G_EXC_ERROR;
427: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
428: THEN
429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: END IF;
431: END IF;
432:
433:

Line 448: p_init_msg_list => fnd_api.g_false,

444: l_create_rec.lock_flag := p_srp_pmt_plans_rec.lock_flag;
445:
446: cn_srp_pmt_plans_pvt.create_srp_pmt_plan
447: ( p_api_version => p_api_version,
448: p_init_msg_list => fnd_api.g_false,
449: p_commit => fnd_api.g_false,
450: p_validation_level => p_validation_level,
451: x_return_status => x_return_status,
452: x_loading_status => x_loading_status,

Line 449: p_commit => fnd_api.g_false,

445:
446: cn_srp_pmt_plans_pvt.create_srp_pmt_plan
447: ( p_api_version => p_api_version,
448: p_init_msg_list => fnd_api.g_false,
449: p_commit => fnd_api.g_false,
450: p_validation_level => p_validation_level,
451: x_return_status => x_return_status,
452: x_loading_status => x_loading_status,
453: x_msg_count => x_msg_count,

Line 457: IF x_return_status <> fnd_api.g_ret_sts_success THEN

453: x_msg_count => x_msg_count,
454: x_msg_data => x_msg_data,
455: p_pmt_plan_assign_rec => l_create_rec);
456:
457: IF x_return_status <> fnd_api.g_ret_sts_success THEN
458: RAISE fnd_api.g_exc_error;
459: END IF;
460:
461: x_srp_pmt_plan_id := l_create_rec.srp_pmt_plan_id;

Line 458: RAISE fnd_api.g_exc_error;

454: x_msg_data => x_msg_data,
455: p_pmt_plan_assign_rec => l_create_rec);
456:
457: IF x_return_status <> fnd_api.g_ret_sts_success THEN
458: RAISE fnd_api.g_exc_error;
459: END IF;
460:
461: x_srp_pmt_plan_id := l_create_rec.srp_pmt_plan_id;
462:

Line 477: p_init_msg_list => fnd_api.g_false,

473: 'V')
474: THEN
475: cn_srp_pmt_plans_pub_vuhk.create_srp_pmt_plan_post
476: (p_api_version => p_api_version,
477: p_init_msg_list => fnd_api.g_false,
478: p_commit => fnd_api.g_false,
479: p_validation_level => p_validation_level,
480: x_return_status => x_return_status,
481: x_msg_count => x_msg_count,

Line 478: p_commit => fnd_api.g_false,

474: THEN
475: cn_srp_pmt_plans_pub_vuhk.create_srp_pmt_plan_post
476: (p_api_version => p_api_version,
477: p_init_msg_list => fnd_api.g_false,
478: p_commit => fnd_api.g_false,
479: p_validation_level => p_validation_level,
480: x_return_status => x_return_status,
481: x_msg_count => x_msg_count,
482: x_msg_data => x_msg_data,

Line 488: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

484: x_srp_pmt_plan_id => x_srp_pmt_plan_id,
485: x_loading_status => x_loading_status
486: );
487:
488: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
489: THEN
490: RAISE FND_API.G_EXC_ERROR;
491: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
492: THEN

Line 490: RAISE FND_API.G_EXC_ERROR;

486: );
487:
488: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
489: THEN
490: RAISE FND_API.G_EXC_ERROR;
491: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
492: THEN
493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
494: END IF;

Line 491: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

487:
488: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
489: THEN
490: RAISE FND_API.G_EXC_ERROR;
491: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
492: THEN
493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
494: END IF;
495: END IF;

Line 493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

489: THEN
490: RAISE FND_API.G_EXC_ERROR;
491: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
492: THEN
493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
494: END IF;
495: END IF;
496:
497: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

Line 504: p_init_msg_list => fnd_api.g_false,

500: 'C')
501: THEN
502: cn_srp_pmt_plans_pub_cuhk.create_srp_pmt_plan_post
503: (p_api_version => p_api_version,
504: p_init_msg_list => fnd_api.g_false,
505: p_commit => fnd_api.g_false,
506: p_validation_level => p_validation_level,
507: x_return_status => x_return_status,
508: x_msg_count => x_msg_count,

Line 505: p_commit => fnd_api.g_false,

501: THEN
502: cn_srp_pmt_plans_pub_cuhk.create_srp_pmt_plan_post
503: (p_api_version => p_api_version,
504: p_init_msg_list => fnd_api.g_false,
505: p_commit => fnd_api.g_false,
506: p_validation_level => p_validation_level,
507: x_return_status => x_return_status,
508: x_msg_count => x_msg_count,
509: x_msg_data => x_msg_data,

Line 515: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

511: x_srp_pmt_plan_id => x_srp_pmt_plan_id,
512: x_loading_status => x_loading_status
513: );
514:
515: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
516: THEN
517: RAISE FND_API.G_EXC_ERROR;
518: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
519: THEN

Line 517: RAISE FND_API.G_EXC_ERROR;

513: );
514:
515: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
516: THEN
517: RAISE FND_API.G_EXC_ERROR;
518: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
519: THEN
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: END IF;

Line 518: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

514:
515: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
516: THEN
517: RAISE FND_API.G_EXC_ERROR;
518: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
519: THEN
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: END IF;
522: END IF;

Line 520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

516: THEN
517: RAISE FND_API.G_EXC_ERROR;
518: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
519: THEN
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: END IF;
522: END IF;
523:
524: --

Line 560: IF (x_return_status = FND_API.G_RET_STS_ERROR)

556: p_oai_param => null,
557: p_oai_array => l_oai_array,
558: x_return_code => x_return_status) ;
559:
560: IF (x_return_status = FND_API.G_RET_STS_ERROR)
561: THEN
562: RAISE FND_API.G_EXC_ERROR;
563: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
564: THEN

Line 562: RAISE FND_API.G_EXC_ERROR;

558: x_return_code => x_return_status) ;
559:
560: IF (x_return_status = FND_API.G_RET_STS_ERROR)
561: THEN
562: RAISE FND_API.G_EXC_ERROR;
563: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
564: THEN
565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
566: END IF;

Line 563: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

559:
560: IF (x_return_status = FND_API.G_RET_STS_ERROR)
561: THEN
562: RAISE FND_API.G_EXC_ERROR;
563: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
564: THEN
565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
566: END IF;
567: END IF;

Line 565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

561: THEN
562: RAISE FND_API.G_EXC_ERROR;
563: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
564: THEN
565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
566: END IF;
567: END IF;
568: END IF;
569:

Line 571: IF FND_API.To_Boolean( p_commit ) THEN

567: END IF;
568: END IF;
569:
570: -- Standard check of p_commit.
571: IF FND_API.To_Boolean( p_commit ) THEN
572: COMMIT WORK;
573: END IF;
574: -- Standard call to get message count and if count is 1, get message info.
575: FND_MSG_PUB.Count_And_Get

Line 579: p_encoded => FND_API.G_FALSE

575: FND_MSG_PUB.Count_And_Get
576: (
577: p_count => x_msg_count ,
578: p_data => x_msg_data ,
579: p_encoded => FND_API.G_FALSE
580: );
581:
582: EXCEPTION
583: WHEN FND_API.G_EXC_ERROR THEN

Line 583: WHEN FND_API.G_EXC_ERROR THEN

579: p_encoded => FND_API.G_FALSE
580: );
581:
582: EXCEPTION
583: WHEN FND_API.G_EXC_ERROR THEN
584: ROLLBACK TO Create_Srp_Pmt_Plan ;
585: x_return_status := FND_API.G_RET_STS_ERROR ;
586: FND_MSG_PUB.Count_And_Get
587: (

Line 585: x_return_status := FND_API.G_RET_STS_ERROR ;

581:
582: EXCEPTION
583: WHEN FND_API.G_EXC_ERROR THEN
584: ROLLBACK TO Create_Srp_Pmt_Plan ;
585: x_return_status := FND_API.G_RET_STS_ERROR ;
586: FND_MSG_PUB.Count_And_Get
587: (
588: p_count => x_msg_count ,
589: p_data => x_msg_data ,

Line 590: p_encoded => FND_API.G_FALSE

586: FND_MSG_PUB.Count_And_Get
587: (
588: p_count => x_msg_count ,
589: p_data => x_msg_data ,
590: p_encoded => FND_API.G_FALSE
591: );
592:
593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
594: ROLLBACK TO Create_Srp_Pmt_Plan;

Line 593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

589: p_data => x_msg_data ,
590: p_encoded => FND_API.G_FALSE
591: );
592:
593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
594: ROLLBACK TO Create_Srp_Pmt_Plan;
595: x_loading_status := 'UNEXPECTED_ERR';
596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
597: FND_MSG_PUB.Count_And_Get

Line 596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

592:
593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
594: ROLLBACK TO Create_Srp_Pmt_Plan;
595: x_loading_status := 'UNEXPECTED_ERR';
596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
597: FND_MSG_PUB.Count_And_Get
598: (
599: p_count => x_msg_count ,
600: p_data => x_msg_data ,

Line 601: p_encoded => FND_API.G_FALSE

597: FND_MSG_PUB.Count_And_Get
598: (
599: p_count => x_msg_count ,
600: p_data => x_msg_data ,
601: p_encoded => FND_API.G_FALSE
602: );
603: WHEN OTHERS THEN
604: ROLLBACK TO Create_Srp_Pmt_Plan;
605: x_loading_status := 'UNEXPECTED_ERR';

Line 606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

602: );
603: WHEN OTHERS THEN
604: ROLLBACK TO Create_Srp_Pmt_Plan;
605: x_loading_status := 'UNEXPECTED_ERR';
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
607: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
608: THEN
609: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
610: END IF;

Line 615: p_encoded => FND_API.G_FALSE

611: FND_MSG_PUB.Count_And_Get
612: (
613: p_count => x_msg_count ,
614: p_data => x_msg_data ,
615: p_encoded => FND_API.G_FALSE
616: );
617:
618: END Create_Srp_Pmt_Plan;
619:

Line 671: IF NOT FND_API.compatible_api_call

667:
668: -- Standard Start of API savepoint
669: SAVEPOINT Update_Srp_Pmt_Plan;
670: -- Standard call to check for call compatibility.
671: IF NOT FND_API.compatible_api_call
672: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
673: THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;

Line 674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

670: -- Standard call to check for call compatibility.
671: IF NOT FND_API.compatible_api_call
672: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
673: THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676: -- Initialize message list if p_init_msg_list is set to TRUE.
677: IF FND_API.to_Boolean( p_init_msg_list ) THEN
678: FND_MSG_PUB.initialize;

Line 677: IF FND_API.to_Boolean( p_init_msg_list ) THEN

673: THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676: -- Initialize message list if p_init_msg_list is set to TRUE.
677: IF FND_API.to_Boolean( p_init_msg_list ) THEN
678: FND_MSG_PUB.initialize;
679: END IF;
680: -- Initialize API return status to success
681: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 681: x_return_status := FND_API.G_RET_STS_SUCCESS;

677: IF FND_API.to_Boolean( p_init_msg_list ) THEN
678: FND_MSG_PUB.initialize;
679: END IF;
680: -- Initialize API return status to success
681: x_return_status := FND_API.G_RET_STS_SUCCESS;
682: x_loading_status := 'CN_UPDATED';
683:
684: -- Assign the parameter to a local variable
685: l_old_spp_rec := p_old_srp_pmt_plans_rec;

Line 706: RAISE FND_API.G_EXC_ERROR ;

702: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
703: FND_MSG_PUB.Add;
704: END IF;
705:
706: RAISE FND_API.G_EXC_ERROR ;
707: end if;
708:
709: l_org_id := l_old_spp_rec.org_id;
710: mo_global.validate_orgid_pub_api

Line 752: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

748: p_action => 'GETOLDREC',
749: p_loading_status => x_loading_status,
750: x_loading_status => x_loading_status
751: );
752: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
753: RAISE FND_API.G_EXC_ERROR ;
754: ELSIF l_old_spp_row.srp_pmt_plan_id IS NULL THEN
755: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
756: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PMT_PLAN_NOT_EXIST');

Line 753: RAISE FND_API.G_EXC_ERROR ;

749: p_loading_status => x_loading_status,
750: x_loading_status => x_loading_status
751: );
752: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
753: RAISE FND_API.G_EXC_ERROR ;
754: ELSIF l_old_spp_row.srp_pmt_plan_id IS NULL THEN
755: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
756: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PMT_PLAN_NOT_EXIST');
757: FND_MSG_PUB.Add;

Line 760: RAISE FND_API.G_EXC_ERROR ;

756: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PMT_PLAN_NOT_EXIST');
757: FND_MSG_PUB.Add;
758: END IF;
759: x_loading_status := 'CN_SRP_PMT_PLAN_NOT_EXIST';
760: RAISE FND_API.G_EXC_ERROR ;
761: END IF;
762:
763: -- Trim spaces before/after user input string (New record) if missing,
764: -- assign the old value into it

Line 769: FND_API.G_MISS_CHAR, l_old_spp_rec.pmt_plan_name,

765:
766: IF ((NVL(l_old_spp_row.lock_flag, 'N') <> 'Y') OR (l_check_lock <> 'Y')) THEN
767: SELECT
768: Decode(p_srp_pmt_plans_rec.pmt_plan_name,
769: FND_API.G_MISS_CHAR, l_old_spp_rec.pmt_plan_name,
770: Ltrim(Rtrim(p_srp_pmt_plans_rec.pmt_plan_name))),
771: Decode(p_srp_pmt_plans_rec.salesrep_type,
772: FND_API.G_MISS_CHAR, l_old_spp_rec.salesrep_type,
773: Ltrim(Rtrim(p_srp_pmt_plans_rec.salesrep_type))),

Line 772: FND_API.G_MISS_CHAR, l_old_spp_rec.salesrep_type,

768: Decode(p_srp_pmt_plans_rec.pmt_plan_name,
769: FND_API.G_MISS_CHAR, l_old_spp_rec.pmt_plan_name,
770: Ltrim(Rtrim(p_srp_pmt_plans_rec.pmt_plan_name))),
771: Decode(p_srp_pmt_plans_rec.salesrep_type,
772: FND_API.G_MISS_CHAR, l_old_spp_rec.salesrep_type,
773: Ltrim(Rtrim(p_srp_pmt_plans_rec.salesrep_type))),
774: Decode(p_srp_pmt_plans_rec.emp_num,
775: FND_API.G_MISS_CHAR, l_old_spp_rec.emp_num,
776: Ltrim(Rtrim(p_srp_pmt_plans_rec.emp_num))),

Line 775: FND_API.G_MISS_CHAR, l_old_spp_rec.emp_num,

771: Decode(p_srp_pmt_plans_rec.salesrep_type,
772: FND_API.G_MISS_CHAR, l_old_spp_rec.salesrep_type,
773: Ltrim(Rtrim(p_srp_pmt_plans_rec.salesrep_type))),
774: Decode(p_srp_pmt_plans_rec.emp_num,
775: FND_API.G_MISS_CHAR, l_old_spp_rec.emp_num,
776: Ltrim(Rtrim(p_srp_pmt_plans_rec.emp_num))),
777: Decode(p_srp_pmt_plans_rec.start_date,
778: FND_API.G_MISS_DATE, l_old_spp_row.start_date,
779: trunc(p_srp_pmt_plans_rec.start_date)),

Line 778: FND_API.G_MISS_DATE, l_old_spp_row.start_date,

774: Decode(p_srp_pmt_plans_rec.emp_num,
775: FND_API.G_MISS_CHAR, l_old_spp_rec.emp_num,
776: Ltrim(Rtrim(p_srp_pmt_plans_rec.emp_num))),
777: Decode(p_srp_pmt_plans_rec.start_date,
778: FND_API.G_MISS_DATE, l_old_spp_row.start_date,
779: trunc(p_srp_pmt_plans_rec.start_date)),
780: Decode(p_srp_pmt_plans_rec.end_date,
781: FND_API.G_MISS_DATE, l_old_spp_row.end_date,
782: trunc(p_srp_pmt_plans_rec.end_date))

Line 781: FND_API.G_MISS_DATE, l_old_spp_row.end_date,

777: Decode(p_srp_pmt_plans_rec.start_date,
778: FND_API.G_MISS_DATE, l_old_spp_row.start_date,
779: trunc(p_srp_pmt_plans_rec.start_date)),
780: Decode(p_srp_pmt_plans_rec.end_date,
781: FND_API.G_MISS_DATE, l_old_spp_row.end_date,
782: trunc(p_srp_pmt_plans_rec.end_date))
783: INTO
784: l_spp_rec.pmt_plan_name,
785: l_spp_rec.salesrep_type,

Line 804: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

800: p_action => l_action,
801: p_loading_status => x_loading_status,
802: x_loading_status => x_loading_status
803: );
804: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
805: RAISE FND_API.G_EXC_ERROR ;
806: END IF;
807:
808: --

Line 805: RAISE FND_API.G_EXC_ERROR ;

801: p_loading_status => x_loading_status,
802: x_loading_status => x_loading_status
803: );
804: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
805: RAISE FND_API.G_EXC_ERROR ;
806: END IF;
807:
808: --
809: -- User hooks

Line 818: p_init_msg_list => fnd_api.g_false,

814: 'C')
815: THEN
816: cn_srp_pmt_plans_pub_cuhk.update_srp_pmt_plan_pre
817: (p_api_version => p_api_version,
818: p_init_msg_list => fnd_api.g_false,
819: p_commit => fnd_api.g_false,
820: p_validation_level => p_validation_level,
821: x_return_status => x_return_status,
822: x_msg_count => x_msg_count,

Line 819: p_commit => fnd_api.g_false,

815: THEN
816: cn_srp_pmt_plans_pub_cuhk.update_srp_pmt_plan_pre
817: (p_api_version => p_api_version,
818: p_init_msg_list => fnd_api.g_false,
819: p_commit => fnd_api.g_false,
820: p_validation_level => p_validation_level,
821: x_return_status => x_return_status,
822: x_msg_count => x_msg_count,
823: x_msg_data => x_msg_data,

Line 829: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

825: p_srp_pmt_plans_rec => l_spp_rec,
826: x_loading_status => x_loading_status
827: );
828:
829: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
830: THEN
831: RAISE FND_API.G_EXC_ERROR;
832: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
833: THEN

Line 831: RAISE FND_API.G_EXC_ERROR;

827: );
828:
829: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
830: THEN
831: RAISE FND_API.G_EXC_ERROR;
832: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
833: THEN
834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
835: END IF;

Line 832: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

828:
829: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
830: THEN
831: RAISE FND_API.G_EXC_ERROR;
832: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
833: THEN
834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
835: END IF;
836: END IF;

Line 834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

830: THEN
831: RAISE FND_API.G_EXC_ERROR;
832: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
833: THEN
834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
835: END IF;
836: END IF;
837:
838: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

Line 845: p_init_msg_list => fnd_api.g_false,

841: 'V')
842: THEN
843: cn_srp_pmt_plans_pub_vuhk.update_srp_pmt_plan_pre
844: (p_api_version => p_api_version,
845: p_init_msg_list => fnd_api.g_false,
846: p_commit => fnd_api.g_false,
847: p_validation_level => p_validation_level,
848: x_return_status => x_return_status,
849: x_msg_count => x_msg_count,

Line 846: p_commit => fnd_api.g_false,

842: THEN
843: cn_srp_pmt_plans_pub_vuhk.update_srp_pmt_plan_pre
844: (p_api_version => p_api_version,
845: p_init_msg_list => fnd_api.g_false,
846: p_commit => fnd_api.g_false,
847: p_validation_level => p_validation_level,
848: x_return_status => x_return_status,
849: x_msg_count => x_msg_count,
850: x_msg_data => x_msg_data,

Line 856: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

852: p_srp_pmt_plans_rec => l_spp_rec,
853: x_loading_status => x_loading_status
854: );
855:
856: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
857: THEN
858: RAISE FND_API.G_EXC_ERROR;
859: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
860: THEN

Line 858: RAISE FND_API.G_EXC_ERROR;

854: );
855:
856: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
857: THEN
858: RAISE FND_API.G_EXC_ERROR;
859: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
860: THEN
861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
862: END IF;

Line 859: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

855:
856: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
857: THEN
858: RAISE FND_API.G_EXC_ERROR;
859: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
860: THEN
861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
862: END IF;
863: END IF;

Line 861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

857: THEN
858: RAISE FND_API.G_EXC_ERROR;
859: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
860: THEN
861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
862: END IF;
863: END IF;
864:
865: -- Call private API

Line 881: p_init_msg_list => fnd_api.g_false,

877: l_update_rec.lock_flag := p_srp_pmt_plans_rec.lock_flag;
878:
879: cn_srp_pmt_plans_pvt.update_srp_pmt_plan
880: ( p_api_version => p_api_version,
881: p_init_msg_list => fnd_api.g_false,
882: p_commit => fnd_api.g_false,
883: p_validation_level => p_validation_level,
884: x_return_status => x_return_status,
885: x_loading_status => x_loading_status,

Line 882: p_commit => fnd_api.g_false,

878:
879: cn_srp_pmt_plans_pvt.update_srp_pmt_plan
880: ( p_api_version => p_api_version,
881: p_init_msg_list => fnd_api.g_false,
882: p_commit => fnd_api.g_false,
883: p_validation_level => p_validation_level,
884: x_return_status => x_return_status,
885: x_loading_status => x_loading_status,
886: x_msg_count => x_msg_count,

Line 890: IF x_return_status <> fnd_api.g_ret_sts_success THEN

886: x_msg_count => x_msg_count,
887: x_msg_data => x_msg_data,
888: p_pmt_plan_assign_rec => l_update_rec);
889:
890: IF x_return_status <> fnd_api.g_ret_sts_success THEN
891: RAISE fnd_api.g_exc_error;
892: END IF;
893:
894: END IF;

Line 891: RAISE fnd_api.g_exc_error;

887: x_msg_data => x_msg_data,
888: p_pmt_plan_assign_rec => l_update_rec);
889:
890: IF x_return_status <> fnd_api.g_ret_sts_success THEN
891: RAISE fnd_api.g_exc_error;
892: END IF;
893:
894: END IF;
895: --

Line 909: p_init_msg_list => fnd_api.g_false,

905: 'V')
906: THEN
907: cn_srp_pmt_plans_pub_vuhk.update_srp_pmt_plan_post
908: (p_api_version => p_api_version,
909: p_init_msg_list => fnd_api.g_false,
910: p_commit => fnd_api.g_false,
911: p_validation_level => p_validation_level,
912: x_return_status => x_return_status,
913: x_msg_count => x_msg_count,

Line 910: p_commit => fnd_api.g_false,

906: THEN
907: cn_srp_pmt_plans_pub_vuhk.update_srp_pmt_plan_post
908: (p_api_version => p_api_version,
909: p_init_msg_list => fnd_api.g_false,
910: p_commit => fnd_api.g_false,
911: p_validation_level => p_validation_level,
912: x_return_status => x_return_status,
913: x_msg_count => x_msg_count,
914: x_msg_data => x_msg_data,

Line 920: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

916: p_srp_pmt_plans_rec => l_spp_rec,
917: x_loading_status => x_loading_status
918: );
919:
920: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
921: THEN
922: RAISE FND_API.G_EXC_ERROR;
923: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
924: THEN

Line 922: RAISE FND_API.G_EXC_ERROR;

918: );
919:
920: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
921: THEN
922: RAISE FND_API.G_EXC_ERROR;
923: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
924: THEN
925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
926: END IF;

Line 923: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

919:
920: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
921: THEN
922: RAISE FND_API.G_EXC_ERROR;
923: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
924: THEN
925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
926: END IF;
927: END IF;

Line 925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

921: THEN
922: RAISE FND_API.G_EXC_ERROR;
923: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
924: THEN
925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
926: END IF;
927: END IF;
928:
929: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

Line 936: p_init_msg_list => fnd_api.g_false,

932: 'C')
933: THEN
934: cn_srp_pmt_plans_pub_cuhk.update_srp_pmt_plan_post
935: (p_api_version => p_api_version,
936: p_init_msg_list => fnd_api.g_false,
937: p_commit => fnd_api.g_false,
938: p_validation_level => p_validation_level,
939: x_return_status => x_return_status,
940: x_msg_count => x_msg_count,

Line 937: p_commit => fnd_api.g_false,

933: THEN
934: cn_srp_pmt_plans_pub_cuhk.update_srp_pmt_plan_post
935: (p_api_version => p_api_version,
936: p_init_msg_list => fnd_api.g_false,
937: p_commit => fnd_api.g_false,
938: p_validation_level => p_validation_level,
939: x_return_status => x_return_status,
940: x_msg_count => x_msg_count,
941: x_msg_data => x_msg_data,

Line 947: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

943: p_srp_pmt_plans_rec => l_spp_rec,
944: x_loading_status => x_loading_status
945: );
946:
947: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
948: THEN
949: RAISE FND_API.G_EXC_ERROR;
950: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
951: THEN

Line 949: RAISE FND_API.G_EXC_ERROR;

945: );
946:
947: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
948: THEN
949: RAISE FND_API.G_EXC_ERROR;
950: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
951: THEN
952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
953: END IF;

Line 950: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

946:
947: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
948: THEN
949: RAISE FND_API.G_EXC_ERROR;
950: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
951: THEN
952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
953: END IF;
954: END IF;

Line 952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

948: THEN
949: RAISE FND_API.G_EXC_ERROR;
950: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
951: THEN
952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
953: END IF;
954: END IF;
955:
956: --

Line 993: IF (x_return_status = FND_API.G_RET_STS_ERROR)

989: p_oai_param => null,
990: p_oai_array => l_oai_array,
991: x_return_code => x_return_status) ;
992:
993: IF (x_return_status = FND_API.G_RET_STS_ERROR)
994: THEN
995: RAISE FND_API.G_EXC_ERROR;
996: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
997: THEN

Line 995: RAISE FND_API.G_EXC_ERROR;

991: x_return_code => x_return_status) ;
992:
993: IF (x_return_status = FND_API.G_RET_STS_ERROR)
994: THEN
995: RAISE FND_API.G_EXC_ERROR;
996: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
997: THEN
998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
999: END IF;

Line 996: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

992:
993: IF (x_return_status = FND_API.G_RET_STS_ERROR)
994: THEN
995: RAISE FND_API.G_EXC_ERROR;
996: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
997: THEN
998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
999: END IF;
1000: END IF;

Line 998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

994: THEN
995: RAISE FND_API.G_EXC_ERROR;
996: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
997: THEN
998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
999: END IF;
1000: END IF;
1001: END IF;
1002:

Line 1004: IF FND_API.To_Boolean( p_commit ) THEN

1000: END IF;
1001: END IF;
1002:
1003: -- Standard check of p_commit.
1004: IF FND_API.To_Boolean( p_commit ) THEN
1005: COMMIT WORK;
1006: END IF;
1007: -- Standard call to get message count and if count is 1, get message info.
1008: FND_MSG_PUB.Count_And_Get

Line 1012: p_encoded => FND_API.G_FALSE

1008: FND_MSG_PUB.Count_And_Get
1009: (
1010: p_count => x_msg_count ,
1011: p_data => x_msg_data ,
1012: p_encoded => FND_API.G_FALSE
1013: );
1014:
1015: EXCEPTION
1016: WHEN FND_API.G_EXC_ERROR THEN

Line 1016: WHEN FND_API.G_EXC_ERROR THEN

1012: p_encoded => FND_API.G_FALSE
1013: );
1014:
1015: EXCEPTION
1016: WHEN FND_API.G_EXC_ERROR THEN
1017: ROLLBACK TO Update_Srp_Pmt_Plan ;
1018: x_return_status := FND_API.G_RET_STS_ERROR ;
1019: FND_MSG_PUB.Count_And_Get
1020: (

Line 1018: x_return_status := FND_API.G_RET_STS_ERROR ;

1014:
1015: EXCEPTION
1016: WHEN FND_API.G_EXC_ERROR THEN
1017: ROLLBACK TO Update_Srp_Pmt_Plan ;
1018: x_return_status := FND_API.G_RET_STS_ERROR ;
1019: FND_MSG_PUB.Count_And_Get
1020: (
1021: p_count => x_msg_count ,
1022: p_data => x_msg_data ,

Line 1023: p_encoded => FND_API.G_FALSE

1019: FND_MSG_PUB.Count_And_Get
1020: (
1021: p_count => x_msg_count ,
1022: p_data => x_msg_data ,
1023: p_encoded => FND_API.G_FALSE
1024: );
1025: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1026: ROLLBACK TO Update_Srp_Pmt_Plan;
1027: x_loading_status := 'UNEXPECTED_ERR';

Line 1025: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1021: p_count => x_msg_count ,
1022: p_data => x_msg_data ,
1023: p_encoded => FND_API.G_FALSE
1024: );
1025: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1026: ROLLBACK TO Update_Srp_Pmt_Plan;
1027: x_loading_status := 'UNEXPECTED_ERR';
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1029: FND_MSG_PUB.Count_And_Get

Line 1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1024: );
1025: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1026: ROLLBACK TO Update_Srp_Pmt_Plan;
1027: x_loading_status := 'UNEXPECTED_ERR';
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1029: FND_MSG_PUB.Count_And_Get
1030: (
1031: p_count => x_msg_count ,
1032: p_data => x_msg_data ,

Line 1033: p_encoded => FND_API.G_FALSE

1029: FND_MSG_PUB.Count_And_Get
1030: (
1031: p_count => x_msg_count ,
1032: p_data => x_msg_data ,
1033: p_encoded => FND_API.G_FALSE
1034: );
1035: WHEN OTHERS THEN
1036: ROLLBACK TO Update_Srp_Pmt_Plan;
1037: x_loading_status := 'UNEXPECTED_ERR';

Line 1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1034: );
1035: WHEN OTHERS THEN
1036: ROLLBACK TO Update_Srp_Pmt_Plan;
1037: x_loading_status := 'UNEXPECTED_ERR';
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1039: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1040: THEN
1041: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1042: END IF;

Line 1047: p_encoded => FND_API.G_FALSE

1043: FND_MSG_PUB.Count_And_Get
1044: (
1045: p_count => x_msg_count ,
1046: p_data => x_msg_data ,
1047: p_encoded => FND_API.G_FALSE
1048: );
1049:
1050: END Update_Srp_Pmt_Plan;
1051:

Line 1094: IF NOT FND_API.compatible_api_call

1090:
1091: -- Standard Start of API savepoint
1092: SAVEPOINT Delete_Srp_Pmt_Plan;
1093: -- Standard call to check for call compatibility.
1094: IF NOT FND_API.compatible_api_call
1095: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
1096: THEN
1097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1098: END IF;

Line 1097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1093: -- Standard call to check for call compatibility.
1094: IF NOT FND_API.compatible_api_call
1095: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
1096: THEN
1097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1098: END IF;
1099: -- Initialize message list if p_init_msg_list is set to TRUE.
1100: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1101: FND_MSG_PUB.initialize;

Line 1100: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1096: THEN
1097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1098: END IF;
1099: -- Initialize message list if p_init_msg_list is set to TRUE.
1100: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1101: FND_MSG_PUB.initialize;
1102: END IF;
1103: -- Initialize API return status to success
1104: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1104: x_return_status := FND_API.G_RET_STS_SUCCESS;

1100: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1101: FND_MSG_PUB.initialize;
1102: END IF;
1103: -- Initialize API return status to success
1104: x_return_status := FND_API.G_RET_STS_SUCCESS;
1105: x_loading_status := 'CN_DELETED';
1106: -- Assign the parameter to a local variable
1107: l_spp_rec := p_srp_pmt_plans_rec;
1108:

Line 1158: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1154: p_action => 'GETOLDREC',
1155: p_loading_status => x_loading_status,
1156: x_loading_status => x_loading_status
1157: );
1158: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1159: RAISE FND_API.G_EXC_ERROR ;
1160: ELSIF l_spp_row.srp_pmt_plan_id IS NULL THEN
1161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1162: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PMT_PLAN_NOT_EXIST');

Line 1159: RAISE FND_API.G_EXC_ERROR ;

1155: p_loading_status => x_loading_status,
1156: x_loading_status => x_loading_status
1157: );
1158: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1159: RAISE FND_API.G_EXC_ERROR ;
1160: ELSIF l_spp_row.srp_pmt_plan_id IS NULL THEN
1161: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1162: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PMT_PLAN_NOT_EXIST');
1163: FND_MSG_PUB.Add;

Line 1166: RAISE FND_API.G_EXC_ERROR ;

1162: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PMT_PLAN_NOT_EXIST');
1163: FND_MSG_PUB.Add;
1164: END IF;
1165: x_loading_status := 'CN_SRP_PMT_PLAN_NOT_EXIST';
1166: RAISE FND_API.G_EXC_ERROR ;
1167: END IF;
1168:
1169: --
1170: -- User hooks

Line 1179: p_init_msg_list => fnd_api.g_false,

1175: 'C')
1176: THEN
1177: cn_srp_pmt_plans_pub_cuhk.delete_srp_pmt_plan_pre
1178: (p_api_version => p_api_version,
1179: p_init_msg_list => fnd_api.g_false,
1180: p_commit => fnd_api.g_false,
1181: p_validation_level => p_validation_level,
1182: x_return_status => x_return_status,
1183: x_msg_count => x_msg_count,

Line 1180: p_commit => fnd_api.g_false,

1176: THEN
1177: cn_srp_pmt_plans_pub_cuhk.delete_srp_pmt_plan_pre
1178: (p_api_version => p_api_version,
1179: p_init_msg_list => fnd_api.g_false,
1180: p_commit => fnd_api.g_false,
1181: p_validation_level => p_validation_level,
1182: x_return_status => x_return_status,
1183: x_msg_count => x_msg_count,
1184: x_msg_data => x_msg_data,

Line 1188: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

1184: x_msg_data => x_msg_data,
1185: p_srp_pmt_plans_rec => l_spp_rec,
1186: x_loading_status => x_loading_status
1187: );
1188: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1189: THEN
1190: RAISE FND_API.G_EXC_ERROR;
1191: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1192: THEN

Line 1190: RAISE FND_API.G_EXC_ERROR;

1186: x_loading_status => x_loading_status
1187: );
1188: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1189: THEN
1190: RAISE FND_API.G_EXC_ERROR;
1191: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1192: THEN
1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;

Line 1191: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1187: );
1188: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1189: THEN
1190: RAISE FND_API.G_EXC_ERROR;
1191: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1192: THEN
1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;
1195: END IF;

Line 1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1189: THEN
1190: RAISE FND_API.G_EXC_ERROR;
1191: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1192: THEN
1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;
1195: END IF;
1196:
1197: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

Line 1204: p_init_msg_list => fnd_api.g_false,

1200: 'V')
1201: THEN
1202: cn_srp_pmt_plans_pub_vuhk.delete_srp_pmt_plan_pre
1203: (p_api_version => p_api_version,
1204: p_init_msg_list => fnd_api.g_false,
1205: p_commit => fnd_api.g_false,
1206: p_validation_level => p_validation_level,
1207: x_return_status => x_return_status,
1208: x_msg_count => x_msg_count,

Line 1205: p_commit => fnd_api.g_false,

1201: THEN
1202: cn_srp_pmt_plans_pub_vuhk.delete_srp_pmt_plan_pre
1203: (p_api_version => p_api_version,
1204: p_init_msg_list => fnd_api.g_false,
1205: p_commit => fnd_api.g_false,
1206: p_validation_level => p_validation_level,
1207: x_return_status => x_return_status,
1208: x_msg_count => x_msg_count,
1209: x_msg_data => x_msg_data,

Line 1213: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

1209: x_msg_data => x_msg_data,
1210: p_srp_pmt_plans_rec => l_spp_rec,
1211: x_loading_status => x_loading_status
1212: );
1213: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1214: THEN
1215: RAISE FND_API.G_EXC_ERROR;
1216: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1217: THEN

Line 1215: RAISE FND_API.G_EXC_ERROR;

1211: x_loading_status => x_loading_status
1212: );
1213: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1214: THEN
1215: RAISE FND_API.G_EXC_ERROR;
1216: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1217: THEN
1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1219: END IF;

Line 1216: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1212: );
1213: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1214: THEN
1215: RAISE FND_API.G_EXC_ERROR;
1216: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1217: THEN
1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1219: END IF;
1220: END IF;

Line 1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1214: THEN
1215: RAISE FND_API.G_EXC_ERROR;
1216: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1217: THEN
1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1219: END IF;
1220: END IF;
1221:
1222: -- API body

Line 1227: p_init_msg_list => fnd_api.g_false,

1223:
1224: cn_srp_pmt_plans_pvt.delete_srp_pmt_plan
1225: (
1226: p_api_version => p_api_version,
1227: p_init_msg_list => fnd_api.g_false,
1228: p_commit => fnd_api.g_false,
1229: p_validation_level => p_validation_level,
1230: x_return_status => x_return_status,
1231: x_loading_status => x_loading_status,

Line 1228: p_commit => fnd_api.g_false,

1224: cn_srp_pmt_plans_pvt.delete_srp_pmt_plan
1225: (
1226: p_api_version => p_api_version,
1227: p_init_msg_list => fnd_api.g_false,
1228: p_commit => fnd_api.g_false,
1229: p_validation_level => p_validation_level,
1230: x_return_status => x_return_status,
1231: x_loading_status => x_loading_status,
1232: x_msg_count => x_msg_count,

Line 1236: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1232: x_msg_count => x_msg_count,
1233: x_msg_data => x_msg_data,
1234: p_srp_pmt_plan_id => l_spp_row.srp_pmt_plan_id);
1235:
1236: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1237: RAISE fnd_api.g_exc_error;
1238: END IF;
1239:
1240: --

Line 1237: RAISE fnd_api.g_exc_error;

1233: x_msg_data => x_msg_data,
1234: p_srp_pmt_plan_id => l_spp_row.srp_pmt_plan_id);
1235:
1236: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1237: RAISE fnd_api.g_exc_error;
1238: END IF;
1239:
1240: --
1241: -- End of API body.

Line 1254: p_init_msg_list => fnd_api.g_false,

1250: 'V')
1251: THEN
1252: cn_srp_pmt_plans_pub_vuhk.delete_srp_pmt_plan_post
1253: (p_api_version => p_api_version,
1254: p_init_msg_list => fnd_api.g_false,
1255: p_commit => fnd_api.g_false,
1256: p_validation_level => p_validation_level,
1257: x_return_status => x_return_status,
1258: x_msg_count => x_msg_count,

Line 1255: p_commit => fnd_api.g_false,

1251: THEN
1252: cn_srp_pmt_plans_pub_vuhk.delete_srp_pmt_plan_post
1253: (p_api_version => p_api_version,
1254: p_init_msg_list => fnd_api.g_false,
1255: p_commit => fnd_api.g_false,
1256: p_validation_level => p_validation_level,
1257: x_return_status => x_return_status,
1258: x_msg_count => x_msg_count,
1259: x_msg_data => x_msg_data,

Line 1264: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

1260: p_srp_pmt_plans_rec => l_spp_rec,
1261: x_loading_status => x_loading_status
1262: );
1263:
1264: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1265: THEN
1266: RAISE FND_API.G_EXC_ERROR;
1267: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1268: THEN

Line 1266: RAISE FND_API.G_EXC_ERROR;

1262: );
1263:
1264: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1265: THEN
1266: RAISE FND_API.G_EXC_ERROR;
1267: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1268: THEN
1269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1270: END IF;

Line 1267: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1263:
1264: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1265: THEN
1266: RAISE FND_API.G_EXC_ERROR;
1267: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1268: THEN
1269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1270: END IF;
1271: END IF;

Line 1269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1265: THEN
1266: RAISE FND_API.G_EXC_ERROR;
1267: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1268: THEN
1269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1270: END IF;
1271: END IF;
1272:
1273: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PMT_PLANS_PUB',

Line 1280: p_init_msg_list => fnd_api.g_false,

1276: 'C')
1277: THEN
1278: cn_srp_pmt_plans_pub_cuhk.delete_srp_pmt_plan_post
1279: (p_api_version => p_api_version,
1280: p_init_msg_list => fnd_api.g_false,
1281: p_commit => fnd_api.g_false,
1282: p_validation_level => p_validation_level,
1283: x_return_status => x_return_status,
1284: x_msg_count => x_msg_count,

Line 1281: p_commit => fnd_api.g_false,

1277: THEN
1278: cn_srp_pmt_plans_pub_cuhk.delete_srp_pmt_plan_post
1279: (p_api_version => p_api_version,
1280: p_init_msg_list => fnd_api.g_false,
1281: p_commit => fnd_api.g_false,
1282: p_validation_level => p_validation_level,
1283: x_return_status => x_return_status,
1284: x_msg_count => x_msg_count,
1285: x_msg_data => x_msg_data,

Line 1290: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

1286: p_srp_pmt_plans_rec => l_spp_rec,
1287: x_loading_status => x_loading_status
1288: );
1289:
1290: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1291: THEN
1292: RAISE FND_API.G_EXC_ERROR;
1293: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1294: THEN

Line 1292: RAISE FND_API.G_EXC_ERROR;

1288: );
1289:
1290: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1291: THEN
1292: RAISE FND_API.G_EXC_ERROR;
1293: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1294: THEN
1295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1296: END IF;

Line 1293: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1289:
1290: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1291: THEN
1292: RAISE FND_API.G_EXC_ERROR;
1293: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1294: THEN
1295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1296: END IF;
1297: END IF;

Line 1295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1291: THEN
1292: RAISE FND_API.G_EXC_ERROR;
1293: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1294: THEN
1295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1296: END IF;
1297: END IF;
1298: --
1299: -- Message enable hook

Line 1335: IF (x_return_status = FND_API.G_RET_STS_ERROR)

1331: p_oai_param => null,
1332: p_oai_array => l_oai_array,
1333: x_return_code => x_return_status) ;
1334:
1335: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1336: THEN
1337: RAISE FND_API.G_EXC_ERROR;
1338: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1339: THEN

Line 1337: RAISE FND_API.G_EXC_ERROR;

1333: x_return_code => x_return_status) ;
1334:
1335: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1336: THEN
1337: RAISE FND_API.G_EXC_ERROR;
1338: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1339: THEN
1340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1341: END IF;

Line 1338: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1334:
1335: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1336: THEN
1337: RAISE FND_API.G_EXC_ERROR;
1338: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1339: THEN
1340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1341: END IF;
1342: END IF;

Line 1340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1336: THEN
1337: RAISE FND_API.G_EXC_ERROR;
1338: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1339: THEN
1340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1341: END IF;
1342: END IF;
1343: END IF;
1344:

Line 1346: IF FND_API.To_Boolean( p_commit ) THEN

1342: END IF;
1343: END IF;
1344:
1345: -- Standard check of p_commit.
1346: IF FND_API.To_Boolean( p_commit ) THEN
1347: COMMIT WORK;
1348: END IF;
1349: -- Standard call to get message count and if count is 1, get message info.
1350: FND_MSG_PUB.Count_And_Get

Line 1354: p_encoded => FND_API.G_FALSE

1350: FND_MSG_PUB.Count_And_Get
1351: (
1352: p_count => x_msg_count ,
1353: p_data => x_msg_data ,
1354: p_encoded => FND_API.G_FALSE
1355: );
1356:
1357: EXCEPTION
1358: WHEN FND_API.G_EXC_ERROR THEN

Line 1358: WHEN FND_API.G_EXC_ERROR THEN

1354: p_encoded => FND_API.G_FALSE
1355: );
1356:
1357: EXCEPTION
1358: WHEN FND_API.G_EXC_ERROR THEN
1359: ROLLBACK TO Delete_Srp_Pmt_Plan ;
1360: x_return_status := FND_API.G_RET_STS_ERROR ;
1361: FND_MSG_PUB.Count_And_Get
1362: (

Line 1360: x_return_status := FND_API.G_RET_STS_ERROR ;

1356:
1357: EXCEPTION
1358: WHEN FND_API.G_EXC_ERROR THEN
1359: ROLLBACK TO Delete_Srp_Pmt_Plan ;
1360: x_return_status := FND_API.G_RET_STS_ERROR ;
1361: FND_MSG_PUB.Count_And_Get
1362: (
1363: p_count => x_msg_count ,
1364: p_data => x_msg_data ,

Line 1365: p_encoded => FND_API.G_FALSE

1361: FND_MSG_PUB.Count_And_Get
1362: (
1363: p_count => x_msg_count ,
1364: p_data => x_msg_data ,
1365: p_encoded => FND_API.G_FALSE
1366: );
1367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1368: ROLLBACK TO Delete_Srp_Pmt_Plan;
1369: x_loading_status := 'UNEXPECTED_ERR';

Line 1367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1363: p_count => x_msg_count ,
1364: p_data => x_msg_data ,
1365: p_encoded => FND_API.G_FALSE
1366: );
1367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1368: ROLLBACK TO Delete_Srp_Pmt_Plan;
1369: x_loading_status := 'UNEXPECTED_ERR';
1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1371: FND_MSG_PUB.Count_And_Get

Line 1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1366: );
1367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1368: ROLLBACK TO Delete_Srp_Pmt_Plan;
1369: x_loading_status := 'UNEXPECTED_ERR';
1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1371: FND_MSG_PUB.Count_And_Get
1372: (
1373: p_count => x_msg_count ,
1374: p_data => x_msg_data ,

Line 1375: p_encoded => FND_API.G_FALSE

1371: FND_MSG_PUB.Count_And_Get
1372: (
1373: p_count => x_msg_count ,
1374: p_data => x_msg_data ,
1375: p_encoded => FND_API.G_FALSE
1376: );
1377: WHEN OTHERS THEN
1378: ROLLBACK TO Delete_Srp_Pmt_Plan;
1379: x_loading_status := 'UNEXPECTED_ERR';

Line 1380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1376: );
1377: WHEN OTHERS THEN
1378: ROLLBACK TO Delete_Srp_Pmt_Plan;
1379: x_loading_status := 'UNEXPECTED_ERR';
1380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1381: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1382: THEN
1383: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1384: END IF;

Line 1389: p_encoded => FND_API.G_FALSE

1385: FND_MSG_PUB.Count_And_Get
1386: (
1387: p_count => x_msg_count ,
1388: p_data => x_msg_data ,
1389: p_encoded => FND_API.G_FALSE
1390: );
1391:
1392: END Delete_Srp_Pmt_Plan;
1393:

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

1398:
1399: PROCEDURE Create_Mass_Asgn_Srp_Pmt_Plan
1400: (
1401: p_api_version IN NUMBER,
1402: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1404: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1405: x_return_status OUT NOCOPY VARCHAR2,
1406: x_msg_count OUT NOCOPY NUMBER,

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

1399: PROCEDURE Create_Mass_Asgn_Srp_Pmt_Plan
1400: (
1401: p_api_version IN NUMBER,
1402: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1404: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1405: x_return_status OUT NOCOPY VARCHAR2,
1406: x_msg_count OUT NOCOPY NUMBER,
1407: x_msg_data OUT NOCOPY VARCHAR2,

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

1400: (
1401: p_api_version IN NUMBER,
1402: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1404: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1405: x_return_status OUT NOCOPY VARCHAR2,
1406: x_msg_count OUT NOCOPY NUMBER,
1407: x_msg_data OUT NOCOPY VARCHAR2,
1408: p_srp_role_id IN NUMBER,

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

1431:
1432: PROCEDURE Update_Mass_Asgn_Srp_Pmt_plan
1433: (
1434: p_api_version IN NUMBER,
1435: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1436: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1437: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1438: x_return_status OUT NOCOPY VARCHAR2,
1439: x_msg_count OUT NOCOPY NUMBER,

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

1432: PROCEDURE Update_Mass_Asgn_Srp_Pmt_plan
1433: (
1434: p_api_version IN NUMBER,
1435: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1436: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1437: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1438: x_return_status OUT NOCOPY VARCHAR2,
1439: x_msg_count OUT NOCOPY NUMBER,
1440: x_msg_data OUT NOCOPY VARCHAR2,

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

1433: (
1434: p_api_version IN NUMBER,
1435: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1436: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1437: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1438: x_return_status OUT NOCOPY VARCHAR2,
1439: x_msg_count OUT NOCOPY NUMBER,
1440: x_msg_data OUT NOCOPY VARCHAR2,
1441: p_srp_role_id IN NUMBER,

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

1462: -- --------------------------------------------------------------------------*
1463:
1464: PROCEDURE Delete_Mass_Asgn_Srp_Pmt_Plan
1465: (p_api_version IN NUMBER,
1466: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1467: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1468: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1469: x_return_status OUT NOCOPY VARCHAR2,
1470: x_msg_count OUT NOCOPY NUMBER,

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

1463:
1464: PROCEDURE Delete_Mass_Asgn_Srp_Pmt_Plan
1465: (p_api_version IN NUMBER,
1466: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1467: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1468: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1469: x_return_status OUT NOCOPY VARCHAR2,
1470: x_msg_count OUT NOCOPY NUMBER,
1471: x_msg_data OUT NOCOPY VARCHAR2,

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

1464: PROCEDURE Delete_Mass_Asgn_Srp_Pmt_Plan
1465: (p_api_version IN NUMBER,
1466: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1467: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1468: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1469: x_return_status OUT NOCOPY VARCHAR2,
1470: x_msg_count OUT NOCOPY NUMBER,
1471: x_msg_data OUT NOCOPY VARCHAR2,
1472: p_srp_role_id IN NUMBER,