eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.ASG_DEFER dependencies on FND_API

Line 24: -- Defers a row. Returns FND_API.G_RET_STS_SUCCESS if the row was

20: -- 24-may-2002 rsripada Implemented reject row
21: -- 17-may-2002 rsripada Modified defer_row
22: -- 19-feb-2002 rsripada Created
23:
24: -- Defers a row. Returns FND_API.G_RET_STS_SUCCESS if the row was
25: -- successfully deferred. FND_API.G_RET_STS_ERROR otherwise. Will
26: -- commit any work done as part of this proceduer using autonomous
27: -- transaction. sequence is a column in the inq that together with
28: -- the user_name, tran_id, pub_item can uniquely identify a record

Line 25: -- successfully deferred. FND_API.G_RET_STS_ERROR otherwise. Will

21: -- 17-may-2002 rsripada Modified defer_row
22: -- 19-feb-2002 rsripada Created
23:
24: -- Defers a row. Returns FND_API.G_RET_STS_SUCCESS if the row was
25: -- successfully deferred. FND_API.G_RET_STS_ERROR otherwise. Will
26: -- commit any work done as part of this proceduer using autonomous
27: -- transaction. sequence is a column in the inq that together with
28: -- the user_name, tran_id, pub_item can uniquely identify a record
29: -- in the inq.

Line 111: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

107: l_bool_ret boolean;
108: l_cp_run varchar2(1);
109: BEGIN
110: l_cp_run := 'N';
111: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
112: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
113: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
114: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
115: x_return_status := FND_API.G_RET_STS_ERROR;

Line 112: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR

108: l_cp_run varchar2(1);
109: BEGIN
110: l_cp_run := 'N';
111: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
112: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
113: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
114: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
115: x_return_status := FND_API.G_RET_STS_ERROR;
116: COMMIT;

Line 113: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR

109: BEGIN
110: l_cp_run := 'N';
111: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
112: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
113: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
114: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
115: x_return_status := FND_API.G_RET_STS_ERROR;
116: COMMIT;
117: return;

Line 114: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN

110: l_cp_run := 'N';
111: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
112: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
113: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
114: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
115: x_return_status := FND_API.G_RET_STS_ERROR;
116: COMMIT;
117: return;
118: END IF;

Line 115: x_return_status := FND_API.G_RET_STS_ERROR;

111: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
112: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
113: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
114: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
115: x_return_status := FND_API.G_RET_STS_ERROR;
116: COMMIT;
117: return;
118: END IF;
119:

Line 120: x_return_status := FND_API.G_RET_STS_SUCCESS;

116: COMMIT;
117: return;
118: END IF;
119:
120: x_return_status := FND_API.G_RET_STS_SUCCESS;
121:
122: -- Construct the error message if it is not passed in
123: IF (p_error_msg = FND_API.G_MISS_CHAR) OR
124: (p_error_msg IS NULL) THEN

Line 123: IF (p_error_msg = FND_API.G_MISS_CHAR) OR

119:
120: x_return_status := FND_API.G_RET_STS_SUCCESS;
121:
122: -- Construct the error message if it is not passed in
123: IF (p_error_msg = FND_API.G_MISS_CHAR) OR
124: (p_error_msg IS NULL) THEN
125: l_error_msg := 'Error Msg: ';
126:
127: FOR j in 1 .. fnd_msg_pub.count_msg LOOP

Line 128: fnd_msg_pub.get(j, FND_API.G_FALSE, l_msg_data, l_msg_dummy);

124: (p_error_msg IS NULL) THEN
125: l_error_msg := 'Error Msg: ';
126:
127: FOR j in 1 .. fnd_msg_pub.count_msg LOOP
128: fnd_msg_pub.get(j, FND_API.G_FALSE, l_msg_data, l_msg_dummy);
129: l_errmsg_length := length(l_error_msg);
130: l_msg_length := l_errmsg_length + length(l_msg_data);
131: IF l_msg_length < 4000 THEN
132: l_error_msg := l_error_msg || l_msg_data;

Line 194: x_return_status := FND_API.G_RET_STS_ERROR;

190: OPEN c_resource_id(p_user_name);
191: FETCH c_resource_id INTO l_resource_id;
192: IF c_resource_id%NOTFOUND THEN
193: CLOSE c_resource_id;
194: x_return_status := FND_API.G_RET_STS_ERROR;
195: COMMIT;
196: return;
197: END IF;
198: CLOSE c_resource_id;

Line 257: x_return_status := FND_API.G_RET_STS_SUCCESS;

253: inq_tbl_name VARCHAR2(30);
254: sql_string VARCHAR2(512);
255: BEGIN
256:
257: x_return_status := FND_API.G_RET_STS_SUCCESS;
258: IF CSM_UTIL_PKG.is_html5_user(p_user_name) THEN
259: sql_string := 'DELETE FROM '|| csm_util_pkg.get_inq_tab(p_pubitem) ||
260: ' WHERE clid$$cs = :1 AND ' ||' tranid$$ = :2 AND ' ||' seqno$$ = :3';
261: ELSE

Line 280: x_return_status := FND_API.G_RET_STS_ERROR;

276: USING p_user_name, p_tranid;
277: EXCEPTION
278: WHEN OTHERS THEN
279: -- Ignore exceptions
280: x_return_status := FND_API.G_RET_STS_ERROR;
281: IF(asg_helper.check_is_log_enabled(g_err_level))
282: THEN
283: asg_helper.log('purge_deferred_rows: Exception: ',
284: 'asg_defer', g_err_level);

Line 329: x_return_status := FND_API.G_RET_STS_SUCCESS;

325: inq_tbl_name VARCHAR2(30);
326: sql_string VARCHAR2(512);
327: BEGIN
328:
329: x_return_status := FND_API.G_RET_STS_SUCCESS;
330: IF CSM_UTIL_PKG.is_html5_user(p_user_name) THEN
331: sql_string := 'DELETE FROM '|| csm_util_pkg.get_inq_tab(p_pubitem) ||
332: ' WHERE clid$$cs = :1 AND ' ||' tranid$$ = :2 AND ' ||' seqno$$ = :3';
333: ELSE

Line 353: x_return_status := FND_API.G_RET_STS_ERROR;

349: USING p_user_name, p_tranid, p_sequence;
350: EXCEPTION
351: WHEN OTHERS THEN
352: -- Ignore exceptions
353: x_return_status := FND_API.G_RET_STS_ERROR;
354: IF(asg_helper.check_is_log_enabled(g_err_level))
355: THEN
356: asg_helper.log('delete_deferred_row_internal: Exception: ',
357: 'asg_defer', g_err_level);

Line 401: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

397: x_return_status OUT NOCOPY VARCHAR2)
398: IS
399: l_deferred_row VARCHAR2(1);
400: BEGIN
401: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
402: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
403: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
404: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
405: x_return_status := FND_API.G_RET_STS_ERROR;

Line 402: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR

398: IS
399: l_deferred_row VARCHAR2(1);
400: BEGIN
401: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
402: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
403: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
404: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
405: x_return_status := FND_API.G_RET_STS_ERROR;
406: return;

Line 403: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR

399: l_deferred_row VARCHAR2(1);
400: BEGIN
401: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
402: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
403: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
404: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
405: x_return_status := FND_API.G_RET_STS_ERROR;
406: return;
407: END IF;

Line 404: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN

400: BEGIN
401: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
402: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
403: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
404: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
405: x_return_status := FND_API.G_RET_STS_ERROR;
406: return;
407: END IF;
408:

Line 405: x_return_status := FND_API.G_RET_STS_ERROR;

401: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
402: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
403: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
404: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
405: x_return_status := FND_API.G_RET_STS_ERROR;
406: return;
407: END IF;
408:
409: l_deferred_row := asg_defer.is_deferred(p_user_name, p_tranid,

Line 412: IF l_deferred_row = FND_API.G_FALSE THEN

408:
409: l_deferred_row := asg_defer.is_deferred(p_user_name, p_tranid,
410: p_pubitem, p_sequence);
411: -- Row is not deferred do not delete.
412: IF l_deferred_row = FND_API.G_FALSE THEN
413: IF(asg_helper.check_is_log_enabled(g_err_level))
414: THEN
415: asg_helper.log('delete_deferred_row: Row is not deferred. Returning...',
416: 'asg_defer',g_err_level);

Line 437: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

433: IS
434: l_ret_status BOOLEAN;
435: l_def_trans VARCHAR2(1);
436: BEGIN
437: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
438: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
439: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
440: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
441: x_return_status := FND_API.G_RET_STS_ERROR;

Line 438: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR

434: l_ret_status BOOLEAN;
435: l_def_trans VARCHAR2(1);
436: BEGIN
437: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
438: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
439: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
440: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
441: x_return_status := FND_API.G_RET_STS_ERROR;
442: return;

Line 439: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR

435: l_def_trans VARCHAR2(1);
436: BEGIN
437: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
438: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
439: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
440: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
441: x_return_status := FND_API.G_RET_STS_ERROR;
442: return;
443: END IF;

Line 440: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN

436: BEGIN
437: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
438: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
439: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
440: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
441: x_return_status := FND_API.G_RET_STS_ERROR;
442: return;
443: END IF;
444:

Line 441: x_return_status := FND_API.G_RET_STS_ERROR;

437: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
438: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
439: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
440: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
441: x_return_status := FND_API.G_RET_STS_ERROR;
442: return;
443: END IF;
444:
445: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 445: x_return_status := FND_API.G_RET_STS_SUCCESS;

441: x_return_status := FND_API.G_RET_STS_ERROR;
442: return;
443: END IF;
444:
445: x_return_status := FND_API.G_RET_STS_SUCCESS;
446:
447: l_ret_status := asg_download.markdirty(p_pubitem, p_user_name,
448: p_tranid, p_sequence);
449: IF (l_ret_status = FALSE) THEN

Line 450: x_return_status := FND_API.G_RET_STS_ERROR;

446:
447: l_ret_status := asg_download.markdirty(p_pubitem, p_user_name,
448: p_tranid, p_sequence);
449: IF (l_ret_status = FALSE) THEN
450: x_return_status := FND_API.G_RET_STS_ERROR;
451: IF(asg_helper.check_is_log_enabled(g_err_level))
452: THEN
453: asg_helper.log('reject_row: Error in call to markdirty',
454: 'asg_defer', g_err_level);

Line 461: IF l_def_trans = FND_API.G_FALSE THEN

457: END IF;
458:
459: -- Check if this transaction is deferred
460: l_def_trans := is_deferred(p_user_name, p_tranid, p_pubitem, p_sequence);
461: IF l_def_trans = FND_API.G_FALSE THEN
462: -- Delete the row from inq
463: asg_apply.delete_row(p_user_name, p_tranid, p_pubitem, p_sequence,
464: x_return_status);
465: END IF;

Line 475: -- Returns FND_API.G_TRUE if the transaction is deferred

471: 'asg_defer',g_stmt_level);
472: END IF;
473: END reject_row;
474:
475: -- Returns FND_API.G_TRUE if the transaction is deferred
476: FUNCTION is_deferred(p_user_name IN VARCHAR2,
477: p_tranid IN NUMBER)
478: RETURN VARCHAR2 IS
479: l_retcode VARCHAR2(1);

Line 489: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

485: tranid = p_tranid AND
486: deferred <> 'N';
487: BEGIN
488:
489: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
490: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
491: return FND_API.G_FALSE;
492: END IF;
493:

Line 490: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN

486: deferred <> 'N';
487: BEGIN
488:
489: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
490: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
491: return FND_API.G_FALSE;
492: END IF;
493:
494: l_retcode := FND_API.G_TRUE;

Line 491: return FND_API.G_FALSE;

487: BEGIN
488:
489: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
490: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
491: return FND_API.G_FALSE;
492: END IF;
493:
494: l_retcode := FND_API.G_TRUE;
495: OPEN c_isdeferred(p_user_name, p_tranid);

Line 494: l_retcode := FND_API.G_TRUE;

490: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
491: return FND_API.G_FALSE;
492: END IF;
493:
494: l_retcode := FND_API.G_TRUE;
495: OPEN c_isdeferred(p_user_name, p_tranid);
496: FETCH c_isdeferred INTO l_user_name;
497: IF c_isdeferred%NOTFOUND THEN
498: l_retcode := FND_API.G_FALSE;

Line 498: l_retcode := FND_API.G_FALSE;

494: l_retcode := FND_API.G_TRUE;
495: OPEN c_isdeferred(p_user_name, p_tranid);
496: FETCH c_isdeferred INTO l_user_name;
497: IF c_isdeferred%NOTFOUND THEN
498: l_retcode := FND_API.G_FALSE;
499: END IF;
500: CLOSE c_isdeferred;
501: IF(asg_helper.check_is_log_enabled(g_stmt_level))
502: THEN

Line 511: -- Returns FND_API.G_TRUE if the record is deferred

507: return l_retcode;
508:
509: END is_deferred;
510:
511: -- Returns FND_API.G_TRUE if the record is deferred
512: FUNCTION is_deferred(p_user_name IN VARCHAR2,
513: p_tranid IN NUMBER,
514: p_pubitem IN VARCHAR2,
515: p_sequence IN NUMBER)

Line 529: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

525: object_name = p_pubitem AND
526: sequence = p_sequence;
527: BEGIN
528:
529: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
530: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
531: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
532: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
533: return FND_API.G_FALSE;

Line 530: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR

526: sequence = p_sequence;
527: BEGIN
528:
529: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
530: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
531: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
532: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
533: return FND_API.G_FALSE;
534: END IF;

Line 531: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR

527: BEGIN
528:
529: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
530: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
531: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
532: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
533: return FND_API.G_FALSE;
534: END IF;
535:

Line 532: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN

528:
529: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
530: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
531: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
532: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
533: return FND_API.G_FALSE;
534: END IF;
535:
536: l_retcode := FND_API.G_TRUE;

Line 533: return FND_API.G_FALSE;

529: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
530: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
531: ((p_pubitem = FND_API.G_MISS_CHAR) OR (p_pubitem IS NULL)) OR
532: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
533: return FND_API.G_FALSE;
534: END IF;
535:
536: l_retcode := FND_API.G_TRUE;
537: OPEN c_isdeferred(p_user_name, p_tranid, p_pubitem, p_sequence);

Line 536: l_retcode := FND_API.G_TRUE;

532: ((p_sequence = FND_API.G_MISS_NUM) OR (p_sequence IS NULL)) THEN
533: return FND_API.G_FALSE;
534: END IF;
535:
536: l_retcode := FND_API.G_TRUE;
537: OPEN c_isdeferred(p_user_name, p_tranid, p_pubitem, p_sequence);
538: FETCH c_isdeferred INTO l_user_name;
539: IF c_isdeferred%NOTFOUND THEN
540: l_retcode := FND_API.G_FALSE;

Line 540: l_retcode := FND_API.G_FALSE;

536: l_retcode := FND_API.G_TRUE;
537: OPEN c_isdeferred(p_user_name, p_tranid, p_pubitem, p_sequence);
538: FETCH c_isdeferred INTO l_user_name;
539: IF c_isdeferred%NOTFOUND THEN
540: l_retcode := FND_API.G_FALSE;
541: END IF;
542: CLOSE c_isdeferred;
543: IF(asg_helper.check_is_log_enabled(g_stmt_level))
544: THEN

Line 562: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

558: x_return_status OUT NOCOPY VARCHAR2)
559: IS
560: BEGIN
561:
562: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
563: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
564: x_return_status := FND_API.G_RET_STS_ERROR;
565: return;
566: END IF;

Line 563: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN

559: IS
560: BEGIN
561:
562: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
563: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
564: x_return_status := FND_API.G_RET_STS_ERROR;
565: return;
566: END IF;
567:

Line 564: x_return_status := FND_API.G_RET_STS_ERROR;

560: BEGIN
561:
562: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
563: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
564: x_return_status := FND_API.G_RET_STS_ERROR;
565: return;
566: END IF;
567:
568: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 568: x_return_status := FND_API.G_RET_STS_SUCCESS;

564: x_return_status := FND_API.G_RET_STS_ERROR;
565: return;
566: END IF;
567:
568: x_return_status := FND_API.G_RET_STS_SUCCESS;
569: UPDATE asg_users_inqinfo
570: SET deferred = 'D'
571: WHERE device_user_name = p_user_name AND
572: tranid = p_tranid;

Line 597: x_return_status := FND_API.G_RET_STS_SUCCESS;

593: FROM asg_deferred_traninfo
594: WHERE device_user_name = p_user_name AND
595: deferred_tran_id = p_tranid;
596: BEGIN
597: x_return_status := FND_API.G_RET_STS_SUCCESS;
598: delete_deferred_row(p_user_name, p_tranid, p_pubitem,
599: p_sequence, x_return_status);
600:
601: OPEN c_deferred_discarded(p_user_name, p_tranid);

Line 656: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

652: WHERE device_user_name = p_user_name AND
653: deferred_tran_id = p_tranid AND
654: status <> 0;
655: BEGIN
656: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
657: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: return;
660: END IF;

Line 657: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN

653: deferred_tran_id = p_tranid AND
654: status <> 0;
655: BEGIN
656: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
657: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: return;
660: END IF;
661:

Line 658: x_return_status := FND_API.G_RET_STS_ERROR;

654: status <> 0;
655: BEGIN
656: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
657: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: return;
660: END IF;
661:
662: IF CSM_UTIL_PKG.is_html5_user(p_user_name) THEN

Line 669: IF l_def_trans = FND_API.G_FALSE THEN

665: END IF;
666:
667: -- Check if this transaction is deferred
668: l_def_trans := is_deferred(p_user_name, p_tranid);
669: IF l_def_trans = FND_API.G_FALSE THEN
670: x_return_status := FND_API.G_RET_STS_ERROR;
671: return;
672: END IF;
673:

Line 670: x_return_status := FND_API.G_RET_STS_ERROR;

666:
667: -- Check if this transaction is deferred
668: l_def_trans := is_deferred(p_user_name, p_tranid);
669: IF l_def_trans = FND_API.G_FALSE THEN
670: x_return_status := FND_API.G_RET_STS_ERROR;
671: return;
672: END IF;
673:
674: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 674: x_return_status := FND_API.G_RET_STS_SUCCESS;

670: x_return_status := FND_API.G_RET_STS_ERROR;
671: return;
672: END IF;
673:
674: x_return_status := FND_API.G_RET_STS_SUCCESS;
675: -- Get all the publications that have deferred pub items
676: counter :=1;
677: FOR cpw in c_pub_wrapper(p_user_name, p_tranid) LOOP
678: l_pubhandlers_tbl(counter) := cpw.wrapper_name;

Line 700: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND

696: l_pubitems_tbl := asg_apply.g_empty_vc2_tbl;
697: asg_apply.get_all_pub_items(p_user_name, p_tranid, l_pubname,
698: l_pubitems_tbl, l_return_status);
699: -- Check if there is any data for this publication
700: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND
701: (l_pubitems_tbl.count >0) THEN
702: IF(asg_helper.check_is_log_enabled(g_stmt_level))
703: THEN
704: asg_helper.log('reapply_transaction: Calling handler package',

Line 737: x_return_status := FND_API.G_RET_STS_SUCCESS;

733: asg_helper.log('reapply_transaction: Exception in ' ||
734: 'wrapper call. Check if valid wrapper exists',
735: 'asg_defer',g_err_level);
736: END IF;
737: x_return_status := FND_API.G_RET_STS_SUCCESS;
738: fnd_global.apps_initialize(l_orig_user_id, l_orig_resp_id,
739: l_orig_app_id);
740: return;
741: END;

Line 784: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

780: l_curr_pubitem VARCHAR2(30);
781: l_pubitems_tbl asg_apply.vc2_tbl_type;
782: l_return_status VARCHAR2(1);
783: BEGIN
784: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
785: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
786: x_return_status := FND_API.G_RET_STS_ERROR;
787: return;
788: END IF;

Line 785: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN

781: l_pubitems_tbl asg_apply.vc2_tbl_type;
782: l_return_status VARCHAR2(1);
783: BEGIN
784: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
785: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
786: x_return_status := FND_API.G_RET_STS_ERROR;
787: return;
788: END IF;
789:

Line 786: x_return_status := FND_API.G_RET_STS_ERROR;

782: l_return_status VARCHAR2(1);
783: BEGIN
784: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
785: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
786: x_return_status := FND_API.G_RET_STS_ERROR;
787: return;
788: END IF;
789:
790: -- Check if this transaction is deferred

Line 792: IF l_def_trans = FND_API.G_FALSE THEN

788: END IF;
789:
790: -- Check if this transaction is deferred
791: l_def_trans := is_deferred(p_user_name, p_tranid);
792: IF l_def_trans = FND_API.G_FALSE THEN
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: return;
795: END IF;
796: IF(asg_helper.check_is_log_enabled(g_stmt_level))

Line 793: x_return_status := FND_API.G_RET_STS_ERROR;

789:
790: -- Check if this transaction is deferred
791: l_def_trans := is_deferred(p_user_name, p_tranid);
792: IF l_def_trans = FND_API.G_FALSE THEN
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: return;
795: END IF;
796: IF(asg_helper.check_is_log_enabled(g_stmt_level))
797: THEN

Line 802: x_return_status := FND_API.G_RET_STS_SUCCESS;

798: asg_helper.log('purge_transaction: Purging user: ' || p_user_name ||
799: ' transaction: ' || p_tranid,
800: 'asg_defer',g_stmt_level);
801: END IF;
802: x_return_status := FND_API.G_RET_STS_SUCCESS;
803: asg_apply.get_all_pub_items(p_user_name, p_tranid,
804: l_pubitems_tbl, l_return_status);
805: -- Check if there is any data for this publication
806: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND

Line 806: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND

802: x_return_status := FND_API.G_RET_STS_SUCCESS;
803: asg_apply.get_all_pub_items(p_user_name, p_tranid,
804: l_pubitems_tbl, l_return_status);
805: -- Check if there is any data for this publication
806: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND
807: (l_pubitems_tbl.count >0) THEN
808: FOR curr_index in 1..l_pubitems_tbl.count LOOP
809: l_curr_pubitem := l_pubitems_tbl(curr_index);
810: IF(asg_helper.check_is_log_enabled(g_stmt_level))