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.

APPS.POS_SPM_WF_PKG1 dependencies on FND_MESSAGE

Line 22: -- FND message text. This needs to be substituted with a message

18: --
19: FUNCTION get_osn_message RETURN VARCHAR2 IS
20: --
21: -- In this project, we have added a new token OSN_MESSAGE to the
22: -- FND message text. This needs to be substituted with a message
23: -- that invites the supplier to sign up at Oracle Supplier Network.
24: -- Look into profile POS_SM_OSN_REG_MESSAGE to find a FND message name.
25: -- Then get the message text and put it into the OSN_MESSAGE token.
26: -- This utility function returns the OSN message or '' if

Line 24: -- Look into profile POS_SM_OSN_REG_MESSAGE to find a FND message name.

20: --
21: -- In this project, we have added a new token OSN_MESSAGE to the
22: -- FND message text. This needs to be substituted with a message
23: -- that invites the supplier to sign up at Oracle Supplier Network.
24: -- Look into profile POS_SM_OSN_REG_MESSAGE to find a FND message name.
25: -- Then get the message text and put it into the OSN_MESSAGE token.
26: -- This utility function returns the OSN message or '' if
27: -- not found.
28: -- Tue Sep 1 20:45:01 PDT 2009 bso R12.1.2

Line 33: -- First get profile value to find the FND message name.

29: --
30: l_message_name VARCHAR2(240);
31: BEGIN
32: --
33: -- First get profile value to find the FND message name.
34: -- Then get and return the message text.
35: --
36: l_message_name := fnd_profile.value('POS_SM_OSN_REG_MESSAGE');
37:

Line 42: RETURN fnd_message.get_string('POS', l_message_name);

38: --
39: -- In PL/SQL NULL is equivalent to ''. Special NULL checking
40: -- logic is not required in this function.
41: --
42: RETURN fnd_message.get_string('POS', l_message_name);
43: END get_osn_message;
44:
45:
46: FUNCTION to_html(p_text VARCHAR2) RETURN VARCHAR2 IS

Line 1686: -- Bug 8325979 - Following attributes have been replaced with FND Messages

1682: aname => 'BUYER_NOTE',
1683: avalue => 'PLSQL:POS_SPM_WF_PKG1.BUYER_NOTE/'||To_char(p_supplier_reg_id));
1684: */
1685:
1686: -- Bug 8325979 - Following attributes have been replaced with FND Messages
1687:
1688: wf_engine.SetItemAttrText (itemtype => l_itemtype,
1689: itemkey => l_itemkey,
1690: aname => 'POS_APPROVE_SUPPLIER_SUBJECT',

Line 1895: -- Logic of the procedure: if notes_to_supplier is not null, returns a fnd message

1891: -- This procedure is used by workflow to generate the buyer note with proper heading
1892: -- in the notification to supplier when the supplier registration is approved or rejected.
1893: -- It should not be used for other purpose.
1894: --
1895: -- Logic of the procedure: if notes_to_supplier is not null, returns a fnd message
1896: -- POS_SUPPREG_BUYER_NOTE_HEADING for heading and the note; otherwise, null.
1897: -- (bug 2725468).
1898: --
1899: PROCEDURE buyer_note

Line 1928: fnd_message.set_name('POS','POS_SUPPREG_BUYER_NOTE_HEADING');

1924: IF l_rec.note_to_supplier IS NULL THEN
1925: document := NULL;
1926: ELSE
1927: get_enterprise_name(l_enterprise_name);
1928: fnd_message.set_name('POS','POS_SUPPREG_BUYER_NOTE_HEADING');
1929: fnd_message.set_token('ENTERPRISE_NAME', l_enterprise_name);
1930: IF display_type = 'text/html' THEN
1931: document_type := 'text/html';
1932: document := fnd_message.get || '
' || l_rec.note_to_supplier || '

Line 1929: fnd_message.set_token('ENTERPRISE_NAME', l_enterprise_name);

1925: document := NULL;
1926: ELSE
1927: get_enterprise_name(l_enterprise_name);
1928: fnd_message.set_name('POS','POS_SUPPREG_BUYER_NOTE_HEADING');
1929: fnd_message.set_token('ENTERPRISE_NAME', l_enterprise_name);
1930: IF display_type = 'text/html' THEN
1931: document_type := 'text/html';
1932: document := fnd_message.get || '
' || l_rec.note_to_supplier || '

';
1933: ELSE

Line 1932: document := fnd_message.get || '
' || l_rec.note_to_supplier || '
';

1928: fnd_message.set_name('POS','POS_SUPPREG_BUYER_NOTE_HEADING');
1929: fnd_message.set_token('ENTERPRISE_NAME', l_enterprise_name);
1930: IF display_type = 'text/html' THEN
1931: document_type := 'text/html';
1932: document := fnd_message.get || '
' || l_rec.note_to_supplier || '

';
1933: ELSE
1934: document := g_new_line || fnd_message.get || g_new_line || l_rec.note_to_supplier || g_new_line;
1935: END IF;
1936: END IF;

Line 1934: document := g_new_line || fnd_message.get || g_new_line || l_rec.note_to_supplier || g_new_line;

1930: IF display_type = 'text/html' THEN
1931: document_type := 'text/html';
1932: document := fnd_message.get || '
' || l_rec.note_to_supplier || '

';
1933: ELSE
1934: document := g_new_line || fnd_message.get || g_new_line || l_rec.note_to_supplier || g_new_line;
1935: END IF;
1936: END IF;
1937:
1938: EXCEPTION

Line 1959: fnd_message.set_name('POS','POS_SBD_BUYER_NOTE_HEADER');

1955:
1956: IF document_id IS NULL THEN
1957: document := NULL;
1958: ELSE
1959: fnd_message.set_name('POS','POS_SBD_BUYER_NOTE_HEADER');
1960: IF display_type = 'text/html' THEN
1961: document_type := 'text/html';
1962: document := fnd_message.get || '
' || document_id;
1963: ELSE

Line 1962: document := fnd_message.get || '
' || document_id;

1958: ELSE
1959: fnd_message.set_name('POS','POS_SBD_BUYER_NOTE_HEADER');
1960: IF display_type = 'text/html' THEN
1961: document_type := 'text/html';
1962: document := fnd_message.get || '
' || document_id;
1963: ELSE
1964: document := fnd_message.get || g_new_line || document_id || g_new_line;
1965: END IF;
1966: END IF;

Line 1964: document := fnd_message.get || g_new_line || document_id || g_new_line;

1960: IF display_type = 'text/html' THEN
1961: document_type := 'text/html';
1962: document := fnd_message.get || '
' || document_id;
1963: ELSE
1964: document := fnd_message.get || g_new_line || document_id || g_new_line;
1965: END IF;
1966: END IF;
1967:
1968: EXCEPTION

Line 3750: -- It returns the tokens replaced FND message to Notification Message Subject

3746: --Name: GET_APPRV_SUPPLIER_SUBJECT
3747: --Type:
3748: -- Function
3749: --Function:
3750: -- It returns the tokens replaced FND message to Notification Message Subject
3751: --Function Usage:
3752: -- This function is used to replace the workflow message subject by FND Message & its tokens
3753: --Logic Implemented:
3754: -- The FND Message Name 'POS_APPROVE_SUPPLIER_SUBJECT' will be replaced with

Line 3752: -- This function is used to replace the workflow message subject by FND Message & its tokens

3748: -- Function
3749: --Function:
3750: -- It returns the tokens replaced FND message to Notification Message Subject
3751: --Function Usage:
3752: -- This function is used to replace the workflow message subject by FND Message & its tokens
3753: --Logic Implemented:
3754: -- The FND Message Name 'POS_APPROVE_SUPPLIER_SUBJECT' will be replaced with
3755: -- corresponding Message Text and tokens inside the Message Text also be replaced.
3756: -- Then, replaced FND message will be return to the corresponding attribute

Line 3754: -- The FND Message Name 'POS_APPROVE_SUPPLIER_SUBJECT' will be replaced with

3750: -- It returns the tokens replaced FND message to Notification Message Subject
3751: --Function Usage:
3752: -- This function is used to replace the workflow message subject by FND Message & its tokens
3753: --Logic Implemented:
3754: -- The FND Message Name 'POS_APPROVE_SUPPLIER_SUBJECT' will be replaced with
3755: -- corresponding Message Text and tokens inside the Message Text also be replaced.
3756: -- Then, replaced FND message will be return to the corresponding attribute
3757: --Parameters:
3758: -- Enterprise Name

Line 3756: -- Then, replaced FND message will be return to the corresponding attribute

3752: -- This function is used to replace the workflow message subject by FND Message & its tokens
3753: --Logic Implemented:
3754: -- The FND Message Name 'POS_APPROVE_SUPPLIER_SUBJECT' will be replaced with
3755: -- corresponding Message Text and tokens inside the Message Text also be replaced.
3756: -- Then, replaced FND message will be return to the corresponding attribute
3757: --Parameters:
3758: -- Enterprise Name
3759: --IN:
3760: -- Enterprise Name

Line 3774: fnd_message.set_name('POS','POS_APPROVE_SUPPLIER_SUBJECT');

3770: l_document VARCHAR2(32000);
3771:
3772: BEGIN
3773:
3774: fnd_message.set_name('POS','POS_APPROVE_SUPPLIER_SUBJECT');
3775: fnd_message.set_token('ENTERPRISE_NAME', p_enterprise_name);
3776: l_document := fnd_message.get;
3777: RETURN l_document;
3778: END GET_APPRV_SUPPLIER_SUBJECT;

Line 3775: fnd_message.set_token('ENTERPRISE_NAME', p_enterprise_name);

3771:
3772: BEGIN
3773:
3774: fnd_message.set_name('POS','POS_APPROVE_SUPPLIER_SUBJECT');
3775: fnd_message.set_token('ENTERPRISE_NAME', p_enterprise_name);
3776: l_document := fnd_message.get;
3777: RETURN l_document;
3778: END GET_APPRV_SUPPLIER_SUBJECT;
3779:

Line 3776: l_document := fnd_message.get;

3772: BEGIN
3773:
3774: fnd_message.set_name('POS','POS_APPROVE_SUPPLIER_SUBJECT');
3775: fnd_message.set_token('ENTERPRISE_NAME', p_enterprise_name);
3776: l_document := fnd_message.get;
3777: RETURN l_document;
3778: END GET_APPRV_SUPPLIER_SUBJECT;
3779:
3780: -------------------------------------------------------------------------------

Line 3786: -- It returns the tokens replaced FND message to Notification Message Body

3782: --Name: GENERATE_APPRV_SUPPLIER_BODY
3783: --Type:
3784: -- Procedure
3785: --Procedure:
3786: -- It returns the tokens replaced FND message to Notification Message Body
3787: --Procedure Usage:
3788: -- It is being used to replace the workflow message Body by FND Message & its tokens
3789: --Logic Implemented:
3790: -- For HTML Body:

Line 3788: -- It is being used to replace the workflow message Body by FND Message & its tokens

3784: -- Procedure
3785: --Procedure:
3786: -- It returns the tokens replaced FND message to Notification Message Body
3787: --Procedure Usage:
3788: -- It is being used to replace the workflow message Body by FND Message & its tokens
3789: --Logic Implemented:
3790: -- For HTML Body:
3791: -- The FND Message Name 'POS_APPROVE_SUPPLIER_HTML_BODY' will be replaced with
3792: -- corresponding Message Text and tokens inside the Message Text also be replaced.

Line 3791: -- The FND Message Name 'POS_APPROVE_SUPPLIER_HTML_BODY' will be replaced with

3787: --Procedure Usage:
3788: -- It is being used to replace the workflow message Body by FND Message & its tokens
3789: --Logic Implemented:
3790: -- For HTML Body:
3791: -- The FND Message Name 'POS_APPROVE_SUPPLIER_HTML_BODY' will be replaced with
3792: -- corresponding Message Text and tokens inside the Message Text also be replaced.
3793: -- Then, replaced FND message will be return to the corresponding attribute
3794: -- For TEXT Body:
3795: -- The FND Message Name 'POS_APPROVE_SUPPLIER_TEXT_BODY' will be replaced with

Line 3793: -- Then, replaced FND message will be return to the corresponding attribute

3789: --Logic Implemented:
3790: -- For HTML Body:
3791: -- The FND Message Name 'POS_APPROVE_SUPPLIER_HTML_BODY' will be replaced with
3792: -- corresponding Message Text and tokens inside the Message Text also be replaced.
3793: -- Then, replaced FND message will be return to the corresponding attribute
3794: -- For TEXT Body:
3795: -- The FND Message Name 'POS_APPROVE_SUPPLIER_TEXT_BODY' will be replaced with
3796: -- corresponding Message Text and tokens inside the Message Text also be replaced.
3797: -- Then, replaced FND message will be return to the corresponding attribute

Line 3795: -- The FND Message Name 'POS_APPROVE_SUPPLIER_TEXT_BODY' will be replaced with

3791: -- The FND Message Name 'POS_APPROVE_SUPPLIER_HTML_BODY' will be replaced with
3792: -- corresponding Message Text and tokens inside the Message Text also be replaced.
3793: -- Then, replaced FND message will be return to the corresponding attribute
3794: -- For TEXT Body:
3795: -- The FND Message Name 'POS_APPROVE_SUPPLIER_TEXT_BODY' will be replaced with
3796: -- corresponding Message Text and tokens inside the Message Text also be replaced.
3797: -- Then, replaced FND message will be return to the corresponding attribute
3798: --Parameters:
3799: -- document_id

Line 3797: -- Then, replaced FND message will be return to the corresponding attribute

3793: -- Then, replaced FND message will be return to the corresponding attribute
3794: -- For TEXT Body:
3795: -- The FND Message Name 'POS_APPROVE_SUPPLIER_TEXT_BODY' will be replaced with
3796: -- corresponding Message Text and tokens inside the Message Text also be replaced.
3797: -- Then, replaced FND message will be return to the corresponding attribute
3798: --Parameters:
3799: -- document_id
3800: --IN:
3801: -- document_id

Line 3878: fnd_message.set_name('POS','POS_APPROVE_SUPPLIER_HTML_BODY');

3874: END IF;
3875:
3876: IF display_type = 'text/html' THEN
3877: l_disp_type:= display_type;
3878: fnd_message.set_name('POS','POS_APPROVE_SUPPLIER_HTML_BODY');
3879: POS_SPM_WF_PKG1.BUYER_NOTE(To_char(l_supplier_reg_id),l_disp_type,l_note,l_disp_type);
3880: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
3881: fnd_message.set_token('URL',l_url);
3882: fnd_message.set_token('USERNAME',l_username);

Line 3880: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);

3876: IF display_type = 'text/html' THEN
3877: l_disp_type:= display_type;
3878: fnd_message.set_name('POS','POS_APPROVE_SUPPLIER_HTML_BODY');
3879: POS_SPM_WF_PKG1.BUYER_NOTE(To_char(l_supplier_reg_id),l_disp_type,l_note,l_disp_type);
3880: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
3881: fnd_message.set_token('URL',l_url);
3882: fnd_message.set_token('USERNAME',l_username);
3883: fnd_message.set_token('PASSWORD',l_password);
3884: fnd_message.set_token('ADMIN_EMAIL',l_adminemail);

Line 3881: fnd_message.set_token('URL',l_url);

3877: l_disp_type:= display_type;
3878: fnd_message.set_name('POS','POS_APPROVE_SUPPLIER_HTML_BODY');
3879: POS_SPM_WF_PKG1.BUYER_NOTE(To_char(l_supplier_reg_id),l_disp_type,l_note,l_disp_type);
3880: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
3881: fnd_message.set_token('URL',l_url);
3882: fnd_message.set_token('USERNAME',l_username);
3883: fnd_message.set_token('PASSWORD',l_password);
3884: fnd_message.set_token('ADMIN_EMAIL',l_adminemail);
3885: fnd_message.set_token('BUYER_NOTE',l_note);

Line 3882: fnd_message.set_token('USERNAME',l_username);

3878: fnd_message.set_name('POS','POS_APPROVE_SUPPLIER_HTML_BODY');
3879: POS_SPM_WF_PKG1.BUYER_NOTE(To_char(l_supplier_reg_id),l_disp_type,l_note,l_disp_type);
3880: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
3881: fnd_message.set_token('URL',l_url);
3882: fnd_message.set_token('USERNAME',l_username);
3883: fnd_message.set_token('PASSWORD',l_password);
3884: fnd_message.set_token('ADMIN_EMAIL',l_adminemail);
3885: fnd_message.set_token('BUYER_NOTE',l_note);
3886:

Line 3883: fnd_message.set_token('PASSWORD',l_password);

3879: POS_SPM_WF_PKG1.BUYER_NOTE(To_char(l_supplier_reg_id),l_disp_type,l_note,l_disp_type);
3880: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
3881: fnd_message.set_token('URL',l_url);
3882: fnd_message.set_token('USERNAME',l_username);
3883: fnd_message.set_token('PASSWORD',l_password);
3884: fnd_message.set_token('ADMIN_EMAIL',l_adminemail);
3885: fnd_message.set_token('BUYER_NOTE',l_note);
3886:
3887: --

Line 3884: fnd_message.set_token('ADMIN_EMAIL',l_adminemail);

3880: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
3881: fnd_message.set_token('URL',l_url);
3882: fnd_message.set_token('USERNAME',l_username);
3883: fnd_message.set_token('PASSWORD',l_password);
3884: fnd_message.set_token('ADMIN_EMAIL',l_adminemail);
3885: fnd_message.set_token('BUYER_NOTE',l_note);
3886:
3887: --
3888: -- Begin Supplier Hub: OSN Integration

Line 3885: fnd_message.set_token('BUYER_NOTE',l_note);

3881: fnd_message.set_token('URL',l_url);
3882: fnd_message.set_token('USERNAME',l_username);
3883: fnd_message.set_token('PASSWORD',l_password);
3884: fnd_message.set_token('ADMIN_EMAIL',l_adminemail);
3885: fnd_message.set_token('BUYER_NOTE',l_note);
3886:
3887: --
3888: -- Begin Supplier Hub: OSN Integration
3889: -- See comments in FUNCTION get_osn_message

Line 3891: fnd_message.set_token('OSN_MESSAGE', to_html(get_osn_message));

3887: --
3888: -- Begin Supplier Hub: OSN Integration
3889: -- See comments in FUNCTION get_osn_message
3890: --
3891: fnd_message.set_token('OSN_MESSAGE', to_html(get_osn_message));
3892: --
3893: -- End Supplier Hub: OSN Integration
3894: --
3895:

Line 3896: l_document := l_document || NL || NL || fnd_message.get;

3892: --
3893: -- End Supplier Hub: OSN Integration
3894: --
3895:
3896: l_document := l_document || NL || NL || fnd_message.get;
3897: WF_NOTIFICATION.WriteToClob(document, l_document);
3898:
3899: ELSE
3900: l_disp_type:= display_type;

Line 3901: fnd_message.set_name('POS','POS_APPROVE_SUPPLIER_TEXT_BODY');

3897: WF_NOTIFICATION.WriteToClob(document, l_document);
3898:
3899: ELSE
3900: l_disp_type:= display_type;
3901: fnd_message.set_name('POS','POS_APPROVE_SUPPLIER_TEXT_BODY');
3902: POS_SPM_WF_PKG1.BUYER_NOTE(To_char(l_supplier_reg_id),l_disp_type,l_note,l_disp_type);
3903: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
3904: fnd_message.set_token('URL',l_url);
3905: fnd_message.set_token('USERNAME',l_username);

Line 3903: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);

3899: ELSE
3900: l_disp_type:= display_type;
3901: fnd_message.set_name('POS','POS_APPROVE_SUPPLIER_TEXT_BODY');
3902: POS_SPM_WF_PKG1.BUYER_NOTE(To_char(l_supplier_reg_id),l_disp_type,l_note,l_disp_type);
3903: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
3904: fnd_message.set_token('URL',l_url);
3905: fnd_message.set_token('USERNAME',l_username);
3906: fnd_message.set_token('PASSWORD',l_password);
3907: fnd_message.set_token('ADMIN_EMAIL',l_adminemail);

Line 3904: fnd_message.set_token('URL',l_url);

3900: l_disp_type:= display_type;
3901: fnd_message.set_name('POS','POS_APPROVE_SUPPLIER_TEXT_BODY');
3902: POS_SPM_WF_PKG1.BUYER_NOTE(To_char(l_supplier_reg_id),l_disp_type,l_note,l_disp_type);
3903: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
3904: fnd_message.set_token('URL',l_url);
3905: fnd_message.set_token('USERNAME',l_username);
3906: fnd_message.set_token('PASSWORD',l_password);
3907: fnd_message.set_token('ADMIN_EMAIL',l_adminemail);
3908: fnd_message.set_token('BUYER_NOTE',l_note);

Line 3905: fnd_message.set_token('USERNAME',l_username);

3901: fnd_message.set_name('POS','POS_APPROVE_SUPPLIER_TEXT_BODY');
3902: POS_SPM_WF_PKG1.BUYER_NOTE(To_char(l_supplier_reg_id),l_disp_type,l_note,l_disp_type);
3903: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
3904: fnd_message.set_token('URL',l_url);
3905: fnd_message.set_token('USERNAME',l_username);
3906: fnd_message.set_token('PASSWORD',l_password);
3907: fnd_message.set_token('ADMIN_EMAIL',l_adminemail);
3908: fnd_message.set_token('BUYER_NOTE',l_note);
3909:

Line 3906: fnd_message.set_token('PASSWORD',l_password);

3902: POS_SPM_WF_PKG1.BUYER_NOTE(To_char(l_supplier_reg_id),l_disp_type,l_note,l_disp_type);
3903: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
3904: fnd_message.set_token('URL',l_url);
3905: fnd_message.set_token('USERNAME',l_username);
3906: fnd_message.set_token('PASSWORD',l_password);
3907: fnd_message.set_token('ADMIN_EMAIL',l_adminemail);
3908: fnd_message.set_token('BUYER_NOTE',l_note);
3909:
3910: --

Line 3907: fnd_message.set_token('ADMIN_EMAIL',l_adminemail);

3903: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
3904: fnd_message.set_token('URL',l_url);
3905: fnd_message.set_token('USERNAME',l_username);
3906: fnd_message.set_token('PASSWORD',l_password);
3907: fnd_message.set_token('ADMIN_EMAIL',l_adminemail);
3908: fnd_message.set_token('BUYER_NOTE',l_note);
3909:
3910: --
3911: -- Begin Supplier Hub: OSN Integration

Line 3908: fnd_message.set_token('BUYER_NOTE',l_note);

3904: fnd_message.set_token('URL',l_url);
3905: fnd_message.set_token('USERNAME',l_username);
3906: fnd_message.set_token('PASSWORD',l_password);
3907: fnd_message.set_token('ADMIN_EMAIL',l_adminemail);
3908: fnd_message.set_token('BUYER_NOTE',l_note);
3909:
3910: --
3911: -- Begin Supplier Hub: OSN Integration
3912: -- See comments in FUNCTION get_osn_message

Line 3914: fnd_message.set_token('OSN_MESSAGE', get_osn_message);

3910: --
3911: -- Begin Supplier Hub: OSN Integration
3912: -- See comments in FUNCTION get_osn_message
3913: --
3914: fnd_message.set_token('OSN_MESSAGE', get_osn_message);
3915: --
3916: -- End Supplier Hub: OSN Integration
3917: --
3918:

Line 3919: l_document := l_document || NL || NL || fnd_message.get;

3915: --
3916: -- End Supplier Hub: OSN Integration
3917: --
3918:
3919: l_document := l_document || NL || NL || fnd_message.get;
3920: WF_NOTIFICATION.WriteToClob(document, l_document);
3921:
3922: END IF;
3923: