DBA Data[Home] [Help]

APPS.AP_APPROVAL_PKG dependencies on APP_EXCEPTION

Line 1778: APP_EXCEPTION.RAISE_EXCEPTION;

1774: -- Error: &ERROR
1775: --
1776: */
1777: FND_MESSAGE.SET_TOKEN('ERROR', l_lcm_msg_data);
1778: APP_EXCEPTION.RAISE_EXCEPTION;
1779:
1780: WHEN TAX_EXCEPTION THEN
1781: FND_MESSAGE.SET_NAME('SQLAP','AP_TAX_EXCEPTION');
1782: IF l_error_code IS NOT NULL THEN

Line 1798: APP_EXCEPTION.RAISE_EXCEPTION;

1794: IF (invoice_line_cur%ISOPEN) THEN
1795: CLOSE invoice_line_cur;
1796: END IF;
1797:
1798: APP_EXCEPTION.RAISE_EXCEPTION;
1799:
1800: WHEN OTHERS THEN
1801: IF (SQLCODE <> -20001) THEN
1802: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

Line 1828: APP_EXCEPTION.RAISE_EXCEPTION;

1824: IF (invoice_line_cur%ISOPEN) THEN
1825: CLOSE invoice_line_cur;
1826: END IF;
1827:
1828: APP_EXCEPTION.RAISE_EXCEPTION;
1829:
1830: END Approve;
1831:
1832: /*bug6858309 - modified the function to look for

Line 2021: APP_EXCEPTION.RAISE_EXCEPTION;

2017: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2018: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
2019: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2020: END IF;
2021: APP_EXCEPTION.RAISE_EXCEPTION;
2022: END Approval_Init;
2023:
2024: /*=============================================================================
2025: | PROCEDURE Inv_Needs_Approving

Line 2110: APP_EXCEPTION.RAISE_EXCEPTION;

2106: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2107: 'Invoice_id = '|| to_char(p_invoice_id)
2108: || 'Run Option = ' || p_run_option);
2109: END IF;
2110: APP_EXCEPTION.RAISE_EXCEPTION;
2111: END Inv_Needs_Approving;
2112:
2113: /*=============================================================================
2114: | PROCEDURE Update_Inv_Dists_To_Selected

Line 2202: APP_EXCEPTION.RAISE_EXCEPTION;

2198: 'Invoice_id = '|| to_char(p_invoice_id)
2199: || 'Run Option = ' || p_run_option);
2200: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2201: END IF;
2202: APP_EXCEPTION.RAISE_EXCEPTION;
2203: END Update_Inv_Dists_To_Selected;
2204:
2205:
2206: /*=============================================================================

Line 2336: APP_EXCEPTION.RAISE_EXCEPTION;

2332: IF ( Alloc_Rule_Cur%ISOPEN ) THEN
2333: CLOSE Alloc_Rule_Cur;
2334: END IF;
2335:
2336: APP_EXCEPTION.RAISE_EXCEPTION;
2337: END Check_Insufficient_Line_Data;
2338:
2339:
2340: /*=============================================================================

Line 2751: APP_EXCEPTION.RAISE_EXCEPTION;

2747:
2748: IF ( Alloc_Rule_Cur%ISOPEN ) THEN
2749: CLOSE Alloc_Rule_Cur;
2750: END IF;
2751: APP_EXCEPTION.RAISE_EXCEPTION;
2752:
2753: END Execute_Dist_Generation_Check;
2754:
2755:

Line 2914: APP_EXCEPTION.RAISE_EXCEPTION;

2910: ||', Set of Books Id = '|| to_char(p_set_of_books_id)
2911: ||', Base Currency Code = '|| p_base_currency_code);
2912: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2913: END IF;
2914: APP_EXCEPTION.RAISE_EXCEPTION;
2915: END Execute_General_Checks;
2916:
2917: /*=============================================================================
2918: | PROCEDURE CHECK_INVALID_DIST_ACCT

Line 3077: APP_EXCEPTION.RAISE_EXCEPTION;

3073: IF ( Invalid_Dist_Acct_Cur%ISOPEN ) THEN
3074: CLOSE Invalid_Dist_Acct_Cur;
3075: END IF;
3076:
3077: APP_EXCEPTION.RAISE_EXCEPTION;
3078: END Check_Invalid_Dist_Acct;
3079:
3080: /*=============================================================================
3081: | PROCEDURE CHECK_PO_REQUIRED

Line 3185: APP_EXCEPTION.RAISE_EXCEPTION;

3181: END IF;
3182: IF ( PO_Required_Cur%ISOPEN ) THEN
3183: CLOSE PO_Required_Cur;
3184: END IF;
3185: APP_EXCEPTION.RAISE_EXCEPTION;
3186: END Check_PO_Required;
3187:
3188: /*=============================================================================
3189: | PROCEDURE CHECK_NO_RATE

Line 3281: APP_EXCEPTION.RAISE_EXCEPTION;

3277: IF ( No_Rate_Cur%ISOPEN ) THEN
3278: CLOSE No_Rate_Cur;
3279: END IF;
3280:
3281: APP_EXCEPTION.RAISE_EXCEPTION;
3282: END Check_No_Rate;
3283:
3284: /*=============================================================================
3285: | PROCEDURE CHECK_DIST_VARIANCE

Line 3444: APP_EXCEPTION.RAISE_EXCEPTION;

3440: IF ( Dist_Var_Cur%ISOPEN ) THEN
3441: CLOSE Dist_Var_Cur;
3442: END IF;
3443:
3444: APP_EXCEPTION.RAISE_EXCEPTION;
3445: END Check_Dist_Variance;
3446:
3447: /*=============================================================================
3448: | PROCEDURE CHECK_LINE_VARIANCE

Line 3608: APP_EXCEPTION.RAISE_EXCEPTION;

3604: IF ( Line_Var_Cur%ISOPEN ) THEN
3605: CLOSE Line_Var_Cur;
3606: END IF;
3607:
3608: APP_EXCEPTION.RAISE_EXCEPTION;
3609: END Check_Line_Variance;
3610:
3611: /*=============================================================================
3612: | PROCEDURE Line_BASE_AMOUNT_CALCULATION

Line 3774: APP_EXCEPTION.RAISE_EXCEPTION;

3770: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3771: 'Invoice_id = '|| to_char(p_invoice_id));
3772: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3773: END IF;
3774: APP_EXCEPTION.RAISE_EXCEPTION;
3775: END Line_Base_Amount_Calculation;
3776:
3777: /*=============================================================================
3778: | PROCEDURE Dist_BASE_AMOUNT_CALCULATION

Line 3928: APP_EXCEPTION.RAISE_EXCEPTION;

3924: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3925: 'Invoice_id = '|| to_char(p_invoice_id));
3926: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3927: END IF;
3928: APP_EXCEPTION.RAISE_EXCEPTION;
3929: END Dist_Base_Amount_Calculation;
3930:
3931: /*=============================================================================
3932: | PROCEDURE GENERATE_ACCOUNT_EVENT

Line 4016: APP_EXCEPTION.RAISE_EXCEPTION;

4012: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4013: 'Invoice_id = '|| to_char(p_invoice_id));
4014: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4015: END IF;
4016: APP_EXCEPTION.RAISE_EXCEPTION;
4017: END Generate_Account_Event;
4018:
4019: /*=============================================================================
4020: | PROCEDURE CHECK_PREPAID_AMOUNT

Line 4118: APP_EXCEPTION.RAISE_EXCEPTION;

4114: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4115: 'Invoice_id = '|| to_char(p_invoice_id));
4116: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4117: END IF;
4118: APP_EXCEPTION.RAISE_EXCEPTION;
4119: END Check_Prepaid_Amount;
4120:
4121: /*=============================================================================
4122: | PROCEDURE CHECK_INVOICE_VENDOR

Line 4244: APP_EXCEPTION.RAISE_EXCEPTION;

4240: ||', Invoice Amount Limit = '|| to_char(p_invoice_amount_limit)
4241: ||', Hold Future Payments Flag = '|| p_hold_future_payments_flag);
4242: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4243: END IF;
4244: APP_EXCEPTION.RAISE_EXCEPTION;
4245: END Check_invoice_vendor;
4246:
4247:
4248: /*=============================================================================

Line 4414: APP_EXCEPTION.RAISE_EXCEPTION;

4410: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
4411: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4412: 'Invoice_id = '|| to_char(p_invoice_id));
4413: END IF;
4414: APP_EXCEPTION.RAISE_EXCEPTION;
4415: END Get_Inv_Matched_Status;
4416:
4417:
4418: /* ============================================================================

Line 4682: APP_EXCEPTION.RAISE_EXCEPTION;

4678: ||', Dist_line_num = '|| to_char(p_program_id)
4679: ||', Dist_line_num = '|| to_char(p_request_id));
4680: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4681: END IF;
4682: APP_EXCEPTION.RAISE_EXCEPTION;
4683: END Withhold_Tax_On;
4684:
4685:
4686: /*=============================================================================

Line 4830: APP_EXCEPTION.RAISE_EXCEPTION;

4826: 'Invoice_id = '|| to_char(p_invoice_id)
4827: || 'Run Option = ' || p_user_id);
4828: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4829: END IF;
4830: APP_EXCEPTION.RAISE_EXCEPTION;
4831: END Update_Inv_Dists_To_Approved;
4832:
4833: --============================================================================
4834: -- HOLD Processing Routines

Line 5001: APP_EXCEPTION.RAISE_EXCEPTION;

4997: ||', Hold_reason = '|| p_hold_reason
4998: ||', Should_have_hold = '|| p_should_have_hold);
4999: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
5000: END IF;
5001: APP_EXCEPTION.RAISE_EXCEPTION;
5002: END Process_Inv_Hold_Status;
5003:
5004: /*=============================================================================
5005: | PROCEDURE GET_HOLD_STATUS

Line 5110: APP_EXCEPTION.RAISE_EXCEPTION;

5106: ||', Line Location Id = '|| to_char(p_line_location_id)
5107: ||', System_User_id = '|| to_char(p_system_user)
5108: ||', Hold Code = '|| p_hold_lookup_code);
5109: END IF;
5110: APP_EXCEPTION.RAISE_EXCEPTION;
5111: END Get_Hold_Status;
5112:
5113:
5114: /*=============================================================================

Line 5226: APP_EXCEPTION.RAISE_EXCEPTION;

5222: ||', Hold_Code = '|| p_hold_lookup_code
5223: ||', Line Location Id = '|| (p_line_location_id));
5224: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
5225: END IF;
5226: APP_EXCEPTION.RAISE_EXCEPTION;
5227: END Release_Hold;
5228:
5229: /*=============================================================================
5230: | PROCEDURE SET_HOLD

Line 5394: APP_EXCEPTION.RAISE_EXCEPTION;

5390: ||', Hold_Code = '|| p_hold_lookup_code
5391: ||', Hold_Reason = '|| p_hold_reason);
5392: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
5393: END IF;
5394: APP_EXCEPTION.RAISE_EXCEPTION;
5395: END Set_Hold;
5396:
5397: /*=============================================================================
5398: | PROCEDURE COUNT_HOLD

Line 5456: APP_EXCEPTION.RAISE_EXCEPTION;

5452: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5453: 'Hold Code = '|| p_hold_lookup_code);
5454: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
5455: END IF;
5456: APP_EXCEPTION.RAISE_EXCEPTION;
5457: END Count_Hold;
5458:
5459:
5460: /*=============================================================================

Line 5603: APP_EXCEPTION.RAISE_EXCEPTION;

5599: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5600: 'Hold Code = '|| p_hold_lookup_code
5601: ||', Release Code = '|| p_release_lookup_code);
5602: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
5603: APP_EXCEPTION.RAISE_EXCEPTION;
5604: WHEN OTHERS THEN
5605: IF (SQLCODE <> -20001) THEN
5606: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5607: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

Line 5614: APP_EXCEPTION.RAISE_EXCEPTION;

5610: 'Hold Code = '|| p_hold_lookup_code
5611: ||', Release Code = '|| p_release_lookup_code);
5612: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
5613: END IF;
5614: APP_EXCEPTION.RAISE_EXCEPTION;
5615: END Get_Release_Lookup_For_Hold;
5616:
5617:
5618: /*=============================================================================

Line 5685: APP_EXCEPTION.RAISE_EXCEPTION;

5681: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5682: 'Hold Code = '|| to_char(p_invoice_id));
5683: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
5684: END IF;
5685: APP_EXCEPTION.RAISE_EXCEPTION;
5686: END Get_Invoice_Statuses;
5687:
5688:
5689: /*=============================================================================

Line 6162: APP_EXCEPTION.RAISE_EXCEPTION;

6158: ||', Exclude Tax from Discount = '|| p_exclude_tax_from_discount
6159: ||', Invoice Type = '|| p_invoice_type_lookup_code );
6160: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
6161: END IF;
6162: APP_EXCEPTION.RAISE_EXCEPTION;
6163:
6164: END Exclude_Tax_Freight_From_Disc;
6165:
6166:

Line 6358: APP_EXCEPTION.RAISE_EXCEPTION;

6354: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
6355:
6356: end if;
6357:
6358: APP_EXCEPTION.RAISE_EXCEPTION;
6359:
6360: END update_payment_schedule_prepay;
6361:
6362:

Line 6473: APP_EXCEPTION.RAISE_EXCEPTION;

6469: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6470: ' Invoice Id = ' || to_char(P_Invoice_Id) ||
6471: ', Calling module = ' || 'Manual_withhold_tax' );
6472: END IF;
6473: APP_EXCEPTION.RAISE_EXCEPTION;
6474:
6475: END Manual_Withhold_Tax;
6476:
6477: /* Added the following procedure for 7393338 */

Line 6584: APP_EXCEPTION.RAISE_EXCEPTION;

6580: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6581: ' Invoice Id = ' || to_char(P_Invoice_Id) ||
6582: ', Calling module = ' || 'Update_Pay_Sched_For_Awt' );
6583: END IF;
6584: APP_EXCEPTION.RAISE_EXCEPTION;
6585:
6586: END Update_Pay_Sched_For_Awt;
6587:
6588: --============================================================================

Line 6704: APP_EXCEPTION.RAISE_EXCEPTION;

6700: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6701: ' Invoice Id = ' || to_char(P_Invoice_Id) ||
6702: ', Calling module = ' || 'createPaymentSchedules' );
6703: END IF;
6704: APP_EXCEPTION.RAISE_EXCEPTION;
6705:
6706: END createPaymentSchedules;
6707:
6708:

Line 6748: APP_EXCEPTION.RAISE_EXCEPTION;

6744: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
6745: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6746: ' Application Id = ' || to_char(P_Application_Id) );
6747: END IF;
6748: APP_EXCEPTION.RAISE_EXCEPTION;
6749:
6750: END Is_Product_Registered;
6751:
6752:

Line 7042: APP_EXCEPTION.RAISE_EXCEPTION;

7038: ', Invoice Line Number = '||to_char(p_invoice_line_rec.Line_Number) ||
7039: ', Registration Api = '||P_Registration_Api ||
7040: ', Registration View = '||P_Registration_View);
7041: END IF;
7042: APP_EXCEPTION.RAISE_EXCEPTION;
7043:
7044: END Gen_Dists_From_Registration;
7045:
7046:

Line 8146: APP_EXCEPTION.RAISE_EXCEPTION;

8142: ||', Invoice Id = '|| to_char(p_invoice_id)
8143: ||', Entered By = '|| to_char(p_entered_by)
8144: ||', Concurrent Request Id = '|| to_char(p_conc_request_id)
8145: ||', Org Id = '|| to_char(p_org_id));
8146: APP_EXCEPTION.RAISE_EXCEPTION;
8147:
8148: --Bug7246971
8149:
8150: RETURN (FALSE);

Line 8177: APP_EXCEPTION.RAISE_EXCEPTION;

8173: ||', Concurrent Request Id = '|| to_char(p_conc_request_id)
8174: ||', Org Id = '|| to_char(p_org_id));
8175:
8176: END IF;
8177: APP_EXCEPTION.RAISE_EXCEPTION;
8178:
8179: --Bug7246971
8180:
8181: RETURN (FALSE);

Line 8299: APP_EXCEPTION.RAISE_EXCEPTION;

8295: IF C_Options_Query%ISOPEN THEN
8296: CLOSE C_Options_Query;
8297: END IF;
8298:
8299: APP_EXCEPTION.RAISE_EXCEPTION;
8300:
8301: END Cache_Options;
8302:
8303:

Line 8380: APP_EXCEPTION.RAISE_EXCEPTION;

8376: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
8377: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
8378: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
8379: END IF;
8380: APP_EXCEPTION.RAISE_EXCEPTION;
8381: END Cache_Tolerance_Templates;
8382:
8383: PROCEDURE Generate_Distributions
8384: (p_invoice_rec IN AP_APPROVAL_PKG.Invoice_Rec,

Line 8779: APP_EXCEPTION.RAISE_EXCEPTION;

8775: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
8776: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
8777: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
8778: END IF;
8779: APP_EXCEPTION.RAISE_EXCEPTION;
8780: END Generate_Distributions;
8781:
8782: PROCEDURE initialize_invoice_holds
8783: (p_invoice_id IN NUMBER,

Line 8833: APP_EXCEPTION.RAISE_EXCEPTION;

8829: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice_id = '||TO_CHAR(p_invoice_id));
8830: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
8831: end if;
8832:
8833: APP_EXCEPTION.RAISE_EXCEPTION;
8834:
8835: END initialize_invoice_holds;
8836:
8837: Procedure Count_Org_Hold(

Line 8915: APP_EXCEPTION.RAISE_EXCEPTION;

8911: ||' Action = '||p_place_or_release);
8912: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
8913: end if;
8914:
8915: APP_EXCEPTION.RAISE_EXCEPTION;
8916: End Count_Org_Hold;
8917:
8918: Procedure Print_Debug(
8919: p_api_name IN VARCHAR2,