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.ASO_BI_QUOTE_FACT_PVT dependencies on BIS_COLLECTION_UTILITIES

Line 48: if (bis_collection_utilities.g_debug) then

44: between p_from_date and p_to_date
45: and nvl(qhd.quote_type,'q')<>'t') qv
46: where qv.quote_version = qv.max_quote_version ;
47:
48: if (bis_collection_utilities.g_debug) then
49: bis_collection_utilities.debug('inserted '||sql%rowcount||' rows in ' ||'aso_bi_quote_ids.');
50: end if;
51:
52: commit;

Line 49: bis_collection_utilities.debug('inserted '||sql%rowcount||' rows in ' ||'aso_bi_quote_ids.');

45: and nvl(qhd.quote_type,'q')<>'t') qv
46: where qv.quote_version = qv.max_quote_version ;
47:
48: if (bis_collection_utilities.g_debug) then
49: bis_collection_utilities.debug('inserted '||sql%rowcount||' rows in ' ||'aso_bi_quote_ids.');
50: end if;
51:
52: commit;
53:

Line 108: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

104: WHERE QHD.last_update_date
105: BETWEEN p_from_date AND p_to_date
106: AND NVL(QHD.QUOTE_TYPE,'Q')<>'T') QV
107: WHERE QV.quote_version = QV.max_quote_version ;
108: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
109: BIS_COLLECTION_UTILITIES.Debug('Inserted '||SQL%ROWCOUNT||' rows in ' ||'ASO_BI_QUOTE_IDS.');
110: END IF;
111: COMMIT;
112: End Populate_Quote_ids;

Line 109: BIS_COLLECTION_UTILITIES.Debug('Inserted '||SQL%ROWCOUNT||' rows in ' ||'ASO_BI_QUOTE_IDS.');

105: BETWEEN p_from_date AND p_to_date
106: AND NVL(QHD.QUOTE_TYPE,'Q')<>'T') QV
107: WHERE QV.quote_version = QV.max_quote_version ;
108: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
109: BIS_COLLECTION_UTILITIES.Debug('Inserted '||SQL%ROWCOUNT||' rows in ' ||'ASO_BI_QUOTE_IDS.');
110: END IF;
111: COMMIT;
112: End Populate_Quote_ids;
113:

Line 122: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

118: SELECT DISTINCT batch_id,0,'UNASSIGNED'
119: FROM ASO_BI_QUOTE_IDS ;
120: COMMIT;
121:
122: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
123: BIS_COLLECTION_UTILITIES.Debug('Inserted '||SQL%ROWCOUNT||' jobs into '||'ASO_BI_QUOTE_FACT_JOBS');
124: END IF;
125:
126: End Register_jobs;

Line 123: BIS_COLLECTION_UTILITIES.Debug('Inserted '||SQL%ROWCOUNT||' jobs into '||'ASO_BI_QUOTE_FACT_JOBS');

119: FROM ASO_BI_QUOTE_IDS ;
120: COMMIT;
121:
122: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
123: BIS_COLLECTION_UTILITIES.Debug('Inserted '||SQL%ROWCOUNT||' jobs into '||'ASO_BI_QUOTE_FACT_JOBS');
124: END IF;
125:
126: End Register_jobs;
127:

Line 135: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

131: l_global_prim_currency Varchar2(10);
132: l_global_sec_currency Varchar2(10);
133: Begin
134:
135: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
136: BIS_COLLECTION_UTILITIES.Debug('populating the Quote fact Staging');
137: END IF;
138:
139: l_global_prim_currency := BIS_COMMON_PARAMETERS.Get_Currency_code ;

Line 136: BIS_COLLECTION_UTILITIES.Debug('populating the Quote fact Staging');

132: l_global_sec_currency Varchar2(10);
133: Begin
134:
135: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
136: BIS_COLLECTION_UTILITIES.Debug('populating the Quote fact Staging');
137: END IF;
138:
139: l_global_prim_currency := BIS_COMMON_PARAMETERS.Get_Currency_code ;
140: l_global_sec_currency := BIS_COMMON_PARAMETERS.Get_Secondary_Currency_code ;

Line 258: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

254: S.marketing_source_code_id,
255: S.Total_adjusted_percent,
256: S.recurring_charge_flag) ;
257:
258: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
259: BIS_COLLECTION_UTILITIES.Debug('Done populating the Quote fact Staging:'||'Rowcount:'|| SQL%ROWCOUNT);
260: END IF;
261:
262: COMMIT;

Line 259: BIS_COLLECTION_UTILITIES.Debug('Done populating the Quote fact Staging:'||'Rowcount:'|| SQL%ROWCOUNT);

255: S.Total_adjusted_percent,
256: S.recurring_charge_flag) ;
257:
258: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
259: BIS_COLLECTION_UTILITIES.Debug('Done populating the Quote fact Staging:'||'Rowcount:'|| SQL%ROWCOUNT);
260: END IF;
261:
262: COMMIT;
263:

Line 276: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

272: l_login_id number;
273: l_global_prim_currency VARCHAR2(20);
274: Begin
275:
276: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
277: BIS_COLLECTION_UTILITIES.Debug('Start populating the Quote fact Table');
278: END IF;
279:
280: l_user_id := FND_GLOBAL.user_id;

Line 277: BIS_COLLECTION_UTILITIES.Debug('Start populating the Quote fact Table');

273: l_global_prim_currency VARCHAR2(20);
274: Begin
275:
276: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
277: BIS_COLLECTION_UTILITIES.Debug('Start populating the Quote fact Table');
278: END IF;
279:
280: l_user_id := FND_GLOBAL.user_id;
281: l_login_id := FND_GLOBAL.login_id;

Line 366: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

362: RATE.org_id(+) = QHD.org_id AND
363: RATE.txn_currency(+) = QHD.currency_code AND
364: RATE.exchange_date(+) = trunc(QHD.last_update_date);
365:
366: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
367: BIS_COLLECTION_UTILITIES.Debug('Done populating the Quote fact Table:'||'Rowcount:'|| SQL%ROWCOUNT);
368: END IF;
369: COMMIT;
370: End InitiLoad_QotHdr ;

Line 367: BIS_COLLECTION_UTILITIES.Debug('Done populating the Quote fact Table:'||'Rowcount:'|| SQL%ROWCOUNT);

363: RATE.txn_currency(+) = QHD.currency_code AND
364: RATE.exchange_date(+) = trunc(QHD.last_update_date);
365:
366: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
367: BIS_COLLECTION_UTILITIES.Debug('Done populating the Quote fact Table:'||'Rowcount:'|| SQL%ROWCOUNT);
368: END IF;
369: COMMIT;
370: End InitiLoad_QotHdr ;
371:

Line 379: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

375: l_user_id NUMBER;
376: l_login_id NUMBER;
377: Begin
378:
379: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
380: BIS_COLLECTION_UTILITIES.Debug('Start populating the Quote fact Table');
381: END IF;
382:
383: l_user_id := FND_GLOBAL.user_id;

Line 380: BIS_COLLECTION_UTILITIES.Debug('Start populating the Quote fact Table');

376: l_login_id NUMBER;
377: Begin
378:
379: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
380: BIS_COLLECTION_UTILITIES.Debug('Start populating the Quote fact Table');
381: END IF;
382:
383: l_user_id := FND_GLOBAL.user_id;
384: l_login_id := FND_GLOBAL.login_id;

Line 495: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

491: STG.marketing_source_code_id,
492: STG.total_adjusted_percent,
493: STG.recurring_charge_flag)' USING SYSDATE, l_user_id,l_login_id,SYSDATE,l_user_id,SYSDATE,l_user_id,l_login_id;
494:
495: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
496: BIS_COLLECTION_UTILITIES.Debug('Done populating the Quote fact Table:'||'Rowcount:'|| SQL%ROWCOUNT);
497: END IF;
498:
499: COMMIT;

Line 496: BIS_COLLECTION_UTILITIES.Debug('Done populating the Quote fact Table:'||'Rowcount:'|| SQL%ROWCOUNT);

492: STG.total_adjusted_percent,
493: STG.recurring_charge_flag)' USING SYSDATE, l_user_id,l_login_id,SYSDATE,l_user_id,SYSDATE,l_user_id,l_login_id;
494:
495: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
496: BIS_COLLECTION_UTILITIES.Debug('Done populating the Quote fact Table:'||'Rowcount:'|| SQL%ROWCOUNT);
497: END IF;
498:
499: COMMIT;
500:

Line 518: IF(BIS_COLLECTION_UTILITIES.Setup(

514: Begin
515: errbuf := NULL;
516: retcode := 0;
517:
518: IF(BIS_COLLECTION_UTILITIES.Setup(
519: p_object_name => 'ASO_BI_QOT_HDR_SUBWORKER'||p_worker_no)) = false
520: Then
521: errbuf := FND_MESSAGE.Get;
522: RAISE_APPLICATION_ERROR(-20000,errbuf);

Line 525: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

521: errbuf := FND_MESSAGE.Get;
522: RAISE_APPLICATION_ERROR(-20000,errbuf);
523: End if;
524:
525: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
526: BIS_COLLECTION_UTILITIES.Debug('ASO_BI_QOT_HDR_SUBWORKER'||p_worker_no||' starting.');
527: END IF;
528:
529: LOOP

Line 526: BIS_COLLECTION_UTILITIES.Debug('ASO_BI_QOT_HDR_SUBWORKER'||p_worker_no||' starting.');

522: RAISE_APPLICATION_ERROR(-20000,errbuf);
523: End if;
524:
525: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
526: BIS_COLLECTION_UTILITIES.Debug('ASO_BI_QOT_HDR_SUBWORKER'||p_worker_no||' starting.');
527: END IF;
528:
529: LOOP
530: SELECT NVL(SUM(DECODE(status,'UNASSIGNED',1,0)),0),

Line 541: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

537: l_total_cnt
538: FROM ASO_BI_QUOTE_FACT_JOBS;
539:
540: IF(l_failed_cnt > 0) Then
541: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
542: BIS_COLLECTION_UTILITIES.Debug('Another worker have errored out.Stop Processing.');
543: END IF;
544: Exit;
545: Elsif (l_unassigned_cnt = 0) Then

Line 542: BIS_COLLECTION_UTILITIES.Debug('Another worker have errored out.Stop Processing.');

538: FROM ASO_BI_QUOTE_FACT_JOBS;
539:
540: IF(l_failed_cnt > 0) Then
541: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
542: BIS_COLLECTION_UTILITIES.Debug('Another worker have errored out.Stop Processing.');
543: END IF;
544: Exit;
545: Elsif (l_unassigned_cnt = 0) Then
546: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

Line 546: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

542: BIS_COLLECTION_UTILITIES.Debug('Another worker have errored out.Stop Processing.');
543: END IF;
544: Exit;
545: Elsif (l_unassigned_cnt = 0) Then
546: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
547: BIS_COLLECTION_UTILITIES.Debug('No More jobs left.Terminating.');
548: END IF;
549: EXIT;
550: Elsif( l_comp_cnt = l_total_cnt) Then

Line 547: BIS_COLLECTION_UTILITIES.Debug('No More jobs left.Terminating.');

543: END IF;
544: Exit;
545: Elsif (l_unassigned_cnt = 0) Then
546: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
547: BIS_COLLECTION_UTILITIES.Debug('No More jobs left.Terminating.');
548: END IF;
549: EXIT;
550: Elsif( l_comp_cnt = l_total_cnt) Then
551: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

Line 551: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

547: BIS_COLLECTION_UTILITIES.Debug('No More jobs left.Terminating.');
548: END IF;
549: EXIT;
550: Elsif( l_comp_cnt = l_total_cnt) Then
551: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
552: BIS_COLLECTION_UTILITIES.Debug('All Jobs completed.Terminating.');
553: END IF;
554: EXIT;
555: Elsif(l_unassigned_cnt > 0) Then

Line 552: BIS_COLLECTION_UTILITIES.Debug('All Jobs completed.Terminating.');

548: END IF;
549: EXIT;
550: Elsif( l_comp_cnt = l_total_cnt) Then
551: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
552: BIS_COLLECTION_UTILITIES.Debug('All Jobs completed.Terminating.');
553: END IF;
554: EXIT;
555: Elsif(l_unassigned_cnt > 0) Then
556: UPDATE ASO_BI_QUOTE_FACT_JOBS

Line 573: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

569: FROM ASO_BI_QUOTE_FACT_JOBS
570: WHERE worker_number = p_worker_no
571: AND status = 'IN_PROCESS';
572:
573: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
574: BIS_COLLECTION_UTILITIES.Debug('Start populate Staging:'||TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS'));
575: END IF;
576:
577: POPULATE_QOT_FACT_STG(p_batch_id => l_batch_id);

Line 574: BIS_COLLECTION_UTILITIES.Debug('Start populate Staging:'||TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS'));

570: WHERE worker_number = p_worker_no
571: AND status = 'IN_PROCESS';
572:
573: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
574: BIS_COLLECTION_UTILITIES.Debug('Start populate Staging:'||TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS'));
575: END IF;
576:
577: POPULATE_QOT_FACT_STG(p_batch_id => l_batch_id);
578:

Line 579: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN

575: END IF;
576:
577: POPULATE_QOT_FACT_STG(p_batch_id => l_batch_id);
578:
579: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
580: BIS_COLLECTION_UTILITIES.Debug('End populate Staging:'||TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS'));
581: END IF;
582:
583: UPDATE ASO_BI_QUOTE_FACT_JOBS

Line 580: BIS_COLLECTION_UTILITIES.Debug('End populate Staging:'||TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS'));

576:
577: POPULATE_QOT_FACT_STG(p_batch_id => l_batch_id);
578:
579: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
580: BIS_COLLECTION_UTILITIES.Debug('End populate Staging:'||TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS'));
581: END IF;
582:
583: UPDATE ASO_BI_QUOTE_FACT_JOBS
584: SET status = 'COMPLETED'