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 AS_UTILITY_PVT

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 104: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)

100: -- 'Validate Sales Lead Id'); END IF;
101:
102: -- ffang 092000 for bug 1406777
103: -- Calling from Create API
104: IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE)
105: THEN
106: IF (p_SALES_LEAD_ID is NOT NULL) and
107: (p_SALES_LEAD_ID <> FND_API.G_MISS_NUM)
108: THEN

Line 114: AS_UTILITY_PVT.Set_Message(

110: FETCH C_Sales_Lead_Id_Exists into l_val;
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);

Line 126: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)

122: CLOSE C_Sales_Lead_Id_Exists ;
123: END IF;
124:
125: -- Calling from Update API
126: ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
127: THEN
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

Line 131: AS_UTILITY_PVT.Set_Message(

127: THEN
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;

Line 142: AS_UTILITY_PVT.Set_Message(

138: FETCH C_Sales_Lead_Id_Exists into l_val;
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 );

Line 201: AS_UTILITY_PVT.Set_Message(

197: FETCH C_Int_Type_Exists INTO l_variable;
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',

Line 262: AS_UTILITY_PVT.Set_Message(

258: FETCH C_Prim_Int_Code_Exists INTO l_variable;
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',

Line 323: AS_UTILITY_PVT.Set_Message(

319: p_interest_type_id);
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',

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 384: AS_UTILITY_PVT.Set_Message(

380: FETCH C_Inventory_Item_Exists into l_val;
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',

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 441: AS_UTILITY_PVT.Set_Message(

437: FETCH C_UOM_Exists into l_val;
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',

Line 496: AS_UTILITY_PVT.Set_Message(

492: FETCH C_category_id_Exists INTO l_variable;
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',

Line 549: AS_UTILITY_PVT.Set_Message(

545: FETCH C_category_set_id_Exists INTO l_variable;
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',

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 607: AS_UTILITY_PVT.Set_Message(

603: THEN
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',

Line 617: AS_UTILITY_PVT.Set_Message(

613: p_token2_value => p_PRIMARY_INTEREST_CODE_ID );
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',

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 662: AND p_validation_mode=AS_UTILITY_PVT.G_CREATE)

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
661: or p_INVENTORY_ITEM_ID=FND_API.G_MISS_NUM)
662: AND p_validation_mode=AS_UTILITY_PVT.G_CREATE)
663: OR
664: (p_INTEREST_TYPE_ID IS NULL
665: AND p_INVENTORY_ITEM_ID is NULL
666: AND p_validation_mode=AS_UTILITY_PVT.G_UPDATE)

Line 666: AND p_validation_mode=AS_UTILITY_PVT.G_UPDATE)

662: AND p_validation_mode=AS_UTILITY_PVT.G_CREATE)
663: OR
664: (p_INTEREST_TYPE_ID IS NULL
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',

Line 668: AS_UTILITY_PVT.Set_Message(

664: (p_INTEREST_TYPE_ID IS NULL
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');

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 736: AS_UTILITY_PVT.Set_Message(

732: CLOSE C_Lines_Amounts;
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;

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 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 1089: AS_UTILITY_PVT.Set_Message(

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',
1092: p_token1 => 'PROFILE',
1093: p_token1_value => 'USER_ID');

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 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 1187: AS_UTILITY_PVT.Set_Message(

1183: OPEN C_Get_Header_Campaign (p_sales_lead_id);
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);

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 1231: p_validation_mode => AS_UTILITY_PVT.G_CREATE,

1227: -- Invoke validation procedures
1228: Validate_sales_lead_line(
1229: p_init_msg_list => FND_API.G_FALSE,
1230: p_validation_level => p_validation_level,
1231: p_validation_mode => AS_UTILITY_PVT.G_CREATE,
1232: P_SALES_LEAD_LINE_Rec => l_SALES_LEAD_LINE_rec,
1233: x_return_status => x_return_status,
1234: x_msg_count => x_msg_count,
1235: x_msg_data => x_msg_data);

Line 1258: AS_UTILITY_PVT.Set_Message(

1254: FETCH C_Get_Category_INFO into l_sales_lead_line_rec.category_id, l_sales_lead_line_rec.category_set_id;
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',

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 1453: p_validation_mode => AS_UTILITY_PVT.G_CREATE,

1449: END IF;
1450:
1451: Validate_BUDGET_AMOUNTS(
1452: p_init_msg_list => FND_API.G_FALSE,
1453: p_validation_mode => AS_UTILITY_PVT.G_CREATE,
1454: p_SALES_LEAD_ID => P_SALES_LEAD_ID,
1455: x_return_status => x_return_status,
1456: x_msg_count => x_msg_count,
1457: x_msg_data => x_msg_data);

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 1503: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1499: );
1500:
1501: EXCEPTION
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

Line 1507: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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);
1511:

Line 1513: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1509: ,X_MSG_DATA => X_MSG_DATA
1510: ,X_RETURN_STATUS => X_RETURN_STATUS);
1511:
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

Line 1517: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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);
1521:

Line 1523: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1519: ,X_MSG_DATA => X_MSG_DATA
1520: ,X_RETURN_STATUS => X_RETURN_STATUS);
1521:
1522: WHEN OTHERS THEN
1523: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1524: P_API_NAME => L_API_NAME
1525: ,P_PKG_NAME => G_PKG_NAME
1526: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1527: ,P_SQLCODE => SQLCODE

Line 1526: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1522: WHEN OTHERS THEN
1523: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1524: P_API_NAME => L_API_NAME
1525: ,P_PKG_NAME => G_PKG_NAME
1526: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1527: ,P_SQLCODE => SQLCODE
1528: ,P_SQLERRM => SQLERRM
1529: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1530: ,X_MSG_COUNT => X_MSG_COUNT

Line 1529: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1525: ,P_PKG_NAME => G_PKG_NAME
1526: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1527: ,P_SQLCODE => SQLCODE
1528: ,P_SQLERRM => SQLERRM
1529: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1530: ,X_MSG_COUNT => X_MSG_COUNT
1531: ,X_MSG_DATA => X_MSG_DATA
1532: ,X_RETURN_STATUS => X_RETURN_STATUS);
1533: END Create_sales_lead_lines;

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 1618: AS_UTILITY_PVT.Set_Message(

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',
1621: p_token1 => 'PROFILE',
1622: p_token1_value => 'USER_ID');

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 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 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 1732: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,

1728: -- Invoke validation procedures
1729: Validate_sales_lead_line(
1730: p_init_msg_list => FND_API.G_FALSE,
1731: p_validation_level => p_validation_level,
1732: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
1733: P_SALES_LEAD_LINE_Rec => l_tar_SALES_LEAD_LINE_rec,
1734: x_return_status => x_return_status,
1735: x_msg_count => x_msg_count,
1736: x_msg_data => x_msg_data);

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 1889: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,

1885: END IF;
1886:
1887: Validate_BUDGET_AMOUNTS(
1888: p_init_msg_list => FND_API.G_FALSE,
1889: p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
1890: p_SALES_LEAD_ID => l_SALES_LEAD_ID,
1891: x_return_status => x_return_status,
1892: x_msg_count => x_msg_count,
1893: x_msg_data => x_msg_data);

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 1934: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1930: );
1931:
1932: EXCEPTION
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

Line 1938: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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);
1942:

Line 1944: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1940: ,X_MSG_DATA => X_MSG_DATA
1941: ,X_RETURN_STATUS => X_RETURN_STATUS);
1942:
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

Line 1948: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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);
1952:

Line 1954: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1950: ,X_MSG_DATA => X_MSG_DATA
1951: ,X_RETURN_STATUS => X_RETURN_STATUS);
1952:
1953: WHEN OTHERS THEN
1954: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1955: P_API_NAME => L_API_NAME
1956: ,P_PKG_NAME => G_PKG_NAME
1957: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1958: ,P_SQLCODE => SQLCODE

Line 1957: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1953: WHEN OTHERS THEN
1954: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1955: P_API_NAME => L_API_NAME
1956: ,P_PKG_NAME => G_PKG_NAME
1957: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1958: ,P_SQLCODE => SQLCODE
1959: ,P_SQLERRM => SQLERRM
1960: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1961: ,X_MSG_COUNT => X_MSG_COUNT

Line 1960: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1956: ,P_PKG_NAME => G_PKG_NAME
1957: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1958: ,P_SQLCODE => SQLCODE
1959: ,P_SQLERRM => SQLERRM
1960: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1961: ,X_MSG_COUNT => X_MSG_COUNT
1962: ,X_MSG_DATA => X_MSG_DATA
1963: ,X_RETURN_STATUS => X_RETURN_STATUS);
1964: END Update_sales_lead_lines;

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 2042: AS_UTILITY_PVT.Set_Message(

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',
2045: p_token1 => 'PROFILE',
2046: p_token1_value => 'USER_ID');

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 2197: p_validation_mode => AS_UTILITY_PVT.G_CREATE,

2193: END IF;
2194:
2195: Validate_BUDGET_AMOUNTS(
2196: p_init_msg_list => FND_API.G_FALSE,
2197: p_validation_mode => AS_UTILITY_PVT.G_CREATE,
2198: p_SALES_LEAD_ID => l_sales_lead_line_rec.sales_lead_id,
2199: x_return_status => x_return_status,
2200: x_msg_count => x_msg_count,
2201: x_msg_data => x_msg_data);

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 2232: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2228: p_data => x_msg_data );
2229:
2230: EXCEPTION
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

Line 2236: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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);
2240:

Line 2242: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2238: ,X_MSG_DATA => X_MSG_DATA
2239: ,X_RETURN_STATUS => X_RETURN_STATUS);
2240:
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

Line 2246: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

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);
2250:

Line 2252: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2248: ,X_MSG_DATA => X_MSG_DATA
2249: ,X_RETURN_STATUS => X_RETURN_STATUS);
2250:
2251: WHEN OTHERS THEN
2252: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2253: P_API_NAME => L_API_NAME
2254: ,P_PKG_NAME => G_PKG_NAME
2255: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2256: ,P_SQLCODE => SQLCODE

Line 2255: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

2251: WHEN OTHERS THEN
2252: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2253: P_API_NAME => L_API_NAME
2254: ,P_PKG_NAME => G_PKG_NAME
2255: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2256: ,P_SQLCODE => SQLCODE
2257: ,P_SQLERRM => SQLERRM
2258: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2259: ,X_MSG_COUNT => X_MSG_COUNT

Line 2258: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

2254: ,P_PKG_NAME => G_PKG_NAME
2255: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
2256: ,P_SQLCODE => SQLCODE
2257: ,P_SQLERRM => SQLERRM
2258: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2259: ,X_MSG_COUNT => X_MSG_COUNT
2260: ,X_MSG_DATA => X_MSG_DATA
2261: ,X_RETURN_STATUS => X_RETURN_STATUS);
2262: END Delete_sales_lead_lines;