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 GMO_CBR_GRP

Line 1: PACKAGE BODY GMO_CBR_GRP AS

1: PACKAGE BODY GMO_CBR_GRP AS
2: /* $Header: GMOGCBRB.pls 120.21.12020000.3 2013/02/12 06:34:56 rborpatl ship $ */
3:
4: PROCEDURE ENABLE_CBR (ERRBUF OUT NOCOPY VARCHAR2,RETCODE OUT NOCOPY VARCHAR2) IS
5: -- Local Variables

Line 29: and b.RULE_FUNCTION in ('GMO_CBR_GRP.PROCESS_EVENT','GMO_CBR_GRP.PROCESS_INSTANCE_INSTR_SET');

25: FROM
26: wf_events_vl a,
27: wf_event_subscriptions b
28: WHERE a.GUID = b.EVENT_FILTER_GUID
29: and b.RULE_FUNCTION in ('GMO_CBR_GRP.PROCESS_EVENT','GMO_CBR_GRP.PROCESS_INSTANCE_INSTR_SET');
30:
31: --
32: -- ERES event subscriptions owned by product teams where GMO subscription exists
33: --

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 716: 'gmo.plsql.GMO_CBR_GRP.PROCESS_EVENT',

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
718: );
719: end if;
720:

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 729: 'gmo.plsql.GMO_CBR_GRP.PROCESS_EVENT',

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
731: );
732: end if;
733: --

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 895: 'gmo.plsql.GMO_CBR_GRP.PROCESS_EVENT',

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
897: );
898: end if;
899:

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 1001: 'gmo.plsql.GMO_CBR_GRP.PROCESS_EVENT',

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
1003: );
1004: end if;
1005: l_batch_prog_rec.PROGRESSION_ID := NULL;

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 1049: 'gmo.plsql.GMO_CBR_GRP.PROCESS_EVENT',

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
1051: );
1052: end if;
1053: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);

Line 1053: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);

1049: 'gmo.plsql.GMO_CBR_GRP.PROCESS_EVENT',
1050: FALSE
1051: );
1052: end if;
1053: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
1054: wf_event.AddParameterToList('BATCH_PROGRESSION_ID', l_batch_progression_id,p_event.Parameter_List);
1055: return 'SUCCESS';
1056: END;
1057:

Line 1117: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);

1113: l_batch_prog_rec.ERECORD_ID := NULL;
1114: l_batch_prog_rec.XML_EREC := NULL;
1115: l_batch_prog_rec.STATUS := 'PENDING';
1116: l_batch_prog_rec.INCLUDED_IN_CBR := 'N';
1117: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
1118: OPEN GET_STEP_DETAILS ;
1119: LOOP
1120: FETCH GET_STEP_DETAILS INTO STEP_DETAILS_REC;
1121: EXIT WHEN GET_STEP_DETAILS%NOTFOUND;

Line 1154: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);

1150: l_batch_prog_rec.ERECORD_ID := NULL;
1151: l_batch_prog_rec.XML_EREC := NULL;
1152: l_batch_prog_rec.STATUS := 'PENDING';
1153: l_batch_prog_rec.INCLUDED_IN_CBR := 'N';
1154: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
1155: l_batch_prog_rec.PROGRESSION_ID := NULL;
1156: l_batch_prog_rec.BATCH_ID := P_BATCH_ID;
1157: l_batch_prog_rec.BATCHSTEP_ID := STEP_DETAILS_REC.BATCHSTEP_ID;
1158: l_batch_prog_rec.MATERIAL_LINE_ID := NULL;

Line 1184: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);

1180: l_batch_prog_rec.ERECORD_ID := NULL;
1181: l_batch_prog_rec.XML_EREC := NULL;
1182: l_batch_prog_rec.STATUS := 'PENDING';
1183: l_batch_prog_rec.INCLUDED_IN_CBR := 'N';
1184: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
1185: l_batch_prog_rec.PROGRESSION_ID := NULL;
1186: l_batch_prog_rec.BATCH_ID := P_BATCH_ID;
1187: l_batch_prog_rec.BATCHSTEP_ID := STEP_DETAILS_REC.BATCHSTEP_ID;
1188: l_batch_prog_rec.MATERIAL_LINE_ID := NULL;

Line 1214: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);

1210: l_batch_prog_rec.ERECORD_ID := NULL;
1211: l_batch_prog_rec.XML_EREC := NULL;
1212: l_batch_prog_rec.STATUS := 'PENDING';
1213: l_batch_prog_rec.INCLUDED_IN_CBR := 'N';
1214: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
1215: END LOOP;
1216: CLOSE GET_STEP_DETAILS;
1217: l_batch_prog_rec.PROGRESSION_ID := NULL;
1218: l_batch_prog_rec.BATCH_ID := P_BATCH_ID;

Line 1246: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);

1242: l_batch_prog_rec.ERECORD_ID := NULL;
1243: l_batch_prog_rec.XML_EREC := NULL;
1244: l_batch_prog_rec.STATUS := 'PENDING';
1245: l_batch_prog_rec.INCLUDED_IN_CBR := 'N';
1246: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
1247: l_batch_prog_rec.PROGRESSION_ID := NULL;
1248: l_batch_prog_rec.BATCH_ID := P_BATCH_ID;
1249: l_batch_prog_rec.BATCHSTEP_ID := NULL;
1250: l_batch_prog_rec.MATERIAL_LINE_ID := NULL;

Line 1277: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);

1273: l_batch_prog_rec.XML_EREC := NULL;
1274: l_batch_prog_rec.STATUS := 'PENDING';
1275: l_batch_prog_rec.INCLUDED_IN_CBR := 'N';
1276: l_batch_prog_rec.compare_xml:='N';
1277: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);
1278: EXCEPTION
1279: WHEN OTHERS THEN
1280: null;
1281: END;

Line 1596: gmo_cbr_grp.insert_event(l_batch_prog_rec,l_batch_progression_id);

1592: l_batch_prog_rec.XML_EREC := l_event_data;
1593: l_batch_prog_rec.STATUS := P_BATCHPROGRESSION_STATUS;
1594: l_batch_prog_rec.INCLUDED_IN_CBR := 'N';
1595: l_batch_prog_rec.COMPARE_XML := 'N';
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');

Line 1606: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.GMO_CBR_GRP.PROCESS_INSTR_XML', FALSE);

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);
1607: end if;
1608: END PROCESS_INSTR_XML;
1609:
1610: FUNCTION PROCESS_INSTANCE_INSTR_SET(P_SUBSCRIPTION_GUID IN RAW, P_EVENT IN OUT NOCOPY WF_EVENT_T) RETURN VARCHAR2 IS

Line 1708: 'gmo.plsql.GMO_CBR_GRP.DELETE_PROGRESSION_ROW',

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
1707: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,
1708: 'gmo.plsql.GMO_CBR_GRP.DELETE_PROGRESSION_ROW',
1709: FALSE
1710: );
1711: end if;
1712: END IF;

Line 1718: END GMO_CBR_GRP;

1714: END DELETE_PROGRESSION_ROW;
1715:
1716:
1717:
1718: END GMO_CBR_GRP;