80: END IF;
81:
82: EXCEPTION
83: WHEN OTHERS THEN
84: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
85: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
86: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'IGC_ETAX_UTIL_PKG.set_tax_security_context');
87: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_org_id: ' || p_org_id ||
88: 'p_legal_entity_id: ' || p_legal_entity_id ||
81:
82: EXCEPTION
83: WHEN OTHERS THEN
84: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
85: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
86: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'IGC_ETAX_UTIL_PKG.set_tax_security_context');
87: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_org_id: ' || p_org_id ||
88: 'p_legal_entity_id: ' || p_legal_entity_id ||
89: 'p_transaction_date: ' || p_transaction_date ||
82: EXCEPTION
83: WHEN OTHERS THEN
84: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
85: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
86: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'IGC_ETAX_UTIL_PKG.set_tax_security_context');
87: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_org_id: ' || p_org_id ||
88: 'p_legal_entity_id: ' || p_legal_entity_id ||
89: 'p_transaction_date: ' || p_transaction_date ||
90: 'p_related_doc_date: ' || p_related_doc_date ||
83: WHEN OTHERS THEN
84: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
85: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
86: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'IGC_ETAX_UTIL_PKG.set_tax_security_context');
87: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_org_id: ' || p_org_id ||
88: 'p_legal_entity_id: ' || p_legal_entity_id ||
89: 'p_transaction_date: ' || p_transaction_date ||
90: 'p_related_doc_date: ' || p_related_doc_date ||
91: 'p_adjusted_doc_date:' || p_adjusted_doc_date);
88: 'p_legal_entity_id: ' || p_legal_entity_id ||
89: 'p_transaction_date: ' || p_transaction_date ||
90: 'p_related_doc_date: ' || p_related_doc_date ||
91: 'p_adjusted_doc_date:' || p_adjusted_doc_date);
92: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
93: APP_EXCEPTION.RAISE_EXCEPTION;
94:
95: END set_tax_security_context;
96:
322: RETURN l_return_status;
323: END IF;
324: EXCEPTION
325: WHEN OTHERS THEN
326: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
327: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
328: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence);
329: FND_MESSAGE.SET_TOKEN('PARAMETERS',
330: ' P_CC_Header_Rec = '||P_CC_Header_Rec.cc_header_id||
323: END IF;
324: EXCEPTION
325: WHEN OTHERS THEN
326: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
327: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
328: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence);
329: FND_MESSAGE.SET_TOKEN('PARAMETERS',
330: ' P_CC_Header_Rec = '||P_CC_Header_Rec.cc_header_id||
331: ' P_Calling_Mode ='||P_Calling_Mode||
324: EXCEPTION
325: WHEN OTHERS THEN
326: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
327: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
328: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence);
329: FND_MESSAGE.SET_TOKEN('PARAMETERS',
330: ' P_CC_Header_Rec = '||P_CC_Header_Rec.cc_header_id||
331: ' P_Calling_Mode ='||P_Calling_Mode||
332: ' P_Legal_Entity_Id = '||P_Legal_Entity_Id);
325: WHEN OTHERS THEN
326: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
327: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
328: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence);
329: FND_MESSAGE.SET_TOKEN('PARAMETERS',
330: ' P_CC_Header_Rec = '||P_CC_Header_Rec.cc_header_id||
331: ' P_Calling_Mode ='||P_Calling_Mode||
332: ' P_Legal_Entity_Id = '||P_Legal_Entity_Id);
333: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
329: FND_MESSAGE.SET_TOKEN('PARAMETERS',
330: ' P_CC_Header_Rec = '||P_CC_Header_Rec.cc_header_id||
331: ' P_Calling_Mode ='||P_Calling_Mode||
332: ' P_Legal_Entity_Id = '||P_Legal_Entity_Id);
333: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
334: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
335:
336: APP_EXCEPTION.RAISE_EXCEPTION;
337:
514: VALUES l_trans_lines(i);
515: RETURN l_return_status;
516: EXCEPTION
517: WHEN OTHERS THEN
518: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
519: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
520: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence);
521: FND_MESSAGE.SET_TOKEN('PARAMETERS',
522: ' P_CC_Header_Rec = '||P_CC_Header_Rec.cc_header_id||
515: RETURN l_return_status;
516: EXCEPTION
517: WHEN OTHERS THEN
518: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
519: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
520: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence);
521: FND_MESSAGE.SET_TOKEN('PARAMETERS',
522: ' P_CC_Header_Rec = '||P_CC_Header_Rec.cc_header_id||
523: ' P_Calling_Mode ='||P_Calling_Mode||
516: EXCEPTION
517: WHEN OTHERS THEN
518: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
519: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
520: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence);
521: FND_MESSAGE.SET_TOKEN('PARAMETERS',
522: ' P_CC_Header_Rec = '||P_CC_Header_Rec.cc_header_id||
523: ' P_Calling_Mode ='||P_Calling_Mode||
524: ' P_Error_Code = '||P_Error_Code||
517: WHEN OTHERS THEN
518: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
519: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
520: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence);
521: FND_MESSAGE.SET_TOKEN('PARAMETERS',
522: ' P_CC_Header_Rec = '||P_CC_Header_Rec.cc_header_id||
523: ' P_Calling_Mode ='||P_Calling_Mode||
524: ' P_Error_Code = '||P_Error_Code||
525: ' P_Amount = '||P_Amount||
523: ' P_Calling_Mode ='||P_Calling_Mode||
524: ' P_Error_Code = '||P_Error_Code||
525: ' P_Amount = '||P_Amount||
526: ' P_Calling_Sequence = '||P_Calling_Sequence);
527: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
528: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529:
530: APP_EXCEPTION.RAISE_EXCEPTION;
531:
629: END IF;
630: RETURN l_return_status;
631: EXCEPTION
632: WHEN OTHERS THEN
633: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
634: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
635: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence);
636: FND_MESSAGE.SET_TOKEN('PARAMETERS',
637: ' P_CC_Header_Rec = '||P_CC_Header_Rec.cc_header_id||
630: RETURN l_return_status;
631: EXCEPTION
632: WHEN OTHERS THEN
633: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
634: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
635: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence);
636: FND_MESSAGE.SET_TOKEN('PARAMETERS',
637: ' P_CC_Header_Rec = '||P_CC_Header_Rec.cc_header_id||
638: ' P_Calling_Mode ='||P_Calling_Mode||
631: EXCEPTION
632: WHEN OTHERS THEN
633: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
634: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
635: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence);
636: FND_MESSAGE.SET_TOKEN('PARAMETERS',
637: ' P_CC_Header_Rec = '||P_CC_Header_Rec.cc_header_id||
638: ' P_Calling_Mode ='||P_Calling_Mode||
639: ' P_Error_Code = '||P_Error_Code||
632: WHEN OTHERS THEN
633: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
634: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
635: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence);
636: FND_MESSAGE.SET_TOKEN('PARAMETERS',
637: ' P_CC_Header_Rec = '||P_CC_Header_Rec.cc_header_id||
638: ' P_Calling_Mode ='||P_Calling_Mode||
639: ' P_Error_Code = '||P_Error_Code||
640: ' P_Amount = '||P_Amount||
638: ' P_Calling_Mode ='||P_Calling_Mode||
639: ' P_Error_Code = '||P_Error_Code||
640: ' P_Amount = '||P_Amount||
641: ' P_Calling_Sequence = '||P_Calling_Sequence);
642: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
643: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644:
645: APP_EXCEPTION.RAISE_EXCEPTION;
646:
853:
854: EXCEPTION
855: WHEN OTHERS THEN
856: --IF (SQLCODE <> -20001) THEN
857: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
858: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
859: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence);
860: FND_MESSAGE.SET_TOKEN('PARAMETERS',
861: ' P_CC_Header_Rec = '||P_CC_Header_Rec.cc_header_id||
854: EXCEPTION
855: WHEN OTHERS THEN
856: --IF (SQLCODE <> -20001) THEN
857: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
858: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
859: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence);
860: FND_MESSAGE.SET_TOKEN('PARAMETERS',
861: ' P_CC_Header_Rec = '||P_CC_Header_Rec.cc_header_id||
862: ' P_Calling_Mode ='||P_Calling_Mode||
855: WHEN OTHERS THEN
856: --IF (SQLCODE <> -20001) THEN
857: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
858: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
859: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence);
860: FND_MESSAGE.SET_TOKEN('PARAMETERS',
861: ' P_CC_Header_Rec = '||P_CC_Header_Rec.cc_header_id||
862: ' P_Calling_Mode ='||P_Calling_Mode||
863: ' P_Amount ='||P_Amount||
856: --IF (SQLCODE <> -20001) THEN
857: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
858: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
859: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence);
860: FND_MESSAGE.SET_TOKEN('PARAMETERS',
861: ' P_CC_Header_Rec = '||P_CC_Header_Rec.cc_header_id||
862: ' P_Calling_Mode ='||P_Calling_Mode||
863: ' P_Amount ='||P_Amount||
864: ' P_Line_Id ='||P_Line_Id);
861: ' P_CC_Header_Rec = '||P_CC_Header_Rec.cc_header_id||
862: ' P_Calling_Mode ='||P_Calling_Mode||
863: ' P_Amount ='||P_Amount||
864: ' P_Line_Id ='||P_Line_Id);
865: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
866: --END IF;
867: P_Error_Code := SQLERRM;
868: P_Return_Status :=FND_API.G_RET_STS_UNEXP_ERROR;
869: APP_EXCEPTION.RAISE_EXCEPTION;
925:
926:
927: EXCEPTION
928: WHEN OTHERS THEN
929: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
930: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
931: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence);
932: FND_MESSAGE.SET_TOKEN('PARAMETERS',
933: ' P_CC_Header_Id = '||p_cc_header_id||
926:
927: EXCEPTION
928: WHEN OTHERS THEN
929: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
930: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
931: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence);
932: FND_MESSAGE.SET_TOKEN('PARAMETERS',
933: ' P_CC_Header_Id = '||p_cc_header_id||
934: ' P_Calling_Sequence = '||P_Calling_Sequence);
927: EXCEPTION
928: WHEN OTHERS THEN
929: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
930: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
931: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence);
932: FND_MESSAGE.SET_TOKEN('PARAMETERS',
933: ' P_CC_Header_Id = '||p_cc_header_id||
934: ' P_Calling_Sequence = '||P_Calling_Sequence);
935: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
928: WHEN OTHERS THEN
929: FND_MESSAGE.SET_NAME('IGC','IGC_DEBUG');
930: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
931: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence);
932: FND_MESSAGE.SET_TOKEN('PARAMETERS',
933: ' P_CC_Header_Id = '||p_cc_header_id||
934: ' P_Calling_Sequence = '||P_Calling_Sequence);
935: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
936:
931: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence);
932: FND_MESSAGE.SET_TOKEN('PARAMETERS',
933: ' P_CC_Header_Id = '||p_cc_header_id||
934: ' P_Calling_Sequence = '||P_Calling_Sequence);
935: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
936:
937: APP_EXCEPTION.RAISE_EXCEPTION;
938:
939: END get_cc_def_tax_classification;