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_NA_WF dependencies on JTF_TTY_WORKFLOW_POP_BIN_PVT

Line 102: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('Beginning of JTF_TTY_NA_WF.AssignRep');

98: AND TGA.TERR_GROUP_ID = c_terr_group_id ;
99:
100:
101: BEGIN
102: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('Beginning of JTF_TTY_NA_WF.AssignRep');
103:
104: --get workflow attributes being passed in
105: l_lead_state := wf_engine.GetItemAttrText
106: ( itemtype => itemtype

Line 110: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('l_lead_state is:'||l_lead_state);

106: ( itemtype => itemtype
107: , itemkey => itemkey
108: , aname => 'STATE'
109: );
110: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('l_lead_state is:'||l_lead_state);
111:
112: l_lead_keyword := wf_engine.GetItemAttrText
113: ( itemtype => itemtype
114: , itemkey => itemkey

Line 117: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('l_lead_keyword is:'||l_lead_keyword);

113: ( itemtype => itemtype
114: , itemkey => itemkey
115: , aname => 'KEYWORD'
116: );
117: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('l_lead_keyword is:'||l_lead_keyword);
118:
119: l_lead_postal_code := wf_engine.GetItemAttrText
120: ( itemtype => itemtype
121: , itemkey => itemkey

Line 124: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('l_lead_postal_code is:'||l_lead_postal_code);

120: ( itemtype => itemtype
121: , itemkey => itemkey
122: , aname => 'POSTAL_CODE'
123: );
124: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('l_lead_postal_code is:'||l_lead_postal_code);
125:
126: l_lead_terrgroup_Id := wf_engine.GetItemAttrNumber
127: ( itemtype => itemtype
128: , itemkey => itemkey

Line 131: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('l_lead_terrgroup_Id is:'||l_lead_terrgroup_Id);

127: ( itemtype => itemtype
128: , itemkey => itemkey
129: , aname => 'TERRGROUP_ID'
130: );
131: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('l_lead_terrgroup_Id is:'||l_lead_terrgroup_Id);
132:
133: l_lead_access_Id := wf_engine.GetItemAttrNumber
134: ( itemtype => itemtype
135: , itemkey => itemkey

Line 138: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('l_lead_access_Id is:'||l_lead_access_Id);

134: ( itemtype => itemtype
135: , itemkey => itemkey
136: , aname => 'ACCESS_ID'
137: );
138: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('l_lead_access_Id is:'||l_lead_access_Id);
139:
140: l_party_Id := wf_engine.GetItemAttrNumber
141: ( itemtype => itemtype
142: , itemkey => itemkey

Line 145: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('l_party_Id is:'||l_party_Id);

141: ( itemtype => itemtype
142: , itemkey => itemkey
143: , aname => 'PARTY_ID'
144: );
145: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('l_party_Id is:'||l_party_Id);
146:
147:
148: query_str :=
149: 'SELECT ILV.NAMED_ACCOUNT_ID, TGA.TERR_GROUP_ID ' ||

Line 227: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('query_str is: '||query_str);

223: ' order by site_rank ';
224:
225: --find one named account which satisfies keyword and state requirement
226:
227: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('query_str is: '||query_str);
228:
229: --bug#2878006 fix ARPATEL 04/21/03
230: IF l_lead_state is not null and l_lead_state <> '' and l_lead_postal_code is not null and l_lead_postal_code <> ''
231: THEN

Line 237: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('l_named_account_rec.named_account_id is:'||l_named_account_rec.named_account_id);

233: --find Reps for each named account and assign to the lead
234: OPEN c_named_accounts FOR query_str;
235: FETCH c_named_accounts INTO l_named_account_rec;
236:
237: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('l_named_account_rec.named_account_id is:'||l_named_account_rec.named_account_id);
238: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('l_named_account_rec.terr_group_id is:'||l_named_account_rec.terr_group_id);
239:
240: FOR rs_rec IN c_resources(l_named_account_rec.named_account_id, l_named_account_rec.terr_group_id)
241: LOOP

Line 238: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('l_named_account_rec.terr_group_id is:'||l_named_account_rec.terr_group_id);

234: OPEN c_named_accounts FOR query_str;
235: FETCH c_named_accounts INTO l_named_account_rec;
236:
237: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('l_named_account_rec.named_account_id is:'||l_named_account_rec.named_account_id);
238: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('l_named_account_rec.terr_group_id is:'||l_named_account_rec.terr_group_id);
239:
240: FOR rs_rec IN c_resources(l_named_account_rec.named_account_id, l_named_account_rec.terr_group_id)
241: LOOP
242: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('rs_rec.rsc_group_id is:'||rs_rec.rsc_group_id);

Line 242: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('rs_rec.rsc_group_id is:'||rs_rec.rsc_group_id);

238: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('l_named_account_rec.terr_group_id is:'||l_named_account_rec.terr_group_id);
239:
240: FOR rs_rec IN c_resources(l_named_account_rec.named_account_id, l_named_account_rec.terr_group_id)
241: LOOP
242: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('rs_rec.rsc_group_id is:'||rs_rec.rsc_group_id);
243: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('rs_rec.resource_id is:'||rs_rec.resource_id);
244:
245: --create record in JTF_TTY_NAMED_ACCOUNT, JTF_TTY_ACCT_QUAL_MAPS, JTF_TTY_NAMED_ACCT_RSC
246: --so that NA territory is created next time

Line 243: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('rs_rec.resource_id is:'||rs_rec.resource_id);

239:
240: FOR rs_rec IN c_resources(l_named_account_rec.named_account_id, l_named_account_rec.terr_group_id)
241: LOOP
242: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('rs_rec.rsc_group_id is:'||rs_rec.rsc_group_id);
243: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('rs_rec.resource_id is:'||rs_rec.resource_id);
244:
245: --create record in JTF_TTY_NAMED_ACCOUNT, JTF_TTY_ACCT_QUAL_MAPS, JTF_TTY_NAMED_ACCT_RSC
246: --so that NA territory is created next time
247:

Line 248: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('calling add_org_to_terrgp');

244:
245: --create record in JTF_TTY_NAMED_ACCOUNT, JTF_TTY_ACCT_QUAL_MAPS, JTF_TTY_NAMED_ACCT_RSC
246: --so that NA territory is created next time
247:
248: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('calling add_org_to_terrgp');
249: /** creates a NA, if one for this party_id does not already exist else
250: ** update the existing named account to include postal code as a mapping rule
251: **/
252: add_org_to_terrgp(p_terr_gp_id => l_named_account_rec.terr_group_id,

Line 267: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('End of JTF_TTY_NA_WF.AssignRep');

263: END LOOP;
264:
265: END IF; --end of bug#2878006 fix
266:
267: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('End of JTF_TTY_NA_WF.AssignRep');
268: commit;
269: EXCEPTION
270: WHEN OTHERS
271: THEN

Line 275: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('ERROR_MESSAGE: '||to_char(SQLCODE)||':'||SQLERRM);

271: THEN
272: /*****************************************************************************
273: ** Something went wrong return 'ERROR' and set the ERROR_MESSAGE
274: *****************************************************************************/
275: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('ERROR_MESSAGE: '||to_char(SQLCODE)||':'||SQLERRM);
276: wf_engine.SetItemAttrText( itemtype => itemtype
277: , itemkey => itemkey
278: , aname => 'ERROR_MESSAGE'
279: , avalue => to_char(SQLCODE)||':'||SQLERRM

Line 306: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('begin add_org_to_terrgp');

302: p_terr_gp_acct_rsc_dn_id number(30) := 0;
303: l_acct_qual_map_id number;
304:
305: BEGIN
306: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('begin add_org_to_terrgp');
307:
308: select count(*)
309: into p_account_count
310: from jtf_tty_named_accts

Line 328: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('create a named account');

324:
325: p_site_type_code := get_site_type_code(p_party_id);
326:
327: if (p_account_count < 1) then
328: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('create a named account');
329:
330: insert into jtf_tty_named_accts
331: (NAMED_ACCOUNT_ID,
332: OBJECT_VERSION_NUMBER ,

Line 473: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('p_account_count = 1: Update mapping rules');

469: commit;
470:
471: elsif (p_account_count = 1)
472: then
473: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('p_account_count = 1: Update mapping rules');
474: -- Update mapping rules for this existing named account by adding the postal code mapping
475: select JTF_TTY_ACCT_QUAL_MAPS_S.nextval
476: into l_acct_qual_map_id
477: from dual;

Line 507: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('end add_org_to_terrgp');

503: , sysdate );
504:
505: end if; --ending if (p_account_count < 1)
506:
507: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('end add_org_to_terrgp');
508: END add_org_to_terrgp;
509:
510: function get_site_type_code( p_party_id NUMBER ) return varchar2
511: is

Line 620: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('begin create_mapping_rules');

616: , p_postal_code IN VARCHAR2)
617: AS
618: l_acct_qual_map_id number;
619: BEGIN
620: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('begin create_mapping_rules');
621:
622: select JTF_TTY_ACCT_QUAL_MAPS_S.nextval
623: into l_acct_qual_map_id
624: from dual;

Line 682: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('end create_mapping_rules');

678: , sysdate
679: , G_USER
680: , sysdate );
681:
682: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('end create_mapping_rules');
683:
684: END create_mapping_rules;
685:
686: