APPS.WSM_RESERVATIONS_GRP dependencies on WSM_RESERVATIONS_GRP

Line 1: package body WSM_RESERVATIONS_GRP as

1: package body WSM_RESERVATIONS_GRP as
2: /* $Header: WSMGRSVB.pls 120.2 2005/09/27 10:38:16 mprathap noship $ */
3:
4: /* Package name */
5: g_pkg_name VARCHAR2(20) := 'WSM_RESERVATIONS_GRP';

Line 5: g_pkg_name VARCHAR2(20) := 'WSM_RESERVATIONS_GRP';

1: package body WSM_RESERVATIONS_GRP as
2: /* $Header: WSMGRSVB.pls 120.2 2005/09/27 10:38:16 mprathap noship $ */
3:
4: /* Package name */
5: g_pkg_name VARCHAR2(20) := 'WSM_RESERVATIONS_GRP';
6:
7: /*logging variables*/
8:
9: g_log_level_unexpected NUMBER := FND_LOG.LEVEL_UNEXPECTED ;

Line 58: l_module VARCHAR2(100) := 'wsm.plsql.WSM_RESERVATIONS_GRP.get_available_supply_demand';

54: l_api_version NUMBER := 1.0;
55: l_api_name VARCHAR2(30) := 'get_available_supply_demand';
56:
57: /* Module name for logging */
58: l_module VARCHAR2(100) := 'wsm.plsql.WSM_RESERVATIONS_GRP.get_available_supply_demand';
59:
60: /* local variable for debug purpose */
61: l_stmt_num NUMBER := 0;
62: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

Line 117: x_msg_data := SUBSTR('WSM_RESERVATIONS_GRP.validate_supply_demand: Unexpected error: '||SQLERRM, 1, 500);

113: x_return_status := G_RET_ERROR ;
114:
115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
116: x_return_status := G_RET_UNEXPECTED ;
117: x_msg_data := SUBSTR('WSM_RESERVATIONS_GRP.validate_supply_demand: Unexpected error: '||SQLERRM, 1, 500);
118:
119: WHEN OTHERS THEN
120: /* handle it... */
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 122: x_msg_data := SUBSTR('WSM_RESERVATIONS_GRP.get_available_supply_demand: Unexpexted error: '||SQLERRM, 1, 500);

118:
119: WHEN OTHERS THEN
120: /* handle it... */
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
122: x_msg_data := SUBSTR('WSM_RESERVATIONS_GRP.get_available_supply_demand: Unexpexted error: '||SQLERRM, 1, 500);
123:
124: END;
125:
126: PROCEDURE validate_supply_demand (

Line 154: l_module VARCHAR2(100) := 'wsm.plsql.WSM_RESERVATIONS_GRP.validate_supply_demand';

150: l_api_version NUMBER := 1.0;
151: l_api_name VARCHAR2(30) := 'validate_supply_demand';
152:
153: /* Module name for logging */
154: l_module VARCHAR2(100) := 'wsm.plsql.WSM_RESERVATIONS_GRP.validate_supply_demand';
155:
156: /* local variable for debug purpose */
157: l_stmt_num NUMBER := 0;
158: l_msg_tokens WSM_Log_PVT.token_rec_tbl;

Line 261: x_msg_data := SUBSTR('WSM_RESERVATIONS_GRP.validate_supply_demand: Unexpected error: '||SQLERRM, 1, 500);

257: x_return_status := G_RET_ERROR ;
258:
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260: x_return_status := G_RET_UNEXPECTED ;
261: x_msg_data := SUBSTR('WSM_RESERVATIONS_GRP.validate_supply_demand: Unexpected error: '||SQLERRM, 1, 500);
262: WHEN OTHERS THEN
263: /* handle it... */
264: x_return_status := G_RET_UNEXPECTED ;
265: x_msg_data := SUBSTR('WSM_RESERVATIONS_GRP.validate_supply_demand: Unexpected error: '||SQLERRM, 1, 500);

Line 265: x_msg_data := SUBSTR('WSM_RESERVATIONS_GRP.validate_supply_demand: Unexpected error: '||SQLERRM, 1, 500);

261: x_msg_data := SUBSTR('WSM_RESERVATIONS_GRP.validate_supply_demand: Unexpected error: '||SQLERRM, 1, 500);
262: WHEN OTHERS THEN
263: /* handle it... */
264: x_return_status := G_RET_UNEXPECTED ;
265: x_msg_data := SUBSTR('WSM_RESERVATIONS_GRP.validate_supply_demand: Unexpected error: '||SQLERRM, 1, 500);
266: END;
267:
268: end WSM_RESERVATIONS_GRP;

Line 268: end WSM_RESERVATIONS_GRP;

264: x_return_status := G_RET_UNEXPECTED ;
265: x_msg_data := SUBSTR('WSM_RESERVATIONS_GRP.validate_supply_demand: Unexpected error: '||SQLERRM, 1, 500);
266: END;
267:
268: end WSM_RESERVATIONS_GRP;