DBA Data[Home] [Help]

APPS.PV_PRGM_APPROVAL_PVT dependencies on FND_MSG_PUB

Line 39: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

35: g_program_mode CONSTANT VARCHAR2 (15) := 'WORKFLOW';
36: g_isApproverInList boolean:=false;
37: g_approver_response VARCHAR2(30):=NULL;
38:
39: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
40: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
41: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
42:
43: PROCEDURE Write_Log(p_which number, p_mssg varchar2) IS

Line 40: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

36: g_isApproverInList boolean:=false;
37: g_approver_response VARCHAR2(30):=NULL;
38:
39: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
40: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
41: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
42:
43: PROCEDURE Write_Log(p_which number, p_mssg varchar2) IS
44: BEGIN

Line 41: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

37: g_approver_response VARCHAR2(30):=NULL;
38:
39: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
40: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
41: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
42:
43: PROCEDURE Write_Log(p_which number, p_mssg varchar2) IS
44: BEGIN
45: FND_FILE.put(p_which, p_mssg);

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

417:
418: EXCEPTION
419: WHEN OTHERS THEN
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
422: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
423: END IF;
424: -- Standard call to get message count and if count=1, get the message
425: FND_MSG_PUB.Count_And_Get (

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

418: EXCEPTION
419: WHEN OTHERS THEN
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
422: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
423: END IF;
424: -- Standard call to get message count and if count=1, get the message
425: FND_MSG_PUB.Count_And_Get (
426: p_encoded => FND_API.G_FALSE

Line 425: FND_MSG_PUB.Count_And_Get (

421: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
422: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
423: END IF;
424: -- Standard call to get message count and if count=1, get the message
425: FND_MSG_PUB.Count_And_Get (
426: p_encoded => FND_API.G_FALSE
427: ,p_count => x_msg_count
428: ,p_data => x_msg_data
429: );

Line 1600: fnd_msg_pub.initialize;

1596: AND ppv.program_type_id=ppt.program_type_id;
1597:
1598:
1599: BEGIN
1600: fnd_msg_pub.initialize;
1601: l_activity_id :=
1602: wf_engine.getitemattrnumber (
1603: itemtype=> itemtype,
1604: itemkey=> itemkey,

Line 1695: fnd_msg_pub.count_and_get (

1691: );
1692:
1693: resultout := 'COMPLETE:SUCCESS';
1694: ELSE
1695: fnd_msg_pub.count_and_get (
1696: p_encoded=> fnd_api.g_false,
1697: p_count=> l_msg_count,
1698: p_data=> l_msg_data
1699: );

Line 1751: fnd_msg_pub.count_and_get (

1747: l_error_msg
1748: );
1749: RAISE;
1750: WHEN OTHERS THEN
1751: fnd_msg_pub.count_and_get (
1752: p_encoded=> fnd_api.g_false,
1753: p_count=> l_msg_count,
1754: p_data=> l_msg_data
1755: );

Line 2052: fnd_msg_pub.count_and_get (

2048: resultout := 'COMPLETE:';
2049: RETURN;
2050: END IF;
2051:
2052: fnd_msg_pub.count_and_get (
2053: p_encoded=> fnd_api.g_false,
2054: p_count=> l_msg_count,
2055: p_data=> l_msg_data
2056: );

Line 2065: fnd_msg_pub.count_and_get (

2061: );
2062: EXCEPTION
2063: WHEN OTHERS THEN
2064: -- x_return_status := fnd_api.g_ret_sts_error;
2065: fnd_msg_pub.count_and_get (
2066: p_encoded=> fnd_api.g_false,
2067: p_count=> l_msg_count,
2068: p_data=> l_msg_data
2069: );

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

2146:
2147: -- write to log
2148: EXCEPTION
2149: WHEN OTHERS THEN
2150: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2151: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2152: END IF;
2153:
2154: --write_to_enrollment_log

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

2147: -- write to log
2148: EXCEPTION
2149: WHEN OTHERS THEN
2150: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2151: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2152: END IF;
2153:
2154: --write_to_enrollment_log
2155: wf_core.context(G_PKG_NAME,'check_approved', itemtype,itemkey,to_char(actid),funcmode);

Line 2409: FND_MSG_PUB.initialize;

2405: WHERE entity_approver_id=p_entity_appr_id;
2406:
2407: BEGIN
2408: -- clear the message buffer
2409: FND_MSG_PUB.initialize;
2410: --write to logs that workflow is getting initiated.
2411: WF_ENGINE.CreateProcess
2412: ( itemtype => l_itemtype
2413: , itemkey => itemkey

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

2460: EXCEPTION
2461: -- The line below records this function call in the error system
2462: -- in the case of an exception.
2463: WHEN OTHERS THEN
2464: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2465: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2466: END IF;
2467:
2468: --write_buffer_to_log (p_object_type, p_object_id);

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

2461: -- The line below records this function call in the error system
2462: -- in the case of an exception.
2463: WHEN OTHERS THEN
2464: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2465: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2466: END IF;
2467:
2468: --write_buffer_to_log (p_object_type, p_object_id);
2469:

Line 3325: FND_MSG_PUB.initialize;

3321: END IF;
3322:
3323: -- Initialize message list if p_init_msg_list is set to TRUE.
3324: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3325: FND_MSG_PUB.initialize;
3326: END IF;
3327:
3328: -- Debug Message
3329: IF (PV_DEBUG_HIGH_ON) THEN

Line 3473: FND_MSG_PUB.add;

3469: */
3470: l_default_approver_id:= isnumber( FND_PROFILE.VALUE('PV_ENRQ_DEFAULT_APPR') );
3471: IF ( l_default_approver_id is NULL ) THEN
3472: FND_MESSAGE.set_name('PV', 'PV_ENRQ_APPR_NOT_SET');
3473: FND_MSG_PUB.add;
3474: RAISE FND_API.G_EXC_ERROR;
3475: END IF;
3476:
3477:

Line 3909: FND_MSG_PUB.add;

3905: FND_MESSAGE.set_name('PV', 'PV_ENRQ_INCAPPRMSG_TO_CM');
3906: ELSE
3907: FND_MESSAGE.set_name('PV', 'PV_ENRQ_INCAPPRMSG_TO_PTNR');
3908: END IF;
3909: FND_MSG_PUB.add;
3910: RAISE FND_API.G_EXC_ERROR;
3911: END IF;
3912:
3913: IF l_personid IS NOT NULL THEN

Line 4016: FND_MSG_PUB.Count_And_Get (

4012: WHEN FND_API.G_EXC_ERROR THEN
4013: ROLLBACK TO submit_enrl_req_for_approval;
4014: x_return_status := FND_API.G_RET_STS_ERROR;
4015: -- Standard call to get message count and if count=1, get the message
4016: FND_MSG_PUB.Count_And_Get (
4017: p_encoded => FND_API.G_FALSE
4018: ,p_count => x_msg_count
4019: ,p_data => x_msg_data
4020: );

Line 4026: FND_MSG_PUB.Count_And_Get (

4022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4023: ROLLBACK TO submit_enrl_req_for_approval;
4024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4025: -- Standard call to get message count and if count=1, get the message
4026: FND_MSG_PUB.Count_And_Get (
4027: p_encoded => FND_API.G_FALSE
4028: ,p_count => x_msg_count
4029: ,p_data => x_msg_data
4030: );

Line 4035: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4031:
4032: WHEN OTHERS THEN
4033: ROLLBACK TO submit_enrl_req_for_approval;
4034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4035: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4036: THEN
4037: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4038: END IF;
4039: -- Standard call to get message count and if count=1, get the message

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

4033: ROLLBACK TO submit_enrl_req_for_approval;
4034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4035: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4036: THEN
4037: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4038: END IF;
4039: -- Standard call to get message count and if count=1, get the message
4040: FND_MSG_PUB.Count_And_Get (
4041: p_encoded => FND_API.G_FALSE

Line 4040: FND_MSG_PUB.Count_And_Get (

4036: THEN
4037: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4038: END IF;
4039: -- Standard call to get message count and if count=1, get the message
4040: FND_MSG_PUB.Count_And_Get (
4041: p_encoded => FND_API.G_FALSE
4042: ,p_count => x_msg_count
4043: ,p_data => x_msg_data
4044: );

Line 4147: FND_MSG_PUB.initialize;

4143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4144: END IF;
4145: -- Initialize message list if p_init_msg_list is set to TRUE.
4146: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4147: FND_MSG_PUB.initialize;
4148: END IF;
4149: PVX_UTILITY_PVT.debug_message('FND Global user id is'|| FND_GLOBAL.USER_ID );
4150: PVX_UTILITY_PVT.debug_message('FND Employee user id is'|| FND_GLOBAL.EMPLOYEE_ID );
4151: -- Debug Message

Line 4182: FND_MSG_PUB.add;

4178: IF l_allow_appr_wo_contract <> 'Y' THEN
4179: l_contract_signed:=checkcontract_status(enrl_request_id);
4180: IF l_contract_signed =false THEN
4181: FND_MESSAGE.set_name('PV', 'PV_ENRQ_CONTRACT_NOT_SIGNED');
4182: FND_MSG_PUB.add;
4183: RAISE FND_API.G_EXC_ERROR;
4184: END IF;
4185: END IF;
4186:

Line 4193: FND_MSG_PUB.add;

4189: l_checklistStatus:=checklist_status(enrl_request_id);
4190: IF l_checklistStatus=false THEN
4191: FND_MESSAGE.set_name('PV', 'PV_CHECKLIST_INCOMPLETE');
4192: --FND_MESSAGE.set_token ('CHECKLISTLINK', l_checklistlink, FALSE);
4193: FND_MSG_PUB.add;
4194: RAISE FND_API.G_EXC_ERROR;
4195: END IF;
4196:
4197: l_approvalStatus:=ame_util.approvedStatus;

Line 4394: FND_MSG_PUB.add;

4390: l_default_approver_id:= isnumber(FND_PROFILE.VALUE('PV_ENRQ_DEFAULT_APPR'));
4391: IF ( l_default_approver_id is NULL ) THEN
4392:
4393: FND_MESSAGE.set_name('PV', 'PV_ENRQ_APPR_NOT_SET');
4394: FND_MSG_PUB.add;
4395: RAISE FND_API.G_EXC_ERROR;
4396: END IF;
4397: OPEN person_id_csr (l_default_approver_id);
4398: FETCH person_id_csr INTO l_default_person_id,l_display_name;

Line 4503: FND_MSG_PUB.Count_And_Get

4499: WHEN FND_API.G_EXC_ERROR THEN
4500: ROLLBACK TO update_enrl_req_status;
4501: x_return_status := FND_API.G_RET_STS_ERROR;
4502: -- Standard call to get message count and if count=1, get the message
4503: FND_MSG_PUB.Count_And_Get
4504: ( p_encoded => FND_API.G_FALSE
4505: , p_count => x_msg_count
4506: , p_data => x_msg_data
4507: );

Line 4513: FND_MSG_PUB.Count_And_Get

4509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4510: ROLLBACK TO update_enrl_req_status;
4511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4512: -- Standard call to get message count and if count=1, get the message
4513: FND_MSG_PUB.Count_And_Get
4514: ( p_encoded => FND_API.G_FALSE
4515: , p_count => x_msg_count
4516: , p_data => x_msg_data
4517: );

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

4517: );
4518: WHEN OTHERS THEN
4519: ROLLBACK TO update_enrl_req_status;
4520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4521: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4522: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4523: END IF;
4524: -- Standard call to get message count and if count=1, get the message
4525: FND_MSG_PUB.Count_And_Get

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

4518: WHEN OTHERS THEN
4519: ROLLBACK TO update_enrl_req_status;
4520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4521: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4522: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4523: END IF;
4524: -- Standard call to get message count and if count=1, get the message
4525: FND_MSG_PUB.Count_And_Get
4526: ( p_encoded => FND_API.G_FALSE

Line 4525: FND_MSG_PUB.Count_And_Get

4521: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4522: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4523: END IF;
4524: -- Standard call to get message count and if count=1, get the message
4525: FND_MSG_PUB.Count_And_Get
4526: ( p_encoded => FND_API.G_FALSE
4527: , p_count => x_msg_count
4528: , p_data => x_msg_data
4529: );

Line 4693: FND_MSG_PUB.initialize;

4689:
4690: -- Initialize message list if p_init_msg_list is set to TRUE.
4691: IF FND_API.to_Boolean( p_init_msg_list )
4692: THEN
4693: FND_MSG_PUB.initialize;
4694: END IF;
4695:
4696: -- Debug Message
4697: IF (PV_DEBUG_HIGH_ON) THEN

Line 4910: FND_MSG_PUB.Count_And_Get

4906: END IF;
4907:
4908:
4909: -- Standard call to get message count and if count is 1, get message info.
4910: FND_MSG_PUB.Count_And_Get
4911: ( p_count => x_msg_count
4912: ,p_data => x_msg_data
4913: );
4914:

Line 4925: FND_MSG_PUB.Count_And_Get (

4921: WHEN FND_API.G_EXC_ERROR THEN
4922: ROLLBACK TO terminate_downgrade_memb;
4923: x_return_status := FND_API.G_RET_STS_ERROR;
4924: -- Standard call to get message count and if count=1, get the message
4925: FND_MSG_PUB.Count_And_Get (
4926: p_encoded => FND_API.G_FALSE,
4927: p_count => x_msg_count,
4928: p_data => x_msg_data
4929: );

Line 4935: FND_MSG_PUB.Count_And_Get (

4931: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4932: ROLLBACK TO terminate_downgrade_memb;
4933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4934: -- Standard call to get message count and if count=1, get the message
4935: FND_MSG_PUB.Count_And_Get (
4936: p_encoded => FND_API.G_FALSE,
4937: p_count => x_msg_count,
4938: p_data => x_msg_data
4939: );

Line 4944: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4940:
4941: WHEN OTHERS THEN
4942: ROLLBACK TO terminate_downgrade_memb;
4943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4944: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4945: THEN
4946: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4947: END IF;
4948: -- Standard call to get message count and if count=1, get the message

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

4942: ROLLBACK TO terminate_downgrade_memb;
4943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4944: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4945: THEN
4946: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4947: END IF;
4948: -- Standard call to get message count and if count=1, get the message
4949: FND_MSG_PUB.Count_And_Get (
4950: p_encoded => FND_API.G_FALSE,

Line 4949: FND_MSG_PUB.Count_And_Get (

4945: THEN
4946: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4947: END IF;
4948: -- Standard call to get message count and if count=1, get the message
4949: FND_MSG_PUB.Count_And_Get (
4950: p_encoded => FND_API.G_FALSE,
4951: p_count => x_msg_count,
4952: p_data => x_msg_data
4953: );

Line 5028: FND_MSG_PUB.initialize;

5024:
5025: -- Initialize message list if p_init_msg_list is set to TRUE.
5026: IF FND_API.to_Boolean( p_init_msg_list )
5027: THEN
5028: FND_MSG_PUB.initialize;
5029: END IF;
5030:
5031: -- Debug Message
5032: IF (PV_DEBUG_HIGH_ON) THEN

Line 5201: FND_MSG_PUB.Count_And_Get (

5197: WHEN FND_API.G_EXC_ERROR THEN
5198: ROLLBACK TO Create_Default_Membership;
5199: x_return_status := FND_API.G_RET_STS_ERROR;
5200: -- Standard call to get message count and if count=1, get the message
5201: FND_MSG_PUB.Count_And_Get (
5202: p_encoded => FND_API.G_FALSE,
5203: p_count => x_msg_count,
5204: p_data => x_msg_data
5205: );

Line 5211: FND_MSG_PUB.Count_And_Get (

5207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5208: ROLLBACK TO Create_Default_Membership;
5209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5210: -- Standard call to get message count and if count=1, get the message
5211: FND_MSG_PUB.Count_And_Get (
5212: p_encoded => FND_API.G_FALSE,
5213: p_count => x_msg_count,
5214: p_data => x_msg_data
5215: );

Line 5220: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5216:
5217: WHEN OTHERS THEN
5218: ROLLBACK TO Create_Default_Membership;
5219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5220: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5221: THEN
5222: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5223: END IF;
5224: -- Standard call to get message count and if count=1, get the message

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

5218: ROLLBACK TO Create_Default_Membership;
5219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5220: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5221: THEN
5222: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5223: END IF;
5224: -- Standard call to get message count and if count=1, get the message
5225: FND_MSG_PUB.Count_And_Get (
5226: p_encoded => FND_API.G_FALSE,

Line 5225: FND_MSG_PUB.Count_And_Get (

5221: THEN
5222: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5223: END IF;
5224: -- Standard call to get message count and if count=1, get the message
5225: FND_MSG_PUB.Count_And_Get (
5226: p_encoded => FND_API.G_FALSE,
5227: p_count => x_msg_count,
5228: p_data => x_msg_data
5229: );

Line 5309: FND_MSG_PUB.initialize;

5305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5306: END IF;
5307: -- Initialize message list if p_init_msg_list is set to TRUE.
5308: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5309: FND_MSG_PUB.initialize;
5310: END IF;
5311: -- Debug Message
5312: PVX_UTILITY_PVT.debug_message( 'Private API: ' || l_api_name || 'start' );
5313: -- Initialize API return status to SUCCESS

Line 5447: FND_MSG_PUB.Count_And_Get

5443: END IF;
5444: -- Debug Message
5445: PVX_UTILITY_PVT.debug_message( 'Private API: ' || l_api_name || 'end' );
5446: -- Standard call to get message count and if count is 1, get message info.
5447: FND_MSG_PUB.Count_And_Get
5448: (
5449: p_count => x_msg_count
5450: , p_data => x_msg_data
5451: );

Line 5461: FND_MSG_PUB.Count_And_Get (

5457: WHEN FND_API.G_EXC_ERROR THEN
5458: ROLLBACK TO send_notifications;
5459: x_return_status := FND_API.G_RET_STS_ERROR;
5460: -- Standard call to get message count and if count=1, get the message
5461: FND_MSG_PUB.Count_And_Get (
5462: p_encoded => FND_API.G_FALSE,
5463: p_count => x_msg_count,
5464: p_data => x_msg_data
5465: );

Line 5471: FND_MSG_PUB.Count_And_Get (

5467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5468: ROLLBACK TO send_notifications;
5469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5470: -- Standard call to get message count and if count=1, get the message
5471: FND_MSG_PUB.Count_And_Get (
5472: p_encoded => FND_API.G_FALSE,
5473: p_count => x_msg_count,
5474: p_data => x_msg_data
5475: );

Line 5480: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5476:
5477: WHEN OTHERS THEN
5478: ROLLBACK TO send_notifications;
5479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5480: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5481: THEN
5482: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5483: END IF;
5484: -- Standard call to get message count and if count=1, get the message

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

5478: ROLLBACK TO send_notifications;
5479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5480: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5481: THEN
5482: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5483: END IF;
5484: -- Standard call to get message count and if count=1, get the message
5485: FND_MSG_PUB.Count_And_Get (
5486: p_encoded => FND_API.G_FALSE,

Line 5485: FND_MSG_PUB.Count_And_Get (

5481: THEN
5482: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5483: END IF;
5484: -- Standard call to get message count and if count=1, get the message
5485: FND_MSG_PUB.Count_And_Get (
5486: p_encoded => FND_API.G_FALSE,
5487: p_count => x_msg_count,
5488: p_data => x_msg_data
5489: );