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 348: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

344: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
345: --
346: IF l_debug_on IS NULL
347: THEN
348: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
349: END IF;
350: --
351: --
352: -- Debug Statements

Line 355: WSH_DEBUG_SV.push(l_module_name);

351: --
352: -- Debug Statements
353: --
354: IF l_debug_on THEN
355: WSH_DEBUG_SV.push(l_module_name);
356: --
357: WSH_DEBUG_SV.log(l_module_name,'P_PARTY_TYPE',P_PARTY_TYPE);
358: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_CODE',P_FROM_PARTY_CODE);
359: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_CODE',P_TO_PARTY_CODE);

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

353: --
354: IF l_debug_on THEN
355: WSH_DEBUG_SV.push(l_module_name);
356: --
357: WSH_DEBUG_SV.log(l_module_name,'P_PARTY_TYPE',P_PARTY_TYPE);
358: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_CODE',P_FROM_PARTY_CODE);
359: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_CODE',P_TO_PARTY_CODE);
360: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY',P_DUMMY);
361: WSH_DEBUG_SV.log(l_module_name,'P_SITE_USE_CODE',P_SITE_USE_CODE);

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

354: IF l_debug_on THEN
355: WSH_DEBUG_SV.push(l_module_name);
356: --
357: WSH_DEBUG_SV.log(l_module_name,'P_PARTY_TYPE',P_PARTY_TYPE);
358: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_CODE',P_FROM_PARTY_CODE);
359: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_CODE',P_TO_PARTY_CODE);
360: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY',P_DUMMY);
361: WSH_DEBUG_SV.log(l_module_name,'P_SITE_USE_CODE',P_SITE_USE_CODE);
362: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_N_DAYS',P_CREATED_N_DAYS);

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

355: WSH_DEBUG_SV.push(l_module_name);
356: --
357: WSH_DEBUG_SV.log(l_module_name,'P_PARTY_TYPE',P_PARTY_TYPE);
358: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_CODE',P_FROM_PARTY_CODE);
359: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_CODE',P_TO_PARTY_CODE);
360: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY',P_DUMMY);
361: WSH_DEBUG_SV.log(l_module_name,'P_SITE_USE_CODE',P_SITE_USE_CODE);
362: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_N_DAYS',P_CREATED_N_DAYS);
363: WSH_DEBUG_SV.log(l_module_name,'P_UPDATED_N_DAYS',P_UPDATED_N_DAYS);

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

356: --
357: WSH_DEBUG_SV.log(l_module_name,'P_PARTY_TYPE',P_PARTY_TYPE);
358: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_CODE',P_FROM_PARTY_CODE);
359: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_CODE',P_TO_PARTY_CODE);
360: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY',P_DUMMY);
361: WSH_DEBUG_SV.log(l_module_name,'P_SITE_USE_CODE',P_SITE_USE_CODE);
362: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_N_DAYS',P_CREATED_N_DAYS);
363: WSH_DEBUG_SV.log(l_module_name,'P_UPDATED_N_DAYS',P_UPDATED_N_DAYS);
364: END IF;

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

357: WSH_DEBUG_SV.log(l_module_name,'P_PARTY_TYPE',P_PARTY_TYPE);
358: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_CODE',P_FROM_PARTY_CODE);
359: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_CODE',P_TO_PARTY_CODE);
360: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY',P_DUMMY);
361: WSH_DEBUG_SV.log(l_module_name,'P_SITE_USE_CODE',P_SITE_USE_CODE);
362: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_N_DAYS',P_CREATED_N_DAYS);
363: WSH_DEBUG_SV.log(l_module_name,'P_UPDATED_N_DAYS',P_UPDATED_N_DAYS);
364: END IF;
365: --

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

358: WSH_DEBUG_SV.log(l_module_name,'P_FROM_PARTY_CODE',P_FROM_PARTY_CODE);
359: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_CODE',P_TO_PARTY_CODE);
360: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY',P_DUMMY);
361: WSH_DEBUG_SV.log(l_module_name,'P_SITE_USE_CODE',P_SITE_USE_CODE);
362: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_N_DAYS',P_CREATED_N_DAYS);
363: WSH_DEBUG_SV.log(l_module_name,'P_UPDATED_N_DAYS',P_UPDATED_N_DAYS);
364: END IF;
365: --
366:

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

359: WSH_DEBUG_SV.log(l_module_name,'P_TO_PARTY_CODE',P_TO_PARTY_CODE);
360: WSH_DEBUG_SV.log(l_module_name,'P_DUMMY',P_DUMMY);
361: WSH_DEBUG_SV.log(l_module_name,'P_SITE_USE_CODE',P_SITE_USE_CODE);
362: WSH_DEBUG_SV.log(l_module_name,'P_CREATED_N_DAYS',P_CREATED_N_DAYS);
363: WSH_DEBUG_SV.log(l_module_name,'P_UPDATED_N_DAYS',P_UPDATED_N_DAYS);
364: END IF;
365: --
366:
367: -- Fetch user and login information

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

381: --
382: -- Debug Statements
383: --
384: IF l_debug_on THEN
385: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
386: END IF;
387: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND PARTY.PARTY_NAME >= :b_from_party', l_Party_Condn1Tab, 'VARCHAR');
388:
389: ELSE

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

397: --
398: -- Debug Statements
399: --
400: IF l_debug_on THEN
401: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
402: END IF;
403: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_NAME >= :b_from_party', l_Carrier_Condn1Tab, 'VARCHAR');
404:
405: END IF;

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

418: --
419: -- Debug Statements
420: --
421: IF l_debug_on THEN
422: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
423: END IF;
424: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND PARTY.PARTY_NAME <= :b_to_party', l_Party_Condn11Tab, 'VARCHAR');
425: ELSE
426:

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

433: --
434: -- Debug Statements
435: --
436: IF l_debug_on THEN
437: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
438: END IF;
439: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Carrier_Table, ' AND PARTY.PARTY_NAME <= :b_to_party', l_Carrier_Condn11Tab, 'VARCHAR');
440:
441: END IF;

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

450: --
451: -- Debug Statements
452: --
453: IF l_debug_on THEN
454: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
455: END IF;
456: --
457: WSH_ITM_QUERY_CUSTOM.ADD_CONDITION(l_Party_Table, ' AND SITE_USES.SITE_USE_CODE = :b_site_use_code', l_Party_Condn2Tab, 'VARCHAR');
458: END IF;

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

471: --
472: -- Debug Statements
473: --
474: IF l_debug_on THEN
475: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
476: END IF;
477: --
478: IF p_party_type = 'CUSTOMER' OR p_party_type is NULL THEN
479:

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

511: --
512: -- Debug Statements
513: --
514: IF l_debug_on THEN
515: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.ADD_CONDITION',WSH_DEBUG_SV.C_PROC_LEVEL);
516: END IF;
517: --
518: IF p_party_type = 'CUSTOMER' OR p_party_type is NULL THEN
519: 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 544: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_CUSTOMIZE.ALTER_PARTY_SYNC for Customer',WSH_DEBUG_SV.C_PROC_LEVEL);

540: --
541: -- Debug Statements
542: --
543: IF l_debug_on THEN
544: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_CUSTOMIZE.ALTER_PARTY_SYNC for Customer',WSH_DEBUG_SV.C_PROC_LEVEL);
545: END IF;
546: WSH_ITM_CUSTOMIZE.ALTER_PARTY_SYNC(l_Party_Table);
547:
548: --

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

548: --
549: -- Debug Statements
550: --
551: IF l_debug_on THEN
552: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_CUSTOMIZE.ALTER_PARTY_SYNC for Carrier',WSH_DEBUG_SV.C_PROC_LEVEL);
553: END IF;
554: WSH_ITM_CUSTOMIZE.ALTER_PARTY_SYNC(l_Carrier_Table);
555:
556:

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

578: l_SQLQuery := l_CustSQLQuery || l_tempStr1 || ' UNION ' || l_CarrierSQLQuery || l_tempStr2;
579: END IF;
580:
581: IF l_debug_on THEN
582: WSH_DEBUG_SV.LOG (l_module_name, 'Query ', l_SQLQuery, WSH_DEBUG_SV.C_STMT_LEVEL);
583: END IF;
584:
585: -- Parse cursor
586: l_CursorID := DBMS_SQL.Open_Cursor;

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

647: --
648: -- Debug Statements
649: --
650: IF l_debug_on THEN
651: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);
652: END IF;
653: --
654: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Party_Table,l_CursorID);
655:

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

656: --
657: -- Debug Statements
658: --
659: IF l_debug_on THEN
660: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_QUERY_CUSTOM.BIND_VALUES',WSH_DEBUG_SV.C_PROC_LEVEL);
661: END IF;
662: --
663: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Carrier_Table,l_CursorID);
664:

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

662: --
663: WSH_ITM_QUERY_CUSTOM.BIND_VALUES(l_Carrier_Table,l_CursorID);
664:
665: IF l_debug_on THEN
666: WSH_DEBUG_SV.LOGMSG (l_module_name,'Successfull in binding values',WSH_DEBUG_SV.C_STMT_LEVEL);
667: END IF;
668:
669: l_ignore := DBMS_SQL.EXECUTE(l_CursorID);
670:

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

733: END LOOP;
734: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
735:
736: IF l_debug_on THEN
737: WSH_DEBUG_SV.LOG (l_module_name, 'Number of parties queried : ' ,l_num_sourceID_tab.COUNT,WSH_DEBUG_SV.C_STMT_LEVEL);
738: END IF;
739:
740: --Bulk Insert into Interface Tables Appropriately
741: IF l_num_hzpartyID_tab.COUNT <> 0 THEN

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

784: SELECT LANGUAGE_CODE INTO l_LanguageCode
785: FROM FND_LANGUAGES
786: WHERE INSTALLED_FLAG = 'B';
787: IF l_debug_on THEN
788: WSH_DEBUG_SV.LOG (l_module_name, 'Base Language : ', l_LanguageCode, WSH_DEBUG_SV.C_STMT_LEVEL);
789: END IF;
790:
791:
792:

Line 795: 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);

791:
792:
793:
794: IF l_debug_on THEN
795: 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);
796: END IF;
797:
798:
799: --Bulk Insert to Request Control Table

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

855: );
856: END IF;
857:
858: IF l_debug_on THEN
859: WSH_DEBUG_SV.LOG (l_module_name, 'Number of Parties to be inserted : ' , l_num_PartyReqCtrl_tab.COUNT,WSH_DEBUG_SV.C_STMT_LEVEL);
860: END IF;
861:
862: --Bulk Insert into Parties Table
863: IF l_num_PartyReqCtrl_tab.COUNT <> 0 THEN

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

957: For i in l_num_itmpartyID_tab.FIRST..l_num_itmpartyID_tab.LAST LOOP
958:
959:
960: IF l_debug_on THEN
961: WSH_DEBUG_SV.LOG (l_module_name, 'Getting Contacts for Party : ' , l_varchar_PartyName_tab(i),WSH_DEBUG_SV.C_STMT_LEVEL);
962: END IF;
963:
964: /* Bug 7297690 Added check to determine whether Contacts for this party site is already being inserted into wsh_itm_party_contacts
965: - For each party site this query will be fired n no of times, n is no of usage of this site (billto, shipto etc)

Line 1034: WSH_DEBUG_SV.LOG (l_module_name,'Party Contact Already inserted ',WSH_DEBUG_SV.C_STMT_LEVEL);

1030: FOR j IN l_num_partyrel_tab.FIRST..l_num_partyrel_tab.LAST LOOP
1031: BEGIN
1032:
1033: IF (l_org_contact_cache(l_org_contact_id_tab(j)) = 'Y' ) THEN
1034: WSH_DEBUG_SV.LOG (l_module_name,'Party Contact Already inserted ',WSH_DEBUG_SV.C_STMT_LEVEL);
1035: END IF;
1036: EXCEPTION
1037: WHEN NO_DATA_FOUND THEN
1038: BEGIN

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

1076: END LOOP;
1077: END IF;
1078:
1079: IF l_debug_on THEN
1080: WSH_DEBUG_SV.LOG (l_module_name, 'Number of Contacts : ' , l_varchar_CtPartyName_tab.COUNT,WSH_DEBUG_SV.C_STMT_LEVEL);
1081: END IF;
1082: -- Bug 7297690 Inserting Party contact only if it is not already populated in wsh_itm_party_contacts
1083: if l_varchar_CtPartyName_tab.COUNT <> 0 THEN
1084:

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

1082: -- Bug 7297690 Inserting Party contact only if it is not already populated in wsh_itm_party_contacts
1083: if l_varchar_CtPartyName_tab.COUNT <> 0 THEN
1084:
1085: FOR j in l_varchar_CtPartyName_tab.FIRST..l_varchar_CtPartyName_tab.LAST LOOP
1086: -- WSH_DEBUG_SV.LOG (l_module_name,'org contact : ',l_org_contact_id_tab(j),WSH_DEBUG_SV.C_STMT_LEVEL);
1087: BEGIN
1088: IF (l_org_contact_cache(l_org_contact_id_tab(j)) = 'Y' ) THEN
1089: WSH_DEBUG_SV.LOG (l_module_name,' Party Contact Already inserted ',WSH_DEBUG_SV.C_STMT_LEVEL);
1090: END IF;

Line 1089: WSH_DEBUG_SV.LOG (l_module_name,' Party Contact Already inserted ',WSH_DEBUG_SV.C_STMT_LEVEL);

1085: FOR j in l_varchar_CtPartyName_tab.FIRST..l_varchar_CtPartyName_tab.LAST LOOP
1086: -- WSH_DEBUG_SV.LOG (l_module_name,'org contact : ',l_org_contact_id_tab(j),WSH_DEBUG_SV.C_STMT_LEVEL);
1087: BEGIN
1088: IF (l_org_contact_cache(l_org_contact_id_tab(j)) = 'Y' ) THEN
1089: WSH_DEBUG_SV.LOG (l_module_name,' Party Contact Already inserted ',WSH_DEBUG_SV.C_STMT_LEVEL);
1090: END IF;
1091: EXCEPTION
1092: WHEN NO_DATA_FOUND THEN
1093: WSH_DEBUG_SV.LOG (l_module_name,'Party Contact being inserted ',WSH_DEBUG_SV.C_STMT_LEVEL);

Line 1093: WSH_DEBUG_SV.LOG (l_module_name,'Party Contact being inserted ',WSH_DEBUG_SV.C_STMT_LEVEL);

1089: WSH_DEBUG_SV.LOG (l_module_name,' Party Contact Already inserted ',WSH_DEBUG_SV.C_STMT_LEVEL);
1090: END IF;
1091: EXCEPTION
1092: WHEN NO_DATA_FOUND THEN
1093: WSH_DEBUG_SV.LOG (l_module_name,'Party Contact being inserted ',WSH_DEBUG_SV.C_STMT_LEVEL);
1094: l_org_contact_cache(l_org_contact_id_tab(j)) := 'Y';
1095: insert into wsh_itm_party_contacts
1096: (
1097: PARTY_ID ,

Line 1166: WSH_DEBUG_SV.pop(l_module_name);

1162: --
1163: -- Debug Statements
1164: --
1165: IF l_debug_on THEN
1166: WSH_DEBUG_SV.pop(l_module_name);
1167: END IF;
1168: --
1169:
1170:

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

1170:
1171: EXCEPTION
1172: WHEN OTHERS THEN
1173: IF l_debug_on THEN
1174: WSH_DEBUG_SV.logmsg(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);
1175: END IF;
1176: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
1177: errbuf := 'Procedure WSH_ITM_PARTY_SYNC.POPULATE_DATA failed with unexpected error';
1178: retcode := '2';

Line 1180: WSH_DEBUG_SV.pop(l_module_name);

1176: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
1177: errbuf := 'Procedure WSH_ITM_PARTY_SYNC.POPULATE_DATA failed with unexpected error';
1178: retcode := '2';
1179: IF l_debug_on THEN
1180: WSH_DEBUG_SV.pop(l_module_name);
1181: END IF;
1182: RETURN;
1183:
1184: END POPULATE_DATA;