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_INTEREST_PUB dependencies on FND_API

Line 29: -- FND_API.G_MISS for update purpose

25: -- Add interest_id, customer_id, address_id,
26: -- contact_id and lead_id into
27: -- interest record
28: -- Changed interest rec default value NULL to
29: -- FND_API.G_MISS for update purpose
30: --
31: --
32: G_PKG_NAME CONSTANT VARCHAR2(30):='AS_INTEREST_PUB';
33: G_FILE_NAME CONSTANT VARCHAR2(12):='asxpintb.pls';

Line 51: ,p_init_msg_list in varchar2 := fnd_api.g_false

47: --
48: -- End of Comments
49:
50: Procedure create_interest(p_api_version_number in number
51: ,p_init_msg_list in varchar2 := fnd_api.g_false
52: ,p_commit in varchar2 := fnd_api.g_false
53: ,p_validation_level IN NUMBER
54: := FND_API.G_VALID_LEVEL_FULL
55: ,p_interest_rec in interest_rec_type

Line 52: ,p_commit in varchar2 := fnd_api.g_false

48: -- End of Comments
49:
50: Procedure create_interest(p_api_version_number in number
51: ,p_init_msg_list in varchar2 := fnd_api.g_false
52: ,p_commit in varchar2 := fnd_api.g_false
53: ,p_validation_level IN NUMBER
54: := FND_API.G_VALID_LEVEL_FULL
55: ,p_interest_rec in interest_rec_type
56: ,p_customer_id in number

Line 54: := FND_API.G_VALID_LEVEL_FULL

50: Procedure create_interest(p_api_version_number in number
51: ,p_init_msg_list in varchar2 := fnd_api.g_false
52: ,p_commit in varchar2 := fnd_api.g_false
53: ,p_validation_level IN NUMBER
54: := FND_API.G_VALID_LEVEL_FULL
55: ,p_interest_rec in interest_rec_type
56: ,p_customer_id in number
57: ,p_address_id in number
58: ,p_contact_id in number

Line 86: if not fnd_api.compatible_api_call ( l_api_version_number,

82: -- standard start of api savepoint
83: savepoint create_interest_pub;
84:
85: -- standard call to check for call compatibility.
86: if not fnd_api.compatible_api_call ( l_api_version_number,
87: p_api_version_number,
88: l_api_name,
89: g_pkg_name)
90: then

Line 91: raise fnd_api.g_exc_unexpected_error;

87: p_api_version_number,
88: l_api_name,
89: g_pkg_name)
90: then
91: raise fnd_api.g_exc_unexpected_error;
92: end if;
93:
94:
95: -- initialize message list if p_init_msg_list is set to true.

Line 96: if fnd_api.to_boolean( p_init_msg_list )

92: end if;
93:
94:
95: -- initialize message list if p_init_msg_list is set to true.
96: if fnd_api.to_boolean( p_init_msg_list )
97: then
98: fnd_msg_pub.initialize;
99: end if;
100:

Line 109: p_return_status := FND_API.G_RET_STS_SUCCESS;

105: fnd_msg_pub.add;
106: end if;
107:
108: -- Initialize API return status to success
109: p_return_status := FND_API.G_RET_STS_SUCCESS;
110:
111: l_interest_tbl(1) := p_interest_rec;
112:
113: -- Convert account classification values to ids

Line 119: ,p_init_msg_list => fnd_api.g_false

115: p_pvt_interest_tbl => l_pvt_classification_tbl
116: );
117:
118: as_interest_pvt.create_interest ( p_api_version_number => 2.0
119: ,p_init_msg_list => fnd_api.g_false
120: ,p_commit => fnd_api.g_false
121: ,p_validation_level => p_validation_level
122: ,p_interest_tbl => l_pvt_classification_tbl
123: ,p_customer_id => p_customer_id

Line 120: ,p_commit => fnd_api.g_false

116: );
117:
118: as_interest_pvt.create_interest ( p_api_version_number => 2.0
119: ,p_init_msg_list => fnd_api.g_false
120: ,p_commit => fnd_api.g_false
121: ,p_validation_level => p_validation_level
122: ,p_interest_tbl => l_pvt_classification_tbl
123: ,p_customer_id => p_customer_id
124: ,p_address_id => p_address_id

Line 140: if l_return_status = fnd_api.g_ret_sts_error then

136: ,p_interest_out_tbl => l_pvt_interest_out_tbl
137: );
138:
139: p_return_status := l_return_status;
140: if l_return_status = fnd_api.g_ret_sts_error then
141: raise fnd_api.g_exc_error;
142: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
143: raise fnd_api.g_exc_unexpected_error;
144: end if;

Line 141: raise fnd_api.g_exc_error;

137: );
138:
139: p_return_status := l_return_status;
140: if l_return_status = fnd_api.g_ret_sts_error then
141: raise fnd_api.g_exc_error;
142: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
143: raise fnd_api.g_exc_unexpected_error;
144: end if;
145:

Line 142: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then

138:
139: p_return_status := l_return_status;
140: if l_return_status = fnd_api.g_ret_sts_error then
141: raise fnd_api.g_exc_error;
142: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
143: raise fnd_api.g_exc_unexpected_error;
144: end if;
145:
146: p_interest_out_id := l_pvt_interest_out_tbl(1).interest_id;

Line 143: raise fnd_api.g_exc_unexpected_error;

139: p_return_status := l_return_status;
140: if l_return_status = fnd_api.g_ret_sts_error then
141: raise fnd_api.g_exc_error;
142: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
143: raise fnd_api.g_exc_unexpected_error;
144: end if;
145:
146: p_interest_out_id := l_pvt_interest_out_tbl(1).interest_id;
147:

Line 156: if fnd_api.to_boolean ( p_commit )

152:
153: AS_RTTAP_ACCOUNT.PROCESS_RTTAP_ACCOUNT
154: (p_interest_rec.customer_id,l_return_status);
155:
156: if fnd_api.to_boolean ( p_commit )
157: then
158: commit work;
159: end if;
160:

Line 175: WHEN FND_API.G_EXC_ERROR THEN

171: ,p_data => p_msg_data );
172:
173: exception
174:
175: WHEN FND_API.G_EXC_ERROR THEN
176:
177: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
178: P_MODULE => l_module
179: ,P_API_NAME => L_API_NAME

Line 187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

183: ,X_MSG_COUNT => P_MSG_COUNT
184: ,X_MSG_DATA => P_MSG_DATA
185: ,X_RETURN_STATUS => P_RETURN_STATUS);
186:
187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
188:
189: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
190: P_MODULE => l_module
191: ,P_API_NAME => L_API_NAME

Line 225: -- Default = FND_API.G_FALSE

221: -- Parameters
222: -- IN :
223: -- p_api_version_number IN NUMBER Required
224: -- p_init_msg_list IN VARCHAR2 Optional
225: -- Default = FND_API.G_FALSE
226: -- p_commit IN VARCHAR2 Optional
227: -- Default = FND_API.G_FALSE
228: -- p_validation_level IN NUMBER Optional
229: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 227: -- Default = FND_API.G_FALSE

223: -- p_api_version_number IN NUMBER Required
224: -- p_init_msg_list IN VARCHAR2 Optional
225: -- Default = FND_API.G_FALSE
226: -- p_commit IN VARCHAR2 Optional
227: -- Default = FND_API.G_FALSE
228: -- p_validation_level IN NUMBER Optional
229: -- Default = FND_API.G_VALID_LEVEL_FULL
230: -- p_identity_salesforce_id IN NUMBER Optional
231: -- p_interest_rec IN INTEREST_REC_TYPE Required

Line 229: -- Default = FND_API.G_VALID_LEVEL_FULL

225: -- Default = FND_API.G_FALSE
226: -- p_commit IN VARCHAR2 Optional
227: -- Default = FND_API.G_FALSE
228: -- p_validation_level IN NUMBER Optional
229: -- Default = FND_API.G_VALID_LEVEL_FULL
230: -- p_identity_salesforce_id IN NUMBER Optional
231: -- p_interest_rec IN INTEREST_REC_TYPE Required
232: -- p_interest_use_code IN VARCHAR2 Required
233: -- (LEAD_CLASSIFICATION, COMPANY_CLASSIFICATION,

Line 256: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

252: -- End of Comments
253:
254: PROCEDURE Update_Interest
255: ( p_api_version_number IN NUMBER,
256: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
257: p_commit IN VARCHAR2 := FND_API.G_FALSE,
258: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
259: p_identity_salesforce_id IN NUMBER := NULL,
260: p_interest_rec IN INTEREST_REC_TYPE := G_MISS_INTEREST_REC,

Line 257: p_commit IN VARCHAR2 := FND_API.G_FALSE,

253:
254: PROCEDURE Update_Interest
255: ( p_api_version_number IN NUMBER,
256: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
257: p_commit IN VARCHAR2 := FND_API.G_FALSE,
258: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
259: p_identity_salesforce_id IN NUMBER := NULL,
260: p_interest_rec IN INTEREST_REC_TYPE := G_MISS_INTEREST_REC,
261: p_interest_use_code IN VARCHAR2,

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

254: PROCEDURE Update_Interest
255: ( p_api_version_number IN NUMBER,
256: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
257: p_commit IN VARCHAR2 := FND_API.G_FALSE,
258: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
259: p_identity_salesforce_id IN NUMBER := NULL,
260: p_interest_rec IN INTEREST_REC_TYPE := G_MISS_INTEREST_REC,
261: p_interest_use_code IN VARCHAR2,
262: p_check_access_flag IN VARCHAR2,

Line 293: IF NOT FND_API.Compatible_API_Call( l_api_version_number,

289: -- Standard Start of API savepoint
290: SAVEPOINT UPDATE_INTEREST_PUB;
291:
292: -- Standard call to check for call compatibility.
293: IF NOT FND_API.Compatible_API_Call( l_api_version_number,
294: p_api_version_number,
295: l_api_name,
296: G_PKG_NAME)
297: THEN

Line 298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

294: p_api_version_number,
295: l_api_name,
296: G_PKG_NAME)
297: THEN
298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
299: END IF;
300:
301:
302: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 303: IF FND_API.to_Boolean( p_init_msg_list )

299: END IF;
300:
301:
302: -- Initialize message list if p_init_msg_list is set to TRUE.
303: IF FND_API.to_Boolean( p_init_msg_list )
304: THEN
305: FND_MSG_PUB.initialize;
306: END IF;
307:

Line 316: x_return_status := FND_API.G_RET_STS_SUCCESS;

312: FND_MSG_PUB.Add;
313: END IF;
314:
315: -- Initialize API return status to success
316: x_return_status := FND_API.G_RET_STS_SUCCESS;
317: l_return_status := FND_API.G_RET_STS_SUCCESS;
318:
319: /*
320: Commented by gbatra as assumption is that ids are always passed

Line 317: l_return_status := FND_API.G_RET_STS_SUCCESS;

313: END IF;
314:
315: -- Initialize API return status to success
316: x_return_status := FND_API.G_RET_STS_SUCCESS;
317: l_return_status := FND_API.G_RET_STS_SUCCESS;
318:
319: /*
320: Commented by gbatra as assumption is that ids are always passed
321: Convert_Interest_Values_To_Ids (p_interest_type => p_interest_rec.interest_type,

Line 371: p_init_msg_list => FND_API.G_FALSE,

367: l_interest_rec.attribute14 := p_interest_rec.attribute14 ;
368: l_interest_rec.attribute15 := p_interest_rec.attribute15 ;
369:
370: AS_INTEREST_PVT.Update_Interest ( p_api_version_number => 2.0,
371: p_init_msg_list => FND_API.G_FALSE,
372: p_commit => FND_API.G_FALSE,
373: p_validation_level => p_validation_level,
374: p_identity_salesforce_id=> p_identity_salesforce_id,
375: p_interest_rec => l_interest_rec,

Line 372: p_commit => FND_API.G_FALSE,

368: l_interest_rec.attribute15 := p_interest_rec.attribute15 ;
369:
370: AS_INTEREST_PVT.Update_Interest ( p_api_version_number => 2.0,
371: p_init_msg_list => FND_API.G_FALSE,
372: p_commit => FND_API.G_FALSE,
373: p_validation_level => p_validation_level,
374: p_identity_salesforce_id=> p_identity_salesforce_id,
375: p_interest_rec => l_interest_rec,
376: p_interest_use_code => p_interest_use_code,

Line 390: x_return_status = FND_API.G_RET_STS_SUCCESS

386:
387: x_interest_id := p_interest_rec.interest_id;
388: -- Success Message
389: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) and
390: x_return_status = FND_API.G_RET_STS_SUCCESS
391: THEN
392: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');
393: FND_MESSAGE.Set_Token('ROW', 'AS_INTEREST', TRUE);
394: FND_MSG_PUB.Add;

Line 399: IF l_lead_id = FND_API.G_MISS_NUM THEN

395: END IF;
396:
397: l_address_id := p_interest_rec.address_id;
398: l_lead_id := p_interest_rec.lead_id;
399: IF l_lead_id = FND_API.G_MISS_NUM THEN
400: l_lead_id := NULL;
401: END IF;
402:
403: AS_RTTAP_ACCOUNT.PROCESS_RTTAP_ACCOUNT

Line 407: IF FND_API.To_Boolean ( p_commit )

403: AS_RTTAP_ACCOUNT.PROCESS_RTTAP_ACCOUNT
404: (p_interest_rec.customer_id,x_return_status);
405:
406: -- Standard check of p_commit.
407: IF FND_API.To_Boolean ( p_commit )
408: THEN
409: COMMIT WORK;
410: END IF;
411:

Line 426: WHEN FND_API.G_EXC_ERROR THEN

422: );
423:
424: EXCEPTION
425:
426: WHEN FND_API.G_EXC_ERROR THEN
427: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
428: P_MODULE => l_module
429: ,P_API_NAME => L_API_NAME
430: ,P_PKG_NAME => G_PKG_NAME

Line 437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

433: ,X_MSG_COUNT => X_MSG_COUNT
434: ,X_MSG_DATA => X_MSG_DATA
435: ,X_RETURN_STATUS => X_RETURN_STATUS);
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
439: P_MODULE => l_module
440: ,P_API_NAME => L_API_NAME
441: ,P_PKG_NAME => G_PKG_NAME

Line 491: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

487: l_any_errors BOOLEAN := FALSE;
488: l_any_row_errors BOOLEAN := FALSE;
489:
490: l_val VARCHAR2(30);
491: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
492:
493: l_pvt_interest_rec AS_INTEREST_PVT.INTEREST_REC_TYPE;
494:
495: Cursor C_Get_Int_Status (X_Int_Status VARCHAR2, X_Product_Category_Id NUMBER, X_Product_Cat_Set_Id NUMBER) IS

Line 553: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

549: );
550:
551: -- Process the return status from the procedure
552: --
553: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
554: THEN
555: l_any_row_errors := TRUE;
556: END IF;
557: */

Line 563: and p_interest_tbl(l_curr_row).status_code <> FND_API.G_MISS_CHAR)

559:
560: -- Convert Interest Status
561: --
562: IF (p_interest_tbl(l_curr_row).status_code is not NULL
563: and p_interest_tbl(l_curr_row).status_code <> FND_API.G_MISS_CHAR)
564: THEN
565:
566: p_pvt_interest_tbl(l_curr_row).status_code :=
567: p_interest_tbl(l_curr_row).status_code;

Line 570: and p_interest_tbl(l_curr_row).status <> FND_API.G_MISS_CHAR)

566: p_pvt_interest_tbl(l_curr_row).status_code :=
567: p_interest_tbl(l_curr_row).status_code;
568:
569: IF (p_interest_tbl(l_curr_row).status is not NULL
570: and p_interest_tbl(l_curr_row).status <> FND_API.G_MISS_CHAR)
571: THEN
572: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
573: THEN
574: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_IGNORED');

Line 581: and p_interest_tbl(l_curr_row).status <> FND_API.G_MISS_CHAR)

577: END IF;
578: END IF;
579:
580: ELSIF (p_interest_tbl(l_curr_row).status is not NULL
581: and p_interest_tbl(l_curr_row).status <> FND_API.G_MISS_CHAR)
582: THEN
583: OPEN C_Get_Int_Status (p_interest_tbl(l_curr_row).status,
584: p_pvt_interest_tbl(l_curr_row).product_category_id,
585: p_pvt_interest_tbl(l_curr_row).product_cat_set_id);

Line 637: raise FND_API.G_EXC_ERROR;

633: -- If there was an error in processing the row, then raise an error
634: --
635: IF l_any_row_errors
636: THEN
637: raise FND_API.G_EXC_ERROR;
638: END IF;
639:
640: EXCEPTION
641: WHEN OTHERS THEN

Line 726: p_return_status := FND_API.G_RET_STS_SUCCESS;

722: l_interest_code_id NUMBER;
723: l_secondary_interest_code_id NUMBER;
724: BEGIN
725:
726: p_return_status := FND_API.G_RET_STS_SUCCESS;
727:
728: -- Initialize Out Variables
729: p_out_interest_type_id := NULL;
730: p_out_primary_interest_code_id := NULL;

Line 737: p_interest_type_id <> FND_API.G_MISS_NUM)

733:
734: -- Convert Interest Type
735: --
736: IF (p_interest_type_id is not NULL and
737: p_interest_type_id <> FND_API.G_MISS_NUM)
738: THEN
739: p_out_interest_type_id := p_interest_type_id;
740: l_interest_type_id := p_interest_type_id;
741:

Line 743: p_interest_type <> FND_API.G_MISS_CHAR)

739: p_out_interest_type_id := p_interest_type_id;
740: l_interest_type_id := p_interest_type_id;
741:
742: IF (p_interest_type is not NULL and
743: p_interest_type <> FND_API.G_MISS_CHAR)
744: THEN
745: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
746: THEN
747: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_IGNORED');

Line 754: p_interest_type <> FND_API.G_MISS_CHAR)

750: END IF;
751: END IF;
752:
753: ELSIF (p_interest_type is not NULL and
754: p_interest_type <> FND_API.G_MISS_CHAR)
755: THEN
756: OPEN C_Get_Int_Type ( p_interest_type );
757: FETCH C_Get_Int_Type INTO l_interest_type_id;
758:

Line 771: raise FND_API.G_EXC_ERROR;

767:
768: -- This will raise an exception immediately, since all other processing
769: -- is dependent upon interest_type existing
770: --
771: raise FND_API.G_EXC_ERROR;
772:
773: ELSE
774: p_out_interest_type_id := l_interest_type_id;
775: END IF;

Line 791: raise FND_API.G_EXC_ERROR;

787:
788: -- This will raise an exception immediately, since all other processing
789: -- is dependent upon interest_type existing
790: --
791: raise FND_API.G_EXC_ERROR;
792: END IF;
793:
794:
795: -- Convert Primary Code

Line 798: p_primary_interest_code_id <> FND_API.G_MISS_NUM)

794:
795: -- Convert Primary Code
796: --
797: IF (p_primary_interest_code_id is not NULL and
798: p_primary_interest_code_id <> FND_API.G_MISS_NUM)
799: THEN
800: p_out_primary_interest_code_id := p_primary_interest_code_id;
801: l_interest_code_id := p_primary_interest_code_id;
802:

Line 804: p_primary_interest_code <> FND_API.G_MISS_CHAR)

800: p_out_primary_interest_code_id := p_primary_interest_code_id;
801: l_interest_code_id := p_primary_interest_code_id;
802:
803: IF (p_primary_interest_code is not NULL and
804: p_primary_interest_code <> FND_API.G_MISS_CHAR)
805: THEN
806: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
807: THEN
808: FND_MESSAGE.Set_Name ('AS','API_ATTRIBUTE_IGNORED');

Line 815: p_primary_interest_code <> FND_API.G_MISS_CHAR)

811: END IF;
812: END IF;
813:
814: ELSIF (p_primary_interest_code is not NULL and
815: p_primary_interest_code <> FND_API.G_MISS_CHAR)
816: THEN
817: OPEN C_Get_Int_Code ( p_primary_interest_code, l_interest_type_id );
818: FETCH C_Get_Int_Code INTO l_interest_code_id;
819: IF (C_Get_Int_Code%NOTFOUND) THEN

Line 827: p_return_status := FND_API.G_RET_STS_ERROR;

823: FND_MESSAGE.Set_Token('VALUE', p_primary_interest_code, FALSE);
824: FND_MSG_PUB.Add;
825: END IF;
826:
827: p_return_status := FND_API.G_RET_STS_ERROR;
828:
829: ELSE
830: p_out_primary_interest_code_id := l_interest_code_id;
831: END IF;

Line 839: p_secondary_interest_code_id <> FND_API.G_MISS_NUM)

835:
836: -- Convert Secondary Code
837: --
838: IF (p_secondary_interest_code_id is not NULL and
839: p_secondary_interest_code_id <> FND_API.G_MISS_NUM)
840: THEN
841: p_out_second_interest_code_id := p_secondary_interest_code_id;
842: l_secondary_interest_code_id := p_secondary_interest_code_id;
843:

Line 845: p_secondary_interest_code <> FND_API.G_MISS_CHAR)

841: p_out_second_interest_code_id := p_secondary_interest_code_id;
842: l_secondary_interest_code_id := p_secondary_interest_code_id;
843:
844: IF (p_secondary_interest_code is not NULL and
845: p_secondary_interest_code <> FND_API.G_MISS_CHAR)
846: THEN
847: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
848: THEN
849: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_IGNORED');

Line 856: p_secondary_interest_code <> FND_API.G_MISS_CHAR)

852: END IF;
853: END IF;
854:
855: ELSIF (p_secondary_interest_code is not NULL and
856: p_secondary_interest_code <> FND_API.G_MISS_CHAR)
857: THEN
858: OPEN C_Get_Int_Code ( p_secondary_interest_code, l_interest_type_id );
859: FETCH C_Get_Int_Code INTO l_secondary_interest_code_id;
860: IF(C_Get_Int_Code%NOTFOUND) THEN

Line 867: p_return_status := FND_API.G_RET_STS_ERROR;

863: FND_MESSAGE.Set_Token ('COLUMN', 'SECONDARY_INTEREST_CODE', FALSE);
864: FND_MESSAGE.Set_Token('VALUE', p_secondary_interest_code, FALSE);
865: FND_MSG_PUB.Add;
866: END IF;
867: p_return_status := FND_API.G_RET_STS_ERROR;
868:
869: ELSE
870: p_out_second_interest_code_id := l_secondary_interest_code_id;
871:

Line 883: p_Description = FND_API.G_MISS_CHAR)

879: -- If not null use primary description, otherwise
880: -- If not null use interest type description, otherwise
881: --
882: IF (p_Description is null and
883: p_Description = FND_API.G_MISS_CHAR)
884: THEN
885: IF l_Secondary_Interest_Code_Id is not null
886: THEN
887: open interest_code_desc(l_Secondary_Interest_Code_Id

Line 901: RAISE FND_API.G_EXC_ERROR;

897: || ',' || to_char(l_Interest_Type_Id), FALSE);
898: FND_MSG_PUB.ADD;
899: END IF;
900: close interest_code_desc;
901: RAISE FND_API.G_EXC_ERROR;
902:
903: ELSE
904: close interest_code_desc;
905: END IF;

Line 923: RAISE FND_API.G_EXC_ERROR;

919: FND_MSG_PUB.ADD;
920: END IF;
921:
922: close interest_code_desc;
923: RAISE FND_API.G_EXC_ERROR;
924:
925: ELSE
926: close interest_code_desc;
927: END IF;

Line 942: RAISE FND_API.G_EXC_ERROR;

938: FND_MESSAGE.Set_Token('VALUE', l_Interest_Type_Id, FALSE);
939: FND_MSG_PUB.ADD;
940: END IF;
941: close interest_type_desc;
942: RAISE FND_API.G_EXC_ERROR;
943: ELSE
944: close interest_type_desc;
945: END IF;
946: END IF;

Line 957: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

953: END Convert_Interest_Values_To_Ids;
954:
955: PROCEDURE Delete_Interest
956: ( p_api_version_number IN NUMBER,
957: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
958: p_commit IN VARCHAR2 := FND_API.G_FALSE,
959: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
960: p_identity_salesforce_id IN NUMBER,
961: p_interest_rec IN INTEREST_REC_TYPE := G_MISS_INTEREST_REC,

Line 958: p_commit IN VARCHAR2 := FND_API.G_FALSE,

954:
955: PROCEDURE Delete_Interest
956: ( p_api_version_number IN NUMBER,
957: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
958: p_commit IN VARCHAR2 := FND_API.G_FALSE,
959: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
960: p_identity_salesforce_id IN NUMBER,
961: p_interest_rec IN INTEREST_REC_TYPE := G_MISS_INTEREST_REC,
962: p_interest_use_code IN VARCHAR2,

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

955: PROCEDURE Delete_Interest
956: ( p_api_version_number IN NUMBER,
957: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
958: p_commit IN VARCHAR2 := FND_API.G_FALSE,
959: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
960: p_identity_salesforce_id IN NUMBER,
961: p_interest_rec IN INTEREST_REC_TYPE := G_MISS_INTEREST_REC,
962: p_interest_use_code IN VARCHAR2,
963: p_check_access_flag in varchar2,

Line 979: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

975: l_module CONSTANT VARCHAR2(255) := 'as.plsql.intpb.Delete_Interest';
976: begin
977: SAVEPOINT DELETE_INTEREST_PUB;
978: -- Standard call to check for call compatibility.
979: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
980: p_api_version_number,
981: l_api_name,
982: G_PKG_NAME)
983: THEN

Line 984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

980: p_api_version_number,
981: l_api_name,
982: G_PKG_NAME)
983: THEN
984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
985: END IF;
986:
987: -- Initialize message list if p_init_msg_list is set to TRUE.
988: IF FND_API.to_Boolean( p_init_msg_list )

Line 988: IF FND_API.to_Boolean( p_init_msg_list )

984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
985: END IF;
986:
987: -- Initialize message list if p_init_msg_list is set to TRUE.
988: IF FND_API.to_Boolean( p_init_msg_list )
989: THEN
990: FND_MSG_PUB.initialize;
991: END IF;
992:

Line 1003: x_return_status := FND_API.G_RET_STS_SUCCESS;

999: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1000: END IF;
1001:
1002: -- Initialize API return status to SUCCESS
1003: x_return_status := FND_API.G_RET_STS_SUCCESS;
1004:
1005: --
1006: -- API body
1007: --

Line 1019: p_init_msg_list => FND_API.G_FALSE,

1015: l_interest_rec.address_id := p_interest_rec.address_id;
1016: l_interest_rec.lead_id := p_interest_rec.lead_id;
1017:
1018: as_interest_pvt.Delete_Interest ( p_api_version_number => 2.0,
1019: p_init_msg_list => FND_API.G_FALSE,
1020: p_commit => FND_API.G_FALSE,
1021: p_validation_level => p_validation_level,
1022: p_identity_salesforce_id=> p_identity_salesforce_id,
1023: p_interest_rec => l_interest_rec,

Line 1020: p_commit => FND_API.G_FALSE,

1016: l_interest_rec.lead_id := p_interest_rec.lead_id;
1017:
1018: as_interest_pvt.Delete_Interest ( p_api_version_number => 2.0,
1019: p_init_msg_list => FND_API.G_FALSE,
1020: p_commit => FND_API.G_FALSE,
1021: p_validation_level => p_validation_level,
1022: p_identity_salesforce_id=> p_identity_salesforce_id,
1023: p_interest_rec => l_interest_rec,
1024: p_interest_use_code => p_interest_use_code,

Line 1035: IF x_return_status = FND_API.G_RET_STS_ERROR then

1031: x_msg_data => x_msg_data
1032: );
1033:
1034:
1035: IF x_return_status = FND_API.G_RET_STS_ERROR then
1036: raise FND_API.G_EXC_ERROR;
1037: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1038: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1039: END IF;

Line 1036: raise FND_API.G_EXC_ERROR;

1032: );
1033:
1034:
1035: IF x_return_status = FND_API.G_RET_STS_ERROR then
1036: raise FND_API.G_EXC_ERROR;
1037: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1038: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1039: END IF;
1040:

Line 1037: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1033:
1034:
1035: IF x_return_status = FND_API.G_RET_STS_ERROR then
1036: raise FND_API.G_EXC_ERROR;
1037: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1038: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1039: END IF;
1040:
1041:

Line 1038: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1034:
1035: IF x_return_status = FND_API.G_RET_STS_ERROR then
1036: raise FND_API.G_EXC_ERROR;
1037: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1038: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1039: END IF;
1040:
1041:
1042: --

Line 1046: IF FND_API.to_Boolean( p_commit )

1042: --
1043: -- End of API body.
1044: --
1045:
1046: IF FND_API.to_Boolean( p_commit )
1047: THEN
1048: COMMIT WORK;
1049: END IF;
1050:

Line 1068: WHEN FND_API.G_EXC_ERROR THEN

1064: p_data => x_msg_data
1065: );
1066:
1067: EXCEPTION
1068: WHEN FND_API.G_EXC_ERROR THEN
1069: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1070: P_MODULE => l_module
1071: ,P_API_NAME => L_API_NAME
1072: ,P_PKG_NAME => G_PKG_NAME

Line 1079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1075: ,X_MSG_COUNT => X_MSG_COUNT
1076: ,X_MSG_DATA => X_MSG_DATA
1077: ,X_RETURN_STATUS => X_RETURN_STATUS);
1078:
1079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1080: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1081: P_MODULE => l_module
1082: ,P_API_NAME => L_API_NAME
1083: ,P_PKG_NAME => G_PKG_NAME