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.IBY_DISBURSEMENT_SETUP_PUB dependencies on FND_API

Line 96: x_return_status := FND_API.G_RET_STS_SUCCESS;

92: END IF;
93:
94: END IF;
95:
96: x_return_status := FND_API.G_RET_STS_SUCCESS;
97:
98: insert into IBY_EXTERNAL_PAYEES_ALL (
99: EXT_PAYEE_ID,
100: PAYEE_PARTY_ID,

Line 175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

171: when others then
172: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
173: print_debuginfo(l_module_name, 'Exception while insertion into iby_external_payees_all. ');
174: END IF;
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176:
177: end insert_payee_row;
178:
179: FUNCTION Exists_Instr(p_instr IN IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type) RETURN BOOLEAN

Line 244: IF (p_val_level = FND_API.G_VALID_LEVEL_FULL) THEN

240: THEN
241: RETURN G_RC_INVALID_PAYEE;
242: END IF;
243:
244: IF (p_val_level = FND_API.G_VALID_LEVEL_FULL) THEN
245: IF (NOT iby_utility_pvt.validate_party_id(p_payee.Party_Id)) THEN
246: RETURN G_RC_INVALID_PAYEE;
247: END IF;
248: END IF;

Line 430: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

426: -- End of comments
427:
428: PROCEDURE Create_External_Payee (
429: p_api_version IN NUMBER,
430: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
431: p_ext_payee_tab IN External_Payee_Tab_Type,
432: x_return_status OUT NOCOPY VARCHAR2,
433: x_msg_count OUT NOCOPY NUMBER,
434: x_msg_data OUT NOCOPY VARCHAR2,

Line 485: IF NOT FND_API.Compatible_API_Call(l_api_version,

481: print_debuginfo(l_module_name, 'ENTER');
482:
483: END IF;
484: -- Standard call to check for call compatibility.
485: IF NOT FND_API.Compatible_API_Call(l_api_version,
486: p_api_version,
487: l_api_name,
488: G_PKG_NAME) THEN
489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

485: IF NOT FND_API.Compatible_API_Call(l_api_version,
486: p_api_version,
487: l_api_name,
488: G_PKG_NAME) THEN
489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
490: END IF;
491:
492: -- Initialize message list if p_init_msg_list is set to TRUE.
493: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 493: IF FND_API.to_Boolean(p_init_msg_list) THEN

489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
490: END IF;
491:
492: -- Initialize message list if p_init_msg_list is set to TRUE.
493: IF FND_API.to_Boolean(p_init_msg_list) THEN
494: FND_MSG_PUB.initialize;
495: END IF;
496:
497: -- Initialize API return status to success

Line 498: x_return_status := FND_API.G_RET_STS_SUCCESS;

494: FND_MSG_PUB.initialize;
495: END IF;
496:
497: -- Initialize API return status to success
498: x_return_status := FND_API.G_RET_STS_SUCCESS;
499:
500: IF p_ext_payee_tab.COUNT > 0 THEN
501: counter := p_ext_payee_tab.FIRST;
502:

Line 522: x_return_status := FND_API.G_RET_STS_ERROR;

518: l_ext_payee_id_rec.Ext_Payee_ID := -1;
519: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';
520: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;
521:
522: x_return_status := FND_API.G_RET_STS_ERROR;
523: -- RAISE FND_API.G_EXC_ERROR;
524: ELSIF (p_ext_payee_tab(counter).Payment_Function IS NULL) THEN
525: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
526: print_debuginfo(l_module_name,'Payment function is null.');

Line 523: -- RAISE FND_API.G_EXC_ERROR;

519: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';
520: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;
521:
522: x_return_status := FND_API.G_RET_STS_ERROR;
523: -- RAISE FND_API.G_EXC_ERROR;
524: ELSIF (p_ext_payee_tab(counter).Payment_Function IS NULL) THEN
525: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
526: print_debuginfo(l_module_name,'Payment function is null.');
527: END IF;

Line 537: x_return_status := FND_API.G_RET_STS_ERROR;

533: l_ext_payee_id_rec.Ext_Payee_ID := -1;
534: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';
535: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;
536:
537: x_return_status := FND_API.G_RET_STS_ERROR;
538: -- RAISE FND_API.G_EXC_ERROR;
539: -- orgid is required if supplier site id passed
540: ELSIF ((p_ext_payee_tab(counter).Payer_ORG_ID IS NULL) and
541: (p_ext_payee_tab(counter).Supplier_Site_Id IS NOT NULL)) THEN

Line 538: -- RAISE FND_API.G_EXC_ERROR;

534: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';
535: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;
536:
537: x_return_status := FND_API.G_RET_STS_ERROR;
538: -- RAISE FND_API.G_EXC_ERROR;
539: -- orgid is required if supplier site id passed
540: ELSIF ((p_ext_payee_tab(counter).Payer_ORG_ID IS NULL) and
541: (p_ext_payee_tab(counter).Supplier_Site_Id IS NOT NULL)) THEN
542: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 553: x_return_status := FND_API.G_RET_STS_ERROR;

549:
550: l_ext_payee_id_rec.Ext_Payee_ID := -1;
551: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';
552: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;
553: x_return_status := FND_API.G_RET_STS_ERROR;
554:
555: ELSIF ((p_ext_payee_tab(counter).Payer_ORG_ID IS NOT NULL) and
556: (p_ext_payee_tab(counter).Payer_Org_Type IS NULL)) THEN
557: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 568: x_return_status := FND_API.G_RET_STS_ERROR;

564:
565: l_ext_payee_id_rec.Ext_Payee_ID := -1;
566: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';
567: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;
568: x_return_status := FND_API.G_RET_STS_ERROR;
569:
570: ELSIF ((p_ext_payee_tab(counter).Payer_Org_Type IS NOT NULL) and
571: (p_ext_payee_tab(counter).Payer_ORG_ID IS NULL)) THEN
572: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 583: x_return_status := FND_API.G_RET_STS_ERROR;

579:
580: l_ext_payee_id_rec.Ext_Payee_ID := -1;
581: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';
582: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;
583: x_return_status := FND_API.G_RET_STS_ERROR;
584: -- Payment_Function
585: ELSIF (((p_ext_payee_tab(counter).Payer_Org_Type IS NOT NULL) or
586: (p_ext_payee_tab(counter).Payer_ORG_ID IS NOT NULL)) and
587: (p_ext_payee_tab(counter).Supplier_Site_Id IS NULL and

Line 601: x_return_status := FND_API.G_RET_STS_ERROR;

597:
598: l_ext_payee_id_rec.Ext_Payee_ID := -1;
599: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';
600: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;
601: x_return_status := FND_API.G_RET_STS_ERROR;
602:
603: /* Bug: 9139631
604: Description: This will no longer be considered as an error.
605: If the value is passed as null , then we derieve the value from

Line 620: x_return_status := FND_API.G_RET_STS_ERROR;

616: l_ext_payee_id_rec.Ext_Payee_ID := -1;
617: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';
618: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;
619:
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: */ -- RAISE FND_API.G_EXC_ERROR;
622: ELSE
623: l_ext_payee_tab :=p_ext_payee_tab;
624:

Line 621: */ -- RAISE FND_API.G_EXC_ERROR;

617: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';
618: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;
619:
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: */ -- RAISE FND_API.G_EXC_ERROR;
622: ELSE
623: l_ext_payee_tab :=p_ext_payee_tab;
624:
625: -- Bug 9139631.

Line 673: IF (l_payee_crt_status = FND_API.G_RET_STS_SUCCESS) THEN

669: insert_payee_row(l_ext_payee_id,
670: l_ext_payee_tab(counter),
671: l_payee_crt_status);
672:
673: IF (l_payee_crt_status = FND_API.G_RET_STS_SUCCESS) THEN
674: l_ext_payee_id_rec.Ext_Payee_ID := l_ext_payee_id;
675: -- create the default payment method
676: IF(p_ext_payee_tab(counter).Default_Pmt_method is not NULL) THEN
677: select count(1)

Line 732: -- x_return_status := FND_API.G_RET_STS_SUCCESS;

728: FND_MESSAGE.set_name('IBY', 'IBY_DUPLICATE_EXT_PAYEE');
729: l_message := fnd_message.get;
730: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;
731:
732: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
733: END IF;
734: END IF;
735:
736: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 758: FND_MSG_PUB.Count_And_Get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

754:
755: /* Bug Number: 8752267
756: */
757: -- Standard call to get message count and if count is 1, get message info.
758: FND_MSG_PUB.Count_And_Get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
759:
760:
761: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
762: print_debuginfo(l_module_name, 'RETURN');

Line 766: WHEN FND_API.G_EXC_ERROR THEN

762: print_debuginfo(l_module_name, 'RETURN');
763:
764: END IF;
765: EXCEPTION
766: WHEN FND_API.G_EXC_ERROR THEN
767: x_return_status := FND_API.G_RET_STS_ERROR;
768:
769: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
770: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 767: x_return_status := FND_API.G_RET_STS_ERROR;

763:
764: END IF;
765: EXCEPTION
766: WHEN FND_API.G_EXC_ERROR THEN
767: x_return_status := FND_API.G_RET_STS_ERROR;
768:
769: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
770: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
771: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');

Line 775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

771: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
772: print_debuginfo(l_module_name,'SQLerr is :'
773: || substr(SQLERRM, 1, 150));
774: END IF;
775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
777:
778: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
779: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

772: print_debuginfo(l_module_name,'SQLerr is :'
773: || substr(SQLERRM, 1, 150));
774: END IF;
775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
777:
778: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
779: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
780: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');

Line 785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

781: print_debuginfo(l_module_name,'SQLerr is :'
782: || substr(SQLERRM, 1, 150));
783: END IF;
784: WHEN OTHERS THEN
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
786:
787: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
788: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
789: END IF;

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

817: -- End of comments
818:
819: PROCEDURE Set_Payee_Instr_Assignment (
820: p_api_version IN NUMBER,
821: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
822: p_commit IN VARCHAR2 := FND_API.G_TRUE,
823: x_return_status OUT NOCOPY VARCHAR2,
824: x_msg_count OUT NOCOPY NUMBER,
825: x_msg_data OUT NOCOPY VARCHAR2,

Line 822: p_commit IN VARCHAR2 := FND_API.G_TRUE,

818:
819: PROCEDURE Set_Payee_Instr_Assignment (
820: p_api_version IN NUMBER,
821: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
822: p_commit IN VARCHAR2 := FND_API.G_TRUE,
823: x_return_status OUT NOCOPY VARCHAR2,
824: x_msg_count OUT NOCOPY NUMBER,
825: x_msg_data OUT NOCOPY VARCHAR2,
826: p_payee IN PayeeContext_rec_type,

Line 885: IF NOT FND_API.Compatible_API_Call (l_api_version,

881: IF (c_instr_assignment%ISOPEN) THEN
882: CLOSE c_instr_assignment;
883: END IF;
884:
885: IF NOT FND_API.Compatible_API_Call (l_api_version,
886: p_api_version,
887: l_module,
888: G_PKG_NAME)
889: THEN

Line 895: RAISE FND_API.G_EXC_ERROR;

891: debug_level => FND_LOG.LEVEL_ERROR,
892: module => G_DEBUG_MODULE || l_module);
893: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
894: FND_MSG_PUB.Add;
895: RAISE FND_API.G_EXC_ERROR;
896: END IF;
897:
898: IF FND_API.to_Boolean( p_init_msg_list ) THEN
899: FND_MSG_PUB.initialize;

Line 898: IF FND_API.to_Boolean( p_init_msg_list ) THEN

894: FND_MSG_PUB.Add;
895: RAISE FND_API.G_EXC_ERROR;
896: END IF;
897:
898: IF FND_API.to_Boolean( p_init_msg_list ) THEN
899: FND_MSG_PUB.initialize;
900: END IF;
901: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
902:

Line 921: Get_Payee_Id(p_payee, FND_API.G_VALID_LEVEL_FULL,l_payee_level, l_payee_id);

917: RETURN;
918: END IF;
919: END IF;
920:
921: Get_Payee_Id(p_payee, FND_API.G_VALID_LEVEL_FULL,l_payee_level, l_payee_id);
922:
923: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
924: print_debuginfo(l_module, 'After Get_Payee_Id');
925: print_debuginfo(l_module, 'Payee level is ' || l_payee_level);

Line 961: IF (l_payee_crt_status <> FND_API.G_RET_STS_SUCCESS) THEN

957: print_debuginfo(l_module, 'After inserting a default payee row.');
958:
959:
960: END IF;
961: IF (l_payee_crt_status <> FND_API.G_RET_STS_SUCCESS) THEN
962: x_response.Result_Code := G_RC_INVALID_PAYEE;
963: RETURN;
964: END IF;
965: END IF;

Line 1113: IF FND_API.To_Boolean(p_commit) THEN

1109: raise_biz_event(l_instr_id, l_payee_id, x_assign_id);
1110: END IF;
1111: */
1112:
1113: IF FND_API.To_Boolean(p_commit) THEN
1114: COMMIT;
1115: END IF;
1116:
1117: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1131: WHEN FND_API.G_EXC_ERROR THEN

1127:
1128: END IF;
1129: EXCEPTION
1130:
1131: WHEN FND_API.G_EXC_ERROR THEN
1132: ROLLBACK TO Set_Payee_Instr_Assignment;
1133: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1134: debug_level => FND_LOG.LEVEL_ERROR,
1135: module => G_DEBUG_MODULE || l_module);

Line 1136: x_return_status := FND_API.G_RET_STS_ERROR ;

1132: ROLLBACK TO Set_Payee_Instr_Assignment;
1133: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1134: debug_level => FND_LOG.LEVEL_ERROR,
1135: module => G_DEBUG_MODULE || l_module);
1136: x_return_status := FND_API.G_RET_STS_ERROR ;
1137: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1138: p_data => x_msg_data
1139: );
1140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1136: x_return_status := FND_API.G_RET_STS_ERROR ;
1137: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1138: p_data => x_msg_data
1139: );
1140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1141: ROLLBACK TO Set_Payee_Instr_Assignment;
1142: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1143: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1144: module => G_DEBUG_MODULE || l_module);

Line 1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1141: ROLLBACK TO Set_Payee_Instr_Assignment;
1142: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1143: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1144: module => G_DEBUG_MODULE || l_module);
1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1146: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1147: p_data => x_msg_data
1148: );
1149: WHEN OTHERS THEN

Line 1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1150: ROLLBACK TO Set_Payee_Instr_Assignment;
1151: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1152: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1153: module => G_DEBUG_MODULE || l_module);
1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1155: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1156: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
1157: END IF;
1158:

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

1182: -- End of comments
1183:
1184: PROCEDURE Get_Payee_Instr_Assignments (
1185: p_api_version IN NUMBER,
1186: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1187: x_return_status OUT NOCOPY VARCHAR2,
1188: x_msg_count OUT NOCOPY NUMBER,
1189: x_msg_data OUT NOCOPY VARCHAR2,
1190: p_payee IN PayeeContext_rec_type,

Line 1223: IF NOT FND_API.Compatible_API_Call (l_api_version,

1219: IF (c_instr_assignments%ISOPEN) THEN
1220: CLOSE c_instr_assignments;
1221: END IF;
1222:
1223: IF NOT FND_API.Compatible_API_Call (l_api_version,
1224: p_api_version,
1225: l_module,
1226: G_PKG_NAME)
1227: THEN

Line 1233: RAISE FND_API.G_EXC_ERROR;

1229: debug_level => FND_LOG.LEVEL_ERROR,
1230: module => G_DEBUG_MODULE || l_module);
1231: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1232: FND_MSG_PUB.Add;
1233: RAISE FND_API.G_EXC_ERROR;
1234: END IF;
1235:
1236: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1237: FND_MSG_PUB.initialize;

Line 1236: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1232: FND_MSG_PUB.Add;
1233: RAISE FND_API.G_EXC_ERROR;
1234: END IF;
1235:
1236: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1237: FND_MSG_PUB.initialize;
1238: END IF;
1239: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1240:

Line 1241: Get_Payee_Id(p_payee,FND_API.G_VALID_LEVEL_FULL,l_payee_level,l_payee_id);

1237: FND_MSG_PUB.initialize;
1238: END IF;
1239: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1240:
1241: Get_Payee_Id(p_payee,FND_API.G_VALID_LEVEL_FULL,l_payee_level,l_payee_id);
1242:
1243: IF (l_payee_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
1244: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;
1245: ELSE

Line 1271: WHEN FND_API.G_EXC_ERROR THEN

1267: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1268:
1269: EXCEPTION
1270:
1271: WHEN FND_API.G_EXC_ERROR THEN
1272:
1273: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1274: debug_level => FND_LOG.LEVEL_ERROR,
1275: module => G_DEBUG_MODULE || l_module);

Line 1276: x_return_status := FND_API.G_RET_STS_ERROR ;

1272:
1273: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1274: debug_level => FND_LOG.LEVEL_ERROR,
1275: module => G_DEBUG_MODULE || l_module);
1276: x_return_status := FND_API.G_RET_STS_ERROR ;
1277: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1278: p_data => x_msg_data
1279: );
1280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1276: x_return_status := FND_API.G_RET_STS_ERROR ;
1277: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1278: p_data => x_msg_data
1279: );
1280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1281:
1282: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1283: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1284: module => G_DEBUG_MODULE || l_module);

Line 1285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1281:
1282: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1283: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1284: module => G_DEBUG_MODULE || l_module);
1285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1286: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1287: p_data => x_msg_data
1288: );
1289: WHEN OTHERS THEN

Line 1294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1290:
1291: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1292: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1293: module => G_DEBUG_MODULE || l_module);
1294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1295: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1296: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
1297: END IF;
1298:

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

1322: -- End of comments
1323:
1324: PROCEDURE Get_Payee_All_Instruments (
1325: p_api_version IN NUMBER,
1326: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1327: x_return_status OUT NOCOPY VARCHAR2,
1328: x_msg_count OUT NOCOPY NUMBER,
1329: x_msg_data OUT NOCOPY VARCHAR2,
1330: p_party_id IN NUMBER,

Line 1356: IF NOT FND_API.Compatible_API_Call (l_api_version,

1352: IF (c_instr_assignments%ISOPEN) THEN
1353: CLOSE c_instr_assignments;
1354: END IF;
1355:
1356: IF NOT FND_API.Compatible_API_Call (l_api_version,
1357: p_api_version,
1358: l_module,
1359: G_PKG_NAME)
1360: THEN

Line 1366: RAISE FND_API.G_EXC_ERROR;

1362: debug_level => FND_LOG.LEVEL_ERROR,
1363: module => G_DEBUG_MODULE || l_module);
1364: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1365: FND_MSG_PUB.Add;
1366: RAISE FND_API.G_EXC_ERROR;
1367: END IF;
1368:
1369: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1370: FND_MSG_PUB.initialize;

Line 1369: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1365: FND_MSG_PUB.Add;
1366: RAISE FND_API.G_EXC_ERROR;
1367: END IF;
1368:
1369: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1370: FND_MSG_PUB.initialize;
1371: END IF;
1372: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1373:

Line 1389: WHEN FND_API.G_EXC_ERROR THEN

1385: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1386:
1387: EXCEPTION
1388:
1389: WHEN FND_API.G_EXC_ERROR THEN
1390:
1391: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1392: debug_level => FND_LOG.LEVEL_ERROR,
1393: module => G_DEBUG_MODULE || l_module);

Line 1394: x_return_status := FND_API.G_RET_STS_ERROR ;

1390:
1391: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1392: debug_level => FND_LOG.LEVEL_ERROR,
1393: module => G_DEBUG_MODULE || l_module);
1394: x_return_status := FND_API.G_RET_STS_ERROR ;
1395: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1396: p_data => x_msg_data
1397: );
1398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1394: x_return_status := FND_API.G_RET_STS_ERROR ;
1395: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1396: p_data => x_msg_data
1397: );
1398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1399:
1400: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1401: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1402: module => G_DEBUG_MODULE || l_module);

Line 1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1399:
1400: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1401: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1402: module => G_DEBUG_MODULE || l_module);
1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1404: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1405: p_data => x_msg_data
1406: );
1407: WHEN OTHERS THEN

Line 1412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1408:
1409: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1410: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1411: module => G_DEBUG_MODULE || l_module);
1412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1414: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
1415: END IF;
1416:

Line 1476: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

1472: -- Initial version : 1.0
1473:
1474: PROCEDURE Validate_External_Payee (
1475: p_api_version IN NUMBER,
1476: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
1477: p_ext_payee_rec IN External_Payee_Rec_Type,
1478: x_return_status OUT NOCOPY VARCHAR2,
1479: x_msg_count OUT NOCOPY NUMBER,
1480: x_msg_data OUT NOCOPY VARCHAR2

Line 1545: IF NOT FND_API.Compatible_API_Call(l_api_version,

1541:
1542: SAVEPOINT Validate_External_Payee_pub;
1543:
1544: -- Standard call to check for call compatibility.
1545: IF NOT FND_API.Compatible_API_Call(l_api_version,
1546: p_api_version,
1547: l_api_name,
1548: G_PKG_NAME) THEN
1549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1545: IF NOT FND_API.Compatible_API_Call(l_api_version,
1546: p_api_version,
1547: l_api_name,
1548: G_PKG_NAME) THEN
1549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1550: END IF;
1551:
1552: -- Initialize message list if p_init_msg_list is set to TRUE.
1553: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1553: IF FND_API.to_Boolean(p_init_msg_list) THEN

1549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1550: END IF;
1551:
1552: -- Initialize message list if p_init_msg_list is set to TRUE.
1553: IF FND_API.to_Boolean(p_init_msg_list) THEN
1554: FND_MSG_PUB.initialize;
1555: END IF;
1556:
1557: -- Initialize API return status to success

Line 1558: x_return_status := FND_API.G_RET_STS_SUCCESS;

1554: FND_MSG_PUB.initialize;
1555: END IF;
1556:
1557: -- Initialize API return status to success
1558: x_return_status := FND_API.G_RET_STS_SUCCESS;
1559:
1560: -- Start of API body
1561: IF (p_ext_payee_rec.Payee_Party_Id IS NOT NULL) THEN
1562: IF (p_ext_payee_rec.Payee_Party_Site_Id IS NOT NULL) THEN

Line 1726: x_return_status := FND_API.G_RET_STS_ERROR;

1722: IF (NOT l_valid) THEN
1723: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1724: print_debuginfo(l_module_name, 'Returning Error Status');
1725: END IF;
1726: x_return_status := FND_API.G_RET_STS_ERROR;
1727: END IF;
1728:
1729: -- End of API body
1730:

Line 1732: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1728:
1729: -- End of API body
1730:
1731: -- get message count and if count is 1, get message info.
1732: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1733: p_count => x_msg_count,
1734: p_data => x_msg_data);
1735:
1736: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1740: WHEN fnd_api.g_exc_error THEN

1736: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1737: print_debuginfo(l_module_name, 'Exit');
1738: END IF;
1739: EXCEPTION
1740: WHEN fnd_api.g_exc_error THEN
1741: ROLLBACK TO Validate_External_Payee_pub;
1742: x_return_status := fnd_api.g_ret_sts_error;
1743: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1744: p_count => x_msg_count,

Line 1742: x_return_status := fnd_api.g_ret_sts_error;

1738: END IF;
1739: EXCEPTION
1740: WHEN fnd_api.g_exc_error THEN
1741: ROLLBACK TO Validate_External_Payee_pub;
1742: x_return_status := fnd_api.g_ret_sts_error;
1743: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1744: p_count => x_msg_count,
1745: p_data => x_msg_data);
1746:

Line 1743: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1739: EXCEPTION
1740: WHEN fnd_api.g_exc_error THEN
1741: ROLLBACK TO Validate_External_Payee_pub;
1742: x_return_status := fnd_api.g_ret_sts_error;
1743: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1744: p_count => x_msg_count,
1745: p_data => x_msg_data);
1746:
1747:

Line 1748: WHEN fnd_api.g_exc_unexpected_error THEN

1744: p_count => x_msg_count,
1745: p_data => x_msg_data);
1746:
1747:
1748: WHEN fnd_api.g_exc_unexpected_error THEN
1749: ROLLBACK TO Validate_External_Payee_pub;
1750: x_return_status := fnd_api.g_ret_sts_unexp_error;
1751: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1752: p_count => x_msg_count,

Line 1750: x_return_status := fnd_api.g_ret_sts_unexp_error;

1746:
1747:
1748: WHEN fnd_api.g_exc_unexpected_error THEN
1749: ROLLBACK TO Validate_External_Payee_pub;
1750: x_return_status := fnd_api.g_ret_sts_unexp_error;
1751: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1752: p_count => x_msg_count,
1753: p_data => x_msg_data);
1754:

Line 1751: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1747:
1748: WHEN fnd_api.g_exc_unexpected_error THEN
1749: ROLLBACK TO Validate_External_Payee_pub;
1750: x_return_status := fnd_api.g_ret_sts_unexp_error;
1751: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1752: p_count => x_msg_count,
1753: p_data => x_msg_data);
1754:
1755:

Line 1758: x_return_status := fnd_api.g_ret_sts_unexp_error;

1754:
1755:
1756: WHEN OTHERS THEN
1757: ROLLBACK TO Validate_External_Payee_pub;
1758: x_return_status := fnd_api.g_ret_sts_unexp_error;
1759: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
1760: fnd_message.set_token('ERROR',SQLERRM);
1761: fnd_msg_pub.add;
1762: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 1762: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1758: x_return_status := fnd_api.g_ret_sts_unexp_error;
1759: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
1760: fnd_message.set_token('ERROR',SQLERRM);
1761: fnd_msg_pub.add;
1762: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1763: p_count => x_msg_count,
1764: p_data => x_msg_data);
1765:
1766:

Line 1782: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

1778: -- Initial version : 1.0
1779:
1780: PROCEDURE Create_Temp_Ext_Bank_Acct (
1781: p_api_version IN NUMBER,
1782: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
1783: x_return_status OUT NOCOPY VARCHAR2,
1784: x_msg_count OUT NOCOPY NUMBER,
1785: x_msg_data OUT NOCOPY VARCHAR2,
1786: p_temp_ext_acct_id IN NUMBER,

Line 1877: IF NOT FND_API.Compatible_API_Call(l_api_version,

1873:
1874: SAVEPOINT Create_Temp_Ext_Bank_Acct_pub;
1875:
1876: -- Standard call to check for call compatibility.
1877: IF NOT FND_API.Compatible_API_Call(l_api_version,
1878: p_api_version,
1879: l_api_name,
1880: G_PKG_NAME) THEN
1881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1877: IF NOT FND_API.Compatible_API_Call(l_api_version,
1878: p_api_version,
1879: l_api_name,
1880: G_PKG_NAME) THEN
1881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1882: END IF;
1883:
1884: -- Initialize message list if p_init_msg_list is set to TRUE.
1885: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1885: IF FND_API.to_Boolean(p_init_msg_list) THEN

1881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1882: END IF;
1883:
1884: -- Initialize message list if p_init_msg_list is set to TRUE.
1885: IF FND_API.to_Boolean(p_init_msg_list) THEN
1886: FND_MSG_PUB.initialize;
1887: END IF;
1888:
1889: -- Initialize API return status to success

Line 1890: x_return_status := FND_API.G_RET_STS_SUCCESS;

1886: FND_MSG_PUB.initialize;
1887: END IF;
1888:
1889: -- Initialize API return status to success
1890: x_return_status := FND_API.G_RET_STS_SUCCESS;
1891:
1892: -- Start of API body
1893: OPEN iby_ext_bank_csr(p_temp_ext_acct_id);
1894: FETCH iby_ext_bank_csr INTO temp_ext_bank_acct_rec;

Line 1950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1946:
1947:
1948:
1949: IF (x_bank_acc_id IS NULL) THEN
1950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1951: END IF;
1952: -- End of API body
1953:
1954: -- get message count and if count is 1, get message info.

Line 1955: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1951: END IF;
1952: -- End of API body
1953:
1954: -- get message count and if count is 1, get message info.
1955: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1956: p_count => x_msg_count,
1957: p_data => x_msg_data);
1958:
1959:

Line 1961: WHEN fnd_api.g_exc_error THEN

1957: p_data => x_msg_data);
1958:
1959:
1960: EXCEPTION
1961: WHEN fnd_api.g_exc_error THEN
1962: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1963: x_return_status := fnd_api.g_ret_sts_error;
1964: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1965: p_count => x_msg_count,

Line 1963: x_return_status := fnd_api.g_ret_sts_error;

1959:
1960: EXCEPTION
1961: WHEN fnd_api.g_exc_error THEN
1962: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1963: x_return_status := fnd_api.g_ret_sts_error;
1964: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1965: p_count => x_msg_count,
1966: p_data => x_msg_data);
1967:

Line 1964: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1960: EXCEPTION
1961: WHEN fnd_api.g_exc_error THEN
1962: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1963: x_return_status := fnd_api.g_ret_sts_error;
1964: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1965: p_count => x_msg_count,
1966: p_data => x_msg_data);
1967:
1968:

Line 1969: WHEN fnd_api.g_exc_unexpected_error THEN

1965: p_count => x_msg_count,
1966: p_data => x_msg_data);
1967:
1968:
1969: WHEN fnd_api.g_exc_unexpected_error THEN
1970: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1971: x_return_status := fnd_api.g_ret_sts_unexp_error;
1972: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1973: p_count => x_msg_count,

Line 1971: x_return_status := fnd_api.g_ret_sts_unexp_error;

1967:
1968:
1969: WHEN fnd_api.g_exc_unexpected_error THEN
1970: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1971: x_return_status := fnd_api.g_ret_sts_unexp_error;
1972: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1973: p_count => x_msg_count,
1974: p_data => x_msg_data);
1975:

Line 1972: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1968:
1969: WHEN fnd_api.g_exc_unexpected_error THEN
1970: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1971: x_return_status := fnd_api.g_ret_sts_unexp_error;
1972: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1973: p_count => x_msg_count,
1974: p_data => x_msg_data);
1975:
1976:

Line 1979: x_return_status := fnd_api.g_ret_sts_unexp_error;

1975:
1976:
1977: WHEN OTHERS THEN
1978: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1979: x_return_status := fnd_api.g_ret_sts_unexp_error;
1980: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
1981: fnd_message.set_token('ERROR',SQLERRM);
1982: fnd_msg_pub.add;
1983: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 1983: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1979: x_return_status := fnd_api.g_ret_sts_unexp_error;
1980: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
1981: fnd_message.set_token('ERROR',SQLERRM);
1982: fnd_msg_pub.add;
1983: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1984: p_count => x_msg_count,
1985: p_data => x_msg_data);
1986:
1987: END Create_Temp_Ext_Bank_Acct;

Line 2002: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

1998: -- Initial version : 1.0
1999:
2000: PROCEDURE Create_Temp_Ext_Bank_Acct (
2001: p_api_version IN NUMBER,
2002: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2003: x_return_status OUT NOCOPY VARCHAR2,
2004: x_msg_count OUT NOCOPY NUMBER,
2005: x_msg_data OUT NOCOPY VARCHAR2,
2006: p_temp_ext_acct_id IN NUMBER,

Line 2121: IF NOT FND_API.Compatible_API_Call(l_api_version,

2117: END IF;
2118: SAVEPOINT Create_Temp_Ext_Bank_Acct_pub;
2119:
2120: -- Standard call to check for call compatibility.
2121: IF NOT FND_API.Compatible_API_Call(l_api_version,
2122: p_api_version,
2123: l_api_name,
2124: G_PKG_NAME) THEN
2125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2121: IF NOT FND_API.Compatible_API_Call(l_api_version,
2122: p_api_version,
2123: l_api_name,
2124: G_PKG_NAME) THEN
2125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2126: END IF;
2127:
2128: -- Initialize message list if p_init_msg_list is set to TRUE.
2129: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2129: IF FND_API.to_Boolean(p_init_msg_list) THEN

2125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2126: END IF;
2127:
2128: -- Initialize message list if p_init_msg_list is set to TRUE.
2129: IF FND_API.to_Boolean(p_init_msg_list) THEN
2130: FND_MSG_PUB.initialize;
2131: END IF;
2132:
2133: -- Initialize API return status to success

Line 2134: x_return_status := FND_API.G_RET_STS_SUCCESS;

2130: FND_MSG_PUB.initialize;
2131: END IF;
2132:
2133: -- Initialize API return status to success
2134: x_return_status := FND_API.G_RET_STS_SUCCESS;
2135:
2136: -- Start of API body
2137: OPEN iby_ext_bank_csr(p_temp_ext_acct_id);
2138: FETCH iby_ext_bank_csr INTO temp_ext_bank_acct_rec;

Line 2200: IF (x_return_status = FND_API.G_RET_STS_SUCCESS and l_dup_acct_id is null) THEN

2196: print_debuginfo(l_module_name, 'Account Id::'||l_dup_acct_id);
2197: END IF;
2198:
2199: /* If bank account doesn't exist in the application*/
2200: IF (x_return_status = FND_API.G_RET_STS_SUCCESS and l_dup_acct_id is null) THEN
2201:
2202:
2203: /* Calling Bank Account Validation API */
2204: IBY_DISBURSEMENT_SETUP_PUB.Validate_Temp_Ext_Bank_Acct(

Line 2206: p_init_msg_list => FND_API.G_FALSE,

2202:
2203: /* Calling Bank Account Validation API */
2204: IBY_DISBURSEMENT_SETUP_PUB.Validate_Temp_Ext_Bank_Acct(
2205: p_api_version => 1.0,
2206: p_init_msg_list => FND_API.G_FALSE,
2207: x_return_status => x_return_status,
2208: x_msg_count => x_msg_count,
2209: x_msg_data => x_msg_data,
2210: p_temp_ext_acct_id => p_temp_ext_acct_id);

Line 2217: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2213: print_debuginfo(l_module_name, 'After the call to Validate_Temp_Ext_Bank_Acct');
2214: print_debuginfo(l_module_name, 'Return Status::'||x_return_status);
2215: END IF;
2216:
2217: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2218:
2219: -- Calling to create external bank account
2220: IBY_EXT_BANKACCT_PUB.create_ext_bank_acct(
2221: p_api_version => 1.0,

Line 2243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2239: print_debuginfo(l_module_name, 'Return Status::'||x_return_status);
2240: END IF;
2241:
2242: IF (x_bank_acc_id IS NULL) THEN
2243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2244: END IF;
2245: ELSE
2246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2247: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_BANK_ACCT_INFO');

Line 2246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2242: IF (x_bank_acc_id IS NULL) THEN
2243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2244: END IF;
2245: ELSE
2246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2247: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_BANK_ACCT_INFO');
2248: FND_MSG_PUB.ADD;
2249: print_debuginfo(l_module_name, 'Bank Account Validation Failed');
2250: END IF;

Line 2254: x_return_status := FND_API.G_RET_STS_SUCCESS;

2250: END IF;
2251:
2252: /* If Bank account is already existing in the application*/
2253: ELSIF (l_dup_acct_id is not null) THEN
2254: x_return_status := FND_API.G_RET_STS_SUCCESS;
2255:
2256: /* API call to find out whether this party is owner of bank account*/
2257: IBY_EXT_BANKACCT_PUB.check_bank_acct_owner (
2258: p_api_version => 1.0,

Line 2273: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2269: print_debuginfo(l_module_name, 'X_RETURN_STATUS::'||x_return_status);
2270: END IF;
2271:
2272: /* If party is not owner of that bank account*/
2273: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2274:
2275: /* Add Party Id as Joint Account Owner of the Bank Account*/
2276: IBY_EXT_BANKACCT_PUB.add_joint_account_owner (
2277: p_api_version => 1.0,

Line 2325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2321: print_debuginfo(l_module_name, 'X_RETURN_STATUS::'||x_return_status);
2322: END IF;
2323:
2324: /*ELSE
2325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2326: FND_MESSAGE.SET_NAME('IBY','IBY_IMP_SUP_NOT_OWN');
2327: FND_MSG_PUB.ADD;
2328: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2329: print_debuginfo(l_module_name, 'Party is not owner of the account');

Line 2334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2330: END IF;
2331:
2332: END IF;*/
2333: ELSE
2334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2335: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2336: print_debuginfo(l_module_name, 'check_ext_acct_exist returned inconsistent data');
2337: END IF;
2338: END IF;

Line 2340: IF( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2336: print_debuginfo(l_module_name, 'check_ext_acct_exist returned inconsistent data');
2337: END IF;
2338: END IF;
2339:
2340: IF( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2341:
2342: -- Bug# 7451534 begin
2343:
2344: intermediate_bank_acct_rec.bank_account_id := x_bank_acc_id;

Line 2373: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2369: -- End of API body
2370: END IF;
2371:
2372: -- get message count and if count is 1, get message info.
2373: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2374: p_count => x_msg_count,
2375: p_data => x_msg_data);
2376:
2377: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2381: WHEN fnd_api.g_exc_error THEN

2377: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2378: print_debuginfo(l_module_name, 'EXIT');
2379: END IF;
2380: EXCEPTION
2381: WHEN fnd_api.g_exc_error THEN
2382: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
2383: x_return_status := fnd_api.g_ret_sts_error;
2384: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2385: p_count => x_msg_count,

Line 2383: x_return_status := fnd_api.g_ret_sts_error;

2379: END IF;
2380: EXCEPTION
2381: WHEN fnd_api.g_exc_error THEN
2382: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
2383: x_return_status := fnd_api.g_ret_sts_error;
2384: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2385: p_count => x_msg_count,
2386: p_data => x_msg_data);
2387:

Line 2384: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2380: EXCEPTION
2381: WHEN fnd_api.g_exc_error THEN
2382: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
2383: x_return_status := fnd_api.g_ret_sts_error;
2384: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2385: p_count => x_msg_count,
2386: p_data => x_msg_data);
2387:
2388:

Line 2389: WHEN fnd_api.g_exc_unexpected_error THEN

2385: p_count => x_msg_count,
2386: p_data => x_msg_data);
2387:
2388:
2389: WHEN fnd_api.g_exc_unexpected_error THEN
2390: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
2391: x_return_status := fnd_api.g_ret_sts_unexp_error;
2392: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2393: p_count => x_msg_count,

Line 2391: x_return_status := fnd_api.g_ret_sts_unexp_error;

2387:
2388:
2389: WHEN fnd_api.g_exc_unexpected_error THEN
2390: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
2391: x_return_status := fnd_api.g_ret_sts_unexp_error;
2392: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2393: p_count => x_msg_count,
2394: p_data => x_msg_data);
2395:

Line 2392: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2388:
2389: WHEN fnd_api.g_exc_unexpected_error THEN
2390: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
2391: x_return_status := fnd_api.g_ret_sts_unexp_error;
2392: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2393: p_count => x_msg_count,
2394: p_data => x_msg_data);
2395:
2396:

Line 2399: x_return_status := fnd_api.g_ret_sts_unexp_error;

2395:
2396:
2397: WHEN OTHERS THEN
2398: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
2399: x_return_status := fnd_api.g_ret_sts_unexp_error;
2400: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
2401: fnd_message.set_token('ERROR',SQLERRM);
2402: fnd_msg_pub.add;
2403: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 2403: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2399: x_return_status := fnd_api.g_ret_sts_unexp_error;
2400: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
2401: fnd_message.set_token('ERROR',SQLERRM);
2402: fnd_msg_pub.add;
2403: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2404: p_count => x_msg_count,
2405: p_data => x_msg_data);
2406:
2407: END Create_Temp_Ext_Bank_Acct;

Line 2426: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

2422: -- Initial version : 1.0
2423:
2424: PROCEDURE Validate_Temp_Ext_Bank_Acct (
2425: p_api_version IN NUMBER,
2426: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2427: x_return_status OUT NOCOPY VARCHAR2,
2428: x_msg_count OUT NOCOPY NUMBER,
2429: x_msg_data OUT NOCOPY VARCHAR2,
2430: p_temp_ext_acct_id IN NUMBER

Line 2552: IF NOT FND_API.Compatible_API_Call(l_api_version,

2548:
2549: SAVEPOINT Val_Temp_Ext_Bank_Acct_pub;
2550:
2551: -- Standard call to check for call compatibility.
2552: IF NOT FND_API.Compatible_API_Call(l_api_version,
2553: p_api_version,
2554: l_api_name,
2555: G_PKG_NAME) THEN
2556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2552: IF NOT FND_API.Compatible_API_Call(l_api_version,
2553: p_api_version,
2554: l_api_name,
2555: G_PKG_NAME) THEN
2556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2557: END IF;
2558:
2559: -- Initialize message list if p_init_msg_list is set to TRUE.
2560: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2560: IF FND_API.to_Boolean(p_init_msg_list) THEN

2556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2557: END IF;
2558:
2559: -- Initialize message list if p_init_msg_list is set to TRUE.
2560: IF FND_API.to_Boolean(p_init_msg_list) THEN
2561: FND_MSG_PUB.initialize;
2562: END IF;
2563:
2564: -- Initialize API return status to success

Line 2565: x_return_status := FND_API.G_RET_STS_SUCCESS;

2561: FND_MSG_PUB.initialize;
2562: END IF;
2563:
2564: -- Initialize API return status to success
2565: x_return_status := FND_API.G_RET_STS_SUCCESS;
2566:
2567: -- Start of API body
2568:
2569: OPEN ext_bank_acct_csr(p_temp_ext_acct_id);

Line 2642: p_init_msg_list => FND_API.G_TRUE,

2638:
2639: -- Call Validations
2640: IBY_EXT_BANKACCT_VALIDATIONS.iby_validate_account(
2641: p_api_version => p_api_version,
2642: p_init_msg_list => FND_API.G_TRUE,
2643: p_create_flag => FND_API.G_TRUE,
2644: p_ext_bank_rec => ext_bank_rec,
2645: p_ext_bank_branch_rec => ext_bank_branch_rec,
2646: p_ext_bank_acct_rec => ext_bank_acct_rec,

Line 2643: p_create_flag => FND_API.G_TRUE,

2639: -- Call Validations
2640: IBY_EXT_BANKACCT_VALIDATIONS.iby_validate_account(
2641: p_api_version => p_api_version,
2642: p_init_msg_list => FND_API.G_TRUE,
2643: p_create_flag => FND_API.G_TRUE,
2644: p_ext_bank_rec => ext_bank_rec,
2645: p_ext_bank_branch_rec => ext_bank_branch_rec,
2646: p_ext_bank_acct_rec => ext_bank_acct_rec,
2647: x_return_status => x_return_status,

Line 2654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2650: x_response => l_response
2651: );
2652:
2653: IF (fnd_msg_pub.count_msg > 0) THEN
2654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2655: END IF;
2656:
2657: -- End of API body
2658:

Line 2660: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2656:
2657: -- End of API body
2658:
2659: -- get message count and if count is 1, get message info.
2660: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2661: p_count => x_msg_count,
2662: p_data => x_msg_data);
2663:
2664:

Line 2666: WHEN fnd_api.g_exc_error THEN

2662: p_data => x_msg_data);
2663:
2664:
2665: EXCEPTION
2666: WHEN fnd_api.g_exc_error THEN
2667: ROLLBACK TO Val_Temp_Ext_Bank_Acct_pub;
2668: x_return_status := fnd_api.g_ret_sts_error;
2669: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2670: p_count => x_msg_count,

Line 2668: x_return_status := fnd_api.g_ret_sts_error;

2664:
2665: EXCEPTION
2666: WHEN fnd_api.g_exc_error THEN
2667: ROLLBACK TO Val_Temp_Ext_Bank_Acct_pub;
2668: x_return_status := fnd_api.g_ret_sts_error;
2669: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2670: p_count => x_msg_count,
2671: p_data => x_msg_data);
2672:

Line 2669: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2665: EXCEPTION
2666: WHEN fnd_api.g_exc_error THEN
2667: ROLLBACK TO Val_Temp_Ext_Bank_Acct_pub;
2668: x_return_status := fnd_api.g_ret_sts_error;
2669: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2670: p_count => x_msg_count,
2671: p_data => x_msg_data);
2672:
2673:

Line 2674: WHEN fnd_api.g_exc_unexpected_error THEN

2670: p_count => x_msg_count,
2671: p_data => x_msg_data);
2672:
2673:
2674: WHEN fnd_api.g_exc_unexpected_error THEN
2675: ROLLBACK TO Val_Temp_Ext_Bank_Acct_pub;
2676: x_return_status := fnd_api.g_ret_sts_unexp_error;
2677: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2678: p_count => x_msg_count,

Line 2676: x_return_status := fnd_api.g_ret_sts_unexp_error;

2672:
2673:
2674: WHEN fnd_api.g_exc_unexpected_error THEN
2675: ROLLBACK TO Val_Temp_Ext_Bank_Acct_pub;
2676: x_return_status := fnd_api.g_ret_sts_unexp_error;
2677: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2678: p_count => x_msg_count,
2679: p_data => x_msg_data);
2680:

Line 2677: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2673:
2674: WHEN fnd_api.g_exc_unexpected_error THEN
2675: ROLLBACK TO Val_Temp_Ext_Bank_Acct_pub;
2676: x_return_status := fnd_api.g_ret_sts_unexp_error;
2677: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2678: p_count => x_msg_count,
2679: p_data => x_msg_data);
2680:
2681:

Line 2684: x_return_status := fnd_api.g_ret_sts_unexp_error;

2680:
2681:
2682: WHEN OTHERS THEN
2683: ROLLBACK TO Val_Temp_Ext_Bank_Acct_pub;
2684: x_return_status := fnd_api.g_ret_sts_unexp_error;
2685: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
2686: fnd_message.set_token('ERROR',SQLERRM);
2687: fnd_msg_pub.add;
2688: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 2688: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2684: x_return_status := fnd_api.g_ret_sts_unexp_error;
2685: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
2686: fnd_message.set_token('ERROR',SQLERRM);
2687: fnd_msg_pub.add;
2688: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2689: p_count => x_msg_count,
2690: p_data => x_msg_data);
2691:
2692: END Validate_Temp_Ext_Bank_Acct;

Line 2718: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

2714: -- End of comments
2715:
2716: PROCEDURE Update_External_Payee (
2717: p_api_version IN NUMBER,
2718: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2719: p_ext_payee_tab IN External_Payee_Tab_Type,
2720: p_ext_payee_id_tab IN Ext_Payee_ID_Tab_Type,
2721: x_return_status OUT NOCOPY VARCHAR2,
2722: x_msg_count OUT NOCOPY NUMBER,

Line 2764: IF NOT FND_API.Compatible_API_Call(l_api_version,

2760: print_debuginfo(l_module_name, 'ENTER');
2761:
2762: END IF;
2763: -- Standard call to check for call compatibility.
2764: IF NOT FND_API.Compatible_API_Call(l_api_version,
2765: p_api_version,
2766: l_api_name,
2767: G_PKG_NAME) THEN
2768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2764: IF NOT FND_API.Compatible_API_Call(l_api_version,
2765: p_api_version,
2766: l_api_name,
2767: G_PKG_NAME) THEN
2768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2769: END IF;
2770:
2771: -- Initialize message list if p_init_msg_list is set to TRUE.
2772: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2772: IF FND_API.to_Boolean(p_init_msg_list) THEN

2768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2769: END IF;
2770:
2771: -- Initialize message list if p_init_msg_list is set to TRUE.
2772: IF FND_API.to_Boolean(p_init_msg_list) THEN
2773: FND_MSG_PUB.initialize;
2774: END IF;
2775:
2776: -- Initialize API return status to success

Line 2777: x_return_status := FND_API.G_RET_STS_SUCCESS;

2773: FND_MSG_PUB.initialize;
2774: END IF;
2775:
2776: -- Initialize API return status to success
2777: x_return_status := FND_API.G_RET_STS_SUCCESS;
2778:
2779: IF p_ext_payee_tab.COUNT > 0 THEN
2780: counter := p_ext_payee_tab.FIRST;
2781:

Line 2799: x_return_status := FND_API.G_RET_STS_ERROR;

2795:
2796: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2797: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2798:
2799: x_return_status := FND_API.G_RET_STS_ERROR;
2800:
2801: ELSIF p_ext_payee_tab(counter).Payee_Party_Id IS NULL THEN
2802: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2803: print_debuginfo(l_module_name,'Payee party Id is null.');

Line 2813: x_return_status := FND_API.G_RET_STS_ERROR;

2809:
2810: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2811: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2812:
2813: x_return_status := FND_API.G_RET_STS_ERROR;
2814:
2815: ELSIF (p_ext_payee_tab(counter).Payment_Function IS NULL) THEN
2816: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2817: print_debuginfo(l_module_name,'Payment function is null.');

Line 2827: x_return_status := FND_API.G_RET_STS_ERROR;

2823:
2824: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2825: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2826:
2827: x_return_status := FND_API.G_RET_STS_ERROR;
2828:
2829: -- orgid is required if supplier site id passed
2830: ELSIF ((p_ext_payee_tab(counter).Payer_ORG_ID IS NULL) and
2831: (p_ext_payee_tab(counter).Supplier_Site_Id IS NOT NULL)) THEN

Line 2868: x_return_status := FND_API.G_RET_STS_ERROR;

2864:
2865: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2866: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2867:
2868: x_return_status := FND_API.G_RET_STS_ERROR;
2869:
2870: ELSE
2871: OPEN external_payee_csr(p_ext_payee_tab(counter).Payee_Party_Id,
2872: p_ext_payee_tab(counter).Payee_Party_Site_Id,

Line 2899: x_return_status := FND_API.G_RET_STS_ERROR;

2895:
2896: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2897: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2898:
2899: x_return_status := FND_API.G_RET_STS_ERROR;
2900:
2901: ELSE
2902: -- update external payee
2903: UPDATE iby_external_payees_all

Line 3040: WHEN FND_API.G_EXC_ERROR THEN

3036: print_debuginfo(l_module_name, 'RETURN');
3037:
3038: END IF;
3039: EXCEPTION
3040: WHEN FND_API.G_EXC_ERROR THEN
3041: x_return_status := FND_API.G_RET_STS_ERROR;
3042:
3043: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3044: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3041: x_return_status := FND_API.G_RET_STS_ERROR;

3037:
3038: END IF;
3039: EXCEPTION
3040: WHEN FND_API.G_EXC_ERROR THEN
3041: x_return_status := FND_API.G_RET_STS_ERROR;
3042:
3043: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3044: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3045: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');

Line 3049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3045: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
3046: print_debuginfo(l_module_name,'SQLerr is :'|| substr(SQLERRM, 1, 150));
3047:
3048: END IF;
3049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3051:
3052: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3053: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3046: print_debuginfo(l_module_name,'SQLerr is :'|| substr(SQLERRM, 1, 150));
3047:
3048: END IF;
3049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3051:
3052: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3053: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3054: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');

Line 3059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3055: print_debuginfo(l_module_name,'SQLerr is :'|| substr(SQLERRM, 1, 150));
3056:
3057: END IF;
3058: WHEN OTHERS THEN
3059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3060:
3061: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3062: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3063: END IF;