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

Line 124: fnd_file.put_line(fnd_file.output, fnd_message.get_string('GMO', 'GMO_IS_ENABLED_START_PROCESS') );

120: BEGIN
121:
122: if (fnd_profile.defined('GMO_ENABLED_FLAG')) THEN
123: if GMO_SETUP_GRP.IS_GMO_ENABLED = GMO_CONSTANTS_GRP.YES THEN
124: fnd_file.put_line(fnd_file.output, fnd_message.get_string('GMO', 'GMO_IS_ENABLED_START_PROCESS') );
125: fnd_file.new_line(fnd_file.output, 1);
126:
127: OPEN CBR_EVENTS;
128: LOOP

Line 133: fnd_message.set_name('GMO', 'GMO_CBR_EVENT_PROCESSING');

129: FETCH CBR_EVENTS INTO l_EVENT_REC;
130: EXIT WHEN CBR_EVENTS%NOTFOUND;
131: l_event_name := l_EVENT_REC.name;
132: IF l_EVENT_REC.STATUS = 'DISABLED' THEN
133: fnd_message.set_name('GMO', 'GMO_CBR_EVENT_PROCESSING');
134: fnd_message.set_token('EVENT', l_EVENT_REC.DISPLAY_NAME);
135: fnd_file.put_line(fnd_file.output, fnd_message.get);
136: fnd_file.new_line(fnd_file.output, 2);
137:

Line 134: fnd_message.set_token('EVENT', l_EVENT_REC.DISPLAY_NAME);

130: EXIT WHEN CBR_EVENTS%NOTFOUND;
131: l_event_name := l_EVENT_REC.name;
132: IF l_EVENT_REC.STATUS = 'DISABLED' THEN
133: fnd_message.set_name('GMO', 'GMO_CBR_EVENT_PROCESSING');
134: fnd_message.set_token('EVENT', l_EVENT_REC.DISPLAY_NAME);
135: fnd_file.put_line(fnd_file.output, fnd_message.get);
136: fnd_file.new_line(fnd_file.output, 2);
137:
138: --

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

131: l_event_name := l_EVENT_REC.name;
132: IF l_EVENT_REC.STATUS = 'DISABLED' THEN
133: fnd_message.set_name('GMO', 'GMO_CBR_EVENT_PROCESSING');
134: fnd_message.set_token('EVENT', l_EVENT_REC.DISPLAY_NAME);
135: fnd_file.put_line(fnd_file.output, fnd_message.get);
136: fnd_file.new_line(fnd_file.output, 2);
137:
138: --
139: -- Enable ERES Event for Control Batch Recording

Line 161: fnd_message.set_name('GMO', 'GMO_CBR_EVT_PROD_SUB_PROCESS');

157: EXIT WHEN CBR_EVENT_SUBCRIPTIONS%NOTFOUND;
158: --
159: -- disable ERES Event subscriptions owned by product teams
160: --
161: fnd_message.set_name('GMO', 'GMO_CBR_EVT_PROD_SUB_PROCESS');
162: fnd_message.set_token('EVENT', l_EVENT_REC.DISPLAY_NAME);
163: fnd_file.put_line(fnd_file.output, fnd_message.get);
164: fnd_file.new_line(fnd_file.output, 2);
165:

Line 162: fnd_message.set_token('EVENT', l_EVENT_REC.DISPLAY_NAME);

158: --
159: -- disable ERES Event subscriptions owned by product teams
160: --
161: fnd_message.set_name('GMO', 'GMO_CBR_EVT_PROD_SUB_PROCESS');
162: fnd_message.set_token('EVENT', l_EVENT_REC.DISPLAY_NAME);
163: fnd_file.put_line(fnd_file.output, fnd_message.get);
164: fnd_file.new_line(fnd_file.output, 2);
165:
166: WF_EVENT_SUBSCRIPTIONS_PKG.UPDATE_ROW(X_GUID => l_CBR_EVENT_SUBCRIPTIONS_REC.GUID

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

159: -- disable ERES Event subscriptions owned by product teams
160: --
161: fnd_message.set_name('GMO', 'GMO_CBR_EVT_PROD_SUB_PROCESS');
162: fnd_message.set_token('EVENT', l_EVENT_REC.DISPLAY_NAME);
163: fnd_file.put_line(fnd_file.output, fnd_message.get);
164: fnd_file.new_line(fnd_file.output, 2);
165:
166: WF_EVENT_SUBSCRIPTIONS_PKG.UPDATE_ROW(X_GUID => l_CBR_EVENT_SUBCRIPTIONS_REC.GUID
167: ,X_SYSTEM_GUID => l_CBR_EVENT_SUBCRIPTIONS_REC.SYSTEM_GUID

Line 199: fnd_message.set_name('GMO', 'GMO_CBR_EVT_GMO_SUB_PROCESS');

195: OPEN CBR_GMO_SUBCRIPTIONS;
196: LOOP
197: FETCH CBR_GMO_SUBCRIPTIONS INTO l_CBR_GMO_SUBCRIPTIONS_REC;
198: EXIT WHEN CBR_GMO_SUBCRIPTIONS%NOTFOUND;
199: fnd_message.set_name('GMO', 'GMO_CBR_EVT_GMO_SUB_PROCESS');
200: fnd_message.set_token('EVENT', l_EVENT_REC.DISPLAY_NAME);
201: fnd_file.put_line(fnd_file.output, fnd_message.get);
202: fnd_file.new_line(fnd_file.output, 2);
203:

Line 200: fnd_message.set_token('EVENT', l_EVENT_REC.DISPLAY_NAME);

196: LOOP
197: FETCH CBR_GMO_SUBCRIPTIONS INTO l_CBR_GMO_SUBCRIPTIONS_REC;
198: EXIT WHEN CBR_GMO_SUBCRIPTIONS%NOTFOUND;
199: fnd_message.set_name('GMO', 'GMO_CBR_EVT_GMO_SUB_PROCESS');
200: fnd_message.set_token('EVENT', l_EVENT_REC.DISPLAY_NAME);
201: fnd_file.put_line(fnd_file.output, fnd_message.get);
202: fnd_file.new_line(fnd_file.output, 2);
203:
204: --

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

197: FETCH CBR_GMO_SUBCRIPTIONS INTO l_CBR_GMO_SUBCRIPTIONS_REC;
198: EXIT WHEN CBR_GMO_SUBCRIPTIONS%NOTFOUND;
199: fnd_message.set_name('GMO', 'GMO_CBR_EVT_GMO_SUB_PROCESS');
200: fnd_message.set_token('EVENT', l_EVENT_REC.DISPLAY_NAME);
201: fnd_file.put_line(fnd_file.output, fnd_message.get);
202: fnd_file.new_line(fnd_file.output, 2);
203:
204: --
205: -- enable ERES Event subscriptions owned by GMO

Line 241: fnd_message.set_name('GMO', 'GMO_EBR_ENABLED_DATE');

237: CLOSE CBR_EVENTS;
238: IF TO_DATE(fnd_profile.value('GMO_CBR_ENABLED_DATE'), datetime_format) is null
239: THEN
240: l_err := fnd_profile.save('GMO_CBR_ENABLED_DATE',TO_CHAR(sysdate, datetime_format), 'SITE');
241: fnd_message.set_name('GMO', 'GMO_EBR_ENABLED_DATE');
242: fnd_message.set_token('ENABLE_DATE',TO_DATE(fnd_profile.value('GMO_CBR_ENABLED_DATE'), datetime_format) );
243: fnd_file.put_line(fnd_file.output, fnd_message.get);
244: fnd_file.new_line(fnd_file.output, 2);
245: END IF;

Line 242: fnd_message.set_token('ENABLE_DATE',TO_DATE(fnd_profile.value('GMO_CBR_ENABLED_DATE'), datetime_format) );

238: IF TO_DATE(fnd_profile.value('GMO_CBR_ENABLED_DATE'), datetime_format) is null
239: THEN
240: l_err := fnd_profile.save('GMO_CBR_ENABLED_DATE',TO_CHAR(sysdate, datetime_format), 'SITE');
241: fnd_message.set_name('GMO', 'GMO_EBR_ENABLED_DATE');
242: fnd_message.set_token('ENABLE_DATE',TO_DATE(fnd_profile.value('GMO_CBR_ENABLED_DATE'), datetime_format) );
243: fnd_file.put_line(fnd_file.output, fnd_message.get);
244: fnd_file.new_line(fnd_file.output, 2);
245: END IF;
246: COMMIT;

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

239: THEN
240: l_err := fnd_profile.save('GMO_CBR_ENABLED_DATE',TO_CHAR(sysdate, datetime_format), 'SITE');
241: fnd_message.set_name('GMO', 'GMO_EBR_ENABLED_DATE');
242: fnd_message.set_token('ENABLE_DATE',TO_DATE(fnd_profile.value('GMO_CBR_ENABLED_DATE'), datetime_format) );
243: fnd_file.put_line(fnd_file.output, fnd_message.get);
244: fnd_file.new_line(fnd_file.output, 2);
245: END IF;
246: COMMIT;
247: else

Line 248: fnd_file.put_line(fnd_file.output, fnd_message.get_string('GMO', 'GMO_IS_NOT_ENABLED') );

244: fnd_file.new_line(fnd_file.output, 2);
245: END IF;
246: COMMIT;
247: else
248: fnd_file.put_line(fnd_file.output, fnd_message.get_string('GMO', 'GMO_IS_NOT_ENABLED') );
249: fnd_file.new_line(fnd_file.output, 1);
250: end if;
251: else
252: fnd_file.put_line(fnd_file.output, fnd_message.get_string('GMO', 'GMO_PROFILE_NOTFOUND') );

Line 252: fnd_file.put_line(fnd_file.output, fnd_message.get_string('GMO', 'GMO_PROFILE_NOTFOUND') );

248: fnd_file.put_line(fnd_file.output, fnd_message.get_string('GMO', 'GMO_IS_NOT_ENABLED') );
249: fnd_file.new_line(fnd_file.output, 1);
250: end if;
251: else
252: fnd_file.put_line(fnd_file.output, fnd_message.get_string('GMO', 'GMO_PROFILE_NOTFOUND') );
253: fnd_file.new_line(fnd_file.output, 1);
254: APP_EXCEPTION.Raise_exception;
255: end if;
256: EXCEPTION WHEN OTHERS THEN

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

706: l_compare_XML := nvl(wf_event.getValueForParameter('COMPARE_XML',p_event.Parameter_List),'Y');
707:
708: l_error_text := 'Event Name:'|| l_event_name || 'Event Key:'||l_event_key;
709: --Diagnostics Start
710: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
711: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
712: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');
713: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');
714: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 711: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);

707:
708: l_error_text := 'Event Name:'|| l_event_name || 'Event Key:'||l_event_key;
709: --Diagnostics Start
710: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
711: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
712: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');
713: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');
714: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
715: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

Line 712: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');

708: l_error_text := 'Event Name:'|| l_event_name || 'Event Key:'||l_event_key;
709: --Diagnostics Start
710: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
711: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
712: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');
713: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');
714: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
715: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
716: 'gmo.plsql.GMO_CBR_GRP.PROCESS_EVENT',

Line 713: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');

709: --Diagnostics Start
710: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
711: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
712: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');
713: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');
714: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
715: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
716: 'gmo.plsql.GMO_CBR_GRP.PROCESS_EVENT',
717: FALSE

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

719: end if;
720:
721: l_error_text := 'user Key:'|| l_user_key_label || 'User Key:'||l_user_key_value ||'eRecordId:'||l_erecord_id ;
722: --Diagnostics Start
723: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
724: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
725: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');
726: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');
727: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 724: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);

720:
721: l_error_text := 'user Key:'|| l_user_key_label || 'User Key:'||l_user_key_value ||'eRecordId:'||l_erecord_id ;
722: --Diagnostics Start
723: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
724: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
725: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');
726: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');
727: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
728: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

Line 725: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');

721: l_error_text := 'user Key:'|| l_user_key_label || 'User Key:'||l_user_key_value ||'eRecordId:'||l_erecord_id ;
722: --Diagnostics Start
723: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
724: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
725: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');
726: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');
727: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
728: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
729: 'gmo.plsql.GMO_CBR_GRP.PROCESS_EVENT',

Line 726: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');

722: --Diagnostics Start
723: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
724: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
725: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');
726: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');
727: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
728: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
729: 'gmo.plsql.GMO_CBR_GRP.PROCESS_EVENT',
730: FALSE

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

885: l_message_token:= 'GME_PSIG_BATCH_RSRC_PARM_LABEL';
886:
887: l_error_text := 'batch Id:'|| l_batch_id || 'resource id:'||l_batch_rsrc_id ;
888: --Diagnostics Start
889: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
890: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
891: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');
892: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');
893: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 890: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);

886:
887: l_error_text := 'batch Id:'|| l_batch_id || 'resource id:'||l_batch_rsrc_id ;
888: --Diagnostics Start
889: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
890: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
891: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');
892: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');
893: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
894: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

Line 891: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');

887: l_error_text := 'batch Id:'|| l_batch_id || 'resource id:'||l_batch_rsrc_id ;
888: --Diagnostics Start
889: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
890: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
891: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');
892: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');
893: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
894: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
895: 'gmo.plsql.GMO_CBR_GRP.PROCESS_EVENT',

Line 892: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');

888: --Diagnostics Start
889: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
890: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
891: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');
892: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');
893: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
894: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
895: 'gmo.plsql.GMO_CBR_GRP.PROCESS_EVENT',
896: FALSE

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

991:
992: /* populate Record object with the details */
993: l_error_text := 'Before populating Record Type' ;
994: --Diagnostics Start
995: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
996: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
997: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');
998: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');
999: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 996: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);

992: /* populate Record object with the details */
993: l_error_text := 'Before populating Record Type' ;
994: --Diagnostics Start
995: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
996: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
997: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');
998: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');
999: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1000: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

Line 997: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');

993: l_error_text := 'Before populating Record Type' ;
994: --Diagnostics Start
995: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
996: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
997: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');
998: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');
999: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1000: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
1001: 'gmo.plsql.GMO_CBR_GRP.PROCESS_EVENT',

Line 998: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');

994: --Diagnostics Start
995: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
996: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
997: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');
998: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');
999: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1000: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
1001: 'gmo.plsql.GMO_CBR_GRP.PROCESS_EVENT',
1002: FALSE

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

1039: l_batch_prog_rec.XML_MAP_CODE := l_map_code;
1040: l_batch_prog_rec.compare_xml:=l_compare_XML;
1041: l_error_text := 'Before insert' ;
1042: --Diagnostics Start
1043: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1044: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
1045: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');
1046: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');
1047: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1044: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);

1040: l_batch_prog_rec.compare_xml:=l_compare_XML;
1041: l_error_text := 'Before insert' ;
1042: --Diagnostics Start
1043: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1044: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
1045: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');
1046: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');
1047: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1048: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,

Line 1045: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');

1041: l_error_text := 'Before insert' ;
1042: --Diagnostics Start
1043: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1044: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
1045: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');
1046: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');
1047: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1048: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
1049: 'gmo.plsql.GMO_CBR_GRP.PROCESS_EVENT',

Line 1046: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');

1042: --Diagnostics Start
1043: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
1044: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
1045: FND_MESSAGE.SET_TOKEN('PKG_NAME','GMO_CBR_GRP');
1046: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','PROCESS_EVENT');
1047: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1048: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
1049: 'gmo.plsql.GMO_CBR_GRP.PROCESS_EVENT',
1050: FALSE

Line 1105: l_batch_prog_rec.USER_KEY_LABEL := FND_MESSAGE.GET_STRING('GME','GME_PSIG_BATCH_LABEL');

1101: l_batch_prog_rec.CURR_NODE_KEY := NULL;
1102: l_batch_prog_rec.CURR_KEY_VAL := NULL;
1103: l_batch_prog_rec.USER_KEY_LABEL_PROD := 'GME';
1104: l_batch_prog_rec.USER_KEY_LABEL_TOKEN := 'GME_PSIG_BATCH_LABEL';
1105: l_batch_prog_rec.USER_KEY_LABEL := FND_MESSAGE.GET_STRING('GME','GME_PSIG_BATCH_LABEL');
1106: l_batch_prog_rec.USER_KEY_VALUE := BATCH_DETAILS_REC.PLANT_CODE || '-'||BATCH_DETAILS_REC.BATCH_NO;
1107: l_batch_prog_rec.EXTERNAL_EVENT := NULL;
1108: l_batch_prog_rec.INCLUDE_IN_CBR := NULL;
1109: l_batch_prog_rec.EVENT := 'oracle.apps.gme.batch.release';

Line 1122: l_step_label := FND_MESSAGE.GET_STRING('GME','GME_PSIG_BATCH_STEP_LABEL');

1118: OPEN GET_STEP_DETAILS ;
1119: LOOP
1120: FETCH GET_STEP_DETAILS INTO STEP_DETAILS_REC;
1121: EXIT WHEN GET_STEP_DETAILS%NOTFOUND;
1122: l_step_label := FND_MESSAGE.GET_STRING('GME','GME_PSIG_BATCH_STEP_LABEL');
1123: l_step_user_val := BATCH_DETAILS_REC.PLANT_CODE || '-'||BATCH_DETAILS_REC.BATCH_NO||
1124: '-' ||STEP_DETAILS_REC.BATCHSTEP_NO||'-'||STEP_DETAILS_REC.OPERATION_NO;
1125: l_batch_prog_rec.PROGRESSION_ID := NULL;
1126: l_batch_prog_rec.BATCH_ID := P_BATCH_ID;

Line 1234: l_batch_prog_rec.USER_KEY_LABEL := FND_MESSAGE.GET_STRING('GME','GME_PSIG_BATCH_LABEL');

1230: l_batch_prog_rec.CURR_NODE_KEY := NULL;
1231: l_batch_prog_rec.CURR_KEY_VAL := NULL;
1232: l_batch_prog_rec.USER_KEY_LABEL_PROD := 'GME';
1233: l_batch_prog_rec.USER_KEY_LABEL_TOKEN := 'GME_PSIG_BATCH_LABEL';
1234: l_batch_prog_rec.USER_KEY_LABEL := FND_MESSAGE.GET_STRING('GME','GME_PSIG_BATCH_LABEL');
1235: l_batch_prog_rec.USER_KEY_VALUE := BATCH_DETAILS_REC.PLANT_CODE || '-'||BATCH_DETAILS_REC.BATCH_NO;
1236: l_batch_prog_rec.EXTERNAL_EVENT := NULL;
1237: l_batch_prog_rec.INCLUDE_IN_CBR := NULL;
1238: l_batch_prog_rec.EVENT := 'oracle.apps.gme.batch.complete';

Line 1264: l_batch_prog_rec.USER_KEY_LABEL := FND_MESSAGE.GET_STRING('GME','GME_PSIG_BATCH_LABEL');

1260: l_batch_prog_rec.CURR_NODE_KEY := NULL;
1261: l_batch_prog_rec.CURR_KEY_VAL := NULL;
1262: l_batch_prog_rec.USER_KEY_LABEL_PROD := 'GME';
1263: l_batch_prog_rec.USER_KEY_LABEL_TOKEN := 'GME_PSIG_BATCH_LABEL';
1264: l_batch_prog_rec.USER_KEY_LABEL := FND_MESSAGE.GET_STRING('GME','GME_PSIG_BATCH_LABEL');
1265: l_batch_prog_rec.USER_KEY_VALUE := BATCH_DETAILS_REC.PLANT_CODE || '-'||BATCH_DETAILS_REC.BATCH_NO;
1266: l_batch_prog_rec.EXTERNAL_EVENT := NULL;
1267: l_batch_prog_rec.INCLUDE_IN_CBR := NULL;
1268: l_batch_prog_rec.EVENT := 'oracle.apps.gme.batch.close';

Line 1407: FND_MESSAGE.SET_NAME('GMO','GMO_VALIDATE_XML_GEN_ERR');

1403: dbms_xmldom.freeDocument(l_srcDoc);
1404: End IF;
1405: EXCEPTION
1406: when DB_TO_XML_ERROR then
1407: FND_MESSAGE.SET_NAME('GMO','GMO_VALIDATE_XML_GEN_ERR');
1408: FND_MESSAGE.SET_TOKEN('OPERATION','DB to XML');
1409: FND_MESSAGE.SET_TOKEN('ERROR_DETAILS',l_error_msg);
1410: FND_MESSAGE.SET_TOKEN('LOG_DETAILS',l_log_file);
1411: APP_EXCEPTION.RAISE_EXCEPTION;

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

1404: End IF;
1405: EXCEPTION
1406: when DB_TO_XML_ERROR then
1407: FND_MESSAGE.SET_NAME('GMO','GMO_VALIDATE_XML_GEN_ERR');
1408: FND_MESSAGE.SET_TOKEN('OPERATION','DB to XML');
1409: FND_MESSAGE.SET_TOKEN('ERROR_DETAILS',l_error_msg);
1410: FND_MESSAGE.SET_TOKEN('LOG_DETAILS',l_log_file);
1411: APP_EXCEPTION.RAISE_EXCEPTION;
1412: END GET_INSTR_XML;

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

1405: EXCEPTION
1406: when DB_TO_XML_ERROR then
1407: FND_MESSAGE.SET_NAME('GMO','GMO_VALIDATE_XML_GEN_ERR');
1408: FND_MESSAGE.SET_TOKEN('OPERATION','DB to XML');
1409: FND_MESSAGE.SET_TOKEN('ERROR_DETAILS',l_error_msg);
1410: FND_MESSAGE.SET_TOKEN('LOG_DETAILS',l_log_file);
1411: APP_EXCEPTION.RAISE_EXCEPTION;
1412: END GET_INSTR_XML;
1413:

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

1406: when DB_TO_XML_ERROR then
1407: FND_MESSAGE.SET_NAME('GMO','GMO_VALIDATE_XML_GEN_ERR');
1408: FND_MESSAGE.SET_TOKEN('OPERATION','DB to XML');
1409: FND_MESSAGE.SET_TOKEN('ERROR_DETAILS',l_error_msg);
1410: FND_MESSAGE.SET_TOKEN('LOG_DETAILS',l_log_file);
1411: APP_EXCEPTION.RAISE_EXCEPTION;
1412: END GET_INSTR_XML;
1413:
1414: PROCEDURE PROCESS_INSTR_XML (p_entity_name VARCHAR2,p_entity_key VARCHAR2,p_event_key varchar2,p_instr_type VARCHAR2,

Line 1460: l_user_key_label := FND_MESSAGE.GET_STRING('GMO',l_message_token);

1456: OPEN get_dispense_Details;
1457: FETCH get_dispense_Details into l_batch_id, l_batchstep_id ,l_material_detail_id;
1458: CLOSE get_dispense_Details;
1459: l_message_token := 'GMO_ENTITY_DISPENSE_ITEM';
1460: l_user_key_label := FND_MESSAGE.GET_STRING('GMO',l_message_token);
1461: l_batch_prog_rec.PROGRESSION_ID := NULL;
1462: l_batch_prog_rec.BATCH_ID := l_batch_id ;
1463: l_batch_prog_rec.BATCHSTEP_ID := l_batchstep_id;
1464: l_batch_prog_rec.MATERIAL_LINE_ID := l_material_detail_id;

Line 1482: l_user_key_label := FND_MESSAGE.GET_STRING('GMO',l_message_token);

1478: OPEN get_rev_dispense_Details;
1479: FETCH get_rev_dispense_Details into l_batch_id, l_batchstep_id ,l_material_detail_id,l_dispense_id;
1480: CLOSE get_rev_dispense_Details;
1481: l_message_token := 'GMO_ENTITY_REV_DISP_ITEM';
1482: l_user_key_label := FND_MESSAGE.GET_STRING('GMO',l_message_token);
1483: l_batch_prog_rec.PROGRESSION_ID := NULL;
1484: l_batch_prog_rec.BATCH_ID := l_batch_id ;
1485: l_batch_prog_rec.BATCHSTEP_ID := l_batchstep_id;
1486: l_batch_prog_rec.MATERIAL_LINE_ID := l_material_detail_id;

Line 1502: l_user_key_label := FND_MESSAGE.GET_STRING('GMO',l_message_token);

1498: ELSIF(p_instr_type = 'PROCESS' and p_entity_name ='ACTIVITY') THEN
1499: SELECT BATCH_ID,BATCHSTEP_ID into l_batch_id,l_batchstep_id FROM GME_BATCH_STEP_ACTIVITIES
1500: WHERE batchstep_activity_id = p_entity_key;
1501: l_message_token := 'GMO_ENTITY_ACTIVITY';
1502: l_user_key_label := FND_MESSAGE.GET_STRING('GMO',l_message_token);
1503: l_batch_prog_rec.PROGRESSION_ID := NULL;
1504: l_batch_prog_rec.BATCH_ID := l_batch_id ;
1505: l_batch_prog_rec.BATCHSTEP_ID := l_batchstep_id;
1506: l_batch_prog_rec.MATERIAL_LINE_ID := NULL;

Line 1523: l_user_key_label := FND_MESSAGE.GET_STRING('GMO',l_message_token);

1519: open get_resource_details;
1520: FETCH get_resource_details into l_batch_id,l_batchstep_id,l_batchstep_activity_id;
1521: CLOSE get_resource_details;
1522: l_message_token := 'GMO_ENTITY_RESOURCE';
1523: l_user_key_label := FND_MESSAGE.GET_STRING('GMO',l_message_token);
1524: l_batch_prog_rec.PROGRESSION_ID := NULL;
1525: l_batch_prog_rec.BATCH_ID := l_batch_id ;
1526: l_batch_prog_rec.BATCHSTEP_ID := l_batchstep_id;
1527: l_batch_prog_rec.MATERIAL_LINE_ID := NULL;

Line 1543: l_user_key_label := FND_MESSAGE.GET_STRING('GMO', l_message_token);

1539: ELSIF(p_instr_type = 'PROCESS' and p_entity_name ='MATERIAL') THEN
1540: select batch_id into l_batch_id from gme_material_details
1541: where material_detail_id=p_entity_key;
1542: l_message_token := 'GMO_ENTITY_MATERIAL';
1543: l_user_key_label := FND_MESSAGE.GET_STRING('GMO', l_message_token);
1544: l_batch_prog_rec.PROGRESSION_ID := NULL;
1545: l_batch_prog_rec.BATCH_ID := l_batch_id ;
1546: l_batch_prog_rec.BATCHSTEP_ID := NULL;
1547: l_batch_prog_rec.MATERIAL_LINE_ID := p_entity_key;

Line 1564: l_user_key_label := FND_MESSAGE.GET_STRING('GMO',l_message_token);

1560: SELECT batch_id into l_batch_id
1561: FROM GME_BATCH_STEPS
1562: WHERE batchstep_id = p_entity_key;
1563: l_message_token := 'GMO_ENTITY_OPERATION';
1564: l_user_key_label := FND_MESSAGE.GET_STRING('GMO',l_message_token);
1565: l_batch_prog_rec.PROGRESSION_ID := NULL;
1566: l_batch_prog_rec.BATCH_ID := l_batch_id ;
1567: l_batch_prog_rec.BATCHSTEP_ID := p_entity_key;
1568: l_batch_prog_rec.MATERIAL_LINE_ID := NULL;

Line 1600: FND_MESSAGE.SET_NAME('GMO','FND_AS_UNEXPECTED_ERROR');

1596: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
1597:
1598: EXCEPTION
1599: WHEN OTHERS THEN
1600: FND_MESSAGE.SET_NAME('GMO','FND_AS_UNEXPECTED_ERROR');
1601: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1602: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
1603: FND_MSG_PUB.ADD;
1604: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count, p_data => l_msg_data);

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

1597:
1598: EXCEPTION
1599: WHEN OTHERS THEN
1600: FND_MESSAGE.SET_NAME('GMO','FND_AS_UNEXPECTED_ERROR');
1601: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1602: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
1603: FND_MSG_PUB.ADD;
1604: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count, p_data => l_msg_data);
1605: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1602: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);

1598: EXCEPTION
1599: WHEN OTHERS THEN
1600: FND_MESSAGE.SET_NAME('GMO','FND_AS_UNEXPECTED_ERROR');
1601: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1602: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
1603: FND_MSG_PUB.ADD;
1604: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count, p_data => l_msg_data);
1605: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1606: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.GMO_CBR_GRP.PROCESS_INSTR_XML', FALSE);

Line 1702: FND_MESSAGE.SET_NAME('GMO','GMO_DEL_PROG_ROW_PARAMETER_ERR');

1698: WHERE EVENT = P_EVENT
1699: AND EVENT_KEY = P_EVENT_KEY;
1700: X_RETURN_STATUS := 'S';
1701: ELSE
1702: FND_MESSAGE.SET_NAME('GMO','GMO_DEL_PROG_ROW_PARAMETER_ERR');
1703: FND_MSG_PUB.ADD;
1704: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1705: X_RETURN_STATUS := 'E';
1706: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then