DBA Data[Home] [Help]

APPS.PO_DOC_UDA_UTIL dependencies on FND_API

Line 59: IF((p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN')

55: WHERE po_header_id = p_po_header_id;
56: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'FORM_TYPE', l_clm_standard_form));
57: END IF;
58:
59: IF((p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN')
60: OR (c_get_usages_rec.attribute_category = 'DOCUMENT_NUMBERING')) THEN
61: -- OR (c_get_usages_rec.attribute_category = 'BASE_DOC_INFO') ) THEN --Bug 11797563
62: IF PO_LOG.d_stmt THEN
63: PO_LOG.stmt(d_module, d_progress, 'Ignore Chain and Doc Numbering AGs');

Line 176: IF(p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN') THEN

172: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'CONTRACT_LINE_TYPE', l_contract_type),
173: EGO_COL_NAME_VALUE_PAIR_OBJ( 'IDC_TYPE' , l_clm_idc_type ));
174: END IF;
175:
176: IF(p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN') THEN
177: IF PO_LOG.d_stmt THEN
178: PO_LOG.stmt(d_module, d_progress, 'Ignore Chain AG Ids');
179: END IF;
180:

Line 245: IF(p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN') THEN

241:
242: l_attr_grp_ids := PO_TBL_NUMBER();
243:
244: FOR c_get_usages_rec IN c_get_usages(p_template_id) LOOP
245: IF(p_is_doc_mod = FND_API.G_TRUE AND c_get_usages_rec.attribute_category = 'CHAIN') THEN
246: IF PO_LOG.d_stmt THEN
247: PO_LOG.stmt(d_module, d_progress, 'Ignore Chain AG Ids');
248: END IF;
249:

Line 350: ,p_commit => FND_API.G_FALSE

346: ,from_pk_col_value_pairs => l_from_pk_col_value_pairs
347: ,to_pk_col_value_pairs => l_to_pk_col_value_pairs
348: ,copy_attribute_groups => 'EXCLUSIVE' -- SPECIFIC / EXCLUSIVE
349: ,attribute_group_table => l_attribute_group_table
350: ,p_commit => FND_API.G_FALSE
351: ,x_return_status => l_return_status
352: ,x_msg_count => l_msg_count
353: ,x_msg_data => l_msg_data
354: );

Line 360: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

356: IF PO_LOG.d_stmt THEN
357: PO_LOG.stmt(d_module, d_progress, 'l_return_status for Headers', l_return_status);
358: END IF;
359:
360: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
361: RAISE FND_API.G_EXC_ERROR;
362: END IF;
363:
364: PO_UDA_DATA_UTIL.Merge_Mod_Address_AG(p_po_header_id => p_po_header_id

Line 361: RAISE FND_API.G_EXC_ERROR;

357: PO_LOG.stmt(d_module, d_progress, 'l_return_status for Headers', l_return_status);
358: END IF;
359:
360: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
361: RAISE FND_API.G_EXC_ERROR;
362: END IF;
363:
364: PO_UDA_DATA_UTIL.Merge_Mod_Address_AG(p_po_header_id => p_po_header_id
365: ,p_draft_id => p_draft_id

Line 371: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

367: IF PO_LOG.d_stmt THEN
368: PO_LOG.stmt(d_module, d_progress, 'Merge_Mod_Address_AG: l_return_status ', l_return_status);
369: END IF;
370:
371: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
372: RAISE FND_API.G_EXC_ERROR;
373: END IF;
374:
375: -- STARTING WITH LINE MERGE

Line 372: RAISE FND_API.G_EXC_ERROR;

368: PO_LOG.stmt(d_module, d_progress, 'Merge_Mod_Address_AG: l_return_status ', l_return_status);
369: END IF;
370:
371: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
372: RAISE FND_API.G_EXC_ERROR;
373: END IF;
374:
375: -- STARTING WITH LINE MERGE
376: SELECT po_line_id BULK COLLECT

Line 417: ,p_commit => FND_API.G_FALSE

413: ,to_template_id => l_template_id
414: ,from_pk_col_value_pairs => l_from_pk_col_value_pairs
415: ,to_pk_col_value_pairs => l_to_pk_col_value_pairs
416: ,copy_attribute_groups => 'ALL' -- SPECIFIC / EXCLUSIVE
417: ,p_commit => FND_API.G_FALSE
418: ,x_return_status => l_return_status
419: ,x_msg_count => l_msg_count
420: ,x_msg_data => l_msg_data
421: );

Line 428: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

424: PO_LOG.stmt(d_module, d_progress, 'Merging UDA for Line ID ', l_po_line_ids(i));
425: PO_LOG.stmt(d_module, d_progress, 'l_return_status ', l_return_status);
426: END IF;
427:
428: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
429: RAISE FND_API.G_EXC_ERROR;
430: END IF;
431:
432: SELECT line_location_id BULK COLLECT

Line 429: RAISE FND_API.G_EXC_ERROR;

425: PO_LOG.stmt(d_module, d_progress, 'l_return_status ', l_return_status);
426: END IF;
427:
428: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
429: RAISE FND_API.G_EXC_ERROR;
430: END IF;
431:
432: SELECT line_location_id BULK COLLECT
433: INTO l_po_line_location_ids

Line 457: ,p_commit => FND_API.G_FALSE

453: ,to_template_id => l_template_id
454: ,from_pk_col_value_pairs => l_from_pk_col_value_pairs
455: ,to_pk_col_value_pairs => l_to_pk_col_value_pairs
456: ,copy_attribute_groups => 'ALL' -- SPECIFIC / EXCLUSIVE
457: ,p_commit => FND_API.G_FALSE
458: ,x_return_status => l_return_status
459: ,x_msg_count => l_msg_count
460: ,x_msg_data => l_msg_data
461: );

Line 468: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

464: PO_LOG.stmt(d_module, d_progress, 'Merging UDA for Shipment ID ', l_po_line_location_ids(j));
465: PO_LOG.stmt(d_module, d_progress, 'l_return_status ', l_return_status);
466: END IF;
467:
468: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
469: RAISE FND_API.G_EXC_ERROR;
470: END IF;
471:
472:

Line 469: RAISE FND_API.G_EXC_ERROR;

465: PO_LOG.stmt(d_module, d_progress, 'l_return_status ', l_return_status);
466: END IF;
467:
468: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
469: RAISE FND_API.G_EXC_ERROR;
470: END IF;
471:
472:
473: END LOOP;

Line 475: x_return_status := FND_API.G_RET_STS_SUCCESS; -- BUG 13580463

471:
472:
473: END LOOP;
474: END LOOP;
475: x_return_status := FND_API.G_RET_STS_SUCCESS; -- BUG 13580463
476: EXCEPTION
477: WHEN FND_API.G_EXC_ERROR THEN
478: d_progress := 090;
479: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);

Line 477: WHEN FND_API.G_EXC_ERROR THEN

473: END LOOP;
474: END LOOP;
475: x_return_status := FND_API.G_RET_STS_SUCCESS; -- BUG 13580463
476: EXCEPTION
477: WHEN FND_API.G_EXC_ERROR THEN
478: d_progress := 090;
479: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
480: IF (PO_LOG.d_exc) THEN
481: PO_LOG.exc(d_module, d_progress, l_msg_data );

Line 484: x_return_status := FND_API.G_RET_STS_ERROR;

480: IF (PO_LOG.d_exc) THEN
481: PO_LOG.exc(d_module, d_progress, l_msg_data );
482: PO_LOG.proc_end(d_module);
483: END IF;
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: WHEN OTHERS THEN
486: d_progress := 100;
487: PO_MESSAGE_S.add_exc_msg
488: ( p_pkg_name => d_pkg_name,

Line 491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

487: PO_MESSAGE_S.add_exc_msg
488: ( p_pkg_name => d_pkg_name,
489: p_procedure_name => d_api_name || '.' || d_progress
490: );
491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
492: END merge_mod_uda ;
493:
494: PROCEDURE get_ext_param_xle_actions_ags(
495: p_template_id IN VARCHAR2,

Line 531: x_return_status := FND_API.G_RET_STS_SUCCESS;

527: l_attr_grp_ids(l_attr_grp_ids.Count) := c_get_attr_ids_rec.ATTR_GROUP_ID;
528: END LOOP;
529:
530: x_attr_grp_ids := l_attr_grp_ids;
531: x_return_status := FND_API.G_RET_STS_SUCCESS;
532:
533: IF PO_LOG.d_stmt THEN
534: PO_LOG.stmt(d_module, d_progress, 'x_return_status ', x_return_status);
535: END IF;

Line 540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

536:
537: EXCEPTION
538: WHEN OTHERS THEN
539: d_progress := 40;
540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
541: IF PO_LOG.d_stmt THEN
542: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
543: END IF;
544: END get_ext_param_xle_actions_ags;

Line 583: x_return_status := FND_API.G_RET_STS_SUCCESS;

579: l_attr_grp_ids(l_attr_grp_ids.Count) := c_get_attr_ids_rec.ATTR_GROUP_ID;
580: END LOOP;
581:
582: x_attr_grp_ids := l_attr_grp_ids;
583: x_return_status := FND_API.G_RET_STS_SUCCESS;
584:
585: IF PO_LOG.d_stmt THEN
586: PO_LOG.stmt(d_module, d_progress, 'x_return_status ', x_return_status);
587: END IF;

Line 592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

588:
589: EXCEPTION
590: WHEN OTHERS THEN
591: d_progress := 40;
592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
593: IF PO_LOG.d_stmt THEN
594: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
595: END IF;
596: END get_ext_param_xd_actions_ags;