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.DPP_EXECUTIONPROCESS_PVT dependencies on FND_MESSAGE

Line 305: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

301: WHEN OTHERS THEN
302: ROLLBACK TO INITIATE_EXEC;
303: retcode := 2;
304: errbuf := 'Error';
305: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
306: fnd_message.set_token('ROUTINE', l_full_name);
307: fnd_message.set_token('ERRNO', sqlcode);
308: fnd_message.set_token('REASON', sqlerrm);
309: FND_MSG_PUB.add;

Line 306: fnd_message.set_token('ROUTINE', l_full_name);

302: ROLLBACK TO INITIATE_EXEC;
303: retcode := 2;
304: errbuf := 'Error';
305: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
306: fnd_message.set_token('ROUTINE', l_full_name);
307: fnd_message.set_token('ERRNO', sqlcode);
308: fnd_message.set_token('REASON', sqlerrm);
309: FND_MSG_PUB.add;
310:

Line 307: fnd_message.set_token('ERRNO', sqlcode);

303: retcode := 2;
304: errbuf := 'Error';
305: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
306: fnd_message.set_token('ROUTINE', l_full_name);
307: fnd_message.set_token('ERRNO', sqlcode);
308: fnd_message.set_token('REASON', sqlerrm);
309: FND_MSG_PUB.add;
310:
311: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE, p_count => l_msg_count, p_data => l_msg_data );

Line 308: fnd_message.set_token('REASON', sqlerrm);

304: errbuf := 'Error';
305: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
306: fnd_message.set_token('ROUTINE', l_full_name);
307: fnd_message.set_token('ERRNO', sqlcode);
308: fnd_message.set_token('REASON', sqlerrm);
309: FND_MSG_PUB.add;
310:
311: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE, p_count => l_msg_count, p_data => l_msg_data );
312: IF l_msg_count > 1 THEN

Line 511: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

507: FND_FILE.NEW_LINE(FND_FILE.LOG);
508:
509: WHEN OTHERS THEN
510: ROLLBACK TO EXECUTE_NOTIF;
511: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
512: fnd_message.set_token('ROUTINE', l_full_name);
513: fnd_message.set_token('ERRNO', sqlcode);
514: fnd_message.set_token('REASON', sqlerrm);
515: FND_MSG_PUB.add;

Line 512: fnd_message.set_token('ROUTINE', l_full_name);

508:
509: WHEN OTHERS THEN
510: ROLLBACK TO EXECUTE_NOTIF;
511: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
512: fnd_message.set_token('ROUTINE', l_full_name);
513: fnd_message.set_token('ERRNO', sqlcode);
514: fnd_message.set_token('REASON', sqlerrm);
515: FND_MSG_PUB.add;
516:

Line 513: fnd_message.set_token('ERRNO', sqlcode);

509: WHEN OTHERS THEN
510: ROLLBACK TO EXECUTE_NOTIF;
511: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
512: fnd_message.set_token('ROUTINE', l_full_name);
513: fnd_message.set_token('ERRNO', sqlcode);
514: fnd_message.set_token('REASON', sqlerrm);
515: FND_MSG_PUB.add;
516:
517: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data );

Line 514: fnd_message.set_token('REASON', sqlerrm);

510: ROLLBACK TO EXECUTE_NOTIF;
511: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
512: fnd_message.set_token('ROUTINE', l_full_name);
513: fnd_message.set_token('ERRNO', sqlcode);
514: fnd_message.set_token('REASON', sqlerrm);
515: FND_MSG_PUB.add;
516:
517: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data );
518: IF x_msg_count > 1 THEN

Line 640: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');

636: FND_FILE.NEW_LINE(FND_FILE.LOG);
637:
638: WHEN OTHERS THEN
639: ROLLBACK TO EXEC_PROCESS;
640: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
641: FND_MESSAGE.SET_TOKEN('ROUTINE', L_FULL_NAME);
642: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);
643: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);
644: FND_MSG_PUB.ADD;

Line 641: FND_MESSAGE.SET_TOKEN('ROUTINE', L_FULL_NAME);

637:
638: WHEN OTHERS THEN
639: ROLLBACK TO EXEC_PROCESS;
640: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
641: FND_MESSAGE.SET_TOKEN('ROUTINE', L_FULL_NAME);
642: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);
643: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);
644: FND_MSG_PUB.ADD;
645: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data );

Line 642: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);

638: WHEN OTHERS THEN
639: ROLLBACK TO EXEC_PROCESS;
640: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
641: FND_MESSAGE.SET_TOKEN('ROUTINE', L_FULL_NAME);
642: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);
643: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);
644: FND_MSG_PUB.ADD;
645: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data );
646: IF x_msg_count > 1 THEN

Line 643: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);

639: ROLLBACK TO EXEC_PROCESS;
640: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
641: FND_MESSAGE.SET_TOKEN('ROUTINE', L_FULL_NAME);
642: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);
643: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);
644: FND_MSG_PUB.ADD;
645: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data );
646: IF x_msg_count > 1 THEN
647: FOR I IN 1..x_msg_count LOOP

Line 687: fnd_message.set_name( 'DPP','DPP_SUPP_TRDPRFLS_MISSING_ERR');

683:
684: EXCEPTION
685: WHEN NO_DATA_FOUND THEN
686: L_RET_ID := null;
687: fnd_message.set_name( 'DPP','DPP_SUPP_TRDPRFLS_MISSING_ERR');
688: fnd_msg_pub.add;
689: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_EXCEPTION, 'dpp.plsql.' || L_FULL_NAME, 'Supplier trade profile setup not available');
690: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Supplier trade profile setup not available');
691: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 780: fnd_message.set_name( 'DPP','DPP_PROCESS_SETUP_MISSING_ERR');

776: || P_VENDOR_ID || ' at site id ' || P_VENDOR_SITE_ID || ', org id ' || P_ORG_ID);
777: --Check if setup is available at system parameter level
778: IF NOT IS_PROCESS_SETUP(NULL, P_ORG_ID) THEN
779: --Process Setup does not exist
780: fnd_message.set_name( 'DPP','DPP_PROCESS_SETUP_MISSING_ERR');
781: fnd_msg_pub.add;
782: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No price protection setup available for vendor id : '
783: || P_VENDOR_ID || ' at site id ' || P_VENDOR_SITE_ID || ', org id ' || P_ORG_ID);
784: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 948: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

944: WHEN OTHERS THEN
945: ROLLBACK TO INITIATE_NOTIF;
946: retcode := 2;
947: errbuf := 'Error';
948: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
949: fnd_message.set_token('ROUTINE', l_full_name);
950: fnd_message.set_token('ERRNO', sqlcode);
951: fnd_message.set_token('REASON', sqlerrm);
952: FND_MSG_PUB.add;

Line 949: fnd_message.set_token('ROUTINE', l_full_name);

945: ROLLBACK TO INITIATE_NOTIF;
946: retcode := 2;
947: errbuf := 'Error';
948: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
949: fnd_message.set_token('ROUTINE', l_full_name);
950: fnd_message.set_token('ERRNO', sqlcode);
951: fnd_message.set_token('REASON', sqlerrm);
952: FND_MSG_PUB.add;
953:

Line 950: fnd_message.set_token('ERRNO', sqlcode);

946: retcode := 2;
947: errbuf := 'Error';
948: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
949: fnd_message.set_token('ROUTINE', l_full_name);
950: fnd_message.set_token('ERRNO', sqlcode);
951: fnd_message.set_token('REASON', sqlerrm);
952: FND_MSG_PUB.add;
953:
954: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE, p_count => l_msg_count, p_data => l_msg_data );

Line 951: fnd_message.set_token('REASON', sqlerrm);

947: errbuf := 'Error';
948: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
949: fnd_message.set_token('ROUTINE', l_full_name);
950: fnd_message.set_token('ERRNO', sqlcode);
951: fnd_message.set_token('REASON', sqlerrm);
952: FND_MSG_PUB.add;
953:
954: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE, p_count => l_msg_count, p_data => l_msg_data );
955: IF l_msg_count > 1 THEN

Line 1364: l_msg_data := fnd_message.get_string('DPP','DPP_AME_NO_APP');

1360: END IF;
1361:
1362: EXCEPTION
1363: WHEN FND_API.G_EXC_ERROR THEN
1364: l_msg_data := fnd_message.get_string('DPP','DPP_AME_NO_APP');
1365: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction Number : ' || l_transaction_number || ' Ref. Document Number : ' || l_ref_document_number);
1366: FND_FILE.NEW_LINE(FND_FILE.LOG);
1367: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message : ' || l_msg_data);
1368: FND_FILE.NEW_LINE(FND_FILE.LOG);

Line 1375: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1371: FND_FILE.NEW_LINE(FND_FILE.LOG);
1372: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message : ' || l_msg_data);
1373: FND_FILE.NEW_LINE(FND_FILE.LOG);
1374: WHEN OTHERS THEN
1375: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1376: fnd_message.set_token('ROUTINE', l_full_name);
1377: fnd_message.set_token('ERRNO', sqlcode);
1378: fnd_message.set_token('REASON', sqlerrm);
1379: FND_MSG_PUB.add;

Line 1376: fnd_message.set_token('ROUTINE', l_full_name);

1372: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Message : ' || l_msg_data);
1373: FND_FILE.NEW_LINE(FND_FILE.LOG);
1374: WHEN OTHERS THEN
1375: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1376: fnd_message.set_token('ROUTINE', l_full_name);
1377: fnd_message.set_token('ERRNO', sqlcode);
1378: fnd_message.set_token('REASON', sqlerrm);
1379: FND_MSG_PUB.add;
1380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1377: fnd_message.set_token('ERRNO', sqlcode);

1373: FND_FILE.NEW_LINE(FND_FILE.LOG);
1374: WHEN OTHERS THEN
1375: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1376: fnd_message.set_token('ROUTINE', l_full_name);
1377: fnd_message.set_token('ERRNO', sqlcode);
1378: fnd_message.set_token('REASON', sqlerrm);
1379: FND_MSG_PUB.add;
1380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1381: END;

Line 1378: fnd_message.set_token('REASON', sqlerrm);

1374: WHEN OTHERS THEN
1375: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1376: fnd_message.set_token('ROUTINE', l_full_name);
1377: fnd_message.set_token('ERRNO', sqlcode);
1378: fnd_message.set_token('REASON', sqlerrm);
1379: FND_MSG_PUB.add;
1380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1381: END;
1382:

Line 1418: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1414: END IF;
1415:
1416: EXCEPTION
1417: WHEN OTHERS THEN
1418: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1419: fnd_message.set_token('ROUTINE', l_full_name);
1420: fnd_message.set_token('ERRNO', sqlcode);
1421: fnd_message.set_token('REASON', sqlerrm);
1422: FND_MSG_PUB.add;

Line 1419: fnd_message.set_token('ROUTINE', l_full_name);

1415:
1416: EXCEPTION
1417: WHEN OTHERS THEN
1418: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1419: fnd_message.set_token('ROUTINE', l_full_name);
1420: fnd_message.set_token('ERRNO', sqlcode);
1421: fnd_message.set_token('REASON', sqlerrm);
1422: FND_MSG_PUB.add;
1423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1420: fnd_message.set_token('ERRNO', sqlcode);

1416: EXCEPTION
1417: WHEN OTHERS THEN
1418: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1419: fnd_message.set_token('ROUTINE', l_full_name);
1420: fnd_message.set_token('ERRNO', sqlcode);
1421: fnd_message.set_token('REASON', sqlerrm);
1422: FND_MSG_PUB.add;
1423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1424: END;

Line 1421: fnd_message.set_token('REASON', sqlerrm);

1417: WHEN OTHERS THEN
1418: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1419: fnd_message.set_token('ROUTINE', l_full_name);
1420: fnd_message.set_token('ERRNO', sqlcode);
1421: fnd_message.set_token('REASON', sqlerrm);
1422: FND_MSG_PUB.add;
1423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1424: END;
1425:

Line 1446: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1442: program_update_date = sysdate
1443: WHERE transaction_header_id = l_transaction_header_id;
1444: EXCEPTION
1445: WHEN OTHERS THEN
1446: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1447: fnd_message.set_token('ROUTINE', l_full_name);
1448: fnd_message.set_token('ERRNO', sqlcode);
1449: fnd_message.set_token('REASON', sqlerrm);
1450: FND_MSG_PUB.add;

Line 1447: fnd_message.set_token('ROUTINE', l_full_name);

1443: WHERE transaction_header_id = l_transaction_header_id;
1444: EXCEPTION
1445: WHEN OTHERS THEN
1446: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1447: fnd_message.set_token('ROUTINE', l_full_name);
1448: fnd_message.set_token('ERRNO', sqlcode);
1449: fnd_message.set_token('REASON', sqlerrm);
1450: FND_MSG_PUB.add;
1451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1448: fnd_message.set_token('ERRNO', sqlcode);

1444: EXCEPTION
1445: WHEN OTHERS THEN
1446: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1447: fnd_message.set_token('ROUTINE', l_full_name);
1448: fnd_message.set_token('ERRNO', sqlcode);
1449: fnd_message.set_token('REASON', sqlerrm);
1450: FND_MSG_PUB.add;
1451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1452: END;

Line 1449: fnd_message.set_token('REASON', sqlerrm);

1445: WHEN OTHERS THEN
1446: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1447: fnd_message.set_token('ROUTINE', l_full_name);
1448: fnd_message.set_token('ERRNO', sqlcode);
1449: fnd_message.set_token('REASON', sqlerrm);
1450: FND_MSG_PUB.add;
1451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1452: END;
1453:

Line 1558: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1554: WHEN OTHERS THEN
1555: ROLLBACK TO Change_Status;
1556: retcode := 2;
1557: errbuf := 'Error';
1558: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1559: fnd_message.set_token('ROUTINE', l_full_name);
1560: fnd_message.set_token('ERRNO', sqlcode);
1561: fnd_message.set_token('REASON', sqlerrm);
1562: FND_MSG_PUB.add;

Line 1559: fnd_message.set_token('ROUTINE', l_full_name);

1555: ROLLBACK TO Change_Status;
1556: retcode := 2;
1557: errbuf := 'Error';
1558: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1559: fnd_message.set_token('ROUTINE', l_full_name);
1560: fnd_message.set_token('ERRNO', sqlcode);
1561: fnd_message.set_token('REASON', sqlerrm);
1562: FND_MSG_PUB.add;
1563:

Line 1560: fnd_message.set_token('ERRNO', sqlcode);

1556: retcode := 2;
1557: errbuf := 'Error';
1558: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1559: fnd_message.set_token('ROUTINE', l_full_name);
1560: fnd_message.set_token('ERRNO', sqlcode);
1561: fnd_message.set_token('REASON', sqlerrm);
1562: FND_MSG_PUB.add;
1563:
1564: -- Standard call to get message count and if count=1, get the message

Line 1561: fnd_message.set_token('REASON', sqlerrm);

1557: errbuf := 'Error';
1558: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1559: fnd_message.set_token('ROUTINE', l_full_name);
1560: fnd_message.set_token('ERRNO', sqlcode);
1561: fnd_message.set_token('REASON', sqlerrm);
1562: FND_MSG_PUB.add;
1563:
1564: -- Standard call to get message count and if count=1, get the message
1565: FND_MSG_PUB.Count_And_Get (

Line 2043: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

2039: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2040: WHEN OTHERS THEN
2041: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2042: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2043: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2044: fnd_message.set_token('ROUTINE', l_full_name);
2045: fnd_message.set_token('ERRNO', SQLCODE);
2046: fnd_message.set_token('REASON', sqlerrm);
2047: END IF;

Line 2044: fnd_message.set_token('ROUTINE', l_full_name);

2040: WHEN OTHERS THEN
2041: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2042: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2043: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2044: fnd_message.set_token('ROUTINE', l_full_name);
2045: fnd_message.set_token('ERRNO', SQLCODE);
2046: fnd_message.set_token('REASON', sqlerrm);
2047: END IF;
2048: x_msg_data := fnd_message.get();

Line 2045: fnd_message.set_token('ERRNO', SQLCODE);

2041: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
2042: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2043: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2044: fnd_message.set_token('ROUTINE', l_full_name);
2045: fnd_message.set_token('ERRNO', SQLCODE);
2046: fnd_message.set_token('REASON', sqlerrm);
2047: END IF;
2048: x_msg_data := fnd_message.get();
2049: FND_FILE.PUT_LINE(FND_FILE.LOG,' ' || x_msg_data);

Line 2046: fnd_message.set_token('REASON', sqlerrm);

2042: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2043: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2044: fnd_message.set_token('ROUTINE', l_full_name);
2045: fnd_message.set_token('ERRNO', SQLCODE);
2046: fnd_message.set_token('REASON', sqlerrm);
2047: END IF;
2048: x_msg_data := fnd_message.get();
2049: FND_FILE.PUT_LINE(FND_FILE.LOG,' ' || x_msg_data);
2050: END Update_HeaderLog;

Line 2048: x_msg_data := fnd_message.get();

2044: fnd_message.set_token('ROUTINE', l_full_name);
2045: fnd_message.set_token('ERRNO', SQLCODE);
2046: fnd_message.set_token('REASON', sqlerrm);
2047: END IF;
2048: x_msg_data := fnd_message.get();
2049: FND_FILE.PUT_LINE(FND_FILE.LOG,' ' || x_msg_data);
2050: END Update_HeaderLog;
2051:
2052: END DPP_EXECUTIONPROCESS_PVT;