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.2 2008/08/28 04:08:28 bkanimoz 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.2 2008/08/28 04:08:28 bkanimoz 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 1235: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Auto_submit_charge_Lines');

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

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

1377: WHEN OTHERS THEN
1378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1379: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1380: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1381: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1382: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1383: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1384: FND_MSG_PUB.add;
1385: FND_MSG_PUB.get(p_encoded => 'F',

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

1474: WHEN OTHERS THEN
1475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1476: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1477: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1478: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Update_Charge_Lines');
1479: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1480: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1481: FND_MSG_PUB.add;
1482: FND_MSG_PUB.get(p_encoded => 'F',

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

1652: WHEN OTHERS THEN
1653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1654: -- ROLLBACK TO CS_Chg_Auto_Submission_PVT;
1655: FND_MESSAGE.SET_NAME('CS', 'CS_DB_ERROR');
1656: FND_MESSAGE.SET_TOKEN(token => 'PROG_NAME', value => 'CS_Chg_Auto_Sub_CON_PKG.Check_Debrief_Status');
1657: FND_MESSAGE.SET_TOKEN(token => 'SQLCODE', value => SQLCODE);
1658: FND_MESSAGE.SET_TOKEN(token => 'SQLERRM', value => SQLERRM);
1659: FND_MSG_PUB.add;
1660: FND_MSG_PUB.get(p_encoded => 'F',

Line 1677: END CS_Chg_Auto_Sub_CON_PKG;

1673:
1674:
1675:
1676:
1677: END CS_Chg_Auto_Sub_CON_PKG;