APPS.AS_SALES_LEAD_RANKS_PVT dependencies on AS_SALES_LEAD_RANKS_PVT

Line 1: PACKAGE BODY AS_SALES_LEAD_RANKS_PVT AS

1: PACKAGE BODY AS_SALES_LEAD_RANKS_PVT AS
2: /* #$Header: asxvrnkb.pls 115.24 2004/01/23 23:48:36 chchandr ship $ */
3: -- Start of Comments
4: -- Package name : AS_SALES_LEAD_RANKS_PVT
5: -- Purpose : to add ranks into AS_SALES_LEAD_RANKS_B and _TL

Line 4: -- Package name : AS_SALES_LEAD_RANKS_PVT

1: PACKAGE BODY AS_SALES_LEAD_RANKS_PVT AS
2: /* #$Header: asxvrnkb.pls 115.24 2004/01/23 23:48:36 chchandr ship $ */
3: -- Start of Comments
4: -- Package name : AS_SALES_LEAD_RANKS_PVT
5: -- Purpose : to add ranks into AS_SALES_LEAD_RANKS_B and _TL
6: -- History : 07/24/2000 raverma created
7: -- NOTE :
8: -- End of Comments

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AS_SALES_LEAD_RANKS_PVT';

6: -- History : 07/24/2000 raverma created
7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AS_SALES_LEAD_RANKS_PVT';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxvrnkb.pls';
12: /*
13: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
14: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;

Line 1052: Write_log (1, 'Error in as_sales_lead_ranks_pvt.update_lead_rank_score');

1048: WHEN FND_API.G_EXC_ERROR THEN
1049: ERRBUF := ERRBUF || sqlerrm;
1050: RETCODE := FND_API.G_RET_STS_ERROR;
1051: ROLLBACK;
1052: Write_log (1, 'Error in as_sales_lead_ranks_pvt.update_lead_rank_score');
1053: Write_log (1, 'SQLCODE ' || to_char(SQLCODE) ||
1054: ' SQLERRM ' || substr(SQLERRM, 1, 100));
1055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1056: ERRBUF := ERRBUF||sqlerrm;

Line 1059: Write_Log(1, 'Unexpected error in as_sales_lead_ranks_pvt.update_lead_rank_score');

1055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1056: ERRBUF := ERRBUF||sqlerrm;
1057: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
1058: ROLLBACK;
1059: Write_Log(1, 'Unexpected error in as_sales_lead_ranks_pvt.update_lead_rank_score');
1060: WHEN others THEN
1061: ERRBUF := SQLERRM;
1062: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
1063: ROLLBACK;

Line 1064: Write_Log(1, 'Exception: others in as_sales_lead_ranks_pvt.update_lead_rank_score');

1060: WHEN others THEN
1061: ERRBUF := SQLERRM;
1062: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
1063: ROLLBACK;
1064: Write_Log(1, 'Exception: others in as_sales_lead_ranks_pvt.update_lead_rank_score');
1065: Write_Log(1, 'SQLCODE ' || to_char(SQLCODE) ||
1066: ' SQLERRM ' || substr(SQLERRM, 1, 100));
1067: end UPDATE_LEAD_RANK_SCORE;
1068:

Line 1076: END AS_SALES_LEAD_RANKS_PVT;

1072: FND_FILE.put(p_which, p_msg);
1073: FND_FILE.new_line(p_which, 1);
1074: END Write_Log;
1075:
1076: END AS_SALES_LEAD_RANKS_PVT;