DBA Data[Home] [Help]

APPS.CS_CHG_AUTO_SUB_CON_PKG dependencies on CS_CHG_AUTO_SUB_CON_PKG

Line 1: PACKAGE BODY CS_Chg_Auto_Sub_CON_PKG as

1: PACKAGE BODY CS_Chg_Auto_Sub_CON_PKG as
2: /* $Header: csxvasub.pls 120.9.12010000.4 2010/01/11 10:59:21 sshilpam ship $ */
3: /*********** Global Variables ********************************/
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_Chg_Auto_Sub_CON_PKG';
5: /***************************************************************/

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_Chg_Auto_Sub_CON_PKG';

1: PACKAGE BODY CS_Chg_Auto_Sub_CON_PKG as
2: /* $Header: csxvasub.pls 120.9.12010000.4 2010/01/11 10:59:21 sshilpam ship $ */
3: /*********** Global Variables ********************************/
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_Chg_Auto_Sub_CON_PKG';
5: /***************************************************************/
6: -- *******************************************************
7: -- Start of Comments
8: -- *******************************************************

Line 1241: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Auto_submit_charge_Lines');

1237: FND_FILE.put_line(FND_FILE.LOG,'There are no eligible Charge lines available for submission to Order Management');
1238: ELSE
1239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1240: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1241: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Auto_submit_charge_Lines');
1242: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1243: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1244: FND_MSG_PUB.add;
1245: FND_MSG_PUB.get(p_encoded => 'F',

Line 1400: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');

1396: WHEN OTHERS THEN
1397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1398: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1399: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1400: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1401: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1402: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1403: FND_MSG_PUB.add;
1404: FND_MSG_PUB.get(p_encoded => 'F',

Line 1497: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');

1493: WHEN OTHERS THEN
1494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1495: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1496: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1497: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1498: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1499: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1500: FND_MSG_PUB.add;
1501: FND_MSG_PUB.get(p_encoded => 'F',

Line 1675: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Check_Debrief_Status');

1671: WHEN OTHERS THEN
1672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1673: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1674: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1675: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Check_Debrief_Status');
1676: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1677: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1678: FND_MSG_PUB.add;
1679: FND_MSG_PUB.get(p_encoded => 'F',

Line 1696: END CS_Chg_Auto_Sub_CON_PKG;

1692:
1693:
1694:
1695:
1696: END CS_Chg_Auto_Sub_CON_PKG;