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.AS_OPP_SALES_CREDIT_PVT dependencies on FND_MSG_PUB

Line 256: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

252: l_temp_bool BOOLEAN;
253: l_win_probability NUMBER;
254: l_win_loss_indicator as_statuses_b.win_loss_indicator%Type;
255: l_forecast_rollup_flag as_statuses_b.forecast_rollup_flag%Type;
256: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
257:
258: l_upd_access_id NUMBER;
259: l_upd_team_flag VARCHAR2(1);
260: l_upd_date DATE;

Line 276: --FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;

272: THEN
273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
274: END IF;
275:
276: --FND_MSG_PUB.G_MSG_LEVEL_THRESHOLD := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
277:
278: -- Initialize message list if p_init_msg_list is set to TRUE.
279: IF FND_API.to_Boolean( p_init_msg_list )
280: THEN

Line 281: FND_MSG_PUB.initialize;

277:
278: -- Initialize message list if p_init_msg_list is set to TRUE.
279: IF FND_API.to_Boolean( p_init_msg_list )
280: THEN
281: FND_MSG_PUB.initialize;
282: END IF;
283:
284:
285: -- Debug Message

Line 287: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

283:
284:
285: -- Debug Message
286: IF l_debug THEN
287: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
288: 'Private API1 ' || l_api_name || ' start');
289: END IF;
290:
291:

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

319: -- Validate Environment
320: -- ******************************************************************
321: IF FND_GLOBAL.User_Id IS NULL
322: THEN
323: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
324: THEN
325: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
326: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
327: FND_MSG_PUB.ADD;

Line 327: FND_MSG_PUB.ADD;

323: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
324: THEN
325: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
326: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
327: FND_MSG_PUB.ADD;
328: END IF;
329: RAISE FND_API.G_EXC_ERROR;
330: END IF;
331:

Line 344: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

340: ,x_msg_data => x_msg_data
341: ,x_sales_member_rec => l_identity_sales_member_rec);
342:
343: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
344: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
345: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
346: 'Private API2 Get_CurrentUser fail');
347: END IF;
348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 345: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

341: ,x_sales_member_rec => l_identity_sales_member_rec);
342:
343: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
344: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
345: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
346: 'Private API2 Get_CurrentUser fail');
347: END IF;
348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
349: END IF;

Line 375: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

371: ,x_msg_data => x_msg_data
372: ,x_update_access_flag => l_update_access_flag );
373:
374: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
375: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
376: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
377: 'has_updateOpportunityAccess fail');
378: END IF;
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 376: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

372: ,x_update_access_flag => l_update_access_flag );
373:
374: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
375: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
376: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
377: 'has_updateOpportunityAccess fail');
378: END IF;
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: END IF;

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

379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: END IF;
381:
382: IF (l_update_access_flag <> 'Y') THEN
383: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
384: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
385: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
386: FND_MSG_PUB.ADD;
387: END IF;

Line 386: FND_MSG_PUB.ADD;

382: IF (l_update_access_flag <> 'Y') THEN
383: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
384: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
385: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
386: FND_MSG_PUB.ADD;
387: END IF;
388: RAISE FND_API.G_EXC_ERROR;
389: END IF;
390: END IF;

Line 401: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

397: IF l_freeze_flag = 'Y'
398: THEN
399: l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');
400: IF l_allow_flag <> 'Y' THEN
401: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
402: 'API_OPP_FROZEN');
403: RAISE FND_API.G_EXC_ERROR;
404: END IF;
405: END IF;

Line 416: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

412: l_SALES_CREDIT_ID := p_SALES_CREDIT_Tbl(I).SALES_CREDIT_ID;
413:
414: -- Progress Message
415: --
416: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
417: THEN
418: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
419: --FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_SALES_CREDIT', TRUE);
420: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);

Line 421: --FND_MSG_PUB.Add;

417: THEN
418: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
419: --FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_SALES_CREDIT', TRUE);
420: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);
421: --FND_MSG_PUB.Add;
422: IF l_debug THEN
423: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
424: 'Processing AS_OPP_SALES_CREDIT row number '||to_char(I));
425: END IF;

Line 423: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

419: --FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_SALES_CREDIT', TRUE);
420: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);
421: --FND_MSG_PUB.Add;
422: IF l_debug THEN
423: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
424: 'Processing AS_OPP_SALES_CREDIT row number '||to_char(I));
425: END IF;
426: END IF;
427:

Line 432: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

428: l_sales_credit_rec := p_SALES_CREDIT_tbl(I);
429:
430: -- Debug message
431: IF l_debug THEN
432: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
433: 'Private API3 Validate_sales_credit');
434: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
435: l_sales_credit_rec.partner_customer_id);
436: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 434: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

430: -- Debug message
431: IF l_debug THEN
432: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
433: 'Private API3 Validate_sales_credit');
434: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
435: l_sales_credit_rec.partner_customer_id);
436: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
437: l_sales_credit_rec.person_id);
438: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 436: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

432: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
433: 'Private API3 Validate_sales_credit');
434: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
435: l_sales_credit_rec.partner_customer_id);
436: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
437: l_sales_credit_rec.person_id);
438: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
439: l_sales_credit_rec.salesforce_id);
440: END IF;

Line 438: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

434: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
435: l_sales_credit_rec.partner_customer_id);
436: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
437: l_sales_credit_rec.person_id);
438: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
439: l_sales_credit_rec.salesforce_id);
440: END IF;
441:
442: IF nvl(l_sales_credit_rec.partner_customer_id, fnd_api.g_miss_num) = fnd_api.g_miss_num and

Line 457: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

453: close C_Partner_Id;
454: END IF;
455: END IF;
456: IF l_debug THEN
457: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
458: 'Before sales group');
459: END IF;
460:
461: -- Get partner contact's sales group id

Line 471: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

467: fetch C_Group_Id into l_group_id_str;
468: close C_Group_Id;
469: END IF;
470: IF l_debug THEN
471: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
472: l_group_id_str);
473: END IF;
474:
475:

Line 499: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

495: x_msg_data => x_msg_data);
496:
497: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
498: IF l_debug THEN
499: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
500: 'Private API4 Validate_sales_credit fail');
501: END IF;
502: RAISE FND_API.G_EXC_ERROR;
503: END IF;

Line 508: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

504:
505:
506: -- Debug Message
507: IF l_debug THEN
508: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
509: 'Private API5 Calling create table handler');
510: END IF;
511:
512: Select lead.win_probability, status.win_loss_indicator,

Line 598: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

594: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
595: RAISE FND_API.G_EXC_ERROR;
596: ELSE
597: IF l_debug THEN
598: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
599: 'Private API6 Created sales credit: ' ||l_SALES_CREDIT_ID );
600: END IF;
601:
602: END IF;

Line 644: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

640: nvl(FND_PROFILE.Value('AS_DEFAULT_FREEZE_FLAG'), 'Y');
641:
642: -- Debug Message
643: IF l_debug THEN
644: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
645: 'Calling Create_SalesTeam');
646: END IF;
647:
648: AS_ACCESS_PUB.Create_SalesTeam (

Line 667: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

663: );
664:
665: -- Debug Message
666: IF l_debug THEN
667: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
668: 'Create_SalesTeam: l_access_id = ' || l_access_id);
669: END IF;
670:
671: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 673: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

669: END IF;
670:
671: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
672: IF l_debug THEN
673: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
674: 'Create_SalesTeam fail');
675: END IF;
676: RAISE FND_API.G_EXC_ERROR;
677: END IF;

Line 709: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

705: ,x_access_id => l_Access_Id );
706:
707: -- Debug Message
708: IF l_debug THEN
709: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
710: 'update_SalesTeam: l_access_id = ' || l_access_id);
711: END IF;
712:
713: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 715: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

711: END IF;
712:
713: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
714: IF l_debug THEN
715: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
716: 'update_SalesTeam fail');
717: END IF;
718: RAISE FND_API.G_EXC_ERROR;
719: END IF;

Line 738: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

734:
735:
736: -- Debug Message
737: IF l_debug THEN
738: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
739: 'Private API7 ' || l_api_name || 'end');
740: END IF;
741:
742:

Line 744: FND_MSG_PUB.Count_And_Get

740: END IF;
741:
742:
743: -- Standard call to get message count and if count is 1, get message info.
744: FND_MSG_PUB.Count_And_Get
745: ( p_count => x_msg_count,
746: p_data => x_msg_data
747: );
748:

Line 773: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

769: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
770: P_MODULE => l_module
771: ,P_API_NAME => L_API_NAME
772: ,P_PKG_NAME => G_PKG_NAME
773: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
774: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
775: ,X_MSG_COUNT => X_MSG_COUNT
776: ,X_MSG_DATA => X_MSG_DATA
777: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 784: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

780: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
781: P_MODULE => l_module
782: ,P_API_NAME => L_API_NAME
783: ,P_PKG_NAME => G_PKG_NAME
784: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
785: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
786: ,X_MSG_COUNT => X_MSG_COUNT
787: ,X_MSG_DATA => X_MSG_DATA
788: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 934: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

930: l_update_access_flag VARCHAR2(1);
931: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
932: l_freeze_flag VARCHAR2(1) := 'N'; -- solin, for bug 1554330
933: l_allow_flag VARCHAR2(1); -- solin, for bug 1554330
934: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
935:
936: l_Sales_Team_Rec AS_ACCESS_PUB.Sales_Team_Rec_Type
937: := AS_ACCESS_PUB.G_MISS_SALES_TEAM_REC;
938: l_access_id NUMBER;

Line 973: FND_MSG_PUB.initialize;

969:
970: -- Initialize message list if p_init_msg_list is set to TRUE.
971: IF FND_API.to_Boolean( p_init_msg_list )
972: THEN
973: FND_MSG_PUB.initialize;
974: END IF;
975:
976:
977: -- Debug Message

Line 979: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

975:
976:
977: -- Debug Message
978: IF l_debug THEN
979: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
980: 'Private API8 ' || l_api_name || ' start');
981: END IF;
982:
983:

Line 1021: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1017: ,x_msg_count => x_msg_count
1018: ,x_msg_data => x_msg_data
1019: ,x_sales_member_rec => l_identity_sales_member_rec);
1020: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1021: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1022: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1023: 'Private API9 Get_CurrentUser fail');
1024: END IF;
1025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1022: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1018: ,x_msg_data => x_msg_data
1019: ,x_sales_member_rec => l_identity_sales_member_rec);
1020: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1021: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1022: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1023: 'Private API9 Get_CurrentUser fail');
1024: END IF;
1025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1026: END IF;

Line 1051: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1047: ,x_msg_data => x_msg_data
1048: ,x_update_access_flag => l_update_access_flag );
1049:
1050: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1051: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1052: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1053: 'has_updateOpportunityAccess fail');
1054: END IF;
1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1052: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1048: ,x_update_access_flag => l_update_access_flag );
1049:
1050: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1051: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1052: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1053: 'has_updateOpportunityAccess fail');
1054: END IF;
1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1056: END IF;

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

1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1056: END IF;
1057:
1058: IF (l_update_access_flag <> 'Y') THEN
1059: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1060: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
1061: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
1062: FND_MSG_PUB.ADD;
1063: END IF;

Line 1062: FND_MSG_PUB.ADD;

1058: IF (l_update_access_flag <> 'Y') THEN
1059: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1060: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
1061: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
1062: FND_MSG_PUB.ADD;
1063: END IF;
1064: RAISE FND_API.G_EXC_ERROR;
1065: END IF;
1066: END IF;

Line 1077: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1073: IF l_freeze_flag = 'Y'
1074: THEN
1075: l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');
1076: IF l_allow_flag <> 'Y' THEN
1077: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1078: 'API_OPP_FROZEN');
1079: RAISE FND_API.G_EXC_ERROR;
1080: END IF;
1081: END IF;

Line 1090: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1086: X_SALES_CREDIT_out_tbl(I).return_status := FND_API.G_RET_STS_SUCCESS;
1087: l_tar_SALES_CREDIT_rec := P_SALES_CREDIT_tbl(I);
1088:
1089: IF l_debug THEN
1090: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1091: 'Private API10processing sales_credit_id: ' || P_SALES_CREDIT_tbl(I).sales_credit_id );
1092: END IF;
1093:
1094:

Line 1095: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1091: 'Private API10processing sales_credit_id: ' || P_SALES_CREDIT_tbl(I).sales_credit_id );
1092: END IF;
1093:
1094:
1095: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1096: THEN
1097: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
1098: --FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_SALES_CREDIT', TRUE);
1099: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);

Line 1100: --FND_MSG_PUB.Add;

1096: THEN
1097: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
1098: --FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_SALES_CREDIT', TRUE);
1099: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);
1100: --FND_MSG_PUB.Add;
1101: IF l_debug THEN
1102: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1103: 'Processing AS_OPP_SALES_CREDIT row number '||to_char(I));
1104: END IF;

Line 1102: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1098: --FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_SALES_CREDIT', TRUE);
1099: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);
1100: --FND_MSG_PUB.Add;
1101: IF l_debug THEN
1102: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1103: 'Processing AS_OPP_SALES_CREDIT row number '||to_char(I));
1104: END IF;
1105: END IF;
1106:

Line 1111: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1107: l_sales_credit_rec := p_SALES_CREDIT_tbl(I);
1108:
1109: -- Debug Message
1110: IF l_debug THEN
1111: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1112: 'Private API11- Open Cursor to Select');
1113:
1114: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1115: 'Private API1 SALES_CREDIT_ID = ' ||l_tar_SALES_CREDIT_rec.SALES_CREDIT_ID);

Line 1114: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1110: IF l_debug THEN
1111: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1112: 'Private API11- Open Cursor to Select');
1113:
1114: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1115: 'Private API1 SALES_CREDIT_ID = ' ||l_tar_SALES_CREDIT_rec.SALES_CREDIT_ID);
1116: END IF;
1117:
1118:

Line 1172: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1168:
1169: If ( C_Get_sales_credit%NOTFOUND) Then
1170:
1171: IF l_debug THEN
1172: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1173: 'Private14PI: C_Get_sales_credit%NOTFOUND ');
1174: END IF;
1175:
1176: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

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

1172: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1173: 'Private14PI: C_Get_sales_credit%NOTFOUND ');
1174: END IF;
1175:
1176: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1177: THEN
1178: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
1179: FND_MESSAGE.Set_Token ('INFO', 'sales_credit', FALSE);
1180: FND_MSG_PUB.Add;

Line 1180: FND_MSG_PUB.Add;

1176: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1177: THEN
1178: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
1179: FND_MESSAGE.Set_Token ('INFO', 'sales_credit', FALSE);
1180: FND_MSG_PUB.Add;
1181: END IF;
1182: raise FND_API.G_EXC_ERROR;
1183: END IF;
1184: -- Debug Message

Line 1186: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');

1182: raise FND_API.G_EXC_ERROR;
1183: END IF;
1184: -- Debug Message
1185: IF l_debug THEN
1186: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
1187: END IF;
1188: Close C_Get_sales_credit;
1189:
1190: If (l_tar_SALES_CREDIT_rec.last_update_date is NULL or

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

1188: Close C_Get_sales_credit;
1189:
1190: If (l_tar_SALES_CREDIT_rec.last_update_date is NULL or
1191: l_tar_SALES_CREDIT_rec.last_update_date = FND_API.G_MISS_Date ) Then
1192: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1193: THEN
1194: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1195: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1196: FND_MSG_PUB.ADD;

Line 1196: FND_MSG_PUB.ADD;

1192: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1193: THEN
1194: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1195: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1196: FND_MSG_PUB.ADD;
1197: END IF;
1198: raise FND_API.G_EXC_ERROR;
1199: End if;
1200: -- Check Whether record has been changed by someone else

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

1198: raise FND_API.G_EXC_ERROR;
1199: End if;
1200: -- Check Whether record has been changed by someone else
1201: If (l_tar_SALES_CREDIT_rec.last_update_date <> l_ref_SALES_CREDIT_rec.last_update_date) Then
1202: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1203: THEN
1204: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
1205: FND_MESSAGE.Set_Token('INFO', 'sales_credit', FALSE);
1206: FND_MSG_PUB.ADD;

Line 1206: FND_MSG_PUB.ADD;

1202: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1203: THEN
1204: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
1205: FND_MESSAGE.Set_Token('INFO', 'sales_credit', FALSE);
1206: FND_MSG_PUB.ADD;
1207: END IF;
1208: raise FND_API.G_EXC_ERROR;
1209: End if;
1210:

Line 1213: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1209: End if;
1210:
1211: -- Debug message
1212: IF l_debug THEN
1213: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1214: 'Private API15Validate_sales_credit');
1215:
1216: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1217: l_sales_credit_rec.partner_customer_id);

Line 1216: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1212: IF l_debug THEN
1213: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1214: 'Private API15Validate_sales_credit');
1215:
1216: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1217: l_sales_credit_rec.partner_customer_id);
1218: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1219: l_sales_credit_rec.salesforce_id);
1220: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1218: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1214: 'Private API15Validate_sales_credit');
1215:
1216: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1217: l_sales_credit_rec.partner_customer_id);
1218: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1219: l_sales_credit_rec.salesforce_id);
1220: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1221: l_sales_credit_rec.person_id);
1222: END IF;

Line 1220: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1216: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1217: l_sales_credit_rec.partner_customer_id);
1218: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1219: l_sales_credit_rec.salesforce_id);
1220: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1221: l_sales_credit_rec.person_id);
1222: END IF;
1223:
1224:

Line 1252: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1248: x_msg_data => x_msg_data);
1249:
1250: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1251: IF l_debug THEN
1252: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1253: 'Private API: Validate_sales_credit fail');
1254: END IF;
1255: RAISE FND_API.G_EXC_ERROR;
1256: END IF;

Line 1262: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1258: -- Hint: Add corresponding Master-Detail business logic here if necessary.
1259:
1260: -- Debug Message
1261: IF l_debug THEN
1262: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1263: 'Private API: Calling update table handler');
1264: END IF;
1265:
1266: Select lead.win_probability, status.win_loss_indicator,

Line 1390: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1386: X_SALES_CREDIT_out_tbl(I).SALES_CREDIT_ID := l_sales_credit_rec.SALES_CREDIT_ID;
1387: X_SALES_CREDIT_out_tbl(I).return_status := x_return_status;
1388:
1389: IF l_debug THEN
1390: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1391: 'Private API17: Updated sales credit: ' ||l_sales_credit_rec.SALES_CREDIT_ID );
1392: END IF;
1393:
1394: if (l_sales_credit_rec.SALESGROUP_ID <> fnd_api.g_miss_num OR nvl(l_sales_credit_rec.PARTNER_CUSTOMER_ID, fnd_api.g_miss_num) <> fnd_api.g_miss_num)

Line 1437: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1433: nvl(FND_PROFILE.Value('AS_DEFAULT_FREEZE_FLAG'), 'Y');
1434:
1435: -- Debug Message
1436: IF l_debug THEN
1437: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1438: 'Calling Create_SalesTeam');
1439: END IF;
1440:
1441: AS_ACCESS_PUB.Create_SalesTeam (

Line 1460: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1456: );
1457:
1458: -- Debug Message
1459: IF l_debug THEN
1460: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1461: 'Create_SalesTeam: l_access_id = ' || l_access_id);
1462: END IF;
1463:
1464: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1466: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1462: END IF;
1463:
1464: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1465: IF l_debug THEN
1466: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1467: 'Create_SalesTeam fail');
1468: END IF;
1469: RAISE FND_API.G_EXC_ERROR;
1470: END IF;

Line 1502: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1498: ,x_access_id => l_Access_Id );
1499:
1500: -- Debug Message
1501: IF l_debug THEN
1502: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1503: 'update_SalesTeam: l_access_id = ' || l_access_id);
1504: END IF;
1505:
1506: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1508: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1504: END IF;
1505:
1506: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1507: IF l_debug THEN
1508: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1509: 'update_SalesTeam fail');
1510: END IF;
1511: RAISE FND_API.G_EXC_ERROR;
1512: END IF;

Line 1548: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1544: nvl(FND_PROFILE.Value('AS_DEFAULT_FREEZE_FLAG'), 'Y');
1545:
1546: -- Debug Message
1547: IF l_debug THEN
1548: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1549: 'Calling Create_SalesTeam');
1550: END IF;
1551:
1552: AS_ACCESS_PUB.Create_SalesTeam (

Line 1571: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1567: );
1568:
1569: -- Debug Message
1570: IF l_debug THEN
1571: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1572: 'Create_SalesTeam: l_access_id = ' || l_access_id);
1573: END IF;
1574:
1575: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1577: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1573: END IF;
1574:
1575: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1576: IF l_debug THEN
1577: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1578: 'Create_SalesTeam fail');
1579: END IF;
1580: RAISE FND_API.G_EXC_ERROR;
1581: END IF;

Line 1602: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1598:
1599:
1600: -- Debug Message
1601: IF l_debug THEN
1602: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1603: 'Private API: ' || l_api_name || 'end');
1604: END IF;
1605:
1606:

Line 1609: FND_MSG_PUB.Count_And_Get

1605:
1606:
1607:
1608: -- Standard call to get message count and if count is 1, get message info.
1609: FND_MSG_PUB.Count_And_Get
1610: ( p_count => x_msg_count,
1611: p_data => x_msg_data
1612: );
1613:

Line 1640: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1636: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1637: P_MODULE => l_module
1638: ,P_API_NAME => L_API_NAME
1639: ,P_PKG_NAME => G_PKG_NAME
1640: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1641: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1642: ,X_MSG_COUNT => X_MSG_COUNT
1643: ,X_MSG_DATA => X_MSG_DATA
1644: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1651: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1647: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1648: P_MODULE => l_module
1649: ,P_API_NAME => L_API_NAME
1650: ,P_PKG_NAME => G_PKG_NAME
1651: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1652: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1653: ,X_MSG_COUNT => X_MSG_COUNT
1654: ,X_MSG_DATA => X_MSG_DATA
1655: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1731: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

1727: DL NUMBER;
1728: delete_flag BOOLEAN;
1729: s_index NUMBER;
1730: e_index NUMBER;
1731: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1732: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lscpv.modify_sales_credits';
1733:
1734: BEGIN
1735: -- Standard Start of API savepoint

Line 1751: FND_MSG_PUB.initialize;

1747:
1748: -- Initialize message list if p_init_msg_list is set to TRUE.
1749: IF FND_API.to_Boolean( p_init_msg_list )
1750: THEN
1751: FND_MSG_PUB.initialize;
1752: END IF;
1753:
1754:
1755: -- Debug Message

Line 1757: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1753:
1754:
1755: -- Debug Message
1756: IF l_debug THEN
1757: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1758: 'Private API 18: ' || l_api_name || ' start');
1759: END IF;
1760:
1761: -- Initialize API return status to SUCCESS

Line 1779: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1775: ,x_msg_count => x_msg_count
1776: ,x_msg_data => x_msg_data
1777: ,x_sales_member_rec => l_identity_sales_member_rec);
1778: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1779: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1780: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1781: 'Private API 19: Get_CurrentUser fail');
1782: END IF;
1783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1780: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1776: ,x_msg_data => x_msg_data
1777: ,x_sales_member_rec => l_identity_sales_member_rec);
1778: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1779: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1780: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1781: 'Private API 19: Get_CurrentUser fail');
1782: END IF;
1783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1784: END IF;

Line 1809: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1805: ,x_msg_data => x_msg_data
1806: ,x_update_access_flag => l_update_access_flag );
1807:
1808: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1809: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1810: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1811: 'has_updateOpportunityAccess fail');
1812: END IF;
1813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1810: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1806: ,x_update_access_flag => l_update_access_flag );
1807:
1808: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1809: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1810: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1811: 'has_updateOpportunityAccess fail');
1812: END IF;
1813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1814: END IF;

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

1813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1814: END IF;
1815:
1816: IF (l_update_access_flag <> 'Y') THEN
1817: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1818: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
1819: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
1820: FND_MSG_PUB.ADD;
1821: END IF;

Line 1820: FND_MSG_PUB.ADD;

1816: IF (l_update_access_flag <> 'Y') THEN
1817: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1818: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
1819: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
1820: FND_MSG_PUB.ADD;
1821: END IF;
1822: RAISE FND_API.G_EXC_ERROR;
1823: END IF;
1824: END IF;

Line 1839: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1835: IF l_freeze_flag = 'Y'
1836: THEN
1837: l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');
1838: IF l_allow_flag <> 'Y' THEN
1839: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1840: 'API_OPP_FROZEN');
1841: RAISE FND_API.G_EXC_ERROR;
1842: END IF;
1843: END IF;

Line 1847: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1843: END IF;
1844: -- end 1554330
1845:
1846: IF l_forecast_credit_type_id IS NULL THEN
1847: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1848: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1849: 'The profile AS_FORECAST_CREDIT_TYPE_ID is null');
1850: END IF;
1851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1848: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1844: -- end 1554330
1845:
1846: IF l_forecast_credit_type_id IS NULL THEN
1847: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1848: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1849: 'The profile AS_FORECAST_CREDIT_TYPE_ID is null');
1850: END IF;
1851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1852: END IF;

Line 1894: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1890: x_msg_data => x_msg_data);
1891:
1892: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1893: IF l_debug THEN
1894: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1895: 'Private API 21: Validate_sales_credit fail');
1896: END IF;
1897: RAISE FND_API.G_EXC_ERROR;
1898: END IF;

Line 1903: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1899:
1900:
1901: IF l_sales_credit_rec.credit_type_id <> l_forecast_credit_type_id THEN
1902: IF l_debug THEN
1903: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1904: 'Private API: Credit_type is not forecast credit type');
1905: END IF;
1906: RAISE FND_API.G_EXC_ERROR;
1907: ELSE

Line 1917: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1913:
1914: -- 100% Validation
1915: IF nvl(l_total_forecast_percent, 0) <> 100 THEN
1916: IF l_debug THEN
1917: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1918: 'Private API 23: 100% Forecast Credit validation fail');
1919: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1920: 'Private API 24: l_total_percent = '||l_total_forecast_percent );
1921: END IF;

Line 1919: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1915: IF nvl(l_total_forecast_percent, 0) <> 100 THEN
1916: IF l_debug THEN
1917: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1918: 'Private API 23: 100% Forecast Credit validation fail');
1919: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1920: 'Private API 24: l_total_percent = '||l_total_forecast_percent );
1921: END IF;
1922: RAISE FND_API.G_EXC_ERROR;
1923: END IF;

Line 1927: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1923: END IF;
1924:
1925: IF l_lead_line_id IS NULL OR l_lead_line_id = FND_API.G_MISS_NUM THEN
1926: IF l_debug THEN
1927: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1928: 'Private API 25: lead_line_id is missing in the first sales credit record');
1929: END IF;
1930: RAISE FND_API.G_EXC_ERROR;
1931: END IF;

Line 1996: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1992: END IF;
1993:
1994: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1995: IF l_debug THEN
1996: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1997: 'Private API 26: Delete_Sales_credits fail');
1998: END IF;
1999: END IF;
2000: END IF;

Line 2031: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2027: END IF;
2028:
2029: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2030: IF l_debug THEN
2031: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2032: 'Private API 27: Create_Sales_credits fail');
2033: END IF;
2034: END IF;
2035: END IF;

Line 2066: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2062: END IF;
2063:
2064: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2065: IF l_debug THEN
2066: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2067: 'Private API 28: Update_Sales_credits fail');
2068: END IF;
2069: END IF;
2070: END IF;

Line 2104: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2100: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;
2101: --END IF;
2102:
2103: --IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2104: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2105: -- 'Private API 26: Delete_Sales_credits fail');
2106: --END IF;
2107:
2108:

Line 2135: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2131: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;
2132: --END IF;
2133:
2134: --IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2135: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2136: -- 'Private API 27: Create_Sales_credits fail');
2137: --END IF;
2138: -- end of the fix for the bug 2902247
2139:

Line 2154: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2150:
2151:
2152: -- Debug Message
2153: IF l_debug THEN
2154: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2155: 'Private API 28: ' || l_api_name || 'end');
2156: END IF;
2157:
2158: -- Standard call to get message count and if count is 1, get message info.

Line 2159: FND_MSG_PUB.Count_And_Get

2155: 'Private API 28: ' || l_api_name || 'end');
2156: END IF;
2157:
2158: -- Standard call to get message count and if count is 1, get message info.
2159: FND_MSG_PUB.Count_And_Get
2160: ( p_count => x_msg_count,
2161: p_data => x_msg_data
2162: );
2163:

Line 2171: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2167: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2168: P_MODULE => l_module
2169: ,P_API_NAME => L_API_NAME
2170: ,P_PKG_NAME => G_PKG_NAME
2171: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2172: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2173: ,X_MSG_COUNT => X_MSG_COUNT
2174: ,X_MSG_DATA => X_MSG_DATA
2175: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2182: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2178: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2179: P_MODULE => l_module
2180: ,P_API_NAME => L_API_NAME
2181: ,P_PKG_NAME => G_PKG_NAME
2182: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2183: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2184: ,X_MSG_COUNT => X_MSG_COUNT
2185: ,X_MSG_DATA => X_MSG_DATA
2186: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2236: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

2232: l_update_access_flag VARCHAR2(1);
2233: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
2234: l_freeze_flag VARCHAR2(1) := 'N'; -- solin, for bug 1554330
2235: l_allow_flag VARCHAR2(1); -- solin, for bug 1554330
2236: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2237: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lscpv.Delete_sales_credits';
2238:
2239: BEGIN
2240: -- Standard Start of API savepoint

Line 2256: FND_MSG_PUB.initialize;

2252:
2253: -- Initialize message list if p_init_msg_list is set to TRUE.
2254: IF FND_API.to_Boolean( p_init_msg_list )
2255: THEN
2256: FND_MSG_PUB.initialize;
2257: END IF;
2258:
2259:
2260: -- Debug Message

Line 2262: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2258:
2259:
2260: -- Debug Message
2261: IF l_debug THEN
2262: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2263: 'Private API 29: ' || l_api_name || 'start');
2264: END IF;
2265:
2266:

Line 2306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2302: ,x_msg_count => x_msg_count
2303: ,x_msg_data => x_msg_data
2304: ,x_sales_member_rec => l_identity_sales_member_rec);
2305: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2307: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2308: 'Private API 30: Get_CurrentUser fail');
2309: END IF;
2310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2307: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2303: ,x_msg_data => x_msg_data
2304: ,x_sales_member_rec => l_identity_sales_member_rec);
2305: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2307: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2308: 'Private API 30: Get_CurrentUser fail');
2309: END IF;
2310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2311: END IF;

Line 2336: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2332: ,x_msg_data => x_msg_data
2333: ,x_update_access_flag => l_update_access_flag );
2334:
2335: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2336: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2337: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2338: 'has_updateOpportunityAccess fail');
2339: END IF;
2340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2337: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2333: ,x_update_access_flag => l_update_access_flag );
2334:
2335: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2336: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2337: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2338: 'has_updateOpportunityAccess fail');
2339: END IF;
2340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2341: END IF;

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

2340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2341: END IF;
2342:
2343: IF (l_update_access_flag <> 'Y') THEN
2344: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2345: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
2346: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
2347: FND_MSG_PUB.ADD;
2348: END IF;

Line 2347: FND_MSG_PUB.ADD;

2343: IF (l_update_access_flag <> 'Y') THEN
2344: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2345: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
2346: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
2347: FND_MSG_PUB.ADD;
2348: END IF;
2349: RAISE FND_API.G_EXC_ERROR;
2350: END IF;
2351: END IF;

Line 2362: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

2358: IF l_freeze_flag = 'Y'
2359: THEN
2360: l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');
2361: IF l_allow_flag <> 'Y' THEN
2362: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2363: 'API_OPP_FROZEN');
2364: RAISE FND_API.G_EXC_ERROR;
2365: END IF;
2366: END IF;

Line 2376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2372: X_SALES_CREDIT_out_tbl(I).return_status := FND_API.G_RET_STS_SUCCESS;
2373:
2374: -- Progress Message
2375: --
2376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2377: THEN
2378: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
2379: --FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_SALES_CREDIT', TRUE);
2380: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);

Line 2381: --FND_MSG_PUB.Add;

2377: THEN
2378: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
2379: --FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_SALES_CREDIT', TRUE);
2380: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);
2381: --FND_MSG_PUB.Add;
2382: IF l_debug THEN
2383: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2384: 'Processing AS_OPP_SALES_CREDIT row number '||to_char(I));
2385: END IF;

Line 2383: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2379: --FND_MESSAGE.Set_Token ('ROW', 'AS_OPP_SALES_CREDIT', TRUE);
2380: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(I), FALSE);
2381: --FND_MSG_PUB.Add;
2382: IF l_debug THEN
2383: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2384: 'Processing AS_OPP_SALES_CREDIT row number '||to_char(I));
2385: END IF;
2386: END IF;
2387:

Line 2390: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2386: END IF;
2387:
2388: -- Debug Message
2389: IF l_debug THEN
2390: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2391: 'Private API 31: Calling delete table handler');
2392: END IF;
2393:
2394: AS_SALES_CREDITS_PKG.Delete_Row(

Line 2417: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2413:
2414:
2415: -- Debug Message
2416: IF l_debug THEN
2417: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2418: 'Private API 32: ' || l_api_name || 'end');
2419: END IF;
2420:
2421: -- Standard call to get message count and if count is 1, get message info.

Line 2422: FND_MSG_PUB.Count_And_Get

2418: 'Private API 32: ' || l_api_name || 'end');
2419: END IF;
2420:
2421: -- Standard call to get message count and if count is 1, get message info.
2422: FND_MSG_PUB.Count_And_Get
2423: ( p_count => x_msg_count,
2424: p_data => x_msg_data
2425: );
2426:

Line 2453: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2449: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2450: P_MODULE => l_module
2451: ,P_API_NAME => L_API_NAME
2452: ,P_PKG_NAME => G_PKG_NAME
2453: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2454: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2455: ,X_MSG_COUNT => X_MSG_COUNT
2456: ,X_MSG_DATA => X_MSG_DATA
2457: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2464: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2460: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2461: P_MODULE => l_module
2462: ,P_API_NAME => L_API_NAME
2463: ,P_PKG_NAME => G_PKG_NAME
2464: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2465: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2466: ,X_MSG_COUNT => X_MSG_COUNT
2467: ,X_MSG_DATA => X_MSG_DATA
2468: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2499: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

2495: FROM as_sales_credits
2496: WHERE sales_credit_id = c_Sales_Credit_Id;
2497:
2498: l_val VARCHAR2(1);
2499: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2500: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lscpv.Validate_SALES_CREDIT_ID';
2501:
2502:
2503: BEGIN

Line 2508: FND_MSG_PUB.initialize;

2504:
2505: -- Initialize message list if p_init_msg_list is set to TRUE.
2506: IF FND_API.to_Boolean( p_init_msg_list )
2507: THEN
2508: FND_MSG_PUB.initialize;
2509: END IF;
2510:
2511:
2512: -- Initialize API return status to SUCCESS

Line 2525: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

2521: OPEN C_Sales_Credit_Id_Exists (p_Sales_Credit_Id);
2522: FETCH C_Sales_Credit_Id_Exists into l_val;
2523: IF C_Sales_Credit_Id_Exists%FOUND THEN
2524: IF l_debug THEN
2525: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2526: 'Private API 33: SALES_CREDIT_ID exist');
2527: END IF;
2528:
2529: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2541: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

2537: -- validate NOT NULL column
2538: IF (p_SALES_CREDIT_ID is NULL) or (p_SALES_CREDIT_ID = FND_API.G_MISS_NUM)
2539: THEN
2540: IF l_debug THEN
2541: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2542: 'Private API 34: Violate NOT NULL constraint(SALES_CREDIT_ID)');
2543: END IF;
2544: x_return_status := FND_API.G_RET_STS_ERROR;
2545: ELSE

Line 2551: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

2547: FETCH C_Sales_Credit_Id_Exists into l_val;
2548: IF C_Sales_Credit_Id_Exists%NOTFOUND
2549: THEN
2550: IF l_debug THEN
2551: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2552: 'Private API 35: SALES_CREDIT_ID is not valid');
2553: END IF;
2554:
2555: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2563: FND_MSG_PUB.Count_And_Get

2559:
2560: END IF;
2561:
2562: -- Standard call to get message count and if count is 1, get message info.
2563: FND_MSG_PUB.Count_And_Get
2564: ( p_count => x_msg_count,
2565: p_data => x_msg_data
2566: );
2567:

Line 2587: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

2583: FROM as_leads
2584: WHERE lead_id = c_Lead_Id;
2585:
2586: l_val VARCHAR2(1);
2587: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2588: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lscpv.Validate_LEAD_ID';
2589:
2590:
2591: BEGIN

Line 2596: FND_MSG_PUB.initialize;

2592:
2593: -- Initialize message list if p_init_msg_list is set to TRUE.
2594: IF FND_API.to_Boolean( p_init_msg_list )
2595: THEN
2596: FND_MSG_PUB.initialize;
2597: END IF;
2598:
2599:
2600: -- Initialize API return status to SUCCESS

Line 2607: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

2603:
2604: IF (p_LEAD_ID is NULL) or (p_LEAD_ID = FND_API.G_MISS_NUM)
2605: THEN
2606: IF l_debug THEN
2607: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2608: 'Private API 36: Violate NOT NULL constraint(LEAD_ID)');
2609: END IF;
2610:
2611: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2618: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

2614: FETCH C_Lead_Id_Exists into l_val;
2615: IF C_Lead_Id_Exists%NOTFOUND
2616: THEN
2617: IF l_debug THEN
2618: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2619: 'Private API 37: LEAD_ID is not valid');
2620: END IF;
2621:
2622: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2628: FND_MSG_PUB.Count_And_Get

2624: CLOSE C_Lead_Id_Exists;
2625: END IF;
2626:
2627: -- Standard call to get message count and if count is 1, get message info.
2628: FND_MSG_PUB.Count_And_Get
2629: ( p_count => x_msg_count,
2630: p_data => x_msg_data
2631: );
2632:

Line 2652: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

2648: FROM as_lead_lines
2649: WHERE lead_line_id = c_Lead_Line_Id;
2650:
2651: l_val VARCHAR2(1);
2652: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2653: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lscpv.Validate_LEAD_LINE_ID';
2654:
2655: BEGIN
2656:

Line 2660: FND_MSG_PUB.initialize;

2656:
2657: -- Initialize message list if p_init_msg_list is set to TRUE.
2658: IF FND_API.to_Boolean( p_init_msg_list )
2659: THEN
2660: FND_MSG_PUB.initialize;
2661: END IF;
2662:
2663:
2664: -- Initialize API return status to SUCCESS

Line 2671: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

2667:
2668: IF (p_LEAD_LINE_ID is NULL) or (p_LEAD_LINE_ID = FND_API.G_MISS_NUM)
2669: THEN
2670: IF l_debug THEN
2671: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2672: 'Private API 38: Violate NOT NULL constraint(LEAD_LINE_ID)');
2673: END IF;
2674:
2675: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2682: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

2678: FETCH C_Lead_Line_Id_Exists into l_val;
2679: IF C_Lead_Line_Id_Exists%NOTFOUND
2680: THEN
2681: IF l_debug THEN
2682: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2683: 'Private API 39: LEAD_LINE_ID is not valid');
2684: END IF;
2685:
2686: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2692: FND_MSG_PUB.Count_And_Get

2688: CLOSE C_Lead_Line_Id_Exists;
2689: END IF;
2690:
2691: -- Standard call to get message count and if count is 1, get message info.
2692: FND_MSG_PUB.Count_And_Get
2693: ( p_count => x_msg_count,
2694: p_data => x_msg_data
2695: );
2696:

Line 2716: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

2712: FROM as_salesforce_v
2713: WHERE salesforce_id = c_Salesforce_Id;
2714:
2715: l_val VARCHAR2(1);
2716: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2717: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lscpv.Validate_SALESFORCE_ID';
2718:
2719: BEGIN
2720:

Line 2724: FND_MSG_PUB.initialize;

2720:
2721: -- Initialize message list if p_init_msg_list is set to TRUE.
2722: IF FND_API.to_Boolean( p_init_msg_list )
2723: THEN
2724: FND_MSG_PUB.initialize;
2725: END IF;
2726:
2727:
2728: -- Initialize API return status to SUCCESS

Line 2735: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

2731:
2732: IF (p_SALESFORCE_ID is NULL) or (p_SALESFORCE_ID = FND_API.G_MISS_NUM)
2733: THEN
2734: IF l_debug THEN
2735: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2736: 'Private API 40: Violate NOT NULL constraint(SALESFORCE_ID)');
2737: END IF;
2738:
2739: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2746: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

2742: FETCH C_Salesforce_Id_Exists into l_val;
2743: IF C_Salesforce_Id_Exists%NOTFOUND
2744: THEN
2745: IF l_debug THEN
2746: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2747: 'Private API 41: SALESFORCE_ID is not valid');
2748: END IF;
2749:
2750: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2756: FND_MSG_PUB.Count_And_Get

2752: CLOSE C_Salesforce_Id_Exists;
2753: END IF;
2754:
2755: -- Standard call to get message count and if count is 1, get message info.
2756: FND_MSG_PUB.Count_And_Get
2757: ( p_count => x_msg_count,
2758: p_data => x_msg_data
2759: );
2760:

Line 2780: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

2776: FROM as_salesforce_v
2777: WHERE EMPLOYEE_PERSON_ID = c_PERSON_ID;
2778:
2779: l_val VARCHAR2(1);
2780: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2781: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lscpv.Validate_PERSON_ID';
2782:
2783: BEGIN
2784:

Line 2788: FND_MSG_PUB.initialize;

2784:
2785: -- Initialize message list if p_init_msg_list is set to TRUE.
2786: IF FND_API.to_Boolean( p_init_msg_list )
2787: THEN
2788: FND_MSG_PUB.initialize;
2789: END IF;
2790:
2791:
2792: -- Initialize API return status to SUCCESS

Line 2802: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

2798: OPEN C_PERSON_ID_Exists (p_PERSON_ID);
2799: FETCH C_PERSON_ID_Exists into l_val;
2800: IF C_PERSON_ID_Exists%NOTFOUND THEN
2801: IF l_debug THEN
2802: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2803: 'Private API 42: PERSON_ID is invalid');
2804: END IF;
2805:
2806: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2812: FND_MSG_PUB.Count_And_Get

2808: CLOSE C_PERSON_ID_Exists;
2809: END IF;
2810:
2811: -- Standard call to get message count and if count is 1, get message info.
2812: FND_MSG_PUB.Count_And_Get
2813: ( p_count => x_msg_count,
2814: p_data => x_msg_data
2815: );
2816:

Line 2846: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

2842: nvl(a.end_date_active,sysdate)
2843: AND a.group_id = c_SALES_GROUP_ID;
2844:
2845: l_val VARCHAR2(1);
2846: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2847:
2848: BEGIN
2849:
2850: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2853: FND_MSG_PUB.initialize;

2849:
2850: -- Initialize message list if p_init_msg_list is set to TRUE.
2851: IF FND_API.to_Boolean( p_init_msg_list )
2852: THEN
2853: FND_MSG_PUB.initialize;
2854: END IF;
2855:
2856:
2857: -- Initialize API return status to SUCCESS

Line 2869: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

2865: OPEN C_SALES_GROUP_ID_Exists (p_SALESGROUP_ID);
2866: FETCH C_SALES_GROUP_ID_Exists into l_val;
2867: IF C_SALES_GROUP_ID_Exists%NOTFOUND THEN
2868: IF l_debug THEN
2869: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
2870: 'SALES_GROUP_ID1 is invalid');
2871: END IF;
2872:
2873: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2881: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

2877: OPEN C_PRTNR_SALES_GROUP_ID_Exists (p_SALESGROUP_ID);
2878: FETCH C_PRTNR_SALES_GROUP_ID_Exists into l_val;
2879: IF C_PRTNR_SALES_GROUP_ID_Exists%NOTFOUND THEN
2880: IF l_debug THEN
2881: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
2882: 'SALES_GROUP_ID2 is invalid');
2883: END IF;
2884: x_return_status := FND_API.G_RET_STS_ERROR;
2885: END IF;

Line 2892: FND_MSG_PUB.Count_And_Get

2888: END IF;
2889:
2890: */
2891: -- Standard call to get message count and if count is 1, get message info.
2892: FND_MSG_PUB.Count_And_Get
2893: ( p_count => x_msg_count,
2894: p_data => x_msg_data
2895: );
2896:

Line 2916: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

2912: FROM as_salesforce_v
2913: WHERE PARTNER_CUSTOMER_ID = c_PARTNER_CUSTOMER_ID;
2914:
2915: l_val VARCHAR2(1);
2916: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2917: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lscpv.Validate_PARTNER_CUSTOMER_ID';
2918:
2919: BEGIN
2920:

Line 2924: FND_MSG_PUB.initialize;

2920:
2921: -- Initialize message list if p_init_msg_list is set to TRUE.
2922: IF FND_API.to_Boolean( p_init_msg_list )
2923: THEN
2924: FND_MSG_PUB.initialize;
2925: END IF;
2926:
2927:
2928: -- Initialize API return status to SUCCESS

Line 2938: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

2934: OPEN C_PARTNER_CUSTOMER_ID_Exists (p_PARTNER_CUSTOMER_ID);
2935: FETCH C_PARTNER_CUSTOMER_ID_Exists into l_val;
2936: IF C_PARTNER_CUSTOMER_ID_Exists%NOTFOUND THEN
2937: IF l_debug THEN
2938: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2939: 'Private API 43: PARTNER_CUSTOMER_ID is invalid');
2940: END IF;
2941:
2942: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2948: FND_MSG_PUB.Count_And_Get

2944: CLOSE C_PARTNER_CUSTOMER_ID_Exists;
2945: END IF;
2946:
2947: -- Standard call to get message count and if count is 1, get message info.
2948: FND_MSG_PUB.Count_And_Get
2949: ( p_count => x_msg_count,
2950: p_data => x_msg_data
2951: );
2952:

Line 2972: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

2968: FROM as_salesforce_v
2969: WHERE PARTNER_ADDRESS_ID = c_PARTNER_ADDRESS_ID;
2970:
2971: l_val VARCHAR2(1);
2972: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2973: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lscpv.Validate_PARTNER_ADDRESS_ID';
2974:
2975: BEGIN
2976:

Line 2980: FND_MSG_PUB.initialize;

2976:
2977: -- Initialize message list if p_init_msg_list is set to TRUE.
2978: IF FND_API.to_Boolean( p_init_msg_list )
2979: THEN
2980: FND_MSG_PUB.initialize;
2981: END IF;
2982:
2983:
2984: -- Initialize API return status to SUCCESS

Line 2994: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

2990: OPEN C_PARTNER_ADDRESS_ID_Exists (p_PARTNER_ADDRESS_ID);
2991: FETCH C_PARTNER_ADDRESS_ID_Exists into l_val;
2992: IF C_PARTNER_ADDRESS_ID_Exists%NOTFOUND THEN
2993: IF l_debug THEN
2994: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2995: 'Private API 44: PARTNER_ADDRESS_ID is invalid');
2996: END IF;
2997:
2998: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3004: FND_MSG_PUB.Count_And_Get

3000: CLOSE C_PARTNER_ADDRESS_ID_Exists;
3001: END IF;
3002:
3003: -- Standard call to get message count and if count is 1, get message info.
3004: FND_MSG_PUB.Count_And_Get
3005: ( p_count => x_msg_count,
3006: p_data => x_msg_data
3007: );
3008:

Line 3028: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

3024: FROM oe_sales_credit_types
3025: WHERE sales_credit_type_id = c_Credit_Type_Id;
3026:
3027: l_val VARCHAR2(1);
3028: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3029: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lscpv.Validate_CREDIT_TYPE_ID';
3030:
3031: BEGIN
3032:

Line 3036: FND_MSG_PUB.initialize;

3032:
3033: -- Initialize message list if p_init_msg_list is set to TRUE.
3034: IF FND_API.to_Boolean( p_init_msg_list )
3035: THEN
3036: FND_MSG_PUB.initialize;
3037: END IF;
3038:
3039:
3040: -- Initialize API return status to SUCCESS

Line 3046: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

3042:
3043:
3044: IF (p_CREDIT_TYPE_ID is NULL) or (p_CREDIT_TYPE_ID = FND_API.G_MISS_NUM)
3045: THEN
3046: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
3047: -- 'Private API 45: Violate NOT NULL constraint(CREDIT_TYPE_ID)');
3048:
3049: AS_UTILITY_PVT.Set_Message(
3050: p_module => l_module,

Line 3051: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

3047: -- 'Private API 45: Violate NOT NULL constraint(CREDIT_TYPE_ID)');
3048:
3049: AS_UTILITY_PVT.Set_Message(
3050: p_module => l_module,
3051: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
3052: p_msg_name => 'API_MISSING_ID',
3053: p_token1 => 'COLUMN',
3054: p_token1_value => 'CREDIT_TYPE_ID');
3055:

Line 3064: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

3060: FETCH C_Credit_Type_Id_Exists into l_val;
3061: IF C_Credit_Type_Id_Exists%NOTFOUND
3062: THEN
3063: IF l_debug THEN
3064: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
3065: 'Private API 46: CREDIT_TYPE_ID is not valid');
3066: END IF;
3067:
3068: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3074: FND_MSG_PUB.Count_And_Get

3070: CLOSE C_Credit_Type_Id_Exists;
3071: END IF;
3072:
3073: -- Standard call to get message count and if count is 1, get message info.
3074: FND_MSG_PUB.Count_And_Get
3075: ( p_count => x_msg_count,
3076: p_data => x_msg_data
3077: );
3078:

Line 3128: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

3124: WHERE sales_group_id = X_Sales_Group_Id;
3125:
3126: l_val VARCHAR2(1);
3127: l_api_name CONSTANT VARCHAR2(30) := 'Validate_sales_credit_rec';
3128: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3129: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lscpv.Validate_SALES_CREDIT_rec';
3130:
3131: BEGIN
3132:

Line 3136: FND_MSG_PUB.initialize;

3132:
3133: -- Initialize message list if p_init_msg_list is set to TRUE.
3134: IF FND_API.to_Boolean( p_init_msg_list )
3135: THEN
3136: FND_MSG_PUB.initialize;
3137: END IF;
3138:
3139: -- Debug Message
3140: IF l_debug THEN

Line 3141: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3137: END IF;
3138:
3139: -- Debug Message
3140: IF l_debug THEN
3141: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3142: 'Private API 47: ' || l_api_name || ' start');
3143: END IF;
3144:
3145:

Line 3155: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'salesforce id' || p_sales_credit_rec.salesforce_id);

3151: --
3152: -- Member must exist
3153: --
3154: IF l_debug THEN
3155: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'salesforce id' || p_sales_credit_rec.salesforce_id);
3156:
3157: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'person_id' || p_sales_credit_rec.person_id);
3158: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'partner_customer_id' || p_sales_credit_rec.partner_customer_id);
3159: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'partner_customer_id' || p_sales_credit_rec.salesgroup_id);

Line 3157: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'person_id' || p_sales_credit_rec.person_id);

3153: --
3154: IF l_debug THEN
3155: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'salesforce id' || p_sales_credit_rec.salesforce_id);
3156:
3157: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'person_id' || p_sales_credit_rec.person_id);
3158: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'partner_customer_id' || p_sales_credit_rec.partner_customer_id);
3159: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'partner_customer_id' || p_sales_credit_rec.salesgroup_id);
3160: END IF;
3161:

Line 3158: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'partner_customer_id' || p_sales_credit_rec.partner_customer_id);

3154: IF l_debug THEN
3155: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'salesforce id' || p_sales_credit_rec.salesforce_id);
3156:
3157: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'person_id' || p_sales_credit_rec.person_id);
3158: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'partner_customer_id' || p_sales_credit_rec.partner_customer_id);
3159: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'partner_customer_id' || p_sales_credit_rec.salesgroup_id);
3160: END IF;
3161:
3162:

Line 3159: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'partner_customer_id' || p_sales_credit_rec.salesgroup_id);

3155: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'salesforce id' || p_sales_credit_rec.salesforce_id);
3156:
3157: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'person_id' || p_sales_credit_rec.person_id);
3158: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'partner_customer_id' || p_sales_credit_rec.partner_customer_id);
3159: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'partner_customer_id' || p_sales_credit_rec.salesgroup_id);
3160: END IF;
3161:
3162:
3163: IF p_sales_credit_rec.salesforce_id is NULL

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

3161:
3162:
3163: IF p_sales_credit_rec.salesforce_id is NULL
3164: THEN
3165: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3166: THEN
3167: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
3168: FND_MESSAGE.Set_Token('COLUMN', 'TRANS_SALESFORCE', TRUE);
3169: FND_MSG_PUB.ADD;

Line 3169: FND_MSG_PUB.ADD;

3165: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3166: THEN
3167: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
3168: FND_MESSAGE.Set_Token('COLUMN', 'TRANS_SALESFORCE', TRUE);
3169: FND_MSG_PUB.ADD;
3170: END IF;
3171:
3172: IF l_debug THEN
3173: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 3173: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3169: FND_MSG_PUB.ADD;
3170: END IF;
3171:
3172: IF l_debug THEN
3173: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3174: 'Private API 48: SALESFORCE_ID is NULL');
3175: END IF;
3176:
3177: x_return_status := FND_API.G_RET_STS_ERROR;

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

3186: (nvl(p_sales_credit_rec.person_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num)
3187:
3188:
3189: THEN
3190: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3191: THEN
3192: FND_MESSAGE.Set_Name('AS', 'API_MEMBER_TOO_MANY_VALUES');
3193: FND_MSG_PUB.ADD;
3194: END IF;

Line 3193: FND_MSG_PUB.ADD;

3189: THEN
3190: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3191: THEN
3192: FND_MESSAGE.Set_Name('AS', 'API_MEMBER_TOO_MANY_VALUES');
3193: FND_MSG_PUB.ADD;
3194: END IF;
3195:
3196: x_return_status := FND_API.G_RET_STS_ERROR;
3197:

Line 3210: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

3206: -- If an admin who is not in any group created an opp., sales group
3207: -- id in sales credit table would be NULL. So, remove this logic.
3208: -- IF p_sales_credit_rec.salesgroup_id is NULL
3209: -- THEN
3210: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3211: -- THEN
3212: -- FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
3213: -- FND_MESSAGE.Set_Token('COLUMN', 'SALESGROUP_ID', FALSE);
3214: -- FND_MSG_PUB.ADD;

Line 3214: -- FND_MSG_PUB.ADD;

3210: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3211: -- THEN
3212: -- FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
3213: -- FND_MESSAGE.Set_Token('COLUMN', 'SALESGROUP_ID', FALSE);
3214: -- FND_MSG_PUB.ADD;
3215: -- END IF;
3216: --
3217: -- l_return_status := FND_API.G_RET_STS_ERROR;
3218: --

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

3222: p_sales_credit_rec.person_id );
3223: FETCH C_Salesforce_Person_Exists INTO l_val;
3224: IF C_Salesforce_Person_Exists%NOTFOUND
3225: THEN
3226: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3227: THEN
3228: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
3229: FND_MESSAGE.Set_Token('COLUMN', 'SALESFORCE_ID, PERSON_ID', FALSE);
3230: FND_MESSAGE.Set_Token('VALUE', p_sales_credit_rec.salesforce_id || ',' ||

Line 3232: FND_MSG_PUB.ADD;

3228: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
3229: FND_MESSAGE.Set_Token('COLUMN', 'SALESFORCE_ID, PERSON_ID', FALSE);
3230: FND_MESSAGE.Set_Token('VALUE', p_sales_credit_rec.salesforce_id || ',' ||
3231: p_sales_credit_rec.person_id, FALSE);
3232: FND_MSG_PUB.ADD;
3233: END IF;
3234:
3235: x_return_status := FND_API.G_RET_STS_ERROR;
3236: END IF;

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

3244: p_sales_credit_rec.partner_customer_id);
3245: FETCH C_Salesforce_Partner_Exists INTO l_val;
3246: IF C_Salesforce_Partner_Exists%NOTFOUND
3247: THEN
3248: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3249: THEN
3250: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
3251: FND_MESSAGE.Set_Token('COLUMN', 'SALESFORCE_ID, PARTNER_CUSTOMER_ID,
3252: PARTNER_ADDRESS_ID', FALSE);

Line 3256: FND_MSG_PUB.ADD;

3252: PARTNER_ADDRESS_ID', FALSE);
3253: FND_MESSAGE.Set_Token('VALUE', p_sales_credit_rec.salesforce_id || ',' ||
3254: p_sales_credit_rec.partner_customer_id || ',' ||
3255: p_sales_credit_rec.partner_address_id , FALSE);
3256: FND_MSG_PUB.ADD;
3257: END IF;
3258:
3259: x_return_status := FND_API.G_RET_STS_ERROR;
3260: END IF;

Line 3264: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3260: END IF;
3261: CLOSE C_Salesforce_Partner_Exists;
3262: ELSE
3263: IF l_debug THEN
3264: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3265: 'Private API 49: Both PERSON_ID and PARTNER_CUSTOMER_ID are NULL');
3266: END IF;
3267:
3268: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3273: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3269: END IF;
3270:
3271: -- Debug Message
3272: IF l_debug THEN
3273: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3274: 'Private API 50: ' || l_api_name || ' end');
3275: END IF;
3276:
3277:

Line 3279: FND_MSG_PUB.Count_And_Get

3275: END IF;
3276:
3277:
3278: -- Standard call to get message count and if count is 1, get message info.
3279: FND_MSG_PUB.Count_And_Get
3280: ( p_count => x_msg_count,
3281: p_data => x_msg_data
3282: );
3283:

Line 3297: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

3293: X_Msg_Data OUT NOCOPY VARCHAR2
3294: )
3295: IS
3296: l_api_name CONSTANT VARCHAR2(30) := 'Validate_sales_credit';
3297: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3298: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lscpv.Validate_sales_credit';
3299:
3300: BEGIN
3301:

Line 3304: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3300: BEGIN
3301:
3302: -- Debug Message
3303: IF l_debug THEN
3304: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3305: 'Private API 51: ' || l_api_name || 'start');
3306: END IF;
3307:
3308:

Line 3318: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3314: -- Hint: We provide validation procedure for every column. Developer should delete
3315: -- unnecessary validation procedures.
3316:
3317: IF l_debug THEN
3318: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3319: 'Private API 52: Validate Items start');
3320: END IF;
3321: -- Begin Added for ASNB
3322: IF nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'), 'N') = 'Y' AND

Line 3336: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3332: raise FND_API.G_EXC_ERROR;
3333: END IF;
3334:
3335: IF l_debug THEN
3336: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3337: 'Private API 53: Validated SALES_CREDIT_ID');
3338: END IF;
3339: END IF;
3340: -- End Added for ASNB

Line 3354: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3350: raise FND_API.G_EXC_ERROR;
3351: END IF;
3352:
3353: IF l_debug THEN
3354: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3355: 'Private API 53: Validated SALES_CREDIT_ID');
3356: END IF;
3357:
3358:

Line 3371: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3367: raise FND_API.G_EXC_ERROR;
3368: END IF;
3369:
3370: IF l_debug THEN
3371: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3372: 'Private API 54: Validated LEAD_ID');
3373: END IF;
3374:
3375:

Line 3388: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3384: raise FND_API.G_EXC_ERROR;
3385: END IF;
3386:
3387: IF l_debug THEN
3388: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3389: 'Private API 55: Validated LEAD_LINE_ID');
3390:
3391: END IF;
3392:

Line 3430: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3426: raise FND_API.G_EXC_ERROR;
3427: END IF;
3428:
3429: IF l_debug THEN
3430: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3431: 'Private API 56: Validated SALESGROUP_ID');
3432: END IF;
3433:
3434:

Line 3470: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3466: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3467: raise FND_API.G_EXC_ERROR;
3468: END IF;
3469: IF l_debug THEN
3470: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3471: 'Private API 57: Validated CREDIT_TYPE_ID ');
3472:
3473: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3474: 'Private API 58: Validate Items end');

Line 3473: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3469: IF l_debug THEN
3470: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3471: 'Private API 57: Validated CREDIT_TYPE_ID ');
3472:
3473: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3474: 'Private API 58: Validate Items end');
3475: END IF;
3476:
3477:

Line 3494: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3490: x_msg_data => x_msg_data);
3491:
3492: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3493: IF l_debug THEN
3494: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3495: 'Private API 59: SALES_CREDIT_Rec is invalid');
3496: END IF;
3497:
3498: raise FND_API.G_EXC_ERROR;

Line 3515: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3511: END IF;
3512:
3513: -- Debug Message
3514: IF l_debug THEN
3515: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3516: 'Private API 60: ' || l_api_name || 'end');
3517: END IF;
3518:
3519:

Line 3547: FND_MSG_PUB.initialize;

3543: BEGIN
3544: -- Initialize message list if p_init_msg_list is set to TRUE.
3545: IF FND_API.to_Boolean( p_init_msg_list )
3546: THEN
3547: FND_MSG_PUB.initialize;
3548: END IF;
3549:
3550:
3551: -- Initialize API return status to SUCCESS

Line 3559: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

3555: FETCH C_dup_Sales_Credit_Exists into l_val;
3556: IF C_dup_Sales_Credit_Exists%FOUND THEN
3557: AS_UTILITY_PVT.Set_Message(
3558: p_module => l_module,
3559: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
3560: p_msg_name => 'AS_DUP_SALES_CREDITS');
3561: x_return_status := FND_API.G_RET_STS_ERROR;
3562: END IF;
3563: CLOSE C_dup_Sales_Credit_Exists;

Line 3564: FND_MSG_PUB.Count_And_Get

3560: p_msg_name => 'AS_DUP_SALES_CREDITS');
3561: x_return_status := FND_API.G_RET_STS_ERROR;
3562: END IF;
3563: CLOSE C_dup_Sales_Credit_Exists;
3564: FND_MSG_PUB.Count_And_Get
3565: ( p_count => x_msg_count,
3566: p_data => x_msg_data
3567: );
3568: