DBA Data[Home] [Help]

APPS.AMS_UPGRADE_TRACK_ERROR_PKG dependencies on FND_API

Line 64: DECODE( p_object_code, FND_API.g_miss_char, NULL, p_object_code),

60: language,
61: error_message,
62: proposed_action
63: ) VALUES (
64: DECODE( p_object_code, FND_API.g_miss_char, NULL, p_object_code),
65: DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id),
66: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
67: DECODE( p_error_code, FND_API.g_miss_char, NULL, p_error_code),
68: DECODE( p_object_name, FND_API.g_miss_char, NULL, p_object_name),

Line 65: DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id),

61: error_message,
62: proposed_action
63: ) VALUES (
64: DECODE( p_object_code, FND_API.g_miss_char, NULL, p_object_code),
65: DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id),
66: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
67: DECODE( p_error_code, FND_API.g_miss_char, NULL, p_error_code),
68: DECODE( p_object_name, FND_API.g_miss_char, NULL, p_object_name),
69: DECODE( p_language, FND_API.g_miss_char, NULL, p_language),

Line 66: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

62: proposed_action
63: ) VALUES (
64: DECODE( p_object_code, FND_API.g_miss_char, NULL, p_object_code),
65: DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id),
66: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
67: DECODE( p_error_code, FND_API.g_miss_char, NULL, p_error_code),
68: DECODE( p_object_name, FND_API.g_miss_char, NULL, p_object_name),
69: DECODE( p_language, FND_API.g_miss_char, NULL, p_language),
70: DECODE( p_error_message, FND_API.g_miss_char, NULL, p_error_message),

Line 67: DECODE( p_error_code, FND_API.g_miss_char, NULL, p_error_code),

63: ) VALUES (
64: DECODE( p_object_code, FND_API.g_miss_char, NULL, p_object_code),
65: DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id),
66: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
67: DECODE( p_error_code, FND_API.g_miss_char, NULL, p_error_code),
68: DECODE( p_object_name, FND_API.g_miss_char, NULL, p_object_name),
69: DECODE( p_language, FND_API.g_miss_char, NULL, p_language),
70: DECODE( p_error_message, FND_API.g_miss_char, NULL, p_error_message),
71: DECODE( p_proposed_action, FND_API.g_miss_char, NULL, p_proposed_action));

Line 68: DECODE( p_object_name, FND_API.g_miss_char, NULL, p_object_name),

64: DECODE( p_object_code, FND_API.g_miss_char, NULL, p_object_code),
65: DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id),
66: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
67: DECODE( p_error_code, FND_API.g_miss_char, NULL, p_error_code),
68: DECODE( p_object_name, FND_API.g_miss_char, NULL, p_object_name),
69: DECODE( p_language, FND_API.g_miss_char, NULL, p_language),
70: DECODE( p_error_message, FND_API.g_miss_char, NULL, p_error_message),
71: DECODE( p_proposed_action, FND_API.g_miss_char, NULL, p_proposed_action));
72: END Insert_Row;

Line 69: DECODE( p_language, FND_API.g_miss_char, NULL, p_language),

65: DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id),
66: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
67: DECODE( p_error_code, FND_API.g_miss_char, NULL, p_error_code),
68: DECODE( p_object_name, FND_API.g_miss_char, NULL, p_object_name),
69: DECODE( p_language, FND_API.g_miss_char, NULL, p_language),
70: DECODE( p_error_message, FND_API.g_miss_char, NULL, p_error_message),
71: DECODE( p_proposed_action, FND_API.g_miss_char, NULL, p_proposed_action));
72: END Insert_Row;
73:

Line 70: DECODE( p_error_message, FND_API.g_miss_char, NULL, p_error_message),

66: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
67: DECODE( p_error_code, FND_API.g_miss_char, NULL, p_error_code),
68: DECODE( p_object_name, FND_API.g_miss_char, NULL, p_object_name),
69: DECODE( p_language, FND_API.g_miss_char, NULL, p_language),
70: DECODE( p_error_message, FND_API.g_miss_char, NULL, p_error_message),
71: DECODE( p_proposed_action, FND_API.g_miss_char, NULL, p_proposed_action));
72: END Insert_Row;
73:
74:

Line 71: DECODE( p_proposed_action, FND_API.g_miss_char, NULL, p_proposed_action));

67: DECODE( p_error_code, FND_API.g_miss_char, NULL, p_error_code),
68: DECODE( p_object_name, FND_API.g_miss_char, NULL, p_object_name),
69: DECODE( p_language, FND_API.g_miss_char, NULL, p_language),
70: DECODE( p_error_message, FND_API.g_miss_char, NULL, p_error_message),
71: DECODE( p_proposed_action, FND_API.g_miss_char, NULL, p_proposed_action));
72: END Insert_Row;
73:
74:
75: ----------------------------------------------------------

Line 105: object_code = DECODE( p_object_code, FND_API.g_miss_char, object_code, p_object_code),

101: IS
102: BEGIN
103: Update AMS_UPGRADE_TRACK_ERROR
104: SET
105: object_code = DECODE( p_object_code, FND_API.g_miss_char, object_code, p_object_code),
106: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),
107: error_code = DECODE( p_error_code, FND_API.g_miss_char, error_code, p_error_code),
108: object_name = DECODE( p_object_name, FND_API.g_miss_char, object_name, p_object_name),
109: language = DECODE( p_language, FND_API.g_miss_char, language, p_language),

Line 106: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),

102: BEGIN
103: Update AMS_UPGRADE_TRACK_ERROR
104: SET
105: object_code = DECODE( p_object_code, FND_API.g_miss_char, object_code, p_object_code),
106: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),
107: error_code = DECODE( p_error_code, FND_API.g_miss_char, error_code, p_error_code),
108: object_name = DECODE( p_object_name, FND_API.g_miss_char, object_name, p_object_name),
109: language = DECODE( p_language, FND_API.g_miss_char, language, p_language),
110: error_message = DECODE( p_error_message, FND_API.g_miss_char, error_message, p_error_message),

Line 107: error_code = DECODE( p_error_code, FND_API.g_miss_char, error_code, p_error_code),

103: Update AMS_UPGRADE_TRACK_ERROR
104: SET
105: object_code = DECODE( p_object_code, FND_API.g_miss_char, object_code, p_object_code),
106: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),
107: error_code = DECODE( p_error_code, FND_API.g_miss_char, error_code, p_error_code),
108: object_name = DECODE( p_object_name, FND_API.g_miss_char, object_name, p_object_name),
109: language = DECODE( p_language, FND_API.g_miss_char, language, p_language),
110: error_message = DECODE( p_error_message, FND_API.g_miss_char, error_message, p_error_message),
111: proposed_action = DECODE( p_proposed_action, FND_API.g_miss_char, proposed_action, p_proposed_action)

Line 108: object_name = DECODE( p_object_name, FND_API.g_miss_char, object_name, p_object_name),

104: SET
105: object_code = DECODE( p_object_code, FND_API.g_miss_char, object_code, p_object_code),
106: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),
107: error_code = DECODE( p_error_code, FND_API.g_miss_char, error_code, p_error_code),
108: object_name = DECODE( p_object_name, FND_API.g_miss_char, object_name, p_object_name),
109: language = DECODE( p_language, FND_API.g_miss_char, language, p_language),
110: error_message = DECODE( p_error_message, FND_API.g_miss_char, error_message, p_error_message),
111: proposed_action = DECODE( p_proposed_action, FND_API.g_miss_char, proposed_action, p_proposed_action)
112: WHERE OBJECT_CODE = p_object_code

Line 109: language = DECODE( p_language, FND_API.g_miss_char, language, p_language),

105: object_code = DECODE( p_object_code, FND_API.g_miss_char, object_code, p_object_code),
106: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),
107: error_code = DECODE( p_error_code, FND_API.g_miss_char, error_code, p_error_code),
108: object_name = DECODE( p_object_name, FND_API.g_miss_char, object_name, p_object_name),
109: language = DECODE( p_language, FND_API.g_miss_char, language, p_language),
110: error_message = DECODE( p_error_message, FND_API.g_miss_char, error_message, p_error_message),
111: proposed_action = DECODE( p_proposed_action, FND_API.g_miss_char, proposed_action, p_proposed_action)
112: WHERE OBJECT_CODE = p_object_code
113: AND OBJECT_ID = p_OBJECT_ID;

Line 110: error_message = DECODE( p_error_message, FND_API.g_miss_char, error_message, p_error_message),

106: object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),
107: error_code = DECODE( p_error_code, FND_API.g_miss_char, error_code, p_error_code),
108: object_name = DECODE( p_object_name, FND_API.g_miss_char, object_name, p_object_name),
109: language = DECODE( p_language, FND_API.g_miss_char, language, p_language),
110: error_message = DECODE( p_error_message, FND_API.g_miss_char, error_message, p_error_message),
111: proposed_action = DECODE( p_proposed_action, FND_API.g_miss_char, proposed_action, p_proposed_action)
112: WHERE OBJECT_CODE = p_object_code
113: AND OBJECT_ID = p_OBJECT_ID;
114:

Line 111: proposed_action = DECODE( p_proposed_action, FND_API.g_miss_char, proposed_action, p_proposed_action)

107: error_code = DECODE( p_error_code, FND_API.g_miss_char, error_code, p_error_code),
108: object_name = DECODE( p_object_name, FND_API.g_miss_char, object_name, p_object_name),
109: language = DECODE( p_language, FND_API.g_miss_char, language, p_language),
110: error_message = DECODE( p_error_message, FND_API.g_miss_char, error_message, p_error_message),
111: proposed_action = DECODE( p_proposed_action, FND_API.g_miss_char, proposed_action, p_proposed_action)
112: WHERE OBJECT_CODE = p_object_code
113: AND OBJECT_ID = p_OBJECT_ID;
114:
115: IF (SQL%NOTFOUND) THEN

Line 116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

112: WHERE OBJECT_CODE = p_object_code
113: AND OBJECT_ID = p_OBJECT_ID;
114:
115: IF (SQL%NOTFOUND) THEN
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117: END IF;
118: END Update_Row;
119:
120:

Line 146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

142: DELETE FROM AMS_UPGRADE_TRACK_ERROR
143: WHERE OBJECT_CODE = p_OBJECT_CODE
144: AND OBJECT_ID = p_OBJECT_ID;
145: If (SQL%NOTFOUND) then
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: End If;
148: END Delete_Row ;
149:
150: END AMS_UPGRADE_TRACK_ERROR_PKG;