APPS.FUN_NET_APAR_UTILS_GRP dependencies on FUN_NET_APAR_UTILS_GRP

Line 1: PACKAGE BODY FUN_NET_APAR_UTILS_GRP AS

1: PACKAGE BODY FUN_NET_APAR_UTILS_GRP AS
2: /* $Header: funntutilb.pls 120.0.12010000.3 2008/10/29 10:12:26 ychandra noship $ */
3:
4: PROCEDURE generic_error(routine in varchar2,
5: errcode in number,

Line 39: generic_error('FUN_NET_APAR_UTILS_GRP.Get_Invoice_Netted_status', sqlcode, sqlerrm || ':' || x_msg_data );

35: WHEN NO_DATA_FOUND THEN
36: RETURN 'N';
37: WHEN OTHERS THEN
38: x_msg_data:='Unknown error in Get_Invoice_Netted_status procedure';
39: generic_error('FUN_NET_APAR_UTILS_GRP.Get_Invoice_Netted_status', sqlcode, sqlerrm || ':' || x_msg_data );
40: RETURN 'E';
41:
42: END;
43: if(l_batch_id IS NOT NULL) then

Line 62: generic_error('FUN_NET_APAR_UTILS_GRP.Get_Invoice_Netted_status', sqlcode, sqlerrm || ':' || x_msg_data );

58: EXCEPTION
59: WHEN OTHERS THEN
60:
61: x_msg_data:='Unknown error in Get_Invoice_Netted_status procedure';
62: generic_error('FUN_NET_APAR_UTILS_GRP.Get_Invoice_Netted_status', sqlcode, sqlerrm || ':' || x_msg_data );
63: RETURN 'E';
64: END Get_Invoice_Netted_status;
65: /* This Procedure Returns batch status and corresponding batch id if the passed invoice_id is valid, else
66: it returns it returns the appropriate error message */

Line 87: generic_error('FUN_NET_APAR_UTILS_GRP.Get_Netting_Batch_Info', sqlcode, sqlerrm || ':' || x_msg_data );

83: exception
84: when NO_DATA_FOUND then
85: x_return_status:='E'; /* In this case the batch is not netted*/
86: x_msg_data:='Invoice ID was not found in any of the Netting Batch';
87: generic_error('FUN_NET_APAR_UTILS_GRP.Get_Netting_Batch_Info', sqlcode, sqlerrm || ':' || x_msg_data );
88: when OTHERS then
89: x_return_status:='E';
90: x_msg_data:='Unknown error in Get_Netting_Batch_Info procedure';
91: generic_error('FUN_NET_APAR_UTILS_GRP.Get_Netting_Batch_Info', sqlcode, sqlerrm || ':' || x_msg_data );

Line 91: generic_error('FUN_NET_APAR_UTILS_GRP.Get_Netting_Batch_Info', sqlcode, sqlerrm || ':' || x_msg_data );

87: generic_error('FUN_NET_APAR_UTILS_GRP.Get_Netting_Batch_Info', sqlcode, sqlerrm || ':' || x_msg_data );
88: when OTHERS then
89: x_return_status:='E';
90: x_msg_data:='Unknown error in Get_Netting_Batch_Info procedure';
91: generic_error('FUN_NET_APAR_UTILS_GRP.Get_Netting_Batch_Info', sqlcode, sqlerrm || ':' || x_msg_data );
92: End;
93: if(x_batch_id IS NOT NULL) then
94: select batch_status_code into x_batch_status from FUN_NET_BATCHES_ALL where batch_id=x_batch_id;
95: x_return_status:='S';

Line 100: x_msg_data:='Message from FUN_NET_APAR_UTILS_GRP package : Invoice_id is Null';

96: return;
97: end if;
98: else
99: x_return_status:='E';
100: x_msg_data:='Message from FUN_NET_APAR_UTILS_GRP package : Invoice_id is Null';
101: generic_error('FUN_NET_APAR_UTILS_GRP.Get_Netting_Batch_Info', sqlcode, sqlerrm || ':' || x_msg_data );
102: RETURN;
103: end if;
104: exception

Line 101: generic_error('FUN_NET_APAR_UTILS_GRP.Get_Netting_Batch_Info', sqlcode, sqlerrm || ':' || x_msg_data );

97: end if;
98: else
99: x_return_status:='E';
100: x_msg_data:='Message from FUN_NET_APAR_UTILS_GRP package : Invoice_id is Null';
101: generic_error('FUN_NET_APAR_UTILS_GRP.Get_Netting_Batch_Info', sqlcode, sqlerrm || ':' || x_msg_data );
102: RETURN;
103: end if;
104: exception
105: when OTHERS then

Line 108: generic_error('FUN_NET_APAR_UTILS_GRP.Get_Netting_Batch_Info', sqlcode, sqlerrm || ':' || x_msg_data );

104: exception
105: when OTHERS then
106: x_return_status:='E';
107: x_msg_data:='Unknown error in Get_Netting_Batch_Info procedure';
108: generic_error('FUN_NET_APAR_UTILS_GRP.Get_Netting_Batch_Info', sqlcode, sqlerrm || ':' || x_msg_data );
109: end Get_Netting_Batch_Info;
110: end FUN_NET_APAR_UTILS_GRP;

Line 110: end FUN_NET_APAR_UTILS_GRP;

106: x_return_status:='E';
107: x_msg_data:='Unknown error in Get_Netting_Batch_Info procedure';
108: generic_error('FUN_NET_APAR_UTILS_GRP.Get_Netting_Batch_Info', sqlcode, sqlerrm || ':' || x_msg_data );
109: end Get_Netting_Batch_Info;
110: end FUN_NET_APAR_UTILS_GRP;