DBA Data[Home] [Help]

APPS.PO_DOC_STYLE_PVT dependencies on FND_API

Line 48: -- FND_API.g_ret_sts_success : indicates a group of requisition lines

44: -- returns the style compatible for a group of requisition lines
45: -- would be NULL incase of style incompatiblities
46: --
47: -- x_return_status
48: -- FND_API.g_ret_sts_success : indicates a group of requisition lines
49: -- are compatible
50: -- FND_API.g_ret_sts_error : group of requisition lines encountered
51: -- style incomaptibility
52: --End of Comments

Line 50: -- FND_API.g_ret_sts_error : group of requisition lines encountered

46: --
47: -- x_return_status
48: -- FND_API.g_ret_sts_success : indicates a group of requisition lines
49: -- are compatible
50: -- FND_API.g_ret_sts_error : group of requisition lines encountered
51: -- style incomaptibility
52: --End of Comments
53: -------------------------------------------------------------------------------
54:

Line 56: p_init_msg_list IN VARCHAR2 default fnd_api.g_false,

52: --End of Comments
53: -------------------------------------------------------------------------------
54:
55: PROCEDURE style_validate_req_lines(p_api_version IN NUMBER DEFAULT 1.0,
56: p_init_msg_list IN VARCHAR2 default fnd_api.g_false,
57: x_return_status OUT NOCOPY VARCHAR2,
58: x_msg_count OUT NOCOPY NUMBER,
59: x_msg_data OUT NOCOPY VARCHAR2,
60: p_session_gt_key IN NUMBER,

Line 126: IF FND_API.to_Boolean(p_init_msg_list) THEN

122: END IF;
123:
124: d_progress := 10;
125:
126: IF FND_API.to_Boolean(p_init_msg_list) THEN
127: FND_MSG_PUB.initialize;
128: END IF;
129:
130: d_progress := 20;

Line 131: IF NOT FND_API.Compatible_API_Call(l_api_version,

127: FND_MSG_PUB.initialize;
128: END IF;
129:
130: d_progress := 20;
131: IF NOT FND_API.Compatible_API_Call(l_api_version,
132: p_api_version,
133: l_api_name,
134: G_PKG_NAME) THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

131: IF NOT FND_API.Compatible_API_Call(l_api_version,
132: p_api_version,
133: l_api_name,
134: G_PKG_NAME) THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;
137:
138:
139: d_progress := 25;

Line 168: IF (x_return_status <> FND_API.g_ret_sts_success) THEN

164: p_purchase_basis => l_purchase_basis,
165: p_destination_type => l_destination_type,
166: p_source => 'AUTOCREATE');
167:
168: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
169:
170: X_style_id := NULL;
171: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
172: p_data => x_msg_data);

Line 223: RAISE FND_API.G_EXC_ERROR;

219: IF l_style_id_tbl.count > 1 THEN
220:
221: d_progress := 50;
222: FND_MESSAGE.SET_NAME('PO','PO_REQ_LINES_MIXED_STYLES');
223: RAISE FND_API.G_EXC_ERROR;
224: END IF;
225:
226: IF l_style_id_tbl.count = 0 THEN
227: --There is no style and hence all are

Line 232: x_return_status := FND_API.g_ret_sts_success;

228: --compatible and they would have a standard style
229: d_progress := 60;
230:
231: x_style_id := PO_DOC_STYLE_GRP.get_standard_doc_style;
232: x_return_status := FND_API.g_ret_sts_success;
233:
234: IF (PO_LOG.d_proc) THEN
235: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
236: PO_LOG.proc_end(d_module, 'x_style_id', x_style_id);

Line 260: RAISE FND_API.G_EXC_ERROR;

256: IF l_style_id_tbl.count > 1 THEN
257: d_progress := 120;
258:
259: FND_MESSAGE.SET_NAME('PO','PO_ADDTO_DOCSTYLE_MISMATCH');
260: RAISE FND_API.G_EXC_ERROR;
261: ELSIF l_style_id_tbl.count = 1 THEN
262: IF l_style_id_tbl(1)<> l_group_style_id THEN
263: FND_MESSAGE.SET_NAME('PO','PO_ADDTO_DOCSTYLE_MISMATCH');
264: RAISE FND_API.G_EXC_ERROR;

Line 264: RAISE FND_API.G_EXC_ERROR;

260: RAISE FND_API.G_EXC_ERROR;
261: ELSIF l_style_id_tbl.count = 1 THEN
262: IF l_style_id_tbl(1)<> l_group_style_id THEN
263: FND_MESSAGE.SET_NAME('PO','PO_ADDTO_DOCSTYLE_MISMATCH');
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266: END IF;
267:
268: d_progress := 130;

Line 282: x_return_status := FND_API.g_ret_sts_success;

278:
279: IF PO_DOC_STYLE_GRP.is_standard_doc_style(l_group_style_id) = 'Y' THEN
280:
281: x_style_id := l_group_style_id;
282: x_return_status := FND_API.g_ret_sts_success;
283:
284: IF (PO_LOG.d_proc) THEN
285: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
286: PO_LOG.proc_end(d_module, 'x_style_id', x_style_id);

Line 317: IF (x_return_status <> FND_API.g_ret_sts_success) THEN

313: p_purchase_basis => l_purchase_basis,
314: p_destination_type => l_destination_type,
315: p_source => 'AUTOCREATE');
316:
317: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
318:
319: X_style_id := NULL;
320: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
321: p_data => x_msg_data);

Line 336: x_return_status := FND_API.g_ret_sts_success;

332:
333: END LOOP;
334:
335: x_style_id := l_group_style_id;
336: x_return_status := FND_API.g_ret_sts_success;
337:
338: IF (PO_LOG.d_proc) THEN
339: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
340: PO_LOG.proc_end(d_module, 'x_style_id', x_style_id);

Line 350: WHEN FND_API.G_EXC_ERROR THEN

346: END IF; /*IF PO_DOC_STYLE_GRP.is_standard_doc_style*/
347:
348:
349: EXCEPTION
350: WHEN FND_API.G_EXC_ERROR THEN
351: x_style_id := NULL;
352: x_return_status := FND_API.G_RET_STS_ERROR;
353: FND_MSG_PUB.ADD;
354: FND_MSG_PUB.Count_And_Get

Line 352: x_return_status := FND_API.G_RET_STS_ERROR;

348:
349: EXCEPTION
350: WHEN FND_API.G_EXC_ERROR THEN
351: x_style_id := NULL;
352: x_return_status := FND_API.G_RET_STS_ERROR;
353: FND_MSG_PUB.ADD;
354: FND_MSG_PUB.Count_And_Get
355: (p_count => x_msg_count,
356: p_data => x_msg_data

Line 359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

355: (p_count => x_msg_count,
356: p_data => x_msg_data
357: );
358:
359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361:
362: IF (PO_LOG.d_exc) THEN
363: PO_LOG.exc(d_module,d_progress,SQLCODE || SQLERRM);

Line 360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

356: p_data => x_msg_data
357: );
358:
359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361:
362: IF (PO_LOG.d_exc) THEN
363: PO_LOG.exc(d_module,d_progress,SQLCODE || SQLERRM);
364: END IF;

Line 368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

364: END IF;
365:
366: WHEN OTHERS THEN
367:
368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
369:
370: IF (PO_LOG.d_exc) THEN
371: PO_LOG.exc(d_module,d_progress,SQLCODE || SQLERRM);
372: END IF;

Line 407: -- FND_API.g_ret_sts_success : indicates the attributes of requisition line

403: -- 'AUTOCREATE' called from Autocreate Forms
404: -- 'REQUISITION' called from Requisition Entry and Automatic Sourcing
405: --OUT:
406: -- x_return_status
407: -- FND_API.g_ret_sts_success : indicates the attributes of requisition line
408: -- are compatible with a style
409: -- FND_API.g_ret_sts_error : attributes of requisition line encountered
410: -- style incomaptibility
411: --End of Comments

Line 409: -- FND_API.g_ret_sts_error : attributes of requisition line encountered

405: --OUT:
406: -- x_return_status
407: -- FND_API.g_ret_sts_success : indicates the attributes of requisition line
408: -- are compatible with a style
409: -- FND_API.g_ret_sts_error : attributes of requisition line encountered
410: -- style incomaptibility
411: --End of Comments
412: -------------------------------------------------------------------------------
413:

Line 415: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

411: --End of Comments
412: -------------------------------------------------------------------------------
413:
414: PROCEDURE style_validate_req_attrs(p_api_version IN NUMBER DEFAULT 1.0,
415: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
416: x_return_status OUT NOCOPY VARCHAR2,
417: x_msg_count OUT NOCOPY NUMBER,
418: x_msg_data OUT NOCOPY VARCHAR2,
419: p_doc_style_id IN NUMBER,

Line 454: IF FND_API.to_Boolean(p_init_msg_list) THEN

450: END IF;
451:
452: d_progress := 10;
453:
454: IF FND_API.to_Boolean(p_init_msg_list) THEN
455: FND_MSG_PUB.initialize;
456: END IF;
457:
458: d_progress := 20;

Line 459: IF NOT FND_API.Compatible_API_Call(l_api_version,

455: FND_MSG_PUB.initialize;
456: END IF;
457:
458: d_progress := 20;
459: IF NOT FND_API.Compatible_API_Call(l_api_version,
460: p_api_version,
461: l_api_name,
462: G_PKG_NAME) THEN
463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

459: IF NOT FND_API.Compatible_API_Call(l_api_version,
460: p_api_version,
461: l_api_name,
462: G_PKG_NAME) THEN
463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;
465:
466: IF p_doc_style_id is NULL then
467: l_doc_style_id := get_doc_style_id(p_document_id);

Line 507: RAISE FND_API.G_EXC_ERROR;

503: IF NOT l_purchase_basis_enabled THEN
504:
505: FND_MESSAGE.set_name('PO', 'PO_REQLINE_ATTR_INCOMPATIBLE');
506: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('PO','PO_LINE_TYPE_PURCHASE_BASIS'));
507: RAISE FND_API.G_EXC_ERROR;
508: END IF;
509:
510:
511: /*Validate Line Type */

Line 526: RAISE FND_API.G_EXC_ERROR;

522:
523: d_progress := 30;
524: FND_MESSAGE.set_name('PO','PO_REQLINE_ATTR_INCOMPATIBLE');
525: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('PO','PO_LINE_TYPE'));
526: RAISE FND_API.G_EXC_ERROR;
527: END IF;
528: END IF;
529:
530: -- The complex work validations need to be done only in the case

Line 556: RAISE FND_API.G_EXC_ERROR;

552: ELSIF (p_source = 'REQUISITION') THEN
553: d_progress := 130;
554: FND_MESSAGE.SET_NAME('PO','PO_DOCSTYLE_TEMPLABOR_MISMATCH');
555: END IF;
556: RAISE FND_API.G_EXC_ERROR;
557: END IF;
558:
559: /*Complex work Validation :2 */
560: IF is_amount_based_services_line(p_line_type_id) THEN

Line 570: RAISE FND_API.G_EXC_ERROR;

566: ELSIF (p_source = 'REQUISITION') THEN
567: d_progress := 139;
568: FND_MESSAGE.SET_NAME('PO','PO_AMT_SRV_PRO_PAY_INVALID');
569: END IF;
570: RAISE FND_API.G_EXC_ERROR;
571: END IF;
572:
573:
574: /*Complex work validation :3 */

Line 601: RAISE FND_API.G_EXC_ERROR;

597: FND_MESSAGE.set_name('PO','PO_DOCSTYLE_DEST_TYPE_MISMATCH');
598: FND_MESSAGE.SET_TOKEN('DESTINATION_TYPE',l_destination_type);
599: END IF;
600:
601: RAISE FND_API.G_EXC_ERROR;
602: END IF;
603:
604: END IF; /*IF is_progress_payments_enabled(l_doc_style_id)*/
605: END IF; /*IF p_source IN ('AUTOCREATE', 'REQUISITION')*/

Line 607: x_return_status := FND_API.G_RET_STS_SUCCESS;

603:
604: END IF; /*IF is_progress_payments_enabled(l_doc_style_id)*/
605: END IF; /*IF p_source IN ('AUTOCREATE', 'REQUISITION')*/
606:
607: x_return_status := FND_API.G_RET_STS_SUCCESS;
608:
609: IF (PO_LOG.d_proc) THEN
610: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
611: PO_LOG.proc_end(d_module);

Line 616: WHEN FND_API.G_EXC_ERROR THEN

612: END IF;
613: RETURN;
614:
615: EXCEPTION
616: WHEN FND_API.G_EXC_ERROR THEN
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: FND_MSG_PUB.ADD;
619: FND_MSG_PUB.Count_And_Get
620: (p_count => x_msg_count,

Line 617: x_return_status := FND_API.G_RET_STS_ERROR;

613: RETURN;
614:
615: EXCEPTION
616: WHEN FND_API.G_EXC_ERROR THEN
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: FND_MSG_PUB.ADD;
619: FND_MSG_PUB.Count_And_Get
620: (p_count => x_msg_count,
621: p_data => x_msg_data

Line 624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

620: (p_count => x_msg_count,
621: p_data => x_msg_data
622: );
623:
624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626:
627: IF (PO_LOG.d_exc) THEN
628: PO_LOG.exc(d_module,d_progress,SQLCODE || SQLERRM);

Line 625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

621: p_data => x_msg_data
622: );
623:
624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626:
627: IF (PO_LOG.d_exc) THEN
628: PO_LOG.exc(d_module,d_progress,SQLCODE || SQLERRM);
629: END IF;

Line 632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

628: PO_LOG.exc(d_module,d_progress,SQLCODE || SQLERRM);
629: END IF;
630:
631: WHEN OTHERS THEN
632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
633:
634: IF (PO_LOG.d_exc) THEN
635: PO_LOG.exc(d_module,d_progress,SQLCODE || SQLERRM);
636: END IF;

Line 1244: p_init_msg_list => FND_API.G_TRUE,

1240: PO_LOG.stmt(d_module, d_progress, 'style_validate_req_lines');
1241: END IF;
1242:
1243: STYLE_VALIDATE_REQ_LINES(p_api_version => 1.0,
1244: p_init_msg_list => FND_API.G_TRUE,
1245: X_return_status => x_return_status,
1246: X_msg_count => x_msg_count,
1247: x_msg_data => x_msg_data,
1248: p_session_gt_key => l_session_gt_key,