DBA Data[Home] [Help]

APPS.CN_SRP_PRD_QUOTA_PUB dependencies on CN_API

Line 8: ( p_api_version IN NUMBER := CN_API.G_MISS_NUM,

4: G_PKG_NAME CONSTANT VARCHAR2(30):='CN_SRP_PRD_QUOTA_PUB';
5:
6:
7: PROCEDURE Distribute_Srp_Prd_Quota
8: ( p_api_version IN NUMBER := CN_API.G_MISS_NUM,
9: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
10: p_commit IN VARCHAR2 := CN_API.G_FALSE,
11: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
12: p_salesrep_name IN CN_SALESREPS.NAME%TYPE,

Line 9: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,

5:
6:
7: PROCEDURE Distribute_Srp_Prd_Quota
8: ( p_api_version IN NUMBER := CN_API.G_MISS_NUM,
9: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
10: p_commit IN VARCHAR2 := CN_API.G_FALSE,
11: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
12: p_salesrep_name IN CN_SALESREPS.NAME%TYPE,
13: p_employee_number IN CN_SALESREPS.EMPLOYEE_NUMBER%TYPE,

Line 10: p_commit IN VARCHAR2 := CN_API.G_FALSE,

6:
7: PROCEDURE Distribute_Srp_Prd_Quota
8: ( p_api_version IN NUMBER := CN_API.G_MISS_NUM,
9: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
10: p_commit IN VARCHAR2 := CN_API.G_FALSE,
11: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
12: p_salesrep_name IN CN_SALESREPS.NAME%TYPE,
13: p_employee_number IN CN_SALESREPS.EMPLOYEE_NUMBER%TYPE,
14: p_role_name IN CN_ROLES.NAME%TYPE,

Line 11: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,

7: PROCEDURE Distribute_Srp_Prd_Quota
8: ( p_api_version IN NUMBER := CN_API.G_MISS_NUM,
9: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
10: p_commit IN VARCHAR2 := CN_API.G_FALSE,
11: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
12: p_salesrep_name IN CN_SALESREPS.NAME%TYPE,
13: p_employee_number IN CN_SALESREPS.EMPLOYEE_NUMBER%TYPE,
14: p_role_name IN CN_ROLES.NAME%TYPE,
15: p_cp_name IN CN_COMP_PLANS.NAME%TYPE,

Line 190: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('PE_NAME', 'INPUT_TOKEN'));

186: IF p_pe_name IS NULL
187: THEN
188: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
189: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
190: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('PE_NAME', 'INPUT_TOKEN'));
191: FND_MSG_PUB.Add;
192: END IF;
193: RAISE FND_API.G_EXC_ERROR ;
194: END IF;

Line 221: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('SR_NAME', 'INPUT_TOKEN'));

217: IF p_salesrep_name IS NULL
218: THEN
219: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
220: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
221: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('SR_NAME', 'INPUT_TOKEN'));
222: FND_MSG_PUB.Add;
223: END IF;
224: RAISE FND_API.G_EXC_ERROR ;
225: END IF;

Line 248: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('ROLE_NAME', 'INPUT_TOKEN'));

244: IF p_role_name IS NULL
245: THEN
246: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
247: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
248: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('ROLE_NAME', 'INPUT_TOKEN'));
249: FND_MSG_PUB.Add;
250: END IF;
251: RAISE FND_API.G_EXC_ERROR ;
252: END IF;

Line 275: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('CP_NAME', 'INPUT_TOKEN'));

271: IF p_cp_name IS NULL
272: THEN
273: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
274: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
275: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('CP_NAME', 'INPUT_TOKEN'));
276: FND_MSG_PUB.Add;
277: END IF;
278: RAISE FND_API.G_EXC_ERROR ;
279: END IF;

Line 304: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('SD', 'INPUT_TOKEN'));

300: IF p_srp_plan_start_date IS NULL
301: THEN
302: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
303: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
304: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('SD', 'INPUT_TOKEN'));
305: FND_MSG_PUB.Add;
306: END IF;
307: RAISE FND_API.G_EXC_ERROR ;
308: END IF;

Line 470: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('PERIOD_NAME', 'INPUT_TOKEN'));

466: IF p_srp_prd_quota_tbl(i).period_name IS NULL
467: THEN
468: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
469: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
470: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('PERIOD_NAME', 'INPUT_TOKEN'));
471: FND_MSG_PUB.Add;
472: END IF;
473: RAISE FND_API.G_EXC_ERROR ;
474: END IF;