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.PRP_RTTAP_INT_PVT dependencies on FND_LOG

Line 13: IF ( P_LOG_LEVEL >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

9: P_MODULE_NAME IN VARCHAR2,
10: P_LOG_LEVEL IN NUMBER) IS
11: BEGIN
12:
13: IF ( P_LOG_LEVEL >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
14: FND_LOG.STRING(LOG_LEVEL => P_LOG_LEVEL,
15: MODULE => G_PKG_NAME ||':'|| P_MODULE_NAME,
16: MESSAGE => P_LOG_MESSAGE);
17: END IF;

Line 14: FND_LOG.STRING(LOG_LEVEL => P_LOG_LEVEL,

10: P_LOG_LEVEL IN NUMBER) IS
11: BEGIN
12:
13: IF ( P_LOG_LEVEL >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
14: FND_LOG.STRING(LOG_LEVEL => P_LOG_LEVEL,
15: MODULE => G_PKG_NAME ||':'|| P_MODULE_NAME,
16: MESSAGE => P_LOG_MESSAGE);
17: END IF;
18:

Line 59: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

55: FND_MSG_PUB.initialize;
56: END IF;
57:
58: -- Log Debug Messages.
59: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
60: P_MODULE_NAME => l_api_name,
61: P_LOG_MESSAGE => 'In CALL_RUNTIME_TAP.. Parameters: ' ||'P_Proposal_id: ' || p_proposal_id);
62:
63:

Line 77: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

73: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
74: l_trans_rec.txn_date := jtf_terr_date_list(null);
75:
76: -- Log Debug Messages.
77: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
78: P_MODULE_NAME => l_api_name,
79: p_LOG_MESSAGE => 'Before Calling JTY_ASSIGN_REALTIME_PUB.get_winners');
80:
81: JTY_ASSIGN_REALTIME_PUB.get_winners(

Line 99: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

95: x_msg_data => l_msg_data,
96: x_winners_rec => l_WinningTerrMember_tbl);
97:
98: -- Log Debug Messages.
99: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
100: P_MODULE_NAME => l_api_name,
101: P_LOG_MESSAGE => 'After Calling JTY_ASSIGN_REALTIME_PUB.get_winners.. x_return_status: '||l_return_status || ' x_message_data: ' || l_msg_data);
102:
103: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 120: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

116:
117: IF (l_WinningTerrMember_tbl.resource_id.count > 0) THEN
118:
119: FOR i IN l_WinningTerrMember_tbl.terr_id.FIRST .. l_WinningTerrMember_tbl.terr_id.LAST LOOP
120: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
121: P_MODULE_NAME => l_api_name,
122: P_LOG_MESSAGE => 'Data from Winning Records... Trans Object ID : ' || l_WinningTerrMember_tbl.trans_object_id(i) ||
123: 'Trans Detail Object ID : ' || l_WinningTerrMember_tbl.trans_detail_object_id(i) ||
124: 'Terr ID : ' || l_WinningTerrMember_tbl.terr_id(i) || ' Terr Name : ' || l_WinningTerrMember_tbl.terr_name(i) ||

Line 130: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

126: ' Resource TYPE : ' || l_WinningTerrMember_tbl.resource_type(i));
127: END LOOP;
128:
129: -- Log Debug Messages.
130: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
131: P_MODULE_NAME => l_api_name,
132: p_LOG_MESSAGE => 'Before Calling Explode_Groups');
133:
134: -- Explode GROUPS if any inside winners

Line 143: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

139: x_return_status => l_return_status);
140:
141:
142: -- Log Debug Messages.
143: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
144: P_MODULE_NAME => l_api_name,
145: p_LOG_MESSAGE => 'After Calling Explode_Groups... ' ||'x_return_status: ' || l_return_status);
146:
147: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

Line 153: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
150: End If;
151:
152: -- Log Debug Messages.
153: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
154: P_MODULE_NAME => l_api_name,
155: p_LOG_MESSAGE => 'Before Calling Explode_Teams');
156: -- Explode TEAMS if any inside winners
157: EXPLODE_TEAMS(

Line 165: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

161: x_return_status => l_return_status);
162:
163:
164: -- Log Debug Messages.
165: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
166: P_MODULE_NAME => l_api_name,
167: p_LOG_MESSAGE => 'After Calling Explode_Teams... ' ||' x_return_Status: ' || l_return_status);
168:
169: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

Line 177: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

173:
174: -- Insert into Proposal Accesses from Winners
175:
176: -- Log Debug Messages.
177: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
178: P_MODULE_NAME => l_api_name,
179: p_LOG_MESSAGE => 'Before Calling Insert_Accesses');
180: INSERT_ACCESSES(
181: x_errbuf => l_errbuf,

Line 187: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

183: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,
184: x_return_status => l_return_status);
185:
186: -- Log Debug Messages.
187: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
188: P_MODULE_NAME => l_api_name,
189: p_LOG_MESSAGE => 'After Calling Insert_Accesses... ' ||' x_return_Status: ' || l_return_status);
190:
191: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

Line 199: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

195:
196: -- Insert into territory Accesses
197:
198: -- Log Debug Messages.
199: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
200: P_MODULE_NAME => l_api_name,
201: p_LOG_MESSAGE => 'Before Calling Insert_Terr_Accesses');
202: INSERT_TERR_ACCESSES(
203: x_errbuf => l_errbuf,

Line 209: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

205: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,
206: x_return_status => l_return_status);
207:
208: -- Log Debug Messages.
209: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
210: P_MODULE_NAME => l_api_name,
211: p_LOG_MESSAGE => 'After Calling Insert_Terr_Accesses... ' ||' x_return_Status: ' || l_return_status);
212:
213: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

Line 221: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

217: END IF;
218:
219:
220: -- Log Debug Messages.
221: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
222: P_MODULE_NAME => l_api_name,
223: p_LOG_MESSAGE => 'Before Calling Perform_Cleanup');
224: PERFORM_CLEANUP(
225: x_errbuf => l_errbuf,

Line 232: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

228: x_return_status => l_return_status);
229:
230:
231: -- Log Debug Messages.
232: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
233: P_MODULE_NAME => l_api_name,
234: p_LOG_MESSAGE => 'After Calling Perform_Cleanup... ' ||' x_return_Status: ' || l_return_status);
235:
236: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

Line 457: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

453: x_retcode := SQLCODE;
454: x_return_status := FND_API.G_RET_STS_ERROR;
455: FND_MSG_PUB.Add_Exc_Msg('PRP_RTTAP_INT_PVT','EXPLODE_TEAMS',SQLERRM);
456: -- Log Debug Messages.
457: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
458: P_MODULE_NAME => 'Insert_Terr_Accesses',
459: p_LOG_MESSAGE => 'Error While Exploding Teams.. ' ||' x_errbuf: ' || x_errbuf);
460: END EXPLODE_TEAMS;
461: /************************** End Explode Teams ******************/

Line 567: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

563: x_retcode := SQLCODE;
564: x_return_status := FND_API.G_RET_STS_ERROR;
565: FND_MSG_PUB.Add_Exc_Msg('PRP_RTTAP_INT_PVT','EXPLODE_GROUPS',SQLERRM);
566: -- Log Debug Messages.
567: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
568: P_MODULE_NAME => 'Insert_Terr_Accesses',
569: p_LOG_MESSAGE => 'Error While Exploding Groups.. ' ||' x_errbuf: ' || x_errbuf);
570: END EXPLODE_GROUPS;
571:

Line 629: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

625: x_retcode := SQLCODE;
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: FND_MSG_PUB.Add_Exc_Msg('PRP_RTTAP_INT_PVT','INSERT_ACCESS',SQLERRM);
628: -- Log Debug Messages.
629: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
630: P_MODULE_NAME => 'Insert_Terr_Accesses',
631: p_LOG_MESSAGE => 'Error While Inserting into PRP_Accesses... ' ||' x_errbuf: ' || x_errbuf);
632: END INSERT_ACCESSES;
633: /************************** End Insert Accessses ***************/

Line 699: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

695: x_return_status := FND_API.G_RET_STS_ERROR;
696:
697: FND_MSG_PUB.Add_Exc_Msg('PRP_RTTAP_INT_PVT','INSERT_TERR_ACCESSES',SQLERRM);
698: -- Log Debug Messages.
699: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
700: P_MODULE_NAME => 'Insert_Terr_Accesses',
701: p_LOG_MESSAGE => 'Error While Inserting into PRP_Terroritory_Accesses... ' ||' x_errbuf: ' || x_errbuf);
702: END INSERT_TERR_ACCESSES;
703: /************************** End Insert Territory Accessses ***************/

Line 733: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

729: x_retcode := SQLCODE;
730: x_return_status := FND_API.G_RET_STS_ERROR;
731: FND_MSG_PUB.Add_Exc_Msg('PRP_RTTAP_INT_PVT','PERFORM_CLEANUP',SQLERRM);
732: -- Log Debug Messages.
733: LOG_MESSAGES(P_LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
734: P_MODULE_NAME => 'Insert_Terr_Accesses',
735: p_LOG_MESSAGE => 'Error in Perform_Cleanup... ' ||' x_errbuf: ' || x_errbuf);
736: END PERFORM_CLEANUP;
737: /************************** End Perform Cleanup ***************/