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.WSH_ITM_PARTY_SYNC dependencies on WSH_DEBUG_SV

Line 535: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

531: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
532: --
533: IF l_debug_on IS NULL
534: THEN
535: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
536: END IF;
537: --
538: --
539: -- Debug Statements

Line 542: WSH_DEBUG_SV.push(l_module_name);

538: --
539: -- Debug Statements
540: --
541: IF l_debug_on THEN
542: WSH_DEBUG_SV.push(l_module_name);
543: --
544: WSH_DEBUG_SV.log(l_module_name,'P_PARTY_TYPE',P_PARTY_TYPE);
545: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_CODE',P_FROM_PARTY_CODE);
546: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_CODE',P_TO_PARTY_CODE);

Line 544: WSH_DEBUG_SV.log(l_module_name,'P_PARTY_TYPE',P_PARTY_TYPE);

540: --
541: IF l_debug_on THEN
542: WSH_DEBUG_SV.push(l_module_name);
543: --
544: WSH_DEBUG_SV.log(l_module_name,'P_PARTY_TYPE',P_PARTY_TYPE);
545: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_CODE',P_FROM_PARTY_CODE);
546: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_CODE',P_TO_PARTY_CODE);
547: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY',P_DUMMY);
548: WSH_DEBUG_SV.log(l_module_name,'P_SITE_USE_CODE',P_SITE_USE_CODE);

Line 545: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_CODE',P_FROM_PARTY_CODE);

541: IF l_debug_on THEN
542: WSH_DEBUG_SV.push(l_module_name);
543: --
544: WSH_DEBUG_SV.log(l_module_name,'P_PARTY_TYPE',P_PARTY_TYPE);
545: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_CODE',P_FROM_PARTY_CODE);
546: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_CODE',P_TO_PARTY_CODE);
547: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY',P_DUMMY);
548: WSH_DEBUG_SV.log(l_module_name,'P_SITE_USE_CODE',P_SITE_USE_CODE);
549: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_N_DAYS',P_CREATED_N_DAYS);

Line 546: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_CODE',P_TO_PARTY_CODE);

542: WSH_DEBUG_SV.push(l_module_name);
543: --
544: WSH_DEBUG_SV.log(l_module_name,'P_PARTY_TYPE',P_PARTY_TYPE);
545: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_CODE',P_FROM_PARTY_CODE);
546: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_CODE',P_TO_PARTY_CODE);
547: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY',P_DUMMY);
548: WSH_DEBUG_SV.log(l_module_name,'P_SITE_USE_CODE',P_SITE_USE_CODE);
549: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_N_DAYS',P_CREATED_N_DAYS);
550: WSH_DEBUG_SV.log(l_module_name,'P_UPDATED_N_DAYS',P_UPDATED_N_DAYS);

Line 547: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY',P_DUMMY);

543: --
544: WSH_DEBUG_SV.log(l_module_name,'P_PARTY_TYPE',P_PARTY_TYPE);
545: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_CODE',P_FROM_PARTY_CODE);
546: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_CODE',P_TO_PARTY_CODE);
547: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY',P_DUMMY);
548: WSH_DEBUG_SV.log(l_module_name,'P_SITE_USE_CODE',P_SITE_USE_CODE);
549: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_N_DAYS',P_CREATED_N_DAYS);
550: WSH_DEBUG_SV.log(l_module_name,'P_UPDATED_N_DAYS',P_UPDATED_N_DAYS);
551: END IF;

Line 548: WSH_DEBUG_SV.log(l_module_name,'P_SITE_USE_CODE',P_SITE_USE_CODE);

544: WSH_DEBUG_SV.log(l_module_name,'P_PARTY_TYPE',P_PARTY_TYPE);
545: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_CODE',P_FROM_PARTY_CODE);
546: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_CODE',P_TO_PARTY_CODE);
547: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY',P_DUMMY);
548: WSH_DEBUG_SV.log(l_module_name,'P_SITE_USE_CODE',P_SITE_USE_CODE);
549: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_N_DAYS',P_CREATED_N_DAYS);
550: WSH_DEBUG_SV.log(l_module_name,'P_UPDATED_N_DAYS',P_UPDATED_N_DAYS);
551: END IF;
552: --

Line 549: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_N_DAYS',P_CREATED_N_DAYS);

545: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_CODE',P_FROM_PARTY_CODE);
546: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_CODE',P_TO_PARTY_CODE);
547: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY',P_DUMMY);
548: WSH_DEBUG_SV.log(l_module_name,'P_SITE_USE_CODE',P_SITE_USE_CODE);
549: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_N_DAYS',P_CREATED_N_DAYS);
550: WSH_DEBUG_SV.log(l_module_name,'P_UPDATED_N_DAYS',P_UPDATED_N_DAYS);
551: END IF;
552: --
553: --gtm flow check

Line 550: WSH_DEBUG_SV.log(l_module_name,'P_UPDATED_N_DAYS',P_UPDATED_N_DAYS);

546: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_CODE',P_TO_PARTY_CODE);
547: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY',P_DUMMY);
548: WSH_DEBUG_SV.log(l_module_name,'P_SITE_USE_CODE',P_SITE_USE_CODE);
549: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_N_DAYS',P_CREATED_N_DAYS);
550: WSH_DEBUG_SV.log(l_module_name,'P_UPDATED_N_DAYS',P_UPDATED_N_DAYS);
551: END IF;
552: --
553: --gtm flow check
554: OPEN cur_check_gtm_flows;

Line 577: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);

573: --
574: -- Debug Statements
575: --
576: IF l_debug_on THEN
577: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
578: END IF;
579: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND PARTY.PARTY_NAME >= :b_from_party', l_Party_Condn1Tab, 'VARCHAR');
580:
581: ELSIF (p_party_type = 'CARRIER' ) THEN

Line 593: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);

589: --
590: -- Debug Statements
591: --
592: IF l_debug_on THEN
593: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
594: END IF;
595: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_NAME >= :b_from_party', l_Carrier_Condn1Tab, 'VARCHAR');
596:
597: ELSE

Line 609: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);

605: --
606: -- Debug Statements
607: --
608: IF l_debug_on THEN
609: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
610: END IF;
611: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_NAME >= :b_from_party', l_Carrier_Condn1Tab, 'VARCHAR');
612:
613: END IF; -- } party_type

Line 631: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);

627: --
628: -- Debug Statements
629: --
630: IF l_debug_on THEN
631: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
632: END IF;
633: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND PARTY.PARTY_NAME <= :b_to_party', l_Party_Condn11Tab, 'VARCHAR');
634:
635: ELSIF (p_party_type = 'CARRIER' ) THEN

Line 647: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);

643: --
644: -- Debug Statements
645: --
646: IF l_debug_on THEN
647: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
648: END IF;
649: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_NAME <= :b_to_party', l_Carrier_Condn11Tab, 'VARCHAR');
650:
651: -- gtm

Line 664: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);

660: --
661: -- Debug Statements
662: --
663: IF l_debug_on THEN
664: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
665: END IF;
666: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_NAME <= :b_to_party', l_Carrier_Condn11Tab, 'VARCHAR');
667:
668: END IF; -- } party_type

Line 680: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);

676: --
677: -- Debug Statements
678: --
679: IF l_debug_on THEN
680: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
681: END IF;
682: --
683: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_TYPE = :b_party_type', l_gtm_Condn1Tab, 'VARCHAR');
684: END IF;

Line 694: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);

690: --
691: -- Debug Statements
692: --
693: IF l_debug_on THEN
694: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
695: END IF;
696: --
697: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND SITE_USES.SITE_USE_CODE = :b_site_use_code', l_Party_Condn2Tab, 'VARCHAR');
698: END IF;

Line 716: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);

712: --
713: -- Debug Statements
714: --
715: IF l_debug_on THEN
716: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
717: END IF;
718: --
719: IF p_party_type = 'CUSTOMER' OR p_party_type is NULL THEN
720:

Line 758: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);

754: --
755: -- Debug Statements
756: --
757: IF l_debug_on THEN
758: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
759: END IF;
760: --
761: IF p_party_type = 'CUSTOMER' OR p_party_type is NULL THEN
762: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND (SITE_USES.LAST_UPDATE_DATE >= SYSDATE - :b_updated_n_days ', l_Party_Condn4Tab, 'NUMBER');

Line 788: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_CUSTOMIZE.ALTER_PARTY_SYNC for Customer',WSH_DEBUG_SV.C_PROC_LEVEL);

784: --
785: -- Debug Statements
786: --
787: IF l_debug_on THEN
788: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_CUSTOMIZE.ALTER_PARTY_SYNC for Customer',WSH_DEBUG_SV.C_PROC_LEVEL);
789: END IF;
790: WSH_ITM_CUSTOMIZE.ALTER_PARTY_SYNC(l_Party_Table);
791:
792: --

Line 796: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_CUSTOMIZE.ALTER_PARTY_SYNC for Carrier',WSH_DEBUG_SV.C_PROC_LEVEL);

792: --
793: -- Debug Statements
794: --
795: IF l_debug_on THEN
796: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_CUSTOMIZE.ALTER_PARTY_SYNC for Carrier',WSH_DEBUG_SV.C_PROC_LEVEL);
797: END IF;
798: WSH_ITM_CUSTOMIZE.ALTER_PARTY_SYNC(l_Carrier_Table);
799:
800:

Line 837: WSH_DEBUG_SV.LOG (l_module_name, 'Query ', l_SQLQuery, WSH_DEBUG_SV.C_STMT_LEVEL);

833: END IF;
834:
835:
836: IF l_debug_on THEN
837: WSH_DEBUG_SV.LOG (l_module_name, 'Query ', l_SQLQuery, WSH_DEBUG_SV.C_STMT_LEVEL);
838: END IF;
839:
840: -- Parse cursor
841: l_CursorID := DBMS_SQL.Open_Cursor;

Line 926: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);

922: --
923: -- Debug Statements
924: --
925: IF l_debug_on THEN
926: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);
927: END IF;
928: --
929: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Party_Table,l_CursorID);
930:

Line 935: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);

931: --
932: -- Debug Statements
933: --
934: IF l_debug_on THEN
935: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);
936: END IF;
937: --
938: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Carrier_Table,l_CursorID);
939:

Line 941: WSH_DEBUG_SV.LOGMSG (l_module_name,'Successfull in binding values',WSH_DEBUG_SV.C_STMT_LEVEL);

937: --
938: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Carrier_Table,l_CursorID);
939:
940: IF l_debug_on THEN
941: WSH_DEBUG_SV.LOGMSG (l_module_name,'Successfull in binding values',WSH_DEBUG_SV.C_STMT_LEVEL);
942: END IF;
943:
944: l_ignore := DBMS_SQL.EXECUTE(l_CursorID);
945:

Line 1032: WSH_DEBUG_SV.LOG (l_module_name, 'Number of parties queried : ' ,l_num_sourceID_tab.COUNT,WSH_DEBUG_SV.C_STMT_LEVEL);

1028: END LOOP;
1029: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
1030:
1031: IF l_debug_on THEN
1032: WSH_DEBUG_SV.LOG (l_module_name, 'Number of parties queried : ' ,l_num_sourceID_tab.COUNT,WSH_DEBUG_SV.C_STMT_LEVEL);
1033: END IF;
1034:
1035: --Bulk Insert into Interface Tables Appropriately
1036: IF l_num_hzpartyID_tab.COUNT <> 0 THEN

Line 1083: WSH_DEBUG_SV.LOG (l_module_name, 'Base Language : ', l_LanguageCode, WSH_DEBUG_SV.C_STMT_LEVEL);

1079: SELECT LANGUAGE_CODE INTO l_LanguageCode
1080: FROM FND_LANGUAGES
1081: WHERE INSTALLED_FLAG = 'B';
1082: IF l_debug_on THEN
1083: WSH_DEBUG_SV.LOG (l_module_name, 'Base Language : ', l_LanguageCode, WSH_DEBUG_SV.C_STMT_LEVEL);
1084: END IF;
1085:
1086:
1087:

Line 1089: WSH_DEBUG_SV.LOG (l_module_name, 'Number of Request Controls to be inserted : ' , l_num_ReqCtrl_tab.COUNT,WSH_DEBUG_SV.C_STMT_LEVEL);

1085:
1086:
1087:
1088: IF l_debug_on THEN
1089: WSH_DEBUG_SV.LOG (l_module_name, 'Number of Request Controls to be inserted : ' , l_num_ReqCtrl_tab.COUNT,WSH_DEBUG_SV.C_STMT_LEVEL);
1090: END IF;
1091:
1092:
1093: --Bulk Insert to Request Control Table

Line 1155: WSH_DEBUG_SV.LOG (l_module_name, 'Number of Parties to be inserted : ' , l_num_PartyReqCtrl_tab.COUNT,WSH_DEBUG_SV.C_STMT_LEVEL);

1151: );
1152: END IF;
1153:
1154: IF l_debug_on THEN
1155: WSH_DEBUG_SV.LOG (l_module_name, 'Number of Parties to be inserted : ' , l_num_PartyReqCtrl_tab.COUNT,WSH_DEBUG_SV.C_STMT_LEVEL);
1156: END IF;
1157:
1158: --Bulk Insert into Parties Table
1159: IF l_num_PartyReqCtrl_tab.COUNT <> 0 THEN

Line 1299: WSH_DEBUG_SV.LOG (l_module_name, 'Getting Contacts for Party : ' , l_varchar_PartyName_tab(i),WSH_DEBUG_SV.C_STMT_LEVEL);

1295: For i in l_num_itmpartyID_tab.FIRST..l_num_itmpartyID_tab.LAST LOOP
1296:
1297:
1298: IF l_debug_on THEN
1299: WSH_DEBUG_SV.LOG (l_module_name, 'Getting Contacts for Party : ' , l_varchar_PartyName_tab(i),WSH_DEBUG_SV.C_STMT_LEVEL);
1300: WSH_DEBUG_SV.LOG (l_module_name, 'gtm :Getting Contacts for Party : ', l_num_hzpartySiteID_tab.count, WSH_DEBUG_SV.C_STMT_LEVEL);
1301: END IF;
1302: -- gtm {
1303: if (l_num_hzpartySiteID_tab.count <> 0 and l_num_hzpartySiteID_tab(i) is not NULL ) then

Line 1300: WSH_DEBUG_SV.LOG (l_module_name, 'gtm :Getting Contacts for Party : ', l_num_hzpartySiteID_tab.count, WSH_DEBUG_SV.C_STMT_LEVEL);

1296:
1297:
1298: IF l_debug_on THEN
1299: WSH_DEBUG_SV.LOG (l_module_name, 'Getting Contacts for Party : ' , l_varchar_PartyName_tab(i),WSH_DEBUG_SV.C_STMT_LEVEL);
1300: WSH_DEBUG_SV.LOG (l_module_name, 'gtm :Getting Contacts for Party : ', l_num_hzpartySiteID_tab.count, WSH_DEBUG_SV.C_STMT_LEVEL);
1301: END IF;
1302: -- gtm {
1303: if (l_num_hzpartySiteID_tab.count <> 0 and l_num_hzpartySiteID_tab(i) is not NULL ) then
1304:

Line 1414: WSH_DEBUG_SV.LOGMSG (l_module_name,'Party Contact Already inserted ',WSH_DEBUG_SV.C_STMT_LEVEL);

1410: BEGIN
1411:
1412: IF (l_org_contact_cache(l_org_contact_id_tab(j)) = 'Y' ) THEN
1413: IF l_debug_on THEN
1414: WSH_DEBUG_SV.LOGMSG (l_module_name,'Party Contact Already inserted ',WSH_DEBUG_SV.C_STMT_LEVEL);
1415: END IF;
1416: END IF;
1417: EXCEPTION
1418: WHEN NO_DATA_FOUND THEN

Line 1461: WSH_DEBUG_SV.LOG (l_module_name, 'Number of Contacts : ' , l_varchar_CtPartyName_tab.COUNT,WSH_DEBUG_SV.C_STMT_LEVEL);

1457: END LOOP;
1458: END IF;
1459:
1460: IF l_debug_on THEN
1461: WSH_DEBUG_SV.LOG (l_module_name, 'Number of Contacts : ' , l_varchar_CtPartyName_tab.COUNT,WSH_DEBUG_SV.C_STMT_LEVEL);
1462: END IF;
1463: -- Bug 7297690 Inserting Party contact only if it is not already populated in wsh_itm_party_contacts
1464: if l_varchar_CtPartyName_tab.COUNT <> 0 THEN
1465:

Line 1467: -- WSH_DEBUG_SV.LOG (l_module_name,'org contact : ',l_org_contact_id_tab(j),WSH_DEBUG_SV.C_STMT_LEVEL);

1463: -- Bug 7297690 Inserting Party contact only if it is not already populated in wsh_itm_party_contacts
1464: if l_varchar_CtPartyName_tab.COUNT <> 0 THEN
1465:
1466: FOR j in l_varchar_CtPartyName_tab.FIRST..l_varchar_CtPartyName_tab.LAST LOOP
1467: -- WSH_DEBUG_SV.LOG (l_module_name,'org contact : ',l_org_contact_id_tab(j),WSH_DEBUG_SV.C_STMT_LEVEL);
1468: BEGIN
1469: IF (l_org_contact_cache(l_org_contact_id_tab(j)) = 'Y' ) THEN
1470: IF l_debug_on THEN
1471: WSH_DEBUG_SV.LOGMSG (l_module_name,' Party Contact Already inserted ',WSH_DEBUG_SV.C_STMT_LEVEL);

Line 1471: WSH_DEBUG_SV.LOGMSG (l_module_name,' Party Contact Already inserted ',WSH_DEBUG_SV.C_STMT_LEVEL);

1467: -- WSH_DEBUG_SV.LOG (l_module_name,'org contact : ',l_org_contact_id_tab(j),WSH_DEBUG_SV.C_STMT_LEVEL);
1468: BEGIN
1469: IF (l_org_contact_cache(l_org_contact_id_tab(j)) = 'Y' ) THEN
1470: IF l_debug_on THEN
1471: WSH_DEBUG_SV.LOGMSG (l_module_name,' Party Contact Already inserted ',WSH_DEBUG_SV.C_STMT_LEVEL);
1472: END IF;
1473: END IF;
1474: EXCEPTION
1475: WHEN NO_DATA_FOUND THEN

Line 1477: WSH_DEBUG_SV.LOGMSG (l_module_name,'Party Contact being inserted ',WSH_DEBUG_SV.C_STMT_LEVEL);

1473: END IF;
1474: EXCEPTION
1475: WHEN NO_DATA_FOUND THEN
1476: IF l_debug_on THEN
1477: WSH_DEBUG_SV.LOGMSG (l_module_name,'Party Contact being inserted ',WSH_DEBUG_SV.C_STMT_LEVEL);
1478: END IF;
1479: l_org_contact_cache(l_org_contact_id_tab(j)) := 'Y';
1480: insert into wsh_itm_party_contacts
1481: (

Line 1587: WSH_DEBUG_SV.pop(l_module_name);

1583: --
1584: -- Debug Statements
1585: --
1586: IF l_debug_on THEN
1587: WSH_DEBUG_SV.pop(l_module_name);
1588: END IF;
1589: --
1590:
1591:

Line 1595: WSH_DEBUG_SV.logmsg(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);

1591:
1592: EXCEPTION
1593: WHEN OTHERS THEN
1594: IF l_debug_on THEN
1595: WSH_DEBUG_SV.logmsg(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);
1596: END IF;
1597: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
1598: errbuf := 'Procedure WSH_ITM_PARTY_SYNC.POPULATE_DATA failed with unexpected error';
1599: retcode := '2';

Line 1601: WSH_DEBUG_SV.pop(l_module_name);

1597: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
1598: errbuf := 'Procedure WSH_ITM_PARTY_SYNC.POPULATE_DATA failed with unexpected error';
1599: retcode := '2';
1600: IF l_debug_on THEN
1601: WSH_DEBUG_SV.pop(l_module_name);
1602: END IF;
1603: RETURN;
1604:
1605: END POPULATE_DATA;