DBA Data[Home] [Help]

APPS.CS_SR_RES_CODE_MAPPING_PKG dependencies on FND_MSG_PUB

Line 351: fnd_msg_pub.initialize;

347: x_return_status := FND_API.G_RET_STS_SUCCESS;
348:
349: IF fnd_api.to_boolean (p_init_msg_list)
350: THEN
351: fnd_msg_pub.initialize;
352: END IF;
353:
354:
355: l_incident_type_id := nvl(p_rescode_criteria_rec.service_request_type_id,0);

Line 583: FND_MSG_PUB.Count_And_Get

579: CLOSE cs_sr_rc_catset_prodcat;
580: END IF;
581:
582: x_return_status := FND_API.G_RET_STS_ERROR;
583: FND_MSG_PUB.Count_And_Get
584: ( p_count => x_msg_count,
585: p_data => x_msg_data
586: );
587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 611: FND_MSG_PUB.Count_And_Get

607: CLOSE cs_sr_rc_catset_prodcat;
608: END IF;
609:
610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
611: FND_MSG_PUB.Count_And_Get
612: ( p_count => x_msg_count,
613: p_data => x_msg_data
614: );
615: WHEN OTHERS THEN

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

635: CLOSE cs_sr_rc_catset_prodcat;
636: END IF;
637:
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
640: FND_MSG_PUB.Add_Exc_Msg('CS_SR_RES_CODE_MAPPING_PKG', l_api_name);
641: END IF;
642: FND_MSG_PUB.Count_And_Get
643: ( p_count => x_msg_count,

Line 640: FND_MSG_PUB.Add_Exc_Msg('CS_SR_RES_CODE_MAPPING_PKG', l_api_name);

636: END IF;
637:
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
640: FND_MSG_PUB.Add_Exc_Msg('CS_SR_RES_CODE_MAPPING_PKG', l_api_name);
641: END IF;
642: FND_MSG_PUB.Count_And_Get
643: ( p_count => x_msg_count,
644: p_data => x_msg_data

Line 642: FND_MSG_PUB.Count_And_Get

638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
640: FND_MSG_PUB.Add_Exc_Msg('CS_SR_RES_CODE_MAPPING_PKG', l_api_name);
641: END IF;
642: FND_MSG_PUB.Count_And_Get
643: ( p_count => x_msg_count,
644: p_data => x_msg_data
645: );
646: END; -- End of procedure VALIDATE_RESOLUTION_CODE()

Line 734: fnd_msg_pub.initialize;

730: x_return_status := fnd_api.g_ret_sts_success;
731:
732: IF fnd_api.to_boolean (p_init_msg_list)
733: THEN
734: fnd_msg_pub.initialize;
735: END IF;
736:
737: /* First, we create the search criteria
738: Then, we create the resolution code mappings to this search criteria */

Line 958: FND_MSG_PUB.Count_And_Get

954: END IF;
955:
956: ROLLBACK TO create_mapping_rules;
957: x_return_status := FND_API.G_RET_STS_ERROR;
958: FND_MSG_PUB.Count_And_Get
959: ( p_count => x_msg_count,
960: p_data => x_msg_data
961: );
962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 978: FND_MSG_PUB.Count_And_Get

974: END IF;
975:
976: ROLLBACK TO create_mapping_rules;
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: FND_MSG_PUB.Count_And_Get
979: ( p_count => x_msg_count,
980: p_data => x_msg_data
981: );
982: WHEN OTHERS THEN

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

994: END IF;
995:
996: ROLLBACK TO create_mapping_rules;
997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
998: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
999: FND_MSG_PUB.Add_Exc_Msg('CS_SR_RES_CODE_MAPPING_PKG', l_api_name);
1000: END IF;
1001: FND_MSG_PUB.Count_And_Get
1002: ( p_count => x_msg_count,

Line 999: FND_MSG_PUB.Add_Exc_Msg('CS_SR_RES_CODE_MAPPING_PKG', l_api_name);

995:
996: ROLLBACK TO create_mapping_rules;
997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
998: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
999: FND_MSG_PUB.Add_Exc_Msg('CS_SR_RES_CODE_MAPPING_PKG', l_api_name);
1000: END IF;
1001: FND_MSG_PUB.Count_And_Get
1002: ( p_count => x_msg_count,
1003: p_data => x_msg_data

Line 1001: FND_MSG_PUB.Count_And_Get

997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
998: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
999: FND_MSG_PUB.Add_Exc_Msg('CS_SR_RES_CODE_MAPPING_PKG', l_api_name);
1000: END IF;
1001: FND_MSG_PUB.Count_And_Get
1002: ( p_count => x_msg_count,
1003: p_data => x_msg_data
1004: );
1005:

Line 1105: fnd_msg_pub.initialize;

1101: SAVEPOINT update_mapping_rules;
1102: x_return_status := fnd_api.g_ret_sts_success;
1103:
1104: IF fnd_api.to_boolean (p_init_msg_list) THEN
1105: fnd_msg_pub.initialize;
1106: END IF;
1107:
1108: l_resolution_map_id := p_rescode_map_criteria_rec.resolution_map_id;
1109: l_start_date_active := p_rescode_map_criteria_rec.start_date_active;

Line 1294: FND_MSG_PUB.Count_And_Get

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

Line 1310: FND_MSG_PUB.Count_And_Get

1306: CLOSE cs_sr_rescode_mapped_csr;
1307: END IF;
1308: ROLLBACK TO update_mapping_rules;
1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1310: FND_MSG_PUB.Count_And_Get
1311: ( p_count => x_msg_count,
1312: p_data => x_msg_data
1313: );
1314:

Line 1377: fnd_msg_pub.initialize;

1373: SAVEPOINT propagate_map_criteria_dates;
1374: x_return_status := fnd_api.g_ret_sts_success;
1375:
1376: IF fnd_api.to_boolean (p_init_msg_list) THEN
1377: fnd_msg_pub.initialize;
1378: END IF;
1379:
1380: OPEN cs_sr_resmapid_crit_csr;
1381: LOOP

Line 1469: FND_MSG_PUB.Count_And_Get

1465: CLOSE cs_sr_resmapid_rules_csr;
1466: END IF;
1467: ROLLBACK TO propagate_map_criteria_dates;
1468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1469: FND_MSG_PUB.Count_And_Get
1470: ( p_count => x_msg_count,
1471: p_data => x_msg_data
1472: );
1473: WHEN OTHERS THEN

Line 1482: FND_MSG_PUB.Count_And_Get

1478: CLOSE cs_sr_resmapid_rules_csr;
1479: END IF;
1480: ROLLBACK TO propagate_map_criteria_dates;
1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1482: FND_MSG_PUB.Count_And_Get
1483: ( p_count => x_msg_count,
1484: p_data => x_msg_data
1485: );
1486: