DBA Data[Home] [Help]

APPS.AHL_MM_CANNIBALIZATION_PVT dependencies on FND_MESSAGE

Line 163: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CAN_NOT_AUTH_USER' );

159:
160: --Validate the authorised user validation for cannibalization
161: IF (NOT FND_FUNCTION.TEST('AHL_MM_CANNIBALIZATION_USER'))
162: THEN
163: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CAN_NOT_AUTH_USER' );
164: FND_MSG_PUB.ADD;
165: RAISE FND_API.G_EXC_ERROR;
166: END IF;
167:

Line 181: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CN_DEM_ASMID_NULL' );

177:
178: -- Validate the Demand Inputs (ASM ID)
179: IF(p_cannibalization_rec.demand_asm_id IS NULL)
180: THEN
181: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CN_DEM_ASMID_NULL' );
182: FND_MSG_PUB.ADD;
183: l_input_valid := TRUE;
184: ELSE
185: OPEN get_demand_mat_details(p_cannibalization_rec.demand_asm_id);

Line 189: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CN_INVLD_ASM_ID' );

185: OPEN get_demand_mat_details(p_cannibalization_rec.demand_asm_id);
186: FETCH get_demand_mat_details INTO l_dem_mat_det_rec;
187: IF (get_demand_mat_details%NOTFOUND)
188: THEN
189: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CN_INVLD_ASM_ID' );
190: FND_MESSAGE.set_token('ASM_ID', p_cannibalization_rec.demand_asm_id);
191: FND_MSG_PUB.add;
192: l_input_valid := TRUE;
193: END IF;

Line 190: FND_MESSAGE.set_token('ASM_ID', p_cannibalization_rec.demand_asm_id);

186: FETCH get_demand_mat_details INTO l_dem_mat_det_rec;
187: IF (get_demand_mat_details%NOTFOUND)
188: THEN
189: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CN_INVLD_ASM_ID' );
190: FND_MESSAGE.set_token('ASM_ID', p_cannibalization_rec.demand_asm_id);
191: FND_MSG_PUB.add;
192: l_input_valid := TRUE;
193: END IF;
194: CLOSE get_demand_mat_details;

Line 201: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CN_INST_NUM_NULL' );

197: -- Validate the supply input details
198: -- Instance id
199: IF(p_cannibalization_rec.supply_instance_id IS NULL)
200: THEN
201: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CN_INST_NUM_NULL' );
202: FND_MSG_PUB.ADD;
203: l_input_valid := TRUE;
204: END IF;
205: -- Visit_id

Line 208: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CN_VST_ID_NULL' );

204: END IF;
205: -- Visit_id
206: IF(p_cannibalization_rec.supply_visit_id IS NULL)
207: THEN
208: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CN_VST_ID_NULL' );
209: FND_MSG_PUB.ADD;
210: l_input_valid := TRUE;
211: END IF;
212:

Line 220: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CN_INV_VST_INS_ID' );

216: OPEN get_supply_inst_details(p_cannibalization_rec.supply_visit_id,p_cannibalization_rec.supply_instance_id );
217: FETCH get_supply_inst_details INTO l_sup_mat_det_rec;
218: IF (get_supply_inst_details%NOTFOUND)
219: THEN
220: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CN_INV_VST_INS_ID' );
221: FND_MESSAGE.set_token('INS_NUM', p_cannibalization_rec.supply_instance_id);
222: FND_MESSAGE.set_token('VSTID', p_cannibalization_rec.supply_visit_id);
223: FND_MSG_PUB.add;
224: l_input_valid := TRUE;

Line 221: FND_MESSAGE.set_token('INS_NUM', p_cannibalization_rec.supply_instance_id);

217: FETCH get_supply_inst_details INTO l_sup_mat_det_rec;
218: IF (get_supply_inst_details%NOTFOUND)
219: THEN
220: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CN_INV_VST_INS_ID' );
221: FND_MESSAGE.set_token('INS_NUM', p_cannibalization_rec.supply_instance_id);
222: FND_MESSAGE.set_token('VSTID', p_cannibalization_rec.supply_visit_id);
223: FND_MSG_PUB.add;
224: l_input_valid := TRUE;
225: END IF;

Line 222: FND_MESSAGE.set_token('VSTID', p_cannibalization_rec.supply_visit_id);

218: IF (get_supply_inst_details%NOTFOUND)
219: THEN
220: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CN_INV_VST_INS_ID' );
221: FND_MESSAGE.set_token('INS_NUM', p_cannibalization_rec.supply_instance_id);
222: FND_MESSAGE.set_token('VSTID', p_cannibalization_rec.supply_visit_id);
223: FND_MSG_PUB.add;
224: l_input_valid := TRUE;
225: END IF;
226: CLOSE get_supply_inst_details;

Line 232: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CN_MC_ID_NULL' );

228:
229: --Validate MC_header_id and position_key
230: IF(p_cannibalization_rec.supply_mc_header_id IS NULL)
231: THEN
232: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CN_MC_ID_NULL' );
233: FND_MSG_PUB.ADD;
234: l_input_valid := TRUE;
235: END IF;
236:

Line 239: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CN_POS_KEY_NULL' );

235: END IF;
236:
237: IF(p_cannibalization_rec.supply_pos_key IS NULL)
238: THEN
239: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CN_POS_KEY_NULL' );
240: FND_MSG_PUB.ADD;
241: l_input_valid := TRUE;
242: END IF;
243:

Line 252: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CN_INV_MC_POS_ID' );

248: OPEN get_mc_pos(p_cannibalization_rec.supply_mc_header_id,p_cannibalization_rec.supply_pos_key );
249: FETCH get_mc_pos INTO l_dummy;
250: IF (get_mc_pos%NOTFOUND)
251: THEN
252: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CN_INV_MC_POS_ID' );
253: FND_MESSAGE.set_token('MC_ID', p_cannibalization_rec.supply_mc_header_id);
254: FND_MESSAGE.set_token('POS', p_cannibalization_rec.supply_pos_key);
255: FND_MSG_PUB.add;
256: l_input_valid := TRUE;

Line 253: FND_MESSAGE.set_token('MC_ID', p_cannibalization_rec.supply_mc_header_id);

249: FETCH get_mc_pos INTO l_dummy;
250: IF (get_mc_pos%NOTFOUND)
251: THEN
252: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CN_INV_MC_POS_ID' );
253: FND_MESSAGE.set_token('MC_ID', p_cannibalization_rec.supply_mc_header_id);
254: FND_MESSAGE.set_token('POS', p_cannibalization_rec.supply_pos_key);
255: FND_MSG_PUB.add;
256: l_input_valid := TRUE;
257: END IF;

Line 254: FND_MESSAGE.set_token('POS', p_cannibalization_rec.supply_pos_key);

250: IF (get_mc_pos%NOTFOUND)
251: THEN
252: FND_MESSAGE.set_name( G_APP_NAME, 'AHL_MM_CN_INV_MC_POS_ID' );
253: FND_MESSAGE.set_token('MC_ID', p_cannibalization_rec.supply_mc_header_id);
254: FND_MESSAGE.set_token('POS', p_cannibalization_rec.supply_pos_key);
255: FND_MSG_PUB.add;
256: l_input_valid := TRUE;
257: END IF;
258: CLOSE get_mc_pos;

Line 271: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_MM_SR_CANN_SUMM');

267: -- Nonroutine --- ONE
268: -- Intialize the input paramaters for NR WO Creation
269:
270: --Problem Summary for Cannibalization NR
271: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_MM_SR_CANN_SUMM');
272: FND_MESSAGE.Set_Token('WO_NUM',l_dem_mat_det_rec.workorder_name);
273:
274: l_cannibalization_sr_rec.Type_id := FND_PROFILE.VALUE('AHL_SR_TYPE_FOR_CANNB');
275: l_cannibalization_sr_rec.Severity_id := 4 ; -- Sevearity High

Line 272: FND_MESSAGE.Set_Token('WO_NUM',l_dem_mat_det_rec.workorder_name);

268: -- Intialize the input paramaters for NR WO Creation
269:
270: --Problem Summary for Cannibalization NR
271: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_MM_SR_CANN_SUMM');
272: FND_MESSAGE.Set_Token('WO_NUM',l_dem_mat_det_rec.workorder_name);
273:
274: l_cannibalization_sr_rec.Type_id := FND_PROFILE.VALUE('AHL_SR_TYPE_FOR_CANNB');
275: l_cannibalization_sr_rec.Severity_id := 4 ; -- Sevearity High
276: l_cannibalization_sr_rec.problem_summary := FND_MESSAGE.GET;

Line 276: l_cannibalization_sr_rec.problem_summary := FND_MESSAGE.GET;

272: FND_MESSAGE.Set_Token('WO_NUM',l_dem_mat_det_rec.workorder_name);
273:
274: l_cannibalization_sr_rec.Type_id := FND_PROFILE.VALUE('AHL_SR_TYPE_FOR_CANNB');
275: l_cannibalization_sr_rec.Severity_id := 4 ; -- Sevearity High
276: l_cannibalization_sr_rec.problem_summary := FND_MESSAGE.GET;
277: l_cannibalization_sr_rec.instance_id := p_cannibalization_rec.supply_instance_id;
278: --l_cannibalization_sr_rec.expected_resolution_date := SYSDATE;
279:
280: IF G_DEBUG = 'Y' THEN

Line 390: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_MM_SR_REP_CANN_SUMM');

386: p_cannibalization_rec.reservation_id := l_reservation_id;
387:
388: -- Nonroutine --- TWO
389: -- Problem Summary for Cannibalization NR
390: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_MM_SR_REP_CANN_SUMM');
391: FND_MESSAGE.Set_Token('INST_NUM',p_cannibalization_rec.supply_instance_id);
392: FND_MESSAGE.Set_Token('WO_NUM',l_get_wo_det.workorder_name);
393:
394: l_rep_cannibalization_sr_rec.Type_id := FND_PROFILE.VALUE('AHL_SR_TYPE_FOR_REP_CANNB');

Line 391: FND_MESSAGE.Set_Token('INST_NUM',p_cannibalization_rec.supply_instance_id);

387:
388: -- Nonroutine --- TWO
389: -- Problem Summary for Cannibalization NR
390: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_MM_SR_REP_CANN_SUMM');
391: FND_MESSAGE.Set_Token('INST_NUM',p_cannibalization_rec.supply_instance_id);
392: FND_MESSAGE.Set_Token('WO_NUM',l_get_wo_det.workorder_name);
393:
394: l_rep_cannibalization_sr_rec.Type_id := FND_PROFILE.VALUE('AHL_SR_TYPE_FOR_REP_CANNB');
395: l_rep_cannibalization_sr_rec.Severity_id := 4 ; -- Sevearity High

Line 392: FND_MESSAGE.Set_Token('WO_NUM',l_get_wo_det.workorder_name);

388: -- Nonroutine --- TWO
389: -- Problem Summary for Cannibalization NR
390: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_MM_SR_REP_CANN_SUMM');
391: FND_MESSAGE.Set_Token('INST_NUM',p_cannibalization_rec.supply_instance_id);
392: FND_MESSAGE.Set_Token('WO_NUM',l_get_wo_det.workorder_name);
393:
394: l_rep_cannibalization_sr_rec.Type_id := FND_PROFILE.VALUE('AHL_SR_TYPE_FOR_REP_CANNB');
395: l_rep_cannibalization_sr_rec.Severity_id := 4 ; -- Sevearity High
396: l_rep_cannibalization_sr_rec.problem_summary := FND_MESSAGE.GET;

Line 396: l_rep_cannibalization_sr_rec.problem_summary := FND_MESSAGE.GET;

392: FND_MESSAGE.Set_Token('WO_NUM',l_get_wo_det.workorder_name);
393:
394: l_rep_cannibalization_sr_rec.Type_id := FND_PROFILE.VALUE('AHL_SR_TYPE_FOR_REP_CANNB');
395: l_rep_cannibalization_sr_rec.Severity_id := 4 ; -- Sevearity High
396: l_rep_cannibalization_sr_rec.problem_summary := FND_MESSAGE.GET;
397: l_rep_cannibalization_sr_rec.Instance_id := p_cannibalization_rec.supply_nha_inst_id;
398: --l_rep_cannibalization_sr_rec.expected_resolution_date := SYSDATE;
399:
400: IF G_DEBUG = 'Y' THEN

Line 1009: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MM_CN_SR_ID_NULL');

1005:
1006: -- check for the entitlement id
1007: IF (p_sr_incident_id IS NULL) THEN
1008: x_return_status := FND_API.G_RET_STS_ERROR;
1009: FND_MESSAGE.Set_Name(G_APP_NAME, 'AHL_MM_CN_SR_ID_NULL');
1010: FND_MSG_PUB.ADD;
1011: RETURN;
1012: END IF;
1013:

Line 1040: l_subject := FND_MESSAGE.GET_STRING(G_APP_NAME, p_wf_sr_sbj);

1036:
1037: -- if the mapping is active, call the notification API
1038: If (l_active_flag = 'Y') THEN
1039: -- get the subject text
1040: l_subject := FND_MESSAGE.GET_STRING(G_APP_NAME, p_wf_sr_sbj);
1041:
1042: IF (G_DEBUG = 'Y')
1043: THEN
1044: AHL_DEBUG_PUB.debug(G_PKG_NAME || '.' || l_api_name || ':before calling AHL_WF_NOTIFICATION_PVT.Launch_OA_Notification with arguments: '||