DBA Data[Home] [Help]

APPS.AHL_MM_CANNIBALIZATION_PVT dependencies on FND_MSG_PUB

Line 157: FND_MSG_PUB.initialize;

153: END IF;
154: -- Initilaize message list
155: IF FND_API.to_boolean(p_init_msg_list)
156: THEN
157: FND_MSG_PUB.initialize;
158: END IF;
159:
160: --Validate the authorised user validation for cannibalization
161: IF (NOT FND_FUNCTION.TEST('AHL_MM_CANNIBALIZATION_USER'))

Line 164: FND_MSG_PUB.ADD;

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:
168: -- Print the All the input parameters

Line 182: FND_MSG_PUB.ADD;

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);
186: FETCH get_demand_mat_details INTO l_dem_mat_det_rec;

Line 191: FND_MSG_PUB.add;

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;
195: END IF;

Line 202: FND_MSG_PUB.ADD;

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
206: IF(p_cannibalization_rec.supply_visit_id IS NULL)

Line 209: FND_MSG_PUB.ADD;

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:
213: -- Validate the Visit Id and item instance id

Line 223: FND_MSG_PUB.add;

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;
227: END IF;

Line 233: FND_MSG_PUB.ADD;

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:
237: IF(p_cannibalization_rec.supply_pos_key IS NULL)

Line 240: FND_MSG_PUB.ADD;

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:
244: -- Validate Input values are correct or not

Line 255: FND_MSG_PUB.add;

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;
259: END IF;

Line 537: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

533: EXCEPTION
534: WHEN FND_API.G_EXC_ERROR THEN
535: x_return_status := FND_API.G_RET_STS_ERROR;
536: Rollback to sp_process_cannibalization;
537: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
538: p_data => x_msg_data,
539: p_encoded => fnd_api.g_false);
540:
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 544: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

540:
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: Rollback to sp_process_cannibalization;
544: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
545: p_data => x_msg_data,
546: p_encoded => fnd_api.g_false);
547:
548: WHEN OTHERS THEN

Line 551: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

547:
548: WHEN OTHERS THEN
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: Rollback to sp_process_cannibalization;
551: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
552: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
553: p_procedure_name => 'process_cannibalization',
554: p_error_text => SUBSTR(SQLERRM,1,240));
555: END IF;

Line 552: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

548: WHEN OTHERS THEN
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: Rollback to sp_process_cannibalization;
551: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
552: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
553: p_procedure_name => 'process_cannibalization',
554: p_error_text => SUBSTR(SQLERRM,1,240));
555: END IF;
556: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 556: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

552: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
553: p_procedure_name => 'process_cannibalization',
554: p_error_text => SUBSTR(SQLERRM,1,240));
555: END IF;
556: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
557: p_data => x_msg_data,
558: p_encoded => fnd_api.g_false);
559:
560: END process_cannibalization;

Line 687: FND_MSG_PUB.initialize;

683:
684: -- Initilaize message list
685: IF FND_API.to_boolean(p_init_msg_list)
686: THEN
687: FND_MSG_PUB.initialize;
688: END IF;
689:
690: -- STEP 1: Call SR API to create Non-routine.
691: AHL_UMP_NONROUTINES_PVT.Create_SR

Line 928: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

924: EXCEPTION
925: WHEN FND_API.G_EXC_ERROR THEN
926: x_return_status := FND_API.G_RET_STS_ERROR;
927: Rollback to sp_create_nr_workorder;
928: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
929: p_data => x_msg_data,
930: p_encoded => fnd_api.g_false);
931:
932:

Line 936: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

932:
933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
935: Rollback to sp_create_nr_workorder;
936: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
937: p_data => x_msg_data,
938: p_encoded => fnd_api.g_false);
939:
940: WHEN OTHERS THEN

Line 943: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

939:
940: WHEN OTHERS THEN
941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
942: Rollback to sp_create_nr_workorder;
943: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
944: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
945: p_procedure_name => 'create_nr_workorder',
946: p_error_text => SUBSTR(SQLERRM,1,240));
947: END IF;

Line 944: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

940: WHEN OTHERS THEN
941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
942: Rollback to sp_create_nr_workorder;
943: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
944: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
945: p_procedure_name => 'create_nr_workorder',
946: p_error_text => SUBSTR(SQLERRM,1,240));
947: END IF;
948: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 948: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

944: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
945: p_procedure_name => 'create_nr_workorder',
946: p_error_text => SUBSTR(SQLERRM,1,240));
947: END IF;
948: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
949: p_data => x_msg_data,
950: p_encoded => fnd_api.g_false);
951:
952: END create_nr_workorder;

Line 1010: FND_MSG_PUB.ADD;

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:
1014: -- get the details of the Workflow process mapped to the object p_wf_sr_obj