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_SALES_LEAD_LINES_PVT dependencies on FND_MSG_PUB

Line 19: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

15:
16: -- Local procedure to reset Opp Header with total_amount
17: -- by the sum of the total_amounts of the lines
18:
19: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
20: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
21: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
22: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
23:

Line 20: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

16: -- Local procedure to reset Opp Header with total_amount
17: -- by the sum of the total_amounts of the lines
18:
19: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
20: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
21: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
22: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
23:
24: PROCEDURE Backupdate_Header(

Line 21: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

17: -- by the sum of the total_amounts of the lines
18:
19: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
20: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
21: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
22: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
23:
24: PROCEDURE Backupdate_Header(
25: p_sales_lead_id IN NUMBER,

Line 22: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);

18:
19: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
20: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
21: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
22: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
23:
24: PROCEDURE Backupdate_Header(
25: p_sales_lead_id IN NUMBER,
26: x_return_status OUT NOCOPY VARCHAR2

Line 92: FND_MSG_PUB.initialize;

88: BEGIN
89: -- Initialize message list IF p_init_msg_list is set to TRUE.
90: IF FND_API.to_Boolean( p_init_msg_list )
91: THEN
92: FND_MSG_PUB.initialize;
93: END IF;
94:
95: -- Initialize API return status to SUCCESS
96: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 99: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

95: -- Initialize API return status to SUCCESS
96: x_return_status := FND_API.G_RET_STS_SUCCESS;
97:
98: -- Debug Message
99: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
100: -- 'Validate Sales Lead Id'); END IF;
101:
102: -- ffang 092000 for bug 1406777
103: -- Calling from Create API

Line 115: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

111:
112: IF C_Sales_Lead_Id_Exists%NOTFOUND
113: THEN
114: AS_UTILITY_PVT.Set_Message(
115: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
116: p_msg_name => 'API_INVALID_ID',
117: p_token1 => 'SALES_LEAD_ID',
118: p_token1_value => p_Sales_Lead_Id);
119:

Line 132: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

128: -- validate NOT NULL column
129: IF (p_sales_lead_id is NULL) or (p_sales_lead_id = FND_API.G_MISS_NUM)
130: THEN
131: AS_UTILITY_PVT.Set_Message(
132: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
133: p_msg_name => 'API_MISSING_LEAD_ID');
134:
135: x_return_status := FND_API.G_RET_STS_ERROR;
136: ELSE

Line 143: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

139:
140: IF C_Sales_Lead_Id_Exists%NOTFOUND
141: THEN
142: AS_UTILITY_PVT.Set_Message(
143: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
144: p_msg_name => 'API_INVALID_LEAD_ID',
145: p_token1 => 'VALUE',
146: p_token1_value => p_sales_lead_id );
147:

Line 157: FND_MSG_PUB.Count_And_Get

153: END IF;
154: -- end ffang 092000 for bug 1306777
155:
156: -- Standard call to get message count and IF count is 1, get message info.
157: FND_MSG_PUB.Count_And_Get
158: ( p_count => x_msg_count,
159: p_data => x_msg_data );
160:
161: END Validate_SALES_LEAD_ID;

Line 186: FND_MSG_PUB.initialize;

182: BEGIN
183: -- Initialize message list IF p_init_msg_list is set to TRUE.
184: IF FND_API.to_Boolean( p_init_msg_list )
185: THEN
186: FND_MSG_PUB.initialize;
187: END IF;
188:
189: -- Initialize API return status to SUCCESS
190: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 202: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

198:
199: IF (C_Int_Type_Exists%NOTFOUND)
200: THEN
201: AS_UTILITY_PVT.Set_Message(
202: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
203: p_msg_name => 'API_INVALID_ID',
204: p_token1 => 'COLUMN',
205: p_token1_value => 'INTEREST_TYPE_ID',
206: p_token2 => 'VALUE',

Line 214: FND_MSG_PUB.Count_And_Get

210: CLOSE C_Int_Type_Exists;
211: END IF;
212:
213: -- Standard call to get message count and IF count is 1, get message info.
214: FND_MSG_PUB.Count_And_Get
215: ( p_count => x_msg_count,
216: p_data => x_msg_data );
217: END Validate_INTEREST_TYPE_ID;
218:

Line 246: FND_MSG_PUB.initialize;

242:
243: -- Initialize message list IF p_init_msg_list is set to TRUE.
244: IF FND_API.to_Boolean( p_init_msg_list )
245: THEN
246: FND_MSG_PUB.initialize;
247: END IF;
248:
249: -- Initialize API return status to SUCCESS
250: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 263: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

259:
260: IF (C_Prim_Int_Code_Exists%NOTFOUND)
261: THEN
262: AS_UTILITY_PVT.Set_Message(
263: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
264: p_msg_name => 'API_INVALID_ID',
265: p_token1 => 'COLUMN',
266: p_token1_value => 'PRIMARY_INTEREST_CODE_ID',
267: p_token2 => 'VALUE',

Line 275: FND_MSG_PUB.Count_And_Get

271: CLOSE C_Prim_Int_Code_Exists;
272: END IF;
273:
274: -- Standard call to get message count and IF count is 1, get message info.
275: FND_MSG_PUB.Count_And_Get
276: ( p_count => x_msg_count,
277: p_data => x_msg_data );
278: END Validate_PRIM_INT_CODE_ID;
279:

Line 307: FND_MSG_PUB.initialize;

303: BEGIN
304: -- Initialize message list IF p_init_msg_list is set to TRUE.
305: IF FND_API.to_Boolean( p_init_msg_list )
306: THEN
307: FND_MSG_PUB.initialize;
308: END IF;
309:
310: -- Initialize API return status to SUCCESS
311: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 324: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

320: FETCH C_Sec_Int_Code_Exists INTO l_variable;
321: IF (C_Sec_Int_Code_Exists%NOTFOUND)
322: THEN
323: AS_UTILITY_PVT.Set_Message(
324: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
325: p_msg_name => 'API_INVALID_ID',
326: p_token1 => 'COLUMN',
327: p_token1_value => 'SECONDARY_INTEREST_CODE_ID',
328: p_token2 => 'VALUE',

Line 336: FND_MSG_PUB.Count_And_Get

332: CLOSE C_Sec_Int_Code_Exists;
333: END IF;
334:
335: -- Standard call to get message count and IF count is 1, get message info.
336: FND_MSG_PUB.Count_And_Get
337: ( p_count => x_msg_count,
338: p_data => x_msg_data );
339: END Validate_SEC_INT_CODE_ID;
340:

Line 363: FND_MSG_PUB.initialize;

359: BEGIN
360: -- Initialize message list IF p_init_msg_list is set to TRUE.
361: IF FND_API.to_Boolean( p_init_msg_list )
362: THEN
363: FND_MSG_PUB.initialize;
364: END IF;
365:
366: -- Initialize API return status to SUCCESS
367: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 370: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

366: -- Initialize API return status to SUCCESS
367: x_return_status := FND_API.G_RET_STS_SUCCESS;
368:
369: -- Debug Message
370: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
371: -- 'Validate Invent. item Org. ID'); END IF;
372:
373: -- Validate Inventory Item and Organization Id
374: IF (p_inventory_item_id is NOT NULL

Line 385: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

381:
382: IF C_Inventory_Item_Exists%NOTFOUND
383: THEN
384: AS_UTILITY_PVT.Set_Message(
385: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
386: p_msg_name => 'API_INVALID_ID',
387: p_token1 => 'COLUMN',
388: p_token1_value => 'INVENTORY_ITEM',
389: p_token2 => 'VALUE',

Line 397: FND_MSG_PUB.Count_And_Get

393: CLOSE C_Inventory_Item_Exists;
394: END IF;
395:
396: -- Standard call to get message count and IF count is 1, get message info.
397: FND_MSG_PUB.Count_And_Get
398: ( p_count => x_msg_count,
399: p_data => x_msg_data
400: );
401:

Line 423: FND_MSG_PUB.initialize;

419: BEGIN
420: -- Initialize message list IF p_init_msg_list is set to TRUE.
421: IF FND_API.to_Boolean( p_init_msg_list )
422: THEN
423: FND_MSG_PUB.initialize;
424: END IF;
425:
426: -- Initialize API return status to SUCCESS
427: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 430: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

426: -- Initialize API return status to SUCCESS
427: x_return_status := FND_API.G_RET_STS_SUCCESS;
428:
429: -- Debug Message
430: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
431: -- 'Validate UOM code'); END IF;
432:
433: -- Validate UOM
434: IF (p_uom_code is NOT NULL AND p_uom_code <> FND_API.G_MISS_CHAR)

Line 442: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

438:
439: IF C_UOM_Exists%NOTFOUND
440: THEN
441: AS_UTILITY_PVT.Set_Message(
442: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
443: p_msg_name => 'API_INVALID_ID',
444: p_token1 => 'COLUMN',
445: p_token1_value => 'UOM_CODE',
446: p_token2 => 'VALUE',

Line 455: FND_MSG_PUB.Count_And_Get

451: CLOSE C_UOM_Exists;
452: END IF;
453:
454: -- Standard call to get message count and IF count is 1, get message info.
455: FND_MSG_PUB.Count_And_Get
456: ( p_count => x_msg_count,
457: p_data => x_msg_data
458: );
459:

Line 483: FND_MSG_PUB.initialize;

479: BEGIN
480: -- Initialize message list IF p_init_msg_list is set to TRUE.
481: IF FND_API.to_Boolean( p_init_msg_list )
482: THEN
483: FND_MSG_PUB.initialize;
484: END IF;
485: -- Initialize API return status to SUCCESS
486: x_return_status := FND_API.G_RET_STS_SUCCESS;
487: -- Validate CATEGORY ID

Line 497: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

493:
494: IF (C_category_id_Exists%NOTFOUND)
495: THEN
496: AS_UTILITY_PVT.Set_Message(
497: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
498: p_msg_name => 'API_INVALID_ID',
499: p_token1 => 'COLUMN',
500: p_token1_value => 'CATEGORY_ID',
501: p_token2 => 'VALUE',

Line 509: FND_MSG_PUB.Count_And_Get

505: CLOSE C_category_id_Exists;
506: END IF;
507:
508: -- Standard call to get message count and IF count is 1, get message info.
509: FND_MSG_PUB.Count_And_Get
510: ( p_count => x_msg_count,
511: p_data => x_msg_data );
512: END validate_category_id;
513:

Line 536: FND_MSG_PUB.initialize;

532: BEGIN
533: -- Initialize message list IF p_init_msg_list is set to TRUE.
534: IF FND_API.to_Boolean( p_init_msg_list )
535: THEN
536: FND_MSG_PUB.initialize;
537: END IF;
538: -- Initialize API return status to SUCCESS
539: x_return_status := FND_API.G_RET_STS_SUCCESS;
540: -- Validate CATEGORY ID

Line 550: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

546:
547: IF (C_category_set_id_Exists%NOTFOUND)
548: THEN
549: AS_UTILITY_PVT.Set_Message(
550: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
551: p_msg_name => 'API_INVALID_ID',
552: p_token1 => 'COLUMN',
553: p_token1_value => 'CATEGORY_SET_ID',
554: p_token2 => 'VALUE',

Line 562: FND_MSG_PUB.Count_And_Get

558: CLOSE C_category_set_id_Exists;
559: END IF;
560:
561: -- Standard call to get message count and IF count is 1, get message info.
562: FND_MSG_PUB.Count_And_Get
563: ( p_count => x_msg_count,
564: p_data => x_msg_data );
565: END validate_category_set_id;
566:

Line 586: FND_MSG_PUB.initialize;

582: BEGIN
583: -- Initialize message list IF p_init_msg_list is set to TRUE.
584: IF FND_API.to_Boolean( p_init_msg_list )
585: THEN
586: FND_MSG_PUB.initialize;
587: END IF;
588:
589: -- Initialize API return status to SUCCESS
590: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 593: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

589: -- Initialize API return status to SUCCESS
590: x_return_status := FND_API.G_RET_STS_SUCCESS;
591:
592: -- Debug Message
593: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
594: -- 'Validate sec. interest'); END IF;
595:
596: -- IF secondary interest code is not null then interest type and primary
597: -- interest code must exist.

Line 608: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

604: IF (p_primary_interest_code_id is NOT NULL
605: and p_primary_interest_code_id <> FND_API.G_MISS_NUM)
606: THEN
607: AS_UTILITY_PVT.Set_Message(
608: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
609: p_msg_name => 'API_INVALID_ID',
610: p_token1 => 'COLUMN',
611: p_token1_value => 'PRIMARY_INTEREST_CODE',
612: p_token2 => 'VALUE',

Line 618: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

614: x_return_status := FND_API.G_RET_STS_ERROR;
615: END IF;
616: ELSE
617: AS_UTILITY_PVT.Set_Message(
618: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
619: p_msg_name => 'API_INVALID_ID',
620: p_token1 => 'COLUMN',
621: p_token1_value => 'INTEREST_TYPE',
622: p_token2 => 'VALUE',

Line 629: FND_MSG_PUB.Count_And_Get

625: x_return_status := FND_API.G_RET_STS_ERROR;
626: END IF;
627:
628: -- Standard call to get message count and IF count is 1, get message info.
629: FND_MSG_PUB.Count_And_Get
630: ( p_count => x_msg_count,
631: p_data => x_msg_data );
632: END Validate_Intrst_Type_Sec_CODE;
633:

Line 649: FND_MSG_PUB.initialize;

645: BEGIN
646: -- Initialize message list IF p_init_msg_list is set to TRUE.
647: IF FND_API.to_Boolean( p_init_msg_list )
648: THEN
649: FND_MSG_PUB.initialize;
650: END IF;
651:
652: -- Initialize API return status to SUCCESS
653: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 656: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

652: -- Initialize API return status to SUCCESS
653: x_return_status := FND_API.G_RET_STS_SUCCESS;
654:
655: -- Debug Message
656: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
657: -- 'Validate inventory interest'); END IF;
658:
659: IF ((p_INTEREST_TYPE_ID is NULL or p_INTEREST_TYPE_ID=FND_API.G_MISS_NUM)
660: AND (p_INVENTORY_ITEM_ID is NULL

Line 669: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

665: AND p_INVENTORY_ITEM_ID is NULL
666: AND p_validation_mode=AS_UTILITY_PVT.G_UPDATE)
667: THEN
668: AS_UTILITY_PVT.Set_Message(
669: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
670: p_msg_name => 'API_MISSING_ID',
671: p_token1 => 'COLUMN',
672: p_token1_value => 'INTEREST_TYPE_ID/INVENTORY_ITEM_ID');
673: x_return_status := FND_API.G_RET_STS_ERROR;

Line 677: FND_MSG_PUB.Count_And_Get

673: x_return_status := FND_API.G_RET_STS_ERROR;
674: END IF;
675:
676: -- Standard call to get message count and IF count is 1, get message info.
677: FND_MSG_PUB.Count_And_Get
678: ( p_count => x_msg_count,
679: p_data => x_msg_data );
680: END Validate_INVENT_INTRST;
681:

Line 714: FND_MSG_PUB.initialize;

710: BEGIN
711: -- Initialize message list IF p_init_msg_list is set to TRUE.
712: IF FND_API.to_Boolean( p_init_msg_list )
713: THEN
714: FND_MSG_PUB.initialize;
715: END IF;
716:
717: -- Initialize API return status to SUCCESS
718: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 721: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

717: -- Initialize API return status to SUCCESS
718: x_return_status := FND_API.G_RET_STS_SUCCESS;
719:
720: -- Debug Message
721: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
722: -- 'Validate budget amount'); END IF;
723:
724: -- The summary of lines' budget_amount should be equal to header's
725: -- budget_amount

Line 737: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

733:
734: IF l_header_amount <> l_lines_amounts
735: THEN
736: AS_UTILITY_PVT.Set_Message(
737: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
738: p_msg_name => 'AS_BUDGET_AMOUNT_NOT_MATCH');
739: x_return_status := FND_API.G_RET_STS_ERROR;
740: END IF;
741:

Line 743: FND_MSG_PUB.Count_And_Get

739: x_return_status := FND_API.G_RET_STS_ERROR;
740: END IF;
741:
742: -- Standard call to get message count and IF count is 1, get message info.
743: FND_MSG_PUB.Count_And_Get
744: ( p_count => x_msg_count,
745: p_data => x_msg_data );
746: END Validate_Budget_Amounts;
747: */

Line 769: FND_MSG_PUB.initialize;

765: BEGIN
766: -- Initialize message list IF p_init_msg_list is set to TRUE.
767: IF FND_API.to_Boolean( p_init_msg_list )
768: THEN
769: FND_MSG_PUB.initialize;
770: END IF;
771:
772: -- Debug Message
773: IF (AS_DEBUG_LOW_ON) THEN

Line 775: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

771:
772: -- Debug Message
773: IF (AS_DEBUG_LOW_ON) THEN
774:
775: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
776: 'PVT: ' || l_api_name || ' Start');
777: END IF;
778:
779: -- Initialize API return status to SUCCESS

Line 966: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

962:
963: -- Debug Message
964: IF (AS_DEBUG_LOW_ON) THEN
965:
966: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
967: 'PVT: ' || l_api_name || ' End');
968: END IF;
969: END Validate_sales_lead_line;
970:

Line 1068: FND_MSG_PUB.initialize;

1064:
1065: -- Initialize message list IF p_init_msg_list is set to TRUE.
1066: IF FND_API.to_Boolean( p_init_msg_list )
1067: THEN
1068: FND_MSG_PUB.initialize;
1069: END IF;
1070:
1071: -- Debug Message
1072: IF (AS_DEBUG_LOW_ON) THEN

Line 1074: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1070:
1071: -- Debug Message
1072: IF (AS_DEBUG_LOW_ON) THEN
1073:
1074: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1075: 'PVT: ' || l_api_name || ' Start');
1076: END IF;
1077:
1078: --

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

1083: -- ******************************************************************
1084:
1085: IF FND_GLOBAL.User_Id IS NULL
1086: THEN
1087: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1088: THEN
1089: AS_UTILITY_PVT.Set_Message(
1090: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1091: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',

Line 1090: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1086: THEN
1087: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1088: THEN
1089: AS_UTILITY_PVT.Set_Message(
1090: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1091: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
1092: p_token1 => 'PROFILE',
1093: p_token1_value => 'USER_ID');
1094:

Line 1117: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1113: RAISE FND_API.G_EXC_ERROR;
1114: END IF;
1115:
1116: -- Debug message
1117: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1118: -- 'Comparing sales_lead_line_id'); END IF;
1119:
1120: -- IF p_sales_lead_line_rec.sales_lead_id <> p_sales_lead_id THEN
1121: -- RAISE FND_API.G_EXC_ERROR;

Line 1131: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)

1127: x_sales_lead_line_out_tbl(l_curr_row).return_status :=
1128: FND_API.G_RET_STS_SUCCESS;
1129: -- Progress Message
1130: --
1131: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
1132: THEN
1133: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
1134: FND_MESSAGE.Set_Token ('ROW', 'SALES_LEAD_LINE', TRUE);
1135: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);

Line 1136: FND_MSG_PUB.Add;

1132: THEN
1133: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
1134: FND_MESSAGE.Set_Token ('ROW', 'SALES_LEAD_LINE', TRUE);
1135: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
1136: FND_MSG_PUB.Add;
1137: END IF;
1138:
1139: l_sales_lead_line_rec := p_sales_lead_line_tbl(l_curr_row);
1140: l_sales_lead_line_rec.sales_lead_id := p_sales_lead_id; -- *****

Line 1152: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1148: -- profile OE_ORGANIZATION_ID
1149: l_org_id := FND_PROFILE.Value('ORG_ID');
1150: IF (AS_DEBUG_LOW_ON) THEN
1151:
1152: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1153: 'org_id: ' || l_org_id);
1154: END IF;
1155:
1156: l_sales_lead_line_rec.organization_id :=

Line 1161: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1157: oe_profile.value('OE_ORGANIZATION_ID', l_org_id);
1158: --FND_PROFILE.Value('OE_ORGANIZATION_ID');
1159: IF (AS_DEBUG_LOW_ON) THEN
1160:
1161: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1162: 'organization_id: ' ||
1163: l_sales_lead_line_rec.organization_id);
1164: END IF;
1165:

Line 1169: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1165:
1166: END IF;
1167: IF (AS_DEBUG_LOW_ON) THEN
1168:
1169: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1170: 'inventory_item_id: '||l_sales_lead_line_rec.inventory_item_id);
1171: END IF;
1172: IF (AS_DEBUG_LOW_ON) THEN
1173:

Line 1174: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1170: 'inventory_item_id: '||l_sales_lead_line_rec.inventory_item_id);
1171: END IF;
1172: IF (AS_DEBUG_LOW_ON) THEN
1173:
1174: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1175: 'organization_id: '||l_sales_lead_line_rec.organization_id);
1176: END IF;
1177:
1178: -- ffang 090801, for bug 1978014

Line 1188: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1184: FETCH C_Get_Header_Campaign into
1185: l_sales_lead_line_rec.source_promotion_id,l_sales_lead_line_rec.offer_id;
1186: IF C_Get_Header_Campaign%NOTFOUND THEN
1187: AS_UTILITY_PVT.Set_Message(
1188: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1189: p_msg_name => 'API_INVALID_ID',
1190: p_token1 => 'SALES_LEAD_ID',
1191: p_token1_value => p_Sales_Lead_Id);
1192:

Line 1201: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW

1197: FND_API.G_MISS_NUM)
1198: THEN
1199: IF (AS_DEBUG_LOW_ON) THEN
1200:
1201: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW
1202: , 'No campaign in header');
1203: END IF;
1204: ELSE
1205: IF (AS_DEBUG_LOW_ON) THEN

Line 1207: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW

1203: END IF;
1204: ELSE
1205: IF (AS_DEBUG_LOW_ON) THEN
1206:
1207: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW
1208: , 'header.source_promotion_id:'
1209: || l_sales_lead_line_rec.source_promotion_id);
1210: END IF;
1211: END IF;

Line 1223: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1219:
1220: -- Debug message
1221: IF (AS_DEBUG_LOW_ON) THEN
1222:
1223: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1224: 'Calling Validate_line');
1225: END IF;
1226:
1227: -- Invoke validation procedures

Line 1259: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1255:
1256: IF C_Get_Category_INFO%NOTFOUND
1257: THEN
1258: AS_UTILITY_PVT.Set_Message(
1259: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1260: p_msg_name => 'API_INVALID_ID',
1261: p_token1 => 'COLUMN',
1262: p_token1_value => 'INVENTORY_ITEM',
1263: p_token2 => 'VALUE',

Line 1290: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1286:
1287:
1288: IF (AS_DEBUG_LOW_ON) THEN
1289:
1290: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1291: 'Cateogry_set_id:' || l_category_set_id);
1292: END IF;
1293:
1294:

Line 1300: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1296: IF(P_Check_Access_Flag = 'Y') THEN
1297: -- Call Get_Access_Profiles to get access_profile_rec
1298: IF (AS_DEBUG_LOW_ON) THEN
1299:
1300: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1301: 'Calling Get_Access_Profiles');
1302: END IF;
1303:
1304: AS_SALES_LEADS_PUB.Get_Access_Profiles(

Line 1312: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1308: IF (AS_DEBUG_LOW_ON) THEN
1309:
1310:
1311:
1312: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1313: 'Calling Has_updateLeadAccess');
1314:
1315: END IF;
1316:

Line 1338: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

1334:
1335: IF l_update_access_flag <> 'Y' THEN
1336: IF (AS_DEBUG_ERROR_ON) THEN
1337:
1338: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1339: 'API_NO_CREATE_PRIVILEGE');
1340: END IF;
1341: RAISE FND_API.G_EXC_ERROR;
1342: END IF;

Line 1353: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1349:
1350: -- Debug Message
1351: IF (AS_DEBUG_LOW_ON) THEN
1352:
1353: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1354: 'Calling Line_Insert_Row');
1355: END IF;
1356:
1357: l_sales_lead_line_id := l_sales_lead_line_rec.sales_lead_line_id;

Line 1436: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1432: /*
1433: -- Debug Message
1434: IF (AS_DEBUG_LOW_ON) THEN
1435:
1436: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1437: 'Updating Header Budget Amount');
1438: END IF;
1439:
1440: UPDATE as_sales_leads

Line 1447: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1443:
1444: -- Debug Message
1445: IF (AS_DEBUG_LOW_ON) THEN
1446:
1447: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1448: 'Validate BUDGET_AMOUNT');
1449: END IF;
1450:
1451: Validate_BUDGET_AMOUNTS(

Line 1471: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1467:
1468: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1469: IF (AS_DEBUG_LOW_ON) THEN
1470:
1471: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1472: 'Private API: Create_lead_line: Backupdate_header fail' );
1473: END IF;
1474: raise FND_API.G_EXC_ERROR;
1475: END IF;

Line 1491: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1487:
1488: -- Debug Message
1489: IF (AS_DEBUG_LOW_ON) THEN
1490:
1491: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1492: 'PVT: ' || l_api_name || ' End');
1493: END IF;
1494:
1495: -- Standard call to get message count and IF count is 1, get message info.

Line 1496: FND_MSG_PUB.Count_And_Get

1492: 'PVT: ' || l_api_name || ' End');
1493: END IF;
1494:
1495: -- Standard call to get message count and IF count is 1, get message info.
1496: FND_MSG_PUB.Count_And_Get
1497: ( p_count => x_msg_count,
1498: p_data => x_msg_data
1499: );
1500:

Line 1506: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1502: WHEN FND_API.G_EXC_ERROR THEN
1503: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1504: P_API_NAME => L_API_NAME
1505: ,P_PKG_NAME => G_PKG_NAME
1506: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1507: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1508: ,X_MSG_COUNT => X_MSG_COUNT
1509: ,X_MSG_DATA => X_MSG_DATA
1510: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1516: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1513: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1514: P_API_NAME => L_API_NAME
1515: ,P_PKG_NAME => G_PKG_NAME
1516: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1517: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1518: ,X_MSG_COUNT => X_MSG_COUNT
1519: ,X_MSG_DATA => X_MSG_DATA
1520: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1594: FND_MSG_PUB.initialize;

1590:
1591: -- Initialize message list IF p_init_msg_list is set to TRUE.
1592: IF FND_API.to_Boolean( p_init_msg_list )
1593: THEN
1594: FND_MSG_PUB.initialize;
1595: END IF;
1596:
1597: -- Debug Message
1598: IF (AS_DEBUG_LOW_ON) THEN

Line 1600: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1596:
1597: -- Debug Message
1598: IF (AS_DEBUG_LOW_ON) THEN
1599:
1600: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1601: 'PVT: ' || l_api_name || ' Start');
1602: END IF;
1603:
1604: -- Initialize API return status to SUCCESS

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

1612: -- Validate Environment
1613: -- ******************************************************************
1614: IF FND_GLOBAL.User_Id IS NULL
1615: THEN
1616: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1617: THEN
1618: AS_UTILITY_PVT.Set_Message(
1619: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1620: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',

Line 1619: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1615: THEN
1616: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1617: THEN
1618: AS_UTILITY_PVT.Set_Message(
1619: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1620: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
1621: p_token1 => 'PROFILE',
1622: p_token1_value => 'USER_ID');
1623:

Line 1654: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)

1650: FND_API.G_RET_STS_SUCCESS;
1651:
1652: -- Progress Message
1653: --
1654: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
1655: THEN
1656: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
1657: FND_MESSAGE.Set_Token ('ROW', 'SALES_LEAD_LINE', TRUE);
1658: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);

Line 1659: FND_MSG_PUB.Add;

1655: THEN
1656: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
1657: FND_MESSAGE.Set_Token ('ROW', 'SALES_LEAD_LINE', TRUE);
1658: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
1659: FND_MSG_PUB.Add;
1660: END IF;
1661:
1662: l_tar_sales_lead_line_rec := p_sales_lead_line_tbl(l_curr_row);
1663:

Line 1667: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1663:
1664: -- Debug Message
1665: IF (AS_DEBUG_LOW_ON) THEN
1666:
1667: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1668: 'Open C_Get_sales_lead_line');
1669: END IF;
1670:
1671: l_Sales_Lead_Id := l_tar_sales_lead_line_rec.SALES_LEAD_ID;

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

1675: Fetch C_Get_sales_lead_line into l_last_update_date, l_budget_amount;
1676:
1677: IF ( C_Get_sales_lead_line%NOTFOUND) THEN
1678: Close C_Get_sales_lead_line;
1679: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1680: THEN
1681: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
1682: FND_MESSAGE.Set_Token ('INFO', 'SALES_LEAD_LINE', FALSE);
1683: FND_MSG_PUB.Add;

Line 1683: FND_MSG_PUB.Add;

1679: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1680: THEN
1681: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
1682: FND_MESSAGE.Set_Token ('INFO', 'SALES_LEAD_LINE', FALSE);
1683: FND_MSG_PUB.Add;
1684: END IF;
1685: raise FND_API.G_EXC_ERROR;
1686: END IF;
1687:

Line 1691: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1687:
1688: -- Debug Message
1689: IF (AS_DEBUG_LOW_ON) THEN
1690:
1691: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1692: 'Close C_Get_sales_lead_line');
1693: END IF;
1694: Close C_Get_sales_lead_line;
1695:

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

1696: -- Check Whether record has been changed by someone else
1697: IF (l_tar_SALES_LEAD_LINE_rec.last_update_date is NULL or
1698: l_tar_SALES_LEAD_LINE_rec.last_update_date = FND_API.G_MISS_Date)
1699: THEN
1700: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1701: THEN
1702: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1703: FND_MESSAGE.Set_Token('COLUMN', 'LAST_UPDATE_DATE', FALSE);
1704: FND_MSG_PUB.ADD;

Line 1704: FND_MSG_PUB.ADD;

1700: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1701: THEN
1702: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1703: FND_MESSAGE.Set_Token('COLUMN', 'LAST_UPDATE_DATE', FALSE);
1704: FND_MSG_PUB.ADD;
1705: END IF;
1706: raise FND_API.G_EXC_ERROR;
1707: END IF;
1708:

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

1707: END IF;
1708:
1709: IF (l_tar_SALES_LEAD_LINE_rec.last_update_date <> l_last_update_date)
1710: THEN
1711: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1712: THEN
1713: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
1714: FND_MESSAGE.Set_Token('INFO', 'SALES_LEAD_LINE', FALSE);
1715: FND_MSG_PUB.ADD;

Line 1715: FND_MSG_PUB.ADD;

1711: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1712: THEN
1713: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
1714: FND_MESSAGE.Set_Token('INFO', 'SALES_LEAD_LINE', FALSE);
1715: FND_MSG_PUB.ADD;
1716: END IF;
1717: raise FND_API.G_EXC_ERROR;
1718: END IF;
1719:

Line 1724: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1720: -- Invoke validation procedures
1721: -- Debug message
1722: IF (AS_DEBUG_LOW_ON) THEN
1723:
1724: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1725: 'Calling Validate_line');
1726: END IF;
1727:
1728: -- Invoke validation procedures

Line 1747: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1743: IF(P_Check_Access_Flag = 'Y') THEN
1744: -- Call Get_Access_Profiles to get access_profile_rec
1745: IF (AS_DEBUG_LOW_ON) THEN
1746:
1747: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1748: 'Calling Get_Access_Profiles');
1749: END IF;
1750:
1751: AS_SALES_LEADS_PUB.Get_Access_Profiles(

Line 1759: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1755: IF (AS_DEBUG_LOW_ON) THEN
1756:
1757:
1758:
1759: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1760: 'Calling Has_updateLeadAccess');
1761:
1762: END IF;
1763:

Line 1784: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

1780:
1781: IF l_update_access_flag <> 'Y' THEN
1782: IF (AS_DEBUG_ERROR_ON) THEN
1783:
1784: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1785: 'API_NO_CREATE_PRIVILEGE');
1786: END IF;
1787: RAISE FND_API.G_EXC_ERROR;
1788: END IF;

Line 1799: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1795:
1796: -- Debug Message
1797: IF (AS_DEBUG_LOW_ON) THEN
1798:
1799: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1800: 'Calling line_Update_Row');
1801: END IF;
1802:
1803: -- Invoke table handler(sales_lead_line_Update_Row)

Line 1883: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1879:
1880: -- Debug Message
1881: IF (AS_DEBUG_LOW_ON) THEN
1882:
1883: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1884: 'Validate BUDGET_AMOUNT');
1885: END IF;
1886:
1887: Validate_BUDGET_AMOUNTS(

Line 1922: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1918:
1919: -- Debug Message
1920: IF (AS_DEBUG_LOW_ON) THEN
1921:
1922: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1923: 'PVT: ' || l_api_name || ' End');
1924: END IF;
1925:
1926: -- Standard call to get message count and IF count is 1, get message info.

Line 1927: FND_MSG_PUB.Count_And_Get

1923: 'PVT: ' || l_api_name || ' End');
1924: END IF;
1925:
1926: -- Standard call to get message count and IF count is 1, get message info.
1927: FND_MSG_PUB.Count_And_Get
1928: ( p_count => x_msg_count,
1929: p_data => x_msg_data
1930: );
1931:

Line 1937: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1933: WHEN FND_API.G_EXC_ERROR THEN
1934: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1935: P_API_NAME => L_API_NAME
1936: ,P_PKG_NAME => G_PKG_NAME
1937: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1938: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1939: ,X_MSG_COUNT => X_MSG_COUNT
1940: ,X_MSG_DATA => X_MSG_DATA
1941: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1947: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1944: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1945: P_API_NAME => L_API_NAME
1946: ,P_PKG_NAME => G_PKG_NAME
1947: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1948: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1949: ,X_MSG_COUNT => X_MSG_COUNT
1950: ,X_MSG_DATA => X_MSG_DATA
1951: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2018: FND_MSG_PUB.initialize;

2014:
2015: -- Initialize message list IF p_init_msg_list is set to TRUE.
2016: IF FND_API.to_Boolean( p_init_msg_list )
2017: THEN
2018: FND_MSG_PUB.initialize;
2019: END IF;
2020:
2021: -- Debug Message
2022: IF (AS_DEBUG_LOW_ON) THEN

Line 2024: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2020:
2021: -- Debug Message
2022: IF (AS_DEBUG_LOW_ON) THEN
2023:
2024: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2025: 'PVT: ' || l_api_name || ' Start');
2026: END IF;
2027:
2028: -- Initialize API return status to SUCCESS

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

2036: -- Validate Environment
2037: -- ******************************************************************
2038: IF FND_GLOBAL.User_Id IS NULL
2039: THEN
2040: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2041: THEN
2042: AS_UTILITY_PVT.Set_Message(
2043: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2044: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',

Line 2043: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

2039: THEN
2040: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2041: THEN
2042: AS_UTILITY_PVT.Set_Message(
2043: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2044: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
2045: p_token1 => 'PROFILE',
2046: p_token1_value => 'USER_ID');
2047: END IF;

Line 2076: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)

2072: := FND_API.G_RET_STS_SUCCESS;
2073:
2074: -- Progress Message
2075: --
2076: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH)
2077: THEN
2078: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
2079: FND_MESSAGE.Set_Token ('ROW', 'AS_SALES_LEAD_LINE', TRUE);
2080: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);

Line 2081: FND_MSG_PUB.Add;

2077: THEN
2078: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
2079: FND_MESSAGE.Set_Token ('ROW', 'AS_SALES_LEAD_LINE', TRUE);
2080: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
2081: FND_MSG_PUB.Add;
2082: END IF;
2083:
2084: l_sales_lead_line_rec := p_sales_lead_line_tbl(l_curr_row);
2085:

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

2087: Fetch C_Get_sales_lead_line into l_last_update_date, l_budget_amount;
2088:
2089: IF ( C_Get_sales_lead_line%NOTFOUND) THEN
2090: Close C_Get_sales_lead_line;
2091: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2092: THEN
2093: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
2094: FND_MESSAGE.Set_Token ('INFO', 'SALES_LEAD_LINE', FALSE);
2095: FND_MSG_PUB.Add;

Line 2095: FND_MSG_PUB.Add;

2091: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2092: THEN
2093: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
2094: FND_MESSAGE.Set_Token ('INFO', 'SALES_LEAD_LINE', FALSE);
2095: FND_MSG_PUB.Add;
2096: END IF;
2097: raise FND_API.G_EXC_ERROR;
2098: END IF;
2099:

Line 2103: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2099:
2100: -- Debug Message
2101: IF (AS_DEBUG_LOW_ON) THEN
2102:
2103: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2104: 'Close C_Get_sales_lead_line');
2105: END IF;
2106: Close C_Get_sales_lead_line;
2107:

Line 2112: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2108: IF(P_Check_Access_Flag = 'Y') THEN
2109: -- Call Get_Access_Profiles to get access_profile_rec
2110: IF (AS_DEBUG_LOW_ON) THEN
2111:
2112: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2113: 'Calling Get_Access_Profiles');
2114: END IF;
2115:
2116: AS_SALES_LEADS_PUB.Get_Access_Profiles(

Line 2124: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2120: IF (AS_DEBUG_LOW_ON) THEN
2121:
2122:
2123:
2124: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2125: 'Calling Has_updateLeadAccess');
2126:
2127: END IF;
2128:

Line 2149: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

2145:
2146: IF l_update_access_flag <> 'Y' THEN
2147: IF (AS_DEBUG_ERROR_ON) THEN
2148:
2149: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
2150: 'API_NO_CREATE_PRIVILEGE');
2151: END IF;
2152: RAISE FND_API.G_EXC_ERROR;
2153: END IF;

Line 2164: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2160:
2161: -- Debug Message
2162: IF (AS_DEBUG_LOW_ON) THEN
2163:
2164: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2165: 'Calling_Line_Delete_Row');
2166: END IF;
2167:
2168: -- Invoke table handler(Sales_Lead_Line_Delete_Row)

Line 2191: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2187:
2188: -- Debug Message
2189: IF (AS_DEBUG_LOW_ON) THEN
2190:
2191: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2192: 'Validate BUDGET_AMOUNT');
2193: END IF;
2194:
2195: Validate_BUDGET_AMOUNTS(

Line 2221: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2217:
2218: -- Debug Message
2219: IF (AS_DEBUG_LOW_ON) THEN
2220:
2221: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2222: 'PVT: ' || l_api_name || ' End');
2223: END IF;
2224:
2225: -- Standard call to get message count and IF count is 1, get message info.

Line 2226: FND_MSG_PUB.Count_And_Get

2222: 'PVT: ' || l_api_name || ' End');
2223: END IF;
2224:
2225: -- Standard call to get message count and IF count is 1, get message info.
2226: FND_MSG_PUB.Count_And_Get
2227: ( p_count => x_msg_count,
2228: p_data => x_msg_data );
2229:
2230: EXCEPTION

Line 2235: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2231: WHEN FND_API.G_EXC_ERROR THEN
2232: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2233: P_API_NAME => L_API_NAME
2234: ,P_PKG_NAME => G_PKG_NAME
2235: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2236: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2237: ,X_MSG_COUNT => X_MSG_COUNT
2238: ,X_MSG_DATA => X_MSG_DATA
2239: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2245: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2242: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2243: P_API_NAME => L_API_NAME
2244: ,P_PKG_NAME => G_PKG_NAME
2245: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2246: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2247: ,X_MSG_COUNT => X_MSG_COUNT
2248: ,X_MSG_DATA => X_MSG_DATA
2249: ,X_RETURN_STATUS => X_RETURN_STATUS);