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.EDR_UTILITIES dependencies on FND_MESSAGE

Line 78: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CHECK_SETUP');

74: MULTIPLE_ERES_SUBSCRIPTIONS EXCEPTION;
75: BEGIN
76: /* Check if Profile option is Defined or Not */
77:
78: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CHECK_SETUP');
79: fnd_message.set_token('EVENT', p_Event);
80: fnd_file.put_line(fnd_file.output, fnd_message.get);
81: fnd_file.new_line(fnd_file.output, 2);
82:

Line 79: fnd_message.set_token('EVENT', p_Event);

75: BEGIN
76: /* Check if Profile option is Defined or Not */
77:
78: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CHECK_SETUP');
79: fnd_message.set_token('EVENT', p_Event);
80: fnd_file.put_line(fnd_file.output, fnd_message.get);
81: fnd_file.new_line(fnd_file.output, 2);
82:
83: if (fnd_profile.defined('EDR_ERES_ENABLED')) THEN

Line 80: fnd_file.put_line(fnd_file.output, fnd_message.get);

76: /* Check if Profile option is Defined or Not */
77:
78: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CHECK_SETUP');
79: fnd_message.set_token('EVENT', p_Event);
80: fnd_file.put_line(fnd_file.output, fnd_message.get);
81: fnd_file.new_line(fnd_file.output, 2);
82:
83: if (fnd_profile.defined('EDR_ERES_ENABLED')) THEN
84: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_Y') );

Line 84: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_Y') );

80: fnd_file.put_line(fnd_file.output, fnd_message.get);
81: fnd_file.new_line(fnd_file.output, 2);
82:
83: if (fnd_profile.defined('EDR_ERES_ENABLED')) THEN
84: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_Y') );
85: else
86: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_N') );
87: end if;
88:

Line 86: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_N') );

82:
83: if (fnd_profile.defined('EDR_ERES_ENABLED')) THEN
84: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_Y') );
85: else
86: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_N') );
87: end if;
88:
89: fnd_file.new_line(fnd_file.output, 1);
90: if (fnd_timezones.GET_SERVER_TIMEZONE_CODE IS NULL) THEN

Line 91: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_TIME_ZONE_N') );

87: end if;
88:
89: fnd_file.new_line(fnd_file.output, 1);
90: if (fnd_timezones.GET_SERVER_TIMEZONE_CODE IS NULL) THEN
91: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_TIME_ZONE_N') );
92: else
93: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_TIME_ZONE_Y');
94: fnd_message.set_token('TMZONE', fnd_timezones.GET_SERVER_TIMEZONE_CODE);
95: fnd_file.put_line(fnd_file.output, fnd_message.get);

Line 93: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_TIME_ZONE_Y');

89: fnd_file.new_line(fnd_file.output, 1);
90: if (fnd_timezones.GET_SERVER_TIMEZONE_CODE IS NULL) THEN
91: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_TIME_ZONE_N') );
92: else
93: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_TIME_ZONE_Y');
94: fnd_message.set_token('TMZONE', fnd_timezones.GET_SERVER_TIMEZONE_CODE);
95: fnd_file.put_line(fnd_file.output, fnd_message.get);
96: end if;
97:

Line 94: fnd_message.set_token('TMZONE', fnd_timezones.GET_SERVER_TIMEZONE_CODE);

90: if (fnd_timezones.GET_SERVER_TIMEZONE_CODE IS NULL) THEN
91: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_TIME_ZONE_N') );
92: else
93: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_TIME_ZONE_Y');
94: fnd_message.set_token('TMZONE', fnd_timezones.GET_SERVER_TIMEZONE_CODE);
95: fnd_file.put_line(fnd_file.output, fnd_message.get);
96: end if;
97:
98: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_V');

Line 95: fnd_file.put_line(fnd_file.output, fnd_message.get);

91: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_TIME_ZONE_N') );
92: else
93: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_TIME_ZONE_Y');
94: fnd_message.set_token('TMZONE', fnd_timezones.GET_SERVER_TIMEZONE_CODE);
95: fnd_file.put_line(fnd_file.output, fnd_message.get);
96: end if;
97:
98: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_V');
99: fnd_message.set_token( 'ERESPROFILE', fnd_profile.value('EDR_ERES_ENABLED'));

Line 98: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_V');

94: fnd_message.set_token('TMZONE', fnd_timezones.GET_SERVER_TIMEZONE_CODE);
95: fnd_file.put_line(fnd_file.output, fnd_message.get);
96: end if;
97:
98: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_V');
99: fnd_message.set_token( 'ERESPROFILE', fnd_profile.value('EDR_ERES_ENABLED'));
100: fnd_file.put_line(fnd_file.output, fnd_message.get);
101: fnd_file.new_line(fnd_file.output, 1);
102:

Line 99: fnd_message.set_token( 'ERESPROFILE', fnd_profile.value('EDR_ERES_ENABLED'));

95: fnd_file.put_line(fnd_file.output, fnd_message.get);
96: end if;
97:
98: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_V');
99: fnd_message.set_token( 'ERESPROFILE', fnd_profile.value('EDR_ERES_ENABLED'));
100: fnd_file.put_line(fnd_file.output, fnd_message.get);
101: fnd_file.new_line(fnd_file.output, 1);
102:
103:

Line 100: fnd_file.put_line(fnd_file.output, fnd_message.get);

96: end if;
97:
98: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_ERES_PROFILE_V');
99: fnd_message.set_token( 'ERESPROFILE', fnd_profile.value('EDR_ERES_ENABLED'));
100: fnd_file.put_line(fnd_file.output, fnd_message.get);
101: fnd_file.new_line(fnd_file.output, 1);
102:
103:
104: /*check if event and subscritptions are Enabled */

Line 141: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_STATUS');

137: OPEN GET_EVT_SUBSCRIPTION_DETAILS;
138: LOOP
139: FETCH GET_EVT_SUBSCRIPTION_DETAILS INTO l_sub_guid,l_Event_status,l_sub_status;
140: EXIT WHEN GET_EVT_SUBSCRIPTION_DETAILS%NOTFOUND;
141: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_STATUS');
142: fnd_message.set_token( 'EVENT', p_event);
143: fnd_message.set_token( 'STATUS', l_event_status);
144: fnd_file.put_line(fnd_file.output, fnd_message.get);
145:

Line 142: fnd_message.set_token( 'EVENT', p_event);

138: LOOP
139: FETCH GET_EVT_SUBSCRIPTION_DETAILS INTO l_sub_guid,l_Event_status,l_sub_status;
140: EXIT WHEN GET_EVT_SUBSCRIPTION_DETAILS%NOTFOUND;
141: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_STATUS');
142: fnd_message.set_token( 'EVENT', p_event);
143: fnd_message.set_token( 'STATUS', l_event_status);
144: fnd_file.put_line(fnd_file.output, fnd_message.get);
145:
146: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_SUBSCRIBE_STATUS');

Line 143: fnd_message.set_token( 'STATUS', l_event_status);

139: FETCH GET_EVT_SUBSCRIPTION_DETAILS INTO l_sub_guid,l_Event_status,l_sub_status;
140: EXIT WHEN GET_EVT_SUBSCRIPTION_DETAILS%NOTFOUND;
141: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_STATUS');
142: fnd_message.set_token( 'EVENT', p_event);
143: fnd_message.set_token( 'STATUS', l_event_status);
144: fnd_file.put_line(fnd_file.output, fnd_message.get);
145:
146: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_SUBSCRIBE_STATUS');
147: fnd_message.set_token( 'EVENT', p_event);

Line 144: fnd_file.put_line(fnd_file.output, fnd_message.get);

140: EXIT WHEN GET_EVT_SUBSCRIPTION_DETAILS%NOTFOUND;
141: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_STATUS');
142: fnd_message.set_token( 'EVENT', p_event);
143: fnd_message.set_token( 'STATUS', l_event_status);
144: fnd_file.put_line(fnd_file.output, fnd_message.get);
145:
146: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_SUBSCRIBE_STATUS');
147: fnd_message.set_token( 'EVENT', p_event);
148: fnd_message.set_token( 'STATUS', l_sub_status);

Line 146: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_SUBSCRIBE_STATUS');

142: fnd_message.set_token( 'EVENT', p_event);
143: fnd_message.set_token( 'STATUS', l_event_status);
144: fnd_file.put_line(fnd_file.output, fnd_message.get);
145:
146: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_SUBSCRIBE_STATUS');
147: fnd_message.set_token( 'EVENT', p_event);
148: fnd_message.set_token( 'STATUS', l_sub_status);
149: fnd_file.put_line(fnd_file.output, fnd_message.get);
150: END LOOP;

Line 147: fnd_message.set_token( 'EVENT', p_event);

143: fnd_message.set_token( 'STATUS', l_event_status);
144: fnd_file.put_line(fnd_file.output, fnd_message.get);
145:
146: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_SUBSCRIBE_STATUS');
147: fnd_message.set_token( 'EVENT', p_event);
148: fnd_message.set_token( 'STATUS', l_sub_status);
149: fnd_file.put_line(fnd_file.output, fnd_message.get);
150: END LOOP;
151: CLOSE GET_EVT_SUBSCRIPTION_DETAILS;

Line 148: fnd_message.set_token( 'STATUS', l_sub_status);

144: fnd_file.put_line(fnd_file.output, fnd_message.get);
145:
146: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_SUBSCRIBE_STATUS');
147: fnd_message.set_token( 'EVENT', p_event);
148: fnd_message.set_token( 'STATUS', l_sub_status);
149: fnd_file.put_line(fnd_file.output, fnd_message.get);
150: END LOOP;
151: CLOSE GET_EVT_SUBSCRIPTION_DETAILS;
152: END IF;

Line 149: fnd_file.put_line(fnd_file.output, fnd_message.get);

145:
146: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_SUBSCRIBE_STATUS');
147: fnd_message.set_token( 'EVENT', p_event);
148: fnd_message.set_token( 'STATUS', l_sub_status);
149: fnd_file.put_line(fnd_file.output, fnd_message.get);
150: END LOOP;
151: CLOSE GET_EVT_SUBSCRIPTION_DETAILS;
152: END IF;
153: END IF;

Line 159: FND_MESSAGE.SET_NAME('EDR','EDR_MULTI_ERES_SUBSCRP_ERR');

155: -- End Bug Fix 3078516
156: --
157: EXCEPTION
158: WHEN MULTIPLE_ERES_SUBSCRIPTIONS THEN
159: FND_MESSAGE.SET_NAME('EDR','EDR_MULTI_ERES_SUBSCRP_ERR');
160: fnd_message.set_token( 'EVENT', p_event);
161: fnd_file.put_line(fnd_file.output, fnd_message.get);
162: RETURN;
163: WHEN NO_DATA_FOUND THEN

Line 160: fnd_message.set_token( 'EVENT', p_event);

156: --
157: EXCEPTION
158: WHEN MULTIPLE_ERES_SUBSCRIPTIONS THEN
159: FND_MESSAGE.SET_NAME('EDR','EDR_MULTI_ERES_SUBSCRP_ERR');
160: fnd_message.set_token( 'EVENT', p_event);
161: fnd_file.put_line(fnd_file.output, fnd_message.get);
162: RETURN;
163: WHEN NO_DATA_FOUND THEN
164: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENTSUB_NOEXIST');

Line 161: fnd_file.put_line(fnd_file.output, fnd_message.get);

157: EXCEPTION
158: WHEN MULTIPLE_ERES_SUBSCRIPTIONS THEN
159: FND_MESSAGE.SET_NAME('EDR','EDR_MULTI_ERES_SUBSCRP_ERR');
160: fnd_message.set_token( 'EVENT', p_event);
161: fnd_file.put_line(fnd_file.output, fnd_message.get);
162: RETURN;
163: WHEN NO_DATA_FOUND THEN
164: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENTSUB_NOEXIST');
165: fnd_message.set_token( 'EVENT', p_event);

Line 164: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENTSUB_NOEXIST');

160: fnd_message.set_token( 'EVENT', p_event);
161: fnd_file.put_line(fnd_file.output, fnd_message.get);
162: RETURN;
163: WHEN NO_DATA_FOUND THEN
164: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENTSUB_NOEXIST');
165: fnd_message.set_token( 'EVENT', p_event);
166: fnd_file.put_line(fnd_file.output, fnd_message.get);
167: RETURN;
168: END;

Line 165: fnd_message.set_token( 'EVENT', p_event);

161: fnd_file.put_line(fnd_file.output, fnd_message.get);
162: RETURN;
163: WHEN NO_DATA_FOUND THEN
164: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENTSUB_NOEXIST');
165: fnd_message.set_token( 'EVENT', p_event);
166: fnd_file.put_line(fnd_file.output, fnd_message.get);
167: RETURN;
168: END;
169:

Line 166: fnd_file.put_line(fnd_file.output, fnd_message.get);

162: RETURN;
163: WHEN NO_DATA_FOUND THEN
164: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENTSUB_NOEXIST');
165: fnd_message.set_token( 'EVENT', p_event);
166: fnd_file.put_line(fnd_file.output, fnd_message.get);
167: RETURN;
168: END;
169:
170: /*check if any AMe stuff is available */

Line 186: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_AME_TRANS_TYPE');

182:
183: l_ame_transaction_type := NVL(EDR_INDEXED_XML_UTIL.GET_WF_PARAMS('EDR_AME_TRANSACTION_TYPE', l_sub_guid), evt.getEventName( ) );
184: -- Bug 5639849 : Ends
185:
186: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_AME_TRANS_TYPE');
187: fnd_message.set_token( 'TRANSTYPE', l_ame_transaction_type);
188: fnd_file.put_line(fnd_file.output, fnd_message.get);
189:
190:

Line 187: fnd_message.set_token( 'TRANSTYPE', l_ame_transaction_type);

183: l_ame_transaction_type := NVL(EDR_INDEXED_XML_UTIL.GET_WF_PARAMS('EDR_AME_TRANSACTION_TYPE', l_sub_guid), evt.getEventName( ) );
184: -- Bug 5639849 : Ends
185:
186: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_AME_TRANS_TYPE');
187: fnd_message.set_token( 'TRANSTYPE', l_ame_transaction_type);
188: fnd_file.put_line(fnd_file.output, fnd_message.get);
189:
190:
191: /* AME Processing, Select APPLICATION_ID of the Event. */

Line 188: fnd_file.put_line(fnd_file.output, fnd_message.get);

184: -- Bug 5639849 : Ends
185:
186: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_AME_TRANS_TYPE');
187: fnd_message.set_token( 'TRANSTYPE', l_ame_transaction_type);
188: fnd_file.put_line(fnd_file.output, fnd_message.get);
189:
190:
191: /* AME Processing, Select APPLICATION_ID of the Event. */
192: /* Required by AME. Assumption made here is OWNER_TAG will always be set to application Short Name*/

Line 199: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_APP_CODE');

195: FROM FND_APPLICATION
196: WHERE APPLICATION_SHORT_NAME in
197: (SELECT OWNER_TAG from WF_EVENTS WHERE NAME=evt.getEventName( ));
198:
199: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_APP_CODE');
200: fnd_message.set_token( 'APPCODE', l_application_code);
201: fnd_file.put_line(fnd_file.output, fnd_message.get);
202: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_APP_ID');
203: fnd_message.set_token( 'APPID', l_application_id);

Line 200: fnd_message.set_token( 'APPCODE', l_application_code);

196: WHERE APPLICATION_SHORT_NAME in
197: (SELECT OWNER_TAG from WF_EVENTS WHERE NAME=evt.getEventName( ));
198:
199: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_APP_CODE');
200: fnd_message.set_token( 'APPCODE', l_application_code);
201: fnd_file.put_line(fnd_file.output, fnd_message.get);
202: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_APP_ID');
203: fnd_message.set_token( 'APPID', l_application_id);
204: fnd_file.put_line(fnd_file.output, fnd_message.get);

Line 201: fnd_file.put_line(fnd_file.output, fnd_message.get);

197: (SELECT OWNER_TAG from WF_EVENTS WHERE NAME=evt.getEventName( ));
198:
199: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_APP_CODE');
200: fnd_message.set_token( 'APPCODE', l_application_code);
201: fnd_file.put_line(fnd_file.output, fnd_message.get);
202: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_APP_ID');
203: fnd_message.set_token( 'APPID', l_application_id);
204: fnd_file.put_line(fnd_file.output, fnd_message.get);
205:

Line 202: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_APP_ID');

198:
199: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_APP_CODE');
200: fnd_message.set_token( 'APPCODE', l_application_code);
201: fnd_file.put_line(fnd_file.output, fnd_message.get);
202: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_APP_ID');
203: fnd_message.set_token( 'APPID', l_application_id);
204: fnd_file.put_line(fnd_file.output, fnd_message.get);
205:
206: EXCEPTION

Line 203: fnd_message.set_token( 'APPID', l_application_id);

199: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_APP_CODE');
200: fnd_message.set_token( 'APPCODE', l_application_code);
201: fnd_file.put_line(fnd_file.output, fnd_message.get);
202: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_APP_ID');
203: fnd_message.set_token( 'APPID', l_application_id);
204: fnd_file.put_line(fnd_file.output, fnd_message.get);
205:
206: EXCEPTION
207: WHEN NO_DATA_FOUND THEN

Line 204: fnd_file.put_line(fnd_file.output, fnd_message.get);

200: fnd_message.set_token( 'APPCODE', l_application_code);
201: fnd_file.put_line(fnd_file.output, fnd_message.get);
202: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_APP_ID');
203: fnd_message.set_token( 'APPID', l_application_id);
204: fnd_file.put_line(fnd_file.output, fnd_message.get);
205:
206: EXCEPTION
207: WHEN NO_DATA_FOUND THEN
208: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_EVENT_APP_ID_NO') );

Line 208: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_EVENT_APP_ID_NO') );

204: fnd_file.put_line(fnd_file.output, fnd_message.get);
205:
206: EXCEPTION
207: WHEN NO_DATA_FOUND THEN
208: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_EVENT_APP_ID_NO') );
209: END;
210:
211: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_AME_RULE_EVAL') );
212:

Line 211: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_AME_RULE_EVAL') );

207: WHEN NO_DATA_FOUND THEN
208: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_EVENT_APP_ID_NO') );
209: END;
210:
211: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_AME_RULE_EVAL') );
212:
213:
214: --Bug 2674799: start
215:

Line 227: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_AME_APPROVER_NUM');

223: );
224:
225: --Bug 2674799: end
226:
227: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_AME_APPROVER_NUM');
228: fnd_message.set_token( 'APPR_NUM', approverlist.count);
229: fnd_file.put_line(fnd_file.output, fnd_message.get);
230:
231: select application_name into l_application_name

Line 228: fnd_message.set_token( 'APPR_NUM', approverlist.count);

224:
225: --Bug 2674799: end
226:
227: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_AME_APPROVER_NUM');
228: fnd_message.set_token( 'APPR_NUM', approverlist.count);
229: fnd_file.put_line(fnd_file.output, fnd_message.get);
230:
231: select application_name into l_application_name
232: from ame_Calling_Apps

Line 229: fnd_file.put_line(fnd_file.output, fnd_message.get);

225: --Bug 2674799: end
226:
227: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_AME_APPROVER_NUM');
228: fnd_message.set_token( 'APPR_NUM', approverlist.count);
229: fnd_file.put_line(fnd_file.output, fnd_message.get);
230:
231: select application_name into l_application_name
232: from ame_Calling_Apps
233: where FND_APPLICATION_ID=l_application_id

Line 247: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_AME_APPROVER_SEQ');

243: --Bug 2674799: start
244: l_user := approverList(i).name;
245: --Bug 2674799: end
246:
247: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_AME_APPROVER_SEQ');
248: fnd_message.set_token( 'APPROVER', l_user);
249: fnd_message.set_token( 'APPR_SEQ', i);
250: fnd_file.put_line(fnd_file.output, fnd_message.get);
251:

Line 248: fnd_message.set_token( 'APPROVER', l_user);

244: l_user := approverList(i).name;
245: --Bug 2674799: end
246:
247: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_AME_APPROVER_SEQ');
248: fnd_message.set_token( 'APPROVER', l_user);
249: fnd_message.set_token( 'APPR_SEQ', i);
250: fnd_file.put_line(fnd_file.output, fnd_message.get);
251:
252: end loop;

Line 249: fnd_message.set_token( 'APPR_SEQ', i);

245: --Bug 2674799: end
246:
247: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_AME_APPROVER_SEQ');
248: fnd_message.set_token( 'APPROVER', l_user);
249: fnd_message.set_token( 'APPR_SEQ', i);
250: fnd_file.put_line(fnd_file.output, fnd_message.get);
251:
252: end loop;
253:

Line 250: fnd_file.put_line(fnd_file.output, fnd_message.get);

246:
247: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_AME_APPROVER_SEQ');
248: fnd_message.set_token( 'APPROVER', l_user);
249: fnd_message.set_token( 'APPR_SEQ', i);
250: fnd_file.put_line(fnd_file.output, fnd_message.get);
251:
252: end loop;
253:
254: for i in 1..l_ruleids.count loop

Line 255: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_AME_RULE_APPLY');

251:
252: end loop;
253:
254: for i in 1..l_ruleids.count loop
255: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_AME_RULE_APPLY');
256: fnd_message.set_token( 'RULEID', l_ruleids(i));
257: fnd_message.set_token( 'RULENAME', l_rulenames(i));
258: fnd_file.put_line(fnd_file.output, fnd_message.get);
259:

Line 256: fnd_message.set_token( 'RULEID', l_ruleids(i));

252: end loop;
253:
254: for i in 1..l_ruleids.count loop
255: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_AME_RULE_APPLY');
256: fnd_message.set_token( 'RULEID', l_ruleids(i));
257: fnd_message.set_token( 'RULENAME', l_rulenames(i));
258: fnd_file.put_line(fnd_file.output, fnd_message.get);
259:
260: -- Bug 3214495 : Start

Line 257: fnd_message.set_token( 'RULENAME', l_rulenames(i));

253:
254: for i in 1..l_ruleids.count loop
255: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_AME_RULE_APPLY');
256: fnd_message.set_token( 'RULEID', l_ruleids(i));
257: fnd_message.set_token( 'RULENAME', l_rulenames(i));
258: fnd_file.put_line(fnd_file.output, fnd_message.get);
259:
260: -- Bug 3214495 : Start
261:

Line 258: fnd_file.put_line(fnd_file.output, fnd_message.get);

254: for i in 1..l_ruleids.count loop
255: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_AME_RULE_APPLY');
256: fnd_message.set_token( 'RULEID', l_ruleids(i));
257: fnd_message.set_token( 'RULENAME', l_rulenames(i));
258: fnd_file.put_line(fnd_file.output, fnd_message.get);
259:
260: -- Bug 3214495 : Start
261:
262: EDR_STANDARD.GET_AMERULE_INPUT_VARIABLES( transactiontypeid =>NVL(l_ame_transaction_type,evt.getEventName( )),

Line 269: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_VAR_NUM');

265: ameruleinputvalues=>l_rulevalues);
266:
267: -- Bug 3214495 : End
268:
269: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_VAR_NUM');
270: fnd_message.set_token( 'NUM_INPUT', l_rulevalues.count);
271: fnd_file.put_line(fnd_file.output, fnd_message.get);
272: if l_rulevalues.count > 0 then
273: for i in 1..l_rulevalues.count loop

Line 270: fnd_message.set_token( 'NUM_INPUT', l_rulevalues.count);

266:
267: -- Bug 3214495 : End
268:
269: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_VAR_NUM');
270: fnd_message.set_token( 'NUM_INPUT', l_rulevalues.count);
271: fnd_file.put_line(fnd_file.output, fnd_message.get);
272: if l_rulevalues.count > 0 then
273: for i in 1..l_rulevalues.count loop
274: if l_rulevalues(i).input_name = 'ESIG_REQUIRED' then

Line 271: fnd_file.put_line(fnd_file.output, fnd_message.get);

267: -- Bug 3214495 : End
268:
269: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_VAR_NUM');
270: fnd_message.set_token( 'NUM_INPUT', l_rulevalues.count);
271: fnd_file.put_line(fnd_file.output, fnd_message.get);
272: if l_rulevalues.count > 0 then
273: for i in 1..l_rulevalues.count loop
274: if l_rulevalues(i).input_name = 'ESIG_REQUIRED' then
275: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_ESIG_REQ');

Line 275: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_ESIG_REQ');

271: fnd_file.put_line(fnd_file.output, fnd_message.get);
272: if l_rulevalues.count > 0 then
273: for i in 1..l_rulevalues.count loop
274: if l_rulevalues(i).input_name = 'ESIG_REQUIRED' then
275: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_ESIG_REQ');
276: fnd_message.set_token( 'VAR_ESIGREQ', l_rulevalues(i).input_value);
277: fnd_file.put_line(fnd_file.output, fnd_message.get);
278: elsif l_rulevalues(i).input_name = 'EREC_REQUIRED' then
279: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_REQ');

Line 276: fnd_message.set_token( 'VAR_ESIGREQ', l_rulevalues(i).input_value);

272: if l_rulevalues.count > 0 then
273: for i in 1..l_rulevalues.count loop
274: if l_rulevalues(i).input_name = 'ESIG_REQUIRED' then
275: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_ESIG_REQ');
276: fnd_message.set_token( 'VAR_ESIGREQ', l_rulevalues(i).input_value);
277: fnd_file.put_line(fnd_file.output, fnd_message.get);
278: elsif l_rulevalues(i).input_name = 'EREC_REQUIRED' then
279: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_REQ');
280: fnd_message.set_token( 'VAR_ERECREQ', l_rulevalues(i).input_value);

Line 277: fnd_file.put_line(fnd_file.output, fnd_message.get);

273: for i in 1..l_rulevalues.count loop
274: if l_rulevalues(i).input_name = 'ESIG_REQUIRED' then
275: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_ESIG_REQ');
276: fnd_message.set_token( 'VAR_ESIGREQ', l_rulevalues(i).input_value);
277: fnd_file.put_line(fnd_file.output, fnd_message.get);
278: elsif l_rulevalues(i).input_name = 'EREC_REQUIRED' then
279: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_REQ');
280: fnd_message.set_token( 'VAR_ERECREQ', l_rulevalues(i).input_value);
281: fnd_file.put_line(fnd_file.output, fnd_message.get);

Line 279: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_REQ');

275: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_ESIG_REQ');
276: fnd_message.set_token( 'VAR_ESIGREQ', l_rulevalues(i).input_value);
277: fnd_file.put_line(fnd_file.output, fnd_message.get);
278: elsif l_rulevalues(i).input_name = 'EREC_REQUIRED' then
279: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_REQ');
280: fnd_message.set_token( 'VAR_ERECREQ', l_rulevalues(i).input_value);
281: fnd_file.put_line(fnd_file.output, fnd_message.get);
282: elsif l_rulevalues(i).input_name = 'EREC_STYLE_SHEET' then
283: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_XSL');

Line 280: fnd_message.set_token( 'VAR_ERECREQ', l_rulevalues(i).input_value);

276: fnd_message.set_token( 'VAR_ESIGREQ', l_rulevalues(i).input_value);
277: fnd_file.put_line(fnd_file.output, fnd_message.get);
278: elsif l_rulevalues(i).input_name = 'EREC_REQUIRED' then
279: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_REQ');
280: fnd_message.set_token( 'VAR_ERECREQ', l_rulevalues(i).input_value);
281: fnd_file.put_line(fnd_file.output, fnd_message.get);
282: elsif l_rulevalues(i).input_name = 'EREC_STYLE_SHEET' then
283: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_XSL');
284: fnd_message.set_token( 'VAR_ERECXSL', l_rulevalues(i).input_value);

Line 281: fnd_file.put_line(fnd_file.output, fnd_message.get);

277: fnd_file.put_line(fnd_file.output, fnd_message.get);
278: elsif l_rulevalues(i).input_name = 'EREC_REQUIRED' then
279: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_REQ');
280: fnd_message.set_token( 'VAR_ERECREQ', l_rulevalues(i).input_value);
281: fnd_file.put_line(fnd_file.output, fnd_message.get);
282: elsif l_rulevalues(i).input_name = 'EREC_STYLE_SHEET' then
283: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_XSL');
284: fnd_message.set_token( 'VAR_ERECXSL', l_rulevalues(i).input_value);
285: fnd_file.put_line(fnd_file.output, fnd_message.get);

Line 283: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_XSL');

279: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_REQ');
280: fnd_message.set_token( 'VAR_ERECREQ', l_rulevalues(i).input_value);
281: fnd_file.put_line(fnd_file.output, fnd_message.get);
282: elsif l_rulevalues(i).input_name = 'EREC_STYLE_SHEET' then
283: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_XSL');
284: fnd_message.set_token( 'VAR_ERECXSL', l_rulevalues(i).input_value);
285: fnd_file.put_line(fnd_file.output, fnd_message.get);
286: elsif l_rulevalues(i).input_name = 'EREC_STYLE_SHEET_VER' then
287: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_VER');

Line 284: fnd_message.set_token( 'VAR_ERECXSL', l_rulevalues(i).input_value);

280: fnd_message.set_token( 'VAR_ERECREQ', l_rulevalues(i).input_value);
281: fnd_file.put_line(fnd_file.output, fnd_message.get);
282: elsif l_rulevalues(i).input_name = 'EREC_STYLE_SHEET' then
283: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_XSL');
284: fnd_message.set_token( 'VAR_ERECXSL', l_rulevalues(i).input_value);
285: fnd_file.put_line(fnd_file.output, fnd_message.get);
286: elsif l_rulevalues(i).input_name = 'EREC_STYLE_SHEET_VER' then
287: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_VER');
288: fnd_message.set_token( 'VAR_ERECVER', l_rulevalues(i).input_value);

Line 285: fnd_file.put_line(fnd_file.output, fnd_message.get);

281: fnd_file.put_line(fnd_file.output, fnd_message.get);
282: elsif l_rulevalues(i).input_name = 'EREC_STYLE_SHEET' then
283: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_XSL');
284: fnd_message.set_token( 'VAR_ERECXSL', l_rulevalues(i).input_value);
285: fnd_file.put_line(fnd_file.output, fnd_message.get);
286: elsif l_rulevalues(i).input_name = 'EREC_STYLE_SHEET_VER' then
287: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_VER');
288: fnd_message.set_token( 'VAR_ERECVER', l_rulevalues(i).input_value);
289: fnd_file.put_line(fnd_file.output, fnd_message.get);

Line 287: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_VER');

283: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_XSL');
284: fnd_message.set_token( 'VAR_ERECXSL', l_rulevalues(i).input_value);
285: fnd_file.put_line(fnd_file.output, fnd_message.get);
286: elsif l_rulevalues(i).input_name = 'EREC_STYLE_SHEET_VER' then
287: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_VER');
288: fnd_message.set_token( 'VAR_ERECVER', l_rulevalues(i).input_value);
289: fnd_file.put_line(fnd_file.output, fnd_message.get);
290: end if;
291: end loop;

Line 288: fnd_message.set_token( 'VAR_ERECVER', l_rulevalues(i).input_value);

284: fnd_message.set_token( 'VAR_ERECXSL', l_rulevalues(i).input_value);
285: fnd_file.put_line(fnd_file.output, fnd_message.get);
286: elsif l_rulevalues(i).input_name = 'EREC_STYLE_SHEET_VER' then
287: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_VER');
288: fnd_message.set_token( 'VAR_ERECVER', l_rulevalues(i).input_value);
289: fnd_file.put_line(fnd_file.output, fnd_message.get);
290: end if;
291: end loop;
292: end if;

Line 289: fnd_file.put_line(fnd_file.output, fnd_message.get);

285: fnd_file.put_line(fnd_file.output, fnd_message.get);
286: elsif l_rulevalues(i).input_name = 'EREC_STYLE_SHEET_VER' then
287: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_INPUT_EREC_VER');
288: fnd_message.set_token( 'VAR_ERECVER', l_rulevalues(i).input_value);
289: fnd_file.put_line(fnd_file.output, fnd_message.get);
290: end if;
291: end loop;
292: end if;
293:

Line 297: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_GET_XML') );

293:
294: END LOOP;
295: END IF;
296:
297: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_GET_XML') );
298: -- Bug 5639849 : Starts
299: -- Read EDR_XML_MAP_CODE from subscription parameter rather than
300: -- event parameter list.
301: l_xml_map_code := NVL(EDR_INDEXED_XML_UTIL.GET_WF_PARAMS('EDR_XML_MAP_CODE',l_sub_guid),

Line 305: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_DOC_GET_MAP');

301: l_xml_map_code := NVL(EDR_INDEXED_XML_UTIL.GET_WF_PARAMS('EDR_XML_MAP_CODE',l_sub_guid),
302: evt.getEventName( ));
303: -- Bug 5639849 : Ends
304:
305: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_DOC_GET_MAP');
306: fnd_message.set_token( 'DOC_MAP', l_xml_map_code);
307: fnd_file.put_line(fnd_file.output, fnd_message.get);
308: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_DOC_GET_ID');
309: fnd_message.set_token( 'DOC_ID', evt.getEventKey());

Line 306: fnd_message.set_token( 'DOC_MAP', l_xml_map_code);

302: evt.getEventName( ));
303: -- Bug 5639849 : Ends
304:
305: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_DOC_GET_MAP');
306: fnd_message.set_token( 'DOC_MAP', l_xml_map_code);
307: fnd_file.put_line(fnd_file.output, fnd_message.get);
308: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_DOC_GET_ID');
309: fnd_message.set_token( 'DOC_ID', evt.getEventKey());
310: fnd_file.put_line(fnd_file.output, fnd_message.get);

Line 307: fnd_file.put_line(fnd_file.output, fnd_message.get);

303: -- Bug 5639849 : Ends
304:
305: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_DOC_GET_MAP');
306: fnd_message.set_token( 'DOC_MAP', l_xml_map_code);
307: fnd_file.put_line(fnd_file.output, fnd_message.get);
308: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_DOC_GET_ID');
309: fnd_message.set_token( 'DOC_ID', evt.getEventKey());
310: fnd_file.put_line(fnd_file.output, fnd_message.get);
311:

Line 308: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_DOC_GET_ID');

304:
305: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_DOC_GET_MAP');
306: fnd_message.set_token( 'DOC_MAP', l_xml_map_code);
307: fnd_file.put_line(fnd_file.output, fnd_message.get);
308: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_DOC_GET_ID');
309: fnd_message.set_token( 'DOC_ID', evt.getEventKey());
310: fnd_file.put_line(fnd_file.output, fnd_message.get);
311:
312: wf_event.AddParameterToList('ECX_MAP_CODE', l_xml_map_code,evt.Parameter_List); /* XML Map Code*/

Line 309: fnd_message.set_token( 'DOC_ID', evt.getEventKey());

305: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_DOC_GET_MAP');
306: fnd_message.set_token( 'DOC_MAP', l_xml_map_code);
307: fnd_file.put_line(fnd_file.output, fnd_message.get);
308: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_DOC_GET_ID');
309: fnd_message.set_token( 'DOC_ID', evt.getEventKey());
310: fnd_file.put_line(fnd_file.output, fnd_message.get);
311:
312: wf_event.AddParameterToList('ECX_MAP_CODE', l_xml_map_code,evt.Parameter_List); /* XML Map Code*/
313: wf_event.AddParameterToList('ECX_DOCUMENT_ID', evt.getEventKey( ),evt.Parameter_List); /* XML Document ID*/

Line 310: fnd_file.put_line(fnd_file.output, fnd_message.get);

306: fnd_message.set_token( 'DOC_MAP', l_xml_map_code);
307: fnd_file.put_line(fnd_file.output, fnd_message.get);
308: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_DOC_GET_ID');
309: fnd_message.set_token( 'DOC_ID', evt.getEventKey());
310: fnd_file.put_line(fnd_file.output, fnd_message.get);
311:
312: wf_event.AddParameterToList('ECX_MAP_CODE', l_xml_map_code,evt.Parameter_List); /* XML Map Code*/
313: wf_event.AddParameterToList('ECX_DOCUMENT_ID', evt.getEventKey( ),evt.Parameter_List); /* XML Document ID*/
314:

Line 315: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_GET_ECX') );

311:
312: wf_event.AddParameterToList('ECX_MAP_CODE', l_xml_map_code,evt.Parameter_List); /* XML Map Code*/
313: wf_event.AddParameterToList('ECX_DOCUMENT_ID', evt.getEventKey( ),evt.Parameter_List); /* XML Document ID*/
314:
315: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_GET_ECX') );
316:
317: /* Generate XML Document */
318: L_XML_DOCUMENT:=ECX_STANDARD.GENERATE
319: ( p_event_name=>evt.getEventName( ),

Line 323: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_XML_GOT') );

319: ( p_event_name=>evt.getEventName( ),
320: p_event_key=>evt.getEventKey( ),
321: p_parameter_list=>evt.Parameter_List );
322:
323: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_XML_GOT') );
324: -- 3186732 start: fnd_message.set_token limit 3000 char, fnd_message.get limit 2000 char
325: fnd_file.put_line(fnd_file.output, dbms_lob.SUBSTR(l_xml_document,32767) );
326: -- 3186732 end: removed fnd_message set_name/set_token/get statements, write to output directly
327:

Line 324: -- 3186732 start: fnd_message.set_token limit 3000 char, fnd_message.get limit 2000 char

320: p_event_key=>evt.getEventKey( ),
321: p_parameter_list=>evt.Parameter_List );
322:
323: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_XML_GOT') );
324: -- 3186732 start: fnd_message.set_token limit 3000 char, fnd_message.get limit 2000 char
325: fnd_file.put_line(fnd_file.output, dbms_lob.SUBSTR(l_xml_document,32767) );
326: -- 3186732 end: removed fnd_message set_name/set_token/get statements, write to output directly
327:
328: fnd_file.new_line(fnd_file.output, 2);

Line 326: -- 3186732 end: removed fnd_message set_name/set_token/get statements, write to output directly

322:
323: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_XML_GOT') );
324: -- 3186732 start: fnd_message.set_token limit 3000 char, fnd_message.get limit 2000 char
325: fnd_file.put_line(fnd_file.output, dbms_lob.SUBSTR(l_xml_document,32767) );
326: -- 3186732 end: removed fnd_message set_name/set_token/get statements, write to output directly
327:
328: fnd_file.new_line(fnd_file.output, 2);
329: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_SETUP_OK') );
330:

Line 329: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_SETUP_OK') );

325: fnd_file.put_line(fnd_file.output, dbms_lob.SUBSTR(l_xml_document,32767) );
326: -- 3186732 end: removed fnd_message set_name/set_token/get statements, write to output directly
327:
328: fnd_file.new_line(fnd_file.output, 2);
329: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_SETUP_OK') );
330:
331:
332: EXCEPTION
333: WHEN OTHERS THEN

Line 336: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_SETUP_NO') );

332: EXCEPTION
333: WHEN OTHERS THEN
334: fnd_file.put_line(fnd_file.output,SQLERRM);
335: fnd_file.new_line(fnd_file.output,2);
336: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_DOC_SETUP_NO') );
337: END VERIFY_SETUP;
338:
339:
340:

Line 455: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_CLEAN_TEMP') );

451: IS
452:
453: BEGIN
454:
455: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_CLEAN_TEMP') );
456:
457: DELETE EDR_ERECORDS where ERECORD_SIGNATURE_STATUS not in ('PENDING');
458:
459: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_EREC');

Line 459: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_EREC');

455: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_CLEAN_TEMP') );
456:
457: DELETE EDR_ERECORDS where ERECORD_SIGNATURE_STATUS not in ('PENDING');
458:
459: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_EREC');
460: fnd_message.set_token( 'CLN_NUMREC', SQL%ROWCOUNT);
461: fnd_file.put_line(fnd_file.output, fnd_message.get);
462:
463: DELETE EDR_ESIGNATURES where EVENT_ID not in (SELECT EVENT_ID from EDR_ERECORDS);

Line 460: fnd_message.set_token( 'CLN_NUMREC', SQL%ROWCOUNT);

456:
457: DELETE EDR_ERECORDS where ERECORD_SIGNATURE_STATUS not in ('PENDING');
458:
459: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_EREC');
460: fnd_message.set_token( 'CLN_NUMREC', SQL%ROWCOUNT);
461: fnd_file.put_line(fnd_file.output, fnd_message.get);
462:
463: DELETE EDR_ESIGNATURES where EVENT_ID not in (SELECT EVENT_ID from EDR_ERECORDS);
464:

Line 461: fnd_file.put_line(fnd_file.output, fnd_message.get);

457: DELETE EDR_ERECORDS where ERECORD_SIGNATURE_STATUS not in ('PENDING');
458:
459: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_EREC');
460: fnd_message.set_token( 'CLN_NUMREC', SQL%ROWCOUNT);
461: fnd_file.put_line(fnd_file.output, fnd_message.get);
462:
463: DELETE EDR_ESIGNATURES where EVENT_ID not in (SELECT EVENT_ID from EDR_ERECORDS);
464:
465: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_ESIG');

Line 465: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_ESIG');

461: fnd_file.put_line(fnd_file.output, fnd_message.get);
462:
463: DELETE EDR_ESIGNATURES where EVENT_ID not in (SELECT EVENT_ID from EDR_ERECORDS);
464:
465: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_ESIG');
466: fnd_message.set_token( 'CLN_NUMSIG', SQL%ROWCOUNT);
467: fnd_file.put_line(fnd_file.output, fnd_message.get);
468:
469: -- Bug 3761813 rvsingh start

Line 466: fnd_message.set_token( 'CLN_NUMSIG', SQL%ROWCOUNT);

462:
463: DELETE EDR_ESIGNATURES where EVENT_ID not in (SELECT EVENT_ID from EDR_ERECORDS);
464:
465: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_ESIG');
466: fnd_message.set_token( 'CLN_NUMSIG', SQL%ROWCOUNT);
467: fnd_file.put_line(fnd_file.output, fnd_message.get);
468:
469: -- Bug 3761813 rvsingh start
470: --Bug 4306292: Start

Line 467: fnd_file.put_line(fnd_file.output, fnd_message.get);

463: DELETE EDR_ESIGNATURES where EVENT_ID not in (SELECT EVENT_ID from EDR_ERECORDS);
464:
465: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_ESIG');
466: fnd_message.set_token( 'CLN_NUMSIG', SQL%ROWCOUNT);
467: fnd_file.put_line(fnd_file.output, fnd_message.get);
468:
469: -- Bug 3761813 rvsingh start
470: --Bug 4306292: Start
471: --Commenting the changes made for the red lining project.

Line 475: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_REDLINE');

471: --Commenting the changes made for the red lining project.
472:
473: DELETE EDR_REDLINE_TRANS_DATA where EVENT_ID not in (SELECT EVENT_ID from EDR_ERECORDS);
474:
475: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_REDLINE');
476: fnd_message.set_token( 'CLN_NUMREDLINE', SQL%ROWCOUNT);
477: fnd_file.put_line(fnd_file.output, fnd_message.get);
478:
479: --Bug 4306292: End

Line 476: fnd_message.set_token( 'CLN_NUMREDLINE', SQL%ROWCOUNT);

472:
473: DELETE EDR_REDLINE_TRANS_DATA where EVENT_ID not in (SELECT EVENT_ID from EDR_ERECORDS);
474:
475: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_REDLINE');
476: fnd_message.set_token( 'CLN_NUMREDLINE', SQL%ROWCOUNT);
477: fnd_file.put_line(fnd_file.output, fnd_message.get);
478:
479: --Bug 4306292: End
480: -- Bug 3761813 rvsing stop

Line 477: fnd_file.put_line(fnd_file.output, fnd_message.get);

473: DELETE EDR_REDLINE_TRANS_DATA where EVENT_ID not in (SELECT EVENT_ID from EDR_ERECORDS);
474:
475: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_REDLINE');
476: fnd_message.set_token( 'CLN_NUMREDLINE', SQL%ROWCOUNT);
477: fnd_file.put_line(fnd_file.output, fnd_message.get);
478:
479: --Bug 4306292: End
480: -- Bug 3761813 rvsing stop
481:

Line 484: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_TQRY');

480: -- Bug 3761813 rvsing stop
481:
482: DELETE EDR_TRANS_QUERY_TEMP;
483:
484: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_TQRY');
485: fnd_message.set_token( 'CLN_NUMQRY', SQL%ROWCOUNT);
486: fnd_file.put_line(fnd_file.output, fnd_message.get);
487:
488: --Bug 5256904: Start

Line 485: fnd_message.set_token( 'CLN_NUMQRY', SQL%ROWCOUNT);

481:
482: DELETE EDR_TRANS_QUERY_TEMP;
483:
484: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_TQRY');
485: fnd_message.set_token( 'CLN_NUMQRY', SQL%ROWCOUNT);
486: fnd_file.put_line(fnd_file.output, fnd_message.get);
487:
488: --Bug 5256904: Start
489: DELETE FROM EDR_ERESPARAMETERS_T

Line 486: fnd_file.put_line(fnd_file.output, fnd_message.get);

482: DELETE EDR_TRANS_QUERY_TEMP;
483:
484: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_TQRY');
485: fnd_message.set_token( 'CLN_NUMQRY', SQL%ROWCOUNT);
486: fnd_file.put_line(fnd_file.output, fnd_message.get);
487:
488: --Bug 5256904: Start
489: DELETE FROM EDR_ERESPARAMETERS_T
490: WHERE PARENT_TYPE = 'EDR_XDOC_PARAMS';

Line 507: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_PREP');

503:
504: DELETE FROM EDR_PREPARE_DOCUMENT_TEMP WHERE REQUEST_ID IN
505: (SELECT REQUEST_ID FROM EDR_COLLATE_PRINT_TEMP
506: WHERE CREATION_DATE < (SYSDATE - 2) );
507: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_PREP');
508: fnd_message.set_token( 'CLN_NUMQRY', SQL%ROWCOUNT);
509: fnd_file.put_line(fnd_file.output, fnd_message.get);
510:
511: DELETE FROM EDR_COLLATE_PRINT_TEMP where CREATION_DATE < (SYSDATE - 2);

Line 508: fnd_message.set_token( 'CLN_NUMQRY', SQL%ROWCOUNT);

504: DELETE FROM EDR_PREPARE_DOCUMENT_TEMP WHERE REQUEST_ID IN
505: (SELECT REQUEST_ID FROM EDR_COLLATE_PRINT_TEMP
506: WHERE CREATION_DATE < (SYSDATE - 2) );
507: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_PREP');
508: fnd_message.set_token( 'CLN_NUMQRY', SQL%ROWCOUNT);
509: fnd_file.put_line(fnd_file.output, fnd_message.get);
510:
511: DELETE FROM EDR_COLLATE_PRINT_TEMP where CREATION_DATE < (SYSDATE - 2);
512: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_COLL');

Line 509: fnd_file.put_line(fnd_file.output, fnd_message.get);

505: (SELECT REQUEST_ID FROM EDR_COLLATE_PRINT_TEMP
506: WHERE CREATION_DATE < (SYSDATE - 2) );
507: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_PREP');
508: fnd_message.set_token( 'CLN_NUMQRY', SQL%ROWCOUNT);
509: fnd_file.put_line(fnd_file.output, fnd_message.get);
510:
511: DELETE FROM EDR_COLLATE_PRINT_TEMP where CREATION_DATE < (SYSDATE - 2);
512: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_COLL');
513: fnd_message.set_token( 'CLN_NUMQRY', SQL%ROWCOUNT);

Line 512: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_COLL');

508: fnd_message.set_token( 'CLN_NUMQRY', SQL%ROWCOUNT);
509: fnd_file.put_line(fnd_file.output, fnd_message.get);
510:
511: DELETE FROM EDR_COLLATE_PRINT_TEMP where CREATION_DATE < (SYSDATE - 2);
512: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_COLL');
513: fnd_message.set_token( 'CLN_NUMQRY', SQL%ROWCOUNT);
514: fnd_file.put_line(fnd_file.output, fnd_message.get);
515:
516: -- Bug 3776079 : End

Line 513: fnd_message.set_token( 'CLN_NUMQRY', SQL%ROWCOUNT);

509: fnd_file.put_line(fnd_file.output, fnd_message.get);
510:
511: DELETE FROM EDR_COLLATE_PRINT_TEMP where CREATION_DATE < (SYSDATE - 2);
512: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_COLL');
513: fnd_message.set_token( 'CLN_NUMQRY', SQL%ROWCOUNT);
514: fnd_file.put_line(fnd_file.output, fnd_message.get);
515:
516: -- Bug 3776079 : End
517:

Line 514: fnd_file.put_line(fnd_file.output, fnd_message.get);

510:
511: DELETE FROM EDR_COLLATE_PRINT_TEMP where CREATION_DATE < (SYSDATE - 2);
512: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_COLL');
513: fnd_message.set_token( 'CLN_NUMQRY', SQL%ROWCOUNT);
514: fnd_file.put_line(fnd_file.output, fnd_message.get);
515:
516: -- Bug 3776079 : End
517:
518: COMMIT;

Line 704: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_SEQUENCE');

700: IF display_type = WF_NOTIFICATION.doc_text THEN
701: document := NULL;
702: ELSE
703: j := 1;
704: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_SEQUENCE');
705: j := j+1;
706: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_NAME');
707: j := j+1;
708: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_STATUS');

Line 706: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_NAME');

702: ELSE
703: j := 1;
704: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_SEQUENCE');
705: j := j+1;
706: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_NAME');
707: j := j+1;
708: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_STATUS');
709: j := j+1;
710: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_DATETIME');

Line 708: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_STATUS');

704: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_SEQUENCE');
705: j := j+1;
706: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_NAME');
707: j := j+1;
708: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_STATUS');
709: j := j+1;
710: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_DATETIME');
711: j := j+1;
712: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_SIGNATURE_TYPE');

Line 710: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_DATETIME');

706: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_NAME');
707: j := j+1;
708: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_STATUS');
709: j := j+1;
710: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_DATETIME');
711: j := j+1;
712: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_SIGNATURE_TYPE');
713: j := j+1;
714: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_REASON_CODE');

Line 712: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_SIGNATURE_TYPE');

708: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_STATUS');
709: j := j+1;
710: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_DATETIME');
711: j := j+1;
712: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_SIGNATURE_TYPE');
713: j := j+1;
714: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_REASON_CODE');
715: j := j+1;
716: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_COMMENTS');

Line 714: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_REASON_CODE');

710: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_DATETIME');
711: j := j+1;
712: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_SIGNATURE_TYPE');
713: j := j+1;
714: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_REASON_CODE');
715: j := j+1;
716: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_COMMENTS');
717: j := j+1;
718: --Bug 4113995: Start

Line 716: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_COMMENTS');

712: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_SIGNATURE_TYPE');
713: j := j+1;
714: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_REASON_CODE');
715: j := j+1;
716: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_COMMENTS');
717: j := j+1;
718: --Bug 4113995: Start
719: --Including overriding details in the signature history table.
720: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_OVERRIDING_DETAILS');

Line 720: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_OVERRIDING_DETAILS');

716: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_COMMENTS');
717: j := j+1;
718: --Bug 4113995: Start
719: --Including overriding details in the signature history table.
720: l_cells(j) := 'S:'||FND_MESSAGE.GET_STRING('EDR','EDR_NTF_OVERRIDING_DETAILS');
721: j := j+1;
722: --Bug 4113995: End
723:
724: i := 0;

Line 761: FND_MESSAGE.GET_STRING('EDR','EDR_NTF_SIGNATURE_HISTORY')||

757: -- classes
758:
759: document:=''||
760: '
'||
761: FND_MESSAGE.GET_STRING('EDR','EDR_NTF_SIGNATURE_HISTORY')||
762: '
'||
763: '' ||
764: '
'||
765: l_result ||'

';

Line 1484: FND_MESSAGE.SET_NAME('EDR','EDR_VALIDATE_XML_GEN_ERR');

1480:
1481: EXCEPTION
1482:
1483: when DB_TO_XML_ERROR then
1484: FND_MESSAGE.SET_NAME('EDR','EDR_VALIDATE_XML_GEN_ERR');
1485: FND_MESSAGE.SET_TOKEN('OPERATION','DB to XML');
1486: FND_MESSAGE.SET_TOKEN('ERROR_DETAILS',l_error_msg);
1487: FND_MESSAGE.SET_TOKEN('LOG_DETAILS',l_log_file);
1488: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1485: FND_MESSAGE.SET_TOKEN('OPERATION','DB to XML');

1481: EXCEPTION
1482:
1483: when DB_TO_XML_ERROR then
1484: FND_MESSAGE.SET_NAME('EDR','EDR_VALIDATE_XML_GEN_ERR');
1485: FND_MESSAGE.SET_TOKEN('OPERATION','DB to XML');
1486: FND_MESSAGE.SET_TOKEN('ERROR_DETAILS',l_error_msg);
1487: FND_MESSAGE.SET_TOKEN('LOG_DETAILS',l_log_file);
1488: APP_EXCEPTION.RAISE_EXCEPTION;
1489:

Line 1486: FND_MESSAGE.SET_TOKEN('ERROR_DETAILS',l_error_msg);

1482:
1483: when DB_TO_XML_ERROR then
1484: FND_MESSAGE.SET_NAME('EDR','EDR_VALIDATE_XML_GEN_ERR');
1485: FND_MESSAGE.SET_TOKEN('OPERATION','DB to XML');
1486: FND_MESSAGE.SET_TOKEN('ERROR_DETAILS',l_error_msg);
1487: FND_MESSAGE.SET_TOKEN('LOG_DETAILS',l_log_file);
1488: APP_EXCEPTION.RAISE_EXCEPTION;
1489:
1490: when XML_TO_XML_ERROR then

Line 1487: FND_MESSAGE.SET_TOKEN('LOG_DETAILS',l_log_file);

1483: when DB_TO_XML_ERROR then
1484: FND_MESSAGE.SET_NAME('EDR','EDR_VALIDATE_XML_GEN_ERR');
1485: FND_MESSAGE.SET_TOKEN('OPERATION','DB to XML');
1486: FND_MESSAGE.SET_TOKEN('ERROR_DETAILS',l_error_msg);
1487: FND_MESSAGE.SET_TOKEN('LOG_DETAILS',l_log_file);
1488: APP_EXCEPTION.RAISE_EXCEPTION;
1489:
1490: when XML_TO_XML_ERROR then
1491: FND_MESSAGE.SET_NAME('EDR','EDR_VALIDATE_XML_GEN_ERR');

Line 1491: FND_MESSAGE.SET_NAME('EDR','EDR_VALIDATE_XML_GEN_ERR');

1487: FND_MESSAGE.SET_TOKEN('LOG_DETAILS',l_log_file);
1488: APP_EXCEPTION.RAISE_EXCEPTION;
1489:
1490: when XML_TO_XML_ERROR then
1491: FND_MESSAGE.SET_NAME('EDR','EDR_VALIDATE_XML_GEN_ERR');
1492: FND_MESSAGE.SET_TOKEN('OPERATION','XML to XML');
1493: FND_MESSAGE.SET_TOKEN('ERROR_DETAILS',l_error_msg);
1494: FND_MESSAGE.SET_TOKEN('LOG_DETAILS',l_log_file);
1495: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1492: FND_MESSAGE.SET_TOKEN('OPERATION','XML to XML');

1488: APP_EXCEPTION.RAISE_EXCEPTION;
1489:
1490: when XML_TO_XML_ERROR then
1491: FND_MESSAGE.SET_NAME('EDR','EDR_VALIDATE_XML_GEN_ERR');
1492: FND_MESSAGE.SET_TOKEN('OPERATION','XML to XML');
1493: FND_MESSAGE.SET_TOKEN('ERROR_DETAILS',l_error_msg);
1494: FND_MESSAGE.SET_TOKEN('LOG_DETAILS',l_log_file);
1495: APP_EXCEPTION.RAISE_EXCEPTION;
1496:

Line 1493: FND_MESSAGE.SET_TOKEN('ERROR_DETAILS',l_error_msg);

1489:
1490: when XML_TO_XML_ERROR then
1491: FND_MESSAGE.SET_NAME('EDR','EDR_VALIDATE_XML_GEN_ERR');
1492: FND_MESSAGE.SET_TOKEN('OPERATION','XML to XML');
1493: FND_MESSAGE.SET_TOKEN('ERROR_DETAILS',l_error_msg);
1494: FND_MESSAGE.SET_TOKEN('LOG_DETAILS',l_log_file);
1495: APP_EXCEPTION.RAISE_EXCEPTION;
1496:
1497: when others then

Line 1494: FND_MESSAGE.SET_TOKEN('LOG_DETAILS',l_log_file);

1490: when XML_TO_XML_ERROR then
1491: FND_MESSAGE.SET_NAME('EDR','EDR_VALIDATE_XML_GEN_ERR');
1492: FND_MESSAGE.SET_TOKEN('OPERATION','XML to XML');
1493: FND_MESSAGE.SET_TOKEN('ERROR_DETAILS',l_error_msg);
1494: FND_MESSAGE.SET_TOKEN('LOG_DETAILS',l_log_file);
1495: APP_EXCEPTION.RAISE_EXCEPTION;
1496:
1497: when others then
1498: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

Line 1498: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

1494: FND_MESSAGE.SET_TOKEN('LOG_DETAILS',l_log_file);
1495: APP_EXCEPTION.RAISE_EXCEPTION;
1496:
1497: when others then
1498: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1499: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1500: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_UTILITIES');
1501: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GENERATE_XML_PAYLOAD');
1502: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1499: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));

1495: APP_EXCEPTION.RAISE_EXCEPTION;
1496:
1497: when others then
1498: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1499: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1500: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_UTILITIES');
1501: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GENERATE_XML_PAYLOAD');
1502: APP_EXCEPTION.RAISE_EXCEPTION;
1503:

Line 1500: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_UTILITIES');

1496:
1497: when others then
1498: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1499: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1500: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_UTILITIES');
1501: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GENERATE_XML_PAYLOAD');
1502: APP_EXCEPTION.RAISE_EXCEPTION;
1503:
1504:

Line 1501: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GENERATE_XML_PAYLOAD');

1497: when others then
1498: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1499: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',nvl(l_error_msg,SQLERRM));
1500: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_UTILITIES');
1501: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GENERATE_XML_PAYLOAD');
1502: APP_EXCEPTION.RAISE_EXCEPTION;
1503:
1504:
1505: END GENERATE_XML_PAYLOAD;

Line 1821: FND_MESSAGE.SET_NAME('EDR','EDR_AME_SETUP_ERR');

1817: WHEN OTHERS THEN
1818: -- Following statement clears all lock aquired by this session
1819: -- This is modified as part of bug fix 2639210
1820: ROLLBACK TO AME_RULES_AND_VARIABLES;
1821: FND_MESSAGE.SET_NAME('EDR','EDR_AME_SETUP_ERR');
1822: FND_MESSAGE.SET_TOKEN('TXN_TYPE',nvl(l_ame_transaction_type,evt.getEventName()));
1823: FND_MESSAGE.SET_TOKEN('ERR_MSG',sqlerrm);
1824: APP_EXCEPTION.RAISE_EXCEPTION;
1825: END;

Line 1822: FND_MESSAGE.SET_TOKEN('TXN_TYPE',nvl(l_ame_transaction_type,evt.getEventName()));

1818: -- Following statement clears all lock aquired by this session
1819: -- This is modified as part of bug fix 2639210
1820: ROLLBACK TO AME_RULES_AND_VARIABLES;
1821: FND_MESSAGE.SET_NAME('EDR','EDR_AME_SETUP_ERR');
1822: FND_MESSAGE.SET_TOKEN('TXN_TYPE',nvl(l_ame_transaction_type,evt.getEventName()));
1823: FND_MESSAGE.SET_TOKEN('ERR_MSG',sqlerrm);
1824: APP_EXCEPTION.RAISE_EXCEPTION;
1825: END;
1826: --Bug 5287504: End

Line 1823: FND_MESSAGE.SET_TOKEN('ERR_MSG',sqlerrm);

1819: -- This is modified as part of bug fix 2639210
1820: ROLLBACK TO AME_RULES_AND_VARIABLES;
1821: FND_MESSAGE.SET_NAME('EDR','EDR_AME_SETUP_ERR');
1822: FND_MESSAGE.SET_TOKEN('TXN_TYPE',nvl(l_ame_transaction_type,evt.getEventName()));
1823: FND_MESSAGE.SET_TOKEN('ERR_MSG',sqlerrm);
1824: APP_EXCEPTION.RAISE_EXCEPTION;
1825: END;
1826: --Bug 5287504: End
1827:

Line 2037: FND_MESSAGE.SET_NAME('EDR','EDR_VALIDATE_MULTI_ERES_ERR');

2033:
2034: EXCEPTION
2035: --In the event of multiple subscriptions raise an exception.
2036: WHEN MULTIPLE_ERES_SUBSCRIPTIONS THEN
2037: FND_MESSAGE.SET_NAME('EDR','EDR_VALIDATE_MULTI_ERES_ERR');
2038: fnd_message.set_token( 'EVENT', p_event_name);
2039: raise_application_error(-20002,fnd_message.get);
2040: WHEN NO_DATA_FOUND THEN
2041: -- Bug 5586151 :start

Line 2038: fnd_message.set_token( 'EVENT', p_event_name);

2034: EXCEPTION
2035: --In the event of multiple subscriptions raise an exception.
2036: WHEN MULTIPLE_ERES_SUBSCRIPTIONS THEN
2037: FND_MESSAGE.SET_NAME('EDR','EDR_VALIDATE_MULTI_ERES_ERR');
2038: fnd_message.set_token( 'EVENT', p_event_name);
2039: raise_application_error(-20002,fnd_message.get);
2040: WHEN NO_DATA_FOUND THEN
2041: -- Bug 5586151 :start
2042: fnd_message.set_name('EDR', 'EDR_VALIDATE_NO_ERES_SUBS_ERR');

Line 2039: raise_application_error(-20002,fnd_message.get);

2035: --In the event of multiple subscriptions raise an exception.
2036: WHEN MULTIPLE_ERES_SUBSCRIPTIONS THEN
2037: FND_MESSAGE.SET_NAME('EDR','EDR_VALIDATE_MULTI_ERES_ERR');
2038: fnd_message.set_token( 'EVENT', p_event_name);
2039: raise_application_error(-20002,fnd_message.get);
2040: WHEN NO_DATA_FOUND THEN
2041: -- Bug 5586151 :start
2042: fnd_message.set_name('EDR', 'EDR_VALIDATE_NO_ERES_SUBS_ERR');
2043: fnd_message.set_token( 'EVENT_NAME', p_event_name);

Line 2042: fnd_message.set_name('EDR', 'EDR_VALIDATE_NO_ERES_SUBS_ERR');

2038: fnd_message.set_token( 'EVENT', p_event_name);
2039: raise_application_error(-20002,fnd_message.get);
2040: WHEN NO_DATA_FOUND THEN
2041: -- Bug 5586151 :start
2042: fnd_message.set_name('EDR', 'EDR_VALIDATE_NO_ERES_SUBS_ERR');
2043: fnd_message.set_token( 'EVENT_NAME', p_event_name);
2044: raise_application_error(-20003,fnd_message.get);
2045: WHEN NO_ERES_SUBSCRIPTIONS THEN
2046: FND_MESSAGE.SET_NAME('EDR','EDR_VALIDATE_NO_ACT_ERES_ERR');

Line 2043: fnd_message.set_token( 'EVENT_NAME', p_event_name);

2039: raise_application_error(-20002,fnd_message.get);
2040: WHEN NO_DATA_FOUND THEN
2041: -- Bug 5586151 :start
2042: fnd_message.set_name('EDR', 'EDR_VALIDATE_NO_ERES_SUBS_ERR');
2043: fnd_message.set_token( 'EVENT_NAME', p_event_name);
2044: raise_application_error(-20003,fnd_message.get);
2045: WHEN NO_ERES_SUBSCRIPTIONS THEN
2046: FND_MESSAGE.SET_NAME('EDR','EDR_VALIDATE_NO_ACT_ERES_ERR');
2047: fnd_message.set_token( 'EVENT_NAME', p_event_name);

Line 2044: raise_application_error(-20003,fnd_message.get);

2040: WHEN NO_DATA_FOUND THEN
2041: -- Bug 5586151 :start
2042: fnd_message.set_name('EDR', 'EDR_VALIDATE_NO_ERES_SUBS_ERR');
2043: fnd_message.set_token( 'EVENT_NAME', p_event_name);
2044: raise_application_error(-20003,fnd_message.get);
2045: WHEN NO_ERES_SUBSCRIPTIONS THEN
2046: FND_MESSAGE.SET_NAME('EDR','EDR_VALIDATE_NO_ACT_ERES_ERR');
2047: fnd_message.set_token( 'EVENT_NAME', p_event_name);
2048: raise_application_error(-20004,fnd_message.get);

Line 2046: FND_MESSAGE.SET_NAME('EDR','EDR_VALIDATE_NO_ACT_ERES_ERR');

2042: fnd_message.set_name('EDR', 'EDR_VALIDATE_NO_ERES_SUBS_ERR');
2043: fnd_message.set_token( 'EVENT_NAME', p_event_name);
2044: raise_application_error(-20003,fnd_message.get);
2045: WHEN NO_ERES_SUBSCRIPTIONS THEN
2046: FND_MESSAGE.SET_NAME('EDR','EDR_VALIDATE_NO_ACT_ERES_ERR');
2047: fnd_message.set_token( 'EVENT_NAME', p_event_name);
2048: raise_application_error(-20004,fnd_message.get);
2049: -- Bug 5586151 :End
2050: WHEN OTHERS THEN

Line 2047: fnd_message.set_token( 'EVENT_NAME', p_event_name);

2043: fnd_message.set_token( 'EVENT_NAME', p_event_name);
2044: raise_application_error(-20003,fnd_message.get);
2045: WHEN NO_ERES_SUBSCRIPTIONS THEN
2046: FND_MESSAGE.SET_NAME('EDR','EDR_VALIDATE_NO_ACT_ERES_ERR');
2047: fnd_message.set_token( 'EVENT_NAME', p_event_name);
2048: raise_application_error(-20004,fnd_message.get);
2049: -- Bug 5586151 :End
2050: WHEN OTHERS THEN
2051: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

Line 2048: raise_application_error(-20004,fnd_message.get);

2044: raise_application_error(-20003,fnd_message.get);
2045: WHEN NO_ERES_SUBSCRIPTIONS THEN
2046: FND_MESSAGE.SET_NAME('EDR','EDR_VALIDATE_NO_ACT_ERES_ERR');
2047: fnd_message.set_token( 'EVENT_NAME', p_event_name);
2048: raise_application_error(-20004,fnd_message.get);
2049: -- Bug 5586151 :End
2050: WHEN OTHERS THEN
2051: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
2052: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

Line 2051: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');

2047: fnd_message.set_token( 'EVENT_NAME', p_event_name);
2048: raise_application_error(-20004,fnd_message.get);
2049: -- Bug 5586151 :End
2050: WHEN OTHERS THEN
2051: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
2052: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2053: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_UTILITIES');
2054: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GET_RULES_AND_VARIABLES');
2055: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2052: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

2048: raise_application_error(-20004,fnd_message.get);
2049: -- Bug 5586151 :End
2050: WHEN OTHERS THEN
2051: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
2052: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2053: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_UTILITIES');
2054: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GET_RULES_AND_VARIABLES');
2055: APP_EXCEPTION.RAISE_EXCEPTION;
2056:

Line 2053: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_UTILITIES');

2049: -- Bug 5586151 :End
2050: WHEN OTHERS THEN
2051: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
2052: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2053: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_UTILITIES');
2054: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GET_RULES_AND_VARIABLES');
2055: APP_EXCEPTION.RAISE_EXCEPTION;
2056:
2057: END GET_RULES_AND_VARIABLES;

Line 2054: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GET_RULES_AND_VARIABLES');

2050: WHEN OTHERS THEN
2051: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
2052: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2053: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_UTILITIES');
2054: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','GET_RULES_AND_VARIABLES');
2055: APP_EXCEPTION.RAISE_EXCEPTION;
2056:
2057: END GET_RULES_AND_VARIABLES;
2058:

Line 2232: FND_MESSAGE.SET_NAME('EDR','EDR_AME_SETUP_ERR');

2228: WHEN OTHERS THEN
2229: -- Following statement clears all lock aquired by this session
2230: -- This is modified as part of bug fix 2639210
2231: ROLLBACK TO AME_RULES_AND_VARIABLES;
2232: FND_MESSAGE.SET_NAME('EDR','EDR_AME_SETUP_ERR');
2233: FND_MESSAGE.SET_TOKEN('TXN_TYPE',p_TRANSACTION_TYPE);
2234: FND_MESSAGE.SET_TOKEN('ERR_MSG',sqlerrm);
2235: APP_EXCEPTION.RAISE_EXCEPTION;
2236: END;

Line 2233: FND_MESSAGE.SET_TOKEN('TXN_TYPE',p_TRANSACTION_TYPE);

2229: -- Following statement clears all lock aquired by this session
2230: -- This is modified as part of bug fix 2639210
2231: ROLLBACK TO AME_RULES_AND_VARIABLES;
2232: FND_MESSAGE.SET_NAME('EDR','EDR_AME_SETUP_ERR');
2233: FND_MESSAGE.SET_TOKEN('TXN_TYPE',p_TRANSACTION_TYPE);
2234: FND_MESSAGE.SET_TOKEN('ERR_MSG',sqlerrm);
2235: APP_EXCEPTION.RAISE_EXCEPTION;
2236: END;
2237: END IF;

Line 2234: FND_MESSAGE.SET_TOKEN('ERR_MSG',sqlerrm);

2230: -- This is modified as part of bug fix 2639210
2231: ROLLBACK TO AME_RULES_AND_VARIABLES;
2232: FND_MESSAGE.SET_NAME('EDR','EDR_AME_SETUP_ERR');
2233: FND_MESSAGE.SET_TOKEN('TXN_TYPE',p_TRANSACTION_TYPE);
2234: FND_MESSAGE.SET_TOKEN('ERR_MSG',sqlerrm);
2235: APP_EXCEPTION.RAISE_EXCEPTION;
2236: END;
2237: END IF;
2238: --Bug 5724159 :End

Line 2243: FND_MESSAGE.SET_NAME('EDR','EDR_AME_SETUP_ERR');

2239:
2240: --Bug 5287504: Start
2241: EXCEPTION
2242: WHEN OTHERS THEN
2243: FND_MESSAGE.SET_NAME('EDR','EDR_AME_SETUP_ERR');
2244: FND_MESSAGE.SET_TOKEN('TXN_TYPE',p_TRANSACTION_TYPE);
2245: FND_MESSAGE.SET_TOKEN('ERR_MSG',sqlerrm);
2246: APP_EXCEPTION.RAISE_EXCEPTION;
2247: --Bug 5287504: End

Line 2244: FND_MESSAGE.SET_TOKEN('TXN_TYPE',p_TRANSACTION_TYPE);

2240: --Bug 5287504: Start
2241: EXCEPTION
2242: WHEN OTHERS THEN
2243: FND_MESSAGE.SET_NAME('EDR','EDR_AME_SETUP_ERR');
2244: FND_MESSAGE.SET_TOKEN('TXN_TYPE',p_TRANSACTION_TYPE);
2245: FND_MESSAGE.SET_TOKEN('ERR_MSG',sqlerrm);
2246: APP_EXCEPTION.RAISE_EXCEPTION;
2247: --Bug 5287504: End
2248: END GET_APPROVERS;

Line 2245: FND_MESSAGE.SET_TOKEN('ERR_MSG',sqlerrm);

2241: EXCEPTION
2242: WHEN OTHERS THEN
2243: FND_MESSAGE.SET_NAME('EDR','EDR_AME_SETUP_ERR');
2244: FND_MESSAGE.SET_TOKEN('TXN_TYPE',p_TRANSACTION_TYPE);
2245: FND_MESSAGE.SET_TOKEN('ERR_MSG',sqlerrm);
2246: APP_EXCEPTION.RAISE_EXCEPTION;
2247: --Bug 5287504: End
2248: END GET_APPROVERS;
2249: -- Bug 2674799 : end