DBA Data[Home] [Help]

APPS.OTA_TFH_API_SHD dependencies on FND_MESSAGE

Line 37: fnd_message.set_name('OTA','OTA_13362_TFH_SUPER_INVALID');

33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'OTA_FINANCE_HEADERS_FK1') Then
37: fnd_message.set_name('OTA','OTA_13362_TFH_SUPER_INVALID');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'OTA_FINANCE_HEADERS_FK2') Then
40: fnd_message.set_name('OTA','OTA_13268_TFH_INVALID_ORG');
41: fnd_message.raise_error;

Line 38: fnd_message.raise_error;

34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'OTA_FINANCE_HEADERS_FK1') Then
37: fnd_message.set_name('OTA','OTA_13362_TFH_SUPER_INVALID');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'OTA_FINANCE_HEADERS_FK2') Then
40: fnd_message.set_name('OTA','OTA_13268_TFH_INVALID_ORG');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'OTA_FINANCE_HEADERS_PK') Then

Line 40: fnd_message.set_name('OTA','OTA_13268_TFH_INVALID_ORG');

36: If (p_constraint_name = 'OTA_FINANCE_HEADERS_FK1') Then
37: fnd_message.set_name('OTA','OTA_13362_TFH_SUPER_INVALID');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'OTA_FINANCE_HEADERS_FK2') Then
40: fnd_message.set_name('OTA','OTA_13268_TFH_INVALID_ORG');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'OTA_FINANCE_HEADERS_PK') Then
43: fnd_message.set_name('OTA','');
44: fnd_message.raise_error;

Line 41: fnd_message.raise_error;

37: fnd_message.set_name('OTA','OTA_13362_TFH_SUPER_INVALID');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'OTA_FINANCE_HEADERS_FK2') Then
40: fnd_message.set_name('OTA','OTA_13268_TFH_INVALID_ORG');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'OTA_FINANCE_HEADERS_PK') Then
43: fnd_message.set_name('OTA','');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_TFH_CANCELLED_FLAG_CHK') Then

Line 43: fnd_message.set_name('OTA','');

39: ElsIf (p_constraint_name = 'OTA_FINANCE_HEADERS_FK2') Then
40: fnd_message.set_name('OTA','OTA_13268_TFH_INVALID_ORG');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'OTA_FINANCE_HEADERS_PK') Then
43: fnd_message.set_name('OTA','');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_TFH_CANCELLED_FLAG_CHK') Then
46: fnd_message.set_name('OTA','OTA_13255_TFH_INVALID_CANCEL');
47: fnd_message.raise_error;

Line 44: fnd_message.raise_error;

40: fnd_message.set_name('OTA','OTA_13268_TFH_INVALID_ORG');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'OTA_FINANCE_HEADERS_PK') Then
43: fnd_message.set_name('OTA','');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_TFH_CANCELLED_FLAG_CHK') Then
46: fnd_message.set_name('OTA','OTA_13255_TFH_INVALID_CANCEL');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'OTA_TFH_PAYMENT_STATUS_FLA_CHK') Then

Line 46: fnd_message.set_name('OTA','OTA_13255_TFH_INVALID_CANCEL');

42: ElsIf (p_constraint_name = 'OTA_FINANCE_HEADERS_PK') Then
43: fnd_message.set_name('OTA','');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_TFH_CANCELLED_FLAG_CHK') Then
46: fnd_message.set_name('OTA','OTA_13255_TFH_INVALID_CANCEL');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'OTA_TFH_PAYMENT_STATUS_FLA_CHK') Then
49: fnd_message.set_name('OTA','OTA_13248_TFH_INVALID_PAY_STA');
50: fnd_message.raise_error;

Line 47: fnd_message.raise_error;

43: fnd_message.set_name('OTA','');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_TFH_CANCELLED_FLAG_CHK') Then
46: fnd_message.set_name('OTA','OTA_13255_TFH_INVALID_CANCEL');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'OTA_TFH_PAYMENT_STATUS_FLA_CHK') Then
49: fnd_message.set_name('OTA','OTA_13248_TFH_INVALID_PAY_STA');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'OTA_TFH_TRANSFER_STATUS_CHK') Then

Line 49: fnd_message.set_name('OTA','OTA_13248_TFH_INVALID_PAY_STA');

45: ElsIf (p_constraint_name = 'OTA_TFH_CANCELLED_FLAG_CHK') Then
46: fnd_message.set_name('OTA','OTA_13255_TFH_INVALID_CANCEL');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'OTA_TFH_PAYMENT_STATUS_FLA_CHK') Then
49: fnd_message.set_name('OTA','OTA_13248_TFH_INVALID_PAY_STA');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'OTA_TFH_TRANSFER_STATUS_CHK') Then
52: fnd_message.set_name('OTA','OTA_13232_TFH_INVALID_TRANS_ST');
53: fnd_message.raise_error;

Line 50: fnd_message.raise_error;

46: fnd_message.set_name('OTA','OTA_13255_TFH_INVALID_CANCEL');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'OTA_TFH_PAYMENT_STATUS_FLA_CHK') Then
49: fnd_message.set_name('OTA','OTA_13248_TFH_INVALID_PAY_STA');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'OTA_TFH_TRANSFER_STATUS_CHK') Then
52: fnd_message.set_name('OTA','OTA_13232_TFH_INVALID_TRANS_ST');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'OTA_TFH_TYPE_CHK') Then

Line 52: fnd_message.set_name('OTA','OTA_13232_TFH_INVALID_TRANS_ST');

48: ElsIf (p_constraint_name = 'OTA_TFH_PAYMENT_STATUS_FLA_CHK') Then
49: fnd_message.set_name('OTA','OTA_13248_TFH_INVALID_PAY_STA');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'OTA_TFH_TRANSFER_STATUS_CHK') Then
52: fnd_message.set_name('OTA','OTA_13232_TFH_INVALID_TRANS_ST');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'OTA_TFH_TYPE_CHK') Then
55: fnd_message.set_name('OTA','OTA_13230_TFH_INVALID_TYPE');
56: fnd_message.raise_error;

Line 53: fnd_message.raise_error;

49: fnd_message.set_name('OTA','OTA_13248_TFH_INVALID_PAY_STA');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'OTA_TFH_TRANSFER_STATUS_CHK') Then
52: fnd_message.set_name('OTA','OTA_13232_TFH_INVALID_TRANS_ST');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'OTA_TFH_TYPE_CHK') Then
55: fnd_message.set_name('OTA','OTA_13230_TFH_INVALID_TYPE');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'OTA_TFH_RECEIVABLE_TYPE_CHK') Then

Line 55: fnd_message.set_name('OTA','OTA_13230_TFH_INVALID_TYPE');

51: ElsIf (p_constraint_name = 'OTA_TFH_TRANSFER_STATUS_CHK') Then
52: fnd_message.set_name('OTA','OTA_13232_TFH_INVALID_TRANS_ST');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'OTA_TFH_TYPE_CHK') Then
55: fnd_message.set_name('OTA','OTA_13230_TFH_INVALID_TYPE');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'OTA_TFH_RECEIVABLE_TYPE_CHK') Then
58: fnd_message.set_name('OTA','OTA_13463_TFH_WRONG_REC_TYPE');
59: fnd_message.raise_error;

Line 56: fnd_message.raise_error;

52: fnd_message.set_name('OTA','OTA_13232_TFH_INVALID_TRANS_ST');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'OTA_TFH_TYPE_CHK') Then
55: fnd_message.set_name('OTA','OTA_13230_TFH_INVALID_TYPE');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'OTA_TFH_RECEIVABLE_TYPE_CHK') Then
58: fnd_message.set_name('OTA','OTA_13463_TFH_WRONG_REC_TYPE');
59: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'OTA_TFH_RECEIVABLE_ATTRIBUTES') Then

Line 58: fnd_message.set_name('OTA','OTA_13463_TFH_WRONG_REC_TYPE');

54: ElsIf (p_constraint_name = 'OTA_TFH_TYPE_CHK') Then
55: fnd_message.set_name('OTA','OTA_13230_TFH_INVALID_TYPE');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'OTA_TFH_RECEIVABLE_TYPE_CHK') Then
58: fnd_message.set_name('OTA','OTA_13463_TFH_WRONG_REC_TYPE');
59: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'OTA_TFH_RECEIVABLE_ATTRIBUTES') Then
61: fnd_message.set_name('OTA','OTA_13282_TFH_RECEIVABLE_ATTS');
62: fnd_message.raise_error;

Line 59: fnd_message.raise_error;

55: fnd_message.set_name('OTA','OTA_13230_TFH_INVALID_TYPE');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'OTA_TFH_RECEIVABLE_TYPE_CHK') Then
58: fnd_message.set_name('OTA','OTA_13463_TFH_WRONG_REC_TYPE');
59: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'OTA_TFH_RECEIVABLE_ATTRIBUTES') Then
61: fnd_message.set_name('OTA','OTA_13282_TFH_RECEIVABLE_ATTS');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'OTA_TFH_PAYABLE_ATTRIBUTES') Then

Line 61: fnd_message.set_name('OTA','OTA_13282_TFH_RECEIVABLE_ATTS');

57: ElsIf (p_constraint_name = 'OTA_TFH_RECEIVABLE_TYPE_CHK') Then
58: fnd_message.set_name('OTA','OTA_13463_TFH_WRONG_REC_TYPE');
59: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'OTA_TFH_RECEIVABLE_ATTRIBUTES') Then
61: fnd_message.set_name('OTA','OTA_13282_TFH_RECEIVABLE_ATTS');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'OTA_TFH_PAYABLE_ATTRIBUTES') Then
64: fnd_message.set_name('OTA','OTA_13277_TFH_PAYABLE_ATTS');
65: fnd_message.raise_error;

Line 62: fnd_message.raise_error;

58: fnd_message.set_name('OTA','OTA_13463_TFH_WRONG_REC_TYPE');
59: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'OTA_TFH_RECEIVABLE_ATTRIBUTES') Then
61: fnd_message.set_name('OTA','OTA_13282_TFH_RECEIVABLE_ATTS');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'OTA_TFH_PAYABLE_ATTRIBUTES') Then
64: fnd_message.set_name('OTA','OTA_13277_TFH_PAYABLE_ATTS');
65: fnd_message.raise_error;
66: ElsIf (p_constraint_name = 'OTA_TFH_CANCELLED_ATTRIBUTES') Then

Line 64: fnd_message.set_name('OTA','OTA_13277_TFH_PAYABLE_ATTS');

60: ElsIf (p_constraint_name = 'OTA_TFH_RECEIVABLE_ATTRIBUTES') Then
61: fnd_message.set_name('OTA','OTA_13282_TFH_RECEIVABLE_ATTS');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'OTA_TFH_PAYABLE_ATTRIBUTES') Then
64: fnd_message.set_name('OTA','OTA_13277_TFH_PAYABLE_ATTS');
65: fnd_message.raise_error;
66: ElsIf (p_constraint_name = 'OTA_TFH_CANCELLED_ATTRIBUTES') Then
67: fnd_message.set_name('OTA','OTA_13279_TFH_CANCEL_ATTS');
68: fnd_message.raise_error;

Line 65: fnd_message.raise_error;

61: fnd_message.set_name('OTA','OTA_13282_TFH_RECEIVABLE_ATTS');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'OTA_TFH_PAYABLE_ATTRIBUTES') Then
64: fnd_message.set_name('OTA','OTA_13277_TFH_PAYABLE_ATTS');
65: fnd_message.raise_error;
66: ElsIf (p_constraint_name = 'OTA_TFH_CANCELLED_ATTRIBUTES') Then
67: fnd_message.set_name('OTA','OTA_13279_TFH_CANCEL_ATTS');
68: fnd_message.raise_error;
69: ElsIf (p_constraint_name = 'OTA_TFH_CHECK_TRANSFER_ATTRIBUTES') Then

Line 67: fnd_message.set_name('OTA','OTA_13279_TFH_CANCEL_ATTS');

63: ElsIf (p_constraint_name = 'OTA_TFH_PAYABLE_ATTRIBUTES') Then
64: fnd_message.set_name('OTA','OTA_13277_TFH_PAYABLE_ATTS');
65: fnd_message.raise_error;
66: ElsIf (p_constraint_name = 'OTA_TFH_CANCELLED_ATTRIBUTES') Then
67: fnd_message.set_name('OTA','OTA_13279_TFH_CANCEL_ATTS');
68: fnd_message.raise_error;
69: ElsIf (p_constraint_name = 'OTA_TFH_CHECK_TRANSFER_ATTRIBUTES') Then
70: fnd_message.set_name('OTA','OTA_13363_TFH_TRANS_ATTS');
71: fnd_message.raise_error;

Line 68: fnd_message.raise_error;

64: fnd_message.set_name('OTA','OTA_13277_TFH_PAYABLE_ATTS');
65: fnd_message.raise_error;
66: ElsIf (p_constraint_name = 'OTA_TFH_CANCELLED_ATTRIBUTES') Then
67: fnd_message.set_name('OTA','OTA_13279_TFH_CANCEL_ATTS');
68: fnd_message.raise_error;
69: ElsIf (p_constraint_name = 'OTA_TFH_CHECK_TRANSFER_ATTRIBUTES') Then
70: fnd_message.set_name('OTA','OTA_13363_TFH_TRANS_ATTS');
71: fnd_message.raise_error;
72: Else

Line 70: fnd_message.set_name('OTA','OTA_13363_TFH_TRANS_ATTS');

66: ElsIf (p_constraint_name = 'OTA_TFH_CANCELLED_ATTRIBUTES') Then
67: fnd_message.set_name('OTA','OTA_13279_TFH_CANCEL_ATTS');
68: fnd_message.raise_error;
69: ElsIf (p_constraint_name = 'OTA_TFH_CHECK_TRANSFER_ATTRIBUTES') Then
70: fnd_message.set_name('OTA','OTA_13363_TFH_TRANS_ATTS');
71: fnd_message.raise_error;
72: Else
73: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
74: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 71: fnd_message.raise_error;

67: fnd_message.set_name('OTA','OTA_13279_TFH_CANCEL_ATTS');
68: fnd_message.raise_error;
69: ElsIf (p_constraint_name = 'OTA_TFH_CHECK_TRANSFER_ATTRIBUTES') Then
70: fnd_message.set_name('OTA','OTA_13363_TFH_TRANS_ATTS');
71: fnd_message.raise_error;
72: Else
73: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
74: hr_utility.set_message_token('PROCEDURE', l_proc);
75: hr_utility.set_message_token('STEP',p_constraint_name);