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.OE_ELECMSGS_PVT dependencies on OE_DEBUG_PUB

Line 419: --oe_debug_pub.add('434'||idx||' fsdf' || results_cursor%ROWCOUNT);

415: END LOOP;
416: CLOSE results_cursor_8;
417: END IF;
418: END IF;
419: --oe_debug_pub.add('434'||idx||' fsdf' || results_cursor%ROWCOUNT);
420:
421: IF p_elec_msgs_tbl.count > 0 then
422:
423:

Line 458: --oe_debug_pub.add('others'||SQLERRM);

454: END IF;
455:
456: EXCEPTION
457: WHEN OTHERS THEN
458: --oe_debug_pub.add('others'||SQLERRM);
459: IF p_elec_msgs_tbl.count = 0 then
460: p_elec_msgs_tbl := l_place_holder_table;
461: END IF;
462: End do_query;

Line 487: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

483: p_last_update_itemkey IN VARCHAR2,
484: x_return_status OUT NOCOPY VARCHAR2)
485: IS
486:
487: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
488:
489: BEGIN
490: /* Validation to ensure that none of the primary key elements is NULL */
491: IF (p_order_source_id IS NULL OR p_sold_to_org_id IS NULL

Line 493: --oe_debug_pub.add('Insufficient key params to insert,returning');

489: BEGIN
490: /* Validation to ensure that none of the primary key elements is NULL */
491: IF (p_order_source_id IS NULL OR p_sold_to_org_id IS NULL
492: OR p_orig_sys_document_ref IS NULL OR p_transaction_type IS NULL OR p_document_id IS NULL) THEN
493: --oe_debug_pub.add('Insufficient key params to insert,returning');
494: x_return_status := FND_API.G_RET_STS_ERROR;
495: return;
496: END IF;
497: --oe_debug_pub.add('before insert');

Line 497: --oe_debug_pub.add('before insert');

493: --oe_debug_pub.add('Insufficient key params to insert,returning');
494: x_return_status := FND_API.G_RET_STS_ERROR;
495: return;
496: END IF;
497: --oe_debug_pub.add('before insert');
498:
499: /* Insertion -- what should the behaviour be if org_id is null */
500: INSERT INTO Oe_Em_Information (
501: order_source_id,

Line 551: oe_debug_pub.add('Insert succeeded'||SQL%ROWCOUNT||' de'||SQLERRM);

547: p_last_update_itemkey
548: );
549: x_return_status := FND_API.G_RET_STS_SUCCESS;
550: IF l_debug_level > 0 THEN
551: oe_debug_pub.add('Insert succeeded'||SQL%ROWCOUNT||' de'||SQLERRM);
552: END IF;
553: EXCEPTION
554: WHEN DUP_VAL_ON_INDEX THEN
555: IF l_debug_level > 0 THEN

Line 556: oe_debug_pub.add('DUPLICATE INDEX VALUE IN OEXVELMB.Create History Entry, update instead of insert'||SQLERRM);

552: END IF;
553: EXCEPTION
554: WHEN DUP_VAL_ON_INDEX THEN
555: IF l_debug_level > 0 THEN
556: oe_debug_pub.add('DUPLICATE INDEX VALUE IN OEXVELMB.Create History Entry, update instead of insert'||SQLERRM);
557: END IF;
558: x_return_status := FND_API.G_RET_STS_ERROR;
559: WHEN OTHERS THEN
560: IF l_debug_level > 0 THEN

Line 561: oe_debug_pub.add('OTHERS IN OEXVELMB.Create History Entry'||SQLERRM);

557: END IF;
558: x_return_status := FND_API.G_RET_STS_ERROR;
559: WHEN OTHERS THEN
560: IF l_debug_level > 0 THEN
561: oe_debug_pub.add('OTHERS IN OEXVELMB.Create History Entry'||SQLERRM);
562: END IF;
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: END Create_History_Entry;
565:

Line 587: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

583: p_document_disposition IN VARCHAR2,
584: p_last_update_itemkey IN VARCHAR2,
585: x_return_status OUT NOCOPY VARCHAR2)
586: IS
587: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
588:
589: BEGIN
590: /* Validation to ensure that none of the primary key elements is NULL */
591: IF (p_order_source_id IS NULL OR p_sold_to_org_id IS NULL

Line 594: oe_debug_pub.add ('Electronic Messages: One or more key elements are null');

590: /* Validation to ensure that none of the primary key elements is NULL */
591: IF (p_order_source_id IS NULL OR p_sold_to_org_id IS NULL
592: OR p_orig_sys_document_ref IS NULL OR p_transaction_type IS NULL OR p_document_id IS NULL) THEN
593: IF l_debug_level > 0 THEN
594: oe_debug_pub.add ('Electronic Messages: One or more key elements are null');
595: END IF;
596: x_return_status := FND_API.G_RET_STS_ERROR;
597: return;
598: END IF;

Line 623: oe_debug_pub.add('Number of rows updated: ' || SQL%ROWCOUNT);

619: AND em_transaction_type_code = p_transaction_type
620: AND document_id = p_document_id;
621:
622: IF l_debug_level > 0 THEN
623: oe_debug_pub.add('Number of rows updated: ' || SQL%ROWCOUNT);
624: END IF;
625: x_return_status := FND_API.G_RET_STS_SUCCESS;
626:
627: EXCEPTION

Line 631: oe_debug_pub.add('OTHERS IN OEXVELMB.Update History Entry');

627: EXCEPTION
628: WHEN OTHERS THEN
629: /* log appropriate debug/error messages and return */
630: IF l_debug_level > 0 THEN
631: oe_debug_pub.add('OTHERS IN OEXVELMB.Update History Entry');
632: END IF;
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634:
635: END Update_History_Entry;

Line 652: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

648: IS
649: l_dummy NUMBER;
650: l_last_itemkey VARCHAR2(240);
651: l_last_request_id NUMBER;
652: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
653:
654: BEGIN
655:
656: SELECT order_source_id, last_update_itemkey, em_conc_request_id

Line 672: oe_debug_pub.add ('Others in Find_History_entry: '||SQLERRM);

668: return TRUE;
669: EXCEPTION
670: WHEN OTHERS THEN
671: IF l_debug_level > 0 THEN
672: oe_debug_pub.add ('Others in Find_History_entry: '||SQLERRM);
673: END IF;
674: return FALSE;
675: END;
676:

Line 691: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

687: )
688: RETURN NUMBER
689: IS
690: l_document_id NUMBER;
691: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
692: BEGIN
693: /* SELECT document_id
694: INTO l_document_id
695: FROM oe_em_information

Line 716: oe_debug_pub.add ('Others in Get_Parent_Document_Id: '||SQLERRM);

712: return l_document_id;
713: EXCEPTION
714: WHEN OTHERS THEN
715: IF l_debug_level > 0 THEN
716: oe_debug_pub.add ('Others in Get_Parent_Document_Id: '||SQLERRM);
717: END IF;
718: return NULL;
719: END;
720:

Line 742: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

738: l_client_org_id NUMBER;
739: l_parameter1 NUMBER;
740:
741: --
742: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
743: --
744: BEGIN
745:
746: IF l_debug_level > 0 THEN

Line 747: oe_debug_pub.add( 'ENTERING OEEM_SELECTOR PROCEDURE' ) ;

743: --
744: BEGIN
745:
746: IF l_debug_level > 0 THEN
747: oe_debug_pub.add( 'ENTERING OEEM_SELECTOR PROCEDURE' ) ;
748:
749: oe_debug_pub.add( 'THE WORKFLOW FUNCTION MODE IS: FUNCMODE='||P_FUNCMODE ) ;
750: END IF;
751:

Line 749: oe_debug_pub.add( 'THE WORKFLOW FUNCTION MODE IS: FUNCMODE='||P_FUNCMODE ) ;

745:
746: IF l_debug_level > 0 THEN
747: oe_debug_pub.add( 'ENTERING OEEM_SELECTOR PROCEDURE' ) ;
748:
749: oe_debug_pub.add( 'THE WORKFLOW FUNCTION MODE IS: FUNCMODE='||P_FUNCMODE ) ;
750: END IF;
751:
752: -- {
753: IF (p_funcmode = 'RUN') THEN

Line 756: oe_debug_pub.add( 'P_FUNCMODE IS RUN' ) ;

752: -- {
753: IF (p_funcmode = 'RUN') THEN
754:
755: IF l_debug_level > 0 THEN
756: oe_debug_pub.add( 'P_FUNCMODE IS RUN' ) ;
757: END IF;
758: p_x_result := 'COMPLETE';
759:
760: -- Engine calls SET_CTX just before activity execution

Line 765: oe_debug_pub.add( 'P_FUNCMODE IS SET_CTX' ) ;

761:
762: ELSIF(p_funcmode = 'SET_CTX') THEN
763:
764: IF l_debug_level > 0 THEN
765: oe_debug_pub.add( 'P_FUNCMODE IS SET_CTX' ) ;
766: END IF;
767:
768: l_org_id := wf_engine.GetItemAttrNumber( p_itemtype
769: , p_itemkey

Line 775: oe_debug_pub.add('l_org_id =>' || l_org_id);

771: );
772:
773:
774: IF l_debug_level > 0 THEN
775: oe_debug_pub.add('l_org_id =>' || l_org_id);
776: END IF;
777:
778: mo_global.set_policy_context(p_access_mode => 'S', p_org_id=>l_Org_Id);
779: p_x_result := 'COMPLETE';

Line 789: oe_debug_pub.add( 'l_org_id (from workflow)=>'|| l_org_id ) ;

785: , 'ORG_ID'
786: );
787:
788: IF l_debug_level > 0 THEN
789: oe_debug_pub.add( 'l_org_id (from workflow)=>'|| l_org_id ) ;
790: END IF;
791:
792: IF (NVL(mo_global.get_current_org_id,-99) <> l_Org_Id)
793: THEN

Line 843: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

839: l_document_disposition VARCHAR2(20);
840: l_last_itemkey VARCHAR2(240);
841: l_last_request_id NUMBER;
842: l_curr_itemkey VARCHAR2(240) := p_itemkey;
843: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
844: l_order_processed_flag VARCHAR2(1) := NULL;
845: BEGIN
846: OE_STANDARD_WF.Set_Msg_Context(p_actid);
847:

Line 875: oe_debug_pub.add('before partner document no');

871: l_sold_to_org_id := wf_engine.GetItemAttrNumber( p_itemtype
872: , p_itemkey
873: , 'SOLD_TO_ORG_ID');
874: IF l_debug_level > 0 THEN
875: oe_debug_pub.add('before partner document no');
876: END IF;
877: l_orig_sys_document_ref := wf_engine.GetItemAttrText( p_itemtype
878: , p_itemkey
879: , 'PARTNER_DOCUMENT_NO');

Line 881: oe_debug_pub.add('before trading partner id');

877: l_orig_sys_document_ref := wf_engine.GetItemAttrText( p_itemtype
878: , p_itemkey
879: , 'PARTNER_DOCUMENT_NO');
880: IF l_debug_level > 0 THEN
881: oe_debug_pub.add('before trading partner id');
882: END IF;
883: l_transaction_type := wf_engine.GetItemAttrText( p_itemtype
884: , p_itemkey
885: , 'XMLG_INTERNAL_TXN_SUBTYPE');

Line 911: oe_debug_pub.add('after org id');

907: l_org_id := wf_engine.GetItemAttrNumber ( p_itemtype
908: , p_itemkey
909: , 'ORG_ID');
910: IF l_debug_level > 0 THEN
911: oe_debug_pub.add('after org id');
912: END IF;
913: IF l_org_id IS NULL THEN
914: /* MOAC_SQL_CHANGE */
915: -- SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',

Line 919: oe_debug_pub.add('set org to :'||l_org_id);

915: -- SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',
916: -- NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))) into l_org_id from DUAL;
917: l_org_id := MO_GLOBAL.Get_Current_Org_Id;
918: IF l_debug_level > 0 THEN
919: oe_debug_pub.add('set org to :'||l_org_id);
920: END IF;
921: END IF;
922:
923: l_order_number := wf_engine.GetItemAttrNumber( p_itemtype

Line 932: oe_debug_pub.add('order number is null');

928: , 'ORDER_TYPE_ID');
929:
930: IF l_order_number IS NULL THEN
931: IF l_debug_level > 0 THEN
932: oe_debug_pub.add('order number is null');
933: END IF;
934: END IF;
935: l_status := wf_engine.GetItemAttrText( p_itemtype
936: , p_itemkey

Line 1009: oe_debug_pub.add(l_order_Source_id||l_orig_sys_document_ref||l_sold_to_org_id||l_transaction_type||l_document_id||l_status||l_message_text||l_response_flag);

1005: l_org_id
1006: );
1007: END IF;
1008: IF l_debug_level > 0 THEN
1009: oe_debug_pub.add(l_order_Source_id||l_orig_sys_document_ref||l_sold_to_org_id||l_transaction_type||l_document_id||l_status||l_message_text||l_response_flag);
1010: END IF;
1011: -- here check if the record already exists for those key values
1012: -- if yes, then update, otherwise create
1013: OE_ELECMSGS_PVT.Create_History_Entry (

Line 1051: oe_debug_pub.add('Out of sequence: p_itemkey : ' || p_itemkey || 'last_itemkey ' || l_last_itemkey);

1047: IF l_last_request_id IS NOT NULL THEN
1048: l_request_id := NULL;
1049: END IF;
1050: IF l_debug_level > 0 THEN
1051: oe_debug_pub.add('Out of sequence: p_itemkey : ' || p_itemkey || 'last_itemkey ' || l_last_itemkey);
1052: END IF;
1053: END IF;
1054:
1055: OE_ELECMSGS_PVT.Update_History_Entry (

Line 1092: oe_debug_pub.add('OTHERS in Create_Or_Update_Hist_WF ' || SQLERRM );

1088: -- in the case of an exception.
1089: wf_core.context('OE_Elecmsgs_Pvt', 'Create_Or_Update_Hist_WF',
1090: p_itemtype, p_itemkey, to_char(p_actid), p_funcmode);
1091: IF l_debug_level > 0 THEN
1092: oe_debug_pub.add('OTHERS in Create_Or_Update_Hist_WF ' || SQLERRM );
1093: END IF;
1094: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1095: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Create_Or_Update_Hist_Wf');
1096: END IF;

Line 1139: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1135: l_filename VARCHAR2(200);
1136: l_request_id NUMBER;
1137: l_return_status VARCHAR2(30);
1138: --l_debug_level CONSTANT NUMBER := to_number(nvl(fnd_profile.value('ONT_DEBUG_LEVEL'),'0'));
1139: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1140:
1141: l_sold_to_org_Id NUMBER := p_customer_number;
1142: l_header_iface BOOLEAN := FALSE;
1143: l_line_iface BOOLEAN := FALSE;

Line 1207: l_filename := oe_debug_pub.set_debug_mode ('FILE');

1203: -- Setting Debug Mode and File
1204: -----------------------------------------------------------
1205:
1206: If nvl(l_debug_level, 1) > 0 Then
1207: l_filename := oe_debug_pub.set_debug_mode ('FILE');
1208: fnd_file.put_line(FND_FILE.OUTPUT,'Debug File: ' || l_filename);
1209: fnd_file.put_line(FND_FILE.OUTPUT, '');
1210: l_filename := OE_DEBUG_PUB.set_debug_mode ('CONC');
1211: END IF;

Line 1210: l_filename := OE_DEBUG_PUB.set_debug_mode ('CONC');

1206: If nvl(l_debug_level, 1) > 0 Then
1207: l_filename := oe_debug_pub.set_debug_mode ('FILE');
1208: fnd_file.put_line(FND_FILE.OUTPUT,'Debug File: ' || l_filename);
1209: fnd_file.put_line(FND_FILE.OUTPUT, '');
1210: l_filename := OE_DEBUG_PUB.set_debug_mode ('CONC');
1211: END IF;
1212:
1213: -----------------------------------------------------------
1214: -- Get Concurrent Request Id

Line 1234: oe_debug_pub.add('Sold To Org Id cannot be derived - returning');

1230:
1231: l_sold_to_org_id := OE_Value_To_Id.sold_to_org (p_sold_to_org => NULL,p_customer_number => p_customer_number);
1232: IF l_sold_to_org_Id = FND_API.G_MISS_NUM THEN
1233: IF l_debug_level > 0 THEN
1234: oe_debug_pub.add('Sold To Org Id cannot be derived - returning');
1235: END IF;
1236: retcode := 2;
1237: errbuf := SQLERRM;
1238: Return;

Line 1246: oe_debug_pub.add ('Sold To Org Id : ' || l_sold_to_org_Id);

1242: IF l_sold_to_org_id IS NOT NULL THEN
1243: OE_Id_To_Value.sold_to_org (p_sold_to_org_id => l_sold_to_org_id, x_org => l_sold_to_org, x_customer_number => l_dummy_cust_no);
1244: END IF;
1245: IF l_debug_level > 0 THEN
1246: oe_debug_pub.add ('Sold To Org Id : ' || l_sold_to_org_Id);
1247: oe_debug_pub.add ('Sold To Org derived : ' || l_sold_to_org);
1248: oe_debug_pub.add ('Org Id: ' || p_operating_unit);
1249: oe_debug_pub.add ('Default Org Id: ' || p_default_org_id);
1250: oe_debug_pub.add ('Process Records with No Org Specified: ' || p_process_null_org_id);

Line 1247: oe_debug_pub.add ('Sold To Org derived : ' || l_sold_to_org);

1243: OE_Id_To_Value.sold_to_org (p_sold_to_org_id => l_sold_to_org_id, x_org => l_sold_to_org, x_customer_number => l_dummy_cust_no);
1244: END IF;
1245: IF l_debug_level > 0 THEN
1246: oe_debug_pub.add ('Sold To Org Id : ' || l_sold_to_org_Id);
1247: oe_debug_pub.add ('Sold To Org derived : ' || l_sold_to_org);
1248: oe_debug_pub.add ('Org Id: ' || p_operating_unit);
1249: oe_debug_pub.add ('Default Org Id: ' || p_default_org_id);
1250: oe_debug_pub.add ('Process Records with No Org Specified: ' || p_process_null_org_id);
1251: END IF;

Line 1248: oe_debug_pub.add ('Org Id: ' || p_operating_unit);

1244: END IF;
1245: IF l_debug_level > 0 THEN
1246: oe_debug_pub.add ('Sold To Org Id : ' || l_sold_to_org_Id);
1247: oe_debug_pub.add ('Sold To Org derived : ' || l_sold_to_org);
1248: oe_debug_pub.add ('Org Id: ' || p_operating_unit);
1249: oe_debug_pub.add ('Default Org Id: ' || p_default_org_id);
1250: oe_debug_pub.add ('Process Records with No Org Specified: ' || p_process_null_org_id);
1251: END IF;
1252:

Line 1249: oe_debug_pub.add ('Default Org Id: ' || p_default_org_id);

1245: IF l_debug_level > 0 THEN
1246: oe_debug_pub.add ('Sold To Org Id : ' || l_sold_to_org_Id);
1247: oe_debug_pub.add ('Sold To Org derived : ' || l_sold_to_org);
1248: oe_debug_pub.add ('Org Id: ' || p_operating_unit);
1249: oe_debug_pub.add ('Default Org Id: ' || p_default_org_id);
1250: oe_debug_pub.add ('Process Records with No Org Specified: ' || p_process_null_org_id);
1251: END IF;
1252:
1253: -----------------------------------------------------------

Line 1250: oe_debug_pub.add ('Process Records with No Org Specified: ' || p_process_null_org_id);

1246: oe_debug_pub.add ('Sold To Org Id : ' || l_sold_to_org_Id);
1247: oe_debug_pub.add ('Sold To Org derived : ' || l_sold_to_org);
1248: oe_debug_pub.add ('Org Id: ' || p_operating_unit);
1249: oe_debug_pub.add ('Default Org Id: ' || p_default_org_id);
1250: oe_debug_pub.add ('Process Records with No Org Specified: ' || p_process_null_org_id);
1251: END IF;
1252:
1253: -----------------------------------------------------------
1254: -- Delete Rows

Line 1315: oe_debug_pub.add('Fetched min order source id ' || l_min_order_source_id || ' and max order source id ' || l_max_order_source_id);

1311: INTO l_max_order_source_id, l_min_order_source_id
1312: FROM OE_Order_Sources;
1313:
1314: IF l_debug_level > 0 THEN
1315: oe_debug_pub.add('Fetched min order source id ' || l_min_order_source_id || ' and max order source id ' || l_max_order_source_id);
1316: END IF;
1317: END IF;
1318: END IF;
1319:

Line 1344: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for customer ref with org_id');

1340: AND c.customer_info_type_code = 'ACCOUNT';
1341: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
1342:
1343: IF l_debug_level > 0 THEN
1344: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for customer ref with org_id');
1345: END IF;
1346:
1347: -- Start MOAC
1348: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN

Line 1364: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

1360: AND h.org_id IS NULL)
1361: AND c.customer_info_type_code = 'ACCOUNT';
1362: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
1363: IF l_debug_level > 0 THEN
1364: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
1365: END IF;
1366: END IF;
1367: -- End MOAC
1368:

Line 1383: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records for sold to contact with org id');

1379: AND h.sold_to_contact_ref IS NOT NULL)
1380: AND c.customer_info_type_code = 'CONTACT';
1381: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
1382: IF l_debug_level > 0 THEN
1383: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records for sold to contact with org id');
1384: END IF;
1385:
1386: -- Start MOAC
1387: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN

Line 1403: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

1399: AND h.org_id IS NULL)
1400: AND c.customer_info_type_code = 'CONTACT';
1401: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
1402: IF l_debug_level > 0 THEN
1403: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
1404: END IF;
1405: END IF;
1406: -- End MOAC
1407:

Line 1422: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for bill to contact ref with org id');

1418: AND h.bill_to_contact_ref IS NOT NULL)
1419: AND c.customer_info_type_code = 'CONTACT';
1420: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
1421: IF l_debug_level > 0 THEN
1422: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for bill to contact ref with org id');
1423: END IF;
1424:
1425: -- Start MOAC
1426: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN

Line 1442: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

1438: AND h.org_id IS NULL)
1439: AND c.customer_info_type_code = 'CONTACT';
1440: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
1441: IF l_debug_level > 0 THEN
1442: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
1443: END IF;
1444: END IF;
1445: -- End MOAC
1446:

Line 1462: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for ship to contact ref with org id');

1458: AND h.ship_to_contact_ref IS NOT NULL)
1459: AND c.customer_info_type_code = 'CONTACT';
1460: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
1461: IF l_debug_level > 0 THEN
1462: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for ship to contact ref with org id');
1463: END IF;
1464:
1465: -- Start MOAC
1466: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN

Line 1482: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

1478: AND h.org_id IS NULL)
1479: AND c.customer_info_type_code = 'CONTACT';
1480: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
1481: IF l_debug_level > 0 THEN
1482: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
1483: END IF;
1484: END IF;
1485: -- End MOAC
1486:

Line 1501: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for deliver to contact ref with org id');

1497: AND h.deliver_to_contact_ref IS NOT NULL)
1498: AND c.customer_info_type_code = 'CONTACT';
1499: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
1500: IF l_debug_level > 0 THEN
1501: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for deliver to contact ref with org id');
1502: END IF;
1503:
1504: -- Start MOAC
1505: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN

Line 1521: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

1517: AND h.org_id IS NULL)
1518: AND c.customer_info_type_code = 'CONTACT';
1519: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
1520: IF l_debug_level > 0 THEN
1521: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
1522: END IF;
1523: END IF;
1524: -- End MOAC
1525:

Line 1541: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for ship address ref with org id');

1537: AND c.customer_info_type_code = 'ADDRESS';
1538: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
1539:
1540: IF l_debug_level > 0 THEN
1541: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for ship address ref with org id');
1542: END IF;
1543:
1544: -- Start MOAC
1545: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN

Line 1561: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

1557: AND h.org_id IS NULL)
1558: AND c.customer_info_type_code = 'ADDRESS';
1559: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
1560: IF l_debug_level > 0 THEN
1561: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
1562: END IF;
1563: END IF;
1564: -- End MOAC
1565:

Line 1580: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for bill address ref with org id');

1576: AND h.orig_bill_address_ref IS NOT NULL)
1577: AND c.customer_info_type_code = 'ADDRESS';
1578: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
1579: IF l_debug_level > 0 THEN
1580: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for bill address ref with org id');
1581: END IF;
1582:
1583: -- Start MOAC
1584: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN

Line 1600: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

1596: AND h.org_id IS NULL)
1597: AND c.customer_info_type_code = 'ADDRESS';
1598: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
1599: IF l_debug_level > 0 THEN
1600: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
1601: END IF;
1602: END IF;
1603: -- End MOAC
1604:

Line 1619: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for deliver address ref with org id');

1615: AND h.orig_deliver_address_ref IS NOT NULL)
1616: AND c.customer_info_type_code = 'ADDRESS';
1617: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
1618: IF l_debug_level > 0 THEN
1619: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for deliver address ref with org id');
1620: END IF;
1621:
1622: -- Start MOAC
1623: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN

Line 1639: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

1635: AND h.org_id IS NULL)
1636: AND c.customer_info_type_code = 'ADDRESS';
1637: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
1638: IF l_debug_level > 0 THEN
1639: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
1640: END IF;
1641: END IF;
1642: -- End MOAC
1643:

Line 1645: oe_debug_pub.add(l_cust_rows || ' rows deleted');

1641: END IF;
1642: -- End MOAC
1643:
1644: IF l_debug_level > 0 THEN
1645: oe_debug_pub.add(l_cust_rows || ' rows deleted');
1646: END IF;
1647: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Customer Info Interface (Header): '|| l_cust_rows);
1648: END IF;
1649:

Line 1652: oe_debug_pub.add('Deleting from OE_HEADERS_INTERFACE');

1648: END IF;
1649:
1650: IF l_header_iface THEN
1651: IF l_debug_level > 0 THEN
1652: oe_debug_pub.add('Deleting from OE_HEADERS_INTERFACE');
1653: END IF;
1654: l_count := 0;
1655:
1656: -- For the interface tables, we delete if either the sold to org or sold to org id

Line 1684: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

1680: OR l_sold_to_org = sold_to_org)
1681: AND org_id IS NULL;
1682: l_count := l_count + SQL%ROWCOUNT;
1683: IF l_debug_level > 0 THEN
1684: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
1685: END IF;
1686: END IF;
1687: -- End MOAC
1688: ELSE

Line 1712: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

1708: OR l_sold_to_org = sold_to_org)
1709: AND org_id IS NULL;
1710: l_count := l_count + SQL%ROWCOUNT;
1711: IF l_debug_level > 0 THEN
1712: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
1713: END IF;
1714: END IF;
1715: -- End MOAC
1716: END IF;

Line 1720: oe_debug_pub.add(l_count || ' rows deleted');

1716: END IF;
1717:
1718:
1719: IF l_debug_level > 0 THEN
1720: oe_debug_pub.add(l_count || ' rows deleted');
1721: END IF;
1722: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Headers Interface: '|| l_count);
1723: END IF;
1724:

Line 1727: oe_debug_pub.add('Deleting Header records from OE_ACTIONS_INTERFACE');

1723: END IF;
1724:
1725: IF l_header_actions THEN
1726: IF l_debug_level > 0 THEN
1727: oe_debug_pub.add('Deleting Header records from OE_ACTIONS_INTERFACE');
1728: END IF;
1729: l_count := 0;
1730:
1731: IF p_order_source_id IS NOT NULL THEN

Line 1758: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

1754: OR l_sold_to_org = sold_to_org)
1755: AND org_id IS NULL;
1756: l_count := l_count + SQL%ROWCOUNT;
1757: IF l_debug_level > 0 THEN
1758: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
1759: END IF;
1760: END IF;
1761: -- End MOAC
1762: ELSE

Line 1788: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

1784: OR l_sold_to_org = sold_to_org)
1785: AND org_id IS NULL;
1786: l_count := l_count + SQL%ROWCOUNT;
1787: IF l_debug_level > 0 THEN
1788: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
1789: END IF;
1790: END IF;
1791: -- End MOAC
1792: END IF;

Line 1795: oe_debug_pub.add(SQL%ROWCOUNT || ' rows deleted');

1791: -- End MOAC
1792: END IF;
1793:
1794: IF l_debug_level > 0 THEN
1795: oe_debug_pub.add(SQL%ROWCOUNT || ' rows deleted');
1796: END IF;
1797: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Actions Interface (Header): '|| l_count);
1798: END IF;
1799: IF l_header_credits THEN

Line 1801: oe_debug_pub.add('Deleting Header records from OE_CREDITS_INTERFACE');

1797: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Actions Interface (Header): '|| l_count);
1798: END IF;
1799: IF l_header_credits THEN
1800: IF l_debug_level > 0 THEN
1801: oe_debug_pub.add('Deleting Header records from OE_CREDITS_INTERFACE');
1802: END IF;
1803: l_count := 0;
1804:
1805: IF p_order_source_id IS NOT NULL THEN

Line 1831: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

1827: OR l_sold_to_org = sold_to_org)
1828: AND org_id IS NULL;
1829: l_count := l_count + SQL%ROWCOUNT;
1830: IF l_debug_level > 0 THEN
1831: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
1832: END IF;
1833: END IF;
1834: -- End MOAC
1835: ELSE

Line 1861: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

1857: OR l_sold_to_org = sold_to_org)
1858: AND org_id IS NULL;
1859: l_count := l_count + SQL%ROWCOUNT;
1860: IF l_debug_level > 0 THEN
1861: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
1862: END IF;
1863: END IF;
1864: -- End MOAC
1865: END IF;

Line 1868: oe_debug_pub.add(l_count || ' rows deleted');

1864: -- End MOAC
1865: END IF;
1866:
1867: IF l_debug_level > 0 THEN
1868: oe_debug_pub.add(l_count || ' rows deleted');
1869: END IF;
1870: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Credits Interface (Header): '|| l_count);
1871: END IF;
1872: IF l_header_price_adj THEN

Line 1874: oe_debug_pub.add('Deleting Header records from OE_PRICE_ADJS_INTERFACE');

1870: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Credits Interface (Header): '|| l_count);
1871: END IF;
1872: IF l_header_price_adj THEN
1873: IF l_debug_level > 0 THEN
1874: oe_debug_pub.add('Deleting Header records from OE_PRICE_ADJS_INTERFACE');
1875: END IF;
1876: l_count := 0;
1877:
1878: IF p_order_source_id IS NOT NULL THEN

Line 1904: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

1900: OR l_sold_to_org = sold_to_org)
1901: AND org_id IS NULL;
1902: l_count := l_count + SQL%ROWCOUNT;
1903: IF l_debug_level > 0 THEN
1904: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
1905: END IF;
1906: END IF;
1907: -- End MOAC
1908: ELSE

Line 1934: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

1930: OR l_sold_to_org = sold_to_org)
1931: AND org_id IS NULL;
1932: l_count := l_count + SQL%ROWCOUNT;
1933: IF l_debug_level > 0 THEN
1934: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
1935: END IF;
1936: END IF;
1937: -- End MOAC
1938: END IF;

Line 1941: oe_debug_pub.add(l_count || ' rows deleted');

1937: -- End MOAC
1938: END IF;
1939:
1940: IF l_debug_level > 0 THEN
1941: oe_debug_pub.add(l_count || ' rows deleted');
1942: END IF;
1943: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Price Adjustments Interface (Header): '|| l_count);
1944: END IF;
1945: IF l_header_price_att THEN

Line 1947: oe_debug_pub.add('Deleting Header records from OE_PRICE_ATTS_INTERFACE');

1943: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Price Adjustments Interface (Header): '|| l_count);
1944: END IF;
1945: IF l_header_price_att THEN
1946: IF l_debug_level > 0 THEN
1947: oe_debug_pub.add('Deleting Header records from OE_PRICE_ATTS_INTERFACE');
1948: END IF;
1949: l_count := 0;
1950:
1951: IF p_order_source_id IS NOT NULL THEN

Line 1977: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

1973: OR l_sold_to_org = sold_to_org)
1974: AND org_id IS NULL;
1975: l_count := l_count + SQL%ROWCOUNT;
1976: IF l_debug_level > 0 THEN
1977: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
1978: END IF;
1979: END IF;
1980: -- End MOAC
1981: ELSE

Line 2007: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2003: OR l_sold_to_org = sold_to_org)
2004: AND org_id IS NULL;
2005: l_count := l_count + SQL%ROWCOUNT;
2006: IF l_debug_level > 0 THEN
2007: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2008: END IF;
2009: END IF;
2010: -- End MOAC
2011: END IF;

Line 2014: oe_debug_pub.add(l_count || ' rows deleted');

2010: -- End MOAC
2011: END IF;
2012:
2013: IF l_debug_level > 0 THEN
2014: oe_debug_pub.add(l_count || ' rows deleted');
2015: END IF;
2016: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Pricing Attributes Interface (Header): '|| l_count);
2017: END IF;
2018:

Line 2021: oe_debug_pub.add('Deleting Header records from OE_PAYMENTS_INTERFACE');

2017: END IF;
2018:
2019: IF l_header_payments THEN
2020: IF l_debug_level > 0 THEN
2021: oe_debug_pub.add('Deleting Header records from OE_PAYMENTS_INTERFACE');
2022: END IF;
2023: l_count := 0;
2024:
2025: IF p_order_source_id IS NOT NULL THEN

Line 2051: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2047: OR l_sold_to_org = sold_to_org)
2048: AND org_id IS NULL;
2049: l_count := l_count + SQL%ROWCOUNT;
2050: IF l_debug_level > 0 THEN
2051: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2052: END IF;
2053: END IF;
2054: -- End MOAC
2055: ELSE

Line 2081: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2077: OR l_sold_to_org = sold_to_org)
2078: AND org_id IS NULL;
2079: l_count := l_count + SQL%ROWCOUNT;
2080: IF l_debug_level > 0 THEN
2081: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2082: END IF;
2083: END IF;
2084: -- End MOAC
2085: END IF;

Line 2088: oe_debug_pub.add(l_count || ' rows deleted');

2084: -- End MOAC
2085: END IF;
2086:
2087: IF l_debug_level > 0 THEN
2088: oe_debug_pub.add(l_count || ' rows deleted');
2089: END IF;
2090: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Payments Interface (Header): '|| l_count);
2091: END IF;
2092:

Line 2119: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for bill to contact ref with org id');

2115: AND h.bill_to_contact_ref IS NOT NULL)
2116: AND c.customer_info_type_code = 'CONTACT';
2117: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
2118: IF l_debug_level > 0 THEN
2119: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for bill to contact ref with org id');
2120: END IF;
2121:
2122: -- Start MOAC
2123: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN

Line 2139: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2135: AND h.org_id IS NULL)
2136: AND c.customer_info_type_code = 'CONTACT';
2137: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
2138: IF l_debug_level > 0 THEN
2139: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2140: END IF;
2141: END IF;
2142: -- End MOAC
2143:

Line 2158: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for ship to contact ref with org id');

2154: AND h.ship_to_contact_ref IS NOT NULL)
2155: AND c.customer_info_type_code = 'CONTACT';
2156: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
2157: IF l_debug_level > 0 THEN
2158: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for ship to contact ref with org id');
2159: END IF;
2160:
2161: -- Start MOAC
2162: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN

Line 2178: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2174: AND h.org_id IS NULL)
2175: AND c.customer_info_type_code = 'CONTACT';
2176: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
2177: IF l_debug_level > 0 THEN
2178: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2179: END IF;
2180: END IF;
2181: -- End MOAC
2182:

Line 2197: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for deliver to contact ref with org id');

2193: AND h.deliver_to_contact_ref IS NOT NULL)
2194: AND c.customer_info_type_code = 'CONTACT';
2195: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
2196: IF l_debug_level > 0 THEN
2197: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for deliver to contact ref with org id');
2198: END IF;
2199:
2200: -- Start MOAC
2201: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN

Line 2217: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2213: AND h.org_id IS NULL)
2214: AND c.customer_info_type_code = 'CONTACT';
2215: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
2216: IF l_debug_level > 0 THEN
2217: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2218: END IF;
2219: END IF;
2220: -- End MOAC
2221:

Line 2236: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for ship to address ref with org id');

2232: AND h.orig_ship_address_ref IS NOT NULL)
2233: AND c.customer_info_type_code = 'ADDRESS';
2234: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
2235: IF l_debug_level > 0 THEN
2236: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for ship to address ref with org id');
2237: END IF;
2238:
2239: -- Start MOAC
2240: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN

Line 2256: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2252: AND h.org_id IS NULL)
2253: AND c.customer_info_type_code = 'ADDRESS';
2254: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
2255: IF l_debug_level > 0 THEN
2256: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2257: END IF;
2258: END IF;
2259: -- End MOAC
2260:

Line 2275: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for bill to address ref with org id');

2271: AND h.orig_bill_address_ref IS NOT NULL)
2272: AND c.customer_info_type_code = 'ADDRESS';
2273: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
2274: IF l_debug_level > 0 THEN
2275: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for bill to address ref with org id');
2276: END IF;
2277:
2278: -- Start MOAC
2279: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN

Line 2295: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2291: AND h.org_id IS NULL)
2292: AND c.customer_info_type_code = 'ADDRESS';
2293: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
2294: IF l_debug_level > 0 THEN
2295: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2296: END IF;
2297: END IF;
2298: -- End MOAC
2299:

Line 2314: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for deliver address ref with org id');

2310: AND h.orig_deliver_address_ref IS NOT NULL)
2311: AND c.customer_info_type_code = 'ADDRESS';
2312: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
2313: IF l_debug_level > 0 THEN
2314: oe_debug_pub.add('Deleted '|| l_cust_rows || ' records for deliver address ref with org id');
2315: END IF;
2316:
2317: -- Start MOAC
2318: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN

Line 2334: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2330: AND h.org_id IS NULL)
2331: AND c.customer_info_type_code = 'ADDRESS';
2332: l_cust_rows := l_cust_rows + SQL%ROWCOUNT;
2333: IF l_debug_level > 0 THEN
2334: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2335: END IF;
2336: END IF;
2337: -- End MOAC
2338:

Line 2340: oe_debug_pub.add(l_cust_rows || ' rows deleted');

2336: END IF;
2337: -- End MOAC
2338:
2339: IF l_debug_level > 0 THEN
2340: oe_debug_pub.add(l_cust_rows || ' rows deleted');
2341: END IF;
2342: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Customer Info Interface (Line): '|| l_cust_rows);
2343: END IF;
2344: IF l_line_iface THEN

Line 2346: oe_debug_pub.add('Deleting from OE_LINES_INTERFACE');

2342: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Customer Info Interface (Line): '|| l_cust_rows);
2343: END IF;
2344: IF l_line_iface THEN
2345: IF l_debug_level > 0 THEN
2346: oe_debug_pub.add('Deleting from OE_LINES_INTERFACE');
2347: END IF;
2348: l_count := 0;
2349: IF p_order_source_id IS NOT NULL THEN
2350: DELETE

Line 2373: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2369: OR l_sold_to_org = sold_to_org)
2370: AND org_id IS NULL;
2371: l_count := l_count + SQL%ROWCOUNT;
2372: IF l_debug_level > 0 THEN
2373: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2374: END IF;
2375: END IF;
2376: -- End MOAC
2377: ELSE

Line 2401: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2397: OR l_sold_to_org = sold_to_org)
2398: AND org_id IS NULL;
2399: l_count := l_count + SQL%ROWCOUNT;
2400: IF l_debug_level > 0 THEN
2401: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2402: END IF;
2403: END IF;
2404: -- End MOAC
2405: END IF;

Line 2408: oe_debug_pub.add(l_count || ' rows deleted');

2404: -- End MOAC
2405: END IF;
2406:
2407: IF l_debug_level > 0 THEN
2408: oe_debug_pub.add(l_count || ' rows deleted');
2409: END IF;
2410: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Lines Interface: '|| l_count);
2411: END IF;
2412:

Line 2415: oe_debug_pub.add('Deleting Line records from OE_ACTIONS_INTERFACE');

2411: END IF;
2412:
2413: IF l_line_actions THEN
2414: IF l_debug_level > 0 THEN
2415: oe_debug_pub.add('Deleting Line records from OE_ACTIONS_INTERFACE');
2416: END IF;
2417: l_count := 0;
2418:
2419: IF p_order_source_id IS NOT NULL THEN

Line 2445: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2441: OR l_sold_to_org = sold_to_org)
2442: AND org_id IS NULL;
2443: l_count := l_count + SQL%ROWCOUNT;
2444: IF l_debug_level > 0 THEN
2445: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2446: END IF;
2447: END IF;
2448: -- End MOAC
2449: ELSE

Line 2475: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2471: OR l_sold_to_org = sold_to_org)
2472: AND org_id IS NULL;
2473: l_count := l_count + SQL%ROWCOUNT;
2474: IF l_debug_level > 0 THEN
2475: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2476: END IF;
2477: END IF;
2478: -- End MOAC
2479: END IF;

Line 2481: oe_debug_pub.add(l_count || ' rows deleted');

2477: END IF;
2478: -- End MOAC
2479: END IF;
2480: IF l_debug_level > 0 THEN
2481: oe_debug_pub.add(l_count || ' rows deleted');
2482: END IF;
2483: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Actions Interface (Line): '|| l_count);
2484: END IF;
2485: IF l_line_credits THEN

Line 2487: oe_debug_pub.add('Deleting Line records from OE_CREDITS_INTERFACE');

2483: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Actions Interface (Line): '|| l_count);
2484: END IF;
2485: IF l_line_credits THEN
2486: IF l_debug_level > 0 THEN
2487: oe_debug_pub.add('Deleting Line records from OE_CREDITS_INTERFACE');
2488: END IF;
2489: l_count := 0;
2490:
2491: IF p_order_source_id IS NOT NULL THEN

Line 2517: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2513: OR l_sold_to_org = sold_to_org)
2514: AND org_id IS NULL;
2515: l_count := l_count + SQL%ROWCOUNT;
2516: IF l_debug_level > 0 THEN
2517: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2518: END IF;
2519: END IF;
2520: -- End MOAC
2521: ELSE

Line 2547: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2543: OR l_sold_to_org = sold_to_org)
2544: AND org_id IS NULL;
2545: l_count := l_count + SQL%ROWCOUNT;
2546: IF l_debug_level > 0 THEN
2547: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2548: END IF;
2549: END IF;
2550: -- End MOAC
2551: END IF;

Line 2553: oe_debug_pub.add(l_count || ' rows deleted');

2549: END IF;
2550: -- End MOAC
2551: END IF;
2552: IF l_debug_level > 0 THEN
2553: oe_debug_pub.add(l_count || ' rows deleted');
2554: END IF;
2555: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Credits Interface (Line): '|| l_count);
2556: END IF;
2557: IF l_line_lotserial THEN

Line 2559: oe_debug_pub.add('Deleting Line records from OE_LOTSERIALS_INTERFACE');

2555: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Credits Interface (Line): '|| l_count);
2556: END IF;
2557: IF l_line_lotserial THEN
2558: IF l_debug_level > 0 THEN
2559: oe_debug_pub.add('Deleting Line records from OE_LOTSERIALS_INTERFACE');
2560: END IF;
2561: l_count := 0;
2562:
2563: IF p_order_source_id IS NOT NULL THEN

Line 2589: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2585: OR l_sold_to_org = sold_to_org)
2586: AND org_id IS NULL;
2587: l_count := l_count + SQL%ROWCOUNT;
2588: IF l_debug_level > 0 THEN
2589: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2590: END IF;
2591: END IF;
2592: -- End MOAC
2593: ELSE

Line 2619: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2615: OR l_sold_to_org = sold_to_org)
2616: AND org_id IS NULL;
2617: l_count := l_count + SQL%ROWCOUNT;
2618: IF l_debug_level > 0 THEN
2619: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2620: END IF;
2621: END IF;
2622: -- End MOAC
2623: END IF;

Line 2625: oe_debug_pub.add(l_count || ' rows deleted');

2621: END IF;
2622: -- End MOAC
2623: END IF;
2624: IF l_debug_level > 0 THEN
2625: oe_debug_pub.add(l_count || ' rows deleted');
2626: END IF;
2627: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Lotserials Interface (Line): '|| l_count );
2628: END IF;
2629: IF l_line_price_adj THEN

Line 2631: oe_debug_pub.add('Deleting Line records from OE_PRICE_ADJS_INTERFACE');

2627: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Lotserials Interface (Line): '|| l_count );
2628: END IF;
2629: IF l_line_price_adj THEN
2630: IF l_debug_level > 0 THEN
2631: oe_debug_pub.add('Deleting Line records from OE_PRICE_ADJS_INTERFACE');
2632: END IF;
2633: l_count := 0;
2634:
2635: IF p_order_source_id IS NOT NULL THEN

Line 2661: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2657: OR l_sold_to_org = sold_to_org)
2658: AND org_id IS NULL;
2659: l_count := l_count + SQL%ROWCOUNT;
2660: IF l_debug_level > 0 THEN
2661: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2662: END IF;
2663: END IF;
2664: -- End MOAC
2665: ELSE

Line 2691: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2687: OR l_sold_to_org = sold_to_org)
2688: AND org_id IS NULL;
2689: l_count := l_count + SQL%ROWCOUNT;
2690: IF l_debug_level > 0 THEN
2691: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2692: END IF;
2693: END IF;
2694: -- End MOAC
2695: END IF;

Line 2697: oe_debug_pub.add(l_count || ' rows deleted');

2693: END IF;
2694: -- End MOAC
2695: END IF;
2696: IF l_debug_level > 0 THEN
2697: oe_debug_pub.add(l_count || ' rows deleted');
2698: END IF;
2699: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Price Adjustments Interface (Line): '|| l_count );
2700: END IF;
2701: IF l_line_price_att THEN

Line 2703: oe_debug_pub.add('Deleting Line records from OE_PRICE_ATTS_INTERFACE');

2699: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Price Adjustments Interface (Line): '|| l_count );
2700: END IF;
2701: IF l_line_price_att THEN
2702: IF l_debug_level > 0 THEN
2703: oe_debug_pub.add('Deleting Line records from OE_PRICE_ATTS_INTERFACE');
2704: END IF;
2705: l_count := 0;
2706:
2707: IF p_order_source_id IS NOT NULL THEN

Line 2733: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2729: OR l_sold_to_org = sold_to_org)
2730: AND org_id IS NULL;
2731: l_count := l_count + SQL%ROWCOUNT;
2732: IF l_debug_level > 0 THEN
2733: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2734: END IF;
2735: END IF;
2736: -- End MOAC
2737: ELSE

Line 2763: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2759: OR l_sold_to_org = sold_to_org)
2760: AND org_id IS NULL;
2761: l_count := l_count + SQL%ROWCOUNT;
2762: IF l_debug_level > 0 THEN
2763: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2764: END IF;
2765: END IF;
2766: -- End MOAC
2767: END IF;

Line 2769: oe_debug_pub.add(l_count || ' rows deleted');

2765: END IF;
2766: -- End MOAC
2767: END IF;
2768: IF l_debug_level > 0 THEN
2769: oe_debug_pub.add(l_count || ' rows deleted');
2770: END IF;
2771: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Pricing Attributes Interface (Line): '|| l_count );
2772: END IF;
2773: IF l_line_reservtns THEN

Line 2775: oe_debug_pub.add('Deleting Line records from OE_RESERVTNS_INTERFACE');

2771: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Pricing Attributes Interface (Line): '|| l_count );
2772: END IF;
2773: IF l_line_reservtns THEN
2774: IF l_debug_level > 0 THEN
2775: oe_debug_pub.add('Deleting Line records from OE_RESERVTNS_INTERFACE');
2776: END IF;
2777: l_count := 0;
2778:
2779: IF p_order_source_id IS NOT NULL THEN

Line 2805: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2801: OR l_sold_to_org = sold_to_org)
2802: AND org_id IS NULL;
2803: l_count := l_count + SQL%ROWCOUNT;
2804: IF l_debug_level > 0 THEN
2805: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2806: END IF;
2807: END IF;
2808: -- End MOAC
2809: ELSE

Line 2835: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2831: OR l_sold_to_org = sold_to_org)
2832: AND org_id IS NULL;
2833: l_count := l_count + SQL%ROWCOUNT;
2834: IF l_debug_level > 0 THEN
2835: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2836: END IF;
2837: END IF;
2838: -- End MOAC
2839: END IF;

Line 2841: oe_debug_pub.add(l_count || ' rows deleted');

2837: END IF;
2838: -- End MOAC
2839: END IF;
2840: IF l_debug_level > 0 THEN
2841: oe_debug_pub.add(l_count || ' rows deleted');
2842: END IF;
2843: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Reservations Interface (Line): '|| l_count );
2844: END IF;
2845:

Line 2848: oe_debug_pub.add('Deleting Line records from OE_PAYMENTS_INTERFACE');

2844: END IF;
2845:
2846: IF l_line_payments THEN
2847: IF l_debug_level > 0 THEN
2848: oe_debug_pub.add('Deleting Line records from OE_PAYMENTS_INTERFACE');
2849: END IF;
2850: l_count := 0;
2851:
2852: IF p_order_source_id IS NOT NULL THEN

Line 2878: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2874: OR l_sold_to_org = sold_to_org)
2875: AND org_id IS NULL;
2876: l_count := l_count + SQL%ROWCOUNT;
2877: IF l_debug_level > 0 THEN
2878: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2879: END IF;
2880: END IF;
2881: -- End MOAC
2882: ELSE

Line 2908: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');

2904: OR l_sold_to_org = sold_to_org)
2905: AND org_id IS NULL;
2906: l_count := l_count + SQL%ROWCOUNT;
2907: IF l_debug_level > 0 THEN
2908: oe_debug_pub.add('Deleted '|| SQL%ROWCOUNT || ' records with NULL Org Id');
2909: END IF;
2910: END IF;
2911: -- End MOAC
2912: END IF;

Line 2914: oe_debug_pub.add(l_count || ' rows deleted');

2910: END IF;
2911: -- End MOAC
2912: END IF;
2913: IF l_debug_level > 0 THEN
2914: oe_debug_pub.add(l_count || ' rows deleted');
2915: END IF;
2916: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Payments Interface (Line): '|| l_count );
2917: END IF;
2918:

Line 2921: oe_debug_pub.add('Deleting Acknowledged Header records from OE_HEADER_ACKS');

2917: END IF;
2918:
2919: IF l_header_acks THEN
2920: IF l_debug_level > 0 THEN
2921: oe_debug_pub.add('Deleting Acknowledged Header records from OE_HEADER_ACKS');
2922: END IF;
2923: l_count := 0;
2924:
2925: IF p_orig_sys_document_ref_from IS NOT NULL

Line 2963: oe_debug_pub.add(l_count || ' rows deleted');

2959: END IF;
2960: l_count := l_count + SQL%ROWCOUNT;
2961:
2962: IF l_debug_level > 0 THEN
2963: oe_debug_pub.add(l_count || ' rows deleted');
2964: END IF;
2965: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Header Acknowledgments: '|| l_count );
2966: END IF;
2967: IF l_line_acks THEN

Line 2969: oe_debug_pub.add('Deleting Acknowledged Line records from OE_LINE_ACKS');

2965: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Header Acknowledgments: '|| l_count );
2966: END IF;
2967: IF l_line_acks THEN
2968: IF l_debug_level > 0 THEN
2969: oe_debug_pub.add('Deleting Acknowledged Line records from OE_LINE_ACKS');
2970: END IF;
2971: l_count := 0;
2972:
2973: IF p_orig_sys_document_ref_from IS NOT NULL

Line 3011: oe_debug_pub.add(l_count || ' rows deleted');

3007: END IF;
3008:
3009: l_count := l_count + SQL%ROWCOUNT;
3010: IF l_debug_level > 0 THEN
3011: oe_debug_pub.add(l_count || ' rows deleted');
3012: END IF;
3013: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Line Acknowledgments: '|| l_count);
3014: END IF;
3015: IF l_elecmsgs THEN

Line 3017: oe_debug_pub.add('Deleting records from OE_EM_INFORMATION');

3013: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Line Acknowledgments: '|| l_count);
3014: END IF;
3015: IF l_elecmsgs THEN
3016: IF l_debug_level > 0 THEN
3017: oe_debug_pub.add('Deleting records from OE_EM_INFORMATION');
3018: END IF;
3019: l_count := 0;
3020:
3021: IF p_order_source_id IS NOT NULL AND l_sold_to_org_id IS NOT NULL THEN

Line 3053: oe_debug_pub.add(l_count || ' rows deleted');

3049: END IF;
3050: l_count := l_count + SQL%ROWCOUNT;
3051:
3052: IF l_debug_level > 0 THEN
3053: oe_debug_pub.add(l_count || ' rows deleted');
3054: END IF;
3055: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Open Interface Tracking table: '|| l_count);
3056: END IF;
3057:

Line 3060: oe_debug_pub.add('Program exited normally');

3056: END IF;
3057:
3058: retcode := 0;
3059: IF l_debug_level > 0 THEN
3060: oe_debug_pub.add('Program exited normally');
3061: END IF;
3062: fnd_file.put_line(FND_FILE.OUTPUT, '');
3063: fnd_file.put_line(FND_FILE.OUTPUT, 'Program exited with code : ' || retcode);
3064: EXCEPTION

Line 3070: oe_debug_pub.add( 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE ) ;

3066: WHEN OTHERS THEN
3067: retcode := 2;
3068: errbuf := SQLERRM;
3069: IF l_debug_level > 0 THEN
3070: oe_debug_pub.add( 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE ) ;
3071: END IF;
3072: fnd_file.put_line(FND_FILE.OUTPUT, '');
3073: fnd_file.put_line(FND_FILE.OUTPUT, 'Program exited with code : '||retcode);
3074: fnd_file.put_line(FND_FILE.OUTPUT, 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE );

Line 3087: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

3083:
3084: PROCEDURE Initialize_EM_Access_List (X_Access_List OUT NOCOPY OE_GLOBALS.ACCESS_LIST)
3085: IS
3086: --
3087: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3088: --
3089: BEGIN
3090: IF l_debug_level > 0 THEN
3091: oe_debug_pub.add( 'ENTERING OE_ELECMSGS_PVT.INITIALIZE_ACCESS_LIST') ;

Line 3091: oe_debug_pub.add( 'ENTERING OE_ELECMSGS_PVT.INITIALIZE_ACCESS_LIST') ;

3087: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3088: --
3089: BEGIN
3090: IF l_debug_level > 0 THEN
3091: oe_debug_pub.add( 'ENTERING OE_ELECMSGS_PVT.INITIALIZE_ACCESS_LIST') ;
3092: END IF;
3093:
3094: IF FND_FUNCTION.TEST('ONT_OEXOEORD_RETRY_WF') THEN
3095: Add_Access('RETRY_WF');

Line 3103: oe_debug_pub.add( 'EXITING OE_ELECMSGS_PVT.INITIALIZE_ACCESS_LIST') ;

3099: Add_Access('PROCESS_MESSAGES');
3100: END IF;
3101:
3102: IF l_debug_level > 0 THEN
3103: oe_debug_pub.add( 'EXITING OE_ELECMSGS_PVT.INITIALIZE_ACCESS_LIST') ;
3104: END IF;
3105:
3106: X_Access_List := OE_GLOBALS.G_EM_ACCESS_LIST;
3107: END Initialize_EM_Access_List;

Line 3113: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

3109: PROCEDURE Add_Access(Function_Name VARCHAR2)
3110: IS
3111: i number:=0;
3112: --
3113: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3114: --
3115: BEGIN
3116: IF l_debug_level > 0 THEN
3117: oe_debug_pub.add( 'ENTERING OE_ELECMSGS_PVT.ADD_ACCESS' ) ;

Line 3117: oe_debug_pub.add( 'ENTERING OE_ELECMSGS_PVT.ADD_ACCESS' ) ;

3113: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3114: --
3115: BEGIN
3116: IF l_debug_level > 0 THEN
3117: oe_debug_pub.add( 'ENTERING OE_ELECMSGS_PVT.ADD_ACCESS' ) ;
3118: END IF;
3119: IF OE_GLOBALS.G_EM_ACCESS_List.Count=0 THEN
3120: OE_GLOBALS.G_EM_Access_List(1):=Function_Name;
3121: ELSIF OE_GLOBALS.G_EM_ACCESS_List.Count>0 THEN

Line 3126: oe_debug_pub.add( 'EXITING OE_ELECMSGS_PVT.ADD_ACCESS') ;

3122: i:=OE_GLOBALS.G_EM_ACCESS_List.Last+1;
3123: OE_GLOBALS.G_EM_ACCESS_List(i):=Function_Name;
3124: END IF;
3125: IF l_debug_level > 0 THEN
3126: oe_debug_pub.add( 'EXITING OE_ELECMSGS_PVT.ADD_ACCESS') ;
3127: END IF;
3128: EXCEPTION
3129: When Others Then
3130: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)