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.ASN_MIG_SALES_TEAM_PVT dependencies on FND_LOG

Line 65: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

61: ORDER BY sales_credit_id ASC, last_update_date DESC, log_id DESC;
62:
63: BEGIN
64: IF (p_debug_flag = 'Y' AND
65: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
66: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
67: 'Start Lead Line Logs Log for lead_id=' || p_lead_id);
68: END IF;
69:

Line 66: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

62:
63: BEGIN
64: IF (p_debug_flag = 'Y' AND
65: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
66: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
67: 'Start Lead Line Logs Log for lead_id=' || p_lead_id);
68: END IF;
69:
70: OPEN c_lead_line_logs(p_lead_id);

Line 76: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

72: INTO l_log_ids, l_lead_line_ids, l_last_update_dates;
73: CLOSE c_lead_line_logs;
74:
75: IF (p_debug_flag = 'Y' AND
76: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
77: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
78: 'Num Lead Line Logs Logs=' || l_log_ids.COUNT);
79: END IF;
80:

Line 77: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

73: CLOSE c_lead_line_logs;
74:
75: IF (p_debug_flag = 'Y' AND
76: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
77: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
78: 'Num Lead Line Logs Logs=' || l_log_ids.COUNT);
79: END IF;
80:
81: l_update_count := 0;

Line 110: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

106: l_update_count := SQL%ROWCOUNT;
107: END IF;
108:
109: IF (p_debug_flag = 'Y' AND
110: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
111: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
112: 'Num Lead Line Logs Updated=' || l_update_count);
113: END IF;
114:

Line 111: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

107: END IF;
108:
109: IF (p_debug_flag = 'Y' AND
110: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
111: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
112: 'Num Lead Line Logs Updated=' || l_update_count);
113: END IF;
114:
115: OPEN c_sales_credits_logs(p_lead_id);

Line 121: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

117: INTO l_log_ids, l_sales_credit_ids, l_last_update_dates;
118: CLOSE c_sales_credits_logs;
119:
120: IF (p_debug_flag = 'Y' AND
121: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
122: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
123: 'Num Sales Credits Logs=' || l_log_ids.COUNT);
124: END IF;
125:

Line 122: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

118: CLOSE c_sales_credits_logs;
119:
120: IF (p_debug_flag = 'Y' AND
121: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
122: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
123: 'Num Sales Credits Logs=' || l_log_ids.COUNT);
124: END IF;
125:
126: l_update_count := 0;

Line 155: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

151: l_update_count := SQL%ROWCOUNT;
152: END IF;
153:
154: IF (p_debug_flag = 'Y' AND
155: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
156: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
157: 'End fixlog for Lead id: ' || p_lead_id ||
158: ' Num Sales Credits Updated=' || l_update_count);
159: END IF;

Line 156: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

152: END IF;
153:
154: IF (p_debug_flag = 'Y' AND
155: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
156: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
157: 'End fixlog for Lead id: ' || p_lead_id ||
158: ' Num Sales Credits Updated=' || l_update_count);
159: END IF;
160: END FixEnddayFlags;

Line 230: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

226: BEGIN
227:
228: -- Log
229: IF (p_debug_flag = 'Y' AND
230: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
231: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
232: 'Begin OSO->ASN Duplicate Sales Rep Opportunity Data Migration.');
233: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
234: 'Start:' || 'p_start_id=' || p_start_id ||

Line 231: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,

227:
228: -- Log
229: IF (p_debug_flag = 'Y' AND
230: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
231: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
232: 'Begin OSO->ASN Duplicate Sales Rep Opportunity Data Migration.');
233: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
234: 'Start:' || 'p_start_id=' || p_start_id ||
235: ',p_end_id='||p_end_id ||

Line 233: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,

229: IF (p_debug_flag = 'Y' AND
230: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
231: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
232: 'Begin OSO->ASN Duplicate Sales Rep Opportunity Data Migration.');
233: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
234: 'Start:' || 'p_start_id=' || p_start_id ||
235: ',p_end_id='||p_end_id ||
236: ',p_debug_flag='||p_debug_flag);
237: END IF;

Line 242: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

238:
239: l_user_id := FND_GLOBAL.user_id;
240:
241: IF l_user_id IS NULL THEN
242: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
243: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module_name,
244: 'Opportunities: Error: Global User Id is not set');
245: END IF;
246: RETURN;

Line 243: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module_name,

239: l_user_id := FND_GLOBAL.user_id;
240:
241: IF l_user_id IS NULL THEN
242: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
243: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module_name,
244: 'Opportunities: Error: Global User Id is not set');
245: END IF;
246: RETURN;
247: END IF;

Line 270: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

266: -- if available else any access_id prefixed with Y or N
267: FOR uniq_steam_rec in c_uniq_steam(l_lead_id) LOOP
268:
269: IF (p_debug_flag = 'Y' AND
270: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
271: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
272: 'Opportunities: Cleaning up duplicates for coded_access_id: ' ||
273: uniq_steam_rec.code_access_id ||
274: ' sf_id ' || uniq_steam_rec.salesforce_id ||

Line 271: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

267: FOR uniq_steam_rec in c_uniq_steam(l_lead_id) LOOP
268:
269: IF (p_debug_flag = 'Y' AND
270: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
271: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
272: 'Opportunities: Cleaning up duplicates for coded_access_id: ' ||
273: uniq_steam_rec.code_access_id ||
274: ' sf_id ' || uniq_steam_rec.salesforce_id ||
275: ' sg_id ' || uniq_steam_rec.sales_group_id ||

Line 310: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

306: WHERE access_id = l_access_id;
307: END LOOP;
308: ---- @@
309: IF (p_debug_flag = 'Y' AND
310: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
311: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
312: 'Successfully processed Opp Id: ' || l_lead_id || ' Entries removed ' || l_remove_count);
313: IF l_custfix_count > 0 THEN
314: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 311: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

307: END LOOP;
308: ---- @@
309: IF (p_debug_flag = 'Y' AND
310: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
311: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
312: 'Successfully processed Opp Id: ' || l_lead_id || ' Entries removed ' || l_remove_count);
313: IF l_custfix_count > 0 THEN
314: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
315: 'Opp Id: ' || l_lead_id || ' CUSTOMER_ID fixes ' || l_custfix_count);

Line 314: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

310: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
311: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
312: 'Successfully processed Opp Id: ' || l_lead_id || ' Entries removed ' || l_remove_count);
313: IF l_custfix_count > 0 THEN
314: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
315: 'Opp Id: ' || l_lead_id || ' CUSTOMER_ID fixes ' || l_custfix_count);
316: END IF;
317: END IF;
318:

Line 325: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

321:
322: IF l_uncommitted_opps >= p_batch_size THEN
323: IF p_commit_flag = 'Y' THEN
324: IF (p_debug_flag = 'Y' AND
325: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
326: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
327: 'Calling Commit after processing ' || l_uncommitted_opps || ' Opportunities');
328: END IF;
329: COMMIT;

Line 326: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

322: IF l_uncommitted_opps >= p_batch_size THEN
323: IF p_commit_flag = 'Y' THEN
324: IF (p_debug_flag = 'Y' AND
325: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
326: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
327: 'Calling Commit after processing ' || l_uncommitted_opps || ' Opportunities');
328: END IF;
329: COMMIT;
330: ELSE

Line 339: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

335:
336: EXCEPTION
337: WHEN OTHERS then
338: Rollback to CURR_OPP;
339: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
340: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
341: 'Error Processing Opp Id : ' || l_lead_id);
342: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
343: 'SQL Error Msg, opp_id: ' || l_lead_id || ': '

Line 340: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

336: EXCEPTION
337: WHEN OTHERS then
338: Rollback to CURR_OPP;
339: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
340: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
341: 'Error Processing Opp Id : ' || l_lead_id);
342: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
343: 'SQL Error Msg, opp_id: ' || l_lead_id || ': '
344: || substr(SQLERRM, 1, 1950));

Line 342: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

338: Rollback to CURR_OPP;
339: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
340: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
341: 'Error Processing Opp Id : ' || l_lead_id);
342: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
343: 'SQL Error Msg, opp_id: ' || l_lead_id || ': '
344: || substr(SQLERRM, 1, 1950));
345: END IF;
346: END;

Line 352: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

348:
349: --Logic needs to be changed -- @@ START
350:
351: IF (p_debug_flag = 'Y' AND
352: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
353: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
354: 'Successfully processed Opp Id: ' || l_lead_id || ' Entries removed ' || l_remove_count);
355: END IF;
356:

Line 353: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

349: --Logic needs to be changed -- @@ START
350:
351: IF (p_debug_flag = 'Y' AND
352: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
353: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
354: 'Successfully processed Opp Id: ' || l_lead_id || ' Entries removed ' || l_remove_count);
355: END IF;
356:
357: --Logic needs to be changed -- @@ --END

Line 362: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

358: -- Commit
359: IF (p_commit_flag = 'Y') THEN
360: -- Log
361: IF (p_debug_flag = 'Y' AND
362: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
364: 'Opprtunities: Committing');
365: END IF;
366: COMMIT;

Line 363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

359: IF (p_commit_flag = 'Y') THEN
360: -- Log
361: IF (p_debug_flag = 'Y' AND
362: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
364: 'Opprtunities: Committing');
365: END IF;
366: COMMIT;
367: ELSE

Line 370: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

366: COMMIT;
367: ELSE
368: -- Log
369: IF (p_debug_flag = 'Y' AND
370: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
371: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
372: 'Opportunities: Rolling back');
373: END IF;
374: ROLLBACK;

Line 371: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

367: ELSE
368: -- Log
369: IF (p_debug_flag = 'Y' AND
370: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
371: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
372: 'Opportunities: Rolling back');
373: END IF;
374: ROLLBACK;
375: END IF;

Line 378: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

374: ROLLBACK;
375: END IF;
376:
377: IF (p_debug_flag = 'Y' AND
378: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
379: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name, 'End of OSO->ASN Duplicate Sales Team Opportunity Data Migration.');
380: END IF;
381:
382: End Mig_Dup_SalesRep_Opp;

Line 379: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name, 'End of OSO->ASN Duplicate Sales Team Opportunity Data Migration.');

375: END IF;
376:
377: IF (p_debug_flag = 'Y' AND
378: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
379: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name, 'End of OSO->ASN Duplicate Sales Team Opportunity Data Migration.');
380: END IF;
381:
382: End Mig_Dup_SalesRep_Opp;
383: --Code added for ASN migration approach suggested by lester -- End -- @@

Line 448: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

444: BEGIN
445:
446: -- Log
447: IF (p_debug_flag = 'Y' AND
448: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
449: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
450: 'Begin OSO->ASN Duplicate Sales Rep Sales Lead Data Migration.');
451: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
452: 'Start:' || 'p_start_id=' || p_start_id ||

Line 449: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,

445:
446: -- Log
447: IF (p_debug_flag = 'Y' AND
448: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
449: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
450: 'Begin OSO->ASN Duplicate Sales Rep Sales Lead Data Migration.');
451: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
452: 'Start:' || 'p_start_id=' || p_start_id ||
453: ',p_end_id='||p_end_id ||

Line 451: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,

447: IF (p_debug_flag = 'Y' AND
448: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
449: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
450: 'Begin OSO->ASN Duplicate Sales Rep Sales Lead Data Migration.');
451: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
452: 'Start:' || 'p_start_id=' || p_start_id ||
453: ',p_end_id='||p_end_id ||
454: ',p_debug_flag='||p_debug_flag);
455: END IF;

Line 460: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

456:
457: l_user_id := FND_GLOBAL.user_id;
458:
459: IF l_user_id IS NULL THEN
460: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
461: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module_name,
462: 'Leads: Error: Global User Id is not set');
463: END IF;
464: RETURN;

Line 461: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module_name,

457: l_user_id := FND_GLOBAL.user_id;
458:
459: IF l_user_id IS NULL THEN
460: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
461: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module_name,
462: 'Leads: Error: Global User Id is not set');
463: END IF;
464: RETURN;
465: END IF;

Line 483: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

479: -- access_id of a record with SALESFORCE_ROLE_CODE non null
480: -- if available else any access_id prefixed with Y or N
481: FOR uniq_steam_rec in c_uniq_steam(l_sales_lead_id) LOOP -- @@
482: IF (p_debug_flag = 'Y' AND
483: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
484: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
485: 'Leads: Cleaning up duplicates for code_access_id: ' ||
486: uniq_steam_rec.code_access_id ||
487: ' sf_id ' || uniq_steam_rec.salesforce_id ||

Line 484: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

480: -- if available else any access_id prefixed with Y or N
481: FOR uniq_steam_rec in c_uniq_steam(l_sales_lead_id) LOOP -- @@
482: IF (p_debug_flag = 'Y' AND
483: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
484: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
485: 'Leads: Cleaning up duplicates for code_access_id: ' ||
486: uniq_steam_rec.code_access_id ||
487: ' sf_id ' || uniq_steam_rec.salesforce_id ||
488: ' sg_id ' || uniq_steam_rec.sales_group_id ||

Line 523: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

519: WHERE access_id = l_access_id;
520: END LOOP;
521:
522: IF (p_debug_flag = 'Y' AND
523: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
524: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
525: 'Successfully processed Sales Lead Id: ' || l_sales_lead_id || ' Entries removed ' || l_remove_count);
526: END IF;
527:

Line 524: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

520: END LOOP;
521:
522: IF (p_debug_flag = 'Y' AND
523: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
524: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
525: 'Successfully processed Sales Lead Id: ' || l_sales_lead_id || ' Entries removed ' || l_remove_count);
526: END IF;
527:
528: IF l_updated_flag THEN

Line 534: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

530: END IF;
531: IF l_uncommitted_leads >= p_batch_size THEN
532: IF p_commit_flag = 'Y' THEN
533: IF (p_debug_flag = 'Y' AND
534: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
535: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
536: 'Calling Commit after processing ' || l_uncommitted_leads || ' Sales Leads');
537: END IF;
538: COMMIT;

Line 535: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

531: IF l_uncommitted_leads >= p_batch_size THEN
532: IF p_commit_flag = 'Y' THEN
533: IF (p_debug_flag = 'Y' AND
534: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
535: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
536: 'Calling Commit after processing ' || l_uncommitted_leads || ' Sales Leads');
537: END IF;
538: COMMIT;
539: ELSE

Line 548: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

544:
545: EXCEPTION
546: WHEN OTHERS then
547: Rollback to CURR_LEAD;
548: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
549: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
550: 'Error Processing Lead Id : ' || l_sales_lead_id);
551: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
552: 'SQL Error Msg, lead_id: ' || l_sales_lead_id || ': '

Line 549: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

545: EXCEPTION
546: WHEN OTHERS then
547: Rollback to CURR_LEAD;
548: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
549: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
550: 'Error Processing Lead Id : ' || l_sales_lead_id);
551: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
552: 'SQL Error Msg, lead_id: ' || l_sales_lead_id || ': '
553: || substr(SQLERRM, 1, 1950));

Line 551: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

547: Rollback to CURR_LEAD;
548: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
549: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
550: 'Error Processing Lead Id : ' || l_sales_lead_id);
551: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
552: 'SQL Error Msg, lead_id: ' || l_sales_lead_id || ': '
553: || substr(SQLERRM, 1, 1950));
554: END IF;
555: END;

Line 562: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

558: -- Commit
559: IF (p_commit_flag = 'Y') THEN
560: -- Log
561: IF (p_debug_flag = 'Y' AND
562: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
563: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
564: 'Leads: Committing');
565: END IF;
566: COMMIT;

Line 563: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

559: IF (p_commit_flag = 'Y') THEN
560: -- Log
561: IF (p_debug_flag = 'Y' AND
562: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
563: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
564: 'Leads: Committing');
565: END IF;
566: COMMIT;
567: ELSE

Line 570: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

566: COMMIT;
567: ELSE
568: -- Log
569: IF (p_debug_flag = 'Y' AND
570: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
571: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
572: 'Leads: Rolling back');
573: END IF;
574: ROLLBACK;

Line 571: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

567: ELSE
568: -- Log
569: IF (p_debug_flag = 'Y' AND
570: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
571: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
572: 'Leads: Rolling back');
573: END IF;
574: ROLLBACK;
575: END IF;

Line 578: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

574: ROLLBACK;
575: END IF;
576:
577: IF (p_debug_flag = 'Y' AND
578: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
579: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name, 'Leads: End of OSO->ASN Duplicate Sales Team Sales Lead Data Migration.');
580: END IF;
581:
582: End Mig_Dup_SalesRep_Lead;

Line 579: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name, 'Leads: End of OSO->ASN Duplicate Sales Team Sales Lead Data Migration.');

575: END IF;
576:
577: IF (p_debug_flag = 'Y' AND
578: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
579: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name, 'Leads: End of OSO->ASN Duplicate Sales Team Sales Lead Data Migration.');
580: END IF;
581:
582: End Mig_Dup_SalesRep_Lead;
583: --Code added for ASN migration approach suggested by lester -- End -- @@

Line 737: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

733: COMMIT;
734:
735: -- Log
736: IF (p_debug_flag = 'Y' AND
737: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
738: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
739: 'Customers: Start:' || 'p_num_workers=' || p_num_workers ||
740: ',p_commit_flag=' || p_commit_flag ||
741: ',p_debug_flag=' || p_debug_flag);

Line 738: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,

734:
735: -- Log
736: IF (p_debug_flag = 'Y' AND
737: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
738: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
739: 'Customers: Start:' || 'p_num_workers=' || p_num_workers ||
740: ',p_commit_flag=' || p_commit_flag ||
741: ',p_debug_flag=' || p_debug_flag);
742: END IF;

Line 986: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

982: ELSE
983:
984: -- Log
985: IF (p_debug_flag = 'Y' AND
986: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
987: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
988: 'Customers: Re-entering:' || 'p_num_workers=' || p_num_workers ||
989: ',p_commit_flag=' || p_commit_flag ||
990: ',p_debug_flag='||p_debug_flag);

Line 987: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,

983:
984: -- Log
985: IF (p_debug_flag = 'Y' AND
986: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
987: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
988: 'Customers: Re-entering:' || 'p_num_workers=' || p_num_workers ||
989: ',p_commit_flag=' || p_commit_flag ||
990: ',p_debug_flag='||p_debug_flag);
991:

Line 1001: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

997: WHEN OTHERS THEN
998:
999: ROLLBACK;
1000:
1001: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1002:
1003: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1004: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1005: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 1007: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);

1003: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1004: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1005: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1006: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1007: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
1008: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1009: l_api_name||':'||sqlcode||':'||sqlerrm);
1010: END IF;
1011:

Line 1008: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

1004: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1005: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1006: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1007: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
1008: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1009: l_api_name||':'||sqlcode||':'||sqlerrm);
1010: END IF;
1011:
1012: END Mig_Dup_SalesRep_Main;

Line 1085: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1081: BEGIN
1082:
1083: -- Log
1084: IF (p_debug_flag = 'Y' AND
1085: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1086: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
1087: 'Begin OSO->ASN Duplicate Sales Rep Customer Data Migration.');
1088: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
1089: 'Start:' || 'p_start_id=' || p_start_id ||

Line 1086: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,

1082:
1083: -- Log
1084: IF (p_debug_flag = 'Y' AND
1085: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1086: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
1087: 'Begin OSO->ASN Duplicate Sales Rep Customer Data Migration.');
1088: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
1089: 'Start:' || 'p_start_id=' || p_start_id ||
1090: ',p_end_id='||p_end_id ||

Line 1088: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,

1084: IF (p_debug_flag = 'Y' AND
1085: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1086: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
1087: 'Begin OSO->ASN Duplicate Sales Rep Customer Data Migration.');
1088: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
1089: 'Start:' || 'p_start_id=' || p_start_id ||
1090: ',p_end_id='||p_end_id ||
1091: ',p_debug_flag='||p_debug_flag);
1092: END IF;

Line 1097: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1093:
1094: l_user_id := FND_GLOBAL.user_id;
1095:
1096: IF l_user_id IS NULL THEN
1097: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1098: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module_name,
1099: 'Customers: Error: Global User Id is not set');
1100: END IF;
1101: RETURN;

Line 1098: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module_name,

1094: l_user_id := FND_GLOBAL.user_id;
1095:
1096: IF l_user_id IS NULL THEN
1097: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1098: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module_name,
1099: 'Customers: Error: Global User Id is not set');
1100: END IF;
1101: RETURN;
1102: END IF;

Line 1121: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1117: -- access_id of a record with SALESFORCE_ROLE_CODE non null
1118: -- if available else any access_id prefixed with Y or N
1119: FOR uniq_steam_rec in c_uniq_steam(l_party_id) LOOP -- @@
1120: IF (p_debug_flag = 'Y' AND
1121: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1122: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1123: 'Customers: Cleaning up duplicates for coded_access_id: ' ||
1124: uniq_steam_rec.code_access_id ||
1125: ' sf_id ' || uniq_steam_rec.salesforce_id ||

Line 1122: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

1118: -- if available else any access_id prefixed with Y or N
1119: FOR uniq_steam_rec in c_uniq_steam(l_party_id) LOOP -- @@
1120: IF (p_debug_flag = 'Y' AND
1121: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1122: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1123: 'Customers: Cleaning up duplicates for coded_access_id: ' ||
1124: uniq_steam_rec.code_access_id ||
1125: ' sf_id ' || uniq_steam_rec.salesforce_id ||
1126: ' sg_id ' || uniq_steam_rec.sales_group_id ||

Line 1165: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1161: WHERE access_id = l_access_id;
1162: END LOOP;
1163:
1164: IF (p_debug_flag = 'Y' AND
1165: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1166: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1167: 'Successfully processed Party Id: ' || l_party_id || ' Entries removed ' || l_remove_count);
1168: END IF;
1169:

Line 1166: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

1162: END LOOP;
1163:
1164: IF (p_debug_flag = 'Y' AND
1165: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1166: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1167: 'Successfully processed Party Id: ' || l_party_id || ' Entries removed ' || l_remove_count);
1168: END IF;
1169:
1170: IF l_updated_flag THEN

Line 1177: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1173:
1174: IF l_uncommitted_parties >= p_batch_size THEN
1175: IF p_commit_flag = 'Y' THEN
1176: IF (p_debug_flag = 'Y' AND
1177: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1178: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1179: 'Calling Commit after processing ' || l_uncommitted_parties || ' Customers');
1180: END IF;
1181: COMMIT;

Line 1178: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

1174: IF l_uncommitted_parties >= p_batch_size THEN
1175: IF p_commit_flag = 'Y' THEN
1176: IF (p_debug_flag = 'Y' AND
1177: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1178: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1179: 'Calling Commit after processing ' || l_uncommitted_parties || ' Customers');
1180: END IF;
1181: COMMIT;
1182: ELSE

Line 1191: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1187:
1188: EXCEPTION
1189: WHEN OTHERS then
1190: Rollback to CURR_PARTY;
1191: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1192: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1193: 'Error Processing Party Id : ' || l_party_id);
1194: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1195: 'SQL Error Msg, party_id: ' || l_party_id || ': '

Line 1192: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

1188: EXCEPTION
1189: WHEN OTHERS then
1190: Rollback to CURR_PARTY;
1191: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1192: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1193: 'Error Processing Party Id : ' || l_party_id);
1194: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1195: 'SQL Error Msg, party_id: ' || l_party_id || ': '
1196: || substr(SQLERRM, 1, 1950));

Line 1194: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

1190: Rollback to CURR_PARTY;
1191: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1192: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1193: 'Error Processing Party Id : ' || l_party_id);
1194: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1195: 'SQL Error Msg, party_id: ' || l_party_id || ': '
1196: || substr(SQLERRM, 1, 1950));
1197: END IF;
1198: END;

Line 1205: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1201: -- Commit
1202: IF (p_commit_flag = 'Y') THEN
1203: -- Log
1204: IF (p_debug_flag = 'Y' AND
1205: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1206: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1207: 'Customers: Committing');
1208: END IF;
1209: COMMIT;

Line 1206: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

1202: IF (p_commit_flag = 'Y') THEN
1203: -- Log
1204: IF (p_debug_flag = 'Y' AND
1205: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1206: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1207: 'Customers: Committing');
1208: END IF;
1209: COMMIT;
1210: ELSE

Line 1213: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1209: COMMIT;
1210: ELSE
1211: -- Log
1212: IF (p_debug_flag = 'Y' AND
1213: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1214: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1215: 'Customers: Rolling back');
1216: END IF;
1217: ROLLBACK;

Line 1214: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

1210: ELSE
1211: -- Log
1212: IF (p_debug_flag = 'Y' AND
1213: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1214: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1215: 'Customers: Rolling back');
1216: END IF;
1217: ROLLBACK;
1218: END IF;

Line 1221: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1217: ROLLBACK;
1218: END IF;
1219:
1220: IF (p_debug_flag = 'Y' AND
1221: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1222: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name, 'End of OSO->ASN Duplicate Sales Team Customer Data Migration.');
1223: END IF;
1224:
1225: End Mig_Dup_SalesRep_Cust;

Line 1222: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name, 'End of OSO->ASN Duplicate Sales Team Customer Data Migration.');

1218: END IF;
1219:
1220: IF (p_debug_flag = 'Y' AND
1221: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1222: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name, 'End of OSO->ASN Duplicate Sales Team Customer Data Migration.');
1223: END IF;
1224:
1225: End Mig_Dup_SalesRep_Cust;
1226: --Procedure modified for ASN migration approach suggested by lester -- End -- @@

Line 1265: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1261: IF (fnd_conc_global.request_data IS NULL) THEN
1262:
1263: -- Log
1264: IF (p_debug_flag = 'Y' AND
1265: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1266: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
1267: 'Opportunities: Start:' || 'p_num_workers=' || p_num_workers ||
1268: ',p_commit_flag=' || p_commit_flag ||
1269: ',p_debug_flag=' || p_debug_flag);

Line 1266: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,

1262:
1263: -- Log
1264: IF (p_debug_flag = 'Y' AND
1265: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1266: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
1267: 'Opportunities: Start:' || 'p_num_workers=' || p_num_workers ||
1268: ',p_commit_flag=' || p_commit_flag ||
1269: ',p_debug_flag=' || p_debug_flag);
1270: END IF;

Line 1439: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1435: ELSE
1436:
1437: -- Log
1438: IF (p_debug_flag = 'Y' AND
1439: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1440: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
1441: 'Opportunities: Re-entering:' || 'p_num_workers=' || p_num_workers ||
1442: ',p_commit_flag=' || p_commit_flag ||
1443: ',p_debug_flag='||p_debug_flag);

Line 1440: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,

1436:
1437: -- Log
1438: IF (p_debug_flag = 'Y' AND
1439: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1440: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
1441: 'Opportunities: Re-entering:' || 'p_num_workers=' || p_num_workers ||
1442: ',p_commit_flag=' || p_commit_flag ||
1443: ',p_debug_flag='||p_debug_flag);
1444: END IF;

Line 1451: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1447: retcode := 0;
1448:
1449: -- Log
1450: IF (p_debug_flag = 'Y' AND
1451: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1452: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
1453: 'Opportunities: Done:' || 'p_num_workers=' || p_num_workers ||
1454: ',p_commit_flag=' || p_commit_flag ||
1455: ',p_debug_flag='||p_debug_flag);

Line 1452: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,

1448:
1449: -- Log
1450: IF (p_debug_flag = 'Y' AND
1451: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1452: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module_name,
1453: 'Opportunities: Done:' || 'p_num_workers=' || p_num_workers ||
1454: ',p_commit_flag=' || p_commit_flag ||
1455: ',p_debug_flag='||p_debug_flag);
1456: END IF;

Line 1465: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1461:
1462: WHEN OTHERS THEN
1463: ROLLBACK;
1464:
1465: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1466:
1467: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1468: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1469: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 1471: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);

1467: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1468: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1469: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1470: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1471: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
1472: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1473: l_api_name||':'||sqlcode||':'||sqlerrm);
1474: END IF;
1475:

Line 1472: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

1468: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1469: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1470: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1471: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
1472: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1473: l_api_name||':'||sqlcode||':'||sqlerrm);
1474: END IF;
1475:
1476: END Mig_Customerid_Enddaylog_Main;

Line 1542: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1538: BEGIN
1539: l_custfix_count := 0;
1540: l_user_id := FND_GLOBAL.user_id;
1541: IF l_user_id IS NULL THEN
1542: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1543: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module_name,
1544: 'Opportunities: Error: Global User Id is not set');
1545: END IF;
1546: RETURN;

Line 1543: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module_name,

1539: l_custfix_count := 0;
1540: l_user_id := FND_GLOBAL.user_id;
1541: IF l_user_id IS NULL THEN
1542: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1543: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module_name,
1544: 'Opportunities: Error: Global User Id is not set');
1545: END IF;
1546: RETURN;
1547: END IF;

Line 1558: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1554: FOR I IN l_lead_id.first..l_lead_id.last LOOP
1555:
1556:
1557: IF (p_debug_flag = 'Y' AND
1558: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1559: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1560: 'Start Lead Line Logs Log for lead_id=' || l_lead_id(i));
1561: END IF;
1562:

Line 1559: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

1555:
1556:
1557: IF (p_debug_flag = 'Y' AND
1558: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1559: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1560: 'Start Lead Line Logs Log for lead_id=' || l_lead_id(i));
1561: END IF;
1562:
1563: OPEN c_lead_line_logs(l_lead_id(i));

Line 1569: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1565: INTO l_log_ids, l_lead_line_ids, l_last_update_dates;
1566: CLOSE c_lead_line_logs;
1567:
1568: IF (p_debug_flag = 'Y' AND
1569: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1570: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1571: 'Num Lead Line Logs Logs=' || l_log_ids.COUNT);
1572: END IF;
1573: l_update_count := 0;

Line 1570: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

1566: CLOSE c_lead_line_logs;
1567:
1568: IF (p_debug_flag = 'Y' AND
1569: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1570: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1571: 'Num Lead Line Logs Logs=' || l_log_ids.COUNT);
1572: END IF;
1573: l_update_count := 0;
1574: IF l_log_ids.COUNT > 0 THEN

Line 1599: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1595:
1596: l_update_count := SQL%ROWCOUNT;
1597: END IF;
1598: IF (p_debug_flag = 'Y' AND
1599: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1600: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1601: 'Num Lead Line Logs Updated=' || l_update_count);
1602: END IF;
1603:

Line 1600: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

1596: l_update_count := SQL%ROWCOUNT;
1597: END IF;
1598: IF (p_debug_flag = 'Y' AND
1599: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1600: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1601: 'Num Lead Line Logs Updated=' || l_update_count);
1602: END IF;
1603:
1604: OPEN c_sales_credits_logs(l_lead_id(i));

Line 1610: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1606: INTO l_log_ids, l_sales_credit_ids, l_last_update_dates;
1607: CLOSE c_sales_credits_logs;
1608:
1609: IF (p_debug_flag = 'Y' AND
1610: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1611: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1612: 'Num Sales Credits Logs=' || l_log_ids.COUNT);
1613: END IF;
1614:

Line 1611: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

1607: CLOSE c_sales_credits_logs;
1608:
1609: IF (p_debug_flag = 'Y' AND
1610: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1611: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1612: 'Num Sales Credits Logs=' || l_log_ids.COUNT);
1613: END IF;
1614:
1615: l_update_count := 0;

Line 1645: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1641: END IF;
1642:
1643:
1644: IF (p_debug_flag = 'Y' AND
1645: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1646: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1647: 'End fixlog for Lead id: ' || l_lead_id(i) ||
1648: ' Num Sales Credits Updated=' || l_update_count);
1649: END IF;

Line 1646: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

1642:
1643:
1644: IF (p_debug_flag = 'Y' AND
1645: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1646: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1647: 'End fixlog for Lead id: ' || l_lead_id(i) ||
1648: ' Num Sales Credits Updated=' || l_update_count);
1649: END IF;
1650:

Line 1671: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1667:
1668: IF l_uncommitted_opps >= p_batch_size THEN
1669: IF p_commit_flag = 'Y' THEN
1670: IF (p_debug_flag = 'Y' AND
1671: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1672: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1673: 'Calling Commit after processing ' || l_uncommitted_opps || ' Opportunities');
1674: END IF;
1675: COMMIT;

Line 1672: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

1668: IF l_uncommitted_opps >= p_batch_size THEN
1669: IF p_commit_flag = 'Y' THEN
1670: IF (p_debug_flag = 'Y' AND
1671: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1672: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
1673: 'Calling Commit after processing ' || l_uncommitted_opps || ' Opportunities');
1674: END IF;
1675: COMMIT;
1676: ELSE

Line 1692: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1688:
1689: WHEN OTHERS THEN
1690: ROLLBACK;
1691:
1692: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1693:
1694: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1695: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1696: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 1698: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);

1694: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1695: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1696: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1697: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1698: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
1699: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1700: l_api_name||':'||sqlcode||':'||sqlerrm);
1701: END IF;
1702:

Line 1699: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

1695: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1696: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1697: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1698: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
1699: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1700: l_api_name||':'||sqlcode||':'||sqlerrm);
1701: END IF;
1702:
1703: END Mig_Customerid_Enddaylog_Sub;