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

Line 325: cn_utils.appendcr(body_code, ' x_return_status := FND_API.G_RET_STS_SUCCESS;');

321:
322:
323: cn_utils.appendcr(body_code, ' l_stmt VARCHAR2(32000); ');
324: cn_utils.appendcr(body_code, ' BEGIN ');
325: cn_utils.appendcr(body_code, ' x_return_status := FND_API.G_RET_STS_SUCCESS;');
326: cn_utils.appendcr(body_code, ' l_stmt := ');
327: cn_utils.appendcr(body_code, '''INSERT INTO cn_sca_winning_rules_gtt (sca_batch_id , ''||');
328: cn_utils.appendcr(body_code, ''' sca_credit_rule_id, ''|| ');
329: cn_utils.appendcr(body_code, ''' sca_headers_interface_id, ''|| ');

Line 483: cn_utils.appindcr(body_code, ' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ; ');

479:
480: cn_utils.appendcr(body_code, ' EXECUTE IMMEDIATE l_stmt;');
481:
482: cn_utils.appindcr(body_code, ' EXCEPTION WHEN OTHERS THEN ');
483: cn_utils.appindcr(body_code, ' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ; ');
484: cn_utils.appindcr(body_code, ' IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)');
485: cn_utils.appindcr(body_code, ' THEN ');
486: cn_utils.appindcr(body_code, ' FND_MSG_PUB.Add_Exc_Msg( '''||g_package_name||''' ,''get_winning_rule'');');
487: cn_utils.appindcr(body_code, ' END IF; ');

Line 491: cn_utils.appindcr(body_code, ' p_encoded => FND_API.G_FALSE ');

487: cn_utils.appindcr(body_code, ' END IF; ');
488: cn_utils.appindcr(body_code, ' FND_MSG_PUB.Count_And_Get ');
489: cn_utils.appindcr(body_code, ' (p_count => x_msg_count , ');
490: cn_utils.appindcr(body_code, ' p_data => x_msg_data , ');
491: cn_utils.appindcr(body_code, ' p_encoded => FND_API.G_FALSE ');
492: cn_utils.appindcr(body_code, ' ); ');
493: cn_utils.appindcr(body_code, 'cn_message_pkg.debug(''EXCEPTION IN get_winning_rule, '' || sqlerrm);');
494: cn_utils.proc_end( procedure_name, 'N', body_code );
495:

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

545: END;
546:
547: PROCEDURE gen_sca_rules_onln_dyn
548: ( p_api_version IN NUMBER,
549: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
550: p_commit IN VARCHAR2 := FND_API.G_FALSE,
551: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
552: p_org_id IN NUMBER,
553: x_return_status OUT NOCOPY VARCHAR2,

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

546:
547: PROCEDURE gen_sca_rules_onln_dyn
548: ( p_api_version IN NUMBER,
549: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
550: p_commit IN VARCHAR2 := FND_API.G_FALSE,
551: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
552: p_org_id IN NUMBER,
553: x_return_status OUT NOCOPY VARCHAR2,
554: x_msg_count OUT NOCOPY NUMBER,

Line 551: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

547: PROCEDURE gen_sca_rules_onln_dyn
548: ( p_api_version IN NUMBER,
549: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
550: p_commit IN VARCHAR2 := FND_API.G_FALSE,
551: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
552: p_org_id IN NUMBER,
553: x_return_status OUT NOCOPY VARCHAR2,
554: x_msg_count OUT NOCOPY NUMBER,
555: x_msg_data OUT NOCOPY VARCHAR2,

Line 583: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

579: l_org_id NUMBER;
580:
581: BEGIN
582: -- Standard call to check for call compatibility.
583: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
584: p_api_version ,
585: l_api_name ,
586: G_PKG_NAME )
587: THEN

Line 588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

584: p_api_version ,
585: l_api_name ,
586: G_PKG_NAME )
587: THEN
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: END IF;
590:
591: -- Initialize message list if p_init_msg_list is set to TRUE.
592: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 592: IF FND_API.to_Boolean( p_init_msg_list ) THEN

588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: END IF;
590:
591: -- Initialize message list if p_init_msg_list is set to TRUE.
592: IF FND_API.to_Boolean( p_init_msg_list ) THEN
593: FND_MSG_PUB.initialize;
594: END IF;
595:
596: -- Initialize API return status to success

Line 597: x_return_status := FND_API.G_RET_STS_SUCCESS;

593: FND_MSG_PUB.initialize;
594: END IF;
595:
596: -- Initialize API return status to success
597: x_return_status := FND_API.G_RET_STS_SUCCESS;
598:
599: -- Codes start here
600:
601: g_org_id := p_org_id;

Line 672: x_return_status := FND_API.g_ret_sts_error;

668:
669: IF l_error_count = 0 THEN
670: NULL;
671: ELSE
672: x_return_status := FND_API.g_ret_sts_error;
673:
674: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
675: THEN
676: fnd_message.set_name('CN', 'CN_DYN_PKG_COMPILE_ERR');

Line 681: p_encoded => FND_API.G_FALSE

677: FND_MSG_PUB.ADD;
678: FND_MSG_PUB.Count_And_Get
679: (p_count => x_msg_count ,
680: p_data => x_msg_data ,
681: p_encoded => FND_API.G_FALSE
682: );
683:
684: END IF;
685: END IF;

Line 687: x_return_status := FND_API.g_ret_sts_error;

683:
684: END IF;
685: END IF;
686: ELSE
687: x_return_status := FND_API.g_ret_sts_error;
688:
689: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
690: THEN
691: fnd_message.set_name('CN', 'CN_DYN_PKG_COMPILE_ERR');

Line 696: p_encoded => FND_API.G_FALSE

692: FND_MSG_PUB.ADD;
693: FND_MSG_PUB.Count_And_Get
694: (p_count => x_msg_count ,
695: p_data => x_msg_data ,
696: p_encoded => FND_API.G_FALSE
697: );
698: END IF;
699: END IF;
700:

Line 701: IF FND_API.To_Boolean( p_commit ) THEN

697: );
698: END IF;
699: END IF;
700:
701: IF FND_API.To_Boolean( p_commit ) THEN
702: COMMIT WORK;
703: END IF;
704:
705: EXCEPTION

Line 706: WHEN FND_API.G_EXC_ERROR THEN

702: COMMIT WORK;
703: END IF;
704:
705: EXCEPTION
706: WHEN FND_API.G_EXC_ERROR THEN
707:
708: x_return_status := FND_API.G_RET_STS_ERROR ;
709: FND_MSG_PUB.Count_And_Get
710: (p_count => x_msg_count ,

Line 708: x_return_status := FND_API.G_RET_STS_ERROR ;

704:
705: EXCEPTION
706: WHEN FND_API.G_EXC_ERROR THEN
707:
708: x_return_status := FND_API.G_RET_STS_ERROR ;
709: FND_MSG_PUB.Count_And_Get
710: (p_count => x_msg_count ,
711: p_data => x_msg_data ,
712: p_encoded => FND_API.G_FALSE

Line 712: p_encoded => FND_API.G_FALSE

708: x_return_status := FND_API.G_RET_STS_ERROR ;
709: FND_MSG_PUB.Count_And_Get
710: (p_count => x_msg_count ,
711: p_data => x_msg_data ,
712: p_encoded => FND_API.G_FALSE
713: );
714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
716: FND_MSG_PUB.Count_And_Get

Line 714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

710: (p_count => x_msg_count ,
711: p_data => x_msg_data ,
712: p_encoded => FND_API.G_FALSE
713: );
714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
716: FND_MSG_PUB.Count_And_Get
717: (p_count => x_msg_count ,
718: p_data => x_msg_data ,

Line 715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

711: p_data => x_msg_data ,
712: p_encoded => FND_API.G_FALSE
713: );
714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
716: FND_MSG_PUB.Count_And_Get
717: (p_count => x_msg_count ,
718: p_data => x_msg_data ,
719: p_encoded => FND_API.G_FALSE

Line 719: p_encoded => FND_API.G_FALSE

715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
716: FND_MSG_PUB.Count_And_Get
717: (p_count => x_msg_count ,
718: p_data => x_msg_data ,
719: p_encoded => FND_API.G_FALSE
720: );
721: WHEN OTHERS THEN
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
723: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

718: p_data => x_msg_data ,
719: p_encoded => FND_API.G_FALSE
720: );
721: WHEN OTHERS THEN
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
723: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
724: THEN
725: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
726: END IF;

Line 730: p_encoded => FND_API.G_FALSE

726: END IF;
727: FND_MSG_PUB.Count_And_Get
728: (p_count => x_msg_count ,
729: p_data => x_msg_data ,
730: p_encoded => FND_API.G_FALSE
731: );
732:
733: END gen_sca_rules_onln_dyn;
734: END cn_sca_rules_online_gen_pvt;