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_PARTNER_PROGRAM_PVT dependencies on DBMS_UTILITY

Line 3888: Write_log (1, TO_CHAR(DBMS_UTILITY.get_time)||': '||l_msg);

3884: FND_MSG_PUB.reset;
3885: LOOP
3886: l_msg := fnd_msg_pub.get(p_encoded => FND_API.G_FALSE);
3887: EXIT WHEN l_msg IS NULL;
3888: Write_log (1, TO_CHAR(DBMS_UTILITY.get_time)||': '||l_msg);
3889: END LOOP;
3890: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3891: RETCODE := '1'; -- warning
3892: Write_log (1, TO_CHAR(DBMS_UTILITY.get_time)||': SQLCODE: ' || to_char(SQLCODE) || ' SQLERRM: ' || SQLERRM);

Line 3892: Write_log (1, TO_CHAR(DBMS_UTILITY.get_time)||': SQLCODE: ' || to_char(SQLCODE) || ' SQLERRM: ' || SQLERRM);

3888: Write_log (1, TO_CHAR(DBMS_UTILITY.get_time)||': '||l_msg);
3889: END LOOP;
3890: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3891: RETCODE := '1'; -- warning
3892: Write_log (1, TO_CHAR(DBMS_UTILITY.get_time)||': SQLCODE: ' || to_char(SQLCODE) || ' SQLERRM: ' || SQLERRM);
3893: END IF;
3894: END;
3895: END LOOP;
3896:

Line 3921: Write_log (1, TO_CHAR(DBMS_UTILITY.get_time)||': '||l_msg);

3917: FND_MSG_PUB.reset;
3918: LOOP
3919: l_msg := fnd_msg_pub.get(p_encoded => FND_API.G_FALSE);
3920: EXIT WHEN l_msg IS NULL;
3921: Write_log (1, TO_CHAR(DBMS_UTILITY.get_time)||': '||l_msg);
3922: END LOOP;
3923: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3924: RETCODE := '1'; -- warning
3925: Write_log (1, TO_CHAR(DBMS_UTILITY.get_time)||': SQLCODE: ' || to_char(SQLCODE) || ' SQLERRM: ' || SQLERRM);

Line 3925: Write_log (1, TO_CHAR(DBMS_UTILITY.get_time)||': SQLCODE: ' || to_char(SQLCODE) || ' SQLERRM: ' || SQLERRM);

3921: Write_log (1, TO_CHAR(DBMS_UTILITY.get_time)||': '||l_msg);
3922: END LOOP;
3923: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3924: RETCODE := '1'; -- warning
3925: Write_log (1, TO_CHAR(DBMS_UTILITY.get_time)||': SQLCODE: ' || to_char(SQLCODE) || ' SQLERRM: ' || SQLERRM);
3926: END IF;
3927: END;
3928: END LOOP;
3929: IF retcode IN (0,1) THEN

Line 3939: Write_log (1, TO_CHAR(DBMS_UTILITY.get_time)||': User Status for CLOSED program status is not setup. Pls. setup, and retry');

3935: WHEN FND_API.G_EXC_ERROR THEN
3936: ERRBUF := ERRBUF || sqlerrm;
3937: RETCODE := '2';
3938: IF l_user_status_id IS NULL THEN
3939: Write_log (1, TO_CHAR(DBMS_UTILITY.get_time)||': User Status for CLOSED program status is not setup. Pls. setup, and retry');
3940: END IF;
3941:
3942: WHEN OTHERS THEN
3943: ERRBUF := ERRBUF||sqlerrm;

Line 3946: Write_log (1, TO_CHAR(DBMS_UTILITY.get_time)||': Other Exception in running the conc. program for closing the endable programs');

3942: WHEN OTHERS THEN
3943: ERRBUF := ERRBUF||sqlerrm;
3944: RETCODE := '2';
3945: --l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
3946: Write_log (1, TO_CHAR(DBMS_UTILITY.get_time)||': Other Exception in running the conc. program for closing the endable programs');
3947: Write_log (1, TO_CHAR(DBMS_UTILITY.get_time)||': SQLCODE: ' || to_char(SQLCODE) || ' SQLERRM: ' || SQLERRM);
3948:
3949: END Close_Ended_programs;
3950:

Line 3947: Write_log (1, TO_CHAR(DBMS_UTILITY.get_time)||': SQLCODE: ' || to_char(SQLCODE) || ' SQLERRM: ' || SQLERRM);

3943: ERRBUF := ERRBUF||sqlerrm;
3944: RETCODE := '2';
3945: --l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
3946: Write_log (1, TO_CHAR(DBMS_UTILITY.get_time)||': Other Exception in running the conc. program for closing the endable programs');
3947: Write_log (1, TO_CHAR(DBMS_UTILITY.get_time)||': SQLCODE: ' || to_char(SQLCODE) || ' SQLERRM: ' || SQLERRM);
3948:
3949: END Close_Ended_programs;
3950:
3951: --------------------------------------------------------------------------