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.PV_BATCH_ASSIGN_PUB dependencies on FND_MSG_PUB

Line 154: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

150: l_failure_code VARCHAR2(1000);
151: l_lead_id NUMBER;
152:
153: BEGIN
154: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
155: p_msg_name => 'PV_CREATE_BATCH_START_TIME',
156: p_token1 => 'P_DATE_TIME',
157: p_token1_value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
158:

Line 168: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

164: l_lead_desc_tbl := JTF_VARCHAR2_TABLE_400();
165:
166:
167: IF (p_country is not null) THEN
168: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
169: p_msg_name => 'PV_BATCH_COUNTRY',
170: p_token1 => 'P_COUNTRY',
171: p_token1_value => p_country);
172:

Line 179: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

175: END IF;
176:
177:
178: IF p_username is not null THEN
179: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
180: p_msg_name => 'PV_CREATE_BATCH_USER',
181: p_token1 => 'P_USER_NAME',
182: p_token1_value => p_username);
183:

Line 250: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

246: l_lead_id_tbl.trim;
247: l_lead_desc_tbl.trim;
248:
249:
250: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
251: p_msg_name => 'PV_OPPORTUNITY_COUNT',
252: p_token1 => 'P_OPP_COUNT',
253: p_token1_value => l_lead_id_tbl.count);
254:

Line 262: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

258: -- -----------------------------------------------------------------------------
259: IF (l_lead_id_tbl.count > 0) THEN
260: FOR j in 1..l_lead_id_tbl.count LOOP
261: BEGIN
262: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
263: p_msg_name => 'PV_OPPORTUNITY_NAME',
264: p_token1 => 'TEXT',
265: p_token1_value => 'Opportunity ID :' || l_lead_id_tbl(j) ||
266: ' Opportunity Name: '||l_lead_desc_tbl(j));

Line 300: l_message := fnd_msg_pub.get(

296: IF (l_return_status <> fnd_api.G_RET_STS_SUCCESS) THEN
297:
298: IF l_msg_count > 0 THEN
299:
300: l_message := fnd_msg_pub.get(
301: p_msg_index => fnd_msg_pub.g_first, p_encoded => FND_API.g_false
302: );
303:
304: WHILE (l_message IS NOT NULL) LOOP

Line 301: p_msg_index => fnd_msg_pub.g_first, p_encoded => FND_API.g_false

297:
298: IF l_msg_count > 0 THEN
299:
300: l_message := fnd_msg_pub.get(
301: p_msg_index => fnd_msg_pub.g_first, p_encoded => FND_API.g_false
302: );
303:
304: WHILE (l_message IS NOT NULL) LOOP
305: fnd_file.put_line(FND_FILE.LOG,substr(l_message,1,200));

Line 306: l_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);

302: );
303:
304: WHILE (l_message IS NOT NULL) LOOP
305: fnd_file.put_line(FND_FILE.LOG,substr(l_message,1,200));
306: l_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
307: END LOOP;
308:
309: END IF;
310:

Line 330: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

326: EXCEPTION
327: WHEN FND_API.G_EXC_ERROR THEN
328: ROLLBACK TO vendor_opp;
329:
330: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
331: p_msg_name => 'PV_NO_OPP_ASSIGN',
332: p_token1 => 'P_OPP_NAME',
333: p_token1_value => l_lead_desc_tbl(j));
334:

Line 346: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

342:
343: WHEN l_no_partner_exec THEN
344: ROLLBACK TO vendor_opp;
345:
346: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
347: p_msg_name => 'PV_NO_PRTNR_FOR_OPPTY',
348: p_token1 => 'P_OPP_NAME',
349: p_token1_value => l_lead_desc_tbl(j));
350:

Line 357: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

353: WHEN OTHERS THEN
354: ROLLBACK TO vendor_opp;
355: l_opp_count := l_opp_count + 1;
356:
357: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
358: p_msg_name => 'PV_UNKNOWN_ERROR',
359: p_token1 => 'TEXT',
360: p_token1_value => 'Database Error'||sqlcode||' '||sqlerrm);
361:

Line 377: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

373: -- Every unassigned opportunity found have failed to be routed for one reason or
374: -- another. The user needs to check the log for the failure reason.
375: -- --------------------------------------------------------------------------------
376: IF (l_opp_count = l_lead_id_tbl.count) THEN
377: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
378: p_msg_name => 'PV_ALL_OPPTY_FAILED');
379:
380: RETCODE := 1;
381: ERRBUF := fnd_message.get;

Line 392: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

388: RETCODE := 1;
389: ERRBUF := fnd_message.get;
390:
391: ELSIF (l_opp_count = 0) THEN
392: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
393: p_msg_name => 'PV_ALL_OPPTY_SUCCESS');
394:
395: RETCODE := 0;
396: ERRBUF := fnd_message.get;

Line 399: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

395: RETCODE := 0;
396: ERRBUF := fnd_message.get;
397:
398: ELSIF (l_opp_count IS null) THEN
399: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
400: p_msg_name => 'PV_NO_OPPTY_FOUND');
401:
402:
403: RETCODE := 0;

Line 407: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

403: RETCODE := 0;
404: ERRBUF := fnd_message.get;
405: END IF;
406:
407: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
408: p_msg_name => 'PV_CREATE_BATCH_END_TIME',
409: p_token1 => 'P_DATE_TIME',
410: p_token1_value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
411:

Line 415: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

411:
412: EXCEPTION
413:
414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
415: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
416: p_msg_name => 'PV_NO_RESOURCE_FOUND');
417:
418: RETCODE := 2;
419: ERRBUF := fnd_message.get;

Line 422: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

418: RETCODE := 2;
419: ERRBUF := fnd_message.get;
420:
421: WHEN l_user_not_emp_exec THEN
422: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
423: p_msg_name => 'PV_USER_NOT_A_EMPLOYEE');
424:
425: RETCODE := 2;
426: ERRBUF := fnd_message.get;

Line 429: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

425: RETCODE := 2;
426: ERRBUF := fnd_message.get;
427:
428: WHEN l_no_user_exec THEN
429: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
430: p_msg_name => 'PV_NO_BATCH_USER',
431: p_token1 => 'TEXT',
432: p_token1_value => 'No Assignment Manager specified, Cannot run the ' ||
433: 'Assignment process');

Line 445: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

441: RETCODE := 2;
442: ERRBUF := fnd_message.get;
443:
444: WHEN OTHERS THEN
445: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
446: p_msg_name => 'PV_UNKNOWN_ERROR',
447: p_token1 => 'TEXT',
448: p_token1_value => 'Database Error:'||sqlcode||' '||sqlerrm);
449:

Line 480: FND_MSG_PUB.Add;

476: FND_MESSAGE.Set_Name('PV', p_msg_type);
477: FND_MESSAGE.Set_Token('TEXT', p_msg_string);
478:
479: IF (g_log_to_file = 'N') THEN
480: FND_MSG_PUB.Add;
481:
482: ELSIF (g_log_to_file = 'Y') THEN
483: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
484: END IF;

Line 517: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level) THEN

513: p_token3_value IN VARCHAR2 := NULL
514: )
515: IS
516: BEGIN
517: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level) THEN
518: FND_MESSAGE.Set_Name('PV', p_msg_name);
519: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
520:
521: IF (p_token1 IS NOT NULL) THEN

Line 534: FND_MSG_PUB.Add;

530: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
531: END IF;
532:
533: IF (g_log_to_file = 'N') THEN
534: FND_MSG_PUB.Add;
535:
536: ELSIF (g_log_to_file = 'Y') THEN
537: FND_FILE.PUT_LINE( FND_FILE.LOG, fnd_message.get );
538: END IF;