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

Line 61: IF(fnd_profile.value('IGR_AMS_DEFAULT_CAT') IS NULL OR fnd_profile.value('IGR_AMS_DEFAULT_SUBCAT') IS NULL

57: app_exception.raise_exception;
58: END IF;
59: -- The following code would ensure the profiles IGS: AMS Categeory, IGS: AMS Category Sub Type
60: -- are IGS: JTF Resource are set before the user tries to insert a new record.
61: IF(fnd_profile.value('IGR_AMS_DEFAULT_CAT') IS NULL OR fnd_profile.value('IGR_AMS_DEFAULT_SUBCAT') IS NULL
62: OR fnd_profile.value('IGR_JTF_DEFAULT_RESOURCE') IS NULL)THEN
63: fnd_message.set_name('IGS','IGR_NO_DEF_PROF');
64: igs_ge_msg_stack.add;
65: app_exception.raise_exception;

Line 62: OR fnd_profile.value('IGR_JTF_DEFAULT_RESOURCE') IS NULL)THEN

58: END IF;
59: -- The following code would ensure the profiles IGS: AMS Categeory, IGS: AMS Category Sub Type
60: -- are IGS: JTF Resource are set before the user tries to insert a new record.
61: IF(fnd_profile.value('IGR_AMS_DEFAULT_CAT') IS NULL OR fnd_profile.value('IGR_AMS_DEFAULT_SUBCAT') IS NULL
62: OR fnd_profile.value('IGR_JTF_DEFAULT_RESOURCE') IS NULL)THEN
63: fnd_message.set_name('IGS','IGR_NO_DEF_PROF');
64: igs_ge_msg_stack.add;
65: app_exception.raise_exception;
66: END IF;

Line 79: l_deliv_rec.country_id := fnd_profile.value('AMS_SRCGEN_USER_CITY'); -- This is the profile Value of 'AMS: User Country'

75: ELSE
76: CLOSE c;
77: END IF;
78: -- This is being hard coded according to Marketing Implementation Guide.
79: l_deliv_rec.country_id := fnd_profile.value('AMS_SRCGEN_USER_CITY'); -- This is the profile Value of 'AMS: User Country'
80: l_deliv_rec.setup_id := 6001;
81: -- the following are defaulted. wonder y we cant say that the following are hard-coded.
82: l_deliv_rec.language_code := 'US';
83: l_deliv_rec.currency_code := nvl(fnd_profile.value('AMS_DEFAULT_CURR_CODE'),'USD');

Line 83: l_deliv_rec.currency_code := nvl(fnd_profile.value('AMS_DEFAULT_CURR_CODE'),'USD');

79: l_deliv_rec.country_id := fnd_profile.value('AMS_SRCGEN_USER_CITY'); -- This is the profile Value of 'AMS: User Country'
80: l_deliv_rec.setup_id := 6001;
81: -- the following are defaulted. wonder y we cant say that the following are hard-coded.
82: l_deliv_rec.language_code := 'US';
83: l_deliv_rec.currency_code := nvl(fnd_profile.value('AMS_DEFAULT_CURR_CODE'),'USD');
84: l_deliv_rec.owner_user_id := fnd_profile.value('IGR_JTF_DEFAULT_RESOURCE');
85: l_deliv_rec.active_flag := 'Y';
86: l_deliv_rec.private_flag := 'N';
87: l_deliv_rec.application_id := 530;

Line 84: l_deliv_rec.owner_user_id := fnd_profile.value('IGR_JTF_DEFAULT_RESOURCE');

80: l_deliv_rec.setup_id := 6001;
81: -- the following are defaulted. wonder y we cant say that the following are hard-coded.
82: l_deliv_rec.language_code := 'US';
83: l_deliv_rec.currency_code := nvl(fnd_profile.value('AMS_DEFAULT_CURR_CODE'),'USD');
84: l_deliv_rec.owner_user_id := fnd_profile.value('IGR_JTF_DEFAULT_RESOURCE');
85: l_deliv_rec.active_flag := 'Y';
86: l_deliv_rec.private_flag := 'N';
87: l_deliv_rec.application_id := 530;
88: l_deliv_rec.category_type_id := fnd_profile.value('IGR_AMS_DEFAULT_CAT');

Line 88: l_deliv_rec.category_type_id := fnd_profile.value('IGR_AMS_DEFAULT_CAT');

84: l_deliv_rec.owner_user_id := fnd_profile.value('IGR_JTF_DEFAULT_RESOURCE');
85: l_deliv_rec.active_flag := 'Y';
86: l_deliv_rec.private_flag := 'N';
87: l_deliv_rec.application_id := 530;
88: l_deliv_rec.category_type_id := fnd_profile.value('IGR_AMS_DEFAULT_CAT');
89: l_deliv_rec.category_sub_type_id := fnd_profile.value('IGR_AMS_DEFAULT_SUBCAT');
90: l_deliv_rec.version := 1;
91:
92: l_deliv_rec.can_fulfill_physical_flag := 'Y'; --3036190

Line 89: l_deliv_rec.category_sub_type_id := fnd_profile.value('IGR_AMS_DEFAULT_SUBCAT');

85: l_deliv_rec.active_flag := 'Y';
86: l_deliv_rec.private_flag := 'N';
87: l_deliv_rec.application_id := 530;
88: l_deliv_rec.category_type_id := fnd_profile.value('IGR_AMS_DEFAULT_CAT');
89: l_deliv_rec.category_sub_type_id := fnd_profile.value('IGR_AMS_DEFAULT_SUBCAT');
90: l_deliv_rec.version := 1;
91:
92: l_deliv_rec.can_fulfill_physical_flag := 'Y'; --3036190
93: l_deliv_rec.deliverable_name := x_package_item;

Line 100: l_deliv_rec.last_updated_by := fnd_profile.value('user_id');

96: l_deliv_rec.object_version_number := x_object_version_number;
97: l_deliv_rec.description := x_description;
98: l_deliv_rec.kit_flag := nvl(x_kit_flag,'N');
99: l_deliv_rec.last_update_date := sysdate;
100: l_deliv_rec.last_updated_by := fnd_profile.value('user_id');
101: l_deliv_rec.creation_date := sysdate;
102: l_deliv_rec.created_by := fnd_profile.value('user_id');
103: l_deliv_rec.last_update_login := fnd_profile.value('user_id');
104: l_deliv_rec.forecasted_complete_date := x_actual_avail_from_date;

Line 102: l_deliv_rec.created_by := fnd_profile.value('user_id');

98: l_deliv_rec.kit_flag := nvl(x_kit_flag,'N');
99: l_deliv_rec.last_update_date := sysdate;
100: l_deliv_rec.last_updated_by := fnd_profile.value('user_id');
101: l_deliv_rec.creation_date := sysdate;
102: l_deliv_rec.created_by := fnd_profile.value('user_id');
103: l_deliv_rec.last_update_login := fnd_profile.value('user_id');
104: l_deliv_rec.forecasted_complete_date := x_actual_avail_from_date;
105:
106: AMS_DELIVERABLE_PUB.CREATE_DELIVERABLE (

Line 103: l_deliv_rec.last_update_login := fnd_profile.value('user_id');

99: l_deliv_rec.last_update_date := sysdate;
100: l_deliv_rec.last_updated_by := fnd_profile.value('user_id');
101: l_deliv_rec.creation_date := sysdate;
102: l_deliv_rec.created_by := fnd_profile.value('user_id');
103: l_deliv_rec.last_update_login := fnd_profile.value('user_id');
104: l_deliv_rec.forecasted_complete_date := x_actual_avail_from_date;
105:
106: AMS_DELIVERABLE_PUB.CREATE_DELIVERABLE (
107: P_API_VERSION_NUMBER => 1.0,