DBA Data[Home] [Help]

APPS.PV_AME_API_W dependencies on FND_MSG_PUB

Line 107: fnd_msg_pub.initialize;

103:
104: -- Initialize message list if p_init_msg_list is set to TRUE.
105: IF FND_API.to_Boolean( p_init_msg_list )
106: THEN
107: fnd_msg_pub.initialize;
108: END IF;
109:
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111: -- ********* End Standard Initializations *********

Line 123: fnd_msg_pub.Add;

119:
120: IF p_approval_entity not in ('PVREFFRL','PVDEALRN','PVDQMAPR') THEN
121: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
122: fnd_message.Set_Token('TEXT', 'Invalid Approval Entity: ' || p_approval_entity);
123: fnd_msg_pub.Add;
124: RAISE FND_API.g_exc_error;
125: END IF;
126:
127: -- This is to make sure that no other thread of execution

Line 254: fnd_msg_pub.Add;

250:
251: IF approverUserIds(1) IS NULL THEN
252: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
253: fnd_message.Set_Token('TEXT', 'Could not find approver in either AME or profile');
254: fnd_msg_pub.Add;
255: RAISE FND_API.G_EXC_ERROR;
256: END IF;
257: ELSE
258: l_appr_status := 'PENDING_APPROVAL';

Line 389: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

385: END IF;
386:
387: CLOSE lc_lock_approvals;
388: -- Standard call to get message count and if count is 1, get message info.
389: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
390: p_count => x_msg_count,
391: p_data => x_msg_data);
392:
393: EXCEPTION

Line 399: fnd_msg_pub.Count_And_Get(

395:
396: ROLLBACK TO START_APPROVAL_PROCESS;
397: x_return_status := FND_API.G_RET_STS_ERROR ;
398:
399: fnd_msg_pub.Count_And_Get(
400: p_encoded => FND_API.G_FALSE,
401: p_count => x_msg_count,
402: p_data => x_msg_data);
403:

Line 409: fnd_msg_pub.Count_And_Get(

405:
406: ROLLBACK TO START_APPROVAL_PROCESS;
407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
408:
409: fnd_msg_pub.Count_And_Get(
410: p_encoded => FND_API.G_FALSE,
411: p_count => x_msg_count,
412: p_data => x_msg_data);
413:

Line 416: fnd_msg_pub.Add;

412: p_data => x_msg_data);
413:
414: WHEN g_concurrent_update THEN
415: fnd_message.Set_Name('PV', 'PV_REQUERY_THE_RECORD');
416: fnd_msg_pub.Add;
417: ROLLBACK TO UPDATE_APPROVER_RESPONSE;
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
419: fnd_msg_pub.Count_And_Get(
420: p_encoded => FND_API.G_FALSE,

Line 419: fnd_msg_pub.Count_And_Get(

415: fnd_message.Set_Name('PV', 'PV_REQUERY_THE_RECORD');
416: fnd_msg_pub.Add;
417: ROLLBACK TO UPDATE_APPROVER_RESPONSE;
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
419: fnd_msg_pub.Count_And_Get(
420: p_encoded => FND_API.G_FALSE,
421: p_count => x_msg_count,
422: p_data => x_msg_data);
423:

Line 429: FND_MSG_PUB.Add_Exc_Msg(

425:
426: ROLLBACK TO START_APPROVAL_PROCESS;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428:
429: FND_MSG_PUB.Add_Exc_Msg(
430: 'PV_AME_API_W',
431: l_api_name);
432:
433: fnd_msg_pub.Count_And_Get(

Line 433: fnd_msg_pub.Count_And_Get(

429: FND_MSG_PUB.Add_Exc_Msg(
430: 'PV_AME_API_W',
431: l_api_name);
432:
433: fnd_msg_pub.Count_And_Get(
434: p_encoded => FND_API.G_FALSE,
435: p_count => x_msg_count,
436: p_data => x_msg_data);
437:

Line 566: fnd_msg_pub.initialize;

562: END IF;
563:
564: -- Initialize message list if p_init_msg_list is set to TRUE.
565: IF FND_API.to_Boolean( p_init_msg_list ) THEN
566: fnd_msg_pub.initialize;
567: END IF;
568:
569: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
570: FND_LOG.MESSAGE(FND_LOG.LEVEL_PROCEDURE

Line 607: fnd_msg_pub.Add;

603: l_forwardee.approver_category := ame_util.approvalApproverCategory;
604:
605: IF l_forwardee.orig_system_id IS NULL THEN
606: fnd_message.Set_Name('PV', 'PV_NO_PERSON_ERROR');
607: fnd_msg_pub.Add;
608: RAISE FND_API.g_exc_error;
609: END IF;
610:
611: l_approval_status := 'FORWARDED';

Line 684: fnd_msg_pub.Add;

680: -- was sent to the API. Hence error!!!
681: IF l_approval_status IS NULL THEN
682: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
683: fnd_message.Set_Token('TEXT', 'Possible error. Invalid : Response ' || p_response);
684: fnd_msg_pub.Add;
685: RAISE FND_API.g_exc_error;
686: END IF;
687:
688: IF p_response = AME_UTIL.forwardStatus and p_forwardee_user_id is null then

Line 690: fnd_msg_pub.Add;

686: END IF;
687:
688: IF p_response = AME_UTIL.forwardStatus and p_forwardee_user_id is null then
689: fnd_message.Set_Name('PV', 'PV_REFERRAL_REASSIGN_APPROVER');
690: fnd_msg_pub.Add;
691: RAISE FND_API.g_exc_error;
692: END IF;
693:
694: open lc_is_default_approver(pc_user_id => p_approver_user_id,

Line 786: FND_MSG_PUB.Add;

782: ,' The approver is NOT in the list. p_response ' || p_response);
783: END IF;
784:
785: FND_MESSAGE.Set_Name('PV', 'PV_REFERRAL_REASSIGN_ERROR');
786: FND_MSG_PUB.Add;
787: RAISE FND_API.G_EXC_ERROR;
788:
789: END IF;
790:

Line 938: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

934: ,x_user_id_exists => l_valid_users_flag);
935: EXCEPTION
936: WHEN OTHERS THEN
937: -- log error message by AME
938: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
939: FND_MSG_PUB.Add_Exc_Msg('PV_AME_API_W',l_api_name);
940: END IF;
941: RAISE;
942: END;

Line 939: FND_MSG_PUB.Add_Exc_Msg('PV_AME_API_W',l_api_name);

935: EXCEPTION
936: WHEN OTHERS THEN
937: -- log error message by AME
938: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
939: FND_MSG_PUB.Add_Exc_Msg('PV_AME_API_W',l_api_name);
940: END IF;
941: RAISE;
942: END;
943:

Line 956: FND_MSG_PUB.Add;

952: END IF;
953:
954: IF ( l_valid_users_flag = 'N' ) THEN
955: FND_MESSAGE.Set_Name('PV', 'PV_NO_USER_FOR_PERSON_ERROR');
956: FND_MSG_PUB.Add;
957: RAISE FND_API.g_exc_error;
958: END IF;
959:
960:

Line 972: FND_MSG_PUB.Add;

968: ,'Even After forwarding l_approval_list is '||l_approval_list.COUNT);
969: END IF;
970:
971: FND_MESSAGE.Set_Name('PV', 'PV_REFERRAL_NO_FORWARDEE');
972: FND_MSG_PUB.Add;
973: RAISE FND_API.g_exc_error;
974: END IF;
975:
976: DEL_PRIOR_REP_APPR(p_approval_entity => p_approval_entity

Line 1200: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

1196: END IF;
1197: END IF;
1198:
1199: -- Standard call to get message count and if count is 1, get message info.
1200: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1201: p_count => x_msg_count,
1202: p_data => x_msg_data);
1203:
1204: EXCEPTION

Line 1211: fnd_msg_pub.Count_And_Get(

1207:
1208: ROLLBACK TO UPDATE_APPROVER_RESPONSE;
1209: x_return_status := FND_API.G_RET_STS_ERROR ;
1210:
1211: fnd_msg_pub.Count_And_Get(
1212: p_encoded => FND_API.G_FALSE,
1213: p_count => x_msg_count,
1214: p_data => x_msg_data);
1215:

Line 1221: fnd_msg_pub.Count_And_Get(

1217:
1218: ROLLBACK TO UPDATE_APPROVER_RESPONSE;
1219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1220:
1221: fnd_msg_pub.Count_And_Get(
1222: p_encoded => FND_API.G_FALSE,
1223: p_count => x_msg_count,
1224: p_data => x_msg_data);
1225:

Line 1228: fnd_msg_pub.Add;

1224: p_data => x_msg_data);
1225:
1226: WHEN g_concurrent_update THEN
1227: fnd_message.Set_Name('PV', 'PV_REQUERY_THE_RECORD');
1228: fnd_msg_pub.Add;
1229:
1230: ROLLBACK TO UPDATE_APPROVER_RESPONSE;
1231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1232: fnd_msg_pub.Count_And_Get(

Line 1232: fnd_msg_pub.Count_And_Get(

1228: fnd_msg_pub.Add;
1229:
1230: ROLLBACK TO UPDATE_APPROVER_RESPONSE;
1231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1232: fnd_msg_pub.Count_And_Get(
1233: p_encoded => FND_API.G_FALSE,
1234: p_count => x_msg_count,
1235: p_data => x_msg_data);
1236:

Line 1242: FND_MSG_PUB.Add_Exc_Msg('PV_AME_API_W', l_api_name);

1238:
1239: ROLLBACK TO UPDATE_APPROVER_RESPONSE;
1240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1241:
1242: FND_MSG_PUB.Add_Exc_Msg('PV_AME_API_W', l_api_name);
1243:
1244: fnd_msg_pub.Count_And_Get(
1245: p_encoded => FND_API.G_FALSE,
1246: p_count => x_msg_count,

Line 1244: fnd_msg_pub.Count_And_Get(

1240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1241:
1242: FND_MSG_PUB.Add_Exc_Msg('PV_AME_API_W', l_api_name);
1243:
1244: fnd_msg_pub.Count_And_Get(
1245: p_encoded => FND_API.G_FALSE,
1246: p_count => x_msg_count,
1247: p_data => x_msg_data);
1248:

Line 1387: FND_MSG_PUB.Add;

1383: ,'Error in getPendingApprovers '||SQLCODE ||
1384: ': ' || SQLERRM);
1385: END IF;
1386: FND_MESSAGE.Set_Name('PV', 'PV_REFERRAL_APPROVAL_ERROR');
1387: FND_MSG_PUB.Add;
1388: RAISE FND_API.G_EXC_ERROR;
1389:
1390: END VALIDATE_APPROVAL;
1391:

Line 1553: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

1549:
1550: EXCEPTION
1551: WHEN OTHERS THEN
1552: -- log error message by AME
1553: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1554: FND_MSG_PUB.Add_Exc_Msg('PV_AME_API_W',l_api_name);
1555: END IF;
1556: l_exception_flag := 'Y';
1557:

Line 1554: FND_MSG_PUB.Add_Exc_Msg('PV_AME_API_W',l_api_name);

1550: EXCEPTION
1551: WHEN OTHERS THEN
1552: -- log error message by AME
1553: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1554: FND_MSG_PUB.Add_Exc_Msg('PV_AME_API_W',l_api_name);
1555: END IF;
1556: l_exception_flag := 'Y';
1557:
1558: IF p_mode = 'UPDATE' THEN

Line 1619: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

1615:
1616: EXCEPTION
1617:
1618: WHEN OTHERS THEN
1619: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1620: FND_MSG_PUB.Add_Exc_Msg('PV_AME_API_W',l_api_name);
1621: END IF;
1622: END GET_APPROVERS;
1623:

Line 1620: FND_MSG_PUB.Add_Exc_Msg('PV_AME_API_W',l_api_name);

1616: EXCEPTION
1617:
1618: WHEN OTHERS THEN
1619: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1620: FND_MSG_PUB.Add_Exc_Msg('PV_AME_API_W',l_api_name);
1621: END IF;
1622: END GET_APPROVERS;
1623:
1624: