DBA Data[Home] [Help]

APPS.CN_SRP_ROLLOVER_QUOTA_PVT dependencies on FND_MSG_PUB

Line 80: FND_MSG_PUB.initialize;

76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78: -- Initialize message list if p_init_msg_list is set to TRUE.
79: IF FND_API.to_Boolean( p_init_msg_list ) THEN
80: FND_MSG_PUB.initialize;
81: END IF;
82: -- Initialize API return status to success
83: x_return_status := FND_API.G_RET_STS_SUCCESS;
84: -- API body

Line 92: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

88:
89: IF (p_srp_rollover_quota.srp_rollover_quota_id is NULL) OR
90: (p_srp_rollover_quota.srp_rollover_quota_id = fnd_api.g_miss_num)
91: THEN
92: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
93: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
94: FND_MESSAGE.SET_TOKEN('INPUT_NAME', 'srp_rollover_quota_id');
95: FND_MSG_PUB.Add;
96: END IF;

Line 95: FND_MSG_PUB.Add;

91: THEN
92: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
93: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
94: FND_MESSAGE.SET_TOKEN('INPUT_NAME', 'srp_rollover_quota_id');
95: FND_MSG_PUB.Add;
96: END IF;
97: RAISE FND_API.G_EXC_ERROR ;
98: END IF;
99:

Line 105: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

101:
102: IF (p_srp_rollover_quota.srp_quota_assign_id is NULL) OR
103: (p_srp_rollover_quota.srp_quota_assign_id = fnd_api.g_miss_num)
104: THEN
105: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
106: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
107: FND_MESSAGE.SET_TOKEN('INPUT_NAME', 'srp_quota_assign_id');
108: FND_MSG_PUB.Add;
109: END IF;

Line 108: FND_MSG_PUB.Add;

104: THEN
105: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
106: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
107: FND_MESSAGE.SET_TOKEN('INPUT_NAME', 'srp_quota_assign_id');
108: FND_MSG_PUB.Add;
109: END IF;
110: RAISE FND_API.G_EXC_ERROR ;
111: END IF;
112:

Line 118: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

114:
115: IF (p_srp_rollover_quota.quota_id is NULL) OR
116: (p_srp_rollover_quota.quota_id = fnd_api.g_miss_num)
117: THEN
118: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
119: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
120: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('PE', 'INPUT_TOKEN'));
121: FND_MSG_PUB.Add;
122: END IF;

Line 121: FND_MSG_PUB.Add;

117: THEN
118: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
119: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
120: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('PE', 'INPUT_TOKEN'));
121: FND_MSG_PUB.Add;
122: END IF;
123: RAISE FND_API.G_EXC_ERROR ;
124: END IF;
125:

Line 132: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

128:
129: IF (p_srp_rollover_quota.source_quota_id is NULL) OR
130: (p_srp_rollover_quota.source_quota_id = fnd_api.g_miss_num)
131: THEN
132: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
133: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
134: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('SPE', 'INPUT_TOKEN'));
135: FND_MSG_PUB.Add;
136: END IF;

Line 135: FND_MSG_PUB.Add;

131: THEN
132: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
133: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
134: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('SPE', 'INPUT_TOKEN'));
135: FND_MSG_PUB.Add;
136: END IF;
137: RAISE FND_API.G_EXC_ERROR ;
138: END IF;
139:

Line 145: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

141:
142: IF (p_srp_rollover_quota.rollover is NULL) OR
143: (p_srp_rollover_quota.rollover = fnd_api.g_miss_num)
144: THEN
145: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
146: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
147: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('ROLLPERCENT', 'INPUT_TOKEN'));
148: FND_MSG_PUB.Add;
149: END IF;

Line 148: FND_MSG_PUB.Add;

144: THEN
145: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
146: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
147: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('ROLLPERCENT', 'INPUT_TOKEN'));
148: FND_MSG_PUB.Add;
149: END IF;
150: RAISE FND_API.G_EXC_ERROR ;
151: END IF;
152:

Line 166: fnd_msg_pub.add;

162: -- 3. check object version number
163: IF l_old_srp_rollover_quota.object_version_number <>
164: p_srp_rollover_quota.object_version_number THEN
165: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
166: fnd_msg_pub.add;
167: raise fnd_api.g_exc_error;
168: END IF;
169:
170:

Line 303: FND_MSG_PUB.Count_And_Get

299: IF FND_API.To_Boolean( p_commit ) THEN
300: COMMIT WORK;
301: END IF;
302: -- Standard call to get message count and if count is 1, get message info.
303: FND_MSG_PUB.Count_And_Get
304: (p_count => x_msg_count ,
305: p_data => x_msg_data ,
306: p_encoded => FND_API.G_FALSE );
307: EXCEPTION

Line 311: FND_MSG_PUB.Count_And_Get

307: EXCEPTION
308: WHEN FND_API.G_EXC_ERROR THEN
309: ROLLBACK TO Update_Srp_Rollover_Quota;
310: x_return_status := FND_API.G_RET_STS_ERROR ;
311: FND_MSG_PUB.Count_And_Get
312: (p_count => x_msg_count ,
313: p_data => x_msg_data ,
314: p_encoded => FND_API.G_FALSE );
315: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 318: FND_MSG_PUB.Count_And_Get

314: p_encoded => FND_API.G_FALSE );
315: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
316: ROLLBACK TO Update_Srp_Rollover_Quota;
317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
318: FND_MSG_PUB.Count_And_Get
319: (p_count => x_msg_count ,
320: p_data => x_msg_data ,
321: p_encoded => FND_API.G_FALSE );
322: WHEN OTHERS THEN

Line 325: IF FND_MSG_PUB.Check_Msg_Level

321: p_encoded => FND_API.G_FALSE );
322: WHEN OTHERS THEN
323: ROLLBACK TO Update_Srp_Rollover_Quota;
324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
325: IF FND_MSG_PUB.Check_Msg_Level
326: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
327: THEN
328: FND_MSG_PUB.Add_Exc_Msg
329: (G_PKG_NAME ,

Line 326: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

322: WHEN OTHERS THEN
323: ROLLBACK TO Update_Srp_Rollover_Quota;
324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
325: IF FND_MSG_PUB.Check_Msg_Level
326: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
327: THEN
328: FND_MSG_PUB.Add_Exc_Msg
329: (G_PKG_NAME ,
330: l_api_name );

Line 328: FND_MSG_PUB.Add_Exc_Msg

324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
325: IF FND_MSG_PUB.Check_Msg_Level
326: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
327: THEN
328: FND_MSG_PUB.Add_Exc_Msg
329: (G_PKG_NAME ,
330: l_api_name );
331: END IF;
332: FND_MSG_PUB.Count_And_Get

Line 332: FND_MSG_PUB.Count_And_Get

328: FND_MSG_PUB.Add_Exc_Msg
329: (G_PKG_NAME ,
330: l_api_name );
331: END IF;
332: FND_MSG_PUB.Count_And_Get
333: (p_count => x_msg_count ,
334: p_data => x_msg_data ,
335: p_encoded => FND_API.G_FALSE );
336: END Update_Srp_Rollover_Quota;