309: ' P_Calling_Sequence = '||P_Calling_Sequence);
310: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
311: END IF;
312:
313: APP_EXCEPTION.RAISE_EXCEPTION;
314:
315: END Get_Event_Class_Code;
316:
317:
478: ' P_Calling_Sequence = '||P_Calling_Sequence);
479: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
480: END IF;
481:
482: APP_EXCEPTION.RAISE_EXCEPTION;
483:
484: END Get_Event_Type_Code;
485:
486: /*=============================================================================
597: END IF;
598:
599: --bug10140354
600: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NULL THEN
601: APP_EXCEPTION.RAISE_EXCEPTION;
602: ELSE
603:
604: RETURN FALSE;
605: END IF;
718: END IF;
719:
720: --bug10140354
721: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NULL THEN
722: APP_EXCEPTION.RAISE_EXCEPTION;
723: ELSE
724:
725: RETURN FALSE;
726: END IF;
834: END IF;
835:
836: --bug10140354
837: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NULL THEN
838: APP_EXCEPTION.RAISE_EXCEPTION;
839: ELSE
840:
841: RETURN FALSE;
842: END IF;
1054: END IF;
1055:
1056: --bug10140354
1057: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NULL THEN
1058: APP_EXCEPTION.RAISE_EXCEPTION;
1059: ELSE
1060:
1061: RETURN FALSE;
1062: END IF;
1137: IF ( prepay_awt_group_id%ISOPEN ) THEN
1138: CLOSE prepay_awt_group_id;
1139: END IF;
1140:
1141: APP_EXCEPTION.RAISE_EXCEPTION;
1142: END Get_Prepay_Awt_Group_Id;
1143:
1144: /*=============================================================================
1145: | FUNCTION - Return_Tax_Lines()
1319: --Bug9395593
1320:
1321: --bug10140354
1322: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NULL THEN
1323: APP_EXCEPTION.RAISE_EXCEPTION;
1324: ELSE
1325:
1326: insert into ap_errors_gt(invoice_id , message_text) values(P_Invoice_Header_Rec.Invoice_id , 'Summary Tax Line Deleted by EBTax. This would cause orphan distributions.');
1327: RETURN FALSE;
1438: ' P_Calling_Sequence = '||P_Calling_Sequence);
1439: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1440: END IF;
1441:
1442: APP_EXCEPTION.RAISE_EXCEPTION;
1443: END;
1444:
1445: /* Start for bug 5943074-- updating summary_tax_line_id of ap_invoice_lines_all based on zx_lines
1446: for manual tax lines and tax only lines so that we do not delete and regenerate the tax lines . */
1504: ||' P_Error_Code = '||P_Error_Code
1505: ||' P_Calling_Sequence = '||P_Calling_Sequence);
1506: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1507: END IF;
1508: APP_EXCEPTION.RAISE_EXCEPTION;
1509: END;
1510: /* End for bug 5943074 */
1511:
1512: -------------------------------------------------------------------
1561: ' P_Calling_Sequence = '||P_Calling_Sequence);
1562: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1563: END IF;
1564:
1565: APP_EXCEPTION.RAISE_EXCEPTION;
1566: END;
1567:
1568: -------------------------------------------------------------------
1569: l_debug_info := 'Get open gl_date';
2007: ' P_Calling_Sequence = '||P_Calling_Sequence);
2008: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2009: END IF;
2010:
2011: APP_EXCEPTION.RAISE_EXCEPTION;
2012: END;
2013:
2014: -------------------------------------------------------------------
2015: l_debug_info := 'Update Inclusive tax amount';
2049: ' P_Calling_Sequence = '||P_Calling_Sequence);
2050: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2051: END IF;
2052:
2053: APP_EXCEPTION.RAISE_EXCEPTION;
2054: END;
2055:
2056: --------------------------------------------------
2057: l_debug_info := 'Create Tax Allocations';
2094: IF ( c_item_line%ISOPEN ) THEN
2095: CLOSE c_item_line;
2096: END IF;
2097:
2098: APP_EXCEPTION.RAISE_EXCEPTION;
2099: END;
2100:
2101: -------------------------------------------------------------------
2102: l_debug_info := 'Update total_tax_amount and self_assessed tax';
2166: ' P_Calling_Sequence = '||P_Calling_Sequence);
2167: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2168: END IF;
2169:
2170: APP_EXCEPTION.RAISE_EXCEPTION;
2171: END;
2172:
2173: -----------------------------------------------------------------
2174: l_debug_info := 'Update tax_already_calculated_flag';
2242: ' P_Calling_Sequence = '||P_Calling_Sequence);
2243: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2244: END IF;
2245:
2246: APP_EXCEPTION.RAISE_EXCEPTION;
2247:
2248: END Return_Tax_Lines;
2249:
2250:
4617:
4618: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4619: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'RETURN_TAX_DISTRIBUTIONS','Error while getting ccid for retainge invoice');
4620: END IF;
4621: APP_EXCEPTION.RAISE_EXCEPTION;
4622: END ;
4623:
4624: --bug 10621602 changes end
4625:
4682: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Error while retriving the ccid from projects');
4683: END IF;
4684:
4685: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NULL THEN
4686: APP_EXCEPTION.RAISE_EXCEPTION;
4687: ELSE
4688: P_Error_Code := FND_MESSAGE.GET;
4689: RETURN FALSE;
4690: END IF;
4939: 'P_Error_Code = '||P_Error_Code||
4940: 'P_Calling_Sequence = '||P_Calling_Sequence);
4941: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4942: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NULL THEN
4943: APP_EXCEPTION.RAISE_EXCEPTION;
4944: ELSE
4945: P_Error_Code := FND_MESSAGE.GET;
4946: RETURN FALSE;
4947: END IF;
5723: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
5724: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
5725: END IF;
5726:
5727: APP_EXCEPTION.RAISE_EXCEPTION;
5728: END;
5729:
5730: END LOOP;
5731: L_INV_SELF_INS.DELETE;
5791: */
5792: FND_MESSAGE.SET_NAME( 'SQLAP', 'AP_FRZN_TAX_DIST_DEL' ); -- Bug 9777752
5793:
5794: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NULL THEN
5795: APP_EXCEPTION.RAISE_EXCEPTION;
5796: ELSE
5797: RETURN FALSE;
5798: END IF;
5799: END IF;
5888: */
5889: FND_MESSAGE.SET_NAME( 'SQLAP', 'AP_FRZN_TAX_DIST_DEL' ); -- Bug 9777752
5890:
5891: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NULL THEN
5892: APP_EXCEPTION.RAISE_EXCEPTION;
5893: ELSE
5894: RETURN FALSE;
5895: END IF;
5896: END IF;
5960: IF INSTRB( SQLERRM, 'AP_INVOICE_DISTRIBUTION_U1' ) <> 0 THEN
5961: FND_MESSAGE.SET_NAME('SQLAP', 'AP_ERR_TAX_DIST_SYNC') ;
5962:
5963: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NULL THEN
5964: APP_EXCEPTION.RAISE_EXCEPTION;
5965: ELSE
5966: RETURN FALSE;
5967: END IF;
5968: END IF ;
5996: END IF;
5997:
5998: --bug10140354
5999: IF AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID IS NULL THEN
6000: APP_EXCEPTION.RAISE_EXCEPTION;
6001: ELSE
6002:
6003: RETURN FALSE;
6004: END IF;
6274: ' P_Calling_Sequence = '||P_Calling_Sequence);
6275: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
6276: END IF;
6277:
6278: APP_EXCEPTION.RAISE_EXCEPTION;
6279: END Return_Default_Import;
6280: /*=============================================================================
6281: | FUNCTION - Return_Tax_Quote()
6282: |
6357: ' P_Calling_Sequence = '||P_Calling_Sequence);
6358: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
6359: END IF;
6360:
6361: APP_EXCEPTION.RAISE_EXCEPTION;
6362:
6363: END Return_Tax_Quote;
6364:
6365: /*=============================================================================
6451: ' P_Calling_Sequence = '||P_Calling_Sequence);
6452: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
6453: END IF;
6454:
6455: APP_EXCEPTION.RAISE_EXCEPTION;
6456:
6457: END Return_Error_Messages;
6458:
6459: /*=============================================================================
6552: IF (tax_already_calculated%ISOPEN ) THEN
6553: CLOSE tax_already_calculated;
6554: END IF;
6555:
6556: APP_EXCEPTION.RAISE_EXCEPTION;
6557:
6558: END Is_Tax_Already_Calc_Inv;
6559:
6560:
6638: ' P_Calling_Sequence = '||P_Calling_Sequence);
6639: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
6640: END IF;
6641:
6642: APP_EXCEPTION.RAISE_EXCEPTION;
6643:
6644: END Is_Tax_Already_Calc_Inv_char;
6645:
6646: /*=============================================================================
6739: IF (etax_already_distributed%ISOPEN ) THEN
6740: CLOSE etax_already_distributed;
6741: END IF;
6742:
6743: APP_EXCEPTION.RAISE_EXCEPTION;
6744:
6745: END Is_Tax_Already_Dist_Inv;
6746:
6747: /*=============================================================================
6816: IF (invoice_dist_id%ISOPEN ) THEN
6817: CLOSE invoice_dist_id;
6818: END IF;
6819:
6820: APP_EXCEPTION.RAISE_EXCEPTION;
6821:
6822: END Get_Dist_Id_For_Tax_Dist_Id;
6823:
6824:
7093: ' P_Tax_Dist_Id = '||P_Tax_Dist_Id);
7094: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
7095: END IF;
7096:
7097: APP_EXCEPTION.RAISE_EXCEPTION;
7098:
7099: END Is_Tax_Dist_Frozen;
7100:
7101:
7194: ' P_Detail_Tax_Line_Id = '||P_Detail_Tax_Line_Id);
7195: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
7196: END IF;
7197:
7198: APP_EXCEPTION.RAISE_EXCEPTION;
7199:
7200: END IS_TAX_LINE_DELETE_ALLOWED;
7201:
7202: /*=============================================================================
7272: 'p_related_doc_date: ' || p_related_doc_date);
7273: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
7274: END IF;
7275:
7276: APP_EXCEPTION.RAISE_EXCEPTION;
7277:
7278: END set_tax_security_context;
7279:
7280:
8615: ' p_document_sub_type = '||p_document_sub_type ||
8616: ' p_tax_related_inv_id = '||p_tax_related_inv_id);
8617: fnd_message.set_token('DEBUG_INFO',l_debug_info);
8618: END IF;
8619: app_exception.raise_exception;
8620:
8621:
8622: END get_header_tax_attr_desc;
8623:
8833: ' p_org_id = '||p_org_id );
8834:
8835: fnd_message.set_token('DEBUG_INFO',l_debug_info);
8836: END IF;
8837: app_exception.raise_exception;
8838:
8839: END get_taxable_line_attr_desc;
8840:
8841: /*=============================================================================
8993: ' p_tax_status_code = '||p_tax_status_code );
8994:
8995: fnd_message.set_token('DEBUG_INFO',l_debug_info);
8996: END IF;
8997: app_exception.raise_exception;
8998:
8999: END get_tax_line_attr_desc;
9000:
9001: /*=============================================================================
9141: ' p_trx_date = '||p_trx_date );
9142:
9143: fnd_message.set_token('DEBUG_INFO',l_debug_info);
9144: END IF;
9145: app_exception.raise_exception;
9146:
9147: END get_default_tax_det_attribs;
9148:
9149:
9584: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
9585: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
9586: END IF;
9587:
9588: APP_EXCEPTION.RAISE_EXCEPTION;
9589: END;
9590:
9591:
9592: -- Bug 4887847: Added function Get_Line_Class to populate a new attribute that
9704: ' P_Calling_Sequence = '||P_Calling_Sequence);
9705: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
9706: END IF;
9707:
9708: APP_EXCEPTION.RAISE_EXCEPTION;
9709:
9710: END Get_Line_Class;
9711:
9712: FUNCTION Is_Tax_Already_Dist_Inv_Char(
9783: IF (etax_already_distributed%ISOPEN ) THEN
9784: CLOSE etax_already_distributed;
9785: END IF;
9786:
9787: APP_EXCEPTION.RAISE_EXCEPTION;
9788:
9789: END Is_Tax_Already_Dist_Inv_Char;
9790:
9791: FUNCTION Get_Converted_Price (x_invoice_distribution_id IN NUMBER)
9961: IF ( prepay_pay_awt_group_id%ISOPEN ) THEN
9962: CLOSE prepay_pay_awt_group_id;
9963: END IF;
9964:
9965: APP_EXCEPTION.RAISE_EXCEPTION;
9966: END Get_Prepay_Pay_Awt_Group_Id;
9967:
9968: /*=============================================================================
9969: | FUNCTION - Is_Inclusive_Flag_Updatable()