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.JTF_TTY_POP_TERR_ADMIN_BIN_PVT dependencies on JTF_TTY_WORKFLOW_POP_BIN_PVT

Line 46: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('In populate_catch_all_bin_info Procedure ');

42: L_ACCOUNTS NUMBER;
43:
44: BEGIN
45: L_SYSDATE := SYSDATE;
46: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('In populate_catch_all_bin_info Procedure ');
47:
48: Update jtf_tty_admin_bin_summ jtabs
49: set LEADS = 0
50: , OPPORTUNITIES = 0

Line 109: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('Exception others in populate_catch_all_bin_information '||SQLERRM);

105:
106:
107: EXCEPTION
108: when FND_API.G_EXC_ERROR then
109: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('Exception others in populate_catch_all_bin_information '||SQLERRM);
110: RETURN;
111: when FND_API.G_EXC_UNEXPECTED_ERROR then
112: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log ('Exception others in populate_catch_all_bin_information '||SQLERRM);
113: RETURN;

Line 112: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log ('Exception others in populate_catch_all_bin_information '||SQLERRM);

108: when FND_API.G_EXC_ERROR then
109: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('Exception others in populate_catch_all_bin_information '||SQLERRM);
110: RETURN;
111: when FND_API.G_EXC_UNEXPECTED_ERROR then
112: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log ('Exception others in populate_catch_all_bin_information '||SQLERRM);
113: RETURN;
114: when others then
115: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log ('Exception others in populate_catch_all_bin_information '||SQLERRM);
116: RETURN;

Line 115: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log ('Exception others in populate_catch_all_bin_information '||SQLERRM);

111: when FND_API.G_EXC_UNEXPECTED_ERROR then
112: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log ('Exception others in populate_catch_all_bin_information '||SQLERRM);
113: RETURN;
114: when others then
115: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log ('Exception others in populate_catch_all_bin_information '||SQLERRM);
116: RETURN;
117:
118: END populate_catch_all_bin_info;
119:

Line 133: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('In populate_kpi_bin_info Procedure ');

129:
130: BEGIN
131: L_SYSDATE := SYSDATE;
132:
133: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('In populate_kpi_bin_info Procedure ');
134:
135: Update jtf_tty_admin_bin_summ jtabs
136: set TOTAL_NAMED_ACCOUNT = '0.0%'
137: , MAPPED_NAMED_ACC_PER = '0.0%'

Line 177: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('Exception others in populate_kpi_bin_information '||SQLERRM);

173:
174:
175: EXCEPTION
176: when FND_API.G_EXC_ERROR then
177: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('Exception others in populate_kpi_bin_information '||SQLERRM);
178: RETURN;
179: when FND_API.G_EXC_UNEXPECTED_ERROR then
180: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log ('Exception others in populate_kpi_bin_information '||SQLERRM);
181: RETURN;

Line 180: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log ('Exception others in populate_kpi_bin_information '||SQLERRM);

176: when FND_API.G_EXC_ERROR then
177: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('Exception others in populate_kpi_bin_information '||SQLERRM);
178: RETURN;
179: when FND_API.G_EXC_UNEXPECTED_ERROR then
180: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log ('Exception others in populate_kpi_bin_information '||SQLERRM);
181: RETURN;
182: when others then
183: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log ('Exception others in populate_kpi_bin_information '||SQLERRM);
184: RETURN;

Line 183: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log ('Exception others in populate_kpi_bin_information '||SQLERRM);

179: when FND_API.G_EXC_UNEXPECTED_ERROR then
180: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log ('Exception others in populate_kpi_bin_information '||SQLERRM);
181: RETURN;
182: when others then
183: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log ('Exception others in populate_kpi_bin_information '||SQLERRM);
184: RETURN;
185:
186: END populate_kpi_bin_info;
187:

Line 201: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('Synchronizing the SUMM table with TERR_GROUPS table');

197:
198: BEGIN
199: L_SYSDATE := SYSDATE;
200:
201: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('Synchronizing the SUMM table with TERR_GROUPS table');
202: /* take care of the logic moved from web adi admin excel */
203:
204: UPDATE JTF_TTY_TERR_GRP_ACCTS
205: SET DN_JNR_ASSIGNED_FLAG = 'Y'

Line 262: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log (' Error in Synchronizing the SUMM table' || SQLERRM );

258: COMMIT;
259:
260: EXCEPTION
261: when FND_API.G_EXC_ERROR then
262: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log (' Error in Synchronizing the SUMM table' || SQLERRM );
263: RETURN;
264: when FND_API.G_EXC_UNEXPECTED_ERROR then
265: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log (' Error in Synchronizing the SUMM table' || SQLERRM );
266: RETURN;

Line 265: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log (' Error in Synchronizing the SUMM table' || SQLERRM );

261: when FND_API.G_EXC_ERROR then
262: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log (' Error in Synchronizing the SUMM table' || SQLERRM );
263: RETURN;
264: when FND_API.G_EXC_UNEXPECTED_ERROR then
265: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log (' Error in Synchronizing the SUMM table' || SQLERRM );
266: RETURN;
267: when others then
268: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log (' Error in Synchronizing the SUMM table' || SQLERRM );
269: RETURN;

Line 268: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log (' Error in Synchronizing the SUMM table' || SQLERRM );

264: when FND_API.G_EXC_UNEXPECTED_ERROR then
265: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log (' Error in Synchronizing the SUMM table' || SQLERRM );
266: RETURN;
267: when others then
268: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log (' Error in Synchronizing the SUMM table' || SQLERRM );
269: RETURN;
270:
271: END Sync_terr_group;
272: