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 34: x_return_status := FND_API.G_RET_STS_SUCCESS;

30: l_module_name VARCHAR2(100) := G_PKG_NAME || 'insert_payee_row';
31: begin
32: print_debuginfo(l_module_name, 'ENTER');
33:
34: x_return_status := FND_API.G_RET_STS_SUCCESS;
35:
36: insert into IBY_EXTERNAL_PAYEES_ALL (
37: EXT_PAYEE_ID,
38: PAYEE_PARTY_ID,

Line 106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

102:
103: exception
104: when others then
105: print_debuginfo(l_module_name, 'Exception while insertion into iby_external_payees_all. ');
106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
107:
108: end insert_payee_row;
109:
110: FUNCTION Exists_Instr(p_instr IN IBY_FNDCPT_SETUP_PUB.PmtInstrument_rec_type) RETURN BOOLEAN

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

171: THEN
172: RETURN G_RC_INVALID_PAYEE;
173: END IF;
174:
175: IF (p_val_level = FND_API.G_VALID_LEVEL_FULL) THEN
176: IF (NOT iby_utility_pvt.validate_party_id(p_payee.Party_Id)) THEN
177: RETURN G_RC_INVALID_PAYEE;
178: END IF;
179: END IF;

Line 338: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

334: -- End of comments
335:
336: PROCEDURE Create_External_Payee (
337: p_api_version IN NUMBER,
338: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
339: p_ext_payee_tab IN External_Payee_Tab_Type,
340: x_return_status OUT NOCOPY VARCHAR2,
341: x_msg_count OUT NOCOPY NUMBER,
342: x_msg_data OUT NOCOPY VARCHAR2,

Line 387: IF NOT FND_API.Compatible_API_Call(l_api_version,

383:
384: print_debuginfo(l_module_name, 'ENTER');
385:
386: -- Standard call to check for call compatibility.
387: IF NOT FND_API.Compatible_API_Call(l_api_version,
388: p_api_version,
389: l_api_name,
390: G_PKG_NAME) THEN
391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

387: IF NOT FND_API.Compatible_API_Call(l_api_version,
388: p_api_version,
389: l_api_name,
390: G_PKG_NAME) THEN
391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
392: END IF;
393:
394: -- Initialize message list if p_init_msg_list is set to TRUE.
395: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 395: IF FND_API.to_Boolean(p_init_msg_list) THEN

391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
392: END IF;
393:
394: -- Initialize message list if p_init_msg_list is set to TRUE.
395: IF FND_API.to_Boolean(p_init_msg_list) THEN
396: FND_MSG_PUB.initialize;
397: END IF;
398:
399: -- Initialize API return status to success

Line 400: x_return_status := FND_API.G_RET_STS_SUCCESS;

396: FND_MSG_PUB.initialize;
397: END IF;
398:
399: -- Initialize API return status to success
400: x_return_status := FND_API.G_RET_STS_SUCCESS;
401:
402: IF p_ext_payee_tab.COUNT > 0 THEN
403: counter := p_ext_payee_tab.FIRST;
404:

Line 420: x_return_status := FND_API.G_RET_STS_ERROR;

416: l_ext_payee_id_rec.Ext_Payee_ID := -1;
417: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';
418: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;
419:
420: x_return_status := FND_API.G_RET_STS_ERROR;
421: -- RAISE FND_API.G_EXC_ERROR;
422: ELSIF (p_ext_payee_tab(counter).Payment_Function IS NULL) THEN
423: print_debuginfo(l_module_name,'Payment function is null.');
424: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');

Line 421: -- RAISE FND_API.G_EXC_ERROR;

417: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';
418: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;
419:
420: x_return_status := FND_API.G_RET_STS_ERROR;
421: -- RAISE FND_API.G_EXC_ERROR;
422: ELSIF (p_ext_payee_tab(counter).Payment_Function IS NULL) THEN
423: print_debuginfo(l_module_name,'Payment function is null.');
424: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
425: FND_MESSAGE.SET_TOKEN('PARAM', 'Payment function');

Line 433: x_return_status := FND_API.G_RET_STS_ERROR;

429: l_ext_payee_id_rec.Ext_Payee_ID := -1;
430: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';
431: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;
432:
433: x_return_status := FND_API.G_RET_STS_ERROR;
434: -- RAISE FND_API.G_EXC_ERROR;
435: -- orgid is required if supplier site id passed
436: ELSIF ((p_ext_payee_tab(counter).Payer_ORG_ID IS NULL) and
437: (p_ext_payee_tab(counter).Supplier_Site_Id IS NOT NULL)) THEN

Line 434: -- RAISE FND_API.G_EXC_ERROR;

430: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';
431: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;
432:
433: x_return_status := FND_API.G_RET_STS_ERROR;
434: -- RAISE FND_API.G_EXC_ERROR;
435: -- orgid is required if supplier site id passed
436: ELSIF ((p_ext_payee_tab(counter).Payer_ORG_ID IS NULL) and
437: (p_ext_payee_tab(counter).Supplier_Site_Id IS NOT NULL)) THEN
438: print_debuginfo(l_module_name,'Payer Org Id is null.');

Line 484: x_return_status := FND_API.G_RET_STS_ERROR;

480: l_ext_payee_id_rec.Ext_Payee_ID := -1;
481: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';
482: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;
483:
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: -- RAISE FND_API.G_EXC_ERROR;
486: ELSE
487:
488: OPEN external_payee_csr(p_ext_payee_tab(counter).Payee_Party_Id,

Line 485: -- RAISE FND_API.G_EXC_ERROR;

481: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';
482: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;
483:
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: -- RAISE FND_API.G_EXC_ERROR;
486: ELSE
487:
488: OPEN external_payee_csr(p_ext_payee_tab(counter).Payee_Party_Id,
489: p_ext_payee_tab(counter).Payee_Party_Site_Id,

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

502: insert_payee_row(l_ext_payee_id,
503: p_ext_payee_tab(counter),
504: l_payee_crt_status);
505:
506: IF (l_payee_crt_status = FND_API.G_RET_STS_SUCCESS) THEN
507: l_ext_payee_id_rec.Ext_Payee_ID := l_ext_payee_id;
508: -- create the default payment method
509: IF(p_ext_payee_tab(counter).Default_Pmt_method is not NULL) THEN
510: select count(1)

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

561: FND_MESSAGE.set_name('IBY', 'IBY_DUPLICATE_EXT_PAYEE');
562: l_message := fnd_message.get;
563: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;
564:
565: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
566: END IF;
567: END IF;
568:
569: print_debuginfo(l_module_name, 'External payee Id is ' || l_ext_payee_id_rec.Ext_Payee_ID);

Line 589: WHEN FND_API.G_EXC_ERROR THEN

585:
586: print_debuginfo(l_module_name, 'RETURN');
587:
588: EXCEPTION
589: WHEN FND_API.G_EXC_ERROR THEN
590: x_return_status := FND_API.G_RET_STS_ERROR;
591:
592: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
593: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');

Line 590: x_return_status := FND_API.G_RET_STS_ERROR;

586: print_debuginfo(l_module_name, 'RETURN');
587:
588: EXCEPTION
589: WHEN FND_API.G_EXC_ERROR THEN
590: x_return_status := FND_API.G_RET_STS_ERROR;
591:
592: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
593: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
594: print_debuginfo(l_module_name,'SQLerr is :'

Line 596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

592: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
593: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
594: print_debuginfo(l_module_name,'SQLerr is :'
595: || substr(SQLERRM, 1, 150));
596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598:
599: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
600: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');

Line 597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

593: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
594: print_debuginfo(l_module_name,'SQLerr is :'
595: || substr(SQLERRM, 1, 150));
596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598:
599: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
600: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
601: print_debuginfo(l_module_name,'SQLerr is :'

Line 604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

600: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
601: print_debuginfo(l_module_name,'SQLerr is :'
602: || substr(SQLERRM, 1, 150));
603: WHEN OTHERS THEN
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
605:
606: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
607: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
608: END IF;

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

634: -- End of comments
635:
636: PROCEDURE Set_Payee_Instr_Assignment (
637: p_api_version IN NUMBER,
638: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
639: p_commit IN VARCHAR2 := FND_API.G_TRUE,
640: x_return_status OUT NOCOPY VARCHAR2,
641: x_msg_count OUT NOCOPY NUMBER,
642: x_msg_data OUT NOCOPY VARCHAR2,

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

635:
636: PROCEDURE Set_Payee_Instr_Assignment (
637: p_api_version IN NUMBER,
638: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
639: p_commit IN VARCHAR2 := FND_API.G_TRUE,
640: x_return_status OUT NOCOPY VARCHAR2,
641: x_msg_count OUT NOCOPY NUMBER,
642: x_msg_data OUT NOCOPY VARCHAR2,
643: p_payee IN PayeeContext_rec_type,

Line 686: IF NOT FND_API.Compatible_API_Call (l_api_version,

682: IF (c_instr_assignment%ISOPEN) THEN
683: CLOSE c_instr_assignment;
684: END IF;
685:
686: IF NOT FND_API.Compatible_API_Call (l_api_version,
687: p_api_version,
688: l_module,
689: G_PKG_NAME)
690: THEN

Line 696: RAISE FND_API.G_EXC_ERROR;

692: debug_level => FND_LOG.LEVEL_ERROR,
693: module => G_DEBUG_MODULE || l_module);
694: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
695: FND_MSG_PUB.Add;
696: RAISE FND_API.G_EXC_ERROR;
697: END IF;
698:
699: IF FND_API.to_Boolean( p_init_msg_list ) THEN
700: FND_MSG_PUB.initialize;

Line 699: IF FND_API.to_Boolean( p_init_msg_list ) THEN

695: FND_MSG_PUB.Add;
696: RAISE FND_API.G_EXC_ERROR;
697: END IF;
698:
699: IF FND_API.to_Boolean( p_init_msg_list ) THEN
700: FND_MSG_PUB.initialize;
701: END IF;
702: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
703:

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

700: FND_MSG_PUB.initialize;
701: END IF;
702: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
703:
704: Get_Payee_Id(p_payee, FND_API.G_VALID_LEVEL_FULL,l_payee_level, l_payee_id);
705:
706: print_debuginfo(l_module, 'After Get_Payee_Id');
707: print_debuginfo(l_module, 'Payee level is ' || l_payee_level);
708:

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

736:
737: print_debuginfo(l_module, 'After inserting a default payee row.');
738:
739:
740: IF (l_payee_crt_status <> FND_API.G_RET_STS_SUCCESS) THEN
741: x_response.Result_Code := G_RC_INVALID_PAYEE;
742: RETURN;
743: END IF;
744: END IF;

Line 854: IF FND_API.To_Boolean(p_commit) THEN

850: raise_biz_event(l_instr_id, l_payee_id, x_assign_id);
851: END IF;
852: */
853:
854: IF FND_API.To_Boolean(p_commit) THEN
855: COMMIT;
856: END IF;
857:
858: print_debuginfo(l_module, 'Before prepare the result.');

Line 868: WHEN FND_API.G_EXC_ERROR THEN

864: print_debuginfo(l_module, 'RETURN');
865:
866: EXCEPTION
867:
868: WHEN FND_API.G_EXC_ERROR THEN
869: ROLLBACK TO Set_Payee_Instr_Assignment;
870: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
871: debug_level => FND_LOG.LEVEL_ERROR,
872: module => G_DEBUG_MODULE || l_module);

Line 873: x_return_status := FND_API.G_RET_STS_ERROR ;

869: ROLLBACK TO Set_Payee_Instr_Assignment;
870: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
871: debug_level => FND_LOG.LEVEL_ERROR,
872: module => G_DEBUG_MODULE || l_module);
873: x_return_status := FND_API.G_RET_STS_ERROR ;
874: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
875: p_data => x_msg_data
876: );
877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

873: x_return_status := FND_API.G_RET_STS_ERROR ;
874: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
875: p_data => x_msg_data
876: );
877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
878: ROLLBACK TO Set_Payee_Instr_Assignment;
879: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
880: debug_level => FND_LOG.LEVEL_UNEXPECTED,
881: module => G_DEBUG_MODULE || l_module);

Line 882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

878: ROLLBACK TO Set_Payee_Instr_Assignment;
879: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
880: debug_level => FND_LOG.LEVEL_UNEXPECTED,
881: module => G_DEBUG_MODULE || l_module);
882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
883: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
884: p_data => x_msg_data
885: );
886: WHEN OTHERS THEN

Line 891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

887: ROLLBACK TO Set_Payee_Instr_Assignment;
888: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
889: debug_level => FND_LOG.LEVEL_UNEXPECTED,
890: module => G_DEBUG_MODULE || l_module);
891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
892: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
893: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
894: END IF;
895:

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

919: -- End of comments
920:
921: PROCEDURE Get_Payee_Instr_Assignments (
922: p_api_version IN NUMBER,
923: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
924: x_return_status OUT NOCOPY VARCHAR2,
925: x_msg_count OUT NOCOPY NUMBER,
926: x_msg_data OUT NOCOPY VARCHAR2,
927: p_payee IN PayeeContext_rec_type,

Line 960: IF NOT FND_API.Compatible_API_Call (l_api_version,

956: IF (c_instr_assignments%ISOPEN) THEN
957: CLOSE c_instr_assignments;
958: END IF;
959:
960: IF NOT FND_API.Compatible_API_Call (l_api_version,
961: p_api_version,
962: l_module,
963: G_PKG_NAME)
964: THEN

Line 970: RAISE FND_API.G_EXC_ERROR;

966: debug_level => FND_LOG.LEVEL_ERROR,
967: module => G_DEBUG_MODULE || l_module);
968: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
969: FND_MSG_PUB.Add;
970: RAISE FND_API.G_EXC_ERROR;
971: END IF;
972:
973: IF FND_API.to_Boolean( p_init_msg_list ) THEN
974: FND_MSG_PUB.initialize;

Line 973: IF FND_API.to_Boolean( p_init_msg_list ) THEN

969: FND_MSG_PUB.Add;
970: RAISE FND_API.G_EXC_ERROR;
971: END IF;
972:
973: IF FND_API.to_Boolean( p_init_msg_list ) THEN
974: FND_MSG_PUB.initialize;
975: END IF;
976: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
977:

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

974: FND_MSG_PUB.initialize;
975: END IF;
976: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
977:
978: Get_Payee_Id(p_payee,FND_API.G_VALID_LEVEL_FULL,l_payee_level,l_payee_id);
979:
980: IF (l_payee_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
981: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;
982: ELSE

Line 1008: WHEN FND_API.G_EXC_ERROR THEN

1004: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1005:
1006: EXCEPTION
1007:
1008: WHEN FND_API.G_EXC_ERROR THEN
1009:
1010: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1011: debug_level => FND_LOG.LEVEL_ERROR,
1012: module => G_DEBUG_MODULE || l_module);

Line 1013: x_return_status := FND_API.G_RET_STS_ERROR ;

1009:
1010: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1011: debug_level => FND_LOG.LEVEL_ERROR,
1012: module => G_DEBUG_MODULE || l_module);
1013: x_return_status := FND_API.G_RET_STS_ERROR ;
1014: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1015: p_data => x_msg_data
1016: );
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1013: x_return_status := FND_API.G_RET_STS_ERROR ;
1014: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1015: p_data => x_msg_data
1016: );
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018:
1019: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1020: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1021: module => G_DEBUG_MODULE || l_module);

Line 1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1018:
1019: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1020: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1021: module => G_DEBUG_MODULE || l_module);
1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1023: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1024: p_data => x_msg_data
1025: );
1026: WHEN OTHERS THEN

Line 1031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1027:
1028: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1029: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1030: module => G_DEBUG_MODULE || l_module);
1031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1032: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1033: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
1034: END IF;
1035:

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

1059: -- End of comments
1060:
1061: PROCEDURE Get_Payee_All_Instruments (
1062: p_api_version IN NUMBER,
1063: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1064: x_return_status OUT NOCOPY VARCHAR2,
1065: x_msg_count OUT NOCOPY NUMBER,
1066: x_msg_data OUT NOCOPY VARCHAR2,
1067: p_party_id IN NUMBER,

Line 1093: IF NOT FND_API.Compatible_API_Call (l_api_version,

1089: IF (c_instr_assignments%ISOPEN) THEN
1090: CLOSE c_instr_assignments;
1091: END IF;
1092:
1093: IF NOT FND_API.Compatible_API_Call (l_api_version,
1094: p_api_version,
1095: l_module,
1096: G_PKG_NAME)
1097: THEN

Line 1103: RAISE FND_API.G_EXC_ERROR;

1099: debug_level => FND_LOG.LEVEL_ERROR,
1100: module => G_DEBUG_MODULE || l_module);
1101: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1102: FND_MSG_PUB.Add;
1103: RAISE FND_API.G_EXC_ERROR;
1104: END IF;
1105:
1106: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1107: FND_MSG_PUB.initialize;

Line 1106: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1102: FND_MSG_PUB.Add;
1103: RAISE FND_API.G_EXC_ERROR;
1104: END IF;
1105:
1106: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1107: FND_MSG_PUB.initialize;
1108: END IF;
1109: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1110:

Line 1126: WHEN FND_API.G_EXC_ERROR THEN

1122: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1123:
1124: EXCEPTION
1125:
1126: WHEN FND_API.G_EXC_ERROR THEN
1127:
1128: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1129: debug_level => FND_LOG.LEVEL_ERROR,
1130: module => G_DEBUG_MODULE || l_module);

Line 1131: x_return_status := FND_API.G_RET_STS_ERROR ;

1127:
1128: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1129: debug_level => FND_LOG.LEVEL_ERROR,
1130: module => G_DEBUG_MODULE || l_module);
1131: x_return_status := FND_API.G_RET_STS_ERROR ;
1132: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1133: p_data => x_msg_data
1134: );
1135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1145:
1146: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1147: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1148: module => G_DEBUG_MODULE || l_module);
1149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1151: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
1152: END IF;
1153:

Line 1213: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

1209: -- Initial version : 1.0
1210:
1211: PROCEDURE Validate_External_Payee (
1212: p_api_version IN NUMBER,
1213: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
1214: p_ext_payee_rec IN External_Payee_Rec_Type,
1215: x_return_status OUT NOCOPY VARCHAR2,
1216: x_msg_count OUT NOCOPY NUMBER,
1217: x_msg_data OUT NOCOPY VARCHAR2

Line 1282: IF NOT FND_API.Compatible_API_Call(l_api_version,

1278:
1279: SAVEPOINT Validate_External_Payee_pub;
1280:
1281: -- Standard call to check for call compatibility.
1282: IF NOT FND_API.Compatible_API_Call(l_api_version,
1283: p_api_version,
1284: l_api_name,
1285: G_PKG_NAME) THEN
1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1282: IF NOT FND_API.Compatible_API_Call(l_api_version,
1283: p_api_version,
1284: l_api_name,
1285: G_PKG_NAME) THEN
1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1287: END IF;
1288:
1289: -- Initialize message list if p_init_msg_list is set to TRUE.
1290: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1290: IF FND_API.to_Boolean(p_init_msg_list) THEN

1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1287: END IF;
1288:
1289: -- Initialize message list if p_init_msg_list is set to TRUE.
1290: IF FND_API.to_Boolean(p_init_msg_list) THEN
1291: FND_MSG_PUB.initialize;
1292: END IF;
1293:
1294: -- Initialize API return status to success

Line 1295: x_return_status := FND_API.G_RET_STS_SUCCESS;

1291: FND_MSG_PUB.initialize;
1292: END IF;
1293:
1294: -- Initialize API return status to success
1295: x_return_status := FND_API.G_RET_STS_SUCCESS;
1296:
1297: -- Start of API body
1298: IF (p_ext_payee_rec.Payee_Party_Id IS NOT NULL) THEN
1299: IF (p_ext_payee_rec.Payee_Party_Site_Id IS NOT NULL) THEN

Line 1411: x_return_status := FND_API.G_RET_STS_ERROR;

1407: END IF;
1408:
1409: -- Return Error if any validations has failed.
1410: IF (NOT l_valid) THEN
1411: x_return_status := FND_API.G_RET_STS_ERROR;
1412: END IF;
1413:
1414: -- End of API body
1415:

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

1413:
1414: -- End of API body
1415:
1416: -- get message count and if count is 1, get message info.
1417: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1418: p_count => x_msg_count,
1419: p_data => x_msg_data);
1420:
1421:

Line 1423: WHEN fnd_api.g_exc_error THEN

1419: p_data => x_msg_data);
1420:
1421:
1422: EXCEPTION
1423: WHEN fnd_api.g_exc_error THEN
1424: ROLLBACK TO Validate_External_Payee_pub;
1425: x_return_status := fnd_api.g_ret_sts_error;
1426: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1427: p_count => x_msg_count,

Line 1425: x_return_status := fnd_api.g_ret_sts_error;

1421:
1422: EXCEPTION
1423: WHEN fnd_api.g_exc_error THEN
1424: ROLLBACK TO Validate_External_Payee_pub;
1425: x_return_status := fnd_api.g_ret_sts_error;
1426: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1427: p_count => x_msg_count,
1428: p_data => x_msg_data);
1429:

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

1422: EXCEPTION
1423: WHEN fnd_api.g_exc_error THEN
1424: ROLLBACK TO Validate_External_Payee_pub;
1425: x_return_status := fnd_api.g_ret_sts_error;
1426: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1427: p_count => x_msg_count,
1428: p_data => x_msg_data);
1429:
1430:

Line 1431: WHEN fnd_api.g_exc_unexpected_error THEN

1427: p_count => x_msg_count,
1428: p_data => x_msg_data);
1429:
1430:
1431: WHEN fnd_api.g_exc_unexpected_error THEN
1432: ROLLBACK TO Validate_External_Payee_pub;
1433: x_return_status := fnd_api.g_ret_sts_unexp_error;
1434: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1435: p_count => x_msg_count,

Line 1433: x_return_status := fnd_api.g_ret_sts_unexp_error;

1429:
1430:
1431: WHEN fnd_api.g_exc_unexpected_error THEN
1432: ROLLBACK TO Validate_External_Payee_pub;
1433: x_return_status := fnd_api.g_ret_sts_unexp_error;
1434: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1435: p_count => x_msg_count,
1436: p_data => x_msg_data);
1437:

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

1430:
1431: WHEN fnd_api.g_exc_unexpected_error THEN
1432: ROLLBACK TO Validate_External_Payee_pub;
1433: x_return_status := fnd_api.g_ret_sts_unexp_error;
1434: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1435: p_count => x_msg_count,
1436: p_data => x_msg_data);
1437:
1438:

Line 1441: x_return_status := fnd_api.g_ret_sts_unexp_error;

1437:
1438:
1439: WHEN OTHERS THEN
1440: ROLLBACK TO Validate_External_Payee_pub;
1441: x_return_status := fnd_api.g_ret_sts_unexp_error;
1442: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
1443: fnd_message.set_token('ERROR',SQLERRM);
1444: fnd_msg_pub.add;
1445: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

1441: x_return_status := fnd_api.g_ret_sts_unexp_error;
1442: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
1443: fnd_message.set_token('ERROR',SQLERRM);
1444: fnd_msg_pub.add;
1445: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1446: p_count => x_msg_count,
1447: p_data => x_msg_data);
1448:
1449:

Line 1465: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

1461: -- Initial version : 1.0
1462:
1463: PROCEDURE Create_Temp_Ext_Bank_Acct (
1464: p_api_version IN NUMBER,
1465: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
1466: x_return_status OUT NOCOPY VARCHAR2,
1467: x_msg_count OUT NOCOPY NUMBER,
1468: x_msg_data OUT NOCOPY VARCHAR2,
1469: p_temp_ext_acct_id IN NUMBER,

Line 1560: IF NOT FND_API.Compatible_API_Call(l_api_version,

1556:
1557: SAVEPOINT Create_Temp_Ext_Bank_Acct_pub;
1558:
1559: -- Standard call to check for call compatibility.
1560: IF NOT FND_API.Compatible_API_Call(l_api_version,
1561: p_api_version,
1562: l_api_name,
1563: G_PKG_NAME) THEN
1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1560: IF NOT FND_API.Compatible_API_Call(l_api_version,
1561: p_api_version,
1562: l_api_name,
1563: G_PKG_NAME) THEN
1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1565: END IF;
1566:
1567: -- Initialize message list if p_init_msg_list is set to TRUE.
1568: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1568: IF FND_API.to_Boolean(p_init_msg_list) THEN

1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1565: END IF;
1566:
1567: -- Initialize message list if p_init_msg_list is set to TRUE.
1568: IF FND_API.to_Boolean(p_init_msg_list) THEN
1569: FND_MSG_PUB.initialize;
1570: END IF;
1571:
1572: -- Initialize API return status to success

Line 1573: x_return_status := FND_API.G_RET_STS_SUCCESS;

1569: FND_MSG_PUB.initialize;
1570: END IF;
1571:
1572: -- Initialize API return status to success
1573: x_return_status := FND_API.G_RET_STS_SUCCESS;
1574:
1575: -- Start of API body
1576: OPEN iby_ext_bank_csr(p_temp_ext_acct_id);
1577: FETCH iby_ext_bank_csr INTO temp_ext_bank_acct_rec;

Line 1631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1627: x_response => x_response
1628: );
1629:
1630: IF (x_bank_acc_id IS NULL) THEN
1631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1632: END IF;
1633: -- End of API body
1634:
1635: -- get message count and if count is 1, get message info.

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

1632: END IF;
1633: -- End of API body
1634:
1635: -- get message count and if count is 1, get message info.
1636: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1637: p_count => x_msg_count,
1638: p_data => x_msg_data);
1639:
1640:

Line 1642: WHEN fnd_api.g_exc_error THEN

1638: p_data => x_msg_data);
1639:
1640:
1641: EXCEPTION
1642: WHEN fnd_api.g_exc_error THEN
1643: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1644: x_return_status := fnd_api.g_ret_sts_error;
1645: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1646: p_count => x_msg_count,

Line 1644: x_return_status := fnd_api.g_ret_sts_error;

1640:
1641: EXCEPTION
1642: WHEN fnd_api.g_exc_error THEN
1643: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1644: x_return_status := fnd_api.g_ret_sts_error;
1645: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1646: p_count => x_msg_count,
1647: p_data => x_msg_data);
1648:

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

1641: EXCEPTION
1642: WHEN fnd_api.g_exc_error THEN
1643: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1644: x_return_status := fnd_api.g_ret_sts_error;
1645: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1646: p_count => x_msg_count,
1647: p_data => x_msg_data);
1648:
1649:

Line 1650: WHEN fnd_api.g_exc_unexpected_error THEN

1646: p_count => x_msg_count,
1647: p_data => x_msg_data);
1648:
1649:
1650: WHEN fnd_api.g_exc_unexpected_error THEN
1651: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1652: x_return_status := fnd_api.g_ret_sts_unexp_error;
1653: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1654: p_count => x_msg_count,

Line 1652: x_return_status := fnd_api.g_ret_sts_unexp_error;

1648:
1649:
1650: WHEN fnd_api.g_exc_unexpected_error THEN
1651: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1652: x_return_status := fnd_api.g_ret_sts_unexp_error;
1653: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1654: p_count => x_msg_count,
1655: p_data => x_msg_data);
1656:

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

1649:
1650: WHEN fnd_api.g_exc_unexpected_error THEN
1651: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1652: x_return_status := fnd_api.g_ret_sts_unexp_error;
1653: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1654: p_count => x_msg_count,
1655: p_data => x_msg_data);
1656:
1657:

Line 1660: x_return_status := fnd_api.g_ret_sts_unexp_error;

1656:
1657:
1658: WHEN OTHERS THEN
1659: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1660: x_return_status := fnd_api.g_ret_sts_unexp_error;
1661: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
1662: fnd_message.set_token('ERROR',SQLERRM);
1663: fnd_msg_pub.add;
1664: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

1660: x_return_status := fnd_api.g_ret_sts_unexp_error;
1661: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
1662: fnd_message.set_token('ERROR',SQLERRM);
1663: fnd_msg_pub.add;
1664: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1665: p_count => x_msg_count,
1666: p_data => x_msg_data);
1667:
1668: END Create_Temp_Ext_Bank_Acct;

Line 1683: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

1679: -- Initial version : 1.0
1680:
1681: PROCEDURE Create_Temp_Ext_Bank_Acct (
1682: p_api_version IN NUMBER,
1683: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
1684: x_return_status OUT NOCOPY VARCHAR2,
1685: x_msg_count OUT NOCOPY NUMBER,
1686: x_msg_data OUT NOCOPY VARCHAR2,
1687: p_temp_ext_acct_id IN NUMBER,

Line 1783: IF NOT FND_API.Compatible_API_Call(l_api_version,

1779: print_debuginfo(l_module_name, 'ENTER');
1780: SAVEPOINT Create_Temp_Ext_Bank_Acct_pub;
1781:
1782: -- Standard call to check for call compatibility.
1783: IF NOT FND_API.Compatible_API_Call(l_api_version,
1784: p_api_version,
1785: l_api_name,
1786: G_PKG_NAME) THEN
1787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1783: IF NOT FND_API.Compatible_API_Call(l_api_version,
1784: p_api_version,
1785: l_api_name,
1786: G_PKG_NAME) THEN
1787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1788: END IF;
1789:
1790: -- Initialize message list if p_init_msg_list is set to TRUE.
1791: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1791: IF FND_API.to_Boolean(p_init_msg_list) THEN

1787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1788: END IF;
1789:
1790: -- Initialize message list if p_init_msg_list is set to TRUE.
1791: IF FND_API.to_Boolean(p_init_msg_list) THEN
1792: FND_MSG_PUB.initialize;
1793: END IF;
1794:
1795: -- Initialize API return status to success

Line 1796: x_return_status := FND_API.G_RET_STS_SUCCESS;

1792: FND_MSG_PUB.initialize;
1793: END IF;
1794:
1795: -- Initialize API return status to success
1796: x_return_status := FND_API.G_RET_STS_SUCCESS;
1797:
1798: -- Start of API body
1799: OPEN iby_ext_bank_csr(p_temp_ext_acct_id);
1800: FETCH iby_ext_bank_csr INTO temp_ext_bank_acct_rec;

Line 1860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1856: );
1857:
1858: print_debuginfo(l_module_name, 'After the call to create_ext_bank_accout');
1859: IF (x_bank_acc_id IS NULL) THEN
1860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1861: END IF;
1862: -- End of API body
1863:
1864: -- get message count and if count is 1, get message info.

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

1861: END IF;
1862: -- End of API body
1863:
1864: -- get message count and if count is 1, get message info.
1865: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1866: p_count => x_msg_count,
1867: p_data => x_msg_data);
1868:
1869: print_debuginfo(l_module_name, 'EXIT');

Line 1871: WHEN fnd_api.g_exc_error THEN

1867: p_data => x_msg_data);
1868:
1869: print_debuginfo(l_module_name, 'EXIT');
1870: EXCEPTION
1871: WHEN fnd_api.g_exc_error THEN
1872: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1873: x_return_status := fnd_api.g_ret_sts_error;
1874: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1875: p_count => x_msg_count,

Line 1873: x_return_status := fnd_api.g_ret_sts_error;

1869: print_debuginfo(l_module_name, 'EXIT');
1870: EXCEPTION
1871: WHEN fnd_api.g_exc_error THEN
1872: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1873: x_return_status := fnd_api.g_ret_sts_error;
1874: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1875: p_count => x_msg_count,
1876: p_data => x_msg_data);
1877:

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

1870: EXCEPTION
1871: WHEN fnd_api.g_exc_error THEN
1872: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1873: x_return_status := fnd_api.g_ret_sts_error;
1874: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1875: p_count => x_msg_count,
1876: p_data => x_msg_data);
1877:
1878:

Line 1879: WHEN fnd_api.g_exc_unexpected_error THEN

1875: p_count => x_msg_count,
1876: p_data => x_msg_data);
1877:
1878:
1879: WHEN fnd_api.g_exc_unexpected_error THEN
1880: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1881: x_return_status := fnd_api.g_ret_sts_unexp_error;
1882: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1883: p_count => x_msg_count,

Line 1881: x_return_status := fnd_api.g_ret_sts_unexp_error;

1877:
1878:
1879: WHEN fnd_api.g_exc_unexpected_error THEN
1880: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1881: x_return_status := fnd_api.g_ret_sts_unexp_error;
1882: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1883: p_count => x_msg_count,
1884: p_data => x_msg_data);
1885:

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

1878:
1879: WHEN fnd_api.g_exc_unexpected_error THEN
1880: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1881: x_return_status := fnd_api.g_ret_sts_unexp_error;
1882: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1883: p_count => x_msg_count,
1884: p_data => x_msg_data);
1885:
1886:

Line 1889: x_return_status := fnd_api.g_ret_sts_unexp_error;

1885:
1886:
1887: WHEN OTHERS THEN
1888: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1889: x_return_status := fnd_api.g_ret_sts_unexp_error;
1890: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
1891: fnd_message.set_token('ERROR',SQLERRM);
1892: fnd_msg_pub.add;
1893: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

1889: x_return_status := fnd_api.g_ret_sts_unexp_error;
1890: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
1891: fnd_message.set_token('ERROR',SQLERRM);
1892: fnd_msg_pub.add;
1893: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1894: p_count => x_msg_count,
1895: p_data => x_msg_data);
1896:
1897: END Create_Temp_Ext_Bank_Acct;

Line 1916: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

1912: -- Initial version : 1.0
1913:
1914: PROCEDURE Validate_Temp_Ext_Bank_Acct (
1915: p_api_version IN NUMBER,
1916: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
1917: x_return_status OUT NOCOPY VARCHAR2,
1918: x_msg_count OUT NOCOPY NUMBER,
1919: x_msg_data OUT NOCOPY VARCHAR2,
1920: p_temp_ext_acct_id IN NUMBER

Line 2042: IF NOT FND_API.Compatible_API_Call(l_api_version,

2038:
2039: SAVEPOINT Val_Temp_Ext_Bank_Acct_pub;
2040:
2041: -- Standard call to check for call compatibility.
2042: IF NOT FND_API.Compatible_API_Call(l_api_version,
2043: p_api_version,
2044: l_api_name,
2045: G_PKG_NAME) THEN
2046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2042: IF NOT FND_API.Compatible_API_Call(l_api_version,
2043: p_api_version,
2044: l_api_name,
2045: G_PKG_NAME) THEN
2046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2047: END IF;
2048:
2049: -- Initialize message list if p_init_msg_list is set to TRUE.
2050: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2050: IF FND_API.to_Boolean(p_init_msg_list) THEN

2046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2047: END IF;
2048:
2049: -- Initialize message list if p_init_msg_list is set to TRUE.
2050: IF FND_API.to_Boolean(p_init_msg_list) THEN
2051: FND_MSG_PUB.initialize;
2052: END IF;
2053:
2054: -- Initialize API return status to success

Line 2055: x_return_status := FND_API.G_RET_STS_SUCCESS;

2051: FND_MSG_PUB.initialize;
2052: END IF;
2053:
2054: -- Initialize API return status to success
2055: x_return_status := FND_API.G_RET_STS_SUCCESS;
2056:
2057: -- Start of API body
2058:
2059: OPEN ext_bank_acct_csr(p_temp_ext_acct_id);

Line 2132: p_init_msg_list => FND_API.G_TRUE,

2128:
2129: -- Call Validations
2130: IBY_EXT_BANKACCT_VALIDATIONS.iby_validate_account(
2131: p_api_version => p_api_version,
2132: p_init_msg_list => FND_API.G_TRUE,
2133: p_create_flag => FND_API.G_TRUE,
2134: p_ext_bank_rec => ext_bank_rec,
2135: p_ext_bank_branch_rec => ext_bank_branch_rec,
2136: p_ext_bank_acct_rec => ext_bank_acct_rec,

Line 2133: p_create_flag => FND_API.G_TRUE,

2129: -- Call Validations
2130: IBY_EXT_BANKACCT_VALIDATIONS.iby_validate_account(
2131: p_api_version => p_api_version,
2132: p_init_msg_list => FND_API.G_TRUE,
2133: p_create_flag => FND_API.G_TRUE,
2134: p_ext_bank_rec => ext_bank_rec,
2135: p_ext_bank_branch_rec => ext_bank_branch_rec,
2136: p_ext_bank_acct_rec => ext_bank_acct_rec,
2137: x_return_status => x_return_status,

Line 2144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2140: x_response => l_response
2141: );
2142:
2143: IF (fnd_msg_pub.count_msg > 0) THEN
2144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2145: END IF;
2146:
2147: -- End of API body
2148:

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

2146:
2147: -- End of API body
2148:
2149: -- get message count and if count is 1, get message info.
2150: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2151: p_count => x_msg_count,
2152: p_data => x_msg_data);
2153:
2154:

Line 2156: WHEN fnd_api.g_exc_error THEN

2152: p_data => x_msg_data);
2153:
2154:
2155: EXCEPTION
2156: WHEN fnd_api.g_exc_error THEN
2157: ROLLBACK TO Val_Temp_Ext_Bank_Acct_pub;
2158: x_return_status := fnd_api.g_ret_sts_error;
2159: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2160: p_count => x_msg_count,

Line 2158: x_return_status := fnd_api.g_ret_sts_error;

2154:
2155: EXCEPTION
2156: WHEN fnd_api.g_exc_error THEN
2157: ROLLBACK TO Val_Temp_Ext_Bank_Acct_pub;
2158: x_return_status := fnd_api.g_ret_sts_error;
2159: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2160: p_count => x_msg_count,
2161: p_data => x_msg_data);
2162:

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

2155: EXCEPTION
2156: WHEN fnd_api.g_exc_error THEN
2157: ROLLBACK TO Val_Temp_Ext_Bank_Acct_pub;
2158: x_return_status := fnd_api.g_ret_sts_error;
2159: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2160: p_count => x_msg_count,
2161: p_data => x_msg_data);
2162:
2163:

Line 2164: WHEN fnd_api.g_exc_unexpected_error THEN

2160: p_count => x_msg_count,
2161: p_data => x_msg_data);
2162:
2163:
2164: WHEN fnd_api.g_exc_unexpected_error THEN
2165: ROLLBACK TO Val_Temp_Ext_Bank_Acct_pub;
2166: x_return_status := fnd_api.g_ret_sts_unexp_error;
2167: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2168: p_count => x_msg_count,

Line 2166: x_return_status := fnd_api.g_ret_sts_unexp_error;

2162:
2163:
2164: WHEN fnd_api.g_exc_unexpected_error THEN
2165: ROLLBACK TO Val_Temp_Ext_Bank_Acct_pub;
2166: x_return_status := fnd_api.g_ret_sts_unexp_error;
2167: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2168: p_count => x_msg_count,
2169: p_data => x_msg_data);
2170:

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

2163:
2164: WHEN fnd_api.g_exc_unexpected_error THEN
2165: ROLLBACK TO Val_Temp_Ext_Bank_Acct_pub;
2166: x_return_status := fnd_api.g_ret_sts_unexp_error;
2167: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2168: p_count => x_msg_count,
2169: p_data => x_msg_data);
2170:
2171:

Line 2174: x_return_status := fnd_api.g_ret_sts_unexp_error;

2170:
2171:
2172: WHEN OTHERS THEN
2173: ROLLBACK TO Val_Temp_Ext_Bank_Acct_pub;
2174: x_return_status := fnd_api.g_ret_sts_unexp_error;
2175: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
2176: fnd_message.set_token('ERROR',SQLERRM);
2177: fnd_msg_pub.add;
2178: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

2174: x_return_status := fnd_api.g_ret_sts_unexp_error;
2175: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
2176: fnd_message.set_token('ERROR',SQLERRM);
2177: fnd_msg_pub.add;
2178: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2179: p_count => x_msg_count,
2180: p_data => x_msg_data);
2181:
2182: END Validate_Temp_Ext_Bank_Acct;

Line 2208: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

2204: -- End of comments
2205:
2206: PROCEDURE Update_External_Payee (
2207: p_api_version IN NUMBER,
2208: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2209: p_ext_payee_tab IN External_Payee_Tab_Type,
2210: p_ext_payee_id_tab IN Ext_Payee_ID_Tab_Type,
2211: x_return_status OUT NOCOPY VARCHAR2,
2212: x_msg_count OUT NOCOPY NUMBER,

Line 2252: IF NOT FND_API.Compatible_API_Call(l_api_version,

2248: BEGIN
2249: print_debuginfo(l_module_name, 'ENTER');
2250:
2251: -- Standard call to check for call compatibility.
2252: IF NOT FND_API.Compatible_API_Call(l_api_version,
2253: p_api_version,
2254: l_api_name,
2255: G_PKG_NAME) THEN
2256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2252: IF NOT FND_API.Compatible_API_Call(l_api_version,
2253: p_api_version,
2254: l_api_name,
2255: G_PKG_NAME) THEN
2256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2257: END IF;
2258:
2259: -- Initialize message list if p_init_msg_list is set to TRUE.
2260: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2260: IF FND_API.to_Boolean(p_init_msg_list) THEN

2256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2257: END IF;
2258:
2259: -- Initialize message list if p_init_msg_list is set to TRUE.
2260: IF FND_API.to_Boolean(p_init_msg_list) THEN
2261: FND_MSG_PUB.initialize;
2262: END IF;
2263:
2264: -- Initialize API return status to success

Line 2265: x_return_status := FND_API.G_RET_STS_SUCCESS;

2261: FND_MSG_PUB.initialize;
2262: END IF;
2263:
2264: -- Initialize API return status to success
2265: x_return_status := FND_API.G_RET_STS_SUCCESS;
2266:
2267: IF p_ext_payee_tab.COUNT > 0 THEN
2268: counter := p_ext_payee_tab.FIRST;
2269:

Line 2283: x_return_status := FND_API.G_RET_STS_ERROR;

2279:
2280: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2281: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2282:
2283: x_return_status := FND_API.G_RET_STS_ERROR;
2284:
2285: ELSIF p_ext_payee_tab(counter).Payee_Party_Id IS NULL THEN
2286: print_debuginfo(l_module_name,'Payee party Id is null.');
2287: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');

Line 2295: x_return_status := FND_API.G_RET_STS_ERROR;

2291:
2292: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2293: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2294:
2295: x_return_status := FND_API.G_RET_STS_ERROR;
2296:
2297: ELSIF (p_ext_payee_tab(counter).Payment_Function IS NULL) THEN
2298: print_debuginfo(l_module_name,'Payment function is null.');
2299: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');

Line 2307: x_return_status := FND_API.G_RET_STS_ERROR;

2303:
2304: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2305: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2306:
2307: x_return_status := FND_API.G_RET_STS_ERROR;
2308:
2309: -- orgid is required if supplier site id passed
2310: ELSIF ((p_ext_payee_tab(counter).Payer_ORG_ID IS NULL) and
2311: (p_ext_payee_tab(counter).Supplier_Site_Id IS NOT NULL)) THEN

Line 2342: x_return_status := FND_API.G_RET_STS_ERROR;

2338:
2339: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2340: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2341:
2342: x_return_status := FND_API.G_RET_STS_ERROR;
2343:
2344: ELSE
2345: OPEN external_payee_csr(p_ext_payee_tab(counter).Payee_Party_Id,
2346: p_ext_payee_tab(counter).Payee_Party_Site_Id,

Line 2369: x_return_status := FND_API.G_RET_STS_ERROR;

2365:
2366: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2367: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2368:
2369: x_return_status := FND_API.G_RET_STS_ERROR;
2370:
2371: ELSE
2372: -- update external payee
2373: UPDATE iby_external_payees_all

Line 2501: WHEN FND_API.G_EXC_ERROR THEN

2497: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2498: print_debuginfo(l_module_name, 'RETURN');
2499:
2500: EXCEPTION
2501: WHEN FND_API.G_EXC_ERROR THEN
2502: x_return_status := FND_API.G_RET_STS_ERROR;
2503:
2504: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2505: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');

Line 2502: x_return_status := FND_API.G_RET_STS_ERROR;

2498: print_debuginfo(l_module_name, 'RETURN');
2499:
2500: EXCEPTION
2501: WHEN FND_API.G_EXC_ERROR THEN
2502: x_return_status := FND_API.G_RET_STS_ERROR;
2503:
2504: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2505: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2506: print_debuginfo(l_module_name,'SQLerr is :'|| substr(SQLERRM, 1, 150));

Line 2508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2504: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2505: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2506: print_debuginfo(l_module_name,'SQLerr is :'|| substr(SQLERRM, 1, 150));
2507:
2508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2510:
2511: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2512: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');

Line 2509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2505: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2506: print_debuginfo(l_module_name,'SQLerr is :'|| substr(SQLERRM, 1, 150));
2507:
2508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2510:
2511: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2512: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2513: print_debuginfo(l_module_name,'SQLerr is :'|| substr(SQLERRM, 1, 150));

Line 2516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2512: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2513: print_debuginfo(l_module_name,'SQLerr is :'|| substr(SQLERRM, 1, 150));
2514:
2515: WHEN OTHERS THEN
2516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2517:
2518: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2519: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2520: END IF;