APPS.CS_SERVICEREQUEST_PVT dependencies on FND_MSG_PUB

Line 74: FND_MSG_PUB.ADD;

70: FND_MESSAGE.set_token
71: ('P_TEXT'
72: , 'CS_SERVICEREQUEST_UTIL.get_incident_type_details'||'-'||SQLERRM
73: );
74: FND_MSG_PUB.ADD;
75: END get_incident_type_details;
76: -- -----------------------------------------------------------------------------
77: -- PROCEDURE : Get_default_contract PRIVATE
78: -- PARAMETERS: p_business_process_id Business Process associayed with incident type

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

198: (px_inp_rec.severity_id IS NULL) OR
199: (px_inp_rec.time_zone_id IS NULL) )
200: THEN
201: FND_MESSAGE.SET_NAME ('CS','CS_SR_DEF_SLA_INSUFF_PARAMS');
202: FND_MSG_PUB.ADD_DETAIL (p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG);
203: --FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
204: ELSE
205: OKS_ENTITLEMENTS_PUB.get_contracts
206: (p_api_version => 1.0,

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

199: (px_inp_rec.time_zone_id IS NULL) )
200: THEN
201: FND_MESSAGE.SET_NAME ('CS','CS_SR_DEF_SLA_INSUFF_PARAMS');
202: FND_MSG_PUB.ADD_DETAIL (p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG);
203: --FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
204: ELSE
205: OKS_ENTITLEMENTS_PUB.get_contracts
206: (p_api_version => 1.0,
207: p_init_msg_list => fnd_api.g_false ,

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

225: x_exp_resolution_date := null ;
226: x_obligation_date := null ;
227:
228: FND_MESSAGE.set_name('CS','CS_SR_UNABLE_DEF_CONTR');
229: FND_MSG_PUB.add_detail(p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG);
230: -- in case of update API, this param is always passed as NULL
231: -- so this will not execute for update API
232: IF p_default_coverage_template_id is NOT NULL
233: THEN

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

598: IF p_old_contract_service_id IS NOT NULL AND
599: NVL(p_sr_rec.contract_service_id,-99) <> p_old_contract_service_id
600: THEN
601: FND_MESSAGE.SET_NAME('CS','CS_SR_CONTRACT_ASSIGN_CHANGED');
602: FND_MSG_PUB.ADD_DETAIL(p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG);
603: END IF ;
604: END IF; -- contract service or related attributes are null
605: -- move the above part to get_default_contract
606: END IF; -- if default contrct sla ind is 'Y'

Line 612: FND_MSG_PUB.add;

608: l_contract_defaulted <> 'Y'
609: THEN
610: FND_MESSAGE.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
611: FND_MESSAGE.set_token('API_NAME', 'CS_SERVICEREQUEST_UTIL.contracts_cross_val' );
612: FND_MSG_PUB.add;
613: RAISE FND_API.G_EXC_ERROR;
614: END IF;
615: -- End of Default contract SLA processing
616: --

Line 652: FND_MSG_PUB.ADD;

648: IF p_auto_assign NOT IN ('Y','N','y','n')
649: THEN
650: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_AUTOASSIGN_PARAM');
651: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
652: FND_MSG_PUB.ADD;
653: END IF;
654: IF p_sr_rec.owner_id IS NULL AND
655: LOWER(p_auto_assign) = 'y' AND
656: NVL(p_sr_related_data.old_disallow_request_update,'N') = 'N'

Line 690: FND_MSG_PUB.Count_And_Get

686: , x_owner_group_id => l_asgn_owner_group_id
687: );
688: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
689: THEN
690: FND_MSG_PUB.Count_And_Get
691: ( p_count => l_msg_count
692: , p_data => l_msg_data
693: );
694: IF (l_orig_group_type_null = 'Y') then

Line 720: FND_MSG_PUB.ADD;

716: IF l_asgn_owner_group_id IS NULL AND l_asgn_owner_id IS NULL
717: THEN
718: FND_MESSAGE.Set_Name('CS', 'CS_SR_AM_API_RETURNED_NULL');
719: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
720: FND_MSG_PUB.ADD;
721: END IF;
722: p_sr_rec.territory_id := l_territory_id;
723: END IF; -- AM API returned with success
724: END IF; -- is call to assign_servicerequest needed?

Line 741: FND_MSG_PUB.ADD;

737: FND_MESSAGE.set_token
738: ('P_TEXT'
739: , 'CS_SERVICEREQUEST_UTIL.vldt_sr_rec'||'-'||SQLERRM
740: );
741: FND_MSG_PUB.ADD;
742: END vldt_sr_rec;
743: --============================================================================
744: -- PROCEDURE : set_time_zone PRIVATE
745: -- PARAMETERS: p_contact_party_id Contact party

Line 1041: FND_MSG_PUB.Initialize;

1037: END IF;
1038:
1039: -- Initialize message list if p_init_msg_list is set to TRUE
1040: IF FND_API.To_Boolean(p_init_msg_list) THEN
1041: FND_MSG_PUB.Initialize;
1042: END IF;
1043:
1044: -- Initialize API return status to success
1045: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1093: FND_MSG_PUB.Count_And_Get

1089: EXCEPTION
1090: WHEN FND_API.G_EXC_ERROR THEN
1091: ROLLBACK TO Create_ServiceRequest_PVT;
1092: x_return_status := FND_API.G_RET_STS_ERROR;
1093: FND_MSG_PUB.Count_And_Get
1094: ( p_count => x_msg_count,
1095: p_data => x_msg_data
1096: );
1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1100: FND_MSG_PUB.Count_And_Get

1096: );
1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1098: ROLLBACK TO Create_ServiceRequest_PVT;
1099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1100: FND_MSG_PUB.Count_And_Get
1101: ( p_count => x_msg_count,
1102: p_data => x_msg_data
1103: );
1104: WHEN OTHERS THEN

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

1103: );
1104: WHEN OTHERS THEN
1105: ROLLBACK TO Create_ServiceRequest_PVT;
1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1107: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1108: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1109: END IF;
1110: FND_MSG_PUB.Count_And_Get
1111: ( p_count => x_msg_count,

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

1104: WHEN OTHERS THEN
1105: ROLLBACK TO Create_ServiceRequest_PVT;
1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1107: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1108: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1109: END IF;
1110: FND_MSG_PUB.Count_And_Get
1111: ( p_count => x_msg_count,
1112: p_data => x_msg_data

Line 1110: FND_MSG_PUB.Count_And_Get

1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1107: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1108: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1109: END IF;
1110: FND_MSG_PUB.Count_And_Get
1111: ( p_count => x_msg_count,
1112: p_data => x_msg_data
1113: );
1114:

Line 1403: FND_MSG_PUB.Initialize;

1399: END IF;
1400:
1401: -- Initialize message list if p_init_msg_list is set to TRUE
1402: IF FND_API.To_Boolean(p_init_msg_list) THEN
1403: FND_MSG_PUB.Initialize;
1404: END IF;
1405:
1406: IF ( l_service_request_rec.initialize_flag IS NULL OR
1407: l_service_request_rec.initialize_flag <> G_INITIALIZED) THEN

Line 1502: FND_MSG_PUB.ADD_DETAIL

1498: FND_MESSAGE.set_token
1499: ( 'API_NAME'
1500: , 'CS_SERVICEREQUEST_PVT.create_servicerequest'
1501: );
1502: FND_MSG_PUB.ADD_DETAIL
1503: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.ITEM_SERIAL_NUMBER'
1504: );
1505: RAISE FND_API.G_EXC_ERROR;
1506: END IF;

Line 1561: FND_MSG_PUB.ADD_DETAIL

1557: FND_MESSAGE.set_token
1558: ( 'API_NAME'
1559: , 'CS_SERVICEREQUEST_PVT.create_servicerequest'
1560: );
1561: FND_MSG_PUB.ADD_DETAIL
1562: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.MAINT_ORGANIZATION_ID'
1563: );
1564: RAISE FND_API.G_EXC_ERROR;
1565: END IF;

Line 3046: FND_MSG_PUB.Count_And_Get

3042: /*resetting the parameter value shijain 4th dec 2002*/
3043: g_restrict_ib:=NULL;
3044:
3045: -- Standard call to get message count and if count is 1, get message info
3046: FND_MSG_PUB.Count_And_Get
3047: ( p_count => x_msg_count,
3048: p_data => x_msg_data
3049: );
3050:

Line 3116: FND_MSG_PUB.ADD;

3112:
3113: IF (p_auto_generate_tasks <> 'N' AND p_auto_generate_tasks <> 'n') THEN
3114: FND_MESSAGE.Set_Name('CS', 'CS_SR_INVALID_AUTOTASK_PARAM');
3115: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
3116: FND_MSG_PUB.ADD;
3117: END IF;
3118:
3119: End If; -- If p_auto_generate_tasks = 'Y'
3120:

Line 3141: FND_MSG_PUB.Count_And_Get

3137: x_msg_count => x_msg_count,
3138: x_msg_data => x_msg_data) ;
3139:
3140: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3141: FND_MSG_PUB.Count_And_Get
3142: ( p_count => x_msg_count,
3143: p_data => x_msg_data
3144: );
3145: END IF;

Line 3156: FND_MSG_PUB.Count_And_Get

3152: EXCEPTION
3153: WHEN FND_API.G_EXC_ERROR THEN
3154: ROLLBACK TO Create_ServiceRequest_PVT;
3155: x_return_status := FND_API.G_RET_STS_ERROR;
3156: FND_MSG_PUB.Count_And_Get
3157: ( p_count => x_msg_count,
3158: p_data => x_msg_data
3159: );
3160: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3163: FND_MSG_PUB.Count_And_Get

3159: );
3160: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3161: ROLLBACK TO Create_ServiceRequest_PVT;
3162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3163: FND_MSG_PUB.Count_And_Get
3164: ( p_count => x_msg_count,
3165: p_data => x_msg_data
3166: );
3167: WHEN Auto_Assign_Excep THEN

Line 3169: FND_MSG_PUB.Count_And_Get

3165: p_data => x_msg_data
3166: );
3167: WHEN Auto_Assign_Excep THEN
3168: x_return_status := FND_API.G_RET_STS_SUCCESS;
3169: FND_MSG_PUB.Count_And_Get
3170: ( p_count => x_msg_count,
3171: p_data => x_msg_data
3172: );
3173: --- For BUG # 2933250

Line 3178: FND_MSG_PUB.ADD;

3174: WHEN invalid_install_site THEN
3175: ROLLBACK TO Create_ServiceRequest_PVT;
3176: x_return_status := FND_API.G_RET_STS_ERROR;
3177: FND_MESSAGE.SET_NAME('CS','CS_SR_INVALID_INSTALL_SITE');
3178: FND_MSG_PUB.ADD;
3179: FND_MSG_PUB.Count_And_Get
3180: ( p_count => x_msg_count,
3181: p_data => x_msg_data
3182: );

Line 3179: FND_MSG_PUB.Count_And_Get

3175: ROLLBACK TO Create_ServiceRequest_PVT;
3176: x_return_status := FND_API.G_RET_STS_ERROR;
3177: FND_MESSAGE.SET_NAME('CS','CS_SR_INVALID_INSTALL_SITE');
3178: FND_MSG_PUB.ADD;
3179: FND_MSG_PUB.Count_And_Get
3180: ( p_count => x_msg_count,
3181: p_data => x_msg_data
3182: );
3183: WHEN OTHERS THEN

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

3182: );
3183: WHEN OTHERS THEN
3184: ROLLBACK TO Create_ServiceRequest_PVT;
3185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3186: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3187: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3188: END IF;
3189: FND_MSG_PUB.Count_And_Get
3190: ( p_count => x_msg_count,

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

3183: WHEN OTHERS THEN
3184: ROLLBACK TO Create_ServiceRequest_PVT;
3185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3186: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3187: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3188: END IF;
3189: FND_MSG_PUB.Count_And_Get
3190: ( p_count => x_msg_count,
3191: p_data => x_msg_data

Line 3189: FND_MSG_PUB.Count_And_Get

3185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3186: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3187: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3188: END IF;
3189: FND_MSG_PUB.Count_And_Get
3190: ( p_count => x_msg_count,
3191: p_data => x_msg_data
3192: );
3193:

Line 3262: FND_MSG_PUB.Initialize;

3258: -- END IF;
3259:
3260: -- Initialize message list if p_init_msg_list is set to TRUE
3261: IF FND_API.To_Boolean(p_init_msg_list) THEN
3262: FND_MSG_PUB.Initialize;
3263: END IF;
3264:
3265: -- Initialize API return status to success
3266: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3317: FND_MSG_PUB.Count_And_Get

3313: --IF (l_ServiceRequest_csr%ISOPEN) THEN
3314: -- CLOSE l_ServiceRequest_csr;
3315: -- END IF;
3316: x_return_status := FND_API.G_RET_STS_ERROR;
3317: FND_MSG_PUB.Count_And_Get
3318: ( p_count => x_msg_count,
3319: p_data => x_msg_data
3320: );
3321:

Line 3328: FND_MSG_PUB.Count_And_Get

3324: -- IF (l_ServiceRequest_csr%ISOPEN) THEN
3325: -- CLOSE l_ServiceRequest_csr;
3326: -- END IF;
3327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3328: FND_MSG_PUB.Count_And_Get
3329: ( p_count => x_msg_count,
3330: p_data => x_msg_data
3331: );
3332:

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

3335: -- IF (l_ServiceRequest_csr%ISOPEN) THEN
3336: -- CLOSE l_ServiceRequest_csr;
3337: -- END IF;
3338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3339: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3340: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3341: END IF;
3342: FND_MSG_PUB.Count_And_Get
3343: ( p_count => x_msg_count,

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

3336: -- CLOSE l_ServiceRequest_csr;
3337: -- END IF;
3338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3339: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3340: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3341: END IF;
3342: FND_MSG_PUB.Count_And_Get
3343: ( p_count => x_msg_count,
3344: p_data => x_msg_data

Line 3342: FND_MSG_PUB.Count_And_Get

3338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3339: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3340: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3341: END IF;
3342: FND_MSG_PUB.Count_And_Get
3343: ( p_count => x_msg_count,
3344: p_data => x_msg_data
3345: );
3346:

Line 3738: FND_MSG_PUB.Initialize;

3734: END IF;
3735:
3736: -- Initialize message list if p_init_msg_list is set to TRUE
3737: IF FND_API.To_Boolean(p_init_msg_list) THEN
3738: FND_MSG_PUB.Initialize;
3739: END IF;
3740:
3741: -- Initialize API return status to success
3742: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3980: FND_MSG_PUB.ADD_DETAIL

3976: FND_MESSAGE.set_token
3977: ( 'API_NAME'
3978: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
3979: );
3980: FND_MSG_PUB.ADD_DETAIL
3981: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.ITEM_SERIAL_NUMBER'
3982: );
3983: RAISE FND_API.G_EXC_ERROR;
3984: END IF;

Line 4132: FND_MSG_PUB.ADD_DETAIL

4128: FND_MESSAGE.set_token
4129: ( 'API_NAME'
4130: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4131: );
4132: FND_MSG_PUB.ADD_DETAIL
4133: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.MAINT_ORGANIZATION_ID'
4134: );
4135: RAISE FND_API.G_EXC_ERROR;
4136: END IF;

Line 4277: FND_MSG_PUB.ADD_DETAIL

4273: ( 'API_NAME'
4274: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4275: );
4276: FND_MESSAGE.set_token('STATUS_ID',l_sr_related_data.target_status_id);
4277: FND_MSG_PUB.ADD_DETAIL
4278: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_status_id'
4279: );
4280: RAISE FND_API.G_EXC_ERROR;
4281: END IF; -- l_pending approval flag is Y

Line 4302: FND_MSG_PUB.Add_Detail

4298: NVL(p_service_request_rec.last_update_program_code,'UNKOWN') <> 'ERES'
4299: THEN
4300: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
4301: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
4302: FND_MSG_PUB.Add_Detail
4303: ( p_message_type => fnd_msg_pub.G_WARNING_MSG
4304: , p_same_associated_columns => 'CS_INCIDENTS_ALL_B.INCIDENT_STATUS_ID'
4305: );
4306: IF l_old_servicerequest_rec.incident_status_id = l_service_request_rec.status_id

Line 4303: ( p_message_type => fnd_msg_pub.G_WARNING_MSG

4299: THEN
4300: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
4301: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
4302: FND_MSG_PUB.Add_Detail
4303: ( p_message_type => fnd_msg_pub.G_WARNING_MSG
4304: , p_same_associated_columns => 'CS_INCIDENTS_ALL_B.INCIDENT_STATUS_ID'
4305: );
4306: IF l_old_servicerequest_rec.incident_status_id = l_service_request_rec.status_id
4307: THEN

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

4513:
4514: -- hardcoded the version 2.0 shijain nov 27 2002
4515: -- for bug # 3640344 - pkesani added the parameter p_closed_date.
4516: -- Give a message to user
4517: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4518: THEN
4519: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
4520: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
4521: FND_MSG_PUB.Add_Detail

Line 4521: FND_MSG_PUB.Add_Detail

4517: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4518: THEN
4519: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
4520: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
4521: FND_MSG_PUB.Add_Detail
4522: ( p_message_type => fnd_msg_pub.G_WARNING_MSG
4523: , p_same_associated_columns => 'T'
4524: );
4525: END IF;

Line 4522: ( p_message_type => fnd_msg_pub.G_WARNING_MSG

4518: THEN
4519: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
4520: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
4521: FND_MSG_PUB.Add_Detail
4522: ( p_message_type => fnd_msg_pub.G_WARNING_MSG
4523: , p_same_associated_columns => 'T'
4524: );
4525: END IF;
4526:

Line 4721: FND_MSG_PUB.add;

4717: )
4718: THEN
4719: FND_MESSAGE.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
4720: FND_MESSAGE.set_token('API_NAME', 'CS_SERVICEREQUEST_UTIL.contracts_cross_val' );
4721: FND_MSG_PUB.add;
4722: RAISE FND_API.G_EXC_ERROR;
4723: END IF;
4724: END IF;
4725:

Line 6295: FND_MSG_PUB.Count_And_Get

6291: x_msg_count => x_msg_count,
6292: x_msg_data => x_msg_data);
6293:
6294: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6295: FND_MSG_PUB.Count_And_Get
6296: ( p_count => x_msg_count,
6297: p_data => x_msg_data
6298: );
6299: END IF;

Line 6312: FND_MSG_PUB.Count_And_Get (

6308: /*resetting the parameter value shijain 4th dec 2002*/
6309: g_restrict_ib:=NULL;
6310:
6311: -- Standard call to get message count and if count is 1, get message info
6312: FND_MSG_PUB.Count_And_Get (
6313: p_count => x_msg_count,
6314: p_data => x_msg_data );
6315:
6316: EXCEPTION

Line 6323: FND_MSG_PUB.Count_And_Get

6319: IF (l_ServiceRequest_csr%ISOPEN) THEN
6320: CLOSE l_ServiceRequest_csr;
6321: END IF;
6322: x_return_status := FND_API.G_RET_STS_ERROR;
6323: FND_MSG_PUB.Count_And_Get
6324: ( p_count => x_msg_count,
6325: p_data => x_msg_data
6326: );
6327:

Line 6334: FND_MSG_PUB.Count_And_Get

6330: IF (l_ServiceRequest_csr%ISOPEN) THEN
6331: CLOSE l_ServiceRequest_csr;
6332: END IF;
6333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6334: FND_MSG_PUB.Count_And_Get
6335: ( p_count => x_msg_count,
6336: p_data => x_msg_data
6337: );
6338:

Line 6349: FND_MSG_PUB.ADD;

6345: ELSE
6346: x_return_status := FND_API.G_RET_STS_ERROR;
6347: END IF;
6348: FND_MESSAGE.SET_NAME('CS','CS_SR_DESTINATION_UPDATED');
6349: FND_MSG_PUB.ADD;
6350: FND_MSG_PUB.Count_And_Get
6351: ( p_count => x_msg_count,
6352: p_data => x_msg_data
6353: );

Line 6350: FND_MSG_PUB.Count_And_Get

6346: x_return_status := FND_API.G_RET_STS_ERROR;
6347: END IF;
6348: FND_MESSAGE.SET_NAME('CS','CS_SR_DESTINATION_UPDATED');
6349: FND_MSG_PUB.ADD;
6350: FND_MSG_PUB.Count_And_Get
6351: ( p_count => x_msg_count,
6352: p_data => x_msg_data
6353: );
6354:

Line 6361: FND_MSG_PUB.ADD;

6357: CLOSE l_ServiceRequest_csr;
6358: END IF;
6359: x_return_status := FND_API.G_RET_STS_ERROR;
6360: FND_MESSAGE.SET_NAME('CS','CS_SR_LESSER_OBJ_VERSION');
6361: FND_MSG_PUB.ADD;
6362: FND_MSG_PUB.Count_And_Get
6363: ( p_count => x_msg_count,
6364: p_data => x_msg_data
6365: );

Line 6362: FND_MSG_PUB.Count_And_Get

6358: END IF;
6359: x_return_status := FND_API.G_RET_STS_ERROR;
6360: FND_MESSAGE.SET_NAME('CS','CS_SR_LESSER_OBJ_VERSION');
6361: FND_MSG_PUB.ADD;
6362: FND_MSG_PUB.Count_And_Get
6363: ( p_count => x_msg_count,
6364: p_data => x_msg_data
6365: );
6366:

Line 6373: FND_MSG_PUB.ADD;

6369: CLOSE l_ServiceRequest_csr;
6370: END IF;
6371: x_return_status := FND_API.G_RET_STS_SUCCESS;
6372: FND_MESSAGE.SET_NAME('CS','CS_SR_HA_NO_REPLAY');
6373: FND_MSG_PUB.ADD;
6374: FND_MSG_PUB.Count_And_Get
6375: ( p_count => x_msg_count,
6376: p_data => x_msg_data
6377: );

Line 6374: FND_MSG_PUB.Count_And_Get

6370: END IF;
6371: x_return_status := FND_API.G_RET_STS_SUCCESS;
6372: FND_MESSAGE.SET_NAME('CS','CS_SR_HA_NO_REPLAY');
6373: FND_MSG_PUB.ADD;
6374: FND_MSG_PUB.Count_And_Get
6375: ( p_count => x_msg_count,
6376: p_data => x_msg_data
6377: );
6378:

Line 6385: FND_MSG_PUB.ADD;

6381: CLOSE l_ServiceRequest_csr;
6382: END IF;
6383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6384: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_CHANGED');
6385: FND_MSG_PUB.ADD;
6386: FND_MSG_PUB.Count_And_Get
6387: ( p_count => x_msg_count,
6388: p_data => x_msg_data
6389: );

Line 6386: FND_MSG_PUB.Count_And_Get

6382: END IF;
6383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6384: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_CHANGED');
6385: FND_MSG_PUB.ADD;
6386: FND_MSG_PUB.Count_And_Get
6387: ( p_count => x_msg_count,
6388: p_data => x_msg_data
6389: );
6390:

Line 6396: FND_MSG_PUB.ADD;

6392: WHEN invalid_install_site THEN
6393: ROLLBACK TO Update_ServiceRequest_PVT;
6394: x_return_status := FND_API.G_RET_STS_ERROR;
6395: FND_MESSAGE.SET_NAME('CS','CS_SR_INVALID_INSTALL_SITE');
6396: FND_MSG_PUB.ADD;
6397: FND_MSG_PUB.Count_And_Get
6398: ( p_count => x_msg_count,
6399: p_data => x_msg_data
6400: );

Line 6397: FND_MSG_PUB.Count_And_Get

6393: ROLLBACK TO Update_ServiceRequest_PVT;
6394: x_return_status := FND_API.G_RET_STS_ERROR;
6395: FND_MESSAGE.SET_NAME('CS','CS_SR_INVALID_INSTALL_SITE');
6396: FND_MSG_PUB.ADD;
6397: FND_MSG_PUB.Count_And_Get
6398: ( p_count => x_msg_count,
6399: p_data => x_msg_data
6400: );
6401:

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

6404: IF (l_ServiceRequest_csr%ISOPEN) THEN
6405: CLOSE l_ServiceRequest_csr;
6406: END IF;
6407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6408: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6409: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6410: END IF;
6411: FND_MSG_PUB.Count_And_Get
6412: ( p_count => x_msg_count,

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

6405: CLOSE l_ServiceRequest_csr;
6406: END IF;
6407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6408: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6409: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6410: END IF;
6411: FND_MSG_PUB.Count_And_Get
6412: ( p_count => x_msg_count,
6413: p_data => x_msg_data

Line 6411: FND_MSG_PUB.Count_And_Get

6407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6408: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6409: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6410: END IF;
6411: FND_MSG_PUB.Count_And_Get
6412: ( p_count => x_msg_count,
6413: p_data => x_msg_data
6414: );
6415:

Line 6571: FND_MSG_PUB.initialize;

6567: END IF;
6568:
6569: -- Initialize message list if requested
6570: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6571: FND_MSG_PUB.initialize;
6572: END IF;
6573:
6574: ----------------------- FND Logging -----------------------------------
6575: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

Line 6800: FND_MSG_PUB.ADD;

6796:
6797: IF (l_sr_related_data.old_pending_approval_flag = 'Y') AND
6798: (l_sr_related_data.old_disallow_request_update = 'Y') THEN
6799: FND_MESSAGE.set_name('CS','CS_ERES_SR_FROZEN_STATUS');
6800: FND_MSG_PUB.ADD;
6801: --FND_MESSAGE.set_name('CS','CS_SR_INTERMEDIATE_STATUS');
6802: --FND_MESSAGE.set_token('API_NAME','CS_SERVICEREQUEST_PVT.update_status');
6803: --FND_MESSAGE.set_token('STATUS_ID',l_servicerequest_rec.incident_status_id);
6804: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1=>'CS_INCIDENTS_ALL_B.incident_status_id');

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

6800: FND_MSG_PUB.ADD;
6801: --FND_MESSAGE.set_name('CS','CS_SR_INTERMEDIATE_STATUS');
6802: --FND_MESSAGE.set_token('API_NAME','CS_SERVICEREQUEST_PVT.update_status');
6803: --FND_MESSAGE.set_token('STATUS_ID',l_servicerequest_rec.incident_status_id);
6804: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1=>'CS_INCIDENTS_ALL_B.incident_status_id');
6805: RAISE FND_API.G_EXC_ERROR;
6806: END IF; -- l_pending approval flag is Y
6807: END IF; -- if after get_status_details call
6808:

Line 6832: FND_MSG_PUB.ADD_DETAIL

6828: ( 'API_NAME'
6829: , 'CS_SERVICEREQUEST_PVT.update_status'
6830: );
6831: FND_MESSAGE.set_token('STATUS_ID',p_status_id);
6832: FND_MSG_PUB.ADD_DETAIL
6833: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_status_id'
6834: );
6835: RAISE FND_API.G_EXC_ERROR;
6836: END IF; -- l_pending approval flag is Y

Line 7233: FND_MSG_PUB.Count_And_Get

7229: x_msg_count => x_msg_count,
7230: x_msg_data => x_msg_data);
7231:
7232: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7233: FND_MSG_PUB.Count_And_Get
7234: ( p_count => x_msg_count,
7235: p_data => x_msg_data
7236: );
7237: END IF;

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

7239: IF FND_API.To_Boolean( p_commit ) THEN
7240: COMMIT WORK;
7241: END IF;
7242:
7243: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
7244: p_data => x_msg_data );
7245:
7246: EXCEPTION
7247: WHEN FND_API.G_EXC_ERROR THEN

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

7249: IF (l_ServiceRequest_csr%ISOPEN) THEN
7250: CLOSE l_ServiceRequest_csr;
7251: END IF;
7252: x_return_status := FND_API.G_RET_STS_ERROR;
7253: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
7254: p_data => x_msg_data );
7255:
7256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7257: ROLLBACK TO Update_Status_PVT;

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

7258: IF (l_ServiceRequest_csr%ISOPEN) THEN
7259: CLOSE l_ServiceRequest_csr;
7260: END IF;
7261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7262: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
7263: p_data => x_msg_data );
7264:
7265: WHEN OTHERS THEN
7266: ROLLBACK TO Update_Status_PVT;

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

7267: IF (l_ServiceRequest_csr%ISOPEN) THEN
7268: CLOSE l_ServiceRequest_csr;
7269: END IF;
7270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7271: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7272: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
7273: l_api_name );
7274: END IF;
7275: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 7272: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

7268: CLOSE l_ServiceRequest_csr;
7269: END IF;
7270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7271: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7272: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
7273: l_api_name );
7274: END IF;
7275: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
7276: p_data => x_msg_data );

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

7271: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7272: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
7273: l_api_name );
7274: END IF;
7275: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
7276: p_data => x_msg_data );
7277:
7278: END Update_Status;
7279:

Line 7427: FND_MSG_PUB.initialize;

7423: END IF;
7424:
7425: -- Initialize message list if requested
7426: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7427: FND_MSG_PUB.initialize;
7428: END IF;
7429:
7430: -- Initialize return status to SUCCESS
7431: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7655: FND_MSG_PUB.add_detail

7651: IF l_sr_related_data.disallow_request_update = 'Y'
7652: THEN
7653: FND_MESSAGE.set_name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
7654: FND_MESSAGE.set_token('API_NAME', l_api_name_full);
7655: FND_MSG_PUB.add_detail
7656: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.INCIDENT_OWNER_ID'
7657: );
7658: RAISE FND_API.G_EXC_ERROR;
7659: END IF;

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

7671: AND p_owner_id IS NULL)
7672: OR (l_ServiceRequest_rec.owner_group_id <> l_owner_group_id)
7673: OR (NOT (l_ServiceRequest_rec.workflow_process_id=p_workflow_process_id)))
7674: THEN
7675: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7676: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_READONLY');
7677: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
7678: FND_MSG_PUB.ADD;
7679: END IF;

Line 7678: FND_MSG_PUB.ADD;

7674: THEN
7675: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7676: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_READONLY');
7677: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
7678: FND_MSG_PUB.ADD;
7679: END IF;
7680: RAISE FND_API.G_EXC_ERROR;
7681: END IF;
7682:

Line 7965: FND_MSG_PUB.Count_And_Get

7961: x_msg_count => x_msg_count,
7962: x_msg_data => x_msg_data);
7963:
7964: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7965: FND_MSG_PUB.Count_And_Get
7966: ( p_count => x_msg_count,
7967: p_data => x_msg_data
7968: );
7969: END IF;

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

7972: IF FND_API.To_Boolean( p_commit ) THEN
7973: COMMIT WORK;
7974: END IF;
7975:
7976: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
7977: p_data => x_msg_data );
7978:
7979: EXCEPTION
7980: WHEN FND_API.G_EXC_ERROR THEN

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

7985: END IF;
7986:
7987: x_return_status := FND_API.G_RET_STS_ERROR;
7988:
7989: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
7990: p_data => x_msg_data );
7991:
7992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7993: ROLLBACK TO Update_Owner_PVT;

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

7997: END IF;
7998:
7999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8000:
8001: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
8002: p_data => x_msg_data );
8003:
8004: WHEN OTHERS THEN
8005: ROLLBACK TO Update_Owner_PVT;

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

8009: END IF;
8010:
8011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8012:
8013: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8014: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name );
8015: END IF;
8016:
8017: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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

8010:
8011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8012:
8013: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8014: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name );
8015: END IF;
8016:
8017: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
8018: p_data => x_msg_data );

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

8013: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8014: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name );
8015: END IF;
8016:
8017: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
8018: p_data => x_msg_data );
8019:
8020: END Update_Owner;
8021:

Line 8065: FND_MSG_PUB.initialize;

8061: END IF;
8062:
8063: -- Initialize message list if requested
8064: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8065: FND_MSG_PUB.initialize;
8066: END IF;
8067:
8068: -- Initialize return status to SUCCESS
8069: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

8976: IF FND_API.To_Boolean( p_commit ) THEN
8977: COMMIT WORK;
8978: END IF;
8979:
8980: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
8981: p_data => x_msg_data );
8982:
8983: EXCEPTION
8984: WHEN FND_API.G_EXC_ERROR THEN

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

8983: EXCEPTION
8984: WHEN FND_API.G_EXC_ERROR THEN
8985: ROLLBACK TO Create_Audit_Record_PVT;
8986: x_return_status := FND_API.G_RET_STS_ERROR;
8987: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
8988: p_data => x_msg_data );
8989:
8990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8991: ROLLBACK TO Create_Audit_Record_PVT;

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

8989:
8990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8991: ROLLBACK TO Create_Audit_Record_PVT;
8992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8993: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
8994: p_data => x_msg_data );
8995:
8996: WHEN OTHERS THEN
8997: ROLLBACK TO Create_Audit_Record_PVT;

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

8995:
8996: WHEN OTHERS THEN
8997: ROLLBACK TO Create_Audit_Record_PVT;
8998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8999: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9000: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
9001: END IF;
9002: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
9003: p_data => x_msg_data );

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

8996: WHEN OTHERS THEN
8997: ROLLBACK TO Create_Audit_Record_PVT;
8998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8999: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9000: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
9001: END IF;
9002: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
9003: p_data => x_msg_data );
9004:

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

8998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8999: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9000: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
9001: END IF;
9002: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
9003: p_data => x_msg_data );
9004:
9005: END Create_Audit_Record;
9006: --------------------------------------------------------------------------

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

9274:
9275: FND_PROFILE.Get('INC_PUBLISH_FLAG_UPDATE', l_can_update) ;
9276:
9277: IF ((l_can_update = 'N' ) OR (l_can_update IS NULL)) THEN
9278: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9279: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_CANT_CHANGE_PUBLISH');
9280: FND_MESSAGE.Set_Token('API_NAME', p_api_name);
9281: FND_MSG_PUB.ADD;
9282: END IF;

Line 9281: FND_MSG_PUB.ADD;

9277: IF ((l_can_update = 'N' ) OR (l_can_update IS NULL)) THEN
9278: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9279: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_CANT_CHANGE_PUBLISH');
9280: FND_MESSAGE.Set_Token('API_NAME', p_api_name);
9281: FND_MSG_PUB.ADD;
9282: END IF;
9283: x_return_status := FND_API.G_RET_STS_ERROR;
9284: RETURN;
9285: END IF;

Line 10116: FND_MSG_PUB.Add;

10112: p_token_p => 'p_platform_version',
10113: p_table_name => G_TABLE_NAME ,
10114: p_column_name => 'PLATFORM_VERSION');
10115:
10116: FND_MSG_PUB.Add;
10117: x_return_status := FND_API.G_RET_STS_ERROR;
10118: RETURN;
10119: END IF;
10120: --

Line 10973: fnd_msg_pub.ADD;

10969:
10970: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
10971: fnd_message.set_token ('CHILD_PARAM','bill_to_account_id');
10972: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
10973: fnd_msg_pub.ADD;
10974:
10975: RAISE FND_API.G_EXC_ERROR;
10976: END IF;
10977: END IF;

Line 10990: fnd_msg_pub.ADD;

10986:
10987: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
10988: fnd_message.set_token ('CHILD_PARAM','bill_to_contact_id');
10989: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
10990: fnd_msg_pub.ADD;
10991:
10992: RAISE FND_API.G_EXC_ERROR;
10993: END IF;
10994: END IF;

Line 11007: fnd_msg_pub.ADD;

11003:
11004: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11005: fnd_message.set_token ('CHILD_PARAM','bill_to_site_id');
11006: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
11007: fnd_msg_pub.ADD;
11008:
11009: RAISE FND_API.G_EXC_ERROR;
11010: END IF;
11011: END IF;

Line 11024: fnd_msg_pub.ADD;

11020:
11021: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11022: fnd_message.set_token ('CHILD_PARAM','bill_to_site_use_id');
11023: fnd_message.set_token ('PARENT_PARAM','bill_to_party_id');
11024: fnd_msg_pub.ADD;
11025:
11026: RAISE FND_API.G_EXC_ERROR;
11027: END IF;
11028: END IF;

Line 11041: fnd_msg_pub.ADD;

11037:
11038: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11039: fnd_message.set_token ('CHILD_PARAM','ship_to_account_id');
11040: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
11041: fnd_msg_pub.ADD;
11042:
11043: RAISE FND_API.G_EXC_ERROR;
11044: END IF;
11045: END IF;

Line 11058: fnd_msg_pub.ADD;

11054:
11055: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11056: fnd_message.set_token ('CHILD_PARAM','ship_to_contact_id');
11057: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
11058: fnd_msg_pub.ADD;
11059:
11060: RAISE FND_API.G_EXC_ERROR;
11061: END IF;
11062: END IF;

Line 11075: fnd_msg_pub.ADD;

11071:
11072: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11073: fnd_message.set_token ('CHILD_PARAM','ship_to_site_id');
11074: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
11075: fnd_msg_pub.ADD;
11076:
11077: RAISE FND_API.G_EXC_ERROR;
11078: END IF;
11079: END IF;

Line 11092: fnd_msg_pub.ADD;

11088:
11089: fnd_message.set_name ('CS', 'CS_SR_PARENT_CHILD_CHECK');
11090: fnd_message.set_token ('CHILD_PARAM','ship_to_site_use_id');
11091: fnd_message.set_token ('PARENT_PARAM','ship_to_party_id');
11092: fnd_msg_pub.ADD;
11093:
11094: RAISE FND_API.G_EXC_ERROR;
11095: END IF;
11096: END IF;

Line 13941: FND_MSG_PUB.Count_And_Get

13937: EXCEPTION
13938: WHEN FND_API.G_EXC_ERROR THEN
13939: ROLLBACK TO Create_ServiceRequest_PVT;
13940: x_return_status := FND_API.G_RET_STS_ERROR;
13941: FND_MSG_PUB.Count_And_Get
13942: ( p_count => x_msg_count,
13943: p_data => x_msg_data
13944: );
13945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 13948: FND_MSG_PUB.Count_And_Get

13944: );
13945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13946: ROLLBACK TO Create_ServiceRequest_PVT;
13947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13948: FND_MSG_PUB.Count_And_Get
13949: ( p_count => x_msg_count,
13950: p_data => x_msg_data
13951: );
13952: WHEN OTHERS THEN

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

13951: );
13952: WHEN OTHERS THEN
13953: ROLLBACK TO Create_ServiceRequest_PVT;
13954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13955: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
13956: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
13957: END IF;
13958: FND_MSG_PUB.Count_And_Get
13959: ( p_count => x_msg_count,

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

13952: WHEN OTHERS THEN
13953: ROLLBACK TO Create_ServiceRequest_PVT;
13954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13955: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
13956: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
13957: END IF;
13958: FND_MSG_PUB.Count_And_Get
13959: ( p_count => x_msg_count,
13960: p_data => x_msg_data

Line 13958: FND_MSG_PUB.Count_And_Get

13954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13955: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
13956: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
13957: END IF;
13958: FND_MSG_PUB.Count_And_Get
13959: ( p_count => x_msg_count,
13960: p_data => x_msg_data
13961: );
13962:

Line 14743: FND_MSG_PUB.ADD;

14739: IF (nvl(l_service_request_rec.customer_id,-99) <> nvl(l_old_servicerequest_rec.customer_id,-99) ) THEN
14740:
14741: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_NOT_UPDATABLE');
14742: FND_MESSAGE.Set_Token('PARAM_NAME', 'Customer_id');
14743: FND_MSG_PUB.ADD;
14744: RAISE FND_API.G_EXC_ERROR;
14745: END IF; ---customer_id <> old customer_id
14746: ELSE
14747:

Line 14756: FND_MSG_PUB.ADD;

14752: IF (nvl(l_service_request_rec.customer_number,-99) <> nvl(l_old_servicerequest_rec.customer_number,-99) ) THEN
14753:
14754: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_NOT_UPDATABLE');
14755: FND_MESSAGE.Set_Token('PARAM_NAME', 'Customer_number');
14756: FND_MSG_PUB.ADD;
14757: RAISE FND_API.G_EXC_ERROR;
14758: END IF; ---customer_number <> old customer_number
14759: END IF; -- customer number is passed
14760: END IF; ----G_MISS_NUM

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

14831:
14832: IF (l_service_request_rec.type_id <> FND_API.G_MISS_NUM) AND
14833: (l_service_request_rec.type_id <> l_old_ServiceRequest_rec.incident_type_id) THEN
14834:
14835: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14836: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_TYPE_READONLY');
14837: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
14838: FND_MSG_PUB.ADD;
14839: END IF;

Line 14838: FND_MSG_PUB.ADD;

14834:
14835: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14836: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_TYPE_READONLY');
14837: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
14838: FND_MSG_PUB.ADD;
14839: END IF;
14840: RAISE FND_API.G_EXC_ERROR;
14841: END IF;
14842:

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

14846: l_old_ServiceRequest_rec.incident_owner_id IS NOT NULL) OR
14847: (l_service_request_rec.owner_group_id <> FND_API.G_MISS_NUM AND
14848: l_service_request_rec.owner_group_id <> l_old_ServiceRequest_rec.owner_group_id) THEN
14849:
14850: IF fnd_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14851: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_READONLY');
14852: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
14853: FND_MSG_PUB.ADD;
14854: END IF;

Line 14853: FND_MSG_PUB.ADD;

14849:
14850: IF fnd_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
14851: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_READONLY');
14852: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
14853: FND_MSG_PUB.ADD;
14854: END IF;
14855: RAISE FND_API.G_EXC_ERROR;
14856: END IF;
14857: END IF; -- Workflow condition

Line 15013: FND_MSG_PUB.ADD_DETAIL

15009: NVL(l_service_requesT_rec.last_update_program_code,'UNKNOWN') <> 'ERES'
15010: THEN
15011: FND_MESSAGE.Set_Name('CS', 'CS_SR_APPROVAL_NEEDED');
15012: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
15013: FND_MSG_PUB.ADD_DETAIL
15014: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.INCIDENT_STATUS_ID'
15015: );
15016: RAISE FND_API.G_EXC_ERROR;
15017: END IF;

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

15033: NVL(l_service_request_rec.owner_id,-9) <> NVL(l_old_servicerequest_rec.incident_owner_id,-9)) OR
15034: (NVL(l_service_request_rec.resource_type,'x') <> FND_API.G_MISS_CHAR AND
15035: NVL(l_service_request_rec.resource_type,'x') <> NVL(l_old_servicerequest_rec.resource_type,'x'))
15036: THEN
15037: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
15038: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_NOT_UPDATED');
15039: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
15040: FND_MSG_PUB.ADD_DETAIL
15041: ( p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG

Line 15040: FND_MSG_PUB.ADD_DETAIL

15036: THEN
15037: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
15038: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_NOT_UPDATED');
15039: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
15040: FND_MSG_PUB.ADD_DETAIL
15041: ( p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG
15042: , p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_owner_id'
15043: );
15044: --END IF;

Line 15041: ( p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG

15037: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
15038: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_NOT_UPDATED');
15039: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
15040: FND_MSG_PUB.ADD_DETAIL
15041: ( p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG
15042: , p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_owner_id'
15043: );
15044: --END IF;
15045: END IF;

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

15077: --These are fields which will have value irrespective of Installed base or not.
15078: l_service_request_rec.inventory_item_id := l_old_ServiceRequest_rec.inventory_item_id;
15079: l_service_request_rec.current_serial_number :=l_old_ServiceRequest_rec.current_serial_number;
15080:
15081: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
15082: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_PRODUCT_NOT_UPDATED');
15083: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
15084: FND_MSG_PUB.ADD;
15085: END IF;

Line 15084: FND_MSG_PUB.ADD;

15080:
15081: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
15082: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_PRODUCT_NOT_UPDATED');
15083: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
15084: FND_MSG_PUB.ADD;
15085: END IF;
15086: END IF;
15087: END IF; /* end of validation level check */
15088:

Line 18391: FND_MSG_PUB.Count_And_Get

18387: IF (l_ServiceRequest_csr%ISOPEN) THEN
18388: CLOSE l_ServiceRequest_csr;
18389: END IF;
18390: x_return_status := FND_API.G_RET_STS_ERROR;
18391: FND_MSG_PUB.Count_And_Get
18392: ( p_count => x_msg_count,
18393: p_data => x_msg_data
18394: );
18395:

Line 18402: FND_MSG_PUB.Count_And_Get

18398: IF (l_ServiceRequest_csr%ISOPEN) THEN
18399: CLOSE l_ServiceRequest_csr;
18400: END IF;
18401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
18402: FND_MSG_PUB.Count_And_Get
18403: ( p_count => x_msg_count,
18404: p_data => x_msg_data
18405: );
18406:

Line 18412: FND_MSG_PUB.Count_And_Get

18408: IF (l_ServiceRequest_csr%ISOPEN) THEN
18409: CLOSE l_ServiceRequest_csr;
18410: END IF;
18411: x_return_status := 'R';
18412: FND_MSG_PUB.Count_And_Get
18413: ( p_count => x_msg_count,
18414: p_data => x_msg_data
18415: );
18416:

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

18419: IF (l_ServiceRequest_csr%ISOPEN) THEN
18420: CLOSE l_ServiceRequest_csr;
18421: END IF;
18422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
18423: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
18424: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
18425: END IF;
18426: FND_MSG_PUB.Count_And_Get
18427: ( p_count => x_msg_count,

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

18420: CLOSE l_ServiceRequest_csr;
18421: END IF;
18422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
18423: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
18424: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
18425: END IF;
18426: FND_MSG_PUB.Count_And_Get
18427: ( p_count => x_msg_count,
18428: p_data => x_msg_data

Line 18426: FND_MSG_PUB.Count_And_Get

18422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
18423: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
18424: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
18425: END IF;
18426: FND_MSG_PUB.Count_And_Get
18427: ( p_count => x_msg_count,
18428: p_data => x_msg_data
18429: );
18430: END Update_SR_Validation;

Line 19210: FND_MSG_PUB.ADD;

19206: FETCH C INTO RECINFO;
19207: IF (C%NOTFOUND) THEN
19208: CLOSE C;
19209: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
19210: FND_MSG_PUB.ADD;
19211: APP_EXCEPTION.RAISE_EXCEPTION;
19212: END IF;
19213: CLOSE C;
19214:

Line 19219: FND_MSG_PUB.ADD;

19215: IF (RECINFO.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER) THEN
19216: NULL;
19217: ELSE
19218: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
19219: FND_MSG_PUB.ADD;
19220: APP_EXCEPTION.RAISE_EXCEPTION;
19221: END IF;
19222:
19223: END LOCK_ROW;

Line 19463: FND_MSG_PUB.Count_And_Get

19459: EXCEPTION
19460: WHEN FND_API.G_EXC_ERROR THEN
19461: ROLLBACK TO Create_ServiceRequest_PVT;
19462: x_return_status := FND_API.G_RET_STS_ERROR;
19463: FND_MSG_PUB.Count_And_Get
19464: ( p_count => x_msg_count,
19465: p_data => x_msg_data
19466: );
19467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 19470: FND_MSG_PUB.Count_And_Get

19466: );
19467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
19468: ROLLBACK TO Create_ServiceRequest_PVT;
19469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
19470: FND_MSG_PUB.Count_And_Get
19471: ( p_count => x_msg_count,
19472: p_data => x_msg_data
19473: );
19474: WHEN OTHERS THEN

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

19473: );
19474: WHEN OTHERS THEN
19475: ROLLBACK TO Create_ServiceRequest_PVT;
19476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
19477: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
19478: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
19479: END IF;
19480: FND_MSG_PUB.Count_And_Get
19481: ( p_count => x_msg_count,

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

19474: WHEN OTHERS THEN
19475: ROLLBACK TO Create_ServiceRequest_PVT;
19476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
19477: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
19478: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
19479: END IF;
19480: FND_MSG_PUB.Count_And_Get
19481: ( p_count => x_msg_count,
19482: p_data => x_msg_data

Line 19480: FND_MSG_PUB.Count_And_Get

19476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
19477: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
19478: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
19479: END IF;
19480: FND_MSG_PUB.Count_And_Get
19481: ( p_count => x_msg_count,
19482: p_data => x_msg_data
19483: );
19484:

Line 19681: FND_MSG_PUB.Count_And_Get

19677: , L_API_NAME
19678: , G_PKG_NAME
19679: )
19680: THEN
19681: FND_MSG_PUB.Count_And_Get
19682: (
19683: p_count => x_msg_count
19684: , p_data => x_msg_data
19685: );

Line 19691: FND_MSG_PUB.initialize;

19687: END IF ;
19688:
19689: IF FND_API.to_Boolean(p_init_msg_list)
19690: THEN
19691: FND_MSG_PUB.initialize;
19692: END IF ;
19693:
19694: ------------------------------------------------------------------------------
19695: -- Parameter Validations:

Line 19714: FND_MSG_PUB.ADD;

19710: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
19711: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
19712: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
19713: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
19714: FND_MSG_PUB.ADD;
19715:
19716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
19717: END IF;
19718:

Line 19742: FND_MSG_PUB.ADD;

19738: (
19739: 'CURRVAL'
19740: , NVL(p_purge_source_with_open_task, 'NULL')
19741: );
19742: FND_MSG_PUB.ADD;
19743:
19744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
19745: END IF;
19746:

Line 19766: FND_MSG_PUB.ADD;

19762: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
19763: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
19764: FND_MESSAGE.Set_Token('PARAM', 'p_audit_required');
19765: FND_MESSAGE.Set_Token('CURRVAL', NVL(p_audit_required, 'NULL'));
19766: FND_MSG_PUB.ADD;
19767:
19768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
19769: END IF;
19770:

Line 19899: x_msg_count := FND_MSG_PUB.Count_Msg;

19895: , L_LOG_MODULE || 'unexpected_error'
19896: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
19897: );
19898:
19899: x_msg_count := FND_MSG_PUB.Count_Msg;
19900:
19901: IF x_msg_count > 0
19902: THEN
19903: FOR

Line 19906: FND_MSG_PUB.Get

19902: THEN
19903: FOR
19904: i IN 1..x_msg_count
19905: LOOP
19906: FND_MSG_PUB.Get
19907: (
19908: p_msg_index => i
19909: , p_encoded => 'F'
19910: , p_data => x_msg_data

Line 19929: FND_MSG_PUB.ADD;

19925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
19926: FND_MESSAGE.Set_Name('CS', 'CS_SR_DEL_API_FAIL');
19927: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
19928: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
19929: FND_MSG_PUB.ADD;
19930:
19931: FND_MSG_PUB.Count_And_Get
19932: (
19933: p_count => x_msg_count

Line 19931: FND_MSG_PUB.Count_And_Get

19927: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
19928: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
19929: FND_MSG_PUB.ADD;
19930:
19931: FND_MSG_PUB.Count_And_Get
19932: (
19933: p_count => x_msg_count
19934: , p_data => x_msg_data
19935: );