APPS.OE_CNCL_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 202: p_header_id = FND_API.G_MISS_NUM

198: BEGIN
199:
200:
201: IF p_header_id IS NULL OR
202: p_header_id = FND_API.G_MISS_NUM
203: THEN
204: RETURN TRUE;
205: END IF;
206:

Line 246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

242: , 'Header'
243: );
244: END IF;
245:
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247:
248: END Header;
249:
250:

Line 259: p_last_updated_by = FND_API.G_MISS_NUM

255: BEGIN
256:
257:
258: IF p_last_updated_by IS NULL OR
259: p_last_updated_by = FND_API.G_MISS_NUM
260: THEN
261:
262: RETURN TRUE;
263: END IF;

Line 304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

300: );
301: END IF;
302:
303:
304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305:
306: END Last_Updated_By;
307:
308: FUNCTION Last_Update_Date ( p_last_update_date IN DATE )

Line 316: p_last_update_date = FND_API.G_MISS_DATE

312: BEGIN
313:
314:
315: IF p_last_update_date IS NULL OR
316: p_last_update_date = FND_API.G_MISS_DATE
317: THEN
318:
319: RETURN TRUE;
320: END IF;

Line 361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

357: );
358: END IF;
359:
360:
361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
362:
363: END Last_Update_Date;
364:
365: FUNCTION Last_Update_Login ( p_last_update_login IN NUMBER )

Line 373: p_last_update_login = FND_API.G_MISS_NUM

369: BEGIN
370:
371:
372: IF p_last_update_login IS NULL OR
373: p_last_update_login = FND_API.G_MISS_NUM
374: THEN
375:
376: RETURN TRUE;
377: END IF;

Line 418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

414: );
415: END IF;
416:
417:
418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
419:
420: END Last_Update_Login;
421:
422: FUNCTION Program_Application ( p_program_application_id IN NUMBER )

Line 430: p_program_application_id = FND_API.G_MISS_NUM

426: BEGIN
427:
428:
429: IF p_program_application_id IS NULL OR
430: p_program_application_id = FND_API.G_MISS_NUM
431: THEN
432:
433: RETURN TRUE;
434: END IF;

Line 475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

471: );
472: END IF;
473:
474:
475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
476:
477: END Program_Application;
478:
479: FUNCTION Program ( p_program_id IN NUMBER )

Line 487: p_program_id = FND_API.G_MISS_NUM

483: BEGIN
484:
485:
486: IF p_program_id IS NULL OR
487: p_program_id = FND_API.G_MISS_NUM
488: THEN
489:
490: RETURN TRUE;
491: END IF;

Line 532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

528: );
529: END IF;
530:
531:
532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
533:
534: END Program;
535:
536: FUNCTION Program_Update_Date ( p_program_update_date IN DATE )

Line 544: p_program_update_date = FND_API.G_MISS_DATE

540: BEGIN
541:
542:
543: IF p_program_update_date IS NULL OR
544: p_program_update_date = FND_API.G_MISS_DATE
545: THEN
546:
547: RETURN TRUE;
548: END IF;

Line 589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

585: );
586: END IF;
587:
588:
589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
590:
591: END Program_Update_Date;
592:
593: FUNCTION Request ( p_request_id IN NUMBER )

Line 601: p_request_id = FND_API.G_MISS_NUM

597: BEGIN
598:
599:
600: IF p_request_id IS NULL OR
601: p_request_id = FND_API.G_MISS_NUM
602: THEN
603:
604: RETURN TRUE;
605: END IF;

Line 646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

642: );
643: END IF;
644:
645:
646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
647:
648: END Request;
649:
650: FUNCTION Price_Adjustment ( p_price_adjustment_id IN NUMBER )

Line 658: p_price_adjustment_id = FND_API.G_MISS_NUM

654: BEGIN
655:
656:
657: IF p_price_adjustment_id IS NULL OR
658: p_price_adjustment_id = FND_API.G_MISS_NUM
659: THEN
660:
661: RETURN TRUE;
662: END IF;

Line 703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

699: );
700: END IF;
701:
702:
703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
704:
705: END Price_Adjustment;
706:
707: FUNCTION Discount ( p_discount_id IN NUMBER )

Line 715: p_discount_id = FND_API.G_MISS_NUM

711: BEGIN
712:
713:
714: IF p_discount_id IS NULL OR
715: p_discount_id = FND_API.G_MISS_NUM
716: THEN
717:
718: RETURN TRUE;
719: END IF;

Line 760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

756: );
757: END IF;
758:
759:
760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
761:
762: END Discount;
763:
764: FUNCTION Discount_Line ( p_discount_line_id IN NUMBER )

Line 772: p_discount_line_id = FND_API.G_MISS_NUM

768: BEGIN
769:
770:
771: IF p_discount_line_id <> -1 OR
772: p_discount_line_id = FND_API.G_MISS_NUM
773: THEN
774:
775: RETURN TRUE;
776: END IF;

Line 818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

814: );
815: END IF;
816:
817:
818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
819:
820: END Discount_Line;
821:
822: FUNCTION Automatic ( p_automatic_flag IN VARCHAR2 )

Line 829: p_automatic_flag = FND_API.G_MISS_CHAR THEN

825: l_dummy VARCHAR2(10);
826: BEGIN
827:
828: IF p_automatic_flag IS NULL OR
829: p_automatic_flag = FND_API.G_MISS_CHAR THEN
830:
831: RETURN TRUE;
832: END IF;
833:

Line 877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

873: );
874: END IF;
875:
876:
877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
878:
879: END Automatic;
880:
881: FUNCTION Percent ( p_percent IN NUMBER )

Line 890: -- p_percent = FND_API.g_miss_num

886:
887:
888: -- All attribute validation being turned on
889: -- IF p_percent IS NULL OR
890: -- p_percent = FND_API.g_miss_num
891: -- THEN
892: -- RETURN TRUE;
893: -- ELSIF p_percent = 0
894: -- THEN

Line 903: p_percent = FND_API.G_MISS_NUM

899: RETURN TRUE;
900:
901: /*
902: IF p_percent IS NULL OR
903: p_percent = FND_API.G_MISS_NUM
904: THEN
905: RETURN TRUE;
906: END IF;
907:

Line 946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

942: );
943: END IF;
944:
945:
946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
947:
948: END Percent;
949:
950: FUNCTION Line ( p_line_id IN NUMBER )

Line 958: p_line_id = FND_API.G_MISS_NUM

954: BEGIN
955:
956:
957: IF p_line_id IS NULL OR
958: p_line_id = FND_API.G_MISS_NUM
959: THEN
960:
961: RETURN TRUE;
962: END IF;

Line 1003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

999: );
1000: END IF;
1001:
1002:
1003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1004:
1005: END Line;
1006:
1007:

Line 1016: p_Applied_Flag = FND_API.G_MISS_CHAR

1012: BEGIN
1013:
1014:
1015: IF p_Applied_Flag IS NULL OR
1016: p_Applied_Flag = FND_API.G_MISS_CHAR
1017: THEN
1018:
1019: RETURN TRUE;
1020: END IF;

Line 1072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1068: );
1069: END IF;
1070:
1071:
1072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1073:
1074: END Applied_Flag;
1075:
1076:

Line 1086: p_Change_Reason_Code = FND_API.G_MISS_CHAR

1082: BEGIN
1083:
1084:
1085: IF p_Change_Reason_Code IS NULL OR
1086: p_Change_Reason_Code = FND_API.G_MISS_CHAR
1087: THEN
1088:
1089: RETURN TRUE;
1090: END IF;

Line 1126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1122: );
1123: END IF;
1124:
1125:
1126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1127:
1128: END Change_Reason_Code;
1129:
1130:

Line 1139: p_Change_Reason_Text = FND_API.G_MISS_CHAR

1135: BEGIN
1136:
1137:
1138: IF p_Change_Reason_Text IS NULL OR
1139: p_Change_Reason_Text = FND_API.G_MISS_CHAR
1140: THEN
1141:
1142: RETURN TRUE;
1143: END IF;

Line 1179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1175: );
1176: END IF;
1177:
1178:
1179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1180:
1181: END Change_Reason_Text;
1182:
1183:

Line 1192: p_List_Header_id = FND_API.G_MISS_NUM

1188: BEGIN
1189:
1190:
1191: IF p_List_Header_id IS NULL OR
1192: p_List_Header_id = FND_API.G_MISS_NUM
1193: THEN
1194:
1195: RETURN TRUE;
1196: END IF;

Line 1237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1233: );
1234: END IF;
1235:
1236:
1237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1238:
1239: END List_Header_id;
1240:
1241:

Line 1250: p_List_Line_id = FND_API.G_MISS_NUM

1246: BEGIN
1247:
1248:
1249: IF p_List_Line_id IS NULL OR
1250: p_List_Line_id = FND_API.G_MISS_NUM
1251: THEN
1252:
1253: RETURN TRUE;
1254: END IF;

Line 1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1290: , 'List_Line_id'
1291: );
1292: END IF;
1293:
1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295:
1296: END List_Line_id;
1297:
1298:

Line 1306: p_List_Line_Type_code = FND_API.G_MISS_CHAR

1302: l_dummy VARCHAR2(10);
1303: BEGIN
1304:
1305: IF p_List_Line_Type_code IS NULL OR
1306: p_List_Line_Type_code = FND_API.G_MISS_CHAR
1307: THEN
1308:
1309: RETURN TRUE;
1310: END IF;

Line 1353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1349: );
1350: END IF;
1351:
1352:
1353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1354:
1355: END List_Line_Type_code;
1356:
1357:

Line 1367: p_Pricing_Phase_id = FND_API.G_MISS_NUM

1363: BEGIN
1364:
1365:
1366: IF p_Pricing_Phase_id IS NULL OR
1367: p_Pricing_Phase_id = FND_API.G_MISS_NUM
1368: THEN
1369:
1370: RETURN TRUE;
1371: END IF;

Line 1414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1410: );
1411: END IF;
1412:
1413:
1414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1415:
1416: END Pricing_Phase_id;
1417:
1418:

Line 1427: p_Adjusted_Amount = FND_API.G_MISS_NUM

1423: BEGIN
1424:
1425:
1426: IF p_Adjusted_Amount IS NULL OR
1427: p_Adjusted_Amount = FND_API.G_MISS_NUM
1428: THEN
1429:
1430: RETURN TRUE;
1431: END IF;

Line 1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1468: );
1469: END IF;
1470:
1471:
1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1473:
1474: END Adjusted_Amount;
1475:
1476:

Line 1486: p_Modified_From = FND_API.G_MISS_CHAR

1482: BEGIN
1483:
1484:
1485: IF p_Modified_From IS NULL OR
1486: p_Modified_From = FND_API.G_MISS_CHAR
1487: THEN
1488:
1489: RETURN TRUE;
1490: END IF;

Line 1533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1529: );
1530: END IF;
1531:
1532:
1533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1534:
1535: END Modified_From;
1536:
1537: FUNCTION Modified_To(p_Modified_To IN VARCHAR2)

Line 1545: p_Modified_To = FND_API.G_MISS_CHAR

1541: BEGIN
1542:
1543:
1544: IF p_Modified_To IS NULL OR
1545: p_Modified_To = FND_API.G_MISS_CHAR
1546: THEN
1547:
1548: RETURN TRUE;
1549: END IF;

Line 1592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1588: );
1589: END IF;
1590:
1591:
1592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1593:
1594: END Modified_To;
1595:
1596:

Line 1605: p_Modifier_mechanism_type_code = FND_API.G_MISS_CHAR

1601: BEGIN
1602:
1603:
1604: IF p_Modifier_mechanism_type_code IS NULL OR
1605: p_Modifier_mechanism_type_code = FND_API.G_MISS_CHAR
1606: THEN
1607:
1608: RETURN TRUE;
1609: END IF;

Line 1650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1646: );
1647: END IF;
1648:
1649:
1650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1651:
1652: END Modifier_mechanism_type_code;
1653:
1654:

Line 1664: p_Operand = FND_API.G_MISS_NUM

1660: BEGIN
1661:
1662:
1663: IF p_Operand IS NULL OR
1664: p_Operand = FND_API.G_MISS_NUM
1665: THEN
1666:
1667: RETURN TRUE;
1668: END IF;

Line 1709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1705: );
1706: END IF;
1707:
1708:
1709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1710:
1711: END operand;
1712:
1713:

Line 1722: p_arithmetic_operator = FND_API.G_MISS_CHAR

1718: BEGIN
1719:
1720:
1721: IF p_arithmetic_operator IS NULL OR
1722: p_arithmetic_operator = FND_API.G_MISS_CHAR
1723: THEN
1724:
1725: RETURN TRUE;
1726: END IF;

Line 1767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1763: );
1764: END IF;
1765:
1766:
1767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1768:
1769: END Arithmetic_Operator;
1770:
1771: FUNCTION List_Line_NO ( p_List_Line_NO IN VARCHAR2 )

Line 1778: p_List_Line_NO = FND_API.G_MISS_CHAR

1774: l_dummy VARCHAR2(10);
1775: BEGIN
1776:
1777: IF p_List_Line_NO IS NULL OR
1778: p_List_Line_NO = FND_API.G_MISS_CHAR
1779: THEN
1780: RETURN TRUE;
1781: END IF;
1782:

Line 1824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1820: , 'List Line NO'
1821: );
1822: END IF;
1823:
1824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1825:
1826: END List_Line_NO;
1827:
1828: FUNCTION Source_System_Code ( p_Source_System_Code IN VARCHAR2 )

Line 1835: p_Source_System_Code = FND_API.G_MISS_CHAR

1831: l_dummy VARCHAR2(10);
1832: BEGIN
1833:
1834: IF p_Source_System_Code IS NULL OR
1835: p_Source_System_Code = FND_API.G_MISS_CHAR
1836: THEN
1837: RETURN TRUE;
1838: END IF;
1839:

Line 1879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1875: , 'Source System Code'
1876: );
1877: END IF;
1878:
1879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1880:
1881: END Source_System_Code;
1882:
1883: FUNCTION Benefit_Qty ( p_Benefit_Qty IN NUMBER )

Line 1890: p_Benefit_Qty = FND_API.G_MISS_NUM

1886: l_dummy VARCHAR2(10);
1887: BEGIN
1888:
1889: IF p_Benefit_Qty IS NULL OR
1890: p_Benefit_Qty = FND_API.G_MISS_NUM
1891: THEN
1892: RETURN TRUE;
1893: END IF;
1894:

Line 1934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1930: , 'Benefit Qty'
1931: );
1932: END IF;
1933:
1934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1935:
1936: END Benefit_Qty;
1937:
1938: FUNCTION Benefit_UOM_Code ( p_Benefit_UOM_Code IN VARCHAR2 )

Line 1945: p_Benefit_UOM_Code = FND_API.G_MISS_CHAR

1941: l_dummy VARCHAR2(10);
1942: BEGIN
1943:
1944: IF p_Benefit_UOM_Code IS NULL OR
1945: p_Benefit_UOM_Code = FND_API.G_MISS_CHAR
1946: THEN
1947: RETURN TRUE;
1948: END IF;
1949:

Line 1989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1985: , 'Benefit UOM Code '
1986: );
1987: END IF;
1988:
1989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1990:
1991: END Benefit_UOM_Code;
1992:
1993: FUNCTION Print_On_Invoice_Flag ( p_Print_On_Invoice_Flag IN VARCHAR2 )

Line 2000: p_Print_On_Invoice_Flag = FND_API.G_MISS_CHAR

1996: l_dummy VARCHAR2(10);
1997: BEGIN
1998:
1999: IF p_Print_On_Invoice_Flag IS NULL OR
2000: p_Print_On_Invoice_Flag = FND_API.G_MISS_CHAR
2001: THEN
2002: RETURN TRUE;
2003: END IF;
2004:

Line 2044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2040: , 'Print On Invoice Flag'
2041: );
2042: END IF;
2043:
2044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2045:
2046: END Print_On_Invoice_Flag;
2047:
2048: FUNCTION Expiration_Date ( p_Expiration_Date IN DATE )

Line 2055: p_Expiration_Date = FND_API.G_MISS_DATE

2051: l_dummy VARCHAR2(10);
2052: BEGIN
2053:
2054: IF p_Expiration_Date IS NULL OR
2055: p_Expiration_Date = FND_API.G_MISS_DATE
2056: THEN
2057: RETURN TRUE;
2058: END IF;
2059:

Line 2099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2095: , 'Expiration Date'
2096: );
2097: END IF;
2098:
2099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2100:
2101: END Expiration_Date;
2102:
2103: FUNCTION Rebate_Transaction_Type_Code ( p_Rebate_Transaction_Type_Code IN VARCHAR2 )

Line 2110: p_Rebate_Transaction_Type_Code = FND_API.G_MISS_CHAR

2106: l_dummy VARCHAR2(10);
2107: BEGIN
2108:
2109: IF p_Rebate_Transaction_Type_Code IS NULL OR
2110: p_Rebate_Transaction_Type_Code = FND_API.G_MISS_CHAR
2111: THEN
2112: RETURN TRUE;
2113: END IF;
2114:

Line 2154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2150: , 'Rebate Transaction Type Code'
2151: );
2152: END IF;
2153:
2154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2155:
2156: END Rebate_Transaction_Type_Code;
2157:
2158: FUNCTION Rebate_Transaction_Reference ( p_Rebate_Transaction_Reference IN VARCHAR2 )

Line 2165: p_Rebate_Transaction_Reference = FND_API.G_MISS_CHAR

2161: l_dummy VARCHAR2(10);
2162: BEGIN
2163:
2164: IF p_Rebate_Transaction_Reference IS NULL OR
2165: p_Rebate_Transaction_Reference = FND_API.G_MISS_CHAR
2166: THEN
2167: RETURN TRUE;
2168: END IF;
2169:

Line 2209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2205: , 'Rebate_Transaction_Reference'
2206: );
2207: END IF;
2208:
2209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2210:
2211: END Rebate_Transaction_Reference;
2212:
2213: FUNCTION Rebate_Payment_System_Code ( p_Rebate_Payment_System_Code IN VARCHAR2 )

Line 2220: p_Rebate_Payment_System_Code = FND_API.G_MISS_CHAR

2216: l_dummy VARCHAR2(10);
2217: BEGIN
2218:
2219: IF p_Rebate_Payment_System_Code IS NULL OR
2220: p_Rebate_Payment_System_Code = FND_API.G_MISS_CHAR
2221: THEN
2222: RETURN TRUE;
2223: END IF;
2224:

Line 2264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2260: , 'Rebate Payment System Code'
2261: );
2262: END IF;
2263:
2264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2265:
2266: END Rebate_Payment_System_Code;
2267:
2268: FUNCTION Redeemed_Date ( p_Redeemed_Date IN DATE )

Line 2275: p_Redeemed_Date = FND_API.G_MISS_DATE

2271: l_dummy VARCHAR2(10);
2272: BEGIN
2273:
2274: IF p_Redeemed_Date IS NULL OR
2275: p_Redeemed_Date = FND_API.G_MISS_DATE
2276: THEN
2277: RETURN TRUE;
2278: END IF;
2279:

Line 2319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2315: , 'Redeemed Date'
2316: );
2317: END IF;
2318:
2319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2320:
2321: END Redeemed_Date;
2322:
2323: FUNCTION Redeemed_Flag ( p_Redeemed_Flag IN VARCHAR2 )

Line 2330: p_Redeemed_Flag = FND_API.G_MISS_CHAR

2326: l_dummy VARCHAR2(10);
2327: BEGIN
2328:
2329: IF p_Redeemed_Flag IS NULL OR
2330: p_Redeemed_Flag = FND_API.G_MISS_CHAR
2331: THEN
2332: RETURN TRUE;
2333: END IF;
2334:

Line 2378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2374: , 'Redeemed Flag'
2375: );
2376: END IF;
2377:
2378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2379:
2380: END Redeemed_Flag;
2381:
2382: FUNCTION Accrual_Flag ( p_Accrual_Flag IN VARCHAR2 )

Line 2389: p_Accrual_Flag = FND_API.G_MISS_CHAR THEN

2385: l_dummy VARCHAR2(10);
2386: BEGIN
2387:
2388: IF p_Accrual_Flag IS NULL OR
2389: p_Accrual_Flag = FND_API.G_MISS_CHAR THEN
2390: RETURN TRUE;
2391: END IF;
2392:
2393: IF p_Accrual_Flag NOT IN ('Y','N') THEN

Line 2436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2432: , 'Accrual Flag'
2433: );
2434: END IF;
2435:
2436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2437:
2438: END Accrual_Flag;
2439:
2440: FUNCTION range_break_quantity ( p_range_break_quantity IN NUMBER )

Line 2447: p_range_break_quantity = FND_API.G_MISS_NUM

2443: l_dummy VARCHAR2(10);
2444: BEGIN
2445:
2446: IF p_range_break_quantity IS NULL OR
2447: p_range_break_quantity = FND_API.G_MISS_NUM
2448: THEN
2449: RETURN TRUE;
2450: END IF;
2451:

Line 2493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2489: , 'range_break_quantity'
2490: );
2491: END IF;
2492:
2493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2494:
2495: END range_break_quantity;
2496:
2497: FUNCTION accrual_conversion_rate ( p_accrual_conversion_rate IN NUMBER )

Line 2504: p_accrual_conversion_rate = FND_API.G_MISS_NUM

2500: l_dummy VARCHAR2(10);
2501: BEGIN
2502:
2503: IF p_accrual_conversion_rate IS NULL OR
2504: p_accrual_conversion_rate = FND_API.G_MISS_NUM
2505: THEN
2506: RETURN TRUE;
2507: END IF;
2508:

Line 2550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2546: , 'accrual_conversion_rate'
2547: );
2548: END IF;
2549:
2550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2551:
2552: END accrual_conversion_rate;
2553:
2554: FUNCTION pricing_group_sequence ( p_pricing_group_sequence IN NUMBER )

Line 2561: p_pricing_group_sequence = FND_API.G_MISS_NUM

2557: l_dummy VARCHAR2(10);
2558: BEGIN
2559:
2560: IF p_pricing_group_sequence IS NULL OR
2561: p_pricing_group_sequence = FND_API.G_MISS_NUM
2562: THEN
2563: RETURN TRUE;
2564: END IF;
2565:

Line 2607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2603: , 'pricing_group_sequence'
2604: );
2605: END IF;
2606:
2607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2608:
2609: END pricing_group_sequence;
2610:
2611: FUNCTION modifier_level_code ( p_modifier_level_code IN VARCHAR2 )

Line 2618: p_modifier_level_code = FND_API.G_MISS_CHAR

2614: l_dummy VARCHAR2(10);
2615: BEGIN
2616:
2617: IF p_modifier_level_code IS NULL OR
2618: p_modifier_level_code = FND_API.G_MISS_CHAR
2619: THEN
2620: RETURN TRUE;
2621: END IF;
2622:

Line 2664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2660: , 'modifier_level_code'
2661: );
2662: END IF;
2663:
2664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2665:
2666: END modifier_level_code;
2667:
2668: FUNCTION price_break_type_code ( p_price_break_type_code IN VARCHAR2 )

Line 2675: p_price_break_type_code = FND_API.G_MISS_CHAR

2671: l_dummy VARCHAR2(10);
2672: BEGIN
2673:
2674: IF p_price_break_type_code IS NULL OR
2675: p_price_break_type_code = FND_API.G_MISS_CHAR
2676: THEN
2677: RETURN TRUE;
2678: END IF;
2679:

Line 2721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2717: , 'price_break_type_code'
2718: );
2719: END IF;
2720:
2721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2722:
2723: END price_break_type_code;
2724:
2725: FUNCTION substitution_attribute ( p_substitution_attribute IN VARCHAR2 )

Line 2732: p_substitution_attribute = FND_API.G_MISS_CHAR

2728: l_dummy VARCHAR2(10);
2729: BEGIN
2730:
2731: IF p_substitution_attribute IS NULL OR
2732: p_substitution_attribute = FND_API.G_MISS_CHAR
2733: THEN
2734: RETURN TRUE;
2735: END IF;
2736:

Line 2778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2774: , 'substitution_attribute'
2775: );
2776: END IF;
2777:
2778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2779:
2780: END substitution_attribute;
2781:
2782: FUNCTION proration_type_code ( p_proration_type_code IN VARCHAR2 )

Line 2789: p_proration_type_code = FND_API.G_MISS_CHAR

2785: l_dummy VARCHAR2(10);
2786: BEGIN
2787:
2788: IF p_proration_type_code IS NULL OR
2789: p_proration_type_code = FND_API.G_MISS_CHAR
2790: THEN
2791: RETURN TRUE;
2792: END IF;
2793:

Line 2835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2831: , 'proration_type_code'
2832: );
2833: END IF;
2834:
2835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2836:
2837: END proration_type_code;
2838:
2839: FUNCTION Updated_Flag(p_Updated_Flag IN VARCHAR2)

Line 2847: p_Updated_Flag = FND_API.G_MISS_CHAR

2843: BEGIN
2844:
2845:
2846: IF p_Updated_Flag IS NULL OR
2847: p_Updated_Flag = FND_API.G_MISS_CHAR
2848: THEN
2849:
2850: RETURN TRUE;
2851: END IF;

Line 2896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2892: );
2893: END IF;
2894:
2895:
2896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2897:
2898: END Updated_Flag;
2899:
2900:

Line 2909: p_Update_Allowed = FND_API.G_MISS_CHAR

2905: BEGIN
2906:
2907:
2908: IF p_Update_Allowed IS NULL OR
2909: p_Update_Allowed = FND_API.G_MISS_CHAR
2910: THEN
2911:
2912: RETURN TRUE;
2913: END IF;

Line 2954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2950: );
2951: END IF;
2952:
2953:
2954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2955:
2956: END Update_Allowed;
2957:
2958:

Line 2967: p_created_by = FND_API.G_MISS_NUM

2963: BEGIN
2964:
2965:
2966: IF p_created_by IS NULL OR
2967: p_created_by = FND_API.G_MISS_NUM
2968: THEN
2969:
2970: RETURN TRUE;
2971: END IF;

Line 3012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3008: );
3009: END IF;
3010:
3011:
3012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3013:
3014: END Created_By;
3015:
3016: FUNCTION Creation_Date ( p_creation_date IN DATE )

Line 3024: p_creation_date = FND_API.G_MISS_DATE

3020: BEGIN
3021:
3022:
3023: IF p_creation_date IS NULL OR
3024: p_creation_date = FND_API.G_MISS_DATE
3025: THEN
3026:
3027: RETURN TRUE;
3028: END IF;

Line 3069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3065: );
3066: END IF;
3067:
3068:
3069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3070:
3071: END Creation_Date;
3072:
3073: --

Line 3083: p_override_flag = FND_API.G_MISS_CHAR

3079: BEGIN
3080:
3081:
3082: IF p_override_flag IS NULL OR
3083: p_override_flag = FND_API.G_MISS_CHAR
3084: THEN
3085:
3086: RETURN TRUE;
3087: END IF;

Line 3128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3124: );
3125: END IF;
3126:
3127:
3128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3129:
3130: END Override_Flag;
3131:
3132: --

Line 3141: p_request_date = FND_API.G_MISS_DATE

3137: BEGIN
3138:
3139:
3140: IF p_request_date IS NULL OR
3141: p_request_date = FND_API.G_MISS_DATE
3142: THEN
3143:
3144: RETURN TRUE;
3145: END IF;

Line 3186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3182: );
3183: END IF;
3184:
3185:
3186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3187:
3188: END Request_Date;
3189:
3190: FUNCTION Price_Adj_Desc_Flex (p_context IN VARCHAR2,

Line 3214: IF (p_attribute1 = FND_API.G_MISS_CHAR)

3210: BEGIN
3211:
3212: -- OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONTEXT');
3213:
3214: IF (p_attribute1 = FND_API.G_MISS_CHAR)
3215: AND (p_attribute2 = FND_API.G_MISS_CHAR)
3216: AND (p_attribute3 = FND_API.G_MISS_CHAR)
3217: AND (p_attribute4 = FND_API.G_MISS_CHAR)
3218: AND (p_attribute5 = FND_API.G_MISS_CHAR)

Line 3215: AND (p_attribute2 = FND_API.G_MISS_CHAR)

3211:
3212: -- OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONTEXT');
3213:
3214: IF (p_attribute1 = FND_API.G_MISS_CHAR)
3215: AND (p_attribute2 = FND_API.G_MISS_CHAR)
3216: AND (p_attribute3 = FND_API.G_MISS_CHAR)
3217: AND (p_attribute4 = FND_API.G_MISS_CHAR)
3218: AND (p_attribute5 = FND_API.G_MISS_CHAR)
3219: AND (p_attribute6 = FND_API.G_MISS_CHAR)

Line 3216: AND (p_attribute3 = FND_API.G_MISS_CHAR)

3212: -- OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CONTEXT');
3213:
3214: IF (p_attribute1 = FND_API.G_MISS_CHAR)
3215: AND (p_attribute2 = FND_API.G_MISS_CHAR)
3216: AND (p_attribute3 = FND_API.G_MISS_CHAR)
3217: AND (p_attribute4 = FND_API.G_MISS_CHAR)
3218: AND (p_attribute5 = FND_API.G_MISS_CHAR)
3219: AND (p_attribute6 = FND_API.G_MISS_CHAR)
3220: AND (p_attribute7 = FND_API.G_MISS_CHAR)

Line 3217: AND (p_attribute4 = FND_API.G_MISS_CHAR)

3213:
3214: IF (p_attribute1 = FND_API.G_MISS_CHAR)
3215: AND (p_attribute2 = FND_API.G_MISS_CHAR)
3216: AND (p_attribute3 = FND_API.G_MISS_CHAR)
3217: AND (p_attribute4 = FND_API.G_MISS_CHAR)
3218: AND (p_attribute5 = FND_API.G_MISS_CHAR)
3219: AND (p_attribute6 = FND_API.G_MISS_CHAR)
3220: AND (p_attribute7 = FND_API.G_MISS_CHAR)
3221: AND (p_attribute8 = FND_API.G_MISS_CHAR)

Line 3218: AND (p_attribute5 = FND_API.G_MISS_CHAR)

3214: IF (p_attribute1 = FND_API.G_MISS_CHAR)
3215: AND (p_attribute2 = FND_API.G_MISS_CHAR)
3216: AND (p_attribute3 = FND_API.G_MISS_CHAR)
3217: AND (p_attribute4 = FND_API.G_MISS_CHAR)
3218: AND (p_attribute5 = FND_API.G_MISS_CHAR)
3219: AND (p_attribute6 = FND_API.G_MISS_CHAR)
3220: AND (p_attribute7 = FND_API.G_MISS_CHAR)
3221: AND (p_attribute8 = FND_API.G_MISS_CHAR)
3222: AND (p_attribute9 = FND_API.G_MISS_CHAR)

Line 3219: AND (p_attribute6 = FND_API.G_MISS_CHAR)

3215: AND (p_attribute2 = FND_API.G_MISS_CHAR)
3216: AND (p_attribute3 = FND_API.G_MISS_CHAR)
3217: AND (p_attribute4 = FND_API.G_MISS_CHAR)
3218: AND (p_attribute5 = FND_API.G_MISS_CHAR)
3219: AND (p_attribute6 = FND_API.G_MISS_CHAR)
3220: AND (p_attribute7 = FND_API.G_MISS_CHAR)
3221: AND (p_attribute8 = FND_API.G_MISS_CHAR)
3222: AND (p_attribute9 = FND_API.G_MISS_CHAR)
3223: AND (p_attribute10 = FND_API.G_MISS_CHAR)

Line 3220: AND (p_attribute7 = FND_API.G_MISS_CHAR)

3216: AND (p_attribute3 = FND_API.G_MISS_CHAR)
3217: AND (p_attribute4 = FND_API.G_MISS_CHAR)
3218: AND (p_attribute5 = FND_API.G_MISS_CHAR)
3219: AND (p_attribute6 = FND_API.G_MISS_CHAR)
3220: AND (p_attribute7 = FND_API.G_MISS_CHAR)
3221: AND (p_attribute8 = FND_API.G_MISS_CHAR)
3222: AND (p_attribute9 = FND_API.G_MISS_CHAR)
3223: AND (p_attribute10 = FND_API.G_MISS_CHAR)
3224: AND (p_attribute11 = FND_API.G_MISS_CHAR)

Line 3221: AND (p_attribute8 = FND_API.G_MISS_CHAR)

3217: AND (p_attribute4 = FND_API.G_MISS_CHAR)
3218: AND (p_attribute5 = FND_API.G_MISS_CHAR)
3219: AND (p_attribute6 = FND_API.G_MISS_CHAR)
3220: AND (p_attribute7 = FND_API.G_MISS_CHAR)
3221: AND (p_attribute8 = FND_API.G_MISS_CHAR)
3222: AND (p_attribute9 = FND_API.G_MISS_CHAR)
3223: AND (p_attribute10 = FND_API.G_MISS_CHAR)
3224: AND (p_attribute11 = FND_API.G_MISS_CHAR)
3225: AND (p_attribute12 = FND_API.G_MISS_CHAR)

Line 3222: AND (p_attribute9 = FND_API.G_MISS_CHAR)

3218: AND (p_attribute5 = FND_API.G_MISS_CHAR)
3219: AND (p_attribute6 = FND_API.G_MISS_CHAR)
3220: AND (p_attribute7 = FND_API.G_MISS_CHAR)
3221: AND (p_attribute8 = FND_API.G_MISS_CHAR)
3222: AND (p_attribute9 = FND_API.G_MISS_CHAR)
3223: AND (p_attribute10 = FND_API.G_MISS_CHAR)
3224: AND (p_attribute11 = FND_API.G_MISS_CHAR)
3225: AND (p_attribute12 = FND_API.G_MISS_CHAR)
3226: AND (p_attribute13 = FND_API.G_MISS_CHAR)

Line 3223: AND (p_attribute10 = FND_API.G_MISS_CHAR)

3219: AND (p_attribute6 = FND_API.G_MISS_CHAR)
3220: AND (p_attribute7 = FND_API.G_MISS_CHAR)
3221: AND (p_attribute8 = FND_API.G_MISS_CHAR)
3222: AND (p_attribute9 = FND_API.G_MISS_CHAR)
3223: AND (p_attribute10 = FND_API.G_MISS_CHAR)
3224: AND (p_attribute11 = FND_API.G_MISS_CHAR)
3225: AND (p_attribute12 = FND_API.G_MISS_CHAR)
3226: AND (p_attribute13 = FND_API.G_MISS_CHAR)
3227: AND (p_attribute14 = FND_API.G_MISS_CHAR)

Line 3224: AND (p_attribute11 = FND_API.G_MISS_CHAR)

3220: AND (p_attribute7 = FND_API.G_MISS_CHAR)
3221: AND (p_attribute8 = FND_API.G_MISS_CHAR)
3222: AND (p_attribute9 = FND_API.G_MISS_CHAR)
3223: AND (p_attribute10 = FND_API.G_MISS_CHAR)
3224: AND (p_attribute11 = FND_API.G_MISS_CHAR)
3225: AND (p_attribute12 = FND_API.G_MISS_CHAR)
3226: AND (p_attribute13 = FND_API.G_MISS_CHAR)
3227: AND (p_attribute14 = FND_API.G_MISS_CHAR)
3228: AND (p_attribute15 = FND_API.G_MISS_CHAR)

Line 3225: AND (p_attribute12 = FND_API.G_MISS_CHAR)

3221: AND (p_attribute8 = FND_API.G_MISS_CHAR)
3222: AND (p_attribute9 = FND_API.G_MISS_CHAR)
3223: AND (p_attribute10 = FND_API.G_MISS_CHAR)
3224: AND (p_attribute11 = FND_API.G_MISS_CHAR)
3225: AND (p_attribute12 = FND_API.G_MISS_CHAR)
3226: AND (p_attribute13 = FND_API.G_MISS_CHAR)
3227: AND (p_attribute14 = FND_API.G_MISS_CHAR)
3228: AND (p_attribute15 = FND_API.G_MISS_CHAR)
3229: AND (p_context = FND_API.G_MISS_CHAR) THEN

Line 3226: AND (p_attribute13 = FND_API.G_MISS_CHAR)

3222: AND (p_attribute9 = FND_API.G_MISS_CHAR)
3223: AND (p_attribute10 = FND_API.G_MISS_CHAR)
3224: AND (p_attribute11 = FND_API.G_MISS_CHAR)
3225: AND (p_attribute12 = FND_API.G_MISS_CHAR)
3226: AND (p_attribute13 = FND_API.G_MISS_CHAR)
3227: AND (p_attribute14 = FND_API.G_MISS_CHAR)
3228: AND (p_attribute15 = FND_API.G_MISS_CHAR)
3229: AND (p_context = FND_API.G_MISS_CHAR) THEN
3230:

Line 3227: AND (p_attribute14 = FND_API.G_MISS_CHAR)

3223: AND (p_attribute10 = FND_API.G_MISS_CHAR)
3224: AND (p_attribute11 = FND_API.G_MISS_CHAR)
3225: AND (p_attribute12 = FND_API.G_MISS_CHAR)
3226: AND (p_attribute13 = FND_API.G_MISS_CHAR)
3227: AND (p_attribute14 = FND_API.G_MISS_CHAR)
3228: AND (p_attribute15 = FND_API.G_MISS_CHAR)
3229: AND (p_context = FND_API.G_MISS_CHAR) THEN
3230:
3231:

Line 3228: AND (p_attribute15 = FND_API.G_MISS_CHAR)

3224: AND (p_attribute11 = FND_API.G_MISS_CHAR)
3225: AND (p_attribute12 = FND_API.G_MISS_CHAR)
3226: AND (p_attribute13 = FND_API.G_MISS_CHAR)
3227: AND (p_attribute14 = FND_API.G_MISS_CHAR)
3228: AND (p_attribute15 = FND_API.G_MISS_CHAR)
3229: AND (p_context = FND_API.G_MISS_CHAR) THEN
3230:
3231:
3232: RETURN TRUE;

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

3225: AND (p_attribute12 = FND_API.G_MISS_CHAR)
3226: AND (p_attribute13 = FND_API.G_MISS_CHAR)
3227: AND (p_attribute14 = FND_API.G_MISS_CHAR)
3228: AND (p_attribute15 = FND_API.G_MISS_CHAR)
3229: AND (p_context = FND_API.G_MISS_CHAR) THEN
3230:
3231:
3232: RETURN TRUE;
3233:

Line 3237: IF p_attribute1 = FND_API.G_MISS_CHAR THEN

3233:
3234: ELSE
3235:
3236:
3237: IF p_attribute1 = FND_API.G_MISS_CHAR THEN
3238:
3239: l_column_value := null;
3240:
3241: ELSE

Line 3252: IF p_attribute2 = FND_API.G_MISS_CHAR THEN

3248: ( column_name => 'ATTRIBUTE1'
3249: , column_value => l_column_value);
3250:
3251:
3252: IF p_attribute2 = FND_API.G_MISS_CHAR THEN
3253:
3254: l_column_value := null;
3255:
3256: ELSE

Line 3265: IF p_attribute3 = FND_API.G_MISS_CHAR THEN

3261: FND_FLEX_DESCVAL.Set_Column_Value
3262: ( column_name => 'ATTRIBUTE2'
3263: , column_value => l_column_value);
3264:
3265: IF p_attribute3 = FND_API.G_MISS_CHAR THEN
3266:
3267: l_column_value := null;
3268:
3269: ELSE

Line 3278: IF p_attribute4 = FND_API.G_MISS_CHAR THEN

3274: FND_FLEX_DESCVAL.Set_Column_Value
3275: ( column_name => 'ATTRIBUTE3'
3276: , column_value => l_column_value);
3277:
3278: IF p_attribute4 = FND_API.G_MISS_CHAR THEN
3279:
3280: l_column_value := null;
3281:
3282: ELSE

Line 3291: IF p_attribute5 = FND_API.G_MISS_CHAR THEN

3287: FND_FLEX_DESCVAL.Set_Column_Value
3288: ( column_name => 'ATTRIBUTE4'
3289: , column_value => l_column_value);
3290:
3291: IF p_attribute5 = FND_API.G_MISS_CHAR THEN
3292:
3293: l_column_value := null;
3294:
3295: ELSE

Line 3304: IF p_attribute6 = FND_API.G_MISS_CHAR THEN

3300: FND_FLEX_DESCVAL.Set_Column_Value
3301: ( column_name => 'ATTRIBUTE5'
3302: , column_value => l_column_value);
3303:
3304: IF p_attribute6 = FND_API.G_MISS_CHAR THEN
3305:
3306: l_column_value := null;
3307:
3308: ELSE

Line 3317: IF p_attribute7 = FND_API.G_MISS_CHAR THEN

3313: FND_FLEX_DESCVAL.Set_Column_Value
3314: ( column_name => 'ATTRIBUTE6'
3315: , column_value => l_column_value);
3316:
3317: IF p_attribute7 = FND_API.G_MISS_CHAR THEN
3318:
3319: l_column_value := null;
3320:
3321: ELSE

Line 3330: IF p_attribute8 = FND_API.G_MISS_CHAR THEN

3326: FND_FLEX_DESCVAL.Set_Column_Value
3327: ( column_name => 'ATTRIBUTE7'
3328: , column_value => l_column_value);
3329:
3330: IF p_attribute8 = FND_API.G_MISS_CHAR THEN
3331:
3332: l_column_value := null;
3333:
3334: ELSE

Line 3343: IF p_attribute9 = FND_API.G_MISS_CHAR THEN

3339: FND_FLEX_DESCVAL.Set_Column_Value
3340: ( column_name => 'ATTRIBUTE8'
3341: , column_value => l_column_value);
3342:
3343: IF p_attribute9 = FND_API.G_MISS_CHAR THEN
3344:
3345: l_column_value := null;
3346:
3347: ELSE

Line 3356: IF p_attribute10 = FND_API.G_MISS_CHAR THEN

3352: FND_FLEX_DESCVAL.Set_Column_Value
3353: ( column_name => 'ATTRIBUTE9'
3354: , column_value => l_column_value);
3355:
3356: IF p_attribute10 = FND_API.G_MISS_CHAR THEN
3357:
3358: l_column_value := null;
3359:
3360: ELSE

Line 3369: IF p_attribute11 = FND_API.G_MISS_CHAR THEN

3365: FND_FLEX_DESCVAL.Set_Column_Value
3366: ( column_name => 'ATTRIBUTE10'
3367: , column_value => l_column_value);
3368:
3369: IF p_attribute11 = FND_API.G_MISS_CHAR THEN
3370:
3371: l_column_value := null;
3372:
3373: ELSE

Line 3382: IF p_attribute12 = FND_API.G_MISS_CHAR THEN

3378: FND_FLEX_DESCVAL.Set_Column_Value
3379: ( column_name => 'ATTRIBUTE11'
3380: , column_value => l_column_value);
3381:
3382: IF p_attribute12 = FND_API.G_MISS_CHAR THEN
3383:
3384: l_column_value := null;
3385:
3386: ELSE

Line 3395: IF p_attribute13 = FND_API.G_MISS_CHAR THEN

3391: FND_FLEX_DESCVAL.Set_Column_Value
3392: ( column_name => 'ATTRIBUTE12'
3393: , column_value => l_column_value);
3394:
3395: IF p_attribute13 = FND_API.G_MISS_CHAR THEN
3396:
3397: l_column_value := null;
3398:
3399: ELSE

Line 3408: IF p_attribute14 = FND_API.G_MISS_CHAR THEN

3404: FND_FLEX_DESCVAL.Set_Column_Value
3405: ( column_name => 'ATTRIBUTE13'
3406: , column_value => l_column_value);
3407:
3408: IF p_attribute14 = FND_API.G_MISS_CHAR THEN
3409:
3410: l_column_value := null;
3411:
3412: ELSE

Line 3421: IF p_attribute15 = FND_API.G_MISS_CHAR THEN

3417: FND_FLEX_DESCVAL.Set_Column_Value
3418: ( column_name => 'ATTRIBUTE14'
3419: , column_value => l_column_value);
3420:
3421: IF p_attribute15 = FND_API.G_MISS_CHAR THEN
3422:
3423: l_column_value := null;
3424:
3425: ELSE

Line 3434: IF p_context = FND_API.G_MISS_CHAR THEN

3430: FND_FLEX_DESCVAL.Set_Column_Value
3431: ( column_name => 'ATTRIBUTE15'
3432: , column_value => l_column_value);
3433:
3434: IF p_context = FND_API.G_MISS_CHAR THEN
3435:
3436: l_column_value := null;
3437:
3438: ELSE

Line 3483: p_flex_title = FND_API.G_MISS_CHAR

3479: l_dummy VARCHAR2(10);
3480: BEGIN
3481:
3482: IF p_flex_title IS NULL OR
3483: p_flex_title = FND_API.G_MISS_CHAR
3484: THEN
3485: RETURN TRUE;
3486: END IF;
3487:

Line 3520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3516: , 'Flex_Title'
3517: );
3518: END IF;
3519:
3520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3521:
3522: END Flex_Title;
3523:
3524: FUNCTION Order_Price_Attrib ( p_order_price_attrib_id IN NUMBER )

Line 3531: p_order_price_attrib_id = FND_API.G_MISS_NUM

3527: l_dummy VARCHAR2(10);
3528: BEGIN
3529:
3530: IF p_order_price_attrib_id IS NULL OR
3531: p_order_price_attrib_id = FND_API.G_MISS_NUM
3532: THEN
3533: RETURN TRUE;
3534: END IF;
3535:

Line 3568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3564: , 'Order_Price_Attrib'
3565: );
3566: END IF;
3567:
3568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3569:
3570: END Order_Price_Attrib;
3571:
3572: -- END GEN validate