DBA Data[Home] [Help]

APPS.AP_RETRO_PRICING_PKG dependencies on FND_MESSAGE

Line 207: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

203: EXCEPTION
204: --
205: WHEN OTHERS THEN
206: IF (SQLCODE <> -20001 ) THEN
207: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
208: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
209: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
210: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );
211: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)

Line 208: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

204: --
205: WHEN OTHERS THEN
206: IF (SQLCODE <> -20001 ) THEN
207: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
208: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
209: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
210: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );
211: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)
212: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)

Line 209: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

205: WHEN OTHERS THEN
206: IF (SQLCODE <> -20001 ) THEN
207: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
208: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
209: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
210: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );
211: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)
212: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)
213: ||',p_po_header_id: '||TO_CHAR(p_po_header_id)

Line 210: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );

206: IF (SQLCODE <> -20001 ) THEN
207: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
208: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
209: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
210: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );
211: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)
212: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)
213: ||',p_po_header_id: '||TO_CHAR(p_po_header_id)
214: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)

Line 211: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)

207: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
208: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
209: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
210: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );
211: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)
212: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)
213: ||',p_po_header_id: '||TO_CHAR(p_po_header_id)
214: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)
215: ||',p_po_release_id: '||TO_CHAR(p_po_release_id)

Line 440: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

436:
437: WHEN OTHERS THEN
438:
439: IF (SQLCODE <> -20001 ) THEN
440: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
441: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
442: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
443: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );
444: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)

Line 441: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

437: WHEN OTHERS THEN
438:
439: IF (SQLCODE <> -20001 ) THEN
440: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
441: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
442: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
443: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );
444: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)
445: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)

Line 442: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

438:
439: IF (SQLCODE <> -20001 ) THEN
440: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
441: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
442: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
443: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );
444: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)
445: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)
446: ||',p_po_header_id: '||TO_CHAR(p_po_header_id)

Line 443: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );

439: IF (SQLCODE <> -20001 ) THEN
440: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
441: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
442: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
443: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );
444: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)
445: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)
446: ||',p_po_header_id: '||TO_CHAR(p_po_header_id)
447: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)

Line 444: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)

440: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
441: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
442: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
443: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );
444: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)
445: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)
446: ||',p_po_header_id: '||TO_CHAR(p_po_header_id)
447: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)
448: ||',p_po_release_id: '||TO_CHAR(p_po_release_id)

Line 620: FND_MESSAGE.SET_NAME('SQLAP', 'ALLOW_PAID_INVOICE_ADJUST');

616: FROM ap_system_parameters_all
617: WHERE org_id = l_org_id_list(i);
618:
619: IF l_allow_paid_invoice_adjust = 'N' THEN
620: FND_MESSAGE.SET_NAME('SQLAP', 'ALLOW_PAID_INVOICE_ADJUST');
621: RAISE Allow_paid_Invoice_Adjust;
622: END IF;
623:
624:

Line 718: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET);

714: --
715: EXCEPTION
716: WHEN Allow_paid_Invoice_Adjust THEN
717:
718: FND_FILE.PUT_LINE(FND_FILE.LOG, fnd_message.GET);
719: debug_info := 'In Allow_paid_Invoice_Adjust Exception';
720: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
721: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,debug_info);
722: END IF;

Line 728: l_msg := FND_MESSAGE.GET;

724:
725: RETURN TRUE;
726:
727: WHEN request_submission_failure THEN
728: l_msg := FND_MESSAGE.GET;
729: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
730: FND_MESSAGE.SET_TOKEN('ERROR',l_msg);
731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
732: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );

Line 729: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

725: RETURN TRUE;
726:
727: WHEN request_submission_failure THEN
728: l_msg := FND_MESSAGE.GET;
729: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
730: FND_MESSAGE.SET_TOKEN('ERROR',l_msg);
731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
732: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );
733: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)

Line 730: FND_MESSAGE.SET_TOKEN('ERROR',l_msg);

726:
727: WHEN request_submission_failure THEN
728: l_msg := FND_MESSAGE.GET;
729: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
730: FND_MESSAGE.SET_TOKEN('ERROR',l_msg);
731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
732: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );
733: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)
734: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)

Line 731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

727: WHEN request_submission_failure THEN
728: l_msg := FND_MESSAGE.GET;
729: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
730: FND_MESSAGE.SET_TOKEN('ERROR',l_msg);
731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
732: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );
733: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)
734: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)
735: ||',p_po_header_id: '||TO_CHAR(p_po_header_id)

Line 732: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );

728: l_msg := FND_MESSAGE.GET;
729: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
730: FND_MESSAGE.SET_TOKEN('ERROR',l_msg);
731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
732: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );
733: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)
734: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)
735: ||',p_po_header_id: '||TO_CHAR(p_po_header_id)
736: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)

Line 733: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)

729: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
730: FND_MESSAGE.SET_TOKEN('ERROR',l_msg);
731: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
732: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );
733: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)
734: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)
735: ||',p_po_header_id: '||TO_CHAR(p_po_header_id)
736: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)
737: ||',p_po_release_id: '||TO_CHAR(p_po_release_id)

Line 751: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

747: RETURN FALSE;
748:
749: WHEN OTHERS THEN
750: IF (SQLCODE <> -20001 ) THEN
751: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
752: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
753: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
754: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );
755: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)

Line 752: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

748:
749: WHEN OTHERS THEN
750: IF (SQLCODE <> -20001 ) THEN
751: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
752: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
753: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
754: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );
755: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)
756: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)

Line 753: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

749: WHEN OTHERS THEN
750: IF (SQLCODE <> -20001 ) THEN
751: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
752: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
753: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
754: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );
755: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)
756: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)
757: ||',p_po_header_id: '||TO_CHAR(p_po_header_id)

Line 754: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );

750: IF (SQLCODE <> -20001 ) THEN
751: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
752: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
753: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
754: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );
755: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)
756: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)
757: ||',p_po_header_id: '||TO_CHAR(p_po_header_id)
758: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)

Line 755: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)

751: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
752: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
753: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
754: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info );
755: FND_MESSAGE.SET_TOKEN('PARAMETERS','P_vendor_id: '||TO_CHAR(P_vendor_id)
756: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)
757: ||',p_po_header_id: '||TO_CHAR(p_po_header_id)
758: ||',P_vendor_site_id: '||TO_CHAR(P_vendor_site_id)
759: ||',p_po_release_id: '||TO_CHAR(p_po_release_id)

Line 1455: FND_MESSAGE.SET_NAME('SQLAP', 'AP_RETRO_IPV_REDIST');

1451: p_lines_rec.invoice_id) + 1;
1452: IF p_correcting = 'IPV' THEN
1453: l_adj_lines_rec.line_type_lookup_code := 'RETROITEM' ;
1454: --'Redistribution of IPV due to Retroactive Pricing of Purchase Order'
1455: FND_MESSAGE.SET_NAME('SQLAP', 'AP_RETRO_IPV_REDIST');
1456: l_adj_lines_rec.description := FND_MESSAGE.GET;
1457: ELSE
1458: l_adj_lines_rec.line_type_lookup_code := 'RETROTAX' ;
1459: --'Redistribution of TIPV due to Retroactive Pricing of Purchase Order'

Line 1456: l_adj_lines_rec.description := FND_MESSAGE.GET;

1452: IF p_correcting = 'IPV' THEN
1453: l_adj_lines_rec.line_type_lookup_code := 'RETROITEM' ;
1454: --'Redistribution of IPV due to Retroactive Pricing of Purchase Order'
1455: FND_MESSAGE.SET_NAME('SQLAP', 'AP_RETRO_IPV_REDIST');
1456: l_adj_lines_rec.description := FND_MESSAGE.GET;
1457: ELSE
1458: l_adj_lines_rec.line_type_lookup_code := 'RETROTAX' ;
1459: --'Redistribution of TIPV due to Retroactive Pricing of Purchase Order'
1460: FND_MESSAGE.SET_NAME('SQLAP', 'AP_RETRO_TIPV_REDIST');

Line 1460: FND_MESSAGE.SET_NAME('SQLAP', 'AP_RETRO_TIPV_REDIST');

1456: l_adj_lines_rec.description := FND_MESSAGE.GET;
1457: ELSE
1458: l_adj_lines_rec.line_type_lookup_code := 'RETROTAX' ;
1459: --'Redistribution of TIPV due to Retroactive Pricing of Purchase Order'
1460: FND_MESSAGE.SET_NAME('SQLAP', 'AP_RETRO_TIPV_REDIST');
1461: l_adj_lines_rec.description := FND_MESSAGE.GET;
1462: END IF;
1463: --
1464: l_adj_lines_rec.line_source := 'ADJUSTMENT CORRECTION';

Line 1461: l_adj_lines_rec.description := FND_MESSAGE.GET;

1457: ELSE
1458: l_adj_lines_rec.line_type_lookup_code := 'RETROTAX' ;
1459: --'Redistribution of TIPV due to Retroactive Pricing of Purchase Order'
1460: FND_MESSAGE.SET_NAME('SQLAP', 'AP_RETRO_TIPV_REDIST');
1461: l_adj_lines_rec.description := FND_MESSAGE.GET;
1462: END IF;
1463: --
1464: l_adj_lines_rec.line_source := 'ADJUSTMENT CORRECTION';
1465: l_adj_lines_rec.generate_dists := 'D';

Line 2088: FND_MESSAGE.SET_NAME('SQLAP', 'AP_RETRO_IPV_REVERSAL');

2084: l_adj_dists_list(i).line_type_lookup_code := 'IPV';
2085: l_adj_dists_list(i).dist_match_type := 'ADJUSTMENT_CORRECTION';
2086:
2087: --'Reversal of IPV due to Retroactive Pricing of Purchase Order'
2088: FND_MESSAGE.SET_NAME('SQLAP', 'AP_RETRO_IPV_REVERSAL');
2089: l_adj_dists_list(i).description := FND_MESSAGE.GET;
2090:
2091: l_adj_dists_list(i).dist_code_combination_id := l_ipv_dists_list(i).dist_code_combination_id;
2092:

Line 2089: l_adj_dists_list(i).description := FND_MESSAGE.GET;

2085: l_adj_dists_list(i).dist_match_type := 'ADJUSTMENT_CORRECTION';
2086:
2087: --'Reversal of IPV due to Retroactive Pricing of Purchase Order'
2088: FND_MESSAGE.SET_NAME('SQLAP', 'AP_RETRO_IPV_REVERSAL');
2089: l_adj_dists_list(i).description := FND_MESSAGE.GET;
2090:
2091: l_adj_dists_list(i).dist_code_combination_id := l_ipv_dists_list(i).dist_code_combination_id;
2092:
2093: l_adj_dists_list(i).accounting_date := SYSDATE;

Line 2552: FND_MESSAGE.SET_NAME('SQLAP', 'AP_RETRO_TIPV_REVERSAL');

2548: l_tipv_adj_dists_list(i).line_type_lookup_code := 'TIPV';
2549: l_tipv_adj_dists_list(i).dist_match_type := 'ADJUSTMENT_CORRECTION';
2550:
2551: --'Reversal of TIPV due to Retroactive Pricing of Purchase Order'
2552: FND_MESSAGE.SET_NAME('SQLAP', 'AP_RETRO_TIPV_REVERSAL');
2553: l_tipv_adj_dists_list(i).description := FND_MESSAGE.GET;
2554:
2555: l_tipv_adj_dists_list(i).dist_code_combination_id := l_tipv_dists_list(i).dist_code_combination_id;
2556:

Line 2553: l_tipv_adj_dists_list(i).description := FND_MESSAGE.GET;

2549: l_tipv_adj_dists_list(i).dist_match_type := 'ADJUSTMENT_CORRECTION';
2550:
2551: --'Reversal of TIPV due to Retroactive Pricing of Purchase Order'
2552: FND_MESSAGE.SET_NAME('SQLAP', 'AP_RETRO_TIPV_REVERSAL');
2553: l_tipv_adj_dists_list(i).description := FND_MESSAGE.GET;
2554:
2555: l_tipv_adj_dists_list(i).dist_code_combination_id := l_tipv_dists_list(i).dist_code_combination_id;
2556:
2557: l_tipv_adj_dists_list(i).accounting_date := SYSDATE;