DBA Data[Home] [Help]

APPS.OE_VALIDATE_ADJ dependencies on FND_API

Line 20: FND_API.g_attr_tbl.DELETE;

16: IS
17: I NUMBER:=0;
18: BEGIN
19:
20: FND_API.g_attr_tbl.DELETE;
21:
22: -- START GEN attributes
23:
24: -- Generator will append new attributes before end generate comment.

Line 27: FND_API.g_attr_tbl(I).name := 'created_by';

23:
24: -- Generator will append new attributes before end generate comment.
25:
26: I := I + 1;
27: FND_API.g_attr_tbl(I).name := 'created_by';
28: I := I + 1;
29: FND_API.g_attr_tbl(I).name := 'creation_date';
30: I := I + 1;
31: FND_API.g_attr_tbl(I).name := 'desc_flex';

Line 29: FND_API.g_attr_tbl(I).name := 'creation_date';

25:
26: I := I + 1;
27: FND_API.g_attr_tbl(I).name := 'created_by';
28: I := I + 1;
29: FND_API.g_attr_tbl(I).name := 'creation_date';
30: I := I + 1;
31: FND_API.g_attr_tbl(I).name := 'desc_flex';
32: I := I + 1;
33: FND_API.g_attr_tbl(I).name := 'header';

Line 31: FND_API.g_attr_tbl(I).name := 'desc_flex';

27: FND_API.g_attr_tbl(I).name := 'created_by';
28: I := I + 1;
29: FND_API.g_attr_tbl(I).name := 'creation_date';
30: I := I + 1;
31: FND_API.g_attr_tbl(I).name := 'desc_flex';
32: I := I + 1;
33: FND_API.g_attr_tbl(I).name := 'header';
34: I := I + 1;
35: FND_API.g_attr_tbl(I).name := 'last_updated_by';

Line 33: FND_API.g_attr_tbl(I).name := 'header';

29: FND_API.g_attr_tbl(I).name := 'creation_date';
30: I := I + 1;
31: FND_API.g_attr_tbl(I).name := 'desc_flex';
32: I := I + 1;
33: FND_API.g_attr_tbl(I).name := 'header';
34: I := I + 1;
35: FND_API.g_attr_tbl(I).name := 'last_updated_by';
36: I := I + 1;
37: FND_API.g_attr_tbl(I).name := 'last_update_date';

Line 35: FND_API.g_attr_tbl(I).name := 'last_updated_by';

31: FND_API.g_attr_tbl(I).name := 'desc_flex';
32: I := I + 1;
33: FND_API.g_attr_tbl(I).name := 'header';
34: I := I + 1;
35: FND_API.g_attr_tbl(I).name := 'last_updated_by';
36: I := I + 1;
37: FND_API.g_attr_tbl(I).name := 'last_update_date';
38: I := I + 1;
39: FND_API.g_attr_tbl(I).name := 'last_update_login';

Line 37: FND_API.g_attr_tbl(I).name := 'last_update_date';

33: FND_API.g_attr_tbl(I).name := 'header';
34: I := I + 1;
35: FND_API.g_attr_tbl(I).name := 'last_updated_by';
36: I := I + 1;
37: FND_API.g_attr_tbl(I).name := 'last_update_date';
38: I := I + 1;
39: FND_API.g_attr_tbl(I).name := 'last_update_login';
40: I := I + 1;
41: FND_API.g_attr_tbl(I).name := 'program_application';

Line 39: FND_API.g_attr_tbl(I).name := 'last_update_login';

35: FND_API.g_attr_tbl(I).name := 'last_updated_by';
36: I := I + 1;
37: FND_API.g_attr_tbl(I).name := 'last_update_date';
38: I := I + 1;
39: FND_API.g_attr_tbl(I).name := 'last_update_login';
40: I := I + 1;
41: FND_API.g_attr_tbl(I).name := 'program_application';
42: I := I + 1;
43: FND_API.g_attr_tbl(I).name := 'program';

Line 41: FND_API.g_attr_tbl(I).name := 'program_application';

37: FND_API.g_attr_tbl(I).name := 'last_update_date';
38: I := I + 1;
39: FND_API.g_attr_tbl(I).name := 'last_update_login';
40: I := I + 1;
41: FND_API.g_attr_tbl(I).name := 'program_application';
42: I := I + 1;
43: FND_API.g_attr_tbl(I).name := 'program';
44: I := I + 1;
45: FND_API.g_attr_tbl(I).name := 'program_update_date';

Line 43: FND_API.g_attr_tbl(I).name := 'program';

39: FND_API.g_attr_tbl(I).name := 'last_update_login';
40: I := I + 1;
41: FND_API.g_attr_tbl(I).name := 'program_application';
42: I := I + 1;
43: FND_API.g_attr_tbl(I).name := 'program';
44: I := I + 1;
45: FND_API.g_attr_tbl(I).name := 'program_update_date';
46: I := I + 1;
47: FND_API.g_attr_tbl(I).name := 'request_date';

Line 45: FND_API.g_attr_tbl(I).name := 'program_update_date';

41: FND_API.g_attr_tbl(I).name := 'program_application';
42: I := I + 1;
43: FND_API.g_attr_tbl(I).name := 'program';
44: I := I + 1;
45: FND_API.g_attr_tbl(I).name := 'program_update_date';
46: I := I + 1;
47: FND_API.g_attr_tbl(I).name := 'request_date';
48: I := I + 1;
49: FND_API.g_attr_tbl(I).name := 'request';

Line 47: FND_API.g_attr_tbl(I).name := 'request_date';

43: FND_API.g_attr_tbl(I).name := 'program';
44: I := I + 1;
45: FND_API.g_attr_tbl(I).name := 'program_update_date';
46: I := I + 1;
47: FND_API.g_attr_tbl(I).name := 'request_date';
48: I := I + 1;
49: FND_API.g_attr_tbl(I).name := 'request';
50: I := I + 1;
51: FND_API.g_attr_tbl(I).name := 'applied_flag';

Line 49: FND_API.g_attr_tbl(I).name := 'request';

45: FND_API.g_attr_tbl(I).name := 'program_update_date';
46: I := I + 1;
47: FND_API.g_attr_tbl(I).name := 'request_date';
48: I := I + 1;
49: FND_API.g_attr_tbl(I).name := 'request';
50: I := I + 1;
51: FND_API.g_attr_tbl(I).name := 'applied_flag';
52: I := I + 1;
53: FND_API.g_attr_tbl(I).name := 'automatic';

Line 51: FND_API.g_attr_tbl(I).name := 'applied_flag';

47: FND_API.g_attr_tbl(I).name := 'request_date';
48: I := I + 1;
49: FND_API.g_attr_tbl(I).name := 'request';
50: I := I + 1;
51: FND_API.g_attr_tbl(I).name := 'applied_flag';
52: I := I + 1;
53: FND_API.g_attr_tbl(I).name := 'automatic';
54: I := I + 1;
55: FND_API.g_attr_tbl(I).name := 'change_reason_code';

Line 53: FND_API.g_attr_tbl(I).name := 'automatic';

49: FND_API.g_attr_tbl(I).name := 'request';
50: I := I + 1;
51: FND_API.g_attr_tbl(I).name := 'applied_flag';
52: I := I + 1;
53: FND_API.g_attr_tbl(I).name := 'automatic';
54: I := I + 1;
55: FND_API.g_attr_tbl(I).name := 'change_reason_code';
56: I := I + 1;
57: FND_API.g_attr_tbl(I).name := 'change_reason_text';

Line 55: FND_API.g_attr_tbl(I).name := 'change_reason_code';

51: FND_API.g_attr_tbl(I).name := 'applied_flag';
52: I := I + 1;
53: FND_API.g_attr_tbl(I).name := 'automatic';
54: I := I + 1;
55: FND_API.g_attr_tbl(I).name := 'change_reason_code';
56: I := I + 1;
57: FND_API.g_attr_tbl(I).name := 'change_reason_text';
58: I := I + 1;
59: FND_API.g_attr_tbl(I).name := 'discount';

Line 57: FND_API.g_attr_tbl(I).name := 'change_reason_text';

53: FND_API.g_attr_tbl(I).name := 'automatic';
54: I := I + 1;
55: FND_API.g_attr_tbl(I).name := 'change_reason_code';
56: I := I + 1;
57: FND_API.g_attr_tbl(I).name := 'change_reason_text';
58: I := I + 1;
59: FND_API.g_attr_tbl(I).name := 'discount';
60: I := I + 1;
61: FND_API.g_attr_tbl(I).name := 'discount_line';

Line 59: FND_API.g_attr_tbl(I).name := 'discount';

55: FND_API.g_attr_tbl(I).name := 'change_reason_code';
56: I := I + 1;
57: FND_API.g_attr_tbl(I).name := 'change_reason_text';
58: I := I + 1;
59: FND_API.g_attr_tbl(I).name := 'discount';
60: I := I + 1;
61: FND_API.g_attr_tbl(I).name := 'discount_line';
62: I := I + 1;
63: FND_API.g_attr_tbl(I).name := 'line';

Line 61: FND_API.g_attr_tbl(I).name := 'discount_line';

57: FND_API.g_attr_tbl(I).name := 'change_reason_text';
58: I := I + 1;
59: FND_API.g_attr_tbl(I).name := 'discount';
60: I := I + 1;
61: FND_API.g_attr_tbl(I).name := 'discount_line';
62: I := I + 1;
63: FND_API.g_attr_tbl(I).name := 'line';
64: I := I + 1;
65: FND_API.g_attr_tbl(I).name := 'list_header_id';

Line 63: FND_API.g_attr_tbl(I).name := 'line';

59: FND_API.g_attr_tbl(I).name := 'discount';
60: I := I + 1;
61: FND_API.g_attr_tbl(I).name := 'discount_line';
62: I := I + 1;
63: FND_API.g_attr_tbl(I).name := 'line';
64: I := I + 1;
65: FND_API.g_attr_tbl(I).name := 'list_header_id';
66: I := I + 1;
67: FND_API.g_attr_tbl(I).name := 'list_line_id';

Line 65: FND_API.g_attr_tbl(I).name := 'list_header_id';

61: FND_API.g_attr_tbl(I).name := 'discount_line';
62: I := I + 1;
63: FND_API.g_attr_tbl(I).name := 'line';
64: I := I + 1;
65: FND_API.g_attr_tbl(I).name := 'list_header_id';
66: I := I + 1;
67: FND_API.g_attr_tbl(I).name := 'list_line_id';
68: I := I + 1;
69: FND_API.g_attr_tbl(I).name := 'list_line_type_code';

Line 67: FND_API.g_attr_tbl(I).name := 'list_line_id';

63: FND_API.g_attr_tbl(I).name := 'line';
64: I := I + 1;
65: FND_API.g_attr_tbl(I).name := 'list_header_id';
66: I := I + 1;
67: FND_API.g_attr_tbl(I).name := 'list_line_id';
68: I := I + 1;
69: FND_API.g_attr_tbl(I).name := 'list_line_type_code';
70: I := I + 1;
71: FND_API.g_attr_tbl(I).name := 'modified_from';

Line 69: FND_API.g_attr_tbl(I).name := 'list_line_type_code';

65: FND_API.g_attr_tbl(I).name := 'list_header_id';
66: I := I + 1;
67: FND_API.g_attr_tbl(I).name := 'list_line_id';
68: I := I + 1;
69: FND_API.g_attr_tbl(I).name := 'list_line_type_code';
70: I := I + 1;
71: FND_API.g_attr_tbl(I).name := 'modified_from';
72: I := I + 1;
73: FND_API.g_attr_tbl(I).name := 'modified_to';

Line 71: FND_API.g_attr_tbl(I).name := 'modified_from';

67: FND_API.g_attr_tbl(I).name := 'list_line_id';
68: I := I + 1;
69: FND_API.g_attr_tbl(I).name := 'list_line_type_code';
70: I := I + 1;
71: FND_API.g_attr_tbl(I).name := 'modified_from';
72: I := I + 1;
73: FND_API.g_attr_tbl(I).name := 'modified_to';
74: I := I + 1;
75: FND_API.g_attr_tbl(I).name := 'modified_mechanism_type_code';

Line 73: FND_API.g_attr_tbl(I).name := 'modified_to';

69: FND_API.g_attr_tbl(I).name := 'list_line_type_code';
70: I := I + 1;
71: FND_API.g_attr_tbl(I).name := 'modified_from';
72: I := I + 1;
73: FND_API.g_attr_tbl(I).name := 'modified_to';
74: I := I + 1;
75: FND_API.g_attr_tbl(I).name := 'modified_mechanism_type_code';
76: I := I + 1;
77: FND_API.g_attr_tbl(I).name := 'percent';

Line 75: FND_API.g_attr_tbl(I).name := 'modified_mechanism_type_code';

71: FND_API.g_attr_tbl(I).name := 'modified_from';
72: I := I + 1;
73: FND_API.g_attr_tbl(I).name := 'modified_to';
74: I := I + 1;
75: FND_API.g_attr_tbl(I).name := 'modified_mechanism_type_code';
76: I := I + 1;
77: FND_API.g_attr_tbl(I).name := 'percent';
78: I := I + 1;
79: FND_API.g_attr_tbl(I).name := 'price_adjustment';

Line 77: FND_API.g_attr_tbl(I).name := 'percent';

73: FND_API.g_attr_tbl(I).name := 'modified_to';
74: I := I + 1;
75: FND_API.g_attr_tbl(I).name := 'modified_mechanism_type_code';
76: I := I + 1;
77: FND_API.g_attr_tbl(I).name := 'percent';
78: I := I + 1;
79: FND_API.g_attr_tbl(I).name := 'price_adjustment';
80: I := I + 1;
81: FND_API.g_attr_tbl(I).name := 'updated_flag';

Line 79: FND_API.g_attr_tbl(I).name := 'price_adjustment';

75: FND_API.g_attr_tbl(I).name := 'modified_mechanism_type_code';
76: I := I + 1;
77: FND_API.g_attr_tbl(I).name := 'percent';
78: I := I + 1;
79: FND_API.g_attr_tbl(I).name := 'price_adjustment';
80: I := I + 1;
81: FND_API.g_attr_tbl(I).name := 'updated_flag';
82: I := I + 1;
83: FND_API.g_attr_tbl(I).name := 'update_allowed';

Line 81: FND_API.g_attr_tbl(I).name := 'updated_flag';

77: FND_API.g_attr_tbl(I).name := 'percent';
78: I := I + 1;
79: FND_API.g_attr_tbl(I).name := 'price_adjustment';
80: I := I + 1;
81: FND_API.g_attr_tbl(I).name := 'updated_flag';
82: I := I + 1;
83: FND_API.g_attr_tbl(I).name := 'update_allowed';
84: I := I + 1;
85: FND_API.g_attr_tbl(I).name := 'adjusted_amount';

Line 83: FND_API.g_attr_tbl(I).name := 'update_allowed';

79: FND_API.g_attr_tbl(I).name := 'price_adjustment';
80: I := I + 1;
81: FND_API.g_attr_tbl(I).name := 'updated_flag';
82: I := I + 1;
83: FND_API.g_attr_tbl(I).name := 'update_allowed';
84: I := I + 1;
85: FND_API.g_attr_tbl(I).name := 'adjusted_amount';
86: I := I + 1;
87: FND_API.g_attr_tbl(I).name := 'pricing_phase_id';

Line 85: FND_API.g_attr_tbl(I).name := 'adjusted_amount';

81: FND_API.g_attr_tbl(I).name := 'updated_flag';
82: I := I + 1;
83: FND_API.g_attr_tbl(I).name := 'update_allowed';
84: I := I + 1;
85: FND_API.g_attr_tbl(I).name := 'adjusted_amount';
86: I := I + 1;
87: FND_API.g_attr_tbl(I).name := 'pricing_phase_id';
88: I := I + 1;
89: FND_API.g_attr_tbl(I).name := 'operand';

Line 87: FND_API.g_attr_tbl(I).name := 'pricing_phase_id';

83: FND_API.g_attr_tbl(I).name := 'update_allowed';
84: I := I + 1;
85: FND_API.g_attr_tbl(I).name := 'adjusted_amount';
86: I := I + 1;
87: FND_API.g_attr_tbl(I).name := 'pricing_phase_id';
88: I := I + 1;
89: FND_API.g_attr_tbl(I).name := 'operand';
90: I := I + 1;
91: FND_API.g_attr_tbl(I).name := 'arithmetic_operator';

Line 89: FND_API.g_attr_tbl(I).name := 'operand';

85: FND_API.g_attr_tbl(I).name := 'adjusted_amount';
86: I := I + 1;
87: FND_API.g_attr_tbl(I).name := 'pricing_phase_id';
88: I := I + 1;
89: FND_API.g_attr_tbl(I).name := 'operand';
90: I := I + 1;
91: FND_API.g_attr_tbl(I).name := 'arithmetic_operator';
92: I := I + 1;
93: FND_API.g_attr_tbl(I).name := 'list_line_no';

Line 91: FND_API.g_attr_tbl(I).name := 'arithmetic_operator';

87: FND_API.g_attr_tbl(I).name := 'pricing_phase_id';
88: I := I + 1;
89: FND_API.g_attr_tbl(I).name := 'operand';
90: I := I + 1;
91: FND_API.g_attr_tbl(I).name := 'arithmetic_operator';
92: I := I + 1;
93: FND_API.g_attr_tbl(I).name := 'list_line_no';
94: I := I + 1;
95: FND_API.g_attr_tbl(I).name := 'source_system_code';

Line 93: FND_API.g_attr_tbl(I).name := 'list_line_no';

89: FND_API.g_attr_tbl(I).name := 'operand';
90: I := I + 1;
91: FND_API.g_attr_tbl(I).name := 'arithmetic_operator';
92: I := I + 1;
93: FND_API.g_attr_tbl(I).name := 'list_line_no';
94: I := I + 1;
95: FND_API.g_attr_tbl(I).name := 'source_system_code';
96: I := I + 1;
97: FND_API.g_attr_tbl(I).name := 'benefit_qty';

Line 95: FND_API.g_attr_tbl(I).name := 'source_system_code';

91: FND_API.g_attr_tbl(I).name := 'arithmetic_operator';
92: I := I + 1;
93: FND_API.g_attr_tbl(I).name := 'list_line_no';
94: I := I + 1;
95: FND_API.g_attr_tbl(I).name := 'source_system_code';
96: I := I + 1;
97: FND_API.g_attr_tbl(I).name := 'benefit_qty';
98: I := I + 1;
99: FND_API.g_attr_tbl(I).name := 'benefit_uom_code';

Line 97: FND_API.g_attr_tbl(I).name := 'benefit_qty';

93: FND_API.g_attr_tbl(I).name := 'list_line_no';
94: I := I + 1;
95: FND_API.g_attr_tbl(I).name := 'source_system_code';
96: I := I + 1;
97: FND_API.g_attr_tbl(I).name := 'benefit_qty';
98: I := I + 1;
99: FND_API.g_attr_tbl(I).name := 'benefit_uom_code';
100: I := I + 1;
101: FND_API.g_attr_tbl(I).name := 'print_on_invoice_flag';

Line 99: FND_API.g_attr_tbl(I).name := 'benefit_uom_code';

95: FND_API.g_attr_tbl(I).name := 'source_system_code';
96: I := I + 1;
97: FND_API.g_attr_tbl(I).name := 'benefit_qty';
98: I := I + 1;
99: FND_API.g_attr_tbl(I).name := 'benefit_uom_code';
100: I := I + 1;
101: FND_API.g_attr_tbl(I).name := 'print_on_invoice_flag';
102: I := I + 1;
103: FND_API.g_attr_tbl(I).name := 'expiration_date';

Line 101: FND_API.g_attr_tbl(I).name := 'print_on_invoice_flag';

97: FND_API.g_attr_tbl(I).name := 'benefit_qty';
98: I := I + 1;
99: FND_API.g_attr_tbl(I).name := 'benefit_uom_code';
100: I := I + 1;
101: FND_API.g_attr_tbl(I).name := 'print_on_invoice_flag';
102: I := I + 1;
103: FND_API.g_attr_tbl(I).name := 'expiration_date';
104: I := I + 1;
105: FND_API.g_attr_tbl(I).name := 'rebate_transaction_type_code';

Line 103: FND_API.g_attr_tbl(I).name := 'expiration_date';

99: FND_API.g_attr_tbl(I).name := 'benefit_uom_code';
100: I := I + 1;
101: FND_API.g_attr_tbl(I).name := 'print_on_invoice_flag';
102: I := I + 1;
103: FND_API.g_attr_tbl(I).name := 'expiration_date';
104: I := I + 1;
105: FND_API.g_attr_tbl(I).name := 'rebate_transaction_type_code';
106: I := I + 1;
107: FND_API.g_attr_tbl(I).name := 'rebate_transaction_reference';

Line 105: FND_API.g_attr_tbl(I).name := 'rebate_transaction_type_code';

101: FND_API.g_attr_tbl(I).name := 'print_on_invoice_flag';
102: I := I + 1;
103: FND_API.g_attr_tbl(I).name := 'expiration_date';
104: I := I + 1;
105: FND_API.g_attr_tbl(I).name := 'rebate_transaction_type_code';
106: I := I + 1;
107: FND_API.g_attr_tbl(I).name := 'rebate_transaction_reference';
108: I := I + 1;
109: FND_API.g_attr_tbl(I).name := 'rebate_payment_system_code';

Line 107: FND_API.g_attr_tbl(I).name := 'rebate_transaction_reference';

103: FND_API.g_attr_tbl(I).name := 'expiration_date';
104: I := I + 1;
105: FND_API.g_attr_tbl(I).name := 'rebate_transaction_type_code';
106: I := I + 1;
107: FND_API.g_attr_tbl(I).name := 'rebate_transaction_reference';
108: I := I + 1;
109: FND_API.g_attr_tbl(I).name := 'rebate_payment_system_code';
110: I := I + 1;
111: FND_API.g_attr_tbl(I).name := 'redeemed_date';

Line 109: FND_API.g_attr_tbl(I).name := 'rebate_payment_system_code';

105: FND_API.g_attr_tbl(I).name := 'rebate_transaction_type_code';
106: I := I + 1;
107: FND_API.g_attr_tbl(I).name := 'rebate_transaction_reference';
108: I := I + 1;
109: FND_API.g_attr_tbl(I).name := 'rebate_payment_system_code';
110: I := I + 1;
111: FND_API.g_attr_tbl(I).name := 'redeemed_date';
112: I := I + 1;
113: FND_API.g_attr_tbl(I).name := 'redeemed_flag';

Line 111: FND_API.g_attr_tbl(I).name := 'redeemed_date';

107: FND_API.g_attr_tbl(I).name := 'rebate_transaction_reference';
108: I := I + 1;
109: FND_API.g_attr_tbl(I).name := 'rebate_payment_system_code';
110: I := I + 1;
111: FND_API.g_attr_tbl(I).name := 'redeemed_date';
112: I := I + 1;
113: FND_API.g_attr_tbl(I).name := 'redeemed_flag';
114: I := I + 1;
115: FND_API.g_attr_tbl(I).name := 'accrual_flag';

Line 113: FND_API.g_attr_tbl(I).name := 'redeemed_flag';

109: FND_API.g_attr_tbl(I).name := 'rebate_payment_system_code';
110: I := I + 1;
111: FND_API.g_attr_tbl(I).name := 'redeemed_date';
112: I := I + 1;
113: FND_API.g_attr_tbl(I).name := 'redeemed_flag';
114: I := I + 1;
115: FND_API.g_attr_tbl(I).name := 'accrual_flag';
116: I := I + 1;
117: FND_API.g_attr_tbl(I).name := 'range_break_quantity';

Line 115: FND_API.g_attr_tbl(I).name := 'accrual_flag';

111: FND_API.g_attr_tbl(I).name := 'redeemed_date';
112: I := I + 1;
113: FND_API.g_attr_tbl(I).name := 'redeemed_flag';
114: I := I + 1;
115: FND_API.g_attr_tbl(I).name := 'accrual_flag';
116: I := I + 1;
117: FND_API.g_attr_tbl(I).name := 'range_break_quantity';
118: I := I + 1;
119: FND_API.g_attr_tbl(I).name := 'accrual_conversion_rate';

Line 117: FND_API.g_attr_tbl(I).name := 'range_break_quantity';

113: FND_API.g_attr_tbl(I).name := 'redeemed_flag';
114: I := I + 1;
115: FND_API.g_attr_tbl(I).name := 'accrual_flag';
116: I := I + 1;
117: FND_API.g_attr_tbl(I).name := 'range_break_quantity';
118: I := I + 1;
119: FND_API.g_attr_tbl(I).name := 'accrual_conversion_rate';
120: I := I + 1;
121: FND_API.g_attr_tbl(I).name := 'pricing_group_sequence';

Line 119: FND_API.g_attr_tbl(I).name := 'accrual_conversion_rate';

115: FND_API.g_attr_tbl(I).name := 'accrual_flag';
116: I := I + 1;
117: FND_API.g_attr_tbl(I).name := 'range_break_quantity';
118: I := I + 1;
119: FND_API.g_attr_tbl(I).name := 'accrual_conversion_rate';
120: I := I + 1;
121: FND_API.g_attr_tbl(I).name := 'pricing_group_sequence';
122: I := I + 1;
123: FND_API.g_attr_tbl(I).name := 'modifier_level_code';

Line 121: FND_API.g_attr_tbl(I).name := 'pricing_group_sequence';

117: FND_API.g_attr_tbl(I).name := 'range_break_quantity';
118: I := I + 1;
119: FND_API.g_attr_tbl(I).name := 'accrual_conversion_rate';
120: I := I + 1;
121: FND_API.g_attr_tbl(I).name := 'pricing_group_sequence';
122: I := I + 1;
123: FND_API.g_attr_tbl(I).name := 'modifier_level_code';
124: I := I + 1;
125: FND_API.g_attr_tbl(I).name := 'price_break_type_code';

Line 123: FND_API.g_attr_tbl(I).name := 'modifier_level_code';

119: FND_API.g_attr_tbl(I).name := 'accrual_conversion_rate';
120: I := I + 1;
121: FND_API.g_attr_tbl(I).name := 'pricing_group_sequence';
122: I := I + 1;
123: FND_API.g_attr_tbl(I).name := 'modifier_level_code';
124: I := I + 1;
125: FND_API.g_attr_tbl(I).name := 'price_break_type_code';
126: I := I + 1;
127: FND_API.g_attr_tbl(I).name := 'substitution_attribute';

Line 125: FND_API.g_attr_tbl(I).name := 'price_break_type_code';

121: FND_API.g_attr_tbl(I).name := 'pricing_group_sequence';
122: I := I + 1;
123: FND_API.g_attr_tbl(I).name := 'modifier_level_code';
124: I := I + 1;
125: FND_API.g_attr_tbl(I).name := 'price_break_type_code';
126: I := I + 1;
127: FND_API.g_attr_tbl(I).name := 'substitution_attribute';
128: I := I + 1;
129: FND_API.g_attr_tbl(I).name := 'proration_type_code';

Line 127: FND_API.g_attr_tbl(I).name := 'substitution_attribute';

123: FND_API.g_attr_tbl(I).name := 'modifier_level_code';
124: I := I + 1;
125: FND_API.g_attr_tbl(I).name := 'price_break_type_code';
126: I := I + 1;
127: FND_API.g_attr_tbl(I).name := 'substitution_attribute';
128: I := I + 1;
129: FND_API.g_attr_tbl(I).name := 'proration_type_code';
130:
131: -- END GEN attributes

Line 129: FND_API.g_attr_tbl(I).name := 'proration_type_code';

125: FND_API.g_attr_tbl(I).name := 'price_break_type_code';
126: I := I + 1;
127: FND_API.g_attr_tbl(I).name := 'substitution_attribute';
128: I := I + 1;
129: FND_API.g_attr_tbl(I).name := 'proration_type_code';
130:
131: -- END GEN attributes
132:
133: END Get_Attr_Tbl;

Line 183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

179: ELSE
180:
181: -- In case of an unexpected error raise an exception.
182:
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184:
185: END IF;
186:
187: END IF;

Line 223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

219: , 'Desc_Flex'
220: );
221: END IF;
222:
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224:
225: END Desc_Flex;
226:
227: FUNCTION Header ( p_header_id IN NUMBER )

Line 235: p_header_id = FND_API.G_MISS_NUM

231: BEGIN
232:
233:
234: IF p_header_id IS NULL OR
235: p_header_id = FND_API.G_MISS_NUM
236: THEN
237: RETURN TRUE;
238: END IF;
239:

Line 279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

275: , 'Header'
276: );
277: END IF;
278:
279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
280:
281: END Header;
282:
283:

Line 292: p_last_updated_by = FND_API.G_MISS_NUM

288: BEGIN
289:
290:
291: IF p_last_updated_by IS NULL OR
292: p_last_updated_by = FND_API.G_MISS_NUM
293: THEN
294:
295: RETURN TRUE;
296: END IF;

Line 337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

333: );
334: END IF;
335:
336:
337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338:
339: END Last_Updated_By;
340:
341: FUNCTION Last_Update_Date ( p_last_update_date IN DATE )

Line 349: p_last_update_date = FND_API.G_MISS_DATE

345: BEGIN
346:
347:
348: IF p_last_update_date IS NULL OR
349: p_last_update_date = FND_API.G_MISS_DATE
350: THEN
351:
352: RETURN TRUE;
353: END IF;

Line 394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

390: );
391: END IF;
392:
393:
394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
395:
396: END Last_Update_Date;
397:
398: FUNCTION Last_Update_Login ( p_last_update_login IN NUMBER )

Line 406: p_last_update_login = FND_API.G_MISS_NUM

402: BEGIN
403:
404:
405: IF p_last_update_login IS NULL OR
406: p_last_update_login = FND_API.G_MISS_NUM
407: THEN
408:
409: RETURN TRUE;
410: END IF;

Line 451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

447: );
448: END IF;
449:
450:
451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
452:
453: END Last_Update_Login;
454:
455: FUNCTION Program_Application ( p_program_application_id IN NUMBER )

Line 463: p_program_application_id = FND_API.G_MISS_NUM

459: BEGIN
460:
461:
462: IF p_program_application_id IS NULL OR
463: p_program_application_id = FND_API.G_MISS_NUM
464: THEN
465:
466: RETURN TRUE;
467: END IF;

Line 508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

504: );
505: END IF;
506:
507:
508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
509:
510: END Program_Application;
511:
512: FUNCTION Program ( p_program_id IN NUMBER )

Line 520: p_program_id = FND_API.G_MISS_NUM

516: BEGIN
517:
518:
519: IF p_program_id IS NULL OR
520: p_program_id = FND_API.G_MISS_NUM
521: THEN
522:
523: RETURN TRUE;
524: END IF;

Line 565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

561: );
562: END IF;
563:
564:
565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
566:
567: END Program;
568:
569: FUNCTION Program_Update_Date ( p_program_update_date IN DATE )

Line 577: p_program_update_date = FND_API.G_MISS_DATE

573: BEGIN
574:
575:
576: IF p_program_update_date IS NULL OR
577: p_program_update_date = FND_API.G_MISS_DATE
578: THEN
579:
580: RETURN TRUE;
581: END IF;

Line 622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

618: );
619: END IF;
620:
621:
622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
623:
624: END Program_Update_Date;
625:
626: FUNCTION Request ( p_request_id IN NUMBER )

Line 634: p_request_id = FND_API.G_MISS_NUM

630: BEGIN
631:
632:
633: IF p_request_id IS NULL OR
634: p_request_id = FND_API.G_MISS_NUM
635: THEN
636:
637: RETURN TRUE;
638: END IF;

Line 679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

675: );
676: END IF;
677:
678:
679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
680:
681: END Request;
682:
683: FUNCTION Price_Adjustment ( p_price_adjustment_id IN NUMBER )

Line 691: p_price_adjustment_id = FND_API.G_MISS_NUM

687: BEGIN
688:
689:
690: IF p_price_adjustment_id IS NULL OR
691: p_price_adjustment_id = FND_API.G_MISS_NUM
692: THEN
693:
694: RETURN TRUE;
695: END IF;

Line 736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

732: );
733: END IF;
734:
735:
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737:
738: END Price_Adjustment;
739:
740: FUNCTION Discount ( p_discount_id IN NUMBER )

Line 748: p_discount_id = FND_API.G_MISS_NUM

744: BEGIN
745:
746:
747: IF p_discount_id IS NULL OR
748: p_discount_id = FND_API.G_MISS_NUM
749: THEN
750:
751: RETURN TRUE;
752: END IF;

Line 793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

789: );
790: END IF;
791:
792:
793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794:
795: END Discount;
796:
797: FUNCTION Discount_Line ( p_discount_line_id IN NUMBER )

Line 805: p_discount_line_id = FND_API.G_MISS_NUM

801: BEGIN
802:
803:
804: IF p_discount_line_id <> -1 OR
805: p_discount_line_id = FND_API.G_MISS_NUM
806: THEN
807:
808: RETURN TRUE;
809: END IF;

Line 851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

847: );
848: END IF;
849:
850:
851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
852:
853: END Discount_Line;
854:
855: FUNCTION Automatic ( p_automatic_flag IN VARCHAR2 )

Line 863: p_automatic_flag = FND_API.G_MISS_CHAR

859: BEGIN
860:
861:
862: IF p_automatic_flag IS NULL OR
863: p_automatic_flag = FND_API.G_MISS_CHAR
864: THEN
865:
866: RETURN TRUE;
867: END IF;

Line 908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

904: );
905: END IF;
906:
907:
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909:
910: END Automatic;
911:
912: FUNCTION Percent ( p_percent IN NUMBER )

Line 921: -- p_percent = FND_API.g_miss_num

917:
918:
919: -- All attribute validation being turned on
920: -- IF p_percent IS NULL OR
921: -- p_percent = FND_API.g_miss_num
922: -- THEN
923: -- RETURN TRUE;
924: -- ELSIF p_percent = 0
925: -- THEN

Line 934: p_percent = FND_API.G_MISS_NUM

930: RETURN TRUE;
931:
932: /*
933: IF p_percent IS NULL OR
934: p_percent = FND_API.G_MISS_NUM
935: THEN
936: RETURN TRUE;
937: END IF;
938:

Line 977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

973: );
974: END IF;
975:
976:
977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
978:
979: END Percent;
980:
981: FUNCTION Line ( p_line_id IN NUMBER )

Line 989: p_line_id = FND_API.G_MISS_NUM

985: BEGIN
986:
987:
988: IF p_line_id IS NULL OR
989: p_line_id = FND_API.G_MISS_NUM
990: THEN
991:
992: RETURN TRUE;
993: END IF;

Line 1034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1030: );
1031: END IF;
1032:
1033:
1034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1035:
1036: END Line;
1037:
1038:

Line 1047: p_Applied_Flag = FND_API.G_MISS_CHAR

1043: BEGIN
1044:
1045:
1046: IF p_Applied_Flag IS NULL OR
1047: p_Applied_Flag = FND_API.G_MISS_CHAR
1048: THEN
1049:
1050: RETURN TRUE;
1051: END IF;

Line 1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1099: );
1100: END IF;
1101:
1102:
1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1104:
1105: END Applied_Flag;
1106:
1107:

Line 1119: p_Change_Reason_Code = FND_API.G_MISS_CHAR OR

1115: BEGIN
1116:
1117:
1118: IF p_Change_Reason_Code IS NULL OR
1119: p_Change_Reason_Code = FND_API.G_MISS_CHAR OR
1120: upper(p_Change_Reason_Code)='MANUAL' OR
1121: upper(p_Change_Reason_Code)='SYSTEM' OR
1122: upper(p_Change_Reason_Code)='CONFIGURATOR'
1123: THEN

Line 1169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1165: );
1166: END IF;
1167:
1168:
1169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1170:
1171: END Change_Reason_Code;
1172:
1173:

Line 1182: p_Change_Reason_Text = FND_API.G_MISS_CHAR

1178: BEGIN
1179:
1180:
1181: IF p_Change_Reason_Text IS NULL OR
1182: p_Change_Reason_Text = FND_API.G_MISS_CHAR
1183: THEN
1184:
1185: RETURN TRUE;
1186: END IF;

Line 1222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1218: );
1219: END IF;
1220:
1221:
1222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1223:
1224: END Change_Reason_Text;
1225:
1226:

Line 1235: p_List_Header_id = FND_API.G_MISS_NUM

1231: BEGIN
1232:
1233:
1234: IF p_List_Header_id IS NULL OR
1235: p_List_Header_id = FND_API.G_MISS_NUM
1236: THEN
1237:
1238: RETURN TRUE;
1239: END IF;

Line 1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1276: );
1277: END IF;
1278:
1279:
1280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1281:
1282: END List_Header_id;
1283:
1284:

Line 1293: p_List_Line_id = FND_API.G_MISS_NUM

1289: BEGIN
1290:
1291:
1292: IF p_List_Line_id IS NULL OR
1293: p_List_Line_id = FND_API.G_MISS_NUM
1294: THEN
1295:
1296: RETURN TRUE;
1297: END IF;

Line 1337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1333: , 'List_Line_id'
1334: );
1335: END IF;
1336:
1337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1338:
1339: END List_Line_id;
1340:
1341:

Line 1350: p_List_Line_Type_code = FND_API.G_MISS_CHAR

1346: BEGIN
1347:
1348:
1349: IF p_List_Line_Type_code IS NULL OR
1350: p_List_Line_Type_code = FND_API.G_MISS_CHAR
1351: THEN
1352:
1353: RETURN TRUE;
1354: END IF;

Line 1395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1391: );
1392: END IF;
1393:
1394:
1395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1396:
1397: END List_Line_Type_code;
1398:
1399:

Line 1409: p_Pricing_Phase_id = FND_API.G_MISS_NUM

1405: BEGIN
1406:
1407:
1408: IF p_Pricing_Phase_id IS NULL OR
1409: p_Pricing_Phase_id = FND_API.G_MISS_NUM
1410: THEN
1411:
1412: RETURN TRUE;
1413: END IF;

Line 1454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1450: );
1451: END IF;
1452:
1453:
1454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1455:
1456: END Pricing_Phase_id;
1457:
1458:

Line 1467: p_Adjusted_Amount = FND_API.G_MISS_NUM

1463: BEGIN
1464:
1465:
1466: IF p_Adjusted_Amount IS NULL OR
1467: p_Adjusted_Amount = FND_API.G_MISS_NUM
1468: THEN
1469:
1470: RETURN TRUE;
1471: END IF;

Line 1512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1508: );
1509: END IF;
1510:
1511:
1512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1513:
1514: END Adjusted_Amount;
1515:
1516:

Line 1526: p_Modified_From = FND_API.G_MISS_CHAR

1522: BEGIN
1523:
1524:
1525: IF p_Modified_From IS NULL OR
1526: p_Modified_From = FND_API.G_MISS_CHAR
1527: THEN
1528:
1529: RETURN TRUE;
1530: END IF;

Line 1571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1567: );
1568: END IF;
1569:
1570:
1571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1572:
1573: END Modified_From;
1574:
1575: FUNCTION Modified_To(p_Modified_To IN VARCHAR2)

Line 1583: p_Modified_To = FND_API.G_MISS_CHAR

1579: BEGIN
1580:
1581:
1582: IF p_Modified_To IS NULL OR
1583: p_Modified_To = FND_API.G_MISS_CHAR
1584: THEN
1585:
1586: RETURN TRUE;
1587: END IF;

Line 1628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1624: );
1625: END IF;
1626:
1627:
1628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1629:
1630: END Modified_To;
1631:
1632:

Line 1641: p_Modifier_mechanism_type_code = FND_API.G_MISS_CHAR

1637: BEGIN
1638:
1639:
1640: IF p_Modifier_mechanism_type_code IS NULL OR
1641: p_Modifier_mechanism_type_code = FND_API.G_MISS_CHAR
1642: THEN
1643:
1644: RETURN TRUE;
1645: END IF;

Line 1686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1682: );
1683: END IF;
1684:
1685:
1686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1687:
1688: END Modifier_mechanism_type_code;
1689:
1690:

Line 1700: p_Operand = FND_API.G_MISS_NUM

1696: BEGIN
1697:
1698:
1699: IF p_Operand IS NULL OR
1700: p_Operand = FND_API.G_MISS_NUM
1701: THEN
1702:
1703: RETURN TRUE;
1704: END IF;

Line 1745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1741: );
1742: END IF;
1743:
1744:
1745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1746:
1747: END operand;
1748:
1749:

Line 1758: p_arithmetic_operator = FND_API.G_MISS_CHAR

1754: BEGIN
1755:
1756:
1757: IF p_arithmetic_operator IS NULL OR
1758: p_arithmetic_operator = FND_API.G_MISS_CHAR
1759: THEN
1760:
1761: RETURN TRUE;
1762: END IF;

Line 1803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1799: );
1800: END IF;
1801:
1802:
1803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1804:
1805: END Arithmetic_Operator;
1806:
1807: FUNCTION List_Line_NO ( p_List_Line_NO IN VARCHAR2 )

Line 1814: p_List_Line_NO = FND_API.G_MISS_CHAR

1810: l_dummy VARCHAR2(10);
1811: BEGIN
1812:
1813: IF p_List_Line_NO IS NULL OR
1814: p_List_Line_NO = FND_API.G_MISS_CHAR
1815: THEN
1816: RETURN TRUE;
1817: END IF;
1818:

Line 1858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1854: , 'List Line NO'
1855: );
1856: END IF;
1857:
1858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1859:
1860: END List_Line_NO;
1861:
1862: FUNCTION Source_System_Code ( p_Source_System_Code IN VARCHAR2 )

Line 1869: p_Source_System_Code = FND_API.G_MISS_CHAR

1865: l_dummy VARCHAR2(10);
1866: BEGIN
1867:
1868: IF p_Source_System_Code IS NULL OR
1869: p_Source_System_Code = FND_API.G_MISS_CHAR
1870: THEN
1871: RETURN TRUE;
1872: END IF;
1873:

Line 1913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1909: , 'Source System Code'
1910: );
1911: END IF;
1912:
1913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1914:
1915: END Source_System_Code;
1916:
1917: FUNCTION Benefit_Qty ( p_Benefit_Qty IN NUMBER )

Line 1924: p_Benefit_Qty = FND_API.G_MISS_NUM

1920: l_dummy VARCHAR2(10);
1921: BEGIN
1922:
1923: IF p_Benefit_Qty IS NULL OR
1924: p_Benefit_Qty = FND_API.G_MISS_NUM
1925: THEN
1926: RETURN TRUE;
1927: END IF;
1928:

Line 1968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1964: , 'Benefit Qty'
1965: );
1966: END IF;
1967:
1968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1969:
1970: END Benefit_Qty;
1971:
1972: FUNCTION Benefit_UOM_Code ( p_Benefit_UOM_Code IN VARCHAR2 )

Line 1979: p_Benefit_UOM_Code = FND_API.G_MISS_CHAR

1975: l_dummy VARCHAR2(10);
1976: BEGIN
1977:
1978: IF p_Benefit_UOM_Code IS NULL OR
1979: p_Benefit_UOM_Code = FND_API.G_MISS_CHAR
1980: THEN
1981: RETURN TRUE;
1982: END IF;
1983:

Line 2023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2019: , 'Benefit UOM Code '
2020: );
2021: END IF;
2022:
2023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2024:
2025: END Benefit_UOM_Code;
2026:
2027: FUNCTION Print_On_Invoice_Flag ( p_Print_On_Invoice_Flag IN VARCHAR2 )

Line 2034: p_Print_On_Invoice_Flag = FND_API.G_MISS_CHAR

2030: l_dummy VARCHAR2(10);
2031: BEGIN
2032:
2033: IF p_Print_On_Invoice_Flag IS NULL OR
2034: p_Print_On_Invoice_Flag = FND_API.G_MISS_CHAR
2035: THEN
2036: RETURN TRUE;
2037: END IF;
2038:

Line 2078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2074: , 'Print On Invoice Flag'
2075: );
2076: END IF;
2077:
2078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2079:
2080: END Print_On_Invoice_Flag;
2081:
2082: FUNCTION Expiration_Date ( p_Expiration_Date IN DATE )

Line 2089: p_Expiration_Date = FND_API.G_MISS_DATE

2085: l_dummy VARCHAR2(10);
2086: BEGIN
2087:
2088: IF p_Expiration_Date IS NULL OR
2089: p_Expiration_Date = FND_API.G_MISS_DATE
2090: THEN
2091: RETURN TRUE;
2092: END IF;
2093:

Line 2133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2129: , 'Expiration Date'
2130: );
2131: END IF;
2132:
2133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2134:
2135: END Expiration_Date;
2136:
2137: FUNCTION Rebate_Transaction_Type_Code ( p_Rebate_Transaction_Type_Code IN VARCHAR2 )

Line 2144: p_Rebate_Transaction_Type_Code = FND_API.G_MISS_CHAR

2140: l_dummy VARCHAR2(10);
2141: BEGIN
2142:
2143: IF p_Rebate_Transaction_Type_Code IS NULL OR
2144: p_Rebate_Transaction_Type_Code = FND_API.G_MISS_CHAR
2145: THEN
2146: RETURN TRUE;
2147: END IF;
2148:

Line 2188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2184: , 'Rebate Transaction Type Code'
2185: );
2186: END IF;
2187:
2188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2189:
2190: END Rebate_Transaction_Type_Code;
2191:
2192: FUNCTION Rebate_Transaction_Reference ( p_Rebate_Transaction_Reference IN VARCHAR2 )

Line 2199: p_Rebate_Transaction_Reference = FND_API.G_MISS_CHAR

2195: l_dummy VARCHAR2(10);
2196: BEGIN
2197:
2198: IF p_Rebate_Transaction_Reference IS NULL OR
2199: p_Rebate_Transaction_Reference = FND_API.G_MISS_CHAR
2200: THEN
2201: RETURN TRUE;
2202: END IF;
2203:

Line 2243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2239: , 'Rebate_Transaction_Reference'
2240: );
2241: END IF;
2242:
2243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2244:
2245: END Rebate_Transaction_Reference;
2246:
2247: FUNCTION Rebate_Payment_System_Code ( p_Rebate_Payment_System_Code IN VARCHAR2 )

Line 2254: p_Rebate_Payment_System_Code = FND_API.G_MISS_CHAR

2250: l_dummy VARCHAR2(10);
2251: BEGIN
2252:
2253: IF p_Rebate_Payment_System_Code IS NULL OR
2254: p_Rebate_Payment_System_Code = FND_API.G_MISS_CHAR
2255: THEN
2256: RETURN TRUE;
2257: END IF;
2258:

Line 2298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2294: , 'Rebate Payment System Code'
2295: );
2296: END IF;
2297:
2298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2299:
2300: END Rebate_Payment_System_Code;
2301:
2302: FUNCTION Redeemed_Date ( p_Redeemed_Date IN DATE )

Line 2309: p_Redeemed_Date = FND_API.G_MISS_DATE

2305: l_dummy VARCHAR2(10);
2306: BEGIN
2307:
2308: IF p_Redeemed_Date IS NULL OR
2309: p_Redeemed_Date = FND_API.G_MISS_DATE
2310: THEN
2311: RETURN TRUE;
2312: END IF;
2313:

Line 2353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2349: , 'Redeemed Date'
2350: );
2351: END IF;
2352:
2353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2354:
2355: END Redeemed_Date;
2356:
2357: FUNCTION Redeemed_Flag ( p_Redeemed_Flag IN VARCHAR2 )

Line 2364: p_Redeemed_Flag = FND_API.G_MISS_CHAR

2360: l_dummy VARCHAR2(10);
2361: BEGIN
2362:
2363: IF p_Redeemed_Flag IS NULL OR
2364: p_Redeemed_Flag = FND_API.G_MISS_CHAR
2365: THEN
2366: RETURN TRUE;
2367: END IF;
2368:

Line 2408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2404: , 'Redeemed Flag'
2405: );
2406: END IF;
2407:
2408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2409:
2410: END Redeemed_Flag;
2411:
2412: FUNCTION Accrual_Flag ( p_Accrual_Flag IN VARCHAR2 )

Line 2419: p_Accrual_Flag = FND_API.G_MISS_CHAR

2415: l_dummy VARCHAR2(10);
2416: BEGIN
2417:
2418: IF p_Accrual_Flag IS NULL OR
2419: p_Accrual_Flag = FND_API.G_MISS_CHAR
2420: THEN
2421: RETURN TRUE;
2422: END IF;
2423:

Line 2463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2459: , 'Accrual Flag'
2460: );
2461: END IF;
2462:
2463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2464:
2465: END Accrual_Flag;
2466:
2467: FUNCTION range_break_quantity ( p_range_break_quantity IN NUMBER )

Line 2474: p_range_break_quantity = FND_API.G_MISS_NUM

2470: l_dummy VARCHAR2(10);
2471: BEGIN
2472:
2473: IF p_range_break_quantity IS NULL OR
2474: p_range_break_quantity = FND_API.G_MISS_NUM
2475: THEN
2476: RETURN TRUE;
2477: END IF;
2478:

Line 2518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2514: , 'range_break_quantity'
2515: );
2516: END IF;
2517:
2518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2519:
2520: END range_break_quantity;
2521:
2522: FUNCTION accrual_conversion_rate ( p_accrual_conversion_rate IN NUMBER )

Line 2529: p_accrual_conversion_rate = FND_API.G_MISS_NUM

2525: l_dummy VARCHAR2(10);
2526: BEGIN
2527:
2528: IF p_accrual_conversion_rate IS NULL OR
2529: p_accrual_conversion_rate = FND_API.G_MISS_NUM
2530: THEN
2531: RETURN TRUE;
2532: END IF;
2533:

Line 2573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2569: , 'accrual_conversion_rate'
2570: );
2571: END IF;
2572:
2573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2574:
2575: END accrual_conversion_rate;
2576:
2577: FUNCTION pricing_group_sequence ( p_pricing_group_sequence IN NUMBER )

Line 2584: p_pricing_group_sequence = FND_API.G_MISS_NUM

2580: l_dummy VARCHAR2(10);
2581: BEGIN
2582:
2583: IF p_pricing_group_sequence IS NULL OR
2584: p_pricing_group_sequence = FND_API.G_MISS_NUM
2585: THEN
2586: RETURN TRUE;
2587: END IF;
2588:

Line 2628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2624: , 'pricing_group_sequence'
2625: );
2626: END IF;
2627:
2628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2629:
2630: END pricing_group_sequence;
2631:
2632: FUNCTION modifier_level_code ( p_modifier_level_code IN VARCHAR2 )

Line 2639: p_modifier_level_code = FND_API.G_MISS_CHAR

2635: l_dummy VARCHAR2(10);
2636: BEGIN
2637:
2638: IF p_modifier_level_code IS NULL OR
2639: p_modifier_level_code = FND_API.G_MISS_CHAR
2640: THEN
2641: RETURN TRUE;
2642: END IF;
2643:

Line 2683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2679: , 'modifier_level_code'
2680: );
2681: END IF;
2682:
2683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2684:
2685: END modifier_level_code;
2686:
2687: FUNCTION price_break_type_code ( p_price_break_type_code IN VARCHAR2 )

Line 2694: p_price_break_type_code = FND_API.G_MISS_CHAR

2690: l_dummy VARCHAR2(10);
2691: BEGIN
2692:
2693: IF p_price_break_type_code IS NULL OR
2694: p_price_break_type_code = FND_API.G_MISS_CHAR
2695: THEN
2696: RETURN TRUE;
2697: END IF;
2698:

Line 2738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2734: , 'price_break_type_code'
2735: );
2736: END IF;
2737:
2738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2739:
2740: END price_break_type_code;
2741:
2742: FUNCTION substitution_attribute ( p_substitution_attribute IN VARCHAR2 )

Line 2749: p_substitution_attribute = FND_API.G_MISS_CHAR

2745: l_dummy VARCHAR2(10);
2746: BEGIN
2747:
2748: IF p_substitution_attribute IS NULL OR
2749: p_substitution_attribute = FND_API.G_MISS_CHAR
2750: THEN
2751: RETURN TRUE;
2752: END IF;
2753:

Line 2793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2789: , 'substitution_attribute'
2790: );
2791: END IF;
2792:
2793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2794:
2795: END substitution_attribute;
2796:
2797: FUNCTION proration_type_code ( p_proration_type_code IN VARCHAR2 )

Line 2804: p_proration_type_code = FND_API.G_MISS_CHAR

2800: l_dummy VARCHAR2(10);
2801: BEGIN
2802:
2803: IF p_proration_type_code IS NULL OR
2804: p_proration_type_code = FND_API.G_MISS_CHAR
2805: THEN
2806: RETURN TRUE;
2807: END IF;
2808:

Line 2848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2844: , 'proration_type_code'
2845: );
2846: END IF;
2847:
2848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2849:
2850: END proration_type_code;
2851:
2852: FUNCTION Updated_Flag(p_Updated_Flag IN VARCHAR2)

Line 2860: p_Updated_Flag = FND_API.G_MISS_CHAR

2856: BEGIN
2857:
2858:
2859: IF p_Updated_Flag IS NULL OR
2860: p_Updated_Flag = FND_API.G_MISS_CHAR
2861: THEN
2862:
2863: RETURN TRUE;
2864: END IF;

Line 2905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2901: );
2902: END IF;
2903:
2904:
2905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2906:
2907: END Updated_Flag;
2908:
2909:

Line 2918: p_Update_Allowed = FND_API.G_MISS_CHAR

2914: BEGIN
2915:
2916:
2917: IF p_Update_Allowed IS NULL OR
2918: p_Update_Allowed = FND_API.G_MISS_CHAR
2919: THEN
2920:
2921: RETURN TRUE;
2922: END IF;

Line 2963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2959: );
2960: END IF;
2961:
2962:
2963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2964:
2965: END Update_Allowed;
2966:
2967:

Line 2976: p_created_by = FND_API.G_MISS_NUM

2972: BEGIN
2973:
2974:
2975: IF p_created_by IS NULL OR
2976: p_created_by = FND_API.G_MISS_NUM
2977: THEN
2978:
2979: RETURN TRUE;
2980: END IF;

Line 3021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3017: );
3018: END IF;
3019:
3020:
3021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3022:
3023: END Created_By;
3024:
3025: FUNCTION Creation_Date ( p_creation_date IN DATE )

Line 3033: p_creation_date = FND_API.G_MISS_DATE

3029: BEGIN
3030:
3031:
3032: IF p_creation_date IS NULL OR
3033: p_creation_date = FND_API.G_MISS_DATE
3034: THEN
3035:
3036: RETURN TRUE;
3037: END IF;

Line 3078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3074: );
3075: END IF;
3076:
3077:
3078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3079:
3080: END Creation_Date;
3081:
3082: --

Line 3092: p_override_flag = FND_API.G_MISS_CHAR

3088: BEGIN
3089:
3090:
3091: IF p_override_flag IS NULL OR
3092: p_override_flag = FND_API.G_MISS_CHAR
3093: THEN
3094:
3095: RETURN TRUE;
3096: END IF;

Line 3137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3133: );
3134: END IF;
3135:
3136:
3137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3138:
3139: END Override_Flag;
3140:
3141: --

Line 3150: p_request_date = FND_API.G_MISS_DATE

3146: BEGIN
3147:
3148:
3149: IF p_request_date IS NULL OR
3150: p_request_date = FND_API.G_MISS_DATE
3151: THEN
3152:
3153: RETURN TRUE;
3154: END IF;

Line 3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3191: );
3192: END IF;
3193:
3194:
3195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3196:
3197: END Request_Date;
3198:
3199: FUNCTION Price_Adj_Desc_Flex (p_context IN VARCHAR2,

Line 3223: IF (p_attribute1 = FND_API.G_MISS_CHAR)

3219: BEGIN
3220:
3221: -- OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONTEXT');
3222:
3223: IF (p_attribute1 = FND_API.G_MISS_CHAR)
3224: AND (p_attribute2 = FND_API.G_MISS_CHAR)
3225: AND (p_attribute3 = FND_API.G_MISS_CHAR)
3226: AND (p_attribute4 = FND_API.G_MISS_CHAR)
3227: AND (p_attribute5 = FND_API.G_MISS_CHAR)

Line 3224: AND (p_attribute2 = FND_API.G_MISS_CHAR)

3220:
3221: -- OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONTEXT');
3222:
3223: IF (p_attribute1 = FND_API.G_MISS_CHAR)
3224: AND (p_attribute2 = FND_API.G_MISS_CHAR)
3225: AND (p_attribute3 = FND_API.G_MISS_CHAR)
3226: AND (p_attribute4 = FND_API.G_MISS_CHAR)
3227: AND (p_attribute5 = FND_API.G_MISS_CHAR)
3228: AND (p_attribute6 = FND_API.G_MISS_CHAR)

Line 3225: AND (p_attribute3 = FND_API.G_MISS_CHAR)

3221: -- OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONTEXT');
3222:
3223: IF (p_attribute1 = FND_API.G_MISS_CHAR)
3224: AND (p_attribute2 = FND_API.G_MISS_CHAR)
3225: AND (p_attribute3 = FND_API.G_MISS_CHAR)
3226: AND (p_attribute4 = FND_API.G_MISS_CHAR)
3227: AND (p_attribute5 = FND_API.G_MISS_CHAR)
3228: AND (p_attribute6 = FND_API.G_MISS_CHAR)
3229: AND (p_attribute7 = FND_API.G_MISS_CHAR)

Line 3226: AND (p_attribute4 = FND_API.G_MISS_CHAR)

3222:
3223: IF (p_attribute1 = FND_API.G_MISS_CHAR)
3224: AND (p_attribute2 = FND_API.G_MISS_CHAR)
3225: AND (p_attribute3 = FND_API.G_MISS_CHAR)
3226: AND (p_attribute4 = FND_API.G_MISS_CHAR)
3227: AND (p_attribute5 = FND_API.G_MISS_CHAR)
3228: AND (p_attribute6 = FND_API.G_MISS_CHAR)
3229: AND (p_attribute7 = FND_API.G_MISS_CHAR)
3230: AND (p_attribute8 = FND_API.G_MISS_CHAR)

Line 3227: AND (p_attribute5 = FND_API.G_MISS_CHAR)

3223: IF (p_attribute1 = FND_API.G_MISS_CHAR)
3224: AND (p_attribute2 = FND_API.G_MISS_CHAR)
3225: AND (p_attribute3 = FND_API.G_MISS_CHAR)
3226: AND (p_attribute4 = FND_API.G_MISS_CHAR)
3227: AND (p_attribute5 = FND_API.G_MISS_CHAR)
3228: AND (p_attribute6 = FND_API.G_MISS_CHAR)
3229: AND (p_attribute7 = FND_API.G_MISS_CHAR)
3230: AND (p_attribute8 = FND_API.G_MISS_CHAR)
3231: AND (p_attribute9 = FND_API.G_MISS_CHAR)

Line 3228: AND (p_attribute6 = FND_API.G_MISS_CHAR)

3224: AND (p_attribute2 = FND_API.G_MISS_CHAR)
3225: AND (p_attribute3 = FND_API.G_MISS_CHAR)
3226: AND (p_attribute4 = FND_API.G_MISS_CHAR)
3227: AND (p_attribute5 = FND_API.G_MISS_CHAR)
3228: AND (p_attribute6 = FND_API.G_MISS_CHAR)
3229: AND (p_attribute7 = FND_API.G_MISS_CHAR)
3230: AND (p_attribute8 = FND_API.G_MISS_CHAR)
3231: AND (p_attribute9 = FND_API.G_MISS_CHAR)
3232: AND (p_attribute10 = FND_API.G_MISS_CHAR)

Line 3229: AND (p_attribute7 = FND_API.G_MISS_CHAR)

3225: AND (p_attribute3 = FND_API.G_MISS_CHAR)
3226: AND (p_attribute4 = FND_API.G_MISS_CHAR)
3227: AND (p_attribute5 = FND_API.G_MISS_CHAR)
3228: AND (p_attribute6 = FND_API.G_MISS_CHAR)
3229: AND (p_attribute7 = FND_API.G_MISS_CHAR)
3230: AND (p_attribute8 = FND_API.G_MISS_CHAR)
3231: AND (p_attribute9 = FND_API.G_MISS_CHAR)
3232: AND (p_attribute10 = FND_API.G_MISS_CHAR)
3233: AND (p_attribute11 = FND_API.G_MISS_CHAR)

Line 3230: AND (p_attribute8 = FND_API.G_MISS_CHAR)

3226: AND (p_attribute4 = FND_API.G_MISS_CHAR)
3227: AND (p_attribute5 = FND_API.G_MISS_CHAR)
3228: AND (p_attribute6 = FND_API.G_MISS_CHAR)
3229: AND (p_attribute7 = FND_API.G_MISS_CHAR)
3230: AND (p_attribute8 = FND_API.G_MISS_CHAR)
3231: AND (p_attribute9 = FND_API.G_MISS_CHAR)
3232: AND (p_attribute10 = FND_API.G_MISS_CHAR)
3233: AND (p_attribute11 = FND_API.G_MISS_CHAR)
3234: AND (p_attribute12 = FND_API.G_MISS_CHAR)

Line 3231: AND (p_attribute9 = FND_API.G_MISS_CHAR)

3227: AND (p_attribute5 = FND_API.G_MISS_CHAR)
3228: AND (p_attribute6 = FND_API.G_MISS_CHAR)
3229: AND (p_attribute7 = FND_API.G_MISS_CHAR)
3230: AND (p_attribute8 = FND_API.G_MISS_CHAR)
3231: AND (p_attribute9 = FND_API.G_MISS_CHAR)
3232: AND (p_attribute10 = FND_API.G_MISS_CHAR)
3233: AND (p_attribute11 = FND_API.G_MISS_CHAR)
3234: AND (p_attribute12 = FND_API.G_MISS_CHAR)
3235: AND (p_attribute13 = FND_API.G_MISS_CHAR)

Line 3232: AND (p_attribute10 = FND_API.G_MISS_CHAR)

3228: AND (p_attribute6 = FND_API.G_MISS_CHAR)
3229: AND (p_attribute7 = FND_API.G_MISS_CHAR)
3230: AND (p_attribute8 = FND_API.G_MISS_CHAR)
3231: AND (p_attribute9 = FND_API.G_MISS_CHAR)
3232: AND (p_attribute10 = FND_API.G_MISS_CHAR)
3233: AND (p_attribute11 = FND_API.G_MISS_CHAR)
3234: AND (p_attribute12 = FND_API.G_MISS_CHAR)
3235: AND (p_attribute13 = FND_API.G_MISS_CHAR)
3236: AND (p_attribute14 = FND_API.G_MISS_CHAR)

Line 3233: AND (p_attribute11 = FND_API.G_MISS_CHAR)

3229: AND (p_attribute7 = FND_API.G_MISS_CHAR)
3230: AND (p_attribute8 = FND_API.G_MISS_CHAR)
3231: AND (p_attribute9 = FND_API.G_MISS_CHAR)
3232: AND (p_attribute10 = FND_API.G_MISS_CHAR)
3233: AND (p_attribute11 = FND_API.G_MISS_CHAR)
3234: AND (p_attribute12 = FND_API.G_MISS_CHAR)
3235: AND (p_attribute13 = FND_API.G_MISS_CHAR)
3236: AND (p_attribute14 = FND_API.G_MISS_CHAR)
3237: AND (p_attribute15 = FND_API.G_MISS_CHAR)

Line 3234: AND (p_attribute12 = FND_API.G_MISS_CHAR)

3230: AND (p_attribute8 = FND_API.G_MISS_CHAR)
3231: AND (p_attribute9 = FND_API.G_MISS_CHAR)
3232: AND (p_attribute10 = FND_API.G_MISS_CHAR)
3233: AND (p_attribute11 = FND_API.G_MISS_CHAR)
3234: AND (p_attribute12 = FND_API.G_MISS_CHAR)
3235: AND (p_attribute13 = FND_API.G_MISS_CHAR)
3236: AND (p_attribute14 = FND_API.G_MISS_CHAR)
3237: AND (p_attribute15 = FND_API.G_MISS_CHAR)
3238: AND (p_context = FND_API.G_MISS_CHAR) THEN

Line 3235: AND (p_attribute13 = FND_API.G_MISS_CHAR)

3231: AND (p_attribute9 = FND_API.G_MISS_CHAR)
3232: AND (p_attribute10 = FND_API.G_MISS_CHAR)
3233: AND (p_attribute11 = FND_API.G_MISS_CHAR)
3234: AND (p_attribute12 = FND_API.G_MISS_CHAR)
3235: AND (p_attribute13 = FND_API.G_MISS_CHAR)
3236: AND (p_attribute14 = FND_API.G_MISS_CHAR)
3237: AND (p_attribute15 = FND_API.G_MISS_CHAR)
3238: AND (p_context = FND_API.G_MISS_CHAR) THEN
3239:

Line 3236: AND (p_attribute14 = FND_API.G_MISS_CHAR)

3232: AND (p_attribute10 = FND_API.G_MISS_CHAR)
3233: AND (p_attribute11 = FND_API.G_MISS_CHAR)
3234: AND (p_attribute12 = FND_API.G_MISS_CHAR)
3235: AND (p_attribute13 = FND_API.G_MISS_CHAR)
3236: AND (p_attribute14 = FND_API.G_MISS_CHAR)
3237: AND (p_attribute15 = FND_API.G_MISS_CHAR)
3238: AND (p_context = FND_API.G_MISS_CHAR) THEN
3239:
3240:

Line 3237: AND (p_attribute15 = FND_API.G_MISS_CHAR)

3233: AND (p_attribute11 = FND_API.G_MISS_CHAR)
3234: AND (p_attribute12 = FND_API.G_MISS_CHAR)
3235: AND (p_attribute13 = FND_API.G_MISS_CHAR)
3236: AND (p_attribute14 = FND_API.G_MISS_CHAR)
3237: AND (p_attribute15 = FND_API.G_MISS_CHAR)
3238: AND (p_context = FND_API.G_MISS_CHAR) THEN
3239:
3240:
3241: RETURN TRUE;

Line 3238: AND (p_context = FND_API.G_MISS_CHAR) THEN

3234: AND (p_attribute12 = FND_API.G_MISS_CHAR)
3235: AND (p_attribute13 = FND_API.G_MISS_CHAR)
3236: AND (p_attribute14 = FND_API.G_MISS_CHAR)
3237: AND (p_attribute15 = FND_API.G_MISS_CHAR)
3238: AND (p_context = FND_API.G_MISS_CHAR) THEN
3239:
3240:
3241: RETURN TRUE;
3242:

Line 3246: IF p_attribute1 = FND_API.G_MISS_CHAR THEN

3242:
3243: ELSE
3244:
3245:
3246: IF p_attribute1 = FND_API.G_MISS_CHAR THEN
3247:
3248: l_column_value := null;
3249:
3250: ELSE

Line 3261: IF p_attribute2 = FND_API.G_MISS_CHAR THEN

3257: ( column_name => 'ATTRIBUTE1'
3258: , column_value => l_column_value);
3259:
3260:
3261: IF p_attribute2 = FND_API.G_MISS_CHAR THEN
3262:
3263: l_column_value := null;
3264:
3265: ELSE

Line 3274: IF p_attribute3 = FND_API.G_MISS_CHAR THEN

3270: FND_FLEX_DESCVAL.Set_Column_Value
3271: ( column_name => 'ATTRIBUTE2'
3272: , column_value => l_column_value);
3273:
3274: IF p_attribute3 = FND_API.G_MISS_CHAR THEN
3275:
3276: l_column_value := null;
3277:
3278: ELSE

Line 3287: IF p_attribute4 = FND_API.G_MISS_CHAR THEN

3283: FND_FLEX_DESCVAL.Set_Column_Value
3284: ( column_name => 'ATTRIBUTE3'
3285: , column_value => l_column_value);
3286:
3287: IF p_attribute4 = FND_API.G_MISS_CHAR THEN
3288:
3289: l_column_value := null;
3290:
3291: ELSE

Line 3300: IF p_attribute5 = FND_API.G_MISS_CHAR THEN

3296: FND_FLEX_DESCVAL.Set_Column_Value
3297: ( column_name => 'ATTRIBUTE4'
3298: , column_value => l_column_value);
3299:
3300: IF p_attribute5 = FND_API.G_MISS_CHAR THEN
3301:
3302: l_column_value := null;
3303:
3304: ELSE

Line 3313: IF p_attribute6 = FND_API.G_MISS_CHAR THEN

3309: FND_FLEX_DESCVAL.Set_Column_Value
3310: ( column_name => 'ATTRIBUTE5'
3311: , column_value => l_column_value);
3312:
3313: IF p_attribute6 = FND_API.G_MISS_CHAR THEN
3314:
3315: l_column_value := null;
3316:
3317: ELSE

Line 3326: IF p_attribute7 = FND_API.G_MISS_CHAR THEN

3322: FND_FLEX_DESCVAL.Set_Column_Value
3323: ( column_name => 'ATTRIBUTE6'
3324: , column_value => l_column_value);
3325:
3326: IF p_attribute7 = FND_API.G_MISS_CHAR THEN
3327:
3328: l_column_value := null;
3329:
3330: ELSE

Line 3339: IF p_attribute8 = FND_API.G_MISS_CHAR THEN

3335: FND_FLEX_DESCVAL.Set_Column_Value
3336: ( column_name => 'ATTRIBUTE7'
3337: , column_value => l_column_value);
3338:
3339: IF p_attribute8 = FND_API.G_MISS_CHAR THEN
3340:
3341: l_column_value := null;
3342:
3343: ELSE

Line 3352: IF p_attribute9 = FND_API.G_MISS_CHAR THEN

3348: FND_FLEX_DESCVAL.Set_Column_Value
3349: ( column_name => 'ATTRIBUTE8'
3350: , column_value => l_column_value);
3351:
3352: IF p_attribute9 = FND_API.G_MISS_CHAR THEN
3353:
3354: l_column_value := null;
3355:
3356: ELSE

Line 3365: IF p_attribute10 = FND_API.G_MISS_CHAR THEN

3361: FND_FLEX_DESCVAL.Set_Column_Value
3362: ( column_name => 'ATTRIBUTE9'
3363: , column_value => l_column_value);
3364:
3365: IF p_attribute10 = FND_API.G_MISS_CHAR THEN
3366:
3367: l_column_value := null;
3368:
3369: ELSE

Line 3378: IF p_attribute11 = FND_API.G_MISS_CHAR THEN

3374: FND_FLEX_DESCVAL.Set_Column_Value
3375: ( column_name => 'ATTRIBUTE10'
3376: , column_value => l_column_value);
3377:
3378: IF p_attribute11 = FND_API.G_MISS_CHAR THEN
3379:
3380: l_column_value := null;
3381:
3382: ELSE

Line 3391: IF p_attribute12 = FND_API.G_MISS_CHAR THEN

3387: FND_FLEX_DESCVAL.Set_Column_Value
3388: ( column_name => 'ATTRIBUTE11'
3389: , column_value => l_column_value);
3390:
3391: IF p_attribute12 = FND_API.G_MISS_CHAR THEN
3392:
3393: l_column_value := null;
3394:
3395: ELSE

Line 3404: IF p_attribute13 = FND_API.G_MISS_CHAR THEN

3400: FND_FLEX_DESCVAL.Set_Column_Value
3401: ( column_name => 'ATTRIBUTE12'
3402: , column_value => l_column_value);
3403:
3404: IF p_attribute13 = FND_API.G_MISS_CHAR THEN
3405:
3406: l_column_value := null;
3407:
3408: ELSE

Line 3417: IF p_attribute14 = FND_API.G_MISS_CHAR THEN

3413: FND_FLEX_DESCVAL.Set_Column_Value
3414: ( column_name => 'ATTRIBUTE13'
3415: , column_value => l_column_value);
3416:
3417: IF p_attribute14 = FND_API.G_MISS_CHAR THEN
3418:
3419: l_column_value := null;
3420:
3421: ELSE

Line 3430: IF p_attribute15 = FND_API.G_MISS_CHAR THEN

3426: FND_FLEX_DESCVAL.Set_Column_Value
3427: ( column_name => 'ATTRIBUTE14'
3428: , column_value => l_column_value);
3429:
3430: IF p_attribute15 = FND_API.G_MISS_CHAR THEN
3431:
3432: l_column_value := null;
3433:
3434: ELSE

Line 3443: IF p_context = FND_API.G_MISS_CHAR THEN

3439: FND_FLEX_DESCVAL.Set_Column_Value
3440: ( column_name => 'ATTRIBUTE15'
3441: , column_value => l_column_value);
3442:
3443: IF p_context = FND_API.G_MISS_CHAR THEN
3444:
3445: l_column_value := null;
3446:
3447: ELSE

Line 3492: p_flex_title = FND_API.G_MISS_CHAR

3488: l_dummy VARCHAR2(10);
3489: BEGIN
3490:
3491: IF p_flex_title IS NULL OR
3492: p_flex_title = FND_API.G_MISS_CHAR
3493: THEN
3494: RETURN TRUE;
3495: END IF;
3496:

Line 3529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3525: , 'Flex_Title'
3526: );
3527: END IF;
3528:
3529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3530:
3531: END Flex_Title;
3532:
3533: FUNCTION Order_Price_Attrib ( p_order_price_attrib_id IN NUMBER )

Line 3540: p_order_price_attrib_id = FND_API.G_MISS_NUM

3536: l_dummy VARCHAR2(10);
3537: BEGIN
3538:
3539: IF p_order_price_attrib_id IS NULL OR
3540: p_order_price_attrib_id = FND_API.G_MISS_NUM
3541: THEN
3542: RETURN TRUE;
3543: END IF;
3544:

Line 3577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3573: , 'Order_Price_Attrib'
3574: );
3575: END IF;
3576:
3577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3578:
3579: END Order_Price_Attrib;
3580:
3581: -- END GEN validate