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 92: l_terr_globals IEX_TERR_WINNERS_PUB.TERR_GLOBALS;

88: p_actual_workers IN VARCHAR2,
89: p_prev_request_id IN NUMBER,
90: p_seq_num IN NUMBER)
91: IS
92: l_terr_globals IEX_TERR_WINNERS_PUB.TERR_GLOBALS;
93: l_status BOOLEAN;
94: l_return_status VARCHAR2(1);
95: l_msg_count NUMBER;
96: l_msg_data VARCHAR2(2000);

Line 117: IEX_TERR_WINNERS_PUB.g_debug_flag := p_debug_mode;

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

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

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

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

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

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

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

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

164:
165: --
166:
167: BEGIN
168: IEX_TERR_WINNERS_PUB.Print_Debug('Starting JTY_ASSIGN_BULK_PUB.get_winners for worker '|| p_worker_id);
169:
170: JTY_ASSIGN_BULK_PUB.get_winners(
171: p_api_version_number => 1.0,
172: p_init_msg_list => FND_API.G_FALSE,

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

182: ERRBUF => l_errbuf,
183: RETCODE => l_retcode
184: );
185:
186: IEX_TERR_WINNERS_PUB.Print_Debug('Completed JTY_ASSIGN_BULK_PUB.get_winners for worker '
187: || p_worker_id || ' with status ' || l_return_status);
188:
189: IEX_TERR_WINNERS_PUB.Print_Debug('Message from JTY_ASSIGN_BULK_PUB.get_winners for worker ' ||
190: l_msg_data);

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

185:
186: IEX_TERR_WINNERS_PUB.Print_Debug('Completed JTY_ASSIGN_BULK_PUB.get_winners for worker '
187: || p_worker_id || ' with status ' || l_return_status);
188:
189: IEX_TERR_WINNERS_PUB.Print_Debug('Message from JTY_ASSIGN_BULK_PUB.get_winners for worker ' ||
190: l_msg_data);
191:
192: COMMIT;
193: EXCEPTION WHEN OTHERS THEN

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

190: l_msg_data);
191:
192: COMMIT;
193: EXCEPTION WHEN OTHERS THEN
194: IEX_TERR_WINNERS_PUB.Print_Debug('Error in JTY_ASSIGN_BULK_PUB.get_winners for worker '|| p_worker_id ||
195: ' '|| SQLERRM);
196: IEX_TERR_WINNERS_PUB.Print_Debug('Error buffer ' || l_errbuf);
197: END;
198:

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

192: COMMIT;
193: EXCEPTION WHEN OTHERS THEN
194: IEX_TERR_WINNERS_PUB.Print_Debug('Error in JTY_ASSIGN_BULK_PUB.get_winners for worker '|| p_worker_id ||
195: ' '|| SQLERRM);
196: IEX_TERR_WINNERS_PUB.Print_Debug('Error buffer ' || l_errbuf);
197: END;
198:
199: SELECT count(*) INTO l_acc_count FROM jtf_tae_1600_cust_winners;
200: IEX_TERR_WINNERS_PUB.Print_Debug('Number of records in jtf_tae_1600_cust_winners : ' || l_acc_count );

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

196: IEX_TERR_WINNERS_PUB.Print_Debug('Error buffer ' || l_errbuf);
197: END;
198:
199: SELECT count(*) INTO l_acc_count FROM jtf_tae_1600_cust_winners;
200: IEX_TERR_WINNERS_PUB.Print_Debug('Number of records in jtf_tae_1600_cust_winners : ' || l_acc_count );
201:
202:
203: --
204:

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

235:
236: -- Delete Unqualified Access Records for Account,Oppot,Lead.
237: IF l_terr_globals.transaction_type = 'ACCOUNT' THEN
238: -- ffang 110703, enh2737659, New new mode TAP
239: IEX_TERR_WINNERS_PUB.Print_Debug('Clean up for Accounts');
240: IF p_run_mode = IEX_ATA_PUB.G_TOTAL_MODE THEN
241: IEX_TERR_ASSIGNMENT_CLEANUP.Perform_Account_Cleanup(
242: x_errbuf => l_errbuf,
243: x_retcode => l_retcode,

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

252: l_sub_exist := iex_gar_pub.exist_subscription(G_BUSINESS_EVENT);
253:
254: IF ((l_return_status = 'S') AND (l_sub_exist = 'Y')) THEN
255:
256: IEX_TERR_WINNERS_PUB.Print_Debug('--- Event subscription exists... ');
257: IEX_TERR_WINNERS_PUB.Print_Debug('--- Event subscription raised from Account... ');
258:
259: RAISE_BES(l_terr_globals);
260:

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

253:
254: IF ((l_return_status = 'S') AND (l_sub_exist = 'Y')) THEN
255:
256: IEX_TERR_WINNERS_PUB.Print_Debug('--- Event subscription exists... ');
257: IEX_TERR_WINNERS_PUB.Print_Debug('--- Event subscription raised from Account... ');
258:
259: RAISE_BES(l_terr_globals);
260:
261:

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

265: /** End Bug 4419234 07/08/2005 No business events for H release **/
266:
267: EXCEPTION
268: WHEN others THEN
269: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in IEX_GAR_PUB::Generate_Access_Records');
270: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE ' || to_char(SQLCODE) || ' SQLERRM ' || SQLERRM );
271: errbuf := SQLERRM;
272: retcode := SQLCODE;
273: --retcode := FND_API.G_RET_STS_UNEXP_ERROR;

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

266:
267: EXCEPTION
268: WHEN others THEN
269: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in IEX_GAR_PUB::Generate_Access_Records');
270: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE ' || to_char(SQLCODE) || ' SQLERRM ' || SQLERRM );
271: errbuf := SQLERRM;
272: retcode := SQLCODE;
273: --retcode := FND_API.G_RET_STS_UNEXP_ERROR;
274: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

Line 300: px_terr_globals IN OUT NOCOPY IEX_TERR_WINNERS_PUB.TERR_GLOBALS)

296: p_worker_id IN VARCHAR2,
297: p_actual_workers IN VARCHAR2,
298: p_prev_request_id IN NUMBER,
299: p_seq_num IN NUMBER,
300: px_terr_globals IN OUT NOCOPY IEX_TERR_WINNERS_PUB.TERR_GLOBALS)
301: IS
302: l_ata_request_id_of_failed_gar number := -1;
303: l_temp varchar(300) ;
304:

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

363: -- If request_id = 0, select directly from sequence
364: IF px_terr_globals.request_id = 0 OR px_terr_globals.request_id IS NULL
365: THEN
366: -- Get concurrent sequence
367: IEX_TERR_WINNERS_PUB.Print_Debug('request_id is 0, get from sequence');
368: SELECT fnd_concurrent_requests_s.nextval into px_terr_globals.request_id from dual;
369: END IF;
370:
371: -- Get the profile option for AS_ENABLE_DUPS_RS_DELETION

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

380: select REQUEST_ID into l_ata_request_id_of_failed_gar from jtf_tae_1001_account_trans
381: where request_id is not null and rownum < 2 ;
382: exception
383: when others then
384: IEX_TERR_WINNERS_PUB.Print_Debug('Cannot restart- JTF_TAE_1001_ACCOUNT_TRANS is Empty');
385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
386: end;
387: px_terr_globals.prev_request_id := l_ata_request_id_of_failed_gar;
388: ELSE

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

395: COMMIT;
396:
397: EXCEPTION
398: WHEN others THEN
399: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in AS_GAR_PUB::Init');
400: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE ' || to_char(SQLCODE) ||
401: ' SQLERRM ' || SQLERRM);
402: RAISE;
403: END Init;

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

396:
397: EXCEPTION
398: WHEN others THEN
399: IEX_TERR_WINNERS_PUB.Print_Debug('Exception: others in AS_GAR_PUB::Init');
400: IEX_TERR_WINNERS_PUB.Print_Debug('SQLCODE ' || to_char(SQLCODE) ||
401: ' SQLERRM ' || SQLERRM);
402: RAISE;
403: END Init;
404:

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

469: |
470: | HISTORY
471: *-------------------------------------------------------------------------*/
472:
473: PROCEDURE RAISE_BES(p_terr_globals IN OUT NOCOPY IEX_TERR_WINNERS_PUB.TERR_GLOBALS) IS
474:
475: l_mode VARCHAR2(7);
476: l_request_id NUMBER;
477: l_ata_request_id NUMBER;

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

531: begin
532:
533: SELECT AS_BUSINESS_EVENT_S.nextval INTO l_event_id FROM dual;
534:
535: IEX_TERR_WINNERS_PUB.Print_Debug(' --- CALL WF_EVENT.RAISE.Start...');
536: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_event_id = '||l_event_id);
537: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_mode = '||l_mode);
538: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_request_id = '||l_request_id);
539: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_ata_request_id = '||l_ata_request_id);

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

532:
533: SELECT AS_BUSINESS_EVENT_S.nextval INTO l_event_id FROM dual;
534:
535: IEX_TERR_WINNERS_PUB.Print_Debug(' --- CALL WF_EVENT.RAISE.Start...');
536: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_event_id = '||l_event_id);
537: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_mode = '||l_mode);
538: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_request_id = '||l_request_id);
539: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_ata_request_id = '||l_ata_request_id);
540: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_worker_id = '||l_worker_id);

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

533: SELECT AS_BUSINESS_EVENT_S.nextval INTO l_event_id FROM dual;
534:
535: IEX_TERR_WINNERS_PUB.Print_Debug(' --- CALL WF_EVENT.RAISE.Start...');
536: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_event_id = '||l_event_id);
537: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_mode = '||l_mode);
538: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_request_id = '||l_request_id);
539: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_ata_request_id = '||l_ata_request_id);
540: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_worker_id = '||l_worker_id);
541: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_transaction_type = '||l_transaction_type);

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

534:
535: IEX_TERR_WINNERS_PUB.Print_Debug(' --- CALL WF_EVENT.RAISE.Start...');
536: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_event_id = '||l_event_id);
537: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_mode = '||l_mode);
538: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_request_id = '||l_request_id);
539: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_ata_request_id = '||l_ata_request_id);
540: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_worker_id = '||l_worker_id);
541: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_transaction_type = '||l_transaction_type);
542: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_total_num_gar_workers = '||l_total_num_gar_workers);

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

535: IEX_TERR_WINNERS_PUB.Print_Debug(' --- CALL WF_EVENT.RAISE.Start...');
536: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_event_id = '||l_event_id);
537: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_mode = '||l_mode);
538: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_request_id = '||l_request_id);
539: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_ata_request_id = '||l_ata_request_id);
540: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_worker_id = '||l_worker_id);
541: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_transaction_type = '||l_transaction_type);
542: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_total_num_gar_workers = '||l_total_num_gar_workers);
543:

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

536: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_event_id = '||l_event_id);
537: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_mode = '||l_mode);
538: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_request_id = '||l_request_id);
539: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_ata_request_id = '||l_ata_request_id);
540: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_worker_id = '||l_worker_id);
541: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_transaction_type = '||l_transaction_type);
542: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_total_num_gar_workers = '||l_total_num_gar_workers);
543:
544:

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

537: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_mode = '||l_mode);
538: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_request_id = '||l_request_id);
539: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_ata_request_id = '||l_ata_request_id);
540: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_worker_id = '||l_worker_id);
541: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_transaction_type = '||l_transaction_type);
542: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_total_num_gar_workers = '||l_total_num_gar_workers);
543:
544:
545: wf_event.raise (

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

538: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_request_id = '||l_request_id);
539: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_ata_request_id = '||l_ata_request_id);
540: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_worker_id = '||l_worker_id);
541: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_transaction_type = '||l_transaction_type);
542: IEX_TERR_WINNERS_PUB.Print_Debug(' --- l_total_num_gar_workers = '||l_total_num_gar_workers);
543:
544:
545: wf_event.raise (
546: p_event_name => G_BUSINESS_EVENT,

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

553:
554: x_errbuf := SQLERRM;
555: x_retcode := SQLCODE;
556:
557: IEX_TERR_WINNERS_PUB.Print_Debug(' --- x_errbuf = '||x_errbuf||' , x_retcode = '||x_retcode);
558:
559: end;
560:
561: l_param_list.DELETE;

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

558:
559: end;
560:
561: l_param_list.DELETE;
562: IEX_TERR_WINNERS_PUB.Print_Debug(' --- CALL WF_EVENT.RAISE.End...');
563:
564: **/
565:
566: null;