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

Line 1: package body EGO_PUB_FWK_PK AS

1: package body EGO_PUB_FWK_PK AS
2: /* $Header: EGOPFWKB.pls 120.15.12020000.7 2013/05/22 09:02:28 qyou ship $*/
3:
4: /*----------------------------------------------------------------------------+
5: | Copyright (c) 2003 Oracle Corporation RedwoodShores, California, USA

Line 24: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_PUB_FWK_PK';

20: -- OUT :
21: -- End of comments
22: */
23:
24: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_PUB_FWK_PK';
25:
26:
27: --Start procedural declaration
28: PROCEDURE process_entities

Line 97: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'

93:
94: l_stmt_num := 0;
95: delete from Ego_Publication_Batch_GT;
96: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
97: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
98: ,p_message => 'Enter EGO_PUB_FWK_PK.add_derived_entities ... '
99: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
100:
101: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 98: ,p_message => 'Enter EGO_PUB_FWK_PK.add_derived_entities ... '

94: l_stmt_num := 0;
95: delete from Ego_Publication_Batch_GT;
96: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
97: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
98: ,p_message => 'Enter EGO_PUB_FWK_PK.add_derived_entities ... '
99: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
100:
101: x_return_status := FND_API.G_RET_STS_SUCCESS;
102:

Line 135: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'

131:
132: l_stmt_num := 10;
133:
134: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
135: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
136: ,p_message =>' i --' ||
137: ' pk1_value(i) --' ||
138: ' pk2_value(i) --' ||
139: ' pk3_value(i) --' ||

Line 158: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'

154: entity_type_id(i) := der_bat_ent_objs(i).entity_type_id;
155:
156:
157: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
158: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
159: ,p_message => i || ' --' ||
160: der_bat_ent_objs(i).pk1_value || ' --' ||
161: der_bat_ent_objs(i).pk2_value || ' --' ||
162: der_bat_ent_objs(i).pk3_value || ' --' ||

Line 208: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'

204: ,FND_GLOBAL.USER_ID
205: ,FND_GLOBAL.LOGIN_ID
206: );
207: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
208: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
209: ,p_message => 'lStmtNum=' || to_char(l_stmt_num)
210: ||' ' || sql%rowcount || ' rows are inserted into EGO_PUBLICATION_BATCH_GT.');
211:
212:

Line 229: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'

225:
226: delete from EGO_PUBLICATION_BATCH_GT;
227:
228: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
229: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
230: ,p_message => 'Exit EGO_PUB_FWK_PK.add_derived_entities successfully... '
231: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
232:
233: EXCEPTION

Line 230: ,p_message => 'Exit EGO_PUB_FWK_PK.add_derived_entities successfully... '

226: delete from EGO_PUBLICATION_BATCH_GT;
227:
228: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
229: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
230: ,p_message => 'Exit EGO_PUB_FWK_PK.add_derived_entities successfully... '
231: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
232:
233: EXCEPTION
234: WHEN EGO_NO_DERIVED_ENTITIES THEN

Line 236: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'

232:
233: EXCEPTION
234: WHEN EGO_NO_DERIVED_ENTITIES THEN
235: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_EXCEPTION
236: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
237: ,p_message => 'Exception EGO_NO_DERIVED_ENTITIES in stmt num: ' || l_stmt_num|| ': '||'sqlerrm=>' ||sqlerrm);
238:
239:
240: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

Line 247: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'

243: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
244: ,p_msg_data => x_msg_data );
245: WHEN EGO_PUB_BATCHID_NULL THEN
246: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_EXCEPTION
247: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
248: ,p_message => 'Exception EGO_PUB_BATCHID_NULL in stmt num: ' || l_stmt_num|| ': '||'sqlerrm=>' ||sqlerrm );
249: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
250: ,p_message =>'EGO_PUB_BATCHID_NULL');
251: x_return_status := FND_API.G_RET_STS_ERROR;

Line 257: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'

253: ,p_msg_data => x_msg_data );
254:
255: WHEN FND_API.G_EXC_ERROR THEN
256: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_EXCEPTION
257: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
258: ,p_message => 'Exception in stmt num: ' || l_stmt_num || ': '||'sqlerrm=>' ||sqlerrm );
259:
260: x_return_status := FND_API.G_RET_STS_ERROR;
261: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

Line 266: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'

262: ,p_msg_data => x_msg_data );
263:
264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
265: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED
266: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
267: ,p_message => 'Unexpedted Exception in stmt num: ' || l_stmt_num || ': '||'sqlerrm=>' ||sqlerrm );
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
269: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
270: ,p_msg_data => x_msg_data );

Line 274: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'

270: ,p_msg_data => x_msg_data );
271:
272: WHEN OTHERS THEN
273: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED
274: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
275: ,p_message => 'Others Exception in stmt num: ' || l_stmt_num || ': '||'sqlerrm=>' ||sqlerrm );
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
278: ,p_msg_data => x_msg_data );

Line 305: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'

301:
302: BEGIN
303: l_stmt_num := 0;
304: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
305: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
306: ,p_message => 'Enter EGO_PUB_FWK_PK.process_entities ... '
307: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
308:
309: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 306: ,p_message => 'Enter EGO_PUB_FWK_PK.process_entities ... '

302: BEGIN
303: l_stmt_num := 0;
304: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
305: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
306: ,p_message => 'Enter EGO_PUB_FWK_PK.process_entities ... '
307: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
308:
309: x_return_status := FND_API.G_RET_STS_SUCCESS;
310:

Line 350: ,p_module => 'EGO_PUB_FWK_PK.process_entities'

346: ,1
347: FROM Ego_Publication_Batch_GT
348: WHERE Batch_Id = p_batch_id;
349: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
350: ,p_module => 'EGO_PUB_FWK_PK.process_entities'
351: ,p_message => 'lStmtNum=' || to_char(l_stmt_num)
352: ||' ' || sql%rowcount || ' rows are inserted into EGO_PUB_BAT_ENT_OBJS_B.');
353:
354:

Line 372: ,p_module => 'EGO_PUB_FWK_PK.process_entities'

368: RAISE EGO_NO_BATCH_SYSTEMS;
369: END IF;
370:
371: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
372: ,p_module => 'EGO_PUB_FWK_PK.process_entities'
373: ,p_message => 'i'|| '---' || 't_batch_ent_obj_id(i)' || '---'|| 't_system_code(i)'
374: );
375: FOR i in t_batch_ent_obj_id.FIRST..t_batch_ent_obj_id.LAST
376: LOOP

Line 378: ,p_module => 'EGO_PUB_FWK_PK.process_entities'

374: );
375: FOR i in t_batch_ent_obj_id.FIRST..t_batch_ent_obj_id.LAST
376: LOOP
377: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
378: ,p_module => 'EGO_PUB_FWK_PK.process_entities'
379: ,p_message => i ||'---' || t_batch_ent_obj_id(i) || '---'|| t_system_code(i)
380: );
381: END LOOP; --for debugging message
382:

Line 413: ,p_module => 'EGO_PUB_FWK_PK.process_entities'

409: ,FND_GLOBAL.LOGIN_ID
410: ,1
411: );
412: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
413: ,p_module => 'EGO_PUB_FWK_PK.process_entities'
414: ,p_message => 'lStmtNum=' || to_char(l_stmt_num)
415: ||' ' || sql%rowcount || ' rows are inserted into EGO_PUB_BAT_STATUS_B.');
416:
417: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE

Line 418: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'

414: ,p_message => 'lStmtNum=' || to_char(l_stmt_num)
415: ||' ' || sql%rowcount || ' rows are inserted into EGO_PUB_BAT_STATUS_B.');
416:
417: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
418: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
419: ,p_message => 'Exit EGO_PUB_FWK_PK.process_entities successfully... '
420: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
421:
422: EXCEPTION

Line 419: ,p_message => 'Exit EGO_PUB_FWK_PK.process_entities successfully... '

415: ||' ' || sql%rowcount || ' rows are inserted into EGO_PUB_BAT_STATUS_B.');
416:
417: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
418: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
419: ,p_message => 'Exit EGO_PUB_FWK_PK.process_entities successfully... '
420: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
421:
422: EXCEPTION
423: WHEN EGO_NO_BATCH_SYSTEMS THEN

Line 425: ,p_module => 'EGO_PUB_FWK_PK.process_entities'

421:
422: EXCEPTION
423: WHEN EGO_NO_BATCH_SYSTEMS THEN
424: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_EXCEPTION
425: ,p_module => 'EGO_PUB_FWK_PK.process_entities'
426: ,p_message => 'Exception EGO_NO_BATCH_SYSTEMS in stmt num: '||l_stmt_num || ':' ||'sqlerrm=>'|| sqlerrm);
427: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'
428: ,p_message =>'EGO_NO_BATCH_SYSTEMS');
429: x_return_status := FND_API.G_RET_STS_ERROR;

Line 436: ,p_module => 'EGO_PUB_FWK_PK.process_entities'

432: ,p_msg_data => x_msg_data );
433:
434: WHEN OTHERS THEN
435: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED
436: ,p_module => 'EGO_PUB_FWK_PK.process_entities'
437: ,p_message => 'Others Exception in stmt num: ' || l_stmt_num || ': '||'sqlerrm=>' ||sqlerrm );
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: EGO_UTIL_PK.count_and_get
440: (p_msg_count => x_msg_count

Line 475: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status_Thru_AIA'

471: BEGIN
472: l_stmt_num := 0;
473:
474: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
475: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status_Thru_AIA'
476: ,p_message => 'Enter EGO_PUB_FWK_PK.Update_Pub_Status_Thru_AIA ... '
477: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
478:
479:

Line 476: ,p_message => 'Enter EGO_PUB_FWK_PK.Update_Pub_Status_Thru_AIA ... '

472: l_stmt_num := 0;
473:
474: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
475: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status_Thru_AIA'
476: ,p_message => 'Enter EGO_PUB_FWK_PK.Update_Pub_Status_Thru_AIA ... '
477: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
478:
479:
480:

Line 523: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status_Thru_AIA'

519: WHERE Batch_id = p_batch_id;
520:
521:
522: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
523: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status_Thru_AIA'
524: ,p_message =>' i --' ||
525: ' batch_id(i) --' ||
526: ' pk1_value(i) --' ||
527: ' pk2_value(i) --' ||

Line 538: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status_Thru_AIA'

534: );
535:
536: FOR i IN t_dbg_batchid.FIRST..t_dbg_batchid.LAST LOOP
537: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
538: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status_Thru_AIA'
539: ,p_message => i || ' --' ||
540: t_dbg_batchid(i) || ' --' ||
541: dbg_pk1_value(i) || ' --' ||
542: dbg_pk2_value(i) || ' --' ||

Line 568: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status_Thru_AIA'

564:
565: x_return_status := calc_return_status(p_batch_id=>p_batch_id);
566:
567: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
568: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status_Thru_AIA'
569: ,p_message => 'Exit EGO_PUB_FWK_PK.Update_Pub_Status_Thru_AIA successfully... '
570: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
571:
572:

Line 569: ,p_message => 'Exit EGO_PUB_FWK_PK.Update_Pub_Status_Thru_AIA successfully... '

565: x_return_status := calc_return_status(p_batch_id=>p_batch_id);
566:
567: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
568: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status_Thru_AIA'
569: ,p_message => 'Exit EGO_PUB_FWK_PK.Update_Pub_Status_Thru_AIA successfully... '
570: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
571:
572:
573:

Line 579: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status_Thru_AIA'

575: Exception
576:
577: When OTHERS Then
578: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED
579: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status_Thru_AIA'
580: ,p_message => 'Unexpedted Exception in stmt num: ' || l_stmt_num || ': '||'sqlerrm=>' ||sqlerrm );
581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
582: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
583: ,p_msg_data => x_msg_data );

Line 596: ,p_module => 'EGO_PUB_FWK_PK.calc_return_status'

592: l_ct_bat NUMBER;
593: l_stmt_num NUMBER;
594: BEGIN
595: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
596: ,p_module => 'EGO_PUB_FWK_PK.calc_return_status'
597: ,p_message => 'Enter EGO_PUB_FWK_PK.calc_return_status ... '
598: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
599:
600: BEGIN

Line 597: ,p_message => 'Enter EGO_PUB_FWK_PK.calc_return_status ... '

593: l_stmt_num NUMBER;
594: BEGIN
595: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
596: ,p_module => 'EGO_PUB_FWK_PK.calc_return_status'
597: ,p_message => 'Enter EGO_PUB_FWK_PK.calc_return_status ... '
598: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
599:
600: BEGIN
601: l_stmt_num := 10;

Line 613: ,p_module => 'EGO_PUB_FWK_PK.calc_return_status'

609: return C_FAILED;
610: END;
611:
612: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_STATEMENT
613: ,p_module => 'EGO_PUB_FWK_PK.calc_return_status'
614: ,p_message => 'row_count_Success=> '||l_ct_S
615: );
616:
617: IF l_ct_S = 0 THEN

Line 629: ,p_module => 'EGO_PUB_FWK_PK.calc_return_status'

625: from ego_publication_batch_gt
626: WHERE batch_id = p_batch_id;
627:
628: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_STATEMENT
629: ,p_module => 'EGO_PUB_FWK_PK.calc_return_status'
630: ,p_message => 'total rows=> '||l_ct_bat
631: );
632:
633: IF l_ct_bat = l_ct_S THEN

Line 643: ,p_module => 'EGO_PUB_FWK_PK.calc_return_status'

639:
640: END IF;
641:
642: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
643: ,p_module => 'EGO_PUB_FWK_PK.calc_return_status'
644: ,p_message => 'Exit EGO_PUB_FWK_PK.calc_return_status ... '
645: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
646:
647: END calc_return_status;

Line 644: ,p_message => 'Exit EGO_PUB_FWK_PK.calc_return_status ... '

640: END IF;
641:
642: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
643: ,p_module => 'EGO_PUB_FWK_PK.calc_return_status'
644: ,p_message => 'Exit EGO_PUB_FWK_PK.calc_return_status ... '
645: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
646:
647: END calc_return_status;
648:

Line 665: ,p_module => 'EGO_PUB_FWK_PK.Basic_Validation'

661: EGO_INVALID_MODE Exception;
662: BEGIN
663: l_stmt_num := 0;
664: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
665: ,p_module => 'EGO_PUB_FWK_PK.Basic_Validation'
666: ,p_message => 'Enter EGO_PUB_FWK_PK.Basic_Validation ... '
667: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
668:
669: x_return_status := C_SUCCESS;

Line 666: ,p_message => 'Enter EGO_PUB_FWK_PK.Basic_Validation ... '

662: BEGIN
663: l_stmt_num := 0;
664: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
665: ,p_module => 'EGO_PUB_FWK_PK.Basic_Validation'
666: ,p_message => 'Enter EGO_PUB_FWK_PK.Basic_Validation ... '
667: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
668:
669: x_return_status := C_SUCCESS;
670:

Line 692: ,p_module => 'EGO_PUB_FWK_PK.Basic_Validation'

688: Raise EGO_INVALID_MODE;
689: END IF;
690:
691: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
692: ,p_module => 'EGO_PUB_FWK_PK.Basic_Validation'
693: ,p_message => 'Exit EGO_PUB_FWK_PK.Basic_Validation ... '
694: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
695:
696: Exception

Line 693: ,p_message => 'Exit EGO_PUB_FWK_PK.Basic_Validation ... '

689: END IF;
690:
691: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
692: ,p_module => 'EGO_PUB_FWK_PK.Basic_Validation'
693: ,p_message => 'Exit EGO_PUB_FWK_PK.Basic_Validation ... '
694: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
695:
696: Exception
697:

Line 700: ,p_module => 'EGO_PUB_FWK_PK.Basic_validation'

696: Exception
697:
698: When FND_API.G_EXC_UNEXPECTED_ERROR Then
699: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED
700: ,p_module => 'EGO_PUB_FWK_PK.Basic_validation'
701: ,p_message => 'Unexpedted Exception in stmt num: ' || l_stmt_num || ': '||'sqlerrm=>' ||sqlerrm );
702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
703: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
704: ,p_msg_data => x_msg_data );

Line 709: ,p_module => 'EGO_PUB_FWK_PK.Basic_validation'

705:
706:
707: When EGO_INVALID_MODE Then
708: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED
709: ,p_module => 'EGO_PUB_FWK_PK.Basic_validation'
710: ,p_message => 'Inavlid Batch mode in stmt num: ' || l_stmt_num );
711:
712: l_stmt_num := 30;
713: Update ego_publication_batch_gt

Line 748: ,p_module => 'EGO_PUB_FWK_PK.validate_batch_id'

744: EGO_NO_HEADER EXCEPTION;
745: BEGIN
746: l_stmt_num := 0;
747: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
748: ,p_module => 'EGO_PUB_FWK_PK.validate_batch_id'
749: ,p_message => 'Enter EGO_PUB_FWK_PK.validate_batch_id ... '
750: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
751:
752: x_return_status := C_SUCCESS;

Line 749: ,p_message => 'Enter EGO_PUB_FWK_PK.validate_batch_id ... '

745: BEGIN
746: l_stmt_num := 0;
747: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
748: ,p_module => 'EGO_PUB_FWK_PK.validate_batch_id'
749: ,p_message => 'Enter EGO_PUB_FWK_PK.validate_batch_id ... '
750: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
751:
752: x_return_status := C_SUCCESS;
753:

Line 773: ,p_module => 'EGO_PUB_FWK_PK.validate_batch_id'

769: RAISE EGO_NO_HEADER;
770: End;
771:
772: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
773: ,p_module => 'EGO_PUB_FWK_PK.validate_batch_id'
774: ,p_message => 'Exit EGO_PUB_FWK_PK.validate_batch_id ... '
775: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
776:
777:

Line 774: ,p_message => 'Exit EGO_PUB_FWK_PK.validate_batch_id ... '

770: End;
771:
772: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
773: ,p_module => 'EGO_PUB_FWK_PK.validate_batch_id'
774: ,p_message => 'Exit EGO_PUB_FWK_PK.validate_batch_id ... '
775: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
776:
777:
778:

Line 782: ,p_module => 'EGO_PUB_FWK_PK.validate_batch_id'

778:
779: EXCEPTION
780: When EGO_NULL_BATCH_ID Then
781: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_EXCEPTION
782: ,p_module => 'EGO_PUB_FWK_PK.validate_batch_id'
783: ,p_message => 'Exception EGO_PUB_BATCHID_NULL in stmt num: '||l_stmt_num || ':' ||'sqlerrm=>'|| sqlerrm);
784:
785:
786: l_stmt_num := 20;

Line 805: ,p_module => 'EGO_PUB_FWK_PK.validate_batch_id'

801:
802: WHEN EGO_NO_HEADER THEN
803:
804: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_EXCEPTION
805: ,p_module => 'EGO_PUB_FWK_PK.validate_batch_id'
806: ,p_message => 'Exception EGO_NO_HEADER in stmt num: '||l_stmt_num || ':' ||'sqlerrm=>'|| sqlerrm);
807:
808:
809: l_stmt_num := 30;

Line 829: ,p_module => 'EGO_PUB_FWK_PK.validate_batch_id'

825:
826: x_return_status := C_FAILED;
827: WHEN OTHERS THEN
828: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED
829: ,p_module => 'EGO_PUB_FWK_PK.validate_batch_id'
830: ,p_message => 'Others Exception in stmt num: ' || l_stmt_num || ': '||'sqlerrm=>' ||sqlerrm );
831:
832:
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 846: ,p_module => 'EGO_PUB_FWK_PK.validateStatus'

842: l_stmt_num NUMBER;
843: BEGIN
844: l_stmt_num := 0;
845: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
846: ,p_module => 'EGO_PUB_FWK_PK.validateStatus'
847: ,p_message => 'Enter EGO_PUB_FWK_PK.validateStatus ... '
848: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
849:
850: l_stmt_num := 10;

Line 847: ,p_message => 'Enter EGO_PUB_FWK_PK.validateStatus ... '

843: BEGIN
844: l_stmt_num := 0;
845: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
846: ,p_module => 'EGO_PUB_FWK_PK.validateStatus'
847: ,p_message => 'Enter EGO_PUB_FWK_PK.validateStatus ... '
848: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
849:
850: l_stmt_num := 10;
851: Update Ego_Publication_Batch_GT

Line 863: ,p_module => 'EGO_PUB_FWK_PK.validateStatus'

859: where Lookup_Type = 'EGO_PUBLICATION_STATUS')
860: and batch_id = p_batch_id;
861:
862: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
863: ,p_module => 'EGO_PUB_FWK_PK.validateStatus'
864: ,p_message => 'Exit EGO_PUB_FWK_PK.validateStatus ... '
865: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
866:
867:

Line 864: ,p_message => 'Exit EGO_PUB_FWK_PK.validateStatus ... '

860: and batch_id = p_batch_id;
861:
862: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
863: ,p_module => 'EGO_PUB_FWK_PK.validateStatus'
864: ,p_message => 'Exit EGO_PUB_FWK_PK.validateStatus ... '
865: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
866:
867:
868:

Line 872: ,p_module => 'EGO_PUB_FWK_PK.validate_status'

868:
869: EXCEPTION
870: WHEN OTHERS THEN
871: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED
872: ,p_module => 'EGO_PUB_FWK_PK.validate_status'
873: ,p_message => 'Others Exception in stmt num: ' || l_stmt_num || ': '||'sqlerrm=>' ||sqlerrm );
874:
875:
876:

Line 890: ,p_module => 'EGO_PUB_FWK_PK.valdiateBatSystem'

886: l_stmt_num NUMBER;
887: BEGIN
888: l_stmt_num := 0;
889: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
890: ,p_module => 'EGO_PUB_FWK_PK.valdiateBatSystem'
891: ,p_message => 'Enter EGO_PUB_FWK_PK.valdiateBatSystem ... '
892: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
893:
894:

Line 891: ,p_message => 'Enter EGO_PUB_FWK_PK.valdiateBatSystem ... '

887: BEGIN
888: l_stmt_num := 0;
889: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
890: ,p_module => 'EGO_PUB_FWK_PK.valdiateBatSystem'
891: ,p_message => 'Enter EGO_PUB_FWK_PK.valdiateBatSystem ... '
892: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
893:
894:
895: l_stmt_num := 10;

Line 911: ,p_module => 'EGO_PUB_FWK_PK.valdiateBatSystem'

907: and batch_id = p_batch_id
908: and process_flag is null;
909:
910: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
911: ,p_module => 'EGO_PUB_FWK_PK.valdiateBatSystem'
912: ,p_message => 'Exit EGO_PUB_FWK_PK.valdiateBatSystem ... '
913: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
914:
915:

Line 912: ,p_message => 'Exit EGO_PUB_FWK_PK.valdiateBatSystem ... '

908: and process_flag is null;
909:
910: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
911: ,p_module => 'EGO_PUB_FWK_PK.valdiateBatSystem'
912: ,p_message => 'Exit EGO_PUB_FWK_PK.valdiateBatSystem ... '
913: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
914:
915:
916: EXCEPTION

Line 919: ,p_module => 'EGO_PUB_FWK_PK.valdiateBatSystem'

915:
916: EXCEPTION
917: WHEN OTHERS THEN
918: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED
919: ,p_module => 'EGO_PUB_FWK_PK.valdiateBatSystem'
920: ,p_message => 'Others Exception in stmt num: ' || l_stmt_num || ': '||'sqlerrm=>' ||sqlerrm );
921:
922:
923:

Line 937: ,p_module => 'EGO_PUB_FWK_PK.validateBatSysEnt'

933:
934: BEGIN
935: l_stmt_num := 0;
936: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
937: ,p_module => 'EGO_PUB_FWK_PK.validateBatSysEnt'
938: ,p_message => 'Enter EGO_PUB_FWK_PK.validateBatSysEnt ... '
939: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
940:
941:

Line 938: ,p_message => 'Enter EGO_PUB_FWK_PK.validateBatSysEnt ... '

934: BEGIN
935: l_stmt_num := 0;
936: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
937: ,p_module => 'EGO_PUB_FWK_PK.validateBatSysEnt'
938: ,p_message => 'Enter EGO_PUB_FWK_PK.validateBatSysEnt ... '
939: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
940:
941:
942: l_stmt_num := 10;

Line 976: ,p_module => 'EGO_PUB_FWK_PK.validateBatSysEnt'

972: AND batch_id = p_batch_id
973: and process_flag is null;
974:
975: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
976: ,p_module => 'EGO_PUB_FWK_PK.validateBatSysEnt'
977: ,p_message => 'Exit EGO_PUB_FWK_PK.validateBatSysEnt ... '
978: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
979:
980:

Line 977: ,p_message => 'Exit EGO_PUB_FWK_PK.validateBatSysEnt ... '

973: and process_flag is null;
974:
975: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
976: ,p_module => 'EGO_PUB_FWK_PK.validateBatSysEnt'
977: ,p_message => 'Exit EGO_PUB_FWK_PK.validateBatSysEnt ... '
978: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
979:
980:
981: EXCEPTION

Line 984: ,p_module => 'EGO_PUB_FWK_PK.validateBatSysEnt'

980:
981: EXCEPTION
982: WHEN OTHERS THEN
983: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED
984: ,p_module => 'EGO_PUB_FWK_PK.validateBatSysEnt'
985: ,p_message => 'Others Exception in stmt num: ' || l_stmt_num || ': '||'sqlerrm=>' ||sqlerrm );
986:
987:
988: RAISE;

Line 1015: ,p_module => 'EGO_PUB_FWK_PK.Process_Pub_Status'

1011: --i NUMBER; --FOR LOOP
1012: BEGIN
1013: l_stmt_num := 0;
1014: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
1015: ,p_module => 'EGO_PUB_FWK_PK.Process_Pub_Status'
1016: ,p_message => 'Enter EGO_PUB_FWK_PK.Process_Pub_Status ... '
1017: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
1018:
1019: x_return_status := C_SUCCESS;

Line 1016: ,p_message => 'Enter EGO_PUB_FWK_PK.Process_Pub_Status ... '

1012: BEGIN
1013: l_stmt_num := 0;
1014: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
1015: ,p_module => 'EGO_PUB_FWK_PK.Process_Pub_Status'
1016: ,p_message => 'Enter EGO_PUB_FWK_PK.Process_Pub_Status ... '
1017: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
1018:
1019: x_return_status := C_SUCCESS;
1020:

Line 1096: ,p_module => 'EGO_PUB_FWK_PK.Process_Pub_Status'

1092: where batch_id = p_batch_id
1093: and process_flag is null;
1094:
1095: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
1096: ,p_module => 'EGO_PUB_FWK_PK.Process_Pub_Status'
1097: ,p_message => 'Exit EGO_PUB_FWK_PK.Process_Pub_Status ... '
1098: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
1099:
1100:

Line 1097: ,p_message => 'Exit EGO_PUB_FWK_PK.Process_Pub_Status ... '

1093: and process_flag is null;
1094:
1095: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
1096: ,p_module => 'EGO_PUB_FWK_PK.Process_Pub_Status'
1097: ,p_message => 'Exit EGO_PUB_FWK_PK.Process_Pub_Status ... '
1098: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
1099:
1100:
1101: EXCEPTION

Line 1104: ,p_module => 'EGO_PUB_FWK_PK.Process_Pub_Status'

1100:
1101: EXCEPTION
1102: WHEN OTHERS THEN
1103: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED
1104: ,p_module => 'EGO_PUB_FWK_PK.Process_Pub_Status'
1105: ,p_message => 'Others Exception in stmt num: ' || l_stmt_num || ': '||'sqlerrm=>' ||sqlerrm );
1106:
1107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1108: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count

Line 1160: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'

1156: delete from Ego_Publication_Batch_GT;
1157:
1158: l_stmt_num := 0;
1159: EGO_COMMON_PVT.WRITE_DIAGNOSTIC( p_log_level => FND_LOG.LEVEL_PROCEDURE
1160: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'
1161: ,p_message => 'Enter EGO_PUB_FWK_PK.Update_Pub_Status ...'
1162: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
1163:
1164: l_stmt_num := 10;

Line 1161: ,p_message => 'Enter EGO_PUB_FWK_PK.Update_Pub_Status ...'

1157:
1158: l_stmt_num := 0;
1159: EGO_COMMON_PVT.WRITE_DIAGNOSTIC( p_log_level => FND_LOG.LEVEL_PROCEDURE
1160: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'
1161: ,p_message => 'Enter EGO_PUB_FWK_PK.Update_Pub_Status ...'
1162: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
1163:
1164: l_stmt_num := 10;
1165: Basic_Validation ( p_batch_id => p_batch_id

Line 1183: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'

1179: RAISE EGO_NO_BAT_STS_IN; --!!!!!!!!! should I raise exception or put error message into GT
1180: END IF;
1181:
1182: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
1183: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'
1184: ,p_message =>' i --' ||
1185: ' pk1_value(i) --' ||
1186: ' pk2_value(i) --' ||
1187: ' pk3_value(i) --' ||

Line 1204: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'

1200: t_system_code(i) := p_bat_status_in(i).system_code;
1201: t_status(i) := p_bat_status_in(i).status;
1202: t_message(i) := p_bat_status_in(i).message;
1203: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
1204: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'
1205: ,p_message => i || ' --' ||
1206: p_bat_status_in(i).pk1_value || ' --' ||
1207: p_bat_status_in(i).pk2_value || ' --' ||
1208: p_bat_status_in(i).pk3_value || ' --' ||

Line 1253: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'

1249: ,FND_GLOBAL.USER_ID
1250: ,FND_GLOBAL.LOGIN_ID
1251: );
1252: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
1253: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'
1254: ,p_message => 'lStmtNum=' || to_char(l_stmt_num)
1255: ||' ' ||sql%rowcount || ' rows are inserted into EGO_PUBLICATION_BATCH_GT.');
1256:
1257:

Line 1301: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'

1297: WHERE Batch_id = p_batch_id;
1298:
1299:
1300: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
1301: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'
1302: ,p_message =>' i --' ||
1303: ' batch_id(i) --' ||
1304: ' pk1_value(i) --' ||
1305: ' pk2_value(i) --' ||

Line 1328: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'

1324: x_bat_status_out(i).ret_err_msg := t_ret_err_msg(i);
1325: x_bat_status_out(i).ret_err_code := t_ret_err_code(i);
1326: x_bat_status_out(i).ret_err_msg_lang := t_ret_err_msg_lang(i);
1327: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
1328: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'
1329: ,p_message => i || ' --' ||
1330: t_ret_batchid(i) || ' --' ||
1331: ret_pk1_value(i) || ' --' ||
1332: ret_pk2_value(i) || ' --' ||

Line 1346: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'

1342:
1343: delete from Ego_Publication_Batch_GT;
1344:
1345: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
1346: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'
1347: ,p_message => 'Exit EGO_PUB_FWK_PK.Update_Pub_Status successfully... '
1348: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
1349:
1350: EXCEPTION

Line 1347: ,p_message => 'Exit EGO_PUB_FWK_PK.Update_Pub_Status successfully... '

1343: delete from Ego_Publication_Batch_GT;
1344:
1345: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
1346: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'
1347: ,p_message => 'Exit EGO_PUB_FWK_PK.Update_Pub_Status successfully... '
1348: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
1349:
1350: EXCEPTION
1351: WHEN EGO_NO_BAT_STS_IN THEN

Line 1353: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'

1349:
1350: EXCEPTION
1351: WHEN EGO_NO_BAT_STS_IN THEN
1352: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_EXCEPTION
1353: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'
1354: ,p_message => 'Exception EGO_NO_BAT_STS_IN in stmt num: ' || l_stmt_num|| ': '||'sqlerrm=>' ||sqlerrm);
1355:
1356:
1357: EGO_UTIL_PK.put_fnd_stack_msg (p_appln_short_name=>'EGO'

Line 1364: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'

1360: EGO_UTIL_PK.count_and_get (p_msg_count => x_msg_count
1361: ,p_msg_data => x_msg_data );
1362: WHEN OTHERS THEN
1363: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED
1364: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'
1365: ,p_message => 'Others Exception in stmt num: ' || l_stmt_num || ': '||'sqlerrm=>' ||sqlerrm );
1366:
1367:
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1386: ,p_module => 'EGO_PUB_FWK_PK.DeleteGTTableData'

1382:
1383: EXCEPTION
1384: WHEN OTHERS THEN
1385: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED
1386: ,p_module => 'EGO_PUB_FWK_PK.DeleteGTTableData'
1387: ,p_message => 'sqlerrm=>' ||sqlerrm );
1388:
1389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1390: END DeleteGTTableData;

Line 1420: l_module_name varchar2(30) := 'EGO_PUB_FWK_PK.validateSystems';

1416: x_msg_count OUT NOCOPY NUMBER,
1417: x_msg_data OUT NOCOPY VARCHAR2
1418: )
1419: IS
1420: l_module_name varchar2(30) := 'EGO_PUB_FWK_PK.validateSystems';
1421: l_system_name varchar2(100);
1422: l_system_code varchar2(30) ;
1423: l_valid boolean := true;
1424: begin

Line 1541: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.validateBatchParams';

1537: x_return_status OUT NOCOPY VARCHAR2,
1538: x_msg_count OUT NOCOPY NUMBER,
1539: x_msg_data OUT NOCOPY VARCHAR2
1540: ) is
1541: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.validateBatchParams';
1542: l_pub_type varchar2(10);
1543: l_sync varchar2(1);
1544: l_has_wkspname varchar2(1) := 'N';
1545: l_has_autorel varchar2(1) := 'N';

Line 1944: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.hasPublishSyncPriv';

1940: x_msg_count OUT NOCOPY NUMBER,
1941: x_msg_data OUT NOCOPY VARCHAR2
1942: )
1943: is
1944: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.hasPublishSyncPriv';
1945: l_err_msg varchar2(2000) := null;
1946: l_func_name varchar2(50) ;
1947:
1948: l_user_id number;

Line 2046: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.hasItemPriv';

2042: x_msg_count OUT NOCOPY NUMBER,
2043: x_msg_data OUT NOCOPY VARCHAR2
2044: )
2045: IS
2046: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.hasItemPriv';
2047: l_has_prv varchar2(1) ;
2048:
2049: l_item_number varchar2(500);
2050: l_item_list varchar2(6000);

Line 2173: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.hasItemsRevsImplExplValid';

2169: x_msg_count OUT NOCOPY NUMBER,
2170: x_msg_data OUT NOCOPY VARCHAR2
2171: )
2172: IS
2173: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.hasItemsRevsImplExplValid';
2174: l_item_id number;
2175: l_org_id number;
2176: l_item_number VARCHAR2(500);
2177: l_item_list varchar2(6000);

Line 2307: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.hasPublishPrivilege';

2303: x_return_status OUT NOCOPY VARCHAR2,
2304: x_msg_count OUT NOCOPY NUMBER,
2305: x_msg_data OUT NOCOPY VARCHAR2
2306: ) is
2307: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.hasPublishPrivilege';
2308: begin
2309: if (p_batch_type = C_BATCH_ENTITY_ITEM ) then
2310: -- check user has view item priv 'EGO_VIEW_ITEM'
2311: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE

Line 2524: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.hasMultiEntRev';

2520: x_msg_count OUT NOCOPY NUMBER,
2521: x_msg_data OUT NOCOPY VARCHAR2
2522: )
2523: is
2524: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.hasMultiEntRev';
2525: l_batch_entities TBL_OF_BAT_ENT_OBJ_TYPE;
2526: begin
2527: x_return_status := FND_API.G_RET_STS_SUCCESS;
2528: l_batch_entities := p_batch_entities;

Line 2601: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.publish_pvt';

2597: x_return_status OUT NOCOPY VARCHAR2,
2598: x_msg_count OUT NOCOPY NUMBER,
2599: x_msg_data OUT NOCOPY VARCHAR2)
2600: IS
2601: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.publish_pvt';
2602: l_batch_id number;
2603: l_user_id number;
2604: l_party_id number;
2605:

Line 2915: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.Create_batch';

2911: x_msg_count OUT NOCOPY NUMBER,
2912: x_msg_data OUT NOCOPY varchar2
2913: )
2914: IS
2915: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.Create_batch';
2916: l_user_id number ;
2917: l_batch_id number ;
2918: l_auto_release VARCHAR2(30);
2919: l_workspace_name varchar2(4000);

Line 3431: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.publish_batch';

3427: x_msg_count OUT NOCOPY NUMBER,
3428: x_msg_data OUT NOCOPY VARCHAR2
3429: )
3430: IS
3431: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.publish_batch';
3432: --l_batch_names dbms_sql.varchar2_table ;
3433: --l_batch_ids dbms_sql.number_table ;
3434: l_batch_name varchar2(50);
3435: l_batch_id number;

Line 3513: if (l_status <> EGO_PUB_FWK_PK.C_STATUS_DRAFT) then

3509:
3510: select status_code into l_status
3511: from EGO_PUB_BAT_STATUS_B
3512: where batch_id = l_batch_id and rownum = 1;
3513: if (l_status <> EGO_PUB_FWK_PK.C_STATUS_DRAFT) then
3514: raise EGO_PUB_BATCH_NOT_DRAFT;
3515: end if;
3516:
3517: -- for item type, get batch entities to check privileges also

Line 3641: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.copy_batch';

3637: x_msg_count OUT NOCOPY NUMBER,
3638: x_msg_data OUT NOCOPY VARCHAR2
3639: )
3640: IS
3641: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.copy_batch';
3642:
3643: l_batch_id number;
3644: l_batch_name varchar2(4000);
3645: l_batch_type varchar2(30);

Line 3815: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.delete_batch';

3811: x_msg_count OUT NOCOPY NUMBER,
3812: x_msg_data OUT NOCOPY VARCHAR2
3813: )
3814: IS
3815: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.delete_batch';
3816: l_batch_name varchar2(50);
3817: l_batch_id number;
3818: l_batch_ids varchar2(3000);
3819: l_user_id number;

Line 3988: END EGO_PUB_FWK_PK;

3984: end delete_batch;
3985: -- end of public apis
3986:
3987:
3988: END EGO_PUB_FWK_PK;