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_PAYMENT_FORMAT_VAL_PUB dependencies on IBY_VALIDATIONSETS_PUB

Line 29: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

25: p_is_online_val IN VARCHAR2,
26: x_result OUT NOCOPY NUMBER
27: )IS
28: -- Initialising Payment Record
29: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
30: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
31: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
32:
33: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 30: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

26: x_result OUT NOCOPY NUMBER
27: )IS
28: -- Initialising Payment Record
29: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
30: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
31: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
32:
33: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
34: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

Line 89: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);

85: l_format_name := 'FVBLCCDP';
86: x_result:=g_SUCCESS;
87:
88: -- Initializing the payment record
89: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
90:
91: l_docErrorRec.validation_set_code := p_validation_set_code;
92: l_docErrorRec.transaction_id := p_instruction_id;
93: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

Line 348: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

344:
345: END IF; -- End of IF pay_instr_data_csr%FOUND
346: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
347:
348: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
349:
350: EXCEPTION
351: WHEN OTHERS THEN
352: x_result := 1;

Line 356: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

352: x_result := 1;
353: l_docErrorRec.transaction_error_id := null;
354: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
355: l_docErrorRec.error_message := SQLERRM;
356: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
357: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
358: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
359:
360: END FVBLCCDP; -- End of Procedure FVBLCCDP

Line 358: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

354: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
355: l_docErrorRec.error_message := SQLERRM;
356: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
357: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
358: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
359:
360: END FVBLCCDP; -- End of Procedure FVBLCCDP
361:
362: ----------------------------------------------------------------------------------------------------------

Line 380: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

376: p_is_online_val IN VARCHAR2,
377: x_result OUT NOCOPY NUMBER
378: )IS
379:
380: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
381: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
382: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
383:
384: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 381: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

377: x_result OUT NOCOPY NUMBER
378: )IS
379:
380: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
381: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
382: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
383:
384: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
385: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

Line 434: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);

430: l_format_name := 'FVBLNCR';
431: x_result:=g_SUCCESS;
432:
433: -- Initializing the payment record
434: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
435:
436: l_docErrorRec.validation_set_code := p_validation_set_code;
437: l_docErrorRec.transaction_id := p_instruction_id;
438: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

Line 660: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

656:
657: END IF; -- End of IF pay_instr_data_csr%FOUND
658: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
659:
660: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
661:
662: EXCEPTION
663: WHEN OTHERS THEN
664: x_result := 1;

Line 668: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

664: x_result := 1;
665: l_docErrorRec.transaction_error_id := null;
666: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
667: l_docErrorRec.error_message := SQLERRM;
668: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
669: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
670: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
671:
672:

Line 670: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

666: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
667: l_docErrorRec.error_message := SQLERRM;
668: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
669: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
670: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
671:
672:
673:
674: END FVBLNCR;-- End of Procedure FVBLNCR

Line 692: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

688: p_is_online_val IN VARCHAR2,
689: x_result OUT NOCOPY NUMBER
690: )IS
691:
692: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
693: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
694: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
695:
696: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 693: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

689: x_result OUT NOCOPY NUMBER
690: )IS
691:
692: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
693: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
694: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
695:
696: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
697: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

Line 751: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);

747: l_format_name := 'FVBLPPDP';
748: x_result:=g_SUCCESS;
749:
750: -- Initializing the payment record
751: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
752:
753: l_docErrorRec.validation_set_code := p_validation_set_code;
754: l_docErrorRec.transaction_id := p_instruction_id;
755: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

Line 1032: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

1028:
1029: END IF; -- End of IF pay_instr_data_csr%FOUND
1030: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
1031:
1032: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1033:
1034: EXCEPTION
1035: WHEN OTHERS THEN
1036: x_result := 1;

Line 1040: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

1036: x_result := 1;
1037: l_docErrorRec.transaction_error_id := null;
1038: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1039: l_docErrorRec.error_message := SQLERRM;
1040: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1041: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
1042: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1043:
1044:

Line 1042: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

1038: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1039: l_docErrorRec.error_message := SQLERRM;
1040: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1041: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
1042: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1043:
1044:
1045: END FVBLPPDP;-- End of Procedure FVBLPPDP
1046: ----------------------------------------------------------------------------------------------------------

Line 1064: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

1060: p_is_online_val IN VARCHAR2,
1061: x_result OUT NOCOPY NUMBER
1062: )IS
1063:
1064: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
1065: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1066: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1067:
1068: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 1065: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

1061: x_result OUT NOCOPY NUMBER
1062: )IS
1063:
1064: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
1065: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1066: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1067:
1068: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1069: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

Line 1118: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);

1114: l_format_name := 'FVBLSLTR';
1115: x_result:=g_SUCCESS;
1116:
1117: -- Initializing the payment record
1118: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
1119:
1120: l_docErrorRec.validation_set_code := p_validation_set_code;
1121: l_docErrorRec.transaction_id := p_instruction_id;
1122: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

Line 1324: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

1320:
1321: END IF; -- End of IF pay_instr_data_csr%FOUND
1322: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
1323:
1324: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1325:
1326: EXCEPTION
1327: WHEN OTHERS THEN
1328:

Line 1333: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

1329: x_result := 1;
1330: l_docErrorRec.transaction_error_id := null;
1331: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1332: l_docErrorRec.error_message := SQLERRM;
1333: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1334: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
1335: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1336:
1337:

Line 1335: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

1331: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1332: l_docErrorRec.error_message := SQLERRM;
1333: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1334: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
1335: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1336:
1337:
1338: END FVBLSLTR;-- End of Procedure FVBLSLTR
1339: ----------------------------------------------------------------------------------------------------------

Line 1357: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

1353: p_is_online_val IN VARCHAR2,
1354: x_result OUT NOCOPY NUMBER
1355: )IS
1356:
1357: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
1358: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1359: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1360:
1361: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 1358: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

1354: x_result OUT NOCOPY NUMBER
1355: )IS
1356:
1357: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
1358: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1359: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1360:
1361: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1362: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

Line 1417: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);

1413: l_format_name := 'FVTICTX';
1414: x_result:=g_SUCCESS;
1415:
1416: -- Initializing the payment record
1417: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
1418:
1419: l_docErrorRec.validation_set_code := p_validation_set_code;
1420: l_docErrorRec.transaction_id := p_instruction_id;
1421: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

Line 1668: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

1664:
1665: END IF; -- End of IF pay_instr_data_csr%FOUND
1666: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
1667:
1668: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1669:
1670: EXCEPTION
1671: WHEN OTHERS THEN
1672: x_result := 1;

Line 1676: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

1672: x_result := 1;
1673: l_docErrorRec.transaction_error_id := null;
1674: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1675: l_docErrorRec.error_message := SQLERRM;
1676: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1677: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
1678: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1679:
1680:

Line 1678: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

1674: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1675: l_docErrorRec.error_message := SQLERRM;
1676: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1677: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
1678: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1679:
1680:
1681: END FVTICTX;-- End of Procedure FVTICTX
1682: ----------------------------------------------------------------------------------------------------------

Line 1700: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

1696: p_is_online_val IN VARCHAR2,
1697: x_result OUT NOCOPY NUMBER
1698: )IS
1699:
1700: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
1701: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1702: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1703:
1704: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 1701: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

1697: x_result OUT NOCOPY NUMBER
1698: )IS
1699:
1700: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
1701: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1702: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1703:
1704: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1705: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

Line 1760: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);

1756: l_format_name := 'FVTPCCD';
1757: x_result:=g_SUCCESS;
1758:
1759: -- Initializing the payment record
1760: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
1761:
1762: l_docErrorRec.validation_set_code := p_validation_set_code;
1763: l_docErrorRec.transaction_id := p_instruction_id;
1764: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

Line 1983: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

1979:
1980: END IF; -- End of IF pay_instr_data_csr%FOUND
1981: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
1982:
1983: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1984:
1985:
1986: EXCEPTION
1987: WHEN OTHERS THEN

Line 1992: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

1988: x_result := 1;
1989: l_docErrorRec.transaction_error_id := null;
1990: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1991: l_docErrorRec.error_message := SQLERRM;
1992: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1993: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
1994: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1995:
1996:

Line 1994: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

1990: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1991: l_docErrorRec.error_message := SQLERRM;
1992: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1993: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
1994: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1995:
1996:
1997: END FVTPCCD;-- End of Procedure FVTPCCD
1998: ----------------------------------------------------------------------------------------------------------

Line 2016: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

2012: p_is_online_val IN VARCHAR2,
2013: x_result OUT NOCOPY NUMBER
2014: )IS
2015:
2016: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
2017: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2018: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2019:
2020: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 2017: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

2013: x_result OUT NOCOPY NUMBER
2014: )IS
2015:
2016: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
2017: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2018: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2019:
2020: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2021: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

Line 2075: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);

2071: l_format_name := 'FVTIACHP';
2072: x_result:=g_SUCCESS;
2073:
2074: -- Initializing the payment record
2075: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
2076:
2077: l_docErrorRec.validation_set_code := p_validation_set_code;
2078: l_docErrorRec.transaction_id := p_instruction_id;
2079: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

Line 2297: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

2293:
2294: END IF; -- End of IF pay_instr_data_csr%FOUND
2295: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
2296:
2297: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2298:
2299: EXCEPTION
2300: WHEN OTHERS THEN
2301: x_result := 1;

Line 2305: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

2301: x_result := 1;
2302: l_docErrorRec.transaction_error_id := null;
2303: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
2304: l_docErrorRec.error_message := SQLERRM;
2305: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2306: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
2307: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2308:
2309:

Line 2307: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

2303: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
2304: l_docErrorRec.error_message := SQLERRM;
2305: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2306: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
2307: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2308:
2309:
2310: END FVTIACHP;-- End of Procedure FVTIACHP
2311: ----------------------------------------------------------------------------------------------------------

Line 2329: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

2325: p_is_online_val IN VARCHAR2,
2326: x_result OUT NOCOPY NUMBER
2327: )IS
2328:
2329: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
2330: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2331: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2332:
2333: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 2330: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

2326: x_result OUT NOCOPY NUMBER
2327: )IS
2328:
2329: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
2330: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2331: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2332:
2333: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2334: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

Line 2381: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);

2377: l_format_name := 'FVTIACHB';
2378: x_result:=g_SUCCESS;
2379:
2380: -- Initializing the payment record
2381: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
2382:
2383: l_docErrorRec.validation_set_code := p_validation_set_code;
2384: l_docErrorRec.transaction_id := p_instruction_id;
2385: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

Line 2558: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

2554:
2555: END IF; -- End of IF pay_instr_data_csr%FOUND
2556: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
2557:
2558: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2559:
2560: EXCEPTION
2561: WHEN OTHERS THEN
2562: x_result := 1;

Line 2566: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

2562: x_result := 1;
2563: l_docErrorRec.transaction_error_id := null;
2564: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
2565: l_docErrorRec.error_message := SQLERRM;
2566: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2567: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
2568: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2569:
2570:

Line 2568: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

2564: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
2565: l_docErrorRec.error_message := SQLERRM;
2566: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2567: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
2568: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2569:
2570:
2571: END FVTIACHB;-- End of Procedure FVTIACHB
2572: ----------------------------------------------------------------------------------------------------------

Line 2590: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

2586: p_is_online_val IN VARCHAR2,
2587: x_result OUT NOCOPY NUMBER
2588: )IS
2589:
2590: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
2591: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2592: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2593:
2594: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 2591: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

2587: x_result OUT NOCOPY NUMBER
2588: )IS
2589:
2590: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
2591: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2592: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2593:
2594: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2595: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

Line 2651: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);

2647: l_format_name := 'FVTPPPD';
2648: x_result:=g_SUCCESS;
2649:
2650: -- Initializing the payment record
2651: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
2652:
2653: l_docErrorRec.validation_set_code := p_validation_set_code;
2654: l_docErrorRec.transaction_id := p_instruction_id;
2655: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

Line 2907: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

2903:
2904: END IF; -- End of IF pay_instr_data_csr%FOUND
2905: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
2906:
2907: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2908:
2909: EXCEPTION
2910: WHEN OTHERS THEN
2911: x_result := 1;

Line 2915: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

2911: x_result := 1;
2912: l_docErrorRec.transaction_error_id := null;
2913: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
2914: l_docErrorRec.error_message := SQLERRM;
2915: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2916: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
2917: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2918:
2919:

Line 2917: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

2913: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
2914: l_docErrorRec.error_message := SQLERRM;
2915: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2916: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
2917: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2918:
2919:
2920: END FVTPPPD;-- End of Procedure FVTPPPD
2921: ----------------------------------------------------------------------------------------------------------

Line 2939: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

2935: p_is_online_val IN VARCHAR2,
2936: x_result OUT NOCOPY NUMBER
2937: )IS
2938:
2939: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
2940: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2941: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2942:
2943: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 2940: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

2936: x_result OUT NOCOPY NUMBER
2937: )IS
2938:
2939: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
2940: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2941: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2942:
2943: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2944: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

Line 3000: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);

2996: l_format_name := 'FVTPPPDP';
2997: x_result:=g_SUCCESS;
2998:
2999: -- Initializing the payment record
3000: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
3001:
3002: l_docErrorRec.validation_set_code := p_validation_set_code;
3003: l_docErrorRec.transaction_id := p_instruction_id;
3004: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

Line 3252: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

3248:
3249: END IF; -- End of IF pay_instr_data_csr%FOUND
3250: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
3251:
3252: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3253:
3254: EXCEPTION
3255: WHEN OTHERS THEN
3256: x_result := 1;

Line 3260: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

3256: x_result := 1;
3257: l_docErrorRec.transaction_error_id := null;
3258: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
3259: l_docErrorRec.error_message := SQLERRM;
3260: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3261: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
3262: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3263:
3264:

Line 3262: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

3258: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
3259: l_docErrorRec.error_message := SQLERRM;
3260: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3261: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
3262: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3263:
3264:
3265: END FVTPPPDP;-- End of Procedure FVTPPPDP
3266: ----------------------------------------------------------------------------------------------------------

Line 3284: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

3280: p_is_online_val IN VARCHAR2,
3281: x_result OUT NOCOPY NUMBER
3282: )IS
3283:
3284: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
3285: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3286: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3287:
3288: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 3285: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

3281: x_result OUT NOCOPY NUMBER
3282: )IS
3283:
3284: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
3285: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3286: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3287:
3288: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3289: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

Line 3344: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);

3340: l_format_name := 'FVSPCCD';
3341: x_result:=g_SUCCESS;
3342:
3343: -- Initializing the payment record
3344: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
3345:
3346: l_docErrorRec.validation_set_code := p_validation_set_code;
3347: l_docErrorRec.transaction_id := p_instruction_id;
3348: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

Line 3551: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

3547:
3548: END IF; -- End of IF pay_instr_data_csr%FOUND
3549: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
3550:
3551: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3552:
3553: EXCEPTION
3554: WHEN OTHERS THEN
3555: x_result := 1;

Line 3559: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

3555: x_result := 1;
3556: l_docErrorRec.transaction_error_id := null;
3557: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
3558: l_docErrorRec.error_message := SQLERRM;
3559: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3560: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
3561: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3562:
3563:

Line 3561: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

3557: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
3558: l_docErrorRec.error_message := SQLERRM;
3559: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3560: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
3561: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3562:
3563:
3564: END FVSPCCD;-- End of Procedure FVSPCCD
3565: ----------------------------------------------------------------------------------------------------------

Line 3583: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

3579: p_is_online_val IN VARCHAR2,
3580: x_result OUT NOCOPY NUMBER
3581: )IS
3582:
3583: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
3584: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3585: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3586:
3587: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 3584: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

3580: x_result OUT NOCOPY NUMBER
3581: )IS
3582:
3583: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
3584: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3585: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3586:
3587: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3588: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

Line 3643: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);

3639: l_format_name := 'FVSPCCDP';
3640: x_result:=g_SUCCESS;
3641:
3642: -- Initializing the payment record
3643: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
3644:
3645: l_docErrorRec.validation_set_code := p_validation_set_code;
3646: l_docErrorRec.transaction_id := p_instruction_id;
3647: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

Line 3853: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

3849:
3850:
3851: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
3852:
3853: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3854:
3855: EXCEPTION
3856: WHEN OTHERS THEN
3857: x_result := 1;

Line 3861: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

3857: x_result := 1;
3858: l_docErrorRec.transaction_error_id := null;
3859: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
3860: l_docErrorRec.error_message := SQLERRM;
3861: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3862: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
3863: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3864:
3865:

Line 3863: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

3859: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
3860: l_docErrorRec.error_message := SQLERRM;
3861: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3862: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
3863: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3864:
3865:
3866: END FVSPCCDP;-- End of Procedure FVSPCCDP
3867: ----------------------------------------------------------------------------------------------------------

Line 3885: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

3881: p_is_online_val IN VARCHAR2,
3882: x_result OUT NOCOPY NUMBER
3883: )IS
3884:
3885: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
3886: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3887: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3888:
3889: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 3886: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

3882: x_result OUT NOCOPY NUMBER
3883: )IS
3884:
3885: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
3886: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3887: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3888:
3889: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3890: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

Line 3940: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);

3936: l_format_name := 'FVSPNCR';
3937: x_result:=g_SUCCESS;
3938:
3939: -- Initializing the payment record
3940: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
3941:
3942: l_docErrorRec.validation_set_code := p_validation_set_code;
3943: l_docErrorRec.transaction_id := p_instruction_id;
3944: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

Line 4106: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

4102:
4103: END IF; -- End of IF pay_instr_data_csr%FOUND
4104: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
4105:
4106: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4107:
4108: EXCEPTION
4109: WHEN OTHERS THEN
4110: x_result := 1;

Line 4114: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

4110: x_result := 1;
4111: l_docErrorRec.transaction_error_id := null;
4112: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
4113: l_docErrorRec.error_message := SQLERRM;
4114: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4115: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
4116: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4117:
4118:

Line 4116: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

4112: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
4113: l_docErrorRec.error_message := SQLERRM;
4114: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4115: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
4116: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4117:
4118:
4119: END FVSPNCR;-- End of Procedure FVSPNCR
4120: ----------------------------------------------------------------------------------------------------------

Line 4138: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

4134: p_is_online_val IN VARCHAR2,
4135: x_result OUT NOCOPY NUMBER
4136: )IS
4137:
4138: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
4139: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4140: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4141:
4142: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 4139: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

4135: x_result OUT NOCOPY NUMBER
4136: )IS
4137:
4138: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
4139: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4140: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4141:
4142: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
4143: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

Line 4198: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);

4194: BEGIN
4195: l_format_name := 'FVSPPPD';
4196: x_result:=g_SUCCESS;
4197: -- Initializing the payment record
4198: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
4199:
4200: l_docErrorRec.validation_set_code := p_validation_set_code;
4201: l_docErrorRec.transaction_id := p_instruction_id;
4202: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

Line 4431: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

4427:
4428: END IF; -- End of IF pay_instr_data_csr%FOUND
4429: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
4430:
4431: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4432:
4433: EXCEPTION
4434: WHEN OTHERS THEN
4435: x_result := 1;

Line 4439: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

4435: x_result := 1;
4436: l_docErrorRec.transaction_error_id := null;
4437: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
4438: l_docErrorRec.error_message := SQLERRM;
4439: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4440: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
4441: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4442:
4443:

Line 4441: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

4437: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
4438: l_docErrorRec.error_message := SQLERRM;
4439: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4440: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
4441: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4442:
4443:
4444: END FVSPPPD;-- End of Procedure FVSPPPD
4445: ----------------------------------------------------------------------------------------------------------

Line 4463: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

4459: p_is_online_val IN VARCHAR2,
4460: x_result OUT NOCOPY NUMBER
4461: )IS
4462:
4463: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
4464: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4465: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4466:
4467: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 4464: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

4460: x_result OUT NOCOPY NUMBER
4461: )IS
4462:
4463: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
4464: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4465: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4466:
4467: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
4468: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

Line 4523: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);

4519: l_format_name := 'FVSPPPDP';
4520: x_result:=g_SUCCESS;
4521:
4522: -- Initializing the payment record
4523: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
4524:
4525: l_docErrorRec.validation_set_code := p_validation_set_code;
4526: l_docErrorRec.transaction_id := p_instruction_id;
4527: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

Line 4759: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

4755:
4756: END IF; -- End of IF pay_instr_data_csr%FOUND
4757: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
4758:
4759: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4760:
4761: EXCEPTION
4762: WHEN OTHERS THEN
4763: x_result := 1;

Line 4767: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);

4763: x_result := 1;
4764: l_docErrorRec.transaction_error_id := null;
4765: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
4766: l_docErrorRec.error_message := SQLERRM;
4767: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4768: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
4769: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4770:
4771:

Line 4769: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);

4765: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
4766: l_docErrorRec.error_message := SQLERRM;
4767: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4768: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
4769: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4770:
4771:
4772: END FVSPPPDP;-- End of Procedure FVSPPPDP
4773: