APPS.CSI_TXN_ERRORS_PKG dependencies on FND_API

Line 59: IF (px_transaction_error_id IS NULL) OR (px_transaction_error_id = fnd_api.g_miss_num) THEN

55: is
56: CURSOR c2 IS SELECT csi_txn_errors_s.nextval FROM sys.dual;
57: v_transaction_error_date DATE;
58: BEGIN
59: IF (px_transaction_error_id IS NULL) OR (px_transaction_error_id = fnd_api.g_miss_num) THEN
60: OPEN c2;
61: FETCH c2 INTO px_transaction_error_id;
62: CLOSE c2;
63: END IF;

Line 65: IF ((p_transaction_error_date = FND_API.G_MISS_DATE) OR

61: FETCH c2 INTO px_transaction_error_id;
62: CLOSE c2;
63: END IF;
64:
65: IF ((p_transaction_error_date = FND_API.G_MISS_DATE) OR
66: (p_transaction_error_date IS NULL))
67: THEN
68: v_transaction_error_date := SYSDATE;
69: END IF;

Line 112: decode( p_transaction_id, fnd_api.g_miss_num, NULL, p_transaction_id),

108: dst_lot_ctrl_code,
109: dst_rev_qty_ctrl_code,
110: comms_nl_trackable_flag)
111: VALUES (px_transaction_error_id,
112: decode( p_transaction_id, fnd_api.g_miss_num, NULL, p_transaction_id),
113: decode( p_message_id, fnd_api.g_miss_num, NULL, p_message_id),
114: decode( p_error_text, fnd_api.g_miss_char, NULL, p_error_text),
115: decode( p_source_type, fnd_api.g_miss_char, NULL, p_source_type),
116: decode( p_source_id, fnd_api.g_miss_num, NULL, p_source_id),

Line 113: decode( p_message_id, fnd_api.g_miss_num, NULL, p_message_id),

109: dst_rev_qty_ctrl_code,
110: comms_nl_trackable_flag)
111: VALUES (px_transaction_error_id,
112: decode( p_transaction_id, fnd_api.g_miss_num, NULL, p_transaction_id),
113: decode( p_message_id, fnd_api.g_miss_num, NULL, p_message_id),
114: decode( p_error_text, fnd_api.g_miss_char, NULL, p_error_text),
115: decode( p_source_type, fnd_api.g_miss_char, NULL, p_source_type),
116: decode( p_source_id, fnd_api.g_miss_num, NULL, p_source_id),
117: decode( p_processed_flag, fnd_api.g_miss_char, NULL, p_processed_flag),

Line 114: decode( p_error_text, fnd_api.g_miss_char, NULL, p_error_text),

110: comms_nl_trackable_flag)
111: VALUES (px_transaction_error_id,
112: decode( p_transaction_id, fnd_api.g_miss_num, NULL, p_transaction_id),
113: decode( p_message_id, fnd_api.g_miss_num, NULL, p_message_id),
114: decode( p_error_text, fnd_api.g_miss_char, NULL, p_error_text),
115: decode( p_source_type, fnd_api.g_miss_char, NULL, p_source_type),
116: decode( p_source_id, fnd_api.g_miss_num, NULL, p_source_id),
117: decode( p_processed_flag, fnd_api.g_miss_char, NULL, p_processed_flag),
118: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),

Line 115: decode( p_source_type, fnd_api.g_miss_char, NULL, p_source_type),

111: VALUES (px_transaction_error_id,
112: decode( p_transaction_id, fnd_api.g_miss_num, NULL, p_transaction_id),
113: decode( p_message_id, fnd_api.g_miss_num, NULL, p_message_id),
114: decode( p_error_text, fnd_api.g_miss_char, NULL, p_error_text),
115: decode( p_source_type, fnd_api.g_miss_char, NULL, p_source_type),
116: decode( p_source_id, fnd_api.g_miss_num, NULL, p_source_id),
117: decode( p_processed_flag, fnd_api.g_miss_char, NULL, p_processed_flag),
118: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
119: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),

Line 116: decode( p_source_id, fnd_api.g_miss_num, NULL, p_source_id),

112: decode( p_transaction_id, fnd_api.g_miss_num, NULL, p_transaction_id),
113: decode( p_message_id, fnd_api.g_miss_num, NULL, p_message_id),
114: decode( p_error_text, fnd_api.g_miss_char, NULL, p_error_text),
115: decode( p_source_type, fnd_api.g_miss_char, NULL, p_source_type),
116: decode( p_source_id, fnd_api.g_miss_num, NULL, p_source_id),
117: decode( p_processed_flag, fnd_api.g_miss_char, NULL, p_processed_flag),
118: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
119: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
120: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),

Line 117: decode( p_processed_flag, fnd_api.g_miss_char, NULL, p_processed_flag),

113: decode( p_message_id, fnd_api.g_miss_num, NULL, p_message_id),
114: decode( p_error_text, fnd_api.g_miss_char, NULL, p_error_text),
115: decode( p_source_type, fnd_api.g_miss_char, NULL, p_source_type),
116: decode( p_source_id, fnd_api.g_miss_num, NULL, p_source_id),
117: decode( p_processed_flag, fnd_api.g_miss_char, NULL, p_processed_flag),
118: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
119: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
120: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
121: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),

Line 118: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),

114: decode( p_error_text, fnd_api.g_miss_char, NULL, p_error_text),
115: decode( p_source_type, fnd_api.g_miss_char, NULL, p_source_type),
116: decode( p_source_id, fnd_api.g_miss_num, NULL, p_source_id),
117: decode( p_processed_flag, fnd_api.g_miss_char, NULL, p_processed_flag),
118: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
119: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
120: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
121: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
122: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),

Line 119: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),

115: decode( p_source_type, fnd_api.g_miss_char, NULL, p_source_type),
116: decode( p_source_id, fnd_api.g_miss_num, NULL, p_source_id),
117: decode( p_processed_flag, fnd_api.g_miss_char, NULL, p_processed_flag),
118: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
119: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
120: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
121: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
122: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
123: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),

Line 120: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),

116: decode( p_source_id, fnd_api.g_miss_num, NULL, p_source_id),
117: decode( p_processed_flag, fnd_api.g_miss_char, NULL, p_processed_flag),
118: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
119: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
120: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
121: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
122: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
123: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
124: decode( p_transaction_type_id, fnd_api.g_miss_num , NULL, p_transaction_type_id),

Line 121: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),

117: decode( p_processed_flag, fnd_api.g_miss_char, NULL, p_processed_flag),
118: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
119: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
120: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
121: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
122: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
123: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
124: decode( p_transaction_type_id, fnd_api.g_miss_num , NULL, p_transaction_type_id),
125: decode( p_source_group_ref, fnd_api.g_miss_char, NULL, p_source_group_ref),

Line 122: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),

118: decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
119: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
120: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
121: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
122: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
123: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
124: decode( p_transaction_type_id, fnd_api.g_miss_num , NULL, p_transaction_type_id),
125: decode( p_source_group_ref, fnd_api.g_miss_char, NULL, p_source_group_ref),
126: decode( p_source_group_ref_id, fnd_api.g_miss_num , NULL, p_source_group_ref_id),

Line 123: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),

119: decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
120: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
121: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
122: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
123: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
124: decode( p_transaction_type_id, fnd_api.g_miss_num , NULL, p_transaction_type_id),
125: decode( p_source_group_ref, fnd_api.g_miss_char, NULL, p_source_group_ref),
126: decode( p_source_group_ref_id, fnd_api.g_miss_num , NULL, p_source_group_ref_id),
127: decode( p_source_header_ref, fnd_api.g_miss_char, NULL, p_source_header_ref),

Line 124: decode( p_transaction_type_id, fnd_api.g_miss_num , NULL, p_transaction_type_id),

120: decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
121: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
122: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
123: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
124: decode( p_transaction_type_id, fnd_api.g_miss_num , NULL, p_transaction_type_id),
125: decode( p_source_group_ref, fnd_api.g_miss_char, NULL, p_source_group_ref),
126: decode( p_source_group_ref_id, fnd_api.g_miss_num , NULL, p_source_group_ref_id),
127: decode( p_source_header_ref, fnd_api.g_miss_char, NULL, p_source_header_ref),
128: decode( p_source_header_ref_id, fnd_api.g_miss_num, NULL, p_source_header_ref_id),

Line 125: decode( p_source_group_ref, fnd_api.g_miss_char, NULL, p_source_group_ref),

121: decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
122: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
123: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
124: decode( p_transaction_type_id, fnd_api.g_miss_num , NULL, p_transaction_type_id),
125: decode( p_source_group_ref, fnd_api.g_miss_char, NULL, p_source_group_ref),
126: decode( p_source_group_ref_id, fnd_api.g_miss_num , NULL, p_source_group_ref_id),
127: decode( p_source_header_ref, fnd_api.g_miss_char, NULL, p_source_header_ref),
128: decode( p_source_header_ref_id, fnd_api.g_miss_num, NULL, p_source_header_ref_id),
129: decode( p_source_line_ref, fnd_api.g_miss_char, NULL, p_source_line_ref),

Line 126: decode( p_source_group_ref_id, fnd_api.g_miss_num , NULL, p_source_group_ref_id),

122: decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
123: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
124: decode( p_transaction_type_id, fnd_api.g_miss_num , NULL, p_transaction_type_id),
125: decode( p_source_group_ref, fnd_api.g_miss_char, NULL, p_source_group_ref),
126: decode( p_source_group_ref_id, fnd_api.g_miss_num , NULL, p_source_group_ref_id),
127: decode( p_source_header_ref, fnd_api.g_miss_char, NULL, p_source_header_ref),
128: decode( p_source_header_ref_id, fnd_api.g_miss_num, NULL, p_source_header_ref_id),
129: decode( p_source_line_ref, fnd_api.g_miss_char, NULL, p_source_line_ref),
130: decode( p_source_line_ref_id, fnd_api.g_miss_num ,NULL, p_source_line_ref_id),

Line 127: decode( p_source_header_ref, fnd_api.g_miss_char, NULL, p_source_header_ref),

123: decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
124: decode( p_transaction_type_id, fnd_api.g_miss_num , NULL, p_transaction_type_id),
125: decode( p_source_group_ref, fnd_api.g_miss_char, NULL, p_source_group_ref),
126: decode( p_source_group_ref_id, fnd_api.g_miss_num , NULL, p_source_group_ref_id),
127: decode( p_source_header_ref, fnd_api.g_miss_char, NULL, p_source_header_ref),
128: decode( p_source_header_ref_id, fnd_api.g_miss_num, NULL, p_source_header_ref_id),
129: decode( p_source_line_ref, fnd_api.g_miss_char, NULL, p_source_line_ref),
130: decode( p_source_line_ref_id, fnd_api.g_miss_num ,NULL, p_source_line_ref_id),
131: decode( p_source_dist_ref_id1, fnd_api.g_miss_num ,NULL, p_source_dist_ref_id1),

Line 128: decode( p_source_header_ref_id, fnd_api.g_miss_num, NULL, p_source_header_ref_id),

124: decode( p_transaction_type_id, fnd_api.g_miss_num , NULL, p_transaction_type_id),
125: decode( p_source_group_ref, fnd_api.g_miss_char, NULL, p_source_group_ref),
126: decode( p_source_group_ref_id, fnd_api.g_miss_num , NULL, p_source_group_ref_id),
127: decode( p_source_header_ref, fnd_api.g_miss_char, NULL, p_source_header_ref),
128: decode( p_source_header_ref_id, fnd_api.g_miss_num, NULL, p_source_header_ref_id),
129: decode( p_source_line_ref, fnd_api.g_miss_char, NULL, p_source_line_ref),
130: decode( p_source_line_ref_id, fnd_api.g_miss_num ,NULL, p_source_line_ref_id),
131: decode( p_source_dist_ref_id1, fnd_api.g_miss_num ,NULL, p_source_dist_ref_id1),
132: decode( p_source_dist_ref_id2, fnd_api.g_miss_num , NULL, p_source_dist_ref_id2),

Line 129: decode( p_source_line_ref, fnd_api.g_miss_char, NULL, p_source_line_ref),

125: decode( p_source_group_ref, fnd_api.g_miss_char, NULL, p_source_group_ref),
126: decode( p_source_group_ref_id, fnd_api.g_miss_num , NULL, p_source_group_ref_id),
127: decode( p_source_header_ref, fnd_api.g_miss_char, NULL, p_source_header_ref),
128: decode( p_source_header_ref_id, fnd_api.g_miss_num, NULL, p_source_header_ref_id),
129: decode( p_source_line_ref, fnd_api.g_miss_char, NULL, p_source_line_ref),
130: decode( p_source_line_ref_id, fnd_api.g_miss_num ,NULL, p_source_line_ref_id),
131: decode( p_source_dist_ref_id1, fnd_api.g_miss_num ,NULL, p_source_dist_ref_id1),
132: decode( p_source_dist_ref_id2, fnd_api.g_miss_num , NULL, p_source_dist_ref_id2),
133: decode( p_inv_material_transaction_id, fnd_api.g_miss_num ,NULL,p_inv_material_transaction_id),

Line 130: decode( p_source_line_ref_id, fnd_api.g_miss_num ,NULL, p_source_line_ref_id),

126: decode( p_source_group_ref_id, fnd_api.g_miss_num , NULL, p_source_group_ref_id),
127: decode( p_source_header_ref, fnd_api.g_miss_char, NULL, p_source_header_ref),
128: decode( p_source_header_ref_id, fnd_api.g_miss_num, NULL, p_source_header_ref_id),
129: decode( p_source_line_ref, fnd_api.g_miss_char, NULL, p_source_line_ref),
130: decode( p_source_line_ref_id, fnd_api.g_miss_num ,NULL, p_source_line_ref_id),
131: decode( p_source_dist_ref_id1, fnd_api.g_miss_num ,NULL, p_source_dist_ref_id1),
132: decode( p_source_dist_ref_id2, fnd_api.g_miss_num , NULL, p_source_dist_ref_id2),
133: decode( p_inv_material_transaction_id, fnd_api.g_miss_num ,NULL,p_inv_material_transaction_id),
134: decode( p_error_stage, fnd_api.g_miss_char ,NULL,p_error_stage),

Line 131: decode( p_source_dist_ref_id1, fnd_api.g_miss_num ,NULL, p_source_dist_ref_id1),

127: decode( p_source_header_ref, fnd_api.g_miss_char, NULL, p_source_header_ref),
128: decode( p_source_header_ref_id, fnd_api.g_miss_num, NULL, p_source_header_ref_id),
129: decode( p_source_line_ref, fnd_api.g_miss_char, NULL, p_source_line_ref),
130: decode( p_source_line_ref_id, fnd_api.g_miss_num ,NULL, p_source_line_ref_id),
131: decode( p_source_dist_ref_id1, fnd_api.g_miss_num ,NULL, p_source_dist_ref_id1),
132: decode( p_source_dist_ref_id2, fnd_api.g_miss_num , NULL, p_source_dist_ref_id2),
133: decode( p_inv_material_transaction_id, fnd_api.g_miss_num ,NULL,p_inv_material_transaction_id),
134: decode( p_error_stage, fnd_api.g_miss_char ,NULL,p_error_stage),
135: decode( p_message_string, fnd_api.g_miss_char ,NULL,p_message_string),

Line 132: decode( p_source_dist_ref_id2, fnd_api.g_miss_num , NULL, p_source_dist_ref_id2),

128: decode( p_source_header_ref_id, fnd_api.g_miss_num, NULL, p_source_header_ref_id),
129: decode( p_source_line_ref, fnd_api.g_miss_char, NULL, p_source_line_ref),
130: decode( p_source_line_ref_id, fnd_api.g_miss_num ,NULL, p_source_line_ref_id),
131: decode( p_source_dist_ref_id1, fnd_api.g_miss_num ,NULL, p_source_dist_ref_id1),
132: decode( p_source_dist_ref_id2, fnd_api.g_miss_num , NULL, p_source_dist_ref_id2),
133: decode( p_inv_material_transaction_id, fnd_api.g_miss_num ,NULL,p_inv_material_transaction_id),
134: decode( p_error_stage, fnd_api.g_miss_char ,NULL,p_error_stage),
135: decode( p_message_string, fnd_api.g_miss_char ,NULL,p_message_string),
136: decode( p_instance_id, fnd_api.g_miss_num , NULL, p_instance_id),

Line 133: decode( p_inv_material_transaction_id, fnd_api.g_miss_num ,NULL,p_inv_material_transaction_id),

129: decode( p_source_line_ref, fnd_api.g_miss_char, NULL, p_source_line_ref),
130: decode( p_source_line_ref_id, fnd_api.g_miss_num ,NULL, p_source_line_ref_id),
131: decode( p_source_dist_ref_id1, fnd_api.g_miss_num ,NULL, p_source_dist_ref_id1),
132: decode( p_source_dist_ref_id2, fnd_api.g_miss_num , NULL, p_source_dist_ref_id2),
133: decode( p_inv_material_transaction_id, fnd_api.g_miss_num ,NULL,p_inv_material_transaction_id),
134: decode( p_error_stage, fnd_api.g_miss_char ,NULL,p_error_stage),
135: decode( p_message_string, fnd_api.g_miss_char ,NULL,p_message_string),
136: decode( p_instance_id, fnd_api.g_miss_num , NULL, p_instance_id),
137: decode( p_inventory_item_id, fnd_api.g_miss_num , NULL, p_inventory_item_id),

Line 134: decode( p_error_stage, fnd_api.g_miss_char ,NULL,p_error_stage),

130: decode( p_source_line_ref_id, fnd_api.g_miss_num ,NULL, p_source_line_ref_id),
131: decode( p_source_dist_ref_id1, fnd_api.g_miss_num ,NULL, p_source_dist_ref_id1),
132: decode( p_source_dist_ref_id2, fnd_api.g_miss_num , NULL, p_source_dist_ref_id2),
133: decode( p_inv_material_transaction_id, fnd_api.g_miss_num ,NULL,p_inv_material_transaction_id),
134: decode( p_error_stage, fnd_api.g_miss_char ,NULL,p_error_stage),
135: decode( p_message_string, fnd_api.g_miss_char ,NULL,p_message_string),
136: decode( p_instance_id, fnd_api.g_miss_num , NULL, p_instance_id),
137: decode( p_inventory_item_id, fnd_api.g_miss_num , NULL, p_inventory_item_id),
138: decode( p_serial_number, fnd_api.g_miss_char ,NULL,p_serial_number),

Line 135: decode( p_message_string, fnd_api.g_miss_char ,NULL,p_message_string),

131: decode( p_source_dist_ref_id1, fnd_api.g_miss_num ,NULL, p_source_dist_ref_id1),
132: decode( p_source_dist_ref_id2, fnd_api.g_miss_num , NULL, p_source_dist_ref_id2),
133: decode( p_inv_material_transaction_id, fnd_api.g_miss_num ,NULL,p_inv_material_transaction_id),
134: decode( p_error_stage, fnd_api.g_miss_char ,NULL,p_error_stage),
135: decode( p_message_string, fnd_api.g_miss_char ,NULL,p_message_string),
136: decode( p_instance_id, fnd_api.g_miss_num , NULL, p_instance_id),
137: decode( p_inventory_item_id, fnd_api.g_miss_num , NULL, p_inventory_item_id),
138: decode( p_serial_number, fnd_api.g_miss_char ,NULL,p_serial_number),
139: decode( p_lot_number, fnd_api.g_miss_char ,NULL,p_lot_number),

Line 136: decode( p_instance_id, fnd_api.g_miss_num , NULL, p_instance_id),

132: decode( p_source_dist_ref_id2, fnd_api.g_miss_num , NULL, p_source_dist_ref_id2),
133: decode( p_inv_material_transaction_id, fnd_api.g_miss_num ,NULL,p_inv_material_transaction_id),
134: decode( p_error_stage, fnd_api.g_miss_char ,NULL,p_error_stage),
135: decode( p_message_string, fnd_api.g_miss_char ,NULL,p_message_string),
136: decode( p_instance_id, fnd_api.g_miss_num , NULL, p_instance_id),
137: decode( p_inventory_item_id, fnd_api.g_miss_num , NULL, p_inventory_item_id),
138: decode( p_serial_number, fnd_api.g_miss_char ,NULL,p_serial_number),
139: decode( p_lot_number, fnd_api.g_miss_char ,NULL,p_lot_number),
140: decode( p_transaction_error_date,fnd_api.g_miss_date, v_transaction_error_date, p_transaction_error_date),

Line 137: decode( p_inventory_item_id, fnd_api.g_miss_num , NULL, p_inventory_item_id),

133: decode( p_inv_material_transaction_id, fnd_api.g_miss_num ,NULL,p_inv_material_transaction_id),
134: decode( p_error_stage, fnd_api.g_miss_char ,NULL,p_error_stage),
135: decode( p_message_string, fnd_api.g_miss_char ,NULL,p_message_string),
136: decode( p_instance_id, fnd_api.g_miss_num , NULL, p_instance_id),
137: decode( p_inventory_item_id, fnd_api.g_miss_num , NULL, p_inventory_item_id),
138: decode( p_serial_number, fnd_api.g_miss_char ,NULL,p_serial_number),
139: decode( p_lot_number, fnd_api.g_miss_char ,NULL,p_lot_number),
140: decode( p_transaction_error_date,fnd_api.g_miss_date, v_transaction_error_date, p_transaction_error_date),
141: decode( p_src_serial_num_ctrl_code, fnd_api.g_miss_num , NULL, p_src_serial_num_ctrl_code),

Line 138: decode( p_serial_number, fnd_api.g_miss_char ,NULL,p_serial_number),

134: decode( p_error_stage, fnd_api.g_miss_char ,NULL,p_error_stage),
135: decode( p_message_string, fnd_api.g_miss_char ,NULL,p_message_string),
136: decode( p_instance_id, fnd_api.g_miss_num , NULL, p_instance_id),
137: decode( p_inventory_item_id, fnd_api.g_miss_num , NULL, p_inventory_item_id),
138: decode( p_serial_number, fnd_api.g_miss_char ,NULL,p_serial_number),
139: decode( p_lot_number, fnd_api.g_miss_char ,NULL,p_lot_number),
140: decode( p_transaction_error_date,fnd_api.g_miss_date, v_transaction_error_date, p_transaction_error_date),
141: decode( p_src_serial_num_ctrl_code, fnd_api.g_miss_num , NULL, p_src_serial_num_ctrl_code),
142: decode( p_src_location_ctrl_code, fnd_api.g_miss_num , NULL, p_src_location_ctrl_code),

Line 139: decode( p_lot_number, fnd_api.g_miss_char ,NULL,p_lot_number),

135: decode( p_message_string, fnd_api.g_miss_char ,NULL,p_message_string),
136: decode( p_instance_id, fnd_api.g_miss_num , NULL, p_instance_id),
137: decode( p_inventory_item_id, fnd_api.g_miss_num , NULL, p_inventory_item_id),
138: decode( p_serial_number, fnd_api.g_miss_char ,NULL,p_serial_number),
139: decode( p_lot_number, fnd_api.g_miss_char ,NULL,p_lot_number),
140: decode( p_transaction_error_date,fnd_api.g_miss_date, v_transaction_error_date, p_transaction_error_date),
141: decode( p_src_serial_num_ctrl_code, fnd_api.g_miss_num , NULL, p_src_serial_num_ctrl_code),
142: decode( p_src_location_ctrl_code, fnd_api.g_miss_num , NULL, p_src_location_ctrl_code),
143: decode( p_src_lot_ctrl_code, fnd_api.g_miss_num , NULL, p_src_lot_ctrl_code),

Line 140: decode( p_transaction_error_date,fnd_api.g_miss_date, v_transaction_error_date, p_transaction_error_date),

136: decode( p_instance_id, fnd_api.g_miss_num , NULL, p_instance_id),
137: decode( p_inventory_item_id, fnd_api.g_miss_num , NULL, p_inventory_item_id),
138: decode( p_serial_number, fnd_api.g_miss_char ,NULL,p_serial_number),
139: decode( p_lot_number, fnd_api.g_miss_char ,NULL,p_lot_number),
140: decode( p_transaction_error_date,fnd_api.g_miss_date, v_transaction_error_date, p_transaction_error_date),
141: decode( p_src_serial_num_ctrl_code, fnd_api.g_miss_num , NULL, p_src_serial_num_ctrl_code),
142: decode( p_src_location_ctrl_code, fnd_api.g_miss_num , NULL, p_src_location_ctrl_code),
143: decode( p_src_lot_ctrl_code, fnd_api.g_miss_num , NULL, p_src_lot_ctrl_code),
144: decode( p_src_rev_qty_ctrl_code, fnd_api.g_miss_num , NULL, p_src_rev_qty_ctrl_code),

Line 141: decode( p_src_serial_num_ctrl_code, fnd_api.g_miss_num , NULL, p_src_serial_num_ctrl_code),

137: decode( p_inventory_item_id, fnd_api.g_miss_num , NULL, p_inventory_item_id),
138: decode( p_serial_number, fnd_api.g_miss_char ,NULL,p_serial_number),
139: decode( p_lot_number, fnd_api.g_miss_char ,NULL,p_lot_number),
140: decode( p_transaction_error_date,fnd_api.g_miss_date, v_transaction_error_date, p_transaction_error_date),
141: decode( p_src_serial_num_ctrl_code, fnd_api.g_miss_num , NULL, p_src_serial_num_ctrl_code),
142: decode( p_src_location_ctrl_code, fnd_api.g_miss_num , NULL, p_src_location_ctrl_code),
143: decode( p_src_lot_ctrl_code, fnd_api.g_miss_num , NULL, p_src_lot_ctrl_code),
144: decode( p_src_rev_qty_ctrl_code, fnd_api.g_miss_num , NULL, p_src_rev_qty_ctrl_code),
145: decode( p_dst_serial_num_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_serial_num_ctrl_code),

Line 142: decode( p_src_location_ctrl_code, fnd_api.g_miss_num , NULL, p_src_location_ctrl_code),

138: decode( p_serial_number, fnd_api.g_miss_char ,NULL,p_serial_number),
139: decode( p_lot_number, fnd_api.g_miss_char ,NULL,p_lot_number),
140: decode( p_transaction_error_date,fnd_api.g_miss_date, v_transaction_error_date, p_transaction_error_date),
141: decode( p_src_serial_num_ctrl_code, fnd_api.g_miss_num , NULL, p_src_serial_num_ctrl_code),
142: decode( p_src_location_ctrl_code, fnd_api.g_miss_num , NULL, p_src_location_ctrl_code),
143: decode( p_src_lot_ctrl_code, fnd_api.g_miss_num , NULL, p_src_lot_ctrl_code),
144: decode( p_src_rev_qty_ctrl_code, fnd_api.g_miss_num , NULL, p_src_rev_qty_ctrl_code),
145: decode( p_dst_serial_num_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_serial_num_ctrl_code),
146: decode( p_dst_location_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_location_ctrl_code),

Line 143: decode( p_src_lot_ctrl_code, fnd_api.g_miss_num , NULL, p_src_lot_ctrl_code),

139: decode( p_lot_number, fnd_api.g_miss_char ,NULL,p_lot_number),
140: decode( p_transaction_error_date,fnd_api.g_miss_date, v_transaction_error_date, p_transaction_error_date),
141: decode( p_src_serial_num_ctrl_code, fnd_api.g_miss_num , NULL, p_src_serial_num_ctrl_code),
142: decode( p_src_location_ctrl_code, fnd_api.g_miss_num , NULL, p_src_location_ctrl_code),
143: decode( p_src_lot_ctrl_code, fnd_api.g_miss_num , NULL, p_src_lot_ctrl_code),
144: decode( p_src_rev_qty_ctrl_code, fnd_api.g_miss_num , NULL, p_src_rev_qty_ctrl_code),
145: decode( p_dst_serial_num_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_serial_num_ctrl_code),
146: decode( p_dst_location_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_location_ctrl_code),
147: decode( p_dst_lot_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_lot_ctrl_code),

Line 144: decode( p_src_rev_qty_ctrl_code, fnd_api.g_miss_num , NULL, p_src_rev_qty_ctrl_code),

140: decode( p_transaction_error_date,fnd_api.g_miss_date, v_transaction_error_date, p_transaction_error_date),
141: decode( p_src_serial_num_ctrl_code, fnd_api.g_miss_num , NULL, p_src_serial_num_ctrl_code),
142: decode( p_src_location_ctrl_code, fnd_api.g_miss_num , NULL, p_src_location_ctrl_code),
143: decode( p_src_lot_ctrl_code, fnd_api.g_miss_num , NULL, p_src_lot_ctrl_code),
144: decode( p_src_rev_qty_ctrl_code, fnd_api.g_miss_num , NULL, p_src_rev_qty_ctrl_code),
145: decode( p_dst_serial_num_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_serial_num_ctrl_code),
146: decode( p_dst_location_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_location_ctrl_code),
147: decode( p_dst_lot_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_lot_ctrl_code),
148: decode( p_dst_rev_qty_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_rev_qty_ctrl_code),

Line 145: decode( p_dst_serial_num_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_serial_num_ctrl_code),

141: decode( p_src_serial_num_ctrl_code, fnd_api.g_miss_num , NULL, p_src_serial_num_ctrl_code),
142: decode( p_src_location_ctrl_code, fnd_api.g_miss_num , NULL, p_src_location_ctrl_code),
143: decode( p_src_lot_ctrl_code, fnd_api.g_miss_num , NULL, p_src_lot_ctrl_code),
144: decode( p_src_rev_qty_ctrl_code, fnd_api.g_miss_num , NULL, p_src_rev_qty_ctrl_code),
145: decode( p_dst_serial_num_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_serial_num_ctrl_code),
146: decode( p_dst_location_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_location_ctrl_code),
147: decode( p_dst_lot_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_lot_ctrl_code),
148: decode( p_dst_rev_qty_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_rev_qty_ctrl_code),
149: decode( p_comms_nl_trackable_flag, fnd_api.g_miss_char ,NULL,p_comms_nl_trackable_flag)

Line 146: decode( p_dst_location_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_location_ctrl_code),

142: decode( p_src_location_ctrl_code, fnd_api.g_miss_num , NULL, p_src_location_ctrl_code),
143: decode( p_src_lot_ctrl_code, fnd_api.g_miss_num , NULL, p_src_lot_ctrl_code),
144: decode( p_src_rev_qty_ctrl_code, fnd_api.g_miss_num , NULL, p_src_rev_qty_ctrl_code),
145: decode( p_dst_serial_num_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_serial_num_ctrl_code),
146: decode( p_dst_location_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_location_ctrl_code),
147: decode( p_dst_lot_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_lot_ctrl_code),
148: decode( p_dst_rev_qty_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_rev_qty_ctrl_code),
149: decode( p_comms_nl_trackable_flag, fnd_api.g_miss_char ,NULL,p_comms_nl_trackable_flag)
150: );

Line 147: decode( p_dst_lot_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_lot_ctrl_code),

143: decode( p_src_lot_ctrl_code, fnd_api.g_miss_num , NULL, p_src_lot_ctrl_code),
144: decode( p_src_rev_qty_ctrl_code, fnd_api.g_miss_num , NULL, p_src_rev_qty_ctrl_code),
145: decode( p_dst_serial_num_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_serial_num_ctrl_code),
146: decode( p_dst_location_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_location_ctrl_code),
147: decode( p_dst_lot_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_lot_ctrl_code),
148: decode( p_dst_rev_qty_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_rev_qty_ctrl_code),
149: decode( p_comms_nl_trackable_flag, fnd_api.g_miss_char ,NULL,p_comms_nl_trackable_flag)
150: );
151:

Line 148: decode( p_dst_rev_qty_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_rev_qty_ctrl_code),

144: decode( p_src_rev_qty_ctrl_code, fnd_api.g_miss_num , NULL, p_src_rev_qty_ctrl_code),
145: decode( p_dst_serial_num_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_serial_num_ctrl_code),
146: decode( p_dst_location_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_location_ctrl_code),
147: decode( p_dst_lot_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_lot_ctrl_code),
148: decode( p_dst_rev_qty_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_rev_qty_ctrl_code),
149: decode( p_comms_nl_trackable_flag, fnd_api.g_miss_char ,NULL,p_comms_nl_trackable_flag)
150: );
151:
152: -- commit;

Line 149: decode( p_comms_nl_trackable_flag, fnd_api.g_miss_char ,NULL,p_comms_nl_trackable_flag)

145: decode( p_dst_serial_num_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_serial_num_ctrl_code),
146: decode( p_dst_location_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_location_ctrl_code),
147: decode( p_dst_lot_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_lot_ctrl_code),
148: decode( p_dst_rev_qty_ctrl_code, fnd_api.g_miss_num , NULL, p_dst_rev_qty_ctrl_code),
149: decode( p_comms_nl_trackable_flag, fnd_api.g_miss_char ,NULL,p_comms_nl_trackable_flag)
150: );
151:
152: -- commit;
153: