DBA Data[Home] [Help]

APPS.AP_INVOICE_LINES_PKG dependencies on FND_MESSAGE

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

207: WHERE distribution_set_id = X_invoice_lines_rec.distribution_set_id;
208: EXCEPTION
209: WHEN NO_DATA_FOUND THEN
210: IF (SQLCODE <> -20001) THEN
211: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
212: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
213: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
214: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)
215: ||', Invoice Line Number = '||TO_CHAR(X_invoice_lines_Rec.line_Number));

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

208: EXCEPTION
209: WHEN NO_DATA_FOUND THEN
210: IF (SQLCODE <> -20001) THEN
211: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
212: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
213: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
214: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)
215: ||', Invoice Line Number = '||TO_CHAR(X_invoice_lines_Rec.line_Number));
216: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

209: WHEN NO_DATA_FOUND THEN
210: IF (SQLCODE <> -20001) THEN
211: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
212: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
213: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
214: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)
215: ||', Invoice Line Number = '||TO_CHAR(X_invoice_lines_Rec.line_Number));
216: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
217: END IF;

Line 214: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)

210: IF (SQLCODE <> -20001) THEN
211: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
212: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
213: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
214: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)
215: ||', Invoice Line Number = '||TO_CHAR(X_invoice_lines_Rec.line_Number));
216: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
217: END IF;
218: X_error_code := 'AP_DEBUG';

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

212: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
213: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
214: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)
215: ||', Invoice Line Number = '||TO_CHAR(X_invoice_lines_Rec.line_Number));
216: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
217: END IF;
218: X_error_code := 'AP_DEBUG';
219: RETURN (FALSE);
220: END;

Line 520: Fnd_Message.Set_Name(l_msg_application, l_msg_data);

516: X_msg_application := l_msg_application;
517: X_msg_data := l_msg_data;
518:
519: --bugfix:5725904
520: Fnd_Message.Set_Name(l_msg_application, l_msg_data);
521: --bug 6682104 setting the token values
522: IF (l_msg_token1 IS NOT NULL) THEN
523: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
524: ELSE

Line 523: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);

519: --bugfix:5725904
520: Fnd_Message.Set_Name(l_msg_application, l_msg_data);
521: --bug 6682104 setting the token values
522: IF (l_msg_token1 IS NOT NULL) THEN
523: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
524: ELSE
525: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);
526: END IF;
527:

Line 525: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);

521: --bug 6682104 setting the token values
522: IF (l_msg_token1 IS NOT NULL) THEN
523: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
524: ELSE
525: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);
526: END IF;
527:
528: IF (l_msg_token2 IS NOT NULL) THEN
529: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);

Line 529: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);

525: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);
526: END IF;
527:
528: IF (l_msg_token2 IS NOT NULL) THEN
529: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);
530: ELSE
531: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);
532: END IF;
533:

Line 531: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);

527:
528: IF (l_msg_token2 IS NOT NULL) THEN
529: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);
530: ELSE
531: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);
532: END IF;
533:
534: IF (l_msg_token3 IS NOT NULL) THEN
535: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);

Line 535: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);

531: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);
532: END IF;
533:
534: IF (l_msg_token3 IS NOT NULL) THEN
535: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
536: ELSE
537: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);
538: END IF;
539:

Line 537: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);

533:
534: IF (l_msg_token3 IS NOT NULL) THEN
535: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
536: ELSE
537: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);
538: END IF;
539:
540: l_message_text := Fnd_Message.get;
541: X_Error_Code := l_message_text;

Line 540: l_message_text := Fnd_Message.get;

536: ELSE
537: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);
538: END IF;
539:
540: l_message_text := Fnd_Message.get;
541: X_Error_Code := l_message_text;
542: */
543:
544: RETURN(FALSE);

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

571: Debug_info := debug_info || ': cannot read account type information';
572: X_debug_context := current_calling_sequence;
573: X_debug_info := debug_info;
574: IF (SQLCODE <> -20001) THEN
575: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
576: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
577: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
578: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)
579: ||', Invoice Line Number = '||TO_CHAR(X_invoice_lines_Rec.line_Number));

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

572: X_debug_context := current_calling_sequence;
573: X_debug_info := debug_info;
574: IF (SQLCODE <> -20001) THEN
575: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
576: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
577: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
578: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)
579: ||', Invoice Line Number = '||TO_CHAR(X_invoice_lines_Rec.line_Number));
580: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

573: X_debug_info := debug_info;
574: IF (SQLCODE <> -20001) THEN
575: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
576: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
577: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
578: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)
579: ||', Invoice Line Number = '||TO_CHAR(X_invoice_lines_Rec.line_Number));
580: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
581: END IF;

Line 578: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)

574: IF (SQLCODE <> -20001) THEN
575: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
576: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
577: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
578: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)
579: ||', Invoice Line Number = '||TO_CHAR(X_invoice_lines_Rec.line_Number));
580: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
581: END IF;
582: X_error_code := 'AP_DEBUG';

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

576: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
577: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
578: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)
579: ||', Invoice Line Number = '||TO_CHAR(X_invoice_lines_Rec.line_Number));
580: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
581: END IF;
582: X_error_code := 'AP_DEBUG';
583: RETURN(FALSE);
584: END;

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

647: || ': cannot read account type information';
648: X_debug_context := current_calling_sequence;
649: X_debug_info := debug_info;
650: IF (SQLCODE <> -20001) THEN
651: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
652: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
653: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
654: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)
655: ||', Invoice Line Number = '||TO_CHAR(X_invoice_lines_Rec.line_Number));

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

648: X_debug_context := current_calling_sequence;
649: X_debug_info := debug_info;
650: IF (SQLCODE <> -20001) THEN
651: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
652: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
653: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
654: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)
655: ||', Invoice Line Number = '||TO_CHAR(X_invoice_lines_Rec.line_Number));
656: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

649: X_debug_info := debug_info;
650: IF (SQLCODE <> -20001) THEN
651: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
652: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
653: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
654: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)
655: ||', Invoice Line Number = '||TO_CHAR(X_invoice_lines_Rec.line_Number));
656: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
657: --Bug7539216

Line 654: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)

650: IF (SQLCODE <> -20001) THEN
651: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
652: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
653: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
654: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)
655: ||', Invoice Line Number = '||TO_CHAR(X_invoice_lines_Rec.line_Number));
656: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
657: --Bug7539216
658: X_error_code := FND_MESSAGE.GET;

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

652: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
653: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
654: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)
655: ||', Invoice Line Number = '||TO_CHAR(X_invoice_lines_Rec.line_Number));
656: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
657: --Bug7539216
658: X_error_code := FND_MESSAGE.GET;
659: ELSE
660: X_error_code := 'AP_DEBUG';

Line 658: X_error_code := FND_MESSAGE.GET;

654: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)
655: ||', Invoice Line Number = '||TO_CHAR(X_invoice_lines_Rec.line_Number));
656: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
657: --Bug7539216
658: X_error_code := FND_MESSAGE.GET;
659: ELSE
660: X_error_code := 'AP_DEBUG';
661: --End of Bug7539216
662: END IF;

Line 832: Fnd_Message.Set_Name(l_msg_application, l_msg_data);

828: X_msg_application := l_msg_application;
829: X_msg_data := l_msg_data;
830:
831: --bugfix:5725904
832: Fnd_Message.Set_Name(l_msg_application, l_msg_data);
833: --bug 6682104 setting the token values
834: IF (l_msg_token1 IS NOT NULL) THEN
835: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
836: ELSE

Line 835: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);

831: --bugfix:5725904
832: Fnd_Message.Set_Name(l_msg_application, l_msg_data);
833: --bug 6682104 setting the token values
834: IF (l_msg_token1 IS NOT NULL) THEN
835: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
836: ELSE
837: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);
838: END IF;
839:

Line 837: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);

833: --bug 6682104 setting the token values
834: IF (l_msg_token1 IS NOT NULL) THEN
835: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
836: ELSE
837: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);
838: END IF;
839:
840: IF (l_msg_token2 IS NOT NULL) THEN
841: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);

Line 841: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);

837: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);
838: END IF;
839:
840: IF (l_msg_token2 IS NOT NULL) THEN
841: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);
842: ELSE
843: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);
844: END IF;
845:

Line 843: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);

839:
840: IF (l_msg_token2 IS NOT NULL) THEN
841: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);
842: ELSE
843: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);
844: END IF;
845:
846: IF (l_msg_token3 IS NOT NULL) THEN
847: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);

Line 847: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);

843: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);
844: END IF;
845:
846: IF (l_msg_token3 IS NOT NULL) THEN
847: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
848: ELSE
849: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);
850: END IF;
851: l_message_text := Fnd_Message.get;

Line 849: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);

845:
846: IF (l_msg_token3 IS NOT NULL) THEN
847: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
848: ELSE
849: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);
850: END IF;
851: l_message_text := Fnd_Message.get;
852: x_error_code := l_message_text;
853: */

Line 851: l_message_text := Fnd_Message.get;

847: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
848: ELSE
849: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);
850: END IF;
851: l_message_text := Fnd_Message.get;
852: x_error_code := l_message_text;
853: */
854:
855: RETURN(FALSE);

Line 931: Fnd_Message.Set_Name(l_msg_application, l_msg_data);

927: X_msg_application := l_msg_application;
928: X_msg_data := l_msg_data;
929:
930: --bugfix:5725904
931: Fnd_Message.Set_Name(l_msg_application, l_msg_data);
932: --bug 6682104 setting the token values
933: IF (l_msg_token1 IS NOT NULL) THEN
934: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
935: ELSE

Line 934: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);

930: --bugfix:5725904
931: Fnd_Message.Set_Name(l_msg_application, l_msg_data);
932: --bug 6682104 setting the token values
933: IF (l_msg_token1 IS NOT NULL) THEN
934: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
935: ELSE
936: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);
937: END IF;
938:

Line 936: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);

932: --bug 6682104 setting the token values
933: IF (l_msg_token1 IS NOT NULL) THEN
934: fnd_message.set_token('PATC_MSG_TOKEN1',l_msg_token1);
935: ELSE
936: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);
937: END IF;
938:
939: IF (l_msg_token2 IS NOT NULL) THEN
940: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);

Line 940: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);

936: fnd_message.set_token('PATC_MSG_TOKEN1',FND_API.G_MISS_CHAR);
937: END IF;
938:
939: IF (l_msg_token2 IS NOT NULL) THEN
940: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);
941: ELSE
942: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);
943: END IF;
944:

Line 942: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);

938:
939: IF (l_msg_token2 IS NOT NULL) THEN
940: fnd_message.set_token('PATC_MSG_TOKEN2',l_msg_token2);
941: ELSE
942: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);
943: END IF;
944:
945: IF (l_msg_token3 IS NOT NULL) THEN
946: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);

Line 946: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);

942: fnd_message.set_token('PATC_MSG_TOKEN2',FND_API.G_MISS_CHAR);
943: END IF;
944:
945: IF (l_msg_token3 IS NOT NULL) THEN
946: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
947: ELSE
948: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);
949: END IF;
950: l_message_text := Fnd_Message.get;

Line 948: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);

944:
945: IF (l_msg_token3 IS NOT NULL) THEN
946: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
947: ELSE
948: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);
949: END IF;
950: l_message_text := Fnd_Message.get;
951: x_error_code := l_message_text;
952: */

Line 950: l_message_text := Fnd_Message.get;

946: fnd_message.set_token('PATC_MSG_TOKEN3',l_msg_token3);
947: ELSE
948: fnd_message.set_token('PATC_MSG_TOKEN3',FND_API.G_MISS_CHAR);
949: END IF;
950: l_message_text := Fnd_Message.get;
951: x_error_code := l_message_text;
952: */
953:
954: RETURN(FALSE);

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

1011: Debug_info := 'Error occurred';
1012: X_debug_context := current_calling_sequence;
1013: X_debug_info := debug_info;
1014: IF (SQLCODE <> -20001) THEN
1015: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1016: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1017: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1018: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)
1019: ||', Invoice Line Number =

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

1012: X_debug_context := current_calling_sequence;
1013: X_debug_info := debug_info;
1014: IF (SQLCODE <> -20001) THEN
1015: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1016: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1017: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1018: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)
1019: ||', Invoice Line Number =
1020: '||TO_CHAR(X_invoice_lines_Rec.line_Number));

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

1013: X_debug_info := debug_info;
1014: IF (SQLCODE <> -20001) THEN
1015: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1016: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1017: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1018: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)
1019: ||', Invoice Line Number =
1020: '||TO_CHAR(X_invoice_lines_Rec.line_Number));
1021: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

Line 1018: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)

1014: IF (SQLCODE <> -20001) THEN
1015: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1016: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1017: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1018: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)
1019: ||', Invoice Line Number =
1020: '||TO_CHAR(X_invoice_lines_Rec.line_Number));
1021: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1022: END IF;

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

1017: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1018: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_lines_Rec.invoice_id)
1019: ||', Invoice Line Number =
1020: '||TO_CHAR(X_invoice_lines_Rec.line_Number));
1021: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1022: END IF;
1023: X_error_code := 'AP_DEBUG';
1024: RETURN(FALSE);
1025:

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

1278: IF (X_line_number IS NULL) THEN
1279: debug_info := debug_info ||': No Line Info is provided';
1280: X_debug_context := current_calling_sequence;
1281: X_debug_info := debug_info;
1282: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1283: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1284: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1285: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));
1286: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

1279: debug_info := debug_info ||': No Line Info is provided';
1280: X_debug_context := current_calling_sequence;
1281: X_debug_info := debug_info;
1282: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1283: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1284: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1285: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));
1286: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1287: X_error_code := 'AP_DEBUG';

Line 1284: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)

1280: X_debug_context := current_calling_sequence;
1281: X_debug_info := debug_info;
1282: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1283: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1284: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1285: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));
1286: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1287: X_error_code := 'AP_DEBUG';
1288: RETURN(FALSE);

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

1282: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1283: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1284: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1285: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));
1286: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1287: X_error_code := 'AP_DEBUG';
1288: RETURN(FALSE);
1289: ELSE
1290: BEGIN

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

1301: debug_info := debug_info ||': No valid line record was found.';
1302: X_debug_context := current_calling_sequence;
1303: X_debug_info := debug_info;
1304: IF (SQLCODE <> -20001) THEN
1305: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1306: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1307: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1308: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1309: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));

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

1302: X_debug_context := current_calling_sequence;
1303: X_debug_info := debug_info;
1304: IF (SQLCODE <> -20001) THEN
1305: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1306: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1307: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1308: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1309: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));
1310: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

1303: X_debug_info := debug_info;
1304: IF (SQLCODE <> -20001) THEN
1305: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1306: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1307: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1308: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1309: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));
1310: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1311: END IF;

Line 1308: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)

1304: IF (SQLCODE <> -20001) THEN
1305: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1306: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1307: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1308: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1309: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));
1310: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1311: END IF;
1312: X_error_code := 'AP_DEBUG';

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

1306: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1307: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1308: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1309: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));
1310: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1311: END IF;
1312: X_error_code := 'AP_DEBUG';
1313: RETURN(FALSE);
1314: END;

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

1373: Debug_info := debug_info || ': Cannot read Dist Set';
1374: X_debug_context := current_calling_sequence;
1375: X_debug_info := debug_info;
1376: IF (SQLCODE <> -20001) THEN
1377: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1378: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1379: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1380: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1381: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));

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

1374: X_debug_context := current_calling_sequence;
1375: X_debug_info := debug_info;
1376: IF (SQLCODE <> -20001) THEN
1377: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1378: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1379: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1380: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1381: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));
1382: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

1375: X_debug_info := debug_info;
1376: IF (SQLCODE <> -20001) THEN
1377: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1378: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1379: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1380: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1381: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));
1382: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1383: END IF;

Line 1380: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)

1376: IF (SQLCODE <> -20001) THEN
1377: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1378: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1379: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1380: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1381: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));
1382: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1383: END IF;
1384: X_error_code := 'AP_DEBUG';

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

1378: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1379: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1380: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1381: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));
1382: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1383: END IF;
1384: X_error_code := 'AP_DEBUG';
1385: RETURN(FALSE);
1386: END;

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

1437: Debug_info := debug_info || ': cannot read invoice information';
1438: X_debug_context := current_calling_sequence;
1439: X_debug_info := debug_info;
1440: IF (SQLCODE <> -20001) THEN
1441: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1442: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1443: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1444: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1445: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));

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

1438: X_debug_context := current_calling_sequence;
1439: X_debug_info := debug_info;
1440: IF (SQLCODE <> -20001) THEN
1441: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1442: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1443: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1444: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1445: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));
1446: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

1439: X_debug_info := debug_info;
1440: IF (SQLCODE <> -20001) THEN
1441: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1442: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1443: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1444: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1445: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));
1446: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1447: END IF;

Line 1444: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)

1440: IF (SQLCODE <> -20001) THEN
1441: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1442: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1443: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1444: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1445: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));
1446: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1447: END IF;
1448: X_error_code := 'AP_DEBUG';

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

1442: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1443: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1444: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1445: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));
1446: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1447: END IF;
1448: X_error_code := 'AP_DEBUG';
1449: RETURN(FALSE);
1450:

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

1472: Debug_info := debug_info || ': No GL information was found';
1473: X_debug_context := current_calling_sequence;
1474: X_debug_info := debug_info;
1475: IF (SQLCODE <> -20001) THEN
1476: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1477: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1478: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1479: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1480: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));

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

1473: X_debug_context := current_calling_sequence;
1474: X_debug_info := debug_info;
1475: IF (SQLCODE <> -20001) THEN
1476: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1477: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1478: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1479: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1480: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));
1481: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

1474: X_debug_info := debug_info;
1475: IF (SQLCODE <> -20001) THEN
1476: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1477: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1478: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1479: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1480: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));
1481: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1482: END IF;

Line 1479: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)

1475: IF (SQLCODE <> -20001) THEN
1476: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1477: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1478: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1479: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1480: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));
1481: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1482: END IF;
1483: X_error_code := 'AP_DEBUG';

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

1477: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1478: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1479: FND_MESSAGE.SET_TOKEN('PARAMETERS','Invoice Id = '||TO_CHAR(X_invoice_id)
1480: ||', Invoice Line Number = '||TO_CHAR(X_line_Number));
1481: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1482: END IF;
1483: X_error_code := 'AP_DEBUG';
1484: RETURN(FALSE);
1485: END;

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

1575:
1576: EXCEPTION
1577: WHEN OTHERS THEN
1578: IF (SQLCODE <> -20001) THEN
1579: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1580: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1581: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1582: current_calling_sequence);
1583: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

1576: EXCEPTION
1577: WHEN OTHERS THEN
1578: IF (SQLCODE <> -20001) THEN
1579: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1580: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1581: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1582: current_calling_sequence);
1583: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1584: 'X_GL_Date = ' ||TO_CHAR(X_GL_Date)

Line 1581: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

1577: WHEN OTHERS THEN
1578: IF (SQLCODE <> -20001) THEN
1579: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1580: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1581: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1582: current_calling_sequence);
1583: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1584: 'X_GL_Date = ' ||TO_CHAR(X_GL_Date)
1585: ||', X_Period_Name = ' ||X_Period_Name

Line 1583: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1579: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1580: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1581: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1582: current_calling_sequence);
1583: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1584: 'X_GL_Date = ' ||TO_CHAR(X_GL_Date)
1585: ||', X_Period_Name = ' ||X_Period_Name
1586: ||', X_Invoice_Id = ' ||TO_CHAR(X_invoice_id)
1587: );

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

1584: 'X_GL_Date = ' ||TO_CHAR(X_GL_Date)
1585: ||', X_Period_Name = ' ||X_Period_Name
1586: ||', X_Invoice_Id = ' ||TO_CHAR(X_invoice_id)
1587: );
1588: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1589: END IF;
1590: APP_EXCEPTION.RAISE_EXCEPTION;
1591:
1592: END insert_from_dist_set;

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

1777:
1778: EXCEPTION
1779: WHEN OTHERS THEN
1780: IF (SQLCODE <> -20001) THEN
1781: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1782: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1783: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1784: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1785: 'Invoice Id = ' || TO_CHAR(X_Invoice_Id));

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

1778: EXCEPTION
1779: WHEN OTHERS THEN
1780: IF (SQLCODE <> -20001) THEN
1781: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1782: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1783: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1784: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1785: 'Invoice Id = ' || TO_CHAR(X_Invoice_Id));
1786: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);

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

1779: WHEN OTHERS THEN
1780: IF (SQLCODE <> -20001) THEN
1781: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1782: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1783: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1784: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1785: 'Invoice Id = ' || TO_CHAR(X_Invoice_Id));
1786: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1787: END IF;

Line 1784: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1780: IF (SQLCODE <> -20001) THEN
1781: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
1782: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1783: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1784: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1785: 'Invoice Id = ' || TO_CHAR(X_Invoice_Id));
1786: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1787: END IF;
1788: debug_info := debug_info || 'Error occurred';

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

1782: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
1783: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1784: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1785: 'Invoice Id = ' || TO_CHAR(X_Invoice_Id));
1786: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', debug_info);
1787: END IF;
1788: debug_info := debug_info || 'Error occurred';
1789: X_debug_context := current_calling_sequence;
1790: X_debug_info := debug_info;

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

5057:
5058: EXCEPTION
5059: WHEN OTHERS THEN
5060: IF (SQLCODE <> -20001) THEN
5061: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5062: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5063: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5064: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5065: ' P_invoice_id = ' || p_line_rec.invoice_id

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

5058: EXCEPTION
5059: WHEN OTHERS THEN
5060: IF (SQLCODE <> -20001) THEN
5061: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5062: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5063: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5064: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5065: ' P_invoice_id = ' || p_line_rec.invoice_id
5066: ||' P_line_number = ' || p_line_rec.line_number

Line 5063: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

5059: WHEN OTHERS THEN
5060: IF (SQLCODE <> -20001) THEN
5061: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5062: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5063: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5064: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5065: ' P_invoice_id = ' || p_line_rec.invoice_id
5066: ||' P_line_number = ' || p_line_rec.line_number
5067: ||' P_last_updated_by = ' || P_last_updated_by

Line 5064: FND_MESSAGE.SET_TOKEN('PARAMETERS',

5060: IF (SQLCODE <> -20001) THEN
5061: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5062: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5063: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
5064: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5065: ' P_invoice_id = ' || p_line_rec.invoice_id
5066: ||' P_line_number = ' || p_line_rec.line_number
5067: ||' P_last_updated_by = ' || P_last_updated_by
5068: ||' P_last_update_login = ' || P_last_update_login

Line 5070: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

5066: ||' P_line_number = ' || p_line_rec.line_number
5067: ||' P_last_updated_by = ' || P_last_updated_by
5068: ||' P_last_update_login = ' || P_last_update_login
5069: ||' P_calling_mode = ' || p_calling_mode);
5070: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
5071: END IF;
5072:
5073: IF ( po_dists_cur%ISOPEN ) THEN
5074: CLOSE po_dists_cur;

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

5602:
5603: 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);
5608: FND_MESSAGE.SET_TOKEN ('CALLING_SEQUENCE',l_curr_calling_sequence);
5609: FND_MESSAGE.SET_TOKEN ('PARAMETERS',
5610: ' P_invoice_id = '|| p_inv_line_rec.invoice_id

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

5603: 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);
5608: FND_MESSAGE.SET_TOKEN ('CALLING_SEQUENCE',l_curr_calling_sequence);
5609: FND_MESSAGE.SET_TOKEN ('PARAMETERS',
5610: ' P_invoice_id = '|| p_inv_line_rec.invoice_id
5611: ||' P_line_number = '|| p_inv_line_rec.line_number

Line 5608: FND_MESSAGE.SET_TOKEN ('CALLING_SEQUENCE',l_curr_calling_sequence);

5604: WHEN OTHERS THEN
5605: IF (SQLCODE <> -20001) THEN
5606: FND_MESSAGE.SET_NAME ('SQLAP','AP_DEBUG');
5607: FND_MESSAGE.SET_TOKEN ('ERROR',SQLERRM);
5608: FND_MESSAGE.SET_TOKEN ('CALLING_SEQUENCE',l_curr_calling_sequence);
5609: FND_MESSAGE.SET_TOKEN ('PARAMETERS',
5610: ' P_invoice_id = '|| p_inv_line_rec.invoice_id
5611: ||' P_line_number = '|| p_inv_line_rec.line_number
5612: ||' P_calling_mode = '|| p_calling_mode);

Line 5609: FND_MESSAGE.SET_TOKEN ('PARAMETERS',

5605: IF (SQLCODE <> -20001) THEN
5606: FND_MESSAGE.SET_NAME ('SQLAP','AP_DEBUG');
5607: FND_MESSAGE.SET_TOKEN ('ERROR',SQLERRM);
5608: FND_MESSAGE.SET_TOKEN ('CALLING_SEQUENCE',l_curr_calling_sequence);
5609: FND_MESSAGE.SET_TOKEN ('PARAMETERS',
5610: ' P_invoice_id = '|| p_inv_line_rec.invoice_id
5611: ||' P_line_number = '|| p_inv_line_rec.line_number
5612: ||' P_calling_mode = '|| p_calling_mode);
5613: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 5613: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

5609: FND_MESSAGE.SET_TOKEN ('PARAMETERS',
5610: ' P_invoice_id = '|| p_inv_line_rec.invoice_id
5611: ||' P_line_number = '|| p_inv_line_rec.line_number
5612: ||' P_calling_mode = '|| p_calling_mode);
5613: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
5614: END IF;
5615:
5616: x_debug_info := l_debug_info;
5617: