DBA Data[Home] [Help]

APPS.AP_APPROVAL_MATCHED_PKG dependencies on APP_EXCEPTION

Line 1218: APP_EXCEPTION.RAISE_EXCEPTION;

1214: ELSE
1215: /*-----------------------------------------------------------------+
1216: | Error occured during Variance Calculation |
1217: +-----------------------------------------------------------------*/
1218: APP_EXCEPTION.RAISE_EXCEPTION;
1219:
1220: END IF; -- end of l_variance_success check
1221:
1222: /*-----------------------------------------------------------------+

Line 1286: APP_EXCEPTION.RAISE_EXCEPTION;

1282: IF ( Check_Variance_Cur%ISOPEN ) THEN
1283: CLOSE Check_Variance_Cur;
1284: END IF;
1285:
1286: APP_EXCEPTION.RAISE_EXCEPTION;
1287:
1288: END Exec_Matched_Variance_Checks;
1289:
1290: /*============================================================================

Line 1551: APP_EXCEPTION.RAISE_EXCEPTION;

1547: IF ( Distribution_Cur%ISOPEN ) THEN
1548: CLOSE Distribution_Cur;
1549: END IF;
1550:
1551: APP_EXCEPTION.RAISE_EXCEPTION;
1552: END Exec_Qty_Variance_Check;
1553:
1554:
1555: /*============================================================================

Line 1807: APP_EXCEPTION.RAISE_EXCEPTION;

1803: IF ( Distribution_Cur%ISOPEN ) THEN
1804: CLOSE Distribution_Cur;
1805: END IF;
1806:
1807: APP_EXCEPTION.RAISE_EXCEPTION;
1808: END Exec_Amt_Variance_Check;
1809:
1810: /*============================================================================
1811: | PUBLIC PROCEDURE EXECUTE_MATCHED_CHECKS

Line 3084: APP_EXCEPTION.Raise_Exception;

3080: p_conc_flag => p_conc_flag,
3081: p_return_code => l_return_code,
3082: p_auto_close => 'Y',
3083: p_origin_doc_id=> p_invoice_id))) THEN
3084: APP_EXCEPTION.Raise_Exception;
3085: END IF;
3086: END IF; -- Not a final match invoice --
3087:
3088: --------------------------------------------------

Line 3299: APP_EXCEPTION.RAISE_EXCEPTION;

3295: ||', Partial_reserv_flag = '|| to_char(p_max_qty_ord_tol)
3296: ||', Max QTY REC Tol = '|| to_char(p_max_qty_rec_tol));
3297: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
3298: END IF;
3299: APP_EXCEPTION.RAISE_EXCEPTION;
3300: END Execute_Matched_Checks;
3301:
3302:
3303: /*============================================================================

Line 3348: APP_EXCEPTION.RAISE_EXCEPTION;

3344: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3345: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3346: 'Invoice_id = '|| to_char(p_line_location_id));
3347: END IF;
3348: APP_EXCEPTION.RAISE_EXCEPTION;
3349: END Get_PO_Closed_Code;
3350:
3351:
3352: /*============================================================================

Line 3401: APP_EXCEPTION.RAISE_EXCEPTION;

3397: 'Invoice_id = '|| to_char(p_invoice_id)
3398: ||', Hold Code1 = '|| p_hold_code
3399: ||', Hold Code2 = '|| p_hold_code2);
3400: END IF;
3401: APP_EXCEPTION.RAISE_EXCEPTION;
3402: END Inv_Has_Holds_Other_Than;
3403:
3404: /*============================================================================
3405: | FUNCTION INV_HAS_UNRELEASED_HOLDS

Line 3453: APP_EXCEPTION.RAISE_EXCEPTION;

3449: 'Invoice_id = '|| to_char(p_invoice_id)
3450: ||', Hold Code1 = '|| p_hold_code
3451: ||', Hold Code2 = '|| p_hold_code2);
3452: END IF;
3453: APP_EXCEPTION.RAISE_EXCEPTION;
3454: END Inv_Has_Unreleased_Holds;
3455:
3456:
3457: /*============================================================================

Line 3496: APP_EXCEPTION.RAISE_EXCEPTION;

3492: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3493: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3494: 'Invoice_id = '|| to_char(p_line_location_id));
3495: END IF;
3496: APP_EXCEPTION.RAISE_EXCEPTION;
3497: END Get_Shipment_Qty_Delivered;
3498:
3499: /*============================================================================
3500: | PROCEDURE UPDATE_FINAL_MATCH_FLAG

Line 3544: APP_EXCEPTION.RAISE_EXCEPTION;

3540: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
3541: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3542: 'Invoice_id = '|| to_char(p_line_location_id));
3543: END IF;
3544: APP_EXCEPTION.RAISE_EXCEPTION;
3545: END Update_Final_Match_Flag;
3546:
3547:
3548: /*============================================================================

Line 3890: THEN APP_EXCEPTION.Raise_Exception;

3886: p_return_code => l_return_code,
3887: p_auto_close => 'N',
3888: p_action_date => l_inv_accounting_date,
3889: p_origin_doc_id=> p_invoice_id)))
3890: THEN APP_EXCEPTION.Raise_Exception;
3891: END IF;
3892:
3893: -----------------------------------------------
3894: l_debug_info := 'Process PO Close retrun code';

Line 4053: APP_EXCEPTION.RAISE_EXCEPTION;

4049: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
4050: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4051: 'Invoice_id = '|| to_char(p_invoice_id));
4052: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4053: APP_EXCEPTION.RAISE_EXCEPTION;
4054: WHEN OTHERS THEN
4055: IF (SQLCODE <> -20001) THEN
4056: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4057: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

Line 4063: APP_EXCEPTION.RAISE_EXCEPTION;

4059: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4060: 'Invoice_id = '|| to_char(p_invoice_id));
4061: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4062: END IF;
4063: APP_EXCEPTION.RAISE_EXCEPTION;
4064: END Exec_PO_Final_Close;
4065:
4066:
4067: /*============================================================================

Line 4172: APP_EXCEPTION.RAISE_EXCEPTION;

4168: 'Invoice_id = '|| to_char(p_invoice_id)
4169: ||', Line Location Id = '|| to_char(p_line_location_id));
4170: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4171: END IF;
4172: APP_EXCEPTION.RAISE_EXCEPTION;
4173: END Check_Receipt_Exception;
4174:
4175:
4176: /*============================================================================

Line 4372: APP_EXCEPTION.RAISE_EXCEPTION;

4368: IF ( corrected_invoices%ISOPEN ) THEN
4369: CLOSE corrected_invoices;
4370: END IF;
4371:
4372: APP_EXCEPTION.RAISE_EXCEPTION;
4373: END Check_Price;
4374:
4375:
4376: /*============================================================================

Line 4580: APP_EXCEPTION.RAISE_EXCEPTION;

4576: ||', PO_Unit_Price = '|| to_char(p_po_unit_price)
4577: ||', Price_Tolerance = '|| to_char(p_price_tolerance));
4578: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
4579: END IF;
4580: APP_EXCEPTION.RAISE_EXCEPTION;
4581:
4582: END CHECK_AVERAGE_PRICE;
4583:
4584:

Line 4681: APP_EXCEPTION.RAISE_EXCEPTION;

4677: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4678: 'Invoice_id = '|| to_char(p_invoice_id)
4679: ||', Dist_line_num = '|| to_char(p_line_location_id));
4680: END IF;
4681: APP_EXCEPTION.RAISE_EXCEPTION;
4682: END Calc_Total_Shipment_Qty_Billed;
4683:
4684:
4685: /*============================================================================

Line 4818: APP_EXCEPTION.RAISE_EXCEPTION;

4814: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4815: 'Invoice_id = '|| to_char(p_invoice_id)
4816: ||', po_line_location_id = '|| to_char(p_line_location_id));
4817: END IF;
4818: APP_EXCEPTION.RAISE_EXCEPTION;
4819: END Calc_Shipment_Qty_Billed;
4820:
4821:
4822:

Line 4921: APP_EXCEPTION.RAISE_EXCEPTION;

4917: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4918: 'Invoice_id = '|| to_char(p_invoice_id)
4919: ||', Dist_line_num = '|| to_char(p_line_location_id));
4920: END IF;
4921: APP_EXCEPTION.RAISE_EXCEPTION;
4922: END Calc_Total_Shipment_Amt_Billed;
4923:
4924:
4925: /*============================================================================

Line 5055: APP_EXCEPTION.RAISE_EXCEPTION;

5051: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5052: 'Invoice_id = '|| to_char(p_invoice_id)
5053: ||', po_line_location_id = '|| to_char(p_line_location_id));
5054: END IF;
5055: APP_EXCEPTION.RAISE_EXCEPTION;
5056: END Calc_Shipment_Amt_Billed;
5057:
5058:
5059:

Line 5229: APP_EXCEPTION.RAISE_EXCEPTION;

5225: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5226: 'Invoice_id = '|| to_char(p_invoice_id)
5227: ||', Shipment_id = '|| to_char(p_line_location_id));
5228: END IF;
5229: APP_EXCEPTION.RAISE_EXCEPTION;
5230: END Calc_Ship_Total_Trx_Amt_Var;
5231:
5232: /*============================================================================
5233: | PROCEDURE CALC_SHIP_TRX_AMT

Line 5377: APP_EXCEPTION.RAISE_EXCEPTION;

5373: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5374: 'Invoice_id = '|| to_char(p_invoice_id)
5375: ||', Shipment_id = '|| to_char(p_line_location_id));
5376: END IF;
5377: APP_EXCEPTION.RAISE_EXCEPTION;
5378: END Calc_Ship_Trx_Amt;
5379:
5380:
5381: /*=============================================================================

Line 5472: APP_EXCEPTION.RAISE_EXCEPTION;

5468: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5469: 'Invoice_id = '|| to_char(p_invoice_id)
5470: ||', Shipment_id = '|| to_char(p_line_location_id));
5471: END IF;
5472: APP_EXCEPTION.RAISE_EXCEPTION;
5473: END Calc_Max_Rate_Var;
5474:
5475:
5476: /*=============================================================================

Line 5629: APP_EXCEPTION.RAISE_EXCEPTION;

5625: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5626: 'Invoice_id = '|| to_char(p_invoice_id)
5627: ||', Shipment_id = '|| to_char(p_line_location_id));
5628: END IF;
5629: APP_EXCEPTION.RAISE_EXCEPTION;
5630: END Calc_Ship_Total_Base_Amt_Var;
5631:
5632: /*============================================================================
5633: | PROCEDURE CALC_SHIP_TRX_BASE_AMT

Line 5790: APP_EXCEPTION.RAISE_EXCEPTION;

5786: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5787: 'Invoice_id = '|| to_char(p_invoice_id)
5788: ||', Shipment_id = '|| to_char(p_line_location_id));
5789: END IF;
5790: APP_EXCEPTION.RAISE_EXCEPTION;
5791: END Calc_Ship_Trx_Base_Amt;
5792:
5793: --Bug 5077550
5794:

Line 5831: APP_EXCEPTION.RAISE_EXCEPTION;

5827: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
5828: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5829: 'Invoice_id = '|| to_char(p_invoice_id));
5830: END IF;
5831: APP_EXCEPTION.RAISE_EXCEPTION;
5832: END;
5833:
5834: return (l_check);
5835:

Line 5845: APP_EXCEPTION.RAISE_EXCEPTION;

5841: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
5842: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5843: 'Invoice_id = '|| to_char(p_invoice_id));
5844: END IF;
5845: APP_EXCEPTION.RAISE_EXCEPTION;
5846: END Check_Milestone_Price_Qty;
5847:
5848: -- 7299826 EnC Project
5849: PROCEDURE exec_pay_when_paid_check(p_invoice_id IN NUMBER,

Line 5889: APP_EXCEPTION.raise_exception;

5885: x_pay_when_paid => l_hold_required);
5886:
5887: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5888: Print_Debug(l_debug_loc, 'error occured while pay when paid check for po_heade_id : '||i.po_header_id );
5889: APP_EXCEPTION.raise_exception;
5890: END IF;
5891:
5892: EXIT WHEN l_hold_required = 'Y';
5893:

Line 5922: APP_EXCEPTION.raise_exception;

5918: FND_MESSAGE.set_token('PARAMETERS', 'Invoice_id = '|| to_char(p_invoice_id) );
5919: FND_MESSAGE.set_token('DEBUG_INFO',l_debug_info);
5920: END IF;
5921:
5922: APP_EXCEPTION.raise_exception;
5923:
5924: END exec_pay_when_paid_check;
5925:
5926: -- 7299826 EnC Project

Line 5968: APP_EXCEPTION.raise_exception;

5964: x_hold_required => l_hold_required);
5965:
5966: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5967: Print_Debug(l_debug_loc, 'error occured while po deliverable check for po_heade_id : '||i.po_header_id );
5968: APP_EXCEPTION.raise_exception;
5969: END IF;
5970:
5971: EXIT WHEN l_hold_required = 'Y';
5972:

Line 6001: APP_EXCEPTION.raise_exception;

5997: FND_MESSAGE.set_token('PARAMETERS', 'Invoice_id = '|| to_char(p_invoice_id) );
5998: FND_MESSAGE.set_token('DEBUG_INFO',l_debug_info);
5999: END IF;
6000:
6001: APP_EXCEPTION.raise_exception;
6002:
6003: END exec_po_deliverable_check;
6004:
6005: -- 7299826 EnC Project