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.

[Home] [Help]

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 1949: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')

1945: l_bind_names(1) := 'REGISTRATION_ID' ;
1946: l_bind_values(1) := TO_CHAR(l_evt_regs_Rec.event_registration_id);
1947:
1948:
1949: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
1950: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
1951: )
1952: THEN
1953: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER

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

2339:
2340: l_bind_names(1) := 'REGISTRATION_ID' ;
2341: l_bind_values(1):= TO_CHAR(l_event_registration_id) ;
2342:
2343: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
2344: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
2345: )
2346: THEN
2347:

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

2446: l_bind_values(1) := to_char(l_event_registration_id); */
2447: l_bind_names(1) := 'REGISTRATION_ID' ;
2448: l_bind_values(1) := TO_CHAR(l_event_registration_id);
2449:
2450: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
2451: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
2452: )
2453: THEN
2454: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER

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

2596: l_bind_values(1) := to_char(l_event_registration_id); */
2597: l_bind_names(1) := 'REGISTRATION_ID' ;
2598: l_bind_values(1) := TO_CHAR(l_event_registration_id);
2599:
2600: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
2601: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
2602: )
2603: THEN
2604: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER

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

2710: l_bind_values(1) := to_char(l_event_registration_id); */
2711: l_bind_names(1) := 'REGISTRATION_ID' ;
2712: l_bind_values(1) := TO_CHAR(l_event_registration_id);
2713:
2714: IF ( (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
2715: AND (nvl(p_block_fulfillment, FND_API.G_FALSE) <> FND_API.G_TRUE)
2716: )
2717: THEN
2718: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER

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

3391: l_bind_names(1) := 'REGISTRATION_ID' ;
3392: l_bind_values(1) := TO_CHAR(l_min_wait_reg_id);
3393:
3394:
3395: IF (nvl(FND_PROFILE.value('AMS_FULFILL_ENABLE_FLAG'), 'N') = 'Y')
3396: THEN
3397: AMS_CT_RULE_PVT.check_content_rule( p_api_version => 1.0 -- IN NUMBER
3398: , p_init_msg_list => FND_API.g_false -- IN VARCHAR2 := FND_API.g_false
3399: , p_commit => FND_API.g_false-- IN VARCHAR2 := FND_API.g_false