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 102: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);

98: l_format_name := 'FVBLCCDP';
99: x_result:=g_SUCCESS;
100:
101: -- Initializing the payment record
102: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
103:
104: l_docErrorRec.validation_set_code := p_validation_set_code;
105: l_docErrorRec.transaction_id := p_instruction_id;
106: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

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

359:
360: END IF; -- End of IF pay_instr_data_csr%FOUND
361: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
362:
363: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
364:
365: EXCEPTION
366: WHEN OTHERS THEN
367: x_result := 1;

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

367: x_result := 1;
368: l_docErrorRec.transaction_error_id := null;
369: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
370: l_docErrorRec.error_message := SQLERRM;
371: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
372: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
373: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
374:
375: END FVBLCCDP; -- End of Procedure FVBLCCDP

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

369: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
370: l_docErrorRec.error_message := SQLERRM;
371: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
372: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
373: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
374:
375: END FVBLCCDP; -- End of Procedure FVBLCCDP
376:
377: ----------------------------------------------------------------------------------------------------------

Line 395: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

391: p_is_online_val IN VARCHAR2,
392: x_result OUT NOCOPY NUMBER
393: )IS
394:
395: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
396: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
397: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
398:
399: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 396: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

392: x_result OUT NOCOPY NUMBER
393: )IS
394:
395: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
396: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
397: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
398:
399: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
400: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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

446: l_format_name := 'FVBLNCR';
447: x_result:=g_SUCCESS;
448:
449: -- Initializing the payment record
450: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
451:
452: l_docErrorRec.validation_set_code := p_validation_set_code;
453: l_docErrorRec.transaction_id := p_instruction_id;
454: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

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

680:
681: END IF; -- End of IF pay_instr_data_csr%FOUND
682: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
683:
684: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
685:
686: EXCEPTION
687: WHEN OTHERS THEN
688: x_result := 1;

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

688: x_result := 1;
689: l_docErrorRec.transaction_error_id := null;
690: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
691: l_docErrorRec.error_message := SQLERRM;
692: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
693: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
694: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
695:
696:

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

690: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
691: l_docErrorRec.error_message := SQLERRM;
692: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
693: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
694: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
695:
696:
697:
698: END FVBLNCR;-- End of Procedure FVBLNCR

Line 716: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

712: p_is_online_val IN VARCHAR2,
713: x_result OUT NOCOPY NUMBER
714: )IS
715:
716: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
717: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
718: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
719:
720: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 717: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

713: x_result OUT NOCOPY NUMBER
714: )IS
715:
716: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
717: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
718: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
719:
720: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
721: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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

784: l_format_name := 'FVBLPPDP';
785: x_result:=g_SUCCESS;
786:
787: -- Initializing the payment record
788: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
789:
790: l_docErrorRec.validation_set_code := p_validation_set_code;
791: l_docErrorRec.transaction_id := p_instruction_id;
792: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

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

1067:
1068: END IF; -- End of IF pay_instr_data_csr%FOUND
1069: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
1070:
1071: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1072:
1073: EXCEPTION
1074: WHEN OTHERS THEN
1075: x_result := 1;

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

1075: x_result := 1;
1076: l_docErrorRec.transaction_error_id := null;
1077: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1078: l_docErrorRec.error_message := SQLERRM;
1079: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1080: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
1081: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1082:
1083:

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

1077: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1078: l_docErrorRec.error_message := SQLERRM;
1079: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1080: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
1081: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1082:
1083:
1084: END FVBLPPDP;-- End of Procedure FVBLPPDP
1085: ----------------------------------------------------------------------------------------------------------

Line 1103: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

1099: p_is_online_val IN VARCHAR2,
1100: x_result OUT NOCOPY NUMBER
1101: )IS
1102:
1103: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
1104: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1105: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1106:
1107: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 1104: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

1100: x_result OUT NOCOPY NUMBER
1101: )IS
1102:
1103: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
1104: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1105: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1106:
1107: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1108: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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

1153: l_format_name := 'FVBLSLTR';
1154: x_result:=g_SUCCESS;
1155:
1156: -- Initializing the payment record
1157: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
1158:
1159: l_docErrorRec.validation_set_code := p_validation_set_code;
1160: l_docErrorRec.transaction_id := p_instruction_id;
1161: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

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

1359:
1360: END IF; -- End of IF pay_instr_data_csr%FOUND
1361: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
1362:
1363: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1364:
1365: EXCEPTION
1366: WHEN OTHERS THEN
1367:

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

1368: x_result := 1;
1369: l_docErrorRec.transaction_error_id := null;
1370: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1371: l_docErrorRec.error_message := SQLERRM;
1372: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1373: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
1374: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1375:
1376:

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

1370: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1371: l_docErrorRec.error_message := SQLERRM;
1372: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1373: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
1374: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1375:
1376:
1377: END FVBLSLTR;-- End of Procedure FVBLSLTR
1378: ----------------------------------------------------------------------------------------------------------

Line 1396: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

1392: p_is_online_val IN VARCHAR2,
1393: x_result OUT NOCOPY NUMBER
1394: )IS
1395:
1396: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
1397: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1398: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1399:
1400: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 1397: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

1393: x_result OUT NOCOPY NUMBER
1394: )IS
1395:
1396: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
1397: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1398: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1399:
1400: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1401: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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

1465: l_format_name := 'FVTICTX';
1466: x_result:=g_SUCCESS;
1467:
1468: -- Initializing the payment record
1469: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
1470:
1471: l_docErrorRec.validation_set_code := p_validation_set_code;
1472: l_docErrorRec.transaction_id := p_instruction_id;
1473: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

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

1719:
1720: END IF; -- End of IF pay_instr_data_csr%FOUND
1721: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
1722:
1723: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1724:
1725: EXCEPTION
1726: WHEN OTHERS THEN
1727: x_result := 1;

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

1727: x_result := 1;
1728: l_docErrorRec.transaction_error_id := null;
1729: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1730: l_docErrorRec.error_message := SQLERRM;
1731: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1732: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
1733: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1734:
1735:

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

1729: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
1730: l_docErrorRec.error_message := SQLERRM;
1731: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
1732: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
1733: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
1734:
1735:
1736: END FVTICTX;-- End of Procedure FVTICTX
1737: ----------------------------------------------------------------------------------------------------------

Line 1755: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

1751: p_is_online_val IN VARCHAR2,
1752: x_result OUT NOCOPY NUMBER
1753: )IS
1754:
1755: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
1756: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1757: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1758:
1759: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 1756: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

1752: x_result OUT NOCOPY NUMBER
1753: )IS
1754:
1755: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
1756: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1757: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
1758:
1759: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
1760: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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

1824: l_format_name := 'FVTPCCD';
1825: x_result:=g_SUCCESS;
1826:
1827: -- Initializing the payment record
1828: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
1829:
1830: l_docErrorRec.validation_set_code := p_validation_set_code;
1831: l_docErrorRec.transaction_id := p_instruction_id;
1832: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

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

2049:
2050: END IF; -- End of IF pay_instr_data_csr%FOUND
2051: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
2052:
2053: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2054:
2055:
2056: EXCEPTION
2057: WHEN OTHERS THEN

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

2058: x_result := 1;
2059: l_docErrorRec.transaction_error_id := null;
2060: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
2061: l_docErrorRec.error_message := SQLERRM;
2062: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2063: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
2064: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2065:
2066:

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

2060: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
2061: l_docErrorRec.error_message := SQLERRM;
2062: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2063: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
2064: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2065:
2066:
2067: END FVTPCCD;-- End of Procedure FVTPCCD
2068: ----------------------------------------------------------------------------------------------------------

Line 2086: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

2082: p_is_online_val IN VARCHAR2,
2083: x_result OUT NOCOPY NUMBER
2084: )IS
2085:
2086: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
2087: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2088: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2089:
2090: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 2087: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

2083: x_result OUT NOCOPY NUMBER
2084: )IS
2085:
2086: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
2087: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2088: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2089:
2090: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2091: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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

2154: l_format_name := 'FVTIACHP';
2155: x_result:=g_SUCCESS;
2156:
2157: -- Initializing the payment record
2158: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
2159:
2160: l_docErrorRec.validation_set_code := p_validation_set_code;
2161: l_docErrorRec.transaction_id := p_instruction_id;
2162: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

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

2378:
2379: END IF; -- End of IF pay_instr_data_csr%FOUND
2380: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
2381:
2382: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2383:
2384: EXCEPTION
2385: WHEN OTHERS THEN
2386: x_result := 1;

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

2386: x_result := 1;
2387: l_docErrorRec.transaction_error_id := null;
2388: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
2389: l_docErrorRec.error_message := SQLERRM;
2390: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2391: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
2392: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2393:
2394:

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

2388: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
2389: l_docErrorRec.error_message := SQLERRM;
2390: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2391: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
2392: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2393:
2394:
2395: END FVTIACHP;-- End of Procedure FVTIACHP
2396: ----------------------------------------------------------------------------------------------------------

Line 2414: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

2410: p_is_online_val IN VARCHAR2,
2411: x_result OUT NOCOPY NUMBER
2412: )IS
2413:
2414: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
2415: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2416: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2417:
2418: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 2415: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

2411: x_result OUT NOCOPY NUMBER
2412: )IS
2413:
2414: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
2415: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2416: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2417:
2418: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2419: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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

2463: l_format_name := 'FVTIACHB';
2464: x_result:=g_SUCCESS;
2465:
2466: -- Initializing the payment record
2467: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
2468:
2469: l_docErrorRec.validation_set_code := p_validation_set_code;
2470: l_docErrorRec.transaction_id := p_instruction_id;
2471: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

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

2649:
2650: END IF; -- End of IF pay_instr_data_csr%FOUND
2651: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
2652:
2653: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2654:
2655: EXCEPTION
2656: WHEN OTHERS THEN
2657: x_result := 1;

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

2657: x_result := 1;
2658: l_docErrorRec.transaction_error_id := null;
2659: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
2660: l_docErrorRec.error_message := SQLERRM;
2661: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2662: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
2663: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2664:
2665:

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

2659: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
2660: l_docErrorRec.error_message := SQLERRM;
2661: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
2662: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
2663: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
2664:
2665:
2666: END FVTIACHB;-- End of Procedure FVTIACHB
2667: ----------------------------------------------------------------------------------------------------------

Line 2685: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

2681: p_is_online_val IN VARCHAR2,
2682: x_result OUT NOCOPY NUMBER
2683: )IS
2684:
2685: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
2686: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2687: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2688:
2689: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 2686: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

2682: x_result OUT NOCOPY NUMBER
2683: )IS
2684:
2685: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
2686: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
2687: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
2688:
2689: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
2690: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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

2755: l_format_name := 'FVTPPPD';
2756: x_result:=g_SUCCESS;
2757:
2758: -- Initializing the payment record
2759: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
2760:
2761: l_docErrorRec.validation_set_code := p_validation_set_code;
2762: l_docErrorRec.transaction_id := p_instruction_id;
2763: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

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

3013:
3014: END IF; -- End of IF pay_instr_data_csr%FOUND
3015: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
3016:
3017: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3018:
3019: EXCEPTION
3020: WHEN OTHERS THEN
3021: x_result := 1;

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

3021: x_result := 1;
3022: l_docErrorRec.transaction_error_id := null;
3023: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
3024: l_docErrorRec.error_message := SQLERRM;
3025: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3026: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
3027: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3028:
3029:

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

3023: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
3024: l_docErrorRec.error_message := SQLERRM;
3025: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3026: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
3027: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3028:
3029:
3030: END FVTPPPD;-- End of Procedure FVTPPPD
3031: ----------------------------------------------------------------------------------------------------------

Line 3049: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

3045: p_is_online_val IN VARCHAR2,
3046: x_result OUT NOCOPY NUMBER
3047: )IS
3048:
3049: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
3050: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3051: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3052:
3053: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 3050: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

3046: x_result OUT NOCOPY NUMBER
3047: )IS
3048:
3049: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
3050: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3051: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3052:
3053: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3054: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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

3119: l_format_name := 'FVTPPPDP';
3120: x_result:=g_SUCCESS;
3121:
3122: -- Initializing the payment record
3123: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
3124:
3125: l_docErrorRec.validation_set_code := p_validation_set_code;
3126: l_docErrorRec.transaction_id := p_instruction_id;
3127: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

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

3373:
3374: END IF; -- End of IF pay_instr_data_csr%FOUND
3375: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
3376:
3377: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3378:
3379: EXCEPTION
3380: WHEN OTHERS THEN
3381: x_result := 1;

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

3381: x_result := 1;
3382: l_docErrorRec.transaction_error_id := null;
3383: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
3384: l_docErrorRec.error_message := SQLERRM;
3385: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3386: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
3387: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3388:
3389:

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

3383: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
3384: l_docErrorRec.error_message := SQLERRM;
3385: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3386: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
3387: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3388:
3389:
3390: END FVTPPPDP;-- End of Procedure FVTPPPDP
3391: ----------------------------------------------------------------------------------------------------------

Line 3409: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

3405: p_is_online_val IN VARCHAR2,
3406: x_result OUT NOCOPY NUMBER
3407: )IS
3408:
3409: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
3410: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3411: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3412:
3413: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 3410: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

3406: x_result OUT NOCOPY NUMBER
3407: )IS
3408:
3409: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
3410: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3411: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3412:
3413: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3414: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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

3478: l_format_name := 'FVSPCCD';
3479: x_result:=g_SUCCESS;
3480:
3481: -- Initializing the payment record
3482: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
3483:
3484: l_docErrorRec.validation_set_code := p_validation_set_code;
3485: l_docErrorRec.transaction_id := p_instruction_id;
3486: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

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

3687:
3688: END IF; -- End of IF pay_instr_data_csr%FOUND
3689: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
3690:
3691: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3692:
3693: EXCEPTION
3694: WHEN OTHERS THEN
3695: x_result := 1;

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

3695: x_result := 1;
3696: l_docErrorRec.transaction_error_id := null;
3697: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
3698: l_docErrorRec.error_message := SQLERRM;
3699: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3700: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
3701: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3702:
3703:

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

3697: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
3698: l_docErrorRec.error_message := SQLERRM;
3699: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
3700: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
3701: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
3702:
3703:
3704: END FVSPCCD;-- End of Procedure FVSPCCD
3705: ----------------------------------------------------------------------------------------------------------

Line 3723: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

3719: p_is_online_val IN VARCHAR2,
3720: x_result OUT NOCOPY NUMBER
3721: )IS
3722:
3723: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
3724: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3725: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3726:
3727: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 3724: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

3720: x_result OUT NOCOPY NUMBER
3721: )IS
3722:
3723: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
3724: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3725: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
3726:
3727: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
3728: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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

3792: l_format_name := 'FVSPCCDP';
3793: x_result:=g_SUCCESS;
3794:
3795: -- Initializing the payment record
3796: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
3797:
3798: l_docErrorRec.validation_set_code := p_validation_set_code;
3799: l_docErrorRec.transaction_id := p_instruction_id;
3800: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

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

4004:
4005:
4006: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
4007:
4008: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4009:
4010: EXCEPTION
4011: WHEN OTHERS THEN
4012: x_result := 1;

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

4012: x_result := 1;
4013: l_docErrorRec.transaction_error_id := null;
4014: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
4015: l_docErrorRec.error_message := SQLERRM;
4016: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4017: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
4018: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4019:
4020:

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

4014: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
4015: l_docErrorRec.error_message := SQLERRM;
4016: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4017: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
4018: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4019:
4020:
4021: END FVSPCCDP;-- End of Procedure FVSPCCDP
4022: ----------------------------------------------------------------------------------------------------------

Line 4040: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

4036: p_is_online_val IN VARCHAR2,
4037: x_result OUT NOCOPY NUMBER
4038: )IS
4039:
4040: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
4041: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4042: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4043:
4044: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 4041: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

4037: x_result OUT NOCOPY NUMBER
4038: )IS
4039:
4040: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
4041: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4042: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4043:
4044: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
4045: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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

4092: l_format_name := 'FVSPNCR';
4093: x_result:=g_SUCCESS;
4094:
4095: -- Initializing the payment record
4096: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
4097:
4098: l_docErrorRec.validation_set_code := p_validation_set_code;
4099: l_docErrorRec.transaction_id := p_instruction_id;
4100: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

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

4268:
4269: END IF; -- End of IF pay_instr_data_csr%FOUND
4270: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
4271:
4272: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4273:
4274: EXCEPTION
4275: WHEN OTHERS THEN
4276: x_result := 1;

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

4276: x_result := 1;
4277: l_docErrorRec.transaction_error_id := null;
4278: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
4279: l_docErrorRec.error_message := SQLERRM;
4280: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4281: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
4282: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4283:
4284:

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

4278: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
4279: l_docErrorRec.error_message := SQLERRM;
4280: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4281: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
4282: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4283:
4284:
4285: END FVSPNCR;-- End of Procedure FVSPNCR
4286: ----------------------------------------------------------------------------------------------------------

Line 4304: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

4300: p_is_online_val IN VARCHAR2,
4301: x_result OUT NOCOPY NUMBER
4302: )IS
4303:
4304: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
4305: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4306: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4307:
4308: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 4305: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

4301: x_result OUT NOCOPY NUMBER
4302: )IS
4303:
4304: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
4305: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4306: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4307:
4308: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
4309: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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

4373: BEGIN
4374: l_format_name := 'FVSPPPD';
4375: x_result:=g_SUCCESS;
4376: -- Initializing the payment record
4377: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
4378:
4379: l_docErrorRec.validation_set_code := p_validation_set_code;
4380: l_docErrorRec.transaction_id := p_instruction_id;
4381: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

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

4608:
4609: END IF; -- End of IF pay_instr_data_csr%FOUND
4610: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
4611:
4612: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4613:
4614: EXCEPTION
4615: WHEN OTHERS THEN
4616: x_result := 1;

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

4616: x_result := 1;
4617: l_docErrorRec.transaction_error_id := null;
4618: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
4619: l_docErrorRec.error_message := SQLERRM;
4620: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4621: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
4622: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4623:
4624:

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

4618: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
4619: l_docErrorRec.error_message := SQLERRM;
4620: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4621: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
4622: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4623:
4624:
4625: END FVSPPPD;-- End of Procedure FVSPPPD
4626: ----------------------------------------------------------------------------------------------------------

Line 4644: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;

4640: p_is_online_val IN VARCHAR2,
4641: x_result OUT NOCOPY NUMBER
4642: )IS
4643:
4644: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
4645: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4646: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4647:
4648: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id

Line 4645: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

4641: x_result OUT NOCOPY NUMBER
4642: )IS
4643:
4644: l_instruction_rec IBY_VALIDATIONSETS_PUB.instructionRecType;
4645: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
4646: l_docErrorRec IBY_TRANSACTION_ERRORS%ROWTYPE;
4647:
4648: -- Pick Up The Required Data From Instructions (IBY_PAY_INSTRUCTIONS_ALL) using payemnt_instruction_id
4649: CURSOR pay_instr_data_csr(p_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE) IS

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

4713: l_format_name := 'FVSPPPDP';
4714: x_result:=g_SUCCESS;
4715:
4716: -- Initializing the payment record
4717: IBY_VALIDATIONSETS_PUB.initInstructionData(p_instruction_id,l_instruction_rec);
4718:
4719: l_docErrorRec.validation_set_code := p_validation_set_code;
4720: l_docErrorRec.transaction_id := p_instruction_id;
4721: l_docErrorRec.transaction_type := 'PAYMENT_INSTRUCTION';

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

4951:
4952: END IF; -- End of IF pay_instr_data_csr%FOUND
4953: CLOSE pay_instr_data_csr; -- Closing Instruction Data Cursor
4954:
4955: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4956:
4957: EXCEPTION
4958: WHEN OTHERS THEN
4959: x_result := 1;

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

4959: x_result := 1;
4960: l_docErrorRec.transaction_error_id := null;
4961: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
4962: l_docErrorRec.error_message := SQLERRM;
4963: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4964: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
4965: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4966:
4967:

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

4961: l_docErrorRec.error_code := 'UNEXPECTED_ERROR';
4962: l_docErrorRec.error_message := SQLERRM;
4963: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
4964: iby_payment_format_val_pvt.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_format_name, SQLERRM);
4965: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
4966:
4967:
4968: END FVSPPPDP;-- End of Procedure FVSPPPDP
4969: