eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_SERVICEREQUEST_PVT dependencies on FND_MSG_PUB

Line 79: FND_MSG_PUB.ADD;

75: FND_MESSAGE.set_token
76: ('P_TEXT'
77: , 'CS_SERVICEREQUEST_UTIL.get_incident_type_details'||'-'||SQLERRM
78: );
79: FND_MSG_PUB.ADD;
80: END get_incident_type_details;
81: -- -----------------------------------------------------------------------------
82: -- PROCEDURE : Get_default_contract PRIVATE
83: -- PARAMETERS: p_business_process_id Business Process associayed with incident type

Line 225: FND_MSG_PUB.ADD_DETAIL (p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG);

221: (px_inp_rec.severity_id IS NULL) OR
222: (px_inp_rec.time_zone_id IS NULL) )
223: THEN
224: FND_MESSAGE.SET_NAME ('CS','CS_SR_DEF_SLA_INSUFF_PARAMS');
225: FND_MSG_PUB.ADD_DETAIL (p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG);
226: --FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
227: ELSE
228: OKS_ENTITLEMENTS_PUB.get_contracts
229: (p_api_version => 1.0,

Line 226: --FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

222: (px_inp_rec.time_zone_id IS NULL) )
223: THEN
224: FND_MESSAGE.SET_NAME ('CS','CS_SR_DEF_SLA_INSUFF_PARAMS');
225: FND_MSG_PUB.ADD_DETAIL (p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG);
226: --FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
227: ELSE
228: OKS_ENTITLEMENTS_PUB.get_contracts
229: (p_api_version => 1.0,
230: p_init_msg_list => fnd_api.g_false ,

Line 252: FND_MSG_PUB.add_detail(p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG);

248: x_exp_resolution_date := null ;
249: x_obligation_date := null ;
250:
251: FND_MESSAGE.set_name('CS','CS_SR_UNABLE_DEF_CONTR');
252: FND_MSG_PUB.add_detail(p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG);
253: -- in case of update API, this param is always passed as NULL
254: -- so this will not execute for update API
255:
256: -- Start changes for bug 9648141. If p_default_coverage_template_id is passed, use the same

Line 652: FND_MSG_PUB.ADD_DETAIL(p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG);

648: IF p_old_contract_service_id IS NOT NULL AND
649: NVL(p_sr_rec.contract_service_id,-99) <> p_old_contract_service_id
650: THEN
651: FND_MESSAGE.SET_NAME('CS','CS_SR_CONTRACT_ASSIGN_CHANGED');
652: FND_MSG_PUB.ADD_DETAIL(p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG);
653: END IF ;
654: END IF; -- contract service or related attributes are null
655: -- move the above part to get_default_contract
656: END IF; -- if default contrct sla ind is 'Y'

Line 662: FND_MSG_PUB.add;

658: l_contract_defaulted <> 'Y'
659: THEN
660: FND_MESSAGE.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
661: FND_MESSAGE.set_token('API_NAME', 'CS_SERVICEREQUEST_UTIL.contracts_cross_val' );
662: FND_MSG_PUB.add;
663: RAISE FND_API.G_EXC_ERROR;
664: END IF;
665: -- End of Default contract SLA processing
666: --

Line 702: FND_MSG_PUB.ADD;

698: IF p_auto_assign NOT IN ('Y','N','y','n')
699: THEN
700: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_AUTOASSIGN_PARAM');
701: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
702: FND_MSG_PUB.ADD;
703: END IF;
704: IF p_sr_rec.owner_id IS NULL AND
705: LOWER(p_auto_assign) = 'y' AND
706: NVL(p_sr_related_data.old_disallow_request_update,'N') = 'N'

Line 740: FND_MSG_PUB.Count_And_Get

736: , x_owner_group_id => l_asgn_owner_group_id
737: );
738: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
739: THEN
740: FND_MSG_PUB.Count_And_Get
741: ( p_count => l_msg_count
742: , p_data => l_msg_data
743: );
744: IF (l_orig_group_type_null = 'Y') then

Line 770: FND_MSG_PUB.ADD;

766: IF l_asgn_owner_group_id IS NULL AND l_asgn_owner_id IS NULL
767: THEN
768: FND_MESSAGE.Set_Name('CS', 'CS_SR_AM_API_RETURNED_NULL');
769: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
770: FND_MSG_PUB.ADD;
771: END IF;
772: p_sr_rec.territory_id := l_territory_id;
773: END IF; -- AM API returned with success
774: END IF; -- is call to assign_servicerequest needed?

Line 791: FND_MSG_PUB.ADD;

787: FND_MESSAGE.set_token
788: ('P_TEXT'
789: , 'CS_SERVICEREQUEST_UTIL.vldt_sr_rec'||'-'||SQLERRM
790: );
791: FND_MSG_PUB.ADD;
792: END vldt_sr_rec;
793: --============================================================================
794: -- PROCEDURE : set_time_zone PRIVATE
795: -- PARAMETERS: p_contact_party_id Contact party

Line 1093: FND_MSG_PUB.Initialize;

1089: END IF;
1090:
1091: -- Initialize message list if p_init_msg_list is set to TRUE
1092: IF FND_API.To_Boolean(p_init_msg_list) THEN
1093: FND_MSG_PUB.Initialize;
1094: END IF;
1095:
1096: -- Initialize API return status to success
1097: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1145: FND_MSG_PUB.Count_And_Get

1141: EXCEPTION
1142: WHEN FND_API.G_EXC_ERROR THEN
1143: ROLLBACK TO Create_ServiceRequest_PVT;
1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145: FND_MSG_PUB.Count_And_Get
1146: ( p_count => x_msg_count,
1147: p_data => x_msg_data
1148: );
1149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1152: FND_MSG_PUB.Count_And_Get

1148: );
1149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1150: ROLLBACK TO Create_ServiceRequest_PVT;
1151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1152: FND_MSG_PUB.Count_And_Get
1153: ( p_count => x_msg_count,
1154: p_data => x_msg_data
1155: );
1156: WHEN OTHERS THEN

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

1155: );
1156: WHEN OTHERS THEN
1157: ROLLBACK TO Create_ServiceRequest_PVT;
1158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1159: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1160: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1161: END IF;
1162: FND_MSG_PUB.Count_And_Get
1163: ( p_count => x_msg_count,

Line 1160: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1156: WHEN OTHERS THEN
1157: ROLLBACK TO Create_ServiceRequest_PVT;
1158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1159: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1160: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1161: END IF;
1162: FND_MSG_PUB.Count_And_Get
1163: ( p_count => x_msg_count,
1164: p_data => x_msg_data

Line 1162: FND_MSG_PUB.Count_And_Get

1158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1159: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1160: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1161: END IF;
1162: FND_MSG_PUB.Count_And_Get
1163: ( p_count => x_msg_count,
1164: p_data => x_msg_data
1165: );
1166:

Line 1465: FND_MSG_PUB.Initialize;

1461: END IF;
1462:
1463: -- Initialize message list if p_init_msg_list is set to TRUE
1464: IF FND_API.To_Boolean(p_init_msg_list) THEN
1465: FND_MSG_PUB.Initialize;
1466: END IF;
1467:
1468: IF ( l_service_request_rec.initialize_flag IS NULL OR
1469: l_service_request_rec.initialize_flag <> G_INITIALIZED) THEN

Line 1564: FND_MSG_PUB.ADD_DETAIL

1560: FND_MESSAGE.set_token
1561: ( 'API_NAME'
1562: , 'CS_SERVICEREQUEST_PVT.create_servicerequest'
1563: );
1564: FND_MSG_PUB.ADD_DETAIL
1565: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.ITEM_SERIAL_NUMBER'
1566: );
1567: RAISE FND_API.G_EXC_ERROR;
1568: END IF;

Line 1623: FND_MSG_PUB.ADD_DETAIL

1619: FND_MESSAGE.set_token
1620: ( 'API_NAME'
1621: , 'CS_SERVICEREQUEST_PVT.create_servicerequest'
1622: );
1623: FND_MSG_PUB.ADD_DETAIL
1624: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.MAINT_ORGANIZATION_ID'
1625: );
1626: RAISE FND_API.G_EXC_ERROR;
1627: END IF;

Line 2181: FND_MSG_PUB.ADD;

2177:
2178: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2179: FND_MESSAGE.Set_Name('CS', 'CS_SR_ONETIME_CREATE_ERROR');
2180: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'CREATE_ONETIME_ADDRESS');
2181: FND_MSG_PUB.ADD;
2182: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2183: --so that the new party_site_id gets stamped in the cs_incidents_all_b table
2184: l_service_request_rec.incident_location_id := l_incident_location_id;
2185: l_service_request_rec.incident_location_type := 'HZ_PARTY_SITE';

Line 2259: FND_MSG_PUB.ADD;

2255: l_service_request_rec.incident_postal_plus4_code := null;
2256: --End of changes for bug 8594093
2257: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_INCIDENT_ADDRESS');
2258: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'CREATE_INCIDENT_ADDRESS');
2259: FND_MSG_PUB.ADD;
2260: END IF;
2261:
2262: END IF;
2263:

Line 2308: FND_MSG_PUB.ADD;

2304:
2305: /*
2306: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_PROJECT_DETAILS');
2307: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'VALIDATE_PROJECT_INFO');
2308: FND_MSG_PUB.ADD;
2309: */
2310: END IF;
2311: END IF;
2312:

Line 3386: FND_MSG_PUB.Count_And_Get

3382: /*resetting the parameter value shijain 4th dec 2002*/
3383: g_restrict_ib:=NULL;
3384:
3385: -- Standard call to get message count and if count is 1, get message info
3386: FND_MSG_PUB.Count_And_Get
3387: ( p_count => x_msg_count,
3388: p_data => x_msg_data
3389: );
3390:

Line 3456: FND_MSG_PUB.ADD;

3452:
3453: IF (p_auto_generate_tasks <> 'N' AND p_auto_generate_tasks <> 'n') THEN
3454: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_AUTOTASK_PARAM');
3455: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
3456: FND_MSG_PUB.ADD;
3457: END IF;
3458:
3459: End If; -- If p_auto_generate_tasks = 'Y'
3460:

Line 3481: FND_MSG_PUB.Count_And_Get

3477: x_msg_count => x_msg_count,
3478: x_msg_data => x_msg_data) ;
3479:
3480: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3481: FND_MSG_PUB.Count_And_Get
3482: ( p_count => x_msg_count,
3483: p_data => x_msg_data
3484: );
3485: END IF;

Line 3496: FND_MSG_PUB.Count_And_Get

3492: EXCEPTION
3493: WHEN FND_API.G_EXC_ERROR THEN
3494: ROLLBACK TO Create_ServiceRequest_PVT;
3495: x_return_status := FND_API.G_RET_STS_ERROR;
3496: FND_MSG_PUB.Count_And_Get
3497: ( p_count => x_msg_count,
3498: p_data => x_msg_data
3499: );
3500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3503: FND_MSG_PUB.Count_And_Get

3499: );
3500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3501: ROLLBACK TO Create_ServiceRequest_PVT;
3502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3503: FND_MSG_PUB.Count_And_Get
3504: ( p_count => x_msg_count,
3505: p_data => x_msg_data
3506: );
3507: WHEN Auto_Assign_Excep THEN

Line 3509: FND_MSG_PUB.Count_And_Get

3505: p_data => x_msg_data
3506: );
3507: WHEN Auto_Assign_Excep THEN
3508: x_return_status := FND_API.G_RET_STS_SUCCESS;
3509: FND_MSG_PUB.Count_And_Get
3510: ( p_count => x_msg_count,
3511: p_data => x_msg_data
3512: );
3513: --- For BUG # 2933250

Line 3518: FND_MSG_PUB.ADD;

3514: WHEN invalid_install_site THEN
3515: ROLLBACK TO Create_ServiceRequest_PVT;
3516: x_return_status := FND_API.G_RET_STS_ERROR;
3517: FND_MESSAGE.SET_NAME('CS','CS_SR_INVALID_INSTALL_SITE');
3518: FND_MSG_PUB.ADD;
3519: FND_MSG_PUB.Count_And_Get
3520: ( p_count => x_msg_count,
3521: p_data => x_msg_data
3522: );

Line 3519: FND_MSG_PUB.Count_And_Get

3515: ROLLBACK TO Create_ServiceRequest_PVT;
3516: x_return_status := FND_API.G_RET_STS_ERROR;
3517: FND_MESSAGE.SET_NAME('CS','CS_SR_INVALID_INSTALL_SITE');
3518: FND_MSG_PUB.ADD;
3519: FND_MSG_PUB.Count_And_Get
3520: ( p_count => x_msg_count,
3521: p_data => x_msg_data
3522: );
3523: WHEN OTHERS THEN

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

3522: );
3523: WHEN OTHERS THEN
3524: ROLLBACK TO Create_ServiceRequest_PVT;
3525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3526: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3527: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3528: END IF;
3529: FND_MSG_PUB.Count_And_Get
3530: ( p_count => x_msg_count,

Line 3527: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

3523: WHEN OTHERS THEN
3524: ROLLBACK TO Create_ServiceRequest_PVT;
3525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3526: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3527: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3528: END IF;
3529: FND_MSG_PUB.Count_And_Get
3530: ( p_count => x_msg_count,
3531: p_data => x_msg_data

Line 3529: FND_MSG_PUB.Count_And_Get

3525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3526: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3527: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3528: END IF;
3529: FND_MSG_PUB.Count_And_Get
3530: ( p_count => x_msg_count,
3531: p_data => x_msg_data
3532: );
3533:

Line 3602: FND_MSG_PUB.Initialize;

3598: -- END IF;
3599:
3600: -- Initialize message list if p_init_msg_list is set to TRUE
3601: IF FND_API.To_Boolean(p_init_msg_list) THEN
3602: FND_MSG_PUB.Initialize;
3603: END IF;
3604:
3605: -- Initialize API return status to success
3606: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3657: FND_MSG_PUB.Count_And_Get

3653: --IF (l_ServiceRequest_csr%ISOPEN) THEN
3654: -- CLOSE l_ServiceRequest_csr;
3655: -- END IF;
3656: x_return_status := FND_API.G_RET_STS_ERROR;
3657: FND_MSG_PUB.Count_And_Get
3658: ( p_count => x_msg_count,
3659: p_data => x_msg_data
3660: );
3661:

Line 3668: FND_MSG_PUB.Count_And_Get

3664: -- IF (l_ServiceRequest_csr%ISOPEN) THEN
3665: -- CLOSE l_ServiceRequest_csr;
3666: -- END IF;
3667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3668: FND_MSG_PUB.Count_And_Get
3669: ( p_count => x_msg_count,
3670: p_data => x_msg_data
3671: );
3672:

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

3675: -- IF (l_ServiceRequest_csr%ISOPEN) THEN
3676: -- CLOSE l_ServiceRequest_csr;
3677: -- END IF;
3678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3679: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3680: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3681: END IF;
3682: FND_MSG_PUB.Count_And_Get
3683: ( p_count => x_msg_count,

Line 3680: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

3676: -- CLOSE l_ServiceRequest_csr;
3677: -- END IF;
3678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3679: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3680: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3681: END IF;
3682: FND_MSG_PUB.Count_And_Get
3683: ( p_count => x_msg_count,
3684: p_data => x_msg_data

Line 3682: FND_MSG_PUB.Count_And_Get

3678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3679: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3680: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3681: END IF;
3682: FND_MSG_PUB.Count_And_Get
3683: ( p_count => x_msg_count,
3684: p_data => x_msg_data
3685: );
3686:

Line 4104: FND_MSG_PUB.Initialize;

4100: END IF;
4101:
4102: -- Initialize message list if p_init_msg_list is set to TRUE
4103: IF FND_API.To_Boolean(p_init_msg_list) THEN
4104: FND_MSG_PUB.Initialize;
4105: END IF;
4106:
4107: -- Initialize API return status to success
4108: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4350: FND_MSG_PUB.ADD_DETAIL

4346: FND_MESSAGE.set_token
4347: ( 'API_NAME'
4348: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4349: );
4350: FND_MSG_PUB.ADD_DETAIL
4351: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.ITEM_SERIAL_NUMBER'
4352: );
4353: RAISE FND_API.G_EXC_ERROR;
4354: END IF;

Line 4502: FND_MSG_PUB.ADD_DETAIL

4498: FND_MESSAGE.set_token
4499: ( 'API_NAME'
4500: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4501: );
4502: FND_MSG_PUB.ADD_DETAIL
4503: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.MAINT_ORGANIZATION_ID'
4504: );
4505: RAISE FND_API.G_EXC_ERROR;
4506: END IF;

Line 4647: FND_MSG_PUB.ADD_DETAIL

4643: ( 'API_NAME'
4644: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4645: );
4646: FND_MESSAGE.set_token('STATUS_ID',l_sr_related_data.target_status_id);
4647: FND_MSG_PUB.ADD_DETAIL
4648: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_status_id'
4649: );
4650: RAISE FND_API.G_EXC_ERROR;
4651: END IF; -- l_pending approval flag is Y

Line 4672: FND_MSG_PUB.Add_Detail

4668: NVL(p_service_request_rec.last_update_program_code,'UNKOWN') <> 'ERES'
4669: THEN
4670: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
4671: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
4672: FND_MSG_PUB.Add_Detail
4673: ( p_message_type => fnd_msg_pub.G_WARNING_MSG
4674: , p_same_associated_columns => 'CS_INCIDENTS_ALL_B.INCIDENT_STATUS_ID'
4675: );
4676: IF l_old_servicerequest_rec.incident_status_id = l_service_request_rec.status_id

Line 4673: ( p_message_type => fnd_msg_pub.G_WARNING_MSG

4669: THEN
4670: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
4671: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
4672: FND_MSG_PUB.Add_Detail
4673: ( p_message_type => fnd_msg_pub.G_WARNING_MSG
4674: , p_same_associated_columns => 'CS_INCIDENTS_ALL_B.INCIDENT_STATUS_ID'
4675: );
4676: IF l_old_servicerequest_rec.incident_status_id = l_service_request_rec.status_id
4677: THEN

Line 4922: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4918: -- then based l_only_status_update_flag, we should only update the status and no other attributes of SR.
4919: -- Since from Contact center, we can only update status field, check whether last_update_prgoram_code
4920: -- is contact center, if, so do not throw the warning.
4921: IF(l_service_request_rec.last_update_program_code <> 'CSXSRTAB') THEN
4922: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4923: THEN
4924: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
4925: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
4926: FND_MSG_PUB.Add_Detail

Line 4926: FND_MSG_PUB.Add_Detail

4922: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4923: THEN
4924: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
4925: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
4926: FND_MSG_PUB.Add_Detail
4927: ( p_message_type => fnd_msg_pub.G_WARNING_MSG
4928: , p_same_associated_columns => 'T'
4929: );
4930: END IF;

Line 4927: ( p_message_type => fnd_msg_pub.G_WARNING_MSG

4923: THEN
4924: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
4925: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
4926: FND_MSG_PUB.Add_Detail
4927: ( p_message_type => fnd_msg_pub.G_WARNING_MSG
4928: , p_same_associated_columns => 'T'
4929: );
4930: END IF;
4931: END IF;

Line 5142: FND_MSG_PUB.add;

5138: )
5139: THEN
5140: FND_MESSAGE.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
5141: FND_MESSAGE.set_token('API_NAME', 'CS_SERVICEREQUEST_UTIL.contracts_cross_val' );
5142: FND_MSG_PUB.add;
5143: RAISE FND_API.G_EXC_ERROR;
5144: END IF;
5145: END IF;
5146:

Line 5610: FND_MSG_PUB.ADD;

5606: x_sr_update_out_rec.incident_location_id := l_old_servicerequest_rec.incident_location_id;
5607: --end changes for bug 8545879
5608: FND_MESSAGE.Set_Name('CS', 'CS_SR_ONETIME_CREATE_ERROR');
5609: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'CREATE_ONETIME_ADDRESS');
5610: FND_MSG_PUB.ADD;
5611:
5612: ELSIF (l_return_status_onetime = FND_API.G_RET_STS_SUCCESS) THEN
5613: --so that the new party_site_id gets stamped in the cs_incidents_all_b table
5614: l_service_request_rec.incident_location_id := l_incident_location_id;

Line 5651: FND_MSG_PUB.ADD;

5647:
5648: IF (l_return_status_onetime <> FND_API.G_RET_STS_SUCCESS) THEN
5649: FND_MESSAGE.Set_Name('CS', 'CS_SR_ONETIME_UPDATE_ERROR');
5650: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'UPDATE_ONETIME_ADDRESS');
5651: FND_MSG_PUB.ADD;
5652:
5653: ELSIF (l_return_status_onetime = FND_API.G_RET_STS_SUCCESS) THEN
5654: l_service_request_rec.incident_location_type := 'HZ_PARTY_SITE';
5655: END IF;

Line 5702: FND_MSG_PUB.ADD;

5698: l_service_request_rec.incident_postal_plus4_code := l_old_servicerequest_rec.incident_postal_plus4_code;
5699: --End of changes for bug 8594093
5700: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_INCIDENT_ADDRESS');
5701: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'CREATE_INCIDENT_ADDRESS');
5702: FND_MSG_PUB.ADD;
5703:
5704: END IF;
5705: END IF;
5706:

Line 5761: FND_MSG_PUB.ADD;

5757: END IF;
5758: IF (l_project_info_status <> FND_API.G_RET_STS_SUCCESS) THEN
5759: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_PROJECT_DETAILS');
5760: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'VALIDATE_PROJECT_INFO');
5761: FND_MSG_PUB.ADD;
5762: END IF;
5763:
5764: --validate all newly passed values
5765: ELSIF (l_service_request_Rec.project_id <> FND_API.G_MISS_NUM AND l_service_request_rec.project_task_id <> FND_API.G_MISS_NUM AND l_service_request_rec.expenditure_org_id <> FND_API.G_MISS_NUM) THEN

Line 5779: FND_MSG_PUB.ADD;

5775:
5776: IF (l_project_info_status <> FND_API.G_RET_STS_SUCCESS) THEN
5777: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_PROJECT_DETAILS');
5778: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'VALIDATE_PROJECT_INFO');
5779: FND_MSG_PUB.ADD;
5780: END IF;
5781:
5782:
5783: --if all scenarios handled dont fall under the checked condition default all values to old valus and do the update

Line 5798: FND_MSG_PUB.ADD;

5794: IF (l_project_info_status <> FND_API.G_RET_STS_SUCCESS) THEN
5795: /*
5796: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_PROJECT_DETAILS');
5797: FND_MESSAGE.Set_Token('API_NAME', l_api_name||'UPDATE SERVICE_REQUEST');
5798: FND_MSG_PUB.ADD;
5799: */
5800: RAISE FND_API.G_EXC_ERROR ;
5801: --ROLLBACK TO Update_ServiceRequest_PVT;
5802: END IF;

Line 6571: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

6567: x_msg_data => x_msg_data
6568: );
6569:
6570: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6571: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
6572: p_data => x_msg_data );
6573: END IF;
6574: END IF; -- End of l_task_template_id is null and l_task_template_id <> -1 , if task_template_id null or -1, dont generate task
6575: END IF; -- end of p_auto_generate_tasks = 'Y'

Line 7089: FND_MSG_PUB.Count_And_Get

7085: x_msg_count => x_msg_count,
7086: x_msg_data => x_msg_data);
7087:
7088: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7089: FND_MSG_PUB.Count_And_Get
7090: ( p_count => x_msg_count,
7091: p_data => x_msg_data
7092: );
7093: END IF;

Line 7106: FND_MSG_PUB.Count_And_Get (

7102: /*resetting the parameter value shijain 4th dec 2002*/
7103: g_restrict_ib:=NULL;
7104:
7105: -- Standard call to get message count and if count is 1, get message info
7106: FND_MSG_PUB.Count_And_Get (
7107: p_count => x_msg_count,
7108: p_data => x_msg_data );
7109:
7110: EXCEPTION

Line 7117: FND_MSG_PUB.Count_And_Get

7113: IF (l_ServiceRequest_csr%ISOPEN) THEN
7114: CLOSE l_ServiceRequest_csr;
7115: END IF;
7116: x_return_status := FND_API.G_RET_STS_ERROR;
7117: FND_MSG_PUB.Count_And_Get
7118: ( p_count => x_msg_count,
7119: p_data => x_msg_data
7120: );
7121:

Line 7128: FND_MSG_PUB.Count_And_Get

7124: IF (l_ServiceRequest_csr%ISOPEN) THEN
7125: CLOSE l_ServiceRequest_csr;
7126: END IF;
7127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7128: FND_MSG_PUB.Count_And_Get
7129: ( p_count => x_msg_count,
7130: p_data => x_msg_data
7131: );
7132:

Line 7143: FND_MSG_PUB.ADD;

7139: ELSE
7140: x_return_status := FND_API.G_RET_STS_ERROR;
7141: END IF;
7142: FND_MESSAGE.SET_NAME('CS','CS_SR_DESTINATION_UPDATED');
7143: FND_MSG_PUB.ADD;
7144: FND_MSG_PUB.Count_And_Get
7145: ( p_count => x_msg_count,
7146: p_data => x_msg_data
7147: );

Line 7144: FND_MSG_PUB.Count_And_Get

7140: x_return_status := FND_API.G_RET_STS_ERROR;
7141: END IF;
7142: FND_MESSAGE.SET_NAME('CS','CS_SR_DESTINATION_UPDATED');
7143: FND_MSG_PUB.ADD;
7144: FND_MSG_PUB.Count_And_Get
7145: ( p_count => x_msg_count,
7146: p_data => x_msg_data
7147: );
7148:

Line 7155: FND_MSG_PUB.ADD;

7151: CLOSE l_ServiceRequest_csr;
7152: END IF;
7153: x_return_status := FND_API.G_RET_STS_ERROR;
7154: FND_MESSAGE.SET_NAME('CS','CS_SR_LESSER_OBJ_VERSION');
7155: FND_MSG_PUB.ADD;
7156: FND_MSG_PUB.Count_And_Get
7157: ( p_count => x_msg_count,
7158: p_data => x_msg_data
7159: );

Line 7156: FND_MSG_PUB.Count_And_Get

7152: END IF;
7153: x_return_status := FND_API.G_RET_STS_ERROR;
7154: FND_MESSAGE.SET_NAME('CS','CS_SR_LESSER_OBJ_VERSION');
7155: FND_MSG_PUB.ADD;
7156: FND_MSG_PUB.Count_And_Get
7157: ( p_count => x_msg_count,
7158: p_data => x_msg_data
7159: );
7160:

Line 7167: FND_MSG_PUB.ADD;

7163: CLOSE l_ServiceRequest_csr;
7164: END IF;
7165: x_return_status := FND_API.G_RET_STS_SUCCESS;
7166: FND_MESSAGE.SET_NAME('CS','CS_SR_HA_NO_REPLAY');
7167: FND_MSG_PUB.ADD;
7168: FND_MSG_PUB.Count_And_Get
7169: ( p_count => x_msg_count,
7170: p_data => x_msg_data
7171: );

Line 7168: FND_MSG_PUB.Count_And_Get

7164: END IF;
7165: x_return_status := FND_API.G_RET_STS_SUCCESS;
7166: FND_MESSAGE.SET_NAME('CS','CS_SR_HA_NO_REPLAY');
7167: FND_MSG_PUB.ADD;
7168: FND_MSG_PUB.Count_And_Get
7169: ( p_count => x_msg_count,
7170: p_data => x_msg_data
7171: );
7172:

Line 7179: FND_MSG_PUB.ADD;

7175: CLOSE l_ServiceRequest_csr;
7176: END IF;
7177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7178: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_CHANGED');
7179: FND_MSG_PUB.ADD;
7180: FND_MSG_PUB.Count_And_Get
7181: ( p_count => x_msg_count,
7182: p_data => x_msg_data
7183: );

Line 7180: FND_MSG_PUB.Count_And_Get

7176: END IF;
7177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7178: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_CHANGED');
7179: FND_MSG_PUB.ADD;
7180: FND_MSG_PUB.Count_And_Get
7181: ( p_count => x_msg_count,
7182: p_data => x_msg_data
7183: );
7184:

Line 7190: FND_MSG_PUB.ADD;

7186: WHEN invalid_install_site THEN
7187: ROLLBACK TO Update_ServiceRequest_PVT;
7188: x_return_status := FND_API.G_RET_STS_ERROR;
7189: FND_MESSAGE.SET_NAME('CS','CS_SR_INVALID_INSTALL_SITE');
7190: FND_MSG_PUB.ADD;
7191: FND_MSG_PUB.Count_And_Get
7192: ( p_count => x_msg_count,
7193: p_data => x_msg_data
7194: );

Line 7191: FND_MSG_PUB.Count_And_Get

7187: ROLLBACK TO Update_ServiceRequest_PVT;
7188: x_return_status := FND_API.G_RET_STS_ERROR;
7189: FND_MESSAGE.SET_NAME('CS','CS_SR_INVALID_INSTALL_SITE');
7190: FND_MSG_PUB.ADD;
7191: FND_MSG_PUB.Count_And_Get
7192: ( p_count => x_msg_count,
7193: p_data => x_msg_data
7194: );
7195:

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

7198: IF (l_ServiceRequest_csr%ISOPEN) THEN
7199: CLOSE l_ServiceRequest_csr;
7200: END IF;
7201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7202: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7203: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7204: END IF;
7205: FND_MSG_PUB.Count_And_Get
7206: ( p_count => x_msg_count,

Line 7203: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

7199: CLOSE l_ServiceRequest_csr;
7200: END IF;
7201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7202: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7203: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7204: END IF;
7205: FND_MSG_PUB.Count_And_Get
7206: ( p_count => x_msg_count,
7207: p_data => x_msg_data

Line 7205: FND_MSG_PUB.Count_And_Get

7201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7202: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7203: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7204: END IF;
7205: FND_MSG_PUB.Count_And_Get
7206: ( p_count => x_msg_count,
7207: p_data => x_msg_data
7208: );
7209:

Line 7380: FND_MSG_PUB.initialize;

7376: END IF;
7377:
7378: -- Initialize message list if requested
7379: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7380: FND_MSG_PUB.initialize;
7381: END IF;
7382:
7383: ----------------------- FND Logging -----------------------------------
7384: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

Line 7614: FND_MSG_PUB.ADD;

7610:
7611: IF (l_sr_related_data.old_pending_approval_flag = 'Y') AND
7612: (l_sr_related_data.old_disallow_request_update = 'Y') THEN
7613: FND_MESSAGE.set_name('CS','CS_ERES_SR_FROZEN_STATUS');
7614: FND_MSG_PUB.ADD;
7615: --FND_MESSAGE.set_name('CS','CS_SR_INTERMEDIATE_STATUS');
7616: --FND_MESSAGE.set_token('API_NAME','CS_SERVICEREQUEST_PVT.update_status');
7617: --FND_MESSAGE.set_token('STATUS_ID',l_servicerequest_rec.incident_status_id);
7618: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1=>'CS_INCIDENTS_ALL_B.incident_status_id');

Line 7618: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1=>'CS_INCIDENTS_ALL_B.incident_status_id');

7614: FND_MSG_PUB.ADD;
7615: --FND_MESSAGE.set_name('CS','CS_SR_INTERMEDIATE_STATUS');
7616: --FND_MESSAGE.set_token('API_NAME','CS_SERVICEREQUEST_PVT.update_status');
7617: --FND_MESSAGE.set_token('STATUS_ID',l_servicerequest_rec.incident_status_id);
7618: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1=>'CS_INCIDENTS_ALL_B.incident_status_id');
7619: RAISE FND_API.G_EXC_ERROR;
7620: END IF; -- l_pending approval flag is Y
7621: END IF; -- if after get_status_details call
7622:

Line 7646: FND_MSG_PUB.ADD_DETAIL

7642: ( 'API_NAME'
7643: , 'CS_SERVICEREQUEST_PVT.update_status'
7644: );
7645: FND_MESSAGE.set_token('STATUS_ID',p_status_id);
7646: FND_MSG_PUB.ADD_DETAIL
7647: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_status_id'
7648: );
7649: RAISE FND_API.G_EXC_ERROR;
7650: END IF; -- l_pending approval flag is Y

Line 7816: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

7812: x_msg_data => x_msg_data
7813: );
7814:
7815: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7816: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
7817: p_data => x_msg_data );
7818: END IF;
7819: END IF; -- End of l_task_template_id is null and l_task_template_id <> -1 , if task_template_id null or -1, dont generate task
7820: END IF; -- end of p_auto_generate_tasks = 'Y'

Line 8175: FND_MSG_PUB.Count_And_Get

8171: x_msg_count => x_msg_count,
8172: x_msg_data => x_msg_data);
8173:
8174: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8175: FND_MSG_PUB.Count_And_Get
8176: ( p_count => x_msg_count,
8177: p_data => x_msg_data
8178: );
8179: END IF;

Line 8185: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

8181: IF FND_API.To_Boolean( p_commit ) THEN
8182: COMMIT WORK;
8183: END IF;
8184:
8185: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
8186: p_data => x_msg_data );
8187:
8188: EXCEPTION
8189: WHEN FND_API.G_EXC_ERROR THEN

Line 8195: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

8191: IF (l_ServiceRequest_csr%ISOPEN) THEN
8192: CLOSE l_ServiceRequest_csr;
8193: END IF;
8194: x_return_status := FND_API.G_RET_STS_ERROR;
8195: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
8196: p_data => x_msg_data );
8197:
8198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8199: ROLLBACK TO Update_Status_PVT;

Line 8204: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

8200: IF (l_ServiceRequest_csr%ISOPEN) THEN
8201: CLOSE l_ServiceRequest_csr;
8202: END IF;
8203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8204: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
8205: p_data => x_msg_data );
8206:
8207: WHEN OTHERS THEN
8208: ROLLBACK TO Update_Status_PVT;

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

8209: IF (l_ServiceRequest_csr%ISOPEN) THEN
8210: CLOSE l_ServiceRequest_csr;
8211: END IF;
8212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8213: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8214: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
8215: l_api_name );
8216: END IF;
8217: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 8214: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

8210: CLOSE l_ServiceRequest_csr;
8211: END IF;
8212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8213: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8214: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
8215: l_api_name );
8216: END IF;
8217: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
8218: p_data => x_msg_data );

Line 8217: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

8213: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8214: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
8215: l_api_name );
8216: END IF;
8217: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
8218: p_data => x_msg_data );
8219:
8220: END Update_Status;
8221:

Line 8369: FND_MSG_PUB.initialize;

8365: END IF;
8366:
8367: -- Initialize message list if requested
8368: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8369: FND_MSG_PUB.initialize;
8370: END IF;
8371:
8372: -- Initialize return status to SUCCESS
8373: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8597: FND_MSG_PUB.add_detail

8593: IF l_sr_related_data.disallow_request_update = 'Y'
8594: THEN
8595: FND_MESSAGE.set_name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
8596: FND_MESSAGE.set_token('API_NAME', l_api_name_full);
8597: FND_MSG_PUB.add_detail
8598: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.INCIDENT_OWNER_ID'
8599: );
8600: RAISE FND_API.G_EXC_ERROR;
8601: END IF;

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

8613: AND p_owner_id IS NULL)
8614: OR (l_ServiceRequest_rec.owner_group_id <> l_owner_group_id)
8615: OR (NOT (l_ServiceRequest_rec.workflow_process_id=p_workflow_process_id)))
8616: THEN
8617: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8618: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_READONLY');
8619: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
8620: FND_MSG_PUB.ADD;
8621: END IF;

Line 8620: FND_MSG_PUB.ADD;

8616: THEN
8617: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8618: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_READONLY');
8619: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
8620: FND_MSG_PUB.ADD;
8621: END IF;
8622: RAISE FND_API.G_EXC_ERROR;
8623: END IF;
8624:

Line 8907: FND_MSG_PUB.Count_And_Get

8903: x_msg_count => x_msg_count,
8904: x_msg_data => x_msg_data);
8905:
8906: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8907: FND_MSG_PUB.Count_And_Get
8908: ( p_count => x_msg_count,
8909: p_data => x_msg_data
8910: );
8911: END IF;

Line 8918: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

8914: IF FND_API.To_Boolean( p_commit ) THEN
8915: COMMIT WORK;
8916: END IF;
8917:
8918: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
8919: p_data => x_msg_data );
8920:
8921: EXCEPTION
8922: WHEN FND_API.G_EXC_ERROR THEN

Line 8931: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

8927: END IF;
8928:
8929: x_return_status := FND_API.G_RET_STS_ERROR;
8930:
8931: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
8932: p_data => x_msg_data );
8933:
8934: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8935: ROLLBACK TO Update_Owner_PVT;

Line 8943: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

8939: END IF;
8940:
8941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8942:
8943: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
8944: p_data => x_msg_data );
8945:
8946: WHEN OTHERS THEN
8947: ROLLBACK TO Update_Owner_PVT;

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

8951: END IF;
8952:
8953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8954:
8955: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8956: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name );
8957: END IF;
8958:
8959: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 8956: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name );

8952:
8953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8954:
8955: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8956: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name );
8957: END IF;
8958:
8959: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
8960: p_data => x_msg_data );

Line 8959: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

8955: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8956: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name );
8957: END IF;
8958:
8959: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
8960: p_data => x_msg_data );
8961:
8962: END Update_Owner;
8963:

Line 9007: FND_MSG_PUB.initialize;

9003: END IF;
9004:
9005: -- Initialize message list if requested
9006: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9007: FND_MSG_PUB.initialize;
9008: END IF;
9009:
9010: -- Initialize return status to SUCCESS
9011: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9992: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

9988: IF FND_API.To_Boolean( p_commit ) THEN
9989: COMMIT WORK;
9990: END IF;
9991:
9992: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
9993: p_data => x_msg_data );
9994:
9995: EXCEPTION
9996: WHEN FND_API.G_EXC_ERROR THEN

Line 9999: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

9995: EXCEPTION
9996: WHEN FND_API.G_EXC_ERROR THEN
9997: ROLLBACK TO Create_Audit_Record_PVT;
9998: x_return_status := FND_API.G_RET_STS_ERROR;
9999: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
10000: p_data => x_msg_data );
10001:
10002: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10003: ROLLBACK TO Create_Audit_Record_PVT;

Line 10005: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

10001:
10002: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10003: ROLLBACK TO Create_Audit_Record_PVT;
10004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10005: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
10006: p_data => x_msg_data );
10007:
10008: WHEN OTHERS THEN
10009: ROLLBACK TO Create_Audit_Record_PVT;

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

10007:
10008: WHEN OTHERS THEN
10009: ROLLBACK TO Create_Audit_Record_PVT;
10010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10011: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10012: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
10013: END IF;
10014: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
10015: p_data => x_msg_data );

Line 10012: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

10008: WHEN OTHERS THEN
10009: ROLLBACK TO Create_Audit_Record_PVT;
10010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10011: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10012: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
10013: END IF;
10014: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
10015: p_data => x_msg_data );
10016:

Line 10014: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

10010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10011: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10012: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
10013: END IF;
10014: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
10015: p_data => x_msg_data );
10016:
10017: END Create_Audit_Record;
10018: --------------------------------------------------------------------------

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

10286:
10287: FND_PROFILE.Get('INC_PUBLISH_FLAG_UPDATE', l_can_update) ;
10288:
10289: IF ((l_can_update = 'N' ) OR (l_can_update IS NULL)) THEN
10290: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10291: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_CANT_CHANGE_PUBLISH');
10292: FND_MESSAGE.Set_Token('API_NAME', p_api_name);
10293: FND_MSG_PUB.ADD;
10294: END IF;

Line 10293: FND_MSG_PUB.ADD;

10289: IF ((l_can_update = 'N' ) OR (l_can_update IS NULL)) THEN
10290: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
10291: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_CANT_CHANGE_PUBLISH');
10292: FND_MESSAGE.Set_Token('API_NAME', p_api_name);
10293: FND_MSG_PUB.ADD;
10294: END IF;
10295: x_return_status := FND_API.G_RET_STS_ERROR;
10296: RETURN;
10297: END IF;

Line 11128: FND_MSG_PUB.Add;

11124: p_token_p => 'p_platform_version',
11125: p_table_name => G_TABLE_NAME ,
11126: p_column_name => 'PLATFORM_VERSION');
11127:
11128: FND_MSG_PUB.Add;
11129: x_return_status := FND_API.G_RET_STS_ERROR;
11130: RETURN;
11131: END IF;
11132: --

Line 12004: fnd_msg_pub.ADD;

12000:
12001: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12002: fnd_message.set_token ('CHILD_PARAM','bill_to_account_id');
12003: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
12004: fnd_msg_pub.ADD;
12005:
12006: RAISE FND_API.G_EXC_ERROR;
12007: END IF;
12008: END IF;

Line 12021: fnd_msg_pub.ADD;

12017:
12018: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12019: fnd_message.set_token ('CHILD_PARAM','bill_to_contact_id');
12020: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
12021: fnd_msg_pub.ADD;
12022:
12023: RAISE FND_API.G_EXC_ERROR;
12024: END IF;
12025: END IF;

Line 12038: fnd_msg_pub.ADD;

12034:
12035: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12036: fnd_message.set_token ('CHILD_PARAM','bill_to_site_id');
12037: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
12038: fnd_msg_pub.ADD;
12039:
12040: RAISE FND_API.G_EXC_ERROR;
12041: END IF;
12042: END IF;

Line 12055: fnd_msg_pub.ADD;

12051:
12052: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12053: fnd_message.set_token ('CHILD_PARAM','bill_to_site_use_id');
12054: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
12055: fnd_msg_pub.ADD;
12056:
12057: RAISE FND_API.G_EXC_ERROR;
12058: END IF;
12059: END IF;

Line 12072: fnd_msg_pub.ADD;

12068:
12069: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12070: fnd_message.set_token ('CHILD_PARAM','ship_to_account_id');
12071: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
12072: fnd_msg_pub.ADD;
12073:
12074: RAISE FND_API.G_EXC_ERROR;
12075: END IF;
12076: END IF;

Line 12089: fnd_msg_pub.ADD;

12085:
12086: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12087: fnd_message.set_token ('CHILD_PARAM','ship_to_contact_id');
12088: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
12089: fnd_msg_pub.ADD;
12090:
12091: RAISE FND_API.G_EXC_ERROR;
12092: END IF;
12093: END IF;

Line 12106: fnd_msg_pub.ADD;

12102:
12103: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12104: fnd_message.set_token ('CHILD_PARAM','ship_to_site_id');
12105: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
12106: fnd_msg_pub.ADD;
12107:
12108: RAISE FND_API.G_EXC_ERROR;
12109: END IF;
12110: END IF;

Line 12123: fnd_msg_pub.ADD;

12119:
12120: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
12121: fnd_message.set_token ('CHILD_PARAM','ship_to_site_use_id');
12122: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
12123: fnd_msg_pub.ADD;
12124:
12125: RAISE FND_API.G_EXC_ERROR;
12126: END IF;
12127: END IF;

Line 15136: FND_MSG_PUB.Count_And_Get

15132: EXCEPTION
15133: WHEN FND_API.G_EXC_ERROR THEN
15134: ROLLBACK TO Create_ServiceRequest_PVT;
15135: x_return_status := FND_API.G_RET_STS_ERROR;
15136: FND_MSG_PUB.Count_And_Get
15137: ( p_count => x_msg_count,
15138: p_data => x_msg_data
15139: );
15140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 15143: FND_MSG_PUB.Count_And_Get

15139: );
15140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
15141: ROLLBACK TO Create_ServiceRequest_PVT;
15142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15143: FND_MSG_PUB.Count_And_Get
15144: ( p_count => x_msg_count,
15145: p_data => x_msg_data
15146: );
15147: WHEN OTHERS THEN

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

15146: );
15147: WHEN OTHERS THEN
15148: ROLLBACK TO Create_ServiceRequest_PVT;
15149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15150: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
15151: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
15152: END IF;
15153: FND_MSG_PUB.Count_And_Get
15154: ( p_count => x_msg_count,

Line 15151: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

15147: WHEN OTHERS THEN
15148: ROLLBACK TO Create_ServiceRequest_PVT;
15149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15150: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
15151: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
15152: END IF;
15153: FND_MSG_PUB.Count_And_Get
15154: ( p_count => x_msg_count,
15155: p_data => x_msg_data

Line 15153: FND_MSG_PUB.Count_And_Get

15149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15150: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
15151: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
15152: END IF;
15153: FND_MSG_PUB.Count_And_Get
15154: ( p_count => x_msg_count,
15155: p_data => x_msg_data
15156: );
15157:

Line 15953: FND_MSG_PUB.ADD;

15949: IF (nvl(l_service_request_rec.customer_id,-99) <> nvl(l_old_servicerequest_rec.customer_id,-99) ) THEN
15950:
15951: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_NOT_UPDATABLE');
15952: FND_MESSAGE.Set_Token('PARAM_NAME', 'Customer_id');
15953: FND_MSG_PUB.ADD;
15954: RAISE FND_API.G_EXC_ERROR;
15955: END IF; ---customer_id <> old customer_id
15956: ELSE
15957:

Line 15966: FND_MSG_PUB.ADD;

15962: IF (nvl(l_service_request_rec.customer_number,-99) <> nvl(l_old_servicerequest_rec.customer_number,-99) ) THEN
15963:
15964: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_NOT_UPDATABLE');
15965: FND_MESSAGE.Set_Token('PARAM_NAME', 'Customer_number');
15966: FND_MSG_PUB.ADD;
15967: RAISE FND_API.G_EXC_ERROR;
15968: END IF; ---customer_number <> old customer_number
15969: END IF; -- customer number is passed
15970: END IF; ----G_MISS_NUM

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

16041:
16042: IF (l_service_request_rec.type_id <> FND_API.G_MISS_NUM) AND
16043: (l_service_request_rec.type_id <> l_old_ServiceRequest_rec.incident_type_id) THEN
16044:
16045: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
16046: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_TYPE_READONLY');
16047: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16048: FND_MSG_PUB.ADD;
16049: END IF;

Line 16048: FND_MSG_PUB.ADD;

16044:
16045: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
16046: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_TYPE_READONLY');
16047: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16048: FND_MSG_PUB.ADD;
16049: END IF;
16050: RAISE FND_API.G_EXC_ERROR;
16051: END IF;
16052:

Line 16060: IF fnd_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

16056: l_old_ServiceRequest_rec.incident_owner_id IS NOT NULL) OR
16057: (l_service_request_rec.owner_group_id <> FND_API.G_MISS_NUM AND
16058: l_service_request_rec.owner_group_id <> l_old_ServiceRequest_rec.owner_group_id) THEN
16059:
16060: IF fnd_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
16061: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_READONLY');
16062: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16063: FND_MSG_PUB.ADD;
16064: END IF;

Line 16063: FND_MSG_PUB.ADD;

16059:
16060: IF fnd_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
16061: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_READONLY');
16062: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16063: FND_MSG_PUB.ADD;
16064: END IF;
16065: RAISE FND_API.G_EXC_ERROR;
16066: END IF;
16067: END IF; -- Workflow condition

Line 16223: FND_MSG_PUB.ADD_DETAIL

16219: NVL(l_service_requesT_rec.last_update_program_code,'UNKNOWN') <> 'ERES'
16220: THEN
16221: FND_MESSAGE.Set_Name('CS', 'CS_SR_APPROVAL_NEEDED');
16222: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16223: FND_MSG_PUB.ADD_DETAIL
16224: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.INCIDENT_STATUS_ID'
16225: );
16226: RAISE FND_API.G_EXC_ERROR;
16227: END IF;

Line 16247: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

16243: NVL(l_service_request_rec.owner_id,-9) <> NVL(l_old_servicerequest_rec.incident_owner_id,-9)) OR
16244: (NVL(l_service_request_rec.resource_type,'x') <> FND_API.G_MISS_CHAR AND
16245: NVL(l_service_request_rec.resource_type,'x') <> NVL(l_old_servicerequest_rec.resource_type,'x'))
16246: THEN
16247: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
16248: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_NOT_UPDATED');
16249: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16250: FND_MSG_PUB.ADD_DETAIL
16251: ( p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG

Line 16250: FND_MSG_PUB.ADD_DETAIL

16246: THEN
16247: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
16248: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_NOT_UPDATED');
16249: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16250: FND_MSG_PUB.ADD_DETAIL
16251: ( p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG
16252: , p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_owner_id'
16253: );
16254: --END IF;

Line 16251: ( p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG

16247: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
16248: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_NOT_UPDATED');
16249: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16250: FND_MSG_PUB.ADD_DETAIL
16251: ( p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG
16252: , p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_owner_id'
16253: );
16254: --END IF;
16255: END IF;

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

16302: l_cust_product_changed := 'N';
16303: END IF;
16304:
16305: IF l_cust_product_changed = 'Y' THEN
16306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
16307: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_PRODUCT_NOT_UPDATED');
16308: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16309: FND_MSG_PUB.ADD;
16310: END IF;

Line 16309: FND_MSG_PUB.ADD;

16305: IF l_cust_product_changed = 'Y' THEN
16306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
16307: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_PRODUCT_NOT_UPDATED');
16308: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16309: FND_MSG_PUB.ADD;
16310: END IF;
16311: END IF;
16312: --End of changes for bug 14242503
16313:

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

16342: l_service_request_rec.inventory_item_id := l_old_ServiceRequest_rec.inventory_item_id;
16343: l_service_request_rec.current_serial_number :=l_old_ServiceRequest_rec.current_serial_number;
16344: --Commented out below code and move the code up for bug 14242503
16345: /*
16346: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
16347: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_PRODUCT_NOT_UPDATED');
16348: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16349: FND_MSG_PUB.ADD;
16350: END IF; */

Line 16349: FND_MSG_PUB.ADD;

16345: /*
16346: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
16347: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_PRODUCT_NOT_UPDATED');
16348: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
16349: FND_MSG_PUB.ADD;
16350: END IF; */
16351: END IF;
16352: END IF; /* end of validation level check */
16353:

Line 19870: FND_MSG_PUB.Count_And_Get

19866: IF (l_ServiceRequest_csr%ISOPEN) THEN
19867: CLOSE l_ServiceRequest_csr;
19868: END IF;
19869: x_return_status := FND_API.G_RET_STS_ERROR;
19870: FND_MSG_PUB.Count_And_Get
19871: ( p_count => x_msg_count,
19872: p_data => x_msg_data
19873: );
19874:

Line 19881: FND_MSG_PUB.Count_And_Get

19877: IF (l_ServiceRequest_csr%ISOPEN) THEN
19878: CLOSE l_ServiceRequest_csr;
19879: END IF;
19880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
19881: FND_MSG_PUB.Count_And_Get
19882: ( p_count => x_msg_count,
19883: p_data => x_msg_data
19884: );
19885:

Line 19891: FND_MSG_PUB.Count_And_Get

19887: IF (l_ServiceRequest_csr%ISOPEN) THEN
19888: CLOSE l_ServiceRequest_csr;
19889: END IF;
19890: x_return_status := 'R';
19891: FND_MSG_PUB.Count_And_Get
19892: ( p_count => x_msg_count,
19893: p_data => x_msg_data
19894: );
19895:

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

19898: IF (l_ServiceRequest_csr%ISOPEN) THEN
19899: CLOSE l_ServiceRequest_csr;
19900: END IF;
19901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
19902: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
19903: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
19904: END IF;
19905: FND_MSG_PUB.Count_And_Get
19906: ( p_count => x_msg_count,

Line 19903: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

19899: CLOSE l_ServiceRequest_csr;
19900: END IF;
19901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
19902: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
19903: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
19904: END IF;
19905: FND_MSG_PUB.Count_And_Get
19906: ( p_count => x_msg_count,
19907: p_data => x_msg_data

Line 19905: FND_MSG_PUB.Count_And_Get

19901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
19902: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
19903: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
19904: END IF;
19905: FND_MSG_PUB.Count_And_Get
19906: ( p_count => x_msg_count,
19907: p_data => x_msg_data
19908: );
19909: END Update_SR_Validation;

Line 20726: FND_MSG_PUB.ADD;

20722: FETCH C INTO RECINFO;
20723: IF (C%NOTFOUND) THEN
20724: CLOSE C;
20725: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
20726: FND_MSG_PUB.ADD;
20727: APP_EXCEPTION.RAISE_EXCEPTION;
20728: END IF;
20729: CLOSE C;
20730:

Line 20735: FND_MSG_PUB.ADD;

20731: IF (RECINFO.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER) THEN
20732: NULL;
20733: ELSE
20734: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
20735: FND_MSG_PUB.ADD;
20736: APP_EXCEPTION.RAISE_EXCEPTION;
20737: END IF;
20738:
20739: END LOCK_ROW;

Line 20979: FND_MSG_PUB.Count_And_Get

20975: EXCEPTION
20976: WHEN FND_API.G_EXC_ERROR THEN
20977: ROLLBACK TO Create_ServiceRequest_PVT;
20978: x_return_status := FND_API.G_RET_STS_ERROR;
20979: FND_MSG_PUB.Count_And_Get
20980: ( p_count => x_msg_count,
20981: p_data => x_msg_data
20982: );
20983: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 20986: FND_MSG_PUB.Count_And_Get

20982: );
20983: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
20984: ROLLBACK TO Create_ServiceRequest_PVT;
20985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
20986: FND_MSG_PUB.Count_And_Get
20987: ( p_count => x_msg_count,
20988: p_data => x_msg_data
20989: );
20990: WHEN OTHERS THEN

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

20989: );
20990: WHEN OTHERS THEN
20991: ROLLBACK TO Create_ServiceRequest_PVT;
20992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
20993: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
20994: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
20995: END IF;
20996: FND_MSG_PUB.Count_And_Get
20997: ( p_count => x_msg_count,

Line 20994: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

20990: WHEN OTHERS THEN
20991: ROLLBACK TO Create_ServiceRequest_PVT;
20992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
20993: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
20994: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
20995: END IF;
20996: FND_MSG_PUB.Count_And_Get
20997: ( p_count => x_msg_count,
20998: p_data => x_msg_data

Line 20996: FND_MSG_PUB.Count_And_Get

20992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
20993: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
20994: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
20995: END IF;
20996: FND_MSG_PUB.Count_And_Get
20997: ( p_count => x_msg_count,
20998: p_data => x_msg_data
20999: );
21000:

Line 21197: FND_MSG_PUB.Count_And_Get

21193: , L_API_NAME
21194: , G_PKG_NAME
21195: )
21196: THEN
21197: FND_MSG_PUB.Count_And_Get
21198: (
21199: p_count => x_msg_count
21200: , p_data => x_msg_data
21201: );

Line 21207: FND_MSG_PUB.initialize;

21203: END IF ;
21204:
21205: IF FND_API.to_Boolean(p_init_msg_list)
21206: THEN
21207: FND_MSG_PUB.initialize;
21208: END IF ;
21209:
21210: ------------------------------------------------------------------------------
21211: -- Parameter Validations:

Line 21230: FND_MSG_PUB.ADD;

21226: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
21227: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
21228: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
21229: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
21230: FND_MSG_PUB.ADD;
21231:
21232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
21233: END IF;
21234:

Line 21258: FND_MSG_PUB.ADD;

21254: (
21255: 'CURRVAL'
21256: , NVL(p_purge_source_with_open_task, 'NULL')
21257: );
21258: FND_MSG_PUB.ADD;
21259:
21260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
21261: END IF;
21262:

Line 21282: FND_MSG_PUB.ADD;

21278: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
21279: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
21280: FND_MESSAGE.Set_Token('PARAM', 'p_audit_required');
21281: FND_MESSAGE.Set_Token('CURRVAL', NVL(p_audit_required, 'NULL'));
21282: FND_MSG_PUB.ADD;
21283:
21284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
21285: END IF;
21286:

Line 21417: x_msg_count := FND_MSG_PUB.Count_Msg;

21413: , L_LOG_MODULE || 'unexpected_error'
21414: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
21415: );
21416:
21417: x_msg_count := FND_MSG_PUB.Count_Msg;
21418:
21419: IF x_msg_count > 0
21420: THEN
21421: FOR

Line 21424: FND_MSG_PUB.Get

21420: THEN
21421: FOR
21422: i IN 1..x_msg_count
21423: LOOP
21424: FND_MSG_PUB.Get
21425: (
21426: p_msg_index => i
21427: , p_encoded => 'F'
21428: , p_data => x_msg_data

Line 21447: FND_MSG_PUB.ADD;

21443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
21444: FND_MESSAGE.Set_Name('CS', 'CS_SR_DEL_API_FAIL');
21445: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
21446: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
21447: FND_MSG_PUB.ADD;
21448:
21449: FND_MSG_PUB.Count_And_Get
21450: (
21451: p_count => x_msg_count

Line 21449: FND_MSG_PUB.Count_And_Get

21445: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
21446: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
21447: FND_MSG_PUB.ADD;
21448:
21449: FND_MSG_PUB.Count_And_Get
21450: (
21451: p_count => x_msg_count
21452: , p_data => x_msg_data
21453: );