APPS.HZ_ADAPTER_LOGS_PKG dependencies on FND_API

Line 22: x_adapter_log_id <> fnd_api.g_miss_num

18: BEGIN
19:
20:
21: IF x_adapter_log_id IS NOT NULL AND
22: x_adapter_log_id <> fnd_api.g_miss_num
23: THEN
24: l_primary_key_passed := TRUE;
25: END IF;
26:

Line 44: fnd_api.g_miss_num, hz_adapter_logs_s.NEXTVAL,

40: last_update_date,
41: last_updated_by
42: ) VALUES (
43: DECODE(x_adapter_log_id,
44: fnd_api.g_miss_num, hz_adapter_logs_s.NEXTVAL,
45: NULL, hz_adapter_logs_s.NEXTVAL,
46: x_adapter_log_id),
47: DECODE(x_created_by_module, fnd_api.g_miss_char, NULL, x_created_by_module),
48: DECODE(x_created_by_module_id, fnd_api.g_miss_num, NULL, x_created_by_module_id),

Line 47: DECODE(x_created_by_module, fnd_api.g_miss_char, NULL, x_created_by_module),

43: DECODE(x_adapter_log_id,
44: fnd_api.g_miss_num, hz_adapter_logs_s.NEXTVAL,
45: NULL, hz_adapter_logs_s.NEXTVAL,
46: x_adapter_log_id),
47: DECODE(x_created_by_module, fnd_api.g_miss_char, NULL, x_created_by_module),
48: DECODE(x_created_by_module_id, fnd_api.g_miss_num, NULL, x_created_by_module_id),
49: DECODE(x_http_status_code, fnd_api.g_miss_char, NULL, x_http_status_code),
50: --x_out_doc,
51: --x_in_doc,

Line 48: DECODE(x_created_by_module_id, fnd_api.g_miss_num, NULL, x_created_by_module_id),

44: fnd_api.g_miss_num, hz_adapter_logs_s.NEXTVAL,
45: NULL, hz_adapter_logs_s.NEXTVAL,
46: x_adapter_log_id),
47: DECODE(x_created_by_module, fnd_api.g_miss_char, NULL, x_created_by_module),
48: DECODE(x_created_by_module_id, fnd_api.g_miss_num, NULL, x_created_by_module_id),
49: DECODE(x_http_status_code, fnd_api.g_miss_char, NULL, x_http_status_code),
50: --x_out_doc,
51: --x_in_doc,
52: DECODE(x_object_version_number, fnd_api.g_miss_num, NULL, x_object_version_number),

Line 49: DECODE(x_http_status_code, fnd_api.g_miss_char, NULL, x_http_status_code),

45: NULL, hz_adapter_logs_s.NEXTVAL,
46: x_adapter_log_id),
47: DECODE(x_created_by_module, fnd_api.g_miss_char, NULL, x_created_by_module),
48: DECODE(x_created_by_module_id, fnd_api.g_miss_num, NULL, x_created_by_module_id),
49: DECODE(x_http_status_code, fnd_api.g_miss_char, NULL, x_http_status_code),
50: --x_out_doc,
51: --x_in_doc,
52: DECODE(x_object_version_number, fnd_api.g_miss_num, NULL, x_object_version_number),
53: hz_utility_v2pub.created_by,

Line 52: DECODE(x_object_version_number, fnd_api.g_miss_num, NULL, x_object_version_number),

48: DECODE(x_created_by_module_id, fnd_api.g_miss_num, NULL, x_created_by_module_id),
49: DECODE(x_http_status_code, fnd_api.g_miss_char, NULL, x_http_status_code),
50: --x_out_doc,
51: --x_in_doc,
52: DECODE(x_object_version_number, fnd_api.g_miss_num, NULL, x_object_version_number),
53: hz_utility_v2pub.created_by,
54: hz_utility_v2pub.creation_date,
55: hz_utility_v2pub.last_update_login,
56: hz_utility_v2pub.last_update_date,

Line 74: RAISE fnd_api.g_exc_error;

70: IF l_primary_key_passed THEN
71: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
72: fnd_message.set_token('COLUMN', 'adapter_log_id');
73: fnd_msg_pub.add;
74: RAISE fnd_api.g_exc_error;
75: END IF;
76:
77: DECLARE
78: l_temp_adptlog_id NUMBER;

Line 111: fnd_api.g_miss_num, NULL,

107: BEGIN
108: UPDATE HZ_ADAPTER_LOGS
109: SET adapter_log_id = DECODE(x_adapter_log_id,
110: NULL, adapter_log_id,
111: fnd_api.g_miss_num, NULL,
112: x_adapter_log_id),
113: created_by_module = DECODE(x_created_by_module,
114: NULL, created_by_module,
115: fnd_api.g_miss_char, NULL,

Line 115: fnd_api.g_miss_char, NULL,

111: fnd_api.g_miss_num, NULL,
112: x_adapter_log_id),
113: created_by_module = DECODE(x_created_by_module,
114: NULL, created_by_module,
115: fnd_api.g_miss_char, NULL,
116: x_created_by_module),
117: created_by_module_id = DECODE(x_created_by_module_id,
118: NULL, created_by_module_id,
119: fnd_api.g_miss_num, NULL,

Line 119: fnd_api.g_miss_num, NULL,

115: fnd_api.g_miss_char, NULL,
116: x_created_by_module),
117: created_by_module_id = DECODE(x_created_by_module_id,
118: NULL, created_by_module_id,
119: fnd_api.g_miss_num, NULL,
120: x_created_by_module_id),
121: http_status_code = DECODE(x_http_status_code,
122: NULL, http_status_code,
123: fnd_api.g_miss_char, NULL,

Line 123: fnd_api.g_miss_char, NULL,

119: fnd_api.g_miss_num, NULL,
120: x_created_by_module_id),
121: http_status_code = DECODE(x_http_status_code,
122: NULL, http_status_code,
123: fnd_api.g_miss_char, NULL,
124: x_http_status_code),
125: request_id = DECODE(x_request_id, NULL, request_id,
126: fnd_api.g_miss_num, NULL,
127: x_request_id),

Line 126: fnd_api.g_miss_num, NULL,

122: NULL, http_status_code,
123: fnd_api.g_miss_char, NULL,
124: x_http_status_code),
125: request_id = DECODE(x_request_id, NULL, request_id,
126: fnd_api.g_miss_num, NULL,
127: x_request_id),
128: --out_doc = DECODE(x_out_doc, NULL, out_doc, x_out_doc),
129: --in_doc = DECODE(x_in_doc, NULL, in_doc, x_in_doc),
130: last_update_date = hz_utility_v2pub.last_update_date,

Line 137: fnd_api.g_miss_num, NULL,

133: created_by = created_by,
134: last_update_login = hz_utility_v2pub.last_update_login,
135: object_version_number = DECODE(x_object_version_number,
136: NULL, object_version_number,
137: fnd_api.g_miss_num, NULL,
138: x_object_version_number)
139: where rowid = x_rowid;
140:
141: If (SQL%NOTFOUND) then