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.BOM_BUSINESS_EVENT_PKG dependencies on BOM_BUSINESS_EVENT_PKG

Line 1: package body Bom_Business_Event_PKG as

1: package body Bom_Business_Event_PKG as
2: /* $Header: BOMSBESB.pls 120.9.12010000.4 2009/12/24 08:25:18 gliang ship $ */
3: /*==========================================================================+
4: | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5: | All rights reserved. |

Line 50: raise Bom_Business_Event_PKG.G_SUBSCRIPTION_EXC;

46: p_message_name => 'EGO_EVENT_SUBSCR'
47: ,p_application_id => 'EGO'
48: ,p_message_type => FND_API.G_RET_STS_ERROR
49: ,p_addto_fnd_stack => 'Y');
50: raise Bom_Business_Event_PKG.G_SUBSCRIPTION_EXC;
51:
52: END Raise_Event;
53:
54: /*

Line 88: Bom_Business_Event_PKG.Add_Parameter_To_List

84: ,p_Event_Name IN VARCHAR2)
85: IS
86: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
87: BEGIN
88: Bom_Business_Event_PKG.Add_Parameter_To_List
89: ( p_parameter_name => 'INVENTORY_ITEM_ID'
90: ,p_value => p_inventory_item_id
91: ,p_parameter_list => l_parameter_list);
92:

Line 93: Bom_Business_Event_PKG.Add_Parameter_To_List

89: ( p_parameter_name => 'INVENTORY_ITEM_ID'
90: ,p_value => p_inventory_item_id
91: ,p_parameter_list => l_parameter_list);
92:
93: Bom_Business_Event_PKG.Add_Parameter_To_List
94: (p_parameter_name => 'ORGANIZATION_ID'
95: ,p_value => p_organization_id
96: ,p_parameter_list => l_parameter_list);
97:

Line 98: Bom_Business_Event_PKG.Add_Parameter_To_List

94: (p_parameter_name => 'ORGANIZATION_ID'
95: ,p_value => p_organization_id
96: ,p_parameter_list => l_parameter_list);
97:
98: Bom_Business_Event_PKG.Add_Parameter_To_List
99: (p_parameter_name => 'ITEM_NAME'
100: ,p_value => p_item_name
101: ,p_parameter_list => l_parameter_list);
102:

Line 103: Bom_Business_Event_PKG.Add_Parameter_To_List

99: (p_parameter_name => 'ITEM_NAME'
100: ,p_value => p_item_name
101: ,p_parameter_list => l_parameter_list);
102:
103: Bom_Business_Event_PKG.Add_Parameter_To_List
104: (p_parameter_name => 'ITEM_DESCRIPTION'
105: ,p_value => p_item_description
106: ,p_parameter_list => l_parameter_list);
107:

Line 110: Bom_Business_Event_PKG.Raise_event

106: ,p_parameter_list => l_parameter_list);
107:
108: --bug:5245403 Create a file with time precision of fraction of seconds to avoid
109: --overwrite in case of multiple events firing within a second.
110: Bom_Business_Event_PKG.Raise_event
111: ( p_Event_Name => p_Event_Name
112: ,p_Event_Key => to_char(systimestamp, 'dd-mon-yyyy hh24:mi:ss:ff')
113: ,p_parameter_list => l_parameter_list);
114:

Line 132: Bom_Business_Event_PKG.Add_Parameter_To_List

128: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
129:
130: BEGIN
131:
132: Bom_Business_Event_PKG.Add_Parameter_To_List
133: ( p_parameter_name => 'OBJ_NAME'
134: ,p_value => p_obj_name
135: ,p_parameter_list => l_parameter_list);
136:

Line 137: Bom_Business_Event_PKG.Add_Parameter_To_List

133: ( p_parameter_name => 'OBJ_NAME'
134: ,p_value => p_obj_name
135: ,p_parameter_list => l_parameter_list);
136:
137: Bom_Business_Event_PKG.Add_Parameter_To_List
138: (p_parameter_name => 'PK1_VALUE'
139: ,p_value => p_pk1_value
140: ,p_parameter_list => l_parameter_list);
141:

Line 142: Bom_Business_Event_PKG.Add_Parameter_To_List

138: (p_parameter_name => 'PK1_VALUE'
139: ,p_value => p_pk1_value
140: ,p_parameter_list => l_parameter_list);
141:
142: Bom_Business_Event_PKG.Add_Parameter_To_List
143: (p_parameter_name => 'PK2_VALUE'
144: ,p_value => p_pk2_value
145: ,p_parameter_list => l_parameter_list);
146:

Line 147: Bom_Business_Event_PKG.Add_Parameter_To_List

143: (p_parameter_name => 'PK2_VALUE'
144: ,p_value => p_pk2_value
145: ,p_parameter_list => l_parameter_list);
146:
147: Bom_Business_Event_PKG.Add_Parameter_To_List
148: (p_parameter_name => 'STRUCTURE_NAME'
149: ,p_value => nvl(p_structure_name,'PRIMARY')
150: ,p_parameter_list => l_parameter_list);
151:

Line 152: Bom_Business_Event_PKG.Add_Parameter_To_List

148: (p_parameter_name => 'STRUCTURE_NAME'
149: ,p_value => nvl(p_structure_name,'PRIMARY')
150: ,p_parameter_list => l_parameter_list);
151:
152: Bom_Business_Event_PKG.Add_Parameter_To_List
153: (p_parameter_name => 'ORGANIZATION_ID'
154: ,p_value => p_organization_id
155: ,p_parameter_list => l_parameter_list);
156:

Line 158: Bom_Business_Event_PKG.Add_Parameter_To_List -- Added for bug#8266922

154: ,p_value => p_organization_id
155: ,p_parameter_list => l_parameter_list);
156:
157:
158: Bom_Business_Event_PKG.Add_Parameter_To_List -- Added for bug#8266922
159: (p_parameter_name => 'REVISED_ITEM_SEQUENCE_ID'
160: ,p_value => p_revised_item_sequence_id
161: ,p_parameter_list => l_parameter_list);
162:

Line 163: Bom_Business_Event_PKG.Raise_event

159: (p_parameter_name => 'REVISED_ITEM_SEQUENCE_ID'
160: ,p_value => p_revised_item_sequence_id
161: ,p_parameter_list => l_parameter_list);
162:
163: Bom_Business_Event_PKG.Raise_event
164: ( p_Event_Name => p_Event_Name
165: ,p_Event_Key => to_char(systimestamp, 'dd-mon-yyyy hh24:mi:ss:ff')
166: ,p_parameter_list => l_parameter_list);
167: END;

Line 184: Bom_Business_Event_PKG.Add_Parameter_To_List

180: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
181:
182: BEGIN
183:
184: Bom_Business_Event_PKG.Add_Parameter_To_List
185: ( p_parameter_name => 'OBJ_NAME'
186: ,p_value => p_obj_name
187: ,p_parameter_list => l_parameter_list);
188:

Line 189: Bom_Business_Event_PKG.Add_Parameter_To_List

185: ( p_parameter_name => 'OBJ_NAME'
186: ,p_value => p_obj_name
187: ,p_parameter_list => l_parameter_list);
188:
189: Bom_Business_Event_PKG.Add_Parameter_To_List
190: (p_parameter_name => 'PK1_VALUE'
191: ,p_value => p_pk1_value
192: ,p_parameter_list => l_parameter_list);
193:

Line 194: Bom_Business_Event_PKG.Add_Parameter_To_List

190: (p_parameter_name => 'PK1_VALUE'
191: ,p_value => p_pk1_value
192: ,p_parameter_list => l_parameter_list);
193:
194: Bom_Business_Event_PKG.Add_Parameter_To_List
195: (p_parameter_name => 'PK2_VALUE'
196: ,p_value => p_pk2_value
197: ,p_parameter_list => l_parameter_list);
198:

Line 199: Bom_Business_Event_PKG.Add_Parameter_To_List

195: (p_parameter_name => 'PK2_VALUE'
196: ,p_value => p_pk2_value
197: ,p_parameter_list => l_parameter_list);
198:
199: Bom_Business_Event_PKG.Add_Parameter_To_List
200: (p_parameter_name => 'BILL_SEQUENCE_ID'
201: ,p_value => p_bill_sequence_id
202: ,p_parameter_list => l_parameter_list);
203:

Line 204: Bom_Business_Event_PKG.Add_Parameter_To_List

200: (p_parameter_name => 'BILL_SEQUENCE_ID'
201: ,p_value => p_bill_sequence_id
202: ,p_parameter_list => l_parameter_list);
203:
204: Bom_Business_Event_PKG.Add_Parameter_To_List
205: (p_parameter_name => 'ORGANIZATION_ID'
206: ,p_value => p_organization_id
207: ,p_parameter_list => l_parameter_list);
208:

Line 209: Bom_Business_Event_PKG.Add_Parameter_To_List

205: (p_parameter_name => 'ORGANIZATION_ID'
206: ,p_value => p_organization_id
207: ,p_parameter_list => l_parameter_list);
208:
209: Bom_Business_Event_PKG.Add_Parameter_To_List
210: (p_parameter_name => 'COMPONENT_ITEM_NAME'
211: ,p_value => p_comp_item_name
212: ,p_parameter_list => l_parameter_list);
213:

Line 214: Bom_Business_Event_PKG.Add_Parameter_To_List

210: (p_parameter_name => 'COMPONENT_ITEM_NAME'
211: ,p_value => p_comp_item_name
212: ,p_parameter_list => l_parameter_list);
213:
214: Bom_Business_Event_PKG.Add_Parameter_To_List
215: (p_parameter_name => 'COMPONENT_ITEM_DESCRIPTION'
216: ,p_value => p_comp_description
217: ,p_parameter_list => l_parameter_list);
218:

Line 219: Bom_Business_Event_PKG.Raise_event

215: (p_parameter_name => 'COMPONENT_ITEM_DESCRIPTION'
216: ,p_value => p_comp_description
217: ,p_parameter_list => l_parameter_list);
218:
219: Bom_Business_Event_PKG.Raise_event
220: ( p_Event_Name => p_Event_Name
221: ,p_Event_Key => to_char(systimestamp, 'dd-mon-yyyy hh24:mi:ss:ff')
222: ,p_parameter_list => l_parameter_list);
223: END;

Line 249: Bom_Business_Event_PKG.Add_Parameter_To_List

245: SELECT common_bill_sequence_id INTO l_common_bill_sequence_id
246: FROM bom_structures_b
247: WHERE bill_sequence_id = p_Event_Entity_Parent_Id;
248:
249: Bom_Business_Event_PKG.Add_Parameter_To_List
250: ( p_parameter_name => 'COMMON_BILL_SEQUENCE_ID'
251: ,p_value => l_common_bill_sequence_id
252: ,p_parameter_list => l_parameter_list);
253:

Line 254: Bom_Business_Event_PKG.Add_Parameter_To_List

250: ( p_parameter_name => 'COMMON_BILL_SEQUENCE_ID'
251: ,p_value => l_common_bill_sequence_id
252: ,p_parameter_list => l_parameter_list);
253:
254: Bom_Business_Event_PKG.Add_Parameter_To_List
255: ( p_parameter_name => 'EVENT_TYPE'
256: ,p_value => p_Event_Load_Type
257: ,p_parameter_list => l_parameter_list);
258:

Line 259: Bom_Business_Event_PKG.Add_Parameter_To_List

255: ( p_parameter_name => 'EVENT_TYPE'
256: ,p_value => p_Event_Load_Type
257: ,p_parameter_list => l_parameter_list);
258:
259: Bom_Business_Event_PKG.Add_Parameter_To_List
260: (p_parameter_name => 'REQUEST_IDENTIFIER'
261: ,p_value => p_Request_Identifier
262: ,p_parameter_list => l_parameter_list);
263:

Line 264: Bom_Business_Event_PKG.Add_Parameter_To_List

260: (p_parameter_name => 'REQUEST_IDENTIFIER'
261: ,p_value => p_Request_Identifier
262: ,p_parameter_list => l_parameter_list);
263:
264: Bom_Business_Event_PKG.Add_Parameter_To_List
265: (p_parameter_name => 'BATCH_IDENTIFIER'
266: ,p_value => p_Batch_Identifier
267: ,p_parameter_list => l_parameter_list);
268:

Line 269: Bom_Business_Event_PKG.Add_Parameter_To_List

265: (p_parameter_name => 'BATCH_IDENTIFIER'
266: ,p_value => p_Batch_Identifier
267: ,p_parameter_list => l_parameter_list);
268:
269: Bom_Business_Event_PKG.Add_Parameter_To_List
270: (p_parameter_name => 'EVENT_ENTITY_NAME'
271: ,p_value => p_Event_Entity_Name
272: ,p_parameter_list => l_parameter_list);
273:

Line 274: Bom_Business_Event_PKG.Add_Parameter_To_List

270: (p_parameter_name => 'EVENT_ENTITY_NAME'
271: ,p_value => p_Event_Entity_Name
272: ,p_parameter_list => l_parameter_list);
273:
274: Bom_Business_Event_PKG.Add_Parameter_To_List
275: (p_parameter_name => 'EVENT_ENTITY_PARENT_ID'
276: ,p_value => p_Event_Entity_Parent_Id
277: ,p_parameter_list => l_parameter_list);
278:

Line 279: Bom_Business_Event_PKG.Add_Parameter_To_List

275: (p_parameter_name => 'EVENT_ENTITY_PARENT_ID'
276: ,p_value => p_Event_Entity_Parent_Id
277: ,p_parameter_list => l_parameter_list);
278:
279: Bom_Business_Event_PKG.Add_Parameter_To_List
280: (p_parameter_name => 'LAST_UPDATE_DATE'
281: ,p_value => to_char(p_last_update_date,'dd-mon-yyyy hh24:mi:ss')
282: ,p_parameter_list => l_parameter_list);
283:

Line 284: Bom_Business_Event_PKG.Add_Parameter_To_List

280: (p_parameter_name => 'LAST_UPDATE_DATE'
281: ,p_value => to_char(p_last_update_date,'dd-mon-yyyy hh24:mi:ss')
282: ,p_parameter_list => l_parameter_list);
283:
284: Bom_Business_Event_PKG.Add_Parameter_To_List
285: (p_parameter_name => 'LAST_UPDATED_BY'
286: ,p_value => p_last_updated_by
287: ,p_parameter_list => l_parameter_list);
288:

Line 291: Bom_Business_Event_PKG.Add_Parameter_To_List

287: ,p_parameter_list => l_parameter_list);
288:
289: IF (p_creation_date IS NOT NULL)
290: THEN
291: Bom_Business_Event_PKG.Add_Parameter_To_List
292: (p_parameter_name => 'CREATION_DATE'
293: ,p_value => to_char(p_creation_date,'dd-mon-yyyy hh24:mi:ss')
294: ,p_parameter_list => l_parameter_list);
295:

Line 296: Bom_Business_Event_PKG.Add_Parameter_To_List

292: (p_parameter_name => 'CREATION_DATE'
293: ,p_value => to_char(p_creation_date,'dd-mon-yyyy hh24:mi:ss')
294: ,p_parameter_list => l_parameter_list);
295:
296: Bom_Business_Event_PKG.Add_Parameter_To_List
297: (p_parameter_name => 'CREATED_BY'
298: ,p_value => p_created_by
299: ,p_parameter_list => l_parameter_list);
300: END IF;

Line 302: Bom_Business_Event_PKG.Raise_event

298: ,p_value => p_created_by
299: ,p_parameter_list => l_parameter_list);
300: END IF;
301:
302: Bom_Business_Event_PKG.Raise_event
303: ( p_Event_Name => p_Event_Name
304: ,p_Event_Key => to_char(systimestamp, 'dd-mon-yyyy hh24:mi:ss:ff')
305: ,p_parameter_list => l_parameter_list);
306: END Raise_Bill_Event;

Line 324: Bom_Business_Event_PKG.Add_Parameter_To_List

320: )
321: IS
322: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
323: BEGIN
324: Bom_Business_Event_PKG.Add_Parameter_To_List
325: ( p_parameter_name => 'EVENT_TYPE'
326: ,p_value => p_Event_Load_Type
327: ,p_parameter_list => l_parameter_list);
328:

Line 329: Bom_Business_Event_PKG.Add_Parameter_To_List

325: ( p_parameter_name => 'EVENT_TYPE'
326: ,p_value => p_Event_Load_Type
327: ,p_parameter_list => l_parameter_list);
328:
329: Bom_Business_Event_PKG.Add_Parameter_To_List
330: (p_parameter_name => 'REQUEST_IDENTIFIER'
331: ,p_value => p_Request_Identifier
332: ,p_parameter_list => l_parameter_list);
333:

Line 334: Bom_Business_Event_PKG.Add_Parameter_To_List

330: (p_parameter_name => 'REQUEST_IDENTIFIER'
331: ,p_value => p_Request_Identifier
332: ,p_parameter_list => l_parameter_list);
333:
334: Bom_Business_Event_PKG.Add_Parameter_To_List
335: (p_parameter_name => 'BATCH_IDENTIFIER'
336: ,p_value => p_Batch_Identifier
337: ,p_parameter_list => l_parameter_list);
338:

Line 339: Bom_Business_Event_PKG.Add_Parameter_To_List

335: (p_parameter_name => 'BATCH_IDENTIFIER'
336: ,p_value => p_Batch_Identifier
337: ,p_parameter_list => l_parameter_list);
338:
339: Bom_Business_Event_PKG.Add_Parameter_To_List
340: (p_parameter_name => 'EVENT_ENTITY_NAME'
341: ,p_value => p_Event_Entity_Name
342: ,p_parameter_list => l_parameter_list);
343:

Line 344: Bom_Business_Event_PKG.Add_Parameter_To_List

340: (p_parameter_name => 'EVENT_ENTITY_NAME'
341: ,p_value => p_Event_Entity_Name
342: ,p_parameter_list => l_parameter_list);
343:
344: Bom_Business_Event_PKG.Add_Parameter_To_List
345: (p_parameter_name => 'LAST_UPDATE_DATE'
346: ,p_value => to_char(p_last_update_date,'dd-mon-yyyy hh24:mi:ss')
347: ,p_parameter_list => l_parameter_list);
348:

Line 349: Bom_Business_Event_PKG.Add_Parameter_To_List

345: (p_parameter_name => 'LAST_UPDATE_DATE'
346: ,p_value => to_char(p_last_update_date,'dd-mon-yyyy hh24:mi:ss')
347: ,p_parameter_list => l_parameter_list);
348:
349: Bom_Business_Event_PKG.Add_Parameter_To_List
350: (p_parameter_name => 'LAST_UPDATED_BY'
351: ,p_value => p_last_updated_by
352: ,p_parameter_list => l_parameter_list);
353:

Line 356: Bom_Business_Event_PKG.Add_Parameter_To_List

352: ,p_parameter_list => l_parameter_list);
353:
354: IF (p_creation_date IS NOT NULL)
355: THEN
356: Bom_Business_Event_PKG.Add_Parameter_To_List
357: (p_parameter_name => 'CREATION_DATE'
358: ,p_value => to_char(p_creation_date,'dd-mon-yyyy hh24:mi:ss')
359: ,p_parameter_list => l_parameter_list);
360:

Line 361: Bom_Business_Event_PKG.Add_Parameter_To_List

357: (p_parameter_name => 'CREATION_DATE'
358: ,p_value => to_char(p_creation_date,'dd-mon-yyyy hh24:mi:ss')
359: ,p_parameter_list => l_parameter_list);
360:
361: Bom_Business_Event_PKG.Add_Parameter_To_List
362: (p_parameter_name => 'CREATED_BY'
363: ,p_value => p_created_by
364: ,p_parameter_list => l_parameter_list);
365: END IF;

Line 368: Bom_Business_Event_PKG.Raise_event

364: ,p_parameter_list => l_parameter_list);
365: END IF;
366:
367:
368: Bom_Business_Event_PKG.Raise_event
369: ( p_Event_Name => p_Event_Name
370: ,p_Event_Key => to_char(systimestamp, 'dd-mon-yyyy hh24:mi:ss:ff')
371: ,p_parameter_list => l_parameter_list);
372: END Raise_Bill_Event;

Line 404: Bom_Business_Event_PKG.Add_Parameter_To_List

400: SELECT common_bill_sequence_id INTO l_common_bill_sequence_id
401: FROM bom_structures_b
402: WHERE bill_sequence_id = p_Event_Entity_Parent_Id;
403:
404: Bom_Business_Event_PKG.Add_Parameter_To_List
405: ( p_parameter_name => 'COMMON_BILL_SEQUENCE_ID'
406: ,p_value => l_common_bill_sequence_id
407: ,p_parameter_list => l_parameter_list);
408:

Line 409: Bom_Business_Event_PKG.Add_Parameter_To_List

405: ( p_parameter_name => 'COMMON_BILL_SEQUENCE_ID'
406: ,p_value => l_common_bill_sequence_id
407: ,p_parameter_list => l_parameter_list);
408:
409: Bom_Business_Event_PKG.Add_Parameter_To_List
410: ( p_parameter_name => 'OBJ_NAME'
411: ,p_value => p_obj_name
412: ,p_parameter_list => l_parameter_list);
413:

Line 414: Bom_Business_Event_PKG.Add_Parameter_To_List

410: ( p_parameter_name => 'OBJ_NAME'
411: ,p_value => p_obj_name
412: ,p_parameter_list => l_parameter_list);
413:
414: Bom_Business_Event_PKG.Add_Parameter_To_List
415: (p_parameter_name => 'PK1_VALUE'
416: ,p_value => p_pk1_value
417: ,p_parameter_list => l_parameter_list);
418:

Line 419: Bom_Business_Event_PKG.Add_Parameter_To_List

415: (p_parameter_name => 'PK1_VALUE'
416: ,p_value => p_pk1_value
417: ,p_parameter_list => l_parameter_list);
418:
419: Bom_Business_Event_PKG.Add_Parameter_To_List
420: (p_parameter_name => 'PK2_VALUE'
421: ,p_value => p_pk2_value
422: ,p_parameter_list => l_parameter_list);
423:

Line 424: Bom_Business_Event_PKG.Add_Parameter_To_List

420: (p_parameter_name => 'PK2_VALUE'
421: ,p_value => p_pk2_value
422: ,p_parameter_list => l_parameter_list);
423:
424: Bom_Business_Event_PKG.Add_Parameter_To_List
425: (p_parameter_name => 'STRUCTURE_NAME'
426: ,p_value => nvl(p_structure_name,'PRIMARY')
427: ,p_parameter_list => l_parameter_list);
428:

Line 429: Bom_Business_Event_PKG.Add_Parameter_To_List

425: (p_parameter_name => 'STRUCTURE_NAME'
426: ,p_value => nvl(p_structure_name,'PRIMARY')
427: ,p_parameter_list => l_parameter_list);
428:
429: Bom_Business_Event_PKG.Add_Parameter_To_List
430: (p_parameter_name => 'ORGANIZATION_ID'
431: ,p_value => p_organization_id
432: ,p_parameter_list => l_parameter_list);
433:

Line 434: Bom_Business_Event_PKG.Add_Parameter_To_List

430: (p_parameter_name => 'ORGANIZATION_ID'
431: ,p_value => p_organization_id
432: ,p_parameter_list => l_parameter_list);
433:
434: Bom_Business_Event_PKG.Add_Parameter_To_List
435: ( p_parameter_name => 'EVENT_TYPE'
436: ,p_value => p_Event_Load_Type
437: ,p_parameter_list => l_parameter_list);
438:

Line 439: Bom_Business_Event_PKG.Add_Parameter_To_List

435: ( p_parameter_name => 'EVENT_TYPE'
436: ,p_value => p_Event_Load_Type
437: ,p_parameter_list => l_parameter_list);
438:
439: Bom_Business_Event_PKG.Add_Parameter_To_List
440: (p_parameter_name => 'EVENT_ENTITY_NAME'
441: ,p_value => p_Event_Entity_Name
442: ,p_parameter_list => l_parameter_list);
443:

Line 444: Bom_Business_Event_PKG.Add_Parameter_To_List

440: (p_parameter_name => 'EVENT_ENTITY_NAME'
441: ,p_value => p_Event_Entity_Name
442: ,p_parameter_list => l_parameter_list);
443:
444: Bom_Business_Event_PKG.Add_Parameter_To_List
445: (p_parameter_name => 'EVENT_ENTITY_PARENT_ID'
446: ,p_value => p_Event_Entity_Parent_Id
447: ,p_parameter_list => l_parameter_list);
448:

Line 451: Bom_Business_Event_PKG.Add_Parameter_To_List

447: ,p_parameter_list => l_parameter_list);
448:
449: IF(p_component_seq_id IS NOT NULL)
450: THEN
451: Bom_Business_Event_PKG.Add_Parameter_To_List
452: (p_parameter_name => 'COMPONENT_SEQUENCE_ID'
453: ,p_value => p_component_seq_id
454: ,p_parameter_list => l_parameter_list);
455: END IF;

Line 457: Bom_Business_Event_PKG.Add_Parameter_To_List

453: ,p_value => p_component_seq_id
454: ,p_parameter_list => l_parameter_list);
455: END IF;
456:
457: Bom_Business_Event_PKG.Add_Parameter_To_List
458: (p_parameter_name => 'LAST_UPDATE_DATE'
459: ,p_value => to_char(p_last_update_date,'dd-mon-yyyy hh24:mi:ss')
460: ,p_parameter_list => l_parameter_list);
461:

Line 462: Bom_Business_Event_PKG.Add_Parameter_To_List

458: (p_parameter_name => 'LAST_UPDATE_DATE'
459: ,p_value => to_char(p_last_update_date,'dd-mon-yyyy hh24:mi:ss')
460: ,p_parameter_list => l_parameter_list);
461:
462: Bom_Business_Event_PKG.Add_Parameter_To_List
463: (p_parameter_name => 'LAST_UPDATED_BY'
464: ,p_value => p_last_updated_by
465: ,p_parameter_list => l_parameter_list);
466:

Line 469: Bom_Business_Event_PKG.Add_Parameter_To_List

465: ,p_parameter_list => l_parameter_list);
466:
467: IF (p_creation_date IS NOT NULL)
468: THEN
469: Bom_Business_Event_PKG.Add_Parameter_To_List
470: (p_parameter_name => 'CREATION_DATE'
471: ,p_value => to_char(p_creation_date,'dd-mon-yyyy hh24:mi:ss')
472: ,p_parameter_list => l_parameter_list);
473:

Line 474: Bom_Business_Event_PKG.Add_Parameter_To_List

470: (p_parameter_name => 'CREATION_DATE'
471: ,p_value => to_char(p_creation_date,'dd-mon-yyyy hh24:mi:ss')
472: ,p_parameter_list => l_parameter_list);
473:
474: Bom_Business_Event_PKG.Add_Parameter_To_List
475: (p_parameter_name => 'CREATED_BY'
476: ,p_value => p_created_by
477: ,p_parameter_list => l_parameter_list);
478: END IF;

Line 480: Bom_Business_Event_PKG.Raise_event

476: ,p_value => p_created_by
477: ,p_parameter_list => l_parameter_list);
478: END IF;
479:
480: Bom_Business_Event_PKG.Raise_event
481: ( p_Event_Name => p_Event_Name
482: ,p_Event_Key => to_char(systimestamp, 'dd-mon-yyyy hh24:mi:ss:ff')
483: ,p_parameter_list => l_parameter_list);
484: END;

Line 533: WHEN Bom_Business_Event_PKG.G_SUBSCRIPTION_EXC THEN

529:
530: p_msg_data := NULL;
531: p_return_status := FND_API.G_RET_STS_SUCCESS;
532: EXCEPTION
533: WHEN Bom_Business_Event_PKG.G_SUBSCRIPTION_EXC THEN
534: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: ERROR_HANDLER.Get_Message_List(l_message_list);
536: FOR i IN l_message_list.FIRST..l_message_list.LAST
537: LOOP

Line 555: Bom_Business_Event_PKG.Add_Parameter_To_List

551: IS
552: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
553: BEGIN
554:
555: Bom_Business_Event_PKG.Add_Parameter_To_List
556: ( p_parameter_name => 'EVENT_TYPE'
557: ,p_value => p_Event_Load_Type
558: ,p_parameter_list => l_parameter_list);
559:

Line 560: Bom_Business_Event_PKG.Add_Parameter_To_List

556: ( p_parameter_name => 'EVENT_TYPE'
557: ,p_value => p_Event_Load_Type
558: ,p_parameter_list => l_parameter_list);
559:
560: Bom_Business_Event_PKG.Add_Parameter_To_List
561: (p_parameter_name => 'REQUEST_IDENTIFIER'
562: ,p_value => p_Request_Identifier
563: ,p_parameter_list => l_parameter_list);
564:

Line 565: Bom_Business_Event_PKG.Add_Parameter_To_List

561: (p_parameter_name => 'REQUEST_IDENTIFIER'
562: ,p_value => p_Request_Identifier
563: ,p_parameter_list => l_parameter_list);
564:
565: Bom_Business_Event_PKG.Add_Parameter_To_List
566: (p_parameter_name => 'BATCH_IDENTIFIER'
567: ,p_value => p_Batch_Identifier
568: ,p_parameter_list => l_parameter_list);
569:

Line 570: Bom_Business_Event_PKG.Add_Parameter_To_List

566: (p_parameter_name => 'BATCH_IDENTIFIER'
567: ,p_value => p_Batch_Identifier
568: ,p_parameter_list => l_parameter_list);
569:
570: Bom_Business_Event_PKG.Add_Parameter_To_List
571: (p_parameter_name => 'EVENT_ENTITY_NAME'
572: ,p_value => p_Event_Entity_Name
573: ,p_parameter_list => l_parameter_list);
574:

Line 575: Bom_Business_Event_PKG.Add_Parameter_To_List

571: (p_parameter_name => 'EVENT_ENTITY_NAME'
572: ,p_value => p_Event_Entity_Name
573: ,p_parameter_list => l_parameter_list);
574:
575: Bom_Business_Event_PKG.Add_Parameter_To_List
576: (p_parameter_name => 'EVENT_ENTITY_PARENT_ID'
577: ,p_value => p_Event_Entity_Parent_Id
578: ,p_parameter_list => l_parameter_list);
579:

Line 580: Bom_Business_Event_PKG.Raise_event

576: (p_parameter_name => 'EVENT_ENTITY_PARENT_ID'
577: ,p_value => p_Event_Entity_Parent_Id
578: ,p_parameter_list => l_parameter_list);
579:
580: Bom_Business_Event_PKG.Raise_event
581: ( p_Event_Name => p_Event_Name
582: ,p_Event_Key => to_char(systimestamp, 'dd-mon-yyyy hh24:mi:ss:ff')
583: ,p_parameter_list => l_parameter_list);
584: END Raise_Component_Event;

Line 604: Bom_Business_Event_PKG.Add_Parameter_To_List

600: IS
601: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
602: BEGIN
603:
604: Bom_Business_Event_PKG.Add_Parameter_To_List
605: ( p_parameter_name => 'EVENT_TYPE'
606: ,p_value => p_Event_Load_Type
607: ,p_parameter_list => l_parameter_list);
608:

Line 609: Bom_Business_Event_PKG.Add_Parameter_To_List

605: ( p_parameter_name => 'EVENT_TYPE'
606: ,p_value => p_Event_Load_Type
607: ,p_parameter_list => l_parameter_list);
608:
609: Bom_Business_Event_PKG.Add_Parameter_To_List
610: (p_parameter_name => 'REQUEST_IDENTIFIER'
611: ,p_value => p_Request_Identifier
612: ,p_parameter_list => l_parameter_list);
613:

Line 614: Bom_Business_Event_PKG.Add_Parameter_To_List

610: (p_parameter_name => 'REQUEST_IDENTIFIER'
611: ,p_value => p_Request_Identifier
612: ,p_parameter_list => l_parameter_list);
613:
614: Bom_Business_Event_PKG.Add_Parameter_To_List
615: (p_parameter_name => 'BATCH_IDENTIFIER'
616: ,p_value => p_Batch_Identifier
617: ,p_parameter_list => l_parameter_list);
618:

Line 619: Bom_Business_Event_PKG.Add_Parameter_To_List

615: (p_parameter_name => 'BATCH_IDENTIFIER'
616: ,p_value => p_Batch_Identifier
617: ,p_parameter_list => l_parameter_list);
618:
619: Bom_Business_Event_PKG.Add_Parameter_To_List
620: (p_parameter_name => 'EVENT_ENTITY_NAME'
621: ,p_value => p_Event_Entity_Name
622: ,p_parameter_list => l_parameter_list);
623:

Line 624: Bom_Business_Event_PKG.Add_Parameter_To_List

620: (p_parameter_name => 'EVENT_ENTITY_NAME'
621: ,p_value => p_Event_Entity_Name
622: ,p_parameter_list => l_parameter_list);
623:
624: Bom_Business_Event_PKG.Add_Parameter_To_List
625: (p_parameter_name => 'LAST_UPDATE_DATE'
626: ,p_value => to_char(p_last_update_date,'dd-mon-yyyy hh24:mi:ss')
627: ,p_parameter_list => l_parameter_list);
628:

Line 630: Bom_Business_Event_PKG.Add_Parameter_To_List

626: ,p_value => to_char(p_last_update_date,'dd-mon-yyyy hh24:mi:ss')
627: ,p_parameter_list => l_parameter_list);
628:
629:
630: Bom_Business_Event_PKG.Add_Parameter_To_List
631: (p_parameter_name => 'LAST_UPDATED_BY'
632: ,p_value => p_last_updated_by
633: ,p_parameter_list => l_parameter_list);
634:

Line 637: Bom_Business_Event_PKG.Add_Parameter_To_List

633: ,p_parameter_list => l_parameter_list);
634:
635: IF (p_creation_date IS NOT NULL)
636: THEN
637: Bom_Business_Event_PKG.Add_Parameter_To_List
638: (p_parameter_name => 'CREATION_DATE'
639: ,p_value => to_char(p_creation_date,'dd-mon-yyyy hh24:mi:ss')
640: ,p_parameter_list => l_parameter_list);
641:

Line 642: Bom_Business_Event_PKG.Add_Parameter_To_List

638: (p_parameter_name => 'CREATION_DATE'
639: ,p_value => to_char(p_creation_date,'dd-mon-yyyy hh24:mi:ss')
640: ,p_parameter_list => l_parameter_list);
641:
642: Bom_Business_Event_PKG.Add_Parameter_To_List
643: (p_parameter_name => 'CREATED_BY'
644: ,p_value => p_created_by
645: ,p_parameter_list => l_parameter_list);
646: END IF;

Line 649: Bom_Business_Event_PKG.Raise_event

645: ,p_parameter_list => l_parameter_list);
646: END IF;
647:
648:
649: Bom_Business_Event_PKG.Raise_event
650: ( p_Event_Name => p_Event_Name
651: ,p_Event_Key => to_char(systimestamp, 'dd-mon-yyyy hh24:mi:ss:ff')
652: ,p_parameter_list => l_parameter_list);
653: END Raise_Component_Event;

Line 682: Bom_Business_Event_PKG.Add_Parameter_To_List

678: IS
679: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
680: BEGIN
681:
682: Bom_Business_Event_PKG.Add_Parameter_To_List
683: ( p_parameter_name => 'OBJ_NAME'
684: ,p_value => p_obj_name
685: ,p_parameter_list => l_parameter_list);
686:

Line 687: Bom_Business_Event_PKG.Add_Parameter_To_List

683: ( p_parameter_name => 'OBJ_NAME'
684: ,p_value => p_obj_name
685: ,p_parameter_list => l_parameter_list);
686:
687: Bom_Business_Event_PKG.Add_Parameter_To_List
688: (p_parameter_name => 'PK1_VALUE'
689: ,p_value => p_pk1_value
690: ,p_parameter_list => l_parameter_list);
691:

Line 692: Bom_Business_Event_PKG.Add_Parameter_To_List

688: (p_parameter_name => 'PK1_VALUE'
689: ,p_value => p_pk1_value
690: ,p_parameter_list => l_parameter_list);
691:
692: Bom_Business_Event_PKG.Add_Parameter_To_List
693: (p_parameter_name => 'PK2_VALUE'
694: ,p_value => p_pk2_value
695: ,p_parameter_list => l_parameter_list);
696:

Line 697: Bom_Business_Event_PKG.Add_Parameter_To_List

693: (p_parameter_name => 'PK2_VALUE'
694: ,p_value => p_pk2_value
695: ,p_parameter_list => l_parameter_list);
696:
697: Bom_Business_Event_PKG.Add_Parameter_To_List
698: (p_parameter_name => 'BILL_SEQUENCE_ID'
699: ,p_value => p_bill_sequence_id
700: ,p_parameter_list => l_parameter_list);
701:

Line 702: Bom_Business_Event_PKG.Add_Parameter_To_List

698: (p_parameter_name => 'BILL_SEQUENCE_ID'
699: ,p_value => p_bill_sequence_id
700: ,p_parameter_list => l_parameter_list);
701:
702: Bom_Business_Event_PKG.Add_Parameter_To_List
703: (p_parameter_name => 'ORGANIZATION_ID'
704: ,p_value => p_organization_id
705: ,p_parameter_list => l_parameter_list);
706:

Line 707: Bom_Business_Event_PKG.Add_Parameter_To_List

703: (p_parameter_name => 'ORGANIZATION_ID'
704: ,p_value => p_organization_id
705: ,p_parameter_list => l_parameter_list);
706:
707: Bom_Business_Event_PKG.Add_Parameter_To_List
708: (p_parameter_name => 'COMPONENT_ITEM_NAME'
709: ,p_value => p_comp_item_name
710: ,p_parameter_list => l_parameter_list);
711:

Line 713: Bom_Business_Event_PKG.Add_Parameter_To_List

709: ,p_value => p_comp_item_name
710: ,p_parameter_list => l_parameter_list);
711:
712: /* bug 5324805
713: Bom_Business_Event_PKG.Add_Parameter_To_List
714: (p_parameter_name => 'COMPONENT_ITEM_DESCRIPTION'
715: ,p_value => p_comp_description
716: ,p_parameter_list => l_parameter_list); */
717:

Line 718: Bom_Business_Event_PKG.Add_Parameter_To_List

714: (p_parameter_name => 'COMPONENT_ITEM_DESCRIPTION'
715: ,p_value => p_comp_description
716: ,p_parameter_list => l_parameter_list); */
717:
718: Bom_Business_Event_PKG.Add_Parameter_To_List
719: ( p_parameter_name => 'EVENT_TYPE'
720: ,p_value => p_Event_Load_Type
721: ,p_parameter_list => l_parameter_list);
722:

Line 723: Bom_Business_Event_PKG.Add_Parameter_To_List

719: ( p_parameter_name => 'EVENT_TYPE'
720: ,p_value => p_Event_Load_Type
721: ,p_parameter_list => l_parameter_list);
722:
723: Bom_Business_Event_PKG.Add_Parameter_To_List
724: (p_parameter_name => 'EVENT_ENTITY_NAME'
725: ,p_value => p_Event_Entity_Name
726: ,p_parameter_list => l_parameter_list);
727:

Line 728: Bom_Business_Event_PKG.Add_Parameter_To_List

724: (p_parameter_name => 'EVENT_ENTITY_NAME'
725: ,p_value => p_Event_Entity_Name
726: ,p_parameter_list => l_parameter_list);
727:
728: Bom_Business_Event_PKG.Add_Parameter_To_List
729: (p_parameter_name => 'EVENT_ENTITY_PARENT_ID'
730: ,p_value => p_Event_Entity_Parent_Id
731: ,p_parameter_list => l_parameter_list);
732:

Line 733: Bom_Business_Event_PKG.Add_Parameter_To_List

729: (p_parameter_name => 'EVENT_ENTITY_PARENT_ID'
730: ,p_value => p_Event_Entity_Parent_Id
731: ,p_parameter_list => l_parameter_list);
732:
733: Bom_Business_Event_PKG.Add_Parameter_To_List
734: (p_parameter_name => 'LAST_UPDATE_DATE'
735: ,p_value => to_char(p_last_update_date,'dd-mon-yyyy hh24:mi:ss')
736: ,p_parameter_list => l_parameter_list);
737:

Line 738: Bom_Business_Event_PKG.Add_Parameter_To_List

734: (p_parameter_name => 'LAST_UPDATE_DATE'
735: ,p_value => to_char(p_last_update_date,'dd-mon-yyyy hh24:mi:ss')
736: ,p_parameter_list => l_parameter_list);
737:
738: Bom_Business_Event_PKG.Add_Parameter_To_List
739: (p_parameter_name => 'LAST_UPDATED_BY'
740: ,p_value => p_last_updated_by
741: ,p_parameter_list => l_parameter_list);
742:

Line 745: Bom_Business_Event_PKG.Add_Parameter_To_List

741: ,p_parameter_list => l_parameter_list);
742:
743: IF (p_creation_date IS NOT NULL)
744: THEN
745: Bom_Business_Event_PKG.Add_Parameter_To_List
746: (p_parameter_name => 'CREATION_DATE'
747: ,p_value => to_char(p_creation_date,'dd-mon-yyyy hh24:mi:ss')
748: ,p_parameter_list => l_parameter_list);
749:

Line 750: Bom_Business_Event_PKG.Add_Parameter_To_List

746: (p_parameter_name => 'CREATION_DATE'
747: ,p_value => to_char(p_creation_date,'dd-mon-yyyy hh24:mi:ss')
748: ,p_parameter_list => l_parameter_list);
749:
750: Bom_Business_Event_PKG.Add_Parameter_To_List
751: (p_parameter_name => 'CREATED_BY'
752: ,p_value => p_created_by
753: ,p_parameter_list => l_parameter_list);
754: END IF;

Line 757: Bom_Business_Event_PKG.Raise_event

753: ,p_parameter_list => l_parameter_list);
754: END IF;
755:
756:
757: Bom_Business_Event_PKG.Raise_event
758: ( p_Event_Name => p_Event_Name
759: ,p_Event_Key => to_char(systimestamp, 'dd-mon-yyyy hh24:mi:ss:ff')
760: ,p_parameter_list => l_parameter_list);
761: END;

Line 811: WHEN Bom_Business_Event_PKG.G_SUBSCRIPTION_EXC THEN

807: p_msg_data := NULL;
808: p_return_status := FND_API.G_RET_STS_SUCCESS;
809:
810: EXCEPTION
811: WHEN Bom_Business_Event_PKG.G_SUBSCRIPTION_EXC THEN
812: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
813: ERROR_HANDLER.Get_Message_List(l_message_list);
814: FOR i IN l_message_list.FIRST..l_message_list.LAST
815: LOOP

Line 828: Bom_Business_Event_PKG.Add_Parameter_To_List

824: IS
825: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
826: BEGIN
827:
828: Bom_Business_Event_PKG.Add_Parameter_To_List
829: (p_parameter_name => 'REQUEST_IDENTIFIER'
830: ,p_value => p_Request_Identifier
831: ,p_parameter_list => l_parameter_list);
832:

Line 833: Bom_Business_Event_PKG.Raise_event

829: (p_parameter_name => 'REQUEST_IDENTIFIER'
830: ,p_value => p_Request_Identifier
831: ,p_parameter_list => l_parameter_list);
832:
833: Bom_Business_Event_PKG.Raise_event
834: ( p_Event_Name => p_Event_Name
835: ,p_Event_Key => to_char(systimestamp, 'dd-mon-yyyy hh24:mi:ss:ff')
836: ,p_parameter_list => l_parameter_list);
837: END Raise_Bill_Event;

Line 845: bom_business_event_pkg.add_parameter_to_list

841: ( p_copy_request_id IN NUMBER )
842: IS
843: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
844: BEGIN
845: bom_business_event_pkg.add_parameter_to_list
846: (p_parameter_name => 'COPY_REQUEST_ID'
847: ,p_value => p_copy_request_id
848: ,p_parameter_list => l_parameter_list
849: );

Line 850: bom_business_event_pkg.raise_event

846: (p_parameter_name => 'COPY_REQUEST_ID'
847: ,p_value => p_copy_request_id
848: ,p_parameter_list => l_parameter_list
849: );
850: bom_business_event_pkg.raise_event
851: ( p_Event_Name => G_STRUCTURE_CPY_COMPLETE_EVENT
852: ,p_Event_Key => to_char(systimestamp, 'dd-mon-yyyy hh24:mi:ss:ff')
853: ,p_parameter_list => l_parameter_list
854: );

Line 857: END Bom_Business_Event_PKG;

853: ,p_parameter_list => l_parameter_list
854: );
855: END raise_str_cpy_complete_event;
856:
857: END Bom_Business_Event_PKG;