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

Line 15: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

11: --+
12: -- -------------------------------------------------------------------------+
13: -- PROCEDURE Get_Credit_Rule_Attr
14: -- (p_api_version IN NUMBER,
15: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
16: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,
17: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
18: -- p_start_record IN NUMBER := -1,
19: -- p_fetch_size IN NUMBER := -1,

Line 16: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,

12: -- -------------------------------------------------------------------------+
13: -- PROCEDURE Get_Credit_Rule_Attr
14: -- (p_api_version IN NUMBER,
15: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
16: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,
17: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
18: -- p_start_record IN NUMBER := -1,
19: -- p_fetch_size IN NUMBER := -1,
20: -- p_search_uname IN cn_sca_rule_attributes.user_column_name%TYPE := '%',

Line 17: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

13: -- PROCEDURE Get_Credit_Rule_Attr
14: -- (p_api_version IN NUMBER,
15: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
16: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,
17: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
18: -- p_start_record IN NUMBER := -1,
19: -- p_fetch_size IN NUMBER := -1,
20: -- p_search_uname IN cn_sca_rule_attributes.user_column_name%TYPE := '%',
21: -- p_search_trx_source IN cn_sca_rule_attributes.transaction_source%TYPE,

Line 109: -- IF NOT FND_API.Compatible_API_Call

105: -- BEGIN
106: -- -- Standard Start of API savepoint
107: -- SAVEPOINT Get_Credit_Rule_Attr;
108: -- -- Standard call to check for call compatibility.
109: -- IF NOT FND_API.Compatible_API_Call
110: -- (l_api_version ,
111: -- p_api_version ,
112: -- l_api_name ,
113: -- G_PKG_NAME )

Line 115: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

111: -- p_api_version ,
112: -- l_api_name ,
113: -- G_PKG_NAME )
114: -- THEN
115: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: -- END IF;
117: -- -- Initialize message list if p_init_msg_list is set to TRUE.
118: -- IF FND_API.to_Boolean( p_init_msg_list ) THEN
119: -- FND_MSG_PUB.initialize;

Line 118: -- IF FND_API.to_Boolean( p_init_msg_list ) THEN

114: -- THEN
115: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: -- END IF;
117: -- -- Initialize message list if p_init_msg_list is set to TRUE.
118: -- IF FND_API.to_Boolean( p_init_msg_list ) THEN
119: -- FND_MSG_PUB.initialize;
120: -- END IF;
121: -- -- Initialize API return status to success
122: -- x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 122: -- x_return_status := FND_API.G_RET_STS_SUCCESS;

118: -- IF FND_API.to_Boolean( p_init_msg_list ) THEN
119: -- FND_MSG_PUB.initialize;
120: -- END IF;
121: -- -- Initialize API return status to success
122: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
123: -- -- API body
124: --
125: -- x_credit_rule_attr := G_MISS_SCACRRR_REC_TB ;
126: --

Line 155: -- x_credit_rule_attr(l_counter).value_set_name := FND_API.G_MISS_CHAR;

151: -- x_credit_rule_attr(l_counter).enable_flag := nvl(l_credit_rule_attr_search.enabled_flag,'N');
152: -- x_credit_rule_attr(l_counter).object_version_number := l_credit_rule_attr_search.object_version_number;
153: --
154: -- IF l_credit_rule_attr_search.VALUE_SET_ID IS NULL THEN
155: -- x_credit_rule_attr(l_counter).value_set_name := FND_API.G_MISS_CHAR;
156: -- ELSE
157: -- OPEN get_value_set_name(l_credit_rule_attr_search.VALUE_SET_ID);
158: -- FETCH get_value_set_name INTO l_value_set_name;
159: --

Line 192: -- x_credit_rule_attr(l_counter).value_set_name := FND_API.G_MISS_CHAR;

188: -- x_credit_rule_attr(l_counter).enable_flag := nvl(l_credit_rule_attr.enabled_flag,'N');
189: -- x_credit_rule_attr(l_counter).object_version_number := l_credit_rule_attr.object_version_number;
190: --
191: -- IF l_credit_rule_attr.VALUE_SET_ID IS NULL THEN
192: -- x_credit_rule_attr(l_counter).value_set_name := FND_API.G_MISS_CHAR;
193: -- ELSE
194: -- OPEN get_value_set_name(l_credit_rule_attr.VALUE_SET_ID);
195: -- FETCH get_value_set_name INTO l_value_set_name;
196: --

Line 210: -- IF FND_API.To_Boolean( p_commit ) THEN

206: -- end if;
207: --
208: -- -- End of API body.
209: -- -- Standard check of p_commit.
210: -- IF FND_API.To_Boolean( p_commit ) THEN
211: -- COMMIT WORK;
212: -- END IF;
213: -- -- Standard call to get message count and if count is 1, get message info.
214: -- FND_MSG_PUB.Count_And_Get

Line 217: -- p_encoded => FND_API.G_FALSE );

213: -- -- Standard call to get message count and if count is 1, get message info.
214: -- FND_MSG_PUB.Count_And_Get
215: -- (p_count => x_msg_count ,
216: -- p_data => x_msg_data ,
217: -- p_encoded => FND_API.G_FALSE );
218: -- EXCEPTION
219: -- WHEN FND_API.G_EXC_ERROR THEN
220: -- ROLLBACK TO Get_Credit_Rule_Attr;
221: -- x_return_status := FND_API.G_RET_STS_ERROR ;

Line 219: -- WHEN FND_API.G_EXC_ERROR THEN

215: -- (p_count => x_msg_count ,
216: -- p_data => x_msg_data ,
217: -- p_encoded => FND_API.G_FALSE );
218: -- EXCEPTION
219: -- WHEN FND_API.G_EXC_ERROR THEN
220: -- ROLLBACK TO Get_Credit_Rule_Attr;
221: -- x_return_status := FND_API.G_RET_STS_ERROR ;
222: -- FND_MSG_PUB.Count_And_Get
223: -- (p_count => x_msg_count ,

Line 221: -- x_return_status := FND_API.G_RET_STS_ERROR ;

217: -- p_encoded => FND_API.G_FALSE );
218: -- EXCEPTION
219: -- WHEN FND_API.G_EXC_ERROR THEN
220: -- ROLLBACK TO Get_Credit_Rule_Attr;
221: -- x_return_status := FND_API.G_RET_STS_ERROR ;
222: -- FND_MSG_PUB.Count_And_Get
223: -- (p_count => x_msg_count ,
224: -- p_data => x_msg_data ,
225: -- p_encoded => FND_API.G_FALSE );

Line 225: -- p_encoded => FND_API.G_FALSE );

221: -- x_return_status := FND_API.G_RET_STS_ERROR ;
222: -- FND_MSG_PUB.Count_And_Get
223: -- (p_count => x_msg_count ,
224: -- p_data => x_msg_data ,
225: -- p_encoded => FND_API.G_FALSE );
226: -- WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: -- ROLLBACK TO Get_Credit_Rule_Attr;
228: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
229: -- FND_MSG_PUB.Count_And_Get

Line 226: -- WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

222: -- FND_MSG_PUB.Count_And_Get
223: -- (p_count => x_msg_count ,
224: -- p_data => x_msg_data ,
225: -- p_encoded => FND_API.G_FALSE );
226: -- WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: -- ROLLBACK TO Get_Credit_Rule_Attr;
228: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
229: -- FND_MSG_PUB.Count_And_Get
230: -- (p_count => x_msg_count ,

Line 228: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

224: -- p_data => x_msg_data ,
225: -- p_encoded => FND_API.G_FALSE );
226: -- WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: -- ROLLBACK TO Get_Credit_Rule_Attr;
228: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
229: -- FND_MSG_PUB.Count_And_Get
230: -- (p_count => x_msg_count ,
231: -- p_data => x_msg_data ,
232: -- p_encoded => FND_API.G_FALSE );

Line 232: -- p_encoded => FND_API.G_FALSE );

228: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
229: -- FND_MSG_PUB.Count_And_Get
230: -- (p_count => x_msg_count ,
231: -- p_data => x_msg_data ,
232: -- p_encoded => FND_API.G_FALSE );
233: -- WHEN OTHERS THEN
234: -- ROLLBACK TO Get_Credit_Rule_Attr;
235: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
236: -- IF FND_MSG_PUB.Check_Msg_Level

Line 235: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

231: -- p_data => x_msg_data ,
232: -- p_encoded => FND_API.G_FALSE );
233: -- WHEN OTHERS THEN
234: -- ROLLBACK TO Get_Credit_Rule_Attr;
235: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
236: -- IF FND_MSG_PUB.Check_Msg_Level
237: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
238: -- THEN
239: -- FND_MSG_PUB.Add_Exc_Msg

Line 246: -- p_encoded => FND_API.G_FALSE );

242: -- END IF;
243: -- FND_MSG_PUB.Count_And_Get
244: -- (p_count => x_msg_count ,
245: -- p_data => x_msg_data ,
246: -- p_encoded => FND_API.G_FALSE );
247: -- END Get_Credit_Rule_Attr;
248:
249:
250: --------------------------------------------------------------------------+

Line 303: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

299:
300:
301: -- Standard call to check for call compatibility.
302:
303: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
304: p_api_version ,
305: l_api_name ,
306: L_PKG_NAME )
307: THEN

Line 308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

304: p_api_version ,
305: l_api_name ,
306: L_PKG_NAME )
307: THEN
308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
309: END IF;
310:
311:
312: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 314: IF FND_API.to_Boolean( p_init_msg_list ) THEN

310:
311:
312: -- Initialize message list if p_init_msg_list is set to TRUE.
313:
314: IF FND_API.to_Boolean( p_init_msg_list ) THEN
315: FND_MSG_PUB.initialize;
316: END IF;
317:
318: l_credit_rule_attr_rec := p_credit_rule_attr_rec;

Line 321: x_return_status := FND_API.G_RET_STS_SUCCESS;

317:
318: l_credit_rule_attr_rec := p_credit_rule_attr_rec;
319: -- Initialize API return status to success
320:
321: x_return_status := FND_API.G_RET_STS_SUCCESS;
322:
323:
324: --OPEN get_value_set_id;
325: --FETCH get_value_set_id INTO l_value_set_id;

Line 335: RAISE FND_API.G_EXC_ERROR;

331:
332: IF (l_credit_rule_attr_rec.source_column IS NULL AND l_credit_rule_attr_rec.transaction_source = 'CN') THEN
333: fnd_message.set_name('CN', 'CN_REQ_PAR_MISSING');
334: fnd_msg_pub.add;
335: RAISE FND_API.G_EXC_ERROR;
336: END IF;
337:
338: IF l_credit_rule_attr_rec.user_name IS NULL
339: THEN

Line 362: RAISE FND_API.G_EXC_ERROR;

358: fnd_msg_pub.add;
359: END IF;
360:
361:
362: RAISE FND_API.G_EXC_ERROR;
363: END IF ;
364:
365: SELECT cn_sca_rule_attributes_s.nextval INTO l_sca_rule_attribute_id FROM sys.dual;
366: -- API body

Line 412: IF FND_API.To_Boolean( p_commit ) THEN

408: SET sca_mapping_status = 'UNSYNC'
409: WHERE org_id = p_org_id; -- MOAC Change
410: END IF;
411:
412: IF FND_API.To_Boolean( p_commit ) THEN
413: COMMIT WORK;
414: END IF;
415:
416:

Line 423: p_encoded => FND_API.G_FALSE

419: FND_MSG_PUB.Count_And_Get
420: (
421: p_count => x_msg_count ,
422: p_data => x_msg_data ,
423: p_encoded => FND_API.G_FALSE
424: );
425:
426: EXCEPTION
427: WHEN FND_API.G_EXC_ERROR THEN

Line 427: WHEN FND_API.G_EXC_ERROR THEN

423: p_encoded => FND_API.G_FALSE
424: );
425:
426: EXCEPTION
427: WHEN FND_API.G_EXC_ERROR THEN
428: ROLLBACK TO Create_Credit_RuleAttr;
429: x_return_status := FND_API.G_RET_STS_ERROR ;
430: FND_MSG_PUB.Count_And_Get
431: (

Line 429: x_return_status := FND_API.G_RET_STS_ERROR ;

425:
426: EXCEPTION
427: WHEN FND_API.G_EXC_ERROR THEN
428: ROLLBACK TO Create_Credit_RuleAttr;
429: x_return_status := FND_API.G_RET_STS_ERROR ;
430: FND_MSG_PUB.Count_And_Get
431: (
432: p_count => x_msg_count ,
433: p_data => x_msg_data ,

Line 434: p_encoded => FND_API.G_FALSE

430: FND_MSG_PUB.Count_And_Get
431: (
432: p_count => x_msg_count ,
433: p_data => x_msg_data ,
434: p_encoded => FND_API.G_FALSE
435: );
436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: ROLLBACK TO Create_Credit_RuleAttr;
438: IF SQLCODE = '-1'

Line 436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

432: p_count => x_msg_count ,
433: p_data => x_msg_data ,
434: p_encoded => FND_API.G_FALSE
435: );
436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: ROLLBACK TO Create_Credit_RuleAttr;
438: IF SQLCODE = '-1'
439: THEN
440: fnd_message.set_name('CN', 'CN_SCA_RULE_ATTRIBUTES_UNIQUE');

Line 442: RAISE fnd_api.g_exc_error;

438: IF SQLCODE = '-1'
439: THEN
440: fnd_message.set_name('CN', 'CN_SCA_RULE_ATTRIBUTES_UNIQUE');
441: fnd_msg_pub.ADD;
442: RAISE fnd_api.g_exc_error;
443: END IF;
444: --x_loading_status := 'UNEXPECTED_ERR';
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
446: FND_MSG_PUB.Count_And_Get

Line 445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

441: fnd_msg_pub.ADD;
442: RAISE fnd_api.g_exc_error;
443: END IF;
444: --x_loading_status := 'UNEXPECTED_ERR';
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
446: FND_MSG_PUB.Count_And_Get
447: (
448: p_count => x_msg_count ,
449: p_data => x_msg_data ,

Line 450: p_encoded => FND_API.G_FALSE

446: FND_MSG_PUB.Count_And_Get
447: (
448: p_count => x_msg_count ,
449: p_data => x_msg_data ,
450: p_encoded => FND_API.G_FALSE
451: );
452: WHEN OTHERS THEN
453: ROLLBACK TO Create_Credit_RuleAttr;
454: --x_loading_status := 'UNEXPECTED_ERR';

Line 455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

451: );
452: WHEN OTHERS THEN
453: ROLLBACK TO Create_Credit_RuleAttr;
454: --x_loading_status := 'UNEXPECTED_ERR';
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
456: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
457: THEN
458: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
459: END IF;

Line 464: p_encoded => FND_API.G_FALSE

460: FND_MSG_PUB.Count_And_Get
461: (
462: p_count => x_msg_count ,
463: p_data => x_msg_data ,
464: p_encoded => FND_API.G_FALSE
465: );
466: END Create_Credit_RuleAttr;
467:
468: ---------------------------------------------------------------------------+

Line 528: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

524: SAVEPOINT Update_Credit_RuleAttr;
525:
526: -- Standard call to check for call compatibility.
527:
528: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
529: p_api_version ,
530: l_api_name ,
531: L_PKG_NAME )
532: THEN

Line 533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

529: p_api_version ,
530: l_api_name ,
531: L_PKG_NAME )
532: THEN
533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
534: END IF;
535:
536: -- Initialize message list if p_init_msg_list is set to TRUE.
537:

Line 538: IF FND_API.to_Boolean( p_init_msg_list ) THEN

534: END IF;
535:
536: -- Initialize message list if p_init_msg_list is set to TRUE.
537:
538: IF FND_API.to_Boolean( p_init_msg_list ) THEN
539: FND_MSG_PUB.initialize;
540: END IF;
541:
542: -- Initialize API return status to success

Line 545: x_return_status := FND_API.G_RET_STS_SUCCESS;

541:
542: -- Initialize API return status to success
543: l_credit_rule_attr_rec := p_credit_rule_attr_rec;
544:
545: x_return_status := FND_API.G_RET_STS_SUCCESS;
546:
547:
548: SELECT object_version_number -- ,sca_rule_attribute_id
549: INTO l_old_ovn -- ,l_sca_rule_attribute_id

Line 560: raise fnd_api.g_exc_error;

556:
557: IF l_old_ovn <> p_credit_rule_attr_rec.object_version_number THEN
558: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
559: fnd_msg_pub.add;
560: raise fnd_api.g_exc_error;
561: END IF;
562:
563: --OPEN get_value_set_id;
564: -- FETCH get_value_set_id INTO l_value_set_id;

Line 581: RAISE FND_API.G_EXC_ERROR;

577:
578: IF (l_credit_rule_attr_rec.source_column IS NULL AND l_credit_rule_attr_rec.transaction_source = 'CN'AND (l_credit_rule_attr_rec.enable_flag <> 'N' OR l_value_set_id IS NOT NULL OR l_credit_rule_attr_rec.user_name IS NOT NULL )) THEN
579: fnd_message.set_name('CN', 'CN_REQ_PAR_MISSING');
580: fnd_msg_pub.add;
581: RAISE FND_API.G_EXC_ERROR;
582: END IF;
583:
584:
585: IF (l_value_set_id IS NULL AND l_credit_rule_attr_rec.user_name IS NULL

Line 610: RAISE FND_API.G_EXC_ERROR;

606: fnd_message.set_name('CN', 'CN_SCA_RULE_COND_EXISTS');
607: fnd_msg_pub.add;
608: END IF;
609:
610: RAISE FND_API.G_EXC_ERROR;
611: END IF;
612: ELSE
613: IF l_credit_rule_attr_rec.user_name IS NULL
614: THEN

Line 633: RAISE FND_API.G_EXC_ERROR;

629: fnd_msg_pub.add;
630: END IF;
631:
632:
633: RAISE FND_API.G_EXC_ERROR;
634: END IF ;
635: --END IF;
636:
637: l_count2 :=0;

Line 698: RAISE FND_API.G_EXC_ERROR;

694: fnd_message.set_name('CN', 'CN_SCA_RULE_COND_EXISTS');
695: fnd_msg_pub.add;
696: END IF;
697:
698: RAISE FND_API.G_EXC_ERROR;
699: END IF;
700: END IF;
701:
702: IF (SQL%NOTFOUND) THEN

Line 708: IF FND_API.To_Boolean( p_commit ) THEN

704: END IF;
705: -- End of API body.
706: -- Standard check of p_commit.
707:
708: IF FND_API.To_Boolean( p_commit ) THEN
709: COMMIT WORK;
710: END IF;
711:
712:

Line 719: p_encoded => FND_API.G_FALSE

715: FND_MSG_PUB.Count_And_Get
716: (
717: p_count => x_msg_count ,
718: p_data => x_msg_data ,
719: p_encoded => FND_API.G_FALSE
720: );
721: EXCEPTION
722: WHEN FND_API.G_EXC_ERROR THEN
723: ROLLBACK TO Update_Credit_RuleAttr;

Line 722: WHEN FND_API.G_EXC_ERROR THEN

718: p_data => x_msg_data ,
719: p_encoded => FND_API.G_FALSE
720: );
721: EXCEPTION
722: WHEN FND_API.G_EXC_ERROR THEN
723: ROLLBACK TO Update_Credit_RuleAttr;
724: x_return_status := FND_API.G_RET_STS_ERROR ;
725: FND_MSG_PUB.Count_And_Get
726: (

Line 724: x_return_status := FND_API.G_RET_STS_ERROR ;

720: );
721: EXCEPTION
722: WHEN FND_API.G_EXC_ERROR THEN
723: ROLLBACK TO Update_Credit_RuleAttr;
724: x_return_status := FND_API.G_RET_STS_ERROR ;
725: FND_MSG_PUB.Count_And_Get
726: (
727: p_count => x_msg_count ,
728: p_data => x_msg_data ,

Line 729: p_encoded => FND_API.G_FALSE

725: FND_MSG_PUB.Count_And_Get
726: (
727: p_count => x_msg_count ,
728: p_data => x_msg_data ,
729: p_encoded => FND_API.G_FALSE
730: );
731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
732: ROLLBACK TO Update_Credit_RuleAttr;
733: --x_loading_status := 'UNEXPECTED_ERR';

Line 731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

727: p_count => x_msg_count ,
728: p_data => x_msg_data ,
729: p_encoded => FND_API.G_FALSE
730: );
731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
732: ROLLBACK TO Update_Credit_RuleAttr;
733: --x_loading_status := 'UNEXPECTED_ERR';
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
735: FND_MSG_PUB.Count_And_Get

Line 734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

730: );
731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
732: ROLLBACK TO Update_Credit_RuleAttr;
733: --x_loading_status := 'UNEXPECTED_ERR';
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
735: FND_MSG_PUB.Count_And_Get
736: (
737: p_count => x_msg_count ,
738: p_data => x_msg_data ,

Line 739: p_encoded => FND_API.G_FALSE

735: FND_MSG_PUB.Count_And_Get
736: (
737: p_count => x_msg_count ,
738: p_data => x_msg_data ,
739: p_encoded => FND_API.G_FALSE
740: );
741: WHEN OTHERS THEN
742: ROLLBACK TO Update_Credit_RuleAttr;
743: -- x_loading_status := 'UNEXPECTED_ERR';

Line 744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

740: );
741: WHEN OTHERS THEN
742: ROLLBACK TO Update_Credit_RuleAttr;
743: -- x_loading_status := 'UNEXPECTED_ERR';
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
745: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
746: THEN
747: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
748: END IF;

Line 753: p_encoded => FND_API.G_FALSE

749: FND_MSG_PUB.Count_And_Get
750: (
751: p_count => x_msg_count ,
752: p_data => x_msg_data ,
753: p_encoded => FND_API.G_FALSE
754: );
755: END Update_Credit_RuleAttr;
756:
757: -- TODO: Make MOAC Changes

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

756:
757: -- TODO: Make MOAC Changes
758: PROCEDURE Generate_Package
759: ( p_api_version IN NUMBER,
760: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
761: p_commit IN VARCHAR2 := FND_API.G_FALSE,
762: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
763: p_org_id IN NUMBER, -- MOAC Change
764: x_return_status OUT NOCOPY VARCHAR2,

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

757: -- TODO: Make MOAC Changes
758: PROCEDURE Generate_Package
759: ( p_api_version IN NUMBER,
760: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
761: p_commit IN VARCHAR2 := FND_API.G_FALSE,
762: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
763: p_org_id IN NUMBER, -- MOAC Change
764: x_return_status OUT NOCOPY VARCHAR2,
765: x_msg_count OUT NOCOPY NUMBER,

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

758: PROCEDURE Generate_Package
759: ( p_api_version IN NUMBER,
760: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
761: p_commit IN VARCHAR2 := FND_API.G_FALSE,
762: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
763: p_org_id IN NUMBER, -- MOAC Change
764: x_return_status OUT NOCOPY VARCHAR2,
765: x_msg_count OUT NOCOPY NUMBER,
766: x_msg_data OUT NOCOPY VARCHAR2

Line 795: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

791: SAVEPOINT Generate_Package;
792:
793: -- Standard call to check for call compatibility.
794:
795: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
796: p_api_version ,
797: l_api_name ,
798: L_PKG_NAME )
799: THEN

Line 800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

796: p_api_version ,
797: l_api_name ,
798: L_PKG_NAME )
799: THEN
800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
801: END IF;
802:
803: -- Initialize message list if p_init_msg_list is set to TRUE.
804:

Line 805: IF FND_API.to_Boolean( p_init_msg_list ) THEN

801: END IF;
802:
803: -- Initialize message list if p_init_msg_list is set to TRUE.
804:
805: IF FND_API.to_Boolean( p_init_msg_list ) THEN
806: FND_MSG_PUB.initialize;
807: END IF;
808:
809:

Line 810: x_return_status := FND_API.G_RET_STS_SUCCESS;

806: FND_MSG_PUB.initialize;
807: END IF;
808:
809:
810: x_return_status := FND_API.G_RET_STS_SUCCESS;
811: -- x_loading_status := 'CN_UPDATED';
812:
813: -- API body
814: SELECT count(*) into l_count

Line 822: raise fnd_api.g_exc_error;

818:
819: IF l_count = 0 THEN
820: fnd_message.set_name('CN', 'CN_NORECORD_GENERATE');
821: fnd_msg_pub.add;
822: raise fnd_api.g_exc_error;
823: ELSE
824:
825:
826: CN_SCA_INTERFACE_MAP_PVT.GENERATE (

Line 828: p_init_msg_list => fnd_api.g_true,

824:
825:
826: CN_SCA_INTERFACE_MAP_PVT.GENERATE (
827: p_api_version => l_api_version,
828: p_init_msg_list => fnd_api.g_true,
829: p_commit => fnd_api.g_false,
830: p_validation_level => fnd_api.g_valid_level_full,
831: p_org_id => p_org_id, -- MOAC Change
832: x_return_status => l_return_status,

Line 829: p_commit => fnd_api.g_false,

825:
826: CN_SCA_INTERFACE_MAP_PVT.GENERATE (
827: p_api_version => l_api_version,
828: p_init_msg_list => fnd_api.g_true,
829: p_commit => fnd_api.g_false,
830: p_validation_level => fnd_api.g_valid_level_full,
831: p_org_id => p_org_id, -- MOAC Change
832: x_return_status => l_return_status,
833: x_msg_count => l_msg_count,

Line 830: p_validation_level => fnd_api.g_valid_level_full,

826: CN_SCA_INTERFACE_MAP_PVT.GENERATE (
827: p_api_version => l_api_version,
828: p_init_msg_list => fnd_api.g_true,
829: p_commit => fnd_api.g_false,
830: p_validation_level => fnd_api.g_valid_level_full,
831: p_org_id => p_org_id, -- MOAC Change
832: x_return_status => l_return_status,
833: x_msg_count => l_msg_count,
834: x_msg_data => l_msg_data

Line 840: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

836:
837:
838:
839:
840: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
841: x_return_status := l_return_status;
842: fnd_message.set_name('CN', 'CN_GENERATION_FAILED');
843:
844: fnd_msg_pub.add;

Line 845: RAISE FND_API.G_EXC_ERROR;

841: x_return_status := l_return_status;
842: fnd_message.set_name('CN', 'CN_GENERATION_FAILED');
843:
844: fnd_msg_pub.add;
845: RAISE FND_API.G_EXC_ERROR;
846: -- x_loading_status := l_loading_status;
847:
848: ELSE
849: update cn_repositories

Line 859: IF FND_API.To_Boolean( p_commit ) THEN

855:
856: -- End of API body.
857: -- Standard check of p_commit.
858:
859: IF FND_API.To_Boolean( p_commit ) THEN
860: COMMIT WORK;
861: END IF;
862:
863:

Line 870: p_encoded => FND_API.G_FALSE

866: FND_MSG_PUB.Count_And_Get
867: (
868: p_count => x_msg_count ,
869: p_data => x_msg_data ,
870: p_encoded => FND_API.G_FALSE
871: );
872: EXCEPTION
873: WHEN FND_API.G_EXC_ERROR THEN
874: --ROLLBACK TO Generate_Package;

Line 873: WHEN FND_API.G_EXC_ERROR THEN

869: p_data => x_msg_data ,
870: p_encoded => FND_API.G_FALSE
871: );
872: EXCEPTION
873: WHEN FND_API.G_EXC_ERROR THEN
874: --ROLLBACK TO Generate_Package;
875: x_return_status := FND_API.G_RET_STS_ERROR ;
876: FND_MSG_PUB.Count_And_Get
877: (

Line 875: x_return_status := FND_API.G_RET_STS_ERROR ;

871: );
872: EXCEPTION
873: WHEN FND_API.G_EXC_ERROR THEN
874: --ROLLBACK TO Generate_Package;
875: x_return_status := FND_API.G_RET_STS_ERROR ;
876: FND_MSG_PUB.Count_And_Get
877: (
878: p_count => x_msg_count ,
879: p_data => x_msg_data ,

Line 880: p_encoded => FND_API.G_FALSE

876: FND_MSG_PUB.Count_And_Get
877: (
878: p_count => x_msg_count ,
879: p_data => x_msg_data ,
880: p_encoded => FND_API.G_FALSE
881: );
882: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
883: --ROLLBACK TO Generate_Package;
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 882: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

878: p_count => x_msg_count ,
879: p_data => x_msg_data ,
880: p_encoded => FND_API.G_FALSE
881: );
882: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
883: --ROLLBACK TO Generate_Package;
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
885: FND_MSG_PUB.Count_And_Get
886: (

Line 884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

880: p_encoded => FND_API.G_FALSE
881: );
882: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
883: --ROLLBACK TO Generate_Package;
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
885: FND_MSG_PUB.Count_And_Get
886: (
887: p_count => x_msg_count ,
888: p_data => x_msg_data ,

Line 889: p_encoded => FND_API.G_FALSE

885: FND_MSG_PUB.Count_And_Get
886: (
887: p_count => x_msg_count ,
888: p_data => x_msg_data ,
889: p_encoded => FND_API.G_FALSE
890: );
891: WHEN OTHERS THEN
892: --ROLLBACK TO Generate_Package;
893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

889: p_encoded => FND_API.G_FALSE
890: );
891: WHEN OTHERS THEN
892: --ROLLBACK TO Generate_Package;
893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
894: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
895: THEN
896: FND_MSG_PUB.Add_Exc_Msg( L_PKG_NAME ,l_api_name );
897: END IF;

Line 902: p_encoded => FND_API.G_FALSE

898: FND_MSG_PUB.Count_And_Get
899: (
900: p_count => x_msg_count ,
901: p_data => x_msg_data ,
902: p_encoded => FND_API.G_FALSE
903: );
904:
905: END Generate_Package;
906: