[Home] [Help]
1: PACKAGE BODY ego_pages_bulkload_pvt AS
2: /* $Header: EGOVPGBB.pls 120.10.12020000.2 2012/10/03 08:49:32 pnagasur ship $ */
3:
4: /*This Procedure is used to initialize certain column values in the interface table.
5: Used in the interface flow.
8: IS
9: lv_smt NUMBER; --Statement counter
10: lv_proc VARCHAR2(30) := 'Initialize';
11: BEGIN
12: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entered Initialize procedure');
13:
14: x_return_status := G_RET_STS_SUCCESS;
15:
16: lv_smt := 1;
14: x_return_status := G_RET_STS_SUCCESS;
15:
16: lv_smt := 1;
17:
18: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
19:
20: /*Sets the EGO Application ID*/
21: SELECT application_id
22: INTO G_EGO_APPLICATION_ID
30: WHERE obj_name = 'EGO_ITEM';
31:
32: lv_smt := 2;
33:
34: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
35:
36: /*Sets the Transaction_id and upper case the transaction_type for pages interface table*/
37: UPDATE ego_pages_interface
38: SET transaction_id = mtl_system_items_interface_s.nextval,
58: OR ( set_process_id = G_SET_PROCESS_ID ) );
59:
60: lv_smt := 2;
61:
62: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
63:
64: /*Sets the Transaction_id and upper case the transaction_type for page entries interface table*/
65: UPDATE ego_page_entries_interface
66: SET transaction_id = mtl_system_items_interface_s.nextval,
84: WHERE process_status = G_PROCESS_RECORD
85: AND ( ( G_SET_PROCESS_ID IS NULL )
86: OR ( set_process_id = G_SET_PROCESS_ID ) );
87:
88: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit Initialize procedure');
89: EXCEPTION
90: WHEN OTHERS THEN
91: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Initialize - Exception when others'||SQLERRM);
92:
87:
88: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit Initialize procedure');
89: EXCEPTION
90: WHEN OTHERS THEN
91: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Initialize - Exception when others'||SQLERRM);
92:
93: x_return_status := G_RET_STS_UNEXP_ERROR;
94:
95: x_return_msg := 'ego_pages_bulkload_pvt.Initialize - '||SQLERRM;
91: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Initialize - Exception when others'||SQLERRM);
92:
93: x_return_status := G_RET_STS_UNEXP_ERROR;
94:
95: x_return_msg := 'ego_pages_bulkload_pvt.Initialize - '||SQLERRM;
96:
97: RETURN;
98: END Initialize;
99:
104: IS
105: lv_smt NUMBER; --Statement counter
106: lv_proc VARCHAR2(30) := 'Validate_transaction_type';
107: BEGIN
108: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entered Validate_transaction_type');
109:
110: x_return_status := G_RET_STS_SUCCESS;
111:
112: /* Update the interface records with process_status 3 and insert into
118: G_MESSAGE_TEXT := fnd_message.get;
119:
120: lv_smt := 1;
121:
122: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
123:
124: INSERT INTO mtl_interface_errors
125: (transaction_id,
126: unique_id,
179: OR ( set_process_id = G_SET_PROCESS_ID ) );
180:
181: lv_smt := 2;
182:
183: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
184:
185: INSERT INTO mtl_interface_errors
186: (transaction_id,
187: unique_id,
238: AND process_status = G_PROCESS_RECORD
239: AND ( ( G_SET_PROCESS_ID IS NULL )
240: OR ( set_process_id = G_SET_PROCESS_ID ) );
241:
242: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit Validate_transaction_type');
243: EXCEPTION
244: WHEN OTHERS THEN
245: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Validate_transaction_type Exception when others'||SQLERRM);
246:
241:
242: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit Validate_transaction_type');
243: EXCEPTION
244: WHEN OTHERS THEN
245: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Validate_transaction_type Exception when others'||SQLERRM);
246:
247: x_return_status := G_RET_STS_UNEXP_ERROR;
248:
249: x_return_msg := 'ego_pages_bulkload_pvt.Validate_transaction_type - '||SQLERRM;
245: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Validate_transaction_type Exception when others'||SQLERRM);
246:
247: x_return_status := G_RET_STS_UNEXP_ERROR;
248:
249: x_return_msg := 'ego_pages_bulkload_pvt.Validate_transaction_type - '||SQLERRM;
250:
251: RETURN;
252: END Validate_transaction_type;
253:
258: IS
259: lv_smt NUMBER; --Statement counter
260: lv_proc VARCHAR2(30) := 'value_to_id_pages';
261: BEGIN
262: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering Value_to_id_pg');
263:
264: x_return_status := G_RET_STS_SUCCESS;
265:
266: /*Get the ICC ID from the Concatenated ICC Name*/
265:
266: /*Get the ICC ID from the Concatenated ICC Name*/
267: lv_smt := 1;
268:
269: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
270:
271: UPDATE ego_pages_interface epi
272: SET classification_code = EGO_ICC_BULKLOAD_PVT.Get_Catalog_Group_Id(classification_name,'FIND_COMBINATION'),
273: last_updated_by = G_USER_ID,
281:
282: /*Get the page ID and set SYNC to UPDATE*/
283: lv_smt := 2;
284:
285: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
286:
287: UPDATE ego_pages_interface epi
288: SET page_id = (SELECT page_id
289: FROM ego_pages_b
304:
305: /*Set SYNC to CREATE and UPDATE*/
306: lv_smt := 3;
307:
308: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 3');
309:
310: UPDATE ego_pages_interface epi
311: SET transaction_type = decode(page_id,NULL,G_OPR_CREATE,G_OPR_UPDATE),
312: last_updated_by = G_USER_ID,
316: AND process_status = G_PROCESS_RECORD
317: AND ( ( G_SET_PROCESS_ID IS NULL )
318: OR ( set_process_id = G_SET_PROCESS_ID ) );
319:
320: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit Value_to_id_pg');
321: EXCEPTION
322: WHEN OTHERS THEN
323: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_pages Exception when others'||SQLERRM);
324:
319:
320: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit Value_to_id_pg');
321: EXCEPTION
322: WHEN OTHERS THEN
323: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_pages Exception when others'||SQLERRM);
324:
325: x_return_status := G_RET_STS_UNEXP_ERROR;
326:
327: x_return_msg := 'ego_pages_bulkload_pvt.value_to_id_pages - '||SQLERRM;
323: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_pages Exception when others'||SQLERRM);
324:
325: x_return_status := G_RET_STS_UNEXP_ERROR;
326:
327: x_return_msg := 'ego_pages_bulkload_pvt.value_to_id_pages - '||SQLERRM;
328:
329: RETURN;
330: END value_to_id_pages;
331:
337: lv_smt NUMBER; --Statement counter
338: lv_proc VARCHAR2(30) := 'value_to_id_pg_entries';
339: BEGIN
340:
341: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering value_to_id_pg_entries');
342:
343: /*Get the ICC ID from the Concatenated ICC Name*/
344: lv_smt := 1;
345:
342:
343: /*Get the ICC ID from the Concatenated ICC Name*/
344: lv_smt := 1;
345:
346: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
347:
348: x_return_status := G_RET_STS_SUCCESS;
349:
350: UPDATE ego_page_entries_interface epi
360:
361: /*Get the page ID*/
362: lv_smt := 2;
363:
364: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
365: --pnagasur: Modified for Bug 13022991
366: UPDATE ego_page_entries_interface epi
367: SET page_id = (SELECT page_id
368: FROM ego_pages_b
382:
383: /*Sets the old_attr_group_id*/
384: lv_smt := 3;
385:
386: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 3');
387:
388: UPDATE ego_page_entries_interface epi
389: SET old_attr_group_id = (SELECT attr_group_id
390: FROM ego_fnd_dsc_flx_ctx_ext
404:
405: /*Sets the new_attr_group_id*/
406: lv_smt := 4;
407:
408: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 4');
409:
410: UPDATE ego_page_entries_interface epi
411: SET new_attr_group_id = (SELECT attr_group_id
412: FROM ego_fnd_dsc_flx_ctx_ext
425: OR ( set_process_id = G_SET_PROCESS_ID ) );
426:
427: lv_smt := 5;
428:
429: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 5');
430:
431: /*Sets the old_association_id*/
432: UPDATE ego_page_entries_interface epi
433: SET old_association_id = (SELECT association_id
450: OR ( set_process_id = G_SET_PROCESS_ID ) );
451:
452: lv_smt := 6;
453:
454: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 6');
455:
456: /*Sets the new_association_id*/
457: UPDATE ego_page_entries_interface epi
458: SET new_association_id = (SELECT association_id
476:
477: /*Sets the SYNC to UPDATE*/
478: lv_smt := 7;
479:
480: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 7');
481:
482: UPDATE ego_page_entries_interface epi
483: SET transaction_type = G_OPR_UPDATE,
484: last_updated_by = G_USER_ID,
495:
496: /*Sets the SYNC to CREATE*/
497: lv_smt := 8;
498:
499: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 8');
500:
501: UPDATE ego_page_entries_interface epi
502: SET transaction_type = G_OPR_CREATE,
503: last_updated_by = G_USER_ID,
507: AND process_status = G_PROCESS_RECORD
508: AND ( ( G_SET_PROCESS_ID IS NULL )
509: OR ( set_process_id = G_SET_PROCESS_ID ) );
510:
511: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit value_to_id_pg_entries');
512: EXCEPTION
513: WHEN OTHERS THEN
514: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_pg_entries Exception when others'||SQLERRM);
515:
510:
511: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit value_to_id_pg_entries');
512: EXCEPTION
513: WHEN OTHERS THEN
514: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_pg_entries Exception when others'||SQLERRM);
515:
516: x_return_status := G_RET_STS_UNEXP_ERROR;
517:
518: x_return_msg := 'ego_pages_bulkload_pvt.value_to_id_pg_entries - '||SQLERRM;
514: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_pg_entries Exception when others'||SQLERRM);
515:
516: x_return_status := G_RET_STS_UNEXP_ERROR;
517:
518: x_return_msg := 'ego_pages_bulkload_pvt.value_to_id_pg_entries - '||SQLERRM;
519:
520: RETURN;
521: END value_to_id_pg_entries;
522:
527: IS
528: lv_smt NUMBER; --Statement counter
529: lv_proc VARCHAR2(30) := 'construct_pages';
530: BEGIN
531: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering construct_pages');
532:
533: /*Set the Page internal name when the page id is given*/
534: lv_smt := 1;
535:
532:
533: /*Set the Page internal name when the page id is given*/
534: lv_smt := 1;
535:
536: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
537:
538: x_return_status := G_RET_STS_SUCCESS;
539:
540: UPDATE ego_pages_interface epi
551:
552: /*Sets the classification name if the classification code is given*/
553: lv_smt := 2;
554:
555: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
556:
557: UPDATE ego_pages_interface epi
558: SET classification_name = (SELECT icc_kfv.concatenated_segments
559: FROM mtl_item_catalog_groups_kfv icc_kfv
565: AND process_status = G_PROCESS_RECORD
566: AND ( ( G_SET_PROCESS_ID IS NULL )
567: OR ( set_process_id = G_SET_PROCESS_ID ) );
568:
569: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit construct_pages');
570: EXCEPTION
571: WHEN OTHERS THEN
572: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'construct_pages Exception when others'||SQLERRM);
573:
568:
569: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit construct_pages');
570: EXCEPTION
571: WHEN OTHERS THEN
572: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'construct_pages Exception when others'||SQLERRM);
573:
574: x_return_status := G_RET_STS_UNEXP_ERROR;
575:
576: x_return_msg := 'ego_pages_bulkload_pvt.construct_pages - '||SQLERRM;
572: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'construct_pages Exception when others'||SQLERRM);
573:
574: x_return_status := G_RET_STS_UNEXP_ERROR;
575:
576: x_return_msg := 'ego_pages_bulkload_pvt.construct_pages - '||SQLERRM;
577:
578: RETURN;
579: END construct_pages;
580:
586: lv_smt NUMBER; --Statement counter
587: lv_proc VARCHAR2(30) := 'construct_pg_entries';
588: BEGIN
589:
590: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering construct_pg_entries');
591:
592: /*Sets the internal_name and the classification_code with the page_id is given*/
593:
594: lv_smt := 1;
592: /*Sets the internal_name and the classification_code with the page_id is given*/
593:
594: lv_smt := 1;
595:
596: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
597:
598: x_return_status := G_RET_STS_SUCCESS;
599: --pnagasur : Modified for Bug 13022991
600: UPDATE ego_page_entries_interface epi
611:
612: /*Sets the classification name if the classification code is given*/
613: lv_smt := 2;
614:
615: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
616:
617: UPDATE ego_page_entries_interface epi
618: SET classification_name = (SELECT icc_kfv.concatenated_segments
619: FROM mtl_item_catalog_groups_kfv icc_kfv
628:
629: /*Sets the old_attr_group_id and old_attr_group_name, if the old_association_id is given*/
630: lv_smt := 3;
631:
632: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 3');
633:
634: UPDATE ego_page_entries_interface epi
635: SET ( old_attr_group_id, old_attr_group_name ) = (SELECT attr_group_id,
636: attr_group_name
646:
647: /*Sets the new_attr_group_id and new_attr_group_name, if the new_association_id is given*/
648: lv_smt := 4;
649:
650: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 4');
651:
652: UPDATE ego_page_entries_interface epi
653: SET ( new_attr_group_id, new_attr_group_name ) = (SELECT attr_group_id,
654: attr_group_name
664:
665: /*Sets the old_attr_group_name and old_association_id, if the old_attr_group_id is given*/
666: lv_smt := 5;
667:
668: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 5');
669:
670: UPDATE ego_page_entries_interface epi
671: SET ( old_association_id, old_attr_group_name ) = (SELECT association_id,
672: attr_group_name
685:
686: /*Sets the new_attr_group_name and new_association_id, if the new_attr_group_id is given*/
687: lv_smt := 5;
688:
689: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 5');
690:
691: UPDATE ego_page_entries_interface epi
692: SET ( new_association_id, new_attr_group_name ) = (SELECT association_id,
693: attr_group_name
702: AND process_status = G_PROCESS_RECORD
703: AND ( ( G_SET_PROCESS_ID IS NULL )
704: OR ( set_process_id = G_SET_PROCESS_ID ) );
705:
706: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit construct_pg_entries');
707: EXCEPTION
708: WHEN OTHERS THEN
709: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'construct_pg_entries Exception when others'||SQLERRM);
710:
705:
706: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit construct_pg_entries');
707: EXCEPTION
708: WHEN OTHERS THEN
709: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'construct_pg_entries Exception when others'||SQLERRM);
710:
711: x_return_status := G_RET_STS_UNEXP_ERROR;
712:
713: x_return_msg := 'ego_pages_bulkload_pvt.construct_pg_entries - '||SQLERRM;
709: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'construct_pg_entries Exception when others'||SQLERRM);
710:
711: x_return_status := G_RET_STS_UNEXP_ERROR;
712:
713: x_return_msg := 'ego_pages_bulkload_pvt.construct_pg_entries - '||SQLERRM;
714:
715: RETURN;
716: END construct_pg_entries;
717:
723: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
724: IS
725: lv_proc VARCHAR2(30) := 'construct_page_tbl';
726: BEGIN
727: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering construct_page_tbl');
728:
729: x_return_status := G_RET_STS_SUCCESS;
730:
731: FOR i IN p_pg_tbl.FIRST.. p_pg_tbl.LAST LOOP
739: EXCEPTION
740: WHEN NO_DATA_FOUND THEN
741: x_return_status := G_RET_STS_ERROR;
742:
743: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_pg_tbl(i).transaction_id||' (PG) = ('||p_pg_tbl(i).internal_name||'). ' ||'Page is not defined in the system');
744:
745: error_handler.Add_error_message(p_message_name => 'EGO_PG_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
746: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
747: p_row_identifier => p_pg_tbl(i).transaction_id,
748: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
749: WHEN OTHERS THEN
750: x_return_status := G_RET_STS_UNEXP_ERROR;
751:
752: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_pg_tbl(i).transaction_id||' (PG) = ('||p_pg_tbl(i).internal_name||'). ' ||'Exception: '||SQLERRM);
753:
754: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
755: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
756: p_row_identifier => p_pg_tbl(i).transaction_id,
755: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
756: p_row_identifier => p_pg_tbl(i).transaction_id,
757: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
758:
759: x_return_msg := 'ego_pages_bulkload_pvt.construct_page_tbl smt 1 - '||SQLERRM;
760:
761: RETURN;
762:
763: END;
772: EXCEPTION
773: WHEN NO_DATA_FOUND THEN
774: x_return_status := G_RET_STS_ERROR;
775:
776: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_pg_tbl(i).transaction_id||' (PG,ICC) = ('||p_pg_tbl(i).internal_name||','||p_pg_tbl(i).classification_code||'). ' ||'ICC is not defined in the system');
777:
778: error_handler.Add_error_message(p_message_name => 'EGO_PG_ICC_INVALID',p_application_id => G_EGO_APPLICATION_ID,
779: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
780: p_row_identifier => p_pg_tbl(i).transaction_id,
781: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
782: WHEN OTHERS THEN
783: x_return_status := G_RET_STS_UNEXP_ERROR;
784:
785: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_pg_tbl(i).transaction_id||' (PG,ICC) = ('||p_pg_tbl(i).internal_name||','||p_pg_tbl(i).classification_code||'). ' ||'Exception: '||SQLERRM);
786:
787: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
788: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
789: p_row_identifier => p_pg_tbl(i).transaction_id,
788: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
789: p_row_identifier => p_pg_tbl(i).transaction_id,
790: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
791:
792: x_return_msg := 'ego_pages_bulkload_pvt.construct_page_tbl smt 2 - '||SQLERRM;
793:
794: RETURN;
795: END;
796: END IF;
796: END IF;
797: END IF;
798: END LOOP;
799:
800: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit construct_page_tbl');
801: EXCEPTION
802: WHEN OTHERS THEN
803: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'construct_page_tbl Exception when others'||SQLERRM);
804:
799:
800: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit construct_page_tbl');
801: EXCEPTION
802: WHEN OTHERS THEN
803: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'construct_page_tbl Exception when others'||SQLERRM);
804:
805: x_return_status := G_RET_STS_UNEXP_ERROR;
806:
807: x_return_msg := 'ego_pages_bulkload_pvt.construct_page_tbl - '||SQLERRM;
803: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'construct_page_tbl Exception when others'||SQLERRM);
804:
805: x_return_status := G_RET_STS_UNEXP_ERROR;
806:
807: x_return_msg := 'ego_pages_bulkload_pvt.construct_page_tbl - '||SQLERRM;
808:
809: RETURN;
810: END construct_page_tbl;
811:
818: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
819: IS
820: lv_proc VARCHAR2(30) := 'construct_pg_entries_tbl';
821: BEGIN
822: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering construct_pg_entries_tbl');
823:
824: x_return_status := G_RET_STS_SUCCESS;
825:
826: FOR i IN p_ent_tbl.FIRST.. p_ent_tbl.LAST LOOP
834: EXCEPTION
835: WHEN NO_DATA_FOUND THEN
836: x_return_status := G_RET_STS_ERROR;
837:
838: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG) = ('||p_ent_tbl(i).internal_name||'). ' ||'Page is not defined in the system');
839:
840: error_handler.Add_error_message(p_message_name => 'EGO_PG_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
841: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
842: p_row_identifier => p_ent_tbl(i).transaction_id,
843: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
844: WHEN OTHERS THEN
845: x_return_status := G_RET_STS_UNEXP_ERROR;
846:
847: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG) = ('||p_ent_tbl(i).internal_name||'). ' ||'Exception: '||SQLERRM);
848:
849: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
850: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
851: p_row_identifier => p_ent_tbl(i).transaction_id,
850: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
851: p_row_identifier => p_ent_tbl(i).transaction_id,
852: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
853:
854: x_return_msg := 'ego_pages_bulkload_pvt.construct_pg_entries_tbl smt 1 - '||SQLERRM;
855:
856: RETURN;
857:
858: END;
867: EXCEPTION
868: WHEN NO_DATA_FOUND THEN
869: x_return_status := G_RET_STS_ERROR;
870:
871: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG,ICC) = ('||p_ent_tbl(i).internal_name||','||p_ent_tbl(i).classification_code||'). ' ||'ICC is not defined in the system');
872:
873: error_handler.Add_error_message(p_message_name => 'EGO_PG_ICC_INVALID',p_application_id => G_EGO_APPLICATION_ID,
874: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
875: p_row_identifier => p_ent_tbl(i).transaction_id,
876: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
877: WHEN OTHERS THEN
878: x_return_status := G_RET_STS_UNEXP_ERROR;
879:
880: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'construct_pg_entries_tbl exception when others smt 2');
881:
882: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
883: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
884: p_row_identifier => p_ent_tbl(i).transaction_id,
883: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
884: p_row_identifier => p_ent_tbl(i).transaction_id,
885: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
886:
887: x_return_msg := 'ego_pages_bulkload_pvt.construct_pg_entries_tbl smt 2 - '||SQLERRM;
888:
889: RETURN;
890: END;
891: END IF;
899: EXCEPTION
900: WHEN NO_DATA_FOUND THEN
901: x_return_status := G_RET_STS_ERROR;
902:
903: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG,AG) = ('||p_ent_tbl(i).internal_name||','||p_ent_tbl(i).old_association_id||'). ' ||'Attribute Association is not defined in the system');
904:
905: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
906: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
907: p_row_identifier => p_ent_tbl(i).transaction_id,
908: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
909: WHEN OTHERS THEN
910: x_return_status := G_RET_STS_UNEXP_ERROR;
911:
912: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'construct_pg_entries_tbl exception when others smt 3');
913:
914: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
915: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
916: p_row_identifier => p_ent_tbl(i).transaction_id,
915: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
916: p_row_identifier => p_ent_tbl(i).transaction_id,
917: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
918:
919: x_return_msg := 'ego_pages_bulkload_pvt.construct_pg_entries_tbl smt 3 - '||SQLERRM;
920:
921: RETURN;
922: END;
923: END IF;
931: EXCEPTION
932: WHEN NO_DATA_FOUND THEN
933: x_return_status := G_RET_STS_ERROR;
934:
935: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG,ICC) = ('||p_ent_tbl(i).internal_name||','||p_ent_tbl(i).new_association_id||'). ' ||'Attribute Association is not defined in the system');
936:
937: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
938: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
939: p_row_identifier => p_ent_tbl(i).transaction_id,
940: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
941: WHEN OTHERS THEN
942: x_return_status := G_RET_STS_UNEXP_ERROR;
943:
944: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'construct_pg_entries_tbl exception when others smt 4');
945:
946: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
947: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
948: p_row_identifier => p_ent_tbl(i).transaction_id,
947: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
948: p_row_identifier => p_ent_tbl(i).transaction_id,
949: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
950:
951: x_return_msg := 'ego_pages_bulkload_pvt.construct_pg_entries_tbl smt 4 - '||SQLERRM;
952:
953: RETURN;
954: END;
955: END IF;
964: EXCEPTION
965: WHEN NO_DATA_FOUND THEN
966: x_return_status := G_RET_STS_ERROR;
967:
968: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG,AG) = ('||p_ent_tbl(i).internal_name||','||p_ent_tbl(i).old_association_id||'). ' ||'Attribute Association is not defined in the system');
969:
970: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
971: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
972: p_row_identifier => p_ent_tbl(i).transaction_id,
973: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
974: WHEN OTHERS THEN
975: x_return_status := G_RET_STS_UNEXP_ERROR;
976:
977: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'construct_pg_entries_tbl exception when others smt 5');
978:
979: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
980: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
981: p_row_identifier => p_ent_tbl(i).transaction_id,
980: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
981: p_row_identifier => p_ent_tbl(i).transaction_id,
982: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
983:
984: x_return_msg := 'ego_pages_bulkload_pvt.construct_pg_entries_tbl smt 5 - '||SQLERRM;
985:
986: RETURN;
987: END;
988: END IF;
997: EXCEPTION
998: WHEN NO_DATA_FOUND THEN
999: x_return_status := G_RET_STS_ERROR;
1000:
1001: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG,ICC) = ('||p_ent_tbl(i).internal_name||','||p_ent_tbl(i).new_association_id||'). ' ||'Attribute Association is not defined in the system');
1002:
1003: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
1004: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
1005: p_row_identifier => p_ent_tbl(i).transaction_id,
1006: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1007: WHEN OTHERS THEN
1008: x_return_status := G_RET_STS_UNEXP_ERROR;
1009:
1010: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'construct_pg_entries_tbl exception when others smt 6');
1011:
1012: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
1013: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1014: p_row_identifier => p_ent_tbl(i).transaction_id,
1013: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1014: p_row_identifier => p_ent_tbl(i).transaction_id,
1015: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1016:
1017: x_return_msg := 'ego_pages_bulkload_pvt.construct_pg_entries_tbl smt 6 - '||SQLERRM;
1018:
1019: RETURN;
1020: END;
1021: END IF;
1021: END IF;
1022:
1023: END IF;
1024: END LOOP;
1025: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit construct_pg_entries_tbl');
1026: EXCEPTION
1027: WHEN OTHERS THEN
1028: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'construct_pg_entries_tbl Exception when others'||SQLERRM);
1029:
1024: END LOOP;
1025: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit construct_pg_entries_tbl');
1026: EXCEPTION
1027: WHEN OTHERS THEN
1028: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'construct_pg_entries_tbl Exception when others'||SQLERRM);
1029:
1030: x_return_status := G_RET_STS_UNEXP_ERROR;
1031:
1032: x_return_msg := 'ego_pages_bulkload_pvt.construct_pg_entries_tbl - '||SQLERRM;
1028: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'construct_pg_entries_tbl Exception when others'||SQLERRM);
1029:
1030: x_return_status := G_RET_STS_UNEXP_ERROR;
1031:
1032: x_return_msg := 'ego_pages_bulkload_pvt.construct_pg_entries_tbl - '||SQLERRM;
1033:
1034: RETURN;
1035: END construct_pg_entries_tbl;
1036:
1043: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
1044: IS
1045: lv_proc VARCHAR2(30) := 'value_to_id_page_tbl';
1046: BEGIN
1047: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering value_to_id_page_tbl');
1048:
1049: x_return_status := G_RET_STS_SUCCESS;
1050:
1051: FOR i IN p_pg_tbl.FIRST.. p_pg_tbl.LAST LOOP
1074: p_pg_tbl(i).transaction_type := G_OPR_CREATE;
1075: ELSE
1076: x_return_status := G_RET_STS_ERROR;
1077:
1078: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Page is not defined in the system');
1079:
1080: error_handler.Add_error_message(p_message_name => 'EGO_PG_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
1081: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
1082: p_row_identifier => p_pg_tbl(i).transaction_id,
1084: END IF;
1085: WHEN OTHERS THEN
1086: x_return_status := G_RET_STS_UNEXP_ERROR;
1087:
1088: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_page_tbl exception when others smt 1');
1089:
1090: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
1091: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1092: p_row_identifier => p_pg_tbl(i).transaction_id,
1091: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1092: p_row_identifier => p_pg_tbl(i).transaction_id,
1093: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
1094:
1095: x_return_msg := 'ego_pages_bulkload_pvt.value_to_id_page_tbl smt 1 - '||SQLERRM;
1096:
1097: RETURN;
1098: END;
1099: END IF;
1100: END IF;
1101: END IF;
1102: END LOOP;
1103:
1104: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit value_to_id_page_tbl');
1105: EXCEPTION
1106: WHEN OTHERS THEN
1107: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_page_tbl Exception when others'||SQLERRM);
1108:
1103:
1104: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit value_to_id_page_tbl');
1105: EXCEPTION
1106: WHEN OTHERS THEN
1107: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_page_tbl Exception when others'||SQLERRM);
1108:
1109: x_return_status := G_RET_STS_UNEXP_ERROR;
1110:
1111: x_return_msg := 'ego_pages_bulkload_pvt.value_to_id_page_tbl - '||SQLERRM;
1107: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_page_tbl Exception when others'||SQLERRM);
1108:
1109: x_return_status := G_RET_STS_UNEXP_ERROR;
1110:
1111: x_return_msg := 'ego_pages_bulkload_pvt.value_to_id_page_tbl - '||SQLERRM;
1112:
1113: RETURN;
1114: END value_to_id_page_tbl;
1115:
1122: IS
1123: lv_proc VARCHAR2(30) := 'value_to_id_pg_entries_tbl';
1124: lv_flag VARCHAR2(1);
1125: BEGIN
1126: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering value_to_id_pg_entries_tbl');
1127:
1128: x_return_status := G_RET_STS_SUCCESS;
1129:
1130: FOR i IN p_ent_tbl.FIRST.. p_ent_tbl.LAST LOOP
1145: EXCEPTION
1146: WHEN NO_DATA_FOUND THEN
1147: x_return_status := G_RET_STS_ERROR;
1148:
1149: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Page is not defined in the system');
1150:
1151: error_handler.Add_error_message(p_message_name => 'EGO_PG_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
1152: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
1153: p_row_identifier => p_ent_tbl(i).transaction_id,
1154: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1155: WHEN OTHERS THEN
1156: x_return_status := G_RET_STS_UNEXP_ERROR;
1157:
1158: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_pg_entries_tbl exception when others smt 1');
1159:
1160: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
1161: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1162: p_row_identifier => p_ent_tbl(i).transaction_id,
1161: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1162: p_row_identifier => p_ent_tbl(i).transaction_id,
1163: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1164:
1165: x_return_msg := 'ego_pages_bulkload_pvt.value_to_id_pg_entries_tbl smt 1 - '||SQLERRM;
1166:
1167: RETURN;
1168: END;
1169: END IF;
1181: EXCEPTION
1182: WHEN NO_DATA_FOUND THEN
1183: x_return_status := G_RET_STS_ERROR;
1184:
1185: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Association does not exist');
1186:
1187: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
1188: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
1189: p_row_identifier => p_ent_tbl(i).transaction_id,
1190: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1191: WHEN OTHERS THEN
1192: x_return_status := G_RET_STS_UNEXP_ERROR;
1193:
1194: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_pg_entries_tbl exception when others smt 2');
1195:
1196: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
1197: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1198: p_row_identifier => p_ent_tbl(i).transaction_id,
1197: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1198: p_row_identifier => p_ent_tbl(i).transaction_id,
1199: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1200:
1201: x_return_msg := 'ego_pages_bulkload_pvt.value_to_id_pg_entries_tbl smt 2 - '||SQLERRM;
1202:
1203: RETURN;
1204:
1205: END;
1218: EXCEPTION
1219: WHEN NO_DATA_FOUND THEN
1220: x_return_status := G_RET_STS_ERROR;
1221:
1222: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Association does not exist');
1223:
1224: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
1225: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
1226: p_row_identifier => p_ent_tbl(i).transaction_id,
1227: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1228: WHEN OTHERS THEN
1229: x_return_status := G_RET_STS_UNEXP_ERROR;
1230:
1231: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_pg_entries_tbl exception when others smt 3');
1232:
1233: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
1234: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1235: p_row_identifier => p_ent_tbl(i).transaction_id,
1234: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1235: p_row_identifier => p_ent_tbl(i).transaction_id,
1236: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1237:
1238: x_return_msg := 'ego_pages_bulkload_pvt.value_to_id_pg_entries_tbl smt 3 - '||SQLERRM;
1239:
1240: RETURN;
1241:
1242: END;
1252: EXCEPTION
1253: WHEN NO_DATA_FOUND THEN
1254: x_return_status := G_RET_STS_ERROR;
1255:
1256: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Association does not exist');
1257:
1258: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
1259: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
1260: p_row_identifier => p_ent_tbl(i).transaction_id,
1261: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1262: WHEN OTHERS THEN
1263: x_return_status := G_RET_STS_UNEXP_ERROR;
1264:
1265: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_pg_entries_tbl exception when others smt 4');
1266:
1267: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
1268: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1269: p_row_identifier => p_ent_tbl(i).transaction_id,
1268: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1269: p_row_identifier => p_ent_tbl(i).transaction_id,
1270: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1271:
1272: x_return_msg := 'ego_pages_bulkload_pvt.value_to_id_pg_entries_tbl smt 4 - '||SQLERRM;
1273:
1274: RETURN;
1275:
1276: END;
1286: EXCEPTION
1287: WHEN NO_DATA_FOUND THEN
1288: x_return_status := G_RET_STS_ERROR;
1289:
1290: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Association does not exist');
1291:
1292: error_handler.Add_error_message(p_message_name => 'EGO_PG_ASSOC_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
1293: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
1294: p_row_identifier => p_ent_tbl(i).transaction_id,
1295: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1296: WHEN OTHERS THEN
1297: x_return_status := G_RET_STS_UNEXP_ERROR;
1298:
1299: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_pg_entries_tbl exception when others smt 5');
1300:
1301: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
1302: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1303: p_row_identifier => p_ent_tbl(i).transaction_id,
1302: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1303: p_row_identifier => p_ent_tbl(i).transaction_id,
1304: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1305:
1306: x_return_msg := 'ego_pages_bulkload_pvt.value_to_id_pg_entries_tbl smt 5 - '||SQLERRM;
1307:
1308: RETURN;
1309:
1310: END;
1324: p_ent_tbl(i).transaction_type := G_OPR_DELETE;
1325: WHEN OTHERS THEN
1326: x_return_status := G_RET_STS_UNEXP_ERROR;
1327:
1328: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_pg_entries_tbl exception when others smt 6');
1329:
1330: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
1331: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1332: p_row_identifier => p_ent_tbl(i).transaction_id,
1331: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
1332: p_row_identifier => p_ent_tbl(i).transaction_id,
1333: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1334:
1335: x_return_msg := 'ego_pages_bulkload_pvt.value_to_id_pg_entries_tbl smt 6 - '||SQLERRM;
1336:
1337: RETURN;
1338: END;
1339: END IF;
1339: END IF;
1340: END IF;
1341: END LOOP;
1342:
1343: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit value_to_id_pg_entries_tbl');
1344: EXCEPTION
1345: WHEN OTHERS THEN
1346: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_pg_entries_tbl Exception when others'||SQLERRM);
1347:
1342:
1343: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit value_to_id_pg_entries_tbl');
1344: EXCEPTION
1345: WHEN OTHERS THEN
1346: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_pg_entries_tbl Exception when others'||SQLERRM);
1347:
1348: x_return_status := G_RET_STS_UNEXP_ERROR;
1349:
1350: x_return_msg := 'ego_pages_bulkload_pvt.value_to_id_pg_entries_tbl - '||SQLERRM;
1346: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'value_to_id_pg_entries_tbl Exception when others'||SQLERRM);
1347:
1348: x_return_status := G_RET_STS_UNEXP_ERROR;
1349:
1350: x_return_msg := 'ego_pages_bulkload_pvt.value_to_id_pg_entries_tbl - '||SQLERRM;
1351:
1352: RETURN;
1353: END value_to_id_pg_entries_tbl;
1354:
1359: IS
1360: lv_smt NUMBER; --Statement counter
1361: lv_proc VARCHAR2(30) := 'Bulk_validate_pages';
1362: BEGIN
1363: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entered Bulk_validate_pages');
1364:
1365: x_return_status := G_RET_STS_SUCCESS;
1366:
1367: Value_to_id_pages(x_return_status, x_return_msg => x_return_msg); IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN RETURN; END IF;
1369: Construct_pages(x_return_status, x_return_msg => x_return_msg); IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN RETURN; END IF;
1370:
1371: lv_smt := 1;
1372:
1373: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 1.1');
1374:
1375: /* Update the interface records with process_status 3 and insert into
1376: MTL_INTERFACE_ERRORS if the ICC name passed is invalid*/
1377: G_MESSAGE_NAME := 'EGO_ICC_ID_INVALID';
1436: OR ( set_process_id = G_SET_PROCESS_ID ) );
1437:
1438: lv_smt := 1.1;
1439:
1440: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 1.1');
1441:
1442: /* Update the interface records with process_status 3 and insert into
1443: MTL_INTERFACE_ERRORS if the page does not exist for update and delete flow*/
1444: G_MESSAGE_NAME := 'EGO_EF_ATTR_PAGE_NOT_FOUND';
1505: OR ( set_process_id = G_SET_PROCESS_ID ) );
1506:
1507: lv_smt := 1.1;
1508:
1509: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 1.1');
1510:
1511: /* Update the interface records with process_status 3 and insert into
1512: MTL_INTERFACE_ERRORS if the page with the internal name already exists in the system*/
1513: G_MESSAGE_NAME := 'EGO_INTERNAL_NAME_EXISTS';
1580: OR ( set_process_id = G_SET_PROCESS_ID ) );
1581:
1582: lv_smt := 2;
1583:
1584: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
1585:
1586: /* Update the interface records with process_status 3 and insert into
1587: MTL_INTERFACE_ERRORS if SEQUENCE IS already existing for the ICC*/
1588: G_MESSAGE_NAME := 'EGO_PG_SEQ_DUP';
1653: AND process_status = G_PROCESS_RECORD
1654: AND ( ( G_SET_PROCESS_ID IS NULL )
1655: OR ( set_process_id = G_SET_PROCESS_ID ) );
1656:
1657: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit Bulk_validate_pages');
1658: EXCEPTION
1659: WHEN OTHERS THEN
1660: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Bulk_validate_pages Exception when others'||SQLERRM);
1661:
1656:
1657: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit Bulk_validate_pages');
1658: EXCEPTION
1659: WHEN OTHERS THEN
1660: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Bulk_validate_pages Exception when others'||SQLERRM);
1661:
1662: x_return_status := G_RET_STS_UNEXP_ERROR;
1663:
1664: x_return_msg := 'ego_pages_bulkload_pvt.Bulk_validate_pages - '||SQLERRM;
1660: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Bulk_validate_pages Exception when others'||SQLERRM);
1661:
1662: x_return_status := G_RET_STS_UNEXP_ERROR;
1663:
1664: x_return_msg := 'ego_pages_bulkload_pvt.Bulk_validate_pages - '||SQLERRM;
1665:
1666: RETURN;
1667: END Bulk_validate_pages;
1668:
1673: IS
1674: lv_smt NUMBER; --Statement counter
1675: lv_proc VARCHAR2(30) := 'bulk_validate_pg_entries';
1676: BEGIN
1677: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entered bulk_validate_pg_entries');
1678:
1679: x_return_status := G_RET_STS_SUCCESS;
1680:
1681: Value_to_id_pg_entries(x_return_status, x_return_msg => x_return_msg); IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN RETURN; END IF;
1683: Construct_pg_entries(x_return_status, x_return_msg => x_return_msg); IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN RETURN; END IF;
1684:
1685: lv_smt := 1;
1686:
1687: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
1688:
1689: /* Update the interface records with process_status 3 and insert into
1690: MTL_INTERFACE_ERRORS if flow is UPDATE or DELETE and the page entry does not exist*/
1691: G_MESSAGE_NAME := 'EGO_PG_ENT_NOT_EXIST';
1760: OR ( set_process_id = G_SET_PROCESS_ID ) );
1761:
1762: lv_smt := 2;
1763:
1764: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
1765:
1766: /* Update the interface records with process_status 3 and insert into
1767: MTL_INTERFACE_ERRORS if SEQ already exists in the page*/
1768: G_MESSAGE_NAME := 'EGO_PAGE_ENTRY_SAME_SEQ';
1833: AND process_status = G_PROCESS_RECORD
1834: AND ( ( G_SET_PROCESS_ID IS NULL )
1835: OR ( set_process_id = G_SET_PROCESS_ID ) );
1836:
1837: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit bulk_validate_pg_entries');
1838: EXCEPTION
1839: WHEN OTHERS THEN
1840: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'bulk_validate_pg_entries Exception when others'||SQLERRM);
1841:
1836:
1837: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit bulk_validate_pg_entries');
1838: EXCEPTION
1839: WHEN OTHERS THEN
1840: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'bulk_validate_pg_entries Exception when others'||SQLERRM);
1841:
1842: x_return_status := G_RET_STS_UNEXP_ERROR;
1843:
1844: x_return_status := G_RET_STS_UNEXP_ERROR;
1842: x_return_status := G_RET_STS_UNEXP_ERROR;
1843:
1844: x_return_status := G_RET_STS_UNEXP_ERROR;
1845:
1846: x_return_msg := 'ego_pages_bulkload_pvt.bulk_validate_pg_entries - '||SQLERRM;
1847:
1848: RETURN;
1849: END bulk_validate_pg_entries;
1850:
1859: lv_smt NUMBER; --Statement counter
1860: lv_flag VARCHAR2(1);
1861: lv_proc VARCHAR2(30) := 'Additional_pg_validations';
1862: BEGIN
1863: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering Additional_pg_validations');
1864:
1865: x_return_status := G_RET_STS_SUCCESS;
1866:
1867: FOR i IN p_pg_tbl.FIRST.. p_pg_tbl.LAST LOOP
1871: /*For the update or delete flow if the page is not existing in the system then Error out*/
1872: IF(p_pg_tbl(i).transaction_type <> G_OPR_CREATE AND p_pg_tbl(i).page_id IS NULL) THEN
1873: x_return_status := G_RET_STS_ERROR;
1874:
1875: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Page is not defined in the system');
1876:
1877: error_handler.Add_error_message(p_message_name => 'EGO_PG_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
1878: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
1879: p_row_identifier => p_pg_tbl(i).transaction_id,
1890: AND page_id <> NVL(p_pg_tbl(i).page_id,-1);
1891:
1892: x_return_status := G_RET_STS_ERROR;
1893:
1894: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Sequence exists in the system');
1895:
1896: error_handler.Add_error_message(p_message_name => 'EGO_PG_SEQ_DUP',p_application_id => G_EGO_APPLICATION_ID,
1897: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
1898: p_row_identifier => p_pg_tbl(i).transaction_id,
1902: NULL;
1903: WHEN OTHERS THEN
1904: x_return_status := G_RET_STS_UNEXP_ERROR;
1905:
1906: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Additional_pg_validations exception when others smt 2');
1907:
1908: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
1909: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
1910: p_row_identifier => p_pg_tbl(i).transaction_id,
1909: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
1910: p_row_identifier => p_pg_tbl(i).transaction_id,
1911: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
1912:
1913: x_return_msg := 'ego_pages_bulkload_pvt.Additional_pg_validations smt 2 - '||SQLERRM;
1914:
1915: RETURN;
1916: END;
1917:
1926: OR p_pg_tbl(i).transaction_type = G_OPR_DELETE
1927: OR p_pg_tbl(i).transaction_type = G_OPR_SYNC) THEN
1928: NULL;
1929: ELSE
1930: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Transaction type is invalid for PG');
1931:
1932: p_pg_tbl(i).process_status := G_ERROR_RECORD;
1933:
1934: x_return_status := G_RET_STS_ERROR;
1932: p_pg_tbl(i).process_status := G_ERROR_RECORD;
1933:
1934: x_return_status := G_RET_STS_ERROR;
1935:
1936: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Invalid transaction type for PG');
1937:
1938: error_handler.Add_error_message(p_message_name => 'EGO_TRANS_TYPE_INVALID',p_application_id => 'EGO',
1939: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
1940: p_row_identifier => p_pg_tbl(i).transaction_id,
1942: END IF;
1943: END IF;
1944: END LOOP;
1945:
1946: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit Additional_pg_validations');
1947: EXCEPTION
1948: WHEN OTHERS THEN
1949: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Additional_pg_validations Exception when others'||SQLERRM);
1950:
1945:
1946: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit Additional_pg_validations');
1947: EXCEPTION
1948: WHEN OTHERS THEN
1949: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Additional_pg_validations Exception when others'||SQLERRM);
1950:
1951: x_return_status := G_RET_STS_UNEXP_ERROR;
1952:
1953: x_return_msg := 'ego_pages_bulkload_pvt.Additional_pg_validations - '||SQLERRM;
1949: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Additional_pg_validations Exception when others'||SQLERRM);
1950:
1951: x_return_status := G_RET_STS_UNEXP_ERROR;
1952:
1953: x_return_msg := 'ego_pages_bulkload_pvt.Additional_pg_validations - '||SQLERRM;
1954:
1955: RETURN;
1956: END Additional_pg_validations;
1957:
1965: lv_smt NUMBER; --Statement counter
1966: lv_flag VARCHAR2(1);
1967: lv_proc VARCHAR2(30) := 'Additional_ent_validations';
1968: BEGIN
1969: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering Additional_ent_validations');
1970:
1971: x_return_status := G_RET_STS_SUCCESS;
1972:
1973: FOR i IN p_ent_tbl.FIRST.. p_ent_tbl.LAST LOOP
1983: EXCEPTION
1984: WHEN NO_DATA_FOUND THEN
1985: x_return_status := G_RET_STS_ERROR;
1986:
1987: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Sequence exists in the system');
1988:
1989: error_handler.Add_error_message(p_message_name => 'EGO_PG_ENT_NOT_EXIST',p_application_id => G_EGO_APPLICATION_ID,
1990: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
1991: p_row_identifier => p_ent_tbl(i).transaction_id,
1992: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
1993: WHEN OTHERS THEN
1994: x_return_status := G_RET_STS_UNEXP_ERROR;
1995:
1996: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Additional_ent_validations exception when others smt 1');
1997:
1998: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
1999: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
2000: p_row_identifier => p_ent_tbl(i).transaction_id,
1999: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
2000: p_row_identifier => p_ent_tbl(i).transaction_id,
2001: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2002:
2003: x_return_msg := 'ego_pages_bulkload_pvt.Additional_ent_validations smt 1- '||SQLERRM;
2004:
2005: RETURN;
2006: END;
2007: END IF;
2016:
2017: IF (lv_flag = 'Y') THEN
2018: x_return_status := G_RET_STS_ERROR;
2019:
2020: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Sequence exists in the system for the same page');
2021:
2022: error_handler.Add_error_message(p_message_name => 'EGO_PAGE_ENTRY_SAME_SEQ',p_application_id => G_EGO_APPLICATION_ID,
2023: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
2024: p_row_identifier => p_ent_tbl(i).transaction_id,
2029: NULL;
2030: WHEN OTHERS THEN
2031: x_return_status := G_RET_STS_UNEXP_ERROR;
2032:
2033: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Additional_ent_validations exception when others smt 2');
2034:
2035: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
2036: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
2037: p_row_identifier => p_ent_tbl(i).transaction_id,
2036: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
2037: p_row_identifier => p_ent_tbl(i).transaction_id,
2038: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2039:
2040: x_return_msg := 'ego_pages_bulkload_pvt.Additional_ent_validations smt 2 - '||SQLERRM;
2041:
2042: RETURN;
2043: END;
2044:
2053: OR p_ent_tbl(i).transaction_type = G_OPR_DELETE
2054: OR p_ent_tbl(i).transaction_type = G_OPR_SYNC) THEN
2055: NULL;
2056: ELSE
2057: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Transaction type is invalid for PG Entries');
2058:
2059: p_ent_tbl(i).process_status := G_ERROR_RECORD;
2060:
2061: x_return_status := G_RET_STS_ERROR;
2059: p_ent_tbl(i).process_status := G_ERROR_RECORD;
2060:
2061: x_return_status := G_RET_STS_ERROR;
2062:
2063: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Invalid transaction type for PG Entries');
2064:
2065: error_handler.Add_error_message(p_message_name => 'EGO_TRANS_TYPE_INVALID',p_application_id => 'EGO',
2066: p_token_tbl => g_token_table,p_message_type => G_RET_STS_ERROR,
2067: p_row_identifier => p_ent_tbl(i).transaction_id,
2069: END IF;
2070: END IF;
2071: END LOOP;
2072:
2073: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit Additional_ent_validations');
2074: EXCEPTION
2075: WHEN OTHERS THEN
2076: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Additional_ent_validations Exception when others'||SQLERRM);
2077:
2072:
2073: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit Additional_ent_validations');
2074: EXCEPTION
2075: WHEN OTHERS THEN
2076: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Additional_ent_validations Exception when others'||SQLERRM);
2077:
2078: x_return_status := G_RET_STS_UNEXP_ERROR;
2079:
2080: x_return_msg := 'ego_pages_bulkload_pvt.Additional_ent_validations - '||SQLERRM;
2076: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Additional_ent_validations Exception when others'||SQLERRM);
2077:
2078: x_return_status := G_RET_STS_UNEXP_ERROR;
2079:
2080: x_return_msg := 'ego_pages_bulkload_pvt.Additional_ent_validations - '||SQLERRM;
2081:
2082: RETURN;
2083: END Additional_ent_validations;
2084:
2092: IS
2093: lv_smt NUMBER; --Statement counter
2094: lv_proc VARCHAR2(30) := 'Common_pg_validations';
2095: BEGIN
2096: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entered Common_pg_validations');
2097:
2098: x_return_status := G_RET_STS_SUCCESS;
2099:
2100: FOR i IN p_pg_tbl.FIRST.. p_pg_tbl.LAST LOOP
2105: OR p_pg_tbl(i).internal_name IS NULL
2106: OR p_pg_tbl(i).classification_code IS NULL
2107: OR p_pg_tbl(i).data_level IS NULL
2108: OR p_pg_tbl(i).sequence IS NULL)) THEN
2109: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_pg_tbl(i).transaction_id||' (PG,ICC) = ('
2110: ||p_pg_tbl(i).internal_name||','||p_pg_tbl(i).classification_code||'). ' ||'Mandatory columns for create flow are not populated');
2111:
2112: p_pg_tbl(i).process_status := G_ERROR_RECORD;
2113:
2126: OR p_pg_tbl(i).data_level = G_DL_ITEM_SUP_SITE
2127: OR p_pg_tbl(i).data_level = G_DL_ITEM_SUP_SITE_ORG)) THEN
2128: NULL;
2129: ELSIF (p_pg_tbl(i).transaction_type <> G_OPR_DELETE) THEN
2130: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_pg_tbl(i).transaction_id||' (PG,DL) = ('
2131: ||p_pg_tbl(i).internal_name||','||p_pg_tbl(i).data_level||'). ' ||'Data Level passed is invalid');
2132:
2133: p_pg_tbl(i).process_status := G_ERROR_RECORD;
2134:
2139: END IF;
2140:
2141: /*Error out if ICC id or name passed is invalid populated is invalid*/
2142: IF (p_pg_tbl(i).classification_code IS NULL OR p_pg_tbl(i).classification_name IS NULL) THEN
2143: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_pg_tbl(i).transaction_id||' (PG,ICC) = ('
2144: ||p_pg_tbl(i).internal_name||','||p_pg_tbl(i).classification_code||'). ' ||'ICC code or name passed is invalid');
2145:
2146: p_pg_tbl(i).process_status := G_ERROR_RECORD;
2147:
2151: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
2152: END IF;
2153: END IF;
2154: END LOOP;
2155: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit Common_pg_validations');
2156: EXCEPTION
2157: WHEN OTHERS THEN
2158: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Common_pg_validations Exception when others'||SQLERRM);
2159:
2154: END LOOP;
2155: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit Common_pg_validations');
2156: EXCEPTION
2157: WHEN OTHERS THEN
2158: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Common_pg_validations Exception when others'||SQLERRM);
2159:
2160: x_return_status := G_RET_STS_UNEXP_ERROR;
2161:
2162: x_return_msg := 'ego_pages_bulkload_pvt.Common_pg_validations - '||SQLERRM;
2158: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Common_pg_validations Exception when others'||SQLERRM);
2159:
2160: x_return_status := G_RET_STS_UNEXP_ERROR;
2161:
2162: x_return_msg := 'ego_pages_bulkload_pvt.Common_pg_validations - '||SQLERRM;
2163:
2164: RETURN;
2165: END Common_pg_validations;
2166:
2173: IS
2174: lv_smt NUMBER; --Statement counter
2175: lv_proc VARCHAR2(30) := 'Common_ent_validations';
2176: BEGIN
2177: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entered Common_ent_validations');
2178:
2179: x_return_status := G_RET_STS_SUCCESS;
2180:
2181: FOR i IN p_ent_tbl.FIRST.. p_ent_tbl.LAST LOOP
2182: IF (p_ent_tbl(i).process_status = G_PROCESS_RECORD) THEN
2183: /*Error out if the page id or the internal name or the classification code is null*/
2184: lv_smt := 1;
2185:
2186: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
2187:
2188: IF (p_ent_tbl(i).page_id IS NULL OR p_ent_tbl(i).internal_name IS NULL OR p_ent_tbl(i).classification_code IS NULL) THEN
2189: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG) = ('
2190: ||p_ent_tbl(i).internal_name||'). ' ||'Page does not exist');
2185:
2186: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
2187:
2188: IF (p_ent_tbl(i).page_id IS NULL OR p_ent_tbl(i).internal_name IS NULL OR p_ent_tbl(i).classification_code IS NULL) THEN
2189: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG) = ('
2190: ||p_ent_tbl(i).internal_name||'). ' ||'Page does not exist');
2191:
2192: p_ent_tbl(i).process_status := G_ERROR_RECORD;
2193:
2199:
2200: /*Error out if the classification code or the classification name is null*/
2201: lv_smt := 2;
2202:
2203: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
2204:
2205: IF (p_ent_tbl(i).classification_code IS NULL OR p_ent_tbl(i).classification_name IS NULL) THEN
2206: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG,ICC) = ('
2207: ||p_ent_tbl(i).internal_name||','||p_ent_tbl(i).classification_code||'). ' ||'ICC does not exist');
2202:
2203: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
2204:
2205: IF (p_ent_tbl(i).classification_code IS NULL OR p_ent_tbl(i).classification_name IS NULL) THEN
2206: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG,ICC) = ('
2207: ||p_ent_tbl(i).internal_name||','||p_ent_tbl(i).classification_code||'). ' ||'ICC does not exist');
2208:
2209: p_ent_tbl(i).process_status := G_ERROR_RECORD;
2210:
2216:
2217: /*Error out if the old_association_id or the old_attr_group_id or the old_attr_group_name is null*/
2218: lv_smt := 3;
2219:
2220: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 3');
2221:
2222: IF (p_ent_tbl(i).old_association_id IS NULL AND (p_ent_tbl(i).old_attr_group_id IS NOT NULL OR p_ent_tbl(i).old_attr_group_name IS NOT NULL)) THEN
2223: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG,AG) = ('
2224: ||p_ent_tbl(i).internal_name||','||p_ent_tbl(i).old_association_id||'). ' ||'Old Association does not exist');
2219:
2220: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 3');
2221:
2222: IF (p_ent_tbl(i).old_association_id IS NULL AND (p_ent_tbl(i).old_attr_group_id IS NOT NULL OR p_ent_tbl(i).old_attr_group_name IS NOT NULL)) THEN
2223: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG,AG) = ('
2224: ||p_ent_tbl(i).internal_name||','||p_ent_tbl(i).old_association_id||'). ' ||'Old Association does not exist');
2225:
2226: p_ent_tbl(i).process_status := G_ERROR_RECORD;
2227:
2233:
2234: /*Error out if the new_association_id or the new_attr_group_id or the new_attr_group_name is null*/
2235: lv_smt := 4;
2236:
2237: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 4');
2238:
2239: IF (p_ent_tbl(i).new_association_id IS NULL AND (p_ent_tbl(i).new_attr_group_id IS NOT NULL OR p_ent_tbl(i).new_attr_group_name IS NOT NULL)) THEN
2240: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG,ICC) = ('
2241: ||p_ent_tbl(i).internal_name||','||p_ent_tbl(i).new_association_id||'). ' ||'New association does not exist');
2236:
2237: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 4');
2238:
2239: IF (p_ent_tbl(i).new_association_id IS NULL AND (p_ent_tbl(i).new_attr_group_id IS NOT NULL OR p_ent_tbl(i).new_attr_group_name IS NOT NULL)) THEN
2240: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG,ICC) = ('
2241: ||p_ent_tbl(i).internal_name||','||p_ent_tbl(i).new_association_id||'). ' ||'New association does not exist');
2242:
2243: p_ent_tbl(i).process_status := G_ERROR_RECORD;
2244:
2252: IF (p_ent_tbl(i).transaction_type = G_OPR_CREATE AND (p_ent_tbl(i).page_id IS NULL
2253: OR p_ent_tbl(i).old_association_id IS NULL
2254: OR p_ent_tbl(i).sequence IS NULL
2255: OR p_ent_tbl(i).classification_code IS NULL)) THEN
2256: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG,ICC) = ('
2257: ||p_ent_tbl(i).internal_name||','||p_ent_tbl(i).classification_code||'). ' ||'Mandatory columns for Page Entry creation is not populated');
2258:
2259: p_ent_tbl(i).process_status := G_ERROR_RECORD;
2260:
2267:
2268: /*Checks whether the attribute group is already associated to the page.*/
2269: lv_smt := 5;
2270:
2271: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 5');
2272:
2273: IF (p_ent_tbl(i).transaction_type = G_OPR_CREATE
2274: AND p_ent_tbl(i).old_association_id IS NOT NULL) THEN
2275: DECLARE
2280: WHERE page_id = p_ent_tbl(i).page_id
2281: AND association_id = p_ent_tbl(i).old_association_id;
2282:
2283: IF (lv_count = 1) THEN
2284: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - Err_msg_TID: '||p_ent_tbl(i).transaction_id||' (PG,AG) = ('
2285: ||p_ent_tbl(i).internal_name||','||p_ent_tbl(i).old_association_id||'). ' ||'Cannot associate the same AG twice.');
2286:
2287: p_ent_tbl(i).process_status := G_ERROR_RECORD;
2288:
2292: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2293: END IF;
2294: EXCEPTION
2295: WHEN OTHERS THEN
2296: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exception'||SQLERRM);
2297:
2298: p_ent_tbl(i).process_status := G_RET_STS_UNEXP_ERROR;
2299:
2300: error_handler.Add_error_message(p_message_text => SQLERRM,p_application_id => G_EGO_APPLICATION_ID,
2301: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_UNEXP_ERROR,
2302: p_row_identifier => p_ent_tbl(i).transaction_id,
2303: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2304:
2305: x_return_msg := 'ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exception'||SQLERRM;
2306:
2307: RETURN;
2308: END;
2309: END IF;
2309: END IF;
2310:
2311: END IF;
2312: END LOOP;
2313: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit Common_ent_validations');
2314: EXCEPTION
2315: WHEN OTHERS THEN
2316: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Common_ent_validations Exception when others'||SQLERRM);
2317:
2312: END LOOP;
2313: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit Common_ent_validations');
2314: EXCEPTION
2315: WHEN OTHERS THEN
2316: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Common_ent_validations Exception when others'||SQLERRM);
2317:
2318: x_return_status := G_RET_STS_UNEXP_ERROR;
2319:
2320: x_return_msg := 'ego_pages_bulkload_pvt.Common_ent_validations - '||SQLERRM;
2316: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Common_ent_validations Exception when others'||SQLERRM);
2317:
2318: x_return_status := G_RET_STS_UNEXP_ERROR;
2319:
2320: x_return_msg := 'ego_pages_bulkload_pvt.Common_ent_validations - '||SQLERRM;
2321:
2322: RETURN;
2323: END Common_ent_validations;
2324:
2348: l_ego_pg_tbl ego_metadata_pub.ego_pg_tbl;
2349: l_ego_ent_tbl ego_metadata_pub.ego_ent_tbl;
2350: lv_proc VARCHAR2(30) := 'import_pg_intf';
2351: BEGIN
2352: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entered import_pg_intf.');
2353:
2354: x_return_status := G_RET_STS_SUCCESS;
2355:
2356: error_handler.Set_bo_identifier(G_BO_IDENTIFIER_PG);
2364:
2365: IF (G_PAGES_COUNT <> 0) THEN
2366: Bulk_validate_pages(x_return_status => x_return_status, x_return_msg => x_return_msg); IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN RETURN; END IF;
2367:
2368: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Load and process PG');
2369:
2370: /*Load PL/SQL tables for PG and then call processing method*/
2371: OPEN c_pg;
2372:
2384: END LOOP;
2385:
2386: CLOSE c_pg;
2387:
2388: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'PG processed');
2389: END IF;
2390: IF (G_PAGE_ENTRIES_COUNT <> 0) THEN
2391: Bulk_validate_pg_entries(x_return_status, x_return_msg => x_return_msg); IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN RETURN; END IF;
2392:
2389: END IF;
2390: IF (G_PAGE_ENTRIES_COUNT <> 0) THEN
2391: Bulk_validate_pg_entries(x_return_status, x_return_msg => x_return_msg); IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN RETURN; END IF;
2392:
2393: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Load and process Page Entries');
2394:
2395: /*Load PL/SQL tables for Page Entries and then call processing method*/
2396: OPEN c_ent;
2397:
2409: END LOOP;
2410:
2411: CLOSE c_ent;
2412:
2413: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Page Entries Processed');
2414: END IF;
2415: END IF;
2416:
2417: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit import_pg_intf.');
2413: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Page Entries Processed');
2414: END IF;
2415: END IF;
2416:
2417: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit import_pg_intf.');
2418: EXCEPTION
2419: WHEN OTHERS THEN
2420: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'import_pg_intf Exception when others'||SQLERRM);
2421:
2416:
2417: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit import_pg_intf.');
2418: EXCEPTION
2419: WHEN OTHERS THEN
2420: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'import_pg_intf Exception when others'||SQLERRM);
2421:
2422: x_return_status := G_RET_STS_UNEXP_ERROR;
2423:
2424: x_return_msg := 'ego_pages_bulkload_pvt.import_pg_intf - '||SQLERRM;
2420: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'import_pg_intf Exception when others'||SQLERRM);
2421:
2422: x_return_status := G_RET_STS_UNEXP_ERROR;
2423:
2424: x_return_msg := 'ego_pages_bulkload_pvt.import_pg_intf - '||SQLERRM;
2425:
2426: RETURN;
2427: END import_pg_intf;
2428:
2437: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
2438: IS
2439: lv_proc VARCHAR2(30) := 'Process_pages';
2440: BEGIN
2441: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering Process_pages');
2442:
2443: x_return_status := G_RET_STS_SUCCESS;
2444:
2445: error_handler.Set_bo_identifier(G_BO_IDENTIFIER_PG);
2459:
2460: /*Send the PG table for processing*/
2461: Process_pg(p_pg_tbl, x_return_status, x_return_msg => x_return_msg); IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN RETURN; END IF;
2462: END IF;
2463: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit Process_pages');
2464: EXCEPTION
2465: WHEN OTHERS THEN
2466: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Process_pages Exception when others'||SQLERRM);
2467:
2462: END IF;
2463: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit Process_pages');
2464: EXCEPTION
2465: WHEN OTHERS THEN
2466: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Process_pages Exception when others'||SQLERRM);
2467:
2468: x_return_status := G_RET_STS_UNEXP_ERROR;
2469:
2470: x_return_msg := 'ego_pages_bulkload_pvt.Process_pages - '||SQLERRM;
2466: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Process_pages Exception when others'||SQLERRM);
2467:
2468: x_return_status := G_RET_STS_UNEXP_ERROR;
2469:
2470: x_return_msg := 'ego_pages_bulkload_pvt.Process_pages - '||SQLERRM;
2471:
2472: RETURN;
2473: END Process_pages;
2474:
2482: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
2483: IS
2484: lv_proc VARCHAR2(30) := 'Process_pg_entries';
2485: BEGIN
2486: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering Process_pg_entries');
2487:
2488: x_return_status := G_RET_STS_SUCCESS;
2489:
2490: error_handler.Set_bo_identifier(G_BO_IDENTIFIER_PG);
2503:
2504: /*Send the Page Entries table for processing*/
2505: Process_ent(p_ent_tbl, x_return_status, x_return_msg => x_return_msg); IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN RETURN; END IF;
2506: END IF;
2507: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit Process_pg_entries');
2508: EXCEPTION
2509: WHEN OTHERS THEN
2510: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Process_pg_entries Exception when others'||SQLERRM);
2511:
2506: END IF;
2507: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit Process_pg_entries');
2508: EXCEPTION
2509: WHEN OTHERS THEN
2510: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Process_pg_entries Exception when others'||SQLERRM);
2511:
2512: x_return_status := G_RET_STS_UNEXP_ERROR;
2513:
2514: x_return_msg := 'ego_pages_bulkload_pvt.Process_pg_entries - '||SQLERRM;
2510: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Process_pg_entries Exception when others'||SQLERRM);
2511:
2512: x_return_status := G_RET_STS_UNEXP_ERROR;
2513:
2514: x_return_msg := 'ego_pages_bulkload_pvt.Process_pg_entries - '||SQLERRM;
2515:
2516: RETURN;
2517: END Process_pg_entries;
2518:
2531: lv_count_pg NUMBER;
2532: lv_count_seq NUMBER;
2533: lv_proc VARCHAR2(30) := 'Process_pg';
2534: BEGIN
2535: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering Process_pg');
2536:
2537: x_return_status := G_RET_STS_SUCCESS;
2538:
2539: Common_pg_validations(p_pg_tbl => p_pg_tbl, x_return_status => x_return_status, x_return_msg => x_return_msg); IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN RETURN; END IF;
2542:
2543: FOR i IN p_pg_tbl.first..p_pg_tbl.last LOOP
2544: IF ( P_pg_tbl(i).process_status = G_PROCESS_RECORD
2545: AND P_pg_tbl(i).transaction_type = G_OPR_CREATE ) THEN
2546: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Create Page');
2547:
2548: /*Check if the page with the internal name already exists. This repeated check is required*/
2549: SELECT count(1) INTO lv_count_pg
2550: FROM EGO_PAGES_B
2557: WHERE classification_code = P_pg_tbl(i).classification_code
2558: AND SEQUENCE = P_pg_tbl(i).SEQUENCE;
2559:
2560: IF (lv_count_pg > 0) THEN
2561: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Page already exists');
2562:
2563: p_pg_tbl(i).process_status := G_ERROR_RECORD;
2564:
2565: error_handler.Add_error_message(p_message_name => 'EGO_INTERNAL_NAME_EXISTS',p_application_id => G_EGO_APPLICATION_ID,
2566: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
2567: p_row_identifier => p_pg_tbl(i).transaction_id,
2568: p_entity_code => G_ENTITY_PG,p_table_name => G_ENTITY_PG_TAB);
2569: ELSIF (lv_count_seq > 0) THEN
2570: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Page sequence already exists');
2571:
2572: p_pg_tbl(i).process_status := G_ERROR_RECORD;
2573:
2574: error_handler.Add_error_message(p_message_name => 'EGO_PG_SEQ_DUP',p_application_id => G_EGO_APPLICATION_ID,
2601: x_return_msg := x_msg_data;
2602:
2603: RETURN;
2604: ELSE
2605: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Error in creating PG');
2606:
2607: P_pg_tbl(i).process_status := G_ERROR_RECORD;
2608:
2609: G_TOKEN_TABLE(1).Token_Name := 'Entity_Name';
2629: END IF;
2630: END IF;
2631: ELSIF ( P_pg_tbl(i).process_status = G_PROCESS_RECORD
2632: AND P_pg_tbl(i).transaction_type = G_OPR_UPDATE ) THEN
2633: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Update Page');
2634:
2635: ego_ext_fwk_pub.Update_page ( p_api_version => 1.0,
2636: p_page_id => P_pg_tbl(i).page_id,
2637: p_internal_name => P_pg_tbl(i).internal_name,
2652: x_return_msg := x_msg_data;
2653:
2654: RETURN;
2655: ELSE
2656: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Error in creating PG');
2657:
2658: P_pg_tbl(i).process_status := G_ERROR_RECORD;
2659:
2660: G_TOKEN_TABLE(1).Token_Name := 'Entity_Name';
2679: G_TOKEN_TABLE.DELETE;
2680: END IF;
2681: ELSIF ( P_pg_tbl(i).process_status = G_PROCESS_RECORD
2682: AND P_pg_tbl(i).transaction_type = G_OPR_DELETE ) THEN
2683: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Delete Page');
2684:
2685: ego_ext_fwk_pub.Delete_page ( p_api_version => 1.0,
2686: p_object_id => G_OBJECT_ID,
2687: p_classification_code => P_pg_tbl(i).classification_code,
2699: x_return_msg := x_msg_data;
2700:
2701: RETURN;
2702: ELSE
2703: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Error in creating PG');
2704:
2705: P_pg_tbl(i).process_status := G_ERROR_RECORD;
2706:
2707: G_TOKEN_TABLE(1).Token_Name := 'Entity_Name';
2729: END IF;
2730: END LOOP;
2731:
2732: IF ( G_COMMIT = true AND G_FLOW_TYPE = G_EGO_MD_API) THEN
2733: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Commit Process_pg');
2734:
2735: COMMIT;
2736: END IF;
2737:
2734:
2735: COMMIT;
2736: END IF;
2737:
2738: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit Process_pg');
2739: EXCEPTION
2740: WHEN OTHERS THEN
2741: x_return_status := G_RET_STS_UNEXP_ERROR;
2742:
2739: EXCEPTION
2740: WHEN OTHERS THEN
2741: x_return_status := G_RET_STS_UNEXP_ERROR;
2742:
2743: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Process_pg Exception when others'||SQLERRM);
2744:
2745: x_return_msg := 'ego_pages_bulkload_pvt.Process_pg - '||SQLERRM;
2746:
2747: RETURN;
2741: x_return_status := G_RET_STS_UNEXP_ERROR;
2742:
2743: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Process_pg Exception when others'||SQLERRM);
2744:
2745: x_return_msg := 'ego_pages_bulkload_pvt.Process_pg - '||SQLERRM;
2746:
2747: RETURN;
2748: END Process_pg;
2749:
2762: lv_count_ag NUMBER;
2763: lv_count_seq NUMBER;
2764: lv_proc VARCHAR2(30) := 'Process_ent';
2765: BEGIN
2766: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering Process_ent');
2767:
2768: x_return_status := G_RET_STS_SUCCESS;
2769:
2770: Common_ent_validations(p_ent_tbl => p_ent_tbl, x_return_status => x_return_status, x_return_msg => x_return_msg); IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN RETURN; END IF;
2773:
2774: FOR i IN p_ent_tbl.first..p_ent_tbl.last LOOP
2775: IF ( P_ent_tbl(i).process_status = G_PROCESS_RECORD
2776: AND P_ent_tbl(i).transaction_type = G_OPR_CREATE ) THEN
2777: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Create Page Entity');
2778:
2779: /*check if the same AG is being reassociated to the page. This repeat check is required*/
2780: SELECT count(1) INTO lv_count_ag
2781: FROM EGO_PAGE_ENTRIES_B
2789: WHERE page_id = P_ent_tbl(i).page_id
2790: AND sequence = P_ent_tbl(i).sequence;
2791:
2792: IF (lv_count_ag > 0) THEN
2793: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Page Entry association already exists');
2794:
2795: P_ent_tbl(i).process_status := G_ERROR_RECORD;
2796:
2797: error_handler.Add_error_message(p_message_name => 'EGO_PG_AG_DUP',p_application_id => G_EGO_APPLICATION_ID,
2798: p_token_tbl => G_TOKEN_TABLE,p_message_type => G_RET_STS_ERROR,
2799: p_row_identifier => P_ent_tbl(i).transaction_id,
2800: p_entity_code => G_ENTITY_ENT,p_table_name => G_ENTITY_ENT_TAB);
2801: ELSIF (lv_count_seq > 0) THEN
2802: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Page Entry sequence already exists');
2803:
2804: P_ent_tbl(i).process_status := G_ERROR_RECORD;
2805:
2806: error_handler.Add_error_message(p_message_name => 'EGO_PAGE_ENTRY_SAME_SEQ',p_application_id => G_EGO_APPLICATION_ID,
2827: x_return_msg := x_msg_data;
2828:
2829: RETURN;
2830: ELSE
2831: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Error in creating PG');
2832:
2833: P_ent_tbl(i).process_status := G_ERROR_RECORD;
2834:
2835: G_TOKEN_TABLE(1).Token_Name := 'Entity_Name';
2855: END IF;
2856: END IF;
2857: ELSIF ( P_ent_tbl(i).process_status = G_PROCESS_RECORD
2858: AND P_ent_tbl(i).transaction_type = G_OPR_UPDATE ) THEN
2859: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Update Page Entity');
2860:
2861: /*Added for bug 9733398*/
2862: /*check if the same sequence is already used.*/
2863: SELECT count(1) INTO lv_count_seq
2866: AND sequence = P_ent_tbl(i).sequence
2867: AND association_id <> P_ent_tbl(i).old_association_id;
2868:
2869: IF (lv_count_seq > 0) THEN
2870: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Page Entry sequence already exists');
2871:
2872: P_ent_tbl(i).process_status := G_ERROR_RECORD;
2873:
2874: error_handler.Add_error_message(p_message_name => 'EGO_PAGE_ENTRY_SAME_SEQ',p_application_id => G_EGO_APPLICATION_ID,
2895: x_return_msg := x_msg_data;
2896:
2897: RETURN;
2898: ELSE
2899: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Error in creating PG');
2900:
2901: P_ent_tbl(i).process_status := G_ERROR_RECORD;
2902:
2903: G_TOKEN_TABLE(1).Token_Name := 'Entity_Name';
2923: END IF;
2924: END IF; /*Added for bug 9733398*/
2925: ELSIF ( P_ent_tbl(i).process_status = G_PROCESS_RECORD
2926: AND P_ent_tbl(i).transaction_type = G_OPR_DELETE ) THEN
2927: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Delete Page Entity');
2928:
2929: ego_ext_fwk_pub.Delete_page_entry ( p_api_version => 1.0,
2930: p_page_id => P_ent_tbl(i).page_id,
2931: p_association_id => P_ent_tbl(i).old_association_id,
2943: x_return_msg := x_msg_data;
2944:
2945: RETURN;
2946: ELSE
2947: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Error in creating PG');
2948:
2949: P_ent_tbl(i).process_status := G_ERROR_RECORD;
2950:
2951: G_TOKEN_TABLE(1).Token_Name := 'Entity_Name';
2973: END IF;
2974: END LOOP;
2975:
2976: IF ( G_COMMIT = true AND G_FLOW_TYPE = G_EGO_MD_API ) THEN
2977: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Commit Process_ent');
2978:
2979: COMMIT;
2980: END IF;
2981:
2978:
2979: COMMIT;
2980: END IF;
2981:
2982: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit Process_ent');
2983: EXCEPTION
2984: WHEN OTHERS THEN
2985: x_return_status := G_RET_STS_UNEXP_ERROR;
2986:
2983: EXCEPTION
2984: WHEN OTHERS THEN
2985: x_return_status := G_RET_STS_UNEXP_ERROR;
2986:
2987: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Process_ent Exception when others'||SQLERRM);
2988:
2989: x_return_msg := 'ego_pages_bulkload_pvt.Process_ent - '||SQLERRM;
2990:
2991: RETURN;
2985: x_return_status := G_RET_STS_UNEXP_ERROR;
2986:
2987: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Process_ent Exception when others'||SQLERRM);
2988:
2989: x_return_msg := 'ego_pages_bulkload_pvt.Process_ent - '||SQLERRM;
2990:
2991: RETURN;
2992: END Process_ent;
2993:
3001: IS
3002: lv_proc VARCHAR2(30) := 'update_intf_pages';
3003: trans_id dbms_sql.number_table;
3004: BEGIN
3005: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering update_intf_pages');
3006:
3007: x_return_status := G_RET_STS_SUCCESS;
3008:
3009: FOR i IN p_pg_tbl.FIRST..p_pg_tbl.LAST LOOP
3014: UPDATE ego_pages_interface
3015: SET ROW = P_pg_tbl(i)
3016: WHERE transaction_id = trans_id(i);
3017:
3018: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit update_intf_pages');
3019: EXCEPTION
3020: WHEN OTHERS THEN
3021: x_return_status := G_RET_STS_UNEXP_ERROR;
3022:
3019: EXCEPTION
3020: WHEN OTHERS THEN
3021: x_return_status := G_RET_STS_UNEXP_ERROR;
3022:
3023: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'update_intf_pages Exception when others'||SQLERRM);
3024:
3025: x_return_msg := 'ego_pages_bulkload_pvt.update_intf_pages - '||SQLERRM;
3026:
3027: RETURN;
3021: x_return_status := G_RET_STS_UNEXP_ERROR;
3022:
3023: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'update_intf_pages Exception when others'||SQLERRM);
3024:
3025: x_return_msg := 'ego_pages_bulkload_pvt.update_intf_pages - '||SQLERRM;
3026:
3027: RETURN;
3028: END update_intf_pages;
3029:
3037: IS
3038: lv_proc VARCHAR2(30) := 'update_intf_pg_entries';
3039: trans_id dbms_sql.number_table;
3040: BEGIN
3041: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering update_intf_pg_entries');
3042:
3043: x_return_status := G_RET_STS_SUCCESS;
3044:
3045: FOR i IN p_ent_tbl.FIRST..p_ent_tbl.LAST LOOP
3050: UPDATE ego_page_entries_interface
3051: SET ROW = P_ent_tbl(i)
3052: WHERE transaction_id = trans_id(i);
3053:
3054: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit update_intf_pg_entries');
3055:
3056:
3057: EXCEPTION
3058: WHEN OTHERS THEN
3057: EXCEPTION
3058: WHEN OTHERS THEN
3059: x_return_status := G_RET_STS_UNEXP_ERROR;
3060:
3061: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'update_intf_pg_entries Exception when others'||SQLERRM);
3062:
3063: x_return_msg := 'ego_pages_bulkload_pvt.update_intf_pg_entries - '||SQLERRM;
3064:
3065: RETURN;
3059: x_return_status := G_RET_STS_UNEXP_ERROR;
3060:
3061: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'update_intf_pg_entries Exception when others'||SQLERRM);
3062:
3063: x_return_msg := 'ego_pages_bulkload_pvt.update_intf_pg_entries - '||SQLERRM;
3064:
3065: RETURN;
3066: END update_intf_pg_entries;
3067:
3075: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
3076: IS
3077: lv_proc VARCHAR2(30) := 'delete_processed_pages';
3078: BEGIN
3079: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering delete_processed_pages');
3080:
3081: x_return_status := G_RET_STS_SUCCESS;
3082:
3083: DELETE FROM ego_pages_interface
3084: WHERE process_status = G_SUCCESS_RECORD
3085: AND (x_set_process_id IS NULL
3086: OR set_process_id = x_set_process_id);
3087:
3088: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit delete_processed_pages');
3089: EXCEPTION
3090: WHEN OTHERS THEN
3091: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'delete_processed_pages Exception when others'||SQLERRM);
3092:
3087:
3088: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit delete_processed_pages');
3089: EXCEPTION
3090: WHEN OTHERS THEN
3091: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'delete_processed_pages Exception when others'||SQLERRM);
3092:
3093: x_return_status := G_RET_STS_UNEXP_ERROR;
3094:
3095: x_return_msg := 'ego_pages_bulkload_pvt.delete_processed_pages - '||SQLERRM;
3091: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'delete_processed_pages Exception when others'||SQLERRM);
3092:
3093: x_return_status := G_RET_STS_UNEXP_ERROR;
3094:
3095: x_return_msg := 'ego_pages_bulkload_pvt.delete_processed_pages - '||SQLERRM;
3096:
3097: RETURN;
3098: END delete_processed_pages;
3099:
3107: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
3108: IS
3109: lv_proc VARCHAR2(30) := 'delete_processed_pg_entries';
3110: BEGIN
3111: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering delete_processed_pg_entries');
3112:
3113: x_return_status := G_RET_STS_SUCCESS;
3114:
3115: DELETE FROM ego_page_entries_interface
3116: WHERE process_status = G_SUCCESS_RECORD
3117: AND (x_set_process_id IS NULL
3118: OR set_process_id = x_set_process_id);
3119:
3120: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit delete_processed_pg_entries');
3121: EXCEPTION
3122: WHEN OTHERS THEN
3123: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'delete_processed_pg_entries Exception when others'||SQLERRM);
3124:
3119:
3120: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit delete_processed_pg_entries');
3121: EXCEPTION
3122: WHEN OTHERS THEN
3123: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'delete_processed_pg_entries Exception when others'||SQLERRM);
3124:
3125: x_return_status := G_RET_STS_UNEXP_ERROR;
3126:
3127: x_return_msg := 'ego_pages_bulkload_pvt.delete_processed_pg_entries - '||SQLERRM;
3123: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'delete_processed_pg_entries Exception when others'||SQLERRM);
3124:
3125: x_return_status := G_RET_STS_UNEXP_ERROR;
3126:
3127: x_return_msg := 'ego_pages_bulkload_pvt.delete_processed_pg_entries - '||SQLERRM;
3128:
3129: RETURN;
3130: END delete_processed_pg_entries;
3131:
3143: lv_display_name EGO_PAGES_TL.DISPLAY_NAME%TYPE;
3144: lv_description EGO_PAGES_TL.DESCRIPTION%TYPE;
3145: lv_proc VARCHAR2(30) := 'handle_null_pg';
3146: BEGIN
3147: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering handle_null_pg');
3148:
3149: x_return_status := G_RET_STS_SUCCESS;
3150:
3151: FOR i IN p_pg_tbl.FIRST..p_pg_tbl.LAST LOOP
3151: FOR i IN p_pg_tbl.FIRST..p_pg_tbl.LAST LOOP
3152: IF (p_pg_tbl(i).process_status = G_PROCESS_RECORD
3153: AND p_pg_tbl(i).transaction_type = G_OPR_UPDATE) THEN
3154: BEGIN
3155: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Smt 1');
3156:
3157: SELECT sequence INTO lv_sequence
3158: FROM EGO_PAGES_B
3159: WHERE page_id = p_pg_tbl(i).page_id;
3157: SELECT sequence INTO lv_sequence
3158: FROM EGO_PAGES_B
3159: WHERE page_id = p_pg_tbl(i).page_id;
3160:
3161: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Smt 2');
3162:
3163: SELECT display_name, description INTO lv_display_name, lv_description
3164: FROM EGO_PAGES_TL
3165: WHERE page_id = p_pg_tbl(i).page_id
3164: FROM EGO_PAGES_TL
3165: WHERE page_id = p_pg_tbl(i).page_id
3166: AND USERENV('LANG') = LANGUAGE;
3167:
3168: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Smt 3');
3169: IF (p_pg_tbl(i).display_name IS NULL or p_pg_tbl(i).display_name = G_NULL_CHAR) THEN
3170: p_pg_tbl(i).display_name := lv_display_name;
3171: END IF;
3172: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Smt 4');
3168: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Smt 3');
3169: IF (p_pg_tbl(i).display_name IS NULL or p_pg_tbl(i).display_name = G_NULL_CHAR) THEN
3170: p_pg_tbl(i).display_name := lv_display_name;
3171: END IF;
3172: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Smt 4');
3173: IF (p_pg_tbl(i).description = G_NULL_CHAR) THEN
3174: write_debug('1');
3175: p_pg_tbl(i).description := NULL;
3176: ELSIF (p_pg_tbl(i).description IS NULL) THEN
3176: ELSIF (p_pg_tbl(i).description IS NULL) THEN
3177: write_debug('2');
3178: p_pg_tbl(i).description := lv_description;
3179: END IF;
3180: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Smt 5');
3181: IF (p_pg_tbl(i).sequence IS NULL OR p_pg_tbl(i).sequence = G_NULL_NUM) THEN
3182: p_pg_tbl(i).sequence := lv_sequence;
3183: END IF;
3184: EXCEPTION
3184: EXCEPTION
3185: WHEN OTHERS THEN
3186: x_return_status := G_RET_STS_UNEXP_ERROR;
3187:
3188: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'handle_null_pg exception when others smt 1');
3189:
3190: x_return_msg := 'ego_pages_bulkload_pvt.handle_null_pg - '||SQLERRM;
3191:
3192: RETURN;
3186: x_return_status := G_RET_STS_UNEXP_ERROR;
3187:
3188: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'handle_null_pg exception when others smt 1');
3189:
3190: x_return_msg := 'ego_pages_bulkload_pvt.handle_null_pg - '||SQLERRM;
3191:
3192: RETURN;
3193: END;
3194: END IF;
3192: RETURN;
3193: END;
3194: END IF;
3195: END LOOP;
3196: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit handle_null_pg');
3197: EXCEPTION
3198: WHEN OTHERS THEN
3199: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'handle_null_pg Exception when others'||SQLERRM);
3200: END handle_null_pg;
3195: END LOOP;
3196: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit handle_null_pg');
3197: EXCEPTION
3198: WHEN OTHERS THEN
3199: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'handle_null_pg Exception when others'||SQLERRM);
3200: END handle_null_pg;
3201:
3202:
3203: /*This procedure is used in the update flow to handle null values for PG Entries
3211: IS
3212: lv_sequence NUMBER;
3213: lv_proc VARCHAR2(30) := 'handle_null_pg_entries';
3214: BEGIN
3215: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering handle_null_pg_entries');
3216:
3217: x_return_status := G_RET_STS_SUCCESS;
3218:
3219: FOR i IN p_ent_tbl.FIRST..p_ent_tbl.LAST LOOP
3219: FOR i IN p_ent_tbl.FIRST..p_ent_tbl.LAST LOOP
3220: IF (p_ent_tbl(i).process_status = G_PROCESS_RECORD
3221: AND p_ent_tbl(i).transaction_type = G_OPR_UPDATE) THEN
3222: BEGIN
3223: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Smt 1');
3224:
3225: SELECT sequence INTO lv_sequence
3226: FROM EGO_PAGE_ENTRIES_B
3227: WHERE page_id = p_ent_tbl(i).page_id
3226: FROM EGO_PAGE_ENTRIES_B
3227: WHERE page_id = p_ent_tbl(i).page_id
3228: AND association_id = p_ent_tbl(i).old_association_id;
3229:
3230: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Smt 2');
3231:
3232: IF (p_ent_tbl(i).sequence IS NULL or p_ent_tbl(i).sequence = G_NULL_NUM) THEN
3233: p_ent_tbl(i).sequence := lv_sequence;
3234: END IF;
3235: EXCEPTION
3236: WHEN OTHERS THEN
3237: x_return_status := G_RET_STS_UNEXP_ERROR;
3238:
3239: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'handle_null_pg_entries exception when others smt 1');
3240:
3241: x_return_msg := 'ego_pages_bulkload_pvt.handle_null_pg_entries - '||SQLERRM;
3242:
3243: RETURN;
3237: x_return_status := G_RET_STS_UNEXP_ERROR;
3238:
3239: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'handle_null_pg_entries exception when others smt 1');
3240:
3241: x_return_msg := 'ego_pages_bulkload_pvt.handle_null_pg_entries - '||SQLERRM;
3242:
3243: RETURN;
3244: END;
3245: END IF;
3243: RETURN;
3244: END;
3245: END IF;
3246: END LOOP;
3247: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit handle_null_pg_entries');
3248: EXCEPTION
3249: WHEN OTHERS THEN
3250: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'handle_null_pg_entries Exception when others'||SQLERRM);
3251: END handle_null_pg_entries;
3246: END LOOP;
3247: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit handle_null_pg_entries');
3248: EXCEPTION
3249: WHEN OTHERS THEN
3250: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'handle_null_pg_entries Exception when others'||SQLERRM);
3251: END handle_null_pg_entries;
3252:
3253: /*This procedure will log debug messages
3254: x_msg IN Input message name*/
3260: EXCEPTION
3261: WHEN OTHERS THEN
3262: NULL;
3263: END write_debug;
3264: END ego_pages_bulkload_pvt;