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_API

Line 38: x_return_status := FND_API.G_RET_STS_SUCCESS;

34:
35: l_line_total NUMBER;
36:
37: BEGIN
38: x_return_status := FND_API.G_RET_STS_SUCCESS;
39:
40: OPEN C_line_total;
41: FETCH C_line_total into l_line_total;
42: CLOSE C_line_total;

Line 59: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

55:
56: EXCEPTION
57: WHEN OTHERS
58: THEN
59: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
60: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
61:
62: END Backupdate_Header;
63:

Line 60: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

56: EXCEPTION
57: WHEN OTHERS
58: THEN
59: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
60: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
61:
62: END Backupdate_Header;
63:
64:

Line 73: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

69: -- Item level validation procedures
70: --
71:
72: PROCEDURE Validate_SALES_LEAD_ID (
73: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
74: P_Validation_mode IN VARCHAR2,
75: P_Sales_Lead_Id IN NUMBER,
76: X_Return_Status OUT NOCOPY VARCHAR2,
77: X_Msg_Count OUT NOCOPY NUMBER,

Line 90: IF FND_API.to_Boolean( p_init_msg_list )

86: l_val VARCHAR2(1);
87:
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:

Line 96: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
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;

Line 107: (p_SALES_LEAD_ID <> FND_API.G_MISS_NUM)

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
109: OPEN C_Sales_Lead_Id_Exists (p_Sales_Lead_Id);
110: FETCH C_Sales_Lead_Id_Exists into l_val;
111:

Line 120: x_return_status := FND_API.G_RET_STS_ERROR;

116: p_msg_name => 'API_INVALID_ID',
117: p_token1 => 'SALES_LEAD_ID',
118: p_token1_value => p_Sales_Lead_Id);
119:
120: x_return_status := FND_API.G_RET_STS_ERROR;
121: END IF;
122: CLOSE C_Sales_Lead_Id_Exists ;
123: END IF;
124:

Line 129: IF (p_sales_lead_id is NULL) or (p_sales_lead_id = FND_API.G_MISS_NUM)

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
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');

Line 135: x_return_status := FND_API.G_RET_STS_ERROR;

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
137: OPEN C_Sales_Lead_Id_Exists (p_sales_lead_id);
138: FETCH C_Sales_Lead_Id_Exists into l_val;
139:

Line 148: x_return_status := FND_API.G_RET_STS_ERROR;

144: p_msg_name => 'API_INVALID_LEAD_ID',
145: p_token1 => 'VALUE',
146: p_token1_value => p_sales_lead_id );
147:
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: END IF;
150:
151: CLOSE C_Sales_Lead_Id_Exists;
152: END IF;

Line 165: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

161: END Validate_SALES_LEAD_ID;
162:
163:
164: PROCEDURE Validate_INTEREST_TYPE_ID (
165: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
166: P_Validation_mode IN VARCHAR2,
167: P_INTEREST_TYPE_ID IN NUMBER,
168: X_Return_Status OUT NOCOPY VARCHAR2,
169: X_Msg_Count OUT NOCOPY NUMBER,

Line 184: IF FND_API.to_Boolean( p_init_msg_list )

180:
181: l_variable VARCHAR2(1);
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:

Line 190: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
191:
192: -- Validate Interest Type ID
193: IF p_interest_type_id is NOT NULL
194: and p_interest_type_id <> FND_API.G_MISS_NUM

Line 194: and p_interest_type_id <> FND_API.G_MISS_NUM

190: x_return_status := FND_API.G_RET_STS_SUCCESS;
191:
192: -- Validate Interest Type ID
193: IF p_interest_type_id is NOT NULL
194: and p_interest_type_id <> FND_API.G_MISS_NUM
195: THEN
196: OPEN C_Int_Type_Exists (p_interest_type_id);
197: FETCH C_Int_Type_Exists INTO l_variable;
198:

Line 208: x_return_status := FND_API.G_RET_STS_ERROR;

204: p_token1 => 'COLUMN',
205: p_token1_value => 'INTEREST_TYPE_ID',
206: p_token2 => 'VALUE',
207: p_token2_value => p_INTEREST_TYPE_ID );
208: x_return_status := FND_API.G_RET_STS_ERROR;
209: END IF;
210: CLOSE C_Int_Type_Exists;
211: END IF;
212:

Line 221: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

217: END Validate_INTEREST_TYPE_ID;
218:
219:
220: PROCEDURE Validate_PRIM_INT_CODE_ID (
221: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
222: P_Validation_mode IN VARCHAR2,
223: P_INTEREST_TYPE_ID IN NUMBER,
224: P_PRIMARY_INTEREST_CODE_ID IN NUMBER,
225: X_Return_Status OUT NOCOPY VARCHAR2,

Line 244: IF FND_API.to_Boolean( p_init_msg_list )

240: l_variable VARCHAR2(1);
241: BEGIN
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:

Line 250: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
251:
252: -- Validate Primary Interest Code
253: IF p_primary_interest_code_id is NOT NULL
254: and p_primary_interest_code_id <> FND_API.G_MISS_NUM

Line 254: and p_primary_interest_code_id <> FND_API.G_MISS_NUM

250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251:
252: -- Validate Primary Interest Code
253: IF p_primary_interest_code_id is NOT NULL
254: and p_primary_interest_code_id <> FND_API.G_MISS_NUM
255: THEN
256: OPEN C_Prim_Int_Code_Exists ( p_primary_interest_code_id,
257: p_interest_type_id);
258: FETCH C_Prim_Int_Code_Exists INTO l_variable;

Line 269: x_return_status := FND_API.G_RET_STS_ERROR;

265: p_token1 => 'COLUMN',
266: p_token1_value => 'PRIMARY_INTEREST_CODE_ID',
267: p_token2 => 'VALUE',
268: p_token2_value => p_PRIMARY_INTEREST_CODE_ID );
269: x_return_status := FND_API.G_RET_STS_ERROR;
270: END IF;
271: CLOSE C_Prim_Int_Code_Exists;
272: END IF;
273:

Line 282: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

278: END Validate_PRIM_INT_CODE_ID;
279:
280:
281: PROCEDURE Validate_SEC_INT_CODE_ID (
282: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
283: P_Validation_mode IN VARCHAR2,
284: P_INTEREST_TYPE_ID IN NUMBER,
285: P_PRIMARY_INTEREST_CODE_ID IN NUMBER,
286: P_SECONDARY_INTEREST_CODE_ID IN NUMBER,

Line 305: IF FND_API.to_Boolean( p_init_msg_list )

301:
302: l_variable VARCHAR2(1);
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:

Line 311: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
312:
313: -- Validate Secondary Interest Code
314: IF (p_secondary_interest_code_id is NOT NULL
315: and p_secondary_interest_code_id <> FND_API.G_MISS_NUM)

Line 315: and p_secondary_interest_code_id <> FND_API.G_MISS_NUM)

311: x_return_status := FND_API.G_RET_STS_SUCCESS;
312:
313: -- Validate Secondary Interest Code
314: IF (p_secondary_interest_code_id is NOT NULL
315: and p_secondary_interest_code_id <> FND_API.G_MISS_NUM)
316: THEN
317: OPEN C_Sec_Int_Code_Exists (p_secondary_interest_code_id,
318: p_primary_interest_code_id,
319: p_interest_type_id);

Line 330: x_return_status := FND_API.G_RET_STS_ERROR;

326: p_token1 => 'COLUMN',
327: p_token1_value => 'SECONDARY_INTEREST_CODE_ID',
328: p_token2 => 'VALUE',
329: p_token2_value => p_SECONDARY_INTEREST_CODE_ID );
330: x_return_status := FND_API.G_RET_STS_ERROR;
331: END IF;
332: CLOSE C_Sec_Int_Code_Exists;
333: END IF;
334:

Line 343: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

339: END Validate_SEC_INT_CODE_ID;
340:
341:
342: PROCEDURE Validate_INV_ORG_ID (
343: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
344: P_Validation_mode IN VARCHAR2,
345: P_INVENTORY_ITEM_ID IN NUMBER,
346: P_ORGANIZATION_ID IN NUMBER,
347: X_Return_Status OUT NOCOPY VARCHAR2,

Line 361: IF FND_API.to_Boolean( p_init_msg_list )

357: and organization_id = X_Organization_Id;
358: l_val VARCHAR2(1);
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:

Line 367: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
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;

Line 375: AND p_inventory_item_id <> FND_API.G_MISS_NUM

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
375: AND p_inventory_item_id <> FND_API.G_MISS_NUM
376: AND p_organization_id IS NOT NULL
377: AND p_organization_id <> FND_API.G_MISS_NUM)
378: THEN
379: OPEN C_Inventory_Item_Exists ( p_inventory_item_id, p_organization_id );

Line 377: AND p_organization_id <> FND_API.G_MISS_NUM)

373: -- Validate Inventory Item and Organization Id
374: IF (p_inventory_item_id is NOT NULL
375: AND p_inventory_item_id <> FND_API.G_MISS_NUM
376: AND p_organization_id IS NOT NULL
377: AND p_organization_id <> FND_API.G_MISS_NUM)
378: THEN
379: OPEN C_Inventory_Item_Exists ( p_inventory_item_id, p_organization_id );
380: FETCH C_Inventory_Item_Exists into l_val;
381:

Line 391: x_return_status := FND_API.G_RET_STS_ERROR;

387: p_token1 => 'COLUMN',
388: p_token1_value => 'INVENTORY_ITEM',
389: p_token2 => 'VALUE',
390: p_token2_value => p_INVENTORY_ITEM_ID );
391: x_return_status := FND_API.G_RET_STS_ERROR;
392: END IF;
393: CLOSE C_Inventory_Item_Exists;
394: END IF;
395:

Line 406: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

402: END Validate_INV_ORG_ID;
403:
404:
405: PROCEDURE Validate_UOM_CODE (
406: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
407: P_Validation_mode IN VARCHAR2,
408: P_UOM_CODE IN VARCHAR2,
409: X_Return_Status OUT NOCOPY VARCHAR2,
410: X_Msg_Count OUT NOCOPY NUMBER,

Line 421: IF FND_API.to_Boolean( p_init_msg_list )

417: FROM mtl_units_of_measure
418: WHERE uom_code = X_Uom_Code;
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:

Line 427: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
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;

Line 434: IF (p_uom_code is NOT NULL AND p_uom_code <> FND_API.G_MISS_CHAR)

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)
435: THEN
436: OPEN C_UOM_Exists ( p_uom_code );
437: FETCH C_UOM_Exists into l_val;
438:

Line 449: x_return_status := FND_API.G_RET_STS_ERROR;

445: p_token1_value => 'UOM_CODE',
446: p_token2 => 'VALUE',
447: p_token2_value => p_UOM_CODE );
448:
449: x_return_status := FND_API.G_RET_STS_ERROR;
450: END IF;
451: CLOSE C_UOM_Exists;
452: END IF;
453:

Line 464: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

460: END Validate_UOM_CODE;
461:
462:
463: PROCEDURE validate_category_id (
464: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
465: P_Validation_mode IN VARCHAR2,
466: p_category_id IN NUMBER,
467: X_Return_Status OUT NOCOPY VARCHAR2,
468: X_Msg_Count OUT NOCOPY NUMBER,

Line 481: IF FND_API.to_Boolean( p_init_msg_list )

477: and PURCHASE_interest = 'Y';
478: l_variable VARCHAR2(1);
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

Line 486: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
488: IF p_category_id is NOT NULL
489: and p_category_id <> FND_API.G_MISS_NUM
490: THEN

Line 489: and p_category_id <> FND_API.G_MISS_NUM

485: -- Initialize API return status to SUCCESS
486: x_return_status := FND_API.G_RET_STS_SUCCESS;
487: -- Validate CATEGORY ID
488: IF p_category_id is NOT NULL
489: and p_category_id <> FND_API.G_MISS_NUM
490: THEN
491: OPEN C_category_id_Exists (p_category_id);
492: FETCH C_category_id_Exists INTO l_variable;
493:

Line 503: x_return_status := FND_API.G_RET_STS_ERROR;

499: p_token1 => 'COLUMN',
500: p_token1_value => 'CATEGORY_ID',
501: p_token2 => 'VALUE',
502: p_token2_value => p_category_id );
503: x_return_status := FND_API.G_RET_STS_ERROR;
504: END IF;
505: CLOSE C_category_id_Exists;
506: END IF;
507:

Line 517: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

513:
514:
515:
516: PROCEDURE validate_category_set_id (
517: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
518: P_Validation_mode IN VARCHAR2,
519: p_category_set_id IN NUMBER,
520: X_Return_Status OUT NOCOPY VARCHAR2,
521: X_Msg_Count OUT NOCOPY NUMBER,

Line 534: IF FND_API.to_Boolean( p_init_msg_list )

530: and PURCHASE_interest = 'Y';
531: l_variable VARCHAR2(1);
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

Line 539: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
541: IF p_category_set_id is NOT NULL
542: and p_category_set_id <> FND_API.G_MISS_NUM
543: THEN

Line 542: and p_category_set_id <> FND_API.G_MISS_NUM

538: -- Initialize API return status to SUCCESS
539: x_return_status := FND_API.G_RET_STS_SUCCESS;
540: -- Validate CATEGORY ID
541: IF p_category_set_id is NOT NULL
542: and p_category_set_id <> FND_API.G_MISS_NUM
543: THEN
544: OPEN C_category_set_id_Exists (p_category_set_id);
545: FETCH C_category_set_id_Exists INTO l_variable;
546:

Line 556: x_return_status := FND_API.G_RET_STS_ERROR;

552: p_token1 => 'COLUMN',
553: p_token1_value => 'CATEGORY_SET_ID',
554: p_token2 => 'VALUE',
555: p_token2_value => p_category_set_id );
556: x_return_status := FND_API.G_RET_STS_ERROR;
557: END IF;
558: CLOSE C_category_set_id_Exists;
559: END IF;
560:

Line 572: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

568: -- Record Level Validation
569: --
570:
571: PROCEDURE Validate_Intrst_Type_Sec_CODE (
572: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
573: P_Validation_mode IN VARCHAR2,
574: P_INTEREST_TYPE_ID IN NUMBER,
575: P_PRIMARY_INTEREST_CODE_ID IN NUMBER,
576: P_SECONDARY_INTEREST_CODE_ID IN NUMBER,

Line 584: IF FND_API.to_Boolean( p_init_msg_list )

580: )
581: IS
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:

Line 590: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
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;

Line 599: and p_secondary_interest_code_id <> FND_API.G_MISS_NUM)

595:
596: -- IF secondary interest code is not null then interest type and primary
597: -- interest code must exist.
598: IF (p_secondary_interest_code_id is NOT NULL
599: and p_secondary_interest_code_id <> FND_API.G_MISS_NUM)
600: THEN
601: IF (p_interest_type_id is NOT NULL
602: and p_interest_type_id <> FND_API.G_MISS_NUM)
603: THEN

Line 602: and p_interest_type_id <> FND_API.G_MISS_NUM)

598: IF (p_secondary_interest_code_id is NOT NULL
599: and p_secondary_interest_code_id <> FND_API.G_MISS_NUM)
600: THEN
601: IF (p_interest_type_id is NOT NULL
602: and p_interest_type_id <> FND_API.G_MISS_NUM)
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

Line 605: and p_primary_interest_code_id <> FND_API.G_MISS_NUM)

601: IF (p_interest_type_id is NOT NULL
602: and p_interest_type_id <> FND_API.G_MISS_NUM)
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',

Line 614: x_return_status := FND_API.G_RET_STS_ERROR;

610: p_token1 => 'COLUMN',
611: p_token1_value => 'PRIMARY_INTEREST_CODE',
612: p_token2 => 'VALUE',
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,

Line 625: x_return_status := FND_API.G_RET_STS_ERROR;

621: p_token1_value => 'INTEREST_TYPE',
622: p_token2 => 'VALUE',
623: p_token2_value => p_INTEREST_TYPE_ID );
624: END IF;
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

Line 636: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

632: END Validate_Intrst_Type_Sec_CODE;
633:
634:
635: PROCEDURE Validate_INVENT_INTRST(
636: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
637: P_Validation_mode IN VARCHAR2,
638: P_INTEREST_TYPE_ID IN NUMBER,
639: P_INVENTORY_ITEM_ID IN NUMBER,
640: X_Return_Status OUT NOCOPY VARCHAR2,

Line 647: IF FND_API.to_Boolean( p_init_msg_list )

643: )
644: IS
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:

Line 653: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
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;

Line 659: IF ((p_INTEREST_TYPE_ID is NULL or p_INTEREST_TYPE_ID=FND_API.G_MISS_NUM)

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
661: or p_INVENTORY_ITEM_ID=FND_API.G_MISS_NUM)
662: AND p_validation_mode=AS_UTILITY_PVT.G_CREATE)
663: OR

Line 661: or p_INVENTORY_ITEM_ID=FND_API.G_MISS_NUM)

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
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

Line 673: x_return_status := FND_API.G_RET_STS_ERROR;

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;
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

Line 689: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

685: --
686:
687: /*
688: PROCEDURE Validate_Budget_Amounts(
689: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
690: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
691: P_Validation_mode IN VARCHAR2,
692: P_SALES_LEAD_ID IN NUMBER,
693: X_Return_Status OUT NOCOPY VARCHAR2,

Line 690: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

686:
687: /*
688: PROCEDURE Validate_Budget_Amounts(
689: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
690: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
691: P_Validation_mode IN VARCHAR2,
692: P_SALES_LEAD_ID IN NUMBER,
693: X_Return_Status OUT NOCOPY VARCHAR2,
694: X_Msg_Count OUT NOCOPY NUMBER,

Line 712: IF FND_API.to_Boolean( p_init_msg_list )

708: l_header_amount NUMBER;
709: l_lines_amounts NUMBER;
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:

Line 718: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
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;

Line 739: x_return_status := FND_API.G_RET_STS_ERROR;

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:
742: -- Standard call to get message count and IF count is 1, get message info.
743: FND_MSG_PUB.Count_And_Get

Line 753: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

749:
750: -- validation procedures
751:
752: PROCEDURE Validate_sales_lead_line(
753: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
754: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
755: P_Validation_mode IN VARCHAR2,
756: P_SALES_LEAD_LINE_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Rec_Type,
757: X_Return_Status OUT NOCOPY VARCHAR2,

Line 754: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

750: -- validation procedures
751:
752: PROCEDURE Validate_sales_lead_line(
753: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
754: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
755: P_Validation_mode IN VARCHAR2,
756: P_SALES_LEAD_LINE_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Rec_Type,
757: X_Return_Status OUT NOCOPY VARCHAR2,
758: X_Msg_Count OUT NOCOPY NUMBER,

Line 767: IF FND_API.to_Boolean( p_init_msg_list )

763: l_Return_Status VARCHAR2(1);
764: l_item_property_rec AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE;
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:

Line 780: x_return_status := FND_API.G_RET_STS_SUCCESS;

776: 'PVT: ' || l_api_name || ' Start');
777: END IF;
778:
779: -- Initialize API return status to SUCCESS
780: x_return_status := FND_API.G_RET_STS_SUCCESS;
781: l_return_status := FND_API.G_RET_STS_SUCCESS;
782:
783: IF ( P_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_ITEM)
784: THEN

Line 781: l_return_status := FND_API.G_RET_STS_SUCCESS;

777: END IF;
778:
779: -- Initialize API return status to SUCCESS
780: x_return_status := FND_API.G_RET_STS_SUCCESS;
781: l_return_status := FND_API.G_RET_STS_SUCCESS;
782:
783: IF ( P_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_ITEM)
784: THEN
785: -- Perform item level validation

Line 790: and P_SALES_LEAD_LINE_Rec.STATUS_CODE <> FND_API.G_MISS_CHAR)

786:
787: -- ffang 092800: status_code in as_sales_lead_lines has been obselete
788: /*
789: IF (P_SALES_LEAD_LINE_Rec.STATUS_CODE IS NOT NULL
790: and P_SALES_LEAD_LINE_Rec.STATUS_CODE <> FND_API.G_MISS_CHAR)
791: THEN
792: Validate_STATUS_CODE(
793: p_init_msg_list => FND_API.G_FALSE,
794: p_validation_mode => p_validation_mode,

Line 793: p_init_msg_list => FND_API.G_FALSE,

789: IF (P_SALES_LEAD_LINE_Rec.STATUS_CODE IS NOT NULL
790: and P_SALES_LEAD_LINE_Rec.STATUS_CODE <> FND_API.G_MISS_CHAR)
791: THEN
792: Validate_STATUS_CODE(
793: p_init_msg_list => FND_API.G_FALSE,
794: p_validation_mode => p_validation_mode,
795: p_STATUS_CODE => P_SALES_LEAD_LINE_Rec.STATUS_CODE,
796: x_return_status => x_return_status,
797: x_msg_count => x_msg_count,

Line 799: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

795: p_STATUS_CODE => P_SALES_LEAD_LINE_Rec.STATUS_CODE,
796: x_return_status => x_return_status,
797: x_msg_count => x_msg_count,
798: x_msg_data => x_msg_data);
799: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
800: l_return_status := FND_API.G_RET_STS_ERROR;
801: -- raise FND_API.G_EXC_ERROR;
802: END IF;
803: END IF;

Line 800: l_return_status := FND_API.G_RET_STS_ERROR;

796: x_return_status => x_return_status,
797: x_msg_count => x_msg_count,
798: x_msg_data => x_msg_data);
799: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
800: l_return_status := FND_API.G_RET_STS_ERROR;
801: -- raise FND_API.G_EXC_ERROR;
802: END IF;
803: END IF;
804: */

Line 801: -- raise FND_API.G_EXC_ERROR;

797: x_msg_count => x_msg_count,
798: x_msg_data => x_msg_data);
799: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
800: l_return_status := FND_API.G_RET_STS_ERROR;
801: -- raise FND_API.G_EXC_ERROR;
802: END IF;
803: END IF;
804: */
805: -- end of ffang 092800

Line 809: p_init_msg_list => FND_API.G_FALSE,

805: -- end of ffang 092800
806:
807: -- ffang 080201, add validate source_promotion_id and offer_id
808: AS_SALES_LEADS_PVT.Validate_SOURCE_PROMOTION_ID(
809: p_init_msg_list => FND_API.G_FALSE,
810: p_validation_mode => p_validation_mode,
811: p_SOURCE_PROMOTION_ID =>P_SALES_LEAD_LINE_Rec.SOURCE_PROMOTION_ID,
812: x_return_status => x_return_status,
813: x_msg_count => x_msg_count,

Line 815: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

811: p_SOURCE_PROMOTION_ID =>P_SALES_LEAD_LINE_Rec.SOURCE_PROMOTION_ID,
812: x_return_status => x_return_status,
813: x_msg_count => x_msg_count,
814: x_msg_data => x_msg_data);
815: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
816: l_return_status := FND_API.G_RET_STS_ERROR;
817: -- raise FND_API.G_EXC_ERROR;
818: END IF;
819:

Line 816: l_return_status := FND_API.G_RET_STS_ERROR;

812: x_return_status => x_return_status,
813: x_msg_count => x_msg_count,
814: x_msg_data => x_msg_data);
815: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
816: l_return_status := FND_API.G_RET_STS_ERROR;
817: -- raise FND_API.G_EXC_ERROR;
818: END IF;
819:
820: AS_SALES_LEADS_PVT.Validate_OFFER_ID(

Line 817: -- raise FND_API.G_EXC_ERROR;

813: x_msg_count => x_msg_count,
814: x_msg_data => x_msg_data);
815: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
816: l_return_status := FND_API.G_RET_STS_ERROR;
817: -- raise FND_API.G_EXC_ERROR;
818: END IF;
819:
820: AS_SALES_LEADS_PVT.Validate_OFFER_ID(
821: p_init_msg_list => FND_API.G_FALSE,

Line 821: p_init_msg_list => FND_API.G_FALSE,

817: -- raise FND_API.G_EXC_ERROR;
818: END IF;
819:
820: AS_SALES_LEADS_PVT.Validate_OFFER_ID(
821: p_init_msg_list => FND_API.G_FALSE,
822: p_validation_mode => p_validation_mode,
823: P_SOURCE_PROMOTION_ID =>P_SALES_LEAD_LINE_Rec.source_promotion_id,
824: p_OFFER_ID => P_SALES_LEAD_LINE_Rec.OFFER_ID,
825: x_item_property_rec => l_item_property_rec,

Line 829: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

825: x_item_property_rec => l_item_property_rec,
826: x_return_status => x_return_status,
827: x_msg_count => x_msg_count,
828: x_msg_data => x_msg_data);
829: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
830: l_return_status := FND_API.G_RET_STS_ERROR;
831: -- raise FND_API.G_EXC_ERROR;
832: END IF;
833: -- end ffang 080201

Line 830: l_return_status := FND_API.G_RET_STS_ERROR;

826: x_return_status => x_return_status,
827: x_msg_count => x_msg_count,
828: x_msg_data => x_msg_data);
829: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
830: l_return_status := FND_API.G_RET_STS_ERROR;
831: -- raise FND_API.G_EXC_ERROR;
832: END IF;
833: -- end ffang 080201
834:

Line 831: -- raise FND_API.G_EXC_ERROR;

827: x_msg_count => x_msg_count,
828: x_msg_data => x_msg_data);
829: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
830: l_return_status := FND_API.G_RET_STS_ERROR;
831: -- raise FND_API.G_EXC_ERROR;
832: END IF;
833: -- end ffang 080201
834:
835: Validate_INV_ORG_ID(

Line 836: p_init_msg_list => FND_API.G_FALSE,

832: END IF;
833: -- end ffang 080201
834:
835: Validate_INV_ORG_ID(
836: p_init_msg_list => FND_API.G_FALSE,
837: p_validation_mode => p_validation_mode,
838: p_ORGANIZATION_ID => P_SALES_LEAD_LINE_Rec.ORGANIZATION_ID,
839: p_INVENTORY_ITEM_ID => P_SALES_LEAD_LINE_Rec.INVENTORY_ITEM_ID,
840: x_return_status => x_return_status,

Line 843: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

839: p_INVENTORY_ITEM_ID => P_SALES_LEAD_LINE_Rec.INVENTORY_ITEM_ID,
840: x_return_status => x_return_status,
841: x_msg_count => x_msg_count,
842: x_msg_data => x_msg_data);
843: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
844: l_return_status := FND_API.G_RET_STS_ERROR;
845: -- raise FND_API.G_EXC_ERROR;
846: END IF;
847:

Line 844: l_return_status := FND_API.G_RET_STS_ERROR;

840: x_return_status => x_return_status,
841: x_msg_count => x_msg_count,
842: x_msg_data => x_msg_data);
843: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
844: l_return_status := FND_API.G_RET_STS_ERROR;
845: -- raise FND_API.G_EXC_ERROR;
846: END IF;
847:
848: Validate_UOM_CODE(

Line 845: -- raise FND_API.G_EXC_ERROR;

841: x_msg_count => x_msg_count,
842: x_msg_data => x_msg_data);
843: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
844: l_return_status := FND_API.G_RET_STS_ERROR;
845: -- raise FND_API.G_EXC_ERROR;
846: END IF;
847:
848: Validate_UOM_CODE(
849: p_init_msg_list => FND_API.G_FALSE,

Line 849: p_init_msg_list => FND_API.G_FALSE,

845: -- raise FND_API.G_EXC_ERROR;
846: END IF;
847:
848: Validate_UOM_CODE(
849: p_init_msg_list => FND_API.G_FALSE,
850: p_validation_mode => p_validation_mode,
851: p_UOM_CODE => P_SALES_LEAD_LINE_Rec.UOM_CODE,
852: x_return_status => x_return_status,
853: x_msg_count => x_msg_count,

Line 855: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

851: p_UOM_CODE => P_SALES_LEAD_LINE_Rec.UOM_CODE,
852: x_return_status => x_return_status,
853: x_msg_count => x_msg_count,
854: x_msg_data => x_msg_data);
855: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
856: l_return_status := FND_API.G_RET_STS_ERROR;
857: -- raise FND_API.G_EXC_ERROR;
858: END IF;
859: END IF;

Line 856: l_return_status := FND_API.G_RET_STS_ERROR;

852: x_return_status => x_return_status,
853: x_msg_count => x_msg_count,
854: x_msg_data => x_msg_data);
855: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
856: l_return_status := FND_API.G_RET_STS_ERROR;
857: -- raise FND_API.G_EXC_ERROR;
858: END IF;
859: END IF;
860:

Line 857: -- raise FND_API.G_EXC_ERROR;

853: x_msg_count => x_msg_count,
854: x_msg_data => x_msg_data);
855: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
856: l_return_status := FND_API.G_RET_STS_ERROR;
857: -- raise FND_API.G_EXC_ERROR;
858: END IF;
859: END IF;
860:
861: IF ( P_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_RECORD)

Line 869: P_Init_Msg_List => FND_API.G_FALSE,

865: -- ffang 092700: use AS_INTEREST_PVT.Validate_Interest_Fields to do
866: -- the record level interests validation
867: /*
868: Validate_Intrst_Type_Sec_CODE (
869: P_Init_Msg_List => FND_API.G_FALSE,
870: P_Validation_mode => p_validation_mode,
871: P_INTEREST_TYPE_ID => P_SALES_LEAD_LINE_Rec.INTEREST_TYPE_ID,
872: P_PRIMARY_INTEREST_CODE_ID
873: => P_SALES_LEAD_LINE_Rec.PRIMARY_INTEREST_CODE_ID,

Line 879: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

875: => P_SALES_LEAD_LINE_Rec.SECONDARY_INTEREST_CODE_ID,
876: X_Return_Status => x_return_status,
877: X_Msg_Count => x_msg_count,
878: X_Msg_Data => x_msg_data);
879: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
880: l_return_status := FND_API.G_RET_STS_ERROR;
881: -- raise FND_API.G_EXC_ERROR;
882: END IF;
883: */

Line 880: l_return_status := FND_API.G_RET_STS_ERROR;

876: X_Return_Status => x_return_status,
877: X_Msg_Count => x_msg_count,
878: X_Msg_Data => x_msg_data);
879: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
880: l_return_status := FND_API.G_RET_STS_ERROR;
881: -- raise FND_API.G_EXC_ERROR;
882: END IF;
883: */
884:

Line 881: -- raise FND_API.G_EXC_ERROR;

877: X_Msg_Count => x_msg_count,
878: X_Msg_Data => x_msg_data);
879: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
880: l_return_status := FND_API.G_RET_STS_ERROR;
881: -- raise FND_API.G_EXC_ERROR;
882: END IF;
883: */
884:
885:

Line 892: (P_SALES_LEAD_LINE_Rec.interest_type_id <> FND_API.G_MISS_NUM)

888:
889: /*
890:
891: IF (P_SALES_LEAD_LINE_Rec.interest_type_id is NOT NULL) and
892: (P_SALES_LEAD_LINE_Rec.interest_type_id <> FND_API.G_MISS_NUM)
893: THEN
894: AS_INTEREST_PVT.Validate_Interest_Fields (
895: p_interest_type_id
896: => P_SALES_LEAD_LINE_Rec.interest_type_id,

Line 903: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

899: p_secondary_interest_code_id
900: => P_SALES_LEAD_LINE_Rec.secondary_interest_code_id,
901: p_interest_status_code => NULL,
902: p_return_status => x_return_status );
903: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
904: l_return_status := FND_API.G_RET_STS_ERROR;
905: -- raise FND_API.G_EXC_ERROR;
906: END IF;
907: END IF;

Line 904: l_return_status := FND_API.G_RET_STS_ERROR;

900: => P_SALES_LEAD_LINE_Rec.secondary_interest_code_id,
901: p_interest_status_code => NULL,
902: p_return_status => x_return_status );
903: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
904: l_return_status := FND_API.G_RET_STS_ERROR;
905: -- raise FND_API.G_EXC_ERROR;
906: END IF;
907: END IF;
908: -- end ffang 092700

Line 905: -- raise FND_API.G_EXC_ERROR;

901: p_interest_status_code => NULL,
902: p_return_status => x_return_status );
903: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
904: l_return_status := FND_API.G_RET_STS_ERROR;
905: -- raise FND_API.G_EXC_ERROR;
906: END IF;
907: END IF;
908: -- end ffang 092700
909:

Line 911: P_Init_Msg_List => FND_API.G_FALSE,

907: END IF;
908: -- end ffang 092700
909:
910: Validate_INVENT_INTRST(
911: P_Init_Msg_List => FND_API.G_FALSE,
912: P_Validation_mode => p_validation_mode,
913: P_INTEREST_TYPE_ID => P_SALES_LEAD_LINE_Rec.INTEREST_TYPE_ID,
914: P_INVENTORY_ITEM_ID => P_SALES_LEAD_LINE_Rec.INVENTORY_ITEM_ID,
915: X_Return_Status => x_return_status,

Line 918: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

914: P_INVENTORY_ITEM_ID => P_SALES_LEAD_LINE_Rec.INVENTORY_ITEM_ID,
915: X_Return_Status => x_return_status,
916: X_Msg_Count => x_msg_count,
917: X_Msg_Data => x_msg_data);
918: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
919: l_return_status := FND_API.G_RET_STS_ERROR;
920: -- raise FND_API.G_EXC_ERROR;
921: END IF;
922: END IF;

Line 919: l_return_status := FND_API.G_RET_STS_ERROR;

915: X_Return_Status => x_return_status,
916: X_Msg_Count => x_msg_count,
917: X_Msg_Data => x_msg_data);
918: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
919: l_return_status := FND_API.G_RET_STS_ERROR;
920: -- raise FND_API.G_EXC_ERROR;
921: END IF;
922: END IF;
923:

Line 920: -- raise FND_API.G_EXC_ERROR;

916: X_Msg_Count => x_msg_count,
917: X_Msg_Data => x_msg_data);
918: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
919: l_return_status := FND_API.G_RET_STS_ERROR;
920: -- raise FND_API.G_EXC_ERROR;
921: END IF;
922: END IF;
923:
924: */

Line 928: P_Init_Msg_List => FND_API.G_FALSE,

924: */
925:
926:
927: Validate_Category_ID (
928: P_Init_Msg_List => FND_API.G_FALSE,
929: P_Validation_mode => p_validation_mode,
930: P_Category_ID => P_SALES_LEAD_LINE_Rec.Category_ID,
931: X_Return_Status => x_return_status,
932: X_Msg_Count => x_msg_count,

Line 934: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

930: P_Category_ID => P_SALES_LEAD_LINE_Rec.Category_ID,
931: X_Return_Status => x_return_status,
932: X_Msg_Count => x_msg_count,
933: X_Msg_Data => x_msg_data);
934: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
935: l_return_status := FND_API.G_RET_STS_ERROR;
936: -- raise FND_API.G_EXC_ERROR;
937: END IF;
938:

Line 935: l_return_status := FND_API.G_RET_STS_ERROR;

931: X_Return_Status => x_return_status,
932: X_Msg_Count => x_msg_count,
933: X_Msg_Data => x_msg_data);
934: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
935: l_return_status := FND_API.G_RET_STS_ERROR;
936: -- raise FND_API.G_EXC_ERROR;
937: END IF;
938:
939: Validate_Category_set_ID (

Line 936: -- raise FND_API.G_EXC_ERROR;

932: X_Msg_Count => x_msg_count,
933: X_Msg_Data => x_msg_data);
934: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
935: l_return_status := FND_API.G_RET_STS_ERROR;
936: -- raise FND_API.G_EXC_ERROR;
937: END IF;
938:
939: Validate_Category_set_ID (
940: P_Init_Msg_List => FND_API.G_FALSE,

Line 940: P_Init_Msg_List => FND_API.G_FALSE,

936: -- raise FND_API.G_EXC_ERROR;
937: END IF;
938:
939: Validate_Category_set_ID (
940: P_Init_Msg_List => FND_API.G_FALSE,
941: P_Validation_mode => p_validation_mode,
942: P_Category_set_ID => P_SALES_LEAD_LINE_Rec.Category_set_ID,
943: X_Return_Status => x_return_status,
944: X_Msg_Count => x_msg_count,

Line 946: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

942: P_Category_set_ID => P_SALES_LEAD_LINE_Rec.Category_set_ID,
943: X_Return_Status => x_return_status,
944: X_Msg_Count => x_msg_count,
945: X_Msg_Data => x_msg_data);
946: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
947: l_return_status := FND_API.G_RET_STS_ERROR;
948: -- raise FND_API.G_EXC_ERROR;
949: END IF;
950:

Line 947: l_return_status := FND_API.G_RET_STS_ERROR;

943: X_Return_Status => x_return_status,
944: X_Msg_Count => x_msg_count,
945: X_Msg_Data => x_msg_data);
946: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
947: l_return_status := FND_API.G_RET_STS_ERROR;
948: -- raise FND_API.G_EXC_ERROR;
949: END IF;
950:
951: END IF;

Line 948: -- raise FND_API.G_EXC_ERROR;

944: X_Msg_Count => x_msg_count,
945: X_Msg_Data => x_msg_data);
946: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
947: l_return_status := FND_API.G_RET_STS_ERROR;
948: -- raise FND_API.G_EXC_ERROR;
949: END IF;
950:
951: END IF;
952:

Line 958: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

954: -- FFANG 112700 For bug 1512008, instead of erroring out once a invalid
955: -- column was found, raise the exception after all validation procedures
956: -- have been gone through.
957: x_return_status := l_return_status;
958: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
959: raise FND_API.G_EXC_ERROR;
960: END IF;
961: -- END FFANG 112700
962:

Line 959: raise FND_API.G_EXC_ERROR;

955: -- column was found, raise the exception after all validation procedures
956: -- have been gone through.
957: x_return_status := l_return_status;
958: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
959: raise FND_API.G_EXC_ERROR;
960: END IF;
961: -- END FFANG 112700
962:
963: -- Debug Message

Line 982: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

978: -- may cause confuse.
979:
980: PROCEDURE Create_sales_lead_lines(
981: P_Api_Version_Number IN NUMBER,
982: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
983: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
984: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
985: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 983: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

979:
980: PROCEDURE Create_sales_lead_lines(
981: P_Api_Version_Number IN NUMBER,
982: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
983: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
984: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
985: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
987: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 984: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

980: PROCEDURE Create_sales_lead_lines(
981: P_Api_Version_Number IN NUMBER,
982: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
983: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
984: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
985: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
987: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
988: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 985: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

981: P_Api_Version_Number IN NUMBER,
982: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
983: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
984: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
985: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
987: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
988: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
989: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

Line 986: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

982: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
983: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
984: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
985: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
987: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
988: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
989: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
990: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 987: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

983: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
984: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
985: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
987: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
988: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
989: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
990: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
991: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type

Line 988: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,

984: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
985: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
987: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
988: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
989: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
990: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
991: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type
992: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,

Line 1052: x_return_status := FND_API.G_RET_STS_SUCCESS;

1048: -- Standard Start of API savepoint
1049: SAVEPOINT CREATE_SALES_LEAD_LINES_PVT;
1050:
1051: -- Initialize API return status to SUCCESS
1052: x_return_status := FND_API.G_RET_STS_SUCCESS;
1053:
1054:
1055: -- Standard call to check for call compatibility.
1056: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1056: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1052: x_return_status := FND_API.G_RET_STS_SUCCESS;
1053:
1054:
1055: -- Standard call to check for call compatibility.
1056: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1057: p_api_version_number,
1058: l_api_name,
1059: G_PKG_NAME)
1060: THEN

Line 1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1057: p_api_version_number,
1058: l_api_name,
1059: G_PKG_NAME)
1060: THEN
1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1062: END IF;
1063:
1064:
1065: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 1066: IF FND_API.to_Boolean( p_init_msg_list )

1062: END IF;
1063:
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:

Line 1096: RAISE FND_API.G_EXC_ERROR;

1092: p_token1 => 'PROFILE',
1093: p_token1_value => 'USER_ID');
1094:
1095: END IF;
1096: RAISE FND_API.G_EXC_ERROR;
1097: END IF;
1098:
1099: IF (p_validation_level = fnd_api.g_valid_level_full)
1100: THEN

Line 1099: IF (p_validation_level = fnd_api.g_valid_level_full)

1095: END IF;
1096: RAISE FND_API.G_EXC_ERROR;
1097: END IF;
1098:
1099: IF (p_validation_level = fnd_api.g_valid_level_full)
1100: THEN
1101: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
1102: p_api_version_number => 2.0
1103: ,p_init_msg_list => p_init_msg_list

Line 1112: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1108: ,x_msg_data => x_msg_data
1109: ,x_sales_member_rec => l_identity_sales_member_rec);
1110: END IF;
1111:
1112: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1113: RAISE FND_API.G_EXC_ERROR;
1114: END IF;
1115:
1116: -- Debug message

Line 1113: RAISE FND_API.G_EXC_ERROR;

1109: ,x_sales_member_rec => l_identity_sales_member_rec);
1110: END IF;
1111:
1112: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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,

Line 1121: -- RAISE FND_API.G_EXC_ERROR;

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;
1122: -- END IF;
1123:
1124: l_lines_amount := 0;
1125:

Line 1128: FND_API.G_RET_STS_SUCCESS;

1124: l_lines_amount := 0;
1125:
1126: FOR l_curr_row IN 1..p_sales_lead_line_tbl.count LOOP
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

Line 1143: l_sales_lead_line_rec.inventory_item_id <> FND_API.G_MISS_NUM AND

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; -- *****
1141:
1142: IF (l_sales_lead_line_rec.inventory_item_id IS NOT NULL AND
1143: l_sales_lead_line_rec.inventory_item_id <> FND_API.G_MISS_NUM AND
1144: (l_sales_lead_line_rec.organization_id IS NULL OR
1145: l_sales_lead_line_rec.organization_id = FND_API.G_MISS_NUM ))
1146: THEN
1147: -- ffang 100301, use oe_profile.value function call instead of

Line 1145: l_sales_lead_line_rec.organization_id = FND_API.G_MISS_NUM ))

1141:
1142: IF (l_sales_lead_line_rec.inventory_item_id IS NOT NULL AND
1143: l_sales_lead_line_rec.inventory_item_id <> FND_API.G_MISS_NUM AND
1144: (l_sales_lead_line_rec.organization_id IS NULL OR
1145: l_sales_lead_line_rec.organization_id = FND_API.G_MISS_NUM ))
1146: THEN
1147: -- ffang 100301, use oe_profile.value function call instead of
1148: -- profile OE_ORGANIZATION_ID
1149: l_org_id := FND_PROFILE.Value('ORG_ID');

Line 1181: l_sales_lead_line_rec.source_promotion_id = FND_API.G_MISS_NUM)

1177:
1178: -- ffang 090801, for bug 1978014
1179: -- Default source_promotion_id as header's
1180: IF (l_sales_lead_line_rec.source_promotion_id IS NULL OR
1181: l_sales_lead_line_rec.source_promotion_id = FND_API.G_MISS_NUM)
1182: THEN
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;

Line 1193: x_return_status := FND_API.G_RET_STS_ERROR;

1189: p_msg_name => 'API_INVALID_ID',
1190: p_token1 => 'SALES_LEAD_ID',
1191: p_token1_value => p_Sales_Lead_Id);
1192:
1193: x_return_status := FND_API.G_RET_STS_ERROR;
1194: ELSE
1195: IF (l_sales_lead_line_rec.source_promotion_id IS NULL OR
1196: l_sales_lead_line_rec.source_promotion_id =
1197: FND_API.G_MISS_NUM)

Line 1197: FND_API.G_MISS_NUM)

1193: x_return_status := FND_API.G_RET_STS_ERROR;
1194: ELSE
1195: IF (l_sales_lead_line_rec.source_promotion_id IS NULL OR
1196: l_sales_lead_line_rec.source_promotion_id =
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

Line 1215: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1211: END IF;
1212: END IF;
1213: CLOSE C_Get_Header_Campaign;
1214: END IF;
1215: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1216: RAISE FND_API.G_EXC_ERROR;
1217: END IF;
1218: -- end ffang 090801
1219:

Line 1216: RAISE FND_API.G_EXC_ERROR;

1212: END IF;
1213: CLOSE C_Get_Header_Campaign;
1214: END IF;
1215: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1216: RAISE FND_API.G_EXC_ERROR;
1217: END IF;
1218: -- end ffang 090801
1219:
1220: -- Debug message

Line 1229: p_init_msg_list => FND_API.G_FALSE,

1225: END IF;
1226:
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,

Line 1237: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1233: x_return_status => x_return_status,
1234: x_msg_count => x_msg_count,
1235: x_msg_data => x_msg_data);
1236:
1237: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1238: x_sales_lead_line_out_tbl(l_curr_row).return_status :=
1239: x_return_status;
1240: RAISE FND_API.G_EXC_ERROR;
1241: END IF;

Line 1240: RAISE FND_API.G_EXC_ERROR;

1236:
1237: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1238: x_sales_lead_line_out_tbl(l_curr_row).return_status :=
1239: x_return_status;
1240: RAISE FND_API.G_EXC_ERROR;
1241: END IF;
1242:
1243: --- retrieve the category_id based on the Inventory_item_id and the organization_id
1244:

Line 1246: l_sales_lead_line_rec.INVENTORY_ITEM_ID <> FND_API.G_MISS_NUM AND

1242:
1243: --- retrieve the category_id based on the Inventory_item_id and the organization_id
1244:
1245: IF(l_sales_lead_line_rec.INVENTORY_ITEM_ID IS NOT NULL AND
1246: l_sales_lead_line_rec.INVENTORY_ITEM_ID <> FND_API.G_MISS_NUM AND
1247: l_sales_lead_line_rec.ORGANIZATION_ID IS NOT NULL AND
1248: l_sales_lead_line_rec.ORGANIZATION_ID <> FND_API.G_MISS_NUM AND
1249: (l_sales_lead_line_rec.category_id IS NULL OR
1250: l_sales_lead_line_rec.category_id = FND_API.G_MISS_NUM)

Line 1248: l_sales_lead_line_rec.ORGANIZATION_ID <> FND_API.G_MISS_NUM AND

1244:
1245: IF(l_sales_lead_line_rec.INVENTORY_ITEM_ID IS NOT NULL AND
1246: l_sales_lead_line_rec.INVENTORY_ITEM_ID <> FND_API.G_MISS_NUM AND
1247: l_sales_lead_line_rec.ORGANIZATION_ID IS NOT NULL AND
1248: l_sales_lead_line_rec.ORGANIZATION_ID <> FND_API.G_MISS_NUM AND
1249: (l_sales_lead_line_rec.category_id IS NULL OR
1250: l_sales_lead_line_rec.category_id = FND_API.G_MISS_NUM)
1251: )
1252: THEN

Line 1250: l_sales_lead_line_rec.category_id = FND_API.G_MISS_NUM)

1246: l_sales_lead_line_rec.INVENTORY_ITEM_ID <> FND_API.G_MISS_NUM AND
1247: l_sales_lead_line_rec.ORGANIZATION_ID IS NOT NULL AND
1248: l_sales_lead_line_rec.ORGANIZATION_ID <> FND_API.G_MISS_NUM AND
1249: (l_sales_lead_line_rec.category_id IS NULL OR
1250: l_sales_lead_line_rec.category_id = FND_API.G_MISS_NUM)
1251: )
1252: THEN
1253: OPEN C_Get_Category_INFO (l_sales_lead_line_rec.INVENTORY_ITEM_ID, l_sales_lead_line_rec.ORGANIZATION_ID);
1254: FETCH C_Get_Category_INFO into l_sales_lead_line_rec.category_id, l_sales_lead_line_rec.category_set_id;

Line 1265: RAISE FND_API.G_EXC_ERROR;

1261: p_token1 => 'COLUMN',
1262: p_token1_value => 'INVENTORY_ITEM',
1263: p_token2 => 'VALUE',
1264: p_token2_value => l_sales_lead_line_rec.INVENTORY_ITEM_ID );
1265: RAISE FND_API.G_EXC_ERROR;
1266: END IF;
1267: CLOSE C_Get_Category_INFO;
1268:
1269: END IF;

Line 1276: l_sales_lead_line_rec.category_set_id <> FND_API.G_MISS_NUM)

1272:
1273: --- Check for the Category_set_ID
1274:
1275: IF(l_sales_lead_line_rec.category_set_id IS NOT NULL AND
1276: l_sales_lead_line_rec.category_set_id <> FND_API.G_MISS_NUM)
1277: THEN
1278: l_category_set_id := l_sales_lead_line_rec.category_set_id ;
1279: ELSE
1280: OPEN C_Get_Category_set_ID (l_sales_lead_line_rec.category_id);

Line 1319: ,p_init_msg_list => FND_API.G_FALSE

1315: END IF;
1316:
1317: AS_ACCESS_PUB.Has_updateLeadAccess(
1318: p_api_version_number => 2.0
1319: ,p_init_msg_list => FND_API.G_FALSE
1320: ,p_validation_level => p_validation_level
1321: ,p_access_profile_rec => l_access_profile_rec
1322: ,p_admin_flag => p_admin_flag
1323: ,p_admin_group_id => p_admin_group_id

Line 1341: RAISE FND_API.G_EXC_ERROR;

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;
1343:
1344: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1345: RAISE FND_API.G_EXC_ERROR;

Line 1344: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1340: END IF;
1341: RAISE FND_API.G_EXC_ERROR;
1342: END IF;
1343:
1344: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1345: RAISE FND_API.G_EXC_ERROR;
1346: END IF;
1347:
1348: END IF;

Line 1345: RAISE FND_API.G_EXC_ERROR;

1341: RAISE FND_API.G_EXC_ERROR;
1342: END IF;
1343:
1344: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1345: RAISE FND_API.G_EXC_ERROR;
1346: END IF;
1347:
1348: END IF;
1349:

Line 1418: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1414: x_sales_lead_line_out_tbl(l_curr_row).sales_lead_line_id :=
1415: l_sales_lead_line_id;
1416: x_sales_lead_line_out_tbl(l_curr_row).return_status := x_return_status;
1417:
1418: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1419: RAISE FND_API.G_EXC_ERROR;
1420: END IF;
1421:
1422: /*

Line 1419: RAISE FND_API.G_EXC_ERROR;

1415: l_sales_lead_line_id;
1416: x_sales_lead_line_out_tbl(l_curr_row).return_status := x_return_status;
1417:
1418: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1419: RAISE FND_API.G_EXC_ERROR;
1420: END IF;
1421:
1422: /*
1423: IF l_SALES_LEAD_LINE_rec.BUDGET_AMOUNT IS NOT NULL AND

Line 1424: l_SALES_LEAD_LINE_rec.BUDGET_AMOUNT <> FND_API.G_MISS_NUM

1420: END IF;
1421:
1422: /*
1423: IF l_SALES_LEAD_LINE_rec.BUDGET_AMOUNT IS NOT NULL AND
1424: l_SALES_LEAD_LINE_rec.BUDGET_AMOUNT <> FND_API.G_MISS_NUM
1425: THEN
1426: l_lines_amount:=l_lines_amount + l_SALES_LEAD_LINE_rec.BUDGET_AMOUNT;
1427: END IF;
1428: */

Line 1452: p_init_msg_list => FND_API.G_FALSE,

1448: 'Validate BUDGET_AMOUNT');
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,

Line 1459: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1455: x_return_status => x_return_status,
1456: x_msg_count => x_msg_count,
1457: x_msg_data => x_msg_data);
1458:
1459: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1460: raise FND_API.G_EXC_ERROR;
1461: END IF;
1462: */
1463: -- Back update total_amount in lead header header

Line 1460: raise FND_API.G_EXC_ERROR;

1456: x_msg_count => x_msg_count,
1457: x_msg_data => x_msg_data);
1458:
1459: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1460: raise FND_API.G_EXC_ERROR;
1461: END IF;
1462: */
1463: -- Back update total_amount in lead header header
1464: Backupdate_Header(

Line 1468: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1464: Backupdate_Header(
1465: p_sales_lead_id => p_sales_lead_id,
1466: x_return_status => x_return_status);
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' );

Line 1474: raise FND_API.G_EXC_ERROR;

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;
1476:
1477:
1478: --

Line 1483: IF FND_API.to_Boolean( p_commit )

1479: -- END of API body
1480: --
1481:
1482: -- Standard check for p_commit
1483: IF FND_API.to_Boolean( p_commit )
1484: THEN
1485: COMMIT WORK;
1486: END IF;
1487:

Line 1502: WHEN FND_API.G_EXC_ERROR THEN

1498: p_data => x_msg_data
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

Line 1512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1508: ,X_MSG_COUNT => X_MSG_COUNT
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

Line 1538: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1534:
1535:
1536: PROCEDURE Update_sales_lead_lines(
1537: P_Api_Version_Number IN NUMBER,
1538: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1539: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1540: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1541: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1542: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1539: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

1535:
1536: PROCEDURE Update_sales_lead_lines(
1537: P_Api_Version_Number IN NUMBER,
1538: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1539: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1540: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1541: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1542: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1543: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 1540: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1536: PROCEDURE Update_sales_lead_lines(
1537: P_Api_Version_Number IN NUMBER,
1538: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1539: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1540: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1541: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1542: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1543: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1544: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 1541: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

1537: P_Api_Version_Number IN NUMBER,
1538: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1539: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1540: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1541: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1542: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1543: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1544: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
1545: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

Line 1542: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

1538: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1539: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1540: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1541: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1542: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1543: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1544: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
1545: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1546: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 1543: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

1539: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1540: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1541: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1542: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1543: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1544: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
1545: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1546: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1547: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type,

Line 1544: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,

1540: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1541: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1542: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1543: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1544: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
1545: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1546: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1547: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type,
1548: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,

Line 1583: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1579: -- Standard Start of API savepoint
1580: SAVEPOINT UPDATE_SALES_LEAD_LINES_PVT;
1581:
1582: -- Standard call to check for call compatibility.
1583: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1584: p_api_version_number,
1585: l_api_name,
1586: G_PKG_NAME)
1587: THEN

Line 1588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1584: p_api_version_number,
1585: l_api_name,
1586: G_PKG_NAME)
1587: THEN
1588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1589: END IF;
1590:
1591: -- Initialize message list IF p_init_msg_list is set to TRUE.
1592: IF FND_API.to_Boolean( p_init_msg_list )

Line 1592: IF FND_API.to_Boolean( p_init_msg_list )

1588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1589: END IF;
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:

Line 1605: x_return_status := FND_API.G_RET_STS_SUCCESS;

1601: 'PVT: ' || l_api_name || ' Start');
1602: END IF;
1603:
1604: -- Initialize API return status to SUCCESS
1605: x_return_status := FND_API.G_RET_STS_SUCCESS;
1606:
1607: --
1608: -- Api body
1609: --

Line 1625: RAISE FND_API.G_EXC_ERROR;

1621: p_token1 => 'PROFILE',
1622: p_token1_value => 'USER_ID');
1623:
1624: END IF;
1625: RAISE FND_API.G_EXC_ERROR;
1626: END IF;
1627:
1628: IF (p_validation_level = fnd_api.g_valid_level_full)
1629: THEN

Line 1628: IF (p_validation_level = fnd_api.g_valid_level_full)

1624: END IF;
1625: RAISE FND_API.G_EXC_ERROR;
1626: END IF;
1627:
1628: IF (p_validation_level = fnd_api.g_valid_level_full)
1629: THEN
1630: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
1631: p_api_version_number => 2.0
1632: ,p_init_msg_list => p_init_msg_list

Line 1641: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1637: ,x_msg_data => x_msg_data
1638: ,x_sales_member_rec => l_identity_sales_member_rec);
1639: END IF;
1640:
1641: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1642: RAISE FND_API.G_EXC_ERROR;
1643: END IF;
1644:
1645: l_update_amounts := 0;

Line 1642: RAISE FND_API.G_EXC_ERROR;

1638: ,x_sales_member_rec => l_identity_sales_member_rec);
1639: END IF;
1640:
1641: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1642: RAISE FND_API.G_EXC_ERROR;
1643: END IF;
1644:
1645: l_update_amounts := 0;
1646:

Line 1650: FND_API.G_RET_STS_SUCCESS;

1646:
1647: FOR l_curr_row IN 1..p_sales_lead_line_tbl.count LOOP
1648:
1649: x_sales_lead_line_out_tbl(l_curr_row).return_status :=
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)

Line 1685: raise FND_API.G_EXC_ERROR;

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:
1688: -- Debug Message
1689: IF (AS_DEBUG_LOW_ON) THEN

Line 1698: l_tar_SALES_LEAD_LINE_rec.last_update_date = FND_API.G_MISS_Date)

1694: Close C_Get_sales_lead_line;
1695:
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');

Line 1706: raise FND_API.G_EXC_ERROR;

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:
1709: IF (l_tar_SALES_LEAD_LINE_rec.last_update_date <> l_last_update_date)
1710: THEN

Line 1717: raise FND_API.G_EXC_ERROR;

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:
1720: -- Invoke validation procedures
1721: -- Debug message

Line 1730: p_init_msg_list => FND_API.G_FALSE,

1726: END IF;
1727:
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,

Line 1738: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

1734: x_return_status => x_return_status,
1735: x_msg_count => x_msg_count,
1736: x_msg_data => x_msg_data);
1737:
1738: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1739: x_sales_lead_line_out_tbl(l_curr_row).return_status:=x_return_status;
1740: RAISE FND_API.G_EXC_ERROR;
1741: END IF;
1742:

Line 1740: RAISE FND_API.G_EXC_ERROR;

1736: x_msg_data => x_msg_data);
1737:
1738: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1739: x_sales_lead_line_out_tbl(l_curr_row).return_status:=x_return_status;
1740: RAISE FND_API.G_EXC_ERROR;
1741: END IF;
1742:
1743: IF(P_Check_Access_Flag = 'Y') THEN
1744: -- Call Get_Access_Profiles to get access_profile_rec

Line 1766: ,p_init_msg_list => FND_API.G_FALSE

1762: END IF;
1763:
1764: AS_ACCESS_PUB.Has_updateLeadAccess(
1765: p_api_version_number => 2.0
1766: ,p_init_msg_list => FND_API.G_FALSE
1767: ,p_validation_level => p_validation_level
1768: ,p_access_profile_rec => l_access_profile_rec
1769: ,p_admin_flag => p_admin_flag
1770: ,p_admin_group_id => p_admin_group_id

Line 1787: RAISE FND_API.G_EXC_ERROR;

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;
1789:
1790: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1791: RAISE FND_API.G_EXC_ERROR;

Line 1790: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1786: END IF;
1787: RAISE FND_API.G_EXC_ERROR;
1788: END IF;
1789:
1790: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1791: RAISE FND_API.G_EXC_ERROR;
1792: END IF;
1793:
1794: END IF;

Line 1791: RAISE FND_API.G_EXC_ERROR;

1787: RAISE FND_API.G_EXC_ERROR;
1788: END IF;
1789:
1790: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1791: RAISE FND_API.G_EXC_ERROR;
1792: END IF;
1793:
1794: END IF;
1795:

Line 1862: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1858: x_sales_lead_line_out_tbl(l_curr_row).sales_lead_line_id
1859: := l_tar_SALES_LEAD_LINE_rec.SALES_LEAD_LINE_ID;
1860: x_sales_lead_line_out_tbl(l_curr_row).return_status := x_return_status;
1861:
1862: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1863: RAISE FND_API.G_EXC_ERROR;
1864: END IF;
1865:
1866: /*

Line 1863: RAISE FND_API.G_EXC_ERROR;

1859: := l_tar_SALES_LEAD_LINE_rec.SALES_LEAD_LINE_ID;
1860: x_sales_lead_line_out_tbl(l_curr_row).return_status := x_return_status;
1861:
1862: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1863: RAISE FND_API.G_EXC_ERROR;
1864: END IF;
1865:
1866: /*
1867: IF l_tar_SALES_LEAD_LINE_rec.BUDGET_AMOUNT <> FND_API.G_MISS_NUM THEN

Line 1867: IF l_tar_SALES_LEAD_LINE_rec.BUDGET_AMOUNT <> FND_API.G_MISS_NUM THEN

1863: RAISE FND_API.G_EXC_ERROR;
1864: END IF;
1865:
1866: /*
1867: IF l_tar_SALES_LEAD_LINE_rec.BUDGET_AMOUNT <> FND_API.G_MISS_NUM THEN
1868: l_update_amounts := l_update_amounts
1869: + NVL(l_tar_SALES_LEAD_LINE_rec.BUDGET_AMOUNT, 0)
1870: - NVL(l_budget_amount, 0);
1871: END IF;

Line 1888: p_init_msg_list => FND_API.G_FALSE,

1884: 'Validate BUDGET_AMOUNT');
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,

Line 1895: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1891: x_return_status => x_return_status,
1892: x_msg_count => x_msg_count,
1893: x_msg_data => x_msg_data);
1894:
1895: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1896: raise FND_API.G_EXC_ERROR;
1897: END IF;
1898: */
1899: -- Back update total_amount in lead header

Line 1896: raise FND_API.G_EXC_ERROR;

1892: x_msg_count => x_msg_count,
1893: x_msg_data => x_msg_data);
1894:
1895: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1896: raise FND_API.G_EXC_ERROR;
1897: END IF;
1898: */
1899: -- Back update total_amount in lead header
1900: Backupdate_Header(

Line 1904: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1900: Backupdate_Header(
1901: p_sales_lead_id => l_sales_lead_id,
1902: x_return_status => x_return_status);
1903:
1904: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1905: raise FND_API.G_EXC_ERROR;
1906: END IF;
1907:
1908:

Line 1905: raise FND_API.G_EXC_ERROR;

1901: p_sales_lead_id => l_sales_lead_id,
1902: x_return_status => x_return_status);
1903:
1904: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1905: raise FND_API.G_EXC_ERROR;
1906: END IF;
1907:
1908:
1909: --

Line 1914: IF FND_API.to_Boolean( p_commit )

1910: -- END of API body.
1911: --
1912:
1913: -- Standard check for p_commit
1914: IF FND_API.to_Boolean( p_commit )
1915: THEN
1916: COMMIT WORK;
1917: END IF;
1918:

Line 1933: WHEN FND_API.G_EXC_ERROR THEN

1929: p_data => x_msg_data
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

Line 1943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1939: ,X_MSG_COUNT => X_MSG_COUNT
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

Line 1969: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1965:
1966:
1967: PROCEDURE Delete_sales_lead_lines(
1968: P_Api_Version_Number IN NUMBER,
1969: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1970: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1971: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1972: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1973: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1970: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

1966:
1967: PROCEDURE Delete_sales_lead_lines(
1968: P_Api_Version_Number IN NUMBER,
1969: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1970: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1971: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1972: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1973: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1974: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

Line 1971: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1967: PROCEDURE Delete_sales_lead_lines(
1968: P_Api_Version_Number IN NUMBER,
1969: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1970: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1971: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1972: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1973: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1974: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1975: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

Line 1972: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

1968: P_Api_Version_Number IN NUMBER,
1969: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1970: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1971: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1972: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1973: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1974: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1975: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1976: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

Line 1973: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

1969: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1970: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1971: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1972: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1973: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1974: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1975: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1976: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1977: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

Line 1974: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,

1970: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1971: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1972: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1973: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1974: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1975: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1976: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1977: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1978: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type,

Line 1975: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,

1971: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1972: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1973: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1974: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1975: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1976: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1977: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1978: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type,
1979: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,

Line 2007: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

2003: -- Standard Start of API savepoint
2004: SAVEPOINT DELETE_SALES_LEAD_LINES_PVT;
2005:
2006: -- Standard call to check for call compatibility.
2007: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2008: p_api_version_number,
2009: l_api_name,
2010: G_PKG_NAME)
2011: THEN

Line 2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2008: p_api_version_number,
2009: l_api_name,
2010: G_PKG_NAME)
2011: THEN
2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2013: END IF;
2014:
2015: -- Initialize message list IF p_init_msg_list is set to TRUE.
2016: IF FND_API.to_Boolean( p_init_msg_list )

Line 2016: IF FND_API.to_Boolean( p_init_msg_list )

2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2013: END IF;
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:

Line 2029: x_return_status := FND_API.G_RET_STS_SUCCESS;

2025: 'PVT: ' || l_api_name || ' Start');
2026: END IF;
2027:
2028: -- Initialize API return status to SUCCESS
2029: x_return_status := FND_API.G_RET_STS_SUCCESS;
2030:
2031: --
2032: -- API body
2033: --

Line 2048: RAISE FND_API.G_EXC_ERROR;

2044: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
2045: p_token1 => 'PROFILE',
2046: p_token1_value => 'USER_ID');
2047: END IF;
2048: RAISE FND_API.G_EXC_ERROR;
2049: END IF;
2050:
2051: IF (p_validation_level = fnd_api.g_valid_level_full)
2052: THEN

Line 2051: IF (p_validation_level = fnd_api.g_valid_level_full)

2047: END IF;
2048: RAISE FND_API.G_EXC_ERROR;
2049: END IF;
2050:
2051: IF (p_validation_level = fnd_api.g_valid_level_full)
2052: THEN
2053: AS_SALES_ORG_MANAGER_PVT.Get_CurrentUser(
2054: p_api_version_number => 2.0
2055: ,p_init_msg_list => p_init_msg_list

Line 2064: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2060: ,x_msg_data => x_msg_data
2061: ,x_sales_member_rec => l_identity_sales_member_rec);
2062: END IF;
2063:
2064: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2065: RAISE FND_API.G_EXC_ERROR;
2066: END IF;
2067:
2068: l_delete_amounts := 0;

Line 2065: RAISE FND_API.G_EXC_ERROR;

2061: ,x_sales_member_rec => l_identity_sales_member_rec);
2062: END IF;
2063:
2064: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2065: RAISE FND_API.G_EXC_ERROR;
2066: END IF;
2067:
2068: l_delete_amounts := 0;
2069:

Line 2072: := FND_API.G_RET_STS_SUCCESS;

2068: l_delete_amounts := 0;
2069:
2070: FOR l_curr_row IN 1..p_sales_lead_line_tbl.count LOOP
2071: x_sales_lead_line_out_tbl(l_curr_row).return_status
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)

Line 2097: raise FND_API.G_EXC_ERROR;

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:
2100: -- Debug Message
2101: IF (AS_DEBUG_LOW_ON) THEN

Line 2131: ,p_init_msg_list => FND_API.G_FALSE

2127: END IF;
2128:
2129: AS_ACCESS_PUB.Has_updateLeadAccess(
2130: p_api_version_number => 2.0
2131: ,p_init_msg_list => FND_API.G_FALSE
2132: ,p_validation_level => p_validation_level
2133: ,p_access_profile_rec => l_access_profile_rec
2134: ,p_admin_flag => p_admin_flag
2135: ,p_admin_group_id => p_admin_group_id

Line 2152: RAISE FND_API.G_EXC_ERROR;

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;
2154:
2155: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2156: RAISE FND_API.G_EXC_ERROR;

Line 2155: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2151: END IF;
2152: RAISE FND_API.G_EXC_ERROR;
2153: END IF;
2154:
2155: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2156: RAISE FND_API.G_EXC_ERROR;
2157: END IF;
2158:
2159: END IF;

Line 2156: RAISE FND_API.G_EXC_ERROR;

2152: RAISE FND_API.G_EXC_ERROR;
2153: END IF;
2154:
2155: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2156: RAISE FND_API.G_EXC_ERROR;
2157: END IF;
2158:
2159: END IF;
2160:

Line 2178: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2174: x_sales_lead_line_out_tbl(l_curr_row).return_status := x_return_status;
2175:
2176: -- l_delete_amounts := l_delete_amounts + nvl(l_budget_amount, 0);
2177:
2178: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2179: RAISE FND_API.G_EXC_ERROR;
2180: END IF;
2181: END LOOP;
2182:

Line 2179: RAISE FND_API.G_EXC_ERROR;

2175:
2176: -- l_delete_amounts := l_delete_amounts + nvl(l_budget_amount, 0);
2177:
2178: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2179: RAISE FND_API.G_EXC_ERROR;
2180: END IF;
2181: END LOOP;
2182:
2183: /*

Line 2196: p_init_msg_list => FND_API.G_FALSE,

2192: 'Validate BUDGET_AMOUNT');
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,

Line 2203: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2199: x_return_status => x_return_status,
2200: x_msg_count => x_msg_count,
2201: x_msg_data => x_msg_data);
2202:
2203: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2204: raise FND_API.G_EXC_ERROR;
2205: END IF;
2206: */
2207:

Line 2204: raise FND_API.G_EXC_ERROR;

2200: x_msg_count => x_msg_count,
2201: x_msg_data => x_msg_data);
2202:
2203: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2204: raise FND_API.G_EXC_ERROR;
2205: END IF;
2206: */
2207:
2208: --

Line 2213: IF FND_API.to_Boolean( p_commit )

2209: -- END of API body
2210: --
2211:
2212: -- Standard check for p_commit
2213: IF FND_API.to_Boolean( p_commit )
2214: THEN
2215: COMMIT WORK;
2216: END IF;
2217:

Line 2231: WHEN FND_API.G_EXC_ERROR THEN

2227: ( p_count => x_msg_count,
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

Line 2241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2237: ,X_MSG_COUNT => X_MSG_COUNT
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