DBA Data[Home] [Help]

APPS.CS_SR_PROB_CODE_MAPPING_PKG dependencies on FND_MSG_PUB

Line 265: fnd_msg_pub.initialize;

261: x_return_status := FND_API.G_RET_STS_SUCCESS;
262:
263: IF fnd_api.to_boolean (p_init_msg_list)
264: THEN
265: fnd_msg_pub.initialize;
266: END IF;
267:
268:
269: l_service_request_type_id := nvl(p_probcode_criteria_rec.service_request_type_id,0);

Line 433: FND_MSG_PUB.Count_And_Get

429: IF cs_sr_pc_catset_with_prod%isopen THEN
430: CLOSE cs_sr_pc_catset_with_prod;
431: END IF;
432: x_return_status := FND_API.G_RET_STS_ERROR;
433: FND_MSG_PUB.Count_And_Get
434: ( p_count => x_msg_count,
435: p_data => x_msg_data
436: );
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 457: FND_MSG_PUB.Count_And_Get

453: IF cs_sr_pc_catset_with_prod%isopen THEN
454: CLOSE cs_sr_pc_catset_with_prod;
455: END IF;
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
457: FND_MSG_PUB.Count_And_Get
458: ( p_count => x_msg_count,
459: p_data => x_msg_data
460: );
461: WHEN OTHERS THEN

Line 481: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

477: IF cs_sr_pc_catset_with_prod%isopen THEN
478: CLOSE cs_sr_pc_catset_with_prod;
479: END IF;
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
481: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
482: FND_MSG_PUB.Add_Exc_Msg('CS_SR_PROB_CODE_MAPPING_PKG', l_api_name);
483: END IF;
484: FND_MSG_PUB.Count_And_Get
485: ( p_count => x_msg_count,

Line 482: FND_MSG_PUB.Add_Exc_Msg('CS_SR_PROB_CODE_MAPPING_PKG', l_api_name);

478: CLOSE cs_sr_pc_catset_with_prod;
479: END IF;
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
481: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
482: FND_MSG_PUB.Add_Exc_Msg('CS_SR_PROB_CODE_MAPPING_PKG', l_api_name);
483: END IF;
484: FND_MSG_PUB.Count_And_Get
485: ( p_count => x_msg_count,
486: p_data => x_msg_data

Line 484: FND_MSG_PUB.Count_And_Get

480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
481: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
482: FND_MSG_PUB.Add_Exc_Msg('CS_SR_PROB_CODE_MAPPING_PKG', l_api_name);
483: END IF;
484: FND_MSG_PUB.Count_And_Get
485: ( p_count => x_msg_count,
486: p_data => x_msg_data
487: );
488:

Line 572: fnd_msg_pub.initialize;

568: SAVEPOINT create_mapping_rules;
569: x_return_status := fnd_api.g_ret_sts_success;
570:
571: IF fnd_api.to_boolean (p_init_msg_list) THEN
572: fnd_msg_pub.initialize;
573: END IF;
574:
575: /* First, we create the search criteria
576: Then, we create the problem code mappings to this search criteria */

Line 807: FND_MSG_PUB.Count_And_Get

803: CLOSE c_sr_prob_code_map_exists_csr;
804: END IF;
805: ROLLBACK TO create_mapping_rules;
806: x_return_status := FND_API.G_RET_STS_ERROR;
807: FND_MSG_PUB.Count_And_Get
808: ( p_count => x_msg_count,
809: p_data => x_msg_data
810: );
811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 826: FND_MSG_PUB.Count_And_Get

822: CLOSE c_sr_prob_code_map_exists_csr;
823: END IF;
824: ROLLBACK TO create_mapping_rules;
825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
826: FND_MSG_PUB.Count_And_Get
827: ( p_count => x_msg_count,
828: p_data => x_msg_data
829: );
830: WHEN OTHERS THEN

Line 845: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

841: CLOSE c_sr_prob_code_map_exists_csr;
842: END IF;
843: ROLLBACK TO create_mapping_rules;
844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
845: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
846: FND_MSG_PUB.Add_Exc_Msg('CS_SR_PROB_CODE_MAPPING_PKG', l_api_name);
847: END IF;
848: FND_MSG_PUB.Count_And_Get
849: ( p_count => x_msg_count,

Line 846: FND_MSG_PUB.Add_Exc_Msg('CS_SR_PROB_CODE_MAPPING_PKG', l_api_name);

842: END IF;
843: ROLLBACK TO create_mapping_rules;
844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
845: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
846: FND_MSG_PUB.Add_Exc_Msg('CS_SR_PROB_CODE_MAPPING_PKG', l_api_name);
847: END IF;
848: FND_MSG_PUB.Count_And_Get
849: ( p_count => x_msg_count,
850: p_data => x_msg_data

Line 848: FND_MSG_PUB.Count_And_Get

844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
845: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
846: FND_MSG_PUB.Add_Exc_Msg('CS_SR_PROB_CODE_MAPPING_PKG', l_api_name);
847: END IF;
848: FND_MSG_PUB.Count_And_Get
849: ( p_count => x_msg_count,
850: p_data => x_msg_data
851: );
852: END CREATE_MAPPING_RULES;

Line 935: fnd_msg_pub.initialize;

931: SAVEPOINT update_mapping_rules;
932: x_return_status := fnd_api.g_ret_sts_success;
933:
934: IF fnd_api.to_boolean (p_init_msg_list) THEN
935: fnd_msg_pub.initialize;
936: END IF;
937:
938: l_problem_map_id := p_probcode_map_criteria_rec.problem_map_id;
939: l_start_date_active := p_probcode_map_criteria_rec.start_date_active;

Line 1119: FND_MSG_PUB.Count_And_Get

1115: CLOSE cs_sr_probcode_mapped_csr;
1116: END IF;
1117: ROLLBACK TO update_mapping_rules;
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1119: FND_MSG_PUB.Count_And_Get
1120: ( p_count => x_msg_count,
1121: p_data => x_msg_data
1122: );
1123: WHEN OTHERS THEN

Line 1135: FND_MSG_PUB.Count_And_Get

1131: CLOSE cs_sr_probcode_mapped_csr;
1132: END IF;
1133: ROLLBACK TO update_mapping_rules;
1134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1135: FND_MSG_PUB.Count_And_Get
1136: ( p_count => x_msg_count,
1137: p_data => x_msg_data
1138: );
1139:

Line 1203: fnd_msg_pub.initialize;

1199: SAVEPOINT propagate_map_criteria_dates;
1200: x_return_status := fnd_api.g_ret_sts_success;
1201:
1202: IF fnd_api.to_boolean (p_init_msg_list) THEN
1203: fnd_msg_pub.initialize;
1204: END IF;
1205:
1206: OPEN cs_sr_probmapid_crit_csr;
1207: LOOP

Line 1295: FND_MSG_PUB.Count_And_Get

1291: CLOSE cs_sr_probmapid_rules_csr;
1292: END IF;
1293: ROLLBACK TO propagate_map_criteria_dates;
1294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1295: FND_MSG_PUB.Count_And_Get
1296: ( p_count => x_msg_count,
1297: p_data => x_msg_data
1298: );
1299: WHEN OTHERS THEN

Line 1308: FND_MSG_PUB.Count_And_Get

1304: CLOSE cs_sr_probmapid_rules_csr;
1305: END IF;
1306: ROLLBACK TO propagate_map_criteria_dates;
1307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1308: FND_MSG_PUB.Count_And_Get
1309: ( p_count => x_msg_count,
1310: p_data => x_msg_data
1311: );
1312: END;