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.IEX_GAR_PUB dependencies on IEX_TERR_WINNERS_PUB

Line 58: px_terr_globals IN OUT NOCOPY IEX_TERR_WINNERS_PUB.TERR_GLOBALS);

54: p_worker_id IN VARCHAR2,
55: p_actual_workers IN VARCHAR2,
56: p_prev_request_id IN NUMBER,
57: p_seq_num IN NUMBER,
58: px_terr_globals IN OUT NOCOPY IEX_TERR_WINNERS_PUB.TERR_GLOBALS);
59: FUNCTION exist_subscription(p_event_name IN VARCHAR2) return VARCHAR2;
60: PROCEDURE RAISE_BES(p_terr_globals IN OUT NOCOPY IEX_TERR_WINNERS_PUB.TERR_GLOBALS);
61:
62:

Line 60: PROCEDURE RAISE_BES(p_terr_globals IN OUT NOCOPY IEX_TERR_WINNERS_PUB.TERR_GLOBALS);

56: p_prev_request_id IN NUMBER,
57: p_seq_num IN NUMBER,
58: px_terr_globals IN OUT NOCOPY IEX_TERR_WINNERS_PUB.TERR_GLOBALS);
59: FUNCTION exist_subscription(p_event_name IN VARCHAR2) return VARCHAR2;
60: PROCEDURE RAISE_BES(p_terr_globals IN OUT NOCOPY IEX_TERR_WINNERS_PUB.TERR_GLOBALS);
61:
62:
63:
64: /*------------------------------------------------------------------------*

Line 93: l_terr_globals IEX_TERR_WINNERS_PUB.TERR_GLOBALS;

89: p_prev_request_id IN NUMBER,
90: p_seq_num IN NUMBER,
91: p_assign_level IN VARCHAR2) -- Added for bug 8708291 pnaveenk multi level strategy
92: IS
93: l_terr_globals IEX_TERR_WINNERS_PUB.TERR_GLOBALS;
94: l_status BOOLEAN;
95: l_return_status VARCHAR2(1);
96: l_msg_count NUMBER;
97: l_msg_data VARCHAR2(2000);

Line 118: IEX_TERR_WINNERS_PUB.g_debug_flag := p_debug_mode;

114:
115: BEGIN
116:
117: g_debug_flag := p_debug_mode;
118: IEX_TERR_WINNERS_PUB.g_debug_flag := p_debug_mode;
119: BEGIN
120: SELECT org_id INTO L_ORG_ID
121: FROM fnd_concurrent_requests
122: WHERE request_id=p_prev_request_id;

Line 127: IEX_TERR_WINNERS_PUB.Print_Debug('* Starting iextptwb.pls::Generate_Access_Records *');

123: EXCEPTION WHEN OTHERS THEN
124: l_org_id := NULL;
125: END;
126:
127: IEX_TERR_WINNERS_PUB.Print_Debug('*** Starting iextptwb.pls::Generate_Access_Records ***');
128: --Bug5043777. Fix By LKKUMAR. Start.
129: MO_GLOBAL.INIT('IEX');
130: IF (l_org_id IS NOT NULL) THEN
131: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_org_id);

Line 137: IEX_TERR_WINNERS_PUB.Print_Debug('Operating Unit Set : ' || 'All');

133: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL);
134: END IF;
135:
136: IF (MO_GLOBAL.GET_CURRENT_ORG_ID IS NULL) THEN
137: IEX_TERR_WINNERS_PUB.Print_Debug('Operating Unit Set : ' || 'All');
138: ELSE
139: IEX_TERR_WINNERS_PUB.Print_Debug('Operating Unit Set : ' || MO_GLOBAL.GET_OU_NAME(MO_GLOBAL.GET_CURRENT_ORG_ID));
140: END IF;
141: --Bug5043777. Fix By LKKUMAR. End.

Line 139: IEX_TERR_WINNERS_PUB.Print_Debug('Operating Unit Set : ' || MO_GLOBAL.GET_OU_NAME(MO_GLOBAL.GET_CURRENT_ORG_ID));

135:
136: IF (MO_GLOBAL.GET_CURRENT_ORG_ID IS NULL) THEN
137: IEX_TERR_WINNERS_PUB.Print_Debug('Operating Unit Set : ' || 'All');
138: ELSE
139: IEX_TERR_WINNERS_PUB.Print_Debug('Operating Unit Set : ' || MO_GLOBAL.GET_OU_NAME(MO_GLOBAL.GET_CURRENT_ORG_ID));
140: END IF;
141: --Bug5043777. Fix By LKKUMAR. End.
142:
143:

Line 170: IEX_TERR_WINNERS_PUB.Print_Debug('Starting JTY_ASSIGN_BULK_PUB.get_winners for worker '|| p_worker_id);

166: --
167:
168: BEGIN
169:
170: IEX_TERR_WINNERS_PUB.Print_Debug('Starting JTY_ASSIGN_BULK_PUB.get_winners for worker '|| p_worker_id);
171:
172: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
173: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
174: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting JTY_ASSIGN_BULK_PUB.get_winners...');

Line 192: IEX_TERR_WINNERS_PUB.Print_Debug('Completed JTY_ASSIGN_BULK_PUB.get_winners for worker '

188: ERRBUF => l_errbuf,
189: RETCODE => l_retcode
190: );
191:
192: IEX_TERR_WINNERS_PUB.Print_Debug('Completed JTY_ASSIGN_BULK_PUB.get_winners for worker '
193: || p_worker_id || ' with status ' || l_return_status);
194:
195: IEX_TERR_WINNERS_PUB.Print_Debug('Message from JTY_ASSIGN_BULK_PUB.get_winners for worker ' ||
196: l_msg_data);

Line 195: IEX_TERR_WINNERS_PUB.Print_Debug('Message from JTY_ASSIGN_BULK_PUB.get_winners for worker ' ||

191:
192: IEX_TERR_WINNERS_PUB.Print_Debug('Completed JTY_ASSIGN_BULK_PUB.get_winners for worker '
193: || p_worker_id || ' with status ' || l_return_status);
194:
195: IEX_TERR_WINNERS_PUB.Print_Debug('Message from JTY_ASSIGN_BULK_PUB.get_winners for worker ' ||
196: l_msg_data);
197:
198: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
199: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');

Line 205: IEX_TERR_WINNERS_PUB.Print_Debug('Error in JTY_ASSIGN_BULK_PUB.get_winners for worker '|| p_worker_id ||

201:
202: COMMIT;
203:
204: EXCEPTION WHEN OTHERS THEN
205: IEX_TERR_WINNERS_PUB.Print_Debug('Error in JTY_ASSIGN_BULK_PUB.get_winners for worker '|| p_worker_id ||
206: ' '|| SQLERRM);
207: IEX_TERR_WINNERS_PUB.Print_Debug('Error buffer ' || l_errbuf);
208: END;
209:

Line 207: IEX_TERR_WINNERS_PUB.Print_Debug('Error buffer ' || l_errbuf);

203:
204: EXCEPTION WHEN OTHERS THEN
205: IEX_TERR_WINNERS_PUB.Print_Debug('Error in JTY_ASSIGN_BULK_PUB.get_winners for worker '|| p_worker_id ||
206: ' '|| SQLERRM);
207: IEX_TERR_WINNERS_PUB.Print_Debug('Error buffer ' || l_errbuf);
208: END;
209:
210: SELECT count(*) INTO l_acc_count FROM jtf_tae_1600_cust_winners;
211: IEX_TERR_WINNERS_PUB.Print_Debug('Number of records in jtf_tae_1600_cust_winners : ' || l_acc_count );

Line 211: IEX_TERR_WINNERS_PUB.Print_Debug('Number of records in jtf_tae_1600_cust_winners : ' || l_acc_count );

207: IEX_TERR_WINNERS_PUB.Print_Debug('Error buffer ' || l_errbuf);
208: END;
209:
210: SELECT count(*) INTO l_acc_count FROM jtf_tae_1600_cust_winners;
211: IEX_TERR_WINNERS_PUB.Print_Debug('Number of records in jtf_tae_1600_cust_winners : ' || l_acc_count );
212:
213: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number of records in jtf_tae_1600_cust_winners : ' || l_acc_count );
214: --
215:

Line 251: IEX_TERR_WINNERS_PUB.Print_Debug('Clean up for Accounts');

247:
248: -- Delete Unqualified Access Records for Account,Oppot,Lead.
249: IF l_terr_globals.transaction_type = 'ACCOUNT' THEN
250: -- ffang 110703, enh2737659, New new mode TAP
251: IEX_TERR_WINNERS_PUB.Print_Debug('Clean up for Accounts');
252: IF p_run_mode = IEX_ATA_PUB.G_TOTAL_MODE THEN
253: IEX_TERR_ASSIGNMENT_CLEANUP.Perform_Account_Cleanup(
254: x_errbuf => l_errbuf,
255: x_retcode => l_retcode,

Line 268: IEX_TERR_WINNERS_PUB.Print_Debug('--- Event subscription exists... ');

264: l_sub_exist := iex_gar_pub.exist_subscription(G_BUSINESS_EVENT);
265:
266: IF ((l_return_status = 'S') AND (l_sub_exist = 'Y')) THEN
267:
268: IEX_TERR_WINNERS_PUB.Print_Debug('--- Event subscription exists... ');
269: IEX_TERR_WINNERS_PUB.Print_Debug('--- Event subscription raised from Account... ');
270:
271: RAISE_BES(l_terr_globals);
272:

Line 269: IEX_TERR_WINNERS_PUB.Print_Debug('--- Event subscription raised from Account... ');

265:
266: IF ((l_return_status = 'S') AND (l_sub_exist = 'Y')) THEN
267:
268: IEX_TERR_WINNERS_PUB.Print_Debug('--- Event subscription exists... ');
269: IEX_TERR_WINNERS_PUB.Print_Debug('--- Event subscription raised from Account... ');
270:
271: RAISE_BES(l_terr_globals);
272:
273:

Line 281: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in IEX_GAR_PUB::Generate_Access_Records');

277: /** End Bug 4419234 07/08/2005 No business events for H release **/
278:
279: EXCEPTION
280: WHEN others THEN
281: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in IEX_GAR_PUB::Generate_Access_Records');
282: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE ' || to_char(SQLCODE) || ' SQLERRM ' || SQLERRM );
283: errbuf := SQLERRM;
284: retcode := SQLCODE;
285: --retcode := FND_API.G_RET_STS_UNEXP_ERROR;

Line 282: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE ' || to_char(SQLCODE) || ' SQLERRM ' || SQLERRM );

278:
279: EXCEPTION
280: WHEN others THEN
281: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in IEX_GAR_PUB::Generate_Access_Records');
282: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE ' || to_char(SQLCODE) || ' SQLERRM ' || SQLERRM );
283: errbuf := SQLERRM;
284: retcode := SQLCODE;
285: --retcode := FND_API.G_RET_STS_UNEXP_ERROR;
286: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

Line 312: px_terr_globals IN OUT NOCOPY IEX_TERR_WINNERS_PUB.TERR_GLOBALS)

308: p_worker_id IN VARCHAR2,
309: p_actual_workers IN VARCHAR2,
310: p_prev_request_id IN NUMBER,
311: p_seq_num IN NUMBER,
312: px_terr_globals IN OUT NOCOPY IEX_TERR_WINNERS_PUB.TERR_GLOBALS)
313: IS
314: l_ata_request_id_of_failed_gar number := -1;
315: l_temp varchar(300) ;
316:

Line 379: IEX_TERR_WINNERS_PUB.Print_Debug('request_id is 0, get from sequence');

375: -- If request_id = 0, select directly from sequence
376: IF px_terr_globals.request_id = 0 OR px_terr_globals.request_id IS NULL
377: THEN
378: -- Get concurrent sequence
379: IEX_TERR_WINNERS_PUB.Print_Debug('request_id is 0, get from sequence');
380: SELECT fnd_concurrent_requests_s.nextval into px_terr_globals.request_id from dual;
381: END IF;
382:
383: -- Get the profile option for AS_ENABLE_DUPS_RS_DELETION

Line 396: IEX_TERR_WINNERS_PUB.Print_Debug('Cannot restart- JTF_TAE_1001_ACCOUNT_TRANS is Empty');

392: select REQUEST_ID into l_ata_request_id_of_failed_gar from jtf_tae_1001_account_trans
393: where request_id is not null and rownum < 2 ;
394: exception
395: when others then
396: IEX_TERR_WINNERS_PUB.Print_Debug('Cannot restart- JTF_TAE_1001_ACCOUNT_TRANS is Empty');
397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
398: end;
399: px_terr_globals.prev_request_id := l_ata_request_id_of_failed_gar;
400: ELSE

Line 411: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in AS_GAR_PUB::Init');

407: COMMIT;
408:
409: EXCEPTION
410: WHEN others THEN
411: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in AS_GAR_PUB::Init');
412: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE ' || to_char(SQLCODE) ||
413: ' SQLERRM ' || SQLERRM);
414: RAISE;
415: END Init;

Line 412: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE ' || to_char(SQLCODE) ||

408:
409: EXCEPTION
410: WHEN others THEN
411: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in AS_GAR_PUB::Init');
412: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE ' || to_char(SQLCODE) ||
413: ' SQLERRM ' || SQLERRM);
414: RAISE;
415: END Init;
416:

Line 485: PROCEDURE RAISE_BES(p_terr_globals IN OUT NOCOPY IEX_TERR_WINNERS_PUB.TERR_GLOBALS) IS

481: |
482: | HISTORY
483: *-------------------------------------------------------------------------*/
484:
485: PROCEDURE RAISE_BES(p_terr_globals IN OUT NOCOPY IEX_TERR_WINNERS_PUB.TERR_GLOBALS) IS
486:
487: l_mode VARCHAR2(7);
488: l_request_id NUMBER;
489: l_ata_request_id NUMBER;

Line 547: IEX_TERR_WINNERS_PUB.Print_Debug(' --- CALL WF_EVENT.RAISE.Start...');

543: begin
544:
545: SELECT AS_BUSINESS_EVENT_S.nextval INTO l_event_id FROM dual;
546:
547: IEX_TERR_WINNERS_PUB.Print_Debug(' --- CALL WF_EVENT.RAISE.Start...');
548: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_event_id = '||l_event_id);
549: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_mode = '||l_mode);
550: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_request_id = '||l_request_id);
551: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_ata_request_id = '||l_ata_request_id);

Line 548: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_event_id = '||l_event_id);

544:
545: SELECT AS_BUSINESS_EVENT_S.nextval INTO l_event_id FROM dual;
546:
547: IEX_TERR_WINNERS_PUB.Print_Debug(' --- CALL WF_EVENT.RAISE.Start...');
548: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_event_id = '||l_event_id);
549: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_mode = '||l_mode);
550: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_request_id = '||l_request_id);
551: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_ata_request_id = '||l_ata_request_id);
552: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_worker_id = '||l_worker_id);

Line 549: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_mode = '||l_mode);

545: SELECT AS_BUSINESS_EVENT_S.nextval INTO l_event_id FROM dual;
546:
547: IEX_TERR_WINNERS_PUB.Print_Debug(' --- CALL WF_EVENT.RAISE.Start...');
548: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_event_id = '||l_event_id);
549: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_mode = '||l_mode);
550: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_request_id = '||l_request_id);
551: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_ata_request_id = '||l_ata_request_id);
552: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_worker_id = '||l_worker_id);
553: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_transaction_type = '||l_transaction_type);

Line 550: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_request_id = '||l_request_id);

546:
547: IEX_TERR_WINNERS_PUB.Print_Debug(' --- CALL WF_EVENT.RAISE.Start...');
548: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_event_id = '||l_event_id);
549: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_mode = '||l_mode);
550: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_request_id = '||l_request_id);
551: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_ata_request_id = '||l_ata_request_id);
552: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_worker_id = '||l_worker_id);
553: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_transaction_type = '||l_transaction_type);
554: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_total_num_gar_workers = '||l_total_num_gar_workers);

Line 551: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_ata_request_id = '||l_ata_request_id);

547: IEX_TERR_WINNERS_PUB.Print_Debug(' --- CALL WF_EVENT.RAISE.Start...');
548: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_event_id = '||l_event_id);
549: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_mode = '||l_mode);
550: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_request_id = '||l_request_id);
551: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_ata_request_id = '||l_ata_request_id);
552: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_worker_id = '||l_worker_id);
553: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_transaction_type = '||l_transaction_type);
554: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_total_num_gar_workers = '||l_total_num_gar_workers);
555:

Line 552: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_worker_id = '||l_worker_id);

548: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_event_id = '||l_event_id);
549: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_mode = '||l_mode);
550: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_request_id = '||l_request_id);
551: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_ata_request_id = '||l_ata_request_id);
552: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_worker_id = '||l_worker_id);
553: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_transaction_type = '||l_transaction_type);
554: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_total_num_gar_workers = '||l_total_num_gar_workers);
555:
556:

Line 553: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_transaction_type = '||l_transaction_type);

549: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_mode = '||l_mode);
550: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_request_id = '||l_request_id);
551: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_ata_request_id = '||l_ata_request_id);
552: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_worker_id = '||l_worker_id);
553: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_transaction_type = '||l_transaction_type);
554: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_total_num_gar_workers = '||l_total_num_gar_workers);
555:
556:
557: wf_event.raise (

Line 554: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_total_num_gar_workers = '||l_total_num_gar_workers);

550: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_request_id = '||l_request_id);
551: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_ata_request_id = '||l_ata_request_id);
552: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_worker_id = '||l_worker_id);
553: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_transaction_type = '||l_transaction_type);
554: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_total_num_gar_workers = '||l_total_num_gar_workers);
555:
556:
557: wf_event.raise (
558: p_event_name => G_BUSINESS_EVENT,

Line 569: IEX_TERR_WINNERS_PUB.Print_Debug(' --- x_errbuf = '||x_errbuf||' , x_retcode = '||x_retcode);

565:
566: x_errbuf := SQLERRM;
567: x_retcode := SQLCODE;
568:
569: IEX_TERR_WINNERS_PUB.Print_Debug(' --- x_errbuf = '||x_errbuf||' , x_retcode = '||x_retcode);
570:
571: end;
572:
573: l_param_list.DELETE;

Line 574: IEX_TERR_WINNERS_PUB.Print_Debug(' --- CALL WF_EVENT.RAISE.End...');

570:
571: end;
572:
573: l_param_list.DELETE;
574: IEX_TERR_WINNERS_PUB.Print_Debug(' --- CALL WF_EVENT.RAISE.End...');
575:
576: **/
577:
578: null;