DBA Data[Home] [Help]

APPS.OTA_TFL_API_SHD dependencies on FND_MESSAGE

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

33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'OTA_FINANCE_LINES_FK1') Then
37: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
38: fnd_message.set_token('STEP','1');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK2') Then
41: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');

Line 38: fnd_message.set_token('STEP','1');

34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'OTA_FINANCE_LINES_FK1') Then
37: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
38: fnd_message.set_token('STEP','1');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK2') Then
41: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
42: fnd_message.set_token('STEP','2');

Line 39: fnd_message.raise_error;

35: --
36: If (p_constraint_name = 'OTA_FINANCE_LINES_FK1') Then
37: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
38: fnd_message.set_token('STEP','1');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK2') Then
41: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
42: fnd_message.set_token('STEP','2');
43: fnd_message.raise_error;

Line 41: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');

37: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
38: fnd_message.set_token('STEP','1');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK2') Then
41: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
42: fnd_message.set_token('STEP','2');
43: fnd_message.raise_error;
44: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK3') Then
45: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');

Line 42: fnd_message.set_token('STEP','2');

38: fnd_message.set_token('STEP','1');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK2') Then
41: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
42: fnd_message.set_token('STEP','2');
43: fnd_message.raise_error;
44: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK3') Then
45: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
46: fnd_message.set_token('STEP','3');

Line 43: fnd_message.raise_error;

39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK2') Then
41: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
42: fnd_message.set_token('STEP','2');
43: fnd_message.raise_error;
44: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK3') Then
45: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
46: fnd_message.set_token('STEP','3');
47: fnd_message.raise_error;

Line 45: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');

41: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
42: fnd_message.set_token('STEP','2');
43: fnd_message.raise_error;
44: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK3') Then
45: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
46: fnd_message.set_token('STEP','3');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK4') Then
49: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');

Line 46: fnd_message.set_token('STEP','3');

42: fnd_message.set_token('STEP','2');
43: fnd_message.raise_error;
44: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK3') Then
45: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
46: fnd_message.set_token('STEP','3');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK4') Then
49: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
50: fnd_message.set_token('STEP','4');

Line 47: fnd_message.raise_error;

43: fnd_message.raise_error;
44: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK3') Then
45: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
46: fnd_message.set_token('STEP','3');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK4') Then
49: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
50: fnd_message.set_token('STEP','4');
51: fnd_message.raise_error;

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

45: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
46: fnd_message.set_token('STEP','3');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK4') Then
49: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
50: fnd_message.set_token('STEP','4');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK5') Then
53: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');

Line 50: fnd_message.set_token('STEP','4');

46: fnd_message.set_token('STEP','3');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK4') Then
49: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
50: fnd_message.set_token('STEP','4');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK5') Then
53: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
54: fnd_message.set_token('STEP','5');

Line 51: fnd_message.raise_error;

47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK4') Then
49: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
50: fnd_message.set_token('STEP','4');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK5') Then
53: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
54: fnd_message.set_token('STEP','5');
55: fnd_message.raise_error;

Line 53: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');

49: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
50: fnd_message.set_token('STEP','4');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK5') Then
53: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
54: fnd_message.set_token('STEP','5');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_PK') Then
57: fnd_message.set_name('OTA','');

Line 54: fnd_message.set_token('STEP','5');

50: fnd_message.set_token('STEP','4');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK5') Then
53: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
54: fnd_message.set_token('STEP','5');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_PK') Then
57: fnd_message.set_name('OTA','');
58: fnd_message.raise_error;

Line 55: fnd_message.raise_error;

51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK5') Then
53: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
54: fnd_message.set_token('STEP','5');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_PK') Then
57: fnd_message.set_name('OTA','');
58: fnd_message.raise_error;
59: ElsIf (p_constraint_name = 'OTA_TFL_CANCELLED_FLAG_CHK') Then

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

53: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
54: fnd_message.set_token('STEP','5');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_PK') Then
57: fnd_message.set_name('OTA','');
58: fnd_message.raise_error;
59: ElsIf (p_constraint_name = 'OTA_TFL_CANCELLED_FLAG_CHK') Then
60: fnd_message.set_name('OTA','OTA_13255_TFH_INVALID_CANCEL');
61: fnd_message.raise_error;

Line 58: fnd_message.raise_error;

54: fnd_message.set_token('STEP','5');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_PK') Then
57: fnd_message.set_name('OTA','');
58: fnd_message.raise_error;
59: ElsIf (p_constraint_name = 'OTA_TFL_CANCELLED_FLAG_CHK') Then
60: fnd_message.set_name('OTA','OTA_13255_TFH_INVALID_CANCEL');
61: fnd_message.raise_error;
62: ElsIf (p_constraint_name = 'OTA_TFL_LINE_TYPE_CHK') Then

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

56: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_PK') Then
57: fnd_message.set_name('OTA','');
58: fnd_message.raise_error;
59: ElsIf (p_constraint_name = 'OTA_TFL_CANCELLED_FLAG_CHK') Then
60: fnd_message.set_name('OTA','OTA_13255_TFH_INVALID_CANCEL');
61: fnd_message.raise_error;
62: ElsIf (p_constraint_name = 'OTA_TFL_LINE_TYPE_CHK') Then
63: fnd_message.set_name('OTA','OTA_13383_TFL_INVALID_TYPE');
64: fnd_message.raise_error;

Line 61: fnd_message.raise_error;

57: fnd_message.set_name('OTA','');
58: fnd_message.raise_error;
59: ElsIf (p_constraint_name = 'OTA_TFL_CANCELLED_FLAG_CHK') Then
60: fnd_message.set_name('OTA','OTA_13255_TFH_INVALID_CANCEL');
61: fnd_message.raise_error;
62: ElsIf (p_constraint_name = 'OTA_TFL_LINE_TYPE_CHK') Then
63: fnd_message.set_name('OTA','OTA_13383_TFL_INVALID_TYPE');
64: fnd_message.raise_error;
65: ElsIf (p_constraint_name = 'OTA_TFL_TRANSFER_STATUS_CHK') Then

Line 63: fnd_message.set_name('OTA','OTA_13383_TFL_INVALID_TYPE');

59: ElsIf (p_constraint_name = 'OTA_TFL_CANCELLED_FLAG_CHK') Then
60: fnd_message.set_name('OTA','OTA_13255_TFH_INVALID_CANCEL');
61: fnd_message.raise_error;
62: ElsIf (p_constraint_name = 'OTA_TFL_LINE_TYPE_CHK') Then
63: fnd_message.set_name('OTA','OTA_13383_TFL_INVALID_TYPE');
64: fnd_message.raise_error;
65: ElsIf (p_constraint_name = 'OTA_TFL_TRANSFER_STATUS_CHK') Then
66: fnd_message.set_name('OTA','OTA_13232_TFH_INVALID_TRANS_ST');
67: fnd_message.raise_error;

Line 64: fnd_message.raise_error;

60: fnd_message.set_name('OTA','OTA_13255_TFH_INVALID_CANCEL');
61: fnd_message.raise_error;
62: ElsIf (p_constraint_name = 'OTA_TFL_LINE_TYPE_CHK') Then
63: fnd_message.set_name('OTA','OTA_13383_TFL_INVALID_TYPE');
64: fnd_message.raise_error;
65: ElsIf (p_constraint_name = 'OTA_TFL_TRANSFER_STATUS_CHK') Then
66: fnd_message.set_name('OTA','OTA_13232_TFH_INVALID_TRANS_ST');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'OTA_TFL_V_AMOUNT_ATTRIBUTES') Then

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

62: ElsIf (p_constraint_name = 'OTA_TFL_LINE_TYPE_CHK') Then
63: fnd_message.set_name('OTA','OTA_13383_TFL_INVALID_TYPE');
64: fnd_message.raise_error;
65: ElsIf (p_constraint_name = 'OTA_TFL_TRANSFER_STATUS_CHK') Then
66: fnd_message.set_name('OTA','OTA_13232_TFH_INVALID_TRANS_ST');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'OTA_TFL_V_AMOUNT_ATTRIBUTES') Then
69: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
70: fnd_message.set_token('STEP','1');

Line 67: fnd_message.raise_error;

63: fnd_message.set_name('OTA','OTA_13383_TFL_INVALID_TYPE');
64: fnd_message.raise_error;
65: ElsIf (p_constraint_name = 'OTA_TFL_TRANSFER_STATUS_CHK') Then
66: fnd_message.set_name('OTA','OTA_13232_TFH_INVALID_TRANS_ST');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'OTA_TFL_V_AMOUNT_ATTRIBUTES') Then
69: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
70: fnd_message.set_token('STEP','1');
71: fnd_message.raise_error;

Line 69: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');

65: ElsIf (p_constraint_name = 'OTA_TFL_TRANSFER_STATUS_CHK') Then
66: fnd_message.set_name('OTA','OTA_13232_TFH_INVALID_TRANS_ST');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'OTA_TFL_V_AMOUNT_ATTRIBUTES') Then
69: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
70: fnd_message.set_token('STEP','1');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'OTA_TFL_E_AMOUNT_ATTRIBUTES') Then
73: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');

Line 70: fnd_message.set_token('STEP','1');

66: fnd_message.set_name('OTA','OTA_13232_TFH_INVALID_TRANS_ST');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'OTA_TFL_V_AMOUNT_ATTRIBUTES') Then
69: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
70: fnd_message.set_token('STEP','1');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'OTA_TFL_E_AMOUNT_ATTRIBUTES') Then
73: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
74: fnd_message.set_token('STEP','2');

Line 71: fnd_message.raise_error;

67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'OTA_TFL_V_AMOUNT_ATTRIBUTES') Then
69: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
70: fnd_message.set_token('STEP','1');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'OTA_TFL_E_AMOUNT_ATTRIBUTES') Then
73: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
74: fnd_message.set_token('STEP','2');
75: fnd_message.raise_error;

Line 73: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');

69: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
70: fnd_message.set_token('STEP','1');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'OTA_TFL_E_AMOUNT_ATTRIBUTES') Then
73: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
74: fnd_message.set_token('STEP','2');
75: fnd_message.raise_error;
76: ElsIf (p_constraint_name = 'OTA_TFL_P_AMOUNT_ATTRIBUTES') Then
77: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');

Line 74: fnd_message.set_token('STEP','2');

70: fnd_message.set_token('STEP','1');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'OTA_TFL_E_AMOUNT_ATTRIBUTES') Then
73: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
74: fnd_message.set_token('STEP','2');
75: fnd_message.raise_error;
76: ElsIf (p_constraint_name = 'OTA_TFL_P_AMOUNT_ATTRIBUTES') Then
77: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
78: fnd_message.set_token('STEP','3');

Line 75: fnd_message.raise_error;

71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'OTA_TFL_E_AMOUNT_ATTRIBUTES') Then
73: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
74: fnd_message.set_token('STEP','2');
75: fnd_message.raise_error;
76: ElsIf (p_constraint_name = 'OTA_TFL_P_AMOUNT_ATTRIBUTES') Then
77: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
78: fnd_message.set_token('STEP','3');
79: fnd_message.raise_error;

Line 77: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');

73: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
74: fnd_message.set_token('STEP','2');
75: fnd_message.raise_error;
76: ElsIf (p_constraint_name = 'OTA_TFL_P_AMOUNT_ATTRIBUTES') Then
77: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
78: fnd_message.set_token('STEP','3');
79: fnd_message.raise_error;
80: ElsIf (p_constraint_name = 'OTA_TFL_R_AMOUNT_ATTRIBUTES') Then
81: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');

Line 78: fnd_message.set_token('STEP','3');

74: fnd_message.set_token('STEP','2');
75: fnd_message.raise_error;
76: ElsIf (p_constraint_name = 'OTA_TFL_P_AMOUNT_ATTRIBUTES') Then
77: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
78: fnd_message.set_token('STEP','3');
79: fnd_message.raise_error;
80: ElsIf (p_constraint_name = 'OTA_TFL_R_AMOUNT_ATTRIBUTES') Then
81: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
82: fnd_message.set_token('STEP','4');

Line 79: fnd_message.raise_error;

75: fnd_message.raise_error;
76: ElsIf (p_constraint_name = 'OTA_TFL_P_AMOUNT_ATTRIBUTES') Then
77: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
78: fnd_message.set_token('STEP','3');
79: fnd_message.raise_error;
80: ElsIf (p_constraint_name = 'OTA_TFL_R_AMOUNT_ATTRIBUTES') Then
81: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
82: fnd_message.set_token('STEP','4');
83: fnd_message.raise_error;

Line 81: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');

77: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
78: fnd_message.set_token('STEP','3');
79: fnd_message.raise_error;
80: ElsIf (p_constraint_name = 'OTA_TFL_R_AMOUNT_ATTRIBUTES') Then
81: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
82: fnd_message.set_token('STEP','4');
83: fnd_message.raise_error;
84: ElsIf (p_constraint_name = 'OTA_TFL_O_AMOUNT_ATTRIBUTES') Then
85: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');

Line 82: fnd_message.set_token('STEP','4');

78: fnd_message.set_token('STEP','3');
79: fnd_message.raise_error;
80: ElsIf (p_constraint_name = 'OTA_TFL_R_AMOUNT_ATTRIBUTES') Then
81: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
82: fnd_message.set_token('STEP','4');
83: fnd_message.raise_error;
84: ElsIf (p_constraint_name = 'OTA_TFL_O_AMOUNT_ATTRIBUTES') Then
85: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
86: fnd_message.set_token('STEP','5');

Line 83: fnd_message.raise_error;

79: fnd_message.raise_error;
80: ElsIf (p_constraint_name = 'OTA_TFL_R_AMOUNT_ATTRIBUTES') Then
81: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
82: fnd_message.set_token('STEP','4');
83: fnd_message.raise_error;
84: ElsIf (p_constraint_name = 'OTA_TFL_O_AMOUNT_ATTRIBUTES') Then
85: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
86: fnd_message.set_token('STEP','5');
87: fnd_message.raise_error;

Line 85: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');

81: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
82: fnd_message.set_token('STEP','4');
83: fnd_message.raise_error;
84: ElsIf (p_constraint_name = 'OTA_TFL_O_AMOUNT_ATTRIBUTES') Then
85: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
86: fnd_message.set_token('STEP','5');
87: fnd_message.raise_error;
88: ElsIf (p_constraint_name = 'OTA_TFL_CHECK_ENROLL_ATTR') Then
89: fnd_message.set_name('OTA','OTA_13350_TFL_ENROLLMENT_ATTR');

Line 86: fnd_message.set_token('STEP','5');

82: fnd_message.set_token('STEP','4');
83: fnd_message.raise_error;
84: ElsIf (p_constraint_name = 'OTA_TFL_O_AMOUNT_ATTRIBUTES') Then
85: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
86: fnd_message.set_token('STEP','5');
87: fnd_message.raise_error;
88: ElsIf (p_constraint_name = 'OTA_TFL_CHECK_ENROLL_ATTR') Then
89: fnd_message.set_name('OTA','OTA_13350_TFL_ENROLLMENT_ATTR');
90: fnd_message.raise_error;

Line 87: fnd_message.raise_error;

83: fnd_message.raise_error;
84: ElsIf (p_constraint_name = 'OTA_TFL_O_AMOUNT_ATTRIBUTES') Then
85: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
86: fnd_message.set_token('STEP','5');
87: fnd_message.raise_error;
88: ElsIf (p_constraint_name = 'OTA_TFL_CHECK_ENROLL_ATTR') Then
89: fnd_message.set_name('OTA','OTA_13350_TFL_ENROLLMENT_ATTR');
90: fnd_message.raise_error;
91: ElsIf (p_constraint_name = 'OTA_TFL_CHECK_PRE_PURCH_ATTR') Then

Line 89: fnd_message.set_name('OTA','OTA_13350_TFL_ENROLLMENT_ATTR');

85: fnd_message.set_name('OTA','OTA_13372_TFL_AMT_ATTRIBUTES');
86: fnd_message.set_token('STEP','5');
87: fnd_message.raise_error;
88: ElsIf (p_constraint_name = 'OTA_TFL_CHECK_ENROLL_ATTR') Then
89: fnd_message.set_name('OTA','OTA_13350_TFL_ENROLLMENT_ATTR');
90: fnd_message.raise_error;
91: ElsIf (p_constraint_name = 'OTA_TFL_CHECK_PRE_PURCH_ATTR') Then
92: fnd_message.set_name('OTA','OTA_13349_TFL_PRE_PURCH_ATTR');
93: fnd_message.raise_error;

Line 90: fnd_message.raise_error;

86: fnd_message.set_token('STEP','5');
87: fnd_message.raise_error;
88: ElsIf (p_constraint_name = 'OTA_TFL_CHECK_ENROLL_ATTR') Then
89: fnd_message.set_name('OTA','OTA_13350_TFL_ENROLLMENT_ATTR');
90: fnd_message.raise_error;
91: ElsIf (p_constraint_name = 'OTA_TFL_CHECK_PRE_PURCH_ATTR') Then
92: fnd_message.set_name('OTA','OTA_13349_TFL_PRE_PURCH_ATTR');
93: fnd_message.raise_error;
94: ElsIf (p_constraint_name = 'OTA_TFL_CHECK_PAYMENT_ATTR') Then

Line 92: fnd_message.set_name('OTA','OTA_13349_TFL_PRE_PURCH_ATTR');

88: ElsIf (p_constraint_name = 'OTA_TFL_CHECK_ENROLL_ATTR') Then
89: fnd_message.set_name('OTA','OTA_13350_TFL_ENROLLMENT_ATTR');
90: fnd_message.raise_error;
91: ElsIf (p_constraint_name = 'OTA_TFL_CHECK_PRE_PURCH_ATTR') Then
92: fnd_message.set_name('OTA','OTA_13349_TFL_PRE_PURCH_ATTR');
93: fnd_message.raise_error;
94: ElsIf (p_constraint_name = 'OTA_TFL_CHECK_PAYMENT_ATTR') Then
95: fnd_message.set_name('OTA','OTA_13353_TFL_VENDOR_PAY_ATTR');
96: fnd_message.raise_error;

Line 93: fnd_message.raise_error;

89: fnd_message.set_name('OTA','OTA_13350_TFL_ENROLLMENT_ATTR');
90: fnd_message.raise_error;
91: ElsIf (p_constraint_name = 'OTA_TFL_CHECK_PRE_PURCH_ATTR') Then
92: fnd_message.set_name('OTA','OTA_13349_TFL_PRE_PURCH_ATTR');
93: fnd_message.raise_error;
94: ElsIf (p_constraint_name = 'OTA_TFL_CHECK_PAYMENT_ATTR') Then
95: fnd_message.set_name('OTA','OTA_13353_TFL_VENDOR_PAY_ATTR');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'OTA_TFL_CHECK_OTHER_ATTR') Then

Line 95: fnd_message.set_name('OTA','OTA_13353_TFL_VENDOR_PAY_ATTR');

91: ElsIf (p_constraint_name = 'OTA_TFL_CHECK_PRE_PURCH_ATTR') Then
92: fnd_message.set_name('OTA','OTA_13349_TFL_PRE_PURCH_ATTR');
93: fnd_message.raise_error;
94: ElsIf (p_constraint_name = 'OTA_TFL_CHECK_PAYMENT_ATTR') Then
95: fnd_message.set_name('OTA','OTA_13353_TFL_VENDOR_PAY_ATTR');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'OTA_TFL_CHECK_OTHER_ATTR') Then
98: fnd_message.set_name('OTA','Invalid-attributes');
99: fnd_message.raise_error;

Line 96: fnd_message.raise_error;

92: fnd_message.set_name('OTA','OTA_13349_TFL_PRE_PURCH_ATTR');
93: fnd_message.raise_error;
94: ElsIf (p_constraint_name = 'OTA_TFL_CHECK_PAYMENT_ATTR') Then
95: fnd_message.set_name('OTA','OTA_13353_TFL_VENDOR_PAY_ATTR');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'OTA_TFL_CHECK_OTHER_ATTR') Then
98: fnd_message.set_name('OTA','Invalid-attributes');
99: fnd_message.raise_error;
100: Else

Line 98: fnd_message.set_name('OTA','Invalid-attributes');

94: ElsIf (p_constraint_name = 'OTA_TFL_CHECK_PAYMENT_ATTR') Then
95: fnd_message.set_name('OTA','OTA_13353_TFL_VENDOR_PAY_ATTR');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'OTA_TFL_CHECK_OTHER_ATTR') Then
98: fnd_message.set_name('OTA','Invalid-attributes');
99: fnd_message.raise_error;
100: Else
101: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
102: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 99: fnd_message.raise_error;

95: fnd_message.set_name('OTA','OTA_13353_TFL_VENDOR_PAY_ATTR');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'OTA_TFL_CHECK_OTHER_ATTR') Then
98: fnd_message.set_name('OTA','Invalid-attributes');
99: fnd_message.raise_error;
100: Else
101: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
102: hr_utility.set_message_token('PROCEDURE', l_proc);
103: hr_utility.set_message_token('STEP',p_constraint_name);