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_MIG_ADJ_PARA_APPROVAL_PVT dependencies on FND_MESSAGE

Line 88: x_msg_data := fnd_message.get_string('DPP','DPP_MIG_COMPLETED_ERR');

84: END IF;
85: EXCEPTION
86: WHEN FND_API.G_EXC_ERROR THEN
87: x_return_status := FND_API.G_RET_STS_ERROR;
88: x_msg_data := fnd_message.get_string('DPP','DPP_MIG_COMPLETED_ERR');
89:
90: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92: -- Standard call to get message count and if count=1, get the message

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

102: END IF;
103:
104: WHEN OTHERS THEN
105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
106: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
107: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.checkMigrationCompletion');
108: fnd_message.set_token('ERRNO', sqlcode);
109: fnd_message.set_token('REASON', sqlerrm);
110: FND_MSG_PUB.add;

Line 107: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.checkMigrationCompletion');

103:
104: WHEN OTHERS THEN
105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
106: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
107: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.checkMigrationCompletion');
108: fnd_message.set_token('ERRNO', sqlcode);
109: fnd_message.set_token('REASON', sqlerrm);
110: FND_MSG_PUB.add;
111:

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

104: WHEN OTHERS THEN
105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
106: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
107: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.checkMigrationCompletion');
108: fnd_message.set_token('ERRNO', sqlcode);
109: fnd_message.set_token('REASON', sqlerrm);
110: FND_MSG_PUB.add;
111:
112: -- Standard call to get message count and if count=1, get the message

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

105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
106: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
107: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.checkMigrationCompletion');
108: fnd_message.set_token('ERRNO', sqlcode);
109: fnd_message.set_token('REASON', sqlerrm);
110: FND_MSG_PUB.add;
111:
112: -- Standard call to get message count and if count=1, get the message
113: FND_MSG_PUB.Count_And_Get (

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

260: END IF;
261:
262: WHEN OTHERS THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
265: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.validate_suppTradeProfile');
266: fnd_message.set_token('ERRNO', sqlcode);
267: fnd_message.set_token('REASON', sqlerrm);
268: FND_MSG_PUB.add;

Line 265: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.validate_suppTradeProfile');

261:
262: WHEN OTHERS THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
265: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.validate_suppTradeProfile');
266: fnd_message.set_token('ERRNO', sqlcode);
267: fnd_message.set_token('REASON', sqlerrm);
268: FND_MSG_PUB.add;
269:

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

262: WHEN OTHERS THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
265: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.validate_suppTradeProfile');
266: fnd_message.set_token('ERRNO', sqlcode);
267: fnd_message.set_token('REASON', sqlerrm);
268: FND_MSG_PUB.add;
269:
270: -- Standard call to get message count and if count=1, get the message

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

263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
265: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.validate_suppTradeProfile');
266: fnd_message.set_token('ERRNO', sqlcode);
267: fnd_message.set_token('REASON', sqlerrm);
268: FND_MSG_PUB.add;
269:
270: -- Standard call to get message count and if count=1, get the message
271: FND_MSG_PUB.Count_And_Get (

Line 395: x_msg_data := fnd_message.get_string('DPP','DPP_PROCESS_SETUP_MISSING_ERR');

391: END IF;
392: EXCEPTION
393: WHEN FND_API.G_EXC_ERROR THEN
394: x_return_status := FND_API.G_RET_STS_ERROR;
395: x_msg_data := fnd_message.get_string('DPP','DPP_PROCESS_SETUP_MISSING_ERR');
396:
397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: -- Standard call to get message count and if count=1, get the message

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

409: END IF;
410:
411: WHEN OTHERS THEN
412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
413: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
414: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.validate_execProcessSetup');
415: fnd_message.set_token('ERRNO', sqlcode);
416: fnd_message.set_token('REASON', sqlerrm);
417: FND_MSG_PUB.add;

Line 414: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.validate_execProcessSetup');

410:
411: WHEN OTHERS THEN
412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
413: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
414: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.validate_execProcessSetup');
415: fnd_message.set_token('ERRNO', sqlcode);
416: fnd_message.set_token('REASON', sqlerrm);
417: FND_MSG_PUB.add;
418:

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

411: WHEN OTHERS THEN
412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
413: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
414: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.validate_execProcessSetup');
415: fnd_message.set_token('ERRNO', sqlcode);
416: fnd_message.set_token('REASON', sqlerrm);
417: FND_MSG_PUB.add;
418:
419: -- Standard call to get message count and if count=1, get the message

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

412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
413: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
414: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.validate_execProcessSetup');
415: fnd_message.set_token('ERRNO', sqlcode);
416: fnd_message.set_token('REASON', sqlerrm);
417: FND_MSG_PUB.add;
418:
419: -- Standard call to get message count and if count=1, get the message
420: FND_MSG_PUB.Count_And_Get (

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

640: END IF;
641:
642: WHEN OTHERS THEN
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
645: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.insertExecutionProcesses');
646: fnd_message.set_token('ERRNO', sqlcode);
647: fnd_message.set_token('REASON', sqlerrm);
648: FND_MSG_PUB.add;

Line 645: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.insertExecutionProcesses');

641:
642: WHEN OTHERS THEN
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
645: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.insertExecutionProcesses');
646: fnd_message.set_token('ERRNO', sqlcode);
647: fnd_message.set_token('REASON', sqlerrm);
648: FND_MSG_PUB.add;
649:

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

642: WHEN OTHERS THEN
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
645: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.insertExecutionProcesses');
646: fnd_message.set_token('ERRNO', sqlcode);
647: fnd_message.set_token('REASON', sqlerrm);
648: FND_MSG_PUB.add;
649:
650: -- Standard call to get message count and if count=1, get the message

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

643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
645: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.insertExecutionProcesses');
646: fnd_message.set_token('ERRNO', sqlcode);
647: fnd_message.set_token('REASON', sqlerrm);
648: FND_MSG_PUB.add;
649:
650: -- Standard call to get message count and if count=1, get the message
651: FND_MSG_PUB.Count_And_Get (

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

742: END IF;
743:
744: EXCEPTION
745: WHEN OTHERS THEN
746: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
747: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');
748: fnd_message.set_token('ERRNO', sqlcode);
749: fnd_message.set_token('REASON', sqlerrm);
750: fnd_msg_pub.add;

Line 747: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');

743:
744: EXCEPTION
745: WHEN OTHERS THEN
746: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
747: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');
748: fnd_message.set_token('ERRNO', sqlcode);
749: fnd_message.set_token('REASON', sqlerrm);
750: fnd_msg_pub.add;
751: RAISE fnd_api.g_exc_unexpected_error;

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

744: EXCEPTION
745: WHEN OTHERS THEN
746: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
747: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');
748: fnd_message.set_token('ERRNO', sqlcode);
749: fnd_message.set_token('REASON', sqlerrm);
750: fnd_msg_pub.add;
751: RAISE fnd_api.g_exc_unexpected_error;
752: END;

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

745: WHEN OTHERS THEN
746: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
747: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');
748: fnd_message.set_token('ERRNO', sqlcode);
749: fnd_message.set_token('REASON', sqlerrm);
750: fnd_msg_pub.add;
751: RAISE fnd_api.g_exc_unexpected_error;
752: END;
753:

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

764: END IF;
765:
766: EXCEPTION
767: WHEN OTHERS THEN
768: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
769: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');
770: fnd_message.set_token('ERRNO', sqlcode);
771: fnd_message.set_token('REASON', sqlerrm);
772: FND_MSG_PUB.add;

Line 769: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');

765:
766: EXCEPTION
767: WHEN OTHERS THEN
768: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
769: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');
770: fnd_message.set_token('ERRNO', sqlcode);
771: fnd_message.set_token('REASON', sqlerrm);
772: FND_MSG_PUB.add;
773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

766: EXCEPTION
767: WHEN OTHERS THEN
768: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
769: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');
770: fnd_message.set_token('ERRNO', sqlcode);
771: fnd_message.set_token('REASON', sqlerrm);
772: FND_MSG_PUB.add;
773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
774: END;

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

767: WHEN OTHERS THEN
768: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
769: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');
770: fnd_message.set_token('ERRNO', sqlcode);
771: fnd_message.set_token('REASON', sqlerrm);
772: FND_MSG_PUB.add;
773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
774: END;
775: END LOOP;

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

804: END IF;
805:
806: WHEN OTHERS THEN
807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
808: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
809: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');
810: fnd_message.set_token('ERRNO', sqlcode);
811: fnd_message.set_token('REASON', sqlerrm);
812: FND_MSG_PUB.add;

Line 809: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');

805:
806: WHEN OTHERS THEN
807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
808: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
809: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');
810: fnd_message.set_token('ERRNO', sqlcode);
811: fnd_message.set_token('REASON', sqlerrm);
812: FND_MSG_PUB.add;
813:

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

806: WHEN OTHERS THEN
807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
808: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
809: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');
810: fnd_message.set_token('ERRNO', sqlcode);
811: fnd_message.set_token('REASON', sqlerrm);
812: FND_MSG_PUB.add;
813:
814: -- Standard call to get message count and if count=1, get the message

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

807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
808: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
809: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.clearAllApprovals');
810: fnd_message.set_token('ERRNO', sqlcode);
811: fnd_message.set_token('REASON', sqlerrm);
812: FND_MSG_PUB.add;
813:
814: -- Standard call to get message count and if count=1, get the message
815: FND_MSG_PUB.Count_And_Get (

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

1001: END IF;
1002:
1003: WHEN OTHERS THEN
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1006: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.update_status');
1007: fnd_message.set_token('ERRNO', sqlcode);
1008: fnd_message.set_token('REASON', sqlerrm);
1009: FND_MSG_PUB.add;

Line 1006: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.update_status');

1002:
1003: WHEN OTHERS THEN
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1006: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.update_status');
1007: fnd_message.set_token('ERRNO', sqlcode);
1008: fnd_message.set_token('REASON', sqlerrm);
1009: FND_MSG_PUB.add;
1010:

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

1003: WHEN OTHERS THEN
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1006: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.update_status');
1007: fnd_message.set_token('ERRNO', sqlcode);
1008: fnd_message.set_token('REASON', sqlerrm);
1009: FND_MSG_PUB.add;
1010:
1011: -- Standard call to get message count and if count=1, get the message

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

1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1006: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.update_status');
1007: fnd_message.set_token('ERRNO', sqlcode);
1008: fnd_message.set_token('REASON', sqlerrm);
1009: FND_MSG_PUB.add;
1010:
1011: -- Standard call to get message count and if count=1, get the message
1012: FND_MSG_PUB.Count_And_Get (

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

1257: WHEN OTHERS THEN
1258: ROLLBACK TO update_transaction_status;
1259: errbuf :='Error';
1260: retcode := 2;
1261: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1262: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.update_transaction_status');
1263: fnd_message.set_token('ERRNO', sqlcode);
1264: fnd_message.set_token('REASON', sqlerrm);
1265: FND_MSG_PUB.add;

Line 1262: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.update_transaction_status');

1258: ROLLBACK TO update_transaction_status;
1259: errbuf :='Error';
1260: retcode := 2;
1261: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1262: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.update_transaction_status');
1263: fnd_message.set_token('ERRNO', sqlcode);
1264: fnd_message.set_token('REASON', sqlerrm);
1265: FND_MSG_PUB.add;
1266:

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

1259: errbuf :='Error';
1260: retcode := 2;
1261: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1262: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.update_transaction_status');
1263: fnd_message.set_token('ERRNO', sqlcode);
1264: fnd_message.set_token('REASON', sqlerrm);
1265: FND_MSG_PUB.add;
1266:
1267: -- Standard call to get message count and if count=1, get the message

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

1260: retcode := 2;
1261: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1262: fnd_message.set_token('ROUTINE', 'DPP_MIG_ADJ_PARA_APPROVAL_PVT.update_transaction_status');
1263: fnd_message.set_token('ERRNO', sqlcode);
1264: fnd_message.set_token('REASON', sqlerrm);
1265: FND_MSG_PUB.add;
1266:
1267: -- Standard call to get message count and if count=1, get the message
1268: FND_MSG_PUB.Count_And_Get (