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.AMS_EVTREGS_PVT dependencies on FND_PROFILE

Line 89: l_code_prefix VARCHAR2(50) := FND_PROFILE.Value('AMS_CONF_CODE_PREFIX');

85: l_event_registration_id NUMBER := l_evt_regs_Rec.EVENT_REGISTRATION_ID;
86: l_confirmation_code VARCHAR2(30) := l_evt_regs_rec.confirmation_code;
87: l_waitlisted_priority NUMBER := NULL;
88: l_confirmation_id NUMBER;
89: l_code_prefix VARCHAR2(50) := FND_PROFILE.Value('AMS_CONF_CODE_PREFIX');
90: /*dbiswas Mar 13, 2003 */
91: l_date_reg_placed DATE := l_evt_regs_rec.DATE_REGISTRATION_PLACED;
92:
93: /* Following code is modified by ptendulk to move to 1:1 ffm

Line 444: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')

440: , p_party_id => l_evt_regs_rec.ATTENDANT_CONTACT_ID
441: );
442:
443: -- Fulfillment
444: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
445: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
446: )
447: THEN
448: IF (AMS_DEBUG_HIGH_ON) THEN

Line 498: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')

494: END IF;
495: ELSIF (l_system_status_code = 'WAITLISTED')
496: THEN
497: -- Fulfillment
498: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
499: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
500: )
501: THEN
502: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1934: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')

1930: l_bind_names(1) := 'REGISTRATION_ID' ;
1931: l_bind_values(1) := TO_CHAR(l_evt_regs_Rec.event_registration_id);
1932:
1933:
1934: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
1935: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
1936: )
1937: THEN
1938: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER

Line 2328: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')

2324:
2325: l_bind_names(1) := 'REGISTRATION_ID' ;
2326: l_bind_values(1):= TO_CHAR(l_event_registration_id) ;
2327:
2328: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
2329: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
2330: )
2331: THEN
2332:

Line 2435: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')

2431: l_bind_values(1) := to_char(l_event_registration_id); */
2432: l_bind_names(1) := 'REGISTRATION_ID' ;
2433: l_bind_values(1) := TO_CHAR(l_event_registration_id);
2434:
2435: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
2436: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
2437: )
2438: THEN
2439: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER

Line 2585: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')

2581: l_bind_values(1) := to_char(l_event_registration_id); */
2582: l_bind_names(1) := 'REGISTRATION_ID' ;
2583: l_bind_values(1) := TO_CHAR(l_event_registration_id);
2584:
2585: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
2586: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
2587: )
2588: THEN
2589: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER

Line 2699: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')

2695: l_bind_values(1) := to_char(l_event_registration_id); */
2696: l_bind_names(1) := 'REGISTRATION_ID' ;
2697: l_bind_values(1) := TO_CHAR(l_event_registration_id);
2698:
2699: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
2700: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
2701: )
2702: THEN
2703: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER

Line 3380: IF (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')

3376: l_bind_names(1) := 'REGISTRATION_ID' ;
3377: l_bind_values(1) := TO_CHAR(l_min_wait_reg_id);
3378:
3379:
3380: IF (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
3381: THEN
3382: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
3383: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
3384: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false