APPS.PO_GA_ORG_ASSIGN_DRAFT_PKG dependencies on FND_API

Line 59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

55: PO_MESSAGE_S.add_exc_msg
56: ( p_pkg_name => d_pkg_name,
57: p_procedure_name => d_api_name || '.' || d_position
58: );
59: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
60: END delete_rows;
61:
62:
63:

Line 126: IF (x_record_already_exist_tbl(i) = FND_API.G_FALSE) THEN

122: -- Created an associative array to store what id has appeared.
123: l_duplicate_flag_tbl.EXTEND(p_org_assignment_id_tbl.COUNT);
124:
125: FOR i IN 1..p_org_assignment_id_tbl.COUNT LOOP
126: IF (x_record_already_exist_tbl(i) = FND_API.G_FALSE) THEN
127:
128: IF (l_distinct_id_list.EXISTS(p_org_assignment_id_tbl(i))) THEN
129:
130: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;

Line 130: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;

126: IF (x_record_already_exist_tbl(i) = FND_API.G_FALSE) THEN
127:
128: IF (l_distinct_id_list.EXISTS(p_org_assignment_id_tbl(i))) THEN
129:
130: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;
131: ELSE
132: l_duplicate_flag_tbl(i) := FND_API.G_FALSE;
133:
134: l_distinct_id_list(p_org_assignment_id_tbl(i)) := 1;

Line 132: l_duplicate_flag_tbl(i) := FND_API.G_FALSE;

128: IF (l_distinct_id_list.EXISTS(p_org_assignment_id_tbl(i))) THEN
129:
130: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;
131: ELSE
132: l_duplicate_flag_tbl(i) := FND_API.G_FALSE;
133:
134: l_distinct_id_list(p_org_assignment_id_tbl(i)) := 1;
135: END IF;
136:

Line 185: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE

181: last_update_login,
182: purchasing_org_id
183: FROM po_ga_org_assignments
184: WHERE org_assignment_id = p_org_assignment_id_tbl(i)
185: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
186: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
187:
188: d_position := 20;
189: IF (PO_LOG.d_stmt) THEN

Line 186: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;

182: purchasing_org_id
183: FROM po_ga_org_assignments
184: WHERE org_assignment_id = p_org_assignment_id_tbl(i)
185: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
186: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
187:
188: d_position := 20;
189: IF (PO_LOG.d_stmt) THEN
190: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

Line 199: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;

195: SET delete_flag = p_delete_flag_tbl(i)
196: WHERE org_assignment_id = p_org_assignment_id_tbl(i)
197: AND draft_id = p_draft_id_tbl(i)
198: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989
199: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;
200:
201: d_position := 30;
202:
203: IF (PO_LOG.d_stmt) THEN

Line 220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

216: PO_MESSAGE_S.add_exc_msg
217: ( p_pkg_name => d_pkg_name,
218: p_procedure_name => d_api_name || '.' || d_position
219: );
220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
221: END sync_draft_from_txn;
222:
223: -----------------------------------------------------------------------
224: --Start of Comments

Line 291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

287: PO_MESSAGE_S.add_exc_msg
288: ( p_pkg_name => d_pkg_name,
289: p_procedure_name => d_api_name || '.' || d_position
290: );
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292: END sync_draft_from_txn;
293:
294: -----------------------------------------------------------------------
295: --Start of Comments

Line 425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

421: PO_MESSAGE_S.add_exc_msg
422: ( p_pkg_name => d_pkg_name,
423: p_procedure_name => d_api_name || '.' || d_position
424: );
425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
426: END merge_changes;
427:
428: -----------------------------------------------------------------------
429: --Start of Comments