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');
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');
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;
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');
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');
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;
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');
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');
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;
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');
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');
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;
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','');
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;
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
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;
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
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;
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
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;
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
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');
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;
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');
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');
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;
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');
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');
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;
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');
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');
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;
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');
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');
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;
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');
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;
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
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;
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
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;
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
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;
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
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);
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);